Understanding Aging Configuration

The aging periods are a consecutive series of time periods that depict how old the open charges and invoices are on the account. The From Days and To Days values for a period mean that if there are any unpaid invoices on the account that are From Days old to To Days old then the system displays the balance in that aging period. The aging is an indication of how well a customer pays the bills. If there is a portion of the account balance in one or more of the older aging periods the hotel needs to increase the collection efforts. Below is a typical example of aging period configuration.

Aging Period From Days old To Days old Explanation
Current Charges 0 30 The first aging period must start at 0 days. The sum of any unpaid charges or invoices, or unmatched payments, that were posted between 0 and 30 days before the current accounting date are displayed in this aging period
30 Days 31 60 The 'From Days' value of the next period must start the day after the 'To Days' value of the previous period. The sum of any unpaid charges or invoices, or unmatched payments, that were posted between 31 and 60 days before the current accounting date are displayed in this aging period
60 Days 61 90 The sum of any unpaid charges or invoices, or unmatched payments, that were posted between 61 and 90 days before the current accounting date are displayed in this aging period
90 + Days 91 -- The last aging period configured does not have a 'To Days' value. The sum of any unpaid charges or invoices, or unmatched payments, that were posted more than 90 days before the current accounting date are displayed in this aging period

There cannot be any gap of days between the periods so the system will adjust the To Days value automatically if possible. Outlined below are few scenarios based on the example above, when the error message is displayed by the system.

  • User changes the From Days value of the 30 Days period to 29 days. Since 29 days is less than the From Days value of the previous period, an error message is displayed.
  • User changes the From Days value of the 30 Days period to 62 days. Since 62 days is greater than the From Days value of the next period, an error message is displayed.

Here are examples of when the system would adjust the 'From Days' value of a period to ensure there are no gaps in days between periods.

  • User changes the From Days value of the 30 Days period to 32. System would change the To Days value of the Current Charges period to 31 to ensure no gaps.

Example of aging based on the aging configuration above:

  • Pre-requisite – Accounting Date = 3/1/2014
  • Total account balance = 5000.00
Aging Period Aging Amount Charges/Invoices / payments posted between
Current Charges 3200.00 1/30/2014 and 3/1/2014
30 Days 1000.00 12/30/2013 and 1/29/2014
60 Days 0.00 11/29/2013 and 12/29/2013
90 + Days 800.00 Before 11/29/2013