This Lesson will discuss the two reports specific to Accounts Receivable: AR Aging, and the Customer Statement.
These reports are located on the Customers tab in My Reports. Only Users with the proper report security will be able to access each report.
AR Aging
The AR Aging report allows you to get a quick glance of any outstanding AR Invoices, broken down by Legal Entity and date. Set the report parameters, then click 'Run' to open the report in the report viewer.
AR Totals will be displayed for each Customer that has an outstanding invoice. Groups include:
- Current
- 1-30 days past
- 31-60 days past
- 61-90 days past
- and 91+ days past
You can expand each line by clicking the '+' icon, or adjust the report parameters to include 'Detail'.
Unassigned Customer
If you have a Customer titled 'Unassigned Customer' this is system generated entry and is created to force the Accounts Receivable account in to balance. This is an error that needs to be resolved, otherwise the Unassigned Customer amount will remain on your AR Aging indefinitely.
Refer to the 'AP Aging' Lesson in the 'AP Reporting' Course for detailed instructions on how to resolve the issue. Replace 'Accounts Payable' with 'Accounts Receivable', and 'Vendors' with 'Customers' in all instructions.
Customer Statement
The Customer Statement report will produce a page for each Customer with any open AR Transactions. The individual Customer Statement page will contain a list of each open AR Transaction, the transaction type, the relevant dates, the total amount, and the Amount remaining.
The top of the statement will list the Total Amount Due. An individual Customer AR Aging will be listed for reference, below the list of transactions. Use the export menu to print the statements and provide them to your Customers.