9. Bank reconciliation Use a spreadsheet program and the following information to complete a bank reconciliation. Use Figure 14-12 as an example. - On June 30 of the current year, the check register for Carson Consulting Company shows a balance of $35,184.64. - The bank statement dated June 25 shows a balance of $35,279.11. - You have identified one outstanding deposit of $450 made on June 26. - You have also identified two outstanding checks: No. 3478 for $150.98 and No. 3488 for $256.89. - The bank charged a service fee of $10.00. - The bank statement shows interest earned of $146.60