Login  |  Navigation  |  Tutorials & Videos  |  Security Setup  |  Utilities  |  Applications  |  Resources  |  Release Notes

Applications > Accounts Receivable > Reports > Aging Summary

 

 

 

 

Aging Summary


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

 

Filters and Options

 

On the Filters tab select if you want to only view Unpaid As Of and then select the Date or 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.

 

Select the Invoice Date range from which you want to view your summary report.  Additional date filters may appear depending on what option you choose.

Select your Invoice Aging option: All, 31 or >, 61 or >, 91 or >, or 121 or >. If you make a selection other than All, you also have the option to Exclude Bill To's with Zero Balances. You have several additional options to narrow down your selections:

Revenue Centers

Sources

Divisions: There is a filter for each division you have set up in Preferences. 

On the Options tab select if you want to Print Bill To Address and Phone or Print Customer Number.

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.

Click the Run Report button to generate a preview of the report.

Click the Clear Preferences link to reset all of your report preferences to their default values.

Click the Close Report button to return to the dashboard.

The report displays on the Report Preview page. Refer to the Report Preview help page for more information.