Using an Excel Checkbook

EDUCATOR'S VERSION

This lesson printed from:
http://www.econedlink.org/e1013

Posted December 18, 2011

Standard: 10

Grades: 9-12

Author: Mike Fladlien

Posted: December 18, 2011

DESCRIPTION

Students will use a spreadsheet to enter checkbook transactions and reconcile.

KEY CONCEPTS

Bank Account, Bank Service Charges, Bank Statement, Check, Check Register, Checking Account

STUDENTS WILL

  • Complete an electronic checkbook for four months and reconcile.  
  • Determine outstanding checks and deposits.
  • Find errors and correct in the reconciliation process if data entry errors are made.

INTRODUCTION

Do you want a fast way to teach bank reconciliation that focuses on process?  In this lesson, students will use a check register template to enter fictitious transactions.  They will also be given a bank statement to reconcile their checkbook with the bank.  Your students will enjoy the ease of using technology to make banking easy but gain the concepts of determining the adjusted bank and checkbook balances.  


PROCESS

checkbook1.  Using the checkbook guide, complete January's monthly transactions and reconciliation with them.  They will now have a model to refer to and will be off to a good start.

2.  Make sure that the students see that the bank balance agrees with the checkbook before they are allowed to proceed to February.  Don't forget the service charge.

3.  Assign the remaining months.

4.  For assessment, have students complete April and reconcile.

ASSESSMENT ACTIVITY

1.  Ask the students to complete the transactions for April and reconcile.

CONCLUSION

Students will be able to enter transactions and reconcile after this activity.  Encourage them to use the spreadsheet for their own transactions.  For students who do not have Excel at home, explain that they can use a free spreadsheet on Google Documents and have free storage. 

Economics predicts that when the cost of an activity decreases, people will do more of it.  This checkbook should reduce the amount of tedious work that students have to do to keep accurate checkbook records so they will do more of it!

After completing this lesson students will have a valuable tool to help them make intelligent personal finance decisions.

EXTENSION ACTIVITY

atm1.  The extension activity introduces students to Automatic Payments, ATM transactions, and Debit card transactions.  Explain to the students how to enter these transactions into their spreadsheet.

2.  Assign the transactions for May and June.

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