Forum Discussion

DL111's avatar
DL111
Experienced User
3 years ago

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

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

 

 

1 Reply

Replies have been turned off for this discussion
  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User

    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