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 

Dec $.......

Jan $.......

Current $.....

 

  • 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.

  • 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

      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

        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.