Skip to main content

NCFS Pre-Built Reports

Title Description Last Updated
NCFS Report - RPT-AP-045 This report captures Expense Delegate set up information for employees. Report populates expense delegates, and the employees assigned to each expense delegate along with employee assignment status, and employee bank account indicator for electronic payment of employee expenses.
NCFS Report - RPT-AP-047 Payment Process Request in Process Report provides information on all invoices currently pulled into PPRs that have not yet been completed. This report can be run by BU or for a specific PPR. The summary tab totals the dollar amount of the PPR by Budget Fund.
NCFS Report - RPT-AP-048 Unpaid Invoice Status Report provides detailed information on unpaid invoices including invoice approval and validation status, invoice hold information, and days past due. The Summary tabs in this report count the number of unpaid invoices by Status Group. There is a summary tab for all unpaid invoices and a separate tab for past due invoices.
NCFS Report - RPT-BE-005 Transactions on Budgetary Hold report summarizes budgetary validation failures and displays corresponding transactions with appropriate details and activity statuses.
NCFS Report - RPT-BE-006 Agency Management budget report shows expenditure, revenues, and changes in appropriation balances for both budgeted (certified and authorized) and actual activity at different levels of aggregation (budget code, budget fund, and detailed account level). It also shows revenues, expenditures, obligations, unpaid invoices, as well as unrealized/unexpended fund to track budget to actual performance on a periodic basis. State agencies and universities will use the report along with OSBM when certifying their month, quarter, and year-end financial reports.
NCFS Report - RPT-BE-012 Cash Availability Report is divided into three separate sections: Appropriations (top section), Analysis of Cash (middle section), and Quarterly Information (bottom section). Appropriations - Displays summary information comparing the year-to-date authorized budget, allotments, and revenue/expenditure activity. The amounts in this section should agree to the BD701 report for the same report period. Analysis of Cash - calculates the ending cash balance in the allotment (cash) account as of the current report month. Quarterly Information - Displays summary information comparing the quarterly allotment and revenue/expenditure activity.
NCFS Report - RPT-BE-013 NC IBIS Budget Interface Reconciliation Report facilitates importing eligible Budget Revisions and Certifications from IBIS (Integrated Budget Information System) into the Oracle Cloud Budget module for the accurate budget to actual balance reporting.
NCFS Report - RPT-BE-017 State reporting requirements entail the need to report the details of transactions entered by Agencies for prior periods they have previously certified and for prior year once their annual ACFR reporting package has been submitted to OSC for approval. This report replaces the legacy report Prior Year Posting Activity Alert, specifically for Budgetary control. This report will only be available to users with access to all agency data, primarily OSC and OSBM support, reporting staff and potentially OSA audit staff.
NCFS Report - RPT-BE-019 Agencies are appropriated funds from one budget code (Repairs and Renovations) to another for operating budgets and capital projects in IBIS. NC Unpaid Invoice Balance Carry forward Report facilitates the importing and recording of approved appropriated budget transfers from IBIS into Oracle ERP Cloud Budget Execution Module for tracking/managing budgets and create supplemental CI appropriation offset entries in Oracle Cloud ERP General Ledger module for accurate cash reporting.
NCFS Report - RPT-CM-002 Deposits Report provides information regarding posted and unposted deposit entries for the day by journal batch, budget code and by agency. This report consists of two pages, a summary and detail version to provide the deposits information. This report is critical to ensure the Daily Cash Management Activity Schedule is followed.
NCFS Report - RPT-CM-003 Cash Availability Report provides information regarding the availability of cash balances by budget code for pending disbursements to confirm payments are completely funded.
NCFS Report - RPT-CM-005

Cash Control Account Trial Balance report provides information regarding summary information by budget code type. The data elements used to determine the summary balances by budget code type include:

  • Budget code (or budget code range)
  • Account
  • Account Description
  • Prior Year Ending Balance
  • Closing Entry for Prior Year
  • Beginning Balance (for current year)
  • YTD Activity
  • YTD Balance (as of month)
NCFS Report - RPT-CM-006

General Fund Report provides information regarding the availability of posted cash balances by agency budget code. The data elements used to determine cash balances include:

  • Deposits/allotments
  • Requisitions
  • Transfers
  • Payments
NCFS Report - RPT-CM-007

Special Revenue Report provides information regarding the availability of posted cash balances by agency budget code. The data elements used to determine cash balances (deposits, requisitions, transfers and payments) by budget code for each agency include:

  • Beginning Balance of Cash Account by budget code- User Prior Year Ending Balance
  • “Receipts YTD” (Deposits and Transfers In) of the Agency Cash Account by Budget Code- (Posted)
  • “Expenditures YTD” (Requisitions, Payments and Transfers Out) of the Agency Cash Account by Budget Code - (Posted)
  • Calculated Ending Cash Balance of the Agency Cash Account by Budget Code
NCFS Report - RPT-CM-008

CI Cash Balance Report provides information regarding the availability of CI funds by agency budget code. The data elements used to determine these balances (deposits/allotments, transfers, requisitions, and payments) by budget code for each agency include:

  • Adjusted Appropriation Balance by budget code
  • Allotment Balance by budget code
  • Unallotted Appropriations Balance (calculated) by budget code
  • Receipts PTD (Deposits and Transfers In) by Budget Code -(posted)
  • Expenditures PTD (Requisitions and Transfers Out) by Budget Code - (posted)
  • Report will include AP transactions in the calculation of expenditures by considering transactions that have Source: Payables, Category: Payments
  • Calculate expenditure by sum of the ‘Cash Clearing’ lines within the payment batch [Total Credit -Debit] by budget fund
  • Exclude payments where the supplier site starts with ‘IGO’
  • Allotment Balance(calculated) by budget code
  • Available Balance (calculated) by budget code
NCFS Report - RPT-CM-010 Daily Disbursements Report provides information regarding by status (Posted and Unposted transactions) entries for the day by journal batch, budget code and by agency. This report will consist of two pages, a summary and detail version to provide the requisitions information. This report will be critical to ensure the Daily Cash Management Activity Schedule is followed.
NCFS Report - RPT-CM-012 Cash Transaction Detail Report provides information regarding posted transaction entries for the day by agency, budget code, transaction type and journal batch. This report will be critical to ensure the Daily Cash Management Activity Schedule is followed.
NCFS Report - RPT-CM-013 Weekly Cash Watch provides the public a summarized calculation of the available cash balance before and after statutory reserves for the State’s general fund (reverting). This report utilizes cash transaction priority codes and budget fund hierarchy data to summarize information. The basic calculation is Beginning Cash + Receipts – Disbursements = Ending Cash –Reserved Cash = Unreserved Cash. The Ending Cash and Unreserved Cash calculated results should match the Daily Cash Position report (RPT-CM-041) for the same day.
NCFS Report - RPT-CM-017

Daily Transfers Report provides information regarding by status (Received, Approved/Complete, and Posted transactions) entries for the day by journal batch, budget code and by agency.

  • Summary of Transfers
  • Unposted Transfers
  • Posted Transfers
NCFS Report - RPT-CM-020 General Fund – Reverting and Non-Reverting Schedule of Assets, Liabilities and Fund Balance report provides public information regarding the State’s financial position at the end of a reporting month. Results are presented in standard balance sheet format to show Assets = Liabilities + Fund Balance.
NCFS Report - RPT-CM-021

General Fund – Reverting and Non-Reverting Reserved and Unreserved Fund Balance Report provides public information regarding cash account balances for reserved and unreserved funds and associated fund balances for the state by account type. The data elements used to determine account balances are budget codes presented by reserve and unreserved types. Displayed amounts are as follows:

  • Current Fiscal Year Balance
  • Prior Fiscal Year Balance (as of report month, e.g. comparing April current year to April prior year)
  • Change: Current Fiscal Year Balance – Prior Fiscal Year Balance
  • % Change: Change / Prior Fiscal Year Balance
NCFS Report - RPT-CM-022

General Fund Reverting Schedule of Operations report will be 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. The data elements used to determine operations by type include budget code by category, function, and operation (Tax, Non-Tax.). Results are calculated as:

  • Monthly Operations = MTD Receipts (deposits + transfers in) - MTD Expenditures (requisitions + transfers out + Payments)
  • Year-To-Date Operations = YTD Receipts (deposits + transfers in) - YTD Expenditures (requisitions + transfers out + Payments)
  • Budget = YTD adjusted appropriations (from Budget Execution)
  • Percent of Budget Realized/Expended = YTD Operations/Budget
NCFS Report - RPT-CM-023

NC General Fund Reverting Net Tax and Non-Tax Revenues provides public information regarding increases or decreases in monthly and year-to-date revenues by tax or nontax categories and specific tax/non-tax budget codes. The data elements used to determine revenues by type include budget code by Tax or Non-Tax. Results are calculated as:

  • Monthly Revenues = – MTD Receipts (deposits + transfers in) -MTD Expenditures (requisitions + payments + transfers out)
  • Year-To-Date Revenues = YTD Cash Balance by budget code
  • Change
  • Percent of Change
NCFS Report - RPT-CM-024

NC Reverting General Fund Report provides public information regarding expenditures funded by state appropriations by function. The data elements used to determine appropriation expenditures by function include budget code by category (Current Operations, Capital Improvements, and Debt Service) as well as by function (General Government, Education, Health and Human Services, Economic Development, Environment and Natural Resources, Public Safety, Correction, and Regulation, Agriculture,  Operating Reserves, Capital Improvements funded from the general fund, and Debt Service. Results are calculated as:

  • YTD Expenditures (requisitions + Payments + transfers out) -YTD Receipts (deposits + transfers in) = Appropriation Expenditures
NCFS Report - RPT-CM-025

NC General Fund – Reverting Appropriation Expenditures, Budget, and Percent Expended provides 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. The data elements used to determine appropriation expenditures by function include budget code by category (Current Operations, Capital Improvements, and Debt Service) as well as by function (General Government, Education, Health and Human Services, Economic Development, Environment and Natural Resources, Public Safety, Correction, and Regulation, Agriculture, Operating Reserves, Capital Improvements funded from the general fund, and Debt Service. Results are calculated as:

  • Appropriation Expenditures = YTD Expenditures (requisitions + payments + transfers out) – YTD Receipts (deposits + transfers in)
  • Budget = Adjusted Appropriation
  • Percent of Budget Expended = YTD Appropriation Expenditures/Budget