E5-5 (Static) Preparing a Bank Reconciliation and Journal Entries and Reporting Cash [LO 5-4] [The following information applies to the questions displayed below.] Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 BANK STATEMENT Checks Deposits: $ 18,000 Other Balance: $ 7,200 25,200 $ 19,100 6,100 $ 30 6,070 6,070 Cash (A) Debit Credit June 1 June Balance Deposits June 30 Balance 6,800 19,000 6,400 19,400 Checks written June E5-5 (Static) Part 1 Required: 1. Prepare a bank reconciliation. A comparison of the checks written with the checks that have cleared the bank shows outstanding checks of $700. Some of the checks that cleared in June were written prior to June. No deposits in transit were noted in May, but a deposit is in transit at the end of June. Bank Statement Ending Balance per Bank Statement Additions: Deductions: HILLS COMPANY Bank Reconciliation June 30 Company's Books Ending Balance per Cash Account Additions: Deductions: Up-to-Date Cash Balance Up-to-Date Cash Balance: