DOL OCFO FINANCIAL SERVICES IDIQ RFI

REQUEST FOR INFORMATION (RFI) FINANCIAL SERVICES SUPPORT This Request for Information (RFI) is for information and planning purposes only and is not a solicitation or a Request for Proposal on behalf of the United States Department of Labor (DOL). DOL does not intend to award a contract on the basis of the responses to this RFI or to otherwise pay for the preparation of any information submitted or for the Government's use of such information. Depending on the information received in response to this RFI, DOL may issue a solicitation in the future. Responses to the sources sought will be treated as "for informational purposes" only. No entitlement to payment of direct or indirect costs will arise as a result of contractor submission of responses or Government use of such information. The Government reserves the right to reject, in whole or in part, any contractor input resulting from the sources sought. Purpose The Office of the Chief Financial Officer (OCFO) must ensure that the agency financial statement compilation data are timely, accurate, and consistent with appropriate reporting requirements; prepare the Department's Financial Statements; cooperate with the Office of Inspector General (OIG) in the OIG's audit of the Financial Statements; and prepare the final Annual Financial Statements for the Department reflecting the OIG's audit opinion and the data statutorily required by all Federal financial management laws, regulations, and guidance. Description Financial services would be performed at twenty (20) locations including Washington, DC as well as the following six (6) regions: Boston, Philadelphia, Atlanta, Dallas, Chicago, and San Francisco. Work would be completed on site utilizing Government furnished facilities, computers and software. Peak work periods would be the first quarter when the financial accounts of the prior year are formally closed-out. Demand may be high for 15 days prior to and the 45 days subsequent to the close of each fiscal quarter. Sample work elements: 1. Prepare accurate and timely quarterly and annual Consolidated Financial Statements and Federal Agency's Centralized Trial Balance System (FACTS) data consistent with the requirements of the OCFO and other applicable legislation and appropriate OMB, Treasury, and Government Accountability Office (GAO) regulations and guidelines in support of the Employment and Training Administration (ETA), the Office of Worker's Compensation Programs (OFCCP), and the Office of Labor Management Standards. 2. Assist agencies in compiling financial data in the extraction, transformation, and loading processes necessary to prepare the agency FACTS I and II data, compilation of the Department's and trust fund financial statements and the compilation of the Department's quarterly and annual Consolidated Financial Statements as well as supporting other agencies within the Department of Labor. 3. Support the maintenance of FECA receivables from other agencies and collections of those receivables including interface transactions that have been recorded and agree with Treasury and worksheets for Federal accounts receivable and future workers compensation liability for distribution to other agencies and publication on the internet; 4. Compile adjustments and supporting documentation for (1) the Panama Commission Compensation Fund including investment and interest receivable transactions and preparation of market values of portfolio for year-end disclosure; and (2) Wage and Hour civil money penalties and accounts receivable; provide recommendations to accounting issues related to the Energy Employees Occupational Illness Compensation Fund, the Long shore and Harbor Workers' Compensation Act-Trust Fund, the District of Columbia Workmen's Compensation Act Trust Fund and the Black Lung Disability Trust Fund to ensure the funds are properly recorded in the Department of Labor accounting system. 5. Provide training on all aspects of financial reporting, which may include presentation materials, agendas, training objectives approved by DOL management, and/or documentation to support attendance. 6. Prepare reconciliations and supporting documentation for: - Subsidiary and general ledger systems for E-Grants (DOL's grant subsidiary), grants, and interfaces; - Fixed assets system and the general ledger (including additions, deletions, impairments, construction in progress (CIP), and transfers); - Treasury closing package, including input data for the Government-wide Financial Reporting System (GFRS), yearly reporting to Treasury, and mock reporting for the quarters ending March 31 and June 30; - Proprietary to budgetary reconciliations' - Payroll and payroll accrual reconciliations; and - Upward and downward adjustments - Provide verbal and written explanations in support of work products to the OCFO, OIG, and the independent auditor, which may include explanations of the accounting treatment of transactions and - Verbal and written guidance to assist with audit resolution, e.g., notifications of findings and recommendations (NFRs), significant deficiencies, material weaknesses, and Management Advisory Comments. 6. Support the Department's compliance with OMB Circular A-136 (or subsequent OMB guidance), as follows: 7. Maintain the Unemployment Trust Fund (UTF)/DOL accounting system interface and make changes when required by changes in Treasury reporting; reconcile UTF transaction files to Treasury supporting documentation and ensure that files are complete and accurate and that they accurately post to the DOL accounting system through the interface; communicate with ETA personnel to obtain databases necessary for recording all other and reimbursable employer receivable, benefit payment accruals, and Federal Employees Compensation Act (FECA) account collections and receivables, and also to obtain data necessary for supplemental information; assist ETA in developing databases so that required information will be obtained from the states; - Record FECA receivables from other agencies and collections of those receivables; ensure that interface transactions have been recorded and cash is in agreement with Treasury; prepare worksheets for Federal accounts receivable and future workers compensation liability for distribution to other agencies and publication on the internet; - Calculate and prepare adjustments for the Panama Commission Compensation Fund including investment and interest receivable transactions and preparation of market values of portfolio for year-end disclosure; calculate and prepare adjustments for Wage and Hour civil money penalties and accounts receivable; assist in accounting issues related to the Energy Employees Occupational Illness Compensation Fund, the Long shore and Harbor Worker's Compensation Act Trust Fund, the District of Columbia Workmen's Compensation Act Trust Fund and the Black Lung Disability Trust Fund and ensure that funds are properly recorded in the DOL accounting system. 8. Cooperate with the OIG in the OIG's audit of the Department's Financial Statements and assist the OCFO as requested during the audit process to clarify accounting treatment of transactions. 9. Assist the agencies in the redrafting of the Department's Financial Statements so as to reflect the OIG's audit findings from the current or prior years. 10. Advise and assist the agencies in the annual update of the "Summary of Procedures Guide" reflecting the procedures used in the most recent compilation of financial statement for audit, including drafting assigned sections. 11. Provide audit liaison services, including audit resolution and responses to notifications of findings and recommendations (NFRs), significant deficiencies, material weaknesses and Management Advisory Comments. 12. Assist in preparing analytical procedures related to the relationship of budgetary and proprietary accounts, and researching and correcting errors identified in the analytical procedures. 13. Prepare child trial balance in a format that could be posted to core financial system and monitor parent/child activity as required by OMB circular A-136 and other central guidance agency requirements. 14. Assist in meeting compliance requirements of the Federal Financial Management Improvement Act of 1996 (FFMIA), the Federal Manager' Financial Integrity Act of 1982 (FMFIA), and Federal Information Security Management Act of 2002 (FISMA). 15. Prepare input data for the Government-wide Financial Reporting System (GFRS), yearly reporting to Treasury, and mock reporting for the quarters ending March 31 and June 30. Prepare reconciliations of the data entered in GFRS and all the paperwork to be submitted to auditors for the closing package (Special Purpose Financial Statement) audit. 16. Prepare financial and related sections to complete the Office of the Chief Financial Officer's portion in the Performance and Accountability Report (PAR) or Agency Financial Reports (AFR) as the case may be. 17. Prepare regional monthly/quarterly/yearly cash reconciliation to the U.S. Treasury and DOLARS. 18. Assist in fiscal year end close out of accounting processes. 19. Prepare monthly/quarterly/yearly NCFMS journal entries for back wage and CMP receivables and collections against the receivables. Unless otherwise communicated by WHD Federal Manager, cash and disbursement reconciliations are due to WJD on the following dates: - Back wage receipts and disbursements reconciliation - due the seventh (7th) calendar day of the month. - CMP collections and disbursements reconciliation - due the seventh (7th) calendar day of the month. - IPAC reconciliation - due the second (2nd) calendar day of the month. 20. Prepare monthly/quarterly/yearly NCFMS journal entries for back wage and CMP receivables and collections against receivables. Unless otherwise communicated by WHD Federal Manager, journal entries are due to WHD on the following dates: - Monthly journal entries are due second (2nd) calendar day of the month. - Quarterly journal entries are due the second (2nd) calendar day following the close of the fiscal quarters ending on 12/3, 03/31, 06/30, and 09/30 of the respective calendar year; - Yearly close out journal entries, including any adjusting entries, are due to WHD as communicated by WHD Federal Manager. 21. Prepare quarterly Treasury Report on Receivables and Debt Collection Activities (TROR) for back wage and CMP. - Prepare accurate back wage and CMP TROR reports in compliance with Treasury publications Managing Federal Receivables and the TROR Handbook. - Unless otherwise communicated by WHD Federal Manager, the TROR reports, including complete reports and supporting documentation, are due to WHD by the 15th calendar day following the close of the fiscal quarters ending on 12/31, 03/31, 06/30, and 09/30 of the respective calendar year. Other Items - Communicate with Bureau of Public debt regarding data or file transmission issues. - Liaise with Trust Fund management branch regarding data, interest accruals, FACT II information. - Obtain and process various quarter-end JVs for UTF, including o Existing Claims accruals JVs o SUIESO accrual JVs o Interest accruals JVs for UTF borrowings o Interest accruals JVs for UTF investments 22. Draft/update a plan for annual Improper Payments Information Act of 2002 (IPIA) and Improper Payments Elimination and Recovery Act 2010 (IPERA) compliance support and other IPIA and IPERA related activities to meet requirements (except Recovery Audit) per OMB Circular A-123, Appendix C, and OMB Circular A-136, and the new statutory requirements including related reporting requirements. 23. Prepare/update an IPIA risk assessment in accordance with OMB Circular A-123, Appendix C. 24. Support OCFO in meeting OMB Circular A-123, Appendix A assessment of internal controls over financial reporting requirements and OMB Circular A-136 AFR reporting requirements as follows: Prepare a Detailed Project Work Plan Overall Project Management and Oversight - Maintain A-123 project team Conduct Design Evaluation of Entity Level Controls Operations and Related Control Environment Assess the IT Environment Assess the Financial Process Testing and Assessment of Control Reporting Prepare weekly status reports and management weekly briefing. Maintain work breakdown structure in Microsoft Project that contains a baseline of budgeted hours and actual hours spent per task. Manage project to work breakdown structure and report on variances as part of the weekly status reports Prepare final reports at the conclusion of the effort. The reports should summarize the work performed, objectives achieved, findings and recommendations relating to internal control and recommendations to improve the A 123 assessment process in the future. The report should also recommend the form of the assurance statement that the Department should use. RESPONSES TO THIS RFI SHOULD CONTAIN THE FOLLOWING INFORMATION: 1. Business name and address. 2. Name, title, and contact information of company representative. 3. Commercial Activity Government Entity (CAGE) Code, GSA schedule contract number if applicable, small business size status. 4. Company's background information, size, and geographic presence nationwide. 5. Contract number(s), dollar value(s) and a brief description of work previously (within the past 3 years) or currently being performed, which specifically demonstrates the contractor's ability to successfully satisfy the requirements identified above. Provide point(s) of contact information (name, telephone number, email address) where available for the efforts cited. 6. Composition/availability of staff nationwide. 7. Credentials of staff. 8. Describe any other considerations or factors that you believe should be addressed in any resultant solicitation. NAIC 541219 Response Date and Time: June 4, 2012 - 12:00 P.M. Eastern Email responses to Ropercharles.isaac@dol.gov