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 NSF check: Richard Nance Collection of $2,500 note plus interest $30 $2,530 $45 $425 $65 Interest earned on checking account Safety deposit box rent At September 30, deposits in transit were $5,450 and outstanding checks totaled $2,383. Instructions: (a) (b) Prepare the bank reconciliation at September 30 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 "?". a) MINTON COMPANY Bank Reconciliation September 30 Cash balance per bank statement Deposits in transit Value Add: Value ? Outstanding checks Value Less: Adjusted cash balance per bank ? Cash balance per books Value Add: Value Value ? Value Less: Value Value Adjusted cash balance per books ? b) Value Sept 30 Account Account Value Value Account Account Value 30 Value Account Account Value Account Value Value Account Value Account 30 30