| 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 2022 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,291,048.87 | 257,767.02 | 642,475.26 | 1,933,524.13 | (25,440.75) | 1,908,083.38 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 436,352.21 | 1,497,065.23 | 1,497,065.23 | (89.32) | 1,496,975.91 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 41,074.22 | 123,197.75 | 123,197.75 | 0.00 | 123,197.75 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,291,048.87 | 735,193.45 | 2,262,738.24 | 3,553,787.11 | (25,530.07) | 3,528,257.04 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 4,719,555.89 | (337,478.34) | (1,360,470.76) | 3,359,085.13 | (143,234.85) | 3,215,850.28 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (989,148.64) | (1,102,145.41) | (1,102,145.41) | (453.26) | (1,102,598.67) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,112,098.01 | (563,507.93) | (1,006,022.99) | 1,106,075.02 | 0.00 | 1,106,075.02 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,831,653.90 | (1,890,134.91) | (3,468,639.16) | 3,363,014.74 | (143,688.11) | 3,219,326.63 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 104,768.53 | (350.90) | (32.92) | 104,735.61 | 0.00 | 104,735.61 | ||||||||||||||||||
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 | (350.90) | (32.92) | 106,235.61 | 0.00 | 106,235.61 | ||||||||||||||||||
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 | (1,155,292.36) | (1,205,933.84) | 7,023,237.86 | (169,218.18) | 6,854,019.68 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 10,123.79 | (200.00) | 40.82 | 10,164.61 | (3,615.71) | 6,548.90 | ||||||||||||||||||
22 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | (13,792.19) | (13,792.19) | (13,792.19) | 0.00 | (13,792.19) | ||||||||||||||||||
23 | Subtotal | 0000-2154-0000-00000-0 | 10,123.79 | (13,992.19) | (13,751.37) | (3,627.58) | (3,615.71) | (7,243.29) | ||||||||||||||||||
24 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 16,172.08 | 0.00 | 554.00 | 16,726.08 | (28,083.93) | (11,357.85) | ||||||||||||||||||
25 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | (62,779.63) | (62,779.63) | (62,779.63) | 0.00 | (62,779.63) | ||||||||||||||||||
26 | Subtotal | 0000-2156-0000-00000-0 | 16,172.08 | (62,779.63) | (62,225.63) | (46,053.55) | (28,083.93) | (74,137.48) | ||||||||||||||||||
27 | Subtotal | Liabilities | 26,295.87 | (76,771.82) | (75,977.00) | (49,681.13) | (31,699.64) | (81,380.77) | ||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | Fund Balances | |||||||||||||||||||||||||
30 | 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) | ||||||||||||||||||
31 | 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) | ||||||||||||||||||
32 | Subtotal | 0000-3111-0000-00000-0 | (8,256,467.57) | 0.00 | 0.00 | (8,256,467.57) | 0.00 | (8,256,467.57) | ||||||||||||||||||
33 | 001-0000-3321-0000-00000-0 | CASUALTY/LOSS CLEARIN | 1,000.00 | 0.00 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | ||||||||||||||||||
34 | Subtotal | (8,255,467.57) | 0.00 | 0.00 | (8,255,467.57) | 0.00 | (8,255,467.57) | |||||||||||||||||||
35 | ||||||||||||||||||||||||||
36 | Revenues | |||||||||||||||||||||||||
37 | Object 51xx | |||||||||||||||||||||||||
38 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 1,966,808.00 | 0.00 | 0.00 | 1,966,808.00 | 0.00 | 1,966,808.00 | 0.00 | |||||||||||||||||
39 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 604,429.00 | 0.00 | 0.00 | 604,429.00 | 0.00 | 604,429.00 | 0.00 | |||||||||||||||||
40 | Subtotal | 0000-5111-0000-00000-1 | 2,571,237.00 | 0.00 | 0.00 | 2,571,237.00 | 0.00 | 2,571,237.00 | 0.00 | |||||||||||||||||
41 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 175,682.00 | 8,468.26 | 36,241.16 | 139,440.84 | 0.00 | 139,440.84 | 20.63 | |||||||||||||||||
42 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 50,397.00 | 2,581.13 | 11,090.83 | 39,306.17 | 0.00 | 39,306.17 | 22.01 | |||||||||||||||||
43 | Subtotal | 0000-5112-0000-00000-1 | 226,079.00 | 11,049.39 | 47,331.99 | 178,747.01 | 0.00 | 178,747.01 | 20.94 | |||||||||||||||||
44 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,081,106.00 | 101,809.85 | 357,589.36 | 723,516.64 | 0.00 | 723,516.64 | 33.08 | |||||||||||||||||
45 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 463,331.00 | 33,936.62 | 107,682.59 | 355,648.41 | 0.00 | 355,648.41 | 23.24 | |||||||||||||||||
46 | Subtotal | 0000-5113-0000-00000-1 | 1,544,437.00 | 135,746.47 | 465,271.95 | 1,079,165.05 | 0.00 | 1,079,165.05 | 30.13 | |||||||||||||||||
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 | 33,000.00 | 45.53 | 86.50 | 32,913.50 | 0.00 | 32,913.50 | 0.26 | |||||||||||||||||
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 | 84,142.00 | 11,132.05 | 38,239.45 | 45,902.55 | 0.00 | 45,902.55 | 45.45 | |||||||||||||||||
51 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 25,858.00 | 594.78 | 2,264.93 | 23,593.07 | 0.00 | 23,593.07 | 8.76 | |||||||||||||||||
52 | Subtotal | 0000-5141-0000-00000-1 | 110,000.00 | 11,726.83 | 40,504.38 | 69,495.62 | 0.00 | 69,495.62 | 36.82 | |||||||||||||||||
53 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 75,000.00 | 5,812.08 | 7,727.40 | 67,272.60 | 0.00 | 67,272.60 | 10.30 | |||||||||||||||||
54 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 12,000.00 | 1,715.81 | 2,148.55 | 9,851.45 | 0.00 | 9,851.45 | 17.90 | |||||||||||||||||
55 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 20.70 | 25.35 | 174.65 | 0.00 | 174.65 | 12.68 | |||||||||||||||||
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 | 3,111.14 | 3,111.14 | 9,888.86 | 0.00 | 9,888.86 | 23.93 | |||||||||||||||||
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 | 1,019.00 | 1,019.00 | 1,481.00 | 0.00 | 1,481.00 | 40.76 | |||||||||||||||||
63 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 975.00 | 975.00 | 9,025.00 | 0.00 | 9,025.00 | 9.75 | |||||||||||||||||
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 | 1,270.80 | 1,270.80 | (270.80) | 0.00 | (270.80) | 127.08 | |||||||||||||||||
67 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 391.00 | 391.00 | 409.00 | 0.00 | 409.00 | 48.88 | |||||||||||||||||
68 | 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 | |||||||||||||||||
69 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 540.00 | 4,460.00 | 0.00 | 4,460.00 | 10.80 | |||||||||||||||||
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 | 100.00 | 180.00 | 4,122.00 | 0.00 | 4,122.00 | 4.18 | |||||||||||||||||
72 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 0.00 | 13,125.00 | (13,125.00) | 0.00 | (13,125.00) | 0.00 | |||||||||||||||||
73 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 526.00 | 1,332.00 | 1,149.00 | 0.00 | 1,149.00 | 53.69 | |||||||||||||||||
74 | 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 | |||||||||||||||||
75 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 3,520.00 | 3,520.00 | 6,770.00 | 0.00 | 6,770.00 | 34.21 | |||||||||||||||||
76 | 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 | |||||||||||||||||
77 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 0.00 | 4,015.21 | (440.21) | 0.00 | (440.21) | 112.31 | |||||||||||||||||
78 | 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 | |||||||||||||||||
79 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 350.00 | 350.00 | 1,172.00 | 0.00 | 1,172.00 | 23.00 | |||||||||||||||||
80 | 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 | |||||||||||||||||
81 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 45.00 | 45.00 | 878.00 | 0.00 | 878.00 | 4.88 | |||||||||||||||||
82 | 001-0000-5173-1050-00032-1 | SA HS BAND CLUB | 11,998.00 | 874.50 | 874.50 | 11,123.50 | 0.00 | 11,123.50 | 7.29 | |||||||||||||||||
83 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
84 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
85 | 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 | |||||||||||||||||
86 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 135.00 | 135.00 | 269.00 | 0.00 | 269.00 | 33.42 | |||||||||||||||||
87 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 27,915.00 | 8,797.00 | 10,750.00 | 17,165.00 | 0.00 | 17,165.00 | 38.51 | |||||||||||||||||
88 | 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 | |||||||||||||||||
89 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 120.00 | 350.00 | 650.00 | 0.00 | 650.00 | 35.00 | |||||||||||||||||
90 | 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 | |||||||||||||||||
91 | 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 | |||||||||||||||||
92 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 0.00 | 0.00 | 180.00 | 0.00 | 180.00 | 0.00 | |||||||||||||||||
93 | 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 | |||||||||||||||||
94 | 001-0000-5173-1050-00061-1 | SA HS CLASS OF 24 | 0.00 | 260.00 | 260.00 | (260.00) | 0.00 | (260.00) | 0.00 | |||||||||||||||||
95 | 001-0000-5173-1050-00062-1 | SA HS CLASS OF 26 | 55,836.00 | 865.00 | 875.00 | 54,961.00 | 0.00 | 54,961.00 | 1.57 | |||||||||||||||||
96 | 001-0000-5173-1050-00065-1 | SA HS STEM | 0.00 | 65.00 | 65.00 | (65.00) | 0.00 | (65.00) | 0.00 | |||||||||||||||||
97 | 001-0000-5173-1050-00066-1 | SA HS CLASS OF 23 | 9,120.00 | 10,979.35 | 11,029.35 | (1,909.35) | 0.00 | (1,909.35) | 120.94 | |||||||||||||||||
98 | 001-0000-5173-1050-00068-1 | SA HS CLASS OF 25 | 0.00 | 510.00 | 510.00 | (510.00) | 0.00 | (510.00) | 0.00 | |||||||||||||||||
99 | 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 | |||||||||||||||||
100 | 001-0000-5173-1050-00089-1 | SA HS FCCLA CLUB | 0.00 | 1,115.65 | 1,115.65 | (1,115.65) | 0.00 | (1,115.65) | 0.00 |