Receivables out of balance, but no transactions in the ledger on the day it goes out of balance...

Hi Kat_Beeton 

Generally speaking an out of balance in the receivables reconciliation report would be caused by one of the types of transactions mentioned on our help article Receivables, payables or inventory out of balance.

If there weren’t any transactions on the date that the out of balance occurred, I’d be inclined to check to see if the control account had been changed, which could cause the out of balance.

If you thought changing the date on the sale had impacted the report, I’d recommend clearing the AccountRight cache. This will cause AccountRight to refresh certain information in the background and can sometimes get around unusual behaviour

Hi Neil_M 

Thanks for your reply.

I tried clearing the cache, but it didn't fix this error. Does it matter that this file is in the cloud and i access it from 2 different computers? I tried clearing the cache on both computers.

I'm pretty sure it's a 'glitch'. the balance sheet figure for debtors as at the day it goes out of balance is different from the debtors balance when i run a general ledger detail for that same date. any other ideas on how to clear it?

Hi Kat_Beeton 

If the figure itself was different, I would be inclined to ensure that both reports are being run to include all transactions and are not excluding any transactions marked as end of year adjustments. Both the reports and Find Transactions window allow you to select whether all transactions are displayed, only year end adjustments or year end adjustments are excluded from the report

Hi Neil_M ,

thanks again for your response. i just checked. both reports include all transactions. Any other ideas?

Hi Kat_Beeton 

You mentioned you changed the date on a couple of sales which you believe caused this issue. Although changing the date on a transaction shouldn’t cause an out of balance to be created, I’m curious if deleting and reentering one of those sales reduces the out of balance as of that date