Forum Discussion

AT3228's avatar
AT3228
Member
14 days ago

Receivables Reconciliation Exception Report Out of Balance

Hi All

 

Has anyone had an issues with this report being out of balance.

FYI - nothing has been posted direct to Trade Debtors via any manual journals, Payment for Invoices have been recorded correctly via receive payents and allocated to orders / invoice.

The current linked recievables account balance is correct ie: its my current aged receivalbes amount, so i am totally stumped.

 

I see that timing errors could be a cause ie: i have received payments and applied to order then have invoiced at a later date ( i track inventory therefore cant sell stock i dont have in possesion etc...)

 

Some discussion around putting a forward date 31/12/9998 shows the same result as well.

 

There is nothing i can click on to see the transactions causing this problem too. I get the same result if i run the company audit data file.

 

My payables reconcile and are not out of balance.

 

 

4 Replies

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    13 days ago

    Hi AT3228,

     

    Thanks for sending through the screenshot. You’ve definitely made a good start, covering through a fair few of the usual checks. 

     

    When the Receivables Reconciliation Exception report is out of balance, it usually means the total of the customer outstanding invoices doesn’t line up with the Trade Debtors linked account balance. That can often be caused by things like timing differences, journal entries posted straight to Trade Debtors, altered linked accounts, or opening balance issues.

     

    It’d be worth giving this help article and forum post one more time, to make sure all the usual checks and report filters have been missed. If it’s still not balancing after that, the best next step would be to get our team to take a closer look. You can reach them by phone, or through live chat via our virtual assistant MOCA.

     

    Cheers,

    Princess

  • AT3228's avatar
    AT3228
    Member
    12 days ago

    Appreciate your reply Princess

     

    My current customer outstanding invoices are exactly what my TD shows..so its not that. 

    My recievables and trade debotors on any detailed report i run are correct and always equal.

     

    its only when i run the company data audotor it shows this as out of balance.

     

    There are no dorect postings via GL to my trade debtors either.

     

    Whats the best way to get your team to have a look at this

     

     

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    12 days ago

    Hi AT3228

     

    Thanks for confirming that. If your receivables reports and Trade Debtors are all matching, and it’s only the Company Data Auditor showing the out of balance, it sounds more like an odd issue rather than the actual balances being wrong. 

     

    Best next best step would be to reach out to support team so they can have a deeper look on what's causing the out-of-balance issue. You can reach out by creating a ticket in My Account or connecting with our live chat team through MOCA, our virtual assistant. 

     

    Cheers,

    Genreve

  • Thanks Genreve,

     

    I'm currently on hold 1hr 54 mins.