NCFS Pre-Built Reports

Receipts and Disbursements by Function 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. The report is made of two sections. In the top section, rows are the budget code titles arranged in budget code number order within function captions. There are subtotals by function caption and a grand total. There are four columns: monthly receipts, year to date receipts, monthly disbursements, year to date disbursements. In the bottom section of the report is the Ending Unreserved Cash calculation: Beginning Unreserved Cash +Year to date Receipts -Year to date Disbursements + Reservations = Ending Unreserved Cash.

General Fund Non-Reverting Departmental Cash Schedule of Receipts and Disbursements by Function and Agency provides 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. The data elements used to determine receipts and disbursements by function include budget code by function (Agriculture, Debt Service, Education, Economic Development, Environment and Natural Resources, General Government, Health and Human Services, and Public Safety, Correction, and Regulation as well as by agency. Results are calculated as:

• Beginning Cash = Prior Year End cash balance
• Receipts - Month = Current Month Receipts (deposits + transfers in) 
• Receipts – Year-To-Date = YTD Receipts (deposits + transfers in) 
• Disbursements – Month = Current Month Expenditures (requisitions + transfers out + payments) 
• Disbursements – Year-To-Date = YTD Expenditures (requisitions + transfers out + payments) 
• Year-To-Date Ending Cash = Beginning Cash + YTD Receipts –YTD Expenditures

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

• Prior Year Ending Balance– Previous year ending balance
• Pending Adjustment to Prior Year
• 19900 – 19929
• 19949 – 19999
• 19800 – 19899
• 19930 – 19948
• Current Year Beginning Balance - Prior Year Ending Balance -Pending Adjustment to Prior Year
• Fund Balance Reclassification: Display YTD Activity for budget codes 19800 – 19899 and 19930 – 19948
• “Receipts YTD” (Deposits and Transfers In) of the Agency Cash Account by Budget Code- (Posted)
• “Expenditures YTD” (Requisitions and Transfers Out) of the Agency Cash Account by Budget Code - (posted)
• 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’
• Calculated Ending Cash Balance of the Agency Cash Account by Budget Code

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. The data elements used to determine YTD balances by budget code for each agency include:

• Original appropriations
• Appropriation revisions
• Adjusted appropriations
• Unexpended appropriations (adjusted appropriation –appropriation expenditures)
• YTD receipts (deposits and transfers in)
• YTD expenditures (requisitions, payments and transfers out)
• Appropriation expenditures (YTD expenditures – YTD receipts)

Daily Cash Position 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. Data for the report summarizes cash transactions in Posted status within Oracle ERP for the selection period. The ending cash and unreserved fund balance calculated on the Weekly Cash Watch report and the Daily Cash report should be the same when the Report To date parms are the same.

Monthly Financial Control Report is an excel spreadsheet that lists various cash balances, calculations and identifying information for all budget code-GASB combinations that represent the General Fund, both reverting and non-reverting. The report includes data from the General Fund Cash Report Mapping table. All budget codes/GASB combinations meeting the selection criteria should be included in the spreadsheet even if the budget code is not found in the mapping table. The user of the spreadsheet will create their own pivot tables and/or calculations to aid in analyzing the General Fund Monthly Financial Report series.

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.

NC AP Disbursements Report provides information regarding daily AP payments. The report will contain two sections, one related to summary data by agency and budget code and a second report containing detail related to pending and completed AP payments.

Bank Account by Agency Report summarizes the bank accounts associated per state agency or university. It also assists in
determining if the account is enabled for use in NCFS.

NC OSC to DST Summary Report creates summary data that will assist DST in reconciling daily transactional data input into CB$ from NCFS.

NC AP IGO Payment Transfers Report provides AP IGO Receivers sufficient information to code transfer receipts, reconcile receipts to amounts billed, and verify remaining balances due. It will also assist in identifying exceptions to payments at an invoice level and provide contact information for AP IGO payments.

This report shows open employee cash advances and any employee reimbursements that are partial applied to advances with remaining outstanding balance.

This report captures possible duplicate transactions that interface from Wright Express (WEX) and Bank of America.

The NC Wright Express Spending report captures spending on individual Wright Express gas cards. Report displays transaction data by card holder and by vendor as interfaced from WEX.

This report provides a printable/PDF friendly copy of employee expense reports. The template includes approver information with dates and expense item information. The AP invoice and payment information populate as the expense moves through the payment process.

This report shows analytical information regarding the process of employee expenses and cash advances including who prepared the expense, the expense item information, approval and auditor information, along with the number of days the expense remained at each stage of processing.

As part of this specification, the Canceled Invoice Line Report generates a list of source lines related to asset invoice lines purchases that were canceled or to credit/debit memos lines created for assets returns in Oracle Cloud Accounts Payable System. These records would interface to Mass Additions Interface as source lines with cost of zero or less. The Asset Accountant will review the source lines with cost of zero or less in the Mass Additions Interface before deleting the related source lines from Mass Additions Interface or retiring the related assets from Oracle Cloud Fixed Assets System.

Deleted Capitalized Source Lines Report generates the list of Source Lines that were deleted from the Mass Additions Interface from the date of last ‘Delete Mass Additions’ ESS program run.

Assets Interface Audit Trail Report is generated on a monthly basis or as needed to show an audit trail for the Source Lines in the
Mass Additions Interface that was updated/maintained in the Mass Additions Interface. The report will display both the old and new values that were modified in the last 60 days from the current period.

Deleted Source Lines Report generates the all the source lines (expense or capitalized) that have been deleted for the past 90 days or from the last ‘Delete Mass Additions’ ESS run. This report will be critical to validate or inquire on source lines that have been deleted.

NC SWCAP Assets Report (RPTFA008) generates the consolidated list of all active capitalized assets and assets that are retired during the current or last fiscal year. This report will also show assets that has depreciated fully.

NC Asset List for Physical Counting Report generates the list of assets by Asset book and physical location.

NC Asset Type Reconciliation Report generates the list of Assets that have the incorrect Asset Type based on the State designated Capitalization Threshold.

NC Asset Additions by Agencies Report generates the list of assets by Asset book that were added as source lines (temporary) or posted as assets on a daily basis or for specific date range.

NC Asset adjustments by Agency Report generates the list of assets by Asset book that were adjusted (changes in Unit, Cost, Category, life in years/months, Date Place in Service) in the given date range period.