word and excel files only.

1) The unadjusted cash account balance for Carson Company at December 31 is $12,615. The bank statement showed an ending balance of $18,250 at December 31. The following information is available from an examination of the bank statement and the company's accounting records:

Bank service charge $ 20

Outstanding checks 7,500

NSF check from a customer 425

Deposits in transit 1,222

Check #433 for the purchase of inventory was written correctly and paid by the bank correctly for $432, but was recorded on the books at $234. Carson uses the perpetual inventory system.

Required:

Prepare a bank reconciliation as of December 31.