Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve in excel format Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for the month

please solve in excel format
image text in transcribed
image text in transcribed
image text in transcribed
Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January, Prepare it in Excel and use the ending balance in your cash account for the ending cash for your books. Be prepared to turn in the Bank Reconciliation after answering the questions in Blackboard. Requirements 1. Make sure you have corrected any errors on your journal and adjusting journal entries and have the correct balance for the cash account in your T-Account before starting the Bank Reconciliation, please use the correct balance in the cash account to start on the book side of the reconciliation 2. Bank Reconciliation: Using the cash balance per books and the bank statement, prepare a bank reconciliation. A template you can use to create a Bank Reconciliation is located on the following page 3. Record Bank Reconciliation Adjustments: After you have prepared the bank reconciliation you must make any adjusting lournal entries to your cash account by entering them in the general journal of the practice set so that the general ledger cash account agrees with the Bank Reconciliation Once you finish the Bank Reconciliation follow the instructions below: Step 1: Use the template below to create an Excel spreadsheet to show the reconciled balance using the Bank Statement and the correct ending balance in the cash account. Once the bank reconciliation is completed, print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder for the corresponding week. Step 3: Once you complete entering all the information into Blackboard, upload the Bank Reconciliation into Blackboard. 13 Page Template for Bank Reconciliation "Evy's Electric Bikes" Wells Fargo Balance Ending Cash Balance on Bank Statement Deposits in Transit Outstanding Checks Adjustments or Errors +/- Reconciled Balance Ending Cash Balance in T-Account Adjustments or Errors +/- Reconciled Balance 14 Page 20CIETY Bank Statement Wells Fargo Bank Page 1 PO Box 12345 El Paso, Texas 79998-2345 Evy's Electric Bikes 123 Main Avenue El Paso, Texas 79945 WELLS FARGO BANK STATEMENT Evy's Electric Bikes Balance, beginning Deposits and other credits Checks and other debits Balance on statement date 01/01/2022 January January 01/31/2022 $0.00 $112,908 $36,545 $76,363 Deposits Added 1/2/2022 Deposit 1 $70,000 1/5/2022 Deposit 2 $10,000 1/20/2022 Deposit 3 $12,124 1/23/2022 Deposit 4 $12,557 1/28/2022 Deposit 5 $8,227 Wells Fargo Bank Statement - Checks Paid and other Debts 1001 $9.000 1007 $490 1002 $4,000 1008 $250 1003 $1,100 1009 $200 1004 $14,000 1011 $6,000 1005 $750 DM $70 Check Printing Fee 1006 $450 DM $235 American Express for Gas * Assume any errors are made by the bank 15 | Page Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January, Prepare it in Excel and use the ending balance in your cash account for the ending cash for your books. Be prepared to turn in the Bank Reconciliation after answering the questions in Blackboard. Requirements 1. Make sure you have corrected any errors on your journal and adjusting journal entries and have the correct balance for the cash account in your T-Account before starting the Bank Reconciliation, please use the correct balance in the cash account to start on the book side of the reconciliation 2. Bank Reconciliation: Using the cash balance per books and the bank statement, prepare a bank reconciliation. A template you can use to create a Bank Reconciliation is located on the following page 3. Record Bank Reconciliation Adjustments: After you have prepared the bank reconciliation you must make any adjusting lournal entries to your cash account by entering them in the general journal of the practice set so that the general ledger cash account agrees with the Bank Reconciliation Once you finish the Bank Reconciliation follow the instructions below: Step 1: Use the template below to create an Excel spreadsheet to show the reconciled balance using the Bank Statement and the correct ending balance in the cash account. Once the bank reconciliation is completed, print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder for the corresponding week. Step 3: Once you complete entering all the information into Blackboard, upload the Bank Reconciliation into Blackboard. 13 Page Template for Bank Reconciliation "Evy's Electric Bikes" Wells Fargo Balance Ending Cash Balance on Bank Statement Deposits in Transit Outstanding Checks Adjustments or Errors +/- Reconciled Balance Ending Cash Balance in T-Account Adjustments or Errors +/- Reconciled Balance 14 Page 20CIETY Bank Statement Wells Fargo Bank Page 1 PO Box 12345 El Paso, Texas 79998-2345 Evy's Electric Bikes 123 Main Avenue El Paso, Texas 79945 WELLS FARGO BANK STATEMENT Evy's Electric Bikes Balance, beginning Deposits and other credits Checks and other debits Balance on statement date 01/01/2022 January January 01/31/2022 $0.00 $112,908 $36,545 $76,363 Deposits Added 1/2/2022 Deposit 1 $70,000 1/5/2022 Deposit 2 $10,000 1/20/2022 Deposit 3 $12,124 1/23/2022 Deposit 4 $12,557 1/28/2022 Deposit 5 $8,227 Wells Fargo Bank Statement - Checks Paid and other Debts 1001 $9.000 1007 $490 1002 $4,000 1008 $250 1003 $1,100 1009 $200 1004 $14,000 1011 $6,000 1005 $750 DM $70 Check Printing Fee 1006 $450 DM $235 American Express for Gas * Assume any errors are made by the bank 15 | Page

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

Connect For Data Analytics For Accounting

Authors: Author

2nd Edition

1264152000, 9781264152001

More Books

Students also viewed these Accounting questions