Forum Discussion
- Mike_JamesUltimate 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.
- MaroniteVExperienced User
- Mike_JamesUltimate 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?