| 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 | AUGUST 2023 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,408,831.86 | 379,290.17 | 813,501.82 | 2,222,333.68 | (28,029.23) | 2,194,304.45 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 479,456.84 | 951,686.30 | 951,686.30 | (1,835.91) | 949,850.39 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 45,357.71 | 933,036.92 | 933,036.92 | 0.00 | 933,036.92 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,408,831.86 | 904,104.72 | 2,698,225.04 | 4,107,056.90 | (29,865.14) | 4,077,191.76 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 5,124,108.73 | (165,299.82) | (956,353.20) | 4,167,755.53 | (165,191.00) | 4,002,564.53 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (61,375.30) | (133,175.86) | (133,175.86) | (524,650.55) | (657,826.41) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 1,774,237.82 | (579,767.10) | 51,048.83 | 1,825,286.65 | (53,489.00) | 1,771,797.65 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,898,346.55 | (806,442.22) | (1,038,480.23) | 5,859,866.32 | (743,330.55) | 5,116,535.77 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 91,525.21 | 321.16 | 90.24 | 91,615.45 | 0.00 | 91,615.45 | ||||||||||||||||||
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 | 321.16 | 90.24 | 93,115.45 | 0.00 | 93,115.45 | ||||||||||||||||||
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 | 97,983.66 | 1,659,835.05 | 10,060,239.07 | (773,195.69) | 9,287,043.38 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (8,170.06) | 0.00 | 0.00 | (8,170.06) | (3,959.29) | (12,129.35) | ||||||||||||||||||
22 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | 0.00 | 0.00 | 0.00 | (12,752.24) | (12,752.24) | ||||||||||||||||||
23 | Subtotal | 0000-2154-0000-00000-0 | (8,170.06) | 0.00 | 0.00 | (8,170.06) | (16,711.53) | (24,881.59) | ||||||||||||||||||
24 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 14,528.08 | 0.00 | 0.00 | 14,528.08 | (28,641.00) | (14,112.92) | ||||||||||||||||||
25 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | 0.00 | 0.00 | 0.00 | (64,763.00) | (64,763.00) | ||||||||||||||||||
26 | Subtotal | 0000-2156-0000-00000-0 | 14,528.08 | 0.00 | 0.00 | 14,528.08 | (93,404.00) | (78,875.92) | ||||||||||||||||||
27 | 002-0000-2158-0000-00000-0 | TEA RETIRE PAYABLE | 0.00 | (22,506.34) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
28 | Subtotal | Liabilities | 6,358.02 | (22,506.34) | 0.00 | 6,358.02 | (110,115.53) | (103,757.51) | ||||||||||||||||||
29 | ||||||||||||||||||||||||||
30 | Fund Balances | |||||||||||||||||||||||||
31 | 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) | ||||||||||||||||||
32 | 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) | ||||||||||||||||||
33 | Subtotal | 0000-3111-0000-00000-0 | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | ||||||||||||||||||
34 | Subtotal | (8,406,762.04) | 0.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 | 0.00 | 0.00 | 2,186,750.00 | 0.00 | 2,186,750.00 | 0.00 | |||||||||||||||||
39 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 666,710.00 | 0.00 | 0.00 | 666,710.00 | 0.00 | 666,710.00 | 0.00 | |||||||||||||||||
40 | Subtotal | 0000-5111-0000-00000-1 | 2,853,460.00 | 0.00 | 0.00 | 2,853,460.00 | 0.00 | 2,853,460.00 | 0.00 | |||||||||||||||||
41 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 192,940.00 | 29,047.48 | 44,234.99 | 148,705.01 | 0.00 | 148,705.01 | 22.93 | |||||||||||||||||
42 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 55,392.00 | 8,853.72 | 13,482.89 | 41,909.11 | 0.00 | 41,909.11 | 24.34 | |||||||||||||||||
43 | Subtotal | 0000-5112-0000-00000-1 | 248,332.00 | 37,901.20 | 57,717.88 | 190,614.12 | 0.00 | 190,614.12 | 23.24 | |||||||||||||||||
44 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,240,849.00 | 104,426.00 | 278,023.36 | 962,825.64 | 0.00 | 962,825.64 | 22.41 | |||||||||||||||||
45 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 531,792.00 | 34,808.67 | 92,674.46 | 439,117.54 | 0.00 | 439,117.54 | 17.43 | |||||||||||||||||
46 | Subtotal | 0000-5113-0000-00000-1 | 1,772,641.00 | 139,234.67 | 370,697.82 | 1,401,943.18 | 0.00 | 1,401,943.18 | 20.91 | |||||||||||||||||
47 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
48 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 51.15 | 125.03 | 34,874.97 | 0.00 | 34,874.97 | 0.36 | |||||||||||||||||
49 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 0.00 | 0.00 | 500.00 | 0.00 | 500.00 | 0.00 | |||||||||||||||||
50 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 190,293.00 | 35,626.62 | 72,503.26 | 117,789.74 | 0.00 | 117,789.74 | 38.10 | |||||||||||||||||
51 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 58,018.00 | 1,526.13 | 2,592.39 | 55,425.61 | 0.00 | 55,425.61 | 4.47 | |||||||||||||||||
52 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 37,152.75 | 75,095.65 | 173,215.35 | 0.00 | 173,215.35 | 30.24 | |||||||||||||||||
53 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 55,000.00 | 279.74 | 279.74 | 54,720.26 | 0.00 | 54,720.26 | 0.51 | |||||||||||||||||
54 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 15,000.00 | 146.56 | 146.56 | 14,853.44 | 0.00 | 14,853.44 | 0.98 | |||||||||||||||||
55 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
56 | 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 | |||||||||||||||||
57 | 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 | |||||||||||||||||
58 | 001-0000-5171-1050-00006-1 | SA HS FOOTBALL | 13,000.00 | 0.00 | 0.00 | 13,000.00 | 0.00 | 13,000.00 | 0.00 | |||||||||||||||||
59 | 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 | |||||||||||||||||
60 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
61 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
62 | 001-0000-5171-1050-00013-1 | SA HS VOLLEYBALL | 2,500.00 | 0.00 | 0.00 | 2,500.00 | 0.00 | 2,500.00 | 0.00 | |||||||||||||||||
63 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 0.00 | 0.00 | 10,000.00 | 0.00 | 10,000.00 | 0.00 | |||||||||||||||||
64 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 0.00 | 0.00 | 900.00 | 0.00 | 900.00 | 0.00 | |||||||||||||||||
65 | 001-0000-5171-3000-00002-1 | SA MS GIRLS BB | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 | |||||||||||||||||
66 | 001-0000-5171-3000-00006-1 | SA MS FOOTBALL | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 | |||||||||||||||||
67 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 0.00 | 800.00 | 0.00 | 800.00 | 0.00 | |||||||||||||||||
68 | 001-0000-5173-0000-00091-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 3,292.26 | 4,792.26 | (4,792.26) | 0.00 | (4,792.26) | 0.00 | |||||||||||||||||
69 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 2,500.00 | 2,500.00 | 2,500.00 | 0.00 | 2,500.00 | 50.00 | |||||||||||||||||
70 | 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 | |||||||||||||||||
71 | 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 | |||||||||||||||||
72 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 1,149.89 | 1,149.89 | 1,331.11 | 0.00 | 1,331.11 | 46.35 | |||||||||||||||||
73 | 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 | |||||||||||||||||
74 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 0.00 | 5,442.45 | 4,847.55 | 0.00 | 4,847.55 | 52.89 | |||||||||||||||||
75 | 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 | |||||||||||||||||
76 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 3,040.52 | 3,040.52 | 534.48 | 0.00 | 534.48 | 85.05 | |||||||||||||||||
77 | 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 | |||||||||||||||||
78 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 0.00 | 0.00 | 1,522.00 | 0.00 | 1,522.00 | 0.00 | |||||||||||||||||
79 | 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 | |||||||||||||||||
80 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 0.00 | 0.00 | 923.00 | 0.00 | 923.00 | 0.00 | |||||||||||||||||
81 | 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 | |||||||||||||||||
82 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
83 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
84 | 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 | |||||||||||||||||
85 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 0.00 | 0.00 | 404.00 | 0.00 | 404.00 | 0.00 | |||||||||||||||||
86 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 47,232.00 | 690.00 | 690.00 | 46,542.00 | 0.00 | 46,542.00 | 1.46 | |||||||||||||||||
87 | 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 | |||||||||||||||||
88 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 | |||||||||||||||||
89 | 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 | |||||||||||||||||
90 | 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 | |||||||||||||||||
91 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 0.00 | 0.00 | 180.00 | 0.00 | 180.00 | 0.00 | |||||||||||||||||
92 | 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 | |||||||||||||||||
93 | 001-0000-5173-1050-00062-1 | SA HS CLASS OF 26 | 55,836.00 | 405.00 | 405.00 | 55,431.00 | 0.00 | 55,431.00 | 0.73 | |||||||||||||||||
94 | 001-0000-5173-1050-00066-1 | SA HS CLASS OF 23 | 9,120.00 | 0.00 | 0.00 | 9,120.00 | 0.00 | 9,120.00 | 0.00 | |||||||||||||||||
95 | 001-0000-5173-1050-00070-1 | SA HS BUSY HANDS CLUB | 4,825.00 | 0.00 | 0.00 | 4,825.00 | 0.00 | 4,825.00 | 0.00 | |||||||||||||||||
96 | 001-0000-5173-1050-00800-0 | SA EA SODA CLUB | 6,337.00 | 0.00 | 0.00 | 6,337.00 | 0.00 | 6,337.00 | 0.00 | |||||||||||||||||
97 | 001-0000-5173-3000-00001-1 | SA MS BOYS BB CLUB | 1,500.00 | 0.00 | 0.00 | 1,500.00 | 0.00 | 1,500.00 | 0.00 | |||||||||||||||||
98 | 001-0000-5173-3000-00002-1 | SA MS GIRLS BB CLUB | 1,302.00 | 0.00 | 0.00 | 1,302.00 | 0.00 | 1,302.00 | 0.00 | |||||||||||||||||
99 | 001-0000-5173-3000-00008-1 | SA MS FB CHEER CLUB | 697.00 | 551.00 | 551.00 | 146.00 | 0.00 | 146.00 | 79.05 | |||||||||||||||||
100 | 001-0000-5173-3000-00013-1 | SA MS VB CLUB | 1,939.00 | 897.00 | 972.00 | 967.00 | 0.00 | 967.00 | 50.13 |