Aging Summary Report

The Aging Summary report allows you to print information on outstanding amounts due and unapplied cash.

Filters

1. Complete the following filters as needed.
   • Unpaid As Of: Select the basis for reporting on outstanding invoices.

Note: The Unpaid As Of option reports on invoices posted to the General Ledger. The Date filter searches based on General Ledger journal dates. Invoices posted when the Feed General Ledger option is turned off do not appear on this report when Unpaid As Of is used.

2. Invoice Date: Select the date range for the summary report. Additional date filters may appear depending on the option chosen.

3. Invoice Aging: Select an aging range. If you select any option other than All, you can also choose to exclude Bill To's with Zero Balances.
   • All
   • 31 >
   • 61 or >
   • 91 or >
   • 121 or >
   • Exclude Bill To's with Zero Balances
4. Revenue Centers
5. Sources
6. Divisions: A filter appears for each division configured in Preferences.

Options

1. Complete the following options as needed.
   • Change Appearance?: Check the box to change the font type and size. A drop-down option is also available to control the white space between columns as a percentage.
   • Print Bill To Address and Phone?
   • Print Customer Number?

Report

1. Click Run Report to generate a preview. Refer to the Report Preview help page for more information.
2. Click Clear Preferences to reset all report preferences to their default values if needed.
3. Click Close Report to return to the dashboard.

Report Output

For each Bill To, the report displays a row with the following columns:

1. Current: The total amount currently due (not overdue).
2. 31-60 Days: The total amount is 31–60 days overdue.
3. 61-90 Days: The total amount is 61–90 days overdue.
4. 91-120 Days: The total amount is 91–20 days overdue.
5. 121 & Over: The total number of days is 121 or more.
6. Total: The total of the previous is |minus any unapplied cash.

Any unapplied cash for the Bill To displays as Unapplied Cash beneath that row.

Note: When using the Unpaid As Of option, all columns are based on the selected date or period rather than the current date. When using the Date option, the filter applies to the exact journal date. For example, an invoice with a journal date of 3/15/15 does not appear on the report if the Unpaid As Of Date is set to 3/14/15.

After all detail rows, the report displays the Aging Summary Report Recap, which includes:

1. Totals by Revenue Centers: Displays Current, 31-60 Days, 61-90 Days, 91-120 Days, 121 & Over, and Total columns for each revenue center. Any Unapplied Cash displays beneath this row, and the Total is adjusted accordingly.
2. Totals by Sources: Displays the same columns for each source. Any Unapplied Cash displays beneath this row, and the Total is adjusted accordingly.

Updated June 10, 2026 06:59