Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please Help Sheridan decides that she cannot afford to hire John to do her accounting. One way that she can ensure that her cash account

image text in transcribed please Help
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Sheridan decides that she cannot afford to hire John to do her accounting. One way that she can ensure that her cash account does not have amy errors and is accurate and up-to date is to prepare a bank reconciliation at the end of each month. Sheridan would like you to help her. She asks you to prepare a bank reconciliation for June 2022 using the following information. \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{\begin{tabular}{c} PREMIER BANK \\ Statement of Account-Cookle Creations \\ June 30,2022 \end{tabular}} \\ \hline Date & Explanation & Checks and Other Debits & Deposits & Balance \\ \hline May 31 & Balance & & & 3,710 \\ \hline June 1 & Deposit & & 855 & 4,630 \\ \hline 6 & Check" 600 & 721 & & 3,861 \\ \hline 6 & Check\#601 & 110 & & 3,751 \\ \hline 8 & Check #602 & 62 & & 3.689 \\ \hline 9 & Deposit & & 1,197 & 4,886 \\ \hline 10 & NSF check & 100 & & \\ \hline 10 & NSF-fee & 35 & & 4,751 \\ \hline 14 & Check \#603 & 432 & & 4,319 \\ \hline 20 & Deposit & & 151 & 4,470 \\ \hline 23 & EFT-Telus & 102 & & 4,368 \\ \hline 28 & Check #599 & 408 & & 3,960 \\ \hline 30 & Bankcharges & 13 & & 3,947 \\ \hline \end{tabular} 1. On May 31, there were two outstanding checks: $595 for $292 and $599 for $408. 2. Premier Bank made a posting error to the bank statement: check #603 was issued for $423, not $432. 3. The deposit made on June 20 was for $151 that Sheridan received for teaching a class. Sheridan made an error in recording this transaction. 4. The electronic funds transfer (EFT) was for Sheridan's cell phone use. Remember that she uses this phone only for business. 5. The NSF check was from Ron Black. Sheridan received this check for teaching a class to Ron's children. Sheridan contacted Ron, and he assured her that she will receive a check in the mail for the outstanding amount of the invoice and the NSF bank charge. Prepare Conlie Creations' bank reconciliation for June 30. thet items that increase cash balance frnt. Reconcile cash balance per bank fine) eToctbook and Media ist of Accounts Sintoritien Attemptsi 0 of 3 used Date Account Iitles and Explanation Debit Credit June 30 (To record bank charges.) June 30 (To record error in deposit made on June 20.) June 30 (To record EFI charges.) June 30 (To record NSF check.)

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

Cost Benefit Analysis Theory And Application

Authors: Tevfik F. Nas

1st Edition

080397132X, 978-0803971325

More Books

Students also viewed these Accounting questions

Question

Understand corporate and HRM strategy.

Answered: 1 week ago