TBP- Statement of Work-Grant Accrual Final.doc

DOC document 73 KB Posted

Attached to
Grant Accrual Support Services
Solicitation number
GrantAccrual2024
Issued by

About this file

This document is a Statement of Work (SOW) for grant accrual support services for the Federal Transit Administration (FTA) of the U.S. Department of Transportation (DOT). The purpose is to provide assessment and validation services to assist FTA in preparing timely monthly and annual financial statements in compliance with federal requirements.

The key tasks include: 1) reviewing FTA's current grant accrual methodology and making changes as necessary; 2) calculating monthly grant accrual estimates and preparing adjusting journal entries; 3) performing quarterly look-back analyses to validate the reasonableness of the grant accrual liabilities; 4) assisting with financial statement preparation, audits, and reviews. Deliverables include monthly grant accrual calculations, revalidation of the accrual methodology every 3 years, quarterly analyses, and ad-hoc financial reports. The anticipated contract period is a 1-year base with four 1-year option periods. The contractor will perform the work onsite at FTA headquarters.

View the file

Other files

On GovTribe

Work with this file

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

Text version

FTA Office of Budget and Policy Grant Accrual Support Statement of Work

STATEMENT OF WORK

1.0

BACKGROUND

The Federal Transit Administration (FTA) is one of the eleven modals of the United States (U.S.) Department of Transportation (DOT) which has a mission to serve the United States by ensuring a fast, safe, efficient, accessible, and convenient transportation system that meets our vital national interests and enhances the quality of life of the American people, today and into the future.

The FTA Office of Budget and Policy (TBP) administers all audit and internal controls, overall strategic planning and program review, performance management, policy, budget, program development, and financial and accounting control matters. This includes providing policy direction on legislation and regulations that relate to public transportation programs. TBP is also responsible for the formulation and execution of the FTA’s $22 billion annual budget and ensures that appropriated funds are obligated and expended in accordance with Executive Branch and congressional intent. TBP is also responsible for managing the development and implementation of the FTA strategic and program planning process, including the review and evaluation of programs to determine their effectiveness in meeting the U.S. Department of Transportation’s and FTA’s strategic goals and objectives.

The Chief Financial Officers’ (CFO) Act of 1990, as amended requires all Federal government agencies to submit financial statements on an annual and quarterly basis. The Office of the Secretary of Transportation (OST) required all Operating Administrations (OA) to submit financial statements monthly. The Office of Management and Budget (OMB) mandated all Federal agencies to submit their audited financial statements by November 15th of each year. In addition, the departmental CFO mandated the requirement for the development and maintenance of procedures to establish an accrual process for FTA grant awards for monthly financial statements beginning May 2003.

2.0

PURPOSE

The purpose of this effort is to provide assistance with financial statement preparation and support services for the grant accrual estimation and validation process. This will assist FTA to comply with policies mandated by the CFO and support the accelerated due dates for agency submission of unaudited financial statements and related packages imposed by U.S. DOT Office of the Secretary (OST), OMB, and U.S. Treasury. This effort will assist in ensuring that FTA can submit all required financial statements in a timely manner.

3.0

DESCRIPTION OF SERVICES

The Contractor shall provide assessment assistance services by performing the following tasks below:

TASK 1 – Contract Line Item Number (CLIN) 0001: Assessment of Financial Date for Determining Monthly Grant Accrual

a) Review the current methodology and standard operating procedure for developing estimated accrual for grant liabilities and expenditures, and make changes, if necessary.

b) Obtain the necessary cumulative grant obligations and disbursements reports as of the end of the period. Using the existing grant accrual methodology and standard operating procedure, calculate the monthly grant accrual estimates and prepare adjusting journal entries to be recorded in the general ledger for each appropriation account for financial statements and other monthly reporting.

c) Perform revalidation of the Grant Accrual Methodology every three years or when there is an addition of significant new program or funding, by surveying a representative sample of grantees to obtain information about changes to grantees’ billing pattern and other information needed to enhance the methodology.

TASK 2 - CLIN 0002: Validation of Grant Accrual Liabilities Estimate

a) FTA has over 6000 active grants and cooperative agreement projects. Grantees are mandated by OMB guideline to submit quarterly Standard Form (SF) 425 Federal Financial Reports (FFR) within 30 days after the end of the quarter. One of the key information that the grantees provide on the FFR for each grant project is the cumulative federal expenditures which grantees reports using the accrual basis of accounting (combination of paid and unpaid expenses). Additionally, FTA maintains a report with shows cumulative payments to the grantees by projects.

b) Perform a look-back analysis on a quarterly basis, utilizing the expenditure information on the grantees’ quarterly FFR and the cumulative grants payments report to calculate FTA’s grants liabilities and compare it the estimated grant accrual liabilities presented in the financial statements to validate its reasonableness. Research and provide explanation for variances greater than 10 percent and make changes to the grant accrual methodology if necessary.

TASK 3 - CLIN 0003: Report to DOT OST on FTA’s Portion of the DOT Consolidated Financial Statements:

a) Assist with performing quarterly financial statements fluctuation (flux) analysis after all quarter-end adjustments and journal entries have been posted in the general ledger and financial statements has been generated.

b) Assist with preparation of ad-hoc financial reports and presentations for FTA management from the accounting system.

c) Assist with researching other federal accounting issues that may arise during the financial accounting and reporting cycle related to grant accrual in the preparation of the monthly financial statements.

TASK 4 - CLIN 0004: Assistance in Coordinating Financial Audits and Reviews within the Office of Financial Management.

a) Work with Office of Inspector General (OIG) contractor or FTA internal control review contractor to provide all documentation requests relating to the grant accrual process in a timely manner.

b) Develop corrective action plan to resolve audit or review findings relating to the grant accrual process.

4.0 DELIVERIES and DELIVERY SCHEDULE Throughout the process, the contractor will interface with the FTA Office of Financial Management staff, the OST, and the OIG auditors to address their questions and concerns about the financial data and audit related issues.

Deliverables and work products:

· Prepare grant accruals for review and approval by the designated Office of Financial Management staff prior to final month-end trial balance.

· Assist the Office of Financial Management with coordination of the annual CFO Financial Statements audit due by November 15th.

Deliverables
Distribution
Format
Delivery Schedule
Acceptance Criteria
Prepare Monthly Grant Accruals Liabilities Estimates
FTA OFM Staff / Contracting Officer’s Representative (COR)
Electronic copy of Excel
By the EOD 5th business day
Review and approve deliverable by COR & FTA Office of Financial Management (OFM) Staff
Perform revalidation of the Grant Accrual Methodology every three years or when there is an addition of significant new program or funding
FTA OFM Staff / FTA management / COR
Electronic copy of Excel
After every three years or as needed
Review and approve by COR & FTA Management
Perform Grant Accruals 4th Quarter Look Back Analysis
FTA Management / COR
Electronic Copy of Excel
3 months after Quarter end
Review and approve by COR & FTA Management
Perform Quarterly financial statement Flux analysis
FTA OFM Staff/ Division Chief/ COR
Electronic Copy of Excel
Quarterly
Review and approve by COR/ FTA OFM Staff/Division Chief
Perform -hoc financial reports and presentations
FTA OFM Staff/ Division Chief/ FTA Management/ COR
Electronic Copy of Power point/ Power BI
Quarterly
Review and approve by COR/ FTA OFM Staff/ Division Chief
Grant Accrual documents for financial statement Audit and Internal Control Review
FTA OFM Staff/ COR
Electronic Copy of Excel/ Microsoft word
As needed
Review and approve by COR/ FTA OFM

5.0

INSPECTION AND ACCEPTANCE

The contractor will be required to comply with the requirements contained in description of tasks above. In addition, the contractor will be required to meet all schedules contained under “Deliveries or Performance” below. The Contracting Officer’s Representative (COR) will inspect the grant accrual methodology, monthly grant accrual calculations, and financial reports. If approved by the COR, acceptance will occur.

6.0

PLACE OF PERFORMANCE

The contractor will perform the work onsite at the FTA headquarters located at 1200 New Jersey Avenue, SE, Washington DC 20590.

7.0

PERIOD OF PERFORMANCE:

The anticipated period of performance will be one (1) 12-month base period and four (4) 12-month option periods.

8.0

GOVERNMENT FURNISHED PROPERTY

The Government will provide access to Government controlled facilities, equipment, and materials for daily business use of contractor personnel called for under this contract. This shall include office space, desk, telephone, chair, computer, shared printer, and requisite consumable materials.

-----------------------------------------------END OF SOW----------------------------------------------

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