A review of the March 30 bank statement and other data of Crane Aviation revealed a $16,864 balance at March 31 on the bank statement and $16,568 as the balance in the cash account in the companys ledger. In addition, the following information was determined:

As of March 31, prepare the bank reconciliation for the month of March

1.		NSF Check from J. Beiber in payment of account $186
2.		Collection of a customer electronic payment by the bank $2,288.
3.		Deposits in transit at March 31 $3,032.
4.		Outstanding checks at March 31 $1,812.
5.		A check written by Crane to Copytronics for a copy machine repair on March 13 was recorded at $1,320 but correctly cleared the bank at $1,230.
6.		A check drawn on the account of Halen Electronics for $676 was mistakenly charged against Cranes account by the bank.