Problem 7-9A Preparing a bank reconciliation and recording adjustments LO6
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,300 | Book balance | $ | 29,825 | ||||
Add: | |||||||||
Deposit of March 31 in transit | 9,637 | ||||||||
$ | 30,937 | ||||||||
Deduct: | |||||||||
Outstanding cheques: | |||||||||
#14 | $ | 807 | |||||||
#22 | 305 | 1,112 | |||||||
Adjusted bank balance | $ | 29,825 | Adjusted book balance | $ | 29,825 | ||||
Cash | Acct. No. 101 | ||||||||
Date | Explanation | PR | Debit | Credit | Balance | ||||
2020 | |||||||||
March | 31 | Balance | 29,825 | ||||||
April | 30 | CR17 | 70,618 | 100,443 | |||||
30 | CD13 | 88,940 | 11,503 | ||||||
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 | $ | 682 | ||
13 | 4,544 | ||||
18 | 5,831 | ||||
23 | 13,736 | ||||
27 | 1,730 | ||||
30 | 44,095 | ||||
Total April Cash Receipts | $ | 70,618 | |||
Cheques Written | ||||||
No. | 23 | $ | 5,133 | |||
24 | 3,113 | |||||
25 | 931 | |||||
26 | 302 | |||||
27 | 4,119 | |||||
28 | 4,900 | |||||
29 | 19,099 | |||||
30 | 39,760 | |||||
31 | 404 | |||||
32 | 11,179 | |||||
Total April Cash Disbursements | $ | 88,940 | ||||
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,300 | |||||||||||||||||
#31 | 04/03 | 404 | 04/03 | 9,637 | 30,533 | ||||||||||||
#28 | 04/07 | 9,400 | 04/07 | 682 | 21,815 | ||||||||||||
#26 | 04/13 | 302 | 04/13 | 4,544 | 26,057 | ||||||||||||
NSF | 04/18 | 13,828 | 04/18 | 5,831 | 18,060 | ||||||||||||
#24 | 04/23 | 3,113 | 04/23 | 13,736 | 28,683 | ||||||||||||
#23 | 04/27 | 5,133 | 04/27 | 1,730 | 25,280 | ||||||||||||
#29 | 04/30 | 19,099 | 04/30 | 112,000 | 118,181 | ||||||||||||
PMT | 04/30 | 15,466 | 102,715 | ||||||||||||||
INT | 04/30 | 384 | 102,331 | ||||||||||||||
SC | 04/30 | 177 | 102,154 | ||||||||||||||
NSF = Not Sufficient Funds |
SC = Service Charge |
PMT = Payment of Principal on the loan |
INT = Interest on Bank Loan |
||||||||||||||
Required:
a. Prepare a bank reconciliation for Stewart Recording
Studio at April 30.
b. Prepare the necessary journal entries to bring
the General Ledger Cash account into agreement with the adjusted
balance on the bank reconciliation.
Problem 7-9A Preparing a bank reconciliation and recording adjustments LO6 Stewart Recording Studio, owned by Ron...
Problem 7-9A Preparing a bank reconciliation and recording adjustments LO6 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,300 Book balance $ 31,225 Add: Deposit of March 31 in transit 10,090 $ 32,390 Deduct: Outstanding cheques: #14 $ 846 #22 319 1,165 Adjusted bank balance $ 31,225 Adjusted book balance $ 31,225 Cash Acct. No. 101 Date Explanation PR Debit Credit...
reparing a bank reconciliation and recording adjustments L06 Problem 7-7B Preparing CHECK FIGURE: 1. The following informa 4 The December 3 h. Cheque #3115 for $1 FIGURE: 1. Adjusted book balance = $35,775 information was available to reconcile Frogbox Moving's book Cash balance with its bank state- went balance as of December 31, 2020: December 31 Cash balance according to the accounting records was $16,562, and the bank statement balance for that date was $36,780. #3115 for $1,119 and cheque...
Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31. a. On July 31, the company's Cash account has a $25,866 debit balance, but its July bank statement shows a $28,091 cash balance. b. Check No. 3031 for $1.480 and Check No. 3040 for $732 were outstanding on the June 30 bank reconciliation. Check No. 3040 is listed with...
Problem 6-5A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to the questions displayed below.) Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reporte two checks outstanding, No. 5888 for $1,058 and No. 5893 for $493. The following information is available for its September 30 reconciliation. From the September 30 Bank Statement PREVIOUS BALANCE 19,500 TOTAL CHECKS AND DEBITS 10,010 TOTAL DEPOSITS AND CREDITS 11,609...
Problem 6-5A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to the questions displayed below.) Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1.058 and No. 5893 for $493. The following information is available for its September 30 reconciliation From the September 30 Bank Statement TOTAL DEPOSITS AND CREDITS PREVIOUS BALANCE 19,500 TOTAL CHECKS AND DEBITS 10,010 CURRENT...
Problem 8-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 a. On July 31, the company's Cash account has a $25,862 debit balance, but its July bank statement shows a $28,128 cash balance. b. Check No. 3031 for $1,490 and Check No. 3040 for $737 were...
Required information Problem 8-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 a. On July 31, the company's Cash account has a $25,868 debit balance, but its July bank statement shows a $28,161 cash balance b. Check No. 3031 for $1,510 and Check No. 3040 for...
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. a. On July 31, the company's Cash account has a $25,722 debit balance, but its July bank statement shows a $27,510 cash balance. b. Check No. 3031 for $1,280, Check No. 3065 for $416, and Check No....
Prepare a bank reconciliation. 21 seharbor Food Store used the following information in recording its bank reconciliation to recording its bank reconciliation for the month of April. Balance per books April 30, 2019: $ 1,810 Balance per bank statement April 30, 2019: 22,600 (1) Checks written in April but still outstanding $21,200. (2) Deposits of April 30 not yet recorded by bank $8,800. (3) NSF check of customer returned by bank $ 1.000. (4) Cash receipts from customers in the...
The December bank statement and cash T-account for Stewart Company follow: Withdrawals Deposits $ 550 7,500 125 Balance $50,500 49,950 42,450 42,325 72,225 70,075 57,575 600 $30,500 2,150 12,500 Date Dec. 1 2-Cheque 4-Cheque 6-Cheque 11-Cheque 13-Cheque 17-Cheque 23-Cheque 26-Cheque 28-Cheque 30-Cheque 30–NSF* 31-Cheque 31-Interest earned 31-Service charge 36,500 . 925 93,085 2,450 17,500 350 1,700 90,6 92,6 о л л op www л л 19,500 92,285 90,585 90,640 90,465 175 *NSF cheque from J. Left, a customer. + Cash...