The Aging Detail report allows you to print a list of outstanding invoices and unapplied cash.
This Section Includes:
Filters
- Complete the following filters as needed.
-
-
Unpaid As Of:
- Date
- Period
-
Unpaid As Of:
| The Unpaid As Of option allows you to report on invoices posted to the General Ledger. The Date filter searches based on General Ledger journal dates. Any invoices posted when the Interface with General Ledger option is turned off do not show on this report when the Unpaid As Of option is used. |
-
- Invoice Date - Range from which you want to view your detail report. Additional date filters may appear depending on what option you choose.
-
- Include Paid Invoices.
- Customers
- Bill To's
- Revenue Centers
- Sources
- Divisions: There is a filter for each division you have set up in Preferences.
| If you filter by Customer, unapplied cash does not show up on the report. This is because unapplied cash is only tied to the Bill To. |
Options
On the Options tab select if you want to Include Invoice Distributions. Select this option to include items, item descriptions, and item amounts from the invoice detail on the report. You can also select additional options:
- Complete the following options as needed.
-
- Change Appearance? - Check the box in order to change the font type and size. There is also a drop-down option to control the white space between the columns by a percentage.
- Include Invoice Distributions - Select this option to include items, item descriptions, and item amounts from the invoice detail on the report.
- Print Notes
- Print Setup Information
- Print Bill To Address and Phone
- Print Divisions
- Print Customer Number
Report:
- Click the Run Report button to generate a preview of the report. Refer to the Report Preview help page for more information. Click the Clear Preferences link to reset all of your report preferences to their default values if needed.
- The following columns display on the report.
For each Bill To each payment or invoice is displayed on a line with the following columns:
-
- Customer
- Date
- Invoice #/Item: The item is included if the option to Include Invoice Distributions is selected.
- Revenue Center/Item Description: The item description is included if the option to Include Invoice Distributions is selected.
- Source/Division
- Amount: A positive amount indicates an invoice, and a negative amount indicates a payment.
Under the detail for each bill to there is a row containing the following columns:
-
- Current: The total amount that is currently due (not overdue).
- 31-60 Days: The total amount that is 31-60 days overdue.
- 61-90 Days: The total amount that is 61-90 days overdue.
- 91-120 Days: The total amount that is 91-120 days overdue.
- 121 & Over: The total amount that is 121 or more days overdue.
- Total: The total of the previous columns minus any unapplied cash.
| If you are using the Unpaid As Of option, all of the columns shown on this report are based on the date or period selected as opposed to the current date. |
Any unapplied cash for the bill to displays as Total Unapplied Cash underneath the row described above.
After all of the detail is the Aging Detail Report Recap. This includes the following:
-
- Totals by Revenue Centers: Columns for Current, 31-60 Days, 61-90 Days, 91-120 Days, 121 & Over and Total are displayed for each revenue center along with any Unapplied Cash. The Total amount is adjusted by any unapplied cash for that revenue center.
- Totals by Sources: Columns for Current, 31-60 Days, 61-90 Days, 91-120 Days, 121 & Over and Total are displayed for each source along with any Unapplied Cash. The Total amount is adjusted by any unapplied cash for that source.
- Item Recap: Columns for Item, Item Description, and Total are displayed for each item. If the option to Include Paid Invoices is selected on the Filters tab the total Sales Tax (if applicable), Total, Less Payments, and Net are also displayed at the bottom of the recap.
- Click the Close Report button to return to the dashboard.
Updated