Financial Data Warehouse (FDW) Subrecipient reports

About

The Financial Data Warehouse (FDW) Subrecipient reports are used by LEAs and Financial Auditors to confirm payments sent by CDE for State and Federal Grants. These are cash-basis reports - any payments that were issued between July 1 and June 30 of the Fiscal Year will appear on the report.

Please note that a new 'Reimbursement' column has been added to the FDW Reports.  This column will be populated as "Y" for yes or "N" for no.  For year-end purposes:

• A classification of "Y" is indicating that grant payments are made on a reimbursement basis; after the expenditure has been incurred.  Reimbursement grants must pass edits in data pipeline, including revenues must equal expenditures for that grant code in data pipeline.  
• A classification of "N" is indicating that revenues were received upfront or that there is not a requirement that revenues equal expenditures for that grant code in data pipeline.  In most cases, expenditures must equal or exceed the revenues reported.  

Refer to the grant guidance for the specifics of each grant.

This report can be used to confirm the grant codes related to the payments from CDE.  In addition, an entry may be needed for Grant Accounts Receivable, for any payments received after 6/30, but requested prior to 6/30.  Review the payments listed between 7/1 and 8/31 in the subsequent year to determine if the year end entry is needed.  This may need to be discussed with the District Auditor and Finance Staff.  

Additional Resources

Office of Grants Fiscal: Awardee Distribution Lookup Tool

This tool provides LEAs, BOCES and other awardees with access to payment information by fiscal year or grant code, covering the current year and the two prior fiscal years. Users can view details including the grant name and code, award amount, allocation, payments to date, remaining balances, and additional relevant data, and is updated once per month.

This information can be used to verify whether a district or school's total revenues and expenditures for a specific grant align with the records maintained by the Grants Fiscal Management Unit (GFMU).

State of Colorado: Transparency Online Project (TOPS)

The State of Colorado has Expenses posted as part of the Transparency Online Project (TOPS).  Use the filters on the right to select your District/BOCES in the vender name.  The Department defaults to Dept of Public Health, in this filter select ALL to view all department payments.  It is also recommended that the month you are needing to view is selected.  Without use of the filters it often populates a blank screen.  The data for this website is updated every 5 business days.

Contacts

Please contact Kelly Wiedemer at wiedemer_k@cde.state.co.us or Yolanda Lucero at lucero_y@cde.state.co.us with any questions or to request an alternate version of a document on this page.