creating bank reconcililiation statments

4. Candy Kane uses a checking account and records her transactions in her check register. On May 31, Candy's bank statement showed a balance of $9,900.50. A $1,315.80 deposit made on May 31 was in transit and check No. 314 for $48.50 and check No. 485 for $465.12 were outstanding. She also paid her taxes with check No. 410 in the amount of $1,200. Candy's bank charges were $10.20. Candy has a $9,512.88 checkbook balance. Prepare a bank reconciliation or the month of Accountholder Name(s) Type of Account Worksheet 4 1 CHECKING ACCOUNT RECONCILIATION 20 1. Ending balance shown on bank statement Mont Add up checks and withdrawals still outstanding Check Number Amount or Date Check Number or Dale Amount Costs $ a. Pri b. TC c.TK 7 Mor TOTAL 2. Deduct total checks withdrawals still outstanding from bank balance Add up deposits still outstanding Date Amount Date Amount TOTAL 3. Add total deposits still outstanding to bank balance A Adjusted Bank Balance (1 - 2 + 3) S 4. Ending balance shown in checkbook S 5. Deduct any bank service charges for the period + S 6. Add interest earned for the period B New Checkbook Balance (4 - 5+6) Note: Your account is reconciled when line A equals line B