The bank reconciliation prepared by Gemma Tours on March 31, 2017, appeared as follows: Gemma Tours Bank Reconciliation March...

Free

60.1K

Verified Solution

Question

Accounting

The bank reconciliation prepared by Gemma Tours on March 31,2017, appeared as follows:

Gemma Tours
Bank Reconciliation
March 31, 2017
  Bank statementbalance$15,500  Book balance$34,257
  Add:
     Deposit of March 31 in transit22,044
$37,544
  Deduct:
     Outstanding cheques:
#79$1,306
#841,9813,287
  Adjusted bankbalance$34,257
  Adjusted bookbalance$34,257


The Cash account in the General Ledger appeared as follows on April30:

                  CashAcct. No.101
DateExplanationPRDebitCreditBalance
2017
March 31Balance34,257.00  
April 30CR1135,645.0069,902.00  
         30CD1445,533.0024,369.00  

A list of deposits made and cheques written during April, takenfrom the Cash Receipts Journal and Cash Disbursements Journal, isshown below:

Deposits Made
  April 7    $14,865.00
       13892.00
       1814,272.00
       23994.00
       271,981.00
       302,641.00
  Total April CashReceipts$35,645.00


Cheques Written
  No.91   $ 1,256
        925,475
        932,590
        943,613
        953,033
        961,895
        978,862
        983,033
        998,982
      1006,794
  Total April CashDisbursements$45,533


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

Bank Statement
  To:Gemma ToursApril 30, 2017
Bank of Montreal
Cheques/ChargesDeposits/CreditsBalance
15,500
#9304/022,50904/0322,04435,035
#9204/075,47504/0714,86544,425
#8404/131,98104/13    89243,336
NSF04/186,87604/1814,27250,732
#9504/233,03304/2399448,693
#9904/278,98204/27  1,98141,692
#9604/301,89504/30  2,64142,438
#9704/308,862INT      4633,622
#9404/303,61330,009
PMT04/309,86120,148
INT04/30    3520,113
SC04/30    5520,058
NSF = NotSufficient
Funds
SC =Service
      Charge
PMT =Principal
          Payment
INT =Interest


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

Required:
a.
Prepare a bank reconciliation at April 30.  

GEMMA TOURS
Bank Reconciliation
April 30, 2017
Bank StatementCompany's Books
Bankstatement balanceBookbalance
Add:Add:
0
00
Deduct:Deduct:
Outstanding cheques:
00
Adjusted bank balanceAdjusted book balance


b. Prepare the necessary journal entries tobring the General Ledger Cash account into agreement with theadjusted balance on the bank reconciliation.

Journal entry worksheet

Record interest earned.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Apr 30

Journal entry worksheet

Record to account for error in Cheque #93.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Apr 30

Journal entry worksheet

Record to reinstate customer account.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Apr 30

Journal entry worksheet

Record April loan payment.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Apr 30

Journal entry worksheet

Record April interest expense.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Apr 30

Journal entry worksheet

Record April bank charges.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Apr 30

Answer & Explanation Solved by verified expert
3.9 Ratings (472 Votes)

Chq number
#79 1306
#91 1256
#98 3033
#100 6794
Total 12389
1 Bank reconciliation
Ending balance as per bank statement 20058
Add Deposit in transit 0
Add Error by bank (750-570)
20058
Less Outstanding checks 12389
Adjusted bank balance 7669
Ending balance as per cash account 24369
Add Interest revenue 46
Error in chq 93 81 127
Less NSF 6876
Service charges 55
Interest expense 35
Principal payment 9861 16827
Adjusted cash balance 7669
Journal entry
Apr-30 Cash 46
          Interest revenue 46
Apr-30 Cash 81 (2590-2509)
          Delivery expense 81
Apr-30 Accounts receivable - laura 6876
          Cash 6876
Apr-30 Loan 9861
         Cash 9861
Apr-30 Interest expense 35
          Cash 35
Apr-30 Misc expense 55
          Cash 55

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The bank reconciliation prepared by Gemma Tours on March 31,2017, appeared as follows:Gemma ToursBank ReconciliationMarch 31, 2017  Bank statementbalance$15,500  Book balance$34,257  Add:     Deposit of March 31 in transit22,044$37,544  Deduct:     Outstanding cheques:#79$1,306#841,9813,287  Adjusted bankbalance$34,257  Adjusted bookbalance$34,257The Cash account in the General Ledger appeared as follows on April30:                  CashAcct. No.101DateExplanationPRDebitCreditBalance2017March 31Balance34,257.00  April 30CR1135,645.0069,902.00           30CD1445,533.0024,369.00  A list of deposits made and cheques written during April, takenfrom the Cash Receipts Journal and Cash Disbursements Journal, isshown below:Deposits Made  April 7    $14,865.00       13892.00       1814,272.00       23994.00       271,981.00       302,641.00  Total April CashReceipts$35,645.00Cheques Written  No.91   $ 1,256        925,475        932,590        943,613        953,033        961,895        978,862        983,033        998,982      1006,794  Total April CashDisbursements$45,533The following bank statement is available for April: (Note: Thebank deposits interest into the bank account at the end of everymonth.)Bank Statement  To:Gemma ToursApril 30, 2017Bank of MontrealCheques/ChargesDeposits/CreditsBalance15,500#9304/022,50904/0322,04435,035#9204/075,47504/0714,86544,425#8404/131,98104/13    89243,336NSF04/186,87604/1814,27250,732#9504/233,03304/2399448,693#9904/278,98204/27  1,98141,692#9604/301,89504/30  2,64142,438#9704/308,862INT      4633,622#9404/303,61330,009PMT04/309,86120,148INT04/30    3520,113SC04/30    5520,058NSF = NotSufficientFundsSC =Service      ChargePMT =Principal          PaymentINT =InterestIn reviewing cheques returned by the bank, the bookkeeperdiscovered that cheque #93, for delivery expense, was recorded inthe Cash Disbursements Journal incorrectly as $2,590. The NSFcheque was that of customer Laura Clark, deposited in April.Required:a. Prepare a bank reconciliation at April 30.  GEMMA TOURSBank ReconciliationApril 30, 2017Bank StatementCompany's BooksBankstatement balanceBookbalanceAdd:Add:000Deduct:Deduct:Outstanding cheques:00Adjusted bank balanceAdjusted book balanceb. Prepare the necessary journal entries tobring the General Ledger Cash account into agreement with theadjusted balance on the bank reconciliation.Journal entry worksheetRecord interest earned.Note: Enter debits before credits.DateGeneral JournalDebitCreditApr 30Journal entry worksheetRecord to account for error in Cheque #93.Note: Enter debits before credits.DateGeneral JournalDebitCreditApr 30Journal entry worksheetRecord to reinstate customer account.Note: Enter debits before credits.DateGeneral JournalDebitCreditApr 30Journal entry worksheetRecord April loan payment.Note: Enter debits before credits.DateGeneral JournalDebitCreditApr 30Journal entry worksheetRecord April interest expense.Note: Enter debits before credits.DateGeneral JournalDebitCreditApr 30Journal entry worksheetRecord April bank charges.Note: Enter debits before credits.DateGeneral JournalDebitCreditApr 30

Other questions asked by students