| 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 | JANUARY 2024 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,408,831.86 | (1,940,851.42) | (723,480.21) | 685,351.65 | 0.00 | 685,351.65 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | (904,330.10) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | (90,890.81) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,408,831.86 | (2,936,072.33) | (723,480.21) | 685,351.65 | 0.00 | 685,351.65 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 5,124,108.73 | 3,045,895.52 | 974,615.91 | 6,098,724.64 | (2,225.75) | 6,096,498.89 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | 1,599,482.51 | 795,564.65 | 795,564.65 | (499,008.39) | 296,556.26 | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 1,774,237.82 | 490,292.98 | 1,099,369.01 | 2,873,606.83 | 0.00 | 2,873,606.83 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,898,346.55 | 5,135,671.01 | 2,869,549.57 | 9,767,896.12 | (501,234.14) | 9,266,661.98 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 91,525.21 | 429.16 | 1,999.69 | 93,524.90 | 0.00 | 93,524.90 | ||||||||||||||||||
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 | 93,025.21 | 429.16 | 1,999.69 | 95,024.90 | 0.00 | 95,024.90 | ||||||||||||||||||
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,400,404.02 | 2,200,027.84 | 2,148,069.05 | 10,548,473.07 | (501,234.14) | 10,047,238.93 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (8,170.06) | (492.30) | 1,333.77 | (6,836.29) | 0.00 | (6,836.29) | ||||||||||||||||||
22 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | 14,273.99 | 2,508.19 | 2,508.19 | (14,927.50) | (12,419.31) | ||||||||||||||||||
23 | Subtotal | 0000-2154-0000-00000-0 | (8,170.06) | 13,781.69 | 3,841.96 | (4,328.10) | (14,927.50) | (19,255.60) | ||||||||||||||||||
24 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 14,528.08 | (544.00) | (1,225.77) | 13,302.31 | 0.00 | 13,302.31 | ||||||||||||||||||
25 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | 65,289.00 | 66.51 | 66.51 | (65,291.00) | (65,224.49) | ||||||||||||||||||
26 | Subtotal | 0000-2156-0000-00000-0 | 14,528.08 | 64,745.00 | (1,159.26) | 13,368.82 | (65,291.00) | (51,922.18) | ||||||||||||||||||
27 | Subtotal | Liabilities | 6,358.02 | 78,526.69 | 2,682.70 | 9,040.72 | (80,218.50) | (71,177.78) | ||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | Fund Balances | |||||||||||||||||||||||||
30 | 001-0000-3111-0000-00000-0 | FUND BALANCE | (6,631,023.82) | 0.00 | 652,920.00 | (5,978,103.82) | 0.00 | (5,978,103.82) | ||||||||||||||||||
31 | 004-0000-3111-0000-00000-0 | FUND BALANCE | (1,775,738.22) | 0.00 | (652,920.00) | (2,428,658.22) | 0.00 | (2,428,658.22) | ||||||||||||||||||
32 | Subtotal | 0000-3111-0000-00000-0 | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | ||||||||||||||||||
33 | 001-0000-3321-0000-00000-0 | CASUALTY/LOSS CLEARIN | 0.00 | 10,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
34 | Subtotal | (8,406,762.04) | 10,000.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | |||||||||||||||||||
35 | ||||||||||||||||||||||||||
36 | Revenues | |||||||||||||||||||||||||
37 | Object 51xx | |||||||||||||||||||||||||
38 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 2,186,750.00 | 1,173,217.52 | 1,549,319.32 | 637,430.68 | 0.00 | 637,430.68 | 70.85 | |||||||||||||||||
39 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 666,710.00 | 357,598.65 | 472,235.09 | 194,474.91 | 0.00 | 194,474.91 | 70.83 | |||||||||||||||||
40 | Subtotal | 0000-5111-0000-00000-1 | 2,853,460.00 | 1,530,816.17 | 2,021,554.41 | 831,905.59 | 0.00 | 831,905.59 | 70.85 | |||||||||||||||||
41 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 192,940.00 | 25,087.74 | 105,891.92 | 87,048.08 | 0.00 | 87,048.08 | 54.88 | |||||||||||||||||
42 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 55,392.00 | 7,646.79 | 32,276.03 | 23,115.97 | 0.00 | 23,115.97 | 58.27 | |||||||||||||||||
43 | Subtotal | 0000-5112-0000-00000-1 | 248,332.00 | 32,734.53 | 138,167.95 | 110,164.05 | 0.00 | 110,164.05 | 55.64 | |||||||||||||||||
44 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,240,849.00 | 107,567.34 | 870,022.71 | 370,826.29 | 0.00 | 370,826.29 | 70.12 | |||||||||||||||||
45 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 531,792.00 | 35,855.78 | 290,007.58 | 241,784.42 | 0.00 | 241,784.42 | 54.53 | |||||||||||||||||
46 | Subtotal | 0000-5113-0000-00000-1 | 1,772,641.00 | 143,423.12 | 1,160,030.29 | 612,610.71 | 0.00 | 612,610.71 | 65.44 | |||||||||||||||||
47 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 2,090.94 | 2,090.94 | (1,990.94) | 0.00 | (1,990.94) | 2,090.94 | |||||||||||||||||
48 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 25,820.17 | 30,454.76 | 4,545.24 | 0.00 | 4,545.24 | 87.01 | |||||||||||||||||
49 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 0.00 | 2,441.93 | (1,941.93) | 0.00 | (1,941.93) | 488.39 | |||||||||||||||||
50 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 190,293.00 | 28,025.23 | 204,150.43 | (13,857.43) | 0.00 | (13,857.43) | 107.28 | |||||||||||||||||
51 | 002-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 0.00 | 257.25 | 343.05 | (343.05) | 0.00 | (343.05) | 0.00 | |||||||||||||||||
52 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 58,018.00 | 903.36 | 5,965.73 | 52,052.27 | 0.00 | 52,052.27 | 10.28 | |||||||||||||||||
53 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 29,185.84 | 210,459.21 | 37,851.79 | 0.00 | 37,851.79 | 84.76 | |||||||||||||||||
54 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 55,000.00 | 547.74 | 7,182.79 | 47,817.21 | 0.00 | 47,817.21 | 13.06 | |||||||||||||||||
55 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 15,000.00 | 872.25 | 6,507.53 | 8,492.47 | 0.00 | 8,492.47 | 43.38 | |||||||||||||||||
56 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 19.35 | 19.85 | 180.15 | 0.00 | 180.15 | 9.93 | |||||||||||||||||
57 | 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 | |||||||||||||||||
58 | 001-0000-5171-1050-00002-1 | SA HS GIRLS BB | 1,500.00 | 0.00 | 784.50 | 715.50 | 0.00 | 715.50 | 52.30 | |||||||||||||||||
59 | 001-0000-5171-1050-00004-1 | SA HS BOYS BB TOURN | 0.00 | 0.00 | 200.00 | (200.00) | 0.00 | (200.00) | 0.00 | |||||||||||||||||
60 | 004-0000-5171-1050-00004-1 | SA HS BOYS BB TOURN | 0.00 | 100.00 | 100.00 | (100.00) | 0.00 | (100.00) | 0.00 | |||||||||||||||||
61 | Subtotal | 0000-5171-1050-00004-1 | 0.00 | 100.00 | 300.00 | (300.00) | 0.00 | (300.00) | 0.00 | |||||||||||||||||
62 | 001-0000-5171-1050-00006-1 | SA HS FOOTBALL | 13,000.00 | 0.00 | 8,949.31 | 4,050.69 | 0.00 | 4,050.69 | 68.84 | |||||||||||||||||
63 | 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 | |||||||||||||||||
64 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
65 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
66 | 001-0000-5171-1050-00013-1 | SA HS VOLLEYBALL | 2,500.00 | 0.00 | 3,782.00 | (1,282.00) | 0.00 | (1,282.00) | 151.28 | |||||||||||||||||
67 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 100.00 | 4,545.00 | 5,455.00 | 0.00 | 5,455.00 | 45.45 | |||||||||||||||||
68 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 0.00 | 1,612.00 | (712.00) | 0.00 | (712.00) | 179.11 | |||||||||||||||||
69 | 001-0000-5171-3000-00002-1 | SA MS GIRLS BB | 1,000.00 | 0.00 | 1,602.00 | (602.00) | 0.00 | (602.00) | 160.20 | |||||||||||||||||
70 | 001-0000-5171-3000-00006-1 | SA MS FOOTBALL | 1,000.00 | 0.00 | 814.00 | 186.00 | 0.00 | 186.00 | 81.40 | |||||||||||||||||
71 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 1,090.00 | (290.00) | 0.00 | (290.00) | 136.25 | |||||||||||||||||
72 | 001-0000-5173-0000-00091-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 0.00 | 4,842.26 | (4,842.26) | 0.00 | (4,842.26) | 0.00 | |||||||||||||||||
73 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 840.00 | 4,118.50 | 881.50 | 0.00 | 881.50 | 82.37 | |||||||||||||||||
74 | 001-0000-5173-1050-00002-1 | SA HS GIRLS BB CLUB | 1,767.00 | 0.00 | 2,747.00 | (980.00) | 0.00 | (980.00) | 155.46 | |||||||||||||||||
75 | 001-0000-5173-1050-00003-1 | SA HS BB CHEER CLUB | 0.00 | 129.98 | 402.48 | (402.48) | 0.00 | (402.48) | 0.00 | |||||||||||||||||
76 | 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 | |||||||||||||||||
77 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 0.00 | 7,200.00 | (7,200.00) | 0.00 | (7,200.00) | 0.00 | |||||||||||||||||
78 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 0.00 | 4,361.87 | (1,880.87) | 0.00 | (1,880.87) | 175.81 | |||||||||||||||||
79 | 001-0000-5173-1050-00009-1 | SA HS GOLF CLUB REVEN | 0.00 | 0.00 | 180.00 | (180.00) | 0.00 | (180.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 | 10,254.45 | 35.55 | 0.00 | 35.55 | 99.65 | |||||||||||||||||
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 | 0.00 | 5,171.02 | (1,596.02) | 0.00 | (1,596.02) | 144.64 | |||||||||||||||||
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 | 0.00 | 915.68 | 606.32 | 0.00 | 606.32 | 60.16 | |||||||||||||||||
86 | 001-0000-5173-1050-00028-1 | SA HS ART CLUB | 1,147.00 | 0.00 | 210.00 | 937.00 | 0.00 | 937.00 | 18.31 | |||||||||||||||||
87 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 40.00 | 505.00 | 418.00 | 0.00 | 418.00 | 54.71 | |||||||||||||||||
88 | 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 | |||||||||||||||||
89 | 001-0000-5173-1050-00033-1 | SA HS TRACTION CLUB | 0.00 | 0.00 | 554.50 | (554.50) | 0.00 | (554.50) | 0.00 | |||||||||||||||||
90 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
91 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
92 | 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 | |||||||||||||||||
93 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 0.00 | 454.50 | (50.50) | 0.00 | (50.50) | 112.50 | |||||||||||||||||
94 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 47,232.00 | 0.00 | 20,453.26 | 26,778.74 | 0.00 | 26,778.74 | 43.30 | |||||||||||||||||
95 | 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 | |||||||||||||||||
96 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 0.00 | 467.00 | 533.00 | 0.00 | 533.00 | 46.70 | |||||||||||||||||
97 | 001-0000-5173-1050-00048-1 | SA HS SPEC LB CLUB | 841.00 | 0.00 | 113.99 | 727.01 | 0.00 | 727.01 | 13.55 | |||||||||||||||||
98 | 001-0000-5173-1050-00052-1 | SA HS SCIENCE CLUB | 1,005.00 | 0.00 | 395.00 | 610.00 | 0.00 | 610.00 | 39.30 | |||||||||||||||||
99 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 114.00 | 489.00 | (309.00) | 0.00 | (309.00) | 271.67 | |||||||||||||||||
100 | 001-0000-5173-1050-00060-1 | SA HS CLASS OF 27 | 23,757.00 | 340.00 | 390.00 | 23,367.00 | 0.00 | 23,367.00 | 1.64 |