A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | M. H. GUEST PTA | |||||
2 | YEAR TO DATE CASH FLOW STATEMENT | |||||
3 | AS OF 6/4/2018 | |||||
4 | WITH BUDGET COMPARISONS | |||||
5 | ||||||
6 | 17-18 | 17-18 | 17-18 | 17-18 | ||
7 | YTD Actual | Budget | Variance | Reforecast | Notes | |
8 | INCOME | |||||
9 | Events - Family Fun | |||||
10 | Bingo Night | 265.00 | 600.00 | (335.00) | 265.00 | |
11 | Math Club | 691.65 | - | 691.65 | 691.65 | Self Funding |
12 | Family Dance Night (Annual) | - | - | - | ||
13 | Spring Carnival | 150.00 | 5,500.00 | (5,350.00) | 150.00 | |
14 | Ice Cream Social | - | - | - | ||
15 | Roller Skating Night | - | - | - | ||
16 | Variety Show | - | - | - | ||
17 | Volleyball Game vs. Glengary | 1,858.13 | 2,000.00 | (141.87) | 1,858.13 | |
18 | Fundraising Projects | |||||
19 | Book Fair | 2,097.74 | 6,250.00 | (4,152.26) | 2,097.74 | |
20 | Box Tops | 1,172.00 | 1,500.00 | (328.00) | 1,172.00 | |
21 | Detroit Red Wings/Tigers Event | 1,510.00 | 1,500.00 | 10.00 | 1,510.00 | |
22 | Display My Art | 650.00 | (650.00) | 650.00 | ||
23 | Fall Fundraiser | 11,575.48 | 12,000.00 | -424.52 | 11,575.48 | |
24 | Holiday Bizarre and Craft Sale | 325.00 | 1,000.00 | (675.00) | 325.00 | |
25 | Lifetime Fitness Fundraiser | 1,090.00 | - | 1,090.00 | 1,090.00 | |
26 | Hungry Howie Fundraiser | 3,536.00 | 5,700.00 | (2,164.00) | 3,536.00 | |
27 | School Mall | 1,164.58 | 1,300.00 | (135.42) | 1,164.58 | |
28 | School Rebate Program | 501.26 | 750.00 | (248.74) | 501.26 | |
29 | Spirit wear | 710.00 | 600.00 | 110.00 | 710.00 | |
30 | Walking Track Fund | 3,186.58 | - | 3,186.58 | 3,186.58 | |
31 | Services | |||||
32 | Directory | - | - | - | Sponsors | |
33 | Membership Dues | 1,901.00 | 1,200.00 | 701.00 | 1,901.00 | |
34 | Interest Income | 1.26 | 5.00 | (3.74) | 1.26 | |
35 | ||||||
36 | TOTAL INCOME | 31,735.68 | 40,555.00 | (8,819.32) | 32,385.68 | |
37 | ||||||
38 | EXPENSES | |||||
39 | Administration | |||||
40 | Accounting & Auditing | 375.00 | 320.00 | (55.00) | 375.00 | Received approval in May meeting moving $55 from Bingo Night expense to Accounting & Auditing |
41 | Bank Service Charges | 49.81 | 70.00 | 20.19 | 49.81 | Received fee returned on 2 of 3 NSF checks. |
42 | Insurance | 490.00 | 490.00 | - | 490.00 | |
43 | Membership (PTA paid to state) | 1,024.00 | 700.00 | (324.00) | 1,024.00 | |
44 | Printing/Postage/Office Supplies | 50.00 | 50.00 | 50.00 | ||
45 | PTA Startup/Board Dec./Conventions | 26.63 | 150.00 | 123.37 | 26.63 | |
46 | PTSA Dues & MPTSA - Annual Fee | 190.00 | 175.00 | (15.00) | 190.00 | |
47 | Events - Student Services | |||||
48 | Assemblies | 1,750.00 | 3,000.00 | 1,250.00 | 1,750.00 | |
49 | Field Day - Grades 1-5 | 814.2 | 1,400.00 | 585.80 | 814.20 | |
50 | Field Trips | 1,358.22 | 2,841.78 | 1,483.56 | 1,358.22 | |
51 | Fifth Grade Camp Night Activity Support | 450.00 | 450.00 | 450.00 | ||
52 | Fifth Grade Celebration | 500.00 | 500.00 | 500.00 | ||
53 | Math Club Expenses | 380.18 | - | -380.18 | 380.18 | Self Funding |
54 | GRAND Event (Book Fair Event) | 60.33 | 250.00 | 189.67 | 60.33 | |
55 | Reflections/Reflections Celebration Night | 73.34 | 180.00 | 106.66 | 73.34 | |
56 | Run Club | 200.00 | 200.00 | 200.00 | ||
57 | Scholastic/Magazine Subscription for Student | 750.00 | 750.00 | 750.00 | $125 per grade level | |
58 | Spelling Bee & Geography Bee | 120.00 | 125.00 | 5.00 | 120.00 | |
59 | Fundraising Projects | |||||
60 | Book Fair Expense | 1,956.60 | 4,434.63 | 2,478.03 | 1,956.60 | |
61 | Box Tops | 150.00 | 150.00 | 150.00 | ||
62 | Display My Art | 100.00 | 100.00 | 100.00 | ||
63 | Fall Fundraiser | 4,358.76 | 4,500.00 | 141.24 | 4,358.76 | 500 for 1st Prize, 250 for 2nd Prize, 150 for 3rd Prize, |
64 | Holiday Bizarre and Craft Sale | 500.00 | 500.00 | |||
65 | Lifetime Fitness | 810.00 | - | -810.00 | 810.00 | |
66 | Hungry Howie Fundraiser | 1,528.00 | 4,500.00 | 2,972.00 | 1,528.00 | |
67 | Spirit wear | 535.25 | 600.00 | 64.75 | 535.25 | Zero Profit Expected |
68 | Walking Track Fund | - | - | |||
69 | Events - Family Fun | |||||
70 | Bingo Night | 54.95 | 245.00 | 190.05 | 54.95 | Received approval in May meeting moving $55 from Bingo Night expense to Accounting & Auditing |
71 | Family Dance Night (Annual) | 200.00 | 250.00 | 50.00 | 200.00 | |
72 | Ice Cream Social | 455.69 | 500.00 | 44.31 | 455.69 | |
73 | Roller Skating Night | - | - | - | ||
74 | Sports Fundraiser (Tigers/Red Wings/Pistons | 1,520.00 | 1,000.00 | (520.00) | 1,520.00 | |
75 | Spring Carnival | 2,476.51 | 3,000.00 | 523.49 | 2,476.51 | |
76 | Talent/Variety Show | 100.00 | 100.00 | 100.00 | ||
77 | Volleyball Game vs. Glengary | 828.64 | 1,000.00 | 171.36 | 828.64 | |
78 | Services - Other | |||||
79 | Annual School Enrichment Gift* | 6,312.13 | 10,150.79 | 3,838.66 | 12,480.73 | Amount Available from 2016/2017 - 9,953.05. Amount Earmarked - Field Game - 50 |
80 | Awards - PTA - Conferences | 252.31 | 250.00 | (2.31) | 252.31 | Got approval to up the budget via board e-mail approval |
81 | Directory | - | - | - | ||
82 | District Parenting Fair | 150.00 | 150.00 | 150.00 | ||
83 | Donations/Community Assistance/MLK Clebration | 150.00 | 250.00 | 100.00 | 150.00 | |
84 | Kindegarten Orientation | 68.59 | 75.00 | 6.41 | 68.59 | |
85 | Literacy Library | 1,500.00 | 1,500.00 | 1,500.00 | ||
86 | Parent Communicator Folders | 537.50 | 560.00 | 22.50 | 537.50 | |
87 | Scholarships (Students in Need) | 107.50 | 215.00 | 107.50 | 107.50 | Received board e-mail approval to move 35 to 5th Grade Camp Scholarship in budget. Received approval in May meeting to allocate up to 200 for Art Camp Scholarships |
88 | Scholarships for 5th Grade Camp | 535.00 | 535.00 | - | 535.00 | Received board e-mail approval to move 35 from Scholarship in budget. |
89 | Scholarships for Music Camp | 215.00 | 250.00 | 35.00 | 215.00 | |
90 | Staff Appreciation Week | 978.07 | 1,000.00 | 21.93 | 978.07 | |
91 | Sunshine Fund/Crisis (cards, gifts, etc.) | 50.00 | 50.00 | 50.00 | ||
92 | Support for Teacher Submitted Grants | 250.00 | 250.00 | 250.00 | 3/5/2018 - Voted to provide Barb O. with support for Grant money. | |
93 | Teacher of the Year | 250.00 | 250.00 | - | 250.00 | |
94 | Teacher Fund | $3,300.29 | $3,800.00 | $499.71 | $3,300.29 | |
95 | TOTAL EXPENSES | 34,142.50 | 51,817.20 | 17,174.70 | 45,061.10 | |
96 | ||||||
97 | Net Income/(Loss) | (2,406.82) | (11,262.20) | (25,994.02) | (12,675.42) | |
98 | Beginning Cash: | 15,675.42 | 15,675.42 | 15,675.42 | ||
99 | Balance Sheet Adjustments: | |||||
100 | Accrual Adjustments: |