Forum Discussion

Experienced User

5 years ago

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
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.

Mike_James
Ultimate Cover User
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
  Experienced 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
    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