Attachment 4 03012023 TSOW 3 - Financial Reporting Analysis Branch.pdf

PDF 260 KB Posted

Attached to
Screening Information Request (SIR)/Request for Proposal (RFP): Financial Services Federal contract opportunity
Solicitation number
6973GH-24-R-00020
Issued by
Department of Transportation Federal Aviation Administration Franchise Acquisition Services

About this file

This statement of work outlines requirements for a financial services support contract to provide personnel for accounting services to the Financial Reporting Analysis Branch of the Enterprise Services Center. Key responsibilities of contractor personnel include reconciling general ledgers, collecting and analyzing financial data, assisting with financial reporting, monitoring funds to ensure regulatory compliance, and testing upgrades to the Delphi financial system. Contractor staff must have skills in oral and written communication and tactfully interact with diverse stakeholders. Performance standards require accurate and timely completion of reconciliations, database updates, financial statement runs, and journal voucher processing according to established procedures and metrics. The related federal opportunity is a solicitation issued by the Department of Transportation Federal Aviation Administration Franchise Acquisition Services seeking proposals for the financial services support contract described in the statement of work.

View the file

Other files for this federal contract opportunity

Other files attached to Screening Information Request (SIR)/Request for Proposal (RFP): Financial Services, newest first.
File Type Posted
6973GH-24-R-00020-0005.pdf PDF
AMD 0004_Attachment 10 11032023 Contract Data Requirements List.pdf PDF
Questions and Answers - 11.06.2023.pdf PDF
6973GH-24-R-00020-0004.pdf PDF
AMD 0004_Attachment 7 11062023 Labor Category Descriptions.pdf PDF
AMD 0004_Attachment 1 11032023 SOW - Financial Services.pdf PDF
6973GH-24-R-00020-0003.pdf PDF
Questions and Answers - 11.03.2023.pdf PDF
Questions and Answers - 11.01.2023.pdf PDF
6973GH-24-R-00020-0002.pdf PDF
Questions and Answers dated 10.30.2023.pdf PDF
6973GH-24-R-00020-0001.pdf PDF
Attachment 10 Contract Data Requirements List.pdf PDF
Attachment 7 10182023 Labor Category Descriptions.pdf PDF
Attachment 6 10182023 TSOW 5 Requirements Analysis and Process Improvement.pdf PDF
Attachment 5 11092022 TSOW 4 Travel.pdf PDF
Attachment 4g_AMKWI-331-332-00010 ACCRUED RECEIPTS RECONCILIATION v04.pdf PDF
Attachment 3 03012023 TSOW 2 - Accounts Receivable.pdf PDF
Attachment 2b_FY22 GC DUTIES-WORK INSTRUCTIONS 08242022.xlsx XLSX spreadsheet
Attachment 2b_FY22 GC DUTIES-WORK INSTRUCTIONS 08242022.pdf PDF
Attachment 2 10162023 TSOW 1 - Accounts Payable.pdf PDF
Attachment 13 - Wage Determination 5315-2015_OKC.pdf PDF
Attachment 11-AMS 3.6.2-29 StatementofEquivalentRates.pdf PDF
Attachment 8 - Quality Assurance Surveillance Plan 10242023.pdf PDF
Attachment 4j_AMKWI-333-334-335-00019 SF-133.pdf PDF
Attachment 4i_AMKWI-333-334-335-00010 Financial Statements v22.pdf PDF
Attachment 4h_AMKWI-333-334-335-00006 Customer Focus Work Group v10.pdf PDF
Attachment 4d_AMKWI-331-332-00004 Accts Payable Recon v08.pdf PDF
Attachment 4a_AMKWI-331-332-00001 Suspense Aging v10.pdf PDF
Attachment 3a_Global Deposit Process-FY22.pdf PDF
Attachment 2a_AMKWI-310-00002.pdf PDF
Attachment 4k_AMKWI-333-334-335-00023 Journal Voucher Processing v41.pdf PDF
Attachment 4e_AMKWI-331-332-00005 FIXED ASSETS DRAFT v09.pdf PDF
Attachment 5a 11092022 E-Travel Post Audit Procedure Requests.pdf PDF
Attachment 1 10232023 SOW Financial Services.pdf PDF
6973GH-24-R-00020.pdf PDF
Attachment 12_Core_Salary_with_Conversion.xlsx XLSX spreadsheet
Attachment 9 Schedule B_FS Excel Breakdown 10-23-23.xlsx XLSX spreadsheet
Attachment 4f_AMKWI-331-332-00006 Purchase Orders v08.pdf PDF
Attachment 4c_AMKWI-331-332-00003 AR Management Review Process v10.pdf PDF
Attachment 4b_AMKWI-331-332-00002 FBwT EDQ Recon v09.pdf PDF
Show all 41

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Enterprise Services Center (ESC)

FINANCIAL SERVICES

Task Statement of Work (TSOW)

Financial Reporting Analysis Branch

ATTACHMENT 4

March 01, 2023

Version 1

Statement of Work Financial Reporting Analysis Branch, AMK-330

Financial Services Support Contract March 01, 2023

Introduction and Overview The Financial Services Division of the Enterprise Services Center (ESC) excels in providing financial management services within the Government. Currently, we provide these services for the entire Department of Transportation (DOT) as well as five non-DOT agencies.

Scope General: The contractor shall provide all personnel, management, supervision and other items or services as necessary to perform financial support related to administrative and accounting services as identified in the statement of work below. Please reference the contract SOW for general requirements. The contractor will work tasks as assigned for

AMK-330.

Description of Work:

General Ledger Accountant Tasks may include (but not limited to) the following:

• Reconcile general ledgers

• Identify and analyze problems that may occur in the processing of recording transactions

• Collect and analyze data by applying accounting policies and procedures to record routine transactions

• Review transactions posted by Accounting Clerks and recommend changes necessary to ensure proper accounting and reporting of funds

• Assist and/or prepare routine and/or special reports on a monthly, quarterly, and yearly basis on a national level

• Monitor appropriations and analyze financial transactions to ensure data is correct and compliant with regulations

• As the level of Accountant increases, provide written explanation to auditors, managements, program managers, and others who review the statements concerning the complex data contained in the reports

• Assist with Delphi Quarterly Release Testing in various test instances as it relates to job function specific tasks to ensure system viability and reliability.

• Assist with patch migration testing and BPI new feature testing as needed for Delphi system and BPI improvements

ESC standard operating procedures will be provided by ESC. These are living documents and may require periodic updates and/or changes.

Reporting

All labor expended shall be substantiated by a summary sheet for the invoiced period listing employee name, date, labor category, number of hours actually worked and supported by the information/report from CMIS. The summary should also include a narrative describing the work performed during the month and description of issues or difficulties.

Travel

Travel is not required for this task.

Work Schedule

Contractor support shall report to duty location Monday thru Friday. Contractor must be present during core hours – 9:30 am to 11:00 am and 1:00 pm to 2:30 pm daily. Contractor shall neither report to work before 6 am nor work later than 6 pm unless approved in advance by COR.

Program requirements may dictate work to be performed at times and days other than those prescribed. Under these circumstances, the COR may authorize workload. In an instance where the work is “Over and Above” the CO may negotiate the change.

For Telecommuting, reference PWS Paragraph 2.10.

Communications Skills: Contractor personnel should be able to effectively communicate with other individuals at all levels within organizations and with differing economic, social, cultural or educational backgrounds. They should have skills in oral and written communications and the ability to exercise tact in dealing with others in a courteous and diplomatic manner.

Quality Assurance Government personnel may from time-to-time observe Contractor operations. These personnel will not interfere with Contractor performance.

At no time shall the Contractor’s personnel be supervised by FAA managers or other FAA or Government personnel. FAA will provide, as needed by the Contractor, limited assistance in the form of technical and policy guidance through the assigned COR.

Performance Requirements The contractor service requirements are summarized into Task Deliverables that relate directly to the mission. The acceptable quality levels (AQL) briefly describe the minimum acceptable quality levels of service required for each requirement. These thresholds are critical to mission success. The Method of Surveillance and Corrective Actions/Disincentives shall be provided as an attachment in the QASP.

Task Deliverable(s) Applicable Standard(s) Acceptable Quality Levels (AQL)

Reconciliations AMKWI-331-332-0001

AMKWI-331-332-0002

AMKWI-331-332-0003

AMKWI-331-332-0004

AMKWI-331-332-0005

AMKWI-331-332-0006

AMKWI-331-332-0010

Complete reconciliations on or before the applicable due date each month 98% of the time.

Update Metrics Database

Accurately update metrics no later than the 15th calendar day of each month 98% of time.

CFWG Meeting Attendance and Reconciliation Reporting

AMKWI-333-334-335-

00006

Attendance and participation by assigned contractor personnel (or designee) for each CFWG meeting 100% of the time.

Accurately report on assigned reconciliations and answer questions in a professional manner 100% of the time.

FSS Process – Run On Demand

AMKWI-333-334-335-

00010 Financial Statements

Run FSS process within 10 minutes of requested start time 100% of the time

Enter FSS parameters properly using the appropriate Fund Groups 100% of the time.

Capture all exceptions and report them to the appropriate Financial Statements Accountants 100% of the time.

SF-133 Preparation and submission

AMKWI-333-334-335-

00019

Compile and complete SF-133 for applicable treasury symbols. Submit deliverable to OA no later than one

(1) business day PRIOR TO GTAS due date 100% of the time.

If (under circumstances beyond the contractor’s control) deadline of one business day PRIOR TO GTAS due date cannot be met, Contractor shall contact the ESC Section or Branch Manager to request and receive an extension PRIOR TO GTAS due date 100% of the time

Journal Voucher Preparation, Review, and Approval

AMKWI-333-334-335-

00023

Accuracy: JV header data is populated with the correct information.

Completeness: Proper approvals are obtained by internal and external approvers. Review process is completed and documented.

Task COR: Cindy Drummond, cindy.drummond@faa.gov, 405 954-1877 mailto:cindy.drummond@faa.gov

Enterprise Services Center (ESC)

File details come from the government source that posted it. Updated .