The Basil Trading Company's bank statem ent for the month of Novem ber showed a balance

per bank of $$6,450.$ The company's Cash account in the general ledger had a balance of

$$5,659$ at $30$ November. Other information is as follows:

Cash re cipts for $30$ November recorded on the company's books were $$2,650$ but this

amount does not appear on the bank statem ent.

The bank statement shows a debit m emorandum for $$95$ for bank adm inistration fees.

Cheque No$.119$ payable to Burns Company was recorded in the cash paym ents journal

and cleared the bank for $$248.$ A review of the accounts payable subsidiary ledger

shows a $$36$ credit balance in the account of Burns Company and that the payment to

them should have been for $$284.$

The total amount of cheques still outstanding at $30$ November am ounted to $$3,175.$

Cheque No$.142$ was correctly witten and paid by the bank for $$409.$ The cash payment

joumal reflects an entry for Cheque No$.142$ as a debit to Accounts P ayable and a credit

to Cash in Bank for $$680.$

The bank returned a dishonored cheque from a customer for $$1,060.$

The bank in duded a credit memorandum for $$1,150,$ which represents collection of a

customer's note by the bank for the company, principal amount of the note was $$1,100$

and interest was $$50.$ Interest has not been accrued.

Required: Prepare a bank reconciliation for the Basil Trading Company at $30$ Novem ber.

Ensure that you calculate and sho wthe adjusted cash account balance in the general ledger