| 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 | NOVEMBER 24 | |||||||||||||||||||||||||
3 | Assets | |||||||||||||||||||||||||
4 | 001-0000-1111-0000-00000-0 | CASH | 1,748,546.12 | 221,965.35 | (183,751.32) | 1,564,794.80 | (27,104.27) | 1,537,690.53 | ||||||||||||||||||
5 | 002-0000-1111-0000-00000-0 | CASH | 0.00 | 411,156.69 | 374,998.96 | 374,998.96 | (3,913.49) | 371,085.47 | ||||||||||||||||||
6 | 004-0000-1111-0000-00000-0 | CASH | 0.00 | 59,341.18 | 59,341.19 | 59,341.19 | 0.00 | 59,341.19 | ||||||||||||||||||
7 | Subtotal | 0000-1111-0000-00000-0 | 1,748,546.12 | 692,463.22 | 250,588.83 | 1,999,134.95 | (31,017.76) | 1,968,117.19 | ||||||||||||||||||
8 | 001-0000-1113-0000-00000-0 | CASH-ALTON BANK | 4,788,648.63 | (594,456.42) | (210,447.65) | 4,578,200.98 | (328,902.90) | 4,249,298.08 | ||||||||||||||||||
9 | 002-0000-1113-0000-00000-0 | CASH-ALTON BANK | 0.00 | (1,034,041.92) | (363,960.80) | (363,960.80) | (98,946.59) | (462,907.39) | ||||||||||||||||||
10 | 004-0000-1113-0000-00000-0 | CASH-ALTON BANK | 2,437,140.40 | (2,068.94) | 198,581.04 | 2,635,721.44 | (86,750.54) | 2,548,970.90 | ||||||||||||||||||
11 | Subtotal | 0000-1113-0000-00000-0 | 7,225,789.03 | (1,630,567.28) | (375,827.41) | 6,849,961.62 | (514,600.03) | 6,335,361.59 | ||||||||||||||||||
12 | 001-0000-1114-0000-00000-0 | CASH-ALTON BANK-SENIOR ACCT | 68,158.14 | 3,525.46 | 24,882.08 | 93,040.22 | 0.00 | 93,040.22 | ||||||||||||||||||
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 | 69,658.14 | 3,525.46 | 24,882.08 | 94,540.22 | 0.00 | 94,540.22 | ||||||||||||||||||
15 | 001-0000-1132-0000-00000-0 | PETTY CASH | 200.00 | 0.00 | 0.00 | 200.00 | 0.00 | 200.00 | ||||||||||||||||||
16 | Subtotal | Assets | 9,044,193.29 | (934,578.60) | (100,356.50) | 8,943,836.79 | (545,617.79) | 8,398,219.00 | ||||||||||||||||||
17 | ||||||||||||||||||||||||||
18 | Liabilities | |||||||||||||||||||||||||
19 | 001-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | (142.40) | 2,119.55 | 2,119.55 | (18.42) | 2,101.13 | ||||||||||||||||||
20 | 002-0000-2154-0000-00000-0 | GROUP INS PAYABLE | 0.00 | (16,558.08) | (15,116.53) | (15,116.53) | 16,272.48 | 1,155.95 | ||||||||||||||||||
21 | Subtotal | 0000-2154-0000-00000-0 | 0.00 | (16,700.48) | (12,996.98) | (12,996.98) | 16,254.06 | 3,257.08 | ||||||||||||||||||
22 | 001-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | 0.00 | 4.21 | 4.21 | 626.00 | 630.21 | ||||||||||||||||||
23 | 002-0000-2156-0000-00000-0 | Group Health and Life Insurance | 0.00 | (65,496.09) | (65,486.69) | (65,486.69) | 65,496.09 | 9.40 | ||||||||||||||||||
24 | Subtotal | 0000-2156-0000-00000-0 | 0.00 | (65,496.09) | (65,482.48) | (65,482.48) | 66,122.09 | 639.61 | ||||||||||||||||||
25 | Subtotal | Liabilities | 0.00 | (82,196.57) | (78,479.46) | (78,479.46) | 82,376.15 | 3,896.69 | ||||||||||||||||||
26 | ||||||||||||||||||||||||||
27 | Fund Balances | |||||||||||||||||||||||||
28 | 001-0000-3111-0000-00000-0 | FUND BALANCE | (6,605,552.89) | 0.00 | 0.00 | (6,605,552.89) | 0.00 | (6,605,552.89) | ||||||||||||||||||
29 | 004-0000-3111-0000-00000-0 | FUND BALANCE | (2,438,640.40) | 0.00 | 0.00 | (2,438,640.40) | 0.00 | (2,438,640.40) | ||||||||||||||||||
30 | Subtotal | 0000-3111-0000-00000-0 | (9,044,193.29) | 0.00 | 0.00 | (9,044,193.29) | 0.00 | (9,044,193.29) | ||||||||||||||||||
31 | Subtotal | (9,044,193.29) | 0.00 | 0.00 | (9,044,193.29) | 0.00 | (9,044,193.29) | |||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | Revenues | |||||||||||||||||||||||||
34 | Object 51xx | |||||||||||||||||||||||||
35 | 001-0000-5111-0000-00000-1 | CURRENT TAXES | 2,425,342.00 | 0.00 | 0.03 | 2,425,341.97 | 0.00 | 2,425,341.97 | 0.00 | |||||||||||||||||
36 | 004-0000-5111-0000-00000-1 | CURRENT TAXES | 529,320.00 | 0.00 | 0.01 | 529,319.99 | 0.00 | 529,319.99 | 0.00 | |||||||||||||||||
37 | Subtotal | 0000-5111-0000-00000-1 | 2,954,662.00 | 0.00 | 0.04 | 2,954,661.96 | 0.00 | 2,954,661.96 | 0.00 | |||||||||||||||||
38 | 001-0000-5112-0000-00000-1 | DELINQUENT TAXES | 210,384.00 | 8,521.26 | 71,484.98 | 138,899.02 | 0.00 | 138,899.02 | 33.98 | |||||||||||||||||
39 | 004-0000-5112-0000-00000-1 | DELINQUENT TAXES | 43,610.00 | 2,051.02 | 17,791.79 | 25,818.21 | 0.00 | 25,818.21 | 40.80 | |||||||||||||||||
40 | Subtotal | 0000-5112-0000-00000-1 | 253,994.00 | 10,572.28 | 89,276.77 | 164,717.23 | 0.00 | 164,717.23 | 35.15 | |||||||||||||||||
41 | 001-0000-5113-0000-00000-1 | PROP C NEW MONIES | 1,300,010.00 | 165,349.34 | 734,047.24 | 565,962.76 | 0.00 | 565,962.76 | 56.46 | |||||||||||||||||
42 | 002-0000-5113-0000-00000-1 | PROP C NEW MONIES | 557,147.00 | 41,337.34 | 197,537.26 | 359,609.74 | 0.00 | 359,609.74 | 35.46 | |||||||||||||||||
43 | Subtotal | 0000-5113-0000-00000-1 | 1,857,157.00 | 206,686.68 | 931,584.50 | 925,572.50 | 0.00 | 925,572.50 | 50.16 | |||||||||||||||||
44 | 004-0000-5114-0000-00000-1 | FIN INST/INTANGIBLE | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
45 | 004-0000-5115-0000-00000-1 | M & M SURTAX | 35,000.00 | 7.52 | 319.69 | 34,680.31 | 0.00 | 34,680.31 | 0.91 | |||||||||||||||||
46 | 004-0000-5116-0000-00000-1 | IN LIEU OF TAXES | 500.00 | 0.00 | 0.00 | 500.00 | 0.00 | 500.00 | 0.00 | |||||||||||||||||
47 | 001-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 203,827.00 | 33,903.97 | 179,085.14 | 24,741.86 | 0.00 | 24,741.86 | 87.86 | |||||||||||||||||
48 | 002-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 0.00 | 0.00 | 70.74 | (70.74) | 0.00 | (70.74) | 0.00 | |||||||||||||||||
49 | 004-0000-5141-0000-00000-1 | EARNINGS ON INVEST | 44,484.00 | 426.85 | 3,409.20 | 41,074.80 | 0.00 | 41,074.80 | 7.66 | |||||||||||||||||
50 | Subtotal | 0000-5141-0000-00000-1 | 248,311.00 | 34,330.82 | 182,565.08 | 65,745.92 | 0.00 | 65,745.92 | 73.52 | |||||||||||||||||
51 | 001-0000-5151-0000-00000-1 | STUDENT FOOD SERVICE | 75,000.00 | 8,214.84 | 30,448.44 | 44,551.56 | 0.00 | 44,551.56 | 40.60 | |||||||||||||||||
52 | 001-0000-5161-0000-00000-1 | ADULT FOOD SERVICE | 8,500.00 | 1,168.04 | 4,669.65 | 3,830.35 | 0.00 | 3,830.35 | 54.94 | |||||||||||||||||
53 | 001-0000-5165-0000-00000-1 | NON PROGRAM MILK | 200.00 | 4.50 | 56.50 | 143.50 | 0.00 | 143.50 | 28.25 | |||||||||||||||||
54 | 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 | |||||||||||||||||
55 | 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 | |||||||||||||||||
56 | 001-0000-5171-1050-00005-1 | SA HS BASEBALL | 0.00 | 0.00 | 300.00 | (300.00) | 0.00 | (300.00) | 0.00 | |||||||||||||||||
57 | 001-0000-5171-1050-00006-1 | SA HS FOOTBALL | 13,000.00 | 0.00 | 3,492.75 | 9,507.25 | 0.00 | 9,507.25 | 26.87 | |||||||||||||||||
58 | 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 | |||||||||||||||||
59 | 001-0000-5171-1050-00010-1 | SA HS SOCCER | 100.00 | 0.00 | 0.00 | 100.00 | 0.00 | 100.00 | 0.00 | |||||||||||||||||
60 | 001-0000-5171-1050-00012-1 | SA HS TRACK REVENUE | 200.00 | 0.00 | 600.00 | (400.00) | 0.00 | (400.00) | 300.00 | |||||||||||||||||
61 | 001-0000-5171-1050-00013-1 | SA HS VOLLEYBALL | 2,500.00 | 250.00 | 1,960.00 | 540.00 | 0.00 | 540.00 | 78.40 | |||||||||||||||||
62 | 001-0000-5171-1050-00050-1 | SA HS YEARBOOK | 10,000.00 | 1,550.00 | 5,725.00 | 4,275.00 | 0.00 | 4,275.00 | 57.25 | |||||||||||||||||
63 | 001-0000-5171-3000-00001-1 | SA MS BOYS BB | 900.00 | 0.00 | 0.00 | 900.00 | 0.00 | 900.00 | 0.00 | |||||||||||||||||
64 | 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 | |||||||||||||||||
65 | 001-0000-5171-3000-00006-1 | SA MS FOOTBALL | 1,000.00 | 0.00 | 1,148.95 | (148.95) | 0.00 | (148.95) | 114.90 | |||||||||||||||||
66 | 001-0000-5171-3000-00013-1 | SA MS VOLLEYBALL | 800.00 | 0.00 | 898.00 | (98.00) | 0.00 | (98.00) | 112.25 | |||||||||||||||||
67 | 001-0000-5173-0000-00024-1 | SA EA SODA CLUB | 0.00 | 0.00 | 19.32 | (19.32) | 0.00 | (19.32) | 0.00 | |||||||||||||||||
68 | 001-0000-5173-0000-00099-1 | SA EA BCK TO SCH KICKOFF | 0.00 | 0.00 | 8,875.88 | (8,875.88) | 0.00 | (8,875.88) | 0.00 | |||||||||||||||||
69 | 001-0000-5173-1050-00001-1 | SA HS BOYS BB CLUB | 5,000.00 | 0.00 | 792.00 | 4,208.00 | 0.00 | 4,208.00 | 15.84 | |||||||||||||||||
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 | 270.00 | 270.00 | 4,032.00 | 0.00 | 4,032.00 | 6.28 | |||||||||||||||||
72 | 001-0000-5173-1050-00006-1 | SA HS FOOTBALL CLUB | 0.00 | 0.00 | 7,420.25 | (7,420.25) | 0.00 | (7,420.25) | 0.00 | |||||||||||||||||
73 | 001-0000-5173-1050-00008-1 | SA HS FB CHEER CLUB | 2,481.00 | 0.00 | 390.00 | 2,091.00 | 0.00 | 2,091.00 | 15.72 | |||||||||||||||||
74 | 001-0000-5173-1050-00009-1 | SA HS GOLF CLUB REVEN | 0.00 | 0.00 | 250.00 | (250.00) | 0.00 | (250.00) | 0.00 | |||||||||||||||||
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-00013-1 | SA HS VB CLUB | 10,290.00 | 3,647.00 | 3,647.00 | 6,643.00 | 0.00 | 6,643.00 | 35.44 | |||||||||||||||||
77 | 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 | |||||||||||||||||
78 | 001-0000-5173-1050-00023-1 | SA HS GEN ACT CLUB | 3,575.00 | 9.74 | 2,953.97 | 621.03 | 0.00 | 621.03 | 82.63 | |||||||||||||||||
79 | 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 | |||||||||||||||||
80 | 001-0000-5173-1050-00025-1 | SA HS STU CO CLUB | 1,522.00 | 256.00 | 1,620.00 | (98.00) | 0.00 | (98.00) | 106.44 | |||||||||||||||||
81 | 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 | |||||||||||||||||
82 | 001-0000-5173-1050-00030-1 | SA HS HON SOC CLUB | 923.00 | 705.00 | 705.00 | 218.00 | 0.00 | 218.00 | 76.38 | |||||||||||||||||
83 | 001-0000-5173-1050-00032-1 | SA HS BAND CLUB | 5,998.00 | 0.00 | 1,000.00 | 4,998.00 | 0.00 | 4,998.00 | 16.67 | |||||||||||||||||
84 | 001-0000-5173-1050-00034-1 | SA HS CHOIR CLUB | 653.00 | 0.00 | 0.00 | 653.00 | 0.00 | 653.00 | 0.00 | |||||||||||||||||
85 | 001-0000-5173-1050-00036-1 | SA HS CONCESS CLUB | 420.00 | 0.00 | 0.00 | 420.00 | 0.00 | 420.00 | 0.00 | |||||||||||||||||
86 | 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 | |||||||||||||||||
87 | 001-0000-5173-1050-00039-1 | SA HS FBLA CLUB | 404.00 | 20.00 | 420.00 | (16.00) | 0.00 | (16.00) | 103.96 | |||||||||||||||||
88 | 001-0000-5173-1050-00040-1 | SA HS FFA CLUB | 47,232.00 | 1,247.00 | 9,266.00 | 37,966.00 | 0.00 | 37,966.00 | 19.62 | |||||||||||||||||
89 | 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 | |||||||||||||||||
90 | 001-0000-5173-1050-00044-1 | SA HS PEP CLUB | 1,000.00 | 0.00 | 140.00 | 860.00 | 0.00 | 860.00 | 14.00 | |||||||||||||||||
91 | 001-0000-5173-1050-00048-1 | SA HS SPEC LB CLUB | 841.00 | 0.00 | 19.69 | 821.31 | 0.00 | 821.31 | 2.34 | |||||||||||||||||
92 | 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 | |||||||||||||||||
93 | 001-0000-5173-1050-00053-1 | SA HS FTA CLUB | 180.00 | 75.00 | 274.00 | (94.00) | 0.00 | (94.00) | 152.22 | |||||||||||||||||
94 | 001-0000-5173-1050-00060-1 | SA HS CLASS OF 27 | 23,757.00 | 265.00 | 761.68 | 22,995.32 | 0.00 | 22,995.32 | 3.21 | |||||||||||||||||
95 | 001-0000-5173-1050-00061-1 | SA HS CLASS OF 24 | 0.00 | 0.00 | (1,546.68) | 1,546.68 | 0.00 | 1,546.68 | 0.00 | |||||||||||||||||
96 | 001-0000-5173-1050-00062-1 | SA HS CLASS OF 26 | 49,555.00 | 1,775.00 | 4,740.00 | 44,815.00 | 0.00 | 44,815.00 | 9.57 | |||||||||||||||||
97 | 001-0000-5173-1050-00063-1 | SA HS YOUTH ALIVE | 0.00 | 0.00 | 220.00 | (220.00) | 0.00 | (220.00) | 0.00 | |||||||||||||||||
98 | 001-0000-5173-1050-00066-1 | SA HS CLASS OF 28 | 9,120.00 | 0.00 | 503.00 | 8,617.00 | 0.00 | 8,617.00 | 5.52 | |||||||||||||||||
99 | 001-0000-5173-1050-00068-1 | SA HS CLASS OF 25 | 0.00 | 2,745.00 | 28,240.96 | (28,240.96) | 0.00 | (28,240.96) | 0.00 | |||||||||||||||||
100 | 001-0000-5173-1050-00070-1 | SA HS BUSY HANDS CLUB | 4,825.00 | 123.00 | 538.00 | 4,287.00 | 0.00 | 4,287.00 | 11.15 |