Checking Account Reconciliation Calculator
to Help You Balance Your Checkbook

[ Skip to Calculator ] Calcy pointing down

Shows you how to balance your check register with your bank statement and then saves you time by doing all the calculations for you.

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.

Define "Reconciliation"

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.

Why is Checkbook Reconciliation Necessary?

Checkbook reconciliation is necessary for three reasons.

  1. Because there is usually a delay between when the bank closes it's month out and when you get your copy of the closing statement. Any transactions that occur during this delay will be recorded in your checkbook register, but will not appear on your statement.
  2. Because checks (or debits to your account) are not received by the bank on the same day you write them. Any checks written in the past but not cashed will be recorded into your checkbook register, but will not appear on your bank statement.
  3. Because some adjustments to your account occur behind the scenes (electronic fund transfers, or EFTs). Since the bank doesn't call to remind you that these ETFs have occurred, it's easy to forget to record them into your checkbook register.

Why Reconcile Bank Account?

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.

How to Balance Check Book

If you've never done it before, here are the steps to balance a check book:

  1. For each line on your bank statement, check to see if the listed item is recorded in your checkbook register. If an item is found, place a check mark next to the item on the bank statement, and also place a check mark next to the item in your checkbook register. Be sure the amount listed on the statement is identical to the amount recorded in your check book.
  2. For each unchecked item on your bank statement, record the missing item into your checkbook register and recalculate the balance.
  3. On a bank reconciliation form, list all deposits from your checkbook register that do not have a check mark next to them, and then find the total. These are deposits that you have made but that the bank received after it created the statement. These are sometimes referred to as deposits outstanding, or deposits in transit.
  4. On the bank reconciliation form, list all withdrawals (checks) from your checkbook register that do not have a check mark next to them, and then find the total. These are withdrawals that you have made but that the bank received after it created the statement. These are sometimes referred to as withdrawals outstanding, or withdrawals in transit.
  5. Add the total deposits outstanding (#3) to the ending balance on your bank statement, and then subtract the withdrawals outstanding (#4). The result is your adjusted statement balance.
  6. Compare your adjusted check book balance (#2) to the adjusted statement balance (#5). If the two match, your checkbook reconciliation was successful (check book balance is equal to the bank's recorded balance). If the two do not match, then your check book balance is said to be "out of balance." This is usually caused by addition or subtraction errors in your checkbook register, so your mission at this point would be to find and fix the errors until the two adjusted balances reconcile (match each other).

With that, let's use the Checking Account Reconciliation Calculator to reconcile a bank statement (balance check book).

Checking Account Reconciliation Calculator
Calcy sign introducing Checking Account Reconciliation Calculator


Instructions: First go through your bank statement line-by-line and place a check mark next to each item that is already recorded in your check book register -- both on your bank statement and next to the item in your checkbook.

Next, for each bank statement item that does not have a check mark next to it, record that amount into your check book register. The result will be your adjusted checkbook balance that you will enter into the first line of the checking account reconciliation calculator.

Next, in the fields provided below, enter the ending statement balance, all deposits in transit, and all withdrawals in transit, then click the "Reconcile Bank Account" button.

Mouse over the blue question marks for a further explanation of each entry field. More in-depth explanations can be found in the glossary of terms located beneath the Checking Account Reconciliation Calculator.

Balances
Help Checking account balance from checkbook ($):
Help Ending balance on bank statement ($):
Deposits Outstanding
Help # $  
 
Help Total outstanding deposits:
Withdrawals Outstanding
Help # $  
 
Help Total outstanding withdrawals:
Help Adjusted ending statement balance:
Help Amount out of balance:
Help

Checking Account Reconciliation Calculator Glossary of Terms

Calcy magnifying glass

Check Out My Other Super
Personal Finance Calculators
To Help You To
Calculate Your ...
Super Calcy

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.

[ Return to Top of Calculator ] [ Return to Top of Page ] Calcy pointing up



> > Checking Account Reconciliation Calculator



+1 Free-Online-Calculator-Use.com
+1 Page Site
Help


Protected by Copyscape Online Plagiarism Detection

Follow me on any of the social media sites below and be among the first to get a sneak peek at the newest and coolest calculators that are being added or updated each week.

Monthly What's New Email Update!

Who knows if I will show up in your next search. This will insure you'll always know what I've been up to and where you can find me!

Email

Name

Then

Don't worry -- your e-mail address is totally secure.
I promise to use it only to send you Whats New.
Online Pocket Calc
Help