A/R Aging Summary Report

This report lists A/R accounts and summarizes their account balances. The account number, account name, account type, account status, and contact information, credit limit amount for an A/R account, and balance per each aging period are printed on the report.

The report can show up to 10 aging periods but will only show as many as are configured at the property.

You can filter the report by account type(s) or sales manager. You can choose to include accounts on credit hold status, accounts in open status, and accounts with zero balances. You can limit the report to only show accounts that are over their credit limit or accounts that are in collections.

You must select the property parameter ARRETAINPOSTDATEONXFER and the CRS application parameter AgingDayBasis must be set to CHARGE to calculate the aging of the transferred charges and payments based on the original posting date.

You can sort the report by account name, account number, account status, report date or account type. You can specify a Report Date to view what the aging looks like on the date that you specified. Usually, you specify a past date but you can also specify a future date. For example, if the current date is 2/7/2014 but you want to see what the aging looked like at month end on 1/31/2013, specify the Report Date as 1/31/2013:

  • All charge/invoice/payment activity that occurred after 1/31/2013 is excluded from the calculations.
  • All charge/invoice/payment activity that occurred on or prior to 1/31/2013 is aged as if the date is 1/31/2013.

If you select:

  • The Age by Month check box, the aging is calculated by the system for each A/R account, based on the calendar month instead of by number of days.
  • The Group By Account Type check box, the report is grouped by the accounts with the same account type and provide a subtotal for each grouping.