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.
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.
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.
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.
This report captures Expense Delegate set up information for employees. Report populates expense delegates, and the employees assigned to each expense delegate along with employee assignment status, and employee bank account indicator for electronic payment of employee expenses.
Payment Process Request in Process Report provides information on all invoices currently pulled into PPRs that have not yet been completed. This report can be run by BU or for a specific PPR. The summary tab totals the dollar amount of the PPR by Budget Fund.
Unpaid Invoice Status Report provides detailed information on unpaid invoices including invoice approval and validation status, invoice hold information, and days past due. The Summary tabs in this report count the number of unpaid invoices by Status Group. There is a summary tab for all unpaid invoices and a separate tab for past due invoices.