| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Account Code | Account Description | Budget/ (Open Bal) | MTD Activity | YTD Activity | Current Balance | Encumbrance | Next MTD Activity | Projected Balance | % of Budget | ||||||||||||||||
2 | AUGUST 2024 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,748,546.12 | 257,864.34 | 543,473.13 | 2,292,019.25 | (26,700.91) | 2,265,318.34 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 457,618.18 | 933,922.03 | 933,922.03 | (1,062.36) | 932,859.67 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 59,837.45 | 120,433.80 | 120,433.80 | 0.00 | 120,433.80 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,748,546.12 | 775,319.97 | 1,597,828.96 | 3,346,375.08 | (27,763.27) | 3,318,611.81 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 4,786,614.99 | (215,121.51) | (315,951.22) | 4,470,663.77 | (177,140.01) | 4,293,523.76 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,033.64 | (586,793.48) | (634,248.81) | (632,215.17) | (6,544.47) | (638,759.64) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,437,140.40 | 8,742.87 | (13,912.42) | 2,423,227.98 | (14,050.00) | 2,409,177.98 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 7,225,789.03 | (793,172.12) | (964,112.45) | 6,261,676.58 | (197,734.48) | 6,063,942.10 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 68,158.14 | 314.73 | 182.09 | 68,340.23 | 0.00 | 68,340.23 | ||||||||||||||||||
13 | 004-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 1,500.00 | 0.00 | 0.00 | 1,500.00 | 0.00 | 1,500.00 | ||||||||||||||||||
14 | Subtotal | 0000-1114-0000-00000-0 | 69,658.14 | 314.73 | 182.09 | 69,840.23 | 0.00 | 69,840.23 | ||||||||||||||||||
15 | 001-0000-1132-0000-00000-0 | PETTY CASH | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | ||||||||||||||||||
16 | 004-0000-1151-0000-00000-0 | UMB Misc Cash | 8.20 | 0.00 | 0.00 | 8.20 | 0.00 | 8.20 | ||||||||||||||||||
17 | 004-0000-1152-0000-00000-0 | UMB Reserve Cash | (7.80) | 0.00 | 0.00 | (7.80) | 0.00 | (7.80) | ||||||||||||||||||
18 | Subtotal | Assets | 9,044,193.69 | (17,537.42) | 633,898.60 | 9,678,092.29 | (225,497.75) | 9,452,594.54 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | (2.00) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
22 | 002-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | (2,116.05) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
23 | Subtotal | 0000-2151-0000-00000-0 | 0.00 | (2,118.05) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
24 | 001-0000-2152-0000-00000-0 | SOC SEC PAYABLE | 0.00 | 176.70 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
25 | 001-0000-2153-0000-00000-0 | ST INC TX PAYABLE | 0.00 | 41.32 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
26 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (9,095.56) | 950.88 | 954.50 | (8,141.06) | (3,826.71) | (11,967.77) | ||||||||||||||||||
27 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (2,153.35) | (15,984.43) | (14,984.37) | (17,137.72) | 0.00 | (17,137.72) | ||||||||||||||||||
28 | Subtotal | 0000-2154-0000-00000-0 | (11,248.91) | (15,033.55) | (14,029.87) | (25,278.78) | (3,826.71) | (29,105.49) | ||||||||||||||||||
29 | 001-0000-2155-0000-00000-0 | Missouri Income Tax | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
30 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 13,886.57 | 4.21 | 4.21 | 13,890.78 | (23,416.33) | (9,525.55) | ||||||||||||||||||
31 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 119.71 | (65,486.69) | (65,486.69) | (65,366.98) | 0.00 | (65,366.98) | ||||||||||||||||||
32 | Subtotal | 0000-2156-0000-00000-0 | 14,006.28 | (65,482.48) | (65,482.48) | (51,476.20) | (23,416.33) | (74,892.53) | ||||||||||||||||||
33 | Subtotal | Liabilities | 2,757.37 | (82,414.06) | (79,512.35) | (76,754.98) | (27,243.04) | (103,998.02) | ||||||||||||||||||
34 | ||||||||||||||||||||||||||
35 | Fund Balances | |||||||||||||||||||||||||
36 | 001-0000-3111-0000-00000-0 | FUND BALANCE | (6,608,310.26) | 0.00 | 0.00 | (6,608,310.26) | 0.00 | (6,608,310.26) | ||||||||||||||||||
37 | 004-0000-3111-0000-00000-0 | FUND BALANCE | (2,438,640.80) | 0.00 | 0.00 | (2,438,640.80) | 0.00 | (2,438,640.80) | ||||||||||||||||||
38 | Subtotal | 0000-3111-0000-00000-0 | (9,046,951.06) | 0.00 | 0.00 | (9,046,951.06) | 0.00 | (9,046,951.06) | ||||||||||||||||||
39 | Subtotal | (9,046,951.06) | 0.00 | 0.00 | (9,046,951.06) | 0.00 | (9,046,951.06) | |||||||||||||||||||
40 | ||||||||||||||||||||||||||
41 | Revenues | |||||||||||||||||||||||||
42 | Object 51xx | |||||||||||||||||||||||||
43 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 2,425,342.00 | 0.00 | 0.03 | 2,425,341.97 | 0.00 | 2,425,341.97 | 0.00 | |||||||||||||||||
44 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 529,320.00 | 0.00 | 0.01 | 529,319.99 | 0.00 | 529,319.99 | 0.00 | |||||||||||||||||
45 | Subtotal | 0000-5111-0000-00000-1 | 2,954,662.00 | 0.00 | 0.04 | 2,954,661.96 | 0.00 | 2,954,661.96 | 0.00 | |||||||||||||||||
46 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 210,384.00 | 22,887.91 | 32,024.64 | 178,359.36 | 0.00 | 178,359.36 | 15.22 | |||||||||||||||||
47 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 43,610.00 | 5,509.01 | 8,293.90 | 35,316.10 | 0.00 | 35,316.10 | 19.02 | |||||||||||||||||
48 | Subtotal | 0000-5112-0000-00000-1 | 253,994.00 | 28,396.92 | 40,318.54 | 213,675.46 | 0.00 | 213,675.46 | 15.87 | |||||||||||||||||
49 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,300,010.00 | 160,735.20 | 329,040.47 | 970,969.53 | 0.00 | 970,969.53 | 25.31 | |||||||||||||||||
50 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 557,147.00 | 40,183.80 | 96,285.56 | 460,861.44 | 0.00 | 460,861.44 | 17.28 | |||||||||||||||||
51 | Subtotal | 0000-5113-0000-00000-1 | 1,857,157.00 | 200,919.00 | 425,326.03 | 1,431,830.97 | 0.00 | 1,431,830.97 | 22.90 | |||||||||||||||||
52 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
53 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 209.96 | 296.40 | 34,703.60 | 0.00 | 34,703.60 | 0.85 | |||||||||||||||||
54 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 0.00 | 0.00 | 500.00 | 0.00 | 500.00 | 0.00 | |||||||||||||||||
55 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 203,827.00 | 37,550.25 | 77,116.43 | 126,710.57 | 0.00 | 126,710.57 | 37.83 | |||||||||||||||||
56 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 44,484.00 | 1,025.65 | 1,436.80 | 43,047.20 | 0.00 | 43,047.20 | 3.23 | |||||||||||||||||
57 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 38,575.90 | 78,553.23 | 169,757.77 | 0.00 | 169,757.77 | 31.64 | |||||||||||||||||
58 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 75,000.00 | 2,435.63 | 2,435.63 | 72,564.37 | 0.00 | 72,564.37 | 3.25 | |||||||||||||||||
59 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 8,500.00 | 299.37 | 299.37 | 8,200.63 | 0.00 | 8,200.63 | 3.52 | |||||||||||||||||
60 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 4.00 | 4.00 | 196.00 | 0.00 | 196.00 | 2.00 | |||||||||||||||||
61 | 001-0000-5171-1050-00001-1 | SA HS BOYS BB | 3,000.00 | 0.00 | 0.00 | 3,000.00 | 0.00 | 3,000.00 | 0.00 | |||||||||||||||||
62 | 001-0000-5171-1050-00002-1 | SA HS GIRLS BB | 1,500.00 | 0.00 | 0.00 | 1,500.00 | 0.00 | 1,500.00 | 0.00 | |||||||||||||||||
63 | 001-0000-5171-1050-00005-1 | SA HS BASEBALL | 0.00 | 0.00 | 300.00 | (300.00) | 0.00 | (300.00) | 0.00 | |||||||||||||||||
64 | 001-0000-5171-1050-00006-1 | SA HS FOOTBALL | 13,000.00 | 0.00 | 0.00 | 13,000.00 | 0.00 | 13,000.00 | 0.00 | |||||||||||||||||
65 | 001-0000-5171-1050-00009-1 | SA HS GOLF REVENUE | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 | |||||||||||||||||
66 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
67 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 300.00 | (100.00) | 0.00 | (100.00) | 150.00 | |||||||||||||||||
68 | 001-0000-5171-1050-00013-1 | SA HS VOLLEYBALL | 2,500.00 | 0.00 | 0.00 | 2,500.00 | 0.00 | 2,500.00 | 0.00 | |||||||||||||||||
69 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 0.00 | 400.00 | 9,600.00 | 0.00 | 9,600.00 | 4.00 | |||||||||||||||||
70 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 0.00 | 0.00 | 900.00 | 0.00 | 900.00 | 0.00 | |||||||||||||||||
71 | 001-0000-5171-3000-00002-1 | SA MS GIRLS BB | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 | |||||||||||||||||
72 | 001-0000-5171-3000-00006-1 | SA MS FOOTBALL | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 | |||||||||||||||||
73 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 0.00 | 800.00 | 0.00 | 800.00 | 0.00 | |||||||||||||||||
74 | 001-0000-5173-0000-00099-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 4,707.41 | 7,207.41 | (7,207.41) | 0.00 | (7,207.41) | 0.00 | |||||||||||||||||
75 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 792.00 | 4,208.00 | 0.00 | 4,208.00 | 15.84 | |||||||||||||||||
76 | 001-0000-5173-1050-00002-1 | SA HS GIRLS BB CLUB | 1,767.00 | 0.00 | 0.00 | 1,767.00 | 0.00 | 1,767.00 | 0.00 | |||||||||||||||||
77 | 001-0000-5173-1050-00005-1 | SA HS BASEBALL CLUB | 4,302.00 | 0.00 | 0.00 | 4,302.00 | 0.00 | 4,302.00 | 0.00 | |||||||||||||||||
78 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 960.00 | 1,460.00 | (1,460.00) | 0.00 | (1,460.00) | 0.00 | |||||||||||||||||
79 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 0.00 | 0.00 | 2,481.00 | 0.00 | 2,481.00 | 0.00 | |||||||||||||||||
80 | 001-0000-5173-1050-00010-1 | SA HS SOCCER CLUB | 3,000.00 | 0.00 | 0.00 | 3,000.00 | 0.00 | 3,000.00 | 0.00 | |||||||||||||||||
81 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 0.00 | 0.00 | 10,290.00 | 0.00 | 10,290.00 | 0.00 | |||||||||||||||||
82 | 001-0000-5173-1050-00015-1 | SA HS SFB CLUB | 2,000.00 | 0.00 | 0.00 | 2,000.00 | 0.00 | 2,000.00 | 0.00 | |||||||||||||||||
83 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 2.84 | 1,520.23 | 2,054.77 | 0.00 | 2,054.77 | 42.52 | |||||||||||||||||
84 | 001-0000-5173-1050-00024-1 | SA HS SODA CLUB | 2,850.00 | 0.00 | 0.00 | 2,850.00 | 0.00 | 2,850.00 | 0.00 | |||||||||||||||||
85 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 600.00 | 600.00 | 922.00 | 0.00 | 922.00 | 39.42 | |||||||||||||||||
86 | 001-0000-5173-1050-00028-1 | SA HS ART CLUB | 1,147.00 | 0.00 | 0.00 | 1,147.00 | 0.00 | 1,147.00 | 0.00 | |||||||||||||||||
87 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 0.00 | 0.00 | 923.00 | 0.00 | 923.00 | 0.00 | |||||||||||||||||
88 | 001-0000-5173-1050-00032-1 | SA HS BAND CLUB | 5,998.00 | 0.00 | 0.00 | 5,998.00 | 0.00 | 5,998.00 | 0.00 | |||||||||||||||||
89 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
90 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
91 | 001-0000-5173-1050-00038-1 | SA HS DRAMA CLUB | 1,496.00 | 0.00 | 0.00 | 1,496.00 | 0.00 | 1,496.00 | 0.00 | |||||||||||||||||
92 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 0.00 | 0.00 | 404.00 | 0.00 | 404.00 | 0.00 | |||||||||||||||||
93 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 47,232.00 | 3,000.00 | 3,000.00 | 44,232.00 | 0.00 | 44,232.00 | 6.35 | |||||||||||||||||
94 | 001-0000-5173-1050-00041-1 | SA HS GRNHOUSE CLUB | 2,500.00 | 0.00 | 0.00 | 2,500.00 | 0.00 | 2,500.00 | 0.00 | |||||||||||||||||
95 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 | |||||||||||||||||
96 | 001-0000-5173-1050-00048-1 | SA HS SPEC LB CLUB | 841.00 | 19.69 | 19.69 | 821.31 | 0.00 | 821.31 | 2.34 | |||||||||||||||||
97 | 001-0000-5173-1050-00052-1 | SA HS SCIENCE CLUB | 1,005.00 | 0.00 | 0.00 | 1,005.00 | 0.00 | 1,005.00 | 0.00 | |||||||||||||||||
98 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 0.00 | 0.00 | 180.00 | 0.00 | 180.00 | 0.00 | |||||||||||||||||
99 | 001-0000-5173-1050-00060-1 | SA HS CLASS OF 27 | 23,757.00 | 0.00 | 0.00 | 23,757.00 | 0.00 | 23,757.00 | 0.00 | |||||||||||||||||
100 | 001-0000-5173-1050-00062-1 | SA HS CLASS OF 26 | 49,555.00 | 0.00 | 0.00 | 49,555.00 | 0.00 | 49,555.00 | 0.00 |