| 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 2022 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,291,048.87 | 488,578.99 | 180,092.67 | 1,471,141.54 | 0.00 | 1,471,141.54 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 405,936.04 | 997,619.93 | 997,619.93 | 0.00 | 997,619.93 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 140,244.99 | 186,685.62 | 186,685.62 | 0.00 | 186,685.62 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,291,048.87 | 1,034,760.02 | 1,364,398.22 | 2,655,447.09 | 0.00 | 2,655,447.09 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 4,719,555.89 | (530,357.09) | (1,239,120.06) | 3,480,435.83 | 306.53 | 3,480,742.36 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (1,005,627.63) | (777,000.85) | (777,000.85) | 22,111.05 | (754,889.80) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,112,098.01 | (271,028.87) | 525,290.36 | 2,637,388.37 | 0.00 | 2,637,388.37 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,831,653.90 | (1,807,013.59) | (1,490,830.55) | 5,340,823.35 | 22,417.58 | 5,363,240.93 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 104,768.53 | (4,908.74) | (13,837.29) | 90,931.24 | 0.00 | 90,931.24 | ||||||||||||||||||
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 | (4,908.74) | (13,837.29) | 92,431.24 | 0.00 | 92,431.24 | ||||||||||||||||||
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 | (777,162.31) | (140,269.62) | 8,088,902.08 | 22,417.58 | 8,111,319.66 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | 306.53 | 306.53 | 306.53 | (306.53) | 0.00 | ||||||||||||||||||
22 | 002-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | 22,111.05 | 22,111.05 | 22,111.05 | (22,111.05) | 0.00 | ||||||||||||||||||
23 | Subtotal | 0000-2151-0000-00000-0 | 0.00 | 22,417.58 | 22,417.58 | 22,417.58 | (22,417.58) | 0.00 | ||||||||||||||||||
24 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 10,123.79 | (3,109.23) | (2,062.76) | 8,061.03 | 0.00 | 8,061.03 | ||||||||||||||||||
25 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | (21,715.60) | (25,371.18) | (25,371.18) | 0.00 | (25,371.18) | ||||||||||||||||||
26 | Subtotal | 0000-2154-0000-00000-0 | 10,123.79 | (24,824.83) | (27,433.94) | (17,310.15) | 0.00 | (17,310.15) | ||||||||||||||||||
27 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 16,172.08 | 544.00 | 186.00 | 16,358.08 | 0.00 | 16,358.08 | ||||||||||||||||||
28 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | (62,339.63) | (62,795.63) | (62,795.63) | 0.00 | (62,795.63) | ||||||||||||||||||
29 | Subtotal | 0000-2156-0000-00000-0 | 16,172.08 | (61,795.63) | (62,609.63) | (46,437.55) | 0.00 | (46,437.55) | ||||||||||||||||||
30 | Subtotal | Liabilities | 26,295.87 | (64,202.88) | (67,625.99) | (41,330.12) | (22,417.58) | (63,747.70) | ||||||||||||||||||
31 | ||||||||||||||||||||||||||
32 | Fund Balances | |||||||||||||||||||||||||
33 | 001-0000-3111-0000-00000-0 | FUND BALANCE | (6,142,869.16) | 0.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) | 0.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 | 60,297.00 | 172,016.84 | 173,016.84 | 0.00 | 173,016.84 | ||||||||||||||||||
37 | Subtotal | (8,255,467.57) | 60,297.00 | 172,016.84 | (8,083,450.73) | 0.00 | (8,083,450.73) | |||||||||||||||||||
38 | ||||||||||||||||||||||||||
39 | Revenues | |||||||||||||||||||||||||
40 | Object 51xx | |||||||||||||||||||||||||
41 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 2,150,902.00 | 314,951.71 | 314,951.71 | 1,835,950.29 | 0.00 | 1,835,950.29 | 14.64 | |||||||||||||||||
42 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 655,781.00 | 95,997.81 | 95,997.81 | 559,783.19 | 0.00 | 559,783.19 | 14.64 | |||||||||||||||||
43 | Subtotal | 0000-5111-0000-00000-1 | 2,806,683.00 | 410,949.52 | 410,949.52 | 2,395,733.48 | 0.00 | 2,395,733.48 | 14.64 | |||||||||||||||||
44 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 175,682.00 | 9,702.44 | 59,376.76 | 116,305.24 | 0.00 | 116,305.24 | 33.80 | |||||||||||||||||
45 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 50,397.00 | 2,957.33 | 18,142.61 | 32,254.39 | 0.00 | 32,254.39 | 36.00 | |||||||||||||||||
46 | Subtotal | 0000-5112-0000-00000-1 | 226,079.00 | 12,659.77 | 77,519.37 | 148,559.63 | 0.00 | 148,559.63 | 34.29 | |||||||||||||||||
47 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,081,106.00 | 99,909.59 | 661,630.34 | 419,475.66 | 0.00 | 419,475.66 | 61.20 | |||||||||||||||||
48 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 463,331.00 | 33,303.19 | 209,029.57 | 254,301.43 | 0.00 | 254,301.43 | 45.11 | |||||||||||||||||
49 | Subtotal | 0000-5113-0000-00000-1 | 1,544,437.00 | 133,212.78 | 870,659.91 | 673,777.09 | 0.00 | 673,777.09 | 56.37 | |||||||||||||||||
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 | 3,523.61 | 3,660.98 | 29,339.02 | 0.00 | 29,339.02 | 11.09 | |||||||||||||||||
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 | 22,355.34 | 94,401.94 | (10,259.94) | 0.00 | (10,259.94) | 112.19 | |||||||||||||||||
54 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 25,858.00 | 642.42 | 3,725.76 | 22,132.24 | 0.00 | 22,132.24 | 14.41 | |||||||||||||||||
55 | Subtotal | 0000-5141-0000-00000-1 | 110,000.00 | 22,997.76 | 98,127.70 | 11,872.30 | 0.00 | 11,872.30 | 89.21 | |||||||||||||||||
56 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 75,000.00 | 5,819.29 | 26,566.83 | 48,433.17 | 0.00 | 48,433.17 | 35.42 | |||||||||||||||||
57 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 12,000.00 | 1,196.00 | 8,272.51 | 3,727.49 | 0.00 | 3,727.49 | 68.94 | |||||||||||||||||
58 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 6.75 | 85.91 | 114.09 | 0.00 | 114.09 | 42.96 | |||||||||||||||||
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 | 4,427.00 | 15,141.14 | (2,141.14) | 0.00 | (2,141.14) | 116.47 | |||||||||||||||||
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 | 2,834.50 | (334.50) | 0.00 | (334.50) | 113.38 | |||||||||||||||||
66 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 1,115.00 | 4,675.00 | 5,325.00 | 0.00 | 5,325.00 | 46.75 | |||||||||||||||||
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 | 168.00 | 832.00 | 0.00 | 832.00 | 16.80 | |||||||||||||||||
69 | 001-0000-5171-3000-00006-1 | SA MS FOOTBALL | 1,000.00 | 0.00 | 1,739.80 | (739.80) | 0.00 | (739.80) | 173.98 | |||||||||||||||||
70 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 996.00 | (196.00) | 0.00 | (196.00) | 124.50 | |||||||||||||||||
71 | 001-0000-5173-0000-00024-1 | SA EA SODA CLUB | 0.00 | 0.00 | 454.00 | (454.00) | 0.00 | (454.00) | 0.00 | |||||||||||||||||
72 | 001-0000-5173-0000-00091-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 0.00 | 3,500.00 | (3,500.00) | 0.00 | (3,500.00) | 0.00 | |||||||||||||||||
73 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 590.00 | 2,250.00 | 2,750.00 | 0.00 | 2,750.00 | 45.00 | |||||||||||||||||
74 | 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 | |||||||||||||||||
75 | 001-0000-5173-1050-00003-1 | SA HS BB CHEER CLUB | 0.00 | 400.00 | 400.00 | (400.00) | 0.00 | (400.00) | 0.00 | |||||||||||||||||
76 | 001-0000-5173-1050-00005-1 | SA HS BASEBALL CLUB | 4,302.00 | 0.00 | 500.00 | 3,802.00 | 0.00 | 3,802.00 | 11.62 | |||||||||||||||||
77 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 4,762.00 | 23,582.00 | (23,582.00) | 0.00 | (23,582.00) | 0.00 | |||||||||||||||||
78 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 106.80 | 1,512.80 | 968.20 | 0.00 | 968.20 | 60.98 | |||||||||||||||||
79 | 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 | |||||||||||||||||
80 | 001-0000-5173-1050-00012-1 | SA HS TRACK CLUB REV | 0.00 | 0.00 | 361.00 | (361.00) | 0.00 | (361.00) | 0.00 | |||||||||||||||||
81 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 0.00 | 7,084.15 | 3,205.85 | 0.00 | 3,205.85 | 68.84 | |||||||||||||||||
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 | 4,047.40 | (472.40) | 0.00 | (472.40) | 113.21 | |||||||||||||||||
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 | 160.00 | 1,496.26 | 25.74 | 0.00 | 25.74 | 98.31 | |||||||||||||||||
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 | 40.00 | 465.00 | 458.00 | 0.00 | 458.00 | 50.38 | |||||||||||||||||
88 | 001-0000-5173-1050-00032-1 | SA HS BAND CLUB | 11,998.00 | 0.00 | 2,230.00 | 9,768.00 | 0.00 | 9,768.00 | 18.59 | |||||||||||||||||
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 | 235.00 | 169.00 | 0.00 | 169.00 | 58.17 | |||||||||||||||||
93 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 27,915.00 | 2,025.00 | 21,909.00 | 6,006.00 | 0.00 | 6,006.00 | 78.48 | |||||||||||||||||
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 | 380.00 | 620.00 | 0.00 | 620.00 | 38.00 | |||||||||||||||||
96 | 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 | |||||||||||||||||
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 | 360.00 | (180.00) | 0.00 | (180.00) | 200.00 | |||||||||||||||||
99 | 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 | |||||||||||||||||
100 | 001-0000-5173-1050-00061-1 | SA HS CLASS OF 24 | 0.00 | 480.00 | 2,857.00 | (2,857.00) | 0.00 | (2,857.00) | 0.00 |