In: Accounting
The following information has been gathered for Highgate Security for the month ended September 30, 2021: 1) The bank statement indicates a balance of $6,417. 2) The general ledger cash account indicates a balance of $5,422 on September 30, 2021. 3) There was an EFT deposit of $1,700 on the bank statement for the monthly rent from a tenant. 4) The bookkeeper had erroneously recorded a $100 cheque as $1,000. The cheque was to settle the account payable of Janex Supplies. 5) The bank statement revealed $50 in service charges. 6) Cheques #112 and #107 for $1,260 and $785 respectively did not appear on the bank statement. 7) A deposit made on September 29, 2021 for $2,900 did not appear on the bank statement. 8) A bank debit memo indicated an NSF cheque for $700 relating to the account receivable of Theodore Childress. Instructions a) Prepare a bank reconciliation for Highgate Security at September 30, 2021. b) Prepare all journal entries required for Highgate Security's September 30, 2021 bank reconciliation.
Bank Reconciliation Statement | ||||||
Balance as per bank statement | 6417 | |||||
Add: | ||||||
Deposits in transit | 2900 | |||||
Sub total | 9317 | |||||
Less: | ||||||
Outstanding checks | 2045 | |||||
Adjusted balance as per bank statement | 7272 | |||||
Balance as per Books | 5422 | |||||
Add: | ||||||
EFT rent deposit | 1700 | |||||
Wrongly recording of check | 900 | |||||
Sub total | 8022 | |||||
Less: | ||||||
Service charges | 50 | |||||
NSF check | 700 | |||||
Adjusted as per Books | 7272 | |||||
Journal entries | ||||||
S.no. | Accounts title and explanations | Debit $ | Credit $ | |||
a. | Cash | 1700 | ||||
Rent revenue | 1700 | |||||
(fo EFT transfer) | ||||||
b. | Cash | 900 | ||||
Accounts payable | 900 | |||||
(for wrongly recording the check) | ||||||
c. | Misc. expense | 50 | ||||
Cash | 50 | |||||
(for service charges) | ||||||
d. | Accounts receivable | 700 | ||||
Cash | 700 | |||||
(for NSF check) | ||||||