Cash Reconciliation May 31, 2017

1 Cash Reconciliation May 31, 2017. BANK ACCOUNTS. CivistaBank - budgetary $ 329, PNC Money Market .5% $ 29, STAR Ohio-General .98% $ 7,798, STAR Ohio-Construction Acct .98% $ 305, STAR Ohio Plus $ - Subtotal Bank Accounts $ 8,463, INVESTMENTS. Certificates of Deposit $ 2,344, Commercial Paper $ - Agency Bonds $ 250, Gift Card Balance $ - Investment Subtotal $ 2,594, Total Account Balances $ 11,057, ADJUSTMENTS TO BANK BALANCE. Outstanding Deposit Less Outstanding Checks - budgetary $ (264, ). Less Outstanding Checks - payroll $ (89, ). Less Outstanding Electronic Transfers $ (58, ). Plus Petty Cash on hand $ 6, TOTAL ADJUSTED BANK BALANCE ** $ 10,652, ACCOUNT LEDGER (FINSUM REPORT) ** $ 10,652, $ - Difference *Adjusted Bank Balance must equal Finsum Report CURRENT INVESTMENTS. May 31, 2017.

2 BANK #/CUSIP # From To TYPE RATE AMOUNT. Key Bank 02006 LQA4 4/9/2015 10/10/2017 Ally Bank CD $ 250, Multi Bank Securities 447764-AH-4 3/22/2017 11/22/2017 Huron VY ST BK $ 249, Multi Bank Securities n/a 12/26/2012 12/26/2017 Goldman Saks CD $ 150, Multi Bank Securities 084601-HA-4 3/17/2017 3/15/2018 Berkshire BK Pittsfiled $ 247, Multi Bank Securities 16116P-HS-3 3/14/2017 7/16/2018 Charter BK Eau Claire $ 248, Key Bank 3130A6AE7 3/31/2017 9/14/2018 Federal Home Loan Bank $ 250, Multi Bank Securities 47804 GCR2 8/26/2016 11/26/2018 John Marshall CD $ 150, Multi Bank Securities 202750-5K-7 3/24/2017 3/25/2019 Commonwealth Business Bk $ 150, Multi Bank Securities 928066-AT-6 3/30/2017 6/28/2019 Virginia Partners Bk $ 150, Multi Bank Securities 92937 CEG9 8/12/2016 8/12/2019 WEX BK Midvale Utah CD $ 150.

3 Multi Bank Securities 48126X-D7-7 3/16/2017 3/16/2020 JPMorgan Chase BK Columbus $ 150, Multi Bank Securities 140420C24 8/17/2016 8/17/2020 Capital One BK USA CD $ 150, Multi Bank Securities 949763AF3 8/17/2016 8/17/2021 Wells Fargo BK CD $ 150, Multi Bank Securities 40434Y-GK-7 3/21/2017 3/21/2022 HSBC BK USA $ 150, RECAP $ - Agency $ 250, Bkr Accpt $ - CertDep $ 2,344, $ 2,594, CommPaper $ - Callable Bonds Norwalk City School District COMPARATIVE FINANCIAL STATEMENT. May 31, 2017. May May MONTHLY FY 17 FY 16 ANNUAL. 2017 2016 DIFFERENCE YTD YTD DIFFERENCE. REVENUE: Real Estate Taxes 0 0 0 7,102,410 7,650,463 -548,053. Personal Tangible 0 0 0 514,316 0 514,316. Income Tax 0 0 0 2,094,877 2,057,340 37,537. State funding 1,198,121 1,154,364 43,757 13,632,302 13,104,224 528,078. State restricted funding 51,002 49,729 1,273 573,779 522,798 50,981.

4 Property Tax Allocation 0 -12,044 12,044 923,922 928,669 -4,747. All Other Operating Revenue 113,216 111,444 1,772 1,754,579 1,361,549 393,030. Non-Operating Revenue 0 0 0 0 68,989 -68,989. TOTAL REVENUE: 1,362,339 1,303,493 58,846 26,596,185 25,694,032 902,153. EXPENSES: Salaries & Wages 1,208,329 1,030,584 177,745 12,356,759 12,030,057 326,702. Fringe Benefits 381,410 496,909 -115,499 5,204,087 5,214,764 -10,677. Purchased Services 627,272 496,897 130,375 5,256,489 4,616,819 639,670. Supplies & Texts 50,119 104,399 -54,280 774,609 657,211 117,398. Capital Outlay 188,578 9,632 178,946 514,871 428,314 86,557. Transfers Out 0 0 0 2,000 2,000 0. Other Expenses 2,034 2,275 -241 296,882 309,021 -12,139. TOT EXPENDITURES 2,457,742 2,140,696 317,046 24,405,697 23,258,186 1,147,511. Revenues - Expenditures -1,095,403 -837,203 2,190,488 2,435,846.

5 Norwalk City School District FISCAL YEAR TO DATE COMPARED TO FORECAST. May 31, 2017. FY 17 FY 17 YTD PERCENT Amount to be YTD ACTUAL FORECAST OF FORECAST Received/Expended BEGINNING CASH BALANCE. REVENUE: Real Estate Taxes 7,102,410 7,102,410 0. Personal Tangible 514,316 514,315 -1. Income Tax 2,094,877 2,094,876 -1. State funding 13,632,302 14,838,077 1,205,775. State restricted funding 573,779 629,210 55,431. Property Tax Allocation 923,922 923,922 0. All Other Operating Revenue 1,754,579 1,837,737 83,158. Non-Operating Revenue 0 0 0. TOTAL REVENUE: 26,596,185 27,940,547 1,344,362. EXPENSES: Salaries & Wages 12,356,759 13,670,133 1,313,374. Fringe Benefits 5,204,087 5,975,775 771,688. Purchased Services 5,256,489 6,026,029 769,540. Supplies & Texts 774,609 1,193,807 419,198. Capital Outlay 514,871 554,147 39,276.

6 Transfers Out 2,000 62,000 60,000. Other Expenses 296,882 313,809 16,927. TOT EXPENDITURES 24,405,697 27,795,700 3,390,003. Revenues - Expenditures 2,190,488 144,847. Norwalk City School District FUND BALANCE REPORT. May 31, 2017. Fund Balance Notes General $7,535, Bond Retirement 1,548, Permanent Improvement 578, Building Fund 305, Food Service -55, Staff funds/scholarships 96, Endowments 281, Resale School supply 2, Principal's Funds 92, Local grants 33, OHSAA Tournament 18, Student Activities 110, Athletics 152, Auxiliary Services 143, Preschool state grant -10, Awaiting ODE Funds Data Communications 1, HSTW Awaiting ODE Funds IDEA-B:Special Education -97, Awaiting ODE Funds LEP Title III -3, Awaiting ODE Funds Title I -71, Awaiting ODE Funds Preschool Spec Ed -2, Awaiting ODE Funds Title II-A -6, Awaiting ODE Funds Title VIB and Food service grants Total $10,652, DATE: 06/05/2017 NORWALK CITY PAGE 1.

7 TIME: 16:49:44 SUMMARY CHECK REGISTER - ALL CHECKS (CHECKS). CHECK DATE NUMBER - VENDOR - NAME AMOUNT O-STS-C REC/VD. 75504 05/05/17 7361 Baker, Callie R. W R 05/31/17. 75505 05/05/17 3310 Cummins Bridgeway LLC 2, W R 05/31/17. 75506 05/05/17 3125 Cuyahoga Cty Educational 7, W R 05/31/17. 75507 05/05/17 19744 Fairfax, Donna W R 05/31/17. 75508 05/05/17 334366 Flocabulary W R 05/31/17. 75509 05/05/17 7012 Frontier 3, W R 05/31/17. 75510 05/05/17 19079 Swartz, Gary W R 05/31/17. 75511 05/05/17 8054 Huron County General Health W R 05/31/17. 75512 05/05/17 9044 Institutional Diversified In 5, W R 05/31/17. 75513 05/05/17 334418 Johnnie J. Smith 8, W R 05/31/17. 75514 05/05/17 11219 Kalahari Waterpark Resort W R 05/31/17. 75515 05/05/17 12122 Laser Images W R 05/31/17. 75516 05/05/17 13083 Math-U-See, Inc.

8 W R 05/31/17. 75517 05/05/17 334360 Maxim Healthcare Services, I 1, W R 05/31/17. 75518 05/05/17 13771 MT Business Technologies W R 05/31/17. 75519 05/05/17 14151 Nobil's Sports & Trophies 1, W R 05/31/17. 75520 05/05/17 5040 North Point Educational 69, W R 05/31/17. 75521 05/05/17 3015 Norwalk Glass Co. W R 05/31/17. 75522 05/05/17 18271 R. J. Beck Protective W R 05/31/17. 75523 05/05/17 8154 Schlotterer, Rachel W R 05/31/17. 75524 05/05/17 19432 School Specialty W R 05/31/17. 75525 05/05/17 19275 Sherwin Williams Company W R 05/31/17. 75526 05/05/17 19082 Stanton's Sheet Music W R 05/31/17. 75527 05/05/17 19384 Super Duper School Co. W R 05/31/17. 75528 05/05/17 20167 Teacher's Discovery W R 05/31/17. 75529 05/05/17 20058 Team Sports, Inc. W R 05/31/17. 75530 05/05/17 21102 US Bank 3, W R 05/31/17.

9 75531 05/08/17 4045 Cardinal Bus Sales & Service 179, W W. 75532 05/12/17 8018 Agile Sport Technologies 2, W R 05/31/17. 75533 05/12/17 1386 9, W R 05/31/17. 75534 05/12/17 1411 Automation Mailing & Shippin W R 05/31/17. 75535 05/12/17 22215 Bay Area Council 6, W R 05/31/17. 75536 05/12/17 14234 New Haven Supco W R 05/31/17. 75537 05/12/17 13211 Mason, Carol W R 05/31/17. 75538 05/12/17 3047 Columbus Clay Co W R 05/31/17. 75539 05/12/17 16174 Pat Catan's Craft Center W R 05/31/17. 75540 05/12/17 4019 Demco Inc W R 05/31/17. 75541 05/12/17 334433 Steffanni, Devyn W R 05/31/17. 75542 05/12/17 15211 Orzech, Donnelle W R 05/31/17. 75543 05/12/17 6118 First Communications, LLC W R 05/31/17. 75544 05/12/17 3282 Forte Music W R 05/31/17. 75545 05/12/17 6019 FP Mailing Solutions W R 05/31/17.

10 75546 05/12/17 6037 Fraternal Order of Eagles W W. 75547 05/12/17 8063 Horowitz, Gabby W W. 75548 05/12/17 7026 GreatAmerica Financial W R 05/31/17. 75549 05/12/17 14063 Guarantee Trust Life Insuran W W. 75550 05/12/17 6128 Beabout, Jeanette W R 05/31/17. 75551 05/12/17 10168 Jerry's Auto Plaza W R 05/31/17. 75552 05/12/17 10084 Jostens 1, W R 05/31/17. 75553 05/12/17 20012 Toczek Kristina W R 05/31/17. 75554 05/12/17 12072 Lakeshore Learning Materials W R 05/31/17. 75555 05/12/17 12122 Laser Images W R 05/31/17. 75556 05/12/17 12042 Lynmarie's Coffee On Main, L W R 05/31/17. 75557 05/12/17 13085 Midwest Regional ESC W R 05/31/17. 75558 05/12/17 13398 Morgan Uniforms & Linen Rent 1, W R 05/31/17. 75559 05/12/17 13340 Moto Electric Inc W R 05/31/17. DATE: 06/05/2017 NORWALK CITY PAGE 2.