Use the steps outlined on the Bank of the West bank statement page or reconciliation steps outline in the materials to complete the bank reconciliation for Glo White Florist.
ATM 1007 1008 Check Register Glo White Florist Number Dale Description of transaction De 41 Create 1/2 Ownervestment 125.000.00 1001 1/2 CB commercial $1.500.00 173 Cash for change 1250.00 1002 1/3 San Garry plants and supplies 125000 1003 1 State Farmin General la buty 11.500.00 T004 1/8 State Warban Compensation it Fund 150000 TOOS 11 Shenada Design-bon, Vases, supplies 500.00 1006 1/3 Howen Us Towers $1.000.00 1/3 Horal Tools R Us qui est 150000 ATM 1/ Once Depotice supplies 130.00 18 Vertroutinem-Phone & Internet 180.00 100 1/4 Huntington Beach Ford van 110 000 1010 15 Sales R Us - Register & Credit Card Machine 1600DD 1011 1/6 Refrigerators R Us -tengeration unit 12.500.00 1012 114 Hower Martens bons 11 500.00 1714 Daily Sales depost 1141631 1/15 Daily Sales de post 11 659.96 1714 Day Sate depost 1828.00 1013 1/16 Power Martens bons 11.328.00 1014 1/17 San Gatlary plants and supple 160000 1/17 Daily Sales deposit 1105111 1718 Oal Sales de post 1125010 1720 Daly sales de post 11161.00 1721 Daly Sales deposit 1163620 1015 1/20 Power Martens bons 11 20500 1/20 Customer Depost-Smith Wedding 11.000.00 1/22 Dalby Sales de post 1016 1723 Flower Mart fewer, vases, boes 1987 00 1723 Oal Sales deposit 11.02670 1:24 Daly sales de post 157146 1725 Daily Sales de post 1017 1:25 hower Mat Town, V3518 1875.50 1727 ay sales de post 110854 1/28 Daily Sales de post 1166110 1:29 Day Salut deposit 151246 1018 1/30 San Gabriel Narpants and oppler 356550 1019 1/31 Rower Martawan, boss 11.350.02 1/30 Daily Sales deposit 11.467.72 1/31 Oaly Sales depost $800.00 1/31 tramiteto Money Market 15.000.00 325.000.00 $23.500.00 121.250.00 123.000.00 121.500.00 12700.00 1230100 118208.00 117.00 11.00 111.220.00 122100 17.000 1500 11.620.00 15.03.31 SEE 22 37.52217 3.502.11 15.902.12 3953.2 11.2003 1833 111.COM 19.750 11.50 111 30 1163 11165100 112.60146 112.84233 113.072.33 114.1514 $15.322.50 115.735.00 11.165 112.013.50 115.2023 116.68724 1110T24 GLO WHITE FLORIST Daily In Shop Sales Log January Date Cut Flowers Arrangements Plants 13-Jan 345.00 450.00 150.00 14-Jan 412.00 810.00 50.00 15-Jan 250.00 362.50 25.00 16-Jan 503.75 132.00 5250 17-Jan 325.50 512.00 75.00 18-Jan 675.00 100.00 50.00 20-Jan 285.00 897.00 100.00 21-Jan 360.00 232.00 15.00 22-Jan 198.50 499.00 50 00 23-Jan 500.00 175.50 26.50 24-Jan 258.10 720.00 70.00 25-Jan 300.00 532.00 35.00 27-Jan 432.50 250.00 175.00 28-Jan 180.00 156.50 30.00 29-Jan 412.50 506.50 25.00 30-Jan 280.75 250.00 45.00 31.Jan 350.00 875.50 65.00 Gift Items Wire Orders Delivery 125.25 103.00 140.00 1,418.31 100.00 65.00 100.00 1,659.96 15.00 40.00 75.00 828.90 225.00 60.00 1,051.11 30.00 65.00 150.00 1.250.10 10.00 40.00 200.00 1.161.00 22.00 87.00 124.00 1,636 20 52.00 75.00 792.72 50.00 75.00 80.00 1.028.70 10.00 87.50 100.00 971.46 40.00 34.00 125.00 1.346.87 16.00 45.00 80.00 1,088.64 65.00 60.00 1.061.10 88.00 20.00 512.46 15.00 250.00 150.00 1,467.72 25.00 120.00 20.00 800.01 30.00 95.00 15.00 1,544.94 Money Market Account moniniy MONTH PREVIOUS BALANCE TOTAL DEPOSITS bank January $0.00 $5,000.00 YEAR ENDING BALANCE TOTAL WITHDRAWLS statement 2014 $5,000.00 $0.00 deposits deposit no withdrawals type date 1/31 date amount amount $5,000.00 $5,000.00 TOTAL TOTAL $0.00 General Checking Account monthly MONTH PREVIOUS BALANCE TOTAL DEPOSITS January $0.00 $44,075.26 bank YEAR ENDING BALANCE TOTAL WITHDRAWLS statement 2014 $13,002.76 $31,072.50 date 1/3 1/4 amount $250.00 N 1/5 1/6 $300.00 $1,500.00 $250.00 $1,500.00 $800.00 $500.00 5 1/7 1/8 deposits deposit no. date 1/2 1/14 1/15 1/16 1/17 1/18 1/20 1/21 1/22 10 1/20 11 1/23 12 1/24 13 1/25 14 1/27 15 1/28 1/9 1/10 1/11 amount $25,000.00 $1,418:31 $1,659.96 $828.90 $1,051,11 $1,250, 10 $1,161.00 $1,636.20 $792.72 $1,000.00 $1,028.70 $971.46 $1,346.87 $1,088.64 $1,061,10 $512.46 $1,467.72 $800.01 $44,075.26 withdrawals type ATM Debit Card check 1001 check 1002 check 1003 check 1004 check 1005 check 1006 check 1007 check 1008 check 1009 check 1010 check 1011 check 1012 check 1013 check 1014 check 1015 check 1016 check 1017 Transfer Online TOTAL 1/6 $1,000.00 $500.00 $180.00 $10,000.00 $600.00 1/5 1/8 1/8 $2,500.00 1/16 1/17 16 1/29 1/18 17 1/30 1/21 $1,500.00 $1,025.00 $600.00 $1,205.00 $987.00 $875.50 $5,000.00 $31,072.50 18 1731 1/25 TOTAL 1/27 1/31 COMPANY NAME: BANK RECONCILIATION FOR THE PERIOD ENDED: BALANCE PER BOOKS ADJUSTING ITEMS: ADJUSTED BOOK BALANCE BALANCE PER BANK LESS: OUTSTANDING CHECKS ADD: DEPOSITS IN TRANSIT OTHER ADJUSTMENTS: ADJUSTED BANK BALANCE OUTSTANDING CHECKS LIST: CHECK # AMOUNT CHECK # AMOUNT CHECK AMOUNT TOTAL ATM 1007 1008 Check Register Glo White Florist Number Dale Description of transaction De 41 Create 1/2 Ownervestment 125.000.00 1001 1/2 CB commercial $1.500.00 173 Cash for change 1250.00 1002 1/3 San Garry plants and supplies 125000 1003 1 State Farmin General la buty 11.500.00 T004 1/8 State Warban Compensation it Fund 150000 TOOS 11 Shenada Design-bon, Vases, supplies 500.00 1006 1/3 Howen Us Towers $1.000.00 1/3 Horal Tools R Us qui est 150000 ATM 1/ Once Depotice supplies 130.00 18 Vertroutinem-Phone & Internet 180.00 100 1/4 Huntington Beach Ford van 110 000 1010 15 Sales R Us - Register & Credit Card Machine 1600DD 1011 1/6 Refrigerators R Us -tengeration unit 12.500.00 1012 114 Hower Martens bons 11 500.00 1714 Daily Sales depost 1141631 1/15 Daily Sales de post 11 659.96 1714 Day Sate depost 1828.00 1013 1/16 Power Martens bons 11.328.00 1014 1/17 San Gatlary plants and supple 160000 1/17 Daily Sales deposit 1105111 1718 Oal Sales de post 1125010 1720 Daly sales de post 11161.00 1721 Daly Sales deposit 1163620 1015 1/20 Power Martens bons 11 20500 1/20 Customer Depost-Smith Wedding 11.000.00 1/22 Dalby Sales de post 1016 1723 Flower Mart fewer, vases, boes 1987 00 1723 Oal Sales deposit 11.02670 1:24 Daly sales de post 157146 1725 Daily Sales de post 1017 1:25 hower Mat Town, V3518 1875.50 1727 ay sales de post 110854 1/28 Daily Sales de post 1166110 1:29 Day Salut deposit 151246 1018 1/30 San Gabriel Narpants and oppler 356550 1019 1/31 Rower Martawan, boss 11.350.02 1/30 Daily Sales deposit 11.467.72 1/31 Oaly Sales depost $800.00 1/31 tramiteto Money Market 15.000.00 325.000.00 $23.500.00 121.250.00 123.000.00 121.500.00 12700.00 1230100 118208.00 117.00 11.00 111.220.00 122100 17.000 1500 11.620.00 15.03.31 SEE 22 37.52217 3.502.11 15.902.12 3953.2 11.2003 1833 111.COM 19.750 11.50 111 30 1163 11165100 112.60146 112.84233 113.072.33 114.1514 $15.322.50 115.735.00 11.165 112.013.50 115.2023 116.68724 1110T24 GLO WHITE FLORIST Daily In Shop Sales Log January Date Cut Flowers Arrangements Plants 13-Jan 345.00 450.00 150.00 14-Jan 412.00 810.00 50.00 15-Jan 250.00 362.50 25.00 16-Jan 503.75 132.00 5250 17-Jan 325.50 512.00 75.00 18-Jan 675.00 100.00 50.00 20-Jan 285.00 897.00 100.00 21-Jan 360.00 232.00 15.00 22-Jan 198.50 499.00 50 00 23-Jan 500.00 175.50 26.50 24-Jan 258.10 720.00 70.00 25-Jan 300.00 532.00 35.00 27-Jan 432.50 250.00 175.00 28-Jan 180.00 156.50 30.00 29-Jan 412.50 506.50 25.00 30-Jan 280.75 250.00 45.00 31.Jan 350.00 875.50 65.00 Gift Items Wire Orders Delivery 125.25 103.00 140.00 1,418.31 100.00 65.00 100.00 1,659.96 15.00 40.00 75.00 828.90 225.00 60.00 1,051.11 30.00 65.00 150.00 1.250.10 10.00 40.00 200.00 1.161.00 22.00 87.00 124.00 1,636 20 52.00 75.00 792.72 50.00 75.00 80.00 1.028.70 10.00 87.50 100.00 971.46 40.00 34.00 125.00 1.346.87 16.00 45.00 80.00 1,088.64 65.00 60.00 1.061.10 88.00 20.00 512.46 15.00 250.00 150.00 1,467.72 25.00 120.00 20.00 800.01 30.00 95.00 15.00 1,544.94 Money Market Account moniniy MONTH PREVIOUS BALANCE TOTAL DEPOSITS bank January $0.00 $5,000.00 YEAR ENDING BALANCE TOTAL WITHDRAWLS statement 2014 $5,000.00 $0.00 deposits deposit no withdrawals type date 1/31 date amount amount $5,000.00 $5,000.00 TOTAL TOTAL $0.00 General Checking Account monthly MONTH PREVIOUS BALANCE TOTAL DEPOSITS January $0.00 $44,075.26 bank YEAR ENDING BALANCE TOTAL WITHDRAWLS statement 2014 $13,002.76 $31,072.50 date 1/3 1/4 amount $250.00 N 1/5 1/6 $300.00 $1,500.00 $250.00 $1,500.00 $800.00 $500.00 5 1/7 1/8 deposits deposit no. date 1/2 1/14 1/15 1/16 1/17 1/18 1/20 1/21 1/22 10 1/20 11 1/23 12 1/24 13 1/25 14 1/27 15 1/28 1/9 1/10 1/11 amount $25,000.00 $1,418:31 $1,659.96 $828.90 $1,051,11 $1,250, 10 $1,161.00 $1,636.20 $792.72 $1,000.00 $1,028.70 $971.46 $1,346.87 $1,088.64 $1,061,10 $512.46 $1,467.72 $800.01 $44,075.26 withdrawals type ATM Debit Card check 1001 check 1002 check 1003 check 1004 check 1005 check 1006 check 1007 check 1008 check 1009 check 1010 check 1011 check 1012 check 1013 check 1014 check 1015 check 1016 check 1017 Transfer Online TOTAL 1/6 $1,000.00 $500.00 $180.00 $10,000.00 $600.00 1/5 1/8 1/8 $2,500.00 1/16 1/17 16 1/29 1/18 17 1/30 1/21 $1,500.00 $1,025.00 $600.00 $1,205.00 $987.00 $875.50 $5,000.00 $31,072.50 18 1731 1/25 TOTAL 1/27 1/31 COMPANY NAME: BANK RECONCILIATION FOR THE PERIOD ENDED: BALANCE PER BOOKS ADJUSTING ITEMS: ADJUSTED BOOK BALANCE BALANCE PER BANK LESS: OUTSTANDING CHECKS ADD: DEPOSITS IN TRANSIT OTHER ADJUSTMENTS: ADJUSTED BANK BALANCE OUTSTANDING CHECKS LIST: CHECK # AMOUNT CHECK # AMOUNT CHECK AMOUNT TOTAL
