Forum Discussion

Advocacy's avatar
Advocacy
Experienced Cover User
3 years ago
Solved

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 o...
  • LRBooks61's avatar
    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

Advocacy's avatar
Advocacy
Experienced Cover User

Thanks Gavin

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

M

The_Doc's avatar
The_Doc
Ultimate Partner
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

  • Advocacy's avatar
    Advocacy
    Experienced Cover User
    3 years ago

    All fixed , thank you