Bank Statement Reconciliation Calculator

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

You can use this calculator to reconcile client bank statements. In addition to the reconciliation, you can create reports for deposits in transit, outstanding checks, and debit charges.

Example

A small business owner is having trouble reconciling a statement and may have overlooked some financial transactions. What is the difference between the books and the financial statements from the bank?

Field Input
Add deposits in transit: date of 7/23/2016 $1200.00
Add deposits in transit: date of 7/25/2016 $22.50
Subtract outstanding checks/debit charges: Check 500 $350.00
Subtract outstanding checks/debit charges: Check 501 $250.00
Subtract outstanding checks/debit charges: date of 7/30/2016 $42.50
Bank balance per books $3200.00
Interest Income $11.50
Other: Cash Deposits $1200.00
Bank service charges $32.50
Other: Payables $500.00

In this example, the Reconciling difference/adjustment is $-99.00.

Share This