Loading...
HomeMy WebLinkAbout06-2014 Controller's Cash ReportTab Page Overview 2 Controller Cash 3 -5 Cash 6 -7 Distribution Period Ending: Issued By: June 2014 Controller City of South Bend Controller's Cash Report Contents Overview of Controller's Cash Report Controller's Cash Report Bank Account Cash Balances Mayor Deputy Mayor Chief of Staff Deputy Chief of Staff City Controller Deputy City Controller City Finance Director Sr. Financial Specialist South Bend City Council Members Department Heads City Fiscal Officers Pete Buttigieg Mark Neal Kathryn Roos Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman 2014 June. controllers cash report Page 1 of 7 CONTROLLER'S CASH REPORT olrTx'6�: The Controiler'sCkahRepmmtisammd =maryof rash sod msestmmftrmmc ;mswithm the nment period by Fad It swims the rash re€eiti-A irferest name ,€ash disbmsEd and cash transferred between Fads xis We City Smth Bend as well a5 ffiy laam s amnn� "barn eau Fmd5. The report pmmSides a mmn&-emd view flf the Chy's rash balance in the r,'Pordmg pericd The City's manm teamis respomsible for establishing and maw an imemal control s mctrme designed to crime that the assets of the CVy are prourled from lins, theft or misuse and to a sure that adegmGe aimaLugug dab is compiled bD allow for the preparation of fimnool statemenrs m roafommigv nith gEnerally accepted actamtg principles. Jane 2414 HIGHI UM: (h-erall: In Jump, propeEtytwi receipts were $24.3 milli mi Thus 15 the fast mftwo install— m2014. TbiL sercad mstallemut is ExpeoW in December- Total cashbdmceatJane34 ,2014 was $$251.7m0irml TaW City Fonds {p& 3): Jima 2014 begmming rash balance of $162529,595 and exl5 cash halaare of $190,511,743 repme;t= an incase in cash of —*27.9 million Compared to Jumte 2013; beghcdng cash bmLamce of 3178,024,712 and ending cash balance of $204,NO,247 rep mauls On i13Mase in €ash of mppro=ml-v $26A millm. Iu comparisaiL &m is m increase y-o-y brar mw year) of -$1.3 mil in ncvmue. Total Rederelapmemt CbmmiissraaFr ads W): Jime 2014begia g cash bah me of 346,795,213 and imdrmg €ash balaxe of $61,188,881 repr A= as iK-ranm mn cash of 314.4 mrllrom_ Compared to JEme '_1413 beonmmg cash babmce of V2- 0771674 and etffing cash balance of $55,157,472 mepmese= an uLmmLLin cash 4f 113.1 milluaa 1n c4mparisnn� there i5 an tcrease y-o-y of31.3 miLlim In m me. hiaease m mvemm is pnimm ly from property to d35tr3bubms acerved from the Comity Fud 101(Cenerml Fmd): ]me 2414 actual receipts were $22 45,464 L'S- prla YRU arttCd receipts of $22,214, 425. The largest receipt thus mnrdh was from 5L kseph Comty fm property taxes m the amount of 324,062,834. Fm d 201 (Pula & Rea-eahioa): Jae 2414 actual reL61% were $4,687 75 53- prior year actual receipts of 34, 744, 714. The largest receipt this m ml was ffem the Comfy for property taxes m the amnmt of $4,021,402. Fm 4313 (HaIl of Fum): property taaesre€ h-ed thrs m=htotabd $289,140, tbas prosy ndhdem €ash far the neat debt sen-ice payment in tiny. Feed 407 (Comb ire Capatd lmprmmmrat): This fmd m lamer shows a negative cash balance for a debt seMUM- nIMtof$185,250 made emiiermisymr- Ciguam tax distnbuti mreceivedthismnoth tailed 3123, 553, tins pm Ehig saffidemt cash for the next debt semce payment im July. Fm d 741 amW 702 (Fue ad Police Pe>Ldoa): These foods im long lase a negatnm balance as a remit of monmly pewam paymews made to poLi€e ohs and frefiotm hired pmiom to May 1, 1977. This march, the mmdmy state pmisuoa relief distnbntion was received Fmmd 741(Fire) reoe:b ed -$2.5 mullion and fmmd 702 (Police) reren -ed 13.0 milliaq tiara prmad sufoemd rash tom moatbly disbrnsemen:ts. This dlismbmm is mvm+ed tRi€e a year, Jae and October, as reimbursement fDrexpeD&tmspmdmdm pmeuiams fiscal year. FarImme 2014, ash umtterestmceh -ed was 351,939 cammpared lo $98,112 inJm►e 2013 please Contact City Controller Johmhimphyat (574)23S-75L111 with artygoest rwm 2 of 7 2014 June. controllers cash report - Overview City of South Bend Controller's Cash Report Month of. June 2014 City Controlled Funds General Fund 101 GENERAL FUND 11.741.311.75 1 $22.845.404.42 1 $4.350.075.38 $3.147.50 $0.00 $0.00 30.239.788.29 0.00 30.239.788.29 615.321.19 Special Revenue Funds Opening Interest Transfers Transfers Ending Total Cash & Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In out Cash Balance Investments Investments (Borrowing) City Controlled Funds General Fund 101 GENERAL FUND 11.741.311.75 1 $22.845.404.42 1 $4.350.075.38 $3.147.50 $0.00 $0.00 30.239.788.29 0.00 30.239.788.29 615.321.19 Special Revenue Funds 102 RAINY DAY FUND 8,632,262.60 0.00 0.00 2,090.91 0.00 0.00 8,634,353.51 0.00 8,634,353.51 0.00 201 PARKS & RECREATION 538,567.89 4,687,975.33 1,285,290.82 193.24 0.00 0.00 3,941,445.64 0.00 3,941,445.64 0.00 202 MOTOR VEHICLE HIGHWAY 3,965,073.40 610,526.38 502,063.05 900.29 0.00 0.00 4,074,437.02 0.00 4,074,437.02 0.00 203 RECREATION - NONREVERTING 882,904.31 104,781.66 81,948.48 215.41 0.00 0.00 905,952.90 0.00 905,952.90 0.00 209 STUDEBAKER /OLIVER REVERTING GRANTS 1,085,217.07 0.00 0.00 262.86 0.00 0.00 1,085,479.93 0.00 1,085,479.93 500,000.00 210 DEPT COMMUNITY INVESTMENT STATE GRANTS 349,575.22 0.00 18,002.61 84.67 0.00 0.00 331,657.28 0.00 331,657.28 0.00 211 DCI OPERATING FUND 963,602.37 37,693.33 174,698.35 251.99 0.00 0.00 826,849.34 0.00 826,849.34 0.00 212 DEPARTMENT OF COMMUNITY INVESTMENT 552,875.36 221,277.99 188,235.01 223.22 0.00 0.00 586,141.56 0.00 586,141.56 0.00 216 POLICE STATE SEIZURES 182,467.57 0.00 0.00 39.59 0.00 0.00 182,507.16 0.00 182,507.16 0.00 217 GIFT, DONATION, BEQUEST 93,202.74 0.00 0.00 22.99 0.00 0.00 93,225.73 0.00 93,225.73 0.00 218 POLICE CURFEW VIOLATIONS 11,704.78 125.00 0.00 2.83 0.00 0.00 11,832.61 0.00 11,832.61 0.00 220 LAW ENFORCEMENT CONTINUING EDUCATION 998,414.27 18,389.70 22,041.39 241.94 0.00 0.00 995,004.52 0.00 995,004.52 0.00 227 LOSS RECOVERY FUND 7,605,951.53 2,441.50 132,986.92 1,849.92 0.00 0.00 7,477,256.03 0.00 7,477,256.03 0.00 244 EMERGENCY TELEPHONE SYSTEM 118,968.26 0.00 11,972.50 0.00 0.00 0.00 106,995.76 0.00 106,995.76 0.00 249 PUBLIC SAFETY L.O.I.T. 1,686,442.29 531,669.10 614,033.85 384.49 0.00 0.00 1,604,462.03 0.00 1,604,462.03 0.00 251 LOCAL ROADS & STREETS 2,385,043.77 90,929.81 43,935.69 572.74 0.00 0.00 2,432,610.63 0.00 2,432,610.63 0.00 252 EXCESS WELFARE DISTRIBUTION 1,151.74 0.00 0.00 0.28 0.00 0.00 1,152.02 0.00 1,152.02 0.00 258 HUMAN RIGHTS - FEDERAL GRANT 421,322.23 43.90 15,321.84 103.77 0.00 0.00 406,148.06 0.00 406,148.06 0.00 271 EASTRACE WATERWAY 5,304.76 0.00 0.00 2.71 0.00 0.00 5,307.47 0.00 5,307.47 0.00 273 MORRIS PAC /PALAIS ROYALE MARKETING 25,415.71 1,112.00 546.56 6.13 0.00 0.00 25,987.28 0.00 25,987.28 0.00 280 POLICE BLOCK GRANTS 3,823.64 0.00 0.00 0.93 0.00 0.00 3,824.57 0.00 3,824.57 0.00 281 DEPT. COMMUNITY INVESTMENT - REV BONDS 27,173.55 0.00 0.00 6.58 0.00 0.00 27,180.13 0.00 27,180.13 0.00 289 HAZMAT 16,234.60 0.00 0.00 3.94 0.00 0.00 16,238.54 0.00 16,238.54 0.00 291 INDIANA RIVER RESCUE 120,146.33 3,600.00 6,013.58 28.91 0.00 0.00 117,761.66 0.00 117,761.66 0.00 292 POLICE GRANTS 133,166.25 0.00 0.00 0.00 0.00 0.00 133,166.25 0.00 133,166.25 0.00 294 REGIONAL POLICE ACADEMY 75,108.63 0.00 564.20 18.51 0.00 0.00 74,562.94 0.00 74,562.94 0.00 295 COPS MORE GRANT 112,094.18 1,346.46 1,795.09 27.16 0.00 0.00 111,672.71 0.00 111,672.71 0.00 299 POLICE FEDERAL DRUG ENFORCEMENT 360,651.95 4,256.00 3,957.41 81.70 0.00 0.00 361,032.24 0.00 361,032.24 0.00 404 COUNTY OPTION INCOME TAX 14,959,654.31 763,938.15 667,948.73 3,567.32 0.00 0.00 15,059,211.05 0.00 15,059,211.05 2,027,973.00 408 ECONOMIC DEVELOPMENT INCOME TAX 10,063,969.39 733,068.39 121,261.10 2,336.48 0.00 0.00 10,678,113.16 0.00 10,678,113.16 0.00 410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 27,633.66 0.00 0.00 6.69 0.00 0.00 27,640.35 0.00 27,640.35 (2,027,973.00) 655 PROJECT RELEAF 1,072,057.96 36,337.98 2,017.81 256.18 0.00 0.00 1,106,634.31 0.00 1,106,634.31 0.00 705 POLICE K -9 UNIT 2,316.53 0.00 0.00 0.56 0.00 0.00 2,317.09 0.00 2,317.09 0.00 Total Special Revenue Funds 57,479,498.85 7,849,512.68 3,894,634.99 1 13,784.94 1 0.00 1 0.00 61,448,161.48 0.00 61,448,161.48 500,000.00 Debt Service Fund 313 HALL OF FAME DEBT SERVICE 117,534.46 301,607.06 0.00 0.00 0.00 0.00 419,141.52 0.00 419,141.52 0.00 Capital Project Funds 288 EMS / FIRE DEPARTMENT CAPITAL 4,411,340.57 355,801.34 157,315.03 1,080.95 0.00 0.00 4,610,907.83 0.00 4,610,907.83 0.00 377 PROFESSIONAL SPORTS DEVELOPMENT 574,242.65 121,525.00 0.00 139.09 0.00 0.00 695,906.74 0.00 695,906.74 0.00 401 COVELESKI STADIUM CAPITAL 26,895.45 0.00 0.00 6.52 0.00 0.00 26,901.97 0.00 26,901.97 0.00 403 ZOO ENDOWMENT 49,105.19 0.00 0.00 11.90 0.00 0.00 49,117.09 0.00 49,117.09 0.00 405 PARK NONREVERTING CAPITAL 437,124.98 648.00 66.60 92.33 0.00 0.00 437,798.71 0.00 437,798.71 0.00 406 CUMULATIVE CAPITAL DEVELOPMENT 501,488.39 258,935.96 56,545.49 135.44 0.00 0.00 704,014.30 0.00 704,014.30 0.00 407 CUMULATIVE CAPITAL IMPROVEMENT (8,442.52) 123,553.13 0.00 0.00 0.00 0.00 115,110.61 0.00 115,110.61 0.00 412 MAJOR MOVES CONSTRUCTION 7,003,210.26 0.00 119,866.50 1,707.68 0.00 0.00 6,885,051.44 0.00 6,885,051.44 5,794,045.96 416 MORRIS PERFORMING ARTS CENTER CAPITAL 496,569.47 1,497.00 0.00 119.63 0.00 0.00 498,186.10 0.00 498,186.10 0.00 2014 June. controllers cash report - Controllers Cash Report Page 3 of 7 City of South Bend Controller's Cash Report Month of. June 2014 434 CREED FUND (11,308.87) Opening 0.00 24.85 Interest Transfers Transfers Ending (11,284.02) Total Cash & Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing) 434 CREED FUND (11,308.87) 0.00 0.00 24.85 0.00 0.00 (11,284.02) 0.00 (11,284.02) 0.00 450 PALAIS ROYALE HISTORIC PRESERVATION 56,272.63 841.35 0.00 13.61 0.00 0.00 57,127.59 0.00 57,127.59 0.00 677 HALL OF FAME CAPITAL FUND 618,250.20 0.00 3,079.49 150.48 0.00 0.00 615,321.19 0.00 615,321.19 (615,321.19) Total Capital & Debt Service Funds 14,272,282.86 1,164,408.84 336,873.11 3,482.48 0.00 0.00 15,103,301.07 0.00 15,103,301.07 5,178,724.77 Enterprise Funds 600 CONSOLIDATED BUILDING DEPARTMENT 615,200.92 195,826.18 190,197.23 167.49 0.00 0.00 620,997.36 0.00 620,997.36 0.00 601 PARKING GARAGES 964,646.68 96,280.40 46,561.66 234.39 0.00 0.00 1,014,599.81 0.00 1,014,599.81 0.00 610 SOLID WASTE OPERATIONS 436,597.45 422,236.95 401,939.42 130.06 0.00 0.00 457,025.04 0.00 457,025.04 0.00 611 SOLID WASTE CAPITAL 66,178.59 0.00 10,821.39 9.89 0.00 0.00 55,367.09 0.00 55,367.09 0.00 620 WATER WORKS OPERATIONS 3,115,155.34 1,451,863.59 1,063,455.81 744.57 1,057.80 179,374.06 3,325,991.43 0.00 3,325,991.43 0.00 622 WATER WORKS CAPITAL 3,534,086.62 0.00 53.34 856.03 0.00 0.00 3,534,889.31 0.00 3,534,889.31 0.00 623 WATER WORKS BOND CAPITAL 366,275.24 0.00 430.03 94.23 0.00 0.00 365,939.44 0.00 365,939.44 0.00 624 WATER WORKS CUSTOMER DEPOSIT 1,466,824.73 28,263.99 29,668.38 355.18 0.00 355.18 1,465,420.34 0.00 1,465,420.34 0.00 625 WATERWORKS SINKING FUND 859,386.67 0.00 383,869.60 197.51 170,810.00 197.51 646,327.07 0.00 646,327.07 0.00 626 WATER WORKS BOND RESERVE 1,611,120.47 534.06 534.06 382.44 8,564.06 0.00 1,620,066.97 0.00 1,620,066.97 0.00 629 WATER WORKS RESERVE - O & M 2,085,038.68 0.00 0.00 505.11 0.00 505.11 2,085,038.68 0.00 2,085,038.68 0.00 640 SEWER REPAIR INSURANCE 1,460,186.76 49,530.88 16,319.44 353.66 0.00 0.00 1,493,751.86 0.00 1,493,751.86 0.00 641 SEWAGE WORKS OPERATIONS 5,052,748.29 2,885,583.57 1,410,381.93 1,188.75 829.14 774,919.02 5,755,048.80 0.00 5,755,048.80 0.00 642 SEWAGE WORKS CAPITAL 5,760,597.03 0.00 350,346.16 1,415.70 0.00 0.00 5,411,666.57 0.00 5,411,666.57 0.00 643 SEWAGE WORKS RESERVE - O & M 3,422,563.54 0.00 0.00 829.14 0.00 829.14 3,422,563.54 0.00 3,422,563.54 0.00 647 2007 SEWER BOND 1,143.19 0.00 805.00 0.28 0.00 0.00 338.47 0.00 338.47 0.00 649 SEWAGE WORKS BOND SINKING 3,119,495.57 0.00 132,890.00 1,031.77 774,919.02 0.00 3,762,556.36 0.00 3,762,556.36 0.00 651 2007B SEWER BOND 2.44 0.00 0.00 0.00 0.00 0.00 2.44 0.00 2.44 0.00 653 SEWAGE WORKS DEBT SERVICE RESERVE 7,286,828.40 0.00 0.00 0.00 0.00 0.00 7,286,828.40 0.00 7,286,828.40 0.00 658 2010 SEWER BOND CSO PLAN 2,219.05 0.00 0.00 0.54 0.00 0.00 2,219.59 0.00 2,219.59 0.00 659 2011 SEWER BOND 6,079,724.31 0.00 711,645.51 1,534.79 0.00 0.00 5,369,613.59 0.00 5,369,613.59 0.00 661 2012 SEWER BOND 17,822,406.91 0.00 6,278.42 4,316.96 0.00 0.00 17,820,445.45 0.00 17,820,445.45 0.00 664 2013 SEWER REFUND BOND 4,475.28 0.00 0.00 1.08 0.00 0.00 4,476.36 0.00 4,476.36 0.00 670 CENTURY CENTER 535,004.38 689,294.88 805,335.45 0.00 0.00 0.00 418,963.81 0.00 418,963.81 0.00 671 CENTURY CENTER CAPITAL 1,757,842.79 0.00 0.00 0.00 0.00 0.00 1,757,842.79 0.00 1,757,842.79 0.00 Total Enterprise Funds 67,425,749.33 5,819,414.50 5,561,532.83 1 14,349.57 1 956,180.02 1 956,180.02 1 67,697,980.57 0.00 67,697,980.57 0.00 Internal Service Funds 222 CENTRAL SERVICES 1,638,790.03 861,706.77 841,135.69 300.22 0.00 0.00 1,659,661.33 0.00 1,659,661.33 0.00 226 LIABILITY INSURANCE 5,395,802.00 251,615.42 514,709.17 1,271.71 0.00 0.00 5,133,979.96 0.00 5,133,979.96 0.00 278 TAKE HOME VEHICLE POLICE 505,502.28 9,400.00 0.00 121.41 0.00 0.00 515,023.69 0.00 515,023.69 0.00 711 SELF - FUNDED EMPLOYEE BENEFITS 4,793,623.28 1,073,126.41 846,028.10 1,211.76 0.00 0.00 5,021,933.35 0.00 5,021,933.35 0.00 713 UNEMPLOYMENT COMP FUND 233,053.18 8,530.35 13,314.57 57.28 0.00 0.00 228,326.24 0.00 228,326.24 0.00 Total Internal Service Funds 12,566,770.77 2,204,378.95 2,215,187.53 2,962.38 0.00 0.00 12,558,924.57 0.00 12,558,924.57 0.00 Trust & Agency Funds 701 FIREFIGHTERS PENSION (1,324,110.63) 2,564,548.94 462,793.22 0.00 0.00 0.00 777,645.09 0.00 777,645.09 0.00 702 POLICE PENSION (1,205,992.17) 3,055,932.73 566,914.65 0.00 0.00 0.00 1,283,025.91 0.00 1,283,025.91 0.00 709 PAYROLL FUND 11.99 7,782,272.04 7,782,272.04 0.00 0.00 0.00 11.99 0.00 11.99 0.00 718 STATE TAX DEDUCTION FUND 256,239.09 277,164.34 256,239.09 0.00 0.00 0.00 277,164.34 0.00 277,164.34 0.00 725 MORRIS / PALAIS BOX OFFICE 1,280,837.00 10,973.30 203,055.96 0.00 0.00 0.00 1,088,754.34 0.00 1,088,754.34 0.00 730 CITY CEMETERY TRUST 36,996.49 0.00 0.00 8.96 0.00 0.00 37,005.45 0.00 37,005.45 0.00 Total Trust & Agency Funds 956,018.23) 13,690,891.35 9,271,274.96 1 8.96 1 0.00 1 0.00 3,463,607.12 0.00 3,463,607.12 0.00 2014 June. controllers cash report - Controllers Cash Report Page 4 o/7 City of South Bend Controller's Cash Report Month of.- June 2014 Total City Funds 162,529,595.33 Opening 25,629,578.80 37,735.83 Interest Transfers Transfers Ending 190,511,763.10 Total Cash & Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing) Total City Funds 162,529,595.33 53,574,010.74 25,629,578.80 37,735.83 956,180.02 956,180.02 190,511,763.10 0.00 190,511,763.10 6,294,045.96 Redevelopment Commission Controlled Funds 10,078.58 0.00 0.00 2.44 0.00 0.00 10,081.02 0.00 10,081.02 0.00 Tax Increment Financing Funds 3,688,816.54 0.00 0.00 893.51 0.00 0.00 3,689,710.05 0.00 3,689,710.05 0.00 324 TIFREVENUE - AIRPORT 22,107,996.27 7,622,286.07 161,642.17 5,397.33 251.68 0.00 29,574,289.18 0.00 29,574,289.18 5,752,006.93 420 TIF DISTRICT - SBCDA GENERAL 1,205,218.29 2,512,174.77 32,301.51 3,307.04 420.52 0.00 3,688,819.11 0.00 3,688,819.11 0.00 422 TIF DISTRICT - WEST WASHINGTON 613,657.13 304,152.20 0.00 148.64 0.00 0.00 917,957.97 0.00 917,957.97 0.00 425 TIF LEIGHTON PLAZA 142,362.64 16,893.92 16,523.75 21.71 0.00 0.00 142,754.52 0.00 142,754.52 0.00 426 TIF CENTRAL MEDICAL SERVICE AREA 1,507,988.62 459,659.10 0.00 369.96 0.00 0.00 1,968,017.68 0.00 1,968,017.68 0.00 429 TIF NORTHEAST DISTRICT 3,013,218.59 808,183.73 858.50 729.86 0.00 0.00 3,821,273.68 0.00 3,821,273.68 0.00 430 TIF SOUTHSIDE DEVELOPMENT AREA #1 3,142,361.86 1,268,946.48 43,124.75 762.80 0.00 0.00 4,368,946.39 0.00 4,368,946.39 0.00 432 TIF SSDA #3 - ERSKINE VILLAGE 6,624,346.52 9,175.08 0.00 1,468.65 0.00 0.00 6,634,990.25 0.00 6,634,990.25 0.00 435 TIF - DOUGLAS ROAD 199,664.26 160,947.28 0.00 48.36 0.00 0.00 360,659.90 0.00 360,659.90 (905,482.00) 436 TIF - NORTHEST RESIDENTIAL 689,934.12 1,382,498.19 0.00 167.26 0.00 0.00 2,072,599.57 0.00 2,072,599.57 (4,888,563.96) Total Tax Increment Financing Funds 39,246,748.30 14,544,916.82 1 254,450.68 1 12,421.61 1 672.20 1 0.00 1 53,550,308.25 0.00 53,550,308.25 (42,039.03) Redevelopment Funds Opening Interest Accrued Change in Transfer In Transfer out Investment Total Cash & 433 REDEVELOPMENT ADMINISTRATION GENERAL 10,078.58 0.00 0.00 2.44 0.00 0.00 10,081.02 0.00 10,081.02 0.00 439 CERTIFIED TECHNOLOGY PARK 3,688,816.54 0.00 0.00 893.51 0.00 0.00 3,689,710.05 0.00 3,689,710.05 0.00 454 AIRPORT URBAN ENTERPRISE ZONE 377,007.36 0.00 0.00 91.32 0.00 0.00 377,098.68 0.00 377,098.68 0.00 619 BLACKTHORN GOLF COURSE OPERATIONS 193,496.25 234,797.50 145,799.79 0.00 0.00 0.00 282,493.96 0.00 282,493.96 (6,252,006.93) Total Redevelopment Funds 4,269,398.73 234,797.50 145,799.79 987.27 0.00 0.00 4,359,383.71 0.00 4,359,383.71 (6,252,006.93) Debt Service Funds Opening Interest Accrued Change in Transfer In Transfer out Investment Total Cash & 315 AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 0.00 251.68 0.00 251.68 1,038,904.00 0.00 1,038,904.00 0.00 317 COVELESKI BOND DEBT RESERVE 504,322.93 0.00 0.00 122.15 0.00 0.00 504,445.08 0.00 504,445.08 0.00 328 SBCDA 2003 DEBT RESERVE 1,735,840.00 0.00 0.00 420.52 420.52 1,735,840.00 1,735,840.00 0.00 Total Debt Service Funds 3,279,066.93 0.00 0.00 794.35 0.00 672.20 3,279,189.08 0.00 3,279,189.08 0.00 0.00 Total Redevelopment Commission Funds 46,795,213.96 14,779,714.32 400,250.47 14,203.23 672.20 672.20 61,188,881.04 0.00 61,188,881.04 (6,294,045.96) City Operations Total 209,324,809.29 68,353,725.06 26,029,829.27 51,939.06 956,852.22 956,852.22 1 251,700,644.14 0.00 1 251,700,644.14 0.00 Memo Item Pooled Investment Account Opening Interest Accrued Change in Transfer In Transfer out Investment Total Cash & Balance Net of Fees Income Asset Value from Depository to Depository Balance Investments 1st Source Bank Investment Account 174,788,578.91 57,929.63 0.00 34,497.31 0.00 29,134.26 174,851,871.59 174,851,871.59 2014 June. controllers cash report - Controllers Cash Report Page 5 of 7 City of South Bend Cash Balance Report Period Ending: June 2014 Account Bank Account Current Prior Q3 Q2 Q1 Prior Month Month September June March December City Controlled Bank Accounts City Cash Total 241,870,901.78 199,276,763.82 1 - - 211,534,952.82 1 237,067,469.42 Century Center Controlled Accounts 1st Source Depository 240,663,093.19 198,018,381.83 210,160,422.82 236,214,882.63 1st Source Payroll (232,360.00) (222,678.95) (282,873.92) (130,182.37) 1st Source Disbursement (834,134.18) (792,792.76) (640,188.05) (1,336,355.89) xxxx 1st Source Police Grant 299 361,032.24 360,651.95 378,835.74 385,160.01 1st Source Benefits 26,118.92 26,118.92 26,118.92 26,118.92 1st Source Section 108 -8 Loan 129,328.83 129,303.98 129,256.43 150,149.54 Key Bank Century Center Capital 1,757,842.79 1 1,757,842.79 1,757,784.04 1 1,757,697.36 1st Source Variance (20.01) (63.94) 5,596.84 (0.78) City Cash Total 241,870,901.78 199,276,763.82 1 - - 211,534,952.82 1 237,067,469.42 Century Center Controlled Accounts CC Cash Total 418,963.81 535,004.38 1 - - 979,360.82 1 887,475.05 Bank of New York Mellon to Lake City Key Bank Operating / Petty Cash 187,991.77 482,377.88 835,327.85 715,532.71 Key Bank Payroll 118,960.92 37,861.67 49,588.83 (20,671.49) Key Bank Event 112,011.12 14,764.83 94,444.14 192,613.83 xxxx xxxx xxxx 561,092.69 561,092.69 561,092.69 561,092.69 CC Cash Total 418,963.81 535,004.38 1 - - 979,360.82 1 887,475.05 Bank of New York Mellon to Lake City xx Cash Total 9,410,778.55 9,513,041.09 1 - - 9,532,014.18 1 9,394,832.83 2014 June. controllers cash report - Cash Balances Page 6 of 7 Fund 101 Cash with Fiscal Agent 97,816.67 97,898.67 97,898.67 100,636.67 Fund 313 Cash with Fiscal Agent 2,933.69 2,933.69 2,933.69 2,933.69 Fund 425 Cash with Fiscal Agent 53,827.17 53,456.82 50,359.26 44,310.68 Fund 432 Cash with Fiscal Agent 561,092.69 561,092.69 561,092.69 561,092.69 Fund 600 Cash with Fiscal Agent 1,899.00 1,899.00 2,328.00 Fund 619 1 Cash with Fiscal Agent 286,574.57 197,576.86 130,555.58 31,585.23 Fund 626 Cash with Fiscal Agent 31,052.02 30,517.96 29,449.84 27,847.66 Fund 653 Cash with Fiscal Agent 7,286,828.40 7,286,828.40 7,286,828.40 7,286,828.40 Fund 725 Cash with Fiscal Agent 1,088,754.34 1,280,837.00 1,370,568.05 1,339,597.81 xx Cash Total 9,410,778.55 9,513,041.09 1 - - 9,532,014.18 1 9,394,832.83 2014 June. controllers cash report - Cash Balances Page 6 of 7 City of South Bend Cash Balance Report Period Ending: June 2014 Account Bank Account Current Prior Q3 Q2 Q1 Prior Month Month September June March December Total Cash on Hand per General Ledger 251,700,644.14 209,324,809.29 1 - - 222,046,327.82 1 247,349,777.30 Adjustments Century Center Event Account Century Center Payroll Account xxxx xxxx Total Adjustments Cash per Controller's Cash Report 251,700,644.14 209,324,809.29 1 - - 222,046,327.82 1 247,349,777.30 2014 June. controllers cash report - Cash Balances Page 7 of 7