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