This free online Checking Account Reconciliation Calculator will help you to reconcile a bank statement (balance check book) by doing the math for you.
Or, if you prefer to reconcile a bank statement manually, the calculator on this page also includes an option for printing out a blank, free bank reconciliation form.
If you're not sure what reconciliation means, or you're not sure how to balance a check book, it may help to read the following explanations and instructions before using the checking account reconciliation calculator.
The term reconciliation basically refers to the process of making two things consistent or compatible. In the case of balancing a check book, this process is used to make the balance in your checkbook register consistent with what the bank considers to be your balance -- something that can't be done simply by comparing one with the other.
Checkbook reconciliation is necessary for three reasons.
If you are not faithfully reconciling your check book with your bank statement, then you run the risk of being assessed stiff overdraft charges. And if not caught in time, these overdraft charges can pile up in a hurry.
The only way to avoid overdraft charges is to faithfully perform a checkbook reconciliation as soon as you receive your bank statement. Personally, since I do all of my personal financial bookkeeping bright and early on Sunday mornings, this means that I always perform a checkbook reconciliation on the first Sunday following the receipt of each bank statement.
If you've never done it before, here are the steps to balance a check book:
With that, let's use the Checking Account Reconciliation Calculator to reconcile a bank statement (balance check book).
Check Out My Other Super
Personal Finance Calculators
To Help You To
Calculate Your ...
Checking account balance from checkbook: Enter the checking account balance after recording all items from the bank statement that were not previously recorded.
Ending balance on bank statement: Enter the ending balance as listed on your bank statement.
Deposits Outstanding: For each deposit that appears in your checkbook but is not listed on your bank statement, enter a reference (number, date, etc.) and an amount, then click the Add Deposit button. This will add the deposit to scrollable list on the next line. Note that you can edit or remove (X button) deposits from within the list.
Total outstanding deposits: This is the calculated total of all deposits not listed on your bank statement. The checking account reconciliation calculator will add this amount to the balance from your bank statement.
Withdrawals Outstanding: For each withdrawal that appears in your checkbook but is not listed on your bank statement, enter a reference (number, date, etc.) and an amount, then click the Add Check button. This will add the withdrawal to the scrollable list on the next line. Note that you can edit or remove (X button) withdrawals from within the list.
Total outstanding withdrawals: This is the calculated total of all withdrawals not listed on your bank statement. The checking account reconciliation calculator will subtract this amount from the balance listed on your bank statement.
Adjusted ending statement balance: This is your adjusted bank statement balance, which is the balance listed on your statement, plus the total of the outstanding deposits, less the total of the outstanding withdrawals.
Amount out of balance: This your checkbook balance minus the adjusted statement balance. If this amount is zero, your checkbook reconciles with your bank statement. If this amount is negative, it means your checkbook balance is less than what the bank shows. If the amount is positive, it means your checkbook balance is greater than what the bank shows. In either of the latter two cases, the next step would be to double check the adding and subtracting in your checkbook register -- back to the last date you created a bank reconciliation statement.
Printable Bank Reconciliation Statement button: Click this button to create a printer friendly page for printing your checking account reconciliation. If you select the Completed option from the drop-down menu the page will display a completed bank reconciliation form. If you select the Blank option from the drop-down menu and click this button the page will display a blank, free bank reconciliation form.