Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Stewart Recording Studio, owned by Ron Stewart, showed the following bank reconciliation at March 31: Stewart Recording Studio Bank Reconciliation March 31, 2020 Bank statement
Stewart Recording Studio, owned by Ron Stewart, showed the following bank reconciliation at March 31:
Stewart Recording Studio | |||||||||
Bank Reconciliation | |||||||||
March 31, 2020 | |||||||||
Bank statement balance | $ | 22,400 | Book balance | $ | 31,365 | ||||
Add: | |||||||||
Deposit of March 31 in transit | 10,135 | ||||||||
$ | 32,535 | ||||||||
Deduct: | |||||||||
Outstanding cheques: | |||||||||
#14 | $ | 849 | |||||||
#22 | 321 | 1,170 | |||||||
Adjusted bank balance | $ | 31,365 | Adjusted book balance | $ | 31,365 | ||||
Cash | Acct. No. 101 | ||||||||
Date | Explanation | PR | Debit | Credit | Balance | ||||
2020 | |||||||||
March | 31 | Balance | 31,365 | ||||||
April | 30 | CR17 | 72,406 | 103,771 | |||||
30 | CD13 | 93,656 | 10,115 | ||||||
A list of deposits made and cheques written during April, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown below:
Deposits Made | |||||
April | 7 | $ | 699 | ||
13 | 4,660 | ||||
18 | 5,978 | ||||
23 | 14,083 | ||||
27 | 1,774 | ||||
30 | 45,212 | ||||
Total April Cash Receipts | $ | 72,406 | |||
Cheques Written | ||||||
No. | 23 | $ | 5,269 | |||
24 | 3,192 | |||||
25 | 952 | |||||
26 | 319 | |||||
27 | 4,353 | |||||
28 | 4,900 | |||||
29 | 20,194 | |||||
30 | 42,320 | |||||
31 | 424 | |||||
32 | 11,733 | |||||
Total April Cash Disbursements | $ | 93,656 | ||||
The following bank statement is available for April:
Bank Statement | |||||||||||||||||
To: Stewart Recording Studio | April 30, 2020 Bank of Canada | ||||||||||||||||
Cheques/Charges | Deposits/Credits | Balance | |||||||||||||||
22,400 | |||||||||||||||||
#31 | 04/03 | 424 | 04/03 | 10,135 | 32,111 | ||||||||||||
#28 | 04/07 | 9,400 | 04/07 | 699 | 23,410 | ||||||||||||
#26 | 04/13 | 319 | 04/13 | 4,660 | 27,751 | ||||||||||||
NSF | 04/18 | 14,611 | 04/18 | 5,978 | 19,118 | ||||||||||||
#24 | 04/23 | 3,192 | 04/23 | 14,083 | 30,009 | ||||||||||||
#23 | 04/27 | 5,269 | 04/27 | 1,774 | 26,514 | ||||||||||||
#29 | 04/30 | 20,194 | 04/30 | 123,000 | 129,320 | ||||||||||||
PMT | 04/30 | 16,356 | 112,964 | ||||||||||||||
INT | 04/30 | 594 | 112,370 | ||||||||||||||
SC | 04/30 | 181 | 112,189 | ||||||||||||||
NSF = Not Sufficient Funds | SC = Service Charge | PMT = Payment of Principal on the loan | INT = Interest on Bank Loan | ||||||||||||||
- In reviewing cheques returned by the bank, the bookkeeper discovered that cheque #28, for delivery expense, was recorded in the Cash Disbursements Journal correctly as $4,900.
- The NSF cheque for $14,611 was that of customer Oprah Winney, deposited in March.
- On the bank statement, the payment for $16,356 is regarding a note payable.
- There is also a deposit of $123,000 dated April 30. It is an investment made by the owner into the business (the bank transferred the funds electronically from the owners personal account to his business account, which is why it was not recorded in the Cash Receipts Journal).
Required: a. Prepare a bank reconciliation for Stewart Recording Studio at April 30.
Journal entry worksheetStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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