Ex 8.12 Prepare bank reconciliation and adjusting entries The information below relates to the Cash account in the ledger of Minton Company. Balance September 1 - $17,150, Cash deposited - $64,000. Balance September 30-$17,404; Checks written - $63,746. The September bank statement shows a balance of $16,422 on September 30 and the following memoranda. Credits Debits Collection of $2,500 note plus interest $30 $2,530 Interest earned on checking account NSF check: Richard Nance Safety deposit box rent $425 $65 $45 At September 30, deposits in transit were $5,450 and outstanding checks totaled $2,383. Instructions: (a) Prepare the bank reconciliation at September 30 (b) Prepare the adjusting entries at September 30, assuming (1) the NSF check was from a customer on account, and (2) no interest had been accrued on the note. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". MINTON COMPANY Bank Reconciliation September 30 Cash balance per bank statement Add: Less: Adjusted cash balance per bank Cash balance per books Add: Less: Adjusted cash balance per books (b) Prepare the adjusting entries at September 30, assuming (1) the NSF check was from a customer on account, and (2) no interest had been accrued on the note. Sept 30 30 30 30