Answer:
1. Adjusted cash balance = Adjusted bank statement balance = $133,620.
2. See the adjusting journal entries and explanation in part 2. below.
Explanation:
Note: The data in the question are merged and they are first sorted in the attached excel file before the questions are answered as follows:
1. Complete the bank reconciliation at December 31, 2019.
The bank reconciliation is presented in two ways as follows:
<u>a) Starting with cash book balance</u>
Gibson Energy Ltd.	
Bank Reconciliation  	
at 31 December 2019  
<u>Particulars                                                                  Amount ($)    </u>
Cash book bal. at 31 Dec. yet to be reconciled          62,000 
Add:  
Collected note receivable from XYZ Corp                  80,000 
Less:  
Dishonored NSF check                                                 (7,000)
Overdraft interest expense                                            (1,320)
Bank service charge                                                 <u>         (60)   </u>
Adjusted cash balance at Dec 31                           <u>   133,620   </u>
<u>b) Starting with bank statement balance</u>
Gibson Energy Ltd.	
Bank Reconciliation  	
at 31 December 2019  
<u>Particulars                                                                       Amount ($)    </u>
Bank statement bal. at Dec 31 yet to reconciled              131,620 
Add:  
Cash deposited on December 9th yet be credited          85,000 
Cash deposited on December 31 yet be credited            15,000 
Check #52094 wrongly drawn                                           62,000 
Less:  
Outstanding checks 233                                                    (83,000)
Outstanding checks 239                                                <u>    (77,000)   </u>
Adjusted bank statement balance at Dec. 31             <u>     133,620   </u>
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.
<u>Date      Accounts title & explanation              DR ($)           CR ($)  </u>
31 Dec 19    Cash                                                80,000  
                    Note Receivable                                                     78,049 
                    Interest on note receivable                                       1,951 
<em><u>                   (To record note receivable & int. collected from XYZ)     </u></em>
31 Dec 19   Overdraft interest expense                1,320
                   Service charge                                        60
                   Cash                                                                           1,380 
<em><u>                    (To record interest expense and bank charges)                   </u></em>
31 Dec 19   Account Receivable                           7,000
                     Cash                                                                           7,000
 <em><u>                   (To record NSF check dishonored)                                       </u></em>