Skip to main content

PNG-04 Report Mapping for Grants

Purpose

The purpose of this Quick Reference Guide (QRG) is to provide a mapping of reports between NCFS and NCAS.

Introduction and Overview

This QRG contains a listing of NCFS report names. Along with report names, additional information is provided to help you understand the purpose of the report, the navigation path needed to submit the report, and the most closely associated NCAS report (if any).  

User Tip

To locate the NCFS report most closely related to your legacy report (NCAS or Cognos), search [Ctl+F] for the name of the legacy report, or a portion of the legacy report name.

Navigation   NCFS Report Name NCAS Equivalent Description Use / Frequency
Custom/FBR Custom/Report/Grants   NC Federal Check Clearance Pattern Report (RPTGM020) N/A The Federal Check  Clearance Pattern report is developed to identify invoices paid through checks for federal programs (CFDA). The report will provide all necessary information related to these invoices, and the payment details. It will also calculate the number of interest days, a difference between the date the check was issued and the date the check cleared.
Custom/FBR Custom/Report/Grants   NC Federal Grant 488-588 Transfer Account Reconciliation Report (RPTGM016) C-U-GL-GRANT-RECON-RPT (IE) This report provides the State the ability to see all related data and associated financial data for a series of accounts (488/588) and assist with the close and reconciliation process. The Federal Grant 488/588 Transfer Account Reconciliation Report is developed to generate a view of financial information for specific account(s) for which the report is run. It will give the chart of account details monthly.
Custom/FBR Custom/Report/Grants   NC Fixed Asset Report with COA (RPTGM021) N/A Fixed Asset Report with COA will aid the State/Agency during financial monitoring visits by the grantors and OSA audit. The report will provide information about fixed assets purchased by the grant being monitored/audited. The report can be used to determine assets for a full COA distribution in case of legislative action to transfer a Division, Agency Program, Agency Management Unit or Grant from one state agency to another. The report will pull the latest and current data (due to asset transfers) for the chart of account segments, and not the original values when the asset was created in the system.
Custom/FBR Custom/Report/Grants   NC GL Project Summary Report (RPTGM013) N/A This report provides the State the ability to see all related data and associated financial data tied to a specific project. The GL Project Summary report is developed to generate a view of financial information for each project for which the report is run. It will give the chart of accounts details and the expense details monthly/quarterly/yearly.
Custom/FBR Custom/Report/Grants   NC Grants Drawdown Report (RPTGM017) N/A This report provides the State the ability to accurately retrieve expense data to aid in drawdown activities. The Grants Drawdown Report is developed to generate a view of expense transactions information for a specific date range that the report is run for. It provides expense information that is sourced from the General Ledger.
Custom/FBR Custom/Report/Grants   NC Life to Date Data for Grants Report (BD701F) (RPTGM011) BD701F This report provides the State the ability to see all related data and associated financial data for federal grant awards and assist with the close and reconciliation process. The Life to Date Federal Budget Code Report (BD701-F) is developed to generate a view of financial information for data as of a specific month for which the report is run. It will give the total grant life-to-date information monthly.
Custom/FBR Custom/Report/Grants   NC LTD Budget Activity Details Report (RPTGM022) N/A LTD Budget Activity Details Report is a budgetary report that shows all detailed LTD transactions by budget code and fund levels. It shows revenues, expenditures, obligations, unpaid invoices, inventory receipts, as well as unused fund to track all transactions.
Custom/FBR Custom/Report/Grants   NC LTD Budget to LTD Actual Dashboard (RPTGM018) Similar to BD701F - Interactive LTD Budget to Actual Dashboard for LTD Budget Consumption is a budgetary dashboard that shows LTD budgets by budget code and fund levels. It shows revenues, expenditures, obligations, unpaid invoices, inventory receipts as well as unused fund to track budget to actual performance on a periodic basis. The dashboard will also include a few charts/graphs to give users a visual snapshot of their LTD budget status.
Custom/FBR Custom/Report/Grants   NC Special Purpose Budget Report (DAPG26) (RPTGM009) DAPG26 The Special Purpose Budget Report (DAPG26) is developed to generate a view of financial information for data as of a specific month for which the report is run. The report provides expense and revenue data grouped, sorted, and summed at various levels all based upon NCFS chart of account values. It provides expense and revenue visibility for all transactions.

Wrap-Up

Using the information contained in this document, determine which NCFS reports have an NCAS equivalent report.

Additional Resources

First Published

Last Updated