Question

In: Accounting

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 Balance
2020
March 31 Balance 32,268.00
April 30 CR11 33,574.00 65,842.00
30 CD14 43,030.00 22,812.00

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 $ 14,001.00
13 841.00
18 13,456.00
23 938.00
27 1,867.00
30 2,471.00
Total April Cash Receipts $ 33,574.00


Cheques Written
No. 91 $ 1,183
92 5,157
93 2,590
94 3,403
95 2,856
96 1,785
97 8,347
98 2,856
99 8,457
100 6,396
Total April Cash Disbursements $ 43,030


The following bank statement is available for April: (Note: The bank deposits interest into the bank account at the end of every month.)

Bank Statement
To: Gemma Tours April 30, 2020
Bank of Montreal
Cheques/Charges Deposits/Credits Balance
14,600
#93 04/02 2,509 04/03 20,764 32,855
#92 04/07 5,157 04/07 14,001 41,699
#84 04/13 1,867 04/13 841 40,673
NSF 04/18 6,488 04/18 13,456 47,641
#95 04/23 2,856 04/23 938 45,723
#99 04/27 8,457 04/27 1,867 39,133
#96 04/30 1,785 04/30 2,471 39,819
#97 04/30 8,347 INT 43 31,515
#94 04/30 3,403 28,112
PMT 04/30 9,288 18,824
INT 04/30 33 18,791
SC 04/30 52 18,739
NSF = Not Sufficient
Funds
SC = Service Charge PMT = Principal Payment INT = Interest


In reviewing cheques returned by the bank, the bookkeeper discovered that cheque #93, for delivery expense, was recorded in the Cash Disbursements Journal incorrectly as $2,590. The NSF cheque was that of customer Laura Clark, deposited in April.

Required:
a.
Prepare a bank reconciliation 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.

Solutions

Expert Solution

Answwer :-

A. Prepare a Bank Reconciliation at April 30.

Gema Tours
Bank Reconciliation
Bank Statement Company's Books
Bank Statement Balance $ 18,739 Book Balance $22,812
Add :
Interest $43
Error in Check #93 Recording $2509 recorded as $2590 $81 $124
Less : Less :
Outstanding Checks NSF Check : Laura Clark $ 6488
#79 $1,229 Loan Payment - PMT $ 9288
#91 $ 1,183 Bank Service Charges $52
#98 $ 2,856 Bank Interest Charges $33 $ 15,861
#100 $ 6,396 $ 11,664
Adjusted Balance $ 7,075 Adjusted Balance $ 7,075

Answer B.

Journal Entries :-

Particular Debit Credit
Cash $43

Interest Income
( to record Interest Income from Bank )

$43
Cash $81

Delivery Exp.
( to adjust error in recording check #93 )

$81
Account Receivable $ 6488
Cash
( to resinstate customer Account )
$ 6488
Loan $ 9288
Cash
( to record loan repayment )
$ 9288
Interest Exp. $33
Cash
( to record interest exp.)
$33
Bank Service Charges Exp. $52

Cash
( to Bank service Charges )

$52

Related Solutions

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...
The bank reconciliation prepared by Gatz Company on May 31, 2017, appeared as follows: GATZ COMPANY...
The bank reconciliation prepared by Gatz Company on May 31, 2017, appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2017   Bank statement balance $9,264.35   Book balance $19,429.00      Add:      Deposit of May 31 in transit 949.00 $10,213.35   Deduct:   Deduct:      Outstanding cheques:   NSF cheque plus service          #876 $636.00     charge $11,530.65          #882 1,744.00 2,380.00   Bank service charge 65.00 11,595.65             Adjusted bank balance $7,833.35   Adjusted book balance $7,833.35 The Cash account in the General Ledger appeared as follows on June 30...
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....
Terry Zelinski, the owner of Tamarisk Mountain Tours, prepared the following trial balance at March 31,...
Terry Zelinski, the owner of Tamarisk Mountain Tours, prepared the following trial balance at March 31, 2021. Cash $12,740 Accounts receivable 2,420 Supplies 810 Equipment 7,370 Accounts payable $2,200 T. Zelinski, capital 23,900 T. Zelinski, drawings 3,630 Service revenue 6,950 Advertising expense 3,680 Salaries expense 380 Totals $34,350 $29,730 A review shows that Terry made the following errors in the accounting records: 1. A purchase of $600 of supplies on account was recorded as a credit to cash. The debit...
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank...
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank Reconciliation For the Month Ended June 30, 20Y7 Cash balance according to bank statement $16,185 Adjustments: Outstanding Check No.1067 $575 Outstanding Check No.1106 470 Outstanding Check No.1110 1,050 Outstanding Check No.1113 910 Deposit of June 30 not recorded by bank (6,600) Total adjustments (3,595) Adjusted balance $12,590 Cash balance according to company’s records $8,985 Adjustments: Proceeds of note collected by bank: Face value $6,000...
Problem 1: The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows....
Problem 1: The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows. WEEZ Ltd Bank Reconciliation 31 October 2017 Cash balance per bank Add: Deposits in transit $ 12 444.70   1 530.20 13 974.90 Less: Outstanding cheques Cheque number Cheque amount 2451 2470 2471 2472 2474 $ 1 260.40 720.10 844.50 503.60 1 050.00 4 378.60 Cash balance per the General Ledger $ 9 596.30 The November bank statement had a balance of $17 069.40 and...
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...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $8,260 Adjustments: Outstanding checks $3,960 Error by Chesner Co. in recording Check No. 1056 as $820 instead of $280 540 Note for $13,000 collected by bank, including interest 13,520 Deposit in transit on July 31 (8,410) Bank service charges (30) Total adjustments 9,580 Cash balance according to bank statement $17,840 a. From the data...
Bank reconciliation The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement,...
Bank reconciliation The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement, and is worried because the Adjusted Balance amounts do not agree. After reviewing the bank reconciliation, scroll down for the next steps in helping the intern. Murdstone Co. Bank Reconciliation January 31, 20Y5 1 Cash balance according to bank statement $23,557.98 2 Deduct deposit of May 31, not recorded by bank 12,125.25 3 $11,432.73 4 Add outstanding checks: 5 No. 124 $62.00 6 No....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT