NCFS Pre-Built Reports

This interface will send receipts and expenditures monthly totals to Department of State Treasury (DST) to perform monthly reconciliations between Oracle GL and Flexcube. The interface will extract the data from Oracle to create a report and send specific information from the report to Flexcube for DST to complete reconciliation tasks.

DST to OSC Receipts and Expenditures Interface will send receipt and expenditure monthly totals from the Department of State Treasury (DST) to Oracle Cloud. The report will show revenue and expenditure balances by budget code in Oracle to compare it to the DST data sent for reconciliation purposes.

NC INV displays the inventory transfer order details keyed into NCFS.

RPT-AP-001 Prepayment Register Report will be run by Agencies for a specific Bank Account and Date Range as defined in the parameters of the report. The Summary level tab of the report will display the total cash by each unique combination of Agency-Budget Fund segment values. This summary-level data will be sourced from the Prepay 2 tab of the report. Following the Summary tab, there will be three Detail-level tabs filled with information. The first Detail-level tab will be the “Prepay 1 by Supplier Site” tab. This will display Invoice Information, grouped by Supplier Site, Supplier Type, then by Business Unit. Within each of these groupings, a subtotal will be calculated for the Total by the respective grouping. The second Detail-level tab will be the “Prepay 2 by BF-Account” tab. This will display Invoice information but grouped first by each unique Agency-Budget Fund-Account segment combination, then by Business Unit. The third Detail-level tab will be the “Prepay 3 by IC Transfers Only” tab. This will display Invoice information for only the intercompany transfers created in AP grouped by Supplier Site and then totaled by Business Unit.

Zero Dollar Payments Report will show all invoice types grouped together that result in a zero-dollar payment. This report can be used for clearing $0.00 from CM.

Payments Statistical Report summarizes the count and amount of payments by payment method, payment month and invoice settlement priority. This report can be used for EAGLE reporting.

Outstanding Check Report provides information regarding uncashed/unreconciled check payments within a selected date range for a selected Business Unit and Bank Account with the following details: Business Unit, Disbursement Bank Account Name, Remit-to-Supplier Number, Remit-to-Alternate Supplier Name, Remit-to-Supplier Site, Remit-to-Supplier Address Line 1, Remit-to Supplier Address Line 2, Remit-to Supplier Address Line 3, Remit-to Supplier Address Line 4, Remit-to Supplier Address City/State/Zip, Payment Process Request, Created By, Payment Number, Payment Date, Payment Amount, Total by Bank Account, Total by Business Unit, Total by Report.

Payment Register Report provides information regarding daily payments with the following details, By Payment Method: Business Unit, Payment Method, Payment Process Request, Created By, Payment Number, Payment Status, Payment Date, Gross Amount, Discount Amount, Withheld Amount, Payment Amount, Remit-to-Supplier Number, Remit-to Tax Reporting Supplier Name, Remit-To Alternate Supplier Site Name, Remit-to-Supplier Site, Remit-To Supplier Address Line 1, Remit-To Supplier Address Line 2, Remit-To Supplier Address Line 3, Remit-To Supplier Address Line 4, Remit-To Supplier Address City/State/Zip, Number, PO Number, Type, Date, Amount, Supplier Number, Tax Reporting Supplier Name, Supplier Alternate Site Name, Supplier Site Name, Supplier Type, Payment Priority, Pay Group, Invoice Group, Total by Payment Method, and Total By Business Unit By Supplier Type: Business Unit, Payment Method, Payment Process Request, Created By, Payment Number, Payment Status, Payment Date, Gross Amount, Discount Amount, Withheld Amount, Payment Amount, Remit-to-Supplier Number, Remit-to Tax Reporting Supplier Name, Remit-To Alternate Supplier Site Name, Remit-to-Supplier Site, Remit-To Supplier Address Line 1, Remit-To Supplier Address Line 2, Remit-To Supplier Address Line 3, Remit-To Supplier Address Line 4, Remit-To Supplier Address City/State/Zip, Number, PO Number, Type, Date, Amount, Supplier Number, Tax Reporting Supplier Name, Supplier Alternate Site Name, Supplier Site Name, Supplier Type, Payment Priority, Pay Group, Invoice Group, Total By Supplier Type, and Total By Business Unit.

Payment with COA Detail Report provides daily payment information including the cost distribution for each line.

Dollars Spent by County Report provides county information for supplier invoices, payments, and purchase orders.

1099 MISC Report populates 1099 MISC Forms to be printed and mailed to suppliers.

1099 MISC Report populates 1099 G Forms to be printed and mailed to suppliers.

1099 MISC Report populates 1099 NEC Forms to be printed and mailed to suppliers.

1099 Invoice Maintenance Report shows all invoices entered within a specific timeframe and whether those invoices have been flagged for 1099 reporting.

Fixed Asset Invoices Report generates a list of Asset invoice line purchases which are completed and accounted in NCFS. These lines interface on the FA Mass Additions Interface as source lines. The report also pulls in applicable Payment information from NCFS Accounts Payable when the invoice is paid, as well as applicable Purchase order information and Asset information once an asset is created. The payment information will not be pushed to FA unless the payment was made prior to the Mass Addition Interface being run. The report has two tabs, one for Excluded transactions and the other for Prospective transactions. AP Manager can review this report to validate that all asset invoices are paid, interfaced to FA, and source lines/assets are created.

AP Invoice Approval Workflow Status Report provides information regarding Unapproved Invoices with the following details: Business Unit, Supplier Number, Tax Reporting Supplier Name, Supplier Alternate Site Name, Supplier Site Name, Invoice Type, Invoice Number, Invoice Date, Invoice Due Date, Invoice Amount, Workflow Type, Invoice Approval Status, Invoice Created By, Invoice Creation Date, Initiated By, Initiated Date, Time, Initiated Action, Approver, Assigned Date, Assigned Time, Pending With Approver (In Days), Cumulative Days, Reason, and Comments.

NCG Grant Payments Report provides information regarding payments of invoices containing an NCG Grant Number.

Direct Entry vs PO Matched Invoices Paid Report provides information regarding matched and Unmatched Paid Invoices with the following details: Business Unit, Disburse Bank Account Name, PO Indicator, PO Number, Account, Account Description, Invoice Number, Invoice Date, Invoice Line Number, Invoice Line Distribution Number, Invoice Line Distribution Amount, Supplier Type, Remit-to-Supplier Number, Remit-to-Supplier Site, Supplier/Party/Employee Name Remit to Name, Payment Number, Payment Date, and Payment Status.

Open Credit Memo Report will display all open credit memos along with the related invoices that were offset resulting in credit balance. Once the credit memo has been completely offset, and paid the credit memo will drop off the report.

Invoice Hold and Released Report displays Invoices on hold as of the current system date OR Invoices Released within a selected date range for a selected Business Unit with the following details: Business Unit, Supplier Number, Tax Reporting Supplier Name, Supplier Name, Supplier Site Name, Invoice Type, Invoice Number, Invoice Date, Invoice Due Date, Invoice Amount, Invoice Line Number, Invoice Line Amount, Hold Name, Hold Reason, Held By, Held Date, Held Time, Assigned to, Releasable, Release Name, Release Reason, Released By, Released Date, Released Time, Agency, Budget Fund, Natural Account, Agency Mgmt Unit, Agency Program, Funding Source, Project, Inter Fund, Future 1, Future 2, Future 3, Remittance Message 1, Remittance Message 2, and Remittance Message 3.

Invoice Analytics Report provides stats regarding invoice creation such as Invoice Creator, Invoice Creation Date, Funds Status, Invoice Status, Approval Status, Approval Action Date, Payment Number, Payment Date, Paid Amount, Paid Status, Invoice Creation to Invoice Approval Days, Invoice Approval to Invoice Payment Days, Invoice Creation to Invoice Payment Days, and Days Payment Past due.

Supplier Tax Withholding report provides information on Withholding Tax amounts taken out of payments for respective Suppliers. This report includes the Invoice Distribution level information including the Withholding Rates that were taken from specific Invoices.

AP Invoice Line Count Extract by Employee Project provides invoice line count information for agencies to complete cost allocations.

PCard Invoice OTBI report provides detailed information on PCard transactions processed in NCFS Accounts Payable as interfaced from Bank of America.

Unpaid Invoices Report is an OTBI report that provides detailed information on unpaid invoices. This report includes fields for PCard information.