Loading...
HomeMy WebLinkAbout[06c] Treasurer ReportCouncil Agenda Item 6 fcl MEETING DATE: August 25, 2014 AGENDA ITEM: Financial Report - 2nd Quarter 2014 & June and July 2014 Financial Reports SUBMITTED BY: Finance BOARD /COMMISSION /COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: Council accepted the Is` quarter, April & May Financial Reports. BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to actual position are provided for Council review. The numbers presented are the cash balances as of June 30th and July 31, 2014. There are a couple points to highlight from the reports. CASH POSITION: - The market rate of return is approximately 1.42% with an average maturity of two years. On June 30'' the 10 -year Treasuries were 2.53 %, 2 -year Treasury is 0.46 %. The City tiers the maturity dates within the boundaries of the Investment Policy. The City has purchased some 5- year CDs in the past at 4 -5% interest rates. A few of these CDs are still owned by the City. The tiered maturity dates has helped the City maintain a higher rate of return than the current market. - Interest earnings for 2014 have rebounded in comparison to 2013. The City's policy is to hold investments until maturity. GASB 31 requires the City to mark investments at the current market value as of the close of each month. In doing this, earnings will show great fluctuations. Since the City holds investments until maturity, investment earnings over the life of a security will be healthy. The alternative would be for the City to invest in money market funds. The money market funds are earning interest similar to the Treasury rates and would equate to much lower returns than the securities we hold. - Overall, the cash and investments balance decreased $2,038,842 from the beginning of the year. FUNDS REPORT: The General fund spent 51% of the 2014 budget and received 22% of the revenue budget. Expenditures are operational in nature. The first 70% of the taxes and assessments were received in June. The July reports reflect the remaining 30% tax settlement and first half state aids. The Enterprise Funds show expenses more than revenues. The reports show 6 months of expenses and 4 months utility revenue received. The revenues will show positive as the year goes on. The amounts include debt interest payments and operational activity for the year. The proceeds for the 2014A water revenue bonds issued in June were removed from the revenues. Water fund analysis (fund 601/501) — The enclosed spreadsheet shows an analysis of the water fund, including the Water fund (601) and the Water Access fund (WAC -501). The City has received a few WAC charges in the second quarter. There are a couple developments working through the platting process. Construction is anticipated to pick up once the developments occur. V2 ¢ Sales Tax (fund 200): The sales tax fund has a balance of 51,218,593 at the end of June. The City anticipates collecting $3,372,754 in sales tax revenue through 2018; $2,249,751 was collected to date. Collections the past couple of years has been higher. The distribution formula is reviewed annually between the area cities. St. Joseph has gained a higher percentage of the distribution each year. Population and sales taxes paid increased St. Joseph's share of the distribution. Also, the economy is showing improvements where people are spending more. The anticipated expenditures total $1,698,218 leaving approximately $1,718,399 remaining for future projects. The balance includes transfers from the General and Recreational Center funds. CIP REPORTS: - Capital projects will be reviewed with the budget discussion. BUDGET /FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action — Quarterly, June and July Financial Reports 2nd Quarter ReTorts: Cash Position as of 6/30/14 Cash and Investment Holdings Chart Cash Balances by Fund /Remaining Budget General & Fire Budget to Actual Expenditures & Revenues Enterprise Funds Activity Graph Quarterly Water Fund Analysis Half Cent Sales Tax Fund Summary June and July Treasurer's ReTorts: Cash and Investment — Council Report Council Month End Revenue Summary Council Month End Revenue — General Fund Council Month End Revenue — Enterprise Funds Council Month End Expenditure Summary Council Month End Expenditure — General Fund Council Month End Expenses - Enterprise Funds REQUESTED COUNCIL ACTION: Accept the financial reports as presented. City of St. Joseph, Minnesota Cash Position As of 6/30/14 Sentry Bank Maturity Date Interest Current Balance # Securities % of Total Checking Account (Reconciled) N/A 0.15% $ 214,729 N/A Money Market Savings N/A 0.50% 5,038,901 N/A Bank Certificates of Deposit 4 months 2.00% avg 250,000 1 averages 4 months 0.88% Total Sentry Bank $ 5,503,630 50% Central MN Credit Union Share Savings Account N/A 0.00% $ 35 N/A Money Market Savings N/A 0.70% 1,263,985 N/A Power Money Market Checking N/A 0.65% 334,769 N/A Jumbo Bank Certificates of Deposit 19 -45 months 1.15% avg 813,050 2 averages 32 months 0.94% Total CMCU $ 2,411,839 22% Total Deposits $ 7,915,469 Morgan Stanley Smith Barney Brokered Money Market Savings N/A 0.01% $ 10,505 N/A Government Securities /Notes 73 -103 months 2.19% avg 974,770 2 Brokered Certificates of Deposit Tiered 3 -83 months 2.49% avg 2,035,004 16 averages 33 months 2.45% Total SB $ 3,020,279 28% Total Investments $ 3,020,279 Total Deposits and Investments $ 10,935,749 Average Interest APY 23 months 1.42% 2014 YTD Cash Held With Fiscal Agent - Northland Securities (2012A Crossover Refunding Bonds) Interest Earned Brokered Money Market Savings N/A 0.39% avg 4,639,030 $133,704 Total Cash Held With Fiscal Agent $ 4,639,030 Total Deposits, Investments & Cash w /Fiscal Agent $ 15,574,779 Cash and Investment Balance Petty Cash Administration N/A N/A $ 200 Police Department N/A N/A 75 Total Petty Cash $ 275 Custodial Credit Risk: All deposits and investments insured by FDIC /SPIC /NCUA or secured by perfected pledged collateral. Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highly sensitive, interest fluctuating investments. The City attempts to purchase longer termed investments when the interest rates are favorable and depending on cash flow needs to lock into a favorable rate. Credit Risk: There are no instruments exposed to credit risk. Maturity Concentration of Credit Risk: The City invests in various instruments and several financial institutions. % Securities Averages Brokered Money Markets $ 10,505 0.10% N/A Brokered Certificates of Deposit $ 2,035,004 18.61% 2.75 years Government Bonds /Notes $ 974,770 8.91% 7.3 years State /Local Government Securities $ 4,639,030 29.79% 6 months Foreign Currency Risk: The City only invests in USA and USA territories dA N .� 61 N 2 N H 0\0 V � O O m O N 0 Ol O Ol 0 -I l0 O Ol W m W z. Ln in U N 0 Co 0 O O Lri O r-I 0 O O O m O r-I h0 Ya) L N L V) u a) a) c V) Y 00 N h0 E U L L N 0 C 0 > U 2 m mL C7 Ln in U N 0 Co 0 O O Lri O r-I 0 O O O m O r-I V I� OO O � � N V M O O V M O M V M LL O Cl) lf) V O r— V O O LO Cl) LU 0-) 00 00 O N O 00 O Cl) J _ r Q (O N O I- 00 V M O In M O V LU O M O Cl) Cl) Cl) l(') N LO 00 00 > (O � O M I� O M 00 O I� N O M N 00 V 1 Cl) N 0 O W 000 U Lo N O O N O LU N V � Ef3 ER > I- � 000 r— N N m N LU O l(7 ' ' CO- ' ' O O O 00 O 00 00 N I- m M Q N Cl) r— N M LO V M N m N r Ef3 00 V OO O V M O OO N M O O O O O M M N M N [- In H V O V `-' N co ' ' 0 V ' ' O N 0 0 y N 00 I, N N O M M O N V W) 0 co co M m N R O m c Wo i� � C En Ef3 Ef3 Ef3 Ef3 Ef3 Ef3 Ef3 Ef3 Ef3 Ef3 Ef3 N N C N Cl) V 00 00 00 I- LO V N O i 0 z 0 O N Lr 000 ONO Lr Q_ M LU O � M LO N I- O +' N 1 (.0 d a0 O � O co V N N C 0 LL O � Cl) O E N i U) r N U) ¢ Ef3 ER Cl) i-� U O Q V 0) O O O O (O O a0 O I� W) In co a0 (O (0 (N N W O O ll- O 00 O V N m M O O M a M l(7 00 V V N Lo M M l(') N l(7 U wN r Ef3 LU M O LO M (O O 00 I- CO V 1- (O O 1- N V O 00 O N l(') (O I� N O LO V O V Z LO N W O O N Lr V V O O — � V M I- O 00 O (O V N L6 N 00 V co Lo M 00 0 Lo M Lo co O N M I� 0 N V co M (.0 LO M (O 00 O M J Q LO LO Lr V LO M LO N N O 00 O m N O 00 N 2 Q U U N X � � I a m cn C LL (J) U) N Q Z c m LL y 0 _ J H U U O R V f/1 � V 7 d V J 0 d 'a E N t O N 'a _ 0 cm V O M Wo LL LL U M > a.+ d _ C Q N L O N N N 7 E N w a U U cn cn w t7 cn W cn cC-n W Ln L CL X W 3 U Q O ++ M� ^W, W L LL W L i Ap m a m a CL CL > x x C C C C C C ^ 0 0 0 0 0 0 i LL i LL i LL i G1 G1 4 v U Gl V c v h n 0 N v v U G1 0 N c v a h LO U a N LL N Q � GJ W v v v v CL > U v w v m s LID m 1 N N N � N E L L 41 O }1 O O O 0 O Lo O O O 0 O Ln O O O 0 O O O O 0 O m O O O O N O O O O t/1 vh nrn 1 0 i� �I(0 �I\ 1 0 1 � :I \ LO N N N C N >Z K W O d C N O t CL �a Lai N t E O -tea O N E x N � L a� C N O E N � V O +� a N � y N O O 3 v � N .s C N > 3 N i N N y i L C O E N � C � L L 0 Q ++ L � AR N � A L City of St. Joseph (4,138.60) Quarterly Water Fund Analysis 1 (9,762.37) As of June 30, 2014 2 (35,187.79) Fund 601 +501, Water/WAC Fund Balance as of December 31, 2013 (audited) $ 88,093.51 Year to Date Revenue: (408.81) Interest Earnings 15,347.68 WAC fees collected for: Water Usage Charge 123,246.89 Millstream Villages - deferred charges due Water Line Charge 73,736.63 323 Lanigan Way - Partial Penalties /Other Usage Fees 3,745.84 Total Expenses WAC /Trunk Fees 14,598.91 2014 Expense Budget Antenna Lease Revenue 16,521.42 Bulk Water Sales 366.00 Net Bond Proceeds 651,806.45 Transfers from other Funds - Total Revenue 899,369.82 21.01% budget collected 2014 Revenue Budget 1,178,170.00 (includes fund 501) (excludes bond proceeds) Year to Date Expenses by Department: Debt Payments (90,692.38) Transfers to Other Funds Power and Pumping (4,138.60) Water Treatment Plant 1 (9,762.37) Water Treatment Plant 2 (35,187.79) Distribution (169.17) Wellhead Protection (408.81) Water Tower (33,729.37) Water Maintenance (98,172.04) Water Administration (16,797.52) Total Expenses 2014 Expense Budget Fund Summary as of June 30, 2014: Water Fund Cash Balance - Fund 601 +501 - unaudited Fund 501 Fund 601 " Amounts exclude activity recorded in the bond escrow fund. The balances represent the cash balance as of 6130114. Water Tower Bond Summary - as of 6/30/14 Bond issue, net 651,806.45 Sewer project portion (83,753.00) Engineering (19,600.11) Legal (526.50) Project costs (11,467.18) Remaining Balance 536,459.66 (289,058.05) 23.78% budget expensed (1,082,770.00) (excludes depreciation) (excludes water tower project) $ 698,405.28 $ 15,426.88 $ 682,978.40 00 N U n OR (O M 't �p ' CD 00 N NV 00 N N (O O (O (O M (C 00 (l 10 }1 Cl) N Cl) (� 1 N 00 (00 w 0 m N N N Cl! N E � _ _ C V N O0 O M O N O (O V l0 O ms O l0 O V d) N O � 00 N O l0 In In O 00 M O d) O In O N U (O N (O O M N O N N V (O 00 O0 (O N - LO r O0 M (O M O M N - N V N d) r (O (O I- M O0 LO O d) O N V �_ LO. O0 I-. (O V l0 M O0 (O M � 6 V I- 00 (O (O I-, l0 6 (O l0 O M CF) r O0 Clio (O N I- r r W (O O 00 M 00 M (O I- V O M O I- M M (O O0 N O0 O0 I- O0 V (O V O O) O V O"T N O (,1 O N V N O) V 00 (C (C 00 O) N N l0 l0 W V LO O l0 (O O T- N O N r V N W M N 60 (O M d) O N V O (O O (3 O 06 V 06 V -7-7 (3 O O (D - O0 00 N Q N LLU N C C L(U L Q� (n O O UU N V) - - iC O C � C 3 -O >. '6 0) '6 0) '6 C N N Y O Y N L N 0) 0) LL y N 0) C 0) 0) y0 0) j( 0) j( 0) N N y W O N N H Q ti . ti ti ti ti N ti d ti a) . ti m m (Y") ti m �• o o d o in LL> o o �' m o m o o d d d o d d Qc E � :° U —0 m .0 :° U u o d �' U c d �' U U o C a aUi U o N (O N (J f� N 3 ao N O N O N 3 .- > N .0 > N N 0 0 > M N .N O> t6 O) N O) y N O) CO U N N W U N LL N N N N N N O N y O) O N a) C 0) D N O) 0) N 0) 0) N Y O) LL' O C U _ C U C U C U- O _ C U C U C d 0 U C X O) U j( O) U X 0) 0) C U '� 0) '� 0) EO '� 0) 0) 0) '� M E LL' .O M LL' E 0) LL M N 0) M 0) 0) M E 0) lL lL 0) c 0) 0) N X 0) C Q Q� U M LL' - W C U lL LL' M lL LL' w M W LL' (n '6 ~ 3 W X (n X W (6 X 3 N U X N U X N -_ C Cu U X N- U Cu N �+ Cu y Cu `w Cu o O `w m v Cu v Cu m: v m. v m m m o d `w Cu y m d N~ N~ O N~ r Cu m N ~~ N O C~ M M~ M M H O) M H H O) >� (`M') ~ M~ M y M d N E d N N E d N '- N N E d N '- E N d N y E N E N E N N 0) != E N - O 0) W 0) C W 0) N Y Y Y E 0) N E 0) C W 0) U N W 0) N W N - W O y Cu U y Cu N U y Cu N Cu Cu Cu U y Cu 0) U Cu y N N U Cu LL' LL' U Cu LL' LL' U Cu LL' LL' LL' O LL' U Cu LL' LL' LL' C Ns(no s(n�os(n�aaao =( n�o( ns�UO (nUUUO(nUUO(n�UUU�LLUO(nUUULL ' '0(0(0 C I- r r 00 00 00 00 00 W V V V O O P O O O p 0 0 0 0 0 0 p 0 0 0 0 O O 3 0 0 O O O 0 0 0 0 0 0 O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 O O O O O O O (L N N w N N N 0 N N N N N N 0 N N N 0 N N N N 0 N N N N 0 N N N 0 N Cl Cl Cl N N N (,I U) N N N N (,I U) W f6 f6 f6 f6 f6 f6 f6 f6 f6 Q f6 f6 f6 f6 f6 f6 f6 f6 f6 O m m m m m m m m m 0 Y_ N (6 � 0) � O` w w O U w O 00 V In In N (O W O V (O O O O (O I- C '6 00 C - _ Ln OR I- Ln O � In V O Ln OR V N O a1 Cu 0) G Cu 0) - - X 00 In N V 00 00 N In 0 0 00 (O ' (O In 00 -� N M N I� N ~ C O N N ~ N N N¢ ~ In 00 I- 00 N M 0 0 0 00 M N r- LO N O0 LO O0 N � O CO In N M N V d) N N CO a1 N C LO N In C 0- 0) c 0- N (6 t t N W C m 00 M N (O N N V M V M V 00 d) 0 00 O M V M (O 00 O C 0) In M O0 I- V In N N LL (Cl) 7 LL — a a '� V M N M (O M M (O m V 0 O U (n E X W C Cu m C N v v C N C X -6 0) 0) • ^w 0) N N N O 0) 0) ( C i 6 U N U 0 X F X U p CIS U W U N N C, H 0) M U U U U O E (6 O H .0 U LL 0) ) O) 7 O) O) O) O) .N Q d LL U Cu '6 O) O Q U O U y N N O j w - E Y N 0) C C CO 0) C C U U C 7 d CO 0) C C C C C CO 3 0I C y 0) -- 0) 0 y Cu N Y C O C U .0 C m m (6 f6 O N 'C LL N O N N �. N (6 LL LL U O_ (6 0, 0) H H m H .0 F0 N O 0) 0) 0) 0) u C 7 N >. N LL t t 'O Cu N LL Cn 0) - Cu Cu 7 E Cu W E 0) Q 0) 0) 0) 0) W •E 3 N O O> .0 N 000) )LL LLCO CO LLi7 W W W W w N CO CO �.2 NQ li LL) N O0 I- O O 10 O O O O 00 O O O O O 00 W U N �' Y X N N 0) C -O LL O (O O (O r O O O O O (O 0 0 0 0 V 0) Cu Cu W c N W M N l0 M Cl) V l0 l0 Cl) V W N O O O O l0 M_ O a) 0) C LL- W W U U I� d) O O r O O O O O Q 7 O O M N O) I- V I- 00 N m r V M N N M r- l0 l0 O I- I- 00 00 U N U CO C~ M a o V N O N M N V N M O `-' N n O N 'O N 0) M H H M •- 0) Y Y C N N N 'V N M N M ` O a`am Cu 0 °aUUUUUL`6L� 00 N U n OR (O M 't �p ' CD 00 N NV 00 N N (O O (O (O M (C 00 (l 10 }1 Cl) N Cl) (� 1 N 00 (00 w 0 m N N N Cl! N E � _ _ C V N O0 O M O N O (O V l0 O ms O l0 O V d) N O � 00 N O l0 In In O 00 M O d) O In O N U (O N (O O M N O N N V (O 00 O0 (O N - LO r O0 M (O M O M N - N V N d) r (O (O I- M O0 LO O d) O N V �_ LO. O0 I-. (O V l0 M O0 (O M � 6 V I- 00 (O (O I-, l0 6 (O l0 O M CF) r O0 Clio (O N I- r r W (O O 00 M 00 M (O I- V O M O I- M M (O O0 N O0 O0 I- O0 V (O V O O) O V O"T N O (,1 O N V N O) V 00 (C (C 00 O) N N l0 l0 W V LO O l0 (O O T- N O N r V N W M N 60 (O M d) O N V O (O O (3 O 06 V 06 V -7-7 (3 O O (D - O0 00 N Q N LLU N C C L(U L Q� (n O O UU N V) - - iC O C � C 3 -O >. '6 0) '6 0) '6 C N N Y O Y N L N 0) 0) LL y N 0) C 0) 0) y0 0) j( 0) j( 0) N N y W O N N H Q ti . ti ti ti ti N ti d ti a) . ti m m (Y") ti m �• o o d o in LL> o o �' m o m o o d d d o d d Qc E � :° U —0 m .0 :° U u o d �' U c d �' U U o C a aUi U o N (O N (J f� N 3 ao N O N O N 3 .- > N .0 > N N 0 0 > M N .N O> t6 O) N O) y N O) CO U N N W U N LL N N N N N N O N y O) O N a) C 0) D N O) 0) N 0) 0) N Y O) LL' O C U _ C U C U C U- O _ C U C U C d 0 U C X O) U j( O) U X 0) 0) C U '� 0) '� 0) EO '� 0) 0) 0) '� M E LL' .O M LL' E 0) LL M N 0) M 0) 0) M E 0) lL lL 0) c 0) 0) N X 0) C Q Q� U M LL' - W C U lL LL' M lL LL' w M W LL' (n '6 ~ 3 W X (n X W (6 X 3 N U X N U X N -_ C Cu U X N- U Cu N �+ Cu y Cu `w Cu o O `w m v Cu v Cu m: v m. v m m m o d `w Cu y m d N~ N~ O N~ r Cu m N ~~ N O C~ M M~ M M H O) M H H O) >� (`M') ~ M~ M y M d N E d N N E d N '- N N E d N '- E N d N y E N E N E N N 0) != E N - O 0) W 0) C W 0) N Y Y Y E 0) N E 0) C W 0) U N W 0) N W N - W O y Cu U y Cu N U y Cu N Cu Cu Cu U y Cu 0) U Cu y N N U Cu LL' LL' U Cu LL' LL' U Cu LL' LL' LL' O LL' U Cu LL' LL' LL' C Ns(no s(n�os(n�aaao =( n�o( ns�UO (nUUUO(nUUO(n�UUU�LLUO(nUUULL ' '0(0(0 C I- r r 00 00 00 00 00 W V V V O O P O O O p 0 0 0 0 0 0 p 0 0 0 0 O O 3 0 0 O O O 0 0 0 0 0 0 O O O O O O O O O O O O O O 0 0 0 0 0 0 0 0 O O O O O O O (L N N w N N N 0 N N N N N N 0 N N N 0 N N N N 0 N N N N 0 N N N 0 N Cl Cl Cl N N N (,I U) N N N N (,I U) W f6 f6 f6 f6 f6 f6 f6 f6 f6 Q f6 f6 f6 f6 f6 f6 f6 f6 f6 O m m m m m m m m m CITY OF ST. JOSEPH Cash Balances Only Current Period: June 2014 MTD MTD Current FUND Descr Account Begin Yr Debit Credit Balance Last Dim 10100 General G 101 -10100 $1,214,534.57 $443,246.12 $206,738.37 $550,035.94 Employee Retirement Reserve G 102 -10100 $0.00 $0.00 $0.00 $0.00 Fire Fund G 105 -10100 $487,027.32 $752.91 $48,292.99 $524,209.73 Cable Access Fee G 108 -10100 $6,152.02 $721.90 $0.00 $10,476.72 Economic Development G 150 -10100 $116,317.66 $64,814.13 $19,814.85 $125,145.05 TIF 2 -1 Millstream G 157 -10100 $14,115.17 $15,493.45 $46.19 $29,711.98 TIF 2 -2 Meat Market G 158 -10100 $34.13 $1,408.18 $45.00 $1,399.90 State Collected Sales Tax G 200 -10100 $1,340,119.29 $34,858.65 $17,389.20 $1,218,593.15 Park Dedication G 205 -10100 $54,660.10 $1,359.55 $11,640.20 $41,941.26 Charitable Gambling G 215 -10100 $3,947.46 $1.61 $0.33 $3,985.81 Revolving Loan Fund G 250 -10100 $30,853.05 $343.68 $2.84 $35,199.85 2009A CrossoverRefunding Bo G 318 -10100 $378,931.21 $89,261.04 $33.30 $473,784.03 2007 Refunding (98/99 St Bon G 320 -10100 $90,198.50 $13,433.36 $7.64 $103,144.81 City Hall Refunded, 2005 G 322 -10100 $3,801.11 $34,358.70 $0.24 $34,485.31 2011A Refunding Fire Hall G 331 -10100 $96,884.08 $9,085.33 $8.87 $117,244.13 2010B Refundin (Hill /Clover) G 333 -10100 $279,471.00 $39,161.69 $23.35 $311,695.72 2011A CO Refund (Interior Sts G 338 -10100 $149,631.78 $36,462.96 $12.33 $194,018.53 2007 St Impry -E Side /3ade /8 A G 341 -10100 $451,442.33 $6,660.75 $37.99 $456,592.56 2009B GO CIP Bonds G 343 -10100 $5,161.41 $24,417.39 $0.32 $24,856.93 2010 Equipment Certificates G 344 -10100 $3,597.49 $12,247.51 $0.29 $15,170.26 2010B Street Impr (16th Ave) G 345 -10100 $215,136.47 $10,383.22 $17.94 $219,188.27 2011A Pumper Truck Certificat G 346 -10100 $1,559.67 $27,438.83 $0.61 $36,458.77 2011A GO CIP Bonds G 347 -10100 $12,286.67 $8,116.51 $15.61 $20,502.16 2013 Street Improve Bonds G 348 -10100 $85,292.99 $4,359.87 $15.78 $84,130.66 2013 Equipment Certificates G 349 -10100 $5,190.81 $21.33 $4.43 $2,412.90 2014 Street Impr[ParkTerrace G 350 -10100 $0.00 $121,307.25 $56,982.34 $190,478.25 Debt Service Relief G 390 -10100 $288,442.46 $1,171.97 $31.80 $284,364.42 2011A GO CIP Bonds G 447 -10100 $174,042.45 $0.00 $0.00 $174,042.45 2013 Imp Cedar /Baker /Ridgew G 448 -10100 $105,698.76 $0.00 $95.70 $103,754.96 2013 Equipment Certificates G 449 -10100 $200,495.55 $0.00 $518.75 $42,758.39 2014 Imp Park Terrace G 450 -10100 $0.00 $1,986,653.80 $6,386.92 $1,902,173.84 Capital Outlay G 490 -10100 $202,751.95 $0.00 $268.43 $262,721.42 Water Extension G 501 -10100 $44.48 $5,001.63 $0.34 $15,426.88 Sewer Extension G 502 -10100 $585,859.32 $238.56 $49.55 $593,067.29 Water Fund G 601 -10100 $3,590.04 $734,227.66 $48,586.57 $682,978.40 Sewer Fund G 602 -10100 $1,829,479.67 $74,928.27 $80,341.86 $1,567,124.38 Refuse Collection G 603 -10100 $254,336.58 $30,491.09 $25,934.08 $242,707.11 Storm Water Utility G 651 -10100 $205,799.32 $13,586.93 $3,944.92 $233,415.85 Street Light Utility G 652 -10100 $20.14 $6,678.44 $3,739.18 $6,350.76 Last Dim 10100 $8,896,907.01 $3,852,694.27 $531,029.11 $10,935,748.83 Last Dim 10200 General G 101 -10200 $275.00 $0.00 $0.00 $275.00 Last Dim 10200 $275.00 $0.00 $0.00 $275.00 Last Dim 10300 Water Fund G 601 -10300 $4,682,985.00 $10,048.63 $0.00 $4,639,029.88 Last Dim 10300 $4,682,985.00 $10,048.63 $0.00 $4,639,029.88 $13,580,167.01 $3,862,742.90 $531,029.11 $15,575,053.71 CITY OF ST. JOSEPH 08/15/14 1:56 PM Cash Balances Only Page 1 Current Period: July 2014 MTD MTD Current FUND Descr Account Begin Yr Debit Credit Balance Last Dim 10100 General G 101 -10100 $1,214,534.57 $2,141,790.59 $1,708,713.97 $983,112.56 Employee Retirement Reserve G 102 -10100 $0.00 $0.00 $0.00 $0.00 Fire Fund G 105 -10100 $487,027.32 $53,752.61 $9,806.33 $568,156.01 Cable Access Fee G 108 -10100 $6,152.02 $693.96 $0.00 $11,170.68 Economic Development G 150 -10100 $116,317.66 $31,040.85 $13,325.72 $142,860.18 TIF 2 -1 Millstream G 157 -10100 $14,115.17 $6,652.20 $19,989.03 $16,375.15 TIF 2 -2 Meat Market G 158 -10100 $34.13 $603.87 $1,987.38 $16.39 State Collected Sales Tax G 200 -10100 $1,340,119.29 $36,486.84 $562.48 $1,254,517.51 Park Dedication G 205 -10100 $54,660.10 $50.94 $210.00 $41,782.20 Charitable Gambling G 215 -10100 $3,947.46 $2,403.00 $902.12 $5,486.69 Revolving Loan Fund G 250 -10100 $30,853.05 $699.62 $0.00 $35,899.47 2009A CrossoverRefunding Bo G 318 -10100 $378,931.21 $40,279.39 $0.00 $514,063.42 2007 Refunding (98/99 St Bon G 320 -10100 $90,198.50 $7,338.51 $0.00 $110,483.32 City Hall Refunded, 2005 G 322 -10100 $3,801.11 $14,734.43 $0.00 $49,219.74 2011A Refunding Fire Hall G 331 -10100 $96,884.08 $10,560.42 $0.00 $127,804.55 2010B Refundin (Hill /Clover) G 333 -10100 $279,471.00 $50,318.47 $0.00 $362,014.19 2011A CO Refund (Interior Sts G 338 -10100 $149,631.78 $15,725.46 $0.00 $209,743.99 2007 St Impry -E Side /3ade /8 A G 341 -10100 $451,442.33 $4,716.25 $0.00 $461,308.81 2009B GO CIP Bonds G 343 -10100 $5,161.41 $10,471.67 $0.00 $35,328.60 2010 Equipment Certificates G 344 -10100 $3,597.49 $5,253.81 $0.00 $20,424.07 2010B Street Impr (16th Ave) G 345 -10100 $215,136.47 $4,660.52 $0.00 $223,848.79 2011A Pumper Truck Certificat G 346 -10100 $1,559.67 $17,145.34 $0.00 $53,604.11 2011A GO CIP Bonds G 347 -10100 $12,286.67 $3,588.69 $0.00 $24,090.85 2013 Street Improve Bonds G 348 -10100 $85,292.99 $2,329.78 $0.00 $86,460.44 2013 Equipment Certificates G 349 -10100 $5,190.81 $36.97 $0.00 $2,449.87 2014 Street Impr [ParkTerrace G 350 -10100 $0.00 $537.55 $0.00 $191,015.80 Debt Service Relief G 390 -10100 $288,442.46 $502.27 $0.00 $284,866.69 2011A GO CIP Bonds G 447 -10100 $174,042.45 $0.00 $0.00 $174,042.45 2013 Imp Cedar /Baker /Ridgew G 448 -10100 $105,698.76 $0.00 $120.20 $103,634.76 2013 Equipment Certificates G 449 -10100 $200,495.55 $0.00 $0.00 $42,758.39 2014 Imp Park Terrace G 450 -10100 $0.00 $0.00 $4,551.20 $1,897,622.64 Capital Outlay G 490 -10100 $202,751.95 $0.00 $0.00 $262,721.42 Water Extension G 501 -10100 $44.48 $4,257.79 $0.00 $19,684.67 Sewer Extension G 502 -10100 $585,859.32 $1,194.90 $0.00 $594,262.19 Water Fund G 601 -10100 $3,590.04 $68,324.13 $287,878.83 $463,423.70 Sewer Fund G 602 -10100 $1,829,479.67 $65,936.26 $86,782.70 $1,546,277.94 Refuse Collection G 603 -10100 $254,336.58 $19,997.61 $26,150.10 $236,554.62 Storm Water Utility G 651 -10100 $205,799.32 $8,389.72 $2,401.99 $239,403.58 Street Light Utility G 652 -10100 $20.14 $6,382.93 $3,373.50 $9,360.19 Last Dim 10100 $8,896,907.01 $2,636,857.35 $2,166,755.55 $11,405,850.63 Last Dim 10200 General G 101 -10200 $275.00 $0.00 $0.00 $275.00 Last Dim 10200 $275.00 $0.00 $0.00 $275.00 Last Dim 10300 Water Fund G 601 -10300 $4,682,985.00 $0.00 $0.00 $4,639,029.88 Last Dim 10300 $4,682,985.00 $0.00 $0.00 $4,639,029.88 $13,580,167.01 $2,636,857.35 $2,166,755.55 $16,045,155.51 CITY OF ST. JOSEPH Council Month End Revenue Summary Current Period: June 2014 08/15/14 9:35 AM Page 1 $6,705,150.00 $3,848,635.63 $4,983,083.51 2014 June 2014 FUND FUND Descr YTD Budget 2014 Amt YTD Amt 101 General $2,430,620.00 $433,369.74 $534,090.08 102 Employee Retirement Reserve $0.00 $0.00 $0.00 105 Fire Fund $281,980.00 $678.99 $116,619.45 108 Cable Access Fee $7,450.00 $721.90 $3,606.38 150 Economic Development $130,595.00 $64,806.37 $212,162.26 157 TIF 2 -1 Millstream $0.00 $15,492.26 $15,637.25 158 TIF 2 -2 Meat Market $0.00 $1,408.18 $1,410.70 200 State Collected Sales Tax $0.00 $34,858.65 $83,089.79 205 Park Dedication $0.00 $1,275.15 $5,816.92 215 Charitable Gambling $0.00 $1.28 $36.84 250 Revolving Loan Fund $8,380.00 $340.84 $4,338.04 318 2009A CrossoverRefunding Bonds $219,545.00 $89,227.74 $92,961.85 320 2007 Refunding (98/99 St Bond) $30,340.00 $13,425.72 $14,390.69 322 City Hall Refunded, 2005 $94,100.00 $34,358.46 $34,444.44 331 2011A Refunding Fire Hall $52,445.00 $9,076.46 $23,159.71 333 2010B Refundin (Hill /Clover) $101,630.00 $39,138.34 $41,791.90 338 2011A CO Refund (Interior Sts) $53,860.00 $36,450.63 $53,228.40 341 2007 St Impry -E Side /3ade /8 Av $54,250.00 $6,622.76 $10,778.79 343 2009B GO CIP Bonds $66,800.00 $24,417.07 $24,499.95 344 2010 Equipment Certificates $33,500.00 $12,247.22 $12,299.29 345 2010B Street Impr (16th Ave) $37,830.00 $10,365.28 $12,342.58 346 2011A Pumper Truck Certificate $43,935.00 $27,438.22 $38,201.78 347 2011A GO CIP Bonds $22,240.00 $8,100.90 $9,778.11 348 2013 Street Improve Bonds $21,130.00 $4,344.09 $6,133.74 349 2013 Equipment Certificates $54,250.00 $16.90 $1,241.77 350 2014 Street Impr [ParkTerrace] $0.00 $121,305.91 $247,459.25 390 Debt Service Relief $0.00 $1,171.97 $23,812.92 447 2011A GO CIP Bonds $0.00 $0.00 $0.00 448 2013 Imp Cedar /Baker /Ridgewood $0.00 $0.00 $0.00 449 2013 Equipment Certificates $0.00 $0.00 $0.00 450 2014 Imp Park Terrace $0.00 $1,986,653.80 $1,986,653.80 490 Capital Outlay $0.00 $0.00 $84,080.00 501 Water Extension $0.00 $5,001.29 $14,863.27 502 Sewer Extension $0.00 $189.01 $7,012.54 601 Water Fund $1,178,170.00 $742,307.41 $913,351.18 602 Sewer Fund $1,322,920.00 $74,750.81 $222,829.14 603 Refuse Collection $287,025.00 $28,825.54 $97,915.13 651 Storm Water Utility $119,130.00 $13,568.52 $13,756.10 652 Street Light Utility $53,025.00 $6,678.22 $19,289.47 $6,705,150.00 $3,848,635.63 $4,983,083.51 CITY OF ST. JOSEPH Council Month End Revenue Summary Current Period: July 2014 08/15/14 3:53 PM Page 1 2014 July 2014 FUND FUND Descr YTD Budget 2014 Amt YTD Amt 101 General $2,430,620.00 $636,458.66 $1,170,548.74 102 Employee Retirement Reserve $0.00 $0.00 $0.00 105 Fire Fund $281,980.00 $53,505.16 $170,124.61 108 Cable Access Fee $7,450.00 $693.96 $4,300.34 150 Economic Development $130,595.00 $31,040.85 $243,203.11 157 TIF 2 -1 Millstream $0.00 $6,652.20 $22,289.45 158 TIF 2 -2 Meat Market $0.00 $603.87 $2,014.57 200 State Collected Sales Tax $0.00 $36,486.84 $119,576.63 205 Park Dedication $0.00 $2,438.44 $8,255.36 215 Charitable Gambling $0.00 $2,403.00 $2,439.84 250 Revolving Loan Fund $8,380.00 $699.62 $5,037.66 318 2009A CrossoverRefunding Bonds $219,545.00 $40,279.39 $133,241.24 320 2007 Refunding (98/99 St Bond) $30,340.00 $7,338.51 $21,729.20 322 City Hall Refunded, 2005 $94,100.00 $14,734.43 $49,178.87 331 2011A Refunding Fire Hall $52,445.00 $10,560.42 $33,720.13 333 2010B Refundin (Hill /Clover) $101,630.00 $50,318.47 $92,110.37 338 2011A CO Refund (Interior Sts) $53,860.00 $15,725.46 $68,953.86 341 2007 St Impry -E Side /3ade /8 Av $54,250.00 $4,716.25 $15,495.04 343 2009B GO CIP Bonds $66,800.00 $10,471.67 $34,971.62 344 2010 Equipment Certificates $33,500.00 $5,253.81 $17,553.10 345 2010B Street Impr (16th Ave) $37,830.00 $4,660.52 $17,003.10 346 2011A Pumper Truck Certificate $43,935.00 $17,145.34 $55,347.12 347 2011A GO CIP Bonds $22,240.00 $3,588.69 $13,366.80 348 2013 Street Improve Bonds $21,130.00 $2,329.78 $8,463.52 349 2013 Equipment Certificates $54,250.00 $36.97 $1,278.74 350 2014 Street Impr [ParkTerrace] $0.00 $537.55 $247,996.80 390 Debt Service Relief $0.00 $502.27 $24,315.19 447 2011A GO CIP Bonds $0.00 $0.00 $0.00 448 2013 Imp Cedar /Baker /Ridgewood $0.00 $0.00 $0.00 449 2013 Equipment Certificates $0.00 $0.00 $0.00 450 2014 Imp Park Terrace $0.00 $0.00 $1,986,653.80 490 Capital Outlay $0.00 $0.00 $84,080.00 501 Water Extension $0.00 $4,257.79 $19,121.06 502 Sewer Extension $0.00 $1,194.90 $8,207.44 601 Water Fund $1,178,170.00 $63,206.62 $976,557.80 602 Sewer Fund $1,322,920.00 $63,988.04 $286,817.18 603 Refuse Collection $287,025.00 $17,499.36 $115,414.49 651 Storm Water Utility $119,130.00 $8,389.72 $22,145.82 652 Street Light Utility $53,025.00 $6,332.93 $25,622.40 $6,705,150.00 $1,124,051.49 $6,107,135.00 CITY OF ST. JOSEPH Council Month End Revenue - General Fund Current Period: June 2014 2014 June 2014 FUND FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt FUND 101 General 101 General Current Ad Valorem Taxes $1,097,245.00 $399,960.31 $399,960.32 101 General Special Levy- City St. Joe $0.00 $0.00 $0.00 101 General State Sales Tax $0.00 - $49.25 $12.55 101 General Gas Franchise $28,000.00 $0.00 $7,838.27 101 General Electric Franchise $52,000.00 $1,798.91 $17,445.72 101 General Beer $375.00 $0.00 $110.00 101 General Liquor $24,000.00 $1,555.00 $14,215.00 101 General Outdoor Liquor Permit $2,500.00 $150.00 $150.00 101 General Gambling Permits $120.00 $0.00 $155.00 101 General Amusement /Hunting Permit $1,000.00 $0.00 $0.00 101 General Excavation Permit $300.00 $100.00 $600.00 101 General Cigarette License $525.00 $0.00 $0.00 101 General Cable Franchise Fee $30,000.00 $1,161.78 $10,212.28 101 General Building Permits $45,000.00 $3,639.57 $12,288.61 101 General Animal License $3,150.00 $145.00 $2,825.00 101 General Rental Housing Registration $22,000.00 $2,954.00 $5,582.50 101 General Federal Grants - Other $5,000.00 $0.00 $1,137.10 101 General State Grants and Aids $0.00 $0.00 $0.00 101 General Local Government Aid $873,160.00 $0.00 $0.00 101 General PERA Rate Increase Aid $1,540.00 $0.00 $0.00 101 General Police Training Reim $3,500.00 $0.00 $0.00 101 General State Municipal Funds Aid $6,180.00 $0.00 $3,772.50 101 General State Police Aid $48,000.00 $0.00 $41.50 101 General Other Grants /Aids $250.00 $0.00 $0.00 101 General Other Governmental Unit $10,000.00 $0.00 $5,000.00 101 General County Grants - Road Maint. $7,750.00 $0.00 $0.00 101 General Zoning and Subdivision Fee $1,000.00 $0.00 $0.00 101 General Land Use Deposit Fee $4,000.00 $10,000.00 $1,000.00 101 General Sale of Maps and Publications $50.00 $0.50 $28.00 101 General Assessments Search $2,500.00 $150.00 $720.00 101 General Special Hearing $4,500.00 $850.00 $1,900.00 101 General Administration Reimb $11,600.00 $14.32 $89.32 101 General Weed Cutting $1,000.00 $0.00 - $100.00 101 General Park Fees $5,500.00 $600.00 $4,240.00 101 General Ball Field Donation $500.00 $0.00 $0.00 101 General Schneider Field Rental $2,700.00 $625.00 $625.00 101 General Kennel Fees $500.00 $61.00 $316.00 101 General County Fines $27,000.00 $2,917.72 $10,148.43 101 General Policy Fines $35,000.00 $770.00 $7,420.00 101 General Accident Report Fee $1,000.00 $60.00 $483.75 101 General Seized Property $500.00 $0.00 $0.00 101 General Special Assessments $1,500.00 $4,311.33 $4,311.33 08/15/14 9:35 AM Page 1 CITY OF ST. JOSEPH Council Month End Revenue - General Fund Current Period: June 2014 08/15/14 9:35 AM Page 2 FUND 102 Employee Retirement Reserve 102 Employee Retirement Res Current Ad Valorem Taxes 102 Employee Retirement Res Interest Earnings 102 Employee Retirement Res Transfers from Other Funds FUND 102 Employee Retirement Reserve FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee 108 Cable Access Fee Transfers from Other Funds FUND 108 Cable Access Fee FUND 150 Economic Development 150 Economic Development 2014 June 2014 FUND FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt 101 General Interest Earnings $15,000.00 $234.51 $10,360.51 101 General Interest Charges $100.00 $0.00 - $28.06 101 General Co -op Dividend - LMCIT $15,000.00 $0.00 $0.00 101 General Water Tower Antenna Lease $3,550.00 $305.96 $1,835.76 101 General Advertising $2,000.00 $200.00 $660.00 101 General Contributions - General $1,500.00 $0.00 $1,000.00 101 General Contribution - Health Ins Div $0.00 $0.00 $0.00 101 General Contributions - Parks $1,000.00 $216.61 $341.74 101 General Surplus Property $0.00 $0.00 $0.00 101 General Reimbursement $32,025.00 $637.47 $7,391.95 101 General Street Access Fee $0.00 $0.00 $0.00 101 General Transfers from Other Funds $0.00 $0.00 $0.00 FUND 101 General $2,430,620.00 $433,369.74 $534,090.08 FUND 102 Employee Retirement Reserve 102 Employee Retirement Res Current Ad Valorem Taxes 102 Employee Retirement Res Interest Earnings 102 Employee Retirement Res Transfers from Other Funds FUND 102 Employee Retirement Reserve FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee 108 Cable Access Fee Transfers from Other Funds FUND 108 Cable Access Fee FUND 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development FUND 150 Economic Development Current Ad Valorem Taxes Federal Grants - Other TIF /MIF Deposit DEED Housing Reimbursement Interest Earnings Transfers from Other Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,450.00 $721.90 $3,606.38 $0.00 $0.00 $0.00 $7,450.00 $721.90 $3,606.38 $130,095.00 $48,915.78 $48,915.78 $0.00 $15,861.00 $162,156.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500.00 $29.59 $1,090.48 $0.00 $0.00 $0.00 $130,595.00 $64,806.37 $212,162.26 $2,568,665.00 $498,898.01 $749,858.72 CITY OF ST. JOSEPH 08/15/14 3:53 PM Council Month End Revenue - General Fund Page 1 Current Period: July 2014 2014 July 2014 FUND FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt FUND 101 General 101 General Current Ad Valorem Taxes $1,097,245.00 $170,143.10 $570,103.42 101 General Special Levy- City St. Joe $0.00 $0.00 $0.00 101 General State Sales Tax $0.00 $22.86 $35.41 101 General Gas Franchise $28,000.00 $0.00 $7,838.27 101 General Electric Franchise $52,000.00 $0.00 $17,445.72 101 General Beer $375.00 $5.00 $115.00 101 General Liquor $24,000.00 -$5.00 $14,210.00 101 General Outdoor Liquor Permit $2,500.00 $0.00 $150.00 101 General Gambling Permits $120.00 $40.00 $195.00 101 General Amusement /Hunting Permit $1,000.00 $0.00 $0.00 101 General Excavation Permit $300.00 $50.00 $650.00 101 General Cigarette License $525.00 $0.00 $0.00 101 General Cable Franchise Fee $30,000.00 $5,689.17 $15,901.45 101 General Building Permits $45,000.00 $1,598.84 $13,887.45 101 General Animal License $3,150.00 $140.00 $2,965.00 101 General Rental Housing Registration $22,000.00 $4,738.75 $10,321.25 101 General Federal Grants - Other $5,000.00 $0.00 $1,137.10 101 General State Grants and Aids $0.00 $0.00 $0.00 101 General Local Government Aid $873,160.00 $436,586.00 $436,586.00 101 General PERA Rate Increase Aid $1,540.00 $770.50 $770.50 101 General Police Training Reim $3,500.00 $0.00 $0.00 101 General State Municipal Funds Aid $6,180.00 $3,772.50 $7,545.00 101 General State Police Aid $48,000.00 $0.00 $41.50 101 General Other Grants /Aids $250.00 $0.00 $0.00 101 General Other Governmental Unit $10,000.00 $5,000.00 $10,000.00 101 General County Grants - Road Maint. $7,750.00 $0.00 $0.00 101 General Zoning and Subdivision Fee $1,000.00 $0.00 $0.00 101 General Land Use Deposit Fee $4,000.00 - $2,000.00 - $1,000.00 101 General Sale of Maps and Publications $50.00 $0.50 $28.50 101 General Assessments Search $2,500.00 $240.00 $960.00 101 General Special Hearing $4,500.00 $650.00 $2,550.00 101 General Administration Reimb $11,600.00 $6.00 $95.32 101 General Weed Cutting $1,000.00 $0.00 - $100.00 101 General Park Fees $5,500.00 $480.00 $4,720.00 101 General Ball Field Donation $500.00 $0.00 $0.00 101 General Schneider Field Rental $2,700.00 $230.00 $855.00 101 General Kennel Fees $500.00 $0.00 $316.00 101 General County Fines $27,000.00 $2,321.52 $12,469.95 101 General Policy Fines $35,000.00 $255.00 $7,675.00 101 General Accident Report Fee $1,000.00 $45.75 $529.50 101 General Seized Property $500.00 $0.00 $0.00 101 General Special Assessments $1,500.00 $164.81 $4,476.14 CITY OF ST. JOSEPH 08/15/14 3:53 PM Council Month End Revenue - General Fund Page 2 Current Period: July 2014 FUND 102 Employee Retirement Reserve 102 Employee Retirement Res Current Ad Valorem Taxes 102 Employee Retirement Res Interest Earnings 102 Employee Retirement Res Transfers from Other Funds FUND 102 Employee Retirement Reserve FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee 108 Cable Access Fee Transfers from Other Funds FUND 108 Cable Access Fee FUND 150 Economic Development 150 Economic Development 2014 July 2014 FUND FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt 101 General Interest Earnings $15,000.00 $962.50 $11,323.01 101 General Interest Charges $100.00 $0.25 - $27.81 101 General Co -op Dividend - LMCIT $15,000.00 $0.00 $0.00 101 General Water Tower Antenna Lease $3,550.00 $305.96 $2,141.72 101 General Advertising $2,000.00 $0.00 $660.00 101 General Contributions - General $1,500.00 $0.00 $1,000.00 101 General Contribution - Health Ins Div $0.00 $0.00 $0.00 101 General Contributions - Parks $1,000.00 $345.09 $686.83 101 General Surplus Property $0.00 $0.00 $0.00 101 General Reimbursement $32,025.00 $3,899.56 $11,291.51 101 General Street Access Fee $0.00 $0.00 $0.00 101 General Transfers from Other Funds $0.00 $0.00 $0.00 FUND 101 General $2,430,620.00 $636,458.66 $1,170,548.74 FUND 102 Employee Retirement Reserve 102 Employee Retirement Res Current Ad Valorem Taxes 102 Employee Retirement Res Interest Earnings 102 Employee Retirement Res Transfers from Other Funds FUND 102 Employee Retirement Reserve FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee 108 Cable Access Fee Transfers from Other Funds FUND 108 Cable Access Fee FUND 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development 150 Economic Development FUND 150 Economic Development Current Ad Valorem Taxes Federal Grants - Other TIF /MIF Deposit DEED Housing Reimbursement Interest Earnings Transfers from Other Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,450.00 $693.96 $4,300.34 $0.00 $0.00 $0.00 $7,450.00 $693.96 $4,300.34 $130,095.00 $20,963.90 $69,879.68 $0.00 $10,000.00 $172,156.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500.00 $76.95 $1,167.43 $0.00 $0.00 $0.00 $130,595.00 $31,040.85 $243,203.11 $2,568,665.00 $668,193.47 $1,418,052.19 CITY OF ST. JOSEPH 08/15/14 9:35 AM Council Month End Revenue - Enterprise Funds Page 1 Current Period: June 2014 FUND 2014 June 2014 FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt FUND 601 Water Fund 601 Water Fund Water Meter $5,000.00 $0.00 $472.80 601 Water Fund State Sales Tax $225.00 - $207.09 - $2,935.66 601 Water Fund Bond Premium Proceeds $0.00 $10,602.45 $10,602.45 601 Water Fund General Oblig. Bond Proceeds $0.00 $660,000.00 $660,000.00 601 Water Fund Transfers from Other Funds $337,500.00 $0.00 $0.00 601 Water Fund Contributed Revenue $0.00 $0.00 $0.00 601 Water Fund Water Line Charge $239,785.00 $20,650.18 $73,736.63 601 Water Fund Penalties and Forfeited Disc $7,190.00 $334.24 $4,269.29 601 Water Fund Connection /Reconnection fees $500.00 $0.00 $0.00 601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00 601 Water Fund Special Assessments $800.00 $1,580.87 - $3,456.35 601 Water Fund MDS Test Fee $11,645.00 $1,083.80 $3,437.23 601 Water Fund Interest Earnings $35,990.00 $10,527.57 $25,131.95 601 Water Fund Undesignated Funds $0.00 $12.38 $1,883.73 601 Water Fund Water Tower Antenna Lease $33,005.00 $2,753.57 $16,521.42 601 Water Fund Surplus Property $0.00 $0.00 $0.00 601 Water Fund Reimbursement $0.00 $0.00 $74.80 601 Water Fund Rate Class One $505,530.00 $34,904.44 $123,246.89 601 Water Fund Bulk Water $1,000.00 $65.00 $366.00 FUND 601 Water Fund $1,178,170.00 $742,307.41 $913,351.18 FUND 602 Sewer Fund 602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00 602 Sewer Fund Sanitary Sewer Service $433,200.00 $46,187.83 $125,067.95 602 Sewer Fund Special Assessments $350.00 $1,193.77 - $2,702.10 602 Sewer Fund Interest Earnings $5,075.00 $529.12 $17,261.14 602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00 602 Sewer Fund Contributions - General $0.00 $0.00 $0.00 602 Sewer Fund Surplus Property $0.00 $0.00 $0.00 602 Sewer Fund Other Governmental Unit $0.00 $0.00 $0.00 602 Sewer Fund Penalties and Forfeited Disc $4,145.00 $228.32 $2,713.89 602 Sewer Fund Sewer Line Charge $269,400.00 $26,611.77 $80,488.26 602 Sewer Fund Transfers from Other Funds $607,750.00 $0.00 $0.00 602 Sewer Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00 602 Sewer Fund Bond Premium Proceeds $0.00 $0.00 $0.00 602 Sewer Fund Reimbursement $3,000.00 $0.00 $0.00 FUND 602 Sewer Fund $1,322,920.00 $74,750.81 $222,829.14 FUND 603 Refuse Collection 603 Refuse Collec Contributions - General $0.00 $0.00 $0.00 603 Refuse Collec Contributed Revenue $0.00 $0.00 $0.00 603 Refuse Collec Interest Earnings $4,000.00 $77.27 $2,318.37 603 Refuse Collec Special Assessments $500.00 $56.15 - $386.26 603 Refuse Collec Refuse Collection Charges $258,150.00 $25,752.09 $80,209.58 603 Refuse Collec Licenses & Permits $18,875.00 $1,760.00 $15,400.00 603 Refuse Collec State Sales Tax $0.00 $852.95 - $2,746.18 603 Refuse Collec Penalties and Forfeifted Disc $5,500.00 $327.08 $3,119.62 FUND 603 Refuse Collection $287,025.00 $28,825.54 $97,915.13 FUND 651 Storm Water Utility 651 Storm Water Contributed Revenue $0.00 $0.00 $0.00 651 Storm Water Transfers from Other Funds $0.00 $0.00 $0.00 651 Storm Water Penalties and Forfeifted Disc $2,000.00 $87.08 $821.82 FUND 652 Street Light Utility 652 Street Light U Transfers from Other Funds 652 Street Light U Special Assessments 652 Street Light U Interest Earnings 652 Street Light U Rate Class One 652 Street Light U Penalties and Forfeited Disc FUND 652 Street Light Utility $0.00 $0.00 CITY OF ST. JOSEPH $25.00 08/15/14 9:35 AM - $16.61 $100.00 $0.84 - $11.55 Page 2 $6,668.40 $19,317.63 Council Month End Revenue - Enterprise Funds $0.00 Current Period: June 2014 $6,678.22 $19,289.47 FUND 2014 June 2014 FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt 651 Storm Water Special Assessments $350.00 $4,418.53 - $18,318.37 651 Storm Water Development Fee $20,000.00 $0.00 $0.00 651 Storm Water Reimbursement $0.00 $0.00 $0.00 651 Storm Water Interest Earnings $550.00 $70.24 $1,994.24 651 Storm Water Rate Class One $96,230.00 $8,992.67 $29,258.41 FUND 651 Storm Water Utility $119,130.00 $13,568.52 $13,756.10 FUND 652 Street Light Utility 652 Street Light U Transfers from Other Funds 652 Street Light U Special Assessments 652 Street Light U Interest Earnings 652 Street Light U Rate Class One 652 Street Light U Penalties and Forfeited Disc FUND 652 Street Light Utility $0.00 $0.00 $0.00 $25.00 $8.98 - $16.61 $100.00 $0.84 - $11.55 $52,700.00 $6,668.40 $19,317.63 $200.00 $0.00 $0.00 $53,025.00 $6,678.22 $19,289.47 $2,960,270.00 $866,130.50 $1,267,141.02 CITY OF ST. JOSEPH 08/15/14 3:53 PM Council Month End Revenue - Enterprise Funds Page 1 Current Period: July 2014 FUND 2014 July 2014 FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt FUND 601 Water Fund 601 Water Fund Water Meter $5,000.00 $0.00 $472.80 601 Water Fund State Sales Tax $225.00 $294.09 - $2,641.57 601 Water Fund Bond Premium Proceeds $0.00 $0.00 $10,602.45 601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $660,000.00 601 Water Fund Transfers from Other Funds $337,500.00 $0.00 $0.00 601 Water Fund Contributed Revenue $0.00 $0.00 $0.00 601 Water Fund Water Line Charge $239,785.00 $20,020.96 $93,757.59 601 Water Fund Penalties and Forfeited Disc $7,190.00 $802.69 $5,071.98 601 Water Fund Connection /Reconnection fees $500.00 $50.00 $50.00 601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00 601 Water Fund Special Assessments $800.00 $677.51 - $2,778.84 601 Water Fund MDS Test Fee $11,645.00 $766.14 $4,203.37 601 Water Fund Interest Earnings $35,990.00 $1,289.91 $26,421.86 601 Water Fund Undesignated Funds $0.00 - $768.53 $1,115.20 601 Water Fund Water Tower Antenna Lease $33,005.00 $2,753.57 $19,274.99 601 Water Fund Surplus Property $0.00 $0.00 $0.00 601 Water Fund Reimbursement $0.00 $0.00 $74.80 601 Water Fund Rate Class One $505,530.00 $36,985.28 $160,232.17 601 Water Fund Bulk Water $1,000.00 $335.00 $701.00 FUND 601 Water Fund $1,178,170.00 $63,206.62 $976,557.80 FUND 602 Sewer Fund 602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00 602 Sewer Fund Sanitary Sewer Service $433,200.00 $38,470.18 $163,538.13 602 Sewer Fund Special Assessments $350.00 $511.61 - $2,190.49 602 Sewer Fund Interest Earnings $5,075.00 $1,206.73 $18,467.87 602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00 602 Sewer Fund Contributions - General $0.00 $0.00 $0.00 602 Sewer Fund Surplus Property $0.00 $0.00 $0.00 602 Sewer Fund Other Governmental Unit $0.00 $0.00 $0.00 602 Sewer Fund Penalties and Forfeited Disc $4,145.00 $541.88 $3,255.77 602 Sewer Fund Sewer Line Charge $269,400.00 $23,257.64 $103,745.90 602 Sewer Fund Transfers from Other Funds $607,750.00 $0.00 $0.00 602 Sewer Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00 602 Sewer Fund Bond Premium Proceeds $0.00 $0.00 $0.00 602 Sewer Fund Reimbursement $3,000.00 $0.00 $0.00 FUND 602 Sewer Fund $1,322,920.00 $63,988.04 $286,817.18 FUND 603 Refuse Collection 603 Refuse Collec Contributions - General $0.00 $0.00 $0.00 603 Refuse Collec Contributed Revenue $0.00 $0.00 $0.00 603 Refuse Collec Interest Earnings $4,000.00 $181.99 $2,500.36 603 Refuse Collec Special Assessments $500.00 $24.06 - $362.20 603 Refuse Collec Refuse Collection Charges $258,150.00 $16,965.30 $97,174.88 603 Refuse Collec Licenses & Permits $18,875.00 $635.00 $16,035.00 603 Refuse Collec State Sales Tax $0.00 - $845.05 - $3,591.23 603 Refuse Collec Penalties and Forfeifted Disc $5,500.00 $538.06 $3,657.68 FUND 603 Refuse Collection $287,025.00 $17,499.36 $115,414.49 FUND 651 Storm Water Utility 651 Storm Water Contributed Revenue $0.00 $0.00 $0.00 651 Storm Water Transfers from Other Funds $0.00 $0.00 $0.00 651 Storm Water Penalties and Forfeifted Disc $2,000.00 $139.98 $961.80 FUND 652 Street Light Utility 652 Street Light U Transfers from Other Funds 652 Street Light U Special Assessments 652 Street Light U Interest Earnings 652 Street Light U Rate Class One 652 Street Light U Penalties and Forfeited Disc FUND 652 Street Light Utility $0.00 $0.00 CITY OF ST. JOSEPH $25.00 08/15/14 3:53 PM - $12.77 $100.00 $3.38 -$8.17 Page 2 $6,325.71 $25,643.34 Council Month End Revenue - Enterprise Funds $0.00 Current Period: July 2014 $53,025.00 $6,332.93 $25,622.40 FUND 2014 July 2014 FUND Descr SOURCE Descr YTD Budget 2014 Amt YTD Amt 651 Storm Water Special Assessments $350.00 $738.17 - $17,580.20 651 Storm Water Development Fee $20,000.00 $0.00 $0.00 651 Storm Water Reimbursement $0.00 $0.00 $0.00 651 Storm Water Interest Earnings $550.00 $170.01 $2,164.25 651 Storm Water Rate Class One $96,230.00 $7,341.56 $36,599.97 FUND 651 Storm Water Utility $119,130.00 $8,389.72 $22,145.82 FUND 652 Street Light Utility 652 Street Light U Transfers from Other Funds 652 Street Light U Special Assessments 652 Street Light U Interest Earnings 652 Street Light U Rate Class One 652 Street Light U Penalties and Forfeited Disc FUND 652 Street Light Utility $0.00 $0.00 $0.00 $25.00 $3.84 - $12.77 $100.00 $3.38 -$8.17 $52,700.00 $6,325.71 $25,643.34 $200.00 $0.00 $0.00 $53,025.00 $6,332.93 $25,622.40 $2,960,270.00 $159,416.67 $1,426,557.69 CITY OF ST. JOSEPH 08/15/14 9:31 AM Page 1 Council Month End Expenditure - Summary Current Period: June 2014 2014 June 2014 Description YTD Budget 2014 Amt YTD Amt General $2,332,710.00 $199,163.86 $1,181,041.83 Employee Retirement Reserve $0.00 $0.00 $0.00 Fire Fund $296,980.00 $48,219.07 $85,976.10 Cable Access Fee $8,500.00 $0.00 $0.00 Economic Development $130,595.00 $19,807.09 $199,002.85 TIF 2 -1 Millstream $0.00 $45.00 $45.00 TIF 2 -2 Meat Market $0.00 $45.00 $45.00 State Collected Sales Tax $0.00 $17,389.20 $137,264.07 Park Dedication $50,400.00 $11,555.80 $18,536.99 Charitable Gambling $0.00 $0.00 $0.00 Revolving Loan Fund $0.00 $0.00 $0.00 2009A CrossoverRefunding Bon $354,900.00 $0.00 $19,850.00 2007 Refunding (98/99 St Bond $120,170.00 $0.00 $2,242.50 City Hall Refunded, 2005 $97,985.00 $0.00 $4,162.50 2011A Refunding Fire Hall $76,150.00 $0.00 $2,900.00 2010B Refundin (Hill /Clover) $139,550.00 $0.00 $9,673.75 2011A CO Refund (Interior Sts) $141,980.00 $0.00 $10,815.00 2007 St Impry -E Side /3ade /8 A $291,670.00 $0.00 $5,734.38 2009B GO CIP Bonds $64,800.00 $0.00 $5,070.00 2010 Equipment Certificates $31,850.00 $0.00 $825.00 2010B Street Impr (16th Ave) $66,855.00 $0.00 $8,327.50 2011A Pumper Truck Certificate $42,010.00 $0.00 $3,330.00 2011A GO CIP Bonds $23,670.00 $0.00 $1,660.00 2013 Street Improve Bonds $9,870.00 $0.00 $7,252.50 2013 Equipment Certificates $55,500.00 $0.00 $3,975.00 2014 Street Impr [ParkTerrace] $0.00 $56,981.00 $56,981.00 Debt Service Relief $0.00 $31.80 $1,531.80 2011A GO CIP Bonds $0.00 $0.00 $0.00 2013 Imp Cedar /Baker /Ridgew $0.00 $95.70 - $10,459.01 2013 Equipment Certificates $0.00 $518.75 $7,416.30 2014 Imp Park Terrace $0.00 $6,386.92 $84,479.96 Capital Outlay $84,080.00 $268.43 $15,110.53 Water Extension $0.00 $0.00 $0.00 Sewer Extension $0.00 $0.00 $0.00 Water Fund $1,442,770.00 $46,617.69 $361,857.80 Sewer Fund $1,529,055.00 $80,164.40 $485,828.49 Refuse Collection $336,185.00 $24,268.53 $142,506.68 Storm Water Utility $257,865.00 $3,926.51 $27,214.77 Street Light Utility $53,025.00 $3,738.96 $20,914.07 $8,039,125.00 $519,223.71 $2,901,112.36 CITY OF ST. JOSEPH 08/15/14 3:52 PM Page 1 Council Month End Expenditure - Summary Current Period: July 2014 2014 July 2014 Description YTD Budget 2014 Amt YTD Amt General $2,332,710.00 $203,686.04 $1,384,727.87 Employee Retirement Reserve $0.00 $0.00 $0.00 Fire Fund $296,980.00 $9,558.88 $95,534.98 Cable Access Fee $8,500.00 $0.00 $0.00 Economic Development $130,595.00 $13,325.72 $212,328.57 TIF 2 -1 Millstream $0.00 $19,989.03 $20,034.03 TIF 2 -2 Meat Market $0.00 $1,987.38 $2,032.38 State Collected Sales Tax $0.00 $562.48 $137,826.55 Park Dedication $50,400.00 $2,597.50 $21,134.49 Charitable Gambling $0.00 $902.12 $902.12 Revolving Loan Fund $0.00 $0.00 $0.00 2009A CrossoverRefunding Bon $354,900.00 $0.00 $19,850.00 2007 Refunding (98/99 St Bond $120,170.00 $0.00 $2,242.50 City Hall Refunded, 2005 $97,985.00 $0.00 $4,162.50 2011A Refunding Fire Hall $76,150.00 $0.00 $2,900.00 2010B Refundin (Hill /Clover) $139,550.00 $0.00 $9,673.75 2011A CO Refund (Interior Sts) $141,980.00 $0.00 $10,815.00 2007 St Impry -E Side /3ade /8 A $291,670.00 $0.00 $5,734.38 2009B GO CIP Bonds $64,800.00 $0.00 $5,070.00 2010 Equipment Certificates $31,850.00 $0.00 $825.00 2010B Street Impr (16th Ave) $66,855.00 $0.00 $8,327.50 2011A Pumper Truck Certificate $42,010.00 $0.00 $3,330.00 2011A GO CIP Bonds $23,670.00 $0.00 $1,660.00 2013 Street Improve Bonds $9,870.00 $0.00 $7,252.50 2013 Equipment Certificates $55,500.00 $0.00 $3,975.00 2014 Street Impr [ParkTerrace] $0.00 $0.00 $56,981.00 Debt Service Relief $0.00 $0.00 $1,531.80 2011A GO CIP Bonds $0.00 $0.00 $0.00 2013 Imp Cedar /Baker /Ridgew $0.00 $120.20 - $10,338.81 2013 Equipment Certificates $0.00 $0.00 $7,416.30 2014 Imp Park Terrace $0.00 $4,551.20 $89,031.16 Capital Outlay $84,080.00 $0.00 $15,110.53 Water Extension $0.00 $0.00 $0.00 Sewer Extension $0.00 $0.00 $0.00 Water Fund $1,442,770.00 $282,761.32 $644,619.12 Sewer Fund $1,529,055.00 $84,834.48 $570,662.97 Refuse Collection $336,185.00 $23,651.85 $166,158.53 Storm Water Utility $257,865.00 $2,401.99 $29,616.76 Street Light Utility $53,025.00 $3,323.50 $24,237.57 $8,039,125.00 $654,253.69 $3,555,366.05 CITY OF ST. JOSEPH 08/15/14 9:30 AM Council Month End Expenditure - General Fund Page 1 Current Period: June 2014 2014 June 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt FUND 101 General $0.00 $0.00 $0.00 $0.00 General Council $49,550.00 $2,597.12 $14,998.44 General Legislative Committees $6,020.00 $350.00 $782.49 General Ordinance & Proceedings $1,350.00 $599.76 $957.38 General Mayor $10,995.00 $1,083.57 $4,600.35 General Elections $3,000.00 $0.00 $1,356.24 General General Adminstration $221,425.00 $16,011.78 $97,133.83 General Finance $119,140.00 $10,078.48 $58,254.03 General Audit Service $25,950.00 $0.00 $25,950.00 General Assessing $23,500.00 $0.00 $0.00 General City Attorney $17,000.00 $4,286.85 $15,128.83 General Planning and Zoning $7,400.00 $5,167.58 $7,516.87 General General Government $19,080.00 $1,050.31 $10,918.40 General City Offices $28,945.00 $1,596.22 $14,092.83 General Facilites and Planning $0.00 $0.00 $0.00 General Cable Access $11,065.00 $1,018.10 $4,740.50 General Crime Control & Investigation $908,340.00 $96,806.59 $418,400.77 General Police Training $7,650.00 $0.00 $1,063.03 General Communication Service $11,185.00 $734.96 $4,658.73 General Automotive Services $51,100.00 $4,173.18 $22,823.83 General Building Inspec. Admistration $92,000.00 $7,500.00 $37,666.41 General Emergency Management $1,280.00 $106.12 $887.87 General Signal Lights CSAH 75 $0.00 $0.00 $0.00 General Animal Control $950.00 $20.00 $765.50 General Street Maintanence $239,205.00 $14,336.98 $88,996.03 General Ice & Snow Removal $97,570.00 $0.00 $86,577.32 General Engineering Fee $30,000.00 $1,800.28 $11,146.00 General Street Cleaning $15,660.00 $1,321.54 $5,760.74 General Skate Park and Ice Rink $3,345.00 $36.56 $1,762.30 General Ball Park $1,750.00 -$9.98 $0.00 General Maintenance Shop $18,085.00 $1,265.92 $11,003.75 General Park Areas $213,270.00 $27,231.94 $94,691.64 General Community Support $0.00 $0.00 $0.00 General Other Financing Uses $0.00 $0.00 $88,080.00 General Fire Protection $96,900.00 $0.00 $50,327.72 FUND 101 General $2,332,710.00 $199,163.86 $1,181,041.83 FUND 102 Employee Retirement Reserve Employee Retirement Resery General Adminstration FUND 102 Employee Retirement Reserve FUND 108 Cable Access Fee Cable Access Fee Cable Access FUND 108 Cable Access Fee $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,500.00 $0.00 $0.00 $8,500.00 $0.00 $0.00 $2,555,885.00 $225,626.30 $1,479,635.17 CITY OF ST. JOSEPH 08/15/14 9:30 AM Page 2 Council Month End Expenditure - General Fund Current Period: June 2014 2014 June 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt FUND 150 Economic Development Economic Development Economic Development Authority $130,595.00 $19,807.09 $199,002.85 Economic Development Other Financing Uses $0.00 $0.00 $0.00 FUND 150 Economic Development $130,595.00 $19,807.09 $199,002.85 FUND 450 2014 Imp Park Terrace 2014 Imp Park Terrace Street Maintanence $0.00 $6,386.92 $61,839.01 2014 Imp Park Terrace Other Financing Uses $0.00 $0.00 $22,640.95 FUND 450 2014 Imp Park Terrace $0.00 $6,386.92 $84,479.96 FUND 490 Capital Outlay Capital Outlay General Adminstration $4,750.00 $268.43 $268.43 Capital Outlay General Government $0.00 $0.00 $0.00 Capital Outlay City Offices $0.00 $0.00 $0.00 Capital Outlay Crime Control & Investigation $4,400.00 $0.00 $335.77 Capital Outlay Communication Service $6,275.00 $0.00 $2,467.50 Capital Outlay Automotive Services $17,150.00 $0.00 $12,038.83 Capital Outlay Emergency Management $2,000.00 $0.00 $0.00 Capital Outlay Street Maintanence $15,500.00 $0.00 $0.00 Capital Outlay Ice & Snow Removal $7,000.00 $0.00 $0.00 Capital Outlay Street Lighting $0.00 $0.00 $0.00 Capital Outlay Street Cleaning $0.00 $0.00 $0.00 Capital Outlay Skate Park and Ice Rink $0.00 $0.00 $0.00 Capital Outlay Maintenance Shop $6,690.00 $0.00 $0.00 Capital Outlay Park Areas $20,315.00 $0.00 $0.00 Capital Outlay Other Financing Uses $0.00 $0.00 $0.00 FUND 490 Capital Outlay $84,080.00 $268.43 $15,110.53 $2,555,885.00 $225,626.30 $1,479,635.17 CITY OF ST. JOSEPH 08/15/14 3:51 PM Council Month End Expenditure - General Fund Page 1 Current Period: July 2014 2014 July 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt FUND 101 General $0.00 $0.00 $0.00 $0.00 General Council $49,550.00 $6,779.51 $21,777.95 General Legislative Committees $6,020.00 $210.00 $992.49 General Ordinance & Proceedings $1,350.00 $411.75 $1,369.13 General Mayor $10,995.00 $905.71 $5,506.06 General Elections $3,000.00 $107.31 $1,463.55 General General Adminstration $221,425.00 $16,478.17 $113,612.00 General Finance $119,140.00 $8,063.95 $66,317.98 General Audit Service $25,950.00 $0.00 $25,950.00 General Assessing $23,500.00 $22,359.15 $22,359.15 General City Attorney $17,000.00 $578.79 $15,707.62 General Planning and Zoning $7,400.00 $279.08 $7,795.95 General General Government $19,080.00 $1,091.80 $12,010.20 General City Offices $28,945.00 $2,658.23 $16,751.06 General Facilites and Planning $0.00 $0.00 $0.00 General Cable Access $11,065.00 $830.60 $5,571.10 General Crime Control & Investigation $908,340.00 $60,684.19 $479,084.96 General Police Training $7,650.00 $392.70 $1,455.73 General Communication Service $11,185.00 $1,246.41 $5,905.14 General Automotive Services $51,100.00 $5,307.13 $28,130.96 General Building Inspec. Admistration $92,000.00 $8,095.97 $45,762.38 General Emergency Management $1,280.00 $7.22 $895.09 General Signal Lights CSAH 75 $0.00 $0.00 $0.00 General Animal Control $950.00 $11.69 $777.19 General Street Maintanence $239,205.00 $18,254.28 $107,250.31 General Ice & Snow Removal $97,570.00 $28.96 $86,606.28 General Engineering Fee $30,000.00 $4,111.82 $15,257.82 General Street Cleaning $15,660.00 $368.72 $6,129.46 General Skate Park and Ice Rink $3,345.00 $44.29 $1,806.59 General Ball Park $1,750.00 $0.00 $0.00 General Maintenance Shop $18,085.00 $1,130.72 $12,134.47 General Park Areas $213,270.00 $18,084.03 $112,775.67 General Community Support $0.00 $0.00 $0.00 General Other Financing Uses $0.00 $0.00 $88,080.00 General Fire Protection $96,900.00 $25,163.86 $75,491.58 FUND 101 General $2,332,710.00 $203,686.04 $1,384,727.87 FUND 102 Employee Retirement Reserve Employee Retirement Resery General Adminstration FUND 102 Employee Retirement Reserve FUND 108 Cable Access Fee Cable Access Fee Cable Access FUND 108 Cable Access Fee $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,500.00 $0.00 $0.00 $8,500.00 $0.00 $0.00 $2,555,885.00 $221,562.96 $1,701,198.13 CITY OF ST. JOSEPH 08/15/14 3:51 PM Page 2 Council Month End Expenditure - General Fund Current Period: July 2014 2014 July 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt FUND 150 Economic Development Economic Development Economic Development Authority $130,595.00 $13,325.72 $212,328.57 Economic Development Other Financing Uses $0.00 $0.00 $0.00 FUND 150 Economic Development $130,595.00 $13,325.72 $212,328.57 FUND 450 2014 Imp Park Terrace 2014 Imp Park Terrace Street Maintanence $0.00 $4,551.20 $66,390.21 2014 Imp Park Terrace Other Financing Uses $0.00 $0.00 $22,640.95 FUND 450 2014 Imp Park Terrace $0.00 $4,551.20 $89,031.16 FUND 490 Capital Outlay Capital Outlay General Adminstration $4,750.00 $0.00 $268.43 Capital Outlay General Government $0.00 $0.00 $0.00 Capital Outlay City Offices $0.00 $0.00 $0.00 Capital Outlay Crime Control & Investigation $4,400.00 $0.00 $335.77 Capital Outlay Communication Service $6,275.00 $0.00 $2,467.50 Capital Outlay Automotive Services $17,150.00 $0.00 $12,038.83 Capital Outlay Emergency Management $2,000.00 $0.00 $0.00 Capital Outlay Street Maintanence $15,500.00 $0.00 $0.00 Capital Outlay Ice & Snow Removal $7,000.00 $0.00 $0.00 Capital Outlay Street Lighting $0.00 $0.00 $0.00 Capital Outlay Street Cleaning $0.00 $0.00 $0.00 Capital Outlay Skate Park and Ice Rink $0.00 $0.00 $0.00 Capital Outlay Maintenance Shop $6,690.00 $0.00 $0.00 Capital Outlay Park Areas $20,315.00 $0.00 $0.00 Capital Outlay Other Financing Uses $0.00 $0.00 $0.00 FUND 490 Capital Outlay $84,080.00 $0.00 $15,110.53 $2,555,885.00 $221,562.96 $1,701,198.13 CITY OF ST. JOSEPH 08/15/14 9:34 AM Council Month End Expense - Enterprise Funds Page 1 Current Period: June 2014 2014 June 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt FUND 601 Water Fund Water Fund Bond Payment (P & I) $664,090.00 $18,796.00 $163,492.13 Water Fund Other Financing Uses $45,000.00 $0.00 $0.00 Water Fund Power and Pumping $21,790.00 $558.46 $4,138.60 Water Fund Purification -Plant 1 $35,100.00 $1,077.78 $9,762.37 Water Fund Purification -Plant 2 $82,465.00 $4,968.74 $35,187.79 Water Fund Distribution $10,000.00 $0.00 $169.17 Water Fund Wellhead Protection $2,000.00 $0.00 $408.81 Water Fund Storage -Tower 1 $5,120.00 $6,628.71 $33,729.37 Water Fund Storage -Tower 2 $0.00 $0.00 $0.00 Water Fund Water Maintenance $179,915.00 $12,261.86 $98,172.04 Water Fund Administration and General $37,290.00 $2,326.14 $16,797.52 Water Fund Depreciation Expense $360,000.00 $0.00 $0.00 FUND 601 Water Fund $1,442,770.00 $46,617.69 $361,857.80 FUND 602 Sewer Fund Sewer Fund Bond Payment (P & I) $230,620.00 $0.00 $29,849.38 Sewer Fund Other Financing Uses $45,000.00 $0.00 $0.00 Sewer Fund Sanitary Sewer Maintenanc $228,165.00 $13,934.21 $74,362.06 Sewer Fund Lift Station -Baker Street $85,780.00 $225.73 $1,340.58 Sewer Fund Lift Station -DBL Labs Area $2,915.00 $338.97 $2,951.70 Sewer Fund Lift Station - Northland $4,995.00 $114.55 $789.84 Sewer Fund Lift Station -CR 121 $5,295.00 $134.72 $1,060.90 Sewer Fund Lift Station -Main $673,270.00 $62,594.03 $356,376.73 Sewer Fund Administration and General $38,015.00 $2,822.19 $19,097.30 Sewer Fund Depreciation Expense $215,000.00 $0.00 $0.00 FUND 602 Sewer Fund $1,529,055.00 $80,164.40 $485,828.49 FUND 603 Refuse Collection Refuse Collectio Waste Collection $336,185.00 $24,268.53 $142,506.68 Refuse Collectio Other Financing Uses $0.00 $0.00 $0.00 Refuse Collectio Depreciation Expense $0.00 $0.00 $0.00 FUND 603 Refuse Collection $336,185.00 $24,268.53 $142,506.68 FUND 651 Storm Water Utility Storm Water Uti Other Financing Uses $18,250.00 $0.00 $0.00 Storm Water Uti Administration and General $12,785.00 $736.33 $6,470.92 Storm Water Uti Storm Water Maintenance $126,830.00 $3,190.18 $20,743.85 Storm Water Uti Depreciation Expense $100,000.00 $0.00 $0.00 FUND 651 Storm Water Utility $257,865.00 $3,926.51 $27,214.77 FUND 652 Street Light Utility Street Light Utili Street Lighting $53,025.00 $3,738.96 $20,914.07 FUND 652 Street Light Utility $53,025.00 $3,738.96 $20,914.07 CITY OF ST. JOSEPH 08/15/14 9:34 AM Page 2 Council Month End Expense - Enterprise Funds Current Period: June 2014 2014 June 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt $3,618,900.00 $158,716.09 $1,038,321.81 CITY OF ST. JOSEPH 08/15/14 3:53 PM Council Month End Expense - Enterprise Funds Page 1 Current Period: July 2014 2014 July 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt FUND 601 Water Fund Water Fund Bond Payment (P & I) $664,090.00 $4,350.00 $167,842.13 Water Fund Other Financing Uses $45,000.00 $0.00 $0.00 Water Fund Power and Pumping $21,790.00 - $1,776.69 $2,361.91 Water Fund Purification -Plant 1 $35,100.00 - $1,001.44 $8,760.93 Water Fund Purification -Plant 2 $82,465.00 $8,104.48 $43,292.27 Water Fund Distribution $10,000.00 $0.00 $169.17 Water Fund Wellhead Protection $2,000.00 $0.00 $408.81 Water Fund Storage -Tower 1 $5,120.00 $258,983.75 $292,713.12 Water Fund Storage -Tower 2 $0.00 $0.00 $0.00 Water Fund Water Maintenance $179,915.00 $11,389.73 $109,561.77 Water Fund Administration and General $37,290.00 $2,711.49 $19,509.01 Water Fund Depreciation Expense $360,000.00 $0.00 $0.00 FUND 601 Water Fund $1,442,770.00 $282,761.32 $644,619.12 FUND 602 Sewer Fund Sewer Fund Bond Payment (P & I) $230,620.00 $0.00 $29,849.38 Sewer Fund Other Financing Uses $45,000.00 $0.00 $0.00 Sewer Fund Sanitary Sewer Maintenanc $228,165.00 $27,388.41 $101,750.47 Sewer Fund Lift Station -Baker Street $85,780.00 $211.59 $1,552.17 Sewer Fund Lift Station -DBL Labs Area $2,915.00 $151.04 $3,102.74 Sewer Fund Lift Station - Northland $4,995.00 $119.63 $909.47 Sewer Fund Lift Station -CR 121 $5,295.00 $142.00 $1,202.90 Sewer Fund Lift Station -Main $673,270.00 $53,378.88 $409,755.61 Sewer Fund Administration and General $38,015.00 $3,442.93 $22,540.23 Sewer Fund Depreciation Expense $215,000.00 $0.00 $0.00 FUND 602 Sewer Fund $1,529,055.00 $84,834.48 $570,662.97 FUND 603 Refuse Collection Refuse Collectio Waste Collection $336,185.00 $23,651.85 $166,158.53 Refuse Collectio Other Financing Uses $0.00 $0.00 $0.00 Refuse Collectio Depreciation Expense $0.00 $0.00 $0.00 FUND 603 Refuse Collection $336,185.00 $23,651.85 $166,158.53 FUND 651 Storm Water Utility Storm Water Uti Other Financing Uses $18,250.00 $0.00 $0.00 Storm Water Uti Administration and General $12,785.00 $662.62 $7,133.54 Storm Water Uti Storm Water Maintenance $126,830.00 $1,739.37 $22,483.22 Storm Water Uti Depreciation Expense $100,000.00 $0.00 $0.00 FUND 651 Storm Water Utility $257,865.00 $2,401.99 $29,616.76 FUND 652 Street Light Utility Street Light Utili Street Lighting $53,025.00 $3,323.50 $24,237.57 FUND 652 Street Light Utility $53,025.00 $3,323.50 $24,237.57 CITY OF ST. JOSEPH 08/15/14 3:53 PM Page 2 Council Month End Expense - Enterprise Funds Current Period: July 2014 2014 July 2014 Description DEPART Descr YTD Budget 2014 Amt YTD Amt $3,618,900.00 $396,973.14 $1,435,294.95 This page intentionally left blank