Forum Discussion

AnnaF's avatar
AnnaF
Experienced Cover User
5 years ago
Solved

End of year Debtors

Hi there

 

Is there a way to see what was still owed from customers at the end of a financial year? Some of the invoices were paid after the financial year had ended so they are now closed and I am not sure how to stop it from showing these payments that were paid after 31 March.

 

Thanks

Anna

  • Mike_James's avatar
    Mike_James
    5 years ago

    Hi AnnaF , use the Receivables Reconciliation report, which treats the date as a cut-off and will exclude subsequent payments and invoices. It will also show you whether the debtors list agrees to the receivables GL account. 

3 Replies

Sort By
Replies have been turned off for this discussion
  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    5 years ago

    Hi AnnaF , use the Receivables Reconciliation report, which treats the date as a cut-off and will exclude subsequent payments and invoices. It will also show you whether the debtors list agrees to the receivables GL account. 

    • AnnaF's avatar
      AnnaF
      Experienced Cover User
      5 years ago

      Thanks Mike_James. If it says the Receivables Account is out of balance compared to the Grand Total, do you know how I would find out what is throwing it out?

       

      Many thanks.

      Anna

      • Neil_M's avatar
        Neil_M
        Former Staff
        5 years ago

        Hi AnnaF 

         

        If there was an out of balance in the Receivables Reconciliation report, this generally indicates that either a payment has been dated before the invoice or that a transaction has been incorrectly allocated to the control account.

         

        You can track this down by running the reconciliation report for a month at a time to see whether the report is in balance or not. If the report isn’t in balance / has an out of balance, keep run the report for the previous month until you find the point where the report is in balance.

         

        The month following that is when the out of balance first occurred, which should help you identify the transaction that has put the report out of balance