Skip to main content

NCFS Pre-Built Reports

Title Description Last Updated
NCFS Report - RPT-RTR-009 The report would list all revenue and expenditure accounts at individual code combination level for the selected Agency, period, Budget Fund.
NCFS Report - RPT-RTR-011 Trial Balance Report lists period debits, period credits, beginning, and ending account balances summarized by natural account, account type, and budget fund segment (Parent and Child).
NCFS Report - RPT-RTR-012 The report is expected to show the transactions that are entered by Agency to a period that has been previously certified. This report will be scheduled to run on a nightly basis and will be delivered by email to the appropriate groups.
NCFS Report - RPT-RTR-013

NCAS to GL reconciliation report will have the following worksheets:

  • Compare account balances at the R1 clearing budget fund level vs the R3 detailed budget funds.
  • Compare account balances at the Budget Code Level in R1 vs R3.
  • Compare cash account balances between the ledgers (Cash Ledger vs Modified Accrual Ledger vs Full Accrual Ledger).
  • Compare net balances in 13th periods in 37000000 & 38000000 accounts in Modified Accrual Ledger & Full Accrual Ledger. If an accounting distribution has a non-zero balance, then it needs to be flagged and reviewed.
  • Extract the Journal Entries created using conversion clearing account- 29000001 (Cash Ledger) & 32900000 (Accrual Ledger).
  • Programmatic comparison of trial balance between NCAS & Oracle as of 13th period.
NCFS Report - RPT-RTR-014 This report is a report used as part of an agency’s official monthly cash basis financial reports. It lists all budget funds within an active Capital Improvement Budget code, it associated Life-to-Date Unallotted and Allotted budgetary amounts as well as actuals in a month, Year to Date, and Project to Date fashion. It also contains the remaining Allotment balance for each natural account listed. Unlike the standard Monthly Report on Capital Improvement Funds which summarizes everything at the budget fund level, this report will break amounts down into the Agency Management Unit, Agency Program, and Project level as appropriate. This allows for agencies to view and manage items within a CI budget fund that are tracked at a lower level than just the fund.
NCFS Report - RPT-RTR-015 Statements of Cash, Receipts, Disbursements and Balances by Budget fund as specified in section 2.5.
NCFS Report - RPT-RTR-019 The Budget to Actuals org mask report is a report that 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. This report will export in a columnar form to allow for easy sorting and filtering based on all 11 segments of the Account string.
NCFS Report - RPT-RTR-020 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.
NCFS Report - RPT-RTR-022 The report is expected to show the count of expenditure lines in the cash ledger based on the parameters selected.
NCFS Report - RPT-RTR-024 The OSBM Annual Fee Report lists statutory or regulatory authority for each fee, the amount of the fee, when the amount of the fee was last changed, the number of times the fee was collected during the prior fiscal year, and the total receipts from the fee during the prior fiscal year. The report generated by this RICE object will pull the actual accounting balances from NCFS that will be used by agencies as part of the OSBM reporting requirements. The report generated as part of this RICE object would be the basis for the OSBM team to publish their final Annual Fee Report annually.
NCFS Report - RPT-RTR-025 The NC Budgetary Compliance Report informs the State on any budget codes/funds that have negative unexpended authorized budget balances for expenditure accounts for NC CASH ledger. This report displays negative budget balance when actual exceeds budget balance and unexpended budget balance when actual does not exceed budget balance.
NCFS Report - RPT-RTR-100 ACFR 11F - Fiduciary Net Position report as specified in section 2.5.
NCFS Report - RPT-RTR-102 CAFR 11G Debt Balance sheet report lists account balances for debt related budget codes as specified by OSC summarized by Account Groups as specified in section 2.5.
NCFS Report - RPT-RTR-103 The report is expected to provide details of every account of Assets, Liabilities and Net Position for the current year. This report will be populated by proprietary 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.
NCFS Report - RPT-RTR-104 ACFR 12G - Operating Statement- Expenditures by Function Report lists Operating expenditures balances for Governmental Funds summarized by Account Groups in the natural account hierarchy as specified in section 2.5. This report contains both a static view of the report and a version of the report that is drillable both on rows and columns.
NCFS Report - RPT-RTR-105 ACFR 17G - Combining Schedule of Revenues and Expenditures-General Fund Report lists Revenue and Expenditure account balances for Governmental Funds summarized by Account Groups in the natural account hierarchy as specified in section 2.5. This report contains both a static view version of the report as well as a version of the report that has both row and column expansion capabilities.
NCFS Report - RPT-RTR-106 ACFR 17G - Combining Schedule of Revenues and Expenditures-Permanent Fund Report lists Revenue and Expenditure account balances for Permanent Funds summarized by Account Groups in the natural account hierarchy as specified in section 2.5. This report contains both a static view version of the report as well as a version of the report that has both row and column expansion capabilities.
NCFS Report - RPT-RTR-107 ACFR 17S - Combining Schedule of Revenues and Expenditures - Special Revenue Funds Report as specified in section 2.5. This report contains both a static view version of the report as well as a version of the report that has both row and column expansion capabilities.
NCFS Report - RPT-RTR-108 ACFR 50 report lists account balances for Governmental Funds summarized by revenue categories in the natural account hierarchy as specified in section 2.5. This report is a Governmental Funds Income Statement. The governmental funds are designated by their GASB fund classification. The revenues and expenditures are further functionalized consistent with the government wide presentation of revenues and expenditures.
NCFS Report - RPT-RTR-109 ACFR 50G report lists revenue account balances for Governmental Funds summarized by revenue categories in the natural account hierarchy as specified in section 2.5. This report is a Governmental Funds Revenue Statement. The governmental funds are designated by their GASB fund classification.
NCFS Report - RPT-RTR-110 ACFR 52G - DEBT (Debt Statement of Revenues, Expenditures and Changes in Fund Balances) the system to generate a report that is a Debt Statement of Revenues, Expenditures and Changes in Fund balance for Debit Issues by statement captions, that allows for drilldown capabilities as well as filtering for month and fiscal year as well as other dimensions, so that the report will be able to prepare for yearend financial reporting. This report is specific to Dept. of State Treasurer Legacy report is ACFR 52G-DEBT. Also, this report will be used primarily by the Department of the State Treasurer, along with the 11G-Debt. Report security should allow them to run both of these reports even though the budget codes presented are not in the DST budget fund hierarchy.
NCFS Report - RPT-RTR-111 ACFR 52G report lists account balances for Governmental Funds summarized by Account Groups in the natural account hierarchy as specified in section 2.5. This report is a Governmental Funds Income Statement. The governmental funds are designated by their GASB fund classification.
NCFS Report - RPT-RTR-112 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 provide such details of balances for every month of every quarter and then total for each quarter The report would also provide the same details for the Net Position and changes in Net Position.
NCFS Report - RPT-RTR-113 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.
NCFS Report - RPT-RTR-114 ACFR 54F Statement of Change 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.