Prepare bank reconciliation and adjusting entries. The following information pertains to Lance Company. 1. Cash balance per bank, July 31,$9834. 2. July bank service charge not recorded by the depositor $85. 3. Cash balance per books, July 31,$9,687. 4. Deposits in transit, July 31,$5,600. 5. $4,598 collected from a customers for Lance Company in July by the bank through electronic funds transfer. The collection has not been recorded by Lance Company. 6. Outstanding checks, July 31,$1,234. Instructions a. Prepare a bank reconciliation at July 31, 2025. NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), into the yellow shaded input cells. a. a. LANCE COMPANY Bank Reconciliation July 31,2025 9834 85 9687 5600 4598 1234