| 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 2022 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,291,048.87 | 118,268.99 | 384,708.24 | 1,675,757.11 | (26,295.89) | 1,649,461.22 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 454,934.35 | 1,060,713.02 | 1,060,713.02 | (1,113.34) | 1,059,599.68 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 41,068.86 | 82,123.53 | 82,123.53 | 0.00 | 82,123.53 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,291,048.87 | 614,272.20 | 1,527,544.79 | 2,818,593.66 | (27,409.23) | 2,791,184.43 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 4,719,555.89 | (165,743.29) | (1,022,992.42) | 3,696,563.47 | (411,241.82) | 3,285,321.65 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (54,674.49) | (112,996.77) | (112,996.77) | (571,242.90) | (684,239.67) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,112,098.01 | (827,358.64) | (442,515.06) | 1,669,582.95 | (574,115.00) | 1,095,467.95 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,831,653.90 | (1,047,776.42) | (1,578,504.25) | 5,253,149.65 | (1,556,599.72) | 3,696,549.93 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 104,768.53 | 195.99 | 317.98 | 105,086.51 | 0.00 | 105,086.51 | ||||||||||||||||||
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 | 106,268.53 | 195.99 | 317.98 | 106,586.51 | 0.00 | 106,586.51 | ||||||||||||||||||
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 | 8,229,171.70 | (433,308.23) | (50,641.48) | 8,178,530.22 | (1,584,008.95) | 6,594,521.27 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 002-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | (4,480.39) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
22 | 001-0000-2152-0000-00000-0 | SOC SEC PAYABLE | 0.00 | 0.00 | 0.00 | 0.00 | (232.50) | (232.50) | ||||||||||||||||||
23 | 001-0000-2153-0000-00000-0 | ST INC TX PAYABLE | 0.00 | 0.00 | 0.00 | 0.00 | (54.38) | (54.38) | ||||||||||||||||||
24 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 10,123.79 | 304.25 | 240.82 | 10,364.61 | 0.00 | 10,364.61 | ||||||||||||||||||
25 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | (1,991.64) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
26 | Subtotal | 0000-2154-0000-00000-0 | 10,123.79 | (1,687.39) | 240.82 | 10,364.61 | 0.00 | 10,364.61 | ||||||||||||||||||
27 | 001-0000-2155-0000-00000-0 | Missouri Income Tax | 0.00 | 0.00 | 0.00 | 0.00 | (27.00) | (27.00) | ||||||||||||||||||
28 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 16,172.08 | 0.00 | 554.00 | 16,726.08 | 0.00 | 16,726.08 | ||||||||||||||||||
29 | 002-0000-2158-0000-00000-0 | TEA RETIRE PAYABLE | 0.00 | (22,593.18) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
30 | Subtotal | Liabilities | 26,295.87 | (28,760.96) | 794.82 | 27,090.69 | (313.88) | 26,776.81 | ||||||||||||||||||
31 | ||||||||||||||||||||||||||
32 | Fund Balances | |||||||||||||||||||||||||
33 | 001-0000-3111-0000-00000-0 | FUND BALANCE | (6,142,869.16) | 1,680.00 | 656,656.00 | (5,486,213.16) | 0.00 | (5,486,213.16) | ||||||||||||||||||
34 | 004-0000-3111-0000-00000-0 | FUND BALANCE | (2,113,598.41) | (1,680.00) | (656,656.00) | (2,770,254.41) | 0.00 | (2,770,254.41) | ||||||||||||||||||
35 | Subtotal | 0000-3111-0000-00000-0 | (8,256,467.57) | 0.00 | 0.00 | (8,256,467.57) | 0.00 | (8,256,467.57) | ||||||||||||||||||
36 | 001-0000-3321-0000-00000-0 | CASUALTY/LOSS CLEARIN | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | ||||||||||||||||||
37 | Subtotal | (8,255,467.57) | 0.00 | 0.00 | (8,255,467.57) | 0.00 | (8,255,467.57) | |||||||||||||||||||
38 | ||||||||||||||||||||||||||
39 | Revenues | |||||||||||||||||||||||||
40 | Object 51xx | |||||||||||||||||||||||||
41 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 1,966,808.00 | 0.00 | 0.00 | 1,966,808.00 | 0.00 | 1,966,808.00 | 0.00 | |||||||||||||||||
42 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 604,429.00 | 0.00 | 0.00 | 604,429.00 | 0.00 | 604,429.00 | 0.00 | |||||||||||||||||
43 | Subtotal | 0000-5111-0000-00000-1 | 2,571,237.00 | 0.00 | 0.00 | 2,571,237.00 | 0.00 | 2,571,237.00 | 0.00 | |||||||||||||||||
44 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 175,682.00 | 10,388.14 | 27,772.90 | 147,909.10 | 0.00 | 147,909.10 | 15.81 | |||||||||||||||||
45 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 50,397.00 | 3,166.32 | 8,509.70 | 41,887.30 | 0.00 | 41,887.30 | 16.89 | |||||||||||||||||
46 | Subtotal | 0000-5112-0000-00000-1 | 226,079.00 | 13,554.46 | 36,282.60 | 189,796.40 | 0.00 | 189,796.40 | 16.05 | |||||||||||||||||
47 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,081,106.00 | 117,613.16 | 255,779.51 | 825,326.49 | 0.00 | 825,326.49 | 23.66 | |||||||||||||||||
48 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 463,331.00 | 39,204.38 | 73,745.97 | 389,585.03 | 0.00 | 389,585.03 | 15.92 | |||||||||||||||||
49 | Subtotal | 0000-5113-0000-00000-1 | 1,544,437.00 | 156,817.54 | 329,525.48 | 1,214,911.52 | 0.00 | 1,214,911.52 | 21.34 | |||||||||||||||||
50 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
51 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 33,000.00 | 6.32 | 40.97 | 32,959.03 | 0.00 | 32,959.03 | 0.12 | |||||||||||||||||
52 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 0.00 | 0.00 | 500.00 | 0.00 | 500.00 | 0.00 | |||||||||||||||||
53 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 84,142.00 | 15,259.92 | 27,107.40 | 57,034.60 | 0.00 | 57,034.60 | 32.22 | |||||||||||||||||
54 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 25,858.00 | 656.72 | 1,670.15 | 24,187.85 | 0.00 | 24,187.85 | 6.46 | |||||||||||||||||
55 | Subtotal | 0000-5141-0000-00000-1 | 110,000.00 | 15,916.64 | 28,777.55 | 81,222.45 | 0.00 | 81,222.45 | 26.16 | |||||||||||||||||
56 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 75,000.00 | 1,915.32 | 1,915.32 | 73,084.68 | 0.00 | 73,084.68 | 2.55 | |||||||||||||||||
57 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 12,000.00 | 432.74 | 432.74 | 11,567.26 | 0.00 | 11,567.26 | 3.61 | |||||||||||||||||
58 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 4.65 | 4.65 | 195.35 | 0.00 | 195.35 | 2.33 | |||||||||||||||||
59 | 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 | |||||||||||||||||
60 | 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 | |||||||||||||||||
61 | 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 | |||||||||||||||||
62 | 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 | |||||||||||||||||
63 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
64 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
65 | 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 | |||||||||||||||||
66 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 0.00 | 0.00 | 10,000.00 | 0.00 | 10,000.00 | 0.00 | |||||||||||||||||
67 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 0.00 | 0.00 | 900.00 | 0.00 | 900.00 | 0.00 | |||||||||||||||||
68 | 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 | |||||||||||||||||
69 | 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 | |||||||||||||||||
70 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 0.00 | 800.00 | 0.00 | 800.00 | 0.00 | |||||||||||||||||
71 | 001-0000-5173-0000-00091-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 2,200.00 | 3,500.00 | (3,500.00) | 0.00 | (3,500.00) | 0.00 | |||||||||||||||||
72 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 540.00 | 4,460.00 | 0.00 | 4,460.00 | 10.80 | |||||||||||||||||
73 | 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 | |||||||||||||||||
74 | 001-0000-5173-1050-00005-1 | SA HS BASEBALL CLUB | 4,302.00 | 80.00 | 80.00 | 4,222.00 | 0.00 | 4,222.00 | 1.86 | |||||||||||||||||
75 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 13,125.00 | 13,125.00 | (13,125.00) | 0.00 | (13,125.00) | 0.00 | |||||||||||||||||
76 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 669.00 | 806.00 | 1,675.00 | 0.00 | 1,675.00 | 32.49 | |||||||||||||||||
77 | 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 | |||||||||||||||||
78 | 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 | |||||||||||||||||
79 | 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 | |||||||||||||||||
80 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 3,065.21 | 4,015.21 | (440.21) | 0.00 | (440.21) | 112.31 | |||||||||||||||||
81 | 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 | |||||||||||||||||
82 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 0.00 | 0.00 | 1,522.00 | 0.00 | 1,522.00 | 0.00 | |||||||||||||||||
83 | 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 | |||||||||||||||||
84 | 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 | |||||||||||||||||
85 | 001-0000-5173-1050-00032-1 | SA HS BAND CLUB | 11,998.00 | 0.00 | 0.00 | 11,998.00 | 0.00 | 11,998.00 | 0.00 | |||||||||||||||||
86 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
87 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
88 | 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 | |||||||||||||||||
89 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 0.00 | 0.00 | 404.00 | 0.00 | 404.00 | 0.00 | |||||||||||||||||
90 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 27,915.00 | 1,953.00 | 1,953.00 | 25,962.00 | 0.00 | 25,962.00 | 7.00 | |||||||||||||||||
91 | 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 | |||||||||||||||||
92 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 230.00 | 230.00 | 770.00 | 0.00 | 770.00 | 23.00 | |||||||||||||||||
93 | 001-0000-5173-1050-00048-1 | SA HS SPEC LB CLUB | 841.00 | 0.00 | 0.00 | 841.00 | 0.00 | 841.00 | 0.00 | |||||||||||||||||
94 | 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 | |||||||||||||||||
95 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 0.00 | 0.00 | 180.00 | 0.00 | 180.00 | 0.00 | |||||||||||||||||
96 | 001-0000-5173-1050-00060-1 | SA HS CLASS OF 22 | 23,757.00 | 0.00 | 0.00 | 23,757.00 | 0.00 | 23,757.00 | 0.00 | |||||||||||||||||
97 | 001-0000-5173-1050-00062-1 | SA HS CLASS OF 26 | 55,836.00 | 10.00 | 10.00 | 55,826.00 | 0.00 | 55,826.00 | 0.02 | |||||||||||||||||
98 | 001-0000-5173-1050-00066-1 | SA HS CLASS OF 23 | 9,120.00 | 50.00 | 50.00 | 9,070.00 | 0.00 | 9,070.00 | 0.55 | |||||||||||||||||
99 | 001-0000-5173-1050-00070-1 | SA HS BUSY HANDS CLUB | 4,825.00 | 0.00 | 0.00 | 4,825.00 | 0.00 | 4,825.00 | 0.00 | |||||||||||||||||
100 | 001-0000-5173-1050-00800-0 | SA EA SODA CLUB | 6,337.00 | 0.00 | 0.00 | 6,337.00 | 0.00 | 6,337.00 | 0.00 |