Forum Discussion

AT3228's avatar
AT3228
Member
1 day 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.

 

 

1 Reply

  • 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