Checking Account Reconciliation Calculator

Reconcile your bank statement with your checkbook register.

Special Instructions

Learn More

Selected Data Record:

A Data Record is a set of calculator entries that are stored in your web browser's Local Storage. If a Data Record is currently selected in the "Data" tab, this line will list the name you gave to that data record. If no data record is selected, or you have no entries stored for this calculator, the line will display "None".

DataData recordData recordSelected data record: None
Ending balances
Chk reg bal:Checkbook balance:Checkbook balance:Checking account balance from checkbook:

Checking account balance from checkbook:

Enter the checking account balance after recording all items from the bank statement that were not previously recorded. Enter the amount without the dollar sign or any commas.

$
Bank stmt bal:Statement balance:Ending bank statement balance:Ending bank statement balance:

Ending balance on bank statement:

Enter the ending balance as listed on your bank statement, but without the dollar sign or any commas.

$
Deposits outstanding

Deposits outstanding:

Depending on the width of the calculator, a different entry form will be displayed. Narrow widths will display a mobile optimized form, whereas wider widths will display a desktop optimized form.

For each deposit that appears in your checkbook but is not listed on your bank statement, enter a reference (numbers only) and an amount (no dollar sign or commas), then click the Add Deposit button (may also appear as "+" or "Add" depending on the width of your device).

This will add the deposit to the drop-down deposit list. Note that you can edit or remove entered deposits by selecting them from the list.

For each deposit that appears in your checkbook but is not listed on your bank statement, click the "Add Deposit Row" button. Then enter a reference (numbers only) and an amount (no dollar sign or commas).
RemoveReference #Deposit Amount
#Ref #Reference #Reference #
#
$Dep $Deposit $Deposit $
$
Total dep:Total deposits:Total outstanding deposits:Total outstanding deposits:

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

Withdrawals outstanding:

Depending on the width of the calculator, a different entry form will be displayed. Narrow widths will display a mobile optimized form, whereas wider widths will display a desktop optimized form.

For each withdrawal that appears in your checkbook but is not listed on your bank statement, enter a reference (numbers only) and an amount (no dollar sign or commas), then click the Add Check button (may also appear as "+" or "Add" depending on the width of your device.

This will add the withdrawal to the drop down check list. Note that you can edit or remove entered checks by selecting them from the check drop-down list.

For each withdrawal that appears in your checkbook but is not listed on your bank statement, click the "Add Deposit Row" button. Then enter a reference (numbers only) and an amount (no dollar sign or commas).
RemoveReference #Withdrawal Amount
#Ref #Reference #Reference #
#
$Chk $Check $Check $
$
Total draws:Total withdrawals:Total outstanding withdrawals:Total outstanding withdrawals:

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.

Reconcile
Adj stmt bal:Adjusted stmt bal:Adjusted ending statement balance:Adjusted ending statement balance:

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.

Out of bal:Out of balance:Amount out of balance:Amount out of balance:

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.

If you would like to save the current entries to the secure online database, tap or click on the Data tab, select "New Data Record", give the data record a name, then tap or click the Save button. To save changes to previously saved entries, simply tap the Save button. Please select and "Clear" any data records you no longer need.

Report type:Report type:Report type:Report type:

Report type:

To create a printer friendly page of your checking account reconciliation, select Completed from the drop-down menu and click the Printable Bank Reconciliation Statement button. To create a printable, free bank reconciliation form, select Blank from the drop-down menu and click the Printable Bank Reconciliation Statement button. To clear the checking account reconciliation calculator of all entries and results, click the Reset button.

Related Calculators

spending trackermonthly budget calculatornon monthly budget calculator

Help and Tools

Learn

What reconciliation is, why it's important, and how to reconcile your accounts.

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).
Back to CalculatorBack to CalculatorBack to Account Reconciliation CalculatorBack up to Checking Account Reconciliation Calculator

Adjust Calculator Width:

Move the slider to left and right to adjust the calculator width. Note that the Help and Tools panel will be hidden when the calculator is too wide to fit both on the screen. Moving the slider to the left will bring the instructions and tools panel back into view.

Also note that some calculators will reformat to accommodate the screen size as you make the calculator wider or narrower. If the calculator is narrow, columns of entry rows will be converted to a vertical entry form, whereas a wider calculator will display columns of entry rows, and the entry fields will be smaller in size ... since they will not need to be "thumb friendly".

Show/Hide Popup Keypads:

Select Show or Hide to show or hide the popup keypad icons located next to numeric entry fields. These are generally only needed for mobile devices that don't have decimal points in their numeric keypads. So if you are on a desktop, you may find the calculator to be more user-friendly and less cluttered without them.

Stick/Unstick Tools:

Select Stick or Unstick to stick or unstick the help and tools panel. Selecting "Stick" will keep the panel in view while scrolling the calculator vertically. If you find that annoying, select "Unstick" to keep the panel in a stationary position.

If the tools panel becomes "Unstuck" on its own, try clicking "Unstick" and then "Stick" to re-stick the panel.