Forum Discussion

MaroniteV's avatar
MaroniteV
Experienced User
2 years ago

Aged receivable report and Sales register dont reconcile

Sales report and GL report dont reconcile. Apparently, the GL report picks up the payment made after the report date too. I need them to reconcile for the audit purpose. Please help.

  • Mike_James's avatar
    Mike_James
    Ultimate Partner

    Hi MaroniteV , the aged receivable reports include the balances of all open invoices regardless of the date you enter, which is purely for aging purposes. 

     

    I recommend using the receivables (and payables) reconciliation reports, where the date is a cut-off date, and the report can therefore be backdated. It should then agree to the debtors account in a balance sheet report as at the same date. If the receivables report shows a difference (out of balance), that should be investigated. 

    • MaroniteV's avatar
      MaroniteV
      Experienced User

      Thank you Mike

      unfortunately it didnt work, 

      please refer to the screenshot attached. 

      please help

      • Mike_James's avatar
        Mike_James
        Ultimate Partner

        Hi MaroniteV , that is a valid report, but it is telling you that the GL account for debtors does not agree with the total of your receivables at the same date. You need to investigate why that is. 

         

        You could start by going back to the date of the last finalised set of accounts, and run the report at that date. Does it balance or not?  If not, don't attach the report here, just quote the 3 figures at the end:

        Total receivables

        Receivables account

        Out of balance amount

         

        When was the file first used?