Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »


 

 

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0
1
2
3
4
5
Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

 

 

Analysing ageing periods can help you monitor how much money your customers owe you, and identify when money is due to come into your business. You can use this information for a number of purposes:

  • Identify the customers who regularly pay late. You might then send out reminder letters or adjust their credit limits accordingly.
  • See which customers whose payments are most overdue, or which ones owe you the most.
  • Check on your cash flow. If a lot of money is overdue now, you might end up with cash flow problems later. By monitoring the ageing of amounts, you can identify potential cash flow problems and try to fix them.

There are many reports and tools in AccountRight that show your aged invoices, This includes customer statements, sales reports (such as Aged Receivables), the To Do List and Business Insights.

Your ageing method can be set to Daily or Monthly.

To change your ageing method you will need to edit a preference.

  1. Go to the Setup menu and choose Preferences. The Preferences window appears.
  2. Click the Reports & Forms tab. You can now select your ageing method.


Ageing example

Assume that you want to age the following invoices as at 31 July 2015 (or any other date in July):

 

CustomerDateAmountTermsDue
A-Z Stationery1 Jul 15123.4521 days from Inv22 Jul 15
A-Z Stationery14 Jul 15200.5021 days from Inv4 Aug 15
Chelsea Mosset2 Jul 15400.24C.O.D.2 Jul 15
Footloose Dance Studio30 Apr 1525.0030 days from Inv30 May 15
Footloose Dance Studio12 May 15112.3030 days from Inv11 Jun 15
Footloose Dance Studio29 Jun 15149.3030 days from Inv29 Jul 15
Footloose Dance Studio30 Jun 1520.3530 days from Inv30 Jul 15
Footloose Dance Studio6 Jul 1590.7030 days from Inv5 Aug 15
Footloose Dance Studio21 Jul 1585.1230 days from Inv

20 Aug 15

My Town Realty26 May 15210.457 days from EOM7 Jun 15
My Town Realty10 Jun 12142.407 days from EOM7 Jul 15

The examples below show the two ageing methods you can use when reporting aged receivables:

  • Number of days since invoice date
  • Days overdue using invoice terms.

 

Ageing by invoice date using month names

Assume you age invoices monthly andidentifyyour ageing periods by month names.

If you age these invoices by invoice date, the invoices will be aged as follows:

 TotalJulyJuneMayPre-May
A-Z Stationery323.95323.950.000.000.00
Chelsea Mosset400.24400.240.000.000.00
Footloose Dance Studio482.77175.82169.65112.3025.00
My Town Realty352.850.00142.40210.450.00
Totals1,559.81900.01312.05322.7525.00
Ageing Percent0.0057.7%20.0%20.7%1.6%

In this example, each ageing period represents the months when the invoices were generated.

Ageing by invoice date using month numbers

Assume you identify your ageing periods by month numbers.

The results above would be the same as per month names, but with different headings, as follows:

 Total1 Month2 Months3 Months3+ Months
A-Z Stationery323.95323.950.000.000.00
Chelsea Mosset400.24400.240.000.000.00
Footloose Dance Studio482.77175.82169.65112.3025.00
My Town Realty352.850.00142.40210.450.00
Totals1,559.81900.01312.05322.7525.00
Ageing Percent0.0057.7%20.0%20.7%1.6%

In this example, each ageing period represents the number of months since the invoice date.

Ageing by invoice terms using month names

If you were to age the transactions based on their invoice terms, the results would look like this: 

 TotalCurrentJulyJunePre-June
A-Z Stationery323.95 200.50 123.450.000.00
Chelsea Mosset400.24 0.00 400.240.000.00
Footloose Dance Studio482.77175.82169.65112.3025.00
My Town Realty352.850.00142.40210.450.00
Totals1,559.81376.32835.74322.7525.00
Ageing Percent0.0024.1%53.6%

20.7%

1.6%

In this example, each ageing period represents the month in which the invoice falls due.

Ageing by invoice terms using month number

If you were to age the transactions based on their invoice terms and using month numbers, the results would look like this:

 TotalCurrent1 Month2 Months2+ Months
A-Z Stationery323.95 200.50 123.450.000.00
Chelsea Mosset400.24 0.00 400.240.000.00
Footloose Dance Studio482.77175.82169.65112.3025.00
My Town Realty352.850.00142.40210.450.00
Totals1,559.81376.32835.74322.7525.00
Ageing Percent0.0024.1%53.6%

20.7%

1.6%

In this example, each ageing period represents the number of months by which the invoices assigned to the period are overdue.

        

 

      
From the community

Could not retrieve http://community.myob.com/myob/rss/search?q=monthly+ageing&filter=labels%2Clocation%2CsolvedThreads&location=category%3AAccountRight&search_type=thread&solved=true - Page not found.