Aged Creditors to Ledger
Agree the aged creditors listing to the payables balance, in total and invoice by invoice.
- Ledger + aged creditors listing
How the result is read
The listing is the population every payables test samples from, so it is agreed before it is used: in total to the trade payables balance, then invoice by invoice against what the ledger shows open. Both directions matter — an invoice open in the ledger and missing from the listing is a completeness gap, one listed after the ledger settled it is an overstatement. Brought-forward balances are agreed through the total; the invoice test runs on this year’s invoices, which the ledger follows from invoice to payment by reference.
In the application
Aged Creditors to Ledger is filed under Purchases & payables, index letter D. "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 D, 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