| 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 | APRIL 2024 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,408,831.86 | 224,334.29 | (23,593.22) | 1,385,238.64 | (25,904.80) | 1,359,333.84 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 481,875.93 | 1,768,757.35 | 1,768,757.35 | (3,768.18) | 1,764,989.17 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 47,299.07 | 136,152.26 | 136,152.26 | 0.00 | 136,152.26 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,408,831.86 | 753,509.29 | 1,881,316.39 | 3,290,148.25 | (29,672.98) | 3,260,475.27 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 5,124,108.73 | (235,297.20) | 929,253.60 | 6,053,362.33 | (158,646.40) | 5,894,715.93 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (95,640.43) | (871,595.22) | (871,595.22) | (525,928.50) | (1,397,523.72) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 1,774,237.82 | (2,637.92) | 795,332.63 | 2,569,570.45 | (6,910.84) | 2,562,659.61 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,898,346.55 | (333,575.55) | 852,991.01 | 7,751,337.56 | (691,485.74) | 7,059,851.82 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 91,525.21 | 419.95 | 3,254.89 | 94,780.10 | 0.00 | 94,780.10 | ||||||||||||||||||
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 | 419.95 | 3,254.89 | 96,280.10 | 0.00 | 96,280.10 | ||||||||||||||||||
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 | 420,353.69 | 2,737,562.29 | 11,137,966.31 | (721,158.72) | 10,416,807.59 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | 0.00 | 0.00 | 0.00 | (25.00) | (25.00) | ||||||||||||||||||
22 | 001-0000-2152-0000-00000-0 | SOC SEC PAYABLE | 0.00 | 0.00 | 0.00 | 0.00 | (151.08) | (151.08) | ||||||||||||||||||
23 | 001-0000-2153-0000-00000-0 | ST INC TX PAYABLE | 0.00 | 0.00 | 0.00 | 0.00 | (35.34) | (35.34) | ||||||||||||||||||
24 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (8,170.06) | (438.41) | (144.13) | (8,314.19) | (4,055.91) | (12,370.10) | ||||||||||||||||||
25 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | 14,219.07 | 422.20 | 422.20 | (14,864.00) | (14,441.80) | ||||||||||||||||||
26 | Subtotal | 0000-2154-0000-00000-0 | (8,170.06) | 13,780.66 | 278.07 | (7,891.99) | (18,919.91) | (26,811.90) | ||||||||||||||||||
27 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 14,528.08 | 0.00 | (641.51) | 13,886.57 | (24,572.00) | (10,685.43) | ||||||||||||||||||
28 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | 65,363.97 | 139.48 | 139.48 | (65,916.00) | (65,776.52) | ||||||||||||||||||
29 | Subtotal | 0000-2156-0000-00000-0 | 14,528.08 | 65,363.97 | (502.03) | 14,026.05 | (90,488.00) | (76,461.95) | ||||||||||||||||||
30 | Subtotal | Liabilities | 6,358.02 | 79,144.63 | (223.96) | 6,134.06 | (109,619.33) | (103,485.27) | ||||||||||||||||||
31 | ||||||||||||||||||||||||||
32 | Fund Balances | |||||||||||||||||||||||||
33 | 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) | ||||||||||||||||||
34 | 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) | ||||||||||||||||||
35 | Subtotal | 0000-3111-0000-00000-0 | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | ||||||||||||||||||
36 | Subtotal | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | |||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | Revenues | |||||||||||||||||||||||||
39 | Object 51xx | |||||||||||||||||||||||||
40 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 2,186,750.00 | 27,443.74 | 2,258,038.12 | (71,288.12) | 0.00 | (71,288.12) | 103.26 | |||||||||||||||||
41 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 666,710.00 | 8,364.90 | 687,974.92 | (21,264.92) | 0.00 | (21,264.92) | 103.19 | |||||||||||||||||
42 | Subtotal | 0000-5111-0000-00000-1 | 2,853,460.00 | 35,808.64 | 2,946,013.04 | (92,553.04) | 0.00 | (92,553.04) | 103.24 | |||||||||||||||||
43 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 192,940.00 | 40,690.96 | 155,607.28 | 37,332.72 | 0.00 | 37,332.72 | 80.65 | |||||||||||||||||
44 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 55,392.00 | 12,402.66 | 47,429.34 | 7,962.66 | 0.00 | 7,962.66 | 85.62 | |||||||||||||||||
45 | Subtotal | 0000-5112-0000-00000-1 | 248,332.00 | 53,093.62 | 203,036.62 | 45,295.38 | 0.00 | 45,295.38 | 81.76 | |||||||||||||||||
46 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,240,849.00 | 104,914.52 | 1,233,779.30 | 7,069.70 | 0.00 | 7,069.70 | 99.43 | |||||||||||||||||
47 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 531,792.00 | 34,971.50 | 411,259.77 | 120,532.23 | 0.00 | 120,532.23 | 77.33 | |||||||||||||||||
48 | Subtotal | 0000-5113-0000-00000-1 | 1,772,641.00 | 139,886.02 | 1,645,039.07 | 127,601.93 | 0.00 | 127,601.93 | 92.80 | |||||||||||||||||
49 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 3,056.90 | (2,956.90) | 0.00 | (2,956.90) | 3,056.90 | |||||||||||||||||
50 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 7,627.06 | 38,846.89 | (3,846.89) | 0.00 | (3,846.89) | 110.99 | |||||||||||||||||
51 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 0.00 | 18,204.39 | (17,704.39) | 0.00 | (17,704.39) | 3,640.88 | |||||||||||||||||
52 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 190,293.00 | 48,742.12 | 342,235.99 | (151,942.99) | 0.00 | (151,942.99) | 179.85 | |||||||||||||||||
53 | 002-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 0.00 | 0.00 | 343.05 | (343.05) | 0.00 | (343.05) | 0.00 | |||||||||||||||||
54 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 58,018.00 | 1,839.96 | 9,716.80 | 48,301.20 | 0.00 | 48,301.20 | 16.75 | |||||||||||||||||
55 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 50,582.08 | 352,295.84 | (103,984.84) | 0.00 | (103,984.84) | 141.88 | |||||||||||||||||
56 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 55,000.00 | 4,663.99 | 20,548.37 | 34,451.63 | 0.00 | 34,451.63 | 37.36 | |||||||||||||||||
57 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 15,000.00 | 1,382.99 | 11,340.17 | 3,659.83 | 0.00 | 3,659.83 | 75.60 | |||||||||||||||||
58 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 17.85 | 62.05 | 137.95 | 0.00 | 137.95 | 31.03 | |||||||||||||||||
59 | 001-0000-5171-1050-00001-1 | SA HS BOYS BB | 3,000.00 | 451.50 | 3,710.50 | (710.50) | 0.00 | (710.50) | 123.68 | |||||||||||||||||
60 | 001-0000-5171-1050-00002-1 | SA HS GIRLS BB | 1,500.00 | 1,375.30 | 7,565.00 | (6,065.00) | 0.00 | (6,065.00) | 504.33 | |||||||||||||||||
61 | 001-0000-5171-1050-00004-1 | SA HS BOYS BB TOURN | 0.00 | 0.00 | 4,577.00 | (4,577.00) | 0.00 | (4,577.00) | 0.00 | |||||||||||||||||
62 | 004-0000-5171-1050-00004-1 | SA HS BOYS BB TOURN | 0.00 | 0.00 | 100.00 | (100.00) | 0.00 | (100.00) | 0.00 | |||||||||||||||||
63 | Subtotal | 0000-5171-1050-00004-1 | 0.00 | 0.00 | 4,677.00 | (4,677.00) | 0.00 | (4,677.00) | 0.00 | |||||||||||||||||
64 | 001-0000-5171-1050-00005-1 | SA HS BASEBALL | 0.00 | 0.00 | 450.00 | (450.00) | 0.00 | (450.00) | 0.00 | |||||||||||||||||
65 | 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 | |||||||||||||||||
66 | 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 | |||||||||||||||||
67 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
68 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
69 | 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 | |||||||||||||||||
70 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 350.00 | 7,085.00 | 2,915.00 | 0.00 | 2,915.00 | 70.85 | |||||||||||||||||
71 | 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 | |||||||||||||||||
72 | 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 | |||||||||||||||||
73 | 001-0000-5171-3000-00006-1 | SA MS FOOTBALL | 1,000.00 | 0.00 | 814.00 | 186.00 | 0.00 | 186.00 | 81.40 | |||||||||||||||||
74 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 1,090.00 | (290.00) | 0.00 | (290.00) | 136.25 | |||||||||||||||||
75 | 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 | |||||||||||||||||
76 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 7,118.50 | (2,118.50) | 0.00 | (2,118.50) | 142.37 | |||||||||||||||||
77 | 001-0000-5173-1050-00002-1 | SA HS GIRLS BB CLUB | 1,767.00 | 1,053.00 | 7,355.00 | (5,588.00) | 0.00 | (5,588.00) | 416.24 | |||||||||||||||||
78 | 001-0000-5173-1050-00003-1 | SA HS BB CHEER CLUB | 0.00 | 15.00 | 968.38 | (968.38) | 0.00 | (968.38) | 0.00 | |||||||||||||||||
79 | 001-0000-5173-1050-00005-1 | SA HS BASEBALL CLUB | 4,302.00 | 1,140.00 | 1,745.00 | 2,557.00 | 0.00 | 2,557.00 | 40.56 | |||||||||||||||||
80 | 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 | |||||||||||||||||
81 | 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 | |||||||||||||||||
82 | 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 | |||||||||||||||||
83 | 001-0000-5173-1050-00010-1 | SA HS SOCCER CLUB | 3,000.00 | 0.00 | 1,140.00 | 1,860.00 | 0.00 | 1,860.00 | 38.00 | |||||||||||||||||
84 | 001-0000-5173-1050-00012-1 | SA HS TRACK CLUB REV | 0.00 | 963.00 | 963.00 | (963.00) | 0.00 | (963.00) | 0.00 | |||||||||||||||||
85 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 1,060.00 | 11,314.45 | (1,024.45) | 0.00 | (1,024.45) | 109.96 | |||||||||||||||||
86 | 001-0000-5173-1050-00015-1 | SA HS SFB CLUB | 2,000.00 | 826.50 | 1,026.50 | 973.50 | 0.00 | 973.50 | 51.33 | |||||||||||||||||
87 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 1,000.00 | 6,189.71 | (2,614.71) | 0.00 | (2,614.71) | 173.14 | |||||||||||||||||
88 | 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 | |||||||||||||||||
89 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 0.00 | 1,465.68 | 56.32 | 0.00 | 56.32 | 96.30 | |||||||||||||||||
90 | 001-0000-5173-1050-00028-1 | SA HS ART CLUB | 1,147.00 | 920.00 | 1,130.00 | 17.00 | 0.00 | 17.00 | 98.52 | |||||||||||||||||
91 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 0.00 | 515.00 | 408.00 | 0.00 | 408.00 | 55.80 | |||||||||||||||||
92 | 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 | |||||||||||||||||
93 | 001-0000-5173-1050-00033-1 | SA HS TRACTION CLUB | 0.00 | 0.00 | 554.50 | (554.50) | 0.00 | (554.50) | 0.00 | |||||||||||||||||
94 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
95 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
96 | 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 | |||||||||||||||||
97 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 0.00 | 454.50 | (50.50) | 0.00 | (50.50) | 112.50 | |||||||||||||||||
98 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 47,232.00 | 0.00 | 24,153.26 | 23,078.74 | 0.00 | 23,078.74 | 51.14 | |||||||||||||||||
99 | 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 | |||||||||||||||||
100 | 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 |