50.1K

Verified Solution

Link Copied!

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 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

Answer & Explanation Solved by verified expert

See Answer