Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help please:) Part Four Instructions In this part of the proctice set, the student wil prepare a Bank Reconciliation for the month of September

Need help please:)
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Part Four Instructions In this part of the proctice set, the student wil prepare a Bank Reconciliation for the month of September by using the ending cash amount in your account for your books. Be prepared to turn in the Bank Reconciliation after answering the questions in Elockboard. Requirements 1. Make sure you have corrected any errors on your journal and adjusfing 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 reconcillation. 2. Bank Reconciliation: Using the cosh balance per books and the bank statement, prepare a bank reconcliation. A template you can use to create a Bank Reconciliation is located below. 3. Record Bank Reconciliation Adjustments: Affer you have prepared the bank reconciliation you must moke any adiusting iournal entries to your cash account by entering them in the general journal of the practice set so that the general ledger cosh account agrees with the Bank Reconcilation. 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. Step 2: Use the Excel 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 spreadsheet into Blackboard by clicking on the navigation pane then clicking on Practice Set. Bank Reconciliation Template Bank Statement Bella's Balloon Bouquet, Inc. 123 Main Avenue El Paso, Texas 79945 "Assume any errors are made by the oank Transactions \begin{tabular}{|c|c|c|} \hline & & \\ \hline 18. & 9/20/23 & CK #1007 \\ \hline & & \\ \hline 19. & 9/22/23 & Ck $1008 \\ \hline21.20. & \begin{tabular}{l} 9/22/23 \\ 9/23/23 \end{tabular} & \\ \hline 21. & 9/23/23 & \\ \hline 22. & 9/23/23 & Deposit \#4 \\ \hline & & \\ \hline 23. & 9/23/23 & Ck #1009 \\ \hline 24. & 9/23/23 & Ck \#1010 \\ \hline & 9/23/239/23/23 & Deposit #5 \\ \hline & & \\ \hline 26. & 9/23/23 & Ck #1011 \\ \hline & & Deposit #6 \\ \hline 27. & 9/25/23 & \\ \hline & 9/28/23 & \\ \hline2920. & 9/30/23 & Ck #1012 \\ \hline 29. & & \\ \hline & & \\ \hline 30. & 9/30/23 & Deposit \#7 \\ \hline & & \\ \hline 31. & 9/30/23 & Ck #1013 \\ \hline 32. & 9/30/23 & Ck #1014 \\ \hline \end{tabular} Wells Fargo Bank Bella's Balloon Bouquets Balance Ending Cash Balance on Bank Statement Ending Cash Balance in T-Account Deposits in Transit Adjustments or Errors +/- Outstanding Checks Reconciled Balance Adjustments or Errors +/- Reconciled Balance If any journal entries need to be written add them here. Insert rows as needed

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

Financial Accounting

Authors: Belverd E. Needles

5th Edition

0395698022, 978-0395698020

More Books

Students also viewed these Accounting questions

Question

Formulate strategies and recommendations for action on HRM issues.

Answered: 1 week ago