Sep 25, 2017 - NOW, THEREFORE, Be it resolved by the Board of Education of said district as follows: ..... CAREER AND TE
ILLINOIS STATE BOARD OF EDUCATION School Business Services Division Accounting Basis:
X
SCHOOL DISTRICT BUDGET FORM * July 1, 2017 - June 30, 2018
Cash Accrual
Balanced budget, no deficit reduction plan is required.
Date of Amended Budget: (MM/DD/YY)
Lindop School District 92
District Name: District RCDT No:
If your FY17 AFR states that you need to do a deficit reduction plan and your FY18 budget is balanced please state the measures you took to have your budget become balanced. (Bckgrnd-Assumpt 25-26) Lindop School District 92
Budget of
July 1, 2017
State of Illinois, for the Fiscal Year beginning
Cook
,
,
and ending
June 30, 2018
.
Lindop School District 92
WHEREAS the Board of Education of
County of
Cook
, County of
,
State of Illinois, caused to be prepared in tentative form a budget, and the Secretary
of this Board has made the same conveniently available to public inspection for at least thirty days prior to final action thereon;
AND WHEREAS a public hearing was held as to such budget on the
day of
,
20
,
notice of said hearing was given at least thirty days prior thereto as required by law, and all other legal requirements have been complied with; NOW, THEREFORE, Be it resolved by the Board of Education of said district as follows: Section 1: That the fiscal year of this school district be and the same hereby is fixed and declared to be
July 1, 2017
beginning
and ending
June 30, 2018
.
Section 2: That the following budget containing an estimate of amounts available in each Fund, separately, and expenditures from each be and the same is hereby adopted as the budget of this school district for said fiscal year.
ADOPTION OF BUDGET The budget shall be approved and signed below by members of the School Board. Adopted this Adopted this day of , 20 by a roll call vote of Yeas, and
** MEMBERS VOTING YEA:
Nays, to wit:
** MEMBERS VOTING NAY:
* Based on the 23 Illinois Administrative CodePart 100 and inconformity with Section 171 of the School Code. ** Type in the members who voted "YEA" nor "NAY". Actual school board member signatures are not required for electronic submission. (1) A certified copy of this document must be filed with the county clerk within 30 days of adoption as required by Section 1850 of the Property Tax Code (35 ILCS 200/1850). (2) Districts are required to submit the adopted/amended budget electronically to ISBE within 30 days of adoption or by October 30, whichever comes first. Budgets are submitted to School Finance Report (SFR): https://sec1.isbe.net/attachmgr/default.aspx The electronic version does not require member signatures. ISBE 5036 SB2018 05/17 Lindop School District 92 ---
41283342.xlsx
BUDGET SUMMARY
Page 2 1
A Begin entering data on EstRev 5-10 and EstExp 11-17 tabs.
B Acct #
Description (Enter Whole Numbers Only)
2 3 ESTIMATED BEGINNING FUND BALANCE July 1, 2017 1 4 RECEIPTS/REVENUES 5 LOCAL SOURCES 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
1000
FLOW-THROUGH RECEIPTS/REVENUES FROM ONE DISTRICT TO ANOTHER DISTRICT STATE SOURCES FEDERAL SOURCES Total Direct Receipts/Revenues 8 Receipts/Revenues for "On Behalf" Payments 2
2000 3000 4000
C (10) Educational
D (20) Operations & Maintenance
E (30) Debt Service
Page 2
F (40) Transportation
G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security 247,417 59,230 1,860,114
6,222,049
368,379
30,069
45,876
4,043,765
460,473
459,833
432,430
655,500
375
0 1,417,114 879,288 6,340,167
0 0 0 460,473
0 0 459,833
0 0 0 432,430
0 0 0 655,500
6,340,167
460,473
459,833
432,430
655,500
3,252,957 2,066,267 0 795,000 0 0
684,050 0 29,000 0 0
0 425,522 0
160,000 0 125,000 0 0
57,967 136,212 0 0 0 0
6,114,224
713,050
425,522
285,000
194,179
0 6,114,224
0 713,050
0 425,522
0 285,000
(252,577)
34,311
147,430
J (80) Tort
K (90) Fire Prevention & Safety
110,770
183,627
50,376
372,000
80,852
0 0 375
0 0 50,376
0 0 372,000
0 0 80,852
375
50,376
372,000
80,852
420,000
0
15,000
0 0
0 0 0
0 0 0
420,000
0
15,000
0 194,179
0 420,000
0 0
0 15,000
461,321
(419,625)
50,376
372,000
65,852
0
0
0
3998
Total Receipts/Revenues DISBURSEMENTS/EXPENDITURES INSTRUCTION SUPPORT SERVICES COMMUNITY SERVICES PAYMENTS TO OTHER DISTRICTS & GOVT UNITS DEBT SERVICES PROVISION FOR CONTINGENCIES Total Direct Disbursements/Expenditures
1000 2000 3000 4000 5000 6000
9
Disbursements/Expenditures for "On Behalf" Payments 2
4180
Total Disbursements/Expenditures Excess of Direct Receipts/Revenues Over (Under) Direct Disbursements/Expenditures
225,943
23 OTHER SOURCES/USES OF FUNDS 24 OTHER SOURCES OF FUNDS (7000) 25 PERMANENT TRANSFER FROM VARIOUS FUNDS 26 27 28 29 30 31 32
Abolishment the Working Cash Fund 16
7110
Abatement of the Working Cash Fund 16 Transfer of Working Cash Fund Interest Transfer Among Funds Transfer of Interest Transfer from Capital Projects Fund to O&M Fund
7110
Transfer of Excess Fire Prev & Safety Tax & Interest 3 Proceeds to O&M Fund
Transfer of Excess Accumulated Fire Prev & Safety Bond and Int 3a 33 Proceeds to Debt Service Fund 34 SALE OF BONDS (7200)
35 36 37 38 39 40 41 42 43 44 45 46
Principal on Bonds Sold 4 Premium on Bonds Sold Accrued Interest on Bonds Sold
0 0
7170
0 7210
Sale or Compensation for Fixed Assets 5 Transfer to Debt Service to Pay Principal on Capital Leases Transfer to Debt Service Fund to Pay Interest on Capital Leases Transfer to Debt Service Fund to Pay Principal on Revenue Bonds Transfer to Debt Service Fund to Pay Interest on Revenue Bonds Transfer to Capital Projects Fund ISBE Loan Proceeds Other Sources Not Classified Elsewhere Total Other Sources of Funds
512,000
7120 7130 7140 7150 7160
8
7220 7230 7300
0 0 0 0
7400 7500 7600 7700 7800 7900 7990
0
0
0
0
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
0
512,000
9/25/2017
L
BUDGET SUMMARY
Page 3 1
A Begin entering data on EstRev 5-10 and EstExp 11-17 tabs.
Acct #
Description (Enter Whole Numbers Only)
2 47 48 OTHER USES OF FUNDS (8000) 49 TRANSFER TO VARIOUS OTHER FUNDS (8100) 16 50 Abolishment or Abatement of the Working Cash Fund 51 Transfer of Working Cash Fund Interest 52 Transfer Among Funds 6 53 Transfer of Interest 54 Transfer from Capital Projects Fund to O&M Fund 55
Transfer of Excess Fire Prev & Safety Tax & Interest Proceeds to O&M Fund
B
3
Transfer of Excess Accumulated Fire Prev & Safety Bond 3a
56 and Int Proceeds to Debt Service Fund 57 Taxes Pledged to Pay Principal on Capital Leases 58 Grants/Reimbursements Pledged to Pay Principal on Capital Leases 59 Other Revenues Pledged to Pay Principal on Capital Leases 60 Fund Balance Transfers Pledged to Pay Principal on Capital Leases 61 Taxes Pledged to Pay Interest on Capital Leases 62 Grants/Reimbursements Pledged to Pay Interest on Capital Leases 63 Other Revenues Pledged to Pay Interest on Capital Leases 64 Fund Balance Transfers Pledged to Pay Interest on Capital Leases 65 Taxes Pledged to Pay Principal on Revenue Bonds 66 Grants/Reimbursements Pledged to Pay Principal on Revenue Bonds 67 Other Revenues Pledged to Pay Principal on Revenue Bonds 68 Fund Balance Transfers Pledged to Pay Principal on Revenue Bonds 69 Taxes Pledged to Pay Interest on Revenue Bonds 70 Grants/Reimbursements Pledged to Pay Interest on Revenue Bonds 71 Other Revenues Pledged to Pay Interest on Revenue Bonds 72 Fund Balance Transfers Pledged to Pay Interest on Revenue Bonds 73 Taxes Transferred to Pay for Capital Projects 74 Grants/Reimbursements Pledged to Pay for Capital Projects 75 Other Revenues Pledged to Pay for Capital Projects 76 Fund Balance Transfers Pledged to Pay for Capital Projects 77 Transfer to Debt Service Fund to Pay Principal on ISBE Loans 78 Other Uses Not Classified Elsewhere Total Other Uses of Funds 9 79 Total Other Sources/Uses of Fund 80 81 ESTIMATED ENDING FUND BALANCE June 30, 2018
C (10) Educational
D (20) Operations & Maintenance
E (30) Debt Service
F (40) Transportation
Page 3 G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security
J (80) Tort
K (90) Fire Prevention & Safety
L
512,000 0
8110 8120 8130 8140 8150 8160 8170 8410 8420 8430 8440 8510 8520 8530 8540 8610 8620 8630 8640 8710 8720 8730 8740 8810 8820 8830 8840 8910 8990
0 0 6,447,992
82 83 84
0 0 115,802
0 0 64,380
0 0 193,306
0 0 708,738
0 512,000 151,605
512,000 (512,000) 1,398,490
0 0 482,770
0 0 249,479
SUMMARY OF EXPENDITURES (by Major Object) Description
85 86 Object Name 87 Salaries 88 Employee Benefits 89 Purchased Services 90 Supplies & Materials 91 Capital Outlay 92 Other Objects 93 NonCapitalized Equipment 94 Termination Benefits Total Expenditures 95
Acct #
100 200 300 400 500 600 700 800
(10)
(20)
(30)
(40)
Educational
Operations & Maintenance
Debt Service
Transportation
3,718,972 668,252 550,900 211,200 157,000 801,900 6,000 0 6,114,224
210,500 53,000 264,000 161,550 24,000 0 0 0 713,050
0
425,522
425,522
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0 0 285,000 0 0 0 0 0 285,000
(50)
(60)
(70)
Municipal Capital Projects Working Cash Retirement/ Social Security
194,179
0
194,179
(80)
(90)
Tort
Fire Prevention Total By Object & Safety
0 0 0 0 420,000 0 0
0 0 0 0 0 0 0
0 0 15,000 0 0 0 0
420,000
0
15,000
9/25/2017
3,929,472 915,431 1,114,900 372,750 601,000 1,227,422 6,000 0 8,166,975
SUMMARY OF CASH TRANSACTIONS
Page 4
A
B
1 Description (Enter Whole Numbers Only)
2 7 3 BEGINNING CASH BALANCE ON HAND July 1, 2017 Total Direct Receipts & Other Sources 8 4 5 OTHER RECEIPTS Interfund Loans Payable (Loans from Other Funds) 6 Interfund Loans Receivable (Repayment of Loans) 7 Notes and Warrants Payable 8 Other Current Assets 9 Total Other Receipts 10 Total Direct Receipts, Other Sources, & Other Receipts 11 Total Amount Available 12 Total Direct Disbursements & Other Uses 9 13
Acct #
Page 4
C
D
E
F
G
H
I
J
K
(10)
(20)
(30)
(40)
(60)
(70)
(80)
(90)
Educational
Operations & Maintenance
Debt Service
Transportation
(50) Municipal Retirement/ Social Security
Capital Projects
Working Cash
Tort
Fire Prevention & Safety
6,222,049 6,340,167
368,379 460,473
30,069 459,833
45,876 432,430
247,417 655,500
59,230 512,375
1,860,114 50,376
110,770 372,000
183,627 80,852
0 6,340,167 12,562,216 6,114,224
0 460,473 828,852 713,050
0 459,833 489,902 425,522
0 432,430 478,306 285,000
0 655,500 902,917 194,179
0 512,375 571,605 420,000
0 50,376 1,910,490 512,000
0 372,000 482,770 0
0 80,852 264,479 15,000
0 6,114,224 6,447,992
0 713,050 115,802
0 425,522 64,380
0 285,000 193,306
0 194,179 708,738
0 420,000 151,605
0 512,000 1,398,490
0 0 482,770
0 15,000 249,479
411 141 433 199
14 OTHER DISBURSEMENTS 10 141 15 Interfund Loans Receivable (Loans to Other Funds) 411 16 Interfund Loans Payable (Repayment of Loans) 433 17 Notes and Warrants Payable 499 18 Other Current Liabilities Total Other Disbursements 19 Total Direct Disbursements, Other Uses, & Other Disbursements 20 7 21 ENDING CASH BALANCE ON HAND June 30, 2018
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
ESTIMATED RECEIPTS/REVENUES
Page 5
A 1 Description (Enter Whole Numbers Only)
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
B
C (10) Acct Educational #
D (20) Operations & Maintenance
E (30) Debt Service
Page 5
F (40) Transportation
G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security
J (80) Tort
K (90) Fire Prevention & Safety
RECEIPTS/REVENUES FROM LOCAL SOURCES (1000) AD VALOREM TAXES LEVIED BY LOCAL EDUCATION AGENCY Designated Purposes Levies
11
Leasing Purposes Levy 12 Special Education Purposes Levy FICA and Medicare Only Levies Area Vocational Construction Purposes Levy Summer School Purposes Levy Other Tax Levies (Describe & Itemize) Total Ad Valorem Taxes Levied by District PAYMENTS IN LIEU OF TAXES Mobile Home Privilege Tax Payments from Local Housing Authority Corporate Personal Property Replacement Taxes 13 Other Payments in Lieu of Taxes (Describe & Itemize) Total Payments in Lieu of Taxes
TUITION Regular Tuition from Pupils or Parents (In State) Regular Tuition from Other Districts (In State) Regular Tuition from Other Sources (In State) Regular Tuition from Other Sources (Out of State) Summer School Tuition from Pupils or Parents (In State) Summer School Tuition from Other Districts (In State) Summer School Tuition from Other Sources (In State) Summer School Tuition from Other Sources (Out of State) CTE Tuition from Pupils or Parents (In State) CTE Tuition from Other Districts (In State) CTE Tuition from Other Sources (In State) CTE Tuition from Other Sources (Out of State) Special Education Tuition from Pupils or Parents (In State) Special Education Tuition from Other Districts (In State) Special Education Tuition from Other Sources (In State) Special Education Tuition from Other Sources (Out of State) Adult Tuition from Pupils or Parents (In State) Adult Tuition from Other Districts (In State) Adult Tuition from Other Sources (In State) Adult Tuition from Other Sources (Out of State) Total Tuition
TRANSPORTATION FEES Regular Transportation Fees from Pupils or Parents (In State) Regular Transportation Fees from Other Districts (In State) Regular Transportation Fees from Other Sources (In State) Regular Transportation Fees from Cocurricular Activities (In State) Regular Transportation Fees from Other Sources (Out of State) Summer School Transportation Fees from Pupils or Parents (In State) Summer School Transportation Fees from Other Districts (In State) Summer School Transportation Fees from Other Sources (In State) Summer School Transportation Fees from Other Sources (Out of State) CTE Transportation Fees from Pupils or Parents (In State) CTE Transportation Fees from Other Districts (In State) CTE Transportation Fees from Other Sources (In State) CTE Transportation Fees from Other Sources (Out of State)
1100
1130 1140 1150 1160 1170 1190
3,114,315
446,473
459,083
403,930
654,750
446,473
459,083
403,930
654,750
0
0
0
0
40,876
371,500
80,102
0
40,876
371,500
80,102
0
0
0
0
324,707
3,439,022 1200 1210 1220 1230 1290
210,000 210,000
1300 1311 1312 1313 1314 1321 1322 1323 1324 1331 1332 1333 1334 1341 1342 1343 1344 1351 1352 1353 1354
0 1400 1411 1412 1413 1415 1416 1421 1422 1423 1424
20,000
1431 1432 1433 1434
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
ESTIMATED RECEIPTS/REVENUES
Page 6
A 1 Description (Enter Whole Numbers Only)
2 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
Special Education Transportation Fees from Pupils or Parents (In State) Special Education Transportation Fees from Other Districts (In State) Special Education Transportation Fees from Other Sources (In State) Special Education Transportation Fees from Other Sources (Out of State) Adult Transportation Fees from Pupils or Parents (In State) Adult Transportation Fees from Other Districts (In State) Adult Transportation Fees from Other Sources (In State) Adult Transportation Fees from Other Sources (Out of State) Total Transportation Fees
EARNINGS ON INVESTMENTS Interest on Investments Gain or Loss on Sale of Investments Total Earnings on Investments
FOOD SERVICE Sales to Pupils Lunch Sales to Pupils Breakfast Sales to Pupils A la Carte Sales to Pupils Other (Describe & Itemize) Sales to Adults Other Food Service (Describe & Itemize) Total Food Service
DISTRICT/SCHOOL ACTIVITY INCOME Admissions Athletic Admissions Other Fees Book Store Sales Other District/School Activity Revenue (Describe & Itemize) Total District/School Activity Income
TEXTBOOK INCOME Rentals Regular Textbooks Rentals Summer School Textbooks Rentals Adult/Continuing Education Textbooks Rentals Other (Describe) Sales Regular Textbooks Sales Summer School Textbooks Sales Adult/Continuing Education Textbooks Sales Other (Describe & Itemize) Other (Describe & Itemize) Total Textbooks
OTHER REVENUE FROM LOCAL SOURCES Rentals Contributions and Donations from Private Sources Impact Fees from Municipal or County Governments Services Provided Other Districts Refund of Prior Years' Expenditures Payments of Surplus Moneys from TIF Districts Drivers' Education Fees Proceeds from Vendors' Contracts School Facility Occupation Tax Proceeds Payment from Other Districts
B
C (10) Acct Educational #
D (20) Operations & Maintenance
E (30) Debt Service
Page 6
F (40) Transportation
G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security
J (80) Tort
K (90) Fire Prevention & Safety
1441 1442 1443 1444 1451 1452 1453 1454
20,000 1500 1510 1520 1600 1611 1612 1613 1614 1620 1690
32,063
3,000
750
4,500
750
375
9,500
500
750
32,063
3,000
750
4,500
750
375
9,500
500
750
22,680 22,680
1700 1711 1719 1720 1730 1790
48,000
48,000
0
1800 1811 1812 1813 1819 1821 1822 1823 1829 1890
0 1900 1910 1920 1930 1940 1950 1960 1970 1980 1983 1991
85,000 200,000
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
4,000
4,000
9/25/2017
ESTIMATED RECEIPTS/REVENUES
Page 7
A 1 Description
2 105 106 107 108 109
(Enter Whole Numbers Only) Sale of Vocational Projects Other Local Fees (Describe & Itemize) Other Local Revenues (Describe & Itemize) Total Other Revenue from Local Sources Total Receipts/Revenues from Local Sources
FLOW-THROUGH RECEIPTS/REVENUES FROM ONE 110 DISTRICT TO ANOTHER DISTRICT (2000) 111 FlowThrough Revenue from State Sources 112 FlowThrough Revenue from Federal Sources 113 Other FlowThrough Revenue (Describe & Itemize)
114
Total Flow-Through Receipts/Revenues From One District to Another District
RECEIPTS/REVENUES FROM STATE SOURCES (3000) 115 116 UNRESTRICTED GRANTS-IN-AID (3001-3099) 117 General State Aid (Section 188.05) 118 General State Aid Hold Harmless/Supplemental 119 Reorganization Incentives (Accounts 30053021)
120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154
Other Unrestricted GrantsInAid From State Sources (Describe & Itemize) Total Unrestricted Grants-In-Aid
B
C (10) Acct Educational # 1992 1993 1999
D (20) Operations & Maintenance
7,000 292,000 4,043,765
7,000 11,000 460,473
2000
0
0
3001 3002 3005 3099
1,055,920
1000
E (30) Debt Service
0 459,833
Page 7
F (40) Transportation
G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security
4,000 432,430
0 655,500
0
0
0
0
0 375
0 50,376
J (80) Tort
K (90) Fire Prevention & Safety
0 372,000
0 80,852
0
0
2100 2200 2300
1,055,920
0
0
0
RESTRICTED GRANTS-IN-AID (3100-3900) SPECIAL EDUCATION Special Education Private Facility Tuition Special Education Funding for Children Requiring Sp Ed Services Special Education Personnel Special Education Orphanage Individual Special Education Orphanage Summer Individual Special Education Summer School Special Education Other (Describe & Itemize) Total Special Education CAREER AND TECHNICAL EDUCATION (CTE) CTE Technical Education Tech Prep CTE Secondary Program Improvement (CTEI) CTE WECEP CTE Agriculture Education CTE Instructor Practicum CTE Student Organizations CTE Other (Describe & Itemize) Total Career and Technical Education BILINGUAL EDUCATION Bilingual Education Downstate TPI and TBE Bilingual Education Downstate Transitional Bilingual Education Total Bilingual Education
3100 3105 3110 3120 3130 3145 3199
3,700 228,700
3200 3220 3225 3235 3240 3270 3299
3305 3310 3360
School Breakfast Initiative
3365
Driver Education
3370
Adult Education (from ICCB)
3410
Adult Education Other (Describe & Itemize)
3499
0
0
250
250
State Free Lunch & Breakfast
TRANSPORTATION Transportation Regular and Vocational Transportation Special Education Transportation Other (Describe & Itemize) Total Transportation
35,000 55,000 40,000 95,000
0
0
11,239 11,239 3,000
0
3500 3510 3599
0
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
0
0
9/25/2017
ESTIMATED RECEIPTS/REVENUES
Page 8
A 1 Description
2 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173
(Enter Whole Numbers Only)
B
C (10) Acct Educational #
Learning Improvement Change Grants
3610
Scientific Literacy
3660
Truant Alternative/Optional Education
3695
Early Childhood Block Grant
3705
Reading Improvement Block Grant
3715
Reading Improvement Block Grant Reading Recovery
3720
Continued Reading Improvement Block Grant
3725
Continued Reading Improvement Block Grant (2% Set Aside)
3726
Chicago General Education Block Grant
3766
Chicago Educational Services Block Grant
3767
School Safety & Educational Improvement Block Grant
3775
Technology Technology for Success
3780
State Charter Schools
3815
Extended Learning Opportunities Summer Bridges
3825
Infrastructure Improvements Planning/Construction
3920
School Infrastructure Maintenance Projects
3925
Other Restricted Revenue from State Sources (Describe & Itemize)
3999
D (20) Operations & Maintenance
E (30) Debt Service
Page 8
F (40) Transportation
G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security
J (80) Tort
K (90) Fire Prevention & Safety
118,005
3000
361,194 1,417,114
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
4001 Other Unrestricted GrantsInAid Received Directly from the Federal 4009 Govt. (Describe & Itemize) Total Unrestricted Grants-In-Aid Received Directly from Fed Govt
0
0
0
0
0
0
0
0
0
Other Restricted GrantsInAid Received Directly from Federal Govt. (Describe & Itemize) Total Restricted Grants-In-Aid Received Directly from Federal Govt.
0
0
0
0
0
0
0
0
0
Total Restricted Grants-In-Aid Total Receipts/Revenues from State Sources
RECEIPTS/REVENUES FROM FEDERAL SOURCES (4000) 174 175 UNRESTRICTED GRANTS-IN-AID RECEIVED DIRECTLY Federal Impact Aid FEDERAL GOVT. (4001-4009) 176 FROM
177 178 179 RESTRICTED GRANTS-IN-AID RECEIVED DIRECTLY FROM FEDERAL Head(4045-4090) Start 4045 180 GOVT 4050 181 Construction (Impact Aid) 4060 182 MAGNET 183
184 185 RESTRICTED GRANTS-IN-AID RECEIVED FROM FEDERAL GOVT.VITHRU THE STATE (4100-4999) 186 TITLE 187 Title VI Innovation and Flexibility Formula 188 Title VI SEA Projects 189 Title VI Rural Education Initiative (REI) 190 Title VI Other (Describe & Itemize) Total Title VI 191 192 FOOD SERVICE 193 Breakfast StartUp Expansion 194 National School Lunch Program 195 Special Milk Program 196 School Breakfast Program 197 Summer Food Service Admin/Program 198 Child and Adult Care Food Program 199 Fresh Fruit and Vegetables 200 Food Service Other (Describe & Itemize) Total Food Service 201
4090
0
4100 4105 4107 4199
4200 4210 4215 4220 4225 4226 4240 4299
199,030 110,100
20,000 329,130
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
9/25/2017
ESTIMATED RECEIPTS/REVENUES
Page 9
A 1 Description
2 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254
(Enter Whole Numbers Only) TITLE I Title I Low Income Title I Low Income Neglected, Private Title I Comprehensive School Reform Title I Reading First Title I Even Start Title I Reading First SEA Funds Title I Migrant Education Title I Other (Describe & Itemize) Total Title I TITLE IV Title IV Safe & Drug Free Schools Formula Title IV 21st Century Comm Learning Centers Title IV Other (Describe & Itemize) Total Title IV FEDERAL - SPECIAL EDUCATION Federal Special Education Preschool FlowThrough Federal Special Education Preschool Discretionary Federal Special Education IDEA Flow Through Federal Special Education IDEA Room & Board Federal Special Education IDEA Discretionary Federal Special Education IDEA Other (Describe & Itemize) Total Federal Special Education CTE - PERKINS CTE PerkinsTitle IIIE Tech Prep CTE Other (Describe & Itemize) Total CTE - Perkins
B
C (10) Acct Educational #
4300 4305 4332 4334 4335 4337 4340 4399
4400 4421 4499
4600 4605 4620 4625 4630 4699
D (20) Operations & Maintenance
E (30) Debt Service
Page 9
F (40) Transportation
G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security
J (80) Tort
K (90) Fire Prevention & Safety
201,200
201,200
0
0
0
10,000 10,000
0
0
0
15,000
0
0
0
0
0
15,000
4770 4799
Federal Adult Education
4810
ARRA General State Aid Education Stabilization ARRA Title I Low Income ARRA Title I Neglected, Private ARRA Title I Delinquent, Private ARRA Title I School Improvement (Part A) ARRA Title I School Improvement (Section 1003g) ARRA IDEA Part B Preschool ARRA IDEA Part B FlowThrough ARRA Title IID Technology Formula ARRA Title IID Technology Competitive ARRA McKinney Vento Homeless Education ARRA Child Nutrition Equipment Assistance Impact Aid Formula Grants Impact Aid Competitive Grants Qualified Zone Academy Bond Tax Credits Qualified School Construction Bond Credits Build America Bond Tax Credits Build America Bond Interest Reimbursement ARRA General State Aid Other Government Services Stabilization Other ARRA Funds II Other ARRA Funds III Other ARRA Funds IV Other ARRA Funds V ARRA Early Childhood Other ARRA Funds VII
4850 4851 4852 4853 4854 4855 4856 4857 4860 4861 4862 4863 4864 4865 4866 4867 4868 4869 4870 4871 4872 4873 4874 4875 4876
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
9/25/2017
ESTIMATED RECEIPTS/REVENUES
Page 10
A 1 Description
2 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275
(Enter Whole Numbers Only)
B
C (10) Acct Educational #
Other ARRA Funds VIII Other ARRA Funds IX Other ARRA Funds X Other ARRA Funds Ed Job Fund Program Total Stimulus Programs
4877 4878 4879 4880
Race to the Top Program
4901
Race to the Top Preschool Expansion Grant
4902
Advanced Placement Fee/International Baccalaureate
4904
Title III Immigrant Education Program (IEP)
4905
Title III Language Inst Program Limited English (LIPLEP)
4909
Learn & Serve America
4910
McKinney Education for Homeless Children
4920
Title II Eisenhower Professional Development Formula
4930
Title II Teacher Quality
4932
Federal Charter Schools
4960
Medicaid Matching Funds Administrative Outreach
4991
Medicaid Matching Funds FeeForService Program
4992
Other Restricted Grants Received from Federal Government through State (Describe & Itemize) Total Restricted Grants-In-Aid Received from Federal Govt. Thru the State TOTAL RECEIPTS/REVENUES FROM FEDERAL SOURCES TOTAL DIRECT RECEIPTS/REVENUES
D (20) Operations & Maintenance
0
E (30) Debt Service
Page 10
F (40) Transportation
G H I (50) (60) (70) Municipal Capital Projects Working Cash Retirement/ Social Security
0
0
0
0
0
0 0 460,473
0 0 459,833
0 0 432,430
0 0 655,500
0 0 375
J (80) Tort
K (90) Fire Prevention & Safety
0
0
0 0 372,000
0 0 80,852
288,000
20,958
15,000
4999
4000
879,288 879,288 6,340,167
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0 50,376
9/25/2017
ESTIMATED DISBURSEMENTS/EXPENDITURES
Page 11
A
B
1 Description (Enter Whole Numbers Only)
2 3 10 - EDUCATIONAL FUND (ED) INSTRUCTION (ED) 4 Regular Programs 5 Tuition Payment to Charter Schools 6 PreK Programs 7 Special Education Programs (Functions 1200 1220) 8 Special Education Programs PreK 9 Remedial and Supplemental Programs K12 10 Remedial and Supplemental Programs PreK 11 Adult/Continuing Education Programs 12 CTE Programs 13 Interscholastic Programs 14 Summer School Programs 15 Gifted Programs 16 Driver's Education Programs 17 Bilingual Programs 18 Truant Alternative & Optional Programs 19 PreK Programs Private Tuition 20 Regular K12 Programs Private Tuition 21 Special Education Programs K12 Private Tuition 22 Special Education Programs PreK Tuition 23 Remedial/Supplemental Programs K12 Private Tuition 24 Remedial/Supplemental Programs PreK Private Tuition 25 Adult/Continuing Education Programs Private Tuition 26 CTE Programs Private Tuition 27 Interscholastic Programs Private Tuition 28 Summer School Programs Private Tuition 29 Gifted Programs Private Tuition 30 Bilingual Programs Private Tuition 31 Truants Alternative/Opt Ed Programs Private Tuition 32 Total Instruction 14 33 34 SUPPORT SERVICES (ED) Support Services - Pupil 35 Attendance & Social Work Services 36 Guidance Services 37 Health Services 38 Psychological Services 39 Speech Pathology & Audiology Services 40 Other Support Services Pupils (Describe & Itemize) 41 Total Support Services - Pupil 42 Support Services - Instructional Staff 43 Improvement of Instruction Services 44 Educational Media Services 45 Assessment & Testing 46 Total Support Services - Instructional Staff 47 Support Services - General Administration 48 Board of Education Services 49 Executive Administration Services 50 Special Area Administration Services 51 52 53 54 55 56 57 58 59 60
Tort Immunity Services Total Support Services - General Administration Support Services - School Administration Office of the Principal Services Other Support Services School Administration (Describe & Itemize) Total Support Services - School Administration Support Services - Business Direction of Business Support Services Fiscal Services
Funct # 1000 1100 1115 1125 1200 1225 1250 1275 1300 1400 1500 1600 1650 1700 1800 1900 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922
Page 11
C (100)
D (200)
E (300)
F (400)
G (500)
H (600)
I (700)
J (800)
K (900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
1,899,924
264,421
90,000
115,000
240,798 242,320
48,800 45,126
4,500 2,000
6,000
60,000
6,500
75,000 59,000
950 1,400
12,000 500
3,800 250
62,439
10,579
500
150
2,639,481
377,776
109,500
125,200
52,437 20,000 58,155
10,579 10,579 2,500 10,579
1,250 131,842
34,237
2210 2220 2230 2200
22,000 52,493
1000
1,000
0
1,000
0
0
2,370,345 0 300,098 289,446 0 66,500 0 0 0 91,750 61,150 0 0 73,668 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3,252,957
0
63,516 10,579 89,500 69,234 0 10,750 243,579
0
65,000 64,179 0 129,179
2000 2110 2120 2130 2140 2150 2190 2100
500 60,000
3,000 500
6,500 66,500
3,000 7,000
16,500 11,386
25,000
1,500 300
74,493
27,886
25,000
1,800
2310 2320 2330 2360 2370 2300
2,000 171,500 97,500
42,958 36,095
85,000 16,000
6,500 2,200 1,000
271,000
79,053
101,000
9,700
2410 2490 2400
232,620
72,000
1,500
20,500
232,620
72,000
1,500
20,500
2510 2520
146,000 45,000
40,000 8,000
1,500 7,000
1,500 1,000
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
4,000
0
0
0
0
4,000
0
10,000 4,500 2,000 0
16,500
103,500 237,158 136,595 0
0
0 477,253
0
328,820 0 328,820
2,200 0
2,200 2,200
0
191,200 61,000
9/25/2017
ESTIMATED DISBURSEMENTS/EXPENDITURES
Page 12
A
B
1 Description
2 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116
(Enter Whole Numbers Only) Operation & Maintenance of Plant Services Pupil Transportation Services Food Services Internal Services Total Support Services - Business Support Services - Central Direction of Central Support Services Planning, Research, Development & Evaluation Services Information Services Staff Services Data Processing Services Total Support Services - Central Other Support Services (Describe & Itemize) Total Support Services
Funct # 2540 2550 2560 2570 2500 2610 2620 2630 2640 2660 2600 2900 2000
COMMUNITY SERVICES (ED)
3000
PAYMENTS TO OTHER DIST & GOVT UNITS (ED) Payments to Other Dist & Govt Units (In-State) Payments for Regular Programs Payments for Special Education Programs Payments for Adult/Continuing Education Programs Payments for CTE Programs Payments for Community College Programs Other Payments to InState Govt Units (Describe & Itemize) Total Payments to Other Dist & Govt Units (In-State) Payments for Regular Programs Tuition Payments for Special Education Programs Tuition Payments for Adult/Continuing Education Programs Tuition Payments for CTE Programs Tuition Payments for Community College Programs Tuition Payments for Other Programs Tuition Other Payments to InState Govt Units (Describe & Itemize) Total Payments to Other Dist & Govt Units - Tuition (In State) Payments for Regular Programs Transfers Payments for Special Education Programs Transfers Payments for Adult/Continuing Ed Programs Transfers Payments for CTE Programs Transfers Payments for Community College Program Transfers Payments for Other Programs Transfers Other Payments to InState Govt Units Transfers (Describe & Itemize) Total Payments to Other Dist & Govt Units-Transfers (In State) Payments to Other Dist & Govt Units (Out of State) Total Payments to Other Dist & Govt Units
4000
DEBT SERVICE (ED) Debt Service - Interest on Short-Term Debt Tax Anticipation Warrants Tax Anticipation Notes Corporate Personal Property Repl Tax Anticipated Notes State Aid Anticipation Certificates Other Interest on ShortTerm Debt (Describe & Itemize) Total Debt Service - Interest on Short-Term Debt Debt Service - Interest on Long-Term Debt Total Debt Service
PROVISION FOR CONTINGENCIES (ED) Total Direct Disbursements/Expenditures
Page 12
C (100)
D (200)
E (300)
F (400)
G (500)
H (600)
I (700)
J (800)
K (900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
95,250
9,000
215,000
1,500
286,250
57,000
223,500
4,000
1,400
5,000
0
2,200
0
0
83,286 83,286
20,300 20,300
7,500 8,900
38,000 43,000
157,000 157,000
0
2,000 2,000
0
1,079,491
290,476
426,400
86,000
157,000
20,900
6,000
0
4110 4120 4130 4140 4170 4190 4100 4210 4220 4230 4240 4270 4280 4290 4200 4310 4320 4330 4340 4370 4380 4390 4300 4400 4000 5000
15,000
780,000
15,000
780,000
0
15,000
780,000
5110 5120 5130 5140 5150 5100 5200 5000 6000
0 0 6,400 0 308,086 314,486 0 2,066,267 0
0 795,000 0 0 0 0 795,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 795,000
0
0
0 0 320,750 0 572,950
0 0 0 0 0 0 0 0 0
0 0 3,718,972
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
668,252
550,900
211,200
157,000
801,900
6,000
0
6,114,224 225,943
9/25/2017
ESTIMATED DISBURSEMENTS/EXPENDITURES
Page 13
A
B
1 Description (Enter Whole Numbers Only)
2 117 20 - OPERATIONS AND MAINTENANCE FUND (O&M) 118 SUPPORT SERVICES (O&M) Support Services - Pupil 119 Other Support Services Pupils (Describe & Itemize) 120 Support Services - Business 121 Direction of Business Support Services 122 Facilities Acquisition & Construction Services 123 Operation & Maintenance of Plant Services 124 Pupil Transportation Services 125 Food Services 126 Total Support Services - Business 127 Other Support Services (Describe & Itemize) 128 Total Support Services 129 130 COMMUNITY SERVICES (O&M) 131 PAYMENTS TO OTHER DIST & GOVT UNITS (O&M) Payments to Other Dist & Govt Units (In-State) 132 Payments for Regular Programs 133 Payments for Special Education Programs 134 Payments for CTE Program 135 Other Payments to InState Govt Units (Describe & Itemize) 136 Total Payments to Other Dist & Govt Units (In-State) 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151
Payments to Other Dist & Govt Units (Out of State) 14 Total Payments to Other Dist & Govt Unit
DEBT SERVICE (O&M) Debt Service - Interest on Short-Term Debt Tax Anticipation Warrants Tax Anticipation Notes Corporate Personal Prop Repl Tax Anticipated Notes State Aid Anticipation Certificates Other Interest on ShortTerm Debt (Describe & Itemize) Total Debt Service - Interest on Short-Term Debt Debt Service - Interest on Long-Term Debt Total Debt Service
PROVISION FOR CONTINGENCIES (O&M)
Funct #
C (100)
D (200)
E (300)
F (400)
G (500)
H (600)
I (700)
J (800)
K (900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
2000
0
2190 2510 2530 2540 2550 2560 2500 2900 2000 3000
210,500
53,000
125,000 110,000
210,500
53,000
235,000
161,550
24,000
0
0
0
210,500
53,000
235,000
161,550
24,000
0
0
0
161,550
24,000
0 125,000 559,050 0 0 684,050 0 684,050 0
4000 4110 4120 4140 4190 4100
29,000
0
0 29,000 0 0 29,000
29,000
0
0 29,000
29,000
4400 4000 5000 5110 5120 5130 5140 5150 5100 5200 5000 6000
0 0 210,500
Total Direct Disbursements/Expenditures Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
152 153 154 30 - DEBT SERVICE FUND (DS) 155 PAYMENTS TO OTHER DIST & GOVT UNITS (DS) 156 Payments to Other Dist & Govt Units (In-State) Payments for Regular Programs 157 Payments for Special Education Programs 158 Other Payments to InState Govt Units (Describe & Itemize) 159 Total Payments to Other Dist & Govt Units (In-State) 160 161 DEBT SERVICE (DS) Debt Service - Interest on Short-Term Debt 162 Tax Anticipation Warrants 163 Tax Anticipation Notes 164 Corporate Personal Prop Repl Tax Anticipation Notes 165 State Aid Anticipation Certificates 166 Other Interest on ShortTerm Debt (Describe & Itemize) 167 Total Debt Service - Interest On Short-Term Debt 168
Page 13
53,000
264,000
161,550
24,000
0
0
0
0 0 0 0 0 0 0 0 0 713,050 (252,577)
4000 4110 4120 4190 4000 5000 5110 5120 5130 5140 5150 5100
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
0 0 0 0
0
0 0 0 0 0 0
9/25/2017
ESTIMATED DISBURSEMENTS/EXPENDITURES
Page 14
A
B
1 Funct #
Description
2 169 170 171 172 173 174
(Enter Whole Numbers Only) Debt Service - Interest on Long-Term Debt Debt Service - Payments of Principal on Long-Term Debt (Lease/Purchase Principal Retired) Debt Service Other (Describe & Itemize) Total Debt Service PROVISION FOR CONTINGENCIES (DS) Total Direct Disbursements/Expenditures Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221
D (200)
E (300)
F (400)
G (500)
H (600)
I (700)
J (800)
K (900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
5300 5400 5000
83,989
83,989
341,533
341,533 0 425,522 0 425,522
0
425,522
0
425,522
6000
34,311 2000
0
2190 2550 2900 2000 3000
160,000 0
0
160,000
0
0
0
0
0
160,000 0 160,000 0
4000 4110 4120 4130 4140 4170 4190 4100
Payments to Other Dist & Govt Units (Out-of-State) (Describe & Itemize) Total Payments to Other Dist & Govt Units
125,000
0
0 125,000 0 0 0 0 125,000
125,000
0
0 125,000
125,000
4400 4000
DEBT SERVICE (TR)
5000
Debt Service - Interest on Short-Term Debt Tax Anticipation Warrants Tax Anticipation Notes Corporate Personal Prop Repl Tax Anticipation Notes State Aid Anticipation Certificates Other Interest on ShortTerm Debt (Describe and Itemize) Total Debt Service - Interest On Short-Term Debt Debt Service - Interest on Long-Term Debt Debt Service - Payments of Principal on Long-Term Debt (Lease/Purchase Principal Retired)
C (100)
5200 15
175 176 177 40 - TRANSPORTATION FUND (TR) 178 SUPPORT SERVICES (TR) 179 Support Services - Pupils Other Support Services Pupils (Describe & Itemize) 180 181 Support Services - Business Pupil Transportation Services 182 Other Support Services (Describe & Itemize) 183 Total Support Services 184 185 COMMUNITY SERVICES (TR) 186 PAYMENTS TO OTHER DIST & GOVT UNITS (TR) Payments to Other Dist & Govt Units (In-State) 187 Payments for Regular Program 188 Payments for Special Education Programs 189 Payments for Adult/Continuing Education Programs 190 Payments for CTE Programs 191 Payments for Community College Programs 192 Other Payments to InState Govt Units (Describe & Itemize) 193 Total Payments to Other Dist & Govt Units (In-State) 194 195 196 197 198 199 200 201 202 203 204 205
Page 14
15
Debt Service - Other (Describe and Itemize) Total Debt Service PROVISION FOR CONTINGENCIES (TR) Total Direct Disbursements/Expenditures Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
5110 5120 5130 5140 5150 5100 5200 5300
0 0 0 0 0 0 0
0
5400 5000 6000
0 0
0
285,000
0
0
0
0
0
0 0 0 0 285,000 147,430
50 - MUNICIPAL RETIREMENT/SOC SEC FUND (MR/SS) INSTRUCTION (MR/SS) Regular Program PreK Programs Special Education Programs (Functions 12001220) Special Education Programs PreK Remedial and Supplemental Programs K12 Remedial and Supplemental Programs PreK Adult/Continuing Education Programs
1000 1100 1125 1200 1225 1250 1275 1300
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
36,900 5,212 9,700
36,900 5,212 9,700 0 0 0 0
9/25/2017
ESTIMATED DISBURSEMENTS/EXPENDITURES
Page 15
A
B
1 Description
2 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277
(Enter Whole Numbers Only) CTE Programs Interscholastic Programs Summer School Programs Gifted Programs Driver's Education Programs Bilingual Programs Truant Alternative & Optional Programs Total Instruction SUPPORT SERVICES (MR/SS) Support Services - Pupil Attendance & Social Work Services Guidance Services Health Services Psychological Services Speech Pathology & Audiology Services Other Support Services Pupils (Describe & Itemize) Total Support Services - Pupil Support Services - Instructional Staff Improvement of Instruction Services Educational Media Services Assessment & Testing Total Support Services - Instructional Staff Support Services - General Administration Board of Education Services Executive Administration Services Special Area Administrative Services Claims Paid from Self Insurance Fund Workers' Compensation or Workers' Occupation Disease Acts Payments Unemployment Insurance Payments Insurance Payments (regular or selfinsurance) Risk Management and Claims Services Payments Judgment and Settlements Educational, Inspectional, Supervisory Services Related to Loss Prevention or Reduction Reciprocal Insurance Payments Legal Service Total Support Services - General Administration Support Services - School Administration Office of the Principal Services Other Support Services School Administration (Describe & Itemize) Total Support Services - School Administration Support Services - Business Direction of Business Support Services Fiscal Services Facilities Acquisition & Construction Services Operation & Maintenance of Plant Service Pupil Transportation Services Food Services Internal Services Total Support Services - Business Support Services - Central Direction of Central Support Services Planning, Research, Development & Evaluation Services Information Services Staff Services Data Processing Services Total Support Services - Central
Funct #
Page 15
C (100)
D (200)
E (300)
F (400)
G (500)
H (600)
I (700)
J (800)
K (900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
1400 1500 1600 1650 1700 1800 1900 1000 2000 2110 2120 2130 2140 2150 2190 2100
890 57,967
763
2,233 345 5,048
2310 2320 2330 2361 2362 2363 2364 2365 2366 2367
8,585 1,780 1,700
8,585 1,780 1,700 0 0 0 0 0 0 0 0 0 12,065
12,065 9,371
2510 2520 2530 2540 2550 2560 2570 2500
25,000 12,700
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
345 5,048 0 5,393
5,393
2410 2490 2400
2610 2620 2630 2640 2660 2600
763 0 700 770 0 0 2,233
700 770
2210 2220 2230 2200
2368 2369 2300
0 3,165 2,100 0 0 890 0 57,967
3,165 2,100
9,371 0 9,371
9,371
16,725 17,875 107,150
25,000 12,700 0 34,850 0 16,725 17,875 107,150
0
0 0 0 0 0 0
34,850
9/25/2017
ESTIMATED DISBURSEMENTS/EXPENDITURES
Page 16
A
B
1 Description
2 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297
(Enter Whole Numbers Only) Other Support Services (Describe & Itemize) Total Support Services COMMUNITY SERVICES (MR/SS) PAYMENTS TO OTHER DIST & GOVT UNITS (MR/SS) Payments for Regular Programs Payments for Special Education Programs Payments for CTE Programs Total Payments to Other Dist & Govt Units DEBT SERVICE (MR/SS) Debt Service - Interest on Short-Term Debt Tax Anticipation Warrants Tax Anticipation Notes Corporate Personal Prop Repl Tax Anticipation Notes State Aid Anticipation Certificates Other (Describe & Itemize) Total Debt Service PROVISION FOR CONTINGENCIES (MR/SS) Total Direct Disbursements/Expenditures Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
Funct #
Page 16
C (100)
D (200)
E (300)
F (400)
G (500)
H (600)
I (700)
J (800)
K (900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
2900 2000 3000 4000 4110 4120 4140 4000 5000
0 136,212 0
136,212
0
0 0 0 0
194,179
0 0 0 0 0 0 0 194,179
5110 5120 5130 5140 5150 5000
0
6000
0
461,321
60 - CAPITAL PROJECTS (CP)
298 299 SUPPORT SERVICES (CP) Support Services - Business 300 Facilities Acquisition & Construction Services 301 Other Support Services (Describe & Itemize) 302 Total Support Services 303 304 PAYMENTS TO OTHER DIST & GOVT UNITS (CP) Payments to Other Dist & Govt Units (In-State) 305 Payments to Regular Programs 306 Payment for Special Education Programs 307 Payment for CTE Programs 308 Payments to Other Govt Units (InState) (Describe & Itemize) 309 Total Payments to Other Districts & Govt Units 310 311 PROVISION FOR CONTINGENCIES (CP) Total Direct Disbursements/Expenditures 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330
2000 2530 2900 2000 4000
420,000 0
0
4110 4120 4140 4190 4000 6000
0
0
420,000
0 0
0
0
0
0
420,000 0 420,000
0
0 0 0 0 0 0 420,000
0 0
420,000
0
Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
(419,625)
70 WORKING CASH FUND (WC) 80 - TORT FUND (TF) SUPPORT SERVICES - GENERAL ADMINISTRATION Claims Paid from Self Insurance Fund Workers' Compensation or Workers' Occupational Disease Act Payments Unemployment Insurance Payments Insurance Payments (regular or selfinsurance) Risk Management and Claims Services Payments Judgment and Settlements Educational, Inspectional, Supervisory Services Related to Loss Prevention or Reduction Reciprocal Insurance Payments Legal Service Property Insurance (Building & Grounds) Vehicle Insurance (Transportation) Total Support Services - General Administration
2000 2361 2362 2363 2364 2365 2366 2367 2368 2369 2371 2372 2000
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0 0 0 0 0 0
0
0
0
0
0
0
0 0 0 0 0 0
0
9/25/2017
ESTIMATED DISBURSEMENTS/EXPENDITURES
Page 17
A
B
1 Funct #
Description
2 331 332 333 334 335 336 337 338 339 340 341 342 343 344
(Enter Whole Numbers Only) PAYMENTS TO OTHER DIST & GOVT UNITS (TF) Payments for Regular Programs Payments for Special Education Programs Total Payments to Other Dist & Govt Units DEBT SERVICE (TF) Debt Service - Interest on Short-Term Debt Tax Anticipation Warrants Corporate Personal Property Replacement Tax Anticipation Notes Other Interest or ShortTerm Debt (Describe & Itemize) Total Debt Service PROVISION FOR CONTINGENCIES (TF) Total Direct Disbursements/Expenditures Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
Page 17
C (100)
D (200)
E (300)
F (400)
G (500)
H (600)
I (700)
J (800)
K (900)
Salaries
Employee Benefits
Purchased Services
Supplies & Materials
Capital Outlay
Other Objects
Non-Capitalized Equipment
Termination Benefits
Total
4000 4110 4120 4000 5000
0 0 0
0
5110 5130 5150 5000
0 0 0 0 0 0
0
6000
0
0
0
0
0
0
0
372,000
90 - FIRE PREVENTION & SAFETY FUND (FP&S)
345 346 SUPPORT SERVICES (FP&S) Support Services - Business 347 Facilities Acquisition & Construction Services 348 Operation & Maintenance of Plant Service 349 Total Support Services - Business 350 Other Support Services (Describe & Itemize) 351 Total Support Services 352 353 PAYMENTS TO OTHER DISTRICTS & GOVT UNITS (FP&S) Payments to Regular Programs 354 Payments to Special Education Programs 355 Other Payments to InState Govt Units (Describe & Itemize) 356 Total Payments to Other Districts & Govt Units (FPS) 357 358 DEBT SERVICE (FP&S) Debt Service - Interest on Short-Term Debt 359 Tax Anticipation Warrants 360 Other Interest on ShortTerm Debt (Describe & Itemize) 361 Total Debt Service - Interest on Short-Term Debt 362 Debt Service - Interest on Long-Term Debt 363 364 365 366 367 368
Debt Service - Payments of Principal on Long-Term Debt (Lease/Purchase Principal Retired) Total Debt Service PROVISIONS FOR CONTINGENCIES (FP&S) Total Direct Disbursements/Expenditures Excess (Deficiency) of Receipts/Revenues Over Disbursements/Expenditures
2000 2530 2540 2500 2900 2000 4000 4110 4120 4190 4000 5000
15
15,000 0
0
15,000
0
0
0
0
0
0
15,000
0
0
0
0
15,000 0 15,000 0 15,000 0 0 0 0
0
5110 5150 5100 5200 5300
0
5000
0
0 0 0 0 0 0 0 15,000
6000
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
0
15,000
0
0
0
0
65,852
9/25/2017
Page 18
Page 18
This page is provided for detailed itemizations as requested within the body of the Report.
1. 2. 3. 4.
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
Page 19
Page 19
A
B
C
D
E
F
WORKING CASH FUND (70)
TOTAL
DEFICIT BUDGET SUMMARY INFORMATION - Operating Funds Only 1 2 3 4 5 6
Description Direct Revenues Direct Expenditures Difference Estimated Fund Balance - June 30, 2018
OPERATIONS & EDUCATIONAL FUND MAINTENANCE FUND (10) (20)
6,340,167 6,114,224 225,943 6,447,992
460,473 713,050 (252,577) 115,802
TRANSPORTATION FUND (40)
432,430 285,000 147,430 193,306
50,376 50,376 1,398,490
7,283,446 7,112,274 171,172 8,155,590
Balanced budget, no deficit reduction plan is required. 7 8 9 10 11 12 13 14 15
A deficit reduction plan is required if the local board of education adopts (or amends) the 2017-18 school district budget in which the “operating funds” listed above result in direct revenues (line 9) being less than direct expenditures (line 19) by an amount equal to or greater than one-third (1/3) of the ending fund balance (line 81). Note: The balance is determined using only the four funds listed above. That is, if the estimated ending fund balance is less than three times the deficit spending, the district must adopt and file with ISBE a deficit reduction plan to balance the shortfall within three years. The School Code, Section 17-1 (105 ILCS 5/17-1) - If the 2016-2017 Annual Financial Report (AFR) reflects a deficit as defined above (page 36), then the school district shall adopt and submit a deficit reduction plan (found here on page 20-24) to ISBE within 30 days after acceptance of the AFR. The deficit reduction plan, if required, is developed using ISBE guidelines and format.
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
Page 20
A
B
C
6 ESTIMATED BEGINNING FUND BALANCE
22
G
Operations & Maintenance Fund
Transportation Fund
Working Cash Fund
Total
368,379
45,876
1,860,114
8,496,418
1000
4,043,765
460,473
432,430
50,376
4,987,044
2000
0 1,417,114 879,288 6,340,167
0 0 0 460,473
0 0 0 432,430
0 0 50,376
0 1,417,114 879,288 7,283,446
3,252,957 2,066,267 0 795,000 0 0 6,114,224
684,050 0 29,000 0 0 713,050
160,000 0 125,000 0 0 285,000
(252,577)
147,430
0 0 0 115,802
0 0 0 193,306
Acct #
3000 4000
DISBURSEMENTS/EXPENDITURES
Funct #
INSTRUCTION SUPPORT SERVICES COMMUNITY SERVICES PAYMENTS TO OTHER DISTRICTS & GOVT. UNITS DEBT SERVICES PROVISION FOR CONTINGENCIES
1000 2000 3000 4000 5000 6000
OTHER SOURCES/USES OF FUNDS 23 24 OTHER SOURCES OF FUNDS (7000) 25 OTHER USES OF FUNDS (8000) TOTAL OTHER SOURCES/USES OF FUNDS 26 27 ESTIMATED ENDING FUND BALANCE
F
6,222,049
7 (must equal prior Ending Fund Balance)
Total Disbursements/Expenditures Excess of Receipts/Revenue Over/(Under) Disbursements/Expenditures
E
ESTIMATED BUDGET FY2017-2018
Educational Fund
RECEIPTS/REVENUES 8 9 LOCAL SOURCES FLOW-THROUGH RECEIPTS/REVENUES FROM ONE 10 DISTRICT TO ANOTHER DISTRICT 11 STATE SOURCES 12 FEDERAL SOURCES 13 Total Receipts/Revenues
D
DEFICIT REDUCTION PLAN
1 2 0 3 4 District Number 5
14 15 16 17 18 19 20 21
Page 20
ILLINOIS STATE BOARD OF EDUCATION SCHOOL BUSINESS SERVICES DIVISION
225,943
0 0 0 6,447,992
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
3,252,957 2,910,317 0 949,000 0 0 7,112,274 50,376
0 512,000 (512,000) 1,398,490
171,172
0 512,000 (512,000) 8,155,590
9/25/2017
Page 21
A
B
H
I
1 2 0 3 4 District Number 5
ESTIMATED BEGINNING FUND BALANCE
6,447,992
7 (must equal prior Ending Fund Balance)
22
Operations & Maintenance Fund
Educational Fund
RECEIPTS/REVENUES 8 9 LOCAL SOURCES FLOW-THROUGH RECEIPTS/REVENUES FROM ONE 10 DISTRICT TO ANOTHER DISTRICT 11 STATE SOURCES 12 FEDERAL SOURCES 13 Total Receipts/Revenues
K
L
115,802
Transportation Fund
Working Cash Fund
Total
193,306
1,398,490
8,155,590
Acct # 1000
0
2000
0 0 0 0
3000 4000
0
DISBURSEMENTS/EXPENDITURES
Funct #
INSTRUCTION SUPPORT SERVICES COMMUNITY SERVICES PAYMENTS TO OTHER DISTRICTS & GOVT. UNITS DEBT SERVICES PROVISION FOR CONTINGENCIES
1000 2000 3000 4000 5000 6000
Total Disbursements/Expenditures Excess of Receipts/Revenue Over/(Under) Disbursements/Expenditures
OTHER SOURCES/USES OF FUNDS 23 24 OTHER SOURCES OF FUNDS (7000) 25 OTHER USES OF FUNDS (8000) TOTAL OTHER SOURCES/USES OF FUNDS 26 27 ESTIMATED ENDING FUND BALANCE
J
ESTIMATED BUDGET FY2018-2019
6
14 15 16 17 18 19 20 21
Page 21
ILLINOIS STATE BOARD OF EDUCATION SCHOOL BUSINESS SERVICES DIVISION
0
0
0
0
0
0
0
0 6,447,992
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
0 115,802
0 193,306
0
0 0 0 0 0 0 0 0
0
0 1,398,490
0 0 0 8,155,590
9/25/2017
Page 22
A
B
M
N
1 2 0 3 4 District Number 5
ESTIMATED BEGINNING FUND BALANCE
6,447,992
7 (must equal prior Ending Fund Balance)
22
Operations & Maintenance Fund
Educational Fund
RECEIPTS/REVENUES 8 9 LOCAL SOURCES FLOW-THROUGH RECEIPTS/REVENUES FROM ONE 10 DISTRICT TO ANOTHER DISTRICT 11 STATE SOURCES 12 FEDERAL SOURCES 13 Total Receipts/Revenues
P
Q
115,802
Transportation Fund
Working Cash Fund
Total
193,306
1,398,490
8,155,590
Acct # 1000
0
2000
0 0 0 0
3000 4000
0
DISBURSEMENTS/EXPENDITURES
Funct #
INSTRUCTION SUPPORT SERVICES COMMUNITY SERVICES PAYMENTS TO OTHER DISTRICTS & GOVT. UNITS DEBT SERVICES PROVISION FOR CONTINGENCIES
1000 2000 3000 4000 5000 6000
Total Disbursements/Expenditures Excess of Receipts/Revenue Over/(Under) Disbursements/Expenditures
OTHER SOURCES/USES OF FUNDS 23 24 OTHER SOURCES OF FUNDS (7000) 25 OTHER USES OF FUNDS (8000) TOTAL OTHER SOURCES/USES OF FUNDS 26 27 ESTIMATED ENDING FUND BALANCE
O
ESTIMATED BUDGET FY2019-2020
6
14 15 16 17 18 19 20 21
Page 22
ILLINOIS STATE BOARD OF EDUCATION SCHOOL BUSINESS SERVICES DIVISION
0
0
0
0
0
0
0
0 6,447,992
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
0 115,802
0 193,306
0
0 0 0 0 0 0 0 0
0
0 1,398,490
0 0 0 8,155,590
9/25/2017
Page 23
A
B
R
S
1 2 0 3 4 District Number 5
ESTIMATED BEGINNING FUND BALANCE
6,447,992
7 (must equal prior Ending Fund Balance)
22
Operations & Maintenance Fund
Educational Fund
RECEIPTS/REVENUES 8 9 LOCAL SOURCES FLOW-THROUGH RECEIPTS/REVENUES FROM ONE 10 DISTRICT TO ANOTHER DISTRICT 11 STATE SOURCES 12 FEDERAL SOURCES 13 Total Receipts/Revenues
U
V
115,802
Transportation Fund
Working Cash Fund
Total
193,306
1,398,490
8,155,590
Acct # 1000
0
2000
0 0 0 0
3000 4000
0
DISBURSEMENTS/EXPENDITURES
Funct #
INSTRUCTION SUPPORT SERVICES COMMUNITY SERVICES PAYMENTS TO OTHER DISTRICTS & GOVT. UNITS DEBT SERVICES PROVISION FOR CONTINGENCIES
1000 2000 3000 4000 5000 6000
Total Disbursements/Expenditures Excess of Receipts/Revenue Over/(Under) Disbursements/Expenditures
OTHER SOURCES/USES OF FUNDS 23 24 OTHER SOURCES OF FUNDS (7000) 25 OTHER USES OF FUNDS (8000) TOTAL OTHER SOURCES/USES OF FUNDS 26 27 ESTIMATED ENDING FUND BALANCE
T
ESTIMATED BUDGET FY2020-2021
6
14 15 16 17 18 19 20 21
Page 23
ILLINOIS STATE BOARD OF EDUCATION SCHOOL BUSINESS SERVICES DIVISION
0
0
0
0
0
0
0
0 6,447,992
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
0 115,802
0 193,306
0
0 0 0 0 0 0 0 0
0
0 1,398,490
0 0 0 8,155,590
9/25/2017
Page 24
Page 24
ILLINOIS STATE BOARD OF EDUCATION SCHOOL BUSINESS SERVICES DIVISION
A
B
W
X
Y
Z
SUMMARY
1 2 0 3 4 District Number 5
BUDGET ADDENDUM - DEFICIT REDUCTION PLAN ESTIMATED BUDGET Date of Adoption: (Enter as MM/DD/YY) FY2017-2018
FY2018-2019
FY2019-2020
FY2020-2021
6 ESTIMATED BEGINNING FUND BALANCE
8,496,418
8,155,590
8,155,590
8,155,590
1000
4,987,044
0
0
0
2000
0 1,417,114 879,288 7,283,446
0 0 0 0
0 0 0 0
0 0 0 0
3,252,957 2,910,317 0 949,000 0 0 7,112,274
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
171,172
0
0
0
0 0 0 8,155,590
0 0 0 8,155,590
0 0 0 8,155,590
7 (must equal prior Ending Fund Balance) RECEIPTS/REVENUES 8 9 LOCAL SOURCES FLOW-THROUGH RECEIPTS/REVENUES FROM ONE 10 DISTRICT TO ANOTHER DISTRICT 11 STATE SOURCES 12 FEDERAL SOURCES 13 Total Receipts/Revenues
14 15 16 17 18 19 20 21 22
Acct #
3000 4000
DISBURSEMENTS/EXPENDITURES
Funct #
INSTRUCTION SUPPORT SERVICES COMMUNITY SERVICES PAYMENTS TO OTHER DISTRICTS & GOVT. UNITS DEBT SERVICES PROVISION FOR CONTINGENCIES
1000 2000 3000 4000 5000 6000
Total Disbursements/Expenditures Excess of Receipts/Revenue Over/(Under) Disbursements/Expenditures
OTHER SOURCES/USES OF FUNDS 23 24 OTHER SOURCES OF FUNDS (7000) 25 OTHER USES OF FUNDS (8000) TOTAL OTHER SOURCES/USES OF FUNDS 26 27 ESTIMATED ENDING FUND BALANCE
0 512,000 (512,000) 8,155,590
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
Page 25
Page 25
Deficit Reduction Plan-Background/Assumptions Fiscal Year 2017-2018 through Fiscal Year 2020-2021 Lindop School District 92 Please complete the following schedule and include a brief description to identify any areas of the budget that will be impacted from one year to the next. If the deficit reduction plan relies upon new local revenues, identify contingencies for further budget reductions which will be enacted in the event those new revenues are not available. 1. Background and Narrative of Budget Reductions:
2. Assumptions Used in the Deficit Reduction Plan:
- Foundation Levels for General State Aid:
- Equal Assessed Valuation and Tax Rates:
- Employee Salaries and Benefits:
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
Page 26
Page 26
- Short and Long Term Borrowing:
- Educational Impact:
- Other Assumptions:
- Has the district considered shared services or outsourcing (Ex: Transportation, Insurance) If yes please explain:
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
Page 27
Page 27
ESTIMATED LIMITATION OF ADMINISTRATIVE COSTS (For Local Use Only) This is an estimated Limitation of Administrative Costs Worksheet only and will not be accepted for Official Submission of the Limitation of Administrative Costs Worksheet. The worksheet is intended for use during the budgeting process to estimate the district's percent increase of FY2018 budgeted expenditures over FY2017 actual expenditures. Budget information is copied to this page. Insert the prior year estimated actual expenditures to compute the estimated percentage increase (decrease). The official Limitation of Administrative Costs Worksheet is attached to the end of the Annual Financial Report (ISBE Form 50-35) and may be submitted in conjunction with that report.
An official Limitation of Administrative Costs Worksheet can also be found on the ISBE website at: Limitation of Administrative Costs
School District Name: ESTIMATED LIMITATION OF ADMINISTRATIVE COSTS WORKSHEET RCDT Number: (Section 171.5 of the School Code) Estimated Actual Expenditures, Fiscal Year 2017
(10) Description (Enter Whole Numbers Only)
Funct #
(20) Operations & Maintenance Fund
Educational Fund
1. Executive Administration Services 2320 2. Special Area Administration Services 2330 Other Support Services School 3. 2490 Administration 4. Direction of Business Support Services 2510 5. Internal Services 2570 6. Direction of Central Support Services 2610 7. Deduct Early Retirement or other pension obligations required by state law and include above 8. Totals 9. Estimated Percent Increase (Decrease) for FY2018 (Budgeted) over FY2017 (Actual)
Lindop School District 92 00-000-0000-00
Budgeted Expenditures, Fiscal Year 2018 (10)
(20) Operations & Maintenance Fund
Educational Fund
Total 0 0
237,158 136,595
237,158 136,595
0
0
0
0 0 0
191,200 0 0
0
0 0
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
0
Total
0
191,200 0 0 0
564,953
0
564,953 Enter Actual Data!
9/25/2017
Page 28
Page 28
REPORTING OF PUBLIC VENDOR CONTRACTS OF $1,000 OR MORE In accordance with the School Code, Section 10-20.21, all school districts are required to file a report listing ‘vendor contracts’ as an attachment to their budget. In this context, the term "vendor contracts" refers to "all contracts and agreements that pertain to goods and services that were intended to generate additional revenue and other remunerations for the school district in excess of $1,000, including without limitation vending machine contracts, sports and other attire, class rings, and photographic services. The report is to list information regarding such contracts for the fiscal year immediately preceding the fiscal year of the budget. All such contracts executed on or after July 1, 2007 must be approved by the school board. See: School Code, Section 10-20.21 - Contracts
(Sheet is unprotected and can be re-formatted as needed, but must be used for submission)
Name of Vendor
Product or Service Provided
Net Revenue
Non-Monetary Remuneration
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
Purpose of Proceeds
Distribution Method and Recipient of Non-Monetary Remunerations Distributed
9/25/2017
Page 29
Page 29
REFERENCE PAGE
Reference Description 1
Each fund balance should correspond to the fund balance reflected on the books as of June 30th Balance Sheet Accounts #720 and #730 (audit figures, if available).
2
Accounting and Financial Reporting for Certain Grants and Other Financial Assistance. The "OnBehalf" Payments should only be reflected on this page (Budget Summary, Lines 10 and 20).
3
Requires the secretary of the school board to notify the county clerk (within 30 days of the transfer approval) to abate an equal amount of taxes to be next extended. See Sec. 1022.14 & 172.11. Requires notification to the county clerk to abate an equal amount from taxes next extended. See section 1022.14
3a 4
Principal on Bonds Sold: (1) Funding Bonds are to be entered in the fund or funds in which the liability occurs. (2) Refunding Bonds can be entered in the Debt Services Fund only. (3) Building Bonds can be entered in the Capital Projects Fund only. (4) Fire Prevention and Safety Bonds can be entered in the Fire Prevention & Safety Fund only.
5
The proceeds from the sale of school sites, buildings, or other real estate shall be used first to pay the principal and interest on any outstanding bonds on the property being sold, and after all such bonds have been retired, the remaining proceeds from the sale next shall be used by the school board to meet any urgent district needs as determined under Sections 23.12 and 172.11 of the School Code. Once these issues have been addressed, any remaining proceeds may be used for any other authorized purpose and for deposit into any district fund.
6
The School Code, Section 1022.44 prohibits the transfer of interest earned on the investment of "any funds for purposes of Illinois Municipal Retirement under the Pension Code." This prohibition does not include funds for Social Security and Medicareonly purposes. For additional requirements on interest earnings, see 23 Illinois Administrative Code, Part 100, Section 100.50.
7
Cash plus investments must be greater than or equal to zero.
8
For cash basis budgets, this total will equal the Budget Summary Total Direct Receipts/Revenues (Line 9) plus Total Other Sources of Funds (Line 46).
9
For cash basis budgets, this total will equal the Budget Summary Total Direct Disbursements/Expenditures (Line 19) plus Total Other Uses of Funds (Line 79).
10
Working Cash Fund loans may be made to any district fund for which taxes are levied (Section 205 of the School Code).
11
Include revenue accounts 1110 through 1115, 1117,1118 & 1120.
12
The School Code Section 172.2c. Tax for leasing educational facilities or computer technology or both, and for temporary relocation expense purposes.
13
Corporate personal property replacement tax revenue must be first applied to the Municipal Retirement/Social Security Fund to replace tax revenue lost due to the abolition of the corporate personal property tax (30 ILCS 115/12). This provision does not apply to taxes levied for MedicareOnly purposes.
14
Only tuition payments made to private facilities. See Functions 4200 or 4400 for estimated public facility disbursements/expenditures.
15
Payment towards the retirement of lease/purchase agreements or bonded/other indebtedness (principal only) otherwise reported within the fund e.g.: alternate revenue bonds. (Describe & Itemize)
16
Only abolishment of Working Cash Fund must transfer its funds directly to the Educational Fund upon adoption of a resolution and at the close of the current school Year (see 105 ILCS 5/208 for further explanation) Only abatement of working cash fund can transfer its funds to any fund in most need of money (see 105 ILCS 5/2010 for further explanation)
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017
Page 30
Page 30
CHECK FOR ERRORS This worksheet checks various cells to assure that selected items are in balance. Out-of-balance conditions are accompanied by an error message. Errors must be corrected before the budget is finalized and submitted to ISBE. Budget Item References Is Deficit Reduction Plan Required?
Message Congratulations! You have a balanced budget.
If required, is Deficit Reduction Plan Completed (Page: DefReductPlan 20-24)? 1. Cover Page - CASH or ACCRUAL Check one type of Accounting Basis used on the Cover sheet.
CASH
2. Budget Summary: Other Sources (Page BudgetSum 2-3 - Acct 7000), must equal Other Uses (BudgetSum 2-3 - Acct. 8000). Estimated Beginning Fund Balance July,1 2017 for all Funds (Cells C3 - K3) (Line must have a number or zero. Do not leave blank.) Transfer Among Funds (Funds 10, 20, 40 - Acct 7130 - Cells C29, D29, F29), must equal (Funds 10, 20 & 40 - Acct 8130 - Cells C52, D52, F52). Transfer of Interest (Funds 10 thru 90 - Acct 7140 - Cells C30:K30), must equal (Funds 10 thru 60, & 80 - Acct 8140 - Cells C53:H53, J53). Transfer to Debt Service to Pay Principal on Capital Leases (Fund 30 - Acct 7400 - Cell E39) must equal (Funds 10, 20 & 60 - Acct 8400 Cells C57:H60). Transfer to Debt Service to Pay Interest on Capital Leases (Fund 30 - Acct 7500 - Cell E40) must equal (Funds 10, 20 & 60 - Acct 8500 - Cells C61:H64). Transfer to Debt Service Fund to Pay Principal on Revenue Bonds (Fund 30 - Acct 7600 Cell E41) must equal (Funds 10 & 20 - Acct 8600 - Cells C65:D68). Transfer to Debt Service to Pay Interest on Revenue Bonds (Fund 30 - Acct 7700 - Cell E42) must equal (Funds 10 & 20 - Acct 8700 - Cells C69:D72). Transfer to Capital Projects Fund (Fund 60 - Acct 7800 - Cell H43) must equal (Fund 10 & 20, Acct 8800 - Cells C73:D76).
OK OK OK OK OK OK OK OK
3. Summary of Cash Transactions: Beginning Cash Balance on Hand July 1, 2017, (CashSum 4, All Funds), cannot be negative. Educational (Fund 10 - Cell C3) OK Operations & Maintenance (Fund 20 - Cell D3) OK Debt Service (Fund 30 - Cell E3) OK Transportation (Fund 40 - Cell F3) OK Municipal Retirement/Social Security (Fund 50 - Cell G3) OK Capital Projects (Fund 60 - Cell H3) OK Working Cash (Fund 70 - Cell I3) OK Tort (Fund 80 - Cell J3) OK Fire Prevention & Safety (Fund 90 - Cell K3) OK 4. Summary of Cash Transactions: Ending Cash Balance on Hand June 30, 2018, (Page CashSum 4 - All Funds), cannot be negative. Educational (Fund 10 - Cell C21) OK Operations & Maintenance (Fund 20 - Cell D21) OK Debt Service (Fund 30 - Cell E21) OK Transportation (Fund 40 - F21) OK Municipal Retirement/Social Security (Fund 50 - Cell G21) OK Capital Projects (Fund 60 - H21) OK Working Cash (Fund 70 - Cell I21) OK Tort (Fund 80 - Cell J21) OK Fire Prevention & Safety (Fund 90 - Cell K21) OK 5. Summary of Cash Transactions: Other Receipts, (Page CashSum 4), must equal Other Disbursements, (Page CashSum 4). Interfund Loans Payable (Funds 10:60, 80, 90 - Acct 411 - Cells C6:H6, J6:K6) must equal Interfund Loans Receivable (Funds 10:20, 40, 70 - Acct 141 - Cells C15:D15, F15, I15).
OK
Interfund Loans Receivable (Funds 10, 20, 40 & 70 - Acct 141 - Cells C7:D7, F7, I7) must equal Interfund Loans Payable (Funds 10:60, 80, 90 - Acct 411 - Cells C16:H16, J16, K16).
OK
End of Balancing
\\Bdbkfilep11.dmz.tasb.org\appsdata\BBookv3\data\1000774\50258049\data\Uploads41283342.xlsx
9/25/2017