Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following bank reconciliation, general ledger, and bank statement for CM Coffee. CM Coffee Bank Reconciliation June 30, 2021 Cash balance per bank statement

Consider the following bank reconciliation, general ledger, and bank statement for CM Coffee.

CM Coffee Bank Reconciliation June 30, 2021
Cash balance per bank statement 4,080 Cash balance per books 5,279
Add Add
Outstanding deposit 1,260 Interest earned 21
Deduct
Deduct outstanding cheques NSF cheque 590
Cheque #55 990 NSF service charge 20
Cheque #56 690 1,680 EFT - Rent 1,000
Bank service charge 30 1,640
Adjusted bank balance 3,660 Adjusted book balance 3,660

Account: Cash GL. No. 101
Date Explanation DR CR Balance
Jul 1 Opening balance 3,660 DR
Jul 10 Cheque #57 940 2,720 DR
Jul 11 Deposit 870 3,590 DR
Jul 17 Cheque #58 490 3,100 DR
Jul 28 Deposit 2,230 5,330 DR
Jul 28 Cheque #59 1,150 4,180 DR

Bank Statement
Date Explanation Withdrawal Deposit Balance
Jul 1 Opening balance 4,080
Jul 2 Deposit 1,260 5,340
Jul 3 Cheque #56 690 4,650
Jul 10 Cheque #57 940 3,710
Jul 11 Deposit 870 4,580
Jul 17 Cheque #58 490 4,090
Jul 26 EFT - monthly rent expense 1,000 3,090
Jul 27 Deposit 2,230 5,320
Jul 31 Service charges 30 5,290
Jul 31 Interest on bank account 23 5,313

Additional Information The deposit from Jul 27, contains a cheque from the customer who provided an NSF cheque from the month before. The customer paid the original amount of $590, plus the $20 charge.

Required Using last month's bank reconciliation, bank statement, and general ledger provided, prepare a bank reconciliation for CM Coffee for July 31, 2021.

Do not enter dollar signs or commas in the input boxes. Do not use the negative sign.

CM Coffee Bank Reconciliation July 31, 2021
Cash balance per bank statement Answer Cash balance per books Answer
Add
Interest on bank account Answer
Deduct outstanding cheques Deduct
Cheque #55 Answer EFT - Rent Answer
Cheque #59 Answer Answer Bank service charge Answer Answer
Adjusted bank balance Answer Adjusted book balance Answer

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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: Robert Kemp, Jeffrey Waybright

2nd edition

978-0132771801, 9780132771580, 132771802, 132771586, 978-0133052152

Students also viewed these Accounting questions