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.
Forum Discussion
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.
Thank you Mike
unfortunately it didnt work,
please refer to the screenshot attached.
please help
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?
Thank you Mike,
It never reconciled. It works well will aged payable though.
I wamted this be fixed so that i dont have to explain this over and over to the auditors.
Please help.
