Accounting Specialist (Advances and Trading Partner Financial)

Advances and Trading Partner Financial: Statement Reporting and Analysis Personnel must work to improve financial operations, address audit findings and develop corrective action plans. This includes developing solutions which improve the effectiveness and efficiency of operations while achieving both financial and program goals. As such the contractor shall provide ongoing technical assistance to include, but is not limited, to the following examples:

Advances:

• The Candidate shall support process improvement reporting – status reporting on cleanup efforts.
• The Candidate shall perform monthly reconciliations of advances paid to other government agencies.
• Candidate shall minimum 3 years of experience in Advance/Trading Partner analysis.
• The Candidate shall compile monthly reporting to ICE management of advances paid, including business reason for the advance of funds.
• The Candidate shall compile supporting documentation related to advances paid.
• The Candidate shall prepare monthly reports, tying Treasury GOALS to financial system at a trading partner level (to be used by HQ in research).
• Candidate shall SF132 to SF133 Reconciliation and explanations experience.
• The Candidate shall prepare exception reports, for use to communicate Trading Partner errors back to finance centers.
• The Candidate shall prepare monthly entries (such as accruals, abnormal balances, intra-governmental, intra-departmental and advance adjustments), which may or may not reverse in subsequent months.
• The Candidate shall prepare permanent expense reclassification entries, to correct trading partner codes.
• The Candidate shall prepare reconciliations and crosswalks with other DHS components, at Intra-Government Payment and Collection (IPAC) and transaction level.
• The Candidate shall prepare quarterly departmental deliverables, such as interagency reimbursement agreements support, Office Personnel Management breakout, Trade Partners 00 and 99 supports, and reconciliation.
• The Candidate shall post all monthly financial statement supporting documentation on the shared drive in a logical and traceable manner and made available for review by OFM management as well as auditors. Information shall be posted to the shared drive within 10 days of the monthly financial statement completion.

MONTHLY REPORTING REQUIREMENTS:

• Monthly explanations for significant analytical discrepancies and abnormal balances
• Monthly explanations for significant variances
• General ledger reconciliations to external data
• Monthly Reconciliations
• SF132 to SF133 Reconciliation and explanations
• ICE Annual, Monthly and Quarterly Financial Report and footnotes
• Citizen's Report
• CFO Certification Briefing and Packages
  • Tier data submission
• Other department requested deliverables as required
• Recovery Analyses Reports
• Accrual, correcting, reclassification, and top-side adjustments and supporting documentation
• Prior Period Adjustment Log
• Process Assessments and Recommendations
• Special briefing packages

• The contractor shall review posting logic and make recommendations for correction if errors are noted. This process will occur monthly and shall be documented in writing for management review and approval of changes prior to the close of the accounting period.
• The contractor shall provide Federal Regulatory and USSGL Expertise, Advice, and Policy and Procedures Regulatory Guidance in Direct support of the OCFO. Contractor technical support is requested on an as needed basis as issues arise relating to questions surrounding new reporting requirements and posting logic questions as a result of mandates issued by the various regulatory agencies such as Treasury and OMB, etc. as well as DHS HQ. The contractor shall provide written recommendations in response to issues within 5 days of occurrence.
• The contractor shall identify, resolve, and correct any new and prior monthly imbalances (budgetary and proprietary) and any unresolved system issues after close of the general ledger (GL) accounting month. Reports on any imbalances shall be provided within one week after the close of the GL.