Question

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 $ 15,700 Book balance $ 34,699
Add:
Deposit of March 31 in transit 22,328
38,028
Deduct:
Outstanding cheques:
#79 $ 1,322
#84 2,007 3,329
Adjusted bank balance $ 34,699 Adjusted book balance $ 34,699


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 34,699.00
April 30 CR11 36,101.00 70,800.00
30 CD14 46,073.00 24,727.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 $ 15,055.00
13 904.00
18 14,464.00
23 1,008.00
27 2,007.00
30 2,663.00
Total April Cash Receipts $ 36,101.00


Cheques Written
No. 91 $ 1,272
92 5,545
93 2,590
94 3,659
95 3,071
96 1,919
97 8,974
98 3,071
99 9,094
100 6,878
Total April Cash Disbursements $ 46,073


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
15,700
#93 04/02 2,509 04/03 22,328 35,519
#92 04/07 5,545 04/07 15,055 45,029
#84 04/13 2,007 04/13 904 43,926
NSF 04/18 6,972 04/18 14,464 51,418
#95 04/23 3,071 04/23 1,008 49,355
#99 04/27 9,094 04/27 2,007 42,268
#96 04/30 1,919 04/30 2,663 43,012
#97 04/30 8,974 INT 46 34,084
#94 04/30 3,659 30,425
PMT 04/30 9,987 20,438
INT 04/30 35 20,403
SC 04/30 55 20,348
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.

  • 1

    Record interest earned.

  • 2

    Record to account for error in Cheque #93.

  • 3

    Record to reinstate customer account.

  • 4

    Record April loan payment.

  • 5

    Record April interest expense.

  • 6

    Record April bank charges.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The bank reconciliation prepared by Arbour Glenn Apartments on October 31, 2013 is shown below: Arbour...
The bank reconciliation prepared by Arbour Glenn Apartments on October 31, 2013 is shown below: Arbour Glenn Apartments, Bank Reconciliation, October 31, 2013 Balance per bank statement           $      801.13 Balance per General Ledger     $   1,027.93      Add: Deposit of Oct 31 in transit        2,345.60        Add:              0.00       3,146.73 Deduct: Outstanding cheques: #417 -     $    58.30 #419 -         806.20 Less: October service charges           (18.00) #423 -      1,272.30      (2,136.80) Adjusted bank balance $   1,009.93 Adjusted general ledger balance $   1,009.93 The November...
Emerge Solutions Company deposits all receipts and makes all payments by cheque. The following information is...
Emerge Solutions Company deposits all receipts and makes all payments by cheque. The following information is available from the cash records: MARCH 31 BANK RECONCILIATION Balance per bank    $26,746 Add: Deposits in transit    2,100 Deduct: Outstanding cheques (3,800) Balance per books $25,046 Month of April Results Per Bank Per Books Balance April 30    $27,995 $27,355 April deposits 11,784 13,889 April cheques 11,100 10,080 April note collected (not included in April deposits) 3,000    0 April bank service...
SNM Sdn Bhd received its bank statement for the month of March 2020 from BCB Bank....
SNM Sdn Bhd received its bank statement for the month of March 2020 from BCB Bank. The bank statement shows a balance of RM520,200 while SNM Sdn Bhd cash book balance shows a balance of RM512,750 on 31 March 2020. A comparison of the bank statement with the cash book reveals the following information. Cheque number 1444 for RM2,000 and cheque number 1501 for RM2,900 are still outstanding on the 31 March 2020. The bank statement indicates that BCB Bank...
Question text Bank Reconciliation The bank reconciliation made by Winton, Inc., on August 31 showed: Deposit...
Question text Bank Reconciliation The bank reconciliation made by Winton, Inc., on August 31 showed: Deposit in transit of $2,560 Outstanding checks no.597 $1,660 no.603 $1,280 The reconciled cash balance on August 31 was $28,220 The following bank statement is available for September: Bank Statement TO Winton, Inc. September 30 St. Louis, MO STATE BANK Date Deposits No. Date Charges Date Balance Sept. 1 $2,560 597 Sept. 1 $1,660 Aug. 31 $28,600 2 2,240 607 5 3,700 Sept. 1 29,500...
Question 6.2                                         &n
Question 6.2                                                                           (Total: 15 marks; 5 marks per part) Emerge Solutions Company deposits all receipts and makes all payments by cheque. The following information is available from the cash records: MARCH 31 BANK RECONCILIATION Balance per bank                                                                                $26,746 Add: Deposits in transit                                                                          2,100 Deduct: Outstanding cheques                                                             (3,800) Balance per books                                                                               $25,046 Month of April Results Per Bank Per Books Balance April 30                                                                                  $27,995 $27,355 April deposits                                                                                         11,784 13,889 April cheques                                                                                         11,100 10,080 April note collected (not included in April deposits)...
The following information regarding cash for Alpha Company is provided for the month ending March 31,...
The following information regarding cash for Alpha Company is provided for the month ending March 31, 2016: Item Amount Ending Cash per Bank Statement Ending Cash per books $22,484 $14,794 Note collected by bank included interest of $106 $5,106 Bank Service Charges $35 Deposits in Transit $1,776 Outstanding Cheques $4,717 Customer Cheque returned NSF $322 Do the bank reconciliation in order to find the adjusted cash balance.
Exercise 7-9 Don Wyatt is unable to reconcile the bank balance at January 31. Don’s reconciliation...
Exercise 7-9 Don Wyatt is unable to reconcile the bank balance at January 31. Don’s reconciliation is as follows. Cash balance per bank $3,760.20 Add: NSF check 590.00 Less: Bank service charge 30.00 Adjusted balance per bank $4,320.20 Cash balance per books $4,075.20 Less: Deposits in transit 630.00 Add: Outstanding checks 935.00 Adjusted balance per books $4,380.20 Prepare a correct bank reconciliation. (List items that increase cash balance first. Reconcile cash balance per bank first. Round answers to 2 decimal...
Please Finish the following using Canadian Accounting version of Bank reconciliation statement: Neopolitan Ltd Bank Reconciliation...
Please Finish the following using Canadian Accounting version of Bank reconciliation statement: Neopolitan Ltd Bank Reconciliation July 31 Cash Balance Per Bank $10670 Add: Deposits in transit 1968 8702 Less: Outstanding Cheques 2359 Reconciled Cash balancer per bank 6343 Cash Balance Per Books Add: EFT collections on Account 1276 Less: NSF cheque and fee Bank Service Charge 40 Reconciled Cash Balance Per books                                                                USE THE FOLLOWING INFORMATION to complete or correct the above bank reconociliations statement The following information is...
1. Prepare the bank reconciliation statement as of April 30, 2020. (10) (a) The bank statement...
1. Prepare the bank reconciliation statement as of April 30, 2020. (10) (a) The bank statement balance is $18,900. (b) The cash account balance is $17,787. (c) Outstanding checks amounted to $8,000. (d) Deposits in transit from sales are $6,000. (e) The bank service charge is $60. (f) NSF Check from Customer Mike for $800. Check #2146 for $152, written to pay supplies expense, was incorrectly recorded in the books for $125.
Belbin’s Grocery Store developed the following information in recording its bank statement for the month of...
Belbin’s Grocery Store developed the following information in recording its bank statement for the month of March, 2017.            Balance per books March 31               $ 1,905            Balance per bank statement March 31 $11,400 1.    Cheques written in March but still outstanding $8,000. 2.    Cheques written in February but still outstanding $2,800. 3.    Deposits of March 30 and 31 not yet recorded by bank $5,200. 4.    NSF cheque of customer returned by bank $700. 5.    Cheque No. 210 for $594...