Aging Summary Report

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

This Section Includes:

• Filters
• Options

Filters

1. Complete the following filters as needed.

• • Unpaid As Of:
    • Date
    • Period

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 Feed 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 summary report.  Additional date filters may appear depending on what option you choose.

• • Invoice Aging:  If you make a selection other than All, you also have the option to Exclude Bill To's with Zero Balances. 
    •  All
    • 31 >
    • 61 or >
    • 91 or >
    • 121 or >
    • Exclude Bill To's with Zero Balances. 
  • Revenue Centers
  • Sources
  • Divisions: There is a filter for each division you have set up in Preferences. 

Options

1. 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.
    • Print Bill To Address and Phone?
    • Print Customer Number?

Report:

1. 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. 
2. The following columns display on the report.

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. If you are using the Date option, it is specific to the exact journal date. Example: An invoice with a journal dated 3/15/15 does not show on the report if you have selected an Unpaid As Of Date of 3/14/15.

Any unapplied cash for the bill to displays as Unapplied Cash underneath the row described above.

After all of the detail is the Aging Summary 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. Any Unapplied Cash is displayed under this row. 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. Any Unapplied Cash is displayed under this row. The Total amount is adjusted by any unapplied cash for that source.

3. Click the Close Report button to return to the dashboard.

Updated February 20, 2025 17:45