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 | Description | Use / Frequency | |
| Custom/FBR Custom/Report/Cash Management and Treasury | FBR Bank Account by Agency Report | FBR Bank Account by Agency Report is developed to extract DFF value set which represents account information of Agencies. This report consists of one page, details to provide the account information. This report will be critical to enter correct Bank account numbers in JE Lines. | Bank Account by Agency Report facilitate sharing of account numbers with agency Business Users. Agencies use this information to enter Journal based on information contained in the report. This report is available for query by individual agencies, who can use the report to get account details corresponding to their Agency. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | FBR General Fund Allotment Reversion Report | NC General Fund Allotment Reversion report identifies agencies that have not yet processed reversion entries to close out cash for their reverting general fund budget codes for the budgetary (cash) fiscal year end. | This report lists the 12th and 13th accounting period ending cash balances and the reversion entry amount for each general fund reverting budget code. Non-zero 13th period ending balances are identified with an error message to facilitate easy identification for budget codes that are not yet closed on a budgetary (cash) basis for the fiscal year end. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | FBR General Fund Automated Allotment Reversion Reconciliation Report | This report is based on an interface that will import cash balances from Oracle GL then Transform the file into Oracle Entries and Upload into Oracle then the report is generated for all imported reversion entries. | This report will facilitate the extraction of unused cash balance from Oracle and importing and recording reversion entries in Oracle to accurately revert agencies’ unused cash back to unreserved cash in OSC General Fund (Agency 9000). | |
| Custom/FBR Custom/Report/Cash Management and Treasury | FBR Internal Transfer Exceptions Report | This report is designed to show all intercompany transfers processed, including batch and transaction statuses, to provide guidance to users as to the progression of IC transactions in the system. | This report is used to assist users in identifying the progression of IC transactions in the system and list exceptions related to account usage and multiple receivers. Identification of specific exceptions is critical to maintaining a balanced ledger and affords opportunities to correct errors prior to posting. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | FBR Negative Budget Code Report | Negative Budget Code Report is a daily report that lists negative cash balances by budget code, only negative amounts are included in the report. | The purpose of this report is to provide the State with a list of budget codes with negative cash balances. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | FBR Statement of General Fund Revenues Report | The report is based on an interface that will send revenue and expenditures monthly totals to Department of State Treasury (DST) to perform monthly reconciliations between Oracle GL and Flexcube. | This report is based on an interface that will extract the monthly cash balances for tax and non-tax revenue budget code data from Oracle GL and send it to Flexcube for DST to complete reconciliation tasks. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC AP Cash Disbursements Report (RPTCM045) | NC AP Cash Disbursements Report provides details for AP payment transactions processed daily that will be reviewed and subject to approval for payment by the Office of the State Controller (OSC). Transactions that are approved by OSC will be posted to the ledger as expenditures with an offset to the cash account and will be incorporated in all NCFS cash basis reports. | The NC AP Disbursements Report (RPTCM045) is developed to provide information regarding daily AP payments. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Budget Code Balance by Type Report (RPTCM007) | The report is developed to provide information regarding the availability of posted cash balances for agency special budget code. | The data elements used to determine cash balances (deposits, requisitions, transfers, and payments) by budget code for each agency include beginning balance, Receipts & Expenditures YTD Balances and calculated ending cash balance. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Cash Availability Report (RPTCM003) | This report provides the cash availability information for OSC to determine if there are adequate funds “in order to avoid disbursing account overdrafts” to abide by the NC OSC Policy 300.1 Statewide Cash Management Plan. This policy requires warrants not to be released “before adequate funds have been requisitioned by the agency and approved and deposited to the applicable disbursing account by the OSC.” | NC Cash Availability Report is developed to provide information regarding the availability of cash balances by budget code for pending disbursements to confirm payments are completely funded. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC CI Cash Balance Report (RPTCM008) | NC CI Cash Balance Report is a daily report that provides CI balance information in Posted status to Oracle ERP. | CI Cash Balance Report will be developed to provide information regarding the availability of CI funds by agency budget code. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Daily Cash Transaction Detail Report (RPTCM012) | NC Daily Cash Transaction Detail Report is a daily report that lists all deposits, requisitions, and transfers from Intercompany and payments from NCFS Account Payables (NCFS AP) in Posted status to Oracle ERP. | NC Cash Transaction Detail Report is developed to provide information regarding posted transaction entries for the day by agency, budget code, transaction type and journal batch. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Daily Disbursements (Requisition) Report (RPTCM010) | NC Daily Disbursements Report is a daily report that lists all requisitions by status (Posted and Unposted transactions) to Oracle ERP. | NC Daily Disbursements Report is developed to provide information regarding by status (Posted and Unposted transactions) entries for the day by journal batch, budget code and by agency. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Daily Transfers Report (RPTCM017) | NC Daily Transfers Report is a daily report that lists all transfers by status (Received, Approved, Complete, and Posted transactions) to Oracle ERP. | NC Daily Transfers Report is developed to provide information regarding by status (Received, Approved/Complete, and Posted transactions) entries for the day by journal batch, budget code and by agency. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Deposits Reports (RPTCM002) | Deposit Report is a daily report that lists all deposits posted and unposted to Oracle ERP. Specifics related to agency, budget code, bank account number, types of deposits, and deposit amounts are included in the report, which is distributed to DST. DST uses this information to reconcile deposits recorded in their Core Banking system. Based on information contained in the report, DST confirms that the amounts and bank account numbers match the data in their system. | NC Deposits Report is developed to provide information regarding posted and unposted deposit entries for the day by journal batch, budget code and by agency. OSC Central Compliance uses the summary section of the report, which provides deposit totals by budget code type, to generate a daily cash statement. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC General Fund Appropriations Expenditures and Balances Report (RPTCM031) | NC General Fund Appropriations, Expenditures, and Balances Report is a daily report that provides YTD balance information (deposits/allotments, requisitions, transfers and payments) in Posted status to Oracle ERP and related budgetary activity in the Oracle Budget Execution module, | NC General Fund Appropriations, Expenditures, and Balances Report will be developed to provide information regarding YTD unexpended appropriations and appropriation expenditures by agency and budget code. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC General Fund Cash Balance Report (RPTCM006) | NC General Fund Cash Balances Report is a daily report that provides the balances information (deposits/allotments, requisitions, transfers, and payments) in Posted status to Oracle ERP. | NC General Fund Report is developed to provide information regarding the availability of posted cash balances by agency budget code. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Reserve Account Balances Report (RPTCM030) | NC Reserve Account Balances Report is a daily report that provides the balances information (deposits, requisitions, and transfers) in Posted status to Oracle ERP. | NC Reserve Account Balances Report is developed to provide information regarding the availability of posted cash balances by agency budget code. | |
| Custom/FBR Custom/Report/Cash Management and Treasury | NC Statement of Receipts and Expenditures Report (INTCM002) | This interface will send receipts and expenditures monthly totals to Department of State Treasury (DST) to perform monthly reconciliations between Oracle GL and Flexcube. | This is an outbound integration that will extract the monthly cash balances for general fund department budget code data from Oracle GL and send it to Flexcube. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | FBR Master Report for Budget Fund Hierarchies | NC Master report for Budget Fund hierarchies (RPTRTR153) lists budget funds and its corresponding agency and GASB relationships in a tabular format based on fiscal year hierarchy versions. | State requirements entail the need for users to view budget fund values and its corresponding Budget Code, GASB and Fund Equity account relationships to provide holistic hierarchy reporting. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Cash Control Account Trial Balance Report (RPTCM005) | NC Cash Control Account Trial Balance report is a daily report that provides prior year ending cash balances, prior year-end closing entries, beginning cash balances, YTD activity, and current balance information for posted transactions in Oracle ERP at a budget type summary level, which is distributed to OSC. | NC Cash Control Account Trial Balance report is developed to provide information regarding summary information by budget code type. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Daily Cash Position Report (RPTCM041) | NC Daily Cash Position report provides a cash flow estimate of the State’s general fund for reverting budget codes as well as non-reverting statutory reserves. The report is run daily for internal OSC review and distribution to select state agencies. | NC Daily Cash Position report provides a summarized calculation of the Unreserved Fund (Cash) Balance for the State’s general fund. The report includes current day’s posted transactions and current month balances. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC DST to OSC Receipts and Expenditures Differences Report (INTCM004) | This interface will send receipt and expenditure monthly totals from the Department of State Treasury (DST) to Oracle Cloud. The report will show revenue and expenditure balances by budget code in Oracle to compare it to the DST data sent for reconciliation purposes. | This is an inbound integration that will extract the monthly revenue and expenditure balances for budget codes from DST (Flexcube) and send it to Oracle GL for reconciliation. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Monthly Financial Control Report (RPTCM042) | NC Monthly Financial Control Report provides control totals to verify balances and amounts in the other General Fund Monthly Financial Reports. | NC Monthly Financial Control Report helps OSC identify and troubleshoot errors in the General Fund Monthly Financial Reports. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Non-reverting Cash Receipts and Disbursements Report (RPTCM027) | NC Non-Reverting Cash Receipts and Disbursements Report is a monthly report that presents prior year ending cash, monthly and year-to-date receipts, and disbursements, and ending cash balances by major function and agency. | NC Non-Reverting Cash Receipts and Disbursements Report is developed to provide public information regarding receipts and disbursements that are not funded by state appropriations, by function and agency presented on a monthly and year-to-date basis. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Receipts and Disbursements by Function Report (RPTCM026) | NC Receipts and Disbursements by Function is an end-of-month report that displays a summary by general fund budget code of monthly and year to date receipts and disbursements organized by function caption. | This report provides the public details of the calculation of the Ending Unreserved Cash balance for the State’s general fund. For this report Receipts are the total of deposit and transfer in transactions. Disbursements are the total of requisition and transfer out transactions. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Reserved and Unreserved Fund Balance Report (RPTCM021) | NC Reserved and Unreserved Fund Balance Report is a monthly report that lists cash balances in both reverting and non-reverting reserve accounts. | NC Reserved and Unreserved Fund Balance Report is developed to provide public information regarding cash account balances for reserved and unreserved funds and associated fund balances for the state by account type. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Reverting and Non-Reverting Trial Balance Report (RPTCM020) | NC Reverting and Non-Reverting Trial Balance Report is a monthly report that displays summary cash balances and fund balances for both reverting and non-reverting budget codes in a balance sheet type format. | NC Reverting and Non-Reverting Trial Balance Report is developed to provide public information regarding the State’s financial position at the end of a reporting month. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Reverting Appropriation Report (RPTCM024) | NC Reverting Appropriation Report is a monthly report that presents reverting, or general fund, financial activities reported net of budgeted and actual receipts, respectively, and are referred to as “appropriation expenditures. | NC Reverting General Fund Report (RPTCM024) is developed to provide public information regarding expenditures funded by state appropriations by function. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Reverting Appropriation with Expenditures Report (RPTCM025) | NC Reverting Appropriation with Expenditures Report is a monthly report that presents monthly and year-to-date appropriation expenditures by major function and agency with comparison to the fiscal year budget. | NC General Fund – Reverting Appropriation Expenditures, Budget, and Percent Expended report (RPTCM025) will be developed to provide public information regarding expenditures funded by state appropriations by function and agency with comparison to actual budget on a monthly and year-to-date basis. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Reverting Tax and Non-Tax Revenue Report (RPTCM023) | NC Reverting Tax and Non-Tax Revenue Report is a monthly report that presents monthly and year-to-date revenues by category and type of tax/non-tax revenue with a comparison increases or decreases from the prior fiscal to the current fiscal year by budget code. | NC General Fund Reverting Net Tax and Non-Tax Revenues report (RPTCM023) is developed to provide public information regarding increases or decreases in monthly and year-to-date revenues by tax or non-tax categories and specific tax/non-tax budget codes. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Schedule of Operations (Reverting Funds) Report (RPTCM022) | Schedule of Operation Report is a monthly report that presents monthly and year-to-date operations by category and function with a comparison to the adjusted appropriations as increases or decreases in realized or expended budget from the prior fiscal to the current fiscal year. | The report is developed to provide public information regarding increases or decreases in monthly and year-to-date as compared to budgetary availability by tax or non-tax categories and specific tax/non-tax budget codes. | |
| Custom/FBR Custom/Report/Cash Management and Treasury/OSC Reports | NC Weekly Cash Watch Report (RPTCM013) | Weekly Cash Watch report displays a summary calculation of the ending cash balance and the unreserved cash balance for the general fund for a weekly period. | This report provides the public a summarized calculation of the available cash balance before and after statutory reserves for the State’s general fund (reverting). | |
| Intercompany Transaction Summary Report | ||||
| Scheduled Processes | Intercompany Account Details Report |
Wrap-Up
Using the information contained in this document, determine which NCFS reports have an NCAS equivalent report.
Additional Resources
- Web-Based Training (WBT)