Skip to main content

NCFS Pre-Built Reports

Title Description Last Updated
NCFS Report - RPT-RTR-146 The report provides details at every account level under operating revenue and operating expenses for the current year. This report will be populated by proprietary GASB funds and will use the Prop account hierarchy. The report would also provide the same details for the Net Position and changes in Net Position For each revenue and expenditure line, the report would calculate and provide details of % of Total Operating Revenue and % of Non-Operating Revenue and For each revenue and expenditure line, the report would calculate and provide details of % of Total Operating Expenditure and % of Non-Operating Expenditure. These calculations also contain conditional formatting to highlight percentages outside of normal range.
NCFS Report - RPT-RTR-148 The report about aggregate receivables for Governmental Funds provides details of receivable balances for the governmental funds in layers along with the corresponding Allowance for Doubtful Accounts and net receivables balance. The report can be run for various period parameter such as QTD, YTD, PTD and for the selected or all GASB Fund/s.
NCFS Report - RPT-RTR-149 The report about aggregate receivables for Proprietary Funds provides details of receivable balances for the Proprietary funds in layers along with the corresponding Allowance for Doubtful Accounts and net receivables balance. The report can be run for various period parameter such as QTD, YTD, PTD and for the selected or all fund/s.
NCFS Report - RPT-RTR-150 The report provides details of every account of Assets, Liabilities and Net Position for the current year period to date as per parameter selected. This report will be populated by GASB funds and will use the Proprietary account hierarchy. The report would also provide the same details for the Net Position and changes in Net Position The report would provide detail by GASB Fund like- Enterprise, Internal Service, Component Units, Proprietary, OTHER and expandable into child fund values The report would also provide for each asset line and for each liability line, the % of each line with total Assets and % of each line with Tot Asset less Tot Cap Assets for all fund columns.
NCFS Report - RPT-RTR-151 NC EAGLE ACFR 54F - Statement of Changes in Fiduciary Net Position Report lists the fiduciary balances total additions, total deductions, and its change in Net Position. The fiduciary funds are designated by their GASB fund classification.
NCFS Report - RPT-RTR-152 The Budget to Actuals org mask report shows budgeted and actual revenues and expenditures, as well as encumbrances, on the cash basis. The report is organized by budget code and budget fund. This report also contains the remaining accounting string elements. The report parameters allow for this report to be generated for specific chart elements, or for the agency as a whole. Additionally, the sort order for the report can be selected to vary from the default of budget code, budget fund.
NCFS Report - RPT-RTR-153 NC Master report for Budget Fund hierarchies lists budget funds and its corresponding agency and GASB relationships in a tabular format based on fiscal year hierarchy versions. The report can be run for specific fiscal years as well as multiple fiscal years.
NCFS Report - RPT-RTR-155 Subledger Reconciliation Report for Receivables compares the account balances in Oracle Receivables to those in Oracle General Ledger, and highlights transaction and/or journal sources where discrepancies might exist. This report simplifies the reconciliation process by comparing Receivables and General Ledger account balances in a single place. Subledger Reconciliation report for Receivables lists Accounting Begin Balance, Invoices, Adjustments, Bills Receivable, Accounting End Balance and other details and differences as specified in section 2.5.
NCFS Report - RPT-RTR-156 The NC Eagle ACFR11G - Balance Sheet Report provides details of assets and liabilities for governmental GASB Funds along with % of what every account is to the total Assets and other debits for the respective GASB Fund balance. This report is used by agency staff for completion of their annual EAGLE risk mitigation review. The report contains conditional formatting that highlights percentages that are larger than expected.
NCFS Report - RPT-RTR-157 NC Combinations Report for Agencies (RPTRTR157) report lists all Account Code Combinations for agencies which are configured in the Oracle along with descriptions.
NCFS Report - RPT-RTR-158 This report is used specifically by the Department of Adult Correction, Correction Enterprises. It is an income statement reflecting net profit for each individual Correction Enterprise operation as well as a consolidated statement. The report is used by Correction Enterprise management in managing operations. The report is run from the NC ACCRUAL US ledger only. It lists all revenues and expenditures for the current month, current quarter and year to date. The consolidated report also includes detail budget by line item and unexpended budget balances.
NCFS Report - RPT-RTR-165 This report will extract transaction level information from NCFS for the specified parameter. This report is a replacement for the legacy NCAS report DAPG67.
NCFS Report - RPT-RTR-166 The report shows the details of balances month wise for the selected fiscal year by every account code combination.
NCFS Report - RPT-RTR-167 The report generated as part of this RICE object would be the basis for the DHHS team to complete their cost allocations.
NCFS Report - RPT-RTR-168

The Report captures balances under parents ‘4800999C Transfers In’ and ‘5809999C Transfers Out’ during a fiscal year. The report needs to show data in 5 tabs of excel depending on some conditions and criteria as listed in 2.1 section below. Because the following agencies transact business in NCFS on a cash basis, but their financial information for ACFR is received through external means, the following agency values are excluded from this report completely.

  • 0A00 NC Housing Finance Authority
  • 4800 UNC Hospitals
  • U* All university agency numbers beginning with U
NCFS Report - RPT-RTR-169 The Report captures balances under ‘Accounts listed in Key logic section below’ during a fiscal year. The report needs to show data in 10 tabs of excel depending on some conditions and criteria as listed in 2.1 section below.
NCFS Report - RPT-RTR-170 This report is similar logic to the FBR Journals Conversion Log Report, but it will set up for agencies to run against the items in the Journal Import Errors Dashboard in NCFS. To develop this report, the existing Journal Import output would be used as input to identify Group Ids in the batches that have failed. This report will be available to be run by agency staff. The Agency User can run this Error Report with Agency and Group id as parameter to see details of records failed in the Interface.
NCFS Report - RPT-RTR-171 This report is designed to assist interface agencies with balancing their monthly financial interface file with the balances in NCFS caused by daily cash related activities. The report will gather system balances for clearing budget funds, summarize the related unposted entries that are from the financial interface, and calculate the projected ending balances by distribution. This will allow agencies to determine if the cash at the budget code level will be in balance after the journal posts and also determine if there are any additional balances in the clearing budget funds that will need to be corrected prior to certification.
NCFS Report - RPT-RTR-174 DHHS Allocation Detail Report (DAPG2605) generates a view of financial information for data as of a specific Accounting Period for which the report is run. It will provide expense and revenue data grouped, sorted, and summed at various levels all based upon NCFS chart of account values. It will display authorized budget, expense, revenue, obligations and unpaid invoices for all transactions and include: Report data flow: Budgetary Transactions Imported from IBIS and posted to Oracle Cloud ERP Budget Cube Financial transactions created directly in NCFS and posted to Oracle General Ledger or loaded through csv files as part of the data migration process. Direct to GL Journal entries referencing Project level information that was not part of conversion The ability to run this report on an as needed basis to review expense and revenue performance Data will be presented with separate tabs for expenditures and revenues and a tab with raw data for the parameters entered, that users can filter by and sort as per needs.
NCFS Report - RPT-RTR-177 State reporting requirements entail the need to reclass invoice expenditures (unpaid keyed before year-end) and to accrue back invoice expenditures (keyed after year-end) at year-end. This document provides the design specifications for requirements and business rules required for the technical design of AP Accrual Injections Report for Invoices keyed after year-end.
NCFS Report - RPT-RTR-178 State reporting requirements entail the need to compare budgetary balances interfaced from the Integrated Budget Information System (IBIS) with the actual consumption of cash in Oracle Cloud ERP. This report details cash basis budget to the rolled-up levels on the Certified Budget to Actuals report.
NCFS Report - RPT-SEC-002 NCFS Agency User Security Report will be developed with the ability to execute on demand, by Agency/Business Unit, Department Name or by User ID. The user should be able to select one parameter, or multiple parameters, or ALL parameters at report generation time. The user should also be able to select one Username or multiple Usernames or ALL Usernames at report generation time.
NCFS Report - RPT-SEC-003 FBR AAC Incidents by Business Unit - Detail Report will be developed with the ability to execute by Business Unit, Control Name, or by User ID. The user should be able to select one parameter, or multiple parameters, or ALL parameters at report generation time. The user should also be able to select one Username or multiple Usernames or ALL Usernames at report generation time. This report should also include detailed information on user access conflicts so that the NCFS Security team can resolve any role level SODs that may need to be remediated.
NCFS Report - RPT-SEC-004 FBR AAC Incidents by Business Unit - Summary Report will be developed with the ability to execute by Business Unit, Control Name, or by User ID. The user should be able to select one parameter, or multiple parameters, or ALL parameters at report generation time. The user should also be able to select one Username or multiple Usernames or ALL Usernames at report generation time.
NCFS Report - RPT-SEC-005 FBR AAC Intra Role Conflicts Report will be developed with the ability to execute by Role Name or Control Name. The user should be able to select one parameter, or multiple parameters, or ALL parameters at report generation time. This report should also include detailed information on role access conflicts so that the NCFS Security team can resolve any role level SODs that may need to be remediated.