2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Unrestricted (Resources 0000-1999) Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) LCFF SOURCES Principal Apportionment State Aid - Current Year 8011 86,888,916.00 87,183,373.00 55,892,492.00 86,985,793.00 (197,580.00) -0.2% Education Protection Account State Aid - Current Year 8012 16,655,429.00 17,959,724.00 9,763,524.00 17,959,724.00 0.00 0.0% State Aid - Prior Years 8019 0.00 0.00 3,125,675.00 0.00 0.00 0.0% Tax Relief Subventions Homeowners' Exemptions 8021 45,000.00 45,000.00 44,291.87 45,000.00 0.00 0.0% Timber Yield Tax 8022 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8029 0.00 0.00 0.00 0.00 0.00 0.0% County & District Taxes Secured Roll Taxes 8041 8,300,000.00 8,300,000.00 4,960,181.23 8,300,000.00 0.00 0.0% Unsecured Roll Taxes 8042 350,000.00 350,000.00 384,204.34 350,000.00 0.00 0.0% Prior Years' Taxes 8043 75,000.00 75,000.00 82,075.29 75,000.00 0.00 0.0% Supplemental Taxes 8044 250,000.00 250,000.00 274,687.43 250,000.00 0.00 0.0% Education Revenue Augmentation Fund (ERAF) 8045 (1,900,000.00) (1,900,000.00) (1,188,652.30) (1,900,000.00) 0.00 0.0% Community Redevelopment Funds (SB 617/699/1992) 8047 5,870,000.00 5,870,000.00 6,949,608.47 5,870,000.00 0.00 0.0% Penalties and Interest from Delinquent Taxes 8048 10,000.00 10,000.00 8,398.30 10,000.00 0.00 0.0% Miscellaneous Funds (EC 41604) Royalties and Bonuses 8081 0.00 0.00 0.00 0.00 0.00 0.0% Other In-Lieu Taxes 8082 0.00 0.00 0.00 0.00 0.00 0.0% Less: Non-LCFF (50%) Adjustment 8089 0.00 0.00 0.00 0.00 0.00 0.0% Subtotal, LCFF Sources 116,544,345.00 118,143,097.00 80,296,485.63 117,945,517.00 (197,580.00) -0.2% LCFF Transfers Unrestricted LCFF Transfers - Current Year 0000 8091 0.00 0.00 0.00 0.00 0.00 0.0% All Other LCFF Transfers - Current Year All Other 8091 0.00 0.00 0.00 0.00 0.00 0.0% Transfers to Charter Schools in Lieu of Property Taxes 8096 0.00 0.00 0.00 0.00 0.00 0.0% Property Taxes Transfers 8097 0.00 0.00 0.00 0.00 0.00 0.0% LCFF/Revenue Limit Transfers - Prior Years 8099 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, LCFF SOURCES 116,544,345.00 118,143,097.00 80,296,485.63 117,945,517.00 (197,580.00) -0.2% FEDERAL REVENUE Maintenance and Operations 8110 0.00 0.00 0.00 0.00 0.00 0.0% Special Education Entitlement 8181 0.00 0.00 0.00 0.00 Special Education Discretionary Grants 8182 0.00 0.00 0.00 0.00 Child Nutrition Programs 8220 0.00 0.00 0.00 0.00 Donated Food Commodities 8221 0.00 0.00 0.00 0.00 Forest Reserve Funds 8260 0.00 0.00 0.00 0.00 0.00 0.0% Flood Control Funds 8270 0.00 0.00 0.00 0.00 0.00 0.0% Wildlife Reserve Funds 8280 0.00 0.00 0.00 0.00 0.00 0.0% FEMA 8281 0.00 0.00 0.00 0.00 0.00 0.0% Interagency Contracts Between LEAs 8285 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues from Federal Sources 8287 0.00 0.00 0.00 0.00 Title I, Part A, Basic 3010 8290 Title I, Part D, Local Delinquent Programs 3025 8290 Title II, Part A, Educator Quality 4035 8290 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 04/13/2018) Page 3 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Unrestricted (Resources 0000-1999) Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) Title III, Part A, Immigrant Education Program 4201 8290 Title III, Part A, English Learner Program 4203 8290 Public Charter Schools Grant Program (PCSGP) 4610 8290 3020, 3040, 3041, 3045, 3060, 3061, 3110, 3150, 3155, 3177, 3180, 3181, 3185, 4050, 4123, 4124, 4126, 4127, Other NCLB / Every Student Succeeds Act 5510, 5630 8290 Career and Technical Education 3500-3599 8290 All Other Federal Revenue All Other 8290 75,000.00 75,000.00 41,301.00 75,000.00 0.00 0.0% TOTAL, FEDERAL REVENUE 75,000.00 75,000.00 41,301.00 75,000.00 0.00 0.0% OTHER STATE REVENUE Other State Apportionments ROC/P Entitlement Prior Years 6360 8319 Special Education Master Plan Current Year 6500 8311 Prior Years 6500 8319 All Other State Apportionments - Current Year All Other 8311 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Apportionments - Prior Years All Other 8319 0.00 0.00 0.00 0.00 0.00 0.0% Child Nutrition Programs 8520 0.00 0.00 0.00 0.00 Mandated Costs Reimbursements 8550 5,142,349.00 2,949,859.00 1,688,491.00 2,949,859.00 0.00 0.0% Lottery - Unrestricted and Instructional Materials 8560 2,085,086.00 2,074,832.00 765,442.78 2,074,832.00 0.00 0.0% Tax Relief Subventions Restricted Levies - Other Homeowners' Exemptions 8575 0.00 0.00 0.00 0.00 Other Subventions/In-Lieu Taxes 8576 0.00 0.00 0.00 0.00 Pass-Through Revenues from State Sources 8587 0.00 0.00 0.00 0.00 0.00 0.0% After School Education and Safety (ASES) 6010 8590 Charter School Facility Grant 6030 8590 Career Technical Education Incentive Grant Program 6387 8590 Drug/Alcohol/Tobacco Funds 6650, 6690, 6695 8590 California Clean Energy Jobs Act 6230 8590 Specialized Secondary 7370 8590 American Indian Early Childhood Education 7210 8590 Quality Education Investment Act 7400 8590 All Other State Revenue All Other 8590 39,000.00 39,000.00 7,010.00 39,000.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 7,266,435.00 5,063,691.00 2,460,943.78 5,063,691.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 04/13/2018) Page 4 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Unrestricted (Resources 0000-1999) Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) OTHER LOCAL REVENUE Other Local Revenue County and District Taxes Other Restricted Levies Secured Roll 8615 0.00 0.00 0.00 0.00 Unsecured Roll 8616 0.00 0.00 0.00 0.00 Prior Years' Taxes 8617 0.00 0.00 0.00 0.00 Supplemental Taxes 8618 0.00 0.00 0.00 0.00 Non-Ad Valorem Taxes Parcel Taxes 8621 0.00 0.00 0.00 0.00 0.00 0.0% Other 8622 0.00 0.00 0.00 0.00 0.00 0.0% Community Redevelopment Funds Not Subject to LCFF Deduction 8625 0.00 0.00 0.00 0.00 Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 0.00 0.00 0.00 Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Sale of Publications 8632 0.00 0.00 0.00 0.00 0.00 0.0% Food Service Sales 8634 0.00 0.00 0.00 0.00 0.00 0.0% All Other Sales 8639 0.00 0.00 0.00 0.00 0.00 0.0% Leases and Rentals 8650 65,000.00 65,000.00 43,021.29 65,000.00 0.00 0.0% Interest 8660 413,000.00 413,000.00 371,484.60 413,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Fees and Contracts Adult Education Fees 8671 0.00 0.00 0.00 0.00 0.00 0.0% Non-Resident Students 8672 0.00 0.00 0.00 0.00 0.00 0.0% Transportation Fees From Individuals 8675 0.00 0.00 0.00 0.00 0.00 0.0% Interagency Services 8677 1,200,000.00 1,200,000.00 360,670.48 1,200,000.00 0.00 0.0% Mitigation/Developer Fees 8681 0.00 0.00 0.00 0.00 0.00 0.0% All Other Fees and Contracts 8689 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue Plus: Misc Funds Non-LCFF (50%) Adjustment 8691 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues From Local Sources 8697 0.00 0.00 0.00 0.00 All Other Local Revenue 8699 5,560,500.00 5,822,075.00 3,959,663.13 5,822,075.00 0.00 0.0% Tuition 8710 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In 8781-8783 0.00 0.00 0.00 0.00 0.00 0.0% Transfers Of Apportionments Special Education SELPA Transfers From Districts or Charter Schools 6500 8791 From County Offices 6500 8792 From JPAs 6500 8793 ROC/P Transfers From Districts or Charter Schools 6360 8791 From County Offices 6360 8792 From JPAs 6360 8793 Other Transfers of Apportionments From Districts or Charter Schools All Other 8791 0.00 0.00 0.00 0.00 0.00 0.0% From County Offices All Other 8792 0.00 0.00 0.00 0.00 0.00 0.0% From JPAs All Other 8793 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 7,238,500.00 7,500,075.00 4,734,839.50 7,500,075.00 0.00 0.0% TOTAL, REVENUES 131,124,280.00 130,781,863.00 87,533,569.91 130,584,283.00 (197,580.00) -0.2% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 04/13/2018) Page 5 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Unrestricted (Resources 0000-1999) Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) Certificated Teachers' Salaries 1100 50,459,642.00 50,521,531.00 25,164,934.66 50,543,330.00 (21,799.00) 0.0% Certificated Pupil Support Salaries 1200 1,065,418.00 1,158,918.00 620,137.38 1,158,918.00 0.00 0.0% Certificated Supervisors' and Administrators' Salaries 1300 5,179,335.00 5,176,935.00 2,769,352.57 5,176,935.00 0.00 0.0% Other Certificated Salaries 1900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CERTIFICATED SALARIES 56,704,395.00 56,857,384.00 28,554,424.61 56,879,183.00 (21,799.00) 0.0% CLASSIFIED SALARIES Classified Instructional Salaries 2100 1,825,365.00 1,875,027.00 1,056,548.71 1,876,077.00 (1,050.00) -0.1% Classified Support Salaries 2200 3,545,628.00 3,579,523.00 2,082,083.54 3,579,673.00 (150.00) 0.0% Classified Supervisors' and Administrators' Salaries 2300 756,237.00 787,237.00 458,039.28 787,237.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 4,353,910.00 4,332,504.00 2,530,087.34 4,333,504.00 (1,000.00) 0.0% Other Classified Salaries 2900 3,740,955.00 3,807,330.00 2,579,447.21 3,807,330.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 14,222,095.00 14,381,621.00 8,706,206.08 14,383,821.00 (2,200.00) 0.0% EMPLOYEE BENEFITS STRS 3101-3102 8,867,211.00 8,873,866.00 4,602,900.04 8,873,067.00 799.00 0.0% PERS 3201-3202 2,521,330.00 2,364,824.00 1,199,296.55 2,364,824.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 1,711,758.00 1,724,290.00 963,493.00 1,724,965.00 (675.00) 0.0% Health and Welfare Benefits 3401-3402 6,713,446.00 7,288,790.00 3,847,363.34 7,288,790.00 0.00 0.0% Unemployment Insurance 3501-3502 35,189.00 35,407.00 18,534.63 35,427.00 (20.00) -0.1% Workers' Compensation 3601-3602 1,226,916.00 1,231,565.00 599,683.24 1,231,920.00 (355.00) 0.0% OPEB, Allocated 3701-3702 384,800.00 456,000.00 241,934.19 456,000.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 1,519,402.00 1,423,220.00 993,301.70 1,423,220.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 22,980,052.00 23,397,962.00 12,466,506.69 23,398,213.00 (251.00) 0.0% BOOKS AND SUPPLIES Approved Textbooks and Core Curricula Materials 4100 0.00 0.00 0.00 0.00 0.00 0.0% Books and Other Reference Materials 4200 110,908.00 113,348.00 78,659.26 112,959.00 389.00 0.3% Materials and Supplies 4300 3,241,935.00 4,435,280.00 1,512,028.14 4,382,211.00 53,069.00 1.2% Noncapitalized Equipment 4400 365,968.00 381,513.00 92,441.93 400,395.00 (18,882.00) -4.9% Food 4700 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, BOOKS AND SUPPLIES 3,718,811.00 4,930,141.00 1,683,129.33 4,895,565.00 34,576.00 0.7% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 3,798,754.00 3,795,454.00 2,032,044.43 3,794,454.00 1,000.00 0.0% Travel and Conferences 5200 210,032.00 292,965.00 191,022.53 298,465.00 (5,500.00) -1.9% Dues and Memberships 5300 44,043.00 66,061.00 51,102.41 66,061.00 0.00 0.0% Insurance 5400-5450 721,500.00 773,733.00 729,261.93 773,733.00 0.00 0.0% Operations and Housekeeping Services 5500 3,118,727.00 2,801,877.00 1,163,160.73 2,801,877.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 355,966.00 390,617.00 102,370.65 392,145.00 (1,528.00) -0.4% Transfers of Direct Costs 5710 (149.00) (2,219.00) (958.29) (2,219.00) 0.00 0.0% Transfers of Direct Costs - Interfund 5750 (153,679.00) (152,159.00) 8,157.36 (152,159.00) 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 4,301,247.00 4,810,704.00 2,750,615.57 4,815,002.00 (4,298.00) -0.1% Communications 5900 314,152.00 328,357.00 210,939.87 328,357.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 12,710,593.00 13,105,390.00 7,237,717.19 13,115,716.00 (10,326.00) -0.1% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 04/13/2018) Page 6 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Unrestricted (Resources 0000-1999) Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 0.00 0.00 0.00 0.00 0.0% Land Improvements 6170 0.00 0.00 0.00 0.00 0.00 0.0% Buildings and Improvements of Buildings 6200 0.00 35,590.00 0.00 35,590.00 0.00 0.0% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 6,742.00 7,942.00 3,850.60 7,942.00 0.00 0.0% Equipment Replacement 6500 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 6,742.00 43,532.00 3,850.60 43,532.00 0.00 0.0% OTHER OUTGO (excluding Transfers of Indirect Costs) Tuition Tuition for Instruction Under Interdistrict Attendance Agreements 7110 0.00 0.00 0.00 0.00 0.00 0.0% State Special Schools 7130 0.00 0.00 0.00 0.00 0.00 0.0% Tuition, Excess Costs, and/or Deficit Payments Payments to Districts or Charter Schools 7141 0.00 0.00 0.00 0.00 0.00 0.0% Payments to County Offices 7142 475,000.00 475,000.00 26,152.50 475,000.00 0.00 0.0% Payments to JPAs 7143 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Pass-Through Revenues To Districts or Charter Schools 7211 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 7212 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 7213 0.00 0.00 0.00 0.00 0.00 0.0% Special Education SELPA Transfers of Apportionments To Districts or Charter Schools 6500 7221 To County Offices 6500 7222 To JPAs 6500 7223 ROC/P Transfers of Apportionments To Districts or Charter Schools 6360 7221 To County Offices 6360 7222 To JPAs 6360 7223 Other Transfers of Apportionments All Other 7221-7223 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers 7281-7283 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 475,000.00 475,000.00 26,152.50 475,000.00 0.00 0.0% OTHER OUTGO - TRANSFERS OF INDIRECT COSTS Transfers of Indirect Costs 7310 (226,883.00) (255,598.00) 0.00 (229,692.00) (25,906.00) 10.1% Transfers of Indirect Costs - Interfund 7350 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO - TRANSFERS OF INDIRECT COSTS (226,883.00) (255,598.00) 0.00 (229,692.00) (25,906.00) 10.1% TOTAL, EXPENDITURES 110,590,805.00 112,935,432.00 58,677,987.00 112,961,338.00 (25,906.00) 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 04/13/2018) Page 7 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Unrestricted (Resources 0000-1999) Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN From: Special Reserve Fund 8912 0.00 0.00 0.00 0.00 0.00 0.0% From: Bond Interest and Redemption Fund 8914 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers In 8919 2,595,129.00 2,656,000.00 0.00 2,656,000.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 2,595,129.00 2,656,000.00 0.00 2,656,000.00 0.00 0.0% INTERFUND TRANSFERS OUT To: Child Development Fund 7611 0.00 0.00 0.00 0.00 0.00 0.0% To: Special Reserve Fund 7612 0.00 0.00 0.00 0.00 0.00 0.0% To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% To: Cafeteria Fund 7616 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 617,601.00 1,467,585.00 0.00 1,467,585.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 617,601.00 1,467,585.00 0.00 1,467,585.00 0.00 0.0% OTHER SOURCES/USES SOURCES State Apportionments Emergency Apportionments 8931 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds Proceeds from Sale/Lease- Purchase of Land/Buildings 8953 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 (21,965,136.00) (22,110,235.00) 0.00 (22,110,235.00) 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS (21,965,136.00) (22,110,235.00) 0.00 (22,110,235.00) 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) (19,987,608.00) (20,921,820.00) 0.00 (20,921,820.00) 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 04/13/2018) Page 8 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 4,036,639.00 4,277,726.00 1,207,827.70 4,277,726.00 0.00 0.0% 3) Other State Revenue 8300-8599 2,698,821.00 2,792,662.00 493,981.26 2,792,662.00 0.00 0.0% 4) Other Local Revenue 8600-8799 7,230,394.00 7,282,001.00 3,951,767.49 7,282,001.00 0.00 0.0% 5) TOTAL, REVENUES 13,965,854.00 14,352,389.00 5,653,576.45 14,352,389.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 11,978,455.00 12,720,793.00 6,083,424.29 12,195,693.00 525,100.00 4.1% 2) Classified Salaries 2000-2999 8,013,946.00 8,268,353.00 4,856,814.69 8,260,580.00 7,773.00 0.1% 3) Employee Benefits 3000-3999 5,912,733.00 6,289,791.00 3,195,509.01 6,158,442.00 131,349.00 2.1% 4) Books and Supplies 4000-4999 1,791,864.00 2,974,866.00 481,486.64 2,993,335.00 (18,469.00) -0.6% 5) Services and Other Operating Expenditures 5000-5999 4,047,080.00 4,812,258.00 2,099,997.35 4,797,332.00 14,926.00 0.3% 6) Capital Outlay 6000-6999 1,132,734.00 1,302,944.00 322,554.44 1,302,944.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299 Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 226,883.00 255,598.00 0.00 229,692.00 25,906.00 10.1% 9) TOTAL, EXPENDITURES 33,103,695.00 36,624,603.00 17,039,786.42 35,938,018.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) (19,137,841.00) (22,272,214.00) (11,386,209.97) (21,585,629.00) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 2,238,300.00 2,238,300.00 0.00 2,238,300.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 21,965,136.00 22,110,235.00 0.00 22,110,235.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 19,726,836.00 19,871,935.00 0.00 19,871,935.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 1 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 588,995.00 (2,400,279.00) (11,386,209.97) (1,713,694.00) F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 542,798.05 3,334,542.87 3,334,542.87 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 542,798.05 3,334,542.87 3,334,542.87 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 542,798.05 3,334,542.87 3,334,542.87 2) Ending Balance, June 30 (E + F1e) 1,131,793.05 934,263.87 1,620,848.87 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Restricted 9740 1,131,793.05 934,263.87 1,620,848.87 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 2 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) LCFF SOURCES Principal Apportionment State Aid - Current Year 8011 0.00 0.00 0.00 0.00 Education Protection Account State Aid - Current Year 8012 0.00 0.00 0.00 0.00 State Aid - Prior Years 8019 0.00 0.00 0.00 0.00 Tax Relief Subventions Homeowners' Exemptions 8021 0.00 0.00 0.00 0.00 Timber Yield Tax 8022 0.00 0.00 0.00 0.00 Other Subventions/In-Lieu Taxes 8029 0.00 0.00 0.00 0.00 County & District Taxes Secured Roll Taxes 8041 0.00 0.00 0.00 0.00 Unsecured Roll Taxes 8042 0.00 0.00 0.00 0.00 Prior Years' Taxes 8043 0.00 0.00 0.00 0.00 Supplemental Taxes 8044 0.00 0.00 0.00 0.00 Education Revenue Augmentation Fund (ERAF) 8045 0.00 0.00 0.00 0.00 Community Redevelopment Funds (SB 617/699/1992) 8047 0.00 0.00 0.00 0.00 Penalties and Interest from Delinquent Taxes 8048 0.00 0.00 0.00 0.00 Miscellaneous Funds (EC 41604) Royalties and Bonuses 8081 0.00 0.00 0.00 0.00 Other In-Lieu Taxes 8082 0.00 0.00 0.00 0.00 Less: Non-LCFF (50%) Adjustment 8089 0.00 0.00 0.00 0.00 Subtotal, LCFF Sources 0.00 0.00 0.00 0.00 LCFF Transfers Unrestricted LCFF Transfers - Current Year 0000 8091 All Other LCFF Transfers - Current Year All Other 8091 0.00 0.00 0.00 0.00 0.00 0.0% Transfers to Charter Schools in Lieu of Property Taxes 8096 0.00 0.00 0.00 0.00 Property Taxes Transfers 8097 0.00 0.00 0.00 0.00 0.00 0.0% LCFF/Revenue Limit Transfers - Prior Years 8099 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, LCFF SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% FEDERAL REVENUE Maintenance and Operations 8110 0.00 0.00 0.00 0.00 0.00 0.0% Special Education Entitlement 8181 2,276,769.00 2,414,566.00 0.00 2,414,566.00 0.00 0.0% Special Education Discretionary Grants 8182 4,500.00 3,463.00 0.00 3,463.00 0.00 0.0% Child Nutrition Programs 8220 0.00 0.00 0.00 0.00 0.00 0.0% Donated Food Commodities 8221 0.00 0.00 0.00 0.00 0.00 0.0% Forest Reserve Funds 8260 0.00 0.00 0.00 0.00 Flood Control Funds 8270 0.00 0.00 0.00 0.00 Wildlife Reserve Funds 8280 0.00 0.00 0.00 0.00 FEMA 8281 0.00 0.00 0.00 0.00 0.00 0.0% Interagency Contracts Between LEAs 8285 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues from Federal Sources 8287 0.00 0.00 0.00 0.00 0.00 0.0% Title I, Part A, Basic 3010 8290 1,144,066.00 1,163,844.00 819,698.90 1,163,844.00 0.00 0.0% Title I, Part D, Local Delinquent Programs 3025 8290 0.00 0.00 0.00 0.00 0.00 0.0% Title II, Part A, Educator Quality 4035 8290 223,994.00 230,667.00 136,954.00 230,667.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 3 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) Title III, Part A, Immigrant Education Program 4201 8290 32,885.00 38,048.00 14,127.14 38,048.00 0.00 0.0% Title III, Part A, English Learner Program 4203 8290 124,425.00 121,931.00 60,966.00 121,931.00 0.00 0.0% Public Charter Schools Grant Program (PCSGP) 4610 8290 0.00 0.00 0.00 0.00 0.00 0.0% 3020, 3040, 3041, 3045, 3060, 3061, 3110, 3150, 3155, 3177, 3180, 3181, 3185, 4050, 4123, 4124, 4126, 4127, Other NCLB / Every Student Succeeds Act 5510, 5630 8290 0.00 75,207.00 37,604.00 75,207.00 0.00 0.0% Career and Technical Education 3500-3599 8290 0.00 0.00 0.00 0.00 0.00 0.0% All Other Federal Revenue All Other 8290 230,000.00 230,000.00 138,477.66 230,000.00 0.00 0.0% TOTAL, FEDERAL REVENUE 4,036,639.00 4,277,726.00 1,207,827.70 4,277,726.00 0.00 0.0% OTHER STATE REVENUE Other State Apportionments ROC/P Entitlement Prior Years 6360 8319 0.00 0.00 0.00 0.00 0.00 0.0% Special Education Master Plan Current Year 6500 8311 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years 6500 8319 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Apportionments - Current Year All Other 8311 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Apportionments - Prior Years All Other 8319 0.00 0.00 0.00 0.00 0.00 0.0% Child Nutrition Programs 8520 0.00 0.00 0.00 0.00 0.00 0.0% Mandated Costs Reimbursements 8550 0.00 0.00 0.00 0.00 Lottery - Unrestricted and Instructional Materia 8560 685,508.00 728,252.00 74,105.26 728,252.00 0.00 0.0% Tax Relief Subventions Restricted Levies - Other Homeowners' Exemptions 8575 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8576 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues from State Sources 8587 0.00 0.00 0.00 0.00 0.00 0.0% After School Education and Safety (ASES) 6010 8590 0.00 0.00 0.00 0.00 0.00 0.0% Charter School Facility Grant 6030 8590 0.00 0.00 0.00 0.00 0.00 0.0% Career Technical Education Incentive Grant Program 6387 8590 0.00 0.00 0.00 0.00 0.00 0.0% Drug/Alcohol/Tobacco Funds 6650, 6690, 6695 8590 0.00 0.00 0.00 0.00 0.00 0.0% California Clean Energy Jobs Act 6230 8590 1,621,380.00 891,205.00 0.00 891,205.00 0.00 0.0% Specialized Secondary 7370 8590 0.00 0.00 0.00 0.00 0.00 0.0% American Indian Early Childhood Education 7210 8590 0.00 0.00 0.00 0.00 0.00 0.0% Quality Education Investment Act 7400 8590 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Revenue All Other 8590 391,933.00 1,173,205.00 419,876.00 1,173,205.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 2,698,821.00 2,792,662.00 493,981.26 2,792,662.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 4 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) OTHER LOCAL REVENUE Other Local Revenue County and District Taxes Other Restricted Levies Secured Roll 8615 0.00 0.00 0.00 0.00 0.00 0.0% Unsecured Roll 8616 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years' Taxes 8617 0.00 0.00 0.00 0.00 0.00 0.0% Supplemental Taxes 8618 0.00 0.00 0.00 0.00 0.00 0.0% Non-Ad Valorem Taxes Parcel Taxes 8621 0.00 0.00 0.00 0.00 0.00 0.0% Other 8622 0.00 0.00 0.00 0.00 0.00 0.0% Community Redevelopment Funds Not Subject to LCFF Deduction 8625 2,238,300.00 2,238,300.00 1,647,727.10 2,238,300.00 0.00 0.0% Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 0.00 0.00 0.00 0.00 0.0% Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Sale of Publications 8632 0.00 0.00 0.00 0.00 0.00 0.0% Food Service Sales 8634 0.00 0.00 0.00 0.00 0.00 0.0% All Other Sales 8639 0.00 0.00 0.00 0.00 0.00 0.0% Leases and Rentals 8650 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 0.00 0.00 0.00 0.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Fees and Contracts Adult Education Fees 8671 0.00 0.00 0.00 0.00 Non-Resident Students 8672 0.00 0.00 0.00 0.00 Transportation Fees From Individuals 8675 0.00 0.00 0.00 0.00 0.00 0.0% Interagency Services 8677 0.00 0.00 0.00 0.00 0.00 0.0% Mitigation/Developer Fees 8681 0.00 0.00 0.00 0.00 0.00 0.0% All Other Fees and Contracts 8689 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue Plus: Misc Funds Non-LCFF (50%) Adjustme 8691 0.00 0.00 0.00 0.00 Pass-Through Revenues From Local Sources 8697 0.00 0.00 0.00 0.00 0.00 0.0% All Other Local Revenue 8699 0.00 24,949.00 24,948.41 24,949.00 0.00 0.0% Tuition 8710 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In 8781-8783 0.00 0.00 0.00 0.00 0.00 0.0% Transfers Of Apportionments Special Education SELPA Transfers From Districts or Charter Schools 6500 8791 0.00 0.00 0.00 0.00 0.00 0.0% From County Offices 6500 8792 4,992,094.00 5,018,752.00 2,279,091.98 5,018,752.00 0.00 0.0% From JPAs 6500 8793 0.00 0.00 0.00 0.00 0.00 0.0% ROC/P Transfers From Districts or Charter Schools 6360 8791 0.00 0.00 0.00 0.00 0.00 0.0% From County Offices 6360 8792 0.00 0.00 0.00 0.00 0.00 0.0% From JPAs 6360 8793 0.00 0.00 0.00 0.00 0.00 0.0% Other Transfers of Apportionments From Districts or Charter Schools All Other 8791 0.00 0.00 0.00 0.00 0.00 0.0% From County Offices All Other 8792 0.00 0.00 0.00 0.00 0.00 0.0% From JPAs All Other 8793 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 7,230,394.00 7,282,001.00 3,951,767.49 7,282,001.00 0.00 0.0% TOTAL, REVENUES 13,965,854.00 14,352,389.00 5,653,576.45 14,352,389.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 5 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) CERTIFICATED SALARIES Certificated Teachers' Salaries 1100 9,158,502.00 9,878,659.00 4,551,319.74 9,353,559.00 525,100.00 5.3% Certificated Pupil Support Salaries 1200 2,026,982.00 2,045,863.00 1,107,325.93 2,045,863.00 0.00 0.0% Certificated Supervisors' and Administrators' Salaries 1300 792,971.00 796,271.00 424,778.62 796,271.00 0.00 0.0% Other Certificated Salaries 1900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CERTIFICATED SALARIES 11,978,455.00 12,720,793.00 6,083,424.29 12,195,693.00 525,100.00 4.1% CLASSIFIED SALARIES Classified Instructional Salaries 2100 6,225,176.00 6,448,413.00 3,852,063.99 6,440,362.00 8,051.00 0.1% Classified Support Salaries 2200 1,299,632.00 1,294,633.00 741,181.32 1,294,633.00 0.00 0.0% Classified Supervisors' and Administrators' Salaries 2300 106,856.00 106,856.00 62,570.90 106,856.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 382,282.00 417,851.00 200,562.77 418,129.00 (278.00) -0.1% Other Classified Salaries 2900 0.00 600.00 435.71 600.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 8,013,946.00 8,268,353.00 4,856,814.69 8,260,580.00 7,773.00 0.1% EMPLOYEE BENEFITS STRS 3101-3102 1,858,583.00 2,002,996.00 973,051.97 1,892,142.00 110,854.00 5.5% PERS 3201-3202 1,173,972.00 1,175,146.00 625,429.21 1,175,146.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 646,993.00 708,982.00 386,659.00 699,333.00 9,649.00 1.4% Health and Welfare Benefits 3401-3402 1,818,116.00 1,977,740.00 1,005,955.13 1,977,740.00 0.00 0.0% Unemployment Insurance 3501-3502 9,742.00 10,451.00 5,418.84 10,117.00 334.00 3.2% Workers' Compensation 3601-3602 345,483.00 360,732.00 174,657.36 350,220.00 10,512.00 2.9% OPEB, Allocated 3701-3702 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 59,844.00 53,744.00 24,337.50 53,744.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 5,912,733.00 6,289,791.00 3,195,509.01 6,158,442.00 131,349.00 2.1% BOOKS AND SUPPLIES Approved Textbooks and Core Curricula Materials 4100 471,100.00 1,745,840.00 44,640.68 1,745,840.00 0.00 0.0% Books and Other Reference Materials 4200 187,023.00 180,866.00 39,707.20 180,866.00 0.00 0.0% Materials and Supplies 4300 1,100,753.00 1,018,585.00 389,340.68 1,025,354.00 (6,769.00) -0.7% Noncapitalized Equipment 4400 32,988.00 29,575.00 7,798.08 41,275.00 (11,700.00) -39.6% Food 4700 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, BOOKS AND SUPPLIES 1,791,864.00 2,974,866.00 481,486.64 2,993,335.00 (18,469.00) -0.6% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 1,009,510.00 1,176,591.00 429,646.32 1,176,591.00 0.00 0.0% Travel and Conferences 5200 126,751.00 156,567.00 56,176.08 156,120.00 447.00 0.3% Dues and Memberships 5300 213.00 1,830.00 1,665.61 1,830.00 0.00 0.0% Insurance 5400-5450 0.00 0.00 0.00 0.00 0.00 0.0% Operations and Housekeeping Services 5500 0.00 0.00 0.00 0.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 1,773,737.00 2,561,504.00 1,453,248.76 2,549,804.00 11,700.00 0.5% Transfers of Direct Costs 5710 149.00 2,219.00 958.29 2,219.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 0.00 0.00 0.00 0.00 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 1,130,440.00 907,267.00 157,318.92 904,488.00 2,779.00 0.3% Communications 5900 6,280.00 6,280.00 983.37 6,280.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 4,047,080.00 4,812,258.00 2,099,997.35 4,797,332.00 14,926.00 0.3% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 6 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 0.00 0.00 0.00 0.00 0.0% Land Improvements 6170 0.00 0.00 0.00 0.00 0.00 0.0% Buildings and Improvements of Buildings 6200 1,057,734.00 1,207,184.00 235,324.55 1,207,184.00 0.00 0.0% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 0.00 2,193.00 2,192.76 2,193.00 0.00 0.0% Equipment Replacement 6500 75,000.00 93,567.00 85,037.13 93,567.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 1,132,734.00 1,302,944.00 322,554.44 1,302,944.00 0.00 0.0% OTHER OUTGO (excluding Transfers of Indirect Costs) Tuition Tuition for Instruction Under Interdistrict Attendance Agreements 7110 0.00 0.00 0.00 0.00 0.00 0.0% State Special Schools 7130 0.00 0.00 0.00 0.00 0.00 0.0% Tuition, Excess Costs, and/or Deficit Payments Payments to Districts or Charter Schools 7141 0.00 0.00 0.00 0.00 0.00 0.0% Payments to County Offices 7142 0.00 0.00 0.00 0.00 0.00 0.0% Payments to JPAs 7143 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Pass-Through Revenues To Districts or Charter Schools 7211 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 7212 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 7213 0.00 0.00 0.00 0.00 0.00 0.0% Special Education SELPA Transfers of Apportionments To Districts or Charter Schools 6500 7221 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 6500 7222 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 6500 7223 0.00 0.00 0.00 0.00 0.00 0.0% ROC/P Transfers of Apportionments To Districts or Charter Schools 6360 7221 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 6360 7222 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 6360 7223 0.00 0.00 0.00 0.00 0.00 0.0% Other Transfers of Apportionments All Other 7221-7223 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers 7281-7283 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 0.00 0.00 0.00 0.00 0.00 0.0% OTHER OUTGO - TRANSFERS OF INDIRECT COSTS Transfers of Indirect Costs 7310 226,883.00 255,598.00 0.00 229,692.00 25,906.00 10.1% Transfers of Indirect Costs - Interfund 7350 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO - TRANSFERS OF INDIRECT COSTS 226,883.00 255,598.00 0.00 229,692.00 25,906.00 10.1% TOTAL, EXPENDITURES 33,103,695.00 36,624,603.00 17,039,786.42 35,938,018.00 686,585.00 1.9% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 7 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Restricted (Resources 2000-9999) Form 01I Revenue, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN From: Special Reserve Fund 8912 0.00 0.00 0.00 0.00 0.00 0.0% From: Bond Interest and Redemption Fund 8914 0.00 0.00 0.00 0.00 Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT To: Child Development Fund 7611 0.00 0.00 0.00 0.00 0.00 0.0% To: Special Reserve Fund 7612 0.00 0.00 0.00 0.00 0.00 0.0% To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% To: Cafeteria Fund 7616 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 2,238,300.00 2,238,300.00 0.00 2,238,300.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 2,238,300.00 2,238,300.00 0.00 2,238,300.00 0.00 0.0% OTHER SOURCES/USES SOURCES State Apportionments Emergency Apportionments 8931 0.00 0.00 0.00 0.00 Proceeds Proceeds from Sale/Lease- Purchase of Land/Buildings 8953 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 21,965,136.00 22,110,235.00 0.00 22,110,235.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 21,965,136.00 22,110,235.00 0.00 22,110,235.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 19,726,836.00 19,871,935.00 0.00 19,871,935.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 02/21/2018) Page 8 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 116,544,345.00 118,143,097.00 80,296,485.63 117,945,517.00 (197,580.00) -0.2% 2) Federal Revenue 8100-8299 4,111,639.00 4,352,726.00 1,249,128.70 4,352,726.00 0.00 0.0% 3) Other State Revenue 8300-8599 9,965,256.00 7,856,353.00 2,954,925.04 7,856,353.00 0.00 0.0% 4) Other Local Revenue 8600-8799 14,468,894.00 14,782,076.00 8,686,606.99 14,782,076.00 0.00 0.0% 5) TOTAL, REVENUES 145,090,134.00 145,134,252.00 93,187,146.36 144,936,672.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 68,682,850.00 69,578,177.00 34,637,848.90 69,074,876.00 503,301.00 0.7% 2) Classified Salaries 2000-2999 22,236,041.00 22,649,974.00 13,563,020.77 22,644,401.00 5,573.00 0.0% 3) Employee Benefits 3000-3999 28,892,785.00 29,687,753.00 15,662,015.70 29,556,655.00 131,098.00 0.4% 4) Books and Supplies 4000-4999 5,510,675.00 7,905,007.00 2,164,615.97 7,888,900.00 16,107.00 0.2% 5) Services and Other Operating Expenditures 5000-5999 16,757,673.00 17,917,648.00 9,337,714.54 17,913,048.00 4,600.00 0.0% 6) Capital Outlay 6000-6999 1,139,476.00 1,346,476.00 326,405.04 1,346,476.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299 Costs) 7400-7499 475,000.00 475,000.00 26,152.50 475,000.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 143,694,500.00 149,560,035.00 75,717,773.42 148,899,356.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) 1,395,634.00 (4,425,783.00) 17,469,372.94 (3,962,684.00) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 2,595,129.00 2,656,000.00 0.00 2,656,000.00 0.00 0.0% b) Transfers Out 7600-7629 2,855,901.00 3,705,885.00 0.00 3,705,885.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES (260,772.00) (1,049,885.00) 0.00 (1,049,885.00) California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 1 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 1,134,862.00 (5,475,668.00) 17,469,372.94 (5,012,569.00) F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 15,444,634.68 28,157,594.03 28,157,594.03 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 15,444,634.68 28,157,594.03 28,157,594.03 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 15,444,634.68 28,157,594.03 28,157,594.03 2) Ending Balance, June 30 (E + F1e) 16,579,496.68 22,681,926.03 23,145,025.03 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 25,000.00 25,000.00 Stores 9712 0.00 50,000.00 50,000.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Restricted 9740 1,131,793.05 934,263.87 1,620,848.87 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 4,396,512.00 4,553,180.00 4,578,157.00 Unassigned/Unappropriated Amount 9790 11,051,191.63 17,119,482.16 16,871,019.16 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 2 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) LCFF SOURCES Principal Apportionment State Aid - Current Year 8011 86,888,916.00 87,183,373.00 55,892,492.00 86,985,793.00 (197,580.00) -0.2% Education Protection Account State Aid - Current Year 8012 16,655,429.00 17,959,724.00 9,763,524.00 17,959,724.00 0.00 0.0% State Aid - Prior Years 8019 0.00 0.00 3,125,675.00 0.00 0.00 0.0% Tax Relief Subventions Homeowners' Exemptions 8021 45,000.00 45,000.00 44,291.87 45,000.00 0.00 0.0% Timber Yield Tax 8022 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8029 0.00 0.00 0.00 0.00 0.00 0.0% County & District Taxes Secured Roll Taxes 8041 8,300,000.00 8,300,000.00 4,960,181.23 8,300,000.00 0.00 0.0% Unsecured Roll Taxes 8042 350,000.00 350,000.00 384,204.34 350,000.00 0.00 0.0% Prior Years' Taxes 8043 75,000.00 75,000.00 82,075.29 75,000.00 0.00 0.0% Supplemental Taxes 8044 250,000.00 250,000.00 274,687.43 250,000.00 0.00 0.0% Education Revenue Augmentation Fund (ERAF) 8045 (1,900,000.00) (1,900,000.00) (1,188,652.30) (1,900,000.00) 0.00 0.0% Community Redevelopment Funds (SB 617/699/1992) 8047 5,870,000.00 5,870,000.00 6,949,608.47 5,870,000.00 0.00 0.0% Penalties and Interest from Delinquent Taxes 8048 10,000.00 10,000.00 8,398.30 10,000.00 0.00 0.0% Miscellaneous Funds (EC 41604) Royalties and Bonuses 8081 0.00 0.00 0.00 0.00 0.00 0.0% Other In-Lieu Taxes 8082 0.00 0.00 0.00 0.00 0.00 0.0% Less: Non-LCFF (50%) Adjustment 8089 0.00 0.00 0.00 0.00 0.00 0.0% Subtotal, LCFF Sources 116,544,345.00 118,143,097.00 80,296,485.63 117,945,517.00 (197,580.00) -0.2% LCFF Transfers Unrestricted LCFF Transfers - Current Year 0000 8091 0.00 0.00 0.00 0.00 0.00 0.0% All Other LCFF Transfers - Current Year All Other 8091 0.00 0.00 0.00 0.00 0.00 0.0% Transfers to Charter Schools in Lieu of Property Taxes 8096 0.00 0.00 0.00 0.00 0.00 0.0% Property Taxes Transfers 8097 0.00 0.00 0.00 0.00 0.00 0.0% LCFF/Revenue Limit Transfers - Prior Years 8099 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, LCFF SOURCES 116,544,345.00 118,143,097.00 80,296,485.63 117,945,517.00 (197,580.00) -0.2% FEDERAL REVENUE Maintenance and Operations 8110 0.00 0.00 0.00 0.00 0.00 0.0% Special Education Entitlement 8181 2,276,769.00 2,414,566.00 0.00 2,414,566.00 0.00 0.0% Special Education Discretionary Grants 8182 4,500.00 3,463.00 0.00 3,463.00 0.00 0.0% Child Nutrition Programs 8220 0.00 0.00 0.00 0.00 0.00 0.0% Donated Food Commodities 8221 0.00 0.00 0.00 0.00 0.00 0.0% Forest Reserve Funds 8260 0.00 0.00 0.00 0.00 0.00 0.0% Flood Control Funds 8270 0.00 0.00 0.00 0.00 0.00 0.0% Wildlife Reserve Funds 8280 0.00 0.00 0.00 0.00 0.00 0.0% FEMA 8281 0.00 0.00 0.00 0.00 0.00 0.0% Interagency Contracts Between LEAs 8285 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues from Federal Sources 8287 0.00 0.00 0.00 0.00 0.00 0.0% Title I, Part A, Basic 3010 8290 1,144,066.00 1,163,844.00 819,698.90 1,163,844.00 0.00 0.0% Title I, Part D, Local Delinquent Programs 3025 8290 0.00 0.00 0.00 0.00 0.00 0.0% Title II, Part A, Educator Quality 4035 8290 223,994.00 230,667.00 136,954.00 230,667.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 3 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) Title III, Part A, Immigrant Education Program 4201 8290 32,885.00 38,048.00 14,127.14 38,048.00 0.00 0.0% Title III, Part A, English Learner Program 4203 8290 124,425.00 121,931.00 60,966.00 121,931.00 0.00 0.0% Public Charter Schools Grant Program (PCSGP) 4610 8290 0.00 0.00 0.00 0.00 0.00 0.0% 3020, 3040, 3041, 3045, 3060, 3061, 3110, 3150, 3155, 3177, 3180, 3181, 3185, 4050, 4123, 4124, 4126, 4127, Other NCLB / Every Student Succeeds Act 5510, 5630 8290 0.00 75,207.00 37,604.00 75,207.00 0.00 0.0% Career and Technical Education 3500-3599 8290 0.00 0.00 0.00 0.00 0.00 0.0% All Other Federal Revenue All Other 8290 305,000.00 305,000.00 179,778.66 305,000.00 0.00 0.0% TOTAL, FEDERAL REVENUE 4,111,639.00 4,352,726.00 1,249,128.70 4,352,726.00 0.00 0.0% OTHER STATE REVENUE Other State Apportionments ROC/P Entitlement Prior Years 6360 8319 0.00 0.00 0.00 0.00 0.00 0.0% Special Education Master Plan Current Year 6500 8311 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years 6500 8319 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Apportionments - Current Year All Other 8311 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Apportionments - Prior Years All Other 8319 0.00 0.00 0.00 0.00 0.00 0.0% Child Nutrition Programs 8520 0.00 0.00 0.00 0.00 0.00 0.0% Mandated Costs Reimbursements 8550 5,142,349.00 2,949,859.00 1,688,491.00 2,949,859.00 0.00 0.0% Lottery - Unrestricted and Instructional Materia 8560 2,770,594.00 2,803,084.00 839,548.04 2,803,084.00 0.00 0.0% Tax Relief Subventions Restricted Levies - Other Homeowners' Exemptions 8575 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8576 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues from State Sources 8587 0.00 0.00 0.00 0.00 0.00 0.0% After School Education and Safety (ASES) 6010 8590 0.00 0.00 0.00 0.00 0.00 0.0% Charter School Facility Grant 6030 8590 0.00 0.00 0.00 0.00 0.00 0.0% Career Technical Education Incentive Grant Program 6387 8590 0.00 0.00 0.00 0.00 0.00 0.0% Drug/Alcohol/Tobacco Funds 6650, 6690, 6695 8590 0.00 0.00 0.00 0.00 0.00 0.0% California Clean Energy Jobs Act 6230 8590 1,621,380.00 891,205.00 0.00 891,205.00 0.00 0.0% Specialized Secondary 7370 8590 0.00 0.00 0.00 0.00 0.00 0.0% American Indian Early Childhood Education 7210 8590 0.00 0.00 0.00 0.00 0.00 0.0% Quality Education Investment Act 7400 8590 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Revenue All Other 8590 430,933.00 1,212,205.00 426,886.00 1,212,205.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 9,965,256.00 7,856,353.00 2,954,925.04 7,856,353.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 4 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) OTHER LOCAL REVENUE Other Local Revenue County and District Taxes Other Restricted Levies Secured Roll 8615 0.00 0.00 0.00 0.00 0.00 0.0% Unsecured Roll 8616 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years' Taxes 8617 0.00 0.00 0.00 0.00 0.00 0.0% Supplemental Taxes 8618 0.00 0.00 0.00 0.00 0.00 0.0% Non-Ad Valorem Taxes Parcel Taxes 8621 0.00 0.00 0.00 0.00 0.00 0.0% Other 8622 0.00 0.00 0.00 0.00 0.00 0.0% Community Redevelopment Funds Not Subject to LCFF Deduction 8625 2,238,300.00 2,238,300.00 1,647,727.10 2,238,300.00 0.00 0.0% Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 0.00 0.00 0.00 0.00 0.0% Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Sale of Publications 8632 0.00 0.00 0.00 0.00 0.00 0.0% Food Service Sales 8634 0.00 0.00 0.00 0.00 0.00 0.0% All Other Sales 8639 0.00 0.00 0.00 0.00 0.00 0.0% Leases and Rentals 8650 65,000.00 65,000.00 43,021.29 65,000.00 0.00 0.0% Interest 8660 413,000.00 413,000.00 371,484.60 413,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Fees and Contracts Adult Education Fees 8671 0.00 0.00 0.00 0.00 0.00 0.0% Non-Resident Students 8672 0.00 0.00 0.00 0.00 0.00 0.0% Transportation Fees From Individuals 8675 0.00 0.00 0.00 0.00 0.00 0.0% Interagency Services 8677 1,200,000.00 1,200,000.00 360,670.48 1,200,000.00 0.00 0.0% Mitigation/Developer Fees 8681 0.00 0.00 0.00 0.00 0.00 0.0% All Other Fees and Contracts 8689 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue Plus: Misc Funds Non-LCFF (50%) Adjustment 8691 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues From Local Sources 8697 0.00 0.00 0.00 0.00 0.00 0.0% All Other Local Revenue 8699 5,560,500.00 5,847,024.00 3,984,611.54 5,847,024.00 0.00 0.0% Tuition 8710 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In 8781-8783 0.00 0.00 0.00 0.00 0.00 0.0% Transfers Of Apportionments Special Education SELPA Transfers From Districts or Charter Schools 6500 8791 0.00 0.00 0.00 0.00 0.00 0.0% From County Offices 6500 8792 4,992,094.00 5,018,752.00 2,279,091.98 5,018,752.00 0.00 0.0% From JPAs 6500 8793 0.00 0.00 0.00 0.00 0.00 0.0% ROC/P Transfers From Districts or Charter Schools 6360 8791 0.00 0.00 0.00 0.00 0.00 0.0% From County Offices 6360 8792 0.00 0.00 0.00 0.00 0.00 0.0% From JPAs 6360 8793 0.00 0.00 0.00 0.00 0.00 0.0% Other Transfers of Apportionments From Districts or Charter Schools All Other 8791 0.00 0.00 0.00 0.00 0.00 0.0% From County Offices All Other 8792 0.00 0.00 0.00 0.00 0.00 0.0% From JPAs All Other 8793 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 14,468,894.00 14,782,076.00 8,686,606.99 14,782,076.00 0.00 0.0% TOTAL, REVENUES 145,090,134.00 145,134,252.00 93,187,146.36 144,936,672.00 (197,580.00) -0.1% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 5 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) CERTIFICATED SALARIES Certificated Teachers' Salaries 1100 59,618,144.00 60,400,190.00 29,716,254.40 59,896,889.00 503,301.00 0.8% Certificated Pupil Support Salaries 1200 3,092,400.00 3,204,781.00 1,727,463.31 3,204,781.00 0.00 0.0% Certificated Supervisors' and Administrators' Salaries 1300 5,972,306.00 5,973,206.00 3,194,131.19 5,973,206.00 0.00 0.0% Other Certificated Salaries 1900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CERTIFICATED SALARIES 68,682,850.00 69,578,177.00 34,637,848.90 69,074,876.00 503,301.00 0.7% CLASSIFIED SALARIES Classified Instructional Salaries 2100 8,050,541.00 8,323,440.00 4,908,612.70 8,316,439.00 7,001.00 0.1% Classified Support Salaries 2200 4,845,260.00 4,874,156.00 2,823,264.86 4,874,306.00 (150.00) 0.0% Classified Supervisors' and Administrators' Salaries 2300 863,093.00 894,093.00 520,610.18 894,093.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 4,736,192.00 4,750,355.00 2,730,650.11 4,751,633.00 (1,278.00) 0.0% Other Classified Salaries 2900 3,740,955.00 3,807,930.00 2,579,882.92 3,807,930.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 22,236,041.00 22,649,974.00 13,563,020.77 22,644,401.00 5,573.00 0.0% EMPLOYEE BENEFITS STRS 3101-3102 10,725,794.00 10,876,862.00 5,575,952.01 10,765,209.00 111,653.00 1.0% PERS 3201-3202 3,695,302.00 3,539,970.00 1,824,725.76 3,539,970.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 2,358,751.00 2,433,272.00 1,350,152.00 2,424,298.00 8,974.00 0.4% Health and Welfare Benefits 3401-3402 8,531,562.00 9,266,530.00 4,853,318.47 9,266,530.00 0.00 0.0% Unemployment Insurance 3501-3502 44,931.00 45,858.00 23,953.47 45,544.00 314.00 0.7% Workers' Compensation 3601-3602 1,572,399.00 1,592,297.00 774,340.60 1,582,140.00 10,157.00 0.6% OPEB, Allocated 3701-3702 384,800.00 456,000.00 241,934.19 456,000.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 1,579,246.00 1,476,964.00 1,017,639.20 1,476,964.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 28,892,785.00 29,687,753.00 15,662,015.70 29,556,655.00 131,098.00 0.4% BOOKS AND SUPPLIES Approved Textbooks and Core Curricula Materials 4100 471,100.00 1,745,840.00 44,640.68 1,745,840.00 0.00 0.0% Books and Other Reference Materials 4200 297,931.00 294,214.00 118,366.46 293,825.00 389.00 0.1% Materials and Supplies 4300 4,342,688.00 5,453,865.00 1,901,368.82 5,407,565.00 46,300.00 0.8% Noncapitalized Equipment 4400 398,956.00 411,088.00 100,240.01 441,670.00 (30,582.00) -7.4% Food 4700 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, BOOKS AND SUPPLIES 5,510,675.00 7,905,007.00 2,164,615.97 7,888,900.00 16,107.00 0.2% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 4,808,264.00 4,972,045.00 2,461,690.75 4,971,045.00 1,000.00 0.0% Travel and Conferences 5200 336,783.00 449,532.00 247,198.61 454,585.00 (5,053.00) -1.1% Dues and Memberships 5300 44,256.00 67,891.00 52,768.02 67,891.00 0.00 0.0% Insurance 5400-5450 721,500.00 773,733.00 729,261.93 773,733.00 0.00 0.0% Operations and Housekeeping Services 5500 3,118,727.00 2,801,877.00 1,163,160.73 2,801,877.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 2,129,703.00 2,952,121.00 1,555,619.41 2,941,949.00 10,172.00 0.3% Transfers of Direct Costs 5710 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 (153,679.00) (152,159.00) 8,157.36 (152,159.00) 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 5,431,687.00 5,717,971.00 2,907,934.49 5,719,490.00 (1,519.00) 0.0% Communications 5900 320,432.00 334,637.00 211,923.24 334,637.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 16,757,673.00 17,917,648.00 9,337,714.54 17,913,048.00 4,600.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 6 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 0.00 0.00 0.00 0.00 0.0% Land Improvements 6170 0.00 0.00 0.00 0.00 0.00 0.0% Buildings and Improvements of Buildings 6200 1,057,734.00 1,242,774.00 235,324.55 1,242,774.00 0.00 0.0% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 6,742.00 10,135.00 6,043.36 10,135.00 0.00 0.0% Equipment Replacement 6500 75,000.00 93,567.00 85,037.13 93,567.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 1,139,476.00 1,346,476.00 326,405.04 1,346,476.00 0.00 0.0% OTHER OUTGO (excluding Transfers of Indirect Costs) Tuition Tuition for Instruction Under Interdistrict Attendance Agreements 7110 0.00 0.00 0.00 0.00 0.00 0.0% State Special Schools 7130 0.00 0.00 0.00 0.00 0.00 0.0% Tuition, Excess Costs, and/or Deficit Payments Payments to Districts or Charter Schools 7141 0.00 0.00 0.00 0.00 0.00 0.0% Payments to County Offices 7142 475,000.00 475,000.00 26,152.50 475,000.00 0.00 0.0% Payments to JPAs 7143 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Pass-Through Revenues To Districts or Charter Schools 7211 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 7212 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 7213 0.00 0.00 0.00 0.00 0.00 0.0% Special Education SELPA Transfers of Apportionments To Districts or Charter Schools 6500 7221 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 6500 7222 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 6500 7223 0.00 0.00 0.00 0.00 0.00 0.0% ROC/P Transfers of Apportionments To Districts or Charter Schools 6360 7221 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 6360 7222 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 6360 7223 0.00 0.00 0.00 0.00 0.00 0.0% Other Transfers of Apportionments All Other 7221-7223 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers 7281-7283 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 475,000.00 475,000.00 26,152.50 475,000.00 0.00 0.0% OTHER OUTGO - TRANSFERS OF INDIRECT COSTS Transfers of Indirect Costs 7310 0.00 0.00 0.00 0.00 Transfers of Indirect Costs - Interfund 7350 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO - TRANSFERS OF INDIRECT COSTS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EXPENDITURES 143,694,500.00 149,560,035.00 75,717,773.42 148,899,356.00 660,679.00 0.4% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 7 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Summary - Unrestricted/Restricted Form 01I Revenues, Expenditures, and Changes in Fund Balance Board Approved Projected Year Difference % Diff Object Original Budget Operating Budget Actuals To Date Totals (Col B & D) (E/B) Description Resource Codes Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN From: Special Reserve Fund 8912 0.00 0.00 0.00 0.00 0.00 0.0% From: Bond Interest and Redemption Fund 8914 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers In 8919 2,595,129.00 2,656,000.00 0.00 2,656,000.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 2,595,129.00 2,656,000.00 0.00 2,656,000.00 0.00 0.0% INTERFUND TRANSFERS OUT To: Child Development Fund 7611 0.00 0.00 0.00 0.00 0.00 0.0% To: Special Reserve Fund 7612 0.00 0.00 0.00 0.00 0.00 0.0% To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% To: Cafeteria Fund 7616 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 2,855,901.00 3,705,885.00 0.00 3,705,885.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 2,855,901.00 3,705,885.00 0.00 3,705,885.00 0.00 0.0% OTHER SOURCES/USES SOURCES State Apportionments Emergency Apportionments 8931 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds Proceeds from Sale/Lease- Purchase of Land/Buildings 8953 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) (260,772.00) (1,049,885.00) 0.00 (1,049,885.00) 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 06/07/2018) Page 8 Printed: 2/12/2019 3:07 PM
Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 01I 2018-19 Resource Description Projected Year Totals 3386 Special Ed: IDEA Quality Assurance & Focus 0.92 5640 Medi-Cal Billing Option 577,502.46 6230 California Clean Energy Jobs Act 234,346.30 6300 Lottery: Instructional Materials 1.34 6500 Special Education 122,412.00 7510 Low-Performing Students Block Grant 686,585.00 8150 Ongoing & Major Maintenance Account (RMA 0.85 Total, Restricted Balance 1,620,848.87 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-a (Rev 04/24/2012) Page 1 Printed: 2/12/2019 3:07 PM
2018-19 Second Interim Etiwanda Elementary Cafeteria Special Revenue Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 13I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 2,200,000.00 2,200,000.00 496,105.67 2,200,000.00 0.00 0.0% 3) Other State Revenue 8300-8599 145,000.00 145,000.00 34,979.40 145,000.00 0.00 0.0% 4) Other Local Revenue 8600-8799 1,592,000.00 1,592,015.75 920,323.77 1,592,015.75 0.00 0.0% 5) TOTAL, REVENUES 3,937,000.00 3,937,015.75 1,451,408.84 3,937,015.75 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 1,360,344.00 1,365,344.00 795,996.45 1,365,344.00 0.00 0.0% 3) Employee Benefits 3000-3999 392,495.00 392,495.00 236,153.25 392,495.00 0.00 0.0% 4) Books and Supplies 4000-4999 2,235,700.00 2,235,417.00 1,229,660.64 2,235,317.00 100.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 139,629.00 159,392.00 45,621.38 159,492.00 (100.00) -0.1% 6) Capital Outlay 6000-6999 95,000.00 69,000.00 0.00 69,000.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 4,223,168.00 4,221,648.00 2,307,431.72 4,221,648.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) (286,168.00) (284,632.25) (856,022.88) (284,632.25) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 0.00 0.00 0.00 0.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 1 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Cafeteria Special Revenue Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 13I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) (286,168.00) (284,632.25) (856,022.88) (284,632.25) F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 1,154,784.98 1,705,916.27 1,705,916.27 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 1,154,784.98 1,705,916.27 1,705,916.27 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 1,154,784.98 1,705,916.27 1,705,916.27 2) Ending Balance, June 30 (E + F1e) 868,616.98 1,421,284.02 1,421,284.02 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 70,000.00 70,000.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Restricted 9740 868,616.98 1,351,284.02 1,351,284.02 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Committments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 2 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Cafeteria Special Revenue Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 13I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) FEDERAL REVENUE Child Nutrition Programs 8220 2,200,000.00 2,200,000.00 496,105.67 2,200,000.00 0.00 0.0% Donated Food Commodities 8221 0.00 0.00 0.00 0.00 0.00 0.0% All Other Federal Revenue 8290 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, FEDERAL REVENUE 2,200,000.00 2,200,000.00 496,105.67 2,200,000.00 0.00 0.0% OTHER STATE REVENUE Child Nutrition Programs 8520 145,000.00 145,000.00 34,979.40 145,000.00 0.00 0.0% All Other State Revenue 8590 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 145,000.00 145,000.00 34,979.40 145,000.00 0.00 0.0% OTHER LOCAL REVENUE Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Food Service Sales 8634 1,582,000.00 1,582,000.00 904,980.52 1,582,000.00 0.00 0.0% Leases and Rentals 8650 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 10,000.00 10,000.00 15,327.50 10,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Fees and Contracts Interagency Services 8677 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 15.75 15.75 15.75 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 1,592,000.00 1,592,015.75 920,323.77 1,592,015.75 0.00 0.0% TOTAL, REVENUES 3,937,000.00 3,937,015.75 1,451,408.84 3,937,015.75 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 3 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Cafeteria Special Revenue Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 13I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CERTIFICATED SALARIES Certificated Supervisors' and Administrators' Salaries 1300 0.00 0.00 0.00 0.00 0.00 0.0% Other Certificated Salaries 1900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CERTIFICATED SALARIES 0.00 0.00 0.00 0.00 0.00 0.0% CLASSIFIED SALARIES Classified Support Salaries 2200 1,146,318.00 1,151,318.00 671,883.43 1,151,318.00 0.00 0.0% Classified Supervisors' and Administrators' Salaries 2300 84,906.00 84,906.00 49,504.00 84,906.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 129,120.00 129,120.00 74,609.02 129,120.00 0.00 0.0% Other Classified Salaries 2900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 1,360,344.00 1,365,344.00 795,996.45 1,365,344.00 0.00 0.0% EMPLOYEE BENEFITS STRS 3101-3102 0.00 0.00 0.00 0.00 0.00 0.0% PERS 3201-3202 161,737.00 161,737.00 80,671.81 161,737.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 68,790.00 68,790.00 42,734.28 68,790.00 0.00 0.0% Health and Welfare Benefits 3401-3402 98,176.00 98,176.00 59,051.58 98,176.00 0.00 0.0% Unemployment Insurance 3501-3502 634.00 634.00 396.49 634.00 0.00 0.0% Workers' Compensation 3601-3602 22,528.00 22,528.00 12,669.48 22,528.00 0.00 0.0% OPEB, Allocated 3701-3702 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 40,630.00 40,630.00 40,629.61 40,630.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 392,495.00 392,495.00 236,153.25 392,495.00 0.00 0.0% BOOKS AND SUPPLIES Books and Other Reference Materials 4200 0.00 0.00 0.00 0.00 0.00 0.0% Materials and Supplies 4300 239,900.00 243,100.00 143,115.69 243,100.00 0.00 0.0% Noncapitalized Equipment 4400 95,800.00 95,800.00 8,842.20 95,800.00 0.00 0.0% Food 4700 1,900,000.00 1,896,517.00 1,077,702.75 1,896,417.00 100.00 0.0% TOTAL, BOOKS AND SUPPLIES 2,235,700.00 2,235,417.00 1,229,660.64 2,235,317.00 100.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 4 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Cafeteria Special Revenue Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 13I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 0.00 0.00 0.00 0.00 0.00 0.0% Travel and Conferences 5200 9,400.00 9,400.00 3,129.18 9,400.00 0.00 0.0% Dues and Memberships 5300 1,500.00 1,610.00 1,484.80 1,710.00 (100.00) -6.2% Insurance 5400-5450 0.00 0.00 0.00 0.00 0.00 0.0% Operations and Housekeeping Services 5500 0.00 0.00 0.00 0.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 32,800.00 32,800.00 11,317.05 32,800.00 0.00 0.0% Transfers of Direct Costs 5710 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 (12,921.00) (14,441.00) (8,157.36) (14,441.00) 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 95,850.00 117,023.00 36,002.65 117,023.00 0.00 0.0% Communications 5900 13,000.00 13,000.00 1,845.06 13,000.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 139,629.00 159,392.00 45,621.38 159,492.00 (100.00) -0.1% CAPITAL OUTLAY Buildings and Improvements of Buildings 6200 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 0.00 0.00 0.00 0.00 0.00 0.0% Equipment Replacement 6500 95,000.00 69,000.00 0.00 69,000.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 95,000.00 69,000.00 0.00 69,000.00 0.00 0.0% OTHER OUTGO (excluding Transfers of Indirect Costs) Debt Service Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 0.00 0.00 0.00 0.00 0.00 0.0% OTHER OUTGO - TRANSFERS OF INDIRECT COSTS Transfers of Indirect Costs - Interfund 7350 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO - TRANSFERS OF INDIRECT COSTS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EXPENDITURES 4,223,168.00 4,221,648.00 2,307,431.72 4,221,648.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 5 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Cafeteria Special Revenue Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 13I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN From: General Fund 8916 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT Other Authorized Interfund Transfers Out 7619 0.00 0.00 0.00 0.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 0.0% OTHER SOURCES/USES SOURCES Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 6 Printed: 2/12/2019 3:08 PM
Second Interim Etiwanda Elementary Cafeteria Special Revenue Fund 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 13I 2018/19 Resource Description Projected Year Totals 5310 Child Nutrition: School Programs (e.g., School Lunch, School 1,351,284.02 Total, Restricted Balance 1,351,284.02 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 04/30/2012) Page 1 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Other Than Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 17I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 99,000.00 99,000.00 88,418.33 99,000.00 0.00 0.0% 5) TOTAL, REVENUES 99,000.00 99,000.00 88,418.33 99,000.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 0.00 0.00 0.00 0.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 0.00 0.00 0.00 0.00 0.00 0.0% 6) Capital Outlay 6000-6999 0.00 0.00 0.00 0.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 0.00 0.00 0.00 0.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) 99,000.00 99,000.00 88,418.33 99,000.00 D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 0.00 0.00 0.00 0.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 1 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Other Than Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 17I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 99,000.00 99,000.00 88,418.33 99,000.00 F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 9,355,037.62 9,391,733.35 9,391,733.35 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 9,355,037.62 9,391,733.35 9,391,733.35 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 9,355,037.62 9,391,733.35 9,391,733.35 2) Ending Balance, June 30 (E + F1e) 9,454,037.62 9,490,733.35 9,490,733.35 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Restricted 9740 0.00 0.00 0.00 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Committments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 9,454,037.62 9,490,733.35 9,490,733.35 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 2 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Other Than Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 17I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) OTHER LOCAL REVENUE Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 99,000.00 99,000.00 88,418.33 99,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 99,000.00 99,000.00 88,418.33 99,000.00 0.00 0.0% TOTAL, REVENUES 99,000.00 99,000.00 88,418.33 99,000.00 INTERFUND TRANSFERS INTERFUND TRANSFERS IN From: General Fund/CSSF 8912 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT To: General Fund/CSSF 7612 0.00 0.00 0.00 0.00 0.00 0.0% To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 0.00 0.00 0.00 0.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 0.0% OTHER SOURCES/USES SOURCES Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 3 Printed: 2/12/2019 3:08 PM
Second Interim Etiwanda Elementary Special Reserve Fund for Other Than Capital Outlay Projects 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 17I 2018/19 Resource Description Projected Year Totals Total, Restricted Balance 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 04/30/2012) Page 1 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Postemployment Benefits 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 20I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 105,000.00 105,000.00 92,631.96 105,000.00 0.00 0.0% 5) TOTAL, REVENUES 105,000.00 105,000.00 92,631.96 105,000.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 0.00 0.00 0.00 0.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 0.00 0.00 0.00 0.00 0.00 0.0% 6) Capital Outlay 6000-6999 0.00 0.00 0.00 0.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 0.00 0.00 0.00 0.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) 105,000.00 105,000.00 92,631.96 105,000.00 D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 617,601.00 1,467,585.00 0.00 1,467,585.00 0.00 0.0% b) Transfers Out 7600-7629 395,129.00 456,000.00 0.00 456,000.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 222,472.00 1,011,585.00 0.00 1,011,585.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 1 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Postemployment Benefits 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 20I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 327,472.00 1,116,585.00 92,631.96 1,116,585.00 F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 9,791,671.64 10,263,948.90 10,263,948.90 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 9,791,671.64 10,263,948.90 10,263,948.90 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 9,791,671.64 10,263,948.90 10,263,948.90 2) Ending Balance, June 30 (E + F1e) 10,119,143.64 11,380,533.90 11,380,533.90 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Restricted 9740 0.00 0.00 0.00 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Committments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 10,119,143.64 11,380,533.90 11,380,533.90 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 2 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Postemployment Benefits 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 20I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) OTHER LOCAL REVENUE Interest 8660 105,000.00 105,000.00 92,631.96 105,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 105,000.00 105,000.00 92,631.96 105,000.00 0.00 0.0% TOTAL, REVENUES 105,000.00 105,000.00 92,631.96 105,000.00 INTERFUND TRANSFERS INTERFUND TRANSFERS IN From: General Fund/CSSF 8912 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers In 8919 617,601.00 1,467,585.00 0.00 1,467,585.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 617,601.00 1,467,585.00 0.00 1,467,585.00 0.00 0.0% INTERFUND TRANSFERS OUT To: General Fund/CSSF 7612 0.00 0.00 0.00 0.00 0.00 0.0% To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 395,129.00 456,000.00 0.00 456,000.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 395,129.00 456,000.00 0.00 456,000.00 0.00 0.0% OTHER SOURCES/USES SOURCES Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 222,472.00 1,011,585.00 0.00 1,011,585.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 05/17/2018) Page 3 Printed: 2/12/2019 3:08 PM
Second Interim Etiwanda Elementary Special Reserve Fund for Postemployment Benefits 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 20I 2018/19 Resource Description Projected Year Totals Total, Restricted Balance 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-b (Rev 04/30/2012) Page 1 Printed: 2/12/2019 3:08 PM
2018-19 Second Interim Etiwanda Elementary Building Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 21I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 291,750.00 291,750.00 322,356.44 291,750.00 0.00 0.0% 5) TOTAL, REVENUES 291,750.00 291,750.00 322,356.44 291,750.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 1,238,256.00 1,764,493.00 992,536.46 1,989,828.00 (225,335.00) -12.8% 5) Services and Other Operating Expenditures 5000-5999 710,755.00 1,548,036.00 1,166,470.42 1,758,134.00 (210,098.00) -13.6% 6) Capital Outlay 6000-6999 26,673,790.00 31,542,351.00 9,987,142.16 31,114,170.00 428,181.00 1.4% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 28,622,801.00 34,854,880.00 12,146,149.04 34,862,132.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) (28,331,051.00) (34,563,130.00) (11,823,792.60) (34,570,382.00) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 0.00 0.00 0.00 0.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 1 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Building Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 21I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) (28,331,051.00) (34,563,130.00) (11,823,792.60) (34,570,382.00) F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 37,056,880.62 34,722,440.98 34,722,440.98 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 37,056,880.62 34,722,440.98 34,722,440.98 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 37,056,880.62 34,722,440.98 34,722,440.98 2) Ending Balance, June 30 (E + F1e) 8,725,829.62 159,310.98 152,058.98 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Legally Restricted Balance 9740 0.00 0.00 0.00 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 8,725,829.62 159,310.98 152,058.98 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 2 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Building Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 21I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) FEDERAL REVENUE FEMA 8281 0.00 0.00 0.00 0.00 0.00 0.0% All Other Federal Revenue 8290 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, FEDERAL REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER STATE REVENUE Tax Relief Subventions Restricted Levies - Other Homeowners' Exemptions 8575 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8576 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Revenue 8590 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER LOCAL REVENUE County and District Taxes Other Restricted Levies Secured Roll 8615 0.00 0.00 0.00 0.00 0.00 0.0% Unsecured Roll 8616 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years' Taxes 8617 0.00 0.00 0.00 0.00 0.00 0.0% Supplemental Taxes 8618 0.00 0.00 0.00 0.00 0.00 0.0% Non-Ad Valorem Taxes Parcel Taxes 8621 0.00 0.00 0.00 0.00 0.00 0.0% Other 8622 0.00 0.00 0.00 0.00 0.00 0.0% Community Redevelopment Funds Not Subject to LCFF Deduction 8625 0.00 0.00 0.00 0.00 0.00 0.0% Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 0.00 0.00 0.00 0.00 0.0% Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Leases and Rentals 8650 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 291,750.00 291,750.00 322,356.44 291,750.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 291,750.00 291,750.00 322,356.44 291,750.00 0.00 0.0% TOTAL, REVENUES 291,750.00 291,750.00 322,356.44 291,750.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 3 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Building Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 21I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CLASSIFIED SALARIES Classified Support Salaries 2200 0.00 0.00 0.00 0.00 0.00 0.0% Classified Supervisors' and Administrators' Salaries 2300 0.00 0.00 0.00 0.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 0.00 0.00 0.00 0.00 0.00 0.0% Other Classified Salaries 2900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 0.00 0.00 0.00 0.00 0.00 0.0% EMPLOYEE BENEFITS STRS 3101-3102 0.00 0.00 0.00 0.00 0.00 0.0% PERS 3201-3202 0.00 0.00 0.00 0.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 0.00 0.00 0.00 0.00 0.00 0.0% Health and Welfare Benefits 3401-3402 0.00 0.00 0.00 0.00 0.00 0.0% Unemployment Insurance 3501-3502 0.00 0.00 0.00 0.00 0.00 0.0% Workers' Compensation 3601-3602 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Allocated 3701-3702 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 0.00 0.00 0.00 0.00 0.00 0.0% BOOKS AND SUPPLIES Books and Other Reference Materials 4200 0.00 0.00 0.00 0.00 0.00 0.0% Materials and Supplies 4300 271,520.00 355,061.00 36,466.30 355,061.00 0.00 0.0% Noncapitalized Equipment 4400 966,736.00 1,409,432.00 956,070.16 1,634,767.00 (225,335.00) -16.0% TOTAL, BOOKS AND SUPPLIES 1,238,256.00 1,764,493.00 992,536.46 1,989,828.00 (225,335.00) -12.8% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 0.00 0.00 0.00 0.00 0.00 0.0% Travel and Conferences 5200 0.00 0.00 0.00 0.00 0.00 0.0% Insurance 5400-5450 0.00 0.00 0.00 0.00 0.00 0.0% Operations and Housekeeping Services 5500 0.00 0.00 0.00 0.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 0.00 537,405.00 517,982.30 537,405.00 0.00 0.0% Transfers of Direct Costs 5710 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 0.00 0.00 0.00 0.00 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 710,755.00 1,010,631.00 648,488.12 1,220,729.00 (210,098.00) -20.8% Communications 5900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 710,755.00 1,548,036.00 1,166,470.42 1,758,134.00 (210,098.00) -13.6% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 4 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Building Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 21I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 358,950.00 290,375.45 358,950.00 0.00 0.0% Land Improvements 6170 583,431.00 409,442.00 88,165.50 409,442.00 0.00 0.0% Buildings and Improvements of Buildings 6200 25,940,359.00 29,907,036.00 9,123,548.13 29,478,855.00 428,181.00 1.4% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 0.00 51,750.00 0.00 51,750.00 0.00 0.0% Equipment Replacement 6500 150,000.00 815,173.00 485,053.08 815,173.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 26,673,790.00 31,542,351.00 9,987,142.16 31,114,170.00 428,181.00 1.4% OTHER OUTGO (excluding Transfers of Indirect Costs) Other Transfers Out All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Repayment of State School Building Fund Aid - Proceeds from Bonds 7435 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EXPENDITURES 28,622,801.00 34,854,880.00 12,146,149.04 34,862,132.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 5 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Building Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 21I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 0.00 0.00 0.00 0.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 0.0% OTHER SOURCES/USES SOURCES Proceeds Proceeds from Sale of Bonds 8951 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Sale/Lease- Purchase of Land/Buildings 8953 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources County School Building Aid 8961 0.00 0.00 0.00 0.00 0.00 0.0% Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 6 Printed: 2/12/2019 3:09 PM
Second Interim Etiwanda Elementary Building Fund 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 21I 2018/19 Resource Description Projected Year Totals Total, Restricted Balance 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/18/2012) Page 1 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Capital Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 25I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 775,000.00 1,725,000.00 1,893,864.73 1,725,000.00 0.00 0.0% 5) TOTAL, REVENUES 775,000.00 1,725,000.00 1,893,864.73 1,725,000.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 0.00 0.00 0.00 0.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 75,800.00 114,099.00 47,551.11 114,099.00 0.00 0.0% 6) Capital Outlay 6000-6999 0.00 251.00 0.00 251.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 75,800.00 114,350.00 47,551.11 114,350.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) 699,200.00 1,610,650.00 1,846,313.62 1,610,650.00 D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 0.00 0.00 0.00 0.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 1 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Capital Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 25I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 699,200.00 1,610,650.00 1,846,313.62 1,610,650.00 F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 4,714,144.70 4,374,996.35 4,374,996.35 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 4,714,144.70 4,374,996.35 4,374,996.35 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 4,714,144.70 4,374,996.35 4,374,996.35 2) Ending Balance, June 30 (E + F1e) 5,413,344.70 5,985,646.35 5,985,646.35 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Legally Restricted Balance 9740 5,413,344.70 5,985,646.35 5,985,646.35 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 2 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Capital Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 25I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) OTHER STATE REVENUE Tax Relief Subventions Restricted Levies - Other Homeowners' Exemptions 8575 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8576 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Revenue 8590 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER LOCAL REVENUE County and District Taxes Other Restricted Levies Secured Roll 8615 0.00 0.00 0.00 0.00 0.00 0.0% Unsecured Roll 8616 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years' Taxes 8617 0.00 0.00 0.00 0.00 0.00 0.0% Supplemental Taxes 8618 0.00 0.00 0.00 0.00 0.00 0.0% Non-Ad Valorem Taxes Parcel Taxes 8621 0.00 0.00 0.00 0.00 0.00 0.0% Other 8622 0.00 0.00 0.00 0.00 0.00 0.0% Community Redevelopment Funds Not Subject to LCFF Deduction 8625 0.00 0.00 0.00 0.00 0.00 0.0% Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 0.00 0.00 0.00 0.00 0.0% Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 25,000.00 25,000.00 46,260.41 25,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Fees and Contracts Mitigation/Developer Fees 8681 750,000.00 1,700,000.00 1,847,604.32 1,700,000.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 775,000.00 1,725,000.00 1,893,864.73 1,725,000.00 0.00 0.0% TOTAL, REVENUES 775,000.00 1,725,000.00 1,893,864.73 1,725,000.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 3 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Capital Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 25I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CERTIFICATED SALARIES Other Certificated Salaries 1900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CERTIFICATED SALARIES 0.00 0.00 0.00 0.00 0.00 0.0% CLASSIFIED SALARIES Classified Support Salaries 2200 0.00 0.00 0.00 0.00 0.00 0.0% Classified Supervisors' and Administrators' Salaries 2300 0.00 0.00 0.00 0.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 0.00 0.00 0.00 0.00 0.00 0.0% Other Classified Salaries 2900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 0.00 0.00 0.00 0.00 0.00 0.0% EMPLOYEE BENEFITS STRS 3101-3102 0.00 0.00 0.00 0.00 0.00 0.0% PERS 3201-3202 0.00 0.00 0.00 0.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 0.00 0.00 0.00 0.00 0.00 0.0% Health and Welfare Benefits 3401-3402 0.00 0.00 0.00 0.00 0.00 0.0% Unemployment Insurance 3501-3502 0.00 0.00 0.00 0.00 0.00 0.0% Workers' Compensation 3601-3602 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Allocated 3701-3702 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 0.00 0.00 0.00 0.00 0.00 0.0% BOOKS AND SUPPLIES Approved Textbooks and Core Curricula Materials 4100 0.00 0.00 0.00 0.00 0.00 0.0% Books and Other Reference Materials 4200 0.00 0.00 0.00 0.00 0.00 0.0% Materials and Supplies 4300 0.00 0.00 0.00 0.00 0.00 0.0% Noncapitalized Equipment 4400 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, BOOKS AND SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.0% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 0.00 0.00 0.00 0.00 0.00 0.0% Travel and Conferences 5200 0.00 0.00 0.00 0.00 0.00 0.0% Insurance 5400-5450 0.00 0.00 0.00 0.00 0.00 0.0% Operations and Housekeeping Services 5500 0.00 0.00 0.00 0.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 0.00 13,658.00 13,657.79 13,658.00 0.00 0.0% Transfers of Direct Costs 5710 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 35,000.00 35,000.00 0.00 35,000.00 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 40,800.00 65,441.00 33,893.32 65,441.00 0.00 0.0% Communications 5900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 75,800.00 114,099.00 47,551.11 114,099.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 4 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Capital Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 25I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 0.00 0.00 0.00 0.00 0.0% Land Improvements 6170 0.00 0.00 0.00 0.00 0.00 0.0% Buildings and Improvements of Buildings 6200 0.00 251.00 0.00 251.00 0.00 0.0% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 0.00 0.00 0.00 0.00 0.00 0.0% Equipment Replacement 6500 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 0.00 251.00 0.00 251.00 0.00 0.0% OTHER OUTGO (excluding Transfers of Indirect Costs) Other Transfers Out All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EXPENDITURES 75,800.00 114,350.00 47,551.11 114,350.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 5 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Capital Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 25I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 0.00 0.00 0.00 0.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 0.0% OTHER SOURCES/USES SOURCES Proceeds Proceeds from Sale/Lease- Purchase of Land/Buildings 8953 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 6 Printed: 2/12/2019 3:09 PM
Second Interim Etiwanda Elementary Capital Facilities Fund 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 25I 2018/19 Resource Description Projected Year Totals 9010 Other Restricted Local 5,985,646.35 Total, Restricted Balance 5,985,646.35 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/18/2012) Page 1 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary County School Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 35I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 15,000.00 15,000.00 35,126.14 15,000.00 0.00 0.0% 5) TOTAL, REVENUES 15,000.00 15,000.00 35,126.14 15,000.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 2,100.00 2,100.00 0.00 2,100.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 79,200.00 79,200.00 0.00 79,200.00 0.00 0.0% 6) Capital Outlay 6000-6999 41,800.00 41,800.00 0.00 41,800.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 123,100.00 123,100.00 0.00 123,100.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) (108,100.00) (108,100.00) 35,126.14 (108,100.00) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 0.00 0.00 0.00 0.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 1 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary County School Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 35I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) (108,100.00) (108,100.00) 35,126.14 (108,100.00) F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 3,732,634.01 3,686,623.88 3,686,623.88 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 3,732,634.01 3,686,623.88 3,686,623.88 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 3,732,634.01 3,686,623.88 3,686,623.88 2) Ending Balance, June 30 (E + F1e) 3,624,534.01 3,578,523.88 3,578,523.88 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Legally Restricted Balance 9740 3,624,534.01 3,578,523.88 3,578,523.88 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 2 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary County School Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 35I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) FEDERAL REVENUE All Other Federal Revenue 8290 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, FEDERAL REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER STATE REVENUE School Facilities Apportionments 8545 0.00 0.00 0.00 0.00 0.00 0.0% Pass-Through Revenues from State Sources 8587 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Revenue 8590 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER LOCAL REVENUE Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Leases and Rentals 8650 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 15,000.00 15,000.00 35,126.14 15,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 15,000.00 15,000.00 35,126.14 15,000.00 0.00 0.0% TOTAL, REVENUES 15,000.00 15,000.00 35,126.14 15,000.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 3 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary County School Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 35I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CLASSIFIED SALARIES Classified Support Salaries 2200 0.00 0.00 0.00 0.00 0.00 0.0% Classified Supervisors' and Administrators' Salaries 2300 0.00 0.00 0.00 0.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 0.00 0.00 0.00 0.00 0.00 0.0% Other Classified Salaries 2900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 0.00 0.00 0.00 0.00 0.00 0.0% EMPLOYEE BENEFITS STRS 3101-3102 0.00 0.00 0.00 0.00 0.00 0.0% PERS 3201-3202 0.00 0.00 0.00 0.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 0.00 0.00 0.00 0.00 0.00 0.0% Health and Welfare Benefits 3401-3402 0.00 0.00 0.00 0.00 0.00 0.0% Unemployment Insurance 3501-3502 0.00 0.00 0.00 0.00 0.00 0.0% Workers' Compensation 3601-3602 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Allocated 3701-3702 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 0.00 0.00 0.00 0.00 0.00 0.0% BOOKS AND SUPPLIES Books and Other Reference Materials 4200 0.00 0.00 0.00 0.00 0.00 0.0% Materials and Supplies 4300 2,100.00 2,100.00 0.00 2,100.00 0.00 0.0% Noncapitalized Equipment 4400 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, BOOKS AND SUPPLIES 2,100.00 2,100.00 0.00 2,100.00 0.00 0.0% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 0.00 0.00 0.00 0.00 0.00 0.0% Travel and Conferences 5200 0.00 0.00 0.00 0.00 0.00 0.0% Insurance 5400-5450 0.00 0.00 0.00 0.00 0.00 0.0% Operations and Housekeeping Services 5500 0.00 0.00 0.00 0.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs 5710 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 0.00 0.00 0.00 0.00 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 79,200.00 79,200.00 0.00 79,200.00 0.00 0.0% Communications 5900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 79,200.00 79,200.00 0.00 79,200.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 4 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary County School Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 35I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 0.00 0.00 0.00 0.00 0.0% Land Improvements 6170 0.00 0.00 0.00 0.00 0.00 0.0% Buildings and Improvements of Buildings 6200 41,800.00 41,800.00 0.00 41,800.00 0.00 0.0% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 0.00 0.00 0.00 0.00 0.00 0.0% Equipment Replacement 6500 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 41,800.00 41,800.00 0.00 41,800.00 0.00 0.0% OTHER OUTGO (excluding Transfers of Indirect Costs) Other Transfers Out Transfers of Pass-Through Revenues To Districts or Charter Schools 7211 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 7212 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 7213 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EXPENDITURES 123,100.00 123,100.00 0.00 123,100.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 5 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary County School Facilities Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 35I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN To: State School Building Fund/ County School Facilities Fund From: All Other Funds 8913 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 0.00 0.00 0.00 0.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 0.0% OTHER SOURCES/USES SOURCES Proceeds Proceeds from Sale/Lease- Purchase of Land/Buildings 8953 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 6 Printed: 2/12/2019 3:09 PM
Second Interim Etiwanda Elementary County School Facilities Fund 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 35I 2018/19 Resource Description Projected Year Totals 7710 State School Facilities Projects 3,578,523.88 Total, Restricted Balance 3,578,523.88 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/18/2012) Page 1 Printed: 2/12/2019 3:09 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 40I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 200,000.00 200,000.00 275,641.09 200,000.00 0.00 0.0% 5) TOTAL, REVENUES 200,000.00 200,000.00 275,641.09 200,000.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 2,435,678.00 3,525,361.00 1,218,810.16 3,525,361.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 0.00 8,145.00 2,840.41 8,145.00 0.00 0.0% 6) Capital Outlay 6000-6999 218,658.00 2,291,677.00 852,161.11 2,256,087.00 35,590.00 1.6% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 2,654,336.00 5,825,183.00 2,073,811.68 5,789,593.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) (2,454,336.00) (5,625,183.00) (1,798,170.59) (5,589,593.00) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 2,238,300.00 2,238,300.00 0.00 2,238,300.00 0.00 0.0% b) Transfers Out 7600-7629 2,200,000.00 2,200,000.00 0.00 2,200,000.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 38,300.00 38,300.00 0.00 38,300.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 1 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 40I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) (2,416,036.00) (5,586,883.00) (1,798,170.59) (5,551,293.00) F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 28,456,715.54 31,472,910.81 31,472,910.81 0.00 0.0% b) Audit Adjustments 9793 0.00 797,792.80 797,792.80 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 28,456,715.54 32,270,703.61 32,270,703.61 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 28,456,715.54 32,270,703.61 32,270,703.61 2) Ending Balance, June 30 (E + F1e) 26,040,679.54 26,683,820.61 26,719,410.61 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Legally Restricted Balance 9740 26,040,679.54 26,683,820.61 26,719,410.61 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 2 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 40I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) FEDERAL REVENUE FEMA 8281 0.00 0.00 0.00 0.00 0.00 0.0% All Other Federal Revenue 8290 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, FEDERAL REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER STATE REVENUE Pass-Through Revenues from State Sources 8587 0.00 0.00 0.00 0.00 0.00 0.0% California Clean Energy Jobs Act 6230 8590 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Revenue All Other 8590 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER LOCAL REVENUE Other Local Revenue Community Redevelopment Funds Not Subject to LCFF Deduction 8625 0.00 0.00 0.00 0.00 0.00 0.0% Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Leases and Rentals 8650 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 200,000.00 200,000.00 275,641.09 200,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 200,000.00 200,000.00 275,641.09 200,000.00 0.00 0.0% TOTAL, REVENUES 200,000.00 200,000.00 275,641.09 200,000.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 3 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 40I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CLASSIFIED SALARIES Classified Support Salaries 2200 0.00 0.00 0.00 0.00 0.00 0.0% Classified Supervisors' and Administrators' Salaries 2300 0.00 0.00 0.00 0.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 0.00 0.00 0.00 0.00 0.00 0.0% Other Classified Salaries 2900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 0.00 0.00 0.00 0.00 0.00 0.0% EMPLOYEE BENEFITS STRS 3101-3102 0.00 0.00 0.00 0.00 0.00 0.0% PERS 3201-3202 0.00 0.00 0.00 0.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 0.00 0.00 0.00 0.00 0.00 0.0% Health and Welfare Benefits 3401-3402 0.00 0.00 0.00 0.00 0.00 0.0% Unemployment Insurance 3501-3502 0.00 0.00 0.00 0.00 0.00 0.0% Workers' Compensation 3601-3602 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Allocated 3701-3702 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 0.00 0.00 0.00 0.00 0.00 0.0% BOOKS AND SUPPLIES Books and Other Reference Materials 4200 0.00 0.00 0.00 0.00 0.00 0.0% Materials and Supplies 4300 1,708,488.00 2,719,169.00 1,101,792.86 2,719,169.00 0.00 0.0% Noncapitalized Equipment 4400 727,190.00 806,192.00 117,017.30 806,192.00 0.00 0.0% TOTAL, BOOKS AND SUPPLIES 2,435,678.00 3,525,361.00 1,218,810.16 3,525,361.00 0.00 0.0% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 0.00 0.00 0.00 0.00 0.00 0.0% Travel and Conferences 5200 0.00 0.00 0.00 0.00 0.00 0.0% Insurance 5400-5450 0.00 0.00 0.00 0.00 0.00 0.0% Operations and Housekeeping Services 5500 0.00 0.00 0.00 0.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 0.00 5,680.00 375.41 5,680.00 0.00 0.0% Transfers of Direct Costs 5710 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 0.00 0.00 0.00 0.00 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 0.00 2,465.00 2,465.00 2,465.00 0.00 0.0% Communications 5900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 0.00 8,145.00 2,840.41 8,145.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 4 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 40I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 0.00 0.00 0.00 0.00 0.0% Land Improvements 6170 0.00 32,046.00 24,300.00 32,046.00 0.00 0.0% Buildings and Improvements of Buildings 6200 218,658.00 1,461,838.00 30,068.31 1,426,248.00 35,590.00 2.4% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 0.00 0.00 0.00 0.00 0.00 0.0% Equipment Replacement 6500 0.00 797,793.00 797,792.80 797,793.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 218,658.00 2,291,677.00 852,161.11 2,256,087.00 35,590.00 1.6% OTHER OUTGO (excluding Transfers of Indirect Costs) Other Transfers Out Transfers of Pass-Through Revenues To Districts or Charter Schools 7211 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 7212 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 7213 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EXPENDITURES 2,654,336.00 5,825,183.00 2,073,811.68 5,789,593.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 5 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Special Reserve Fund for Capital Outlay Projects 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 40I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN From: General Fund/CSSF 8912 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers In 8919 2,238,300.00 2,238,300.00 0.00 2,238,300.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 2,238,300.00 2,238,300.00 0.00 2,238,300.00 0.00 0.0% INTERFUND TRANSFERS OUT To: General Fund/CSSF 7612 0.00 0.00 0.00 0.00 0.00 0.0% To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 2,200,000.00 2,200,000.00 0.00 2,200,000.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 2,200,000.00 2,200,000.00 0.00 2,200,000.00 0.00 0.0% OTHER SOURCES/USES SOURCES Proceeds Proceeds from Sale/Lease- Purchase of Land/Buildings 8953 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 38,300.00 38,300.00 0.00 38,300.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 6 Printed: 2/12/2019 3:10 PM
Second Interim Etiwanda Elementary Special Reserve Fund for Capital Outlay Projects 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 40I 2018/19 Resource Description Projected Year Totals 9010 Other Restricted Local 26,719,410.61 Total, Restricted Balance 26,719,410.61 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/18/2012) Page 1 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Capital Project Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 49I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 1,830,000.00 1,830,000.00 0.00 1,830,000.00 0.00 0.0% 5) TOTAL, REVENUES 1,830,000.00 1,830,000.00 0.00 1,830,000.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 0.00 0.00 0.00 0.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 451,600.00 451,600.00 0.00 451,600.00 0.00 0.0% 6) Capital Outlay 6000-6999 0.00 0.00 0.00 0.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 0.00 0.00 0.00 0.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 451,600.00 451,600.00 0.00 451,600.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) 1,378,400.00 1,378,400.00 0.00 1,378,400.00 D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 0.00 0.00 0.00 0.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 1 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Capital Project Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 49I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 1,378,400.00 1,378,400.00 0.00 1,378,400.00 F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 5,264,061.11 5,115,918.59 5,115,918.59 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 5,264,061.11 5,115,918.59 5,115,918.59 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 5,264,061.11 5,115,918.59 5,115,918.59 2) Ending Balance, June 30 (E + F1e) 6,642,461.11 6,494,318.59 6,494,318.59 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Legally Restricted Balance 9740 0.00 0.00 0.00 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 6,642,461.11 6,494,318.59 6,494,318.59 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 2 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Capital Project Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 49I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) FEDERAL REVENUE All Other Federal Revenue 8290 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, FEDERAL REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER STATE REVENUE Tax Relief Subventions Restricted Levies - Other Homeowners' Exemptions 8575 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8576 0.00 0.00 0.00 0.00 0.00 0.0% All Other State Revenue 8590 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER LOCAL REVENUE County and District Taxes Other Restricted Levies Secured Roll 8615 0.00 0.00 0.00 0.00 0.00 0.0% Unsecured Roll 8616 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years' Taxes 8617 0.00 0.00 0.00 0.00 0.00 0.0% Supplemental Taxes 8618 0.00 0.00 0.00 0.00 0.00 0.0% Non-Ad Valorem Taxes Parcel Taxes 8621 0.00 0.00 0.00 0.00 0.00 0.0% Other 8622 1,800,000.00 1,800,000.00 0.00 1,800,000.00 0.00 0.0% Community Redevelopment Funds Not Subject to LCFF Deduction 8625 0.00 0.00 0.00 0.00 0.00 0.0% Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 0.00 0.00 0.00 0.00 0.0% Sales Sale of Equipment/Supplies 8631 0.00 0.00 0.00 0.00 0.00 0.0% Leases and Rentals 8650 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 30,000.00 30,000.00 0.00 30,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 1,830,000.00 1,830,000.00 0.00 1,830,000.00 0.00 0.0% TOTAL, REVENUES 1,830,000.00 1,830,000.00 0.00 1,830,000.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 3 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Capital Project Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 49I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CLASSIFIED SALARIES Classified Support Salaries 2200 0.00 0.00 0.00 0.00 0.00 0.0% Classified Supervisors' and Administrators' Salaries 2300 0.00 0.00 0.00 0.00 0.00 0.0% Clerical, Technical and Office Salaries 2400 0.00 0.00 0.00 0.00 0.00 0.0% Other Classified Salaries 2900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CLASSIFIED SALARIES 0.00 0.00 0.00 0.00 0.00 0.0% EMPLOYEE BENEFITS STRS 3101-3102 0.00 0.00 0.00 0.00 0.00 0.0% PERS 3201-3202 0.00 0.00 0.00 0.00 0.00 0.0% OASDI/Medicare/Alternative 3301-3302 0.00 0.00 0.00 0.00 0.00 0.0% Health and Welfare Benefits 3401-3402 0.00 0.00 0.00 0.00 0.00 0.0% Unemployment Insurance 3501-3502 0.00 0.00 0.00 0.00 0.00 0.0% Workers' Compensation 3601-3602 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Allocated 3701-3702 0.00 0.00 0.00 0.00 0.00 0.0% OPEB, Active Employees 3751-3752 0.00 0.00 0.00 0.00 0.00 0.0% Other Employee Benefits 3901-3902 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EMPLOYEE BENEFITS 0.00 0.00 0.00 0.00 0.00 0.0% BOOKS AND SUPPLIES Books and Other Reference Materials 4200 0.00 0.00 0.00 0.00 0.00 0.0% Materials and Supplies 4300 0.00 0.00 0.00 0.00 0.00 0.0% Noncapitalized Equipment 4400 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, BOOKS AND SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.0% SERVICES AND OTHER OPERATING EXPENDITURES Subagreements for Services 5100 0.00 0.00 0.00 0.00 0.00 0.0% Travel and Conferences 5200 0.00 0.00 0.00 0.00 0.00 0.0% Insurance 5400-5450 0.00 0.00 0.00 0.00 0.00 0.0% Operations and Housekeeping Services 5500 0.00 0.00 0.00 0.00 0.00 0.0% Rentals, Leases, Repairs, and Noncapitalized Improvements 5600 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs 5710 0.00 0.00 0.00 0.00 0.00 0.0% Transfers of Direct Costs - Interfund 5750 131,600.00 131,600.00 0.00 131,600.00 0.00 0.0% Professional/Consulting Services and Operating Expenditures 5800 320,000.00 320,000.00 0.00 320,000.00 0.00 0.0% Communications 5900 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, SERVICES AND OTHER OPERATING EXPENDITURES 451,600.00 451,600.00 0.00 451,600.00 0.00 0.0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 4 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Capital Project Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 49I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) CAPITAL OUTLAY Land 6100 0.00 0.00 0.00 0.00 0.00 0.0% Land Improvements 6170 0.00 0.00 0.00 0.00 0.00 0.0% Buildings and Improvements of Buildings 6200 0.00 0.00 0.00 0.00 0.00 0.0% Books and Media for New School Libraries or Major Expansion of School Libraries 6300 0.00 0.00 0.00 0.00 0.00 0.0% Equipment 6400 0.00 0.00 0.00 0.00 0.00 0.0% Equipment Replacement 6500 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.0% OTHER OUTGO (excluding Transfers of Indirect Costs) Other Transfers Out Transfers of Pass-Through Revenues To Districts or Charter Schools 7211 0.00 0.00 0.00 0.00 0.00 0.0% To County Offices 7212 0.00 0.00 0.00 0.00 0.00 0.0% To JPAs 7213 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers Out to All Others 7299 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service Repayment of State School Building Fund Aid - Proceeds from Bonds 7435 0.00 0.00 0.00 0.00 0.00 0.0% Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, EXPENDITURES 451,600.00 451,600.00 0.00 451,600.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 5 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Capital Project Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 49I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT To: State School Building Fund/ County School Facilities Fund 7613 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 0.00 0.00 0.00 0.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 0.0% OTHER SOURCES/USES SOURCES Proceeds Proceeds from Sale of Bonds 8951 0.00 0.00 0.00 0.00 0.00 0.0% Other Sources County School Building Aid 8961 0.00 0.00 0.00 0.00 0.00 0.0% Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% Long-Term Debt Proceeds Proceeds from Certificates of Participation 8971 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Capital Leases 8972 0.00 0.00 0.00 0.00 0.00 0.0% Proceeds from Lease Revenue Bonds 8973 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 6 Printed: 2/12/2019 3:10 PM
Second Interim Etiwanda Elementary Capital Project Fund for Blended Component Units 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 49I 2018/19 Resource Description Projected Year Totals Total, Restricted Balance 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/18/2012) Page 1 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Bond Interest and Redemption Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 51I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 15,674.00 15,674.00 0.00 15,674.00 0.00 0.0% 4) Other Local Revenue 8600-8799 1,853,678.00 1,954,077.00 487,297.59 1,984,646.00 30,569.00 1.6% 5) TOTAL, REVENUES 1,869,352.00 1,969,751.00 487,297.59 2,000,320.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 0.00 0.00 0.00 0.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 0.00 0.00 0.00 0.00 0.00 0.0% 6) Capital Outlay 6000-6999 0.00 0.00 0.00 0.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 1,268,999.00 4,268,999.00 3,947,800.00 4,268,999.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 1,268,999.00 4,268,999.00 3,947,800.00 4,268,999.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) 600,353.00 (2,299,248.00) (3,460,502.41) (2,268,679.00) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 0.00 0.00 0.00 0.00 0.00 0.0% b) Transfers Out 7600-7629 0.00 0.00 0.00 0.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 0.00 0.00 0.00 0.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 1 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Bond Interest and Redemption Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 51I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 600,353.00 (2,299,248.00) (3,460,502.41) (2,268,679.00) F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 600,353.10 5,359,562.25 5,359,562.25 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 600,353.10 5,359,562.25 5,359,562.25 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 600,353.10 5,359,562.25 5,359,562.25 2) Ending Balance, June 30 (E + F1e) 1,200,706.10 3,060,314.25 3,090,883.25 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Legally Restricted Balance 9740 1,200,706.10 3,060,314.25 3,090,883.25 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 0.00 0.00 0.00 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 2 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Bond Interest and Redemption Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 51I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) FEDERAL REVENUE All Other Federal Revenue 8290 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, FEDERAL REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER STATE REVENUE Tax Relief Subventions Voted Indebtedness Levies Homeowners' Exemptions 8571 15,674.00 15,674.00 0.00 15,674.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8572 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 15,674.00 15,674.00 0.00 15,674.00 0.00 0.0% OTHER LOCAL REVENUE County and District Taxes Voted Indebtedness Levies Secured Roll 8611 1,847,155.00 1,847,155.00 380,379.19 1,871,748.00 24,593.00 1.3% Unsecured Roll 8612 0.00 43,347.00 43,346.28 43,657.00 310.00 0.7% Prior Years' Taxes 8613 0.00 4.00 3.01 784.00 780.00 19500.0% Supplemental Taxes 8614 0.00 22,685.00 22,684.49 26,808.00 4,123.00 18.2% Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 3,075.00 3,074.32 3,838.00 763.00 24.8% Interest 8660 6,523.00 37,811.00 37,810.30 37,811.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 1,853,678.00 1,954,077.00 487,297.59 1,984,646.00 30,569.00 1.6% TOTAL, REVENUES 1,869,352.00 1,969,751.00 487,297.59 2,000,320.00 OTHER OUTGO (excluding Transfers of Indirect Costs) Debt Service Bond Redemptions 7433 0.00 3,000,000.00 3,000,000.00 3,000,000.00 0.00 0.0% Bond Interest and Other Service Charges 7434 1,268,999.00 1,268,999.00 947,800.00 1,268,999.00 0.00 0.0% Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 1,268,999.00 4,268,999.00 3,947,800.00 4,268,999.00 0.00 0.0% TOTAL, EXPENDITURES 1,268,999.00 4,268,999.00 3,947,800.00 4,268,999.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 3 Printed: 2/12/2019 3:10 PM
2018-19 Second Interim Etiwanda Elementary Bond Interest and Redemption Fund 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 51I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN Other Authorized Interfund Transfers In 8919 0.00 0.00 0.00 0.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 0.00 0.00 0.00 0.00 0.00 0.0% INTERFUND TRANSFERS OUT To: General Fund 7614 0.00 0.00 0.00 0.00 0.00 0.0% Other Authorized Interfund Transfers Out 7619 0.00 0.00 0.00 0.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00 0.0% OTHER SOURCES/USES SOURCES Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 0.00 0.00 0.00 0.00 0.00 0.0% (c) TOTAL, SOURCES 0.00 0.00 0.00 0.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 0.00 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 4 Printed: 2/12/2019 3:10 PM
Second Interim Etiwanda Elementary Bond Interest and Redemption Fund 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 51I 2018/19 Resource Description Projected Year Totals 9010 Other Restricted Local 3,090,883.25 Total, Restricted Balance 3,090,883.25 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/18/2012) Page 1 Printed: 2/12/2019 3:11 PM
2018-19 Second Interim Etiwanda Elementary Debt Service Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 52I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) A. REVENUES 1) LCFF Sources 8010-8099 0.00 0.00 0.00 0.00 0.00 0.0% 2) Federal Revenue 8100-8299 0.00 0.00 0.00 0.00 0.00 0.0% 3) Other State Revenue 8300-8599 0.00 0.00 0.00 0.00 0.00 0.0% 4) Other Local Revenue 8600-8799 11,500,000.00 11,500,000.00 0.00 11,500,000.00 0.00 0.0% 5) TOTAL, REVENUES 11,500,000.00 11,500,000.00 0.00 11,500,000.00 B. EXPENDITURES 1) Certificated Salaries 1000-1999 0.00 0.00 0.00 0.00 0.00 0.0% 2) Classified Salaries 2000-2999 0.00 0.00 0.00 0.00 0.00 0.0% 3) Employee Benefits 3000-3999 0.00 0.00 0.00 0.00 0.00 0.0% 4) Books and Supplies 4000-4999 0.00 0.00 0.00 0.00 0.00 0.0% 5) Services and Other Operating Expenditures 5000-5999 0.00 0.00 0.00 0.00 0.00 0.0% 6) Capital Outlay 6000-6999 0.00 0.00 0.00 0.00 0.00 0.0% 7) Other Outgo (excluding Transfers of Indirect 7100-7299, Costs) 7400-7499 11,600,000.00 11,600,000.00 0.00 11,600,000.00 0.00 0.0% 8) Other Outgo - Transfers of Indirect Costs 7300-7399 0.00 0.00 0.00 0.00 0.00 0.0% 9) TOTAL, EXPENDITURES 11,600,000.00 11,600,000.00 0.00 11,600,000.00 C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9) (100,000.00) (100,000.00) 0.00 (100,000.00) D. OTHER FINANCING SOURCES/USES 1) Interfund Transfers a) Transfers In 8900-8929 7,100,000.00 7,100,000.00 0.00 7,100,000.00 0.00 0.0% b) Transfers Out 7600-7629 7,100,000.00 7,100,000.00 0.00 7,100,000.00 0.00 0.0% 2) Other Sources/Uses a) Sources 8930-8979 2,300,000.00 2,300,000.00 0.00 2,300,000.00 0.00 0.0% b) Uses 7630-7699 0.00 0.00 0.00 0.00 0.00 0.0% 3) Contributions 8980-8999 0.00 0.00 0.00 0.00 0.00 0.0% 4) TOTAL, OTHER FINANCING SOURCES/USES 2,300,000.00 2,300,000.00 0.00 2,300,000.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 1 Printed: 2/12/2019 3:11 PM
2018-19 Second Interim Etiwanda Elementary Debt Service Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 52I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) 2,200,000.00 2,200,000.00 0.00 2,200,000.00 F. FUND BALANCE, RESERVES 1) Beginning Fund Balance a) As of July 1 - Unaudited 9791 59,869,266.89 82,299,297.85 82,299,297.85 0.00 0.0% b) Audit Adjustments 9793 0.00 0.00 0.00 0.00 0.0% c) As of July 1 - Audited (F1a + F1b) 59,869,266.89 82,299,297.85 82,299,297.85 d) Other Restatements 9795 0.00 0.00 0.00 0.00 0.0% e) Adjusted Beginning Balance (F1c + F1d) 59,869,266.89 82,299,297.85 82,299,297.85 2) Ending Balance, June 30 (E + F1e) 62,069,266.89 84,499,297.85 84,499,297.85 Components of Ending Fund Balance a) Nonspendable Revolving Cash 9711 0.00 0.00 0.00 Stores 9712 0.00 0.00 0.00 Prepaid Items 9713 0.00 0.00 0.00 All Others 9719 0.00 0.00 0.00 b) Legally Restricted Balance 9740 0.00 0.00 0.00 c) Committed Stabilization Arrangements 9750 0.00 0.00 0.00 Other Commitments 9760 0.00 0.00 0.00 d) Assigned Other Assignments 9780 62,069,266.89 84,499,297.85 84,499,297.85 e) Unassigned/Unappropriated Reserve for Economic Uncertainties 9789 0.00 0.00 0.00 Unassigned/Unappropriated Amount 9790 0.00 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 2 Printed: 2/12/2019 3:11 PM
2018-19 Second Interim Etiwanda Elementary Debt Service Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 52I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) FEDERAL REVENUE All Other Federal Revenue 8290 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, FEDERAL REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER STATE REVENUE Tax Relief Subventions Voted Indebtedness Levies Homeowners' Exemptions 8571 0.00 0.00 0.00 0.00 0.00 0.0% Other Subventions/In-Lieu Taxes 8572 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER STATE REVENUE 0.00 0.00 0.00 0.00 0.00 0.0% OTHER LOCAL REVENUE County and District Taxes Voted Indebtedness Levies Secured Roll 8611 0.00 0.00 0.00 0.00 0.00 0.0% Unsecured Roll 8612 0.00 0.00 0.00 0.00 0.00 0.0% Prior Years' Taxes 8613 0.00 0.00 0.00 0.00 0.00 0.0% Supplemental Taxes 8614 0.00 0.00 0.00 0.00 0.00 0.0% Non-Ad Valorem Taxes Other 8622 9,000,000.00 9,000,000.00 0.00 9,000,000.00 0.00 0.0% Penalties and Interest from Delinquent Non-LCFF Taxes 8629 0.00 0.00 0.00 0.00 0.00 0.0% Interest 8660 2,500,000.00 2,500,000.00 0.00 2,500,000.00 0.00 0.0% Net Increase (Decrease) in the Fair Value of Investments 8662 0.00 0.00 0.00 0.00 0.00 0.0% Other Local Revenue All Other Local Revenue 8699 0.00 0.00 0.00 0.00 0.00 0.0% All Other Transfers In from All Others 8799 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER LOCAL REVENUE 11,500,000.00 11,500,000.00 0.00 11,500,000.00 0.00 0.0% TOTAL, REVENUES 11,500,000.00 11,500,000.00 0.00 11,500,000.00 OTHER OUTGO (excluding Transfers of Indirect Costs) Debt Service Bond Redemptions 7433 4,900,000.00 4,900,000.00 0.00 4,900,000.00 0.00 0.0% Bond Interest and Other Service Charges 7434 6,700,000.00 6,700,000.00 0.00 6,700,000.00 0.00 0.0% Debt Service - Interest 7438 0.00 0.00 0.00 0.00 0.00 0.0% Other Debt Service - Principal 7439 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER OUTGO (excluding Transfers of Indirect Costs) 11,600,000.00 11,600,000.00 0.00 11,600,000.00 0.00 0.0% TOTAL, EXPENDITURES 11,600,000.00 11,600,000.00 0.00 11,600,000.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 3 Printed: 2/12/2019 3:11 PM
2018-19 Second Interim Etiwanda Elementary Debt Service Fund for Blended Component Units 36 67702 0000000 San Bernardino County Revenues, Expenditures, and Changes in Fund Balance Form 52I % Diff Board Approved Projected Year Difference Column Original Budget Operating Budget Actuals To Date Totals (Col B & D) B & D Description Resource Codes Object Codes (A) (B) (C) (D) (E) (F) INTERFUND TRANSFERS INTERFUND TRANSFERS IN Other Authorized Interfund Transfers In 8919 7,100,000.00 7,100,000.00 0.00 7,100,000.00 0.00 0.0% (a) TOTAL, INTERFUND TRANSFERS IN 7,100,000.00 7,100,000.00 0.00 7,100,000.00 0.00 0.0% INTERFUND TRANSFERS OUT Other Authorized Interfund Transfers Out 7619 7,100,000.00 7,100,000.00 0.00 7,100,000.00 0.00 0.0% (b) TOTAL, INTERFUND TRANSFERS OUT 7,100,000.00 7,100,000.00 0.00 7,100,000.00 0.00 0.0% OTHER SOURCES/USES SOURCES Other Sources Transfers from Funds of Lapsed/Reorganized LEAs 8965 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Sources 8979 2,300,000.00 2,300,000.00 0.00 2,300,000.00 0.00 0.0% (c) TOTAL, SOURCES 2,300,000.00 2,300,000.00 0.00 2,300,000.00 0.00 0.0% USES Transfers of Funds from Lapsed/Reorganized LEAs 7651 0.00 0.00 0.00 0.00 0.00 0.0% All Other Financing Uses 7699 0.00 0.00 0.00 0.00 0.00 0.0% (d) TOTAL, USES 0.00 0.00 0.00 0.00 0.00 0.0% CONTRIBUTIONS Contributions from Unrestricted Revenues 8980 0.00 0.00 0.00 0.00 0.00 0.0% Contributions from Restricted Revenues 8990 0.00 0.00 0.00 0.00 0.00 0.0% (e) TOTAL, CONTRIBUTIONS 0.00 0.00 0.00 0.00 0.00 0.0% TOTAL, OTHER FINANCING SOURCES/USES (a - b + c - d + e) 2,300,000.00 2,300,000.00 0.00 2,300,000.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/30/2018) Page 4 Printed: 2/12/2019 3:11 PM
Second Interim Etiwanda Elementary Debt Service Fund for Blended Component Units 36 67702 0000000 San Bernardino County Exhibit: Restricted Balance Detail Form 52I 2018/19 Resource Description Projected Year Totals Total, Restricted Balance 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: fundi-d (Rev 04/18/2012) Page 1 Printed: 2/12/2019 3:11 PM
2018-19 Second Interim Etiwanda Elementary AVERAGE DAILY ATTENDANCE 36 67702 0000000 San Bernardino County Form AI ESTIMATED FUNDED ADA ESTIMATED ESTIMATED Board P-2 REPORT ESTIMATED FUNDED ADA Approved ADA FUNDED ADA PERCENTAGE Original Operating Projected Year Projected DIFFERENCE DIFFERENCE Budget Budget Totals Year Totals (Col. D - B) (Col. E / B) Description (A) (B) (C) (D) (E) (F) A. DISTRICT 1. Total District Regular ADA Includes Opportunity Classes, Home & Hospital, Special Day Class, Continuation Education, Special Education NPS/LCI and Extended Year, and Community Day School (includes Necessary Small School ADA) 13,458.41 13,707.30 13,537.92 13,707.30 0.00 0% 2. Total Basic Aid Choice/Court Ordered Voluntary Pupil Transfer Regular ADA Includes Opportunity Classes, Home & Hospital, Special Day Class, Continuation Education, Special Education NPS/LCI and Extended Year, and Community Day School (ADA not included in Line A1 above) 0.00 0.00 0.00 0.00 0.00 0% 3. Total Basic Aid Open Enrollment Regular ADA Includes Opportunity Classes, Home & Hospital, Special Day Class, Continuation Education, Special Education NPS/LCI and Extended Year, and Community Day School (ADA not included in Line A1 above) 0.00 0.00 0.00 0.00 0.00 0% 4. Total, District Regular ADA (Sum of Lines A1 through A3) 13,458.41 13,707.30 13,537.92 13,707.30 0.00 0% 5. District Funded County Program ADA a. County Community Schools 0.00 0.00 0.00 0.00 0.00 0% b. Special Education-Special Day Class 57.68 57.68 57.68 57.68 0.00 0% c. Special Education-NPS/LCI 0.00 0.00 0.00 0.00 0.00 0% d. Special Education Extended Year 1.51 1.51 1.51 1.51 0.00 0% e. Other County Operated Programs: Opportunity Schools and Full Day Opportunity Classes, Specialized Secondary Schools 0.00 0.00 0.00 0.00 0.00 0% f. County School Tuition Fund (Out of State Tuition) [EC 2000 and 46380] 0.00 0.00 0.00 0.00 0.00 0% g. Total, District Funded County Program ADA (Sum of Lines A5a through A5f) 59.19 59.19 59.19 59.19 0.00 0% 6. TOTAL DISTRICT ADA (Sum of Line A4 and Line A5g) 13,517.60 13,766.49 13,597.11 13,766.49 0.00 0% 7. Adults in Correctional Facilities 0.00 0.00 0.00 0.00 0.00 0% 8. Charter School ADA (Enter Charter School ADA using Tab C. Charter School ADA) California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: adai (Rev 02/05/2018) Page 1 of 1 Printed: 2/12/2019 3:11 PM
2018-19 Second Interim Etiwanda Elementary AVERAGE DAILY ATTENDANCE 36 67702 0000000 San Bernardino County Form AI ESTIMATED FUNDED ADA ESTIMATED ESTIMATED Board P-2 REPORT ESTIMATED FUNDED ADA Approved ADA FUNDED ADA PERCENTAGE Original Operating Projected Year Projected DIFFERENCE DIFFERENCE Budget Budget Totals Year Totals (Col. D - B) (Col. E / B) Description (A) (B) (C) (D) (E) (F) B. COUNTY OFFICE OF EDUCATION 1. County Program Alternative Education ADA a. County Group Home and Institution Pupils 0.00 0.00 0.00 0.00 0.00 0% b. Juvenile Halls, Homes, and Camps 0.00 0.00 0.00 0.00 0.00 0% c. Probation Referred, On Probation or Parole, Expelled per EC 48915(a) or (c) [EC 2574(c)(4)(A)] 0.00 0.00 0.00 0.00 0.00 0% d. Total, County Program Alternative Education ADA (Sum of Lines B1a through B1c) 0.00 0.00 0.00 0.00 0.00 0% 2. District Funded County Program ADA a. County Community Schools 0.00 0.00 0.00 0.00 0.00 0% b. Special Education-Special Day Class 0.00 0.00 0.00 0.00 0.00 0% c. Special Education-NPS/LCI 0.00 0.00 0.00 0.00 0.00 0% d. Special Education Extended Year 0.00 0.00 0.00 0.00 0.00 0% e. Other County Operated Programs: Opportunity Schools and Full Day Opportunity Classes, Specialized Secondary Schools 0.00 0.00 0.00 0.00 0.00 0% f. County School Tuition Fund (Out of State Tuition) [EC 2000 and 46380] 0.00 0.00 0.00 0.00 0.00 0% g. Total, District Funded County Program ADA (Sum of Lines B2a through B2f) 0.00 0.00 0.00 0.00 0.00 0% 3. TOTAL COUNTY OFFICE ADA (Sum of Lines B1d and B2g) 0.00 0.00 0.00 0.00 0.00 0% 4. Adults in Correctional Facilities 0.00 0.00 0.00 0.00 0.00 0% 5. County Operations Grant ADA 0.00 0.00 0.00 0.00 0.00 0% 6. Charter School ADA (Enter Charter School ADA using Tab C. Charter School ADA) California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: adai (Rev 02/03/2016) Page 1 of 1 Printed: 2/12/2019 3:11 PM
2018-19 Second Interim Etiwanda Elementary AVERAGE DAILY ATTENDANCE 36 67702 0000000 San Bernardino County Form AI ESTIMATED FUNDED ADA ESTIMATED ESTIMATED Board P-2 REPORT ESTIMATED FUNDED ADA Approved ADA FUNDED ADA PERCENTAGE Original Operating Projected Year Projected DIFFERENCE DIFFERENCE Budget Budget Totals Year Totals (Col. D - B) (Col. E / B) Description (A) (B) (C) (D) (E) (F) C. CHARTER SCHOOL ADA Authorizing LEAs reporting charter school SACS financial data in their Fund 01, 09, or 62 use this worksheet to report ADA for those charter schools Authorizing LEAs reporting charter school SACS financial data in their Fund 01, 09, or 62 use this worksheet to report ADA for those charter schools Charter schools reporting SACS financial data separately from their authorizing LEAs in Fund 01 or Fund 62 use this worksheet to report their ADA Charter schools reporting SACS financial data separately from their authorizing LEAs in Fund 01 or Fund 62 use this worksheet to report their ADA FUND 01: Charter School ADA corresponding to SACS financial data reported in Fund 01 FUND 01: Charter School ADA corresponding to SACS financial data reported in Fund 01 1. Total Charter School Regular ADA 0.00 0.00 0.00 0.00 0.00 0% 2. Charter School County Program Alternative Education ADA a. County Group Home and Institution Pupils 0.00 0.00 0.00 0.00 0.00 0% b. Juvenile Halls, Homes, and Camps 0.00 0.00 0.00 0.00 0.00 0% c. Probation Referred, On Probation or Parole, Expelled per EC 48915(a) or (c) [EC 2574(c)(4)(A)] 0.00 0.00 0.00 0.00 0.00 0% d. Total, Charter School County Program Alternative Education ADA (Sum of Lines C2a through C2c) 0.00 0.00 0.00 0.00 0.00 0% 3. Charter School Funded County Program ADA a. County Community Schools 0.00 0.00 0.00 0.00 0.00 0% b. Special Education-Special Day Class 0.00 0.00 0.00 0.00 0.00 0% c. Special Education-NPS/LCI 0.00 0.00 0.00 0.00 0.00 0% d. Special Education Extended Year 0.00 0.00 0.00 0.00 0.00 0% e. Other County Operated Programs: Opportunity Schools and Full Day Opportunity Classes, Specialized Secondary Schools 0.00 0.00 0.00 0.00 0.00 0% f. Total, Charter School Funded County Program ADA (Sum of Lines C3a through C3e) 0.00 0.00 0.00 0.00 0.00 0% 4. TOTAL CHARTER SCHOOL ADA (Sum of Lines C1, C2d, and C3f) 0.00 0.00 0.00 0.00 0.00 0% FUND 09 or 62: Charter School ADA corresponding to SACS financial data reported in Fund 09 or Fund 62 5. Total Charter School Regular ADA 0.00 0.00 0.00 0.00 0.00 0% 6. Charter School County Program Alternative Education ADA a. County Group Home and Institution Pupils 0.00 0.00 0.00 0.00 0.00 0% b. Juvenile Halls, Homes, and Camps 0.00 0.00 0.00 0.00 0.00 0% c. Probation Referred, On Probation or Parole, Expelled per EC 48915(a) or (c) [EC 2574(c)(4)(A)] 0.00 0.00 0.00 0.00 0.00 0% d. Total, Charter School County Program Alternative Education ADA (Sum of Lines C6a through C6c) 0.00 0.00 0.00 0.00 0.00 0% 7. Charter School Funded County Program ADA a. County Community Schools 0.00 0.00 0.00 0.00 0.00 0% b. Special Education-Special Day Class 0.00 0.00 0.00 0.00 0.00 0% c. Special Education-NPS/LCI 0.00 0.00 0.00 0.00 0.00 0% d. Special Education Extended Year 0.00 0.00 0.00 0.00 0.00 0% e. Other County Operated Programs: Opportunity Schools and Full Day Opportunity Classes, Specialized Secondary Schools 0.00 0.00 0.00 0.00 0.00 0% f. Total, Charter School Funded County Program ADA (Sum of Lines C7a through C7e) 0.00 0.00 0.00 0.00 0.00 0% 8. TOTAL CHARTER SCHOOL ADA (Sum of Lines C5, C6d, and C7f) 0.00 0.00 0.00 0.00 0.00 0% 9. TOTAL CHARTER SCHOOL ADA Reported in Fund 01, 09, or 62 (Sum of Lines C4 and C8) 0.00 0.00 0.00 0.00 0.00 0% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: adai (Rev 03/27/2018) Page 1 of 1 Printed: 2/12/2019 3:11 PM
Second Interim Etiwanda Elementary 2018-19 Projected Year Totals 36 67702 0000000 San Bernardino County Every Student Succeeds Act Maintenance of Effort Expenditures Form ESMOE 2018-19 Funds 01, 09, and 62 Section I - Expenditures Expenditures Goals Functions Objects A. Total state, federal, and local expenditures (all resources) 152,605,241.00 All All 1000-7999 B. Less all federal expenditures not allowed for MOE (Resources 3000-5999, except 3385) 9,324,899.00 All All 1000-7999 C. Less state and local expenditures not allowed for MOE: (All resources, except federal as identified in Line B) 1. Community Services 4,191,874.00 All 5000-5999 1000-7999 All except All except 2. Capital Outlay 1,344,283.00 7100-7199 5000-5999 6000-6999 5400-5450, 5800, 7430- 3. Debt Service 0.00 All 9100 7439 4. Other Transfers Out 0.00 All 9200 7200-7299 5. Interfund Transfers Out 3,705,885.00 All 9300 7600-7629 9100 7699 6. All Other Financing Uses 0.00 All 9200 7651 All except 5000-5999, 7. Nonagency 0.00 7100-7199 9000-9999 1000-7999 8. Tuition (Revenue, in lieu of expenditures, to approximate costs of services for which tuition is received) 0.00 All All 8710 9. Supplemental expenditures made as a result of a Manually entered. Must not include Presidentially declared disaster expenditures in lines B, C1-C8, D1, or D2. 10. Total state and local expenditures not allowed for MOE calculation (Sum lines C1 through C9) 9,242,042.00 1000-7143, D. Plus additional MOE expenditures: 7300-7439 1. Expenditures to cover deficits for food services minus (Funds 13 and 61) (If negative, then zero) 284,632.25 All All 8000-8699 Manually entered. Must not include 2. Expenditures to cover deficits for student body activities expenditures in lines A or D1. E. Total expenditures subject to MOE (Line A minus lines B and C10, plus lines D1 and D2) 134,322,932.25 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: esmoe (Rev 03/01/2018) Page 1 Printed: 2/12/2019 3:12 PM
Second Interim Etiwanda Elementary 2018-19 Projected Year Totals 36 67702 0000000 San Bernardino County Every Student Succeeds Act Maintenance of Effort Expenditures Form ESMOE 2018-19 Annual ADA/ Section II - Expenditures Per ADA Exps. Per ADA A. Average Daily Attendance (Form AI, Column C, sum of lines A6 and C9)* 13,597.11 B. Expenditures per ADA (Line I.E divided by Line II.A) 9,878.79 Section III - MOE Calculation (For data collection only. Final determination will be done by CDE) Total Per ADA A. Base expenditures (Preloaded expenditures extracted from prior year Unaudited Actuals MOE calculation). (Note: If the prior year MOE was not met, in its final determination, CDE will adjust the prior year base to 90 percent of the preceding prior year amount rather than the actual prior year expenditure amount.) 125,297,027.53 9,078.09 1. Adjustment to base expenditure and expenditure per ADA amounts for LEAs failing prior year MOE calculation (From Section IV) 0.00 0.00 2. Total adjusted base expenditure amounts (Line A plus Line A.1) 125,297,027.53 9,078.09 B. Required effort (Line A.2 times 90%) 112,767,324.78 8,170.28 C. Current year expenditures (Line I.E and Line II.B) 134,322,932.25 9,878.79 D. MOE deficiency amount, if any (Line B minus Line C) (If negative, then zero) 0.00 0.00 E. MOE determination (If one or both of the amounts in line D are zero, the MOE requirement MOE Met is met; if both amounts are positive, the MOE requirement is not met. If either column in Line A.2 or Line C equals zero, the MOE calculation is incomplete.) F. MOE deficiency percentage, if MOE not met; otherwise, zero (Line D divided by Line B) (Funding under ESSA covered programs in FY 2020-21 may be reduced by the lower of the two percentages) 0.00% 0.00% *Interim Periods - Annual ADA not available from Form AI. For your convenience, Projected Year Totals Estimated P-2 ADA is extracted. Manual adjustment may be required to reflect estimated Annual ADA. California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: esmoe (Rev 03/01/2018) Page 2 Printed: 2/12/2019 3:12 PM
Second Interim Etiwanda Elementary 2018-19 Projected Year Totals 36 67702 0000000 San Bernardino County Every Student Succeeds Act Maintenance of Effort Expenditures Form ESMOE SECTION IV - Detail of Adjustments to Base Expenditures (used in Section III, Line A.1) Total Expenditures Description of Adjustments Expenditures Per ADA Total adjustments to base expenditures 0.00 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: esmoe (Rev 03/01/2018) Page 3 Printed: 2/12/2019 3:12 PM
Second Interim Etiwanda Elementary 2018-19 Projected Year Totals 36 67702 0000000 San Bernardino County Indirect Cost Rate Worksheet Form ICR Part I - General Administrative Share of Plant Services Costs California's indirect cost plan allows that the general administrative costs in the indirect cost pool may include that portion of plant services costs (maintenance and operations costs and facilities rents and leases costs) attributable to the general administrative offices. The calculation of the plant services costs attributed to general administration and included in the pool is standardized and automated using the percentage of salaries and benefits relating to general administration as proxy for the percentage of square footage occupied by general administration. A. Salaries and Benefits - Other General Administration and Centralized Data Processing 1. Salaries and benefits paid through payroll (Funds 01, 09, and 62, objects 1000-3999 except 3701-3702) (Functions 7200-7700, goals 0000 and 9000) 3,822,838.00 2. Contracted general administrative positions not paid through payroll a. Enter the costs, if any, of general administrative positions performing services ON SITE but paid through a contract, rather than through payroll, in functions 7200-7700, goals 0000 and 9000, Object 5800. b. If an amount is entered on Line A2a, provide the title, duties, and approximate FTE of each general administrative position paid through a contract. Retain supporting documentation in case of audit. B. Salaries and Benefits - All Other Activities 1. Salaries and benefits paid through payroll (Funds 01, 09, and 62, objects 1000-3999 except 3701-3702) (Functions 1000-6999, 7100-7180, & 8100-8400; Functions 7200-7700, all goals except 0000 & 9000) 116,990,402.00 C. Percentage of Plant Services Costs Attributable to General Administration (Line A1 plus Line A2a, divided by Line B1; zero if negative) (See Part III, Lines A5 and A6) 3.27% Part II - Adjustments for Employment Separation Costs When an employee separates from service, the local educational agency (LEA) may incur costs associated with the separation in addition to the employee's regular salary and benefits for the final pay period. These additional costs can be categorized as "normal" or "abnormal or mass" separation costs. Normal separation costs include items such as pay for accumulated unused leave or routine severance pay authorized by governing board policy. Normal separation costs are not allowable as direct costs to federal programs, but are allowable as indirect costs. State programs may have similar restrictions. Where federal or state program guidelines required that the LEA charge an employee's normal separation costs to an unrestricted resource rather than to the restricted program in which the employee worked, the LEA may identify and enter these costs on Line A for inclusion in the indirect cost pool. Abnormal or mass separation costs are those costs resulting from actions taken by an LEA to influence employees to terminate their employment earlier than they normally would have. Abnormal or mass separation costs include retirement incentives such as a Golden Handshake or severance packages negotiated to effect termination. Abnormal or mass separation costs may not be charged to federal programs as either direct costs or indirect costs. Where an LEA paid abnormal or mass separation costs on behalf of positions in general administrative functions included in the indirect cost pool, the LEA must identify and enter these costs on Line B for exclusion from the pool. A. Normal Separation Costs (optional) Enter any normal separation costs paid on behalf of employees of restricted state or federal programs that were charged to an unrestricted resource (0000-1999) in funds 01, 09, and 62 with functions 1000-6999 or 8100-8400 rather than to the restricted program. These costs will be moved in Part III from base costs to the indirect cost pool. Retain supporting documentation. B. Abnormal or Mass Separation Costs (required) Enter any abnormal or mass separation costs paid on behalf of general administrative positions charged to unrestricted resources (0000-1999) in funds 01, 09, and 62 with functions 7200-7700. These costs will be moved in Part III from the indirect cost pool to base costs. If none, enter zero. 0.00 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: icr (Rev 02/21/2017) Page 1 of 3 Printed: 2/12/2019 3:12 PM
Second Interim Etiwanda Elementary 2018-19 Projected Year Totals 36 67702 0000000 San Bernardino County Indirect Cost Rate Worksheet Form ICR Part III - Indirect Cost Rate Calculation (Funds 01, 09, and 62, unless indicated otherwise) A. Indirect Costs 1. Other General Administration, less portion charged to restricted resources or specific goals (Functions 7200-7600, objects 1000-5999, minus Line B9) 4,573,546.00 2. Centralized Data Processing, less portion charged to restricted resources or specific goals (Function 7700, objects 1000-5999, minus Line B10) 1,279,438.00 3. External Financial Audit - Single Audit (Function 7190, resources 0000-1999, goals 0000 and 9000, objects 5000-5999) 51,000.00 4. Staff Relations and Negotiations (Function 7120, resources 0000-1999, goals 0000 and 9000, objects 1000-5999) 0.00 5. Plant Maintenance and Operations (portion relating to general administrative offices only) (Functions 8100-8400, objects 1000-5999 except 5100, times Part I, Line C) 383,688.26 6. Facilities Rents and Leases (portion relating to general administrative offices only) (Function 8700, resources 0000-1999, objects 1000-5999 except 5100, times Part I, Line C) 0.00 7. Adjustment for Employment Separation Costs a. Plus: Normal Separation Costs (Part II, Line A) 0.00 b. Less: Abnormal or Mass Separation Costs (Part II, Line B) 0.00 8. Total Indirect Costs (Lines A1 through A7a, minus Line A7b) 6,287,672.26 9. Carry-Forward Adjustment (Part IV, Line F) 357,441.14 10. Total Adjusted Indirect Costs (Line A8 plus Line A9) 6,645,113.40 B. Base Costs 1. Instruction (Functions 1000-1999, objects 1000-5999 except 5100) 97,468,014.00 2. Instruction-Related Services (Functions 2000-2999, objects 1000-5999 except 5100) 12,082,707.00 3. Pupil Services (Functions 3000-3999, objects 1000-5999 except 5100) 9,843,713.00 4. Ancillary Services (Functions 4000-4999, objects 1000-5999 except 5100) 0.00 5. Community Services (Functions 5000-5999, objects 1000-5999 except 5100) 4,191,874.00 6. Enterprise (Function 6000, objects 1000-5999 except 5100) 0.00 7. Board and Superintendent (Functions 7100-7180, objects 1000-5999, minus Part III, Line A4) 648,370.00 8. External Financial Audit - Single Audit and Other (Functions 7190-7191, objects 5000-5999, minus Part III, Line A3) 100,000.00 9. Other General Administration (portion charged to restricted resources or specific goals only) (Functions 7200-7600, resources 2000-9999, objects 1000-5999; Functions 7200-7600, resources 0000-1999, all goals except 0000 and 9000, objects 1000-5999) 37,895.00 10. Centralized Data Processing (portion charged to restricted resources or specific goals only) (Function 7700, resources 2000-9999, objects 1000-5999; Function 7700, resources 0000-1999, all goals except 0000 and 9000, objects 1000-5999) 0.00 11. Plant Maintenance and Operations (all except portion relating to general administrative offices) (Functions 8100-8400, objects 1000-5999 except 5100, minus Part III, Line A5) 11,349,897.74 12. Facilities Rents and Leases (all except portion relating to general administrative offices) (Function 8700, objects 1000-5999 except 5100, minus Part III, Line A6) 0.00 13. Adjustment for Employment Separation Costs a. Less: Normal Separation Costs (Part II, Line A) 0.00 b. Plus: Abnormal or Mass Separation Costs (Part II, Line B) 0.00 14. Adult Education (Fund 11, functions 1000-6999, 8100-8400, and 8700, objects 1000-5999 except 5100) 0.00 15. Child Development (Fund 12, functions 1000-6999, 8100-8400, and 8700, objects 1000-5999 except 5100) 0.00 16. Cafeteria (Funds 13 and 61, functions 1000-6999, 8100-8400, and 8700, objects 1000-5999 except 5100) 4,152,648.00 17. Foundation (Funds 19 and 57, functions 1000-6999, 8100-8400, and 8700, objects 1000-5999 except 5100) 0.00 18. Total Base Costs (Lines B1 through B12 and Lines B13b through B17, minus Line B13a) 139,875,118.74 C. Straight Indirect Cost Percentage Before Carry-Forward Adjustment (For information only - not for use when claiming/recovering indirect costs) (Line A8 divided by Line B18) 4.50% D. Preliminary Proposed Indirect Cost Rate (For final approved fixed-with-carry-forward rate for use in 2020-21 see www.cde.ca.gov/fg/ac/ic) (Line A10 divided by Line B18) 4.75% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: icr (Rev 02/21/2017) Page 2 of 3 Printed: 2/12/2019 3:12 PM
Second Interim Etiwanda Elementary 2018-19 Projected Year Totals 36 67702 0000000 San Bernardino County Indirect Cost Rate Worksheet Form ICR Part IV - Carry-forward Adjustment The carry-forward adjustment is an after-the-fact adjustment for the difference between indirect costs recoverable using the indirect cost rate approved for use in a given year, and the actual indirect costs incurred in that year. The carry-forward adjustment eliminates the need for LEAs to file amended federal reports when their actual indirect costs vary from the estimated indirect costs on which the approved rate was based. Where the ratio of indirect costs incurred in the current year is less than the estimated ratio of indirect costs on which the approved rate for use in the current year was based, the carry-forward adjustment is limited by using either the approved rate times current year base costs, or the highest rate actually used to recover costs from any program times current year base costs, if the highest rate used was less than the approved rate. Rates used to recover costs from programs are displayed in Exhibit A. A. Indirect costs incurred in the current year (Part III, Line A8) 6,287,672.26 B. Carry-forward adjustment from prior year(s) 1. Carry-forward adjustment from the second prior year (503,076.51) 2. Carry-forward adjustment amount deferred from prior year(s), if any 0.00 C. Carry-forward adjustment for under- or over-recovery in the current year 1. Under-recovery: Part III, Line A8, plus carry-forward adjustment from prior years, minus (approved indirect cost rate (3.88%) times Part III, Line B18); zero if negative 357,441.14 2. Over-recovery: Part III, Line A8, plus carry-forward adjustment from prior years, minus the lesser of (approved indirect cost rate (3.88%) times Part III, Line B18) or (the highest rate used to recover costs from any program (3.88%) times Part III, Line B18); zero if positive 0.00 D. Preliminary carry-forward adjustment (Line C1 or C2) 357,441.14 E. Optional allocation of negative carry-forward adjustment over more than one year Where a negative carry-forward adjustment causes the proposed approved rate to fall below zero or would reduce the rate at which the LEA could recover indirect costs to such an extent that it would cause the LEA significant fiscal harm, the LEA may request that the carry-forward adjustment be allocated over more than one year. Where allocation of a negative carry-forward adjustment over more than one year does not resolve a negative rate, the CDE will work with the LEA on a case-by-case basis to establish an approved rate. Option 1. Preliminary proposed approved rate (Part III, Line D) if entire negative carry-forward adjustment is applied to the current year calculation: not applicable Option 2. Preliminary proposed approved rate (Part III, Line D) if one-half of negative carry-forward adjustment is applied to the current year calculation and the remainder is deferred to one or more future years: not applicable Option 3. Preliminary proposed approved rate (Part III, Line D) if one-third of negative carry-forward adjustment is applied to the current year calculation and the remainder is deferred to one or more future years: not applicable LEA request for Option 1, Option 2, or Option 3 1 F. Carry-forward adjustment used in Part III, Line A9 (Line D minus amount deferred if Option 2 or Option 3 is selected) 357,441.14 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: icr (Rev 02/21/2017) Page 3 of 3 Printed: 2/12/2019 3:12 PM
Second Interim Etiwanda Elementary 2018-19 Projected Year Totals 36 67702 0000000 San Bernardino County Exhibit A: Indirect Cost Rates Charged to Programs Form ICR Approved indirect cost rate: 3.88% Highest rate used in any program: 3.88% Eligible Expenditures (Objects 1000-5999 Indirect Costs Charged Rate Fund Resource except Object 5100) (Objects 7310 and 7350) Used 01 3010 1,118,920.00 42,731.00 3.82% 01 4035 222,301.00 8,366.00 3.76% 01 4127 72,398.00 2,809.00 3.88% 01 4201 36,820.00 1,228.00 3.34% 01 4203 119,492.00 2,439.00 2.04% 01 6230 86,238.00 2,248.00 2.61% 01 8150 4,701,621.00 169,871.00 3.61% California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: icr (Rev 03/16/2012) Page 1 of 1 Printed: 2/12/2019 3:12 PM
2018-19 Second Interim Etiwanda Elementary General Fund 36 67702 0000000 San Bernardino County Multiyear Projections Form MYPI Unrestricted Projected Year % % Totals Change 2019-20 Change 2020-21 Object (Form 01I) (Cols. C-A/A) Projection (Cols. E-C/C) Projection Description Codes (A) (B) (C) (D) (E) (Enter projections for subsequent years 1 and 2 in Columns C and E; current year - Column A - is extracted) A. REVENUES AND OTHER FINANCING SOURCES 1. LCFF/Revenue Limit Sources 8010-8099 117,945,517.00 2.48% 120,876,316.00 1.81% 123,064,325.00 2. Federal Revenues 8100-8299 75,000.00 0.00% 75,000.00 0.00% 75,000.00 3. Other State Revenues 8300-8599 5,063,691.00 -49.82% 2,540,951.00 0.00% 2,540,951.00 4. Other Local Revenues 8600-8799 7,500,075.00 0.00% 7,500,075.00 0.00% 7,500,075.00 5. Other Financing Sources a. Transfers In 8900-8929 2,656,000.00 0.00% 2,656,000.00 0.00% 2,656,000.00 b. Other Sources 8930-8979 0.00 0.00% 0.00 0.00% 0.00 c. Contributions 8980-8999 (22,110,235.00) 7.02% (23,662,453.00) -1.04% (23,416,301.00) 6. Total (Sum lines A1 thru A5c) 111,130,048.00 -1.03% 109,985,889.00 2.21% 112,420,050.00 B. EXPENDITURES AND OTHER FINANCING USES 1. Certificated Salaries a. Base Salaries 56,879,183.00 57,745,619.00 b. Step & Column Adjustment 1,187,716.00 1,192,417.00 c. Cost-of-Living Adjustment d. Other Adjustments (321,280.00) (963,840.00) e. Total Certificated Salaries (Sum lines B1a thru B1d) 1000-1999 56,879,183.00 1.52% 57,745,619.00 0.40% 57,974,196.00 2. Classified Salaries a. Base Salaries 14,383,821.00 14,599,578.00 b. Step & Column Adjustment 215,757.00 218,994.00 c. Cost-of-Living Adjustment d. Other Adjustments e. Total Classified Salaries (Sum lines B2a thru B2d) 2000-2999 14,383,821.00 1.50% 14,599,578.00 1.50% 14,818,572.00 3. Employee Benefits 3000-3999 23,398,213.00 2.33% 23,942,719.00 -0.64% 23,790,605.00 4. Books and Supplies 4000-4999 4,895,565.00 -28.69% 3,490,950.00 3.23% 3,603,708.00 5. Services and Other Operating Expenditures 5000-5999 13,115,716.00 3.50% 13,574,766.00 3.23% 14,013,231.00 6. Capital Outlay 6000-6999 43,532.00 -78.26% 9,466.00 3.23% 9,772.00 7. Other Outgo (excluding Transfers of Indirect Costs) 7100-7299, 7400-7499 475,000.00 3.50% 491,625.00 3.23% 507,504.00 8. Other Outgo - Transfers of Indirect Costs 7300-7399 (229,692.00) 3.50% (237,731.00) 3.23% (245,410.00) 9. Other Financing Uses a. Transfers Out 7600-7629 1,467,585.00 90.64% 2,797,830.00 -36.44% 1,778,336.00 b. Other Uses 7630-7699 0.00 0.00% 0.00 0.00% 0.00 10. Other Adjustments (Explain in Section F below) 0.00 0.00 11. Total (Sum lines B1 thru B10) 114,428,923.00 1.74% 116,414,822.00 -0.14% 116,250,514.00 C. NET INCREASE (DECREASE) IN FUND BALANCE (Line A6 minus line B11) (3,298,875.00) (6,428,933.00) (3,830,464.00) D. FUND BALANCE 1. Net Beginning Fund Balance (Form 01I, line F1e) 24,823,051.16 21,524,176.16 15,095,243.16 2. Ending Fund Balance (Sum lines C and D1) 21,524,176.16 15,095,243.16 11,264,779.16 3. Components of Ending Fund Balance (Form 01I) a. Nonspendable 9710-9719 75,000.00 75,000.00 75,000.00 b. Restricted 9740 c. Committed 1. Stabilization Arrangements 9750 0.00 0.00 0.00 2. Other Commitments 9760 0.00 0.00 0.00 d. Assigned 9780 0.00 0.00 0.00 e. Unassigned/Unappropriated 1. Reserve for Economic Uncertainties 9789 4,578,157.00 3,492,445.00 3,487,515.00 2. Unassigned/Unappropriated 9790 16,871,019.16 11,527,798.16 7,702,264.16 f. Total Components of Ending Fund Balance (Line D3f must agree with line D2) 21,524,176.16 15,095,243.16 11,264,779.16 California Dept of Education SACS Financial Reporting Software - 2018.2.0 File: mypi (Rev 03/30/2015) Page 1 Printed: 2/12/2019 3:13 PM
Recommend
More recommend