The bank reconciliation prepared by Gatz Company on May 31, 2017, appeared as follows: GATZ COMPANY Bank Reconciliation May...

90.2K

Verified Solution

Question

Accounting

The bank reconciliation prepared by Gatz Company on May 31,2017, appeared as follows:

GATZ COMPANY
Bank Reconciliation
May 31, 2017
  Bank statementbalance$9,264.35  Book balance$19,429.00  
  Add:
     Deposit of May 31 in transit949.00
$10,213.35
  Deduct:  Deduct:
     Outstanding cheques:  NSF cheque plusservice
         #876$636.00    charge$11,530.65
         #8821,744.002,380.00  Bank servicecharge65.0011,595.65
         
  Adjusted bankbalance$7,833.35
  Adjusted bookbalance$7,833.35


The Cash account in the General Ledger appeared as follows on June30 (Gatz uses only a General Journal to recordtransactions):

CashAcct. No.101
DateExplanationPRDebitCreditBalance
2017
May 31  Balance7,833.35  
June 1  Cheque #883GJ161,847.005,986.35  
        1  Cheque #884GJ16107.005,879.35  
        3  Cheque #885GJ16618.005,261.35  
       4  Cheque #886GJ161,917.003,344.35  
       9  DepositGJ164,579.007,923.35  
      12  Cheque #887GJ16425.157,498.20  
      12  Cheque #888GJ163,138.004,360.20  
      12  Cheque #889GJ16936.003,424.20  
      18  DepositGJ163,879.007,303.20  
      20  Cheque #890GJ162,537.004,766.20  
      21  Cheque #891GJ161,406.243,359.96  
      24  Cheque #892GJ162,492.00867.96  
      26  Cheque #893GJ1671.00796.96  
      29  DepositGJ161,745.002,541.96  


The following bank statement is available for June:

Bank Statement
  To: GatzCompanyJune 30, 2017
Bank of Montreal
Cheques/ChargesDeposits/CreditsBalance
05/319,264.35
#88406/01107.0006/01  949.0010,106.35
#88306/041,847.008,259.35
#87606/09636.0006/094,579.0012,202.35
#88906/12936.0011,266.35
#88206/141,744.009,522.35
#88706/18245.1506/183,879.0013,156.20
#88506/20618.0012,538.20
#89106/211,046.2411,491.96
#88606/291,917.009,574.96
SC06/3072.0006/309,502.96
NSF = Not Sufficient
          Funds
SC = Service
         Charge
PMT = Principal
           Payment
INT = Interest


Required:
a.
Prepare a bank reconciliation at June 30, 2017. Assumethat any errors made were by the book keeper (cheque #887 was foroffice supplies; cheque #891 was for utilities expense).(Round the final answers to the nearest cent.)

GATZ COMPANY
Bank Reconciliation
June 30, 2017
Bank StatementCompany's Books
Bankstatement balanceBookbalance
Add:Add:
$0.00$0.00
Deduct:Deduct:
Outstanding cheques:
0.00
Adjusted bank balanceAdjusted book balance

b. Prepare the necessary entries resulting fromthe bank reconciliation.

Journal entry worksheet

Record to account for error in Cheque #887.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Jun 30

Journal entry worksheet

Record to account for error in Cheque #891.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Jun 30

Journal entry worksheet

Record bank service charges for June.

Note: Enter debits before credits.

DateGeneral JournalDebitCredit
Jun 30

Answer & Explanation Solved by verified expert
4.0 Ratings (537 Votes)
Bank Reconcilation Statement as on june 30 before passing rectification entries GATZ COMPANY Bank Reconciliation June 30 2017 Bank Statement Companys Books Bank statement balance 950296 Book balance 254196 AddDeposit of june 30 in transit 1745 AddCheque issued but    See Answer
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 Gatz Company on May 31,2017, appeared as follows:GATZ COMPANYBank ReconciliationMay 31, 2017  Bank statementbalance$9,264.35  Book balance$19,429.00    Add:     Deposit of May 31 in transit949.00$10,213.35  Deduct:  Deduct:     Outstanding cheques:  NSF cheque plusservice         #876$636.00    charge$11,530.65         #8821,744.002,380.00  Bank servicecharge65.0011,595.65           Adjusted bankbalance$7,833.35  Adjusted bookbalance$7,833.35The Cash account in the General Ledger appeared as follows on June30 (Gatz uses only a General Journal to recordtransactions):CashAcct. No.101DateExplanationPRDebitCreditBalance2017May 31  Balance7,833.35  June 1  Cheque #883GJ161,847.005,986.35          1  Cheque #884GJ16107.005,879.35          3  Cheque #885GJ16618.005,261.35         4  Cheque #886GJ161,917.003,344.35         9  DepositGJ164,579.007,923.35        12  Cheque #887GJ16425.157,498.20        12  Cheque #888GJ163,138.004,360.20        12  Cheque #889GJ16936.003,424.20        18  DepositGJ163,879.007,303.20        20  Cheque #890GJ162,537.004,766.20        21  Cheque #891GJ161,406.243,359.96        24  Cheque #892GJ162,492.00867.96        26  Cheque #893GJ1671.00796.96        29  DepositGJ161,745.002,541.96  The following bank statement is available for June:Bank Statement  To: GatzCompanyJune 30, 2017Bank of MontrealCheques/ChargesDeposits/CreditsBalance05/319,264.35#88406/01107.0006/01  949.0010,106.35#88306/041,847.008,259.35#87606/09636.0006/094,579.0012,202.35#88906/12936.0011,266.35#88206/141,744.009,522.35#88706/18245.1506/183,879.0013,156.20#88506/20618.0012,538.20#89106/211,046.2411,491.96#88606/291,917.009,574.96SC06/3072.0006/309,502.96NSF = Not Sufficient          FundsSC = Service         ChargePMT = Principal           PaymentINT = InterestRequired:a. Prepare a bank reconciliation at June 30, 2017. Assumethat any errors made were by the book keeper (cheque #887 was foroffice supplies; cheque #891 was for utilities expense).(Round the final answers to the nearest cent.)GATZ COMPANYBank ReconciliationJune 30, 2017Bank StatementCompany's BooksBankstatement balanceBookbalanceAdd:Add:$0.00$0.00Deduct:Deduct:Outstanding cheques:0.00Adjusted bank balanceAdjusted book balanceb. Prepare the necessary entries resulting fromthe bank reconciliation.Journal entry worksheetRecord to account for error in Cheque #887.Note: Enter debits before credits.DateGeneral JournalDebitCreditJun 30Journal entry worksheetRecord to account for error in Cheque #891.Note: Enter debits before credits.DateGeneral JournalDebitCreditJun 30Journal entry worksheetRecord bank service charges for June.Note: Enter debits before credits.DateGeneral JournalDebitCreditJun 30

Other questions asked by students