Answered step by step
Verified Expert Solution
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
Get Instant Access with AI-Powered 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