The Aging Period Summary report prints total charges and receipts for outstanding invoices within the selected date range. The report displays all Bill To records with Accounts Receivable invoice history.
Filters
- 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
- Complete the following options as needed:
- Change Appearance?: check the box to change the font type and size. A drop-down also controls the white space between the columns by a percentage.
- Print Bill To Address and Phone?
- 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 in the report. For each Bill To, there is a row containing the following columns:
- Previous Balance: this column includes open invoices with invoice dates outside the report's date range. If you select to summarize by period, 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.
- Click the Close Report button to return to the dashboard.
Updated