Answered step by step
Verified Expert Solution
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
URGENT For part
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 TAccount 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 : 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 : Use the Excel Template spreadsheet to answer the questions in Blackboard for the corresponding week in the content folder.
Step : 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
PO Box
El Paso, Texas
Carla's Candles, Inc.
Main Avenue
El Paso, Texas
WELLS FARCO BANK STATEMENT
Carla's Candles, Inc.
tableBalance beginning,$
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 TAccount 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 : 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 : Use the Excel Template spreadsheet to answer the questions in Blackboard for the corresponding week in the content folder.
Step : 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
Pag e
Bank Statement
Wells Fargo Bank
Page
PO Box
El Paso, Texas
Carla's Candles, Inc.
Main Avenue
El Paso, Texas
WELLS FARCO BANK STATM MENT
Carla's Candlles, Inc.
tableBalance beginning,$
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started