| 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 | OCTOBER 2022 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,291,048.87 | (1,152,199.24) | (509,723.98) | 781,324.89 | 0.00 | 781,324.89 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | (1,497,065.23) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | (123,197.75) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,291,048.87 | (2,772,462.22) | (509,723.98) | 781,324.89 | 0.00 | 781,324.89 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 4,719,555.89 | 1,110,049.81 | (250,420.95) | 4,469,134.94 | (19,172.77) | 4,449,962.17 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | 1,875,975.58 | 773,830.17 | 773,830.17 | (490,321.92) | 283,508.25 | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,112,098.01 | 1,800,483.64 | 794,460.65 | 2,906,558.66 | 0.00 | 2,906,558.66 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 6,831,653.90 | 4,786,509.03 | 1,317,869.87 | 8,149,523.77 | (509,494.69) | 7,640,029.08 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 104,768.53 | (8,129.77) | (8,162.69) | 96,605.84 | 0.00 | 96,605.84 | ||||||||||||||||||
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 | (8,129.77) | (8,162.69) | 98,105.84 | 0.00 | 98,105.84 | ||||||||||||||||||
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 | 2,005,917.04 | 799,983.20 | 9,029,154.90 | (509,494.69) | 8,519,660.21 | ||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | Liabilities | |||||||||||||||||||||||||
21 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 10,123.79 | 3,686.41 | 3,727.23 | 13,851.02 | 0.00 | 13,851.02 | ||||||||||||||||||
22 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | 18,012.19 | 4,220.00 | 4,220.00 | (13,975.57) | (9,755.57) | ||||||||||||||||||
23 | Subtotal | 0000-2154-0000-00000-0 | 10,123.79 | 21,698.60 | 7,947.23 | 18,071.02 | (13,975.57) | 4,095.45 | ||||||||||||||||||
24 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 16,172.08 | (456.00) | 98.00 | 16,270.08 | 0.00 | 16,270.08 | ||||||||||||||||||
25 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | 62,323.63 | (456.00) | (456.00) | (62,339.63) | (62,795.63) | ||||||||||||||||||
26 | Subtotal | 0000-2156-0000-00000-0 | 16,172.08 | 61,867.63 | (358.00) | 15,814.08 | (62,339.63) | (46,525.55) | ||||||||||||||||||
27 | Subtotal | Liabilities | 26,295.87 | 83,566.23 | 7,589.23 | 33,885.10 | (76,315.20) | (42,430.10) | ||||||||||||||||||
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 | 7,947.81 | 7,947.81 | 8,947.81 | 0.00 | 8,947.81 | ||||||||||||||||||
34 | Subtotal | (8,255,467.57) | 7,947.81 | 7,947.81 | (8,247,519.76) | 0.00 | (8,247,519.76) | |||||||||||||||||||
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,483.11 | 44,724.27 | 130,957.73 | 0.00 | 130,957.73 | 25.46 | |||||||||||||||||
42 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 50,397.00 | 2,585.66 | 13,676.49 | 36,720.51 | 0.00 | 36,720.51 | 27.14 | |||||||||||||||||
43 | Subtotal | 0000-5112-0000-00000-1 | 226,079.00 | 11,068.77 | 58,400.76 | 167,678.24 | 0.00 | 167,678.24 | 25.83 | |||||||||||||||||
44 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,081,106.00 | 106,671.76 | 464,261.12 | 616,844.88 | 0.00 | 616,844.88 | 42.94 | |||||||||||||||||
45 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 463,331.00 | 35,557.25 | 143,239.84 | 320,091.16 | 0.00 | 320,091.16 | 30.92 | |||||||||||||||||
46 | Subtotal | 0000-5113-0000-00000-1 | 1,544,437.00 | 142,229.01 | 607,500.96 | 936,936.04 | 0.00 | 936,936.04 | 39.33 | |||||||||||||||||
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 | 18.79 | 105.29 | 32,894.71 | 0.00 | 32,894.71 | 0.32 | |||||||||||||||||
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 | 13,270.24 | 51,509.69 | 32,632.31 | 0.00 | 32,632.31 | 61.22 | |||||||||||||||||
51 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 25,858.00 | 500.70 | 2,765.63 | 23,092.37 | 0.00 | 23,092.37 | 10.70 | |||||||||||||||||
52 | Subtotal | 0000-5141-0000-00000-1 | 110,000.00 | 13,770.94 | 54,275.32 | 55,724.68 | 0.00 | 55,724.68 | 49.34 | |||||||||||||||||
53 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 75,000.00 | 5,870.86 | 13,598.26 | 61,401.74 | 0.00 | 61,401.74 | 18.13 | |||||||||||||||||
54 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 12,000.00 | 2,189.37 | 4,337.92 | 7,662.08 | 0.00 | 7,662.08 | 36.15 | |||||||||||||||||
55 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 8.10 | 33.45 | 166.55 | 0.00 | 166.55 | 16.73 | |||||||||||||||||
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,377.00 | 6,488.14 | 6,511.86 | 0.00 | 6,511.86 | 49.91 | |||||||||||||||||
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 | 937.50 | 1,956.50 | 543.50 | 0.00 | 543.50 | 78.26 | |||||||||||||||||
63 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 685.00 | 1,660.00 | 8,340.00 | 0.00 | 8,340.00 | 16.60 | |||||||||||||||||
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 | 469.00 | 1,739.80 | (739.80) | 0.00 | (739.80) | 173.98 | |||||||||||||||||
67 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 444.00 | 835.00 | (35.00) | 0.00 | (35.00) | 104.38 | |||||||||||||||||
68 | 001-0000-5173-0000-00024-1 | SA EA SODA CLUB | 0.00 | 454.00 | 454.00 | (454.00) | 0.00 | (454.00) | 0.00 | |||||||||||||||||
69 | 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 | |||||||||||||||||
70 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 280.00 | 820.00 | 4,180.00 | 0.00 | 4,180.00 | 16.40 | |||||||||||||||||
71 | 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 | |||||||||||||||||
72 | 001-0000-5173-1050-00005-1 | SA HS BASEBALL CLUB | 4,302.00 | 290.00 | 470.00 | 3,832.00 | 0.00 | 3,832.00 | 10.93 | |||||||||||||||||
73 | 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 | |||||||||||||||||
74 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 74.00 | 1,406.00 | 1,075.00 | 0.00 | 1,075.00 | 56.67 | |||||||||||||||||
75 | 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 | |||||||||||||||||
76 | 001-0000-5173-1050-00012-1 | SA HS TRACK CLUB REV | 0.00 | 361.00 | 361.00 | (361.00) | 0.00 | (361.00) | 0.00 | |||||||||||||||||
77 | 001-0000-5173-1050-00013-1 | SA HS VB CLUB | 10,290.00 | 3,564.15 | 7,084.15 | 3,205.85 | 0.00 | 3,205.85 | 68.84 | |||||||||||||||||
78 | 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 | |||||||||||||||||
79 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 10.00 | 4,025.21 | (450.21) | 0.00 | (450.21) | 112.59 | |||||||||||||||||
80 | 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 | |||||||||||||||||
81 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 966.26 | 1,316.26 | 205.74 | 0.00 | 205.74 | 86.48 | |||||||||||||||||
82 | 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 | |||||||||||||||||
83 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 40.00 | 85.00 | 838.00 | 0.00 | 838.00 | 9.21 | |||||||||||||||||
84 | 001-0000-5173-1050-00032-1 | SA HS BAND CLUB | 11,998.00 | 1,022.50 | 1,897.00 | 10,101.00 | 0.00 | 10,101.00 | 15.81 | |||||||||||||||||
85 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
86 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
87 | 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 | |||||||||||||||||
88 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 100.00 | 235.00 | 169.00 | 0.00 | 169.00 | 58.17 | |||||||||||||||||
89 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 27,915.00 | 8,981.00 | 19,731.00 | 8,184.00 | 0.00 | 8,184.00 | 70.68 | |||||||||||||||||
90 | 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 | |||||||||||||||||
91 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 20.00 | 370.00 | 630.00 | 0.00 | 630.00 | 37.00 | |||||||||||||||||
92 | 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 | |||||||||||||||||
93 | 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 | |||||||||||||||||
94 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 130.00 | 130.00 | 50.00 | 0.00 | 50.00 | 72.22 | |||||||||||||||||
95 | 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 | |||||||||||||||||
96 | 001-0000-5173-1050-00061-1 | SA HS CLASS OF 24 | 0.00 | 1,356.00 | 1,616.00 | (1,616.00) | 0.00 | (1,616.00) | 0.00 | |||||||||||||||||
97 | 001-0000-5173-1050-00062-1 | SA HS CLASS OF 26 | 55,836.00 | 110.00 | 985.00 | 54,851.00 | 0.00 | 54,851.00 | 1.76 | |||||||||||||||||
98 | 001-0000-5173-1050-00065-1 | SA HS STEM | 0.00 | 6,020.00 | 6,085.00 | (6,085.00) | 0.00 | (6,085.00) | 0.00 | |||||||||||||||||
99 | 001-0000-5173-1050-00066-1 | SA HS CLASS OF 23 | 9,120.00 | 13,840.99 | 24,870.34 | (15,750.34) | 0.00 | (15,750.34) | 272.70 | |||||||||||||||||
100 | 001-0000-5173-1050-00068-1 | SA HS CLASS OF 25 | 0.00 | 30.00 | 540.00 | (540.00) | 0.00 | (540.00) | 0.00 |