Gibson Energy Ltd.'s general ledger account for Cash in Bank showed the following at December 31, 2019:                     Cash in Bank   Acct. No. 101               Balance DR (CR) Date   Description Folio Debit Credit Nov. 30   Balance (overdraft)       221,000 Dec. 1-31   Cash receipts CRJ10 813,000   1,034,000 Dec. 1-31   Cash Payments CDJ21   972,000 62,000                     December deposits made and checks issued were as follows:                       Deposits   Checks       Date Amount   No. Amount       Dec. 5 30,000   232 110,000       7 210,000   233 83,000       9 85,000   234 25,000       12 32,000   235 59,000       15 26,000   236 590,000       21 420,000   237 17,000       24 16,000   238 28,000       26 51,000   239 77,000       28 21,000             31 15,000               $813,000     $972,000                       The December bank statement showed:                         First Chartered Bank       Gibson Energy Ltd. Bank Statement       Month Ended December 31, 2019       Date Type Out In Balance       Dec. 3 Deposit   70,000 215,000       4 NR XYZ Corp.   80,000 295,000       5 Ck. 232 110,000   185,000       6 Ck. 231 70,000   115,000       6 Deposit   30,000 145,000       7 Deposit   210,000 355,000       10 Ck. 234 25,000   330,000       12 Ck. 236 590,000   (260,000)       13 Deposit   32,000 (228,000)       14 Ck. 52094* 62,000   (290,000)       14 NSF ABC. Inc. 7,000   (297,000)       15 Deposit   26,000 (271,000)       16 Ck. 238 28,000   (299,000)       17 Deposit   420,000 121,000       18 Ck. 235 59,000   62,000       20 Ck. 237 17,000   45,000       24 Deposit   16,000 61,000       26 Deposit   51,000 112,000       28 Deposit   21,000 133,000       31 OD int 1,320   131,680       31 SC 60   131,620       *drawn in error on Gibson's bank account         NR = note receivable collected from XYZ Corp. including interest of:         $1,951       NSF = not sufficient funds         SC = service charge             OD int = overdraft interest expense           Outstanding items at November 30, 2019 were as follows:         Nov. 30 deposit $70,000           Ck. 231   $70,000       Required:             1 Complete the bank reconciliation at December 31, 2019.                   2 Prepare the adjusting journal entries required to make the Cash in Bank account in the general ledger agree with the adjusted cash balance on the December 31 bank reconciliation. Include descriptions.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Gibson Energy Ltd.'s general ledger account for Cash in Bank showed the following at December 31, 2019:
               
    Cash in Bank   Acct. No. 101
              Balance DR (CR)
Date   Description Folio Debit Credit
Nov. 30   Balance (overdraft)       221,000
Dec. 1-31   Cash receipts CRJ10 813,000   1,034,000
Dec. 1-31   Cash Payments CDJ21   972,000 62,000
               
    December deposits made and checks issued were as follows:  
               
    Deposits   Checks  
    Date Amount   No. Amount  
    Dec. 5 30,000   232 110,000  
    7 210,000   233 83,000  
    9 85,000   234 25,000  
    12 32,000   235 59,000  
    15 26,000   236 590,000  
    21 420,000   237 17,000  
    24 16,000   238 28,000  
    26 51,000   239 77,000  
    28 21,000        
    31 15,000        
      $813,000     $972,000  
               
    The December bank statement showed:    
               
    First Chartered Bank  
    Gibson Energy Ltd. Bank Statement  
    Month Ended December 31, 2019  
    Date Type Out In Balance  
    Dec. 3 Deposit   70,000 215,000  
    4 NR XYZ Corp.   80,000 295,000  
    5 Ck. 232 110,000   185,000  
    6 Ck. 231 70,000   115,000  
    6 Deposit   30,000 145,000  
    7 Deposit   210,000 355,000  
    10 Ck. 234 25,000   330,000  
    12 Ck. 236 590,000   (260,000)  
    13 Deposit   32,000 (228,000)  
    14 Ck. 52094* 62,000   (290,000)  
    14 NSF ABC. Inc. 7,000   (297,000)  
    15 Deposit   26,000 (271,000)  
    16 Ck. 238 28,000   (299,000)  
    17 Deposit   420,000 121,000  
    18 Ck. 235 59,000   62,000  
    20 Ck. 237 17,000   45,000  
    24 Deposit   16,000 61,000  
    26 Deposit   51,000 112,000  
    28 Deposit   21,000 133,000  
    31 OD int 1,320   131,680  
    31 SC 60   131,620  
    *drawn in error on Gibson's bank account    
    NR = note receivable collected from XYZ Corp. including interest of:    
    $1,951  
    NSF = not sufficient funds    
    SC = service charge        
    OD int = overdraft interest expense      
    Outstanding items at November 30, 2019 were as follows:  
      Nov. 30 deposit $70,000    
      Ck. 231   $70,000    
  Required:          
  1 Complete the bank reconciliation at December 31, 2019.
               
  2 Prepare the adjusting journal entries required to make the Cash in Bank account in the general ledger agree with the adjusted cash balance on the December 31 bank reconciliation. Include descriptions.
   
   
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Cash Flow Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education