| 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 | SEPTEMBER 2023 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,408,831.86 | 180,881.63 | 994,383.45 | 2,403,215.31 | (28,460.82) | 2,374,754.49 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 452,407.04 | 1,404,093.34 | 1,404,093.34 | (3,720.12) | 1,400,373.22 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 541,279.98 | 1,474,316.90 | 1,474,316.90 | 0.00 | 1,474,316.90 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,408,831.86 | 1,174,568.65 | 3,872,793.69 | 5,281,625.55 | (32,180.94) | 5,249,444.61 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 5,124,108.73 | (447,183.78) | (1,403,536.98) | 3,720,571.75 | (170,924.11) | 3,549,647.64 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (1,069,935.61) | (1,203,111.47) | (1,203,111.47) | 22,424.05 | (1,180,687.42) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 1,774,237.82 | (1,051,031.59) | (999,982.76) | 774,255.06 | 0.00 | 774,255.06 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,898,346.55 | (2,568,150.98) | (3,606,631.21) | 3,291,715.34 | (148,500.06) | 3,143,215.28 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 91,525.21 | 493.20 | 583.44 | 92,108.65 | 0.00 | 92,108.65 | ||||||||||||||||||
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 | 493.20 | 583.44 | 93,608.65 | 0.00 | 93,608.65 | ||||||||||||||||||
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,393,089.13) | 266,745.92 | 8,667,149.94 | (180,681.00) | 8,486,468.94 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | 256.32 | 256.32 | 256.32 | (256.32) | 0.00 | ||||||||||||||||||
22 | 002-0000-2151-0000-00000-0 | FED WITHOD PAYABLE | 0.00 | 22,839.01 | 22,839.01 | 22,839.01 | (22,839.01) | 0.00 | ||||||||||||||||||
23 | Subtotal | 0000-2151-0000-00000-0 | 0.00 | 23,095.33 | 23,095.33 | 23,095.33 | (23,095.33) | 0.00 | ||||||||||||||||||
24 | 001-0000-2152-0000-00000-0 | SOC SEC PAYABLE | 0.00 | 356.80 | 356.80 | 356.80 | (356.80) | 0.00 | ||||||||||||||||||
25 | 002-0000-2152-0000-00000-0 | SOC SEC PAYABLE | 0.00 | 4,951.02 | 4,951.02 | 4,951.02 | (4,951.02) | 0.00 | ||||||||||||||||||
26 | Subtotal | 0000-2152-0000-00000-0 | 0.00 | 5,307.82 | 5,307.82 | 5,307.82 | (5,307.82) | 0.00 | ||||||||||||||||||
27 | 001-0000-2153-0000-00000-0 | ST INC TX PAYABLE | 0.00 | 83.44 | 83.44 | 83.44 | (83.44) | 0.00 | ||||||||||||||||||
28 | 002-0000-2153-0000-00000-0 | ST INC TX PAYABLE | 0.00 | 1,157.98 | 1,157.98 | 1,157.98 | (1,157.98) | 0.00 | ||||||||||||||||||
29 | Subtotal | 0000-2153-0000-00000-0 | 0.00 | 1,241.42 | 1,241.42 | 1,241.42 | (1,241.42) | 0.00 | ||||||||||||||||||
30 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | (8,170.06) | 39.73 | 39.73 | (8,130.33) | (4,057.81) | (12,188.14) | ||||||||||||||||||
31 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | (2,914.33) | (2,914.33) | (2,914.33) | (11,608.26) | (14,522.59) | ||||||||||||||||||
32 | Subtotal | 0000-2154-0000-00000-0 | (8,170.06) | (2,874.60) | (2,874.60) | (11,044.66) | (15,666.07) | (26,710.73) | ||||||||||||||||||
33 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 14,528.08 | (132.00) | (132.00) | 14,396.08 | (27,981.00) | (13,584.92) | ||||||||||||||||||
34 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | (65,228.35) | (65,228.35) | (65,228.35) | 0.00 | (65,228.35) | ||||||||||||||||||
35 | Subtotal | 0000-2156-0000-00000-0 | 14,528.08 | (65,360.35) | (65,360.35) | (50,832.27) | (27,981.00) | (78,813.27) | ||||||||||||||||||
36 | Subtotal | Liabilities | 6,358.02 | (38,590.38) | (38,590.38) | (32,232.36) | (73,291.64) | (105,524.00) | ||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | Fund Balances | |||||||||||||||||||||||||
39 | 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) | ||||||||||||||||||
40 | 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) | ||||||||||||||||||
41 | Subtotal | 0000-3111-0000-00000-0 | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | ||||||||||||||||||
42 | Subtotal | (8,406,762.04) | 0.00 | 0.00 | (8,406,762.04) | 0.00 | (8,406,762.04) | |||||||||||||||||||
43 | ||||||||||||||||||||||||||
44 | Revenues | |||||||||||||||||||||||||
45 | Object 51xx | |||||||||||||||||||||||||
46 | 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 | |||||||||||||||||
47 | 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 | |||||||||||||||||
48 | 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 | |||||||||||||||||
49 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 192,940.00 | 10,387.00 | 54,621.99 | 138,318.01 | 0.00 | 138,318.01 | 28.31 | |||||||||||||||||
50 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 55,392.00 | 3,165.96 | 16,648.85 | 38,743.15 | 0.00 | 38,743.15 | 30.06 | |||||||||||||||||
51 | Subtotal | 0000-5112-0000-00000-1 | 248,332.00 | 13,552.96 | 71,270.84 | 177,061.16 | 0.00 | 177,061.16 | 28.70 | |||||||||||||||||
52 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,240,849.00 | 122,398.26 | 400,421.62 | 840,427.38 | 0.00 | 840,427.38 | 32.27 | |||||||||||||||||
53 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 531,792.00 | 40,799.42 | 133,473.88 | 398,318.12 | 0.00 | 398,318.12 | 25.10 | |||||||||||||||||
54 | Subtotal | 0000-5113-0000-00000-1 | 1,772,641.00 | 163,197.68 | 533,895.50 | 1,238,745.50 | 0.00 | 1,238,745.50 | 30.12 | |||||||||||||||||
55 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
56 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 51.69 | 176.72 | 34,823.28 | 0.00 | 34,823.28 | 0.50 | |||||||||||||||||
57 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 2,441.93 | 2,441.93 | (1,941.93) | 0.00 | (1,941.93) | 488.39 | |||||||||||||||||
58 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 190,293.00 | 25,044.28 | 97,547.54 | 92,745.46 | 0.00 | 92,745.46 | 51.26 | |||||||||||||||||
59 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 58,018.00 | 678.27 | 3,270.66 | 54,747.34 | 0.00 | 54,747.34 | 5.64 | |||||||||||||||||
60 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 25,722.55 | 100,818.20 | 147,492.80 | 0.00 | 147,492.80 | 40.60 | |||||||||||||||||
61 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 55,000.00 | 1,389.51 | 1,669.25 | 53,330.75 | 0.00 | 53,330.75 | 3.04 | |||||||||||||||||
62 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 15,000.00 | 1,390.59 | 1,537.15 | 13,462.85 | 0.00 | 13,462.85 | 10.25 | |||||||||||||||||
63 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
64 | 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 | |||||||||||||||||
65 | 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 | |||||||||||||||||
66 | 001-0000-5171-1050-00006-1 | SA HS FOOTBALL | 13,000.00 | 3,979.25 | 3,979.25 | 9,020.75 | 0.00 | 9,020.75 | 30.61 | |||||||||||||||||
67 | 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 | |||||||||||||||||
68 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
69 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | 0.00 | |||||||||||||||||
70 | 001-0000-5171-1050-00013-1 | SA HS VOLLEYBALL | 2,500.00 | 1,921.00 | 1,921.00 | 579.00 | 0.00 | 579.00 | 76.84 | |||||||||||||||||
71 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 1,960.00 | 1,960.00 | 8,040.00 | 0.00 | 8,040.00 | 19.60 | |||||||||||||||||
72 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 0.00 | 0.00 | 900.00 | 0.00 | 900.00 | 0.00 | |||||||||||||||||
73 | 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 | |||||||||||||||||
74 | 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 | |||||||||||||||||
75 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 751.00 | 751.00 | 49.00 | 0.00 | 49.00 | 93.88 | |||||||||||||||||
76 | 001-0000-5173-0000-00091-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 50.00 | 4,842.26 | (4,842.26) | 0.00 | (4,842.26) | 0.00 | |||||||||||||||||
77 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 2,500.00 | 2,500.00 | 0.00 | 2,500.00 | 50.00 | |||||||||||||||||
78 | 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 | |||||||||||||||||
79 | 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 | |||||||||||||||||
80 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 7,200.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 | 302.98 | 1,452.87 | 1,028.13 | 0.00 | 1,028.13 | 58.56 | |||||||||||||||||
82 | 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 | |||||||||||||||||
83 | 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 | |||||||||||||||||
84 | 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 | |||||||||||||||||
85 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 1,484.50 | 4,525.02 | (950.02) | 0.00 | (950.02) | 126.57 | |||||||||||||||||
86 | 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 | |||||||||||||||||
87 | 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 | |||||||||||||||||
88 | 001-0000-5173-1050-00028-1 | SA HS ART CLUB | 1,147.00 | 120.00 | 120.00 | 1,027.00 | 0.00 | 1,027.00 | 10.46 | |||||||||||||||||
89 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 5.00 | 5.00 | 918.00 | 0.00 | 918.00 | 0.54 | |||||||||||||||||
90 | 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 | |||||||||||||||||
91 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
92 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
93 | 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 | |||||||||||||||||
94 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 250.00 | 250.00 | 154.00 | 0.00 | 154.00 | 61.88 | |||||||||||||||||
95 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 47,232.00 | 14,894.00 | 15,584.00 | 31,648.00 | 0.00 | 31,648.00 | 32.99 | |||||||||||||||||
96 | 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 | |||||||||||||||||
97 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 270.00 | 270.00 | 730.00 | 0.00 | 730.00 | 27.00 | |||||||||||||||||
98 | 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 | |||||||||||||||||
99 | 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 | |||||||||||||||||
100 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 185.00 | 185.00 | (5.00) | 0.00 | (5.00) | 102.78 |