WIXLIB

Title of Lesson: Twilight – Reconciling Edward Cullen’s Bank StatementGrade Level(s): 9th – 12th GradesMaterials Needed: Lesson Plan information sheet, worksheet, and quiz, pencils, & calculatorsLesson Overview: In this lesson students will become familiar with the information listed onbank statements and will compare the information listed on a check register in order toreconcile the bank account. Students will use business math concepts to figure the totalnumber of deposits on a bank statement, the total ATM withdrawals, and master the equationto adjust the bank statement balance as well as the adjusted checkbook balance.Learning Objectives: In this lesson the objective is to teach the concept ofreconciling bank statements. Students will need to master this skill to use in theirown personal business as well as using this skill as a record keeper or bookkeeperin the business office. Students will also practice the skill of team work. Workingwith a partner helps develop the student’s ability to work as a member of a team.Regardless of the area of business, students will need to work as a team in thebusiness world.Procedures: Students will be provided with information sheets and assignments to workthrough the steps for completing sample problems. They will split into groups of threestudents to work as a team to solve the problems. The instructor will allow each team achance to present their answers to the problems. Students will have the chance to discusstheir checkbook problems and procedures for improving their method of banking recordkeeping.

TwilightRECONCILING BANK STATEMENTSLESSON PLANINFORMATION SHEETEdward Cullen from the movie Twilight has a bank account and money to manage. You willlearn to check his monthly account statement and help him make sure his bank balance is correct. Thiswill help him to make sure that he has enough money for his date with Bella this weekend. This willhelp you in your own life with your own banking responsibilities.A bank statement is a detailed record of the checking account from the bank. The bank statementbalance is the amount of money left in the account per bank’s records. The checkbook balance is theamount of money left in the account per depositor’s records. All banks use computers to prepare bankstatements. Data about all checks paid and all deposits received are entered into the computer in order tokeep the depositor’s account up-to-date. All of the data that is stored in the computer is printed out onthe bank statement.

The bank statement shows the depositor’s beginning balance, individual and total deposits,individual and total checks, and the ending balance. The ending balance, called the bank statementbalance, is the amount of money left in the checking account according to the bank’s records.The depositor also has a record of deposits, checks, and balances. This record is kept either oncheck stubs or in a check register. The ending balance, called checkbook balance, is the amount ofmoney left in the checking account according to the depositor’s records. The check register comes withyour order of checks. The bank customer receives a check register when he/she opens a checkingaccount at the bank.There will usually be differences between the checkbook balance and the bank statementbalance. In this lesson, students will begin to learn how to explain these differences by preparing a bankreconciliation statement. This statement is used to bring the checkbook and the bank statement balancesinto agreement.The following document is a sample of a bank statement. Notice the dates the bank statementcovers, the name of the bank, as well as the name of the customer. Listed is the number of deposits,withdrawals, service charges, and new balance. The checks that have cleared the bank are listed as wellas the ATM withdrawals. The deposits and other credits are also listed.

PracticeTHE TWILIGHTNATIONAL BANKOF FORKSCheckingAccount0471-505Check andOther DebitsDeposits andOther CreditsStatement forEdward Cullen2 See LaneForks, WashingtonThis Statement Covers12/20/08 thru 1/18/09Previous Statement of BalanceTotal of 3 deposits forTotal of 10 withdrawals forTotal Service ChargesNew BalanceCheck161162163Date Paid12/241/0412/26Amount15.0017.00217.54 612.041,980.68 1,705.25 4.50 882.97 Check164*166167Date Paid12/1712/311/03Amount1232.2754.4753.97Monthly Maintenance Charge1/184.50Withdrawal #00281 at ATM #423CWithdrawal #02628 at ATM #423AWithdrawal #08744 at ATM #430EWithdrawal #02456 Check Card12/2412/311/151/1640.0020.0020.0035.00Date er from 4039-557 at ATM #423CCustomer Deposit at ATM#423A on 1/12Direct Deposit from #05323 on 1/17423A: 2500 Main, Forks, WashingtonATMLOCATIONS 423C: 2500 Main, Forks, Washington430E: 945 Jones, Forks, WashingtonUSEDThank you for Banking with

WorksheetUse the bank statement from the Twilight National Bank of Forks to answerthe questions about Edward Cullen’s checking account:1. What period does the statement cover?2. What is Edward’s account number?3. How many deposits were made in Edward’s account? What were theamounts?4. How many checks cleared and what was the total amount of the clearedchecks?5. Was there any ATM activity? If so, how many transactions were there andwhat was the total amount?6. Was there any check card activity? If so, how many transactions were thereand what was the total amount?7. Were there and service charges on Edwards’s account? If so, what was thetotal amount?8. What was the total of all withdrawals? (Checks, ATM transactions, check cardtransactions and service charges)9. Did check number 162 and 165 clear the account?

WORKSHEET ANSWER KEYUse the bank statement from the Twilight National Bank of Forks to answerthe questions about Edward Cullen’s checking account:1. What period does the statement cover?12/20/08 thru 1/18/092. What is Edward’s account number?0471-5053. How many deposits were made in Edward’s account? What was the totalamount?Three, 1,980.684. How many checks cleared and what was the total amount of the clearedchecks?6 for 1,590.255. Was there any ATM activity? If so, how many transactions were there andwhat was the total amount?3 for 80.006. Was there any check card activity? If so, how many transactions were thereand what was the total amount?1 for 35.007. Were there and service charges on Edwards’s account? If so, what was thetotal amount?Yes for 4.508. What was the total of all withdrawals? (Checks, ATM transactions, check cardtransactions and service charges) 1,709.759. Did check number 162 and 165 clear the account?YES and NO

Use this statement from the Twilight National Bank of Forks, the check register,and the reconciliation worksheet to help Edward balance his account.Statement forTHE TWILIGHTNATIONAL BANKEdward Cullen2 See LaneForks, WashingtonThis Statement Covers06/20/09 thru 7/19/09OF FORKSCheckingAccount0471-505Check andOther DebitsPrevious Statement of BalanceTotal of 1 deposits forTotal of 6 withdrawals forTotal Service ChargesNew BalanceCheckDate PaidAmount 150.671,200.00 1,246.98 0103.69 Check161162163Date 186/2635.0020.0055.0054.11Date Posted6/23Amount 1,200.00Withdrawal #00286 at ATM #423AWithdrawal #02699at ATM BWithdrawal #02566 Check CardWithdrawal #06959 Check CardDeposits andOther CreditsTransfer from 9963-557 at ATM #423CATMLOCATIONS423A: 2500 Main, Forks, Washington423B: 2500 Main, Forks, WashingtonThank you for Banking with TTHHEETTWWIILLIIGGHHTT NNAATTIIOONNAALL BBAANNKK OOFF FFOORRKKSS

366.97NumDateTransaction Description1616/4Best BuyATM6/18Ck cardPaymentDepositBalance216 30150 67Withdrawal35 00115 676/18Food Land55 0060 67ATM6/23Deposit1626/24American Eagle82 871177 80ATM6/25Withdrawal20 001157 801636/26Apartment1000 00157 80Ck card6/26Wal-Mart54 11103 691647/5Blockbuster26 3177 381657/14Hot Topic10 0067 38ATM7/19Deposit1200 00253 171260 67320 55

NAMEItems OutstandingNumberAmountEnterThe New Balance shownon your statement.AddAny deposits or transfers listedin your register that are notshown on your statement.TOTALTOTALCalculate the subtotalSubtractYour total outstandingchecks and withdrawals.Use the reconciliation worksheet to answerthe following questions:Calculate your ending balance.This amount should be thesame as the current balancein the check register. - 1. What is the new balance shown on the statement?2. What is the total amount of deposits listed on the register but not shown on the statement?3. What is the sum of the new balance and deposits not shown on the statement?4. What is the total of outstanding checks and withdrawals?5.What is the ending balance?

Answer KeyItems OutstandingNumberAmount16426311651000EnterThe New Balance shownOn your statementAddAny deposits or transfers listedIn your register that are notShown on your statementTOTALCalculate the subtotalSubtractYour total outstandingChecks and withdrawalsTOTAL3631Calculate your ending balanceThis amount should be thesame as the current balanceIn the check register. 103.69 253.17 253.17 356.86- 36.31 320.55Use the reconciliation worksheet to answer the following questions:1. What is the new balance shown on the statement? 103.692. What is the total amount of deposits listed on the register but not shown on the statement? 253.173. What is the sum of the new balance and deposits not shown on the statement? 356.864. What is the total of outstanding checks and withdrawals? 36.315. What is the ending balance? 320.55

Method of Evaluation (if applicable, please include the answer key on a separate sheetof paper): Teacher observation and student completed worksheets. The teacher will checkthe worksheets for each team for accuracy and answer questions as they fill them out. Shecan number the teams or have the students put their names on their sheets. The studentswill take the quiz after the students have completed the worksheet to see if they fullyunderstand the concepts. There is also an Alternate Exam for students who don’t score apassing grade.Give the students the following quiz.

NAMEBank Reconciliation QuizYou are helping Edward Cullen take care of his account. Part of your job is to prepare hischeckbook and prepare a reconciliationstatement. Avoid making mistakes and Entercheck your work twice, because youThe New Balance shown on yourknow what can happen when Edwardstatement.gets upset! AddOn July 31, his balance isAny deposits or transfers listed in your 2,699.04 and the bank shows aregister that are not shown on your balance of 2,780.75.statement. After comparing records you find andTOTAL outstanding deposit of 611.96.Calculate the subtotal. The following checks areoutstanding:SubtractYour total outstanding checks and791104.17withdrawals.- 792426.08Prepare bank reconciliation asCalculate your ending balance.of July 31.This amount should be the same as thecurrent balance in the check register. Items OutstandingNumberAmountTOTAL

ANSWER KEYItems nterThe New Balance shownon your statement.AddAny deposits or transfers listedin your register that are notshown on your statement.TOTAL 611.96 Calculate the subtotal. 3,311.00SubtractYour total outstandingchecks and withdrawals.- 530.25Calculate your ending balance.This amount should be thesame as the current balancein the check register. 2,780.75 2,699.04