Forum Discussion

robert5's avatar
3 years ago

Negative figure in Debtors Reconciliation

My Client maintains their records. On doing the year end accounting I note there is a negative figure in the debtors reconcilation report in 1-30 days. This coincidentally matched two paid invoices yet the payment is not recorded twice.

 

So I am unsure how to fix this problem

2 Replies

Replies have been turned off for this discussion
  • SamaraM's avatar
    SamaraM
    Former Staff
    3 years ago

    Hi robert5 

     

    When the reports are not matching the reconciliation I recommend Clearing the Browser Cache, which can resolve some odd behavior in reports. 

     

    If that does not resolve your issue, could you send me the last 4 digits of your Serial Number and a screenshot of the report and the reconciliation window so assist you further?


    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

  • AlanT's avatar
    AlanT
    Ultimate Partner
    3 years ago

    Hi robert5 ,

     

    I have come across this often with one of my clients who receive the money into their bank account and *then* raise the invoice.  But they raise the invoice with a date *after* the date that the funds arrived in their bank account.

     

    This has the effect of throwing the customers account into credit between the two dates.

     

    To fix this, I go into the invoices and change the dates back to the date that the funds were received in their bank account.

     

    Hope that helps,

     

    AlanT