When MYOB AccountEdge performs aging on a monthly basis, it determines the month in which an invoice or purchase was recorded, and adds its value to that month’s column. For example, assume you have the following invoices:
Customer |
Date |
Amount |
Terms |
Due |
A-Z Stationery |
Jul 1, 01 |
$123.45 |
21 days from Inv |
Jul 22, 01 |
A-Z Stationery |
Jul 14, 01 |
200.50 |
21 days from Inv |
Aug 4, 01 |
Chelsea Mosset |
Jul 2, 01 |
400.24 |
C.O.D. |
Jul 2, 01 |
Footloose Dance Studio |
Apr 30, 01 |
25.00 |
30 days from Inv |
May 30, 01 |
Footloose Dance Studio |
May 12, 01 |
112.30 |
30 days from Inv |
Jun 11, 01 |
Footloose Dance Studio |
Jun 29, 01 |
149.30 |
30 days from Inv |
J ul 29, 01 |
Footloose Dance Studio |
Jun 30, 01 |
20.35 |
30 days from Inv |
Jul 30, 01 |
Footloose Dance Studio |
Jul 6, 01 |
90.70 |
30 days from Inv |
Aug 5, 01 |
Footloose Dance Studio |
Jul 21, 01 |
85.12 |
30 days from Inv |
Aug 20, 01 |
My Town Realty |
May 26, 01 |
210.45 |
7 days from EOM |
Jun 7, 01 |
My Town Realty |
Jun 10, 01 |
142.40 |
7 days from EOM |
Jul 7, 01 |
Assume you chose to age on a monthly basis and selected to identify your aging periods by month names. If you age these invoices by invoice date using any date in July 2001, the invoices will be aged in the following fashion.
|
Total |
July |
June |
May |
Pre-May |
A-Z Stationery |
323.95 |
323.95 |
0.00 |
0.00 |
0.00 |
Chelsea Mosset |
400.24 |
400.24 |
0.00 |
0.00 |
0.00 |
Footloose Dance Studio |
482.77 |
175.82 |
169.65 |
112.30 |
25.00 |
My Town Realty |
352.85 |
0.00 |
142.40 |
210.45 |
0.00 |
Totals |
1,559.81 |
900.01 |
312.05 |
322.75 |
25.00 |
Aging Percent |
0.00 |
57.7% |
20.0% |
20.7% |
1.6% |
In the example above, each aging period represents the month in which the invoice came due.
Now assume you chose to identify your aging periods by month numbers. The results above would be the same, but with different headings, as follows:
Total |
1 Month |
2 Month |
3 Months |
3+ Months | |
A-Z Stationery |
323.95 |
323.95 |
0.00 |
0.00 |
0.00 |
Chelsea Mosset |
400.24 |
400.24 |
0.00 |
0.00 |
0.00 |
Footloose Dance Studio |
482.77 |
175.82 |
169.65 |
112.30 |
25.00 |
My Town Realty |
352.85 |
0.00 |
142.40 |
210.45 |
0.00 |
Totals |
1,559.81 |
900.01 |
312.05 |
322.75 |
25.00 |
Aging Percent |
0.00 |
57.7% |
20.0% |
20.7% |
1.6% |
In this example, each aging period represents the number of months by which the invoices assigned to the period are overdue.
If you were to age the transactions based on their invoice terms, the results would be similar; however, your report or MYOB AccountEdge window would show the month in which the invoice falls due.
Total |
Current |
July |
June |
Pre-June | |
A-Z Stationery |
323.95 |
200.50 |
123.45 |
0.00 |
0.00 |
Chelsea Mosset |
400.24 |
0.00 |
400.24 |
0.00 |
0.00 |
Footloose Dance Studio |
482.77 |
175.82 |
169.65 |
112.30 |
25.00 |
My Town Realty |
352.85 |
0.00 |
142.40 |
210.45 |
0.00 |
Totals |
1,559.81 |
376.32 |
835.74 |
322.75 |
25.00 |
Aging Percent |
0.00 |
24.1% |
53.6% |
20.7% |
1.6% |
If you were to age the example transactions based on their invoice terms and using month numbers, the results would look like this:
Total |
Current |
1 Month |
2 Months |
2+ Months | |
A-Z Stationery |
323.95 |
200.50 |
123.45 |
0.00 |
0.00 |
Chelsea Mosset |
400.24 |
0.00 |
400.24 |
0.00 |
0.00 |
Footloose Dance Studio |
482.77 |
175.82 |
169.65 |
112.30 |
25.00 |
My Town Realty |
352.85 |
0.00 |
142.40 |
210.45 |
0.00 |
Totals |
1,559.81 |
376.32 |
835.74 |
322.75 |
25.00 |
Aging Percent |
0.00 |
24.1% |
53.6% |
20.7% |
1.6% |
Examples of Monthly Aging