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
4 years ago

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.