How to Balance Checkbook Worksheets

By Bonnie Conrad

A worksheet makes balancing your checkbook easier.
i Paying Bills image by ne_fall_photos from <a href=''></a>

Most of us know how important it is to balance our checkbooks, but many of us never get around to performing this vital calculation. The results of not balancing your checkbook can be quite expensive. Overdraft fees and bounced check fees are on the rise, and failing to keep enough money in your bank account could get you in trouble with creditors as well. By using a simple spreadsheet program, you can create a worksheet that you can use to balance your checkbook and reconcile your statement at the end of each month.

Step 1

Gather your latest bank statement and your checkbook. Log on to your computer and open your spreadsheet program. Click on "File" and select "New" to create a new worksheet.

Step 2

Enter the label "Bank Statement Balance" in cell A1 of the spreadsheet. Enter the ending balance from the bank statement in cell B1.

Step 3

Create a line for each check that is not shown on the bank statement. Use the check number as the label and enter these checks in the "A" column. Enter the actual amounts in the "B" column. When entering the amounts, use a minus sign. For instance, a check for $30 would be entered as "-30."

Step 4

Enter any deposits not shown on the bank statement. Deposits should be recorded as positive numbers. Enter the date of the deposit in column "A" and the amount in column "B."

Step 5

Create a formula to add up all of the numbers you entered. This formula will take the ending balance shown on your bank statement, subtract any checks you have written since the closing date and add any deposits from after the closing date. For instance, if your numbers are recorded in cells B1 through B15, the formula will read "=SUM(B1:B15)."

Step 6

Compare the result of your calculation with the balance in your checkbook. If the numbers do not match, look for any unrecorded deposits, debit payments, ATM withdrawals or checks. Many people fail to record all of their debit card purchases and ATM transactions, so that is a good place to start. If you have online access to your account, you can log on and look for recent activity that could explain the discrepancy.