Aging Period Summary Report

The Aging Period Summary report allows you to print total charges and receipts from outstanding invoices within the date range or period selected. The report displays all Bill To records with Accounts Receivable invoice history.

This Section Includes:

• Filters
• Options

Filters

1. Complete the following filters as needed.

• • Summarize for
    • Date Range 
    • Period 
  • Invoice Date

• • Exclude Bill To's with Zero Balances.
  • Bill To's
  • 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:

• • Previous Balance: This column includes open invoices with invoice dates before the date range of the report. If you are selecting to summarize by period, then open invoices posted to a period before the selected period are included in this column.
  • Charges: All Invoices within the date range or selected period are included in this column when they match other filters in report preferences.
  • Receipts: All Payments within the date range or selected period are included in this column.
  • Ending Balance: A calculation of the previous three columns: [Previous Balance] + [Charges] - [Receipts].

NOTE: Miscellaneous Cash payments do not show on this report. All Unapplied Cash payments that are less than or equal to the end date or the selected period display on a separate row, right below the Bill To.

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

Updated February 20, 2025 20:13