HomeMy WebLinkAbout01-2013 Controller’s Cash ReportPeriod Ending:
Issued By:
January 2013
Controller
City of South Bend
Controller's Cash Report
Tab Page
Overview
Controller Cash
Cash
Distribution
Contents
Overview of Controller's Cash Report
Controller's Cash Report
Bank Account Cash Balances
Mayor Pete Buttigieg
Controller Mark Neal
City Finance Director J Murphy
City Finance Director R Johnson
South Bend City Council Members
City Department Heads
City Fiscal Officers
2013 January. controllers cash report.xls Page 1 of 7
CONTROLLER'S CASH REPORT
OVERVIEW:
The Controller's Cash Report is a monthly summary of cash and investment transactions within the current
period by Fund. It summarizes the cash received, interest earned, cash disbursed and cash transferred
between Funds within the City of South Bend as well as any loans among/between Funds. The report
provides a month -end view of the City's cash balance in the reporting period.
The City's management team is responsible for establishing and maintaining an internal control structure
designed to ensure that the assets of the City are protected from loss, theft or misuse and to ensure that
adequate accounting data is compiled to allow for the preparation of financial statements in conformity
with generally accepted accounting principles.
JANUARY 2013 HIGHLIGHTS:
On January 28, 2013, the Board of Finance authorized the City of South Bend Administration to increase
its investments in the 1St Source Investment account from $150 to $175 million. This additional funding of
$25 million was transferred from the City's checking account to the investment account on January 29,
2013.
Total City Funds (pg .4): January 2013 beginning cash balance of $207,891,357 and ending cash balance
of $202,709,602 represents a decrease in cash of ^'$5.18 million. Compared to January 2012, beginning
cash balance of $174,855,808 and ending cash balance of $166,363,741 represents a decrease in cash of
approximately $8.5 million. The — $3.3 million net increase y -o -y (year over year) is due to —$2.3 million
in higher receipts while there were —$1.0 million of fewer disbursements.
Total TIF (Tax Increment Financing) Funds (pg.4): January 2013 beginning cash balance of
$42,523,096 and ending cash balance of $38,769,031 represents a decrease in cash of —$3.75 million.
Compared to January 2012, beginning cash balance of $44,959,950 and ending cash balance of
$38,175,632 represents a decrease in cash of ^'$6.78 million. This approximate $3.0 million net increase
y -o -y is due to fewer disbursements in fund 324 (TIF Revenue — Airport) and fund 420 (TIF District —
SBCDA General). The disbursements in these funds are related primarily to the purchase of the Gate's
property, the 2003 Police and Fire Bldg. Revenue bonds, and annual debt service payments.
Total Redevelopment Funds (pg. 4): January 2013 actual receipts were $1,529,624 vs. prior year actual
receipts of $101,807. Variance of $1.4 million is due to fund 439 (Certified Technology Park). On January
2, 2013 the City received $1,446,074 from the State of Indiana for the 2012 CTP annual distribution.
Fund 101 (General Fund): January 2013 actual receipts were $1,390,087 vs. prior year actual receipts of
$1,251,334. The largest receipts in January '13 were $100,018 from St. Joseph County for Code
Enforcement fees and $215,000 from St. Joseph County for 911 reimbursements for the year 2012.
Fund 249 (Public Safety LOIT): - 2013 Revenue budget of $5,892,386. The transfer of $1,775,439.25
represents 1St Quarter Transfer Out to General Fund for Police and Fire personnel paid for from this Fund.
Fund 313 (Hall of Fame): Negative cash balance reflects a debt service payment of $633,500
in January '13. Revenue will increase when property taxes are received in late May or early June thus
providing sufficient cash for the next debt service payment in July.
Fund 407 (Cumulative Capital Improvement): Century Center debt service bond payment of $184,875
was made this month, which caused negative cash balance. Revenue will increase when Cigarette and
Hotel / Motel Tax money is received in late May or early June.
For January 2013, cash interest received was $115,132.37 compared to $106,992.03 in January 2012.
Please Contact City Controller Mark Neal at (574) 235 -7500 with any questions.
City of South Bend
Controller's Cash Report
Month of: January 2013
City Controlled Funds
General Fund
101 GENERAL FUND 28,205,847.66 $1,390,087.49 $4,585,650.56 $14,842.29 1 $1,775,439.25 $0.00 26,800,566.13 0.00 26,800,566.13 0.00
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 28,205,847.66 $1,390,087.49 $4,585,650.56 $14,842.29 1 $1,775,439.25 $0.00 26,800,566.13 0.00 26,800,566.13 0.00
Special Revenue Funds
102 RAINY DAY FUND
8,588,180.46
0.00
0.00
4,404.59
0.00
0.00
8,592,585.05
0.00
8,592,585.05
0.00
103 EXCESS LEVY
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
201 PARKS & RECREATION
4,885,352.16
158,045.32
846,681.72
2,505.54
0.00
0.00
4,199,221.30
0.00
4,199,221.30
0.00
202 MOTOR VEHICLE HIGHWAY
2,271,733.07
487,925.34
483,688.58
1,165.09
0.00
0.00
2,277,134.92
0.00
2,277,134.92
0.00
203 RECREATION - NONREVERTING
671,131.84
100,010.74
45,993.41
344.20
0.00
0.00
725,493.37
0.00
725,493.37
0.00
209 STUDEBAKER/OLIVER REVERTING GRANTS
1,079,675.32
0.00
0.00
553.73
0.00
0.00
1,080,229.05
0.00
1,080,229.05
500,000.00
210 DEPT COMMUNITY INVESTMENT STATE GRANTS
918,454.91
0.00
11,492.12
471.04
0.00
0.00
907,433.83
0.00
907,433.83
0.00
211 DCI OPERATING FUND
584,036.54
14,539.33
166,453.95
299.54
429,379.75
0.00
861,801.21
0.00
861,801.21
0.00
212 DEPARTMENT OF COMMUNITY INVESTMENT
514,341.13
528,710.62
529,686.71
164.94
0.00
0.00
513,529.98
0.00
513,529.98
0.00
213 POLICE FEDERAL GRANTS
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
216 POLICE STATE SEIZURES
144,925.09
0.00
0.00
74.33
0.00
0.00
144,999.42
0.00
144,999.42
0.00
217 GIFT, DONATION, BEQUEST
63,232.94
795.00
0.00
32.43
0.00
0.00
64,060.37
0.00
64,060.37
0.00
218 POLICE CURFEW VIOLATIONS
10,884.70
37.50
0.00
5.58
0.00
0.00
10,927.78
0.00
10,927.78
0.00
220 LAW ENFORCEMENT CONTINUING EDUCATION
1,087,206.88
24,650.82
9,543.42
557.59
0.00
0.00
1,102,871.87
0.00
1,102,871.87
0.00
227 LOSS RECOVERY FUND
4,341,561.12
0.00
0.00
2,226.64
0.00
0.00
4,343,787.76
0.00
4,343,787.76
0.00
249 PUBLIC SAFETY L.O.I.T.
2,989,940.29
491,032.15
0.00
1,533.44
0.00
1,775,439.25
1,707,066.63
0.00
1,707,066.63
0.00
250 GENERAL GRANT
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
251 LOCAL ROADS & STREETS
1,714,297.82
82,968.15
17,646.50
879.20
0.00
0.00
1,780,498.67
0.00
1,780,498.67
0.00
252 EXCESS WELFARE DISTRIBUTION
1,145.87
0.00
0.00
0.59
0.00
0.00
1,146.46
0.00
1,146.46
0.00
258 HUMAN RIGHTS - FEDERAL GRANT
486,164.25
14.90
10,685.89
249.33
0.00
0.00
475,742.59
0.00
475,742.59
0.00
271 EASTRACE WATERWAY
14,323.04
0.00
0.00
7.34
0.00
0.00
14,330.38
0.00
14,330.38
0.00
273 MORRIS PAC /PALAIS ROYALE MARKETING
28,762.72
8.00
2,048.50
14.75
0.00
0.00
26,736.97
0.00
26,736.97
0.00
280 POLICE BLOCK GRANTS
3,804.12
0.00
0.00
1.95
0.00
0.00
3,806.07
0.00
3,806.07
0.00
281 DEPT. COMMUNITY INVESTMENT - REV BONDS
27,034.80
0.00
0.00
13.86
0.00
0.00
27,048.66
0.00
27,048.66
0.00
289 HAZMAT
2,682.93
0.00
0.00
1.38
0.00
0.00
2,684.31
0.00
2,684.31
0.00
291 INDIANA RIVER RESCUE
119,423.45
2,500.00
18,756.24
61.25
0.00
0.00
103,228.46
0.00
103,228.46
0.00
292 POLICE GRANTS
98,125.00
0.00
0.00
0.00
0.00
0.00
98,125.00
0.00
98,125.00
0.00
294 REGIONAL POLICE ACADEMY
73,815.26
10,100.00
1,297.68
37.86
0.00
0.00
82,655.44
0.00
82,655.44
0.00
295 COPS MORE GRANT
107,288.86
1,030.00
485.00
55.02
0.00
0.00
107,888.88
0.00
107,888.88
0.00
299 POLICE FEDERAL DRUG ENFORCEMENT
335,340.82
2,216.43
6,433.00
103.96
0.00
0.00
331,228.21
0.00
331,228.21
0.00
404 COUNTY OPTION INCOME TAX
15,327,002.33
694,710.61
1,604,032.55
7,860.71
0.00
0.00
14,425,541.10
0.00
14,425,541.10
2,027,973.00
408 ECONOMIC DEVELOPMENT INCOME TAX
9,984,411.08
681,445.98
1,045,164.39
5,120.68
0.00
429,379.75
9,196,433.60
0.00
9,196,433.60
0.00
410 URBAN DEVELOPMENT ACTION GRANT (UDAG)
23,753.29
448.42
0.00
12.19
0.00
0.00
24,213.90
0.00
24,213.90
(2,027,973.00)
655 PROJECT RELEAF
859,452.10
36,718.70
3,183.88
440.78
0.00
0.00
893,427.70
0.00
893,427.70
0.00
705 POLICE K -9 UNIT
1,930.55
0.00
0.00
0.99
0.00
0.00
1,931.54
0.00
1,931.54
0.00
Total Special Revenue Funds
57,359,414.74
3,317,908.01
4,803,273.54
1 29,200.52
1 429,379.75
1 2,204,819.00
54,127,810.48
0.00
54,127,810.48
500,000.00
Debt Service Fund
313 HALL OF FAME DEBT SERVICE
574,438.99
5,955.68
633,500.00
0.00
0.00
0.00
(53,105.33)
0.00
(53,105.33)
0.00
Capital Project Funds
288 EMS / FIRE DEPARTMENT CAPITAL
5,522,334.84
211,027.78
77,701.65
2,832.22
0.00
0.00
5,658,493.19
0.00
5,658,493.19
(72,825.00)
377 PROFESSIONAL SPORTS DEVELOPMENT
1,040,822.42
103,035.37
487,547.50
533.80
0.00
0.00
656,844.09
0.00
656,844.09
0.00
401 COVELESKI STADIUM CAPITAL
26,758.08
0.00
0.00
13.73
0.00
0.00
26,771.81
0.00
26,771.81
0.00
403 ZOO ENDOWMENT
48,846.07
0.00
0.00
25.05
0.00
0.00
48,871.12
0.00
48,871.12
0.00
405 PARK NONREVERTING CAPITAL
492,385.07
76.00
6,302.06
252.53
0.00
0.00
486,411.54
0.00
486,411.54
0.00
406 CUMULATIVE CAPITAL DEVELOPMENT
835,769.21
3,837.88
42.00
428.63
0.00
0.00
839,993.72
0.00
839,993.72
0.00
407 CUMULATIVE CAPITAL IMPROVEMENT
97,720.44
0.00
184,875.00
50.12
0.00
0.00
(87,104.44)
0.00
(87,104.44)
0.00
2013 January. controllers cash report.xls - Controllers Cash Report Page 2 of 7
City of South Bend
Controller's Cash Report
Month of: January 2013
409 CUMULATIVE SEWER
0.00
Opening
0.00
0.00
Interest
Transfers
Transfers
Ending
0.00
Total Cash &
Interfund Loans
Fund
Fund Name
Cash Balance
Receipts
Disbursements
Earned
In
Out
Cash Balance
Investments
Investments
(Borrowing)
409 CUMULATIVE SEWER
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
412 MAJOR MOVES CONSTRUCTION
7,896,696.41
0.00
0.00
4,049.96
0.00
0.00
7,900,746.37
0.00
7,900,746.37
6,128,413.44
416 MORRIS PERFORMING ARTS CENTER CAPITAL
396,267.78
743.00
229.50
203.23
0.00
0.00
396,984.51
0.00
396,984.51
0.00
434 CREED FUND
223,586.53
0.00
36,974.50
105.57
0.00
0.00
186,717.60
0.00
186,717.60
0.00
450 PALAIS ROYALE HISTORIC PRESERVATION
58,304.29
1,250.55
0.00
29.90
0.00
0.00
59,584.74
0.00
59,584.74
0.00
677 HALL OF FAME CAPITAL FUND
719,086.15
0.00
2,222.50
368.79
0.00
0.00
717,232.44
0.00
717,232.44
0.00
Total Capital & Debt Service Funds
17,933,016.28
325,926.26
1,429,394.71
8,893.53
0.00
1 0.00
16,838,441.36
0.00
16,838,441.36
1 6,055,588.44
Enterprise Funds
600 CONSOLIDATED BUILDING DEPARTMENT
203,849.69
88,652.06
72,806.89
104.55
0.00
0.00
219,799.41
0.00
219,799.41
0.00
601 PARKING GARAGES
855,444.13
65,919.40
94,337.44
438.73
0.00
0.00
827,464.82
0.00
827,464.82
0.00
610 SOLID WASTE OPERATIONS
1,169,979.65
411,469.62
352,827.59
600.04
0.00
279,338.68
949,883.04
0.00
949,883.04
0.00
611 SOLID WASTE CAPITAL
108.55
0.00
188,809.19
0.06
279,338.68
0.00
90,638.10
0.00
90,638.10
0.00
620 WATER WORKS OPERATIONS
1,763,223.47
1,271,977.37
985,275.65
904.30
0.00
241,651.06
1,809,178.43
0.00
1,809,178.43
0.00
622 WATER WORKS CAPITAL
4,145,317.31
0.00
817.73
2,126.00
0.00
0.00
4,146,625.58
0.00
4,146,625.58
0.00
623 WATERWORKS BOND CAPITAL
5,802,836.53
0.00
90,214.33
2,976.09
0.00
0.00
5,715,598.29
0.00
5,715,598.29
0.00
624 WATER WORKS CUSTOMER DEPOSIT
1,408,694.37
19,270.26
15,087.57
722.48
0.00
0.00
1,413,599.54
0.00
1,413,599.54
0.00
625 WATERWORKS SINKING FUND
4,636.52
0.00
600.00
2.38
170,953.00
0.00
174,991.90
0.00
174,991.90
0.00
626 WATER WORKS BOND RESERVE
1,311,688.08
534.06
534.06
661.73
25,397.06
0.00
1,337,746.87
0.00
1,337,746.87
0.00
629 WATER WORKS RESERVE - O & M
1,986,230.68
0.00
0.00
1,018.67
45,301.00
0.00
2,032,550.35
0.00
2,032,550.35
0.00
640 SEWER REPAIR INSURANCE
1,160,016.75
46,139.64
33,996.78
594.93
0.00
0.00
1,172,754.54
0.00
1,172,754.54
0.00
641 SEWAGE WORKS OPERATIONS
4,431,602.79
2,517,421.30
1,660,098.63
2,272.83
0.00
817,767.66
4,473,430.63
0.00
4,473,430.63
0.00
642 SEWAGE WORKS CAPITAL
8,863,108.93
0.00
47,174.14
4,545.60
0.00
0.00
8,820,480.39
0.00
8,820,480.39
0.00
643 SEWAGE WORKS RESERVE - O & M
3,092,303.65
0.00
0.00
1,585.94
0.00
0.00
3,093,889.59
0.00
3,093,889.59
0.00
644 WATER LEAK INSURANCE
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
645 2004 SEWER BOND
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
645 2006 SEWER BOND
12.43
0.00
0.00
0.00
0.00
0.00
12.43
0.00
12.43
0.00
647 2007 SEWER BOND
19,040.75
0.00
0.00
9.77
0.00
0.00
19,050.52
0.00
19,050.52
0.00
648 SEWAGE WORKS SINKING SRF
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
649 SEWAGE WORKS BOND SINKING
836,045.47
0.00
0.00
428.78
814,243.77
0.00
1,650,718.02
0.00
1,650,718.02
0.00
650 CLAY SEWAGE WORKS OPERATIONS
696.45
0.00
0.00
0.36
0.00
0.00
696.81
0.00
696.81
0.00
651 2007B SEWER BOND
39,557.49
0.00
0.00
20.28
0.00
0.00
39,577.77
0.00
39,577.77
0.00
653 SEWAGE WORKS DEBT SERVICE RESERVE
9,710,816.93
3,523.89
3,523.89
3,523.89
0.00
9,714,340.82
0.00
9,714,340.82
0.00
658 2010 SEWER BOND CSO PLAN
112,203.24
0.00
517.50
57.55
0.00
0.00
111,743.29
0.00
111,743.29
0.00
659 2011 SEWER BOND
10,166,509.94
0.00
745,740.20
5,214.07
0.00
0.00
9,425,983.81
0.00
9,425,983.81
0.00
661 2012 SEWER BOND
23,246,887.70
0.00
104,980.88
0.00
0.00
0.00
23,141,906.82
0.00
23,141,906.82
0.00
670 CENTURY CENTER
901,198.47
994,494.02
356,431.88
0.00
0.00
0.00
1,539,260.61
0.00
1,539,260.61
0.00
671 CENTURY CENTER CAPITAL
1,274,877.44
100,000.00
0.00
22.04
0.00
0.00
1,374,899.48
0.00
1,374,899.48
0.00
Total Enterprise Funds
82,506,887.41
5,519,401.62
4,753,774.35
24,307.18
1,338,757.40
1 1,338,757.40
83,296,821.86
0.00
83,296,821.86
0.00
Internal Service Funds
222 CENTRAL SERVICES
1,090,656.09
916,697.38
929,046.03
559.36
0.00
0.00
1,078,866.80
0.00
1,078,866.80
0.00
226 LIABILITY INSURANCE
5,245,412.02
247,574.12
257,965.63
2,690.20
0.00
0.00
5,237,710.71
0.00
5,237,710.71
0.00
278 TAKE HOME VEHICLE POLICE
391,805.21
9,620.00
0.00
200.95
0.00
0.00
401,626.16
0.00
401,626.16
0.00
711 SELF - FUNDED EMPLOYEE BENEFITS
7,428,190.64
1,002,486.60
1,141,445.63
3,809.68
0.00
0.00
7,293,041.29
0.00
7,293,041.29
0.00
713 UNEMPLOYMENT COMP FUND
72,566.03
28,437.50
5,421.68
37.22
0.00
0.00
95,619.07
0.00
95,619.07
0.00
Total Internal Service Funds
14,228,629.99
2,204,815.60
1 2,333,878.97
1 7,297.41
1 0.00
1 0.00
1 14,106,864.03
1 0.00
1 14,106,864.03
1 0.00
Trust & Agency Funds
701 FIREFIGHTERS PENSION 1,347,864.41 0.00 464,307.28 691.28 0.00 0.00 884,248.41 0.00 884,248.41 0.00
2013 January. controllers cash report.xls - Controllers Cash Report Page 3 of 7
City of South Bend
Controller's Cash Report
Month of: January 2013
702 POLICE PENSION
2,308,625.89
Opening
542,086.33
1,184.02
Interest
Transfers
Transfers
Ending
1,767,990.68
Total Cash &
Interfund Loans
Fund
Fund Name
Cash Balance
Receipts
Disbursements
Earned
In
Out
Cash Balance
Investments
Investments
(Borrowing)
702 POLICE PENSION
2,308,625.89
267.10
542,086.33
1,184.02
0.00
0.00
1,767,990.68
0.00
1,767,990.68
0.00
703 POLICE /FIRE 1977 STATE PENSION
1,576,002.36
545,625.53
0.00
0.00
0.00
0.00
2,121,627.89
0.00
2,121,627.89
0.00
709 PAYROLLFUND
0.00
7,337,917.29
7,338,159.40
0.00
0.00
0.00
(242.11)
0.00
(242.11)
0.00
712 PUBLIC EMPLOYEES RETIREMENT FUND
717,279.64
277,987.07
0.00
0.00
0.00
0.00
995,266.71
0.00
995,266.71
0.00
718 STATE TAX DEDUCTION FUND
283,370.12
247,166.31
283,370.12
0.00
0.00
0.00
247,166.31
0.00
247,166.31
0.00
725 MORRIS / PALAIS BOX OFFICE
1,383,306.44
98,600.86
0.00
0.00
0.00
0.00
1,481,907.30
0.00
1,481,907.30
0.00
730 CITY CEMETERY TRUST
41,112.09
0.00
0.00
21.08
0.00
0.00
41,133.17
0.00
41,133.17
0.00
Total Trust & Agency Funds
7,657,560.95
8,507,564.16
8,627,923.13
1,896.38
0.00
0.00
7,539,098.36
0.00
7,539,098.36
0.00
Total City Funds
207,891,357.03
21,265,703.14
26,533,895.26
86,437.31
3,543,576.40
3,543,576.40
202,709,602.22
0.00
202,709,602.22
6,555,588.44
Redevelopment Commission Controlled Funds
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Tax Increment Financing Funds
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
324 TIFREVENUE - AIRPORT
18,429,251.52
65,000.00
1,666,887.58
9,451.75
0.00
0.00
16,836,815.69
0.00
16,836,815.69
5,625,768.74
414 TIF DISTRICT - SAMPLE -EWING GEN'L
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
420 TIF DISTRICT - SBCDA GENERAL
2,843,356.75
32,196.01
48,683.85
5,874.82
0.00
0.00
2,832,743.73
0.00
2,832,743.73
0.00
422 TIF DISTRICT - WEST WASHINGTON
451,728.77
0.00
90,126.46
231.68
0.00
0.00
361,833.99
0.00
361,833.99
0.00
425 TIF LEIGHTON PLAZA
95,394.64
12,987.58
3,969.50
43.97
0.00
0.00
104,456.69
0.00
104,456.69
0.00
426 TIF CENTRAL MEDICAL SERVICE AREA
3,859,101.03
0.00
233,050.50
1,979.21
0.00
0.00
3,628,029.74
0.00
3,628,029.74
0.00
429 TIF NORTHEAST DISTRICT
2,219,622.79
0.00
8,320.00
1,138.37
0.00
0.00
2,212,441.16
0.00
2,212,441.16
0.00
430 TIF SOUTHSIDE DEVELOPMENT AREA #1
5,394,776.59
0.00
123,533.06
2,766.80
0.00
0.00
5,274,010.33
0.00
5,274,010.33
0.00
431 TIF SSDA #2 - ERSKINE COMM
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
432 TIF SSDA #3 - ERSKINE VILLAGE
5,567,627.20
0.00
344,897.50
2,855.46
0.00
0.00
5,225,585.16
0.00
5,225,585.16
0.00
435 TIF - DOUGLAS ROAD
160,925.75
0.00
0.00
82.53
0.00
0.00
161,008.28
0.00
161,008.28
(959,191.00)
436 TIF - NORTHEST RESIDENTIAL
3,501,311.10
0.00
1,371,000.00
1,795.70
0.00
0.00
2,132,106.80
0.00
2,132,106.80
(5,169,222.44)
Total Tax Increment Financing Funds
42,523,096.14
110,183.59
3,890,468.45
26,220.29
0.00
0.00
38,769,031.57
0.00
38,769,031.57
(502,644.70)
Redevelopment Funds
305 SBCDA BOND PROCEEDS - 2003
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
428 REDEVELOPMENT DISTRICT CAPITAL - AEDA2003
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
433 REDEVELOPMENT ADMINISTRATION GENERAL
31,443.12
0.00
0.00
16.12
0.00
0.00
31,459.24
0.00
31,459.24
0.00
438 COVELESKI BOND CONSTRUCTION
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
439 CERTIFIED TECHNOLOGY PARK
816,361.78
1,446,074.00
0.00
418.68
0.00
0.00
2,262,854.46
0.00
2,262,854.46
0.00
454 AIRPORT URBAN ENTERPRISE ZONE
375,082.11
0.00
0.00
192.37
0.00
0.00
375,274.48
0.00
375,274.48
0.00
619 BLACKTHORN GOLF COURSE OPERATIONS
45,371.49
83,550.09
27,586.10
0.00
0.00
0.00
101,335.48
0.00
101,335.48
(6,052,943.74)
Total Redevelopment Funds
1,268,258.50
1,529,624.09
27,586.10
627.17
0.00
0.00
2,770,923.66
0.00
2,770,923.66
1 (6,052,943.74)
Debt Service Funds
314 REDEV BOND - 1990 PUBLIC IMPROVEMENT
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
315 AIRPORT 2003 DEBT RESERVE
1,038,904.00
0.00
0.00
532.82
0.00
0.00
1,039,436.82
0.00
1,039,436.82
0.00
317 COVELESKI BOND DEBT RESERVE
501,747.51
0.00
0.00
257.33
0.00
0.00
502,004.84
0.00
502,004.84
0.00
319 REDEVELOPMENT BOND - BLACKTHORN GOLF
326,000.00
0.00
0.00
167.20
0.00
0.00
326,167.20
0.00
326,167.20
0.00
328 SBCDA 2003 DEBT RESERVE
1,735,840.00
0.00
0.00
890.25
0.00
0.00
1,736,730.25
1,736,730.25
0.00
Total Debt Service Funds
3,602,491.51
0.00
1 0.00
1 1,847.60
1 0.00
1 0.00
3,604,339.11
0.00
3,604,339.11
0.00
0.00
Total Redevelopment Commission Funds
47,393,846.15
1 1,639,807.68
1 3,918,054.55
1 28,695.06
1 0.00
1 0.00
45,144,294.34
0.00
45,144,294.34
(6,555,588.44)
2013 January. controllers cash report.xls - Controllers Cash Report Page 4 o(7
City of South Bend
Controller's Cash Report
Month of: January 2013
City Operations Total 255,285,203.18 22,905,510.82 30,451,949.81 115,132.37 1 3,543,576.40 1 3,543,576.40 1 247,853,896.56 0.00 1 247,853,896.56 0.00
Memo Item
Pooled Investment Account
Opening
Opening
Accrued
Change in
Interest
Transfers
Transfers
Ending
Total Cash &
Total Cash &
Interfund Loans
Fund
Fund Name
Cash Balance
Receipts
Disbursements
Earned
In
Out
Cash Balance
Investments
Investments
(Borrowing)
City Operations Total 255,285,203.18 22,905,510.82 30,451,949.81 115,132.37 1 3,543,576.40 1 3,543,576.40 1 247,853,896.56 0.00 1 247,853,896.56 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
150,187,135.10
78,723.33
(9,495.29)
(25,783.08)
25,000,000.00
91,933.14
175,138,646.92
175,138,646.92
2013 January. controllers cash repon.xls - Controllers Cash Report Page 5 of 7
City of South Bend
Cash Balance Report
Period Ending: January 2013
Account Bank Account Current Prior Q3 Q2 Q1 Prior
Month I Month September June March December
City Controlled Bank Accounts
City Cash Total 234,978,255.37 - - - - 243,214,715.19
Century Center Controlled Accounts
1st Source
Depositoty
231,393,951.85
241,096,766.64
1st Source
Payroll
233,371.17
145,031.81
1st Source
Disbursement
1,898,003.70
402,349.78
xxxx
1st Source
Police Grant
-
-
1st Source
Police Grant 299
331,228.21
335,340.82
1st Source
Section 108 OPW
-
-
1 st Source
Benefits
26,118.92
26,118.92
1st Source
Section 108 -8 Custodial
-
-
1st Source
Section 108 -8 Loan
186,717.60
223,586.53
1st Source
Section 108 -8 Investment
-
-
Key Bank
Century Center Capital
1,374,899.48
1,274,877.44
xxxx
xxxx
1xxxx
-
i
i
i
i -
1st Source
lVariance
1 706.78
1
1
1
1
1 706.87
City Cash Total 234,978,255.37 - - - - 243,214,715.19
Century Center Controlled Accounts
CC Cash Total 1,539,260.61 1 - - - - 901,198.47
Bank of New York Mellon to Lake City
Key Bank
Op erating/ Pett Cash
1,390,546.88
781,675.43
Key Bank
Payroll
4,322.32
4,500.46
Key Bank
Event
144,391.41
115,022.58
xxxx
xxxx
xxxx
1,481,907.30
1,383,306.44
CC Cash Total 1,539,260.61 1 - - - - 901,198.47
Bank of New York Mellon to Lake City
xx Cash Total 11,336,380.58 1 - - - - 11,169,289.52
2013 January. controllers cash report.xls - Cash Balances Page 6 of 7
Fund 653
Cash with Fiscal Agent
9,714,340.82
9,710,816.93
Fund 619
Cash with Fiscal Agent
99,691.27
43,727.28
Fund 425
Cash with Fiscal Agent
18,468.19
9,999.93
Fund 725
Cash with Fiscal Agent
1,481,907.30
1,383,306.44
Fund 626
Cash with Fiscal Agent
21,973.00
21,438.94
xx Cash Total 11,336,380.58 1 - - - - 11,169,289.52
2013 January. controllers cash report.xls - Cash Balances Page 6 of 7
City of South Bend
Cash Balance Report
Period Ending: January 2013
Account Bank Account Current Prior Q3 Q2 Q1 Prior
Month I Month September June March December
Total Cash on Hand per General Ledger 247,853,896.56 1 - - - - 255,285,203.18
Adjustments
Century Center Event Account
Century Center Payroll Account
xxxx
xxxx
Total Adjustments
Cash per Controller's Cash Report 247,853,896.56 1 - - - - 255,285,203.18
2013 January. controllers cash report.xls - Cash Balances Page 7 of 7