Forum Discussion

Advocacy's avatar
Advocacy
Experienced Cover User
2 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 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

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

6 Replies

Sort By
Replies have been turned off for this discussion
  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    2 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

  • gavin12345's avatar
    gavin12345
    Ultimate User
    2 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's avatar
      Advocacy
      Experienced Cover User
      2 years ago

      Thanks Gavin

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

      M

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