HomeMy WebLinkAbout10-2017 Departmental Financial ReportPeriod Ending:
Issued By:
City of South Bend
Monthly Departmental Financial Report
Page Contents
2 Fund Guide
3 Narrative
4 Summaries
8 General Fund Departments
22 Special Revenue Funds
60 Debt Service/Capital Project Funds
77 Enterprise Funds
102 Internal Service Funds
109 Trust Funds
112 Redevelopmemt Commission Funds
Distribution
Mayor Pete Buttigieg
Chief of Staff Laura O'Sullivan
Deputy Chief of Staff Suzanna Fritzberg
Common Council
Department Heads
Fiscal Officers
October 31, 2017
Controller
Page # General Fund Page # Enterprise Funds
8 101-0101 Mayor 77 287 Emergency Medical Services Capital
9 101-0104 311 Call Center 78 288 Emergency Medical Services Operating
10 101-0201 City Clerk 79 600 Consolidated Building Fund
11 101-0301 Common Council 80 601 Parking Garages
12 101-0302 WNIT Contract 81 610 Solid Waste Operations
13 101-0401 Admn Finance 82 611 Solid Waste Capital
14 101-0404 Morris PAC 83 620 Water Works Operations
15 101-0405 Palais Royale 84 622 Water Works Capital
16 101-0501 Legal 85 624 Water Works Customer Deposit
17 101-0602 Engineering 86 625 Water Works Sinking
18 101-0801 Police 87 626 Water Works Bond Reserve
19 101-0901 Fire 88 629 Water Works Reserve Operations & Maintenance
20 101-1008 Human Rights 89 640 Sewer Repair Insurance
21 101-1201 Code Enforce 90 641 Sewage Works Operations
91 642 Sewage Works Capital
Special Revenue Funds 92 643 Sewage Works Reserve Operations & Maint.
22 102 Rainy Day 93 649 Sewage Sinking
23 103 Excess Levy 94 653 Sewage Debt Service Reserve
24 201 Parks & Recreation 95 659 Sewer Bond 2011
25 202 Motor Vehicle Highway 96 661 Sewer Bond 2012
26 203 Recreation Nonreverting 97 664 2013A Cost of Issuance Fund
27 209 Studebaker-Oliver Reverting Grants 98 666 2015 Sewer Bond Issuance
28 210 Economic Development State Grants 99 670 Century Center
29 211 Department of Community Investment (DCI)100 671 Century Center Capital
30 212 Dept of Community Investment Grants 101 672 Century Center Energy Conservation Debt Svc
31 216 Police State Seizures
32 217 Gift, Donation, Bequest Internal Service Funds
33 218 Police Curfew Violations 102 222 Central Services
34 219 Unsafe Building 103 224 Central Services Capital
35 220 Law Enforcement Continuing Education 104 226 Liability Insurance
36 221 Landlord Registration 105 278 Take Home Vehicle Police
37 227 Loss Recovery 106 279 IT / Innovation / 311 Call Center
38 244 Emergency Phone System 107 711 Self-Funded Employee Benefits
39 249 Public Safety LOIT 108 713 Unemployment Compensation
40 251 Local Roads & Streets
41 252 Excess Welfare Distribution Trust Funds
42 257 LOIT Special Distribution 109 701 Firefighters Pension
43 258 Human Rights Federal Grant 110 702 Police Pension
44 265 Local Road & Bridge Grant 111 730 City Cemetery
45 271 Eastrace Waterway
46 273 Morris PAC / Palais Royale Marketing Redevelopmemt Commission Funds
47 280 Police Block Grants 112 324 TIF - River West Development Area (Airport)
48 281 Economic Develop Commission-Revenue Bonds 113 422 TIF - West Washington
49 289 HAZMAT 114 425 TIF - Leighton Plaza (Redevelop Retail)
50 291 Indiana River Rescue 115 429 TIF - River East Development Area (NE Dev)
51 292 Police Grants 116 430 TIF - Southside Development #1
52 294 Regional Police Academy 117 432 TIF - Southside Development #3
53 295 COPS MORE Grant 118 435 TIF - Douglas Road
54 299 Police Federal Drug Enforcement 119 436 TIF - River East Residential (NE Res)
55 404 County Option Income Tax 120 433 Redevelopment General
56 408 Economic Development Income Tax 121 439 Certified Technology Park
57 410 Urban Development Action Grant 122 454 Airport Urban Enterprise Zone
58 655 Project Releaf 123 754 Industrial Revolving Fund
59 705 Police K-9 Unit 124 315 Redevelopment Bond - Airport Taxable
125 317 Coveleski Debt Service Reserve
Debt Service/Capital Project Funds 126 328 Redevelopment Bond - Palais Royale
60 313 Football Hall of Fame Debt Service 127 752 South Bend Redevelopment Authority
61 755 South Bend Building Corp 128 756 Smart Streets Debt Service
62 757 Parks Bond Debt Service 129 758 Erskine Village Debt Service
63 377 Professional Sports Development 130 759 Eddy Street Commons Capital
64 401 Coveleski Stadium Capital 131 760 Eddy Street Commons Debt Service
65 403 Zoo Endowment
66 405 Park Nonreverting Capital
67 406 Cumulative Capital Development
68 407 Cumulative Capital Improvement
69 412 Major Moves Construction
70 416 Morris Performing Arts Center Capital
71 434 Community Revitalization Enhancement District
72 450 Palais Royale Historic Preservation
73 677 Football Hall of Fame Capital
74 750 Equipment/Vehicle Leasing
75 751 Parks Bond Capital
76 753 Smart Streets Bond Capital
2
October 2017
The Monthly Departmental Financial Report
The City of South Bend has developed the attached Monthly Departmental Financial Report to provide
current year financial information for each City fund, as well as individual departments within the General
Fund, in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash
balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal
officers to provide an explanation of significant expenditure and staffing variances and spending on major
capital projects. Departmental fiscal officers are asked to complete the monthly financial reports (“blue
sheets”) for their funds and General Fund departments no later than the 18th of the month following the
reporting period. The staff of the Department of Administration & Finance then summarizes the data and
publishes this consolidated report no later than 30 days after the end of the reporting period.
The Monthly Departmental Financial Report supplements—but does not replace—other financial reports
that the City prepares such as the Monthly Financial Report, Controller’s Cash Report, the Department of
Local Government Finance’s Annual Financial Report (AFR), or the Comprehensive Annual Financial
Report (CAFR).
Summary Trends & Observations
As of October 31, 2017, total revenue for the year was $272,392,901, 80% of estimated revenue. As of
October 31, 2016, total revenue received was $223,730,195 within the same funds. Property taxes are
received in June and December each year and are budgeted at $77,024,124 for 2017. Local income tax
(LOIT, COIT and EDIT) receipts are budgeted to be $28.36 million in 2017, to be received in monthly
installments of $2.37 million. In March 2017, the City received a $1 million Community Crossings grant
from INDOT.
As of October 31, 2017, total expenditures were $259,774,518 and outstanding encumbrances were
$37,018,011, a total of $296,792,529 which represents 72% of the amended expenditure budget.
Encumbrances are either holdovers from previous years or obligations for the remainder of the year. If
encumbrances were excluded, expenditures were 63% of the amended expenditure budget at the end of
the period. Total expenditures, excluding encumbrances, were $230,423,895 as of October 31, 2016.
New for 2017, all costs associated with the Department of Innovation & Technology were consolidated
into Fund 279, an internal service fund that already accounts for the 311 Call Center budget. Fund 265
was established to account for the receipt of the Community Crossings grant and matching revenue and
for the payment of expenditures on eligible projects, per the Indiana State Board of Accounts.
Also, several funds were established to integrate the various trustees cash balances into the City’s
regular accounting system.
We hope that you find this Monthly Departmental Financial Report useful in better understanding the
finances of the City of South Bend. If you have any questions regarding this report, please contact the
Department of Administration & Finance.
3
City of South Bend
Monthly Department Financial Report
REVENUE SUMMARY
October 31, 2017
Values
Fund
Type Dept Name
Current Amended
Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance
Percent of
Budget
City Funds
General Fund 59,191,016 1,095,479 36,708,588 34,350,442 22,482,428 62%
Special Revenue
102 Rainy Day 90,000 5,005 85,583 1,478,003 4,417 95%
103 Excess Levy - - - 7 - 0%
201 Parks & Recreation 20,194,318 408,832 9,188,713 7,161,350 11,005,605 46%
202 Motor Vehicle Highway 10,023,367 852,455 8,322,122 8,123,856 1,701,245 83%
203 Recreation Nonreverting 1,157,768 33,284 859,574 831,002 298,194 74%
209 Studebaker-Oliver Reverting Grants 425,787 13,383 335,465 240,803 90,322 79%
210 Economic Development State Grants 262,141 18,176 59,640 1,841,227 202,501 23%
211 Department of Community Investment (DCI)2,294,428 10,494 1,335,680 2,146,079 958,748 58%
212 Dept of Community Investment Grants 5,574,676 58,202 1,738,955 2,267,622 3,835,721 31%
216 Police State Seizures 37,000 116 41,776 31,854 (4,776) 113%
217 Gift, Donation, Bequest 214,094 1,153 183,185 137,544 30,909 86%
218 Police Curfew Violations 1,000 6 254 283 746 25%
219 Unsafe Building 884,475 13,846 600,105 953,997 284,370 68%
220 Law Enforcement Continuing Education 246,175 20,150 227,998 231,227 18,177 93%
221 Landlord Registration 7,000 1,655 6,560 10 440 94%
227 Loss Recovery 9,000 418 7,941 7,583 1,059 88%
249 Public Safety LOIT 7,478,618 622,735 6,231,232 5,664,794 1,247,386 83%
251 Local Roads & Streets 1,692,997 176,319 1,165,671 1,452,364 527,326 69%
257 LOIT Special Distribution 1,623,397 1,475 389,709 4,347,943 1,233,688 24%
258 Human Rights Federal Grant 258,740 218 146,912 199,496 111,828 57%
265 Local Road & Bridge Grant 2,000,000 - 2,000,000 - - 100%
271 Eastrace Waterway 22 - 9 10 13 40%
273 Morris PAC / Palais Royale Marketing 18,450 744 9,615 17,342 8,835 52%
280 Police Block Grants 50 2 33 30 17 65%
281 Economic Develop Commission-Revenue Bonds 300 14 232 212 68 77%
289 HAZMAT 10,250 12 3,264 230 6,986 32%
291 Indiana River Rescue 69,400 4,260 73,248 109,885 (3,848) 106%
294 Regional Police Academy 22,980 3,141 19,131 19,233 3,849 83%
295 COPS MORE Grant 123,500 1,108 54,848 80,500 68,652 44%
299 Police Federal Drug Enforcement 63,000 218 3,584 26,466 59,416 6%
404 County Option Income Tax 11,063,418 914,931 9,301,606 8,666,560 1,761,812 84%
408 Economic Development Income Tax 11,794,400 873,124 10,041,973 8,580,983 1,752,427 85%
410 Urban Development Action Grant 6,110 245 4,487 4,066 1,623 73%
655 Project Releaf 449,153 37,789 377,605 374,529 71,548 84%
705 Police K-9 Unit 2,036 1 24 29 2,012 1%
Special Revenue Total 78,098,050 4,073,513 52,816,734 54,997,119 25,281,316 68%
City Debt Service
313 Football Hall of Fame Debt Service 894,300 18 474,996 871,772 419,304 53%
755 South Bend Building Corp 2,654,500 333 2,652,618 - 1,882 100%
757 Parks Bond Debt Service 391,482 31,815 290,722 - 100,760 74%
760 Eddy Street Commons Debt Service - 233 2,500,233 - (2,500,233) 0%
City Debt Service Total 3,940,282 32,399 5,918,568 871,772 (1,978,286) 150%
Capital Project
377 Professional Sports Development 734,325 - 258,581 683,396 475,744 35%
401 Coveleski Stadium Capital 42,715 39 42,508 41,318 207 100%
403 Zoo Endowment 200 - 151 383 49 76%
405 Park Nonreverting Capital 439,850 130 270,829 7,924 169,021 62%
406 Cumulative Capital Development 485,600 201 262,844 306,277 222,756 54%
407 Cumulative Capital Improvement 437,000 147 294,825 298,717 142,175 67%
412 Major Moves Construction 1,056,786 1,380 1,052,163 1,373,079 4,623 100%
416 Morris Performing Arts Center Capital 106,500 4,958 61,654 81,244 44,846 58%
434 Community Revitalization Enhancement District - - - 573 - 0%
450 Palais Royale Historic Preservation 17,500 1,898 14,308 12,280 3,192 82%
677 Football Hall of Fame Capital 5,000 226 3,994 52,613 1,007 80%
750 Equipment/Vehicle Leasing 5,502,900 766 4,553,201 - 949,699 83%
751 Parks Bond Capital 7,500 588 5,042 - 2,458 67%
753 Smart Streets Bond Capital 58,880 (19,750) 48,115 - 10,765 82%
759 Eddy Street Commons Capital - - 22,500,000 - (22,500,000) 0%
Capital Project Total 8,894,756 (9,417) 29,368,215 2,857,803 (20,473,459) 330%
Enterprise
287 Emergency Medical Services Capital 4,529,349 2,252 3,244,707 2,485,448 1,284,642 72%
288 Emergency Medical Services Operating 6,385,015 522,004 4,594,455 4,738,549 1,790,560 72%
600 Consolidated Building Fund 4,060,706 147,393 3,189,257 3,044,617 871,449 79%
601 Parking Garages 1,163,261 119,935 1,070,080 854,714 93,181 92%
610 Solid Waste Operations 6,103,341 460,975 4,540,077 4,649,256 1,563,264 74%
611 Solid Waste Capital 836,713 85,029 779,537 964,013 57,176 93%
620 Water Works Operations 15,765,622 1,419,155 12,986,535 12,837,808 2,779,087 82%
622 Water Works Capital 24,000 1,073 19,559 21,794 4,441 81%
624 Water Works Customer Deposit 15,000 733 12,726 11,751 2,274 85%
625 Water Works Sinking 2,067,642 328,522 1,659,360 1,710,043 408,282 80%
626 Water Works Bond Reserve 16,000 705 11,938 12,446 4,062 75%
629 Water Works Reserve Operations & Maintenance 176,500 1,276 172,957 245,919 3,543 98%
640 Sewer Repair Insurance 632,424 53,701 547,389 534,464 85,035 87%
641 Sewage Works Operations 37,547,695 3,289,782 32,202,875 32,067,938 5,344,820 86%
642 Sewage Works Capital 4,894,000 503,426 3,895,889 2,547,336 998,111 80%
643 Sewage Works Reserve Operations & Maint.561,755 2,515 558,554 990,955 3,201 99%
649 Sewage Sinking 9,190,024 765,892 7,658,389 7,646,490 1,531,635 83%
653 Sewage Debt Service Reserve 15,000 3,033 17,276 4,038 (2,276) 115%
659 Sewer Bond 2011 201 0 154 1,794 47 77%
661 Sewer Bond 2012 50,000 505 18,597 89,259 31,403 37%
664 2013A Cost of Issuance Fund - - - 32 - 0%
666 2015 Sewer Bond Issuance - - - 114 - 0%
670 Century Center 4,228,683 371,908 3,541,064 3,508,335 687,619 84%
671 Century Center Capital 750 74 722 787 28 96%
672 Century Center Energy Conservation Debt Svc 192,297 4 137,726 187,439 54,571 72%
Enterprise Total 98,455,978 8,079,892 80,859,824 79,155,340 17,596,154 82%
4
City of South Bend
Monthly Department Financial Report
REVENUE SUMMARY
October 31, 2017
Values
Fund
Type Dept Name
Current Amended
Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance
Percent of
Budget
Internal Service
222 Central Services 8,308,569 676,545 6,378,618 6,224,289 1,929,951 77%
224 Central Services Capital 287,600 18 287,388 879 212 100%
226 Liability Insurance 3,576,234 254,535 2,513,764 1,898,111 1,062,470 70%
278 Take Home Vehicle Police 8,360 610 7,679 96,595 681 92%
279 IT / Innovation / 311 Call Center 5,205,034 430,621 4,306,210 401,016 898,824 83%
711 Self-Funded Employee Benefits 17,892,659 1,469,820 14,989,019 14,865,557 2,903,640 84%
713 Unemployment Compensation 2,800 118 2,208 90,984 592 79%
Internal Service Total 35,281,256 2,832,266 28,484,886 23,577,431 6,796,370 81%
Trust & Agency
701 Firefighters Pension 4,925,212 - 4,921,423 4,872,074 3,789 100%
702 Police Pension 6,223,679 12 6,221,569 6,008,857 2,110 100%
730 City Cemetery 280 14 242 221 38 86%
Trust & Agency Total 11,149,171 26 11,143,234 10,881,152 5,937 100%
City Funds Total 295,010,509 16,104,158 245,300,050 206,691,058 49,710,459 83%
Redevelopment Commission Controlled Funds
Tax Increment Financing
324 TIF - River West Development Area (Airport) 23,789,389 212,113 10,920,549 11,448,833 12,868,840 46%
422 TIF - West Washington 442,000 1,054 215,160 295,145 226,840 49%
425 TIF - Leighton Plaza (Redevelop Retail) 197,014 3,553 91,810 108,542 105,204 47%
429 TIF - River East Development Area (NE Dev)3,236,467 3,955 1,651,258 1,299,538 1,585,209 51%
430 TIF - Southside Development #1 3,916,127 3,426 2,732,180 1,296,373 1,183,947 70%
432 TIF - Southside Development #3 8,520 - 8,519 38,568 1 100%
435 TIF - Douglas Road 328,208 20 219,030 232,274 109,178 67%
436 TIF - River East Residential (NE Res)3,300,903 - 2,320,763 2,274,510 980,140 70%
Tax Increment Financing Total 35,218,628 224,120 18,159,270 16,993,784 17,059,358 52%
Redevelopment
433 Redevelopment General 135 4 66 67 70 49%
439 Certified Technology Park 302,625 299 262,148 17,017 40,477 87%
454 Airport Urban Enterprise Zone 3,900 188 3,219 2,938 681 83%
754 Industrial Revolving Fund 223,824 51,814 125,552 - 98,272 56%
Redevelopment Total 530,484 52,304 390,985 20,022 139,499 74%
Debt Service
315 Redevelopment Bond - Airport Taxable 14,000 507 8,694 8,013 5,306 62%
317 Coveleski Debt Service Reserve 5,000 252 4,306 3,930 694 86%
328 Redevelopment Bond - Palais Royale 20,000 847 14,541 13,389 5,459 73%
752 South Bend Redevelopment Authority 3,868,669 682 3,693,357 - 175,312 95%
756 Smart Streets Debt Service 857,284 329 858,917 - (1,633) 100%
758 Erskine Village Debt Service 3,961,782 - 3,961,781 - 1 100%
Debt Service Total 8,726,735 2,617 8,541,597 25,332 185,138 98%
Redevelopment Commission Controlled Funds Total 44,475,847 279,042 27,091,852 17,039,137 17,383,995 61%
Grand Total 339,486,356 16,383,200 272,391,901 223,730,195 67,094,455 80%
5
City of South Bend
Monthly Department Financial Report
EXPENDITURE SUMMARY
October 31, 2017
Values
Fund
Type Department Name
Current Amended
Budget
Current Month
Actual Current YTD Actual Prior YTD Actual
Current
Encumbrances Budget Balance
Percent of
Budget*
City Funds
General Fund
101-0101 Mayor's Office 872,923 78,827 668,293 539,150 665 203,966 77%
101-0104 311 Call Center - - - 3,810 - - 0%
101-0201 City Clerk 536,216 40,750 381,935 312,414 28,708 125,573 77%
101-0301 Common Council 571,148 33,663 369,936 397,309 62,616 138,596 76%
101-0302 WNIT Contract 43,000 - 43,000 43,000 - - 100%
101-0401 Administration & Finance 2,476,351 197,229 1,984,047 1,611,910 29,446 462,857 81%
101-0404 Morris Performing Arts Center 1,271,039 234,731 811,979 837,504 6,438 452,622 64%
101-0405 Palais Royale 530,200 86,714 266,471 360,977 6,031 257,698 51%
101-0501 Legal Department 1,158,567 69,972 885,626 797,876 5,204 267,738 77%
101-0602 Engineering 1,485,157 97,783 975,029 881,609 108,134 401,994 73%
101-0801 Police Department 29,668,433 2,294,848 22,151,503 19,990,819 1,017,460 6,499,470 78%
101-0802 Communications Center - - - 1,232,510 - - 0%
101-0901 Fire Department 21,111,466 1,741,647 16,288,642 14,989,145 122,473 4,700,351 78%
101-1008 Human Rights 425,805 29,160 337,871 286,081 4,339 83,595 80%
101-1201 Code Enforcement - - - 202,104 - - 0%
General Fund Total 60,150,305 4,905,322 45,164,332 42,486,218 1,391,513 13,594,461 77%
Special Revenue
103 Excess Levy - - - 3,673 - - 0%
201 Parks & Recreation 19,042,888 1,242,437 10,849,717 9,161,279 574,432 7,618,739 60%
202 Motor Vehicle Highway 11,765,531 818,495 7,539,965 7,108,098 680,051 3,545,515 70%
203 Recreation Nonreverting 1,599,683 70,450 863,990 816,369 111,314 624,379 61%
209 Studebaker-Oliver Reverting Grants 539,393 26,237 280,759 473,198 158,634 100,000 81%
210 Economic Development State Grants 509,757 - 54,008 1,687,243 185,120 270,629 47%
211 Department of Community Investment (DCI)2,775,376 165,449 1,836,642 1,960,477 153,619 785,115 72%
212 Dept of Community Investment Grants 5,455,838 343,006 1,824,957 2,387,951 2,535,146 1,095,735 80%
216 Police State Seizures 116,000 - - 3,110 - 116,000 0%
217 Gift, Donation, Bequest 241,700 - 194,856 97,000 5,351 41,492 83%
218 Police Curfew Violations 1,000 - - - - 1,000 0%
219 Unsafe Building 905,479 94,695 695,037 622,534 79,545 130,897 86%
220 Law Enforcement Continuing Education 788,422 59,013 466,516 282,229 48,090 273,815 65%
221 Landlord Registration 1,000 - 10 - - 990 1%
227 Loss Recovery 598,675 - 121,212 25,169 150,863 326,600 45%
244 Emergency Phone System 33,671 - 33,671 - - 0 100%
249 Public Safety LOIT 7,462,645 518,805 6,084,573 5,256,754 - 1,378,072 82%
251 Local Roads & Streets 2,308,544 146,800 1,048,379 1,093,932 198,751 1,061,414 54%
252 Excess Welfare Distribution 8 - - - - 8 0%
257 LOIT Special Distribution 3,757,457 331,499 1,701,061 303,635 1,667,837 388,559 90%
258 Human Rights Federal Grant 201,773 8,794 114,052 153,686 8,666 79,056 61%
265 Local Road & Bridge Grant 2,000,000 1,400 1,464 - 1,443,225 555,311 72%
271 Eastrace Waterway 1,367 - 1,353 - - 14 99%
273 Morris PAC / Palais Royale Marketing 21,675 - 5,673 4,212 - 16,002 26%
289 HAZMAT 10,431 - 5,768 7,609 - 4,663 55%
291 Indiana River Rescue 117,349 981 94,714 42,384 184 22,451 81%
292 Police Grants 35,805 226 28,178 33,239 4,756 2,871 92%
294 Regional Police Academy 22,500 254 7,542 7,495 - 14,958 34%
295 COPS MORE Grant 263,767 19,534 155,879 201,720 41,406 66,482 75%
299 Police Federal Drug Enforcement 286,337 79,491 149,201 26,413 - 137,136 52%
404 County Option Income Tax 12,071,593 1,134,105 9,769,240 11,446,324 303,331 1,999,022 83%
408 Economic Development Income Tax 11,559,184 215,858 8,125,558 6,975,448 825,191 2,608,435 77%
410 Urban Development Action Grant 126,144 31,814 126,142 238,173 - 2 100%
655 Project Releaf 537,171 28,300 378,831 463,915 1,750 156,590 71%
705 Police K-9 Unit 2,020 - - 1,044 - 2,020 0%
Special Revenue Total 85,160,183 5,337,641 52,558,947 50,884,312 9,177,264 23,423,972 72%
City Debt Service
313 Football Hall of Fame Debt Service 1,268,999 800 1,144,220 1,271,000 - 124,779 90%
755 South Bend Building Corp 2,643,214 - 2,642,214 - - 1,000 100%
757 Parks Bond Debt Service 391,482 - 390,481 - - 1,001 100%
760 Eddy Street Commons Debt Service - - - - - - 0%
City Debt Service Total 4,303,695 800 4,176,915 1,271,000 - 126,780 97%
Capital Project
377 Professional Sports Development 827,955 - 827,955 838,051 - - 100%
401 Coveleski Stadium Capital 30,000 61,597 78,597 25,430 9,829 (58,426) 295%
403 Zoo Endowment 50,050 - 50,049 - - 1 100%
405 Park Nonreverting Capital 553,024 (22,800) 396,061 132,783 17,068 139,895 75%
406 Cumulative Capital Development 476,500 10,711 440,885 502,013 - 35,615 93%
407 Cumulative Capital Improvement 372,250 800 372,050 368,250 - 200 100%
412 Major Moves Construction 2,470,708 93,796 511,527 658,833 1,058,559 900,622 64%
416 Morris Performing Arts Center Capital 401,144 - 17,878 32,184 204,200 179,065 55%
434 Community Revitalization Enhancement District - - - 2,977 - - 0%
450 Palais Royale Historic Preservation 5,000 - 627 - - 4,373 13%
677 Football Hall of Fame Capital 81,091 2,067 40,649 57,029 2,996 37,445 54%
750 Equipment/Vehicle Leasing 5,500,000 912,178 3,239,464 - 1,679,544 580,992 89%
751 Parks Bond Capital 3,500,000 130,079 1,035,395 - 27,221 2,437,384 30%
753 Smart Streets Bond Capital 10,000,000 406,356 4,907,828 - - 5,092,172 49%
759 Eddy Street Commons Capital - - 396,250 - - (396,250) 0%
Capital Project Total 24,267,722 1,594,784 12,315,216 2,617,550 2,999,417 8,953,089 63%
Enterprise
287 Emergency Medical Services Capital 3,991,466 138,888 2,495,785 1,355,187 738,204 757,477 81%
288 Emergency Medical Services Operating 6,137,914 392,910 4,357,657 4,721,115 106,930 1,673,327 73%
600 Consolidated Building Fund 3,785,643 300,045 2,894,081 2,671,383 41,316 850,247 78%
601 Parking Garages 1,247,254 178,986 822,548 580,097 265,176 159,530 87%
610 Solid Waste Operations 5,662,910 425,165 4,377,455 4,599,984 105,856 1,179,599 79%
611 Solid Waste Capital 1,135,613 83,924 1,055,794 869,797 - 79,819 93%
620 Water Works Operations 17,727,254 1,281,890 12,755,732 12,894,506 673,321 4,298,201 76%
622 Water Works Capital 1,414,466 2 404,551 310,392 463,906 546,009 61%
624 Water Works Customer Deposit 15,000 733 12,441 9,783 - 2,559 83%
625 Water Works Sinking 2,054,891 522 312,020 352,001 - 1,742,871 15%
626 Water Works Bond Reserve 16,000 - 10,000 6,531 - 6,000 63%
629 Water Works Reserve Operations & Maintenance 23,000 1,276 21,231 15,552 - 1,769 92%
6
City of South Bend
Monthly Department Financial Report
EXPENDITURE SUMMARY
October 31, 2017
Values
Fund
Type Department Name
Current Amended
Budget
Current Month
Actual Current YTD Actual Prior YTD Actual
Current
Encumbrances Budget Balance
Percent of
Budget*
640 Sewer Repair Insurance 634,509 43,442 446,510 390,865 43,708 144,290 77%
641 Sewage Works Operations 44,831,185 4,217,627 32,011,181 28,320,351 3,654,996 9,165,009 80%
642 Sewage Works Capital 8,051,255 402,622 3,949,930 3,711,340 1,116,250 2,985,074 63%
643 Sewage Works Reserve Operations & Maint.30,000 2,515 40,944 28,448 - (10,944) 136%
649 Sewage Sinking 9,163,754 - 1,081,626 1,148,456 - 8,082,128 12%
659 Sewer Bond 2011 51,888 - 51,687 162,482 - 201 100%
661 Sewer Bond 2012 3,010,364 235,348 2,263,409 10,167,911 632,186 114,769 96%
664 2013A Cost of Issuance Fund - - - 4,538 - - 0%
666 2015 Sewer Bond Issuance - - - 9,205 - - 0%
670 Century Center 4,194,310 360,110 3,404,094 3,469,269 - 790,216 81%
671 Century Center Capital - - - 130,547 - - 0%
672 Century Center Energy Conservation Debt Svc 192,297 96,169 191,297 236,132 - 1,000 99%
Enterprise Total 113,370,973 8,162,171 72,959,972 76,165,871 7,841,847 32,569,154 71%
Internal Service
222 Central Services 8,564,643 630,259 6,532,369 6,005,489 652,907 1,379,367 84%
224 Central Services Capital 326,025 25,071 199,182 206,190 6,255 120,587 63%
226 Liability Insurance 3,587,586 202,052 2,660,951 1,749,238 35,410 891,225 75%
278 Take Home Vehicle Police 10,000 - 972 53 - 9,028 10%
279 IT / Innovation / 311 Call Center 5,205,034 558,378 2,944,271 401,018 269,096 1,991,668 62%
711 Self-Funded Employee Benefits 17,803,200 1,206,650 12,522,851 12,751,526 319,227 4,961,122 72%
713 Unemployment Compensation 84,105 4,323 54,270 59,737 11,000 18,835 78%
Internal Service Total 35,580,593 2,626,732 24,914,865 21,173,250 1,293,896 9,371,832 74%
Trust & Agency
701 Firefighters Pension 5,098,269 378,976 3,864,781 4,344,393 - 1,233,488 76%
702 Police Pension 6,423,889 507,795 5,121,881 5,339,534 - 1,302,008 80%
730 City Cemetery 6,000 599 599 - - 5,401 10%
Trust & Agency Total 11,528,158 887,370 8,987,261 9,683,927 - 2,540,897 78%
City Funds Total 334,361,629 23,514,820 221,077,508 204,282,128 22,703,937 90,580,185 73%
Redevelopment Commission Controlled Funds
Tax Increment Financing
324 TIF - River West Development Area (Airport)39,618,887 2,086,165 15,899,632 16,336,711 11,206,368 12,512,887 68%
422 TIF - West Washington 1,428,292 4,008 72,591 13,612 445,401 910,300 36%
425 TIF - Leighton Plaza (Redevelop Retail)158,166 6,020 102,638 128,631 - 55,528 65%
429 TIF - River East Development Area (NE Dev)10,602,696 127,537 1,604,844 1,837,792 1,904,128 7,093,724 33%
430 TIF - Southside Development #1 6,917,426 52,826 405,203 3,465,246 752,977 5,759,246 17%
432 TIF - Southside Development #3 4,878,795 - 4,866,784 489,503 - 12,011 100%
435 TIF - Douglas Road 344,216 116 335,724 341,288 4,200 4,292 99%
436 TIF - River East Residential (NE Res)3,430,231 2,331 3,166,584 3,368,278 1,000 262,647 92%
Tax Increment Financing Total 67,378,709 2,279,003 26,454,000 25,981,060 14,314,074 26,610,635 61%
Redevelopment
433 Redevelopment General 4,500 - 1,133 - - 3,367 25%
439 Certified Technology Park 2,200,000 - 1,800,000 142,913 - 400,000 82%
454 Airport Urban Enterprise Zone 50,000 - - - - 50,000 0%
754 Industrial Revolving Fund 157,000 24,153 85,186 - - 71,814 54%
Redevelopment Total 2,411,500 24,153 1,886,319 142,913 - 525,181 78%
Debt Service
315 Redevelopment Bond - Airport Taxable 14,000 507 8,502 6,663 - 5,498 61%
328 Redevelopment Bond - Palais Royale 15,000 847 14,220 11,132 - 780 95%
752 South Bend Redevelopment Authority 4,603,405 - 4,561,503 - - 41,902 99%
756 Smart Streets Debt Service 1,252,284 - 1,249,569 - - 2,715 100%
758 Erskine Village Debt Service 4,522,918 - 4,522,898 - - 20 100%
Debt Service Total 10,407,607 1,354 10,356,692 17,795 - 50,915 100%
Redevelopment Commission Controlled Funds Total 80,197,816 2,304,510 38,697,011 26,141,767 14,314,074 27,186,731 66%
Grand Total 414,559,445 25,819,330 259,774,518 230,423,895 37,018,011 117,766,916 72%
* Includes year to date expenditures and encumbrances
7
Department Name Fund/Dept No.101-0101
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 872,323 78,827 668,223 538,540 - 204,100 77%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 600 - 70 610 - 530 12%
Transfers In - - - - - - 0%
Total Revenue 872,923 78,827 668,293 539,150 - 204,630 77%
Expenditures
Personnel 704,849 62,862 527,133 491,629 - 177,716 75%
Supplies 3,119 35 975 1,045 665 1,479 53%
Services 163,755 15,821 139,081 46,035 - 24,674 85%
Debt Service 1,200 109 1,103 441 - 97 92%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 872,923 78,827 668,293 539,150 665 203,966 77%
Net - - - - (665) 665
Cash Balance - -
Staffing Budget Actual
Full Time 7.00 8.00
Part-Time /Seasonal/Temporary 2.00 -
Total 9.00 8.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
Leading the community to become a model city through formulating policy, directing operations, and responding to customer concerns. The Mayor
is the elected chief executive officer of the city.
Increase from 2016 service category due mainly to the increase in Interfund Allocations for IT which allow for all departments to see the full cost of
IT and other administration functions that they would not have seen in the past. Also, health insurance rose approximately 8% per employee.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Mayor's Office
General Fund
City Funds
8
Department Name Fund/Dept No.101-0104
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 3,810 - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 3,810 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - 1,629 - - 0%
Services - - - 2,181 - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - 3,810 - - 0%
Net - - - - - -
Cash Balance - -
Department Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
In 2013, the Central 311 Call Center was established to handle citizen telephone calls in an efficient and effective manner. It provides citizens with a
"one-stop" shop to contact city departments with inquiries and service requests.
In 2016, the budget was moved to a new internal service fund (Fund 279).
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
311 Call Center
General Fund
City Funds
9
Department Name Fund/Dept No.101-0201
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 536,216 40,750 381,935 312,414 - 154,281 71%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 536,216 40,750 381,935 312,414 - 154,281 71%
Expenditures
Personnel 349,234 25,469 264,283 246,816 - 84,951 76%
Supplies 7,800 2,104 4,536 6,356 601 2,663 66%
Services 179,182 13,177 113,116 59,243 28,107 37,959 79%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 536,216 40,750 381,935 312,414 28,708 125,573 77%
Net - - - - (28,708) 28,708
Cash Balance - -
Staffing Budget Actual
Full Time 5.00 5.00
Part-Time /Seasonal/Temporary - -
Total 5.00 5.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
We ensure the integrity and accuracy of City records, and liaise between the Common Council, City Administration and South Bend residents
fostering relationships and common ground.
We accomplish our mission by:
- Serving as a responsible steward of information and historical artifacts
- Empowering the community to engage
- Supporting open and transparent government
- Striving for the highest degree of excellence in customer service
Expenditures are in line with budgeted expectations for 2017, encumbrances from 2016 account for the large differences. Funds were encumbered
in 2016 to pay for Granicus software for Boards and Commissions (PO: $6450, YTD Spent: $4950), Dictation Services for past and current
meetings (PO: $4,000, YTD Spent: $3700), Electrical Work (PO: $9,000, YTD Spent: $0), the New Legislative Resource Center (POs and YTD
Spent: $3,678), Ongoing in-house remodel (PO and YTD Spent: $6,443). Value Purchase Orders make it look like we've spent more than we have.
These include additions to the City's code book through Municode (PO: $10,000, YTD Spent: $8,068.20), Legal Representation (PO: $2,800, YTD
Spent: $1012.5), and Legal Advertising (POs: $20,000, YTD Spent: $10,566.73).
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
City Clerk
General Fund
City Funds
10
Department Name Fund/Dept No.101-0301
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 571,148 33,663 369,936 397,309 - 201,212 65%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 571,148 33,663 369,936 397,309 - 201,212 65%
Expenditures
Personnel 304,402 23,762 235,950 233,688 112 68,340 78%
Supplies 4,503 160 2,123 6,422 217 2,163 52%
Services 262,243 9,741 131,864 157,199 62,286 68,093 74%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 571,148 33,663 369,936 397,309 62,616 138,596 76%
Net - - - - (62,616) 62,616
Cash Balance - -
Staffing Budget Actual
Full Time 9.00 9.00
Part-Time /Seasonal/Temporary - -
Total 9.00 9.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The fiscal body of the City, which exists to make certain that our City Government is always responsive to the needs of our residents & that the
betterment of South Bend is always our highest priority. There are nine (9) Council Members.
Funds encumbered and spent from 2016 are the following: New furniture for the Council ($19,119.04), new furniture for the Council Informal
Meeting Room ($12,366.24), and new AV equipment for the Council Informal Meeting Room ($3,572.21). Large Value Purchase Orders account
for much of the encumbrances. These include the Council Attorney (PO: $60,000, Spent: $25,761.50) and Additional Legal Services (PO: $29,000,
Spent: $1376.00).
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Common Council
General Fund
City Funds
11
Department Name Fund/Dept No.101-0302
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 43,000 - 43,000 43,000 - - 100%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 43,000 - 43,000 43,000 - - 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 43,000 - 43,000 43,000 - - 100%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 43,000 - 43,000 43,000 - - 100%
Net - - - - - -
Cash Balance - -
Department Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
In 2012 the City, along with the City of Mishawaka and St. Joseph County, entered into an agreement with WNIT Public Television for the
establishment and maintenance of a public access channel which is used to broadcast all public Common Council meetings, among other things.
The allocation of costs is $43,000 to South Bend, $13,000 to Mishawaka and $29,000 to Saint Joseph County. The current WNIT contract expires
February 2, 2020.
This annual expenditure was previously paid from the Council department (101-0301) but was segregated upon the Council's request.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
WNIT Contract
General Fund
City Funds
12
Department Name Fund/Dept No.101-0401
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 2,464,047 197,218 1,971,774 1,595,746 - 492,273 80%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 12,304 11 12,273 16,163 - 31 100%
Transfers In - - - - - - 0%
Total Revenue 2,476,351 197,229 1,984,047 1,611,910 - 492,304 80%
Expenditures
Personnel 2,053,815 171,010 1,629,116 1,454,888 - 424,699 79%
Supplies 25,158 555 20,744 17,776 1,668 2,746 89%
Services 392,304 25,021 329,529 133,195 27,778 34,997 91%
Debt Service 5,074 643 4,659 6,050 - 415 92%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,476,351 197,229 1,984,047 1,611,910 29,446 462,857 81%
Net - - - - (29,446) 29,446
Cash Balance - -
Staffing Budget Actual
Full Time 24.00 23.00
Part-Time /Seasonal/Temporary - -
Total 24.00 23.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
Provide financial management and administrative services to City operations including finance and accounting services, human resources, risk
management, benefit administration, and purchasing management.
The larges encumbrances for services is related to an outstanding contract for diversity consulting. The encumbrances for supplies is mainly the
value purchase order with Office Depot.
In October, the Chief Financial Officer left for a job with the County, bringing the staffing level down to 23 out of 24 budgeted.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Administration & Finance
General Fund
City Funds
13
Department Name Fund/Dept No.101-0404
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 294,394 201,302 151,072 (252,783) - 143,322 51%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 488,000 26,087 325,773 470,746 - 162,227 67%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 488,645 7,342 335,135 619,540 - 153,510 69%
Transfers In - - - - - - 0%
Total Revenue 1,271,039 234,731 811,979 837,504 - 459,060 64%
Expenditures
Personnel 510,299 34,675 357,508 609,885 - 152,791 70%
Supplies 7,697 173 3,646 10,498 2,083 1,969 74%
Services 753,043 199,882 450,825 217,120 4,355 297,863 60%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,271,039 234,731 811,979 837,504 6,438 452,622 64%
Net - - - - (6,438) 6,438
Cash Balance - -
Staffing Budget Actual
Full Time 6.60 7.00
Part-Time /Seasonal/Temporary 4.00 4.00
Total 10.60 11.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This department accounts for the operating costs of the Morris Performing Arts Center, the Premier Performing Arts Center in this region of the
country. It provides improved quality of life to the City citizens, serves as an economic catalyst in the City, and fosters historic preservation of
landmark City venues.
Starting with 2017, the position of Executive Administrative Assistant was replaced with Operations Manager.
As part of the Venues, Parks & Arts consolidation, maintenance and marketing costs are charged to Fund 201 and then allocated back to the Morris
and Palais. However, maintenance and marketing expenditures have been allocated only inclusive of August, causing the year-to-date services
expenditures to come in under budget.
There are no Capital Expenses budgeted for this year. This is an Operating Budget. By Ordinance, Fund 416 is used to support renovating,
remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Morris Performing Arts Center
General Fund
City Funds
14
Department Name Fund/Dept No.101-0405
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 170,698 56,977 (11,541) 93,088 - 182,239 -7%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 332,072 27,897 257,793 243,423 - 74,279 78%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 27,430 1,840 20,219 24,466 - 7,211 74%
Transfers In - - - - - - 0%
Total Revenue 530,200 86,714 266,471 360,977 - 263,729 50%
Expenditures
Personnel 142,131 9,998 93,168 208,216 - 48,963 66%
Supplies 3,398 230 1,024 11,282 1,174 1,200 65%
Services 384,671 76,486 172,279 141,479 4,857 207,535 46%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 530,200 86,714 266,471 360,977 6,031 257,698 51%
Net - - - - (6,031) 6,031
Cash Balance - -
Staffing Budget Actual
Full Time 2.40 2.40
Part-Time /Seasonal/Temporary - -
Total 2.40 2.40
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This department accounts for the operating expenses of the Palais Royale, a premier banquet/meeting facility. It provides exquisite food and
beverage catering service, for both social events and business events, and supports South Bend's downtown economy. The Palais Royale is
distinguished by its history and ambiance.
As part of the Venues, Parks & Arts consolidation, maintenance and marketing costs are charged to Fund 201 and then allocated back to the Morris
and Palais. However, maintenance and marketing expenditures have been allocated only inclusive of August, causing the year-to-date services
expenditures to come in under budget.
Capital projects for the Palais Royale are located in the Palais Royale Historic Preservation Fund #450.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Palais Royale
General Fund
City Funds
15
Department Name Fund/Dept No.101-0501
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 1,083,190 69,962 828,517 721,421 - 254,673 76%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 75,377 10 57,109 76,454 - 18,268 76%
Transfers In - - - - - - 0%
Total Revenue 1,158,567 69,972 885,626 797,876 - 272,941 76%
Expenditures
Personnel 966,603 59,155 727,290 765,205 - 239,313 75%
Supplies 5,977 893 4,314 1,008 5,204 (3,541) 159%
Services 184,715 9,923 153,068 30,710 - 31,647 83%
Debt Service 1,272 - 953 953 - 319 75%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,158,567 69,972 885,626 797,876 5,204 267,738 77%
Net - - - - (5,204) 5,204
Cash Balance - -
Staffing Budget Actual
Full Time 11.00 9.00
Part-Time /Seasonal/Temporary 1.00 1.00
Total 12.00 10.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Legal Department provides quality legal representation to the City of South Bend’s Mayor, departments, commissions and agencies with a
dedicated and professionally-skilled staff, efficiently and cost effectively, in furtherance of the City’s strategic goals, and preserving the legal and
ethical integrity of the City.
A majority of the supplies budget is already expended due to the purchasing of new furniture for the office renovation.
The Legal Department has two vacancies: In August, the Corporate Counsel attorney accepted a position with another organization. As a result, the
Police & Fire attorney was promoted to Corporate Counsel attorney. In September, the Assistant City Attorney accepted the position of Director of
Purchasing under the Administration & Finance Department.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Legal Department
General Fund
City Funds
16
Department Name Fund/Dept No.101-0602
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 1,161,693 87,203 879,506 824,548 - 282,187 76%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits 100,000 10,500 86,530 16,655 - 13,470 87%
Charges for Services 6,127 - 8,002 2,400 - (1,875) 131%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 217,337 80 991 38,006 - 216,346 0%
Transfers In - - - - - - 0%
Total Revenue 1,485,157 97,783 975,029 881,609 - 510,128 66%
Expenditures
Personnel 841,636 58,368 603,523 556,894 195 237,918 72%
Supplies 34,113 6,404 20,503 52,936 4,893 8,717 74%
Services 581,300 33,011 325,068 256,246 102,393 153,840 74%
Debt Service 28,108 - 25,935 15,533 654 1,519 95%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,485,157 97,783 975,029 881,609 108,134 401,994 73%
Net - - - - (108,134) 108,134
Cash Balance - -
Staffing Budget Actual
Full Time 7.93 5.11
Part-Time /Seasonal/Temporary 1.41 0.47
Total 9.34 5.58
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Engineering Department oversees the design and execution of the City's construction projects.
Other income includes reimbursement from the River West TIF for 100% of the salary of an engineer.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Engineering
General Fund
City Funds
17
Department Name Fund/Dept No.101-0801
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 29,000,025 2,284,425 21,564,560 19,697,381 - 7,435,465 74%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations 7,500 - - - - 7,500 0%
Other Income 660,908 10,423 586,943 293,439 - 73,965 89%
Transfers In - - - - - - 0%
Total Revenue 29,668,433 2,294,848 22,151,503 19,990,819 - 7,516,930 75%
Expenditures
Personnel 23,071,143 1,767,058 17,951,299 17,900,112 - 5,119,844 78%
Supplies 1,306,776 30,197 189,274 203,813 976,598 140,904 89%
Services 5,135,514 497,157 3,863,473 1,882,087 40,862 1,231,178 76%
Debt Service 155,000 436 147,457 4,808 - 7,543 95%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 29,668,433 2,294,848 22,151,503 19,990,819 1,017,460 6,499,470 78%
Net - - - - (1,017,460) 1,017,460
Cash Balance - -
Staffing Budget Actual
Full Time 248.00 236.00
Part-Time /Seasonal/Temporary 60.00 5.00
Total 308.00 241.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The South Bend Police Department exists to serve and protect our community with the highest quality emergency services protecting life and
property.
This fund includes the expenditures for 192 of the 247 budgeted Police officers and 44 full time civilian staff. Fund 249 contains the funding for 43
of the 247 Police officers that are funded by the LOIT. The $896,046 encumbrance amount for Supplies is the cost of replacing video cameras for
patrol vehicles.
Police cars are leased out of COIT Fund #404.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police Department
General Fund
City Funds
18
Department Name Fund/Dept No.101-0901
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 21,068,583 1,741,622 16,246,235 14,969,752 - 4,822,348 77%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 500 25 25 175 - 475 5%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 42,383 - 42,382 19,219 - 1 100%
Transfers In - - - - - - 0%
Total Revenue 21,111,466 1,741,647 16,288,642 14,989,145 - 4,822,824 77%
Expenditures
Personnel 17,624,592 1,312,044 13,438,166 13,460,335 6,590 4,179,836 76%
Supplies 502,435 41,311 237,127 245,899 54,938 210,370 58%
Services 2,984,439 388,292 2,613,349 1,282,911 60,944 310,146 90%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 21,111,466 1,741,647 16,288,642 14,989,145 122,473 4,700,351 78%
Net - - - - (122,473) 122,473
Cash Balance - -
Staffing Budget Actual
Full Time 180.00 183.00
Part-Time /Seasonal/Temporary - -
Total 180.00 183.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The South Bend Fire Department exists to provide our community with the highest quality emergency services protecting life and property through
education, response, and dynamic outreach.
The South Bend Fire Department is budgeted to have 253 sworn firefighters, 6 recruits and 7 civilian full time employees. 35 firefighters are paid
directly through the Public Safety LOIT (Fund 249). 47 Sworn and 4 civilian employees' costs are allocated to EMS Operations (Fund 288).
There is a lengthy recruitment process every 2 years. The Fire Department hires individuals in groups of 6-10 as needed. The Fire Department also
employs civilian administrative staff who handle payroll, purchasing, and billing for ambulance services. There was a transfer of expenses for
ambulance maintenance charges to Fund 288 in August. August also had the Repairs and Maintenance post to Fund 404 those expenses will
return to fund 101 in October.
In October, 6 new recruits were sworn in, causing the number of full-time employees to exceed budget.
Expenses related to purchasing Fire Department capital equipment and capital improvements are not paid out of the General Fund. All capital
projects relating to the Fire Department operations are run through the EMS Capital Fund #287.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Fire Department
General Fund
City Funds
19
Department Name Fund/Dept No.101-1008
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 425,805 29,160 337,871 286,081 - 87,934 79%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 425,805 29,160 337,871 286,081 - 87,934 79%
Expenditures
Personnel 294,036 18,669 231,761 232,045 - 62,275 79%
Supplies 1,037 - 388 552 500 149 86%
Services 130,732 10,491 105,722 53,484 3,839 21,171 84%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 425,805 29,160 337,871 286,081 4,339 83,595 80%
Net - - - - (4,339) 4,339
Cash Balance - -
Staffing Budget Actual
Full Time 4.00 4.00
Part-Time /Seasonal/Temporary - -
Total 4.00 4.00
Department Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Human Rights mission is to educate and promote fair housing as well as ensure that all citizens receive equal employment opportunity.
Expenditures are higher this year in the services category. This is due to a roughly 1,200% increase in allocation costs related to information
technology.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Human Rights
General Fund
City Funds
20
Department Name Fund/Dept No.101-1201
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - 202,104 - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 202,104 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - 202,104 - - 0%
Total Expenditures - - - 202,104 - - 0%
Net - - - - - -
Cash Balance - -
Department Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This department was transferred to the Consolidated Building Fund (600) in 2014.
In 2016, $202,164 was transferred to the Unsafe Building Fund 219.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Code Enforcement
General Fund
City Funds
21
Fund Name Fund Number 102
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - 1,405,850 - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 90,000 5,005 85,583 72,153 - 4,417 95%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 90,000 5,005 85,583 1,478,003 - 4,417 95%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 90,000 5,005 85,583 1,478,003 - 4,417
Cash Balance 10,269,956 10,170,110
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to accumulate cash reserves for unforeseen purposes. This fund receives from time to time certain "catch up" distributions of
COIT and EDIT monies from the State that are required to be deposited into this fund. This fund is used for mid-year or year-end advances to other
funds that have cash shortages and the advances must be paid back within six months.
The establishment of a Rainy Day Fund is looked upon favorably by bond rating agencies and is one of the factors resulting in South Bend's good
AA bond rating with Standard & Poor's.
No expenditures are budgeted in this fund.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Rainy Day
Special Revenue Funds
City Funds
22
Fund Name Fund Number 103
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - 7 - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 7 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - 3,673 - - 0%
Total Expenditures - - - 3,673 - - 0%
Net - - - (3,665) - -
Cash Balance - -
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
Excess levy distributions of property taxes that are received from the State are deposited here. They are used to reduce future property tax levies.
This fund was closed in August 2016.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Excess Levy
Special Revenue Funds
City Funds
23
Fund Name Fund Number 201
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 8,900,000 - 4,976,456 4,312,626 - 3,923,544 56%
Local Income Taxes - - - - - - 0%
Other Taxes 670,000 - 379,124 323,330 - 290,876 57%
Grants/Intergovernmental 5,095,000 - - - - 5,095,000 0%
Licenses & Permits - - - - - - 0%
Charges for Services 3,093,558 409,956 1,959,230 1,596,467 - 1,134,328 63%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 25,000 1,760 25,964 21,781 - (964) 104%
Bond Proceeds - - - - - - 0%
Donations 1,500 - 1,500 650 - - 100%
Other Income 1,783,913 (2,885) 1,321,092 906,498 - 462,821 74%
Transfers In 625,347 - 525,347 - - 100,000 84%
Total Revenue 20,194,318 408,832 9,188,713 7,161,350 - 11,005,605 46%
Expenditures
Personnel 8,380,352 597,711 6,399,441 5,865,219 - 1,980,911 76%
Supplies 1,343,520 61,769 776,686 802,052 195,805 371,029 72%
Services 4,936,475 475,212 3,392,986 2,278,626 376,105 1,167,384 76%
Debt Service 279,691 107,744 280,603 192,622 2,522 (3,435) 101%
Capital 4,000,000 - - 22,760 - 4,000,000 0%
Transfers Out 102,850 - - - - 102,850 0%
Total Expenditures 19,042,888 1,242,437 10,849,717 9,161,279 574,432 7,618,739 60%
Net 1,151,430 (833,604) (1,661,004) (1,999,929) (574,432) 3,386,866
Cash Balance 2,840,574 1,946,962
Staffing Budget Actual
Full Time 97.00 96.00
Part-Time /Seasonal/Temporary N/A 151.00
Total 97.00 247.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the operation of the Venues, Parks and Arts (VPA) that are predominantly taxpayer funded. There are eight divisions within
the department: Administration, Maintenance, Golf, Recreation, Greenhouse, Graffiti, Experience and the Regional Cities grant division.
Part-time staffing is individuals, not FTEs. Property tax and other tax revenues are received in June and December of the year. Charges for
Services include intra-City charges such as site mowing and graffiti removal.
In 2017, the VPA Maintenance department has assumed responsibility for maintenance and marketing of the Morris/Palais building and will receive
revenue via a Service Maintenance Agreement, valued at $653K. As part of the process, VPA picked up 3 FTE's from the Morris that are now
being paid from this fund.
In 2017 the City won a Regional Cities grant. In July, entered its portion of the grant into its 2017 budget as $5 million in grant revenues and $4
million in capital expenditures. These values are reflected above.
The Cash Balance normally runs lower than City Policy due to the timing of receipts of property taxes, but the situation clears itself in June and
December. June's receipt was higher than expected and the budgeted revenue has been adjusted accordingly.
VPA's capital needs, other than the Regional Cities grant, are being addressed through a bond that was issued in 2015. Please see Fund 751 for
details.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Parks & Recreation
Special Revenue Funds
City Funds
24
Fund Name Fund Number 202
Fund Type Date Updated 10/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes 5,650,000 810,032 5,079,190 4,988,437 - 570,810 90%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 223,365 37,381 151,520 184,474 - 71,845 68%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 60,000 3,246 55,872 45,390 - 4,128 93%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 125,028 1,795 61,810 40,806 - 63,218 49%
Transfers In 3,964,974 - 2,973,731 2,864,750 - 991,244 75%
Total Revenue 10,023,367 852,455 8,322,122 8,123,856 - 1,701,245 83%
Expenditures
Personnel 4,585,702 273,571 3,063,972 3,036,427 - 1,521,730 67%
Supplies 2,628,557 143,379 1,472,379 1,497,315 270,282 885,896 66%
Services 3,744,927 363,057 2,295,143 2,099,020 398,969 1,050,815 72%
Debt Service 775,545 38,489 692,476 435,879 - 83,069 89%
Capital 30,800 - 15,995 39,458 10,800 4,005 87%
Transfers Out - - - - - - 0%
Total Expenditures 11,765,531 818,495 7,539,965 7,108,098 680,051 3,545,515 70%
Net (1,742,164) 33,959 782,157 1,015,758 (680,051) (1,844,270)
Cash Balance 6,943,113 6,190,957
Staffing Budget Actual
Full Time 58.03 53.03
Part-Time /Seasonal/Temporary 7.68 2.92
Total 65.71 55.95
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the operations of the following departments: Streets, Traffic & Lighting, and Curb & Sidewalk.
The major encumbrances were $303k for curb & sidewalk, $225k for road salt, $39k for Corby Blvd Project design services, and $16k for County-
City Building van accessible parking.
Historically, this fund has received its revenues through gasoline taxes, but since 2008 has also received wheel tax revenues. Currently, it receives
transfers from COIT to support the curb and sidewalk program, from EDIT to support street department operations and from Project ReLeaf to
support leaf collection efforts in the City.
$20,000 is budgeted for a new printer for the sign shop.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Motor Vehicle Highway
Special Revenue Funds
City Funds
25
Fund Name Fund Number 203
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 1,081,212 32,740 806,552 823,979 - 274,660 75%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 10,200 418 7,784 6,825 - 2,416 76%
Bond Proceeds - - - - - - 0%
Donations 55,000 - 44,700 - - 10,300 81%
Other Income 11,356 126 538 198 - 10,818 5%
Transfers In - - - - - - 0%
Total Revenue 1,157,768 33,284 859,574 831,002 - 298,194 74%
Expenditures
Personnel 571,393 21,227 302,557 324,879 - 268,836 53%
Supplies 318,589 12,382 139,672 137,326 45,104 133,813 58%
Services 594,701 36,840 365,711 312,865 66,210 162,780 73%
Debt Service - - - - - - 0%
Capital 115,000 - 56,050 41,299 - 58,950 49%
Transfers Out - - - - - - 0%
Total Expenditures 1,599,683 70,450 863,990 816,369 111,314 624,379 61%
Net (441,915) (37,166) (4,416) 14,633 (111,314) (326,185)
Cash Balance 805,830 854,830
Staffing Budget Actual
Full Time 1.00 -
Part-Time /Seasonal/Temporary -38.00
Total 1.00 38.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for recreation programs and events that are self supporting through user fees or sponsorships and donations. This fund is
budgeted generally to cover costs of programs.
Part time employees are individuals, not FTEs. Supplies encumbrances are for annual PO's to suppliers of commodities, such as Sam's Club, and
for pool supplies. Services encumbrances are annual PO's for sports referees and contracts for fitness instructors.
The Director of the Fitness Center resigned in September. VPA has elected to leave the position vacant at this time.
Capital budget includes $85,000 for Leeper Park tennis court resurfacing and $30,000 for undefined athletics equipment.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Recreation Nonreverting
Special Revenue Funds
City Funds
26
Fund Name Fund Number 209
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 318,587 12,943 228,541 132,129 - 90,046 72%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 7,200 441 6,925 8,674 - 275 96%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 100,000 - 100,000 100,000 - - 100%
Transfers In - - - - - - 0%
Total Revenue 425,787 13,383 335,465 240,803 - 90,322 79%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 539,393 26,237 280,759 473,198 158,634 100,000 81%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 539,393 26,237 280,759 473,198 158,634 100,000 81%
Net (113,606) (12,854) 54,706 (232,395) (158,634) (9,678)
Cash Balance 909,792 1,204,614
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to account for various grants relating to Studebaker/Oliver area and brownfields. Revenues and expenditures in this fund are grant
and project specific and will vary from year to year.
Brownfield Assessment Grant awarded by EPA for use in South Bend, Mishawaka and St. Joseph County covers the outstanding encumbrance.
Consultant work proceeding. We are able to draw revenue from the grant as we make expenditures.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Studebaker-Oliver Reverting Grants
Special Revenue Funds
City Funds
27
Fund Name Fund Number 210
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 187,129 - 2,696 1,801,244 - 184,433 1%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 11,351 2,202 9,378 6,172 - 1,973 83%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 63,661 15,974 47,566 33,812 - 16,095 75%
Transfers In - - - - - - 0%
Total Revenue 262,141 18,176 59,640 1,841,227 - 202,501 23%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 185,120 - - 685,860 185,120 - 100%
Debt Service 72,012 - 54,008 54,008 - 18,004 75%
Capital 252,625 - - 947,375 - 252,625 0%
Transfers Out - - - - - - 0%
Total Expenditures 509,757 - 54,008 1,687,243 185,120 270,629 47%
Net (247,616) 18,176 5,633 153,984 (185,120) (68,129)
Cash Balance 356,627 314,530
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established to track the receipt and subsequent expenditure of grants from the State of Indiana.
Capital expenditures shown here are for the ND Turbo Project.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Economic Development State Grants
Special Revenue Funds
City Funds
28
Fund Name Fund Number 211
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 440,636 - - 454,755 - 440,636 0%
Licenses & Permits - - - - - - 0%
Charges for Services 316,000 10,069 183,152 282,233 - 132,848 58%
Fines, Forfeitures, and Fees 2,000 - 470 165 - 1,530 24%
Interest Earnings 13,000 425 9,935 10,093 - 3,065 76%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 119 - 118 2,604 - 1 99%
Transfers In 1,522,673 - 1,142,005 1,396,229 - 380,668 75%
Total Revenue 2,294,428 10,494 1,335,680 2,146,079 - 958,748 58%
Expenditures
Personnel 1,876,469 122,820 1,374,295 1,545,874 - 502,174 73%
Supplies 26,356 1,308 9,633 11,095 1,376 15,347 42%
Services 872,551 41,322 452,714 368,351 152,243 267,594 69%
Debt Service - - - - - - 0%
Capital - - - 35,157 - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,775,376 165,449 1,836,642 1,960,477 153,619 785,115 72%
Net (480,948) (154,956) (500,962) 185,602 (153,619) 173,633
Cash Balance 861,588 1,308,059
Staffing Budget Actual
Full Time 23.00 20.00
Part-Time /Seasonal/Temporary - -
Total 23.00 20.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the activities of the Department of Community Investment, formerly known as the Department of Economic Development.
Transfers In come from EDIT Fund 408 on a quarterly basis.
Vacant positions: one Analyst position; Assistant Executive Director; and one Associate position. Expect 2 positions to be filled by 11/30/17.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Department of Community Investment (DCI)
Special Revenue Funds
City Funds
29
Fund Name Fund Number 212
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 5,238,451 55,910 1,353,337 2,245,517 - 3,885,114 26%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees 1,000 - 40 214 - 960 4%
Interest Earnings 2,000 8 551 1,324 - 1,449 28%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 333,225 2,284 385,027 20,567 - (51,802) 116%
Transfers In - - - - - - 0%
Total Revenue 5,574,676 58,202 1,738,955 2,267,622 - 3,835,721 31%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Grants & Subsidies 5,455,838 343,006 1,824,957 2,387,451 2,535,146 1,095,735 80%
Transfers Out - - - 500 - - 0%
Total Expenditures 5,455,838 343,006 1,824,957 2,387,951 2,535,146 1,095,735 80%
Net 118,838 (284,804) (86,002) (120,329) (2,535,146) 2,739,986
Cash Balance 154,832 507,402
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for various grants including Community Development Block Grants (CDBG), Emergency Solutions Grant, Shelter Plus Care,
Neighborhood Stabilization Project, etc.
There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on-going and the timing of funding
varies widely. We can only draw revenue in response to funds expended so revenues will come in as funds are spent. The federal government
does not allow us to hold too much cash. Expenditures in 2017, as in previous years, will be made by outside not-for-profits for eligible activities
such as: Homeownership Assistance; Housing Acquisition/Rehab/Resale; Owner-Occupied Housing Rehab; Spot Blight Clearance; Technical
Assistance; Public Services; Public Facility Improvements; Emergency Shelter Operations; Rapid Re-housing; Shelter Plus Supportive Services;
and New Housing Construction. All services must either assist low/moderate income households or eliminate slum & blight and/or other
requirements specific to the particular grants. The not-for-profits can generally apply for funding for 2018 in the summer of 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Dept of Community Investment Grants
Special Revenue Funds
City Funds
30
Fund Name Fund Number 216
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 35,000 - 15,003 30,184 - 19,997 43%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,000 116 1,933 1,670 - 67 97%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - 24,840 - - (24,840) 0%
Transfers In - - - - - - 0%
Total Revenue 37,000 116 41,776 31,854 - (4,776) 113%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 36,000 - - 3,110 - 36,000 0%
Debt Service - - - - - - 0%
Capital 80,000 - - - - 80,000 0%
Transfers Out - - - - - - 0%
Total Expenditures 116,000 - - 3,110 - 116,000 0%
Net (79,000) 116 41,776 28,744 - (120,776)
Cash Balance 259,382 228,481
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for law enforcement expenditures financed by the authorized state or local agencies sale of confiscated property.
This fund's revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug
activities. Expenditures are to be used to support the Police Department's effort to combat drug activity.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police State Seizures
Special Revenue Funds
City Funds
31
Fund Name Fund Number 217
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 20,000 - 20,000 - - - 100%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,100 51 1,165 557 - (65) 106%
Bond Proceeds - - - - - - 0%
Donations 192,994 1,102 162,020 136,987 - 30,974 84%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 214,094 1,153 183,185 137,544 - 30,909 86%
Expenditures
Personnel - - - - - - 0%
Supplies 8,700 - - - - 8,700 0%
Services 233,000 - 194,856 97,000 5,351 32,792 86%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 241,700 - 194,856 97,000 5,351 41,492 83%
Net (27,606) 1,153 (11,671) 40,544 (5,351) (10,583)
Cash Balance 105,103 105,418
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for miscellaneous contributions to the City for specific projects and the expenses related to the projects.
$350,000 has been budgeted from this fund to help fund public art projects throughout the City. The City wishes to serve as a conduit for this
activity and hopes to receive $185,000 in private donations to help fund these projects.
A new sculpture of Dr. Martin Luther King Jr and Father Theodore Hesburgh was unveiled on June 21. The sculpture is located in Leighton Plaza in
downtown South Bend. It was funded by many community donations.
In March 2017, the Department of Animal Care & Control received a large donation of $23k.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Gift, Donation, Bequest
Special Revenue Funds
City Funds
32
Fund Name Fund Number 218
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees 900 - 148 188 - 752 16%
Interest Earnings 100 6 106 95 - (6) 106%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 1,000 6 254 283 - 746 25%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 1,000 - - - - 1,000 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,000 - - - - 1,000 0%
Net - 6 254 283 - (254)
Cash Balance 12,817 12,521
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for monies received from Juvenile Positive Assistance. Juvenile Positive Assistance accounts for monies received from
penalties paid for curfew violations.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police Curfew Violations
Special Revenue Funds
City Funds
33
Fund Name Fund Number 219
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 254,218 10,580 111,203 196,039 - 143,015 44%
Fines, Forfeitures, and Fees 50,500 3,266 54,084 141,046 - (3,584) 107%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 579,757 - 434,818 616,911 - 144,939 75%
Total Revenue 884,475 13,846 600,105 953,997 - 284,370 68%
Expenditures
Personnel 273,536 22,514 222,123 210,294 - 51,413 81%
Supplies 24,959 1,146 13,716 13,651 194 11,049 56%
Services 606,984 71,035 459,198 398,589 79,351 68,435 89%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 905,479 94,695 695,037 622,534 79,545 130,897 86%
Net (21,004) (80,849) (94,932) 331,463 (79,545) 153,473
Cash Balance 278,063 334,580
Staffing Budget Actual
Full Time 4.00 4.00
Part-Time /Seasonal/Temporary - -
Total 4.00 4.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Unsafe Building fund is a new fund established in 2016 to receive fines and fees related to Indiana's Unsafe Building law. The costs and
expenses incurred in board-ups and other related services are recorded here.
This fund accounts for the activities of the Neighborhood Enhancement Activity Team (NEAT) Crew, charged with maintaining property standards
regarding property cleanliness and upkeep. The City's mowing and graffiti removal programs are also run through this fund. The NEAT Crew is a
division of Code Enforcement. Revenue in Fines, Forfeitures, and Fees represent miscellaneous collections for delinquent billing through invoices
which were deemed uncollectible, and therefore turned over to a collection agency. Also included in this category is revenue collected by the
Ordinance Violation Bureau for fines levied against property owners for certain violations tagged by Code Enforcement. In addition, in 2017 Fund
219 will receive interfund operating transfers from Fund 408 (EDIT) in the amount of $579,757.
Current year encumbrances include two large valued purchase orders made payable to the Venues, Parks, and Arts for their services for
Centralized Mowing, and Graffiti removal ($140,000 and $75,000 respectively). An additional value purchase order has encumbered funds for legal
representation for weekly Code Enforcement hearings ($30,000).
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Unsafe Building
Special Revenue Funds
City Funds
34
Fund Name Fund Number 220
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 120,000 12,029 104,281 118,116 - 15,719 87%
Fines, Forfeitures, and Fees 96,000 7,828 99,402 75,686 - (3,402) 104%
Interest Earnings 7,500 293 5,635 6,814 - 1,865 75%
Bond Proceeds - - - - - - 0%
Donations 2,000 - 1,125 325 - 875 56%
Other Income 20,675 - 17,554 30,286 - 3,121 85%
Transfers In - - - - - - 0%
Total Revenue 246,175 20,150 227,998 231,227 - 18,177 93%
Expenditures
Personnel - - - - - - 0%
Supplies 318,332 37,108 121,624 114,434 38,557 158,151 50%
Services 470,090 21,904 344,893 167,796 9,533 115,664 75%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 788,422 59,013 466,516 282,229 48,090 273,815 65%
Net (542,247) (38,863) (238,519) (51,002) (48,090) (255,638)
Cash Balance 553,794 839,790
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established for the continuing education and supplies for police and is funded by fees from accident reports, gun permits, false alarm
and loud noise fines.
During the first quarter of 2017, the majority of expenditures were for travel expenses related to various police training events.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Law Enforcement Continuing Education
Special Revenue Funds
City Funds
35
Fund Name Fund Number 221
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits 7,000 1,655 6,560 10 - 440 94%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 7,000 1,655 6,560 10 - 440 94%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 1,000 - 10 - - 990 1%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,000 - 10 - - 990 1%
Net 6,000 1,655 6,550 10 - (550)
Cash Balance 7,775 10
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the revenues and expenditures related to the Landlord Registration ordinance, enacted by the Common Council in 2016. The
proceeds from the registration, $5 registration per year, will fund Code Enforcement's costs of the program. There is a penalty of $100 to $500 per
landlord for failure to comply with the new ordinance. Any revenues from penalties will be used to subsidize the City's Curb and Sidewalk program.
Primary revenue for this account is generated by landlord registrations, with the majority of the revenue stream flowing in from September through
February.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Landlord Registration
Special Revenue Funds
City Funds
36
Fund Name Fund Number 227
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 9,000 418 7,941 7,583 - 1,059 88%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 9,000 418 7,941 7,583 - 1,059 88%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 550,333 - 108,352 21,969 115,381 326,600 41%
Debt Service - - - - - - 0%
Capital 48,342 - 12,860 3,200 35,482 - 100%
Transfers Out - - - - - - 0%
Total Expenditures 598,675 - 121,212 25,169 150,863 326,600 45%
Net (589,675) 418 (113,270) (17,586) (150,863) (325,541)
Cash Balance 857,295 975,663
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2008 with the recovery of monies from lawsuits brought about by environmental actions on the Studebaker and Oliver
industrial sites. The fund continues to receive, intermittently, monies from similar settlements. The fund is used for capital projects and the Vacant
and Abandoned Housing initiative.
Services include $350,000 budgeted for Ignition Park land remediation and $70,000 for vacant & abandoned housing.
The encumbrances in Services include $50K for the continuation of the vacant & abandoned housing program and $70K for legal services.
The capital encumbrance is for costs related to the purchasing of properties along the West Side Corridors (Western & Lincolnway West). These
properties are up for tax sale. The City is only purchasing properties which fit into the City’s strategy for future improvement of the corridors.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Loss Recovery
Special Revenue Funds
City Funds
37
Fund Name Fund Number 244
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - - - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 33,671 - 33,671 - - - 100%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 33,671 - 33,671 - - - 100%
Net (33,671) - (33,671) - - -
Cash Balance - 33,671
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2014 to better track costs related to the City's emergency dispatch center that was funded by State 911 revenue.
However, the State mandated consolidation of all dispatch centers within the county the following year.
This fund was closed in 2015 with the advent of the county-wide PSAP system. The remaining funds will be used to pay for the county-wide PSAP
system in 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Emergency Phone System
Special Revenue Funds
City Funds
38
Fund Name Fund Number 249
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes 7,467,618 622,302 6,223,015 5,659,300 - 1,244,603 83%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 11,000 434 8,217 5,494 - 2,783 75%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 7,478,618 622,735 6,231,232 5,664,794 - 1,247,386 83%
Expenditures
Personnel 7,462,645 518,805 6,084,573 5,256,754 - 1,378,072 82%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 7,462,645 518,805 6,084,573 5,256,754 - 1,378,072 82%
Net 15,973 103,930 146,659 408,040 - (130,686)
Cash Balance 1,087,108 1,049,975
Staffing Budget Actual
Full Time 78.00 78.00
Part-Time /Seasonal/Temporary - -
Total 78.00 78.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2010 due to Indiana's property tax "circuit breaker" system that effectively limited property tax receipts. The City has
adopted a special income tax of one quarter of one percent (0.25%) to be used solely for the salaries of public safety employees that were formerly
paid by property taxes.
This fund covered the costs of salaries and fringe benefits for 43 police officers and 35 firefighters in 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Public Safety LOIT
Special Revenue Funds
City Funds
39
Fund Name Fund Number 251
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes 1,068,000 174,931 1,002,124 862,816 - 65,876 94%
Grants/Intergovernmental 256,000 - 129,966 162,655 - 126,034 51%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 30,000 1,388 24,585 22,927 - 5,415 82%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 338,997 - 8,996 403,967 - 330,001 3%
Transfers In - - - - - - 0%
Total Revenue 1,692,997 176,319 1,165,671 1,452,364 - 527,326 69%
Expenditures
Personnel - - - - - - 0%
Supplies 500,378 5,670 455,306 381,478 364 44,708 91%
Services 794,905 3,859 122,701 263,644 38,282 633,922 20%
Debt Service - - - - - - 0%
Capital 1,013,261 137,270 470,372 448,810 160,105 382,784 62%
Transfers Out - - - - - - 0%
Total Expenditures 2,308,544 146,800 1,048,379 1,093,932 198,751 1,061,414 54%
Net (615,547) 29,520 117,292 358,433 (198,751) (534,088)
Cash Balance 2,947,326 3,138,267
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to track expenditures for road projects. In 2008, wheel tax revenue was moved from this fund to the Motor Vehicle Highway Fund
(202). This fund receives gas taxes as its primary revenue source.
This fund receives most of its revenue through the gas tax, budgeted at $1.068 million for 2017. Other Income is reimbursement from the Indiana
Department of Transportation (INDOT) as they pay the City back for their share of certain construction projects. The fund is used predominantly for
street capital projects. The large encumbrance in supplies is for street material.
Projects in 2017 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. The
encumbrance includes $56K for Bendix Dr. (Lathrop to Toll Road), $43K for the Boland Trail, $68K for Safe Routes to School (Coquillard, Harrison,
Perley and Lincoln schools), and $127K for Olive St. at Sample design and construction.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Local Roads & Streets
Special Revenue Funds
City Funds
40
Fund Name Fund Number 252
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - - - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies 8 - - - - 8 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 8 - - - - 8 0%
Net (8) - - - - (8)
Cash Balance 8 8
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
In 2009, the City received a one-time $2.9 million distribution for this fund, ear-marked for public safety. In 2012, the City spent approximately $2.1
million for portable radios for both the Police and Fire departments.
This fund will be closed in 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Excess Welfare Distribution
Special Revenue Funds
City Funds
41
Fund Name Fund Number 257
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - 4,217,549 - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 1,278,000 - - - - 1,278,000 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 40,000 1,475 28,521 - - 11,479 71%
Bond Proceeds - - - - - - 0%
Donations 100,000 - 100,000 - - - 100%
Other Income 205,397 - 261,189 130,394 - (55,792) 127%
Transfers In - - - - - - 0%
Total Revenue 1,623,397 1,475 389,709 4,347,943 - 1,233,688 24%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 852,100 39,568 187,367 - 638,853 25,880 97%
Debt Service - - - - - - 0%
Capital 1,905,357 291,931 513,694 303,635 1,028,985 362,679 81%
Transfers Out 1,000,000 - 1,000,000 - - - 100%
Total Expenditures 3,757,457 331,499 1,701,061 303,635 1,667,837 388,559 90%
Net (2,134,060) (330,024) (1,311,351) 4,044,307 (1,667,837) 845,129
Cash Balance 2,713,715 4,086,041
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2016, per the State Board of Accounts (SBOA), to receive a one-time payment of local income taxes from the State for
the purpose of infrastructure expenditures. Per the state statute, a minimum of 75% must be spent on infrastructure projects. The remainder was
deposited into the Rainy Day Fund (102).
A total of $4,217,549, representing 75% of the total distribution, was deposited in May 2016, comprised of $4,160,901 distributed to the City and
$56,648 distributed to the Redevelopment Authority.
The capital budget was established in July 2016 and is $850,000 comprised of 3 projects: 2 Safe Routes to School projects (LaSalle/Marquette and
Monroe/Studebaker) and initial planning for the Ironwood/Corby/Rockne intersection. The $606K encumbered is comprised of $22K for Safe Routes
- Monroe/Studebaker, $78K for Safe Routes - Marquette/LaSalle, $138K for Edison/Ironwood Design, and $368K for design work on the
Ironwood/Corby/Rockne intersection.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
LOIT Special Distribution
Special Revenue Funds
City Funds
42
Fund Name Fund Number 258
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 236,200 - 130,390 178,600 - 105,810 55%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,500 218 3,780 3,138 - 720 84%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 18,040 - 12,742 17,758 - 5,298 71%
Transfers In - - - - - - 0%
Total Revenue 258,740 218 146,912 199,496 - 111,828 57%
Expenditures
Personnel 126,096 5,642 64,023 97,767 - 62,073 51%
Supplies 7,630 739 6,760 1,184 371 500 93%
Services 68,047 2,412 43,269 54,735 8,295 16,483 76%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 201,773 8,794 114,052 153,686 8,666 79,056 61%
Net 56,967 (8,576) 32,860 45,810 (8,666) 32,772
Cash Balance 512,925 471,206
Staffing Budget Actual
Full Time 2.00 1.00
Part-Time /Seasonal/Temporary - -
Total 2.00 1.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund tracks that portion of the Human Rights Department that is funded by the federal government, including grants from HUD and EEOC. The
Human Rights mission is to educate and promote fair housing as well as ensure that all citizens receive equal employment opportunity.
Revenues are lower at this time versus last year due to timing of receipt for grants. Expenditures are lower this year in the personnel category due
to reduction in staffing that occurred earlier this year.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Human Rights Federal Grant
Special Revenue Funds
City Funds
43
Fund Name Fund Number 265
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 1,000,000 - 1,000,000 - - - 100%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 1,000,000 - 1,000,000 - - - 100%
Total Revenue 2,000,000 - 2,000,000 - - - 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 2,000,000 1,400 1,464 - 1,443,225 555,311 72%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,000,000 1,400 1,464 - 1,443,225 555,311 72%
Net - (1,400) 1,998,536 - (1,443,225) (555,311)
Cash Balance 1,998,536 -
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in December 2016 to account for the receipt of the Community Crossings grant and matching revenue and for the
payment of expenditures on eligible projects, per the Indiana State Board of Accounts.
In February 2017, the City received the $1 million Community Crossings state grant from INDOT. $1 million was transferred from Fund 257 (LOIT
2016 Special Distribution) to match the grant revenue.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Local Road & Bridge Grant
Special Revenue Funds
City Funds
44
Fund Name Fund Number 271
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 22 - 9 10 - 13 40%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 22 - 9 10 - 13 40%
Expenditures
Personnel - - - - - - 0%
Supplies 1,367 - 1,353 - - 14 99%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,367 - 1,353 - - 14 99%
Net (1,345) - (1,344) 10 - (1)
Cash Balance 3 1,345
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In recent years, there
have been no races.
Budgeted expenditures are for East Race equipment. This fund will be closed in 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Eastrace Waterway
Special Revenue Funds
City Funds
45
Fund Name Fund Number 273
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 18,000 720 9,229 17,079 - 8,771 51%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 450 24 386 263 - 64 86%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 18,450 744 9,615 17,342 - 8,835 52%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 21,675 - 5,673 4,212 - 16,002 26%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 21,675 - 5,673 4,212 - 16,002 26%
Net (3,225) 744 3,942 13,131 - (7,167)
Cash Balance 51,030 43,482
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate, non-reverting fund to receive monies from
solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marquee sponsorships; and to
accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the
sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Morris PAC / Palais Royale Marketing
Special Revenue Funds
City Funds
46
Fund Name Fund Number 280
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 50 2 33 30 - 17 65%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 50 2 33 30 - 17 65%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 50 2 33 30 - 17
Cash Balance 3,918 3,880
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund has been used to account for certain Police grants. There are no open grants at this time.
Justice Assistance Grant 2009-SB-B9-1280 was essentially completed in 2014.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police Block Grants
Special Revenue Funds
City Funds
47
Fund Name Fund Number 281
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 300 14 232 212 - 68 77%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 300 14 232 212 - 68 77%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 300 14 232 212 - 68
Cash Balance 27,844 27,574
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was used for the expenses of Economic Development Revenue Bonds. These bonds have been paid off.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Economic Develop Commission-Revenue Bonds
Special Revenue Funds
City Funds
48
Fund Name Fund Number 289
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 10,000 - 3,060 - - 6,940 31%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 250 12 204 230 - 46 81%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 10,250 12 3,264 230 - 6,986 32%
Expenditures
Personnel - - - - - - 0%
Supplies 10,431 - 5,768 7,609 - 4,663 55%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 10,431 - 5,768 7,609 - 4,663 55%
Net (181) 12 (2,505) (7,379) - 2,324
Cash Balance 24,270 24,684
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to account for the cost of the Hazardous Materials Response team. By ordinance the South Bend Fire Department charges
businesses for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund,
responses are made by firefighters of the South Bend Fire Department.
Funding is entirely dependent on the number of billable Hazardous Material responses in any given calendar year.
No major capital expenditures are planned through this fund. Major purchases are funded through the Fire Department and EMS Capital and the
minimal fees collected in this fund are used to replace equipment and gear used in responses.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
HAZMAT
Special Revenue Funds
City Funds
49
Fund Name Fund Number 291
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 67,800 4,200 72,000 108,900 - (4,200) 106%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,600 60 1,248 985 - 352 78%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 69,400 4,260 73,248 109,885 - (3,848) 106%
Expenditures
Personnel 15,500 231 3,200 2,423 - 12,300 21%
Supplies 16,849 750 16,299 6,181 - 550 97%
Services 85,000 0 75,215 33,779 184 9,601 89%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 117,349 981 94,714 42,384 184 22,451 81%
Net (47,949) 3,279 (21,466) 67,501 (184) (26,299)
Cash Balance 120,554 171,946
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2-4 schools a year, each a week in
duration. Expenditures are for the maintenance and repair of rescue equipment.
Funding relies on the number of Indiana River Rescue School (IRRS) courses offered in any given year. Generally, there are at least 3 courses
offered. In recent years, demand from the fire departments of Chicago and New York has increased the need for additional dedicated classes. In
those years, revenue can increase dramatically.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Indiana River Rescue
Special Revenue Funds
City Funds
50
Fund Name Fund Number 292
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - - - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 35,805 226 28,178 33,239 4,756 2,871 92%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 35,805 226 28,178 33,239 4,756 2,871 92%
Net (35,805) (226) (28,178) (33,239) (4,756) (2,871)
Cash Balance 48,451 87,957
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established to track the revenue and expenditures related to specific Federal Grants. Federal Grant revenue and expenditures are
now tracked in Fund 295.
The City did not received any grants during 2016 and does not anticipate any grant revenue during 2017. $21,735 payment to Lexipol in August.
All expenses are for the Lexipol implementation.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police Grants
Special Revenue Funds
City Funds
51
Fund Name Fund Number 294
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 20,000 3,100 18,375 18,600 - 1,625 92%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 980 41 706 633 - 274 72%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 2,000 - 50 - - 1,950 3%
Transfers In - - - - - - 0%
Total Revenue 22,980 3,141 19,131 19,233 - 3,849 83%
Expenditures
Personnel - - - - - - 0%
Supplies 1,500 121 696 100 - 804 46%
Services 21,000 133 6,847 7,394 - 14,153 33%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 22,500 254 7,542 7,495 - 14,958 34%
Net 480 2,887 11,589 11,738 - (11,109)
Cash Balance 87,664 81,957
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are
offered to other police departments who pay a fee to attend the training.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Regional Police Academy
Special Revenue Funds
City Funds
52
Fund Name Fund Number 295
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 53,750 - - 7,319 - 53,750 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,000 75 1,469 1,001 - 531 73%
Bond Proceeds - - - - - - 0%
Donations 3,250 - - - - 3,250 0%
Other Income 64,500 1,032 53,379 72,180 - 11,121 83%
Transfers In - - - - - - 0%
Total Revenue 123,500 1,108 54,848 80,500 - 68,652 44%
Expenditures
Personnel - - - - - - 0%
Supplies 110,467 - 23,860 150,452 40,066 46,541 58%
Services 153,300 19,534 132,019 51,269 1,340 19,941 87%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 263,767 19,534 155,879 201,720 41,406 66,482 75%
Net (140,267) (18,426) (101,030) (121,220) (41,406) 2,170
Cash Balance 136,394 146,779
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds
received from the grants along with impound towing fees. The Community-Oriented Policing Services (COPS) Office of the Department of Justice
offers grants through the Making Officer Redeployment Effective (MORE) program.
The $40,000 Encumbrances are for dash cameras paid for by a grant.
Grant monies were paid to another Police Department
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
COPS MORE Grant
Special Revenue Funds
City Funds
53
Fund Name Fund Number 299
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 30,000 - 1,823 10,786 - 28,177 6%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,000 218 1,761 1,144 - 239 88%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 31,000 - - 14,536 - 31,000 0%
Transfers In - - - - - - 0%
Total Revenue 63,000 218 3,584 26,466 - 59,416 6%
Expenditures
Personnel - - - - - - 0%
Supplies 89,337 - 34,337 21,336 - 55,000 38%
Services 62,000 - 16,372 1,290 - 45,628 26%
Debt Service - - - - - - 0%
Capital 135,000 79,491 98,491 3,787 - 36,509 73%
Transfers Out - - - - - - 0%
Total Expenditures 286,337 79,491 149,201 26,413 - 137,136 52%
Net (223,337) (79,273) (145,617) 53 - (77,720)
Cash Balance 80,442 252,805
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established to receive the Police Department share of money acquired in drug enforcement activity. Expenditures are to be used to
fund drug enforcement and training.
In the first quarter of 2017, workstations ($11k) and surveillance cameras ($23k) were purchased within the supplies budget. Additionally, $13,200
of the services budget was spent on SWAT training. September's negative revenue is the reversal of August revenue that was posted in error.
Microscope was purchased for the Lab.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police Federal Drug Enforcement
Special Revenue Funds
City Funds
54
Fund Name Fund Number 404
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes 10,459,265 871,605 8,716,054 7,878,353 - 1,743,211 83%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 100,000 4,742 75,630 84,182 - 24,370 76%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 504,153 38,584 509,922 701,049 - (5,769) 101%
Transfers In - - - 2,977 - - 0%
Total Revenue 11,063,418 914,931 9,301,606 8,666,560 - 1,761,812 84%
Expenditures
Personnel - - - 309,601 - - 0%
Supplies 1,234,438 57,581 721,554 625,656 9,454 503,430 59%
Services 5,597,611 953,100 4,916,434 6,727,548 239,099 442,078 92%
Debt Service 1,282,337 - 1,277,051 2,436,746 - 5,286 100%
Capital 514,629 123,423 184,681 221,774 54,778 275,170 47%
Transfers Out 3,442,578 - 2,669,520 1,125,000 - 773,058 78%
Total Expenditures 12,071,593 1,134,105 9,769,240 11,446,324 303,331 1,999,022 83%
Net (1,008,175) (219,173) (467,634) (2,779,764) (303,331) (237,210)
Cash Balance 8,444,791 9,364,191
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the receipt and county option income tax (COIT) and expenditures of those funds. The revenue is determined annually by the
Indiana Department of Local Government Finance (DLGF). Expenditures in this fund include debt service payments, maintenance, and the Curb &
Sidewalk program.
Prior to 2017, this fund paid for Information Technology/Innovation costs, but these costs have been moved into fund 279 for 2017. Certain debt
service payments on public facilities, including the Public Works Service Center, Police and Fire Stations and Main Street/Colfax Garage, have
been paid by the COIT fund, but will be paid from the Tax Increment Financing (TIF) funds in 2017. The Curb & Sidewalk program increased by
$177,224 to the level of $1,677,224. Expenditures are consistent with normal operating costs.
This year, budgeted capital projects include bus shelters of $180,000, and the neighborhood plan program for $95,000.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
County Option Income Tax
Special Revenue Funds
City Funds
55
Fund Name Fund Number 408
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes 10,433,361 866,667 8,700,026 7,995,502 - 1,733,335 83%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 150,000 - 150,000 150,000 - - 100%
Fines, Forfeitures, and Fees 354,660 - 354,660 354,660 - - 100%
Interest Earnings 120,000 6,457 100,909 77,787 - 19,091 84%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 1,138 - 1,137 3,034 - 1 100%
Transfers In 735,241 - 735,240 - - 1 100%
Total Revenue 11,794,400 873,124 10,041,973 8,580,983 - 1,752,427 85%
Expenditures
Personnel - - - - - - 0%
Supplies 83 - - 1,460 83 - 100%
Services 4,404,649 184,135 2,694,757 950,050 825,108 884,784 80%
Debt Service 384,256 31,723 354,862 1,238,473 - 29,394 92%
Capital 102,700 - 60,317 2,628 - 42,383 59%
Transfers Out 6,667,496 - 5,015,622 4,782,837 - 1,651,874 75%
Total Expenditures 11,559,184 215,858 8,125,558 6,975,448 825,191 2,608,435 77%
Net 235,216 657,266 1,916,415 1,605,536 (825,191) (856,008)
Cash Balance 13,077,200 11,481,115
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to subsidize many operations throughout the City via transfers to those operations' various funds. Services expenditures include
the payment to St Joe County for PSAP, various economic development & assistance grants, workforce development programming, and others.
The economic development income tax (EDIT) rate was increased from 0.2% of salaries and wages in 2009 to 0.4% in 2010 in response to revenue
losses incurred by the "circuit breaker" property tax caps.
Transfers out relate to: $1,522,673 - annual subsidy to Fund 211 for DCI, $400,000 to Fund 201 for maintenance and other services formerly
provided by DTSB, $1,937,750 to Fund 202 for Street Department expenditures and road paving expenses, $1,438,451 to Fund 600-1201 for Code
Enforcement, $579,757 to Fund 219, and $728,865 to Fund 600-1207 for Animal Care & Control. Services expenditures includes the $2,054,126
payment to St Joe County for PSAP, various economic development & assistance grants, workforce development programming, and others. The
Debt Service expenditures are payments on the 2015 EDIT Parks Bond.
$45K is budgeted for the recording of deeds. $57.7K is for ATVs with plows for snowplowing sidewalks.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Economic Development Income Tax
Special Revenue Funds
City Funds
56
Fund Name Fund Number 410
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 6,110 245 4,487 4,066 - 1,623 73%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 6,110 245 4,487 4,066 - 1,623 73%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 126,144 31,814 126,142 238,173 - 2 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 126,144 31,814 126,142 238,173 - 2 100%
Net (120,034) (31,569) (121,655) (234,107) - 1,621
Cash Balance 470,821 396,294
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is currently used to pay for an inter-fund loan from the COIT Fund (404) in connection with a downtown hotel/parking garage project.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Urban Development Action Grant
Special Revenue Funds
City Funds
57
Fund Name Fund Number 655
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 440,153 37,346 370,302 367,888 - 69,851 84%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 9,000 444 7,303 6,641 - 1,697 81%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 449,153 37,789 377,605 374,529 - 71,548 84%
Expenditures
Personnel 61,606 - - - - 61,606 0%
Supplies 4,344 510 1,386 1,603 1,750 1,208 72%
Services 49,001 3,299 42,727 40,094 - 6,274 87%
Debt Service 72,220 24,490 72,218 72,218 - 2 100%
Capital - - - - - - 0%
Transfers Out 350,000 - 262,500 350,000 - 87,500 75%
Total Expenditures 537,171 28,300 378,831 463,915 1,750 156,590 71%
Net (88,018) 9,490 (1,227) (89,386) (1,750) (85,041)
Cash Balance 874,804 833,407
Staffing Budget Actual
Full Time - -
Part-Time /Seasonal/Temporary 2.02 1.30
Total 2.02 1.30
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the fall and spring leaf collection program. The program is financed by a $0.99 per month charge on residents' utility bills.
The annual transfer of $350,000 is to cover a portion of MVH costs paid for spring & fall Project Releaf. These costs include supervisory wages and
benefits, gasoline, depreciation on the leaf vacs and other costs.
2017 Fall Leaf Pickup program began October 23.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Project Releaf
Special Revenue Funds
City Funds
58
Fund Name Fund Number 705
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 36 1 24 29 - 12 67%
Bond Proceeds - - - - - - 0%
Donations 2,000 - - - - 2,000 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 2,036 1 24 29 - 2,012 1%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 2,020 - - 1,044 - 2,020 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,020 - - 1,044 - 2,020 0%
Net 16 1 24 (1,015) - (8)
Cash Balance 2,882 2,854
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police K-9 Unit
Special Revenue Funds
City Funds
59
Fund Name Fund Number 313
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 827,000 - 451,820 744,230 - 375,180 55%
Local Income Taxes - - - - - - 0%
Other Taxes 67,000 - 22,945 34,112 - 44,055 34%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 300 18 231 - - 69 77%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 93,430 - - 0%
Transfers In - - - - - - 0%
Total Revenue 894,300 18 474,996 871,772 - 419,304 53%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 1,268,999 800 1,144,220 1,271,000 - 124,779 90%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,268,999 800 1,144,220 1,271,000 - 124,779 90%
Net (374,699) (782) (669,224) (399,228) - 294,525
Cash Balance (376,431) (387,832)
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former
College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will
typically have a negative cash balance until the property tax distributions are received.
The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. During
2017, certain debt service payments may need to be transferred to another fund due to a reduction in the property tax levy for this fund.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Football Hall of Fame Debt Service
Capital & Debt Service Funds
City Funds
60
Fund Name Fund Number 755
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,000 333 2,118 - - 1,882 53%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 2,650,500 - 2,650,500 - - - 100%
Total Revenue 2,654,500 333 2,652,618 - - 1,882 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 2,643,214 - 2,642,214 - - 1,000 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,643,214 - 2,642,214 - - 1,000 100%
Net 11,286 333 10,404 - - 882
Cash Balance 772,492 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The South Bend Building Corporation receives debt service payments from the City and passes them through to trustee banks and bondholders.
The South Bend Building Corporation is a separate legal entity and the City wishes to formally integrate its operations into its formal accounting
system in 2017. The South Bend Building Corporation is reported as a fund in the City's Comprehensive Annual Financial Report (CAFR).
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Debt service payments are for the 2012 Police & Fire refunding (debt schedule #39), the 2010 Public Works Building refunding (#36), and the 2013
EMS Fire Station/Tower bonds (#116). Debt payments are made twice a year, in February and August.
The 2010 Public Works Building refunding bonds are scheduled to be paid off in 2021. The 2012 Police & Fire refunding are scheduled to be paid
off in 2023. The 2013 EMS Fire Station/Tower bonds are scheduled to be paid off in 2033.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
South Bend Building Corp
Capital & Debt Service Funds
City Funds
61
Fund Name Fund Number 757
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,000 92 1,057 - - (57) 106%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 390,482 31,723 289,665 - - 100,817 74%
Total Revenue 391,482 31,815 290,722 - - 100,760 74%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 391,482 - 390,481 - - 1,001 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 391,482 - 390,481 - - 1,001 100%
Net - 31,815 (99,760) - - 99,760
Cash Balance 462,183 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
A new Parks Bond Debt Service Fund 757 is being established for 2017 to account for the receipt of monthly lease rental payments from the City's
EDIT Fund 408 and the payment of debt service principal and interest semi-annually to the bond holders. The accounting records are maintained in
US Bank trustee accounts and, beginning in 2017, will be integrated into the City's regular accounting system. The par amount of the 2015
Parks/EDIT bond was $5,605,000 and the final payment is due August 1, 2035.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Transfers in are from the bond trustee.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Parks Bond Debt Service
Capital & Debt Service Funds
City Funds
62
Fund Name Fund Number 377
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes 700,000 - 224,912 636,213 - 475,088 32%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,000 - 1,345 2,202 - 655 67%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 32,325 - 32,324 44,981 - 1 100%
Transfers In - - - - - - 0%
Total Revenue 734,325 - 258,581 683,396 - 475,744 35%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 827,955 - 827,955 838,051 - - 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 827,955 - 827,955 838,051 - - 100%
Net (93,630) - (569,374) (154,655) - 475,744
Cash Balance (172,096) 272,719
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund collects a special tax which is used primarily for debt service and improvements at the Four Winds Field baseball stadium. The PSDA
revenue is projected to end in August 2018.
Effective January 1, 2013, this fund no longer collects hotel/motel tax allocations from St. Joseph County for payment to the Hall of Fame, but still
receives funding from the State for PSDA on a monthly basis. The PSDA area includes Four Winds field, Century Center, MPAC and Studebaker
National Museum. This fund is currently used for debt service. Four Winds Field generates the majority of PSDA revenue. The PSDA revenue is
projected to end in August 2018. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) will be paid January 15,
2019.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Professional Sports Development
Capital & Debt Service Funds
City Funds
63
Fund Name Fund Number 401
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 41,815 - 41,814 40,789 - 1 100%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 900 39 693 528 - 207 77%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 42,715 39 42,508 41,318 - 207 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 30,000 61,597 78,597 25,430 9,829 (58,426) 295%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 30,000 61,597 78,597 25,430 9,829 (58,426) 295%
Net 12,715 (61,558) (36,089) 15,888 (9,829) 58,634
Cash Balance 54,445 98,442
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used for minor capital improvements for Four Winds Field at Coveleski Stadium. Revenues are in the form of a bonus received by the
City if attendance reaches or maintains certain levels.
Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Further, the budgeted items are for
repair & maintenance, not capital.
A Form B budget adjustment has been submitted to Council for approval; approval is expected in December.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Coveleski Stadium Capital
Capital & Debt Service Funds
City Funds
64
Fund Name Fund Number 403
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 200 - 151 383 - 49 76%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 200 - 151 383 - 49 76%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 50,050 - 50,049 - - 1 100%
Transfers Out - - - - - - 0%
Total Expenditures 50,050 - 50,049 - - 1 100%
Net (49,850) - (49,898) 383 - 48
Cash Balance - 49,828
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for donations dedicated to Potawatomi Zoo.
In the past few years, several endowments that were funding this fund were liquidated, resulting in a drop in revenues to this fund. This fund is now
empty and will have no more activity.
The 2017 capital budget is for the re-paving of the zoo parking lot.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Zoo Endowment
Capital & Debt Service Funds
City Funds
65
Fund Name Fund Number 405
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 26,000 94 5,634 4,987 - 20,366 22%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,000 36 1,195 2,937 - 2,805 30%
Bond Proceeds - - - - - - 0%
Donations 100,000 - 75,000 - - 25,000 75%
Other Income 22,000 - 4,000 - - 18,000 18%
Transfers In 287,850 - 185,000 - - 102,850 64%
Total Revenue 439,850 130 270,829 7,924 - 169,021 62%
Expenditures
Personnel - - - - - - 0%
Supplies 92,326 3,610 52,324 53,754 12,802 27,201 71%
Services 63,288 10,710 28,873 55,848 4,266 30,149 52%
Debt Service - - - - - - 0%
Capital 397,410 (37,120) 314,865 23,181 - 82,545 79%
Transfers Out - - - - - - 0%
Total Expenditures 553,024 (22,800) 396,061 132,783 17,068 139,895 75%
Net (113,174) 22,930 (125,233) (124,859) (17,068) 29,126
Cash Balance 185,476 356,469
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This is a capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and
Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, and Howard Park Ice Rink. Currently, this fund is used for more than capital
expenditures.
Annual transfers to this fund from Park Funds (201/203) were not done in 2015 and 2016 due to an oversight. This will be corrected in 2017 and
revenues going forward in this fund should be more consistent. Encumbrances for Supplies are made up of many small PO's, with $500 for
Maintenance, $10.3K for Golf and $2.5K for Recreation.
The cash balance includes $60,300 that is restricted to expenditures in Voorde Park.
Capital expenditures are for the purchase of equipment for the golf courses.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Park Nonreverting Capital
Capital & Debt Service Funds
City Funds
66
Fund Name Fund Number 406
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 444,000 - 240,635 240,590 - 203,365 54%
Local Income Taxes - - - - - - 0%
Other Taxes 37,500 - 18,332 18,038 - 19,168 49%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,100 201 3,876 3,449 - 224 95%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 44,200 - - 0%
Transfers In - - - - - - 0%
Total Revenue 485,600 201 262,844 306,277 - 222,756 54%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 476,500 10,711 440,885 502,013 - 35,615 93%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 476,500 10,711 440,885 502,013 - 35,615 93%
Net 9,100 (10,510) (178,041) (195,737) - 187,141
Cash Balance 402,273 376,223
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The fund is used to finance police vehicles and related equipment. This fund receives revenue from a property tax levy and distributions are
received from St. Joseph County in June and December.
Expenditures are for debt service payments on capital leases and the due dates vary per lease.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Cumulative Capital Development
Capital & Debt Service Funds
City Funds
67
Fund Name Fund Number 407
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes 408,000 - 266,697 271,494 - 141,303 65%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,000 147 3,129 2,223 - 871 78%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 25,000 - 25,000 25,000 - - 100%
Transfers In - - - - - - 0%
Total Revenue 437,000 147 294,825 298,717 - 142,175 67%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 372,250 800 372,050 368,250 - 200 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 372,250 800 372,050 368,250 - 200 100%
Net 64,750 (653) (77,225) (69,533) - 141,975
Cash Balance 301,021 241,699
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund receives revenues from the hotel/motel tax as well as the cigarette tax. The fund is used to pay debt service on a Century Center bond.
Revenue in this fund includes $150,000 in hotel/motel taxes and $258,000 in cigarette taxes from other units of government. The hotel/motel tax
distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December.
This fund is used to pay 75% of the 2011 Century Center Refunding bonds. Payments on the Century Center bond are due in February and July.
Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Cumulative Capital Improvement
Capital & Debt Service Funds
City Funds
68
Fund Name Fund Number 412
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 28,000 1,380 23,302 17,704 - 4,698 83%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 1,028,786 - 1,028,861 1,355,375 - (75) 100%
Transfers In - - - - - - 0%
Total Revenue 1,056,786 1,380 1,052,163 1,373,079 - 4,623 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 1,468,808 93,796 489,827 30,226 844,602 134,379 91%
Debt Service - - - - - - 0%
Capital 1,001,900 - 21,700 628,607 213,957 766,243 24%
Transfers Out - - - - - - 0%
Total Expenditures 2,470,708 93,796 511,527 658,833 1,058,559 900,622 64%
Net (1,413,922) (92,416) 540,636 714,246 (1,058,559) (895,999)
Cash Balance 2,904,726 2,871,235
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2006 with the City's share of the proceeds for the lease of the Indiana Toll Road (I-80/90). The fund is used to finance
capital improvements projects and also makes loans to other funds. Annual revenue is the loan payments from those other funds. In recent years
the fund has been used in connection with the City's Smart Streets program.
Initial funding for the Major Moves fund in the amount of $12,823,151 was received from the State of Indiana on September 15, 2006, derived from
the State lease of the I-80 toll road to a private company. This fund has been used in the past to provide seed money for economic development
projects at Douglas Road, Eddy Street Commons, and the Triangle Development near Notre Dame. The amounts advanced for these projects are
being repaid by the respective tax increment financing (TIF) funds as per formal amortization schedules. In August the fund received the second of
two semi-annual payments on these loans, totaling $418,156 in principal and interest. Balances due are $181,081 from Fund 435 (Douglas Road)
and $3,342,237 from Fund 436 (River East Residential).
The 2017 budget continues funding for the Smart Streets initiative and includes $592K for Smart Streets, $250K for the Boland Trail and $80K for
Bendix Drive (both projects moved from the LRSA Fund 251). The $265K encumbered comprises $68K for the downtown portion of the 2-way
conversion of Main and Michigan/St. Joseph streets from Chippewa to LaSalle (the former IN-933), $1K for the Olive-Sample overpass.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Major Moves Construction
Capital & Debt Service Funds
City Funds
69
Fund Name Fund Number 416
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 100,000 4,654 56,504 77,177 - 43,496 57%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 6,500 304 5,150 4,067 - 1,350 79%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 106,500 4,958 61,654 81,244 - 44,846 58%
Expenditures
Personnel - - - - - - 0%
Supplies 20,958 - 3,603 8,422 - 17,355 17%
Services 80,186 - 14,143 23,762 32,075 33,968 58%
Debt Service - - - - - - 0%
Capital 300,000 - 133 - 172,125 127,742 57%
Transfers Out - - - - - - 0%
Total Expenditures 401,144 - 17,878 32,184 204,200 179,065 55%
Net (294,644) 4,958 43,776 49,061 (204,200) (134,220)
Cash Balance 633,609 565,786
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for capital projects at the Morris Performing Arts Center (MPAC).
This fund was established for the purpose of renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons of the
Morris Performing Arts Center. There is no staffing for this fund. Funds in this account are received from a per ticket surcharge included on every
sold ticket.
Dimmer Rack Upgrades (Lighting 1/3) in the amount of $31,474.92.
Marqee Upgrade in the amount of $250,000.00.
Public Elevator Repair - Upgrade in the amount of $43,000.00.
HVAC - Chiller Repair in the amount of $15,100.
Wi-Fi Upgrade in the amount of $12,000.00.
Water Softener Upgrade-Replacement in the amount of $22,000.00.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Morris Performing Arts Center Capital
Capital & Debt Service Funds
City Funds
70
Fund Name Fund Number 434
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - 573 - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 573 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - 2,977 - - 0%
Total Expenditures - - - 2,977 - - 0%
Net - - - (2,404) - -
Cash Balance - -
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund formerly received a special distribution of state tax revenue captured in the district and was used for debt service. This fund was closed
and the remaining cash transferred to COIT Fund #404.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Community Revitalization Enhancement District
Capital & Debt Service Funds
City Funds
71
Fund Name Fund Number 450
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,000 50 814 620 - 186 81%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 16,500 1,848 13,493 11,660 - 3,007 82%
Transfers In - - - - - - 0%
Total Revenue 17,500 1,898 14,308 12,280 - 3,192 82%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 5,000 - 627 - - 4,373 13%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 5,000 - 627 - - 4,373 13%
Net 12,500 1,898 13,681 12,280 - (1,181)
Cash Balance 106,591 88,694
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund provides funding for capital projects that preserve the historic character of the Palais Royale Ballroom.
This fund is funded through a portion of revenues received from functions held at the Palais.
There are no capital projects budgeted at this time.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Palais Royale Historic Preservation
Capital & Debt Service Funds
City Funds
72
Fund Name Fund Number 677
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 5,000 226 3,994 3,905 - 1,007 80%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 48,709 - - 0%
Transfers In - - - - - - 0%
Total Revenue 5,000 226 3,994 52,613 - 1,007 80%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 81,091 2,067 40,649 57,029 2,996 37,445 54%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 81,091 2,067 40,649 57,029 2,996 37,445 54%
Net (76,091) (1,841) (36,656) (4,416) (2,996) (36,439)
Cash Balance 458,784 498,837
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established to provide capital repairs and improvements at the former College Football Hall of Fame building. The fund received
distributions from the PSDA Tax Fund (377) through 2010.
The College Football Hall of Fame ceased operations in South Bend at the end of 2012.
Budgeted expenditures are for the utilities and maintenance of the building.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Football Hall of Fame Capital
Capital & Debt Service Funds
City Funds
73
Fund Name Fund Number 750
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 3,900 766 4,701 - - (801) 121%
Bond Proceeds 5,499,000 - 4,548,500 - - 950,500 83%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 5,502,900 766 4,553,201 - - 949,699 83%
Expenditures
Personnel - - - - - - 0%
Supplies 230,000 - - - - 230,000 0%
Services - - - - - - 0%
Debt Service - - 186 - - (186) 0%
Capital 5,270,000 912,178 3,239,278 - 1,679,544 351,178 93%
Transfers Out - - - - - - 0%
Total Expenditures 5,500,000 912,178 3,239,464 - 1,679,544 580,992 89%
Net 2,900 (911,411) 1,313,737 - (1,679,544) 368,706
Cash Balance 4,729,071 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to pay for City vehicles and equipment that are financed by a lease. The funds are maintained by trustee financial institutions and
expended upon the provision by the City of a proper claim form and invoice. The trustee escrow accounts have been maintained by the City for
many years and the desire is to integrate these records into the formal accounting system in 2017.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
The City leases certain vehicles and equipment for the police department, public works and other departments and pays them through capital lease
proceeds that are accounted for in this fund. These are the major budgeted capital expenditures:
Solid Waste - $275,000 CNG Trash Truck, $65,000 Pickup Truck with Dump Bed, $250,000 Grapple Truck
Police - $1,250,000 Police Cars, $250,000 Police Car Equipment
EMS - $1,000,000 Aerial Truck
Street Dept - $450,000 Tandem Axle Dump Trucks (Qty 2)
Building Dept - $90,000 2017 4WD Pickup Trucks (Qty 2), $45,000 2018 Chassis
Animal Care & Control - $30,000 Animal Box
Water Works - $960,000 Water Meters
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Equipment/Vehicle Leasing
Capital & Debt Service Funds
City Funds
74
Fund Name Fund Number 751
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 7,500 588 5,042 - - 2,458 67%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 7,500 588 5,042 - - 2,458 67%
Expenditures
Personnel - - - - - - 0%
Supplies 60,000 4,041 51,259 - 10,383 (1,642) 103%
Services 200,000 16,996 215,785 - 500 (16,285) 108%
Debt Service - - - - - - 0%
Capital 3,240,000 109,042 768,351 - 16,338 2,455,311 24%
Transfers Out - - - - - - 0%
Total Expenditures 3,500,000 130,079 1,035,395 - 27,221 2,437,384 30%
Net (3,492,500) (129,490) (1,030,353) - (27,221) (2,434,926)
Cash Balance 3,319,157 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to account for the bond proceeds and expenditures of the 2015 Parks/EDIT bond that is accounted for by US Bank in trustee
accounts. The original bond was issued in 2015 for $5,605,000. The City submits pay requests for costs incurred under the bond to US Bank. This
fund was established in 2017 to integrate these trustee accounts into the City's regular accounting system.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
The vast majority of the $435K spent on capital is for an HVAC upgrade at the Martin Luther King Center. Effective in May 2017, this fund will now
use PO's to encumber expenditures to enable tracking in NaviLine. The payments will still be made through the bond trustee, but the payments will
be cleared in NaviLine as well.
Capital expenditures include $350K for upgrades to the HVAC system at the Martin Luther King Center and $84K for miscellaneous park
improvements.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Parks Bond Capital
Capital & Debt Service Funds
City Funds
75
Fund Name Fund Number 753
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 17,000 250 4,536 - - 12,464 27%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 41,880 (20,000) 43,579 - - (1,699) 104%
Transfers In - - - - - - 0%
Total Revenue 58,880 (19,750) 48,115 - - 10,765 82%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - 1,500 - - (1,500) 0%
Debt Service - - - - - - 0%
Capital 10,000,000 406,356 4,906,328 - - 5,093,672 49%
Transfers Out - - - - - - 0%
Total Expenditures 10,000,000 406,356 4,907,828 - - 5,092,172 49%
Net (9,941,120) (426,106) (4,859,713) - - (5,081,407)
Cash Balance 1,069,741 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The purpose of the Smart Streets Bond Capital Fund is to account for the remaining expenditures from the bond issued in 2015 in the amount of
$25,000,000.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Conversion from 1-way to 2-way streets and other improvements associated with the conversion project.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Smart Streets Bond Capital
Capital & Debt Service Funds
City Funds
76
Fund Name Fund Number 287
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 75,000 - - - - 75,000 0%
Licenses & Permits - - - - - - 0%
Charges for Services 4,410,349 - 3,210,349 2,460,775 - 1,200,000 73%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 44,000 2,252 34,358 24,674 - 9,642 78%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 4,529,349 2,252 3,244,707 2,485,448 - 1,284,642 72%
Expenditures
Personnel - - - - - - 0%
Supplies 205,300 - - - - 205,300 0%
Services 1,075,099 111,850 723,792 428,228 218,555 132,753 88%
Debt Service 729,756 126 530,399 60,935 - 199,357 73%
Capital 1,981,311 26,913 1,241,594 866,024 519,649 220,068 89%
Transfers Out - - - - - - 0%
Total Expenditures 3,991,466 138,888 2,495,785 1,355,187 738,204 757,477 81%
Net 537,883 (136,636) 748,921 1,130,261 (738,204) 527,165
Cash Balance 4,378,455 3,702,502
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2015 to track capital expenditures related to Emergency Medical Services. The fund receives revenues from Medicaid
settlements and transfers from EMS Operating Fund (288). These funds are used for capital purchases such as fire apparatus, ambulances and
major construction projects.
In June, a payment of $471,088 was made to Indiana State Medicaid for a cost reimbursement program. In September, Ambulance #4 was rebuilt
for $166,644.
Planned purchase of ambulance & fleet vehicle.
In February, a new, smaller ambulance was purchased. In April, 5 homes were purchased for the new location of Fire Station #9, totaling $385,570.
In August, the City made a payment of $422,918 for the chassis on two fire trucks being built by Rosenbauer.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Emergency Medical Services Capital
Enterprise Funds
City Funds
77
Fund Name Fund Number 288
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 6,356,765 520,799 4,557,073 4,626,781 - 1,799,692 72%
Fines, Forfeitures, and Fees 2,500 - 1,400 2,200 - 1,100 56%
Interest Earnings 20,000 1,205 21,945 16,698 - (1,945) 110%
Bond Proceeds - - - - - - 0%
Donations 750 - 1,070 - - (320) 143%
Other Income 5,000 - 12,967 92,870 - (7,967) 259%
Transfers In - - - - - - 0%
Total Revenue 6,385,015 522,004 4,594,455 4,738,549 - 1,790,560 72%
Expenditures
Personnel 5,180,304 342,200 3,758,862 3,761,603 - 1,421,442 73%
Supplies 368,825 31,620 254,007 225,138 16,485 98,334 73%
Services 587,692 19,089 344,471 283,254 88,716 154,506 74%
Debt Service 1,093 - 318 451,120 1,729 (954) 187%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 6,137,914 392,910 4,357,657 4,721,115 106,930 1,673,327 73%
Net 247,101 129,095 236,798 17,434 (106,930) 117,233
Cash Balance 1,952,142 2,188,423
Staffing Budget Actual
Full Time 51.00 51.00
Part-Time /Seasonal/Temporary - 1.00
Total 51.00 52.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the expenditures of the Emergency Medical Services (EMS) program. The revenues in this account are generated through
user fees for the South Bend Fire Department EMS division, Training Bureau, and Inspections. This Fund captures personnel and operating
expenses primarily for Emergency Medical Services division and reflects a portion of the cost associated with operating ambulances.
A payment to Memorial Hospital of $32,700 was made per the contract. Also, $20,000 was spent on fire gear and clothing for the newly sworn
firefighters in July.
Fire Department and EMS capital expenditures are accounted for in the EMS Capital Fund #287.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Emergency Medical Services Operating
Enterprise Funds
City Funds
78
Fund Name Fund Number 600
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits 79,270 6,942 74,813 64,488 - 4,457 94%
Charges for Services 1,485,433 124,308 1,369,219 1,307,379 - 116,214 92%
Fines, Forfeitures, and Fees 289,000 13,851 88,416 62,004 - 200,584 31%
Interest Earnings 24,000 1,376 23,394 15,881 - 606 97%
Bond Proceeds - - - - - - 0%
Donations 4,000 - - 1,522 - 4,000 0%
Other Income 11,687 916 7,928 10,792 - 3,759 68%
Transfers In 2,167,316 - 1,625,487 1,582,551 - 541,829 75%
Total Revenue 4,060,706 147,393 3,189,257 3,044,617 - 871,449 79%
Expenditures
Personnel 2,683,460 208,339 2,082,745 1,916,263 - 600,715 78%
Supplies 127,282 4,450 83,818 59,980 7,050 36,414 71%
Services 902,974 86,890 673,833 596,044 33,586 195,555 78%
Debt Service 71,925 364 53,683 28,812 679 17,563 76%
Capital 2 2 2 70,285 - - 100%
Transfers Out - - - - - - 0%
Total Expenditures 3,785,643 300,045 2,894,081 2,671,383 41,316 850,247 78%
Net 275,063 (152,652) 295,176 373,234 (41,316) 21,203
Cash Balance 2,914,313 2,289,807
Staffing Budget Actual Fund Purpose:
Code Enforcement (600-1201)/Animal Control (600-1207)
Full Time 24.00 24.00
Part-Time /Seasonal/Temporary 1.50 1.50
Building Department (600-1306)
Full Time 14.00 14.00
Part-Time /Seasonal/Temporary 0.50 0.50
Total 40.00 40.00
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Code Enforcement (600-1201)/Animal Control (600-1207)
Building Department (600-1306)
Explain Significant Spending on Capital Projects Below:
Code Enforcement (600-1201)/Animal Control (600-1207)
Building Department (600-1306)
City Funds
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Consolidated Building Fund
Enterprise Funds
This fund accounts for the expenditures of the Building Department,
Code Enforcement, and Animal Care & Control. Code Enforcement
and Animal Care & Control are managed together, but are run
separately from the Building Department per the Common Council.
This portion of the fund comprises revenues and expenditures for Code Enforcement and its subsidiary, Animal Care and Control. While some revenues are derived
from fees for processing abandoned vehicles and animal control activities, the vast majority comes from a transfer from the EDIT fund. Most of the Other Income is
from collections for ordinance violations. The $2.1 million transfer is from the EDIT Fund to cover Code and Animal Control activities which, unlike the Consolidated
Building Department, are not enterprises by nature. Some revenues are derived from fees for processing abandoned vehicles and animal control activities.
The Building Department's purpose is to promote safe occupancy for all residents of the jurisdiction, serving all properties within the City of South Bend and all
properties with a 5 digit address within St. Joseph County.
The majority of the Building Department's expenses are for personnel costs, approximately 70% of the budget. Other expenses include vehicle lease payments, fuel
and repairs, building rent and cleaning/maintenance, and supplies.
Capital expenditures are for two pickup trucks. The first truck was paid for in January and the second in June.
Purchased 4 new vehicles (lease payments) in November 2016, first payments were in January 2017. The department acquired 3 new cars in June
2017 with a lease/purchase.
79
Fund Name Fund Number 601
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 1,039,479 114,171 1,005,510 800,679 - 33,969 97%
Fines, Forfeitures, and Fees 99,000 5,138 50,337 48,390 - 48,663 51%
Interest Earnings 13,500 625 9,515 5,532 - 3,985 70%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 11,282 - 4,719 113 - 6,563 42%
Transfers In - - - - - - 0%
Total Revenue 1,163,261 119,935 1,070,080 854,714 - 93,181 92%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 1,208,218 178,986 822,548 580,097 226,140 159,530 87%
Debt Service - - - - - - 0%
Capital 39,036 - - - 39,036 - 100%
Transfers Out - - - - - - 0%
Total Expenditures 1,247,254 178,986 822,548 580,097 265,176 159,530 87%
Net (83,993) (59,051) 247,532 274,617 (265,176) (66,349)
Cash Balance 1,218,103 915,234
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the revenues and expenditures from the various parking garages owned by the City of South Bend. Parking garage
operations are under outside contract with Downtown South Bend, Inc. Other contracts are for various repair & maintenance projects among the
garages.
The vast majority of the Services encumbrance is what remains of $892K for the annual Block By Block contract, for maintaining the garages and
assisting patrons. In addition to revenues for parking fees, $265K in revenue is a reimbursement from DTSB to the City to reimburse for the City's
expenditures to a third party for the Downtown Ambassador program.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Parking Garages
Enterprise Funds
City Funds
80
Fund Name Fund Number 610
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 6,025,275 460,448 4,461,861 4,596,227 - 1,563,414 74%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 3,900 165 3,689 2,506 - 211 95%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 74,166 362 74,528 50,522 - (362) 100%
Transfers In - - - - - - 0%
Total Revenue 6,103,341 460,975 4,540,077 4,649,256 - 1,563,264 74%
Expenditures
Personnel 1,781,122 125,200 1,319,636 1,232,423 - 461,486 74%
Supplies 237,532 19,184 202,129 269,678 3,816 31,588 87%
Services 2,800,961 195,781 2,077,090 2,425,183 102,040 621,831 78%
Debt Service 7,682 - - 9,700 - 7,682 0%
Capital - - - - - - 0%
Transfers Out 835,613 85,000 778,600 663,000 - 57,013 93%
Total Expenditures 5,662,910 425,165 4,377,455 4,599,984 105,856 1,179,599 79%
Net 440,431 35,809 162,622 49,272 (105,856) 383,664
Cash Balance 393,525 346,287
Staffing Budget Actual
Full Time 26.20 26.20
Part-Time /Seasonal/Temporary - -
Total 26.20 26.20
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the operations of the Solid Waste Department. It is funded by charging City residents a monthly fee for pick-up and disposal
of trash at area landfills and recycling centers. Funds are transferred out to the Solid Waste Capital Fund #611 for the payment of debt service
obligations as needed.
Recycling fees now charged to residents on their property tax bill is the main reason Service Revenue is running below budget expectations.
Transfers out to Fund #611 are done as needed to cover lease-purchase payments on capital equipment.
Solid Waste capital expenditures are accounted for in the Solid Waste Capital Fund #611.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Solid Waste Operations
Enterprise Funds
City Funds
81
Fund Name Fund Number 611
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - 300,000 - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,100 29 937 1,013 - 163 85%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 835,613 85,000 778,600 663,000 - 57,013 93%
Total Revenue 836,713 85,029 779,537 964,013 - 57,176 93%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 1,123,613 83,924 1,055,794 869,797 - 67,819 94%
Capital 12,000 - - - - 12,000 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,135,613 83,924 1,055,794 869,797 - 79,819 93%
Net (298,900) 1,105 (276,256) 94,216 - (22,644)
Cash Balance 60,191 94,659
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used for debt service and capital expenditures related to the Solid Waste Department. This fund receives transfers from the Solid
Waste Operations Fund #610.
A $300K State grant received in 2016 to cover part of the cost of new CNG fueled trash trucks will not be repeated this year. Transfers in from
operating Fund #610 are done as needed to have funds available for debt service payments, per City debt payment schedules.
With few exceptions, all vehicles and equipment are lease-purchased over a five year term. The debt service payments cover lease payments for
eleven trucks in the fleet. Four of them will be fully paid for in July 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Solid Waste Capital
Enterprise Funds
City Funds
82
Fund Name Fund Number 620
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 15,585,122 1,415,169 12,856,577 12,726,326 - 2,728,545 82%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 35,000 1,418 23,522 25,869 - 11,478 67%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 83,000 39 56,164 48,760 - 26,836 68%
Transfers In 62,500 2,530 50,272 36,852 - 12,228 80%
Total Revenue 15,765,622 1,419,155 12,986,535 12,837,808 - 2,779,087 82%
Expenditures
Personnel 5,604,157 400,348 4,185,273 4,165,238 - 1,418,884 75%
Supplies 1,727,233 116,449 986,921 1,013,185 198,583 541,729 69%
Services 6,228,201 450,706 4,080,465 3,964,739 473,679 1,674,057 73%
Debt Service 260,853 1,559 223,532 119,042 1,058 36,263 86%
Capital - - - - - - 0%
Transfers Out 3,906,810 312,827 3,279,542 3,632,301 - 627,268 84%
Total Expenditures 17,727,254 1,281,890 12,755,732 12,894,506 673,321 4,298,201 76%
Net (1,961,632) 137,266 230,803 (56,698) (673,321) (1,519,115)
Cash Balance 3,788,643 3,831,871
Staffing Budget Actual
Full Time 72.00 70.00
Part-Time /Seasonal/Temporary 3.56 2.00
Total 75.56 72.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established to account for all revenue and operational expenses of the water utility. This fund provides the monies for debt service
obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations.
Water Works capital expenditures are accounted for in the Water Works Capital Fund #622.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Water Works Operations
Enterprise Funds
City Funds
83
Fund Name Fund Number 622
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 24,000 1,073 19,559 21,794 - 4,441 81%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 24,000 1,073 19,559 21,794 - 4,441 81%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 1,414,466 2 404,551 310,392 463,906 546,009 61%
Transfers Out - - - - - - 0%
Total Expenditures 1,414,466 2 404,551 310,392 463,906 546,009 61%
Net (1,390,466) 1,071 (384,992) (288,598) (463,906) (541,569)
Cash Balance 2,202,524 2,591,810
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used for acquiring, constructing, and improving water utility capital assets. Water utility capital assets include Wells, Reservoirs,
Transmission and Distribution Mains, Pumping, Treatment and Transportation Equipment and other general plant items.
1 Ton 2 WD Dump Truck (1) $48,493
Freightliner Dump Truck (1) $177,777
Truck w/Utility Body (2) $88,840
Concrete/Asphalt Saw (1) $23,098
Hydraulic Breaker-Loader 586 (1) $11,843
WIP:
North Station Well #1 Replacement /Eng Design - $54,498
Encumb:
Hydro-Excavator Vactor (1) $345,848
Ford Transit Connect Cargo Van (3) $68,247
North Station Well #1 Replacement Project - $49,811
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Water Works Capital
Enterprise Funds
City Funds
84
Fund Name Fund Number 624
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 15,000 733 12,726 11,751 - 2,274 85%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 15,000 733 12,726 11,751 - 2,274 85%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 15,000 733 12,441 9,783 - 2,559 83%
Total Expenditures 15,000 733 12,441 9,783 - 2,559 83%
Net - - 285 1,968 - (285)
Cash Balance 1,506,840 1,542,464
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
Security deposits are collected from utility customers and are retained in this restricted fund. Upon termination of service, refunds are credit applied
to the customers final bill.
Revenue and expenditures are tied to the enrollment and termination of service.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Water Works Customer Deposit
Enterprise Funds
City Funds
85
Fund Name Fund Number 625
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 8,500 522 6,610 4,993 - 1,890 78%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 12,751 - 12,750 - - 1 100%
Transfers In 2,046,391 328,000 1,640,000 1,705,050 - 406,391 80%
Total Revenue 2,067,642 328,522 1,659,360 1,710,043 - 408,282 80%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 2,046,391 - 305,419 347,014 - 1,740,972 15%
Capital - - - - - - 0%
Transfers Out 8,500 522 6,601 4,987 - 1,900 78%
Total Expenditures 2,054,891 522 312,020 352,001 - 1,742,871 15%
Net 12,751 328,000 1,347,340 1,358,042 - (1,334,589)
Cash Balance 1,397,498 1,362,447
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. It receives transfers from the
Water Works Operations Fund #620.
Biannual debt service installments are disbursed at the end of June and December. June's payment includes 50% of the annual interest and
December's payment comprises the rest of the interest and all of the principal.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Water Works Sinking
Enterprise Funds
City Funds
86
Fund Name Fund Number 626
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 16,000 705 11,938 12,446 - 4,062 75%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 16,000 705 11,938 12,446 - 4,062 75%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 16,000 - 10,000 6,531 - 6,000 63%
Total Expenditures 16,000 - 10,000 6,531 - 6,000 63%
Net - 705 1,938 5,914 - (1,938)
Cash Balance 1,429,302 1,645,476
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The purpose of this fund is to ensure compliance with certain debt service bond covenants. Required balance is determined by debt service
financing arrangements at the time of issuance. 2017 cash reserve requirement is $1,421,206.
Interest earnings are transferred to Water Works Operations Fund #620. Additional investment earnings are scheduled for transfer in period 11.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Water Works Bond Reserve
Enterprise Funds
City Funds
87
Fund Name Fund Number 629
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 25,000 1,276 21,685 18,458 - 3,315 87%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 151,500 - 151,272 227,461 - 228 100%
Total Revenue 176,500 1,276 172,957 245,919 - 3,543 98%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 23,000 1,276 21,231 15,552 - 1,769 92%
Total Expenditures 23,000 1,276 21,231 15,552 - 1,769 92%
Net 153,500 - 151,727 230,367 - 1,773
Cash Balance 2,614,000 2,462,728
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies, and other
economic risks that may impact the Water Utility's ability to meet financial commitments.
The Cash Balance of this fund is equivalent to two months' worth of the amended annual operating expenditure budget in Water Works Operations
Fund #620, excluding transfers.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Water Works Reserve Operations & Maintenance
Enterprise Funds
City Funds
88
Fund Name Fund Number 640
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 613,924 52,805 532,305 521,303 - 81,619 87%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 18,500 896 15,084 13,162 - 3,416 82%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 632,424 53,701 547,389 534,464 - 85,035 87%
Expenditures
Personnel 219,798 16,819 172,584 126,385 - 47,214 79%
Supplies 37,970 1,412 15,390 16,087 11,702 10,877 71%
Services 362,444 25,211 244,318 234,175 32,006 86,119 76%
Debt Service 14,297 - 14,218 14,218 - 79 99%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 634,509 43,442 446,510 390,865 43,708 144,290 77%
Net (2,085) 10,260 100,879 143,600 (43,708) (59,255)
Cash Balance 1,860,148 1,803,992
Staffing Budget Actual
Full Time 2.70 2.70
Part-Time /Seasonal/Temporary - -
Total 2.70 2.70
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Sewer Insurance program is funded by a monthly charge on city residents' sewer bills. The city is responsible for the main sewer line; from the
main line to the house is the homeowner's responsibility. This program helps residents who have an issue with their lateral that cannot be resolved
by a simple clean-out by a plumber, i.e., collapsed line, complete root infiltration, etc. that requires excavation work. The program is set up so that
the homeowner pays a maximum $500.00 deductible toward the cost of the repair and the city pays the rest.
2017 Stats/Expenses:
1st quarter: "Successful" Second Opinions - 49; "Unsuccessful" Second Opinions - 9; "Digs" - 19. Total program expense $124,888.46.
2nd quarter: "Successful" Second Opinions - 31; "Unsuccessful" Second Opinions - 13; "Digs" - 12. Total program expense $83,975.79.
3rd quarter: "Successful" Second Opinions - 17; "Unsuccessful" Second Opinions - 9; "Digs" - 9. Total program expense $55,053.89.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewer Repair Insurance
Enterprise Funds
City Funds
89
Fund Name Fund Number 641
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 37,233,004 3,276,064 31,915,081 31,910,813 - 5,317,923 86%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 120,000 7,029 120,088 84,908 - (88) 100%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 153,691 4,175 126,762 43,769 - 26,929 82%
Transfers In 41,000 2,515 40,944 28,448 - 56 100%
Total Revenue 37,547,695 3,289,782 32,202,875 32,067,938 - 5,344,820 86%
Expenditures
Personnel 7,750,680 549,206 5,748,575 5,471,085 6 2,002,099 74%
Supplies 2,671,812 107,247 1,098,183 1,430,101 414,435 1,159,194 57%
Services 15,412,827 1,928,046 9,223,221 6,745,360 3,240,554 2,949,051 81%
Debt Service 943,719 1,797 669,132 560,104 - 274,587 71%
Capital - - - - - - 0%
Transfers Out 18,052,147 1,631,332 15,272,070 14,113,701 - 2,780,077 85%
Total Expenditures 44,831,185 4,217,627 32,011,181 28,320,351 3,654,996 9,165,009 80%
Net (7,283,490) (927,845) 191,695 3,747,587 (3,654,996) (3,820,189)
Cash Balance 13,884,406 12,521,585
Staffing Budget Actual
Full Time 94.25 91.25
Part-Time /Seasonal/Temporary 11.47 0.82
Total 105.72 92.07
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the operations of the Wastewater Department, Sewer Department, Organic Resources Department, and Concrete Crew.
Sewer rates have increased recently due to higher operating costs and to cover the costs for the EPA-mandated Long Term Control Plan (LTCP), a
construction project designed to address overflow issues.
There are no significant revenue or expenditure variances to report at this time.
Sewage Works capital expenditures are accounted for in the Sewage Works Capital Fund #642.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewage Works Operations
Enterprise Funds
City Funds
90
Fund Name Fund Number 642
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 52,000 3,426 53,889 60,336 - (1,889) 104%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 400,000 - 400,000 - - - 100%
Transfers In 4,442,000 500,000 3,442,000 2,487,000 - 1,000,000 77%
Total Revenue 4,894,000 503,426 3,895,889 2,547,336 - 998,111 80%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 8,051,255 402,622 3,949,930 3,711,340 1,116,250 2,985,074 63%
Transfers Out - - - - - - 0%
Total Expenditures 8,051,255 402,622 3,949,930 3,711,340 1,116,250 2,985,074 63%
Net (3,157,255) 100,804 (54,042) (1,164,004) (1,116,250) (1,986,963)
Cash Balance 7,162,971 7,610,935
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to purchase capital equipment and fund major renovations/restorations for the Wastewater and Sewer Departments. The primary
source of income is from Sewage Works Operating Fund #641, which transfers funds here as needed.
Higher than expected unspent cash balance in fund has resulted in higher than budgeted interest revenue.
The $400,000 other income was received in February from the Pokagon Band to cover part of the cost of a new lift station at the site of their tribal
village and casino.
Year to Date totals spent include:
Wastewater Treatment Plant Secondary Improvements $1,532,509, Grit & Screening Improvements $20,067
Calvert St. Lift Station $916,364, Digester Gas Utilization $558,461
East Bank 5 Sewer separation $73,600
Sewer Vactor Truck $331,398
Sewer Dept Crew Trucks $89,192
Sewer Dump Truck $207,540
Wastewater Crew Trucks $79,255
Wastewater Cargo Van, Lift Truck, Passenger cars $141,544
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewage Works Capital
Enterprise Funds
City Funds
91
Fund Name Fund Number 643
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 45,000 2,515 41,799 33,231 - 3,201 93%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 516,755 - 516,755 957,725 - - 100%
Total Revenue 561,755 2,515 558,554 990,955 - 3,201 99%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 30,000 2,515 40,944 28,448 - (10,944) 136%
Total Expenditures 30,000 2,515 40,944 28,448 - (10,944) 136%
Net 531,755 - 517,611 962,507 - 14,144
Cash Balance 5,153,129 4,636,374
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The purpose of this fund is to hold the equivalent of two month's of Sewage Works (Sewers & Wastewater) budgeted operating expenses in
reserve.
The funds transferred in were done to bring the fund balance in compliance with City policy. Interest earned on the fund balance is transferred out to
Sewage Works Operating Fund #641. The budget overdraft in this line will be corrected by year end.
Not applicable to this fund.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewage Works Reserve Operations & Maint.
Enterprise Funds
City Funds
92
Fund Name Fund Number 649
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 26,000 3,095 30,414 26,321 - (4,414) 117%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 9,164,024 762,798 7,627,975 7,620,169 - 1,536,049 83%
Total Revenue 9,190,024 765,892 7,658,389 7,646,490 - 1,531,635 83%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 9,163,754 - 1,081,626 1,148,456 - 8,082,128 12%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 9,163,754 - 1,081,626 1,148,456 - 8,082,128 12%
Net 26,270 765,892 6,576,763 6,498,034 - (6,550,493)
Cash Balance 7,392,425 7,302,775
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers from Sewage Works Operating Fund #641 are
done in specified amounts each month to satisfy bond covenants.
Debt has grown significantly in recent years as the City continues work on the EPA-mandated Long-Term Control Plan (LTCP). Debt service
payments are due in June and December.
Not applicable to this fund.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewage Sinking
Enterprise Funds
City Funds
93
Fund Name Fund Number 653
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 15,000 3,033 17,276 4,038 - (2,276) 115%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 15,000 3,033 17,276 4,038 - (2,276) 115%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 15,000 3,033 17,276 4,038 - (2,276)
Cash Balance 4,128,908 4,109,662
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for required debt service reserves as required by bond documents.
This Debt Reserve fund is held in a separate account at Bank of NY Mellon Trust. The account was fully funded for existing debt in 2013. A
reconciliation of this account is done on a monthly basis.
Not applicable to this fund.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewage Debt Service Reserve
Enterprise Funds
City Funds
94
Fund Name Fund Number 659
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 201 - 154 1,794 - 47 77%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 201 - 154 1,794 - 47 77%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 51,688 - 51,687 162,482 - 1 100%
Transfers Out 200 - - - - 200 0%
Total Expenditures 51,888 - 51,687 162,482 - 201 100%
Net (51,687) - (51,533) (160,687) - (154)
Cash Balance 145 71,207
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for expenditures of bond proceeds.
This Sewage Works Revenue Bond closed in October of 2011. The remaining cash balance has been nearly encumbered and is expected to be
spent this year. The significant projects this bond has funded are listed below.
From issue late in 2011, this bond has funded numerous projects including:
Diamond Ave. Trunk Sewer, Phase II $3.7 million
East Bank Sewer Separation, Phase II $2.8 million
East Bank Sewer Separation, Phase III $2.3 million
LaSalle School Area Sewer Separation, $1.7 million
East Bank Sewer Separation, Phase III $545,000
Southwood Sewer Separation, $1,438,816
Diamond Ave. Trunk Sewer, Phase III $248,000
St. Joseph River CSO Stabilization $217,831
Secondary Clarifier Upgrade $545,828
Wastewater Treatment Plant Digester Upgrade $5,945,471
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewer Bond 2011
Enterprise Funds
City Funds
95
Fund Name Fund Number 661
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 50,000 505 18,597 89,259 - 31,403 37%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 50,000 505 18,597 89,259 - 31,403 37%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 50,000 - - - - 50,000 0%
Debt Service - - - - - - 0%
Capital 2,960,364 235,348 2,263,409 10,167,911 632,186 64,769 98%
Transfers Out - - - - - - 0%
Total Expenditures 3,010,364 235,348 2,263,409 10,167,911 632,186 114,769 96%
Net (2,960,364) (234,843) (2,244,812) (10,078,652) (632,186) (83,367)
Cash Balance 641,544 5,174,082
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for expenditures of bond proceeds.
Current year spending from this Bond has been for:
East Bank Sewer Separation, Phase 5 $971,381
Wastewater Treatment Plant Grit/Screening Improvements $64,037
Wastewater Treatment Secondary Improvements $992,644
Since issue through December 2015, projects funded from this Bond include:
East Bank Sewer Separation-Phase 4 $2.6 million
Diamond Ave. Sewer Separation Phase 3, $2.6 million
Prairie Avenue Sewer Separation-Phase I $600,445
Southwood Sewer Separation $919,608
Fairfax Sewer $70,022
East Bank Sewer Separation-Phase 5 $2,331,436
Sewer Sensory Control Network $193,609
Wastewater Treatment Plant Grit/Screening Improvements $186,216
Secondary Improvements $3,723,987
CSO LTCP re-look $1,714,206
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Sewer Bond 2012
Enterprise Funds
City Funds
96
Fund Name Fund Number 664
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - 32 - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 32 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - 4,538 - - 0%
Total Expenditures - - - 4,538 - - 0%
Net - - - (4,506) - -
Cash Balance - -
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounted for issuance costs for the 2013A Sewer Refunding Bonds.
The issuance costs were paid in 2013. In 2016, the remaining cash balance was transferred to the Sewage Sinking Fund #649 to be used for loan
payments.
Not applicable to this fund.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
2013A Cost of Issuance Fund
Enterprise Funds
City Funds
97
Fund Name Fund Number 666
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - 114 - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 114 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - 2,500 - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - 6,705 - - 0%
Total Expenditures - - - 9,205 - - 0%
Net - - - (9,090) - -
Cash Balance - -
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounted for the issuance costs of the 2015 Sewer Bond refunding.
This fund was set up to pay the legal and financial accounting costs associated with the refunding of the 2006, 2007, and 2007B Sewer bonds. Most
of those expenses were paid in December 2015. In 2016, the cash balance in this fund was transferred to Sewage Sinking Fund #649 to be used
for loan payments.
Not applicable to this fund.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
2015 Sewer Bond Issuance
Enterprise Funds
City Funds
98
Fund Name Fund Number 670
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes 1,275,000 106,250 1,062,500 1,313,450 - 212,500 83%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 2,942,683 265,658 2,477,564 2,184,667 - 465,119 84%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 11,000 - 1,000 10,218 - 10,000 9%
Transfers In - - - - - - 0%
Total Revenue 4,228,683 371,908 3,541,064 3,508,335 - 687,619 84%
Expenditures
Personnel 2,327,806 174,988 1,857,364 1,800,149 - 470,442 80%
Supplies 513,040 62,968 486,821 543,299 - 26,219 95%
Services 1,144,768 122,154 977,742 1,046,145 - 167,026 85%
Debt Service - - - - - - 0%
Capital 126,529 - - - - 126,529 0%
Transfers Out 82,167 - 82,167 79,676 - - 100%
Total Expenditures 4,194,310 360,110 3,404,094 3,469,269 - 790,216 81%
Net 34,373 11,798 136,971 39,067 - (102,598)
Cash Balance 1,718,483 1,731,398
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the operating costs of Century Center, the City's convention center. Century Center is currently managed by SMG
Corporation.
Fund 670 and 671 are reported on an accrual basis, unlike the rest of the City's funds.
SMG has assumed management of Century Center effective July 1, 2013. One of their contractual duties is to reduce the operating deficit in the
fund. Covered by hotel/motel tax revenue which is received twice per year. The first installment was received in February 2015. Other income
includes charges to large conferences for electric costs.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Century Center
Enterprise Funds
City Funds
99
Fund Name Fund Number 671
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 750 74 722 787 - 28 96%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 750 74 722 787 - 28 96%
Expenditures
Personnel - - - - - - 0%
Supplies - - - 5,774 - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - 124,773 - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - 130,547 - - 0%
Net 750 74 722 (129,760) - 28
Cash Balance 866,708 872,312
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2012 to account for capital expenditures at Century Center. A separate capital bank account has been maintained.
Fund 670 and 671 are reported on an accrual basis, unlike the rest of the City's funds.
In 2013, the fund received a capital contribution of $575,000 from the new facility manager and a $100,000 allocation of Professional Sports
Development Area (PSDA) taxes. The remainder of these funds have been appropriated for spending during 2015. $25,000 was appropriated to
help pay for the Wall of Fame in conjunction with the South Bend Alumni Association. $50,000 was transferred out to the new fund 672 for bond
payments on the Energy Savings Contract.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Century Center Capital
Enterprise Funds
City Funds
100
Fund Name Fund Number 672
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 110,130 4 55,559 107,763 - 54,571 50%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 82,167 - 82,167 79,676 - - 100%
Total Revenue 192,297 4 137,726 187,439 - 54,571 72%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 192,297 96,169 191,297 236,132 - 1,000 99%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 192,297 96,169 191,297 236,132 - 1,000 99%
Net - (96,164) (53,571) (48,693) - 53,571
Cash Balance 3,482 1,339
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2015 to account for debt service payments of the 2015 Century Center Energy Conservation bonds.
This fund receives a federal interest rebate, transfers from Century Operating Fund (670), and a County hotel/motel tax allocation.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Century Center Energy Conservation Debt Svc
Enterprise Funds
City Funds
101
Fund Name Fund Number 222
Fund Type Date Updated 11/15/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits 11,400 518 5,461 10,816 - 5,939 48%
Charges for Services 3,754,119 303,647 2,638,455 2,480,325 - 1,115,664 70%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 6,800 491 8,485 8,648 - (1,685) 125%
Bond Proceeds - - - - - - 0%
Donations 10,000 - - - - 10,000 0%
Other Income 4,526,250 371,890 3,726,217 3,724,500 - 800,033 82%
Transfers In - - - - - - 0%
Total Revenue 8,308,569 676,545 6,378,618 6,224,289 - 1,929,951 77%
Expenditures
Personnel 3,288,165 234,571 2,330,079 2,119,425 - 958,086 71%
Supplies 170,652 17,693 100,005 65,127 14,179 56,468 67%
Services 4,803,170 377,160 3,803,055 3,810,911 637,683 362,432 92%
Debt Service 15,956 835 12,530 10,025 1,045 2,381 85%
Capital - - - - - - 0%
Transfers Out 286,700 - 286,700 - - - 100%
Total Expenditures 8,564,643 630,259 6,532,369 6,005,489 652,907 1,379,367 84%
Net (256,074) 46,287 (153,750) 218,800 (652,907) 550,584
Cash Balance 1,150,488 1,614,336
Staffing Budget Actual
Full Time 42.00 41.00
Part-Time /Seasonal/Temporary 2.00 2.00
Total 44.00 43.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Central Services Division consists of six cost centers that provide a variety of services to other city departments, along with several local
county, state and federal agencies.
In October we had 1,596 vehicle repairs. Average Fuel prices for Oct is $2.03 for Unleaded and $2.49 for Diesel. Budgeted amount per gallon is
$2.50. Equipment Services continues to purchase new vehicles with compressed natural gas or hybrids. The Compressed Natural Gas price is
$1.45. The gas tax increased on July 1, 2017 by $0.10. The large encumbrances for Services are the City Departments Utility Charges from the
Sustainability Departments account.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Central Services
Internal Service Funds
City Funds
102
Fund Name Fund Number 224
Fund Type Date Updated 11/15/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 900 18 688 879 - 212 76%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 286,700 - 286,700 - - - 100%
Total Revenue 287,600 18 287,388 879 - 212 100%
Expenditures
Personnel - - - - - - 0%
Supplies 28,000 - 23,273 22,299 - 4,727 83%
Services 69,025 25,071 61,729 10,495 6,255 1,040 98%
Debt Service - - - - - - 0%
Capital 229,000 - 114,180 173,396 - 114,820 50%
Transfers Out - - - - - - 0%
Total Expenditures 326,025 25,071 199,182 206,190 6,255 120,587 63%
Net (38,425) (25,053) 88,206 (205,311) (6,255) (120,375)
Cash Balance 200,367 (18,391)
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for capital expenditures for the Central Services department. This fund receives transfers from the Central Services Operating
Fund (222).
Replacement of Inground Hoists at the Riverside North Garage, new mobile portable lifts for Sample Street garage, one stand alone Hyd. Pres.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Central Services Capital
Internal Service Funds
City Funds
103
Fund Name Fund Number 226
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 2,927,591 252,319 2,438,843 1,848,922 - 488,748 83%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 42,000 2,096 38,159 35,574 - 3,841 91%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 606,643 120 36,762 13,615 - 569,881 6%
Transfers In - - - - - - 0%
Total Revenue 3,576,234 254,535 2,513,764 1,898,111 - 1,062,470 70%
Expenditures
Personnel 268,799 21,241 221,281 170,705 - 47,518 82%
Supplies 21,062 1,946 11,268 10,528 3,238 6,555 69%
Services 3,297,725 178,864 2,428,402 1,568,005 32,172 837,151 75%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 3,587,586 202,052 2,660,951 1,749,238 35,410 891,225 75%
Net (11,352) 52,483 (147,187) 148,873 (35,410) 171,245
Cash Balance 4,460,107 4,674,121
Staffing Budget Actual
Full Time 3.00 3.00
Part-Time /Seasonal/Temporary - -
Total 3.00 3.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This internal service fund handles operations relating to business insurance and claims--property, liability, workers compensation, etc.--and the
operation of the Safety and Risk Department. Revenues for this fund come from other City funds who pay a share proportionate to their expected
expense.
The City budgeted $1 million in 2017 for expected liability claims. At the end of October, only $247,385 had been spent.
The City budgeted $603,386 for expected workers compensation activities. At the end of October, workers compensation activities were $87,169
over budget. A 4th quarter budget transfer request will go before the Common Council to transfer funds to cover the overage.
The City budgeted $800,000 for the City's portion of cost of Beck's Lake clean-up.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Liability Insurance
Internal Service Funds
City Funds
104
Fund Name Fund Number 278
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - 45,680 - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 7,000 370 6,319 5,235 - 681 90%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 1,360 240 1,360 45,680 - - 100%
Transfers In - - - - - - 0%
Total Revenue 8,360 610 7,679 96,595 - 681 92%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 10,000 - 972 53 - 9,028 10%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 10,000 - 972 53 - 9,028 10%
Net (1,640) 610 6,707 96,542 - (8,347)
Cash Balance 759,559 738,014
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. Deductions from officers for gas and
insurance have been suspended for 2017 and are estimated to be suspended for 2018 in accordance with an agreement with the Fraternal Order of
Police (FOP). The agreement calls for the suspension of the deduction based on the price of gas and the balance of cash in this fund. This fund
pays for police vehicle off duty accident claims. Claims have been minimal in this fund since it was created. This fund is classified as an Internal
Service Fund for financial reporting.
The cash reserves in this fund have increased in recent years. The revenue is the amount deducted from officers' pay for the vehicle take home
program. The decrease in revenue is the result of suspending the payroll deduction for sworn officers as outlined in the agreement between the
Police Department and the FOP.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Take Home Vehicle Police
Internal Service Funds
City Funds
105
Fund Name Fund Number 279
Fund Type Date Updated
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 5,205,034 430,621 4,306,210 401,016 - 898,824 83%
Transfers In - - - - - - 0%
Total Revenue 5,205,034 430,621 4,306,210 401,016 - 898,824 83%
Expenditures
Personnel 2,053,699 151,760 1,515,730 373,772 - 537,969 74%
Supplies 981,191 4,575 52,187 2,657 17,443 911,561 7%
Services 2,006,824 363,130 1,242,902 24,589 251,652 512,270 74%
Debt Service 163,320 38,914 133,452 - - 29,868 82%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 5,205,034 558,378 2,944,271 401,018 269,096 1,991,668 62%
Net - (127,757) 1,361,939 (2) (269,096) (1,092,844)
Cash Balance 1,361,939 340
Staffing Budget Actual
Full Time 20.00 20.00
Part-Time /Seasonal/Temporary 2.00 2.00
Total 22.00 22.00
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This internal service fund was established in 2016 to track the operational revenues and expenditures on the 311 Call Center, whose expenses in
previous years were charged to the General Fund. The 311 Call Center was established to handle citizen telephone calls in an efficient and
effective manner. It provides citizens with a "one-stop" shop to contact city departments with inquiries and service requests.
Starting in 2017, the Department of Innovation & Technology was moved to this fund. The IT Dept provides technical services to the various
departments within the City.
This fund's revenue is a monthly allocation between the various City departments that are served by the 311 Call Center and IT Department.
Expenditures are predominantly related to salaries & benefits and IT software services. Outstanding encumbrances for supplies are for items that
have been ordered and not yet invoiced and for wiring that has been scheduled to be performed. Outstanding encumbrances for services are mainly
various software services. PO's are set at the beginning of the year, but services are paid out on a monthly basis. The major expenditures are for
Sungard NaviLine hosting, Amazon Web Services hosting, VoIP Phone Service, internet service, storage service, Tier1 Help Desk Support, and
MyStaffingPro.
The 311 Call Center has 6 full-time employees and 2 part-time employees. The Dept of Innovation & Technology has 14 full-time employees.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
IT / Innovation / 311 Call Center
Internal Service Funds
City Funds
106
Fund Name Fund Number 711
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 17,770,850 1,460,367 14,807,299 13,784,655 - 2,963,551 83%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 75,000 4,541 71,909 39,820 - 3,091 96%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 46,809 4,911 109,811 1,041,081 - (63,002) 235%
Transfers In - - - - - - 0%
Total Revenue 17,892,659 1,469,820 14,989,019 14,865,557 - 2,903,640 84%
Expenditures
Personnel - - - - - - 0%
Supplies 118,935 10,909 92,372 41,197 6,441 20,122 83%
Services 1,217,190 10,044 876,708 1,104,937 294,027 46,456 96%
Insurance 16,467,075 1,185,697 11,553,770 11,605,392 18,759 4,894,545 70%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 17,803,200 1,206,650 12,522,851 12,751,526 319,227 4,961,122 72%
Net 89,459 263,170 2,466,169 2,114,031 (319,227) (2,057,483)
Cash Balance 9,196,985 6,496,056
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund handles expenses relating to insurance and claims relating to employees, including medical, dental, life, flex spending, etc.
An Employee Wellness Center was opened on January 18, 2016, which was set in place with the understanding that the City should see a drop in
claims expenses over time.
For 2017, the City will pay the Wellness Center approx. $996,000. This accounts for the majority of the services budget and $236K of the remaining
services encumbrances.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Self-Funded Employee Benefits
Internal Service Funds
City Funds
107
Fund Name Fund Number 713
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - 88,848 - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,800 118 2,208 2,136 - 592 79%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 2,800 118 2,208 90,984 - 592 79%
Expenditures
Personnel 45,000 4,014 48,980 42,667 - (3,980) 109%
Supplies - - - - - - 0%
Services 39,105 309 5,290 17,070 11,000 22,815 42%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 84,105 4,323 54,270 59,737 11,000 18,835 78%
Net (81,305) (4,205) (52,062) 31,248 (11,000) (18,243)
Cash Balance 234,490 300,530
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2011 to account for unemployment claims and outplacement services paid. All unemployment claims and
outplacement services are paid through this fund.
Typically, this fund charges an allocation of 0.25% of payroll to most departments to cover the cost of unemployment claims paid. However,
beginning in Nov 2016, the charge of 0.25% of payroll costs was suspended indefinitely due to the fund's high cash reserves. The allocation will
remain suspended during 2017.
The personnel expenditures line item is unemployment compensation claims paid. Claims have been relatively stable. The services line item
includes a monthly administrative fee of $309 and a $11,000 encumbrances for potential outplacement services. To date, $2,200 has been paid for
outplacement services for one employee.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Unemployment Compensation
Internal Service Funds
City Funds
108
Fund Name Fund Number 701
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes 4,920,712 - 4,920,712 4,866,271 - - 100%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,500 - 711 1,123 - 3,789 16%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 4,679 - - 0%
Transfers In - - - - - - 0%
Total Revenue 4,925,212 - 4,921,423 4,872,074 - 3,789 100%
Expenditures
Personnel 5,091,119 378,906 3,861,052 4,340,349 - 1,230,067 76%
Supplies 200 - 10 19 - 190 5%
Services 6,950 70 3,719 4,025 - 3,231 54%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 5,098,269 378,976 3,864,781 4,344,393 - 1,233,488 76%
Net (173,057) (378,976) 1,056,642 527,681 - (1,229,699)
Cash Balance 1,224,214 999,200
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the operation of a pension plan for former Fire Department employees and receives reimbursement from the State of
Indiana. Retiree health insurance payments are paid through this fund through 2016; this cost is not reimbursed by the state.
The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid
and reported in the previous year. For 2017, the total amount received was $4,920,712.04. The first payment was received in June in the amount of
$2,461,856.02. The second payment was received in September in the amount of $2,458,856.02.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Firefighters Pension
Trust Funds
City Funds
109
Fund Name Fund Number 702
Fund Type Date Updated 11/17/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes 6,204,179 - 6,204,179 5,991,750 - - 100%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,500 - 2,810 3,713 - 1,690 62%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 15,000 12 14,580 13,395 - 420 97%
Transfers In - - - - - - 0%
Total Revenue 6,223,679 12 6,221,569 6,008,857 - 2,110 100%
Expenditures
Personnel 6,415,689 507,705 5,118,060 5,335,487 - 1,297,629 80%
Supplies 800 - - 67 - 800 0%
Services 7,400 90 3,822 3,981 - 3,579 52%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 6,423,889 507,795 5,121,881 5,339,534 - 1,302,008 80%
Net (200,210) (507,783) 1,099,688 669,323 - (1,299,898)
Cash Balance 1,892,242 1,827,527
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the operation of a pension plan for former Police Department employees and receives reimbursement from the State of
Indiana. Retiree health insurance is paid from this fund through 2016; this cost is not reimbursed by the state.
The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in
the previous fiscal year. For 2017, the total amount received was $6,204,179.46. The first payment was received in June in the amount of
$3,103,589.73. The second payment was received in September in the amount of $3,103,589.73.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Police Pension
Trust Funds
City Funds
110
Fund Name Fund Number 730
Fund Type Date Updated 11/16/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 280 14 242 221 - 38 86%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 280 14 242 221 - 38 86%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 6,000 599 599 - - 5,401 10%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 6,000 599 599 - - 5,401 10%
Net (5,720) (585) (357) 221 - (5,363)
Cash Balance 28,446 28,763
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This trust fund is designated for expenses specifically for the City Cemetery. Revenue was originally derived from the sale of cemetery plots and
burial expenses. There are few sites available for sale and most plots are occupied, resulting in little burial activity. This fund is managed by the
Parks Department.
$6,000 has been generically budgeted for repairs, but no specific projects exist at this time.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
City Cemetery
Trust Funds
City Funds
111
Fund Name Fund Number 324
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 17,808,613 - 8,932,881 9,769,452 - 8,875,732 50%
Local Income Taxes - - - - - - 0%
Other Taxes 394,000 196,500 394,000 396,000 - - 100%
Grants/Intergovernmental 243,745 - 244,301 63,990 - (556) 100%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 243,829 13,459 235,685 239,303 - 8,144 97%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 5,070,202 800 1,090,959 962,293 - 3,979,243 22%
Transfers In 29,000 1,354 22,723 17,795 - 6,277 78%
Total Revenue 23,789,389 212,113 10,920,549 11,448,833 - 12,868,840 46%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 4,781,763 344,867 1,258,592 656,313 2,298,518 1,224,653 74%
Debt Service 8,182,682 196,500 7,719,016 5,773,171 - 463,666 94%
Capital 26,654,442 1,544,797 6,922,024 9,907,227 8,907,850 10,824,568 59%
Transfers Out - - - - - - 0%
Total Expenditures 39,618,887 2,086,165 15,899,632 16,336,711 11,206,368 12,512,887 68%
Net (15,829,498) (1,874,052) (4,979,084) (4,887,877) (11,206,368) 355,953
Cash Balance 27,545,538 27,885,632
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the collection of Tax Increment Financing Revenues for the River West Development Area.
In 2016, major expenditures (other than debt service) included: Ignition Park Infrastructure; LaSalle Hotel; Safe Routes to School @ Harrison
School; Advanced Center for Cancer Care; Lippert; Nello; Western Restriping; Hoffman Hotel; Ignition Park Multi-Tenant Bldg.; Ignition Park Land
Improvements; Bartlett Roundabout; Coal Line Trail; Patel Hotel/Plaza; Ameriplex Lease; Chet Waggoner Drive; Airport Authority; Ignition Park
Signage.
Major capital expenditures thus far in 2017 include: $122K for Berlin Place; $265K for Chet Waggoner Drive; $278K for Coal Line Trail; $837K for
Four Winds Field Planning Area Improvements; $975K for Fire Station #4; $244K for Ignition Park Infrastructure; $605K for JMS Building; $140K
LaSalle Building; $857K Nello; $105K Olive Street Metronet; $230K Patel Hotel; $93K Project Lead the Way; $57K Southeast Master Plan and
$2.1M for Western Avenue Streetscape.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - River West Development Area (Airport)
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
112
Fund Name Fund Number 422
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 420,000 - 198,152 282,810 - 221,848 47%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 22,000 1,054 17,009 12,336 - 4,991 77%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 442,000 1,054 215,160 295,145 - 226,840 49%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 3,492 208 3,013 13,612 479 0 100%
Debt Service - - - - - - 0%
Capital 1,424,800 3,800 69,578 - 444,922 910,300 36%
Transfers Out - - - - - - 0%
Total Expenditures 1,428,292 4,008 72,591 13,612 445,401 910,300 36%
Net (986,292) (2,954) 142,569 281,533 (445,401) (683,461)
Cash Balance 2,103,628 1,790,243
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the TIF revenue and expenses of those funds on eligible development projects for this TIF area.
Major projects committed thus far in 2017 are: City Cemetery Project.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - West Washington
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
113
Fund Name Fund Number 425
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,706 82 1,399 1,278 - 307 82%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 195,308 3,471 90,411 107,265 - 104,897 46%
Transfers In - - - - - - 0%
Total Revenue 197,014 3,553 91,810 108,542 - 105,204 47%
Expenditures
Personnel - - - - - - 0%
Supplies 10,342 1,396 7,263 2,628 - 3,079 70%
Services 147,824 4,624 95,375 90,603 - 52,449 65%
Debt Service - - - - - - 0%
Capital - - - 35,400 - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 158,166 6,020 102,638 128,631 - 55,528 65%
Net 38,848 (2,467) (10,828) (20,089) - 49,676
Cash Balance 175,982 188,727
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund is used for South Bend downtown retail space property management.
Revenue and expenditures are reported one month in arrears.
Operations under outside contract with Bradley Co.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - Leighton Plaza (Redevelop Retail)
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
114
Fund Name Fund Number 429
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 3,000,000 - 1,428,046 1,170,979 - 1,571,954 48%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 8,400 - 2,450 700 - 5,950 29%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 72,000 3,955 64,697 59,458 - 7,303 90%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 156,067 - 156,065 68,401 - 2 100%
Transfers In - - - - - - 0%
Total Revenue 3,236,467 3,955 1,651,258 1,299,538 - 1,585,209 51%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 799,849 40,074 260,604 63,918 262,966 276,279 65%
Debt Service - - - - - - 0%
Capital 9,802,847 87,464 1,344,240 1,773,874 1,641,163 6,817,445 30%
Transfers Out - - - - - - 0%
Total Expenditures 10,602,696 127,537 1,604,844 1,837,792 1,904,128 7,093,724 33%
Net (7,366,229) (123,582) 46,414 (538,254) (1,904,128) (5,508,515)
Cash Balance 7,922,064 7,022,878
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The boundaries for this TIF district were changed during the 2015 TIF re-alignment. This fund was formerly known as the Northeast TIF.
Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Capital expenses thus far in
2017 include: $870K for East Bank CSO Phase V and $435K for Newman's Center/Armory project. Also, $149K for Howard Park Ice Rink design
services.
Projects committed to in 2017 include: East Bank Phase 5 CSO; Howard Park Ice Rink; Howard Park Improvements; Michiana Brick Demolition;
Niles/Jefferson Bridge Tunnel; Newman Center Armory; and Perley School (Safe Routes to School); Riverfront Parks & Trails; and Wharf
Development.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - River East Development Area (NE Dev)
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
115
Fund Name Fund Number 430
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 2,400,000 - 1,216,824 1,251,614 - 1,183,176 51%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 48,000 3,426 49,009 44,760 - (1,009) 102%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 1,468,127 - 1,466,348 - - 1,779 100%
Total Revenue 3,916,127 3,426 2,732,180 1,296,373 - 1,183,947 70%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 1,391,554 24,762 73,879 252,868 203,953 1,113,722 20%
Debt Service - - - - - - 0%
Capital 5,525,872 28,064 331,324 3,212,377 549,024 4,645,524 16%
Transfers Out - - - - - - 0%
Total Expenditures 6,917,426 52,826 405,203 3,465,246 752,977 5,759,246 17%
Net (3,001,299) (49,400) 2,326,977 (2,168,872) (752,977) (4,575,299)
Cash Balance 6,948,865 3,926,507
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the TIF revenue and expenses of those funds on eligible development projects for this TIF area.
Capital project thus far in 2017 is final expenses for Chippewa Roundabout.
Projects committed to in 2016 include: Chippewa Improvements, Ireland & Miami Area Improvements, and Safe Routes to School (Perley).
Major expenditures in 2017 are thus far: $305K on the Chippewa Roundabout. Additional projects approved include: $280K for Bowen Street
Improvements; $400K for Erskine Drainage Improvements; $1M for Erskine Golf Course Improvements; $105K for Ireland/Miami Improvements;
and $1.6M for South Well Field Improvements.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - Southside Development #1
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
116
Fund Name Fund Number 432
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 8,520 - 8,519 38,568 - 1 100%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 8,520 - 8,519 38,568 - 1 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 3,961,668 - 3,961,667 489,503 - 1 100%
Capital - - - - - - 0%
Transfers Out 917,127 - 905,117 - - 12,010 99%
Total Expenditures 4,878,795 - 4,866,784 489,503 - 12,011 100%
Net (4,870,275) - (4,858,265) (450,935) - (12,010)
Cash Balance - 4,851,461
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was used to pay debt service.
The bond was paid off in February 2017. The Redevelopment Commission passed a resolution in to close the allocation area. The remaining cash
will be transferred to South Side #1 (Fund 430) and the fund closed.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - Southside Development #3
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
117
Fund Name Fund Number 435
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 327,108 - 218,280 231,289 - 108,828 67%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,100 20 750 985 - 350 68%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 328,208 20 219,030 232,274 - 109,178 67%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 8,608 116 116 100 4,200 4,292 50%
Debt Service 335,608 - 335,608 341,188 - - 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 344,216 116 335,724 341,288 4,200 4,292 99%
Net (16,008) (96) (116,694) (109,014) (4,200) 104,886
Cash Balance 40,039 42,651
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Douglas Road TIF was established to develop the road and area near the border between South Bend and Mishawaka.
The fund borrowed money from the City of Mishawaka and Major Moves Fund (412) to finance construction. TIF tax revenue is used to repay the
loans. During February 2015, the amounts due to the City of Mishawaka was paid in full. Payments will now be accelerated on the Major Moves loan
in order to pay it off as early as available cash allows.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - Douglas Road
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
118
Fund Name Fund Number 436
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes 3,298,403 - 2,320,321 2,061,402 - 978,082 70%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - 210,999 - - 0%
Interest Earnings 2,500 - 442 2,109 - 2,058 18%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 3,300,903 - 2,320,763 2,274,510 - 980,140 70%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 263,901 1,331 1,331 1,100 - 262,570 1%
Debt Service 3,166,330 1,000 3,165,253 3,367,178 1,000 77 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 3,430,231 2,331 3,166,584 3,368,278 1,000 262,647 92%
Net (129,328) (2,331) (845,821) (1,093,768) (1,000) 717,493
Cash Balance 1,550,532 526,250
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The boundaries for this TIF district were changed as part of the TIF re-alignment during 2015. The fund was formerly known as the Northeast
Residential TIF.
Expenditures are related to debt service for the Eddy Street Commons Project--payment on the ESC Bonds and reimbursement to Major Moves
fund for project costs.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
TIF - River East Residential (NE Res)
Tax Increment Financing Funds
Redevelopment Commission Controlled Funds
119
Fund Name Fund Number 433
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 135 4 66 67 - 70 49%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 135 4 66 67 - 70 49%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 4,500 - 1,133 - - 3,367 25%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 4,500 - 1,133 - - 3,367 25%
Net (4,365) 4 (1,067) 67 - (3,298)
Cash Balance 7,386 8,769
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund's sole expenditure is for general legal fees for DCI.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Redevelopment General
Redevelopment Funds
Redevelopment Commission Controlled Funds
120
Fund Name Fund Number 439
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental 252,625 - 252,625 - - - 100%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 50,000 299 9,523 17,017 - 40,477 19%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 302,625 299 262,148 17,017 - 40,477 87%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 2,200,000 - 1,800,000 142,913 - 400,000 82%
Transfers Out - - - - - - 0%
Total Expenditures 2,200,000 - 1,800,000 142,913 - 400,000 82%
Net (1,897,375) 299 (1,537,852) (125,896) - (359,523)
Cash Balance 612,570 2,147,411
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund receives a special state tax distribution and is used for improvements at Innovation Park and Ignition Park, the city's two certified
technology parks.
Capital funds are to be expended in Ignition Park and Innovation Park. 2017 Appropriation was passed on 4/13/17. $1.8M will be used on
Innovation Park. Unlikely remaining funds will be spent in 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Certified Technology Park
Redevelopment Funds
Redevelopment Commission Controlled Funds
121
Fund Name Fund Number 454
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 3,900 188 3,219 2,938 - 681 83%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 3,900 188 3,219 2,938 - 681 83%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 50,000 - - - - 50,000 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 50,000 - - - - 50,000 0%
Net (46,100) 188 3,219 2,938 - (49,319)
Cash Balance 386,314 382,559
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund has been used in the past to pay for job training programs. Staff working to develop appropriate program to use these funds. Significant
staff turnover in DCI has impeded progress. Unsure if funds will be used this year.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Airport Urban Enterprise Zone
Redevelopment Funds
Redevelopment Commission Controlled Funds
122
Fund Name Fund Number 754
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 192,000 39,604 108,518 - - 83,482 57%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 31,824 12,210 17,034 - - 14,790 54%
Transfers In - - - - - - 0%
Total Revenue 223,824 51,814 125,552 - - 98,272 56%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 142,000 19,819 75,425 - - 66,575 53%
Debt Service 15,000 4,334 9,761 - - 5,239 65%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 157,000 24,153 85,186 - - 71,814 54%
Net 66,824 27,661 40,366 - - 26,458
Cash Balance 2,879,898 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Industrial Revolving Fund is a loan fund for small businesses that is governed by a separate Board of Directors which contracts with the City's
Community Investment Dept for administration services. The fund is reported in the City's Comprehensive Annual Financial Report (CAFR) and is
being integrated into the City's budget during 2017. A City cash reserve target has not been established for the fund but it operates under federal
guidelines with respect the amount of loans and cash balances that must be maintained.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Expenses include legal costs; staff contract costs; and professional services necessary to properly oversee operations and review new and
outstanding loans. Costs shown under debt service relate to Trustee fees charged by the Trustee bank.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Industrial Revolving Fund
Redevelopment Funds
Redevelopment Commission Controlled Funds
123
Fund Name Fund Number 315
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 14,000 507 8,694 8,013 - 5,306 62%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 14,000 507 8,694 8,013 - 5,306 62%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 14,000 507 8,502 6,663 - 5,498 61%
Total Expenditures 14,000 507 8,502 6,663 - 5,498 61%
Net - - 192 1,351 - (192)
Cash Balance 1,038,904 1,038,904
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income
which is promptly transferred out to the corresponding TIF fund (324 - River West). Any variance in the trend of interest income will be due to
changes in City prevailing interest rates City is able to secure.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Redevelopment Bond - Airport Taxable
Debt Service Funds
Redevelopment Commission Controlled Funds
124
Fund Name Fund Number 317
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 5,000 252 4,306 3,930 - 694 86%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 5,000 252 4,306 3,930 - 694 86%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 5,000 252 4,306 3,930 - 694
Cash Balance 516,773 511,749
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund was established in 2010 to collect reserve monies as stipulated in the bond covenants. The fund receives interest earnings revenue. This
fund will be used to make the final debt service payment on January 15, 2019.
The fund is at the proper level per the bond financial advisor, Crowe Horwath. No additional transfers-in are needed. Any interest variations due to
City policy on investments and increase in cash available to earn interest.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Coveleski Debt Service Reserve
Debt Service Funds
Redevelopment Commission Controlled Funds
125
Fund Name Fund Number 328
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 20,000 847 14,541 13,389 - 5,459 73%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 20,000 847 14,541 13,389 - 5,459 73%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 15,000 847 14,220 11,132 - 780 95%
Total Expenditures 15,000 847 14,220 11,132 - 780 95%
Net 5,000 - 320 2,257 - 4,680
Cash Balance 1,735,840 1,735,840
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income
which is promptly transferred out to the corresponding TIF fund (324 - River West). Any variance in the trend of interest income will be due to
changes in City prevailing interest rates City is able to secure.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Redevelopment Bond - Palais Royale
Debt Service Funds
Redevelopment Commission Controlled Funds
126
Fund Name Fund Number 752
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,500 682 2,857 - - (357) 114%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 3,866,169 - 3,690,500 - - 175,669 95%
Total Revenue 3,868,669 682 3,693,357 - - 175,312 95%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 3,868,164 - 3,826,263 - - 41,901 99%
Capital - - - - - - 0%
Transfers Out 735,241 - 735,240 - - 1 100%
Total Expenditures 4,603,405 - 4,561,503 - - 41,902 99%
Net (734,736) 682 (868,146) - - 133,410
Cash Balance 364,624 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The South Bend Redevelopment Authority Funds records debt service payments received by the City that are passed through to the paying agent
bank and the bondholders per bond agreements. The South Bend Redevelopment Authority is a separate legal entity that is recorded in the
Comprehensive Annual Financial Report (CAFR). This fund was established in 2017 to integrate this activity into the City's formal accounting
system.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Debt service payments are for the 2009 Morris PAC refunding (debt schedule #11), 2011 Century Center refunding (#7), 2013 Century Center
refunding (#62), and 2015 Eddy Street Commons refunding (#54). Debt payments are made twice a year, in February and August.
The 2009 Morris PAC bonds are scheduled to be paid off in 2017 and the 2011 Century Center bonds are scheduled to be paid off in 2018.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
South Bend Redevelopment Authority
Debt Service Funds
Redevelopment Commission Controlled Funds
127
Fund Name Fund Number 756
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,500 329 2,417 - - 83 97%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 854,784 - 856,500 - - (1,716) 100%
Total Revenue 857,284 329 858,917 - - (1,633) 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 1,252,284 - 1,249,569 - - 2,715 100%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,252,284 - 1,249,569 - - 2,715 100%
Net (395,000) 329 (390,652) - - (4,348)
Cash Balance 1,717,789 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
The Smart Streets Debt Service Fund records debt service payments made on the 2015 Smart Streets bond that had a par amount of $25,000,000.
The final payment is due February 1, 2037. The accounting records are maintained in US Bank trustee accounts and, beginning in 2017, will be
integrated into the City's regular accounting system.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
City lease rental payments are received from the River West TIF Fund (324). The Smarts Streets project converted a number of downtown streets
from one-way to two-way traffic and added amenities such as larger sidewalks, bicycle lanes, street trees to increase the attractiveness and
economic vitality of the downtown area.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Smart Streets Debt Service
Debt Service Funds
Redevelopment Commission Controlled Funds
128
Fund Name Fund Number 758
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 115 - 114 - - 1 100%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 3,961,667 - 3,961,667 - - - 100%
Total Revenue 3,961,782 - 3,961,781 - - 1 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 3,961,668 - 3,961,668 - - 1 100%
Capital - - - - - - 0%
Transfers Out 561,250 - 561,230 - - 20 100%
Total Expenditures 4,522,918 - 4,522,898 - - 20 100%
Net (561,136) - (561,117) - - (19)
Cash Balance - -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
In February 2017, the 2005 Erskine Village Developer Bond was paid off early, thanks to sufficient tax increment financing revenue. The City plans
to close this fund in 2017.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Erskine Village Debt Service
Debt Service Funds
Redevelopment Commission Controlled Funds
129
Fund Name Fund Number 759
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - 22,500,000 - - (22,500,000) 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - 22,500,000 - - (22,500,000) 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - 396,250 - - (396,250) 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - 396,250 - - (396,250) 0%
Net - - 22,103,750 - - (22,103,750)
Cash Balance 22,103,750 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the expenditures of the bond proceeds from the $25 million Eddy Street Commons Bond issued in 2017 (closing date
8/14/17, debt schedule #163). The funds will be spent on Phase II of the Eddy Street Commons mixed use development near the University of Notre
Dame.
This fund accounts for the cash in 3 trustee bank accounts: Bond Issuance Cost, Hotel Construction Fund, and Mixed-Use Construction Fund.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
In August 2017, the $25 million in bond proceeds was deposited into the trustee bank. $22.5 million was deposited into Fund 759 and $2.5 million
was deposited in Fund 760. The cost of issuance was $396,250, paid out of Fund 759.
Since this fund was established mid-year, the City will file an additional appropriations request for any 2017 expenditures.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Eddy Street Commons Capital
Capital & Debt Service Funds
City Funds
130
Fund Name Fund Number 760
Fund Type Date Updated 11/20/2017
Control
Current Current Current Prior
Amended Month Year to Date Year to Date Current Budget Percent of
Budget Actual Actual Actual Encumbrances Balance Budget
Revenue
Property Taxes - - - - - - 0%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - 233 233 - - (233) 0%
Bond Proceeds - - 2,500,000 - - (2,500,000) 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - 233 2,500,233 - - (2,500,233) 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net - 233 2,500,233 - - (2,500,233)
Cash Balance 2,500,233 -
Fund Purpose:
Accounting Methodology:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
This fund accounts for the receipt of payments from the City's North East Residential Area TIF Fund (436) and the subsequent semi-annual
payment of debt service principal and interest to the bondholders. The par amount of the 2017 Eddy Street Commons Bond was $25 million and the
final payment is due February 15, 2037. This fund will hold a minimum of $2.5 million in cash reserves per the bond covenant. The bonds were
closted on August 14, 2017 and ther first debt service payment is due on February 15, 2018. A debt service reserve amount of $2.5 million dollars
was established at the debt closing.
Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus,
changes are entered in the general ledger the following month. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
The principal and interest payments are set forth in the 20 year debt amortization schedule with the first payment made on February 15, 2018 and
the final payment on February 15, 2037. The bond was issued for Phase II of the Eddy Street Commons mixed use development near the University
of Notre Dame.
City of South Bend, Indiana
Monthly Financial Report
October 31, 2017
Eddy Street Commons Debt Service
Capital & Debt Service Funds
City Funds
131