Report Name: RPT-OTC-011 AR Aging Report by Invoices
Report Description: The RPT-OTC-011 AR Aging Report by Invoices will be run by AR Managers and Collections Managers to aid in the collections process. It will list all applicable outstanding Invoices based on the selected parameters, showing all applicable related transaction details, including the total transaction amount, total outstanding amount, specific aging bucket based on 7-bucket aging, Invoice write-off status, and the Receivables Distribution Account. The report can be run two different ways, one where it is Grouped by Customer, and another where it is grouped by Receivables Distribution Account.
Report Data Flow: AR transactions will be created outlining the items and services for which they are billing the customer for payment. This will include all lines for items and services as well as tax, freight and charges (penalty and/or interest) if applicable. Create Accounting program will run and post all applicable transactions to the ledger. During collections process, AR Manager will run report and identify all transactions in report, verifying the correct outstanding amounts, statuses, and distribution accounts.