Prepare the bank reconciliation on excel at September 30th.

The information below relates to the Cash account in the ledger of Redding Company (16 points) Balance September 1-$35,725; Cash deposited$86,000. Balance September 30-$32,225; Checks written-$89,500. The September bank statement shows a balance of $35,375 on September 30 and the following memoranda Credits Collection of $5,250 note plus interest $50 Interest earned on checking account $5,300 $80 Debits NSF check: J. E. Hoover Safety deposit box rent $935 $175 At September 30, deposits in transit were $5,695, and outstanding checks totaled $4,575. Instructions Prepare the bank reconciliation at September 30