please post answer in pdf or excel form :)

Assignment 4 CLO 5 East Square Company's bank statement for the month of December showed a balance per bank of $9,000. The company's Cash account in the general ledger had a balance of $7,460 at December 31. Other information is as follows: (1) Cash receipts for December 31 recorded on the company's books were $5,700 but this amount does not appear on the bank statement. (2) The bank statement shows a debit memorandum for $40 for check printing charges. (3) Check No. 5202 payable to Mann Company was recorded in the cash payments journal and cleared the bank for $248. A review of the accounts payable subsidiary ledger shows a $36 credit balance in the account of Mann Company and that the payment to them should have been for $284. (4) The total amount of checks still outstanding at December 31 amounted to $5,000. (5) A check was correctly written and paid by the bank for $410. The cash payment journal reflects an entry for check as a debit to Accounts Payable and a credit to Cash in Bank for \$490. (6) The bank returned an NSF check from a customer for $360. (7) The bank included a credit memorandum for $2,560 which represents collection of a customer's note by the bank for the company; principal amount of the note was $2,500 and interest was $60. Interest has not been accrued. Instructions (a) Prepare a bank reconciliation for East Square Company at December 31. (6 marks) (b) Prepare any adjusting entries necessary as a result of the bank reconciliation. (4 marks)