Bank reconciliation
Agree the book balance to the bank statement, and see how much is left unexplained.
Result
- Total difference
- 12750.00
- Explained
- 12750.00
- Unexplained
- 0.00
The method
- Difference = bank balance − book balance, less whatever is explained by outstanding cheques or deposits in transit.
- What remains after explanation is what must be investigated; a reconciliation does not close on an unexplained amount.
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 book balance to the bank statement, and see how much is left unexplained.
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
Bank 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: Book balance = 482350.00, Bank statement balance = 495100.00, Explained items = 12750.00. Change any value to see its effect immediately.
Continue the workflow
- Learn the treatment behind the toolAccount required
- Open the Financial Accountant trackAvailable now