Payables Reconciliation (summary)

[Advocacy]

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.

M

[gavin12345]

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]

Thanks Gavin

I will have a go at that, and hopefully find it. 

M

[The_Doc]

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

[LRBooks61 · Accepted solution]

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]

Thank you , all fixed

[Advocacy]

All fixed , thank you