Answered step by step
Verified Expert Solution
Link Copied!

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$21,100Book balance$29,545
Add:
Deposit of March 31 in transit9,547
$30,647
Deduct:
Outstanding cheques:
#14$801
#223011,102
Adjusted bank balance$29,545Adjusted book balance$29,545
CashAcct. No. 101
DateExplanationPRDebitCreditBalance
2020
March31Balance29,545
April30CR1770,38499,929
30CD1388,39411,535


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
April7$680
134,530
185,813
2313,694
271,724
3043,943
Total April Cash Receipts$70,384
Cheques Written
No.23$5,115
243,103
25929
26300
274,091
284,900
2918,971
3039,460
31402
3211,123
Total April Cash Disbursements$88,394


The following bank statement is available for April:

Bank Statement
To: Stewart Recording StudioApril 30, 2020
Bank of Canada
Cheques/ChargesDeposits/CreditsBalance
21,100
#3104/0340204/039,54730,245
#2804/079,40004/0768021,525
#2604/1330004/134,53025,755
NSF04/1813,73604/185,81317,832
#2404/233,10304/2313,69428,423
#2304/275,11504/271,72425,032
#2904/3018,97104/30110,000116,061
PMT04/3015,362100,699
INT04/30368100,331
SC04/30177100,154
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 $13,736 was that of customer Oprah Winney, deposited in March.
  • On the bank statement, the payment for $15,362 is regarding a note payable.
  • There is also a deposit of $110,000 dated April 30. It is an investment made by the owner into the business (the bank transferred the funds electronically from the owner’s 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.

STEWART RECORDING STUDIO

Bank Reconciliation

April 30, 2020

Bank Statement Company's Books

Bank statement balance     Book balance

Add: Add:

Deduct: Deduct:

Outstanding cheques:

Adjusted bank balance Adjusted book balance



b. Prepare the necessary journal entries to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation.

- Record to reinstate customer account.

- Record the April bank service charges.

- Record the April interest expense.

- Record the April payment on note.

- Record the investment by owner.

If you could answer these but also explain why you did each answer and your though process and how you broke down the question im trying to learn how to do it myself as well. thankyou so much <3


Step by Step Solution

3.34 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Solution Bank reconciliation statement is a statement which is prepared to find the reasons behind the differences between bank statement and Cash boo... 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

Financial Accounting

Authors: LibbyShort

7th Edition

78111021, 978-0078111020

More Books

Students also viewed these Accounting questions