| 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 | JULY 2023 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,408,831.86 | 434,211.65 | 434,211.65 | 1,843,043.51 | 0.00 | 1,843,043.51 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 472,229.46 | 472,229.46 | 472,229.46 | 0.00 | 472,229.46 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 887,679.21 | 887,679.21 | 887,679.21 | 0.00 | 887,679.21 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,408,831.86 | 1,794,120.32 | 1,794,120.32 | 3,202,952.18 | 0.00 | 3,202,952.18 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 5,124,108.73 | (791,053.38) | (791,053.38) | 4,333,055.35 | (241,067.33) | 4,091,988.02 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (71,800.56) | (71,800.56) | (71,800.56) | (67,364.53) | (139,165.09) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 1,774,237.82 | 630,815.93 | 630,815.93 | 2,405,053.75 | (577,199.10) | 1,827,854.65 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,898,346.55 | (232,038.01) | (232,038.01) | 6,666,308.54 | (885,630.96) | 5,780,677.58 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 91,525.21 | (230.92) | (230.92) | 91,294.29 | 0.00 | 91,294.29 | ||||||||||||||||||
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 | (230.92) | (230.92) | 92,794.29 | 0.00 | 92,794.29 | ||||||||||||||||||
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 | 1,561,851.39 | 1,561,851.39 | 9,962,255.41 | (885,630.96) | 9,076,624.45 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (8,170.06) | 0.00 | 0.00 | (8,170.06) | 0.00 | (8,170.06) | ||||||||||||||||||
22 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 14,528.08 | 0.00 | 0.00 | 14,528.08 | 0.00 | 14,528.08 | ||||||||||||||||||
23 | 002-0000-2158-0000-00000-0 | TEA RETIRE PAYABLE | 0.00 | 22,506.34 | 22,506.34 | 22,506.34 | (22,506.34) | 0.00 | ||||||||||||||||||
24 | Subtotal | Liabilities | 6,358.02 | 22,506.34 | 22,506.34 | 28,864.36 | (22,506.34) | 6,358.02 | ||||||||||||||||||
25 | ||||||||||||||||||||||||||
26 | Fund Balances | |||||||||||||||||||||||||
27 | 001-0000-3111-0000-00000-0 | FUND BALANCE | (6,631,023.82) | 652,920.00 | 652,920.00 | (5,978,103.82) | 0.00 | (5,978,103.82) | ||||||||||||||||||
28 | 004-0000-3111-0000-00000-0 | FUND BALANCE | (1,775,738.22) | (652,920.00) | (652,920.00) | (2,428,658.22) | 0.00 | (2,428,658.22) | ||||||||||||||||||
29 | Subtotal | 0000-3111-0000-00000-0 | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | ||||||||||||||||||
30 | Subtotal | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | |||||||||||||||||||
31 | ||||||||||||||||||||||||||
32 | Revenues | |||||||||||||||||||||||||
33 | Object 51xx | |||||||||||||||||||||||||
34 | 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 | |||||||||||||||||
35 | 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 | |||||||||||||||||
36 | 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 | |||||||||||||||||
37 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 192,940.00 | 15,187.51 | 15,187.51 | 177,752.49 | 0.00 | 177,752.49 | 7.87 | |||||||||||||||||
38 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 55,392.00 | 4,629.17 | 4,629.17 | 50,762.83 | 0.00 | 50,762.83 | 8.36 | |||||||||||||||||
39 | Subtotal | 0000-5112-0000-00000-1 | 248,332.00 | 19,816.68 | 19,816.68 | 228,515.32 | 0.00 | 228,515.32 | 7.98 | |||||||||||||||||
40 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,240,849.00 | 173,597.36 | 173,597.36 | 1,067,251.64 | 0.00 | 1,067,251.64 | 13.99 | |||||||||||||||||
41 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 531,792.00 | 57,865.79 | 57,865.79 | 473,926.21 | 0.00 | 473,926.21 | 10.88 | |||||||||||||||||
42 | Subtotal | 0000-5113-0000-00000-1 | 1,772,641.00 | 231,463.15 | 231,463.15 | 1,541,177.85 | 0.00 | 1,541,177.85 | 13.06 | |||||||||||||||||
43 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
44 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 73.88 | 73.88 | 34,926.12 | 0.00 | 34,926.12 | 0.21 | |||||||||||||||||
45 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 0.00 | 0.00 | 500.00 | 0.00 | 500.00 | 0.00 | |||||||||||||||||
46 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 190,293.00 | 36,876.64 | 36,876.64 | 153,416.36 | 0.00 | 153,416.36 | 19.38 | |||||||||||||||||
47 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 58,018.00 | 1,066.26 | 1,066.26 | 56,951.74 | 0.00 | 56,951.74 | 1.84 | |||||||||||||||||
48 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 37,942.90 | 37,942.90 | 210,368.10 | 0.00 | 210,368.10 | 15.28 | |||||||||||||||||
49 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 55,000.00 | 0.00 | 0.00 | 55,000.00 | 0.00 | 55,000.00 | 0.00 | |||||||||||||||||
50 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 15,000.00 | 0.00 | 0.00 | 15,000.00 | 0.00 | 15,000.00 | 0.00 | |||||||||||||||||
51 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
52 | 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 | |||||||||||||||||
53 | 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 | |||||||||||||||||
54 | 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 | |||||||||||||||||
55 | 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 | |||||||||||||||||
56 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
57 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
58 | 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 | |||||||||||||||||
59 | 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 | |||||||||||||||||
60 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 0.00 | 0.00 | 900.00 | 0.00 | 900.00 | 0.00 | |||||||||||||||||
61 | 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 | |||||||||||||||||
62 | 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 | |||||||||||||||||
63 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 0.00 | 800.00 | 0.00 | 800.00 | 0.00 | |||||||||||||||||
64 | 001-0000-5173-0000-00091-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 1,500.00 | 1,500.00 | (1,500.00) | 0.00 | (1,500.00) | 0.00 | |||||||||||||||||
65 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 0.00 | 5,000.00 | 0.00 | 5,000.00 | 0.00 | |||||||||||||||||
66 | 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 | |||||||||||||||||
67 | 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 | |||||||||||||||||
68 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 0.00 | 0.00 | 2,481.00 | 0.00 | 2,481.00 | 0.00 | |||||||||||||||||
69 | 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 | |||||||||||||||||
70 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 5,442.45 | 5,442.45 | 4,847.55 | 0.00 | 4,847.55 | 52.89 | |||||||||||||||||
71 | 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 | |||||||||||||||||
72 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 0.00 | 0.00 | 3,575.00 | 0.00 | 3,575.00 | 0.00 | |||||||||||||||||
73 | 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 | |||||||||||||||||
74 | 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 | |||||||||||||||||
75 | 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 | |||||||||||||||||
76 | 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 | |||||||||||||||||
77 | 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 | |||||||||||||||||
78 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
79 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
80 | 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 | |||||||||||||||||
81 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 0.00 | 0.00 | 404.00 | 0.00 | 404.00 | 0.00 | |||||||||||||||||
82 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 47,232.00 | 0.00 | 0.00 | 47,232.00 | 0.00 | 47,232.00 | 0.00 | |||||||||||||||||
83 | 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 | |||||||||||||||||
84 | 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 | |||||||||||||||||
85 | 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 | |||||||||||||||||
86 | 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 | |||||||||||||||||
87 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 0.00 | 0.00 | 180.00 | 0.00 | 180.00 | 0.00 | |||||||||||||||||
88 | 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 | |||||||||||||||||
89 | 001-0000-5173-1050-00062-1 | SA HS CLASS OF 26 | 55,836.00 | 0.00 | 0.00 | 55,836.00 | 0.00 | 55,836.00 | 0.00 | |||||||||||||||||
90 | 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 | |||||||||||||||||
91 | 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 | |||||||||||||||||
92 | 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 | |||||||||||||||||
93 | 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 | |||||||||||||||||
94 | 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 | |||||||||||||||||
95 | 001-0000-5173-3000-00008-1 | SA MS FB CHEER CLUB | 697.00 | 0.00 | 0.00 | 697.00 | 0.00 | 697.00 | 0.00 | |||||||||||||||||
96 | 001-0000-5173-3000-00013-1 | SA MS VB CLUB | 1,939.00 | 75.00 | 75.00 | 1,864.00 | 0.00 | 1,864.00 | 3.87 | |||||||||||||||||
97 | 001-0000-5173-3000-00021-1 | SA MS BOOK FAIR CLUB | 1,339.00 | 0.00 | 0.00 | 1,339.00 | 0.00 | 1,339.00 | 0.00 | |||||||||||||||||
98 | 001-0000-5173-3000-00022-1 | SA MS BOOK CLUB | 52.00 | 0.00 | 0.00 | 52.00 | 0.00 | 52.00 | 0.00 | |||||||||||||||||
99 | 001-0000-5173-3000-00023-1 | SA MS GEN ACT CLUB | 750.00 | 0.00 | 0.00 | 750.00 | 0.00 | 750.00 | 0.00 | |||||||||||||||||
100 | 001-0000-5173-3000-00024-1 | SA MS SODA CLUB | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 0.00 |