Question

In: Accounting

Stewart Recording Studio, owned by Ron Stewart, showed the following bank reconciliation at March 31: Stewart...

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,800 Book balance $ 30,525
Add:
Deposit of March 31 in transit 9,862
$ 31,662
Deduct:
Outstanding cheques:
#14 $ 822
#22 315 1,137
Adjusted bank balance $ 30,525 Adjusted book balance $ 30,525
Cash Acct. No. 101
Date Explanation PR Debit Credit Balance
2020
March 31 Balance 30,525
April 30 CR17 71,203 101,728
30 CD13 90,305 11,423


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 $ 687
13 4,579
18 5,876
23 13,841
27 1,745
30 44,475
Total April Cash Receipts $ 71,203
Cheques Written
No. 23 $ 5,178
24 3,138
25 936
26 307
27 4,189
28 4,900
29 19,419
30 40,510
31 409
32 11,319
Total April Cash Disbursements $ 90,305


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
21,800
#31 04/03 409 04/03 9,862 31,253
#28 04/07 9,400 04/07 687 22,540
#26 04/13 307 04/13 4,579 26,812
NSF 04/18 14,058 04/18 5,876 18,630
#24 04/23 3,138 04/23 13,841 29,333
#23 04/27 5,178 04/27 1,745 25,900
#29 04/30 19,419 04/30 117,000 123,481
PMT 04/30 15,726 107,755
INT 04/30 424 107,331
SC 04/30 177 107,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 $14,058 was that of customer Oprah Winney, deposited in March.
  • On the bank statement, the payment for $15,726 is regarding a note payable.
  • There is also a deposit of $117,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).

Solutions

Expert Solution

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
21,800
#31 04/03 409 04/03 9,862 31,253
#28 04/07 4900 04/07 687 27,040
#26 04/13 307 04/13 4,579 31,312
NSF 04/18 14,058 04/18 5,876 23,130
#24 04/23 3,138 04/23 13,841 33,833
#23 04/27 5,178 04/27 1,745 30,400
#29 04/30 19,419 04/30 117,000 127,981
INT 04/30 424 127,557
SC 04/30 177 127380

1.firt one reversed journal

bank a/c dr. 9400

to Delivery expense a/c 9400

(reversed Entry)

after that corrected entry

Delivary expense a/c dr 4900

To Bank A/c 4900

(corrected Entry)

2 Bank a/c Dr. $14058

To opera Winner $14058

(amount deposited Opera winner)

3. Payment for party A/c Dr. $15726

To Bank A/c $15726

(payment to Party a/c)

4.Bank a/c Dr. $117000

To Owners Capital A/c $11700

( Amout deposited in Business)


Related Solutions

Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed:...
Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed: Deposit in transit of $1,100 Outstanding checks no.797 $450 no.804 $890 The reconciled cash balance on March 31 was $11,720 The following bank statement is available for April 2012. Bank Statement TO Sandler Company April 30 Fairbanks, AK FAIRBANKS NATIONAL BANK Date Deposits No. Date Charges Date Balance Apr. 1 $1,100 804 Apr. 2 $890 Mar. 31 $11,960 3 1,680 807 3 730 Apr....
The cash records of the Margo Company show the following: 1. The March 31 bank reconciliation...
The cash records of the Margo Company show the following: 1. The March 31 bank reconciliation indicated that deposits in transit totaled $390 2. During April the Cash account shows deposits of $11,800, but the bank statement indicates that only $9,540 in deposits were received during the month 3. The March 31 bank reconciliation also reported outstanding checks of $850 4. During the month of April, the Margo Company books show that $11,670 of checks were issued, yet the bank...
The Odum Corporation’s cash account showed a balance of $17,198 on March 31, 2007. The bank...
The Odum Corporation’s cash account showed a balance of $17,198 on March 31, 2007. The bank statement balance for the same date indicated a balance of $17,924.55. The following additional information is available concerning Odum’s cash balance on March 31, 2007. 1. Undeposited cash on hand on March 31 amounted to $724.50. 2. A customer’s NSF check for $173.80 was returned with the bank statement. 3. A note for $2,000 plus interest of $25 was collected for Odum by the...
The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS...
The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS Bank Reconciliation March 31, 2020 Bank statement balance $ 14,600 Book balance $ 32,268 Add: Deposit of March 31 in transit 20,764 35,364 Deduct: Outstanding cheques: #79 $ 1,229 #84 1,867 3,096 Adjusted bank balance $ 32,268 Adjusted book balance $ 32,268 The Cash account in the General Ledger appeared as follows on April 30: Cash Acct. No. 101 Date Explanation PR Debit Credit...
The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS...
The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS Bank Reconciliation March 31, 2020 Bank statement balance $ 14,600 Book balance $ 32,268 Add: Deposit of March 31 in transit 20,764 35,364 Deduct: Outstanding cheques: #79 $ 1,229 #84 1,867 3,096 Adjusted bank balance $ 32,268 Adjusted book balance $ 32,268 The Cash account in the General Ledger appeared as follows on April 30: Cash Acct. No. 101 Date Explanation PR Debit Credit...
The bank reconciliation prepared by Gemma Tours on March 31, 2017, appeared as follows: Gemma Tours...
The bank reconciliation prepared by Gemma Tours on March 31, 2017, appeared as follows: Gemma Tours Bank Reconciliation March 31, 2017   Bank statement balance $15,500   Book balance $34,257   Add:      Deposit of March 31 in transit 22,044 $37,544   Deduct:      Outstanding cheques: #79 $1,306 #84 1,981 3,287   Adjusted bank balance $34,257   Adjusted book balance $34,257 The Cash account in the General Ledger appeared as follows on April 30:                   Cash Acct. No. 101 Date Explanation PR Debit Credit Balance 2017 March 31 Balance...
Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the...
Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the following format. I am not going to be particular about how you show your numbers as long as you have them in the right spot and can get to the correct adjusted balances. Bank Balance: Cash Balance: Add: Add: Deduct: Deduct: Adjusted Balance: Adjusted Balance: Journalize the necessary entries. After completing the bank reconciliation show any necessary journal entries. Pretend you have a general...
Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance...
Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance of $15,180. Meanwhile its Cash book balance at March 31, 2019 stood $8,140. In addition, the Accountant of Broadway Enterprises was presented with the following information: Bank charges for the month were shown as $250 as per bank statement. Cheques issued to two creditors-Alloy Limited for $900 (cheque #253) and Ben Lion for $270 (cheque #258) were not presented to the bank and remain...
Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to...
Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to the questions displayed below.] The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017. On July 31, the company’s Cash account has a $27,497 debit balance, but its July bank statement shows a $27,233 cash balance. Check No. 3031 for $1,482 and Check No. 3040 for $558 were outstanding on...
Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 Skip to question [The following...
Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 Skip to question [The following information applies to the questions displayed below.] The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31.    On July 31, the company’s Cash account has a $25,636 debit balance, but its July bank statement shows a $27,925 cash balance. Check No. 3031 for $1,480, Check No. 3065 for $516, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT