Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

URGENT ! ! ! For part 4 Part Four Instructions In this part of the practice set, the student will prepare a Bank Reconciliation for

image text in transcribed
URGENT !!! For part 4
Part Four Instructions
In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January. Start by using the ending balance in your cash account for the cash for your books and the ending balance on the bank statement for the bank balance.
Requirements
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.
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 below.
Record Bank Reconciliation Adjustments: After you have prepared the bank reconciliation you must make any adjusting journal 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: Enter the journal entries into the Excel Template spreadsheet and when completed print it out. Save your completed template to your computer where you can access it later to upload.
Step 2: Use the Excel Template spreadsheet to answer the questions in Blackboard for the corresponding week in the content folder.
Step 3: Once you complete entering information into Blackboard, upload the template spreadsheet into Blackboard by clicking on the navigation pane then clicking on Practice Set.
Bank Reconciliation Template
Wells Fargo Bank Balance
Ending Cash Balance
Deposits in Transit
Outstanding Checks
Adjustments or Errors +/-
Reconciled Balance
"Carla's Candles"
Ending Cash Balance
Adjustments or Errors +/-
Reconciled Balance
Bank Statement
Wells Fargo Bank
Page 1
PO Box 12345
El Paso, Texas 79902
Carla's Candles, Inc.
123 Main Avenue
El Paso, Texas 79945
WELLS FARCO BANK STATEMENT
Carla's Candles, Inc.
\table[[Balance, beginning,0101?2024,$0
Part Four Instructions
In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January. Start by using the ending balance in your cash account for the cash for your books and the ending balance on the bank statement for the bank balance.
Requirements
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.
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 below.
Record Bank Reconciliation Adjustments: After you have prepared the bank reconciliation you must make any adjusting journal 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: Enter the journal entries into the Excel Template spreadsheet and when completed print it out. Save your completed template to your computer where you can access it later to upload.
Step 2: Use the Excel Template spreadsheet to answer the questions in Blackboard for the corresponding week in the content folder.
Step 3: Once you complete entering information into Blackboard, upload the template spreadsheet into Blackboard by clicking on the navigation pane then clicking on Practice Set.
Bank Reconciliation Template
Wells Fargo Bank Balance
Ending Cash Balance
Deposits in Transit
Outstanding Checks
Adjustments or Errors +/-
Reconciled Balance
"Carla's Candles"
Ending Cash Balance
Adjustments or Errors +/-
Reconciled Balance
14
Pag e
Bank Statement
Wells Fargo Bank
Page 1
PO Box 12345
El Paso, Texas 79902
Carla's Candles, Inc.
123 Main Avenue
El Paso, Texas 79945
WELLS FARCO BANK STATM MENT
Carla's Candlles, Inc.
\table[[Balance, beginning,0101?2024,$0
image text in transcribed

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

Managerial Accounting

Authors: John J. Wild, Ken W. Shaw

4th edition

78129052, 978-0078129056

More Books

Students also viewed these Accounting questions

Question

What is a namespace?

Answered: 1 week ago

Question

Describe tables, rows, and columns.

Answered: 1 week ago

Question

What are operational and analytical databases?

Answered: 1 week ago