It would be really helpful when running the aged debtors and creditors reports to be able to specify an “as at” date and for payments on account to show if there aren’t any other entries on the supplier/customer record.
Is it possible to amend the report to be able to show this? Otherwise I have to run the Debtor/Creditor report and manipulate in excel to get the data our auditors require for the financial year end.
Maybe you’re looking for more of the Debtors / Creditors report, which allows you to specify a particular date range and show what’s outstanding as of that date (and the status now).
This can be found by going to Reports >> All Reports >> Debtors / Creditors Report.