Aged Debtors to Ledger
Agree the aged debtors listing to the receivables balance, in total and invoice by invoice.
- Ledger + aged debtors listing
How the result is read
Confirmations, subsequent receipts and the allowance are all drawn from the listing, so it is agreed before it is used: in total to the trade receivables balance, then invoice by invoice against what the ledger shows still due. An invoice due and missing from the listing escapes every later test; one listed after the ledger receipted it overstates the balance. Brought-forward balances are agreed through the total; the invoice test runs on this year’s invoices, which the ledger follows from invoice to receipt by reference.
In the application
Aged Debtors to Ledger is filed under Revenue & receivables, index letter C. "Run all analyses" runs it with every other analysis the ledger and the documents loaded can answer. The worksheet states the population it tested on its face — or "Not applicable" with the reason when a column it depends on is empty — and the Excel workbook the engagement exports files it under C, beside an index of the source files with their SHA-256 fingerprints.
Read it with
Run your next audit file test without the Excel crash.
One free engagement to evaluate, valid 60 days. The ledger never leaves the machine.
- 20 minutes
- Runs on a fictional engagement
- No client data required