| 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 2023 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,291,048.87 | 229,057.71 | 409,150.38 | 1,700,199.25 | (26,499.02) | 1,673,700.23 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 553,148.24 | 1,550,768.17 | 1,550,768.17 | (3,392.18) | 1,547,375.99 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 40,958.19 | 227,643.81 | 227,643.81 | 0.00 | 227,643.81 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,291,048.87 | 823,164.14 | 2,187,562.36 | 3,478,611.23 | (29,891.20) | 3,448,720.03 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 4,719,555.89 | 1,084,330.48 | (154,789.58) | 4,564,766.31 | (285,078.11) | 4,279,688.20 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (34,606.56) | (811,607.41) | (811,607.41) | (503,483.96) | (1,315,091.37) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,112,098.01 | 181,201.15 | 706,491.51 | 2,818,589.52 | (661,634.10) | 2,156,955.42 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,831,653.90 | 1,230,925.07 | (259,905.48) | 6,571,748.42 | (1,450,196.17) | 5,121,552.25 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 104,768.53 | 347.09 | (13,490.20) | 91,278.33 | 0.00 | 91,278.33 | ||||||||||||||||||
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 | 347.09 | (13,490.20) | 92,778.33 | 0.00 | 92,778.33 | ||||||||||||||||||
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 | 2,054,436.30 | 1,914,166.68 | 10,143,338.38 | (1,480,087.37) | 8,663,251.01 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | (306.53) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
22 | 002-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | (22,111.05) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
23 | Subtotal | 0000-2151-0000-00000-0 | 0.00 | (22,417.58) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
24 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 10,123.79 | (342.01) | (2,404.77) | 7,719.02 | (3,604.55) | 4,114.47 | ||||||||||||||||||
25 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | 13,419.28 | (11,951.90) | (11,951.90) | (13,842.92) | (25,794.82) | ||||||||||||||||||
26 | Subtotal | 0000-2154-0000-00000-0 | 10,123.79 | 13,077.27 | (14,356.67) | (4,232.88) | (17,447.47) | (21,680.35) | ||||||||||||||||||
27 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 16,172.08 | 802.00 | 988.00 | 17,160.08 | (28,113.93) | (10,953.85) | ||||||||||||||||||
28 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | 62,339.63 | (456.00) | (456.00) | (62,339.63) | (62,795.63) | ||||||||||||||||||
29 | Subtotal | 0000-2156-0000-00000-0 | 16,172.08 | 63,141.63 | 532.00 | 16,704.08 | (90,453.56) | (73,749.48) | ||||||||||||||||||
30 | Subtotal | Liabilities | 26,295.87 | 53,801.32 | (13,824.67) | 12,471.20 | (107,901.03) | (95,429.83) | ||||||||||||||||||
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 | 34,959.55 | 206,976.39 | 207,976.39 | 46,967.99 | 254,944.38 | ||||||||||||||||||
37 | Subtotal | (8,255,467.57) | 34,959.55 | 206,976.39 | (8,048,491.18) | 46,967.99 | (8,001,523.19) | |||||||||||||||||||
38 | ||||||||||||||||||||||||||
39 | Revenues | |||||||||||||||||||||||||
40 | Object 51xx | |||||||||||||||||||||||||
41 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 2,150,902.00 | 1,386,974.00 | 1,701,925.71 | 448,976.29 | 0.00 | 448,976.29 | 79.13 | |||||||||||||||||
42 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 655,781.00 | 422,752.00 | 518,749.81 | 137,031.19 | 0.00 | 137,031.19 | 79.10 | |||||||||||||||||
43 | Subtotal | 0000-5111-0000-00000-1 | 2,806,683.00 | 1,809,726.00 | 2,220,675.52 | 586,007.48 | 0.00 | 586,007.48 | 79.12 | |||||||||||||||||
44 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 175,682.00 | 10,910.76 | 70,287.52 | 105,394.48 | 0.00 | 105,394.48 | 40.01 | |||||||||||||||||
45 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 50,397.00 | 3,325.61 | 21,468.22 | 28,928.78 | 0.00 | 28,928.78 | 42.60 | |||||||||||||||||
46 | Subtotal | 0000-5112-0000-00000-1 | 226,079.00 | 14,236.37 | 91,755.74 | 134,323.26 | 0.00 | 134,323.26 | 40.59 | |||||||||||||||||
47 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,081,106.00 | 108,038.10 | 769,668.44 | 311,437.56 | 0.00 | 311,437.56 | 71.19 | |||||||||||||||||
48 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 463,331.00 | 36,012.70 | 245,042.27 | 218,288.73 | 0.00 | 218,288.73 | 52.89 | |||||||||||||||||
49 | Subtotal | 0000-5113-0000-00000-1 | 1,544,437.00 | 144,050.80 | 1,014,710.71 | 529,726.29 | 0.00 | 529,726.29 | 65.70 | |||||||||||||||||
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 | 24,692.31 | 28,353.29 | 4,646.71 | 0.00 | 4,646.71 | 85.92 | |||||||||||||||||
52 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 202.75 | 202.75 | 297.25 | 0.00 | 297.25 | 40.55 | |||||||||||||||||
53 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 84,142.00 | 26,479.88 | 120,881.82 | (36,739.82) | 0.00 | (36,739.82) | 143.66 | |||||||||||||||||
54 | 002-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 0.00 | 226.28 | 226.28 | (226.28) | 0.00 | (226.28) | 0.00 | |||||||||||||||||
55 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 25,858.00 | 928.57 | 4,654.33 | 21,203.67 | 0.00 | 21,203.67 | 18.00 | |||||||||||||||||
56 | Subtotal | 0000-5141-0000-00000-1 | 110,000.00 | 27,634.73 | 125,762.43 | (15,762.43) | 0.00 | (15,762.43) | 114.33 | |||||||||||||||||
57 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 75,000.00 | 3,801.65 | 30,368.48 | 44,631.52 | 0.00 | 44,631.52 | 40.49 | |||||||||||||||||
58 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 12,000.00 | 1,152.09 | 9,424.60 | 2,575.40 | 0.00 | 2,575.40 | 78.54 | |||||||||||||||||
59 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 3.60 | 89.51 | 110.49 | 0.00 | 110.49 | 44.76 | |||||||||||||||||
60 | 001-0000-5171-1050-00001-1 | SA HS BOYS BB | 3,000.00 | 564.00 | 564.00 | 2,436.00 | 0.00 | 2,436.00 | 18.80 | |||||||||||||||||
61 | 001-0000-5171-1050-00002-1 | SA HS GIRLS BB | 1,500.00 | 903.00 | 903.00 | 597.00 | 0.00 | 597.00 | 60.20 | |||||||||||||||||
62 | 001-0000-5171-1050-00006-1 | SA HS FOOTBALL | 13,000.00 | 0.00 | 15,141.14 | (2,141.14) | 0.00 | (2,141.14) | 116.47 | |||||||||||||||||
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 | 2,834.50 | (334.50) | 0.00 | (334.50) | 113.38 | |||||||||||||||||
67 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 780.00 | 5,455.00 | 4,545.00 | 0.00 | 4,545.00 | 54.55 | |||||||||||||||||
68 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 491.00 | 491.00 | 409.00 | 0.00 | 409.00 | 54.56 | |||||||||||||||||
69 | 001-0000-5171-3000-00002-1 | SA MS GIRLS BB | 1,000.00 | 383.00 | 551.00 | 449.00 | 0.00 | 449.00 | 55.10 | |||||||||||||||||
70 | 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 | |||||||||||||||||
71 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 996.00 | (196.00) | 0.00 | (196.00) | 124.50 | |||||||||||||||||
72 | 001-0000-5173-0000-00024-1 | SA EA SODA CLUB | 0.00 | 0.00 | 454.00 | (454.00) | 0.00 | (454.00) | 0.00 | |||||||||||||||||
73 | 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 | |||||||||||||||||
74 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 2,616.40 | 4,866.40 | 133.60 | 0.00 | 133.60 | 97.33 | |||||||||||||||||
75 | 001-0000-5173-1050-00002-1 | SA HS GIRLS BB CLUB | 1,767.00 | 1,445.00 | 1,445.00 | 322.00 | 0.00 | 322.00 | 81.78 | |||||||||||||||||
76 | 001-0000-5173-1050-00003-1 | SA HS BB CHEER CLUB | 0.00 | 1,578.00 | 1,978.00 | (1,978.00) | 0.00 | (1,978.00) | 0.00 | |||||||||||||||||
77 | 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 | |||||||||||||||||
78 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 735.00 | 24,317.00 | (24,317.00) | 0.00 | (24,317.00) | 0.00 | |||||||||||||||||
79 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 0.00 | 1,512.80 | 968.20 | 0.00 | 968.20 | 60.98 | |||||||||||||||||
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-00012-1 | SA HS TRACK CLUB REV | 0.00 | 0.00 | 361.00 | (361.00) | 0.00 | (361.00) | 0.00 | |||||||||||||||||
82 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 1,624.00 | 8,708.15 | 1,581.85 | 0.00 | 1,581.85 | 84.63 | |||||||||||||||||
83 | 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 | |||||||||||||||||
84 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 5.00 | 4,052.40 | (477.40) | 0.00 | (477.40) | 113.35 | |||||||||||||||||
85 | 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 | |||||||||||||||||
86 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 410.00 | 1,906.26 | (384.26) | 0.00 | (384.26) | 125.25 | |||||||||||||||||
87 | 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 | |||||||||||||||||
88 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 20.00 | 485.00 | 438.00 | 0.00 | 438.00 | 52.55 | |||||||||||||||||
89 | 001-0000-5173-1050-00032-1 | SA HS BAND CLUB | 11,998.00 | 2,963.00 | 5,193.00 | 6,805.00 | 0.00 | 6,805.00 | 43.28 | |||||||||||||||||
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 | 235.00 | 169.00 | 0.00 | 169.00 | 58.17 | |||||||||||||||||
94 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 27,915.00 | 1,350.00 | 23,259.00 | 4,656.00 | 0.00 | 4,656.00 | 83.32 | |||||||||||||||||
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 | 380.00 | 620.00 | 0.00 | 620.00 | 38.00 | |||||||||||||||||
97 | 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 | |||||||||||||||||
98 | 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 | |||||||||||||||||
99 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 0.00 | 360.00 | (180.00) | 0.00 | (180.00) | 200.00 | |||||||||||||||||
100 | 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 |