Using an Excel Checkbook


This lesson printed from:


Using a computer has greatly reduced the amount of recordkeeping work.  In this lesson, you will learn how to use an Excel Spreadsheet to enter data into a checkbook register and reconcile your checkbook.  You will find that there is no more tedious addition and subtraction on a calculator, but simple data entry.


You will enter the transactions for January, February, and March into an Excel spreadsheet.  You will reconcile the bank balance with your spreadsheet.


1.  Listen as your teacher explains how to enter data from your checkbook guide into the spreadsheet using the monthly transactions and how to reconcile.checkbook

2.  You will now open the Checkbook spreadsheet or enter the formulas and cell headings manually.

3.  Enter the transactions for January.  Using January's bank statement, reconcile your checkbook for January.  If your teacher requires it, complete the bank reconciliation form manually at the bottom of the bank statement.

4.  Complete the transactions for February and March, then reconcile. 

5.  Print off your spreadsheet and give it to your teacher.


Keeping a checkbook is easy when a spreadsheet is used.  You have found how easy it is to let technology take the repetitive math out of keeping a checkbook so that you have more time to enjoy other activities.

Using a computer to keep track of your checkbook offers the advantage of compact and portable storage.  For example, you can keep a record of your transactions on Google Documents for easy reference anywhere there is an Internet connection.

You now have one of the most powerful personal finance tools to help you make wise and informed choices.


1.  Complete the month of April and reconcile.


atm1. Your teacher will introduce you to Automatic Payments, ATM transactions, and Debit card transactions, and will explain how to enter these transactions into your spreadsheet.

2.  Complete the months of May and June, then reconcile.

3.  Check to see if the checkbook agrees with the bank statement.