Supplier statement reconciliation
Agree the payables ledger to the supplier statement, and see what is left unexplained before paying.
Result
- Total difference
- 14500.00
- Explained
- 14500.00
- Unexplained
- 0.00
The method
- Difference = supplier statement balance less payables ledger balance, less whatever is explained by invoices in transit or payments not yet received.
- What remains is investigated before payment, not after: paying on an unexplained difference is how an invoice gets paid twice.
Built forAn accountant reviewing an entry or balance before close
When you need it
You have connected figures that need testing before they enter the close file. Agree the payables ledger to the supplier statement, and see what is left unexplained before paying.
The decision it supports
Use the result to decide whether the work can be accepted or a difference or classification needs tracing. The tool shows its method beside the result so you can review it.
What you receive
Supplier statement reconciliation result
A shareable interactive result with findings, calculation method and an Excel workpaper carrying the same figures.
An example you can inspect
A ready-to-run example
The tool opens with: Payables ledger balance = 318400.00, Supplier statement balance = 332900.00, Explained items = 14500.00. Change any value to see its effect immediately.
Continue the workflow
- Learn the treatment behind the toolAvailable now
- Open the Accounts Payable Accountant trackAvailable now