Purchase recon out of balance by $125,222!!!!

[DL111]

Greetings

The payable reconciliation is out by $125,222 as at 4/4/2022. I have run the payable reconciliation summary report day by day and sort out where the difference is from and struggling to find it. Future dated invoices are entered but not sure if this would cause a massive difference. Have also run the report project to 31/12/2999 and still showing as the same amount. 

- All bills are entered via the purchase register and are under $5,000 

- At the end of the month - we pay bills via the electronic payment account and upload to our banking portal

- Looks as though it may have been on the 23 Feb (balance was zero on the 22nd). How can we determine what occured on this day. Have reviewed all the purchases entered and they have been allocated to the correct account! 

Any thoughts as to what could have occurred this massive error and how to resolve (have tried reading though the help notes). If it is a journal entry - how can we identify which one and if it was posted to the linked account>  TIA

[LRBooks61]

hi 

Usually the reason this occurs is due to a payment being made which predates the invoice date

That is paid 3/2 but invoice dated 4/2

that is a huge amount - does it relate to a bulk payment ?

In the accounts command centre you will find the Company data Auditor 

In the transaction review section it will scan for prepaid transactions

That may help you find it

Hope that helps

Lisa