| 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 | DECEMBER 2023 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,408,831.86 | 190,704.03 | 1,217,371.21 | 2,626,203.07 | (26,342.98) | 2,599,860.09 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 438,535.45 | 904,330.10 | 904,330.10 | (3,627.02) | 900,703.08 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 45,343.63 | 90,890.81 | 90,890.81 | 0.00 | 90,890.81 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,408,831.86 | 674,583.11 | 2,212,592.12 | 3,621,423.98 | (29,970.00) | 3,591,453.98 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 5,124,108.73 | (139,843.42) | (2,071,279.61) | 3,052,829.12 | (384,562.97) | 2,668,266.15 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (339,469.62) | (803,917.86) | (803,917.86) | (98,215.58) | (902,133.44) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 1,774,237.82 | (427,271.95) | 609,076.03 | 2,383,313.85 | (40,934.06) | 2,342,379.79 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,898,346.55 | (906,584.99) | (2,266,121.44) | 4,632,225.11 | (523,712.61) | 4,108,512.50 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 91,525.21 | 225.94 | 1,570.53 | 93,095.74 | 0.00 | 93,095.74 | ||||||||||||||||||
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 | 225.94 | 1,570.53 | 94,595.74 | 0.00 | 94,595.74 | ||||||||||||||||||
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 | (231,775.94) | (51,958.79) | 8,348,445.23 | (553,682.61) | 7,794,762.62 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | (453.30) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
22 | 002-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | (23,303.87) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
23 | Subtotal | 0000-2151-0000-00000-0 | 0.00 | (23,757.17) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
24 | 001-0000-2152-0000-00000-0 | SOC SEC PAYABLE | 0.00 | (442.46) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
25 | 002-0000-2152-0000-00000-0 | SOC SEC PAYABLE | 0.00 | (5,134.32) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
26 | Subtotal | 0000-2152-0000-00000-0 | 0.00 | (5,576.78) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
27 | 001-0000-2153-0000-00000-0 | ST INC TX PAYABLE | 0.00 | (103.48) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
28 | 002-0000-2153-0000-00000-0 | ST INC TX PAYABLE | 0.00 | (1,200.84) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
29 | Subtotal | 0000-2153-0000-00000-0 | 0.00 | (1,304.32) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
30 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (8,170.06) | (596.90) | 1,826.07 | (6,343.99) | (492.30) | (6,836.29) | ||||||||||||||||||
31 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | (12,329.89) | (11,765.80) | (11,765.80) | 14,273.99 | 2,508.19 | ||||||||||||||||||
32 | Subtotal | 0000-2154-0000-00000-0 | (8,170.06) | (12,926.79) | (9,939.73) | (18,109.79) | 13,781.69 | (4,328.10) | ||||||||||||||||||
33 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 14,528.08 | (549.77) | (681.77) | 13,846.31 | (544.00) | 13,302.31 | ||||||||||||||||||
34 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | 0.00 | (65,222.49) | (65,222.49) | 65,291.00 | 68.51 | ||||||||||||||||||
35 | Subtotal | 0000-2156-0000-00000-0 | 14,528.08 | (549.77) | (65,904.26) | (51,376.18) | 64,747.00 | 13,370.82 | ||||||||||||||||||
36 | Subtotal | Liabilities | 6,358.02 | (44,114.83) | (75,843.99) | (69,485.97) | 78,528.69 | 9,042.72 | ||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | Fund Balances | |||||||||||||||||||||||||
39 | 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) | ||||||||||||||||||
40 | 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) | ||||||||||||||||||
41 | Subtotal | 0000-3111-0000-00000-0 | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | ||||||||||||||||||
42 | 001-0000-3321-0000-00000-0 | CASUALTY/LOSS CLEARIN | 0.00 | 0.00 | (10,000.00) | (10,000.00) | 10,000.00 | 0.00 | ||||||||||||||||||
43 | Subtotal | (8,406,762.04) | 0.00 | (10,000.00) | (8,416,762.04) | 10,000.00 | (8,406,762.04) | |||||||||||||||||||
44 | ||||||||||||||||||||||||||
45 | Revenues | |||||||||||||||||||||||||
46 | Object 51xx | |||||||||||||||||||||||||
47 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 2,186,750.00 | 376,101.80 | 376,101.80 | 1,810,648.20 | 0.00 | 1,810,648.20 | 17.20 | |||||||||||||||||
48 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 666,710.00 | 114,636.44 | 114,636.44 | 552,073.56 | 0.00 | 552,073.56 | 17.19 | |||||||||||||||||
49 | Subtotal | 0000-5111-0000-00000-1 | 2,853,460.00 | 490,738.24 | 490,738.24 | 2,362,721.76 | 0.00 | 2,362,721.76 | 17.20 | |||||||||||||||||
50 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 192,940.00 | 12,334.54 | 80,804.18 | 112,135.82 | 0.00 | 112,135.82 | 41.88 | |||||||||||||||||
51 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 55,392.00 | 3,759.59 | 24,629.24 | 30,762.76 | 0.00 | 30,762.76 | 44.46 | |||||||||||||||||
52 | Subtotal | 0000-5112-0000-00000-1 | 248,332.00 | 16,094.13 | 105,433.42 | 142,898.58 | 0.00 | 142,898.58 | 42.46 | |||||||||||||||||
53 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,240,849.00 | 99,907.65 | 762,455.37 | 478,393.63 | 0.00 | 478,393.63 | 61.45 | |||||||||||||||||
54 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 531,792.00 | 33,302.55 | 254,151.80 | 277,640.20 | 0.00 | 277,640.20 | 47.79 | |||||||||||||||||
55 | Subtotal | 0000-5113-0000-00000-1 | 1,772,641.00 | 133,210.20 | 1,016,607.17 | 756,033.83 | 0.00 | 756,033.83 | 57.35 | |||||||||||||||||
56 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
57 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 4,451.26 | 4,634.59 | 30,365.41 | 0.00 | 30,365.41 | 13.24 | |||||||||||||||||
58 | 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 | |||||||||||||||||
59 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 190,293.00 | 25,997.08 | 176,125.20 | 14,167.80 | 0.00 | 14,167.80 | 92.55 | |||||||||||||||||
60 | 002-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 0.00 | 0.00 | 85.80 | (85.80) | 0.00 | (85.80) | 0.00 | |||||||||||||||||
61 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 58,018.00 | 917.03 | 5,062.37 | 52,955.63 | 0.00 | 52,955.63 | 8.73 | |||||||||||||||||
62 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 26,914.11 | 181,273.37 | 67,037.63 | 0.00 | 67,037.63 | 73.00 | |||||||||||||||||
63 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 55,000.00 | 1,577.47 | 6,635.05 | 48,364.95 | 0.00 | 48,364.95 | 12.06 | |||||||||||||||||
64 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 15,000.00 | 1,264.28 | 5,635.28 | 9,364.72 | 0.00 | 9,364.72 | 37.57 | |||||||||||||||||
65 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 0.00 | 0.50 | 199.50 | 0.00 | 199.50 | 0.25 | |||||||||||||||||
66 | 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 | |||||||||||||||||
67 | 001-0000-5171-1050-00002-1 | SA HS GIRLS BB | 1,500.00 | 784.50 | 784.50 | 715.50 | 0.00 | 715.50 | 52.30 | |||||||||||||||||
68 | 001-0000-5171-1050-00004-1 | SA HS BOYS BB TOURN | 0.00 | 200.00 | 200.00 | (200.00) | 0.00 | (200.00) | 0.00 | |||||||||||||||||
69 | 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 | |||||||||||||||||
70 | 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 | |||||||||||||||||
71 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
72 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
73 | 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 | |||||||||||||||||
74 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 0.00 | 4,445.00 | 5,555.00 | 0.00 | 5,555.00 | 44.45 | |||||||||||||||||
75 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 1,314.00 | 1,612.00 | (712.00) | 0.00 | (712.00) | 179.11 | |||||||||||||||||
76 | 001-0000-5171-3000-00002-1 | SA MS GIRLS BB | 1,000.00 | 1,602.00 | 1,602.00 | (602.00) | 0.00 | (602.00) | 160.20 | |||||||||||||||||
77 | 001-0000-5171-3000-00006-1 | SA MS FOOTBALL | 1,000.00 | 0.00 | 814.00 | 186.00 | 0.00 | 186.00 | 81.40 | |||||||||||||||||
78 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 1,090.00 | (290.00) | 0.00 | (290.00) | 136.25 | |||||||||||||||||
79 | 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 | |||||||||||||||||
80 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 3,278.50 | 1,721.50 | 0.00 | 1,721.50 | 65.57 | |||||||||||||||||
81 | 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 | |||||||||||||||||
82 | 001-0000-5173-1050-00003-1 | SA HS BB CHEER CLUB | 0.00 | 150.00 | 272.50 | (272.50) | 0.00 | (272.50) | 0.00 | |||||||||||||||||
83 | 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 | |||||||||||||||||
84 | 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 | |||||||||||||||||
85 | 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 | |||||||||||||||||
86 | 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 | |||||||||||||||||
87 | 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 | |||||||||||||||||
88 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 15.00 | 10,254.45 | 35.55 | 0.00 | 35.55 | 99.65 | |||||||||||||||||
89 | 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 | |||||||||||||||||
90 | 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 | |||||||||||||||||
91 | 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 | |||||||||||||||||
92 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 100.00 | 915.68 | 606.32 | 0.00 | 606.32 | 60.16 | |||||||||||||||||
93 | 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 | |||||||||||||||||
94 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 40.00 | 465.00 | 458.00 | 0.00 | 458.00 | 50.38 | |||||||||||||||||
95 | 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 | |||||||||||||||||
96 | 001-0000-5173-1050-00033-1 | SA HS TRACTION CLUB | 0.00 | 437.50 | 554.50 | (554.50) | 0.00 | (554.50) | 0.00 | |||||||||||||||||
97 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
98 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
99 | 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 | |||||||||||||||||
100 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 0.00 | 454.50 | (50.50) | 0.00 | (50.50) | 112.50 |