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 Balance
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.

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:

a) Starting with cash book balance

Gibson Energy Ltd.

Bank Reconciliation  

at 31 December 2019  

Particulars                                                                  Amount ($)    

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                                                         (60)  

Adjusted cash balance at Dec 31                             133,620  

b) Starting with bank statement balance

Gibson Energy Ltd.

Bank Reconciliation  

at 31 December 2019  

Particulars                                                                       Amount ($)    

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                                                    (77,000)  

Adjusted bank statement balance at Dec. 31                 133,620  

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.

Date      Accounts title & explanation              DR ($)           CR ($)  

31 Dec 19    Cash                                                80,000  

                   Note Receivable                                                     78,049

                   Interest on note receivable                                       1,951

                  (To record note receivable & int. collected from XYZ)    

31 Dec 19   Overdraft interest expense                1,320

                  Service charge                                        60

                  Cash                                                                           1,380

                   (To record interest expense and bank charges)                  

31 Dec 19   Account Receivable                           7,000

                    Cash                                                                           7,000

                  (To record NSF check dishonored)                                      

an online clothing brand

explanation: