Skip to main content

BUD-30 Pre Built Reports - Budget

Purpose

The purpose of this Quick Reference Guide (QRG) is to provide list of the Budget Execution (BUD) pre-built reports and their descriptions available in the North Carolina Financial System (NCFS).

Process Area   Report Number Report Name Report Description
BE   RPT-BE-005 RPT-BE-005 Transactions on Budgetary Hold Report

Transactions on Budgetary Hold report summarizes budgetary validation failures and displays corresponding transactions with appropriate details and activity statuses.

Report data flow:

  • Finance team will complete and Post all eligible transactions to the ledger.
  • Finance team will run the report and review the results.
BE   RPT-BE-006 RPT-BE-006 BD701 - Budget to Actual OSBM Certified Report

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.  

Report data flow:

  • Budgetary Transactions Imported from IBIS and posted to Oracle Cloud ERP Budget Cube.
  • Finance team will complete and Post all eligible transactions to the ledger.
  • Finance team will run the report and review the results.
BE   RPT-BE-009 RPT-BE-009_RPT-BE-004_RPT-BE-016 Cash Basis Report for Budget Consumption

Cash Basis Report for Budget Consumption is a budgetary report that shows both certified and authorized budgets and the budget code and fund levels.  It also shows revenues, expenditures, commitments, obligations, unpaid invoices, as well as unused fund to track budget to actual performance on a periodic basis.

Report data flow:

  • Budgetary Transactions Imported from IBIS and posted to Oracle Cloud ERP Budget Cube.
  • Finance team will complete and Post all eligible transactions to the ledger.
  • Finance team will run the report and review the results.
BE   RPT-BE-012 RPT-BE-012 Allotments to Cash Availability Report This 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.
BE   RPT-BE-013 RPT-BE-013 NC IBIS Budget Interface Reconciliation Report This interface will facilitate 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.
BE   RPT-BE-014 RPT-BE-014_RPT-BE-011 Budget to Actual Dashboard

Budget to Actual Dashboard for Budget Consumption is a budgetary dashboard that shows authorized budgets by budget code and fund levels.  It also shows revenues, expenditures, commitments, obligations, unpaid invoices, as well as unused funds 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 budget status.

Dashboard data flow:

  • Budgetary Transactions Imported from IBIS and posted to Oracle Cloud ERP Budget Cube.
  • Finance team will complete and Post all eligible transactions to the ledger.
  • Finance team will set the POV details for the dashboard and review the results.
BE   RPT-BE-017 RPT-BE-017 Prior Month/Year Posting Activity for Budgetary Control 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.
BE   RPT-BE-019 RPT-BE-019 NC Unpaid Invoice Balance Carry forward Report Agencies are appropriated funds from one budget code (Repairs and Renovations) to another for operating budgets and capital projects in IBIS. This interface will facilitate 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.

First Published

Last Updated