Purpose
The purpose of this Quick Reference Guide (QRG) is to provide a mapping of reports between NCFS and NCAS.
Introduction and Overview
This QRG contains a listing of NCFS report names. Along with report names, additional information is provided to help you understand the purpose of the report, the navigation path needed to submit the report, and the most closely associated NCAS report (if any).
User Tip
To locate the NCFS report most closely related to your legacy report (NCAS or Cognos), search [Ctl+F] for the name of the legacy report, or a portion of the legacy report name.
| Navigation | NCFS Report | NCAS Equivalent | Cognos Equivalent | Description | Use / Frequency | |
| Custom/FBR Custom/Reports/General Ledger | NC Available Funds Report AFF (RPTRTR001) | N/A | N/A | The Available Funds Report provides details of expense for specific budget fund—Agency Management Unit—Agency Program—Project combination. The budget is also captured for the same combination in Budgetary Control menu. This report can be run at any date and the expenses would be captured till date along with budget amounts. The summary levels will be based on the control budget used by the agency for funds checking. | State reporting requirements entail the need to report on available budgetary fund balances at the distribution level as well as the associated summary levels used for budgetary funds checking. This report is designed to accomplish that and to provide details of ‘Budgeted Amount’, Expense amount’, ‘Encumbrance Amount’ and ‘Commitment Amount’ for all the expense account ranges starting with 5 series. | |
| Custom/FBR Custom/Reports/General Ledger | NC Cash Basis - Project Life to Date Balances Report (RPTRTR003) | N/A | N/A | This report is designed to provide a Life-To-Date view of projects tracked using the Project Segment of the Chart of Accounts. | ||
| Custom/FBR Custom/Reports/General Ledger | NC Liability Report for All Ledgers (RPTRTR006) | N/A | N/A | This report displays the debits, credits, beginning, and ending balances for liability accounts. | State reporting requirements entail the need to report the liability for Accrual, Modified Accrual and Cash ledgers. | |
| Custom/FBR Custom/Reports/General Ledger | NC Accrual Report for All Ledgers (RPTRTR007) | N/A | N/A | This report lists the debits, credits, beginning, and ending account balances for accrual balances. | State reporting requirements entail the need to report the Accrual for Accrual, Modified Accrual and Cash ledgers. | |
| Custom/FBR Custom/Reports/General Ledger | NC Detailed Balances by Bank Account Report (RPTRTR008) | N/A | N/A | |||
| Custom/FBR Custom/Reports/General Ledger | NC Income and Expenditures Report by Fiscal Year (Audit) (RPTRTR009) | N/A | N/A | The report lists all revenue and expenditure accounts at individual code combination level for the selected Agency, period, Budget Fund. | State reporting requirements entail the need to report the amounts of Income and Expenditures for the fiscal year or Quarter or Period by detailed account combinations. | |
| Custom/FBR Custom/Reports/General Ledger | NC Trial Balance by Agency and GASB Fund or Budget Code Report (RPTRTR011) | N/A | GASB and Budget Code Trial Balances | Trial Balance Report lists period debits, period credits, beginning, and ending account balances summarized by natural account, account type, and budget fund segment. | Summary and Detail, Budget Code or GASB Code trial balance. | |
| Custom/FBR Custom/Reports/General Ledger | NC Prior Period Posting Activity Report (RPTRTR012) | Cert Agencies W/Set Backs | N/A | This 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 group. | 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 will only be available to users with access to all agency data, primarily OSC support and reporting staff and potentially OSA audit staff. | |
| Custom/FBR Custom/Reports/General Ledger | NC GL Balances from Interface Agency Reconciliation Report (INTRTR013) | N/A | N/A | |||
| Custom/FBR Custom/Reports/General Ledger | NC Capital Improvements (725) Detail Report (RPTRTR014) | BD725 Org Mask | N/A | 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. 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. | Monthly Reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC Cash Receipts Disbursements and Balance by Budget Fund (704) Report (RPTRTR015) | BD704 | N/A | Budget fund cash report (BD704) is needed for the month that is closing after an agency has notified OSC that they are ready to certify, so that a copy of Statements of Cash, Receipts, Disbursements and Balances by Budget fund reports can be maintained (BD704) for each month of the fiscal year. | Monthly Reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC Statewide Cost Allocation Plan Count Report (RPTRTR022) | N/A | N/A | This report will generate an expenditure transaction count for cash basis agency transactions for use in the preparation of the Statewide Cost Allocation Plan (SWCAP). | SWCAP Reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC Annual Fee Report (RPTRTR024) | N/A | N/A | 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. | OSBM use | |
| Custom/FBR Custom/Reports/General Ledger | NC Budgetary Compliance Report (RPTRTR025) | N/A | N/A | The NC Budgetary Compliance Report (RPTRTR025) is developed to inform 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. | The purpose of this report is to provide the State with a list of expense accounts with their unexpended budget balances by GASB fund, Budget code, Budget fund and account, where the negative/unexpended amounts are emphasized. | |
| Custom/FBR Custom/Reports/General Ledger | NC Perform Programmatic Close of GL Reconciliation Report (INTRTR048) | N/A | N/A | |||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 11F - Fiduciary Net Position Report (RPTRTR100) | N/A | CAFR 11F | Balance sheet equivalent for fiduciary funds. | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC DHHS Expense Allocation Pre-Validation Report (RPTRTR101) | N/A | N/A | This report pulls line counts for deposit journals keyed by employees in the Cashiering section of DHHS for a given period. The deposit lines counted exclude lines keyed to the project code for “to be allocated” costs, formerly FRC 99. | Cost allocation validation | |
| Custom/FBR Custom/Reports/General Ledger | NC DHHS Expense Allocation Reconciliation Report (RPTRTR101) | N/A | N/A | This report displays the allocation of actual expenditures and cost allocated expenditures at a detailed account level and is used for financial reporting and audit documentation. | Cost allocation validation | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 11G Debt Balance Sheet Report (RPTRTR102) | N/A | CAFR 11 G Debt | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 11P - Statement of Net Position Report (RPTRTR103) | N/A | CAFR 11P | Balance sheet equivalent for proprietary funds (Enterprise and Internal Service). | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 12G - Operating Statement - Expenditures by Function Report (RPTRTR104_163) | N/A | CAFR 12G | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 12G - Operating Statement - Expenditures by Function Report-Static View (RPTRTR104_163) | N/A | CAFR 12G | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 17G - Combining Schedule of Revenues and Expenditures - General Fund Report (RPTRTR105_160) | N/A | CAFR 17G | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 17G - Combining Schedule of Revenues and Expenditures - General Fund Report-Static View (RPTRTR105_160) | N/A | CAFR 17G | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 17P - Combining Schedule of Revenues and Expenditures - Permanent Funds Report (RPTRTR106_161) | N/A | CAFR 17P | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 17P - Combining Schedule of Revenues and Expenditures - Permanent Funds Report-Static View (RPTRTR106_161) | N/A | CAFR 17P | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 17S - Combining Schedule of Revenues and Expenditures - Special Revenue Funds Report (RPTRTR107_159) | N/A | CAFR 17S | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 17S - Combining Schedule of Revenues and Expenditures - Special Revenue Funds Report-Static View (RPTRTR107_159) | N/A | CAFR 17S | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 50 - Statement of Activities - Part 1 (RPTRTR108) | N/A | CAFR 50G - Part 1 | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 50G - Statement of Activities - Part 2 - Govt'l Funds Report (RPTRTR109) | N/A | CAFR 50G - Part 2 | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 52G DEBT - Debt Statement of Revenues Expenditures and Changes in Fund Balance Report (RPTRTR110) | N/A | CAFR 52G DEBT | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 53P - Quarterly Statement of Revenues Expenses and Changes in Fund Net Position Report (RPTRTR112) | N/A | CAFR 53P -Quarterly | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 53P - Statement of Revenues Expenses and Changes in Fund Net Position Report (RPTRTR113) | N/A | CAFR 53P | Operating statement for proprietary funds (Enterprise and Internal Service). | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 54F - Statement of Changes in Fiduciary Net Position Report (RPTRTR114) | N/A | CAFR 54F | Operating statement equivalent for fiduciary funds. | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/Statewide Reports | NC COMP 11F - Comparative Fiduciary Net Position Report (RPTRTR115) | N/A | COMP 11F | 2 Year Comparative Balance sheet equivalent for fiduciary funds. | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/Statewide Reports | NC COMP 11G - Comparative Balance Sheet Report (RPTRTR116) | N/A | COMP 11G | 2 Year Comparative Balance sheet equivalent for governmental funds (General fund, Special revenue and Capital). | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/Statewide Reports | NC COMP 11P - Comparative Statement of Net Position Report (RPTRTR117) | N/A | COMP 11P | 2 Year Comparative Balance sheet equivalent for proprietary funds (Enterprise and Internal Service). | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 12G - Comparative Operating Statement - Expenditures by Function Report (RPTRTR118_162) | N/A | CAFR 12G-Comparative | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC ACFR 12G - Comparative Operating Statement - Expenditures by Function Report-Static View (RPTRTR118_162) | N/A | CAFR 12G- Comparative | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/Statewide Reports | NC COMP 52G - Comparative Statement of Revenues Expenditures and Changes in Fund Balance Report (RPTRTR119) | N/A | COMP 52G | 2 Year Comparative Operating statement for governmental funds (General fund, Special revenue and Capital). | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/Statewide Reports | NC COMP 53P - Comparative Statement of Revenues Expenditures and Changes in Fund Net Position Report (RPTRTR120) | N/A | COMP 53P | 2 Year Comparative Operating statement for proprietary funds (Enterprise and Internal Service). | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/Statewide Reports | NC COMP 54F - Comparative Statement of Changes in Fiduciary Net Position Report (RPTRTR121) | N/A | COMP 54F | 2 Year Comparative Operating statement equivalent for fiduciary funds. | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR Prep-Major Fund Enterprise Report (RPTRTR122) | N/A | N/A | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR Prep-Major Fund Governmental Report (RPTRTR123) | N/A | N/A | ACFR reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC Management Analysis Report - All Agencies by Account and Fund Report (RPTRTR124_125) | All Agencies by Account and Fund | N/A | This report lists budget and actual amounts by natural expenditure account and Budget Fund. | The report will pull budget information from Budgetary Control and Actuals from the ledger. | |
| Custom/FBR Custom/Reports/General Ledger | NC Negative Unexpended Authorized Budget Report (RPTRTR129) | N/A | N/A | NC Negative Unexpended Authorized Budget Report is developed to inform the State on any budget codes 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. | This report provides the State with a list of accounts with their unexpended budget balances by budget code, where the negative unexpended amounts are emphasized. | |
| Custom/FBR Custom/Reports/General Ledger | NC COPS Reconciliation Report (RPTRTR130) | N/A | COPS Reconciliation Report (GDAC portal) | Due to security, report will need to be scheduled by OSC to be sent to DST as needed. | ||
| Custom/FBR Custom/Reports/General Ledger | NC Over Expenditures Agencies and Over Expenditures Universities Report (RPTRTR132) | NC Over Expenditures Agencies and Over Expenditures Universities Report | N/A | This report lists the amount of annual budget and year to date actuals by natural expenditure account, budget fund and budget code out of Oracle ERP Cloud. | The report does a calculation of budget – actuals = unexpended authorized. (These are dollar amounts and not percentages. A positive amount means you spent less than your budget. A negative amount meant you overspent your budget). | |
| Custom/FBR Custom/Reports/General Ledger | NC Year End Analyst Gov Report (RPTRTR133) | N/A | Year end Analyst Gov Report | This report identifies issues that would prevent an agency from closing out the fiscal year from a financial reporting perspective or cause reporting issues. This report is intended for the ACFR analyst and is a tool to quickly identify issues. | Finance team will complete and post all eligible transactions to the ledger and the Finance team/respective user will run the report and review the results. | |
| Custom/FBR Custom/Reports/General Ledger | NC YEar End Analyst Prop Report (RPTRTR134) | N/A | Year end Analyst Prop Report | This report identifies issues that would prevent an agency from closing out the fiscal year from a financial reporting perspective or cause reporting issues. This report is intended for the ACFR analyst and is a tool to quickly identify issues. | Finance team will complete and post all eligible transactions to the ledger and the Finance team/respective user will run the report and review the results. | |
| Custom/FBR Custom/Reports/General Ledger | NC Agency Chart of Account Values (RPTRTR135) | N/A | N/A | |||
| Custom/FBR Custom/Reports/General Ledger | NC Agency Chart of Account Values Report (RPTRTR135) | N/A | N/A | Report listing available chart segment values for an agency that matches the report parameters entered by the user when running the report. The report produces an excel document that contains a tab for each of the 11 charts of accounts segments with information and the primary hierarchy for each. The report shows child values and the parent values they roll up to. The report is controlled by segment security so that each agency only sees the values available for them to use. | ||
| Custom/FBR Custom/Reports/General Ledger | NC Capital Improvements (725) Report (RPTRTR137) | BD725 | N/A | 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. | Monthly reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC Journal Audit Report (RPTRTR138) | N/A | N/A | The Audit Report is a report that lists all the journals and changes made to unposted journals within Oracle GL based on the parameters selected. | The purpose of this report is to provide oversight to changes made to the journals. This report will facilitate the auditing process. | |
| Custom/FBR Custom/Reports/General Ledger | NC List of Agencies Certified Report (RPTRTR139) | N/A | N/A | This report show what Agencies are certified for a given period and the date they are certified. | State needs a report to know what Agencies are certified for a given period and the date they certified for a given period. | |
| Custom/FBR Custom/Reports/General Ledger | NC GL All Ledgers Reconciliation Report (RPTRTR140) | N/A | N/A | This report lists the total beginning account balances, period debits, period credits, ending account balances and its differences summarized by account code combination for all three ledgers. | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/ACFR Reports | NC ACFR 11G - Balance Sheet Report (RPTRTR141) | N/A | CAFR 11G | Balance sheet equivalent for governmental funds (General fund, Special revenue and Capital). | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC GL Account Balances Reconciliation Report (RPTRTR142) | N/A | N/A | The report is generated by reconciling the bank account balances with Cash and investment GL account balances. | State reporting requirements entail the need to report account balances by Governmental Funds and Account Groups out of Oracle ERP Cloud. | |
| Custom/FBR Custom/Reports/General Ledger | NC IT Expenditures Report (RPTRTR143) | N/A | N/A | This report is NCFS version of the report that is built to support and reconcile with final report that would be built from FCCS. | State reporting requirements entail the need to report the IT expenditures incurred by the State during the specified period. While the actual IT Expenditure Report will be created primarily in FCCS, this report will allow the user to verify the expenditure data going from NCFS to FCCS to produce that portion of the IT Expenditures Report. | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/EAGLE Reports | NC EAGLE ACFR 11F - Fiduciary Net Position Report (RPTRTR144) | N/A | EAGLE ACFR 11F | 2 Year Comparative Balance sheet equivalent for fiduciary funds. | EAGLE analysis | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/EAGLE Reports | NC EAGLE ACFR 52G - Statement of Revenues Expenditures and Changes in Fund Balances Report (RPTRTR145) | N/A | EAGLE ACFR 52G | 2 Year Comparative Operating statement for governmental funds (General fund, Special revenue and Capital). | EAGLE analysis | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/EAGLE Reports | NC EAGLE ACFR 53P - Statement of Revenues Expenses and Changes in Fund Net Position Report (RPTRTR146) | N/A | EAGLE ACFR 53P | 2 Year Comparative Operating statement for proprietary funds (Enterprise and Internal Service). | EAGLE analysis | |
| Custom/FBR Custom/Reports/General Ledger | NC Aggregate of Receivables for Governmental Funds Report (RPTRTR148) | N/A | Aggregate of Receivables for Governmental Funds | 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. | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger | NC Aggregate of Receivables for Proprietary Funds Report (RPTRTR149) | N/A | Aggregate of Receivables for Proprietary Funds | 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. | ACFR reporting | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/EAGLE Reports | NC EAGLE ACFR 11P - Statement of Net Position Report (RPTRTR150) | N/A | EAGLE ACFR 11P | 2 Year Comparative Balance sheet equivalent for proprietary funds (Enterprise and Internal Service). | EAGLE analysis | |
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/EAGLE Reports | NC EAGLE ACFR 54F - Statement of Changes in Fiduciary Net Position Report (RPTRTR151) | N/A | EAGLE ACFR 54F | 2 Year Comparative Operating statement equivalent for fiduciary funds. | EAGLE analysis | |
| Custom/FBR Custom/Reports/General Ledger | NC Master Report for Budget Fund Hierarchies (RPTRTR153) | N/A | N/A | NC Master report for Budget Fund hierarchies (RPTRTR153) will list 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. | ||
| Custom/FBR Custom/Reports/General Ledger/FRS Reports/EAGLE Reports | NC EAGLE ACFR 11G - Balance Sheet Report (RPTRTR156) | N/A | EAGLE ACFR 11G | 2 Year Comparative Balance sheet equivalent for governmental funds (General fund, Special revenue and Capital). | EAGLE analysis | |
| Custom/FBR Custom/Reports/General Ledger | NC Chart of Accounts Combinations Report (RPTRTR157) | IE report COA-BY-CENTER | N/A | Report listing the accounting combinations currently created in NCFS that match the report parameters listed by the user when running the report. The report provides the chart segment values, as well as their descriptions that have been combined to make an accounting combination. It also provides various attributes such as whether the combination is enabled or not, the account type, etc. The report is controlled by segment security so that each agency only sees their combinations. | ||
| Custom/FBR Custom/Reports/General Ledger | NC Consolidated Statement of Enterprise Operations Report (RPTRTR158) | BD70 | N/A | 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. | |
| Custom/FBR Custom/Reports/General Ledger | NC Payroll Requisitions Interface Reconciliation Report (RPTRTR164) | N/A | N/A | |||
| Custom/FBR Custom/Reports/General Ledger | NC Agency GL Detailed Transaction Report (RPTRTR165) | IE report DAPG67 | N/A | Transaction Detail | ||
| Custom/FBR Custom/Reports/General Ledger | NC Monthly Balances Report (RPTRTR166) | N/A | N/A | The report would show the details of balances month wise for the selected fiscal year by every account code combination. | The need for the report to see the details of period activity month wise for a fiscal year by every account code combination. | |
| Custom/FBR Custom/Reports/General Ledger | NC DHHS AR Deposit Transaction Count Report (RPTRTR167) | N/A | N/A | Input for cost allocation percentage calculation. | ||
| Custom/FBR Custom/Reports/General Ledger | NC GASB Transfers Reconciliation Report (RPTRTR168) | N/A | N/A | This report is designed to be used to help analysts reconcile the transfer related amounts that are imported into FCCS from NCFS. This report will help identify whether transfer amounts match between GASB funds and when they do not. | ACFR compilation | |
| Custom/FBR Custom/Reports/General Ledger | NC GASB Due to and Due From Reconciliation Report (RPTRTR169) | N/A | N/A | This report will help identify whether amounts match between GASB funds and when they do not. This report will not include information from NC Housing Finance Authority, UNC Hospitals, or Universities. The related amounts for these entities will be imported into FCCS via package spreadsheet. | ACFR compilation | |
| Custom/FBR Custom/Reports/General Ledger | NC Agency Journal Import Errors Report (RPTRTR170) | N/A | N/A | 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. | This report will help to show agencies if there are any Journal Import Error batches that failed for their agency number and details of such failed records. | |
| Custom/FBR Custom/Reports/General Ledger | NC Interface Agency Reconciliation Report (RPTRTR171) | N/A | N/A | 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. | Used to assist interface agencies with determining their clearing budget fund information has been reversed. | |
| Custom/FBR Custom/Reports/General Ledger | NC DHHS Revenue Distribution Pre-Validation Report (RPTRTR173) | N/A | N/A | cost allocation validation | ||
| Custom/FBR Custom/Reports/General Ledger | NC DHHS Revenue Distribution Reconciliation Report (RPTRTR173) | N/A | N/A | cost allocation validation | ||
| Custom/FBR Custom/Reports/General Ledger | NC DHHS Direct and Allocated Expenditures Report (RPTRTR174) | DHHS 2605Detail | N/A | Detailed balances by bank ID Report lists the GL transactional balances, period debits, period credits, Journal batch name, Journal name, Journal category, Journal Source and other details for selected Agency, Budget code, and Accounting Period by bank account number. | cost allocation validation | |
| Custom/FBR Custom/Reports/General Ledger | NC Accrual Basis Budget to Actuals Report (RPTRTR187) | N/A | N/A | This report is specifically used by NC DIT. NC Accrual Basis Budget to Actuals Report is a report that shows budgeted to actual revenues and expenditure, as well as encumbrances, on the accrual basis. | Monthly reporting | |
| Financials/General Ledger/Account Analysis | Account Analysis Report | N/A | N/A | Ad hoc | ||
| Custom/FBR Custom/Reports/General Ledger | FBR Budget Code Cash Transfer Report | N/A | N/A | Payroll allocation reconciliation | ||
| Custom/FBR Custom/Reports/General Ledger | FBR Cash inter Fund Clearing Interface Reconciliation Report | N/A | N/A | ACFR Reporting/reconciliation | ||
| Custom/FBR Custom/Reports/General Ledger | FBR CoA Mapping Set Report | N/A | N/A | Crosswalk of NCAS distributions to NCFS. | ||
| Custom/FBR Custom/Reports/General Ledger | FBR Commerce Cost Allocation Reconciliation Report | N/A | N/A | Agency Specific Report | ||
| Custom/FBR Custom/Reports/General Ledger | FBR Cost Allocation Pre-Validation Report | N/A | N/A | Agency Specific Report | ||
| Custom/FBR Custom/Reports/General Ledger | FBR DPS Cost Allocations Reconciliation Report | N/A | N/A | Agency Specific Report | ||
| Custom/FBR Custom/Reports/General Ledger | FBR NCFS GL Journal Interface Reconciliation Report | N/A | N/A | Interface Recon Report | ||
| Custom/FBR Custom/Reports/General Ledger | FBR OSC Payroll Cost Allocations Reconciliation Report | N/A | N/A | Agency Specific Report | ||
| Financials/General Ledger/Journals | General Journals Report | N/A | N/A | Ad hoc | ||
| Scheduled Processes | General Ledger Account Details Report | N/A | N/A | Ad hoc | ||
| Scheduled Processes | General Ledger Journal Entry Report | N/A | N/A | Ad hoc | ||
| Scheduled Processes | General Ledger Trial Balance Report | N/A | N/A | Ad hoc | ||
| Custom/FBR Custom/Reports/General Ledger | NC Budget to Actual (701) Detailed Report | BD701 Org Mask | BD701 | Monthly Reporting | ||
| Custom/FBR Custom/Reports/General Ledger | NC Budget to Actual (701) Excel Report | BD701 Excel | BD701 | Monthly Reporting | ||
| Financials/General Ledger/Trial Balances | Trial Balance Report | N/A | N/A | Ad hoc |
Wrap-Up
Using the information contained in this document, determine which NCFS reports have an NCAS equivalent report.
Additional Resources
- Web-Based Training (WBT)