Forum Discussion

Experienced Cover User

3 years ago

Payables Reconciliation (summary)

Hi All

I have an amount of $462 on my payable recon out of balance, I have followed it back to 17/1/22, however there was no transaction on that day for that amount, nor is there a combination of transactions to equal it.

Any idea where to go from here, really want the out of balance to be $0.00.

Thanks in advance.

LRBooks61
3 years ago
Hi M

This error usually occurs when the payment date is prior to the invoice date.

If you have identified when it happened you should be able to identify the transactions involved.
Running the Company Data Auditor may also help locate them
(Accounts screen- righthand side second row)

Hope that helps

Lisa

LRBooks61
Ultimate Cover User
3 years ago
Hi M

This error usually occurs when the payment date is prior to the invoice date.

If you have identified when it happened you should be able to identify the transactions involved.
Running the Company Data Auditor may also help locate them
(Accounts screen- righthand side second row)

Hope that helps

Lisa
- Advocacy
  Experienced Cover User
  3 years ago
  Thank you , all fixed
gavin12345
Ultimate User
3 years ago
Hi Advocacy

Use Find Transactions to view the transactions for this account over a nominated period. There should only be Bills, Pay Bills and Debit Notes. Look of any other transaction types such as Journals or Spend Money etc.

Regards
Gavin
- Advocacy
  Experienced Cover User
  3 years ago
  Thanks Gavin
  I will have a go at that, and hopefully find it.
  M
  - The_Doc
    Ultimate Cover User
    3 years ago
    Hi Advocacy
    
    I use a combination of what Gavin suggests and the other process is reducing the date you are reconciling to until the error disappears - often in month lots until it disappears then moving forward 1 day at a time until you have the day.
    
    Then its just looking into the ledger at that tdate to find the problem - but sometimes the out of balance is made up of a combination of problems - often just paying a bill before a bill is dated - so go back to the beginning eg. EOFY is where you start and step forward.
    
    However, always do a big date check by putting some date forward by 20 years (just to make sure you haven't entered a payment or bill wildly wrong) - that is the big date check!!!
    
    The Doc