creating a bank reconciliation for each example

1. Susie Ricardo uses checks rather than a debit card and records her transactions in her check register. The monthly bank statement shows a balance of $7,689.23 on March 1 of this year. The bank charged a service fee of $15. Susie's checking account register shows deposits of $824.66 and $1,231.65 that do not appear on the statement. Four checks recorded in the register did not clear the bank by the end of the month. These were written for $18.65; $95.00; $122.36; and $55.98. The register is showing a balance of $9,468.55. Complete a bank reconciliation form. 2. Mary Beth Groom uses a debit card for all purchases, and she keeps a register of all of her transactions. On November 1, Mary Beth received a bank statement that showed a $2,950 balance. Mary Beth showed a $4,010 account balance. Transaction No. 124 for $1,080, Transaction No. 138 for $720, and Transaction No. 140 for $370 are outstanding. A $3,200 deposit made on October 30 was in transit. The bank charged Mary Beth $12 for a service charge and $18 for the monthly service fee. Prepare a bank reconciliation 3. Amy Brown uses a debit card for all purchases, and she keeps a register of all of her transactions. On December 31, Amy's register showed an $8,195.32 balance. Brown's bank statement showed a balance of $8,400.50. Transaction No. 311 for $395.10 and Transaction No. 418 for $115.46 were outstanding. A $310.30 deposit was in transit. The bank charged a $10 service charge. The statement showed $14.92 earned interest income. Prepare a bank reconciliation 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 Wortsheet 4 1 CHECKING ACCOUNT RECONCILIANON 20 For the month of Accountholder Name(s) Type of Account 5 3 1. Ending balance shown on bank statement 0 Add up checks and withdrawals still oublanding Check Number Chuck Numbe or Date Amount Or Date Amount S 11 12 13 15 16 17 18 20 21 22 TOTAL 2. Deduct towalchucks/withdrawals still bublanding from bank balance 24 26 22 Add up deposiis salt outstanding Amount Amount 25 30 31 TOTALIS Add lou dois still outstanding lub 34 $ 86 A Adjusted Bank Balance (1+2+3) $ 38 showth buk 40 BINEw Chuckbook ( 45) w