Forum Discussion

Chelbelz's avatar
Chelbelz
Experienced User
4 years ago

Monthly overdue amounts not showing on statement and current shouldn't be the full amount

Can someone please help me set up MYOB properly to show the actually Monthly Overdue Amounts as they should be and not just Current(Not Overdue) taking the full sum? Please refer to my photo - TIA  ...
  • Tracey_H's avatar
    Tracey_H
    4 years ago

    Hi Chelbelz 

     

    Thanks for that information. The difference in your statement ageing is because of the 45 days after EOM terms. A January invoice is due on the 15 March, February on the 15 April and March on the 15 May. 

     

    When you select the monthly ageing periods there are no invoices due in Feb, they are all due March and later so will be reported as Current on a March statement:

     

     

     

     

    But when you change the ageing to daily the January invoice is overdue because it was due on the 15 March and the statement is being run at the 31 March. It's 16 days overdue so falls into the 30 Days Overdue column:

     

     

     

     

    I hope that clarifies it for you. Please let me know if you need further help.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Tracey_H's avatar
Tracey_H
Former Staff

Hi Chelbelz 

 

Thanks for your post. How invoices appear on statements depends on the set up of the customer credit terms in AccountRight. I'll give you a couple of help articles that explain aging in detail:

Monthly aging on invoices

Credit terms

 

If you're still have problems with aging on your statements please let me know how your credit terms are set up and I'll be happy to help.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Chelbelz's avatar
Chelbelz
Experienced User
4 years ago

Thank you for taking the time to assist Tracy.  It has fixed the issue but I really need the "month name" listed rather than 30 days.. 60 days etc as it affecs other reports.  Am I correct in say that I dont have an option?

 


<<Attachments removed by Moderator>>

 

 

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    4 years ago

    Hi Chelbelz 

     

    Go to Setup>>Preferences>>Reports & Forms tab and select Use Monthly Ageing Periods Identify by: Month Names to report by months instead of number of days.

     

     

    Please let me know if you need further help.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

    • Chelbelz's avatar
      Chelbelz
      Experienced User
      4 years ago

      Hi Tracy.

      No its doesn't work because I then lose the overdue monthly figures

      Pic 1.  Choose months and I lose the division of overdue amounts

      Pic 2.  Overdue amounts appears correct but i need the month name because it changes to this format accross other reports

      I.e. Aged receivables - refer to pic 3.

      • Tracey_H's avatar
        Tracey_H
        Former Staff
        4 years ago

        Hi Chelbelz 

         

        What are the credit terms for that customer? And what are the invoice date(s) for the 30 Days overdue amount?

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.