Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me out. I will like or do anything. this is due soon. ch 5 Continuing Case 28. Checking Account Reconciliation Jamie Lee Jackson,

image text in transcribedimage text in transcribedimage text in transcribed

Please help me out. I will like or do anything. this is due soon. ch 5

Continuing Case 28. Checking Account Reconciliation Jamie Lee Jackson, age 26, is in her last semester of college and is ardously waiting for graduation day that is just around the comer! She still works part-time as a bakery clerk, has been sticking to her budget the past two years, and is on track to accumulating enough money for the $10,000 down payment she needs to open her cupcake care within the next two years. Jamie Lee is still single, shares a small apartment with a friend, and continues to split all of the associated living expenses, such as rent and utilities, but unfortunately, through a turn of events, has had to seriously consider a place of her own One evening, after returning to the apartment after a long shift at the bakery, Jamie learned that her roommate had a couple of friends over earlier in the evening. As Jamie went to her room, she noticed that her top desk drawer had been left open and her Debit/ATM card, as well as her checkbook and Social Security card, were missing. She immediately contacted the authorities, and the police instructed her to notify her financial institution immediately. But it was late Saturday night, and Jamie thought she had to now wait until Monday morning. Unfortunately, within no time, Jamie found that her checking account had been emptied! Jamie Lee's luck worsened, as she had paid many of her monthly bills late last week. Her automobile insurance, two utility bills, and a layaway payment had all been paid for by check. Her bank almost immediately began sending Overdraft alerts through her smart phone for the emptied checking account. Determine the balance in Jamie Lee's checkbook register below. Use this total along with the information from Jamie Lee's monthly bank statement to reconcile her checkbook register with her bank statement. Each answer must have a value for the assignment to be complete. Enter "O' for any unused categories. Bank accounts: Checking account before theft) Savings account Emergency fund savings account 401K) balance $2,330 $7,100 $4100 $360 Checked Number Amount Deposit Balance 50 $ 50.00 2,125.53 $ 52.00 Excerpt from Jamie Lee's Check Register bed Check Date Description 792 9-10 Car Care (car insurance) World Card 793 9-10 Express (credit card payment) 794 9-10 Great Foods (groceries) 795 9-14 Target (shirts 9-15 Deposit paycheck) 9-17 Chick Fil A $ 58.60 390 390212 Debit 8.67 7969-19 9-22 Susie Barrett (birthday gift) Deposit Statement date: 2017 Checking Account Reconciliation date September 16, Statement balance: Enter balance from statement) Step 1: Subtract total of outstanding checks (checks that you have written but that have not yet cleared in the banking system) Check Number Amount Check Number Amount Total Step 2: Add deposits in transit (deposits you have made but that have not yet been reported on this statement) Deposit Date Amount Deposit Date Amount Total: Adjusted cash balance: Checkbook balance: (Enter balance from checkbook) Step 3: Subtract fees or other charges listed on your bank statement, along with ATM withdrawals, debit card payments, and other automatic payments that are not yet reported Description Amount Description Amount Chik Fil A Total Step 4: Add any interest earned and direct deposits to your checkbook balance Interest eamed Direct deposits: Adjusted cash balance: Note: At this point, the balances for both the checkbook and bank statement should be the same. Page 1 of BANK STATEMENT: Link Trust Bank P.O. Box 0000000 Any City, US 12345 Page 1 of 1 Acct. ending xxx4560 09/15/2017 Link Trust Bank Jamie Lee Jackson 126 West Street, Apt. 3A Somewhere, US 23456 Account Account Type Summary CHECKING Account Number XXXXXXXXXXX4560 Statement Period 08/16/2017 - 09/15/2017 Description Amount Average Balance $1,378.33 Number of days in Statement Period 31 Description Beginning Balance Deposits/Credits Checks Withdrawals/Debits Ending Balance Amount $1,292.09 $1,950.62 $ 591.12 $ 153.28 $2,498.31 Deposits/ Date Credits 08/18 08/25 09/01 09/08 09/15 Amount 390.12 390.13 390.12 390.13 390.12 Description DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. Checks Check Number Amount Description 786 787 788 789 47.86 33.26 275.00 80.00 45.00 60.00 50.00 Date Paid 08/19 08/17 09/03 09/02 09/05 09/04 09/12 Great Foods Grocery Target Lion's Gate Communities Electric Co-Op City Water Services Cable Connection World Services Car Care Insurance 790 791 792 Debits Debit Debit Debit Debit Debit Debit 13.56 22.94 39.65 23.74 35.00 18.39 08/19 08/25 08/27 08/28 09/08 09/10 Check Card Purchase - Family Value Gas Check Card Purchase - Domino's Pizza #0001 Check Card Purchase - Great Foods Grocery Check Card Purchase - Family Value Gas Check Card Purchase - World of Cakes Check Card Purchase - Family Value Gas Continuing Case 28. Checking Account Reconciliation Jamie Lee Jackson, age 26, is in her last semester of college and is ardously waiting for graduation day that is just around the comer! She still works part-time as a bakery clerk, has been sticking to her budget the past two years, and is on track to accumulating enough money for the $10,000 down payment she needs to open her cupcake care within the next two years. Jamie Lee is still single, shares a small apartment with a friend, and continues to split all of the associated living expenses, such as rent and utilities, but unfortunately, through a turn of events, has had to seriously consider a place of her own One evening, after returning to the apartment after a long shift at the bakery, Jamie learned that her roommate had a couple of friends over earlier in the evening. As Jamie went to her room, she noticed that her top desk drawer had been left open and her Debit/ATM card, as well as her checkbook and Social Security card, were missing. She immediately contacted the authorities, and the police instructed her to notify her financial institution immediately. But it was late Saturday night, and Jamie thought she had to now wait until Monday morning. Unfortunately, within no time, Jamie found that her checking account had been emptied! Jamie Lee's luck worsened, as she had paid many of her monthly bills late last week. Her automobile insurance, two utility bills, and a layaway payment had all been paid for by check. Her bank almost immediately began sending Overdraft alerts through her smart phone for the emptied checking account. Determine the balance in Jamie Lee's checkbook register below. Use this total along with the information from Jamie Lee's monthly bank statement to reconcile her checkbook register with her bank statement. Each answer must have a value for the assignment to be complete. Enter "O' for any unused categories. Bank accounts: Checking account before theft) Savings account Emergency fund savings account 401K) balance $2,330 $7,100 $4100 $360 Checked Number Amount Deposit Balance 50 $ 50.00 2,125.53 $ 52.00 Excerpt from Jamie Lee's Check Register bed Check Date Description 792 9-10 Car Care (car insurance) World Card 793 9-10 Express (credit card payment) 794 9-10 Great Foods (groceries) 795 9-14 Target (shirts 9-15 Deposit paycheck) 9-17 Chick Fil A $ 58.60 390 390212 Debit 8.67 7969-19 9-22 Susie Barrett (birthday gift) Deposit Statement date: 2017 Checking Account Reconciliation date September 16, Statement balance: Enter balance from statement) Step 1: Subtract total of outstanding checks (checks that you have written but that have not yet cleared in the banking system) Check Number Amount Check Number Amount Total Step 2: Add deposits in transit (deposits you have made but that have not yet been reported on this statement) Deposit Date Amount Deposit Date Amount Total: Adjusted cash balance: Checkbook balance: (Enter balance from checkbook) Step 3: Subtract fees or other charges listed on your bank statement, along with ATM withdrawals, debit card payments, and other automatic payments that are not yet reported Description Amount Description Amount Chik Fil A Total Step 4: Add any interest earned and direct deposits to your checkbook balance Interest eamed Direct deposits: Adjusted cash balance: Note: At this point, the balances for both the checkbook and bank statement should be the same. Page 1 of BANK STATEMENT: Link Trust Bank P.O. Box 0000000 Any City, US 12345 Page 1 of 1 Acct. ending xxx4560 09/15/2017 Link Trust Bank Jamie Lee Jackson 126 West Street, Apt. 3A Somewhere, US 23456 Account Account Type Summary CHECKING Account Number XXXXXXXXXXX4560 Statement Period 08/16/2017 - 09/15/2017 Description Amount Average Balance $1,378.33 Number of days in Statement Period 31 Description Beginning Balance Deposits/Credits Checks Withdrawals/Debits Ending Balance Amount $1,292.09 $1,950.62 $ 591.12 $ 153.28 $2,498.31 Deposits/ Date Credits 08/18 08/25 09/01 09/08 09/15 Amount 390.12 390.13 390.12 390.13 390.12 Description DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. DEPOSIT - Electronic Credit/Great Foods, Inc. Checks Check Number Amount Description 786 787 788 789 47.86 33.26 275.00 80.00 45.00 60.00 50.00 Date Paid 08/19 08/17 09/03 09/02 09/05 09/04 09/12 Great Foods Grocery Target Lion's Gate Communities Electric Co-Op City Water Services Cable Connection World Services Car Care Insurance 790 791 792 Debits Debit Debit Debit Debit Debit Debit 13.56 22.94 39.65 23.74 35.00 18.39 08/19 08/25 08/27 08/28 09/08 09/10 Check Card Purchase - Family Value Gas Check Card Purchase - Domino's Pizza #0001 Check Card Purchase - Great Foods Grocery Check Card Purchase - Family Value Gas Check Card Purchase - World of Cakes Check Card Purchase - Family Value Gas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Food And Beverage Cost Control

Authors: Lea R. Dopson, David K. Hayes

6th Edition

1118988493, 978-1118988497

More Books

Students also viewed these Accounting questions