Payables Reconciliation with tax report out of balance

Hi Folks

 

Need some quick help here - a longterm client threw this problem at me last night and whilst I am halfway there to solving it - I just need someone to say - oh - do this.

This client never gives me simple problems - and this one sources back to 2017 - they reconcile their creditors and debtors - however the creditors reconcile to zero the creditors with tax report shows an out of balance of -21K - and likely has been there for a longtime but suddenly the accountant doing their returns says - sorry fix.

 

The client is a big builder and has been with me for 20 years - and I have full access - so last night went Sherlock Holmesing - and found the cause of the grief - in 2017 the client appear to apply credit from creditors refunds directly into the creditor journal with a negative service purchase - the trail and originals are purged making it harder to define. (I might have an old backup I think on our server in Classic MYOB that I can resurrect.

 

However, I reversed all of these -ve purchases ( dated 30/6/25)  and erased all but -$39 of out of balance in the reconciliation and tax report - great except now the 'reconciliation payables' report is out of balance this much - so to save my tired brain - anyone got a quick - fix to solve this problem directly.

 

The Doc