Using the following information, prepare a bank reconciliation for Charlie Company for July 31: (a) The bank statement balance is $14,872 (b) The cash account balance per books is $11,163. (c) Outstanding checks amounted to $5,904. (d) Deposits in transit are $2,201. (e) The bank service charge is $30. (f) A check for $1,226 for supplies was recorded as $1,262 in the ledger. Requirements: 1. Prepare a bank reconciliation for Charlie Company. 2. Prepare the journal entries required by Charlie Company to bring their cash balance at July 31 in agreement with the adjusted cash balance according to the bank reconciliation. Enter you answers to requirements 1 and 2 in the Text Box below.