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 $3$,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. (Learning Objective 4)