The A/R Aging Method control maintenance record determines the method used by Eclipse to move A/R amounts from one aging bucket to the next. The record must be set to one of nine methods:
Methods 1 through 4 and 9 are based on the due date calculated from the terms on the invoice., whereas methods 5 through 8 use the invoice date.
The default method is Method 4 - Fiscal Month End. If you elect to use method 5, 6, 7, or 8, the system does not use the Future bucket.
Use the A/R Aging Bucket Names control maintenance record to modify A/R aging bucket names to suit your industry. For example, if you are using an aging method that uses due dates, then some sites change the name of the Current bucket to be "1-30," since those invoices are 1 to 30 days past due.
The following tables demonstrate what the aging bucket dates would be for each method using the this example:
Invoice Date: 06/04/09
Due Date: 07/15/09
Fiscal Month: Ends on 25th of each month
|
Aging Bucket |
Description |
Example Dates |
|
Future |
The invoice date up until the due date. |
06/04/09 - 07/14/09 |
|
Current |
The due date up until one month past the due date. |
07/15/09 - 08/14/09 |
|
31 - 60 |
One month past the due date up until two months past the due date. |
08/15/09 - 09/14/09 |
|
61 - 90 |
Two months past the due date up until two months past the due date. |
09/15/09 - 10/14/09 |
|
91 - 120 |
Three months past the due date up until two months past the due date. |
10/15/09 - 11/14/09 |
|
Over 120 |
Four months past the due and beyond. |
11/15/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
Future through the day before the due date. |
Anytime through 07/14/09 |
|
Current |
From the due date through 30 days from the due date. |
07/15/09 - 08/13/09 |
|
31 - 60 |
From the next day through 30 days from that date. |
08/14/09 - 09/12/09 |
|
61 - 90 |
From the next day through 30 days from that date. |
09/13/09- 10/12/09 |
|
91 - 120 |
From the next day through 30 days from that date. |
10/13/09 - 11/12/09 |
|
Over 120 |
From the next day and later. |
11/12/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
The invoice date up until the last date of that calendar month. |
06/04/09 - 06/30/09 |
|
Current |
The first date of the next calendar month up until the last date of that calendar month. |
07/01/09 - 07/31/09 |
|
31 - 60 |
The first date of the next calendar month up until the last date of that calendar month. |
08/01/09 - 08/31/09 |
|
61 - 90 |
The first date of the next calendar month up until the last date of that calendar month. |
09/01/09 - 09/30/09 |
|
91 - 120 |
The first date of the next calendar month up until the last date of that calendar month. |
10/01/09 - 10/31/09 |
|
Over 120 |
The first date of the next calendar month and beyond. |
11/01/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
The invoice date up until the last date of that fiscal month. |
Anytime through 06/25/09 |
|
Current |
The first date of the next fiscal month up until the last date of that fiscal month. |
06/26/09 - 07/25/09 |
|
31 - 60 |
31 days past the due date up until 60 days past the due date. |
07/26/09 - 08/25/09 |
|
61 - 90 |
61 days past the due date up until 90 days past the due date. |
08/26/09 - 09/25/09 |
|
91 - 120 |
91 days past the due date up until 120 days past the due date. |
09/26/09 - 10/25/09 |
|
Over 120 |
121 days past the due and beyond. |
10/26/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
The invoice date up until the due date. |
Anytime through 06/25/09 |
|
Current |
The due date up until one month past the due date. |
06/04/09 - 07/03/09 |
|
31 - 60 |
One month past the due date up until two months past the due date. |
07/04/09 - 08/02/09 |
|
61 - 90 |
Two months past the due date up until three months past the due date. |
08/03/09 - 09/01/09 |
|
91 - 120 |
Three months past the due date up until three months past the due date. |
09/02/09 - 10/01/09 |
|
Over 120 |
Three months past the due date and beyond |
10/02/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
Through the date before the invoice date. |
Anytime through 06/25/09 |
|
Current |
The due date up until 30 days past the due date. |
06/04/09 - 07/03/09 |
|
31 - 60 |
31 days past the due date up until 60 days past the due date. |
07/04/09 - 08/02/09 |
|
61 - 90 |
61 days past the due date up until 90 days past the due date. |
08/03/09 - 09/01/09 |
|
91 - 120 |
91 days past the due date up until 120 days past the due date. |
09/02/09 - 10/01/09 |
|
Over 120 |
121 days past the due and beyond. |
10/02/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
Through the last date of the fiscal month before the invoice date. |
Anytime through 05/31/09 |
|
Current |
The invoice date up until the last date of that calendar month. |
06/04/09 - 06/30/09 |
|
31 - 60 |
The first date of the next calendar month up until the last date of that calendar month. |
07/01/09 - 07/31/09 |
|
61 - 90 |
The first date of the next calendar month up until the last date of that calendar month. |
08/01/09 - 08/31/09 |
|
91 - 120 |
The first date of the next calendar month up until the last date of that calendar month. |
09/01/09 - 09/30/09 |
|
Over 120 |
The first date of the next calendar month and beyond. |
10/01/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
Through the last date of the fiscal month before the invoice date. |
Anytime through 05/25/09 |
|
Current |
The first date of the next fiscal month up until the last date of that fiscal month. |
05/26/09 - 06/25/09 |
|
31 - 60 |
31 days past the due date up until 60 days past the due date. |
06/26/09 - 07/25/09 |
|
61 - 90 |
61 days past the due date up until 90 days past the due date. |
07/26/09 - 08/25/09 |
|
91 - 120 |
91 days past the due date up until 120 days past the due date. |
08/26/09 - 09/25/09 |
|
Over 120 |
121 days past the due and beyond. |
09/26/09 and later |
|
Aging Bucket |
Description |
Example Dates |
|
Future |
Future through the day before the due date. |
Anytime through 07/15/09 |
|
Current |
From the due date through 30 days from the due date. |
07/16/09 - 08/14/09 |
|
31 - 60 |
From the next day through 30 days from that date. |
08/15/09 - 09/13/09 |
|
61 - 90 |
From the next day through 30 days from that date. |
09/14/09- 10/13/09 |
|
91 - 120 |
From the next day through 30 days from that date. |
10/14/09 - 11/13/09 |
|
Over 120 |
From the next day and later. |
11/14/09 and later |
See Also: