HomeMy WebLinkAbout[04c] Financial Report
Council Agenda Item 4c
MEETING DATE: July 17, 2017
AGENDA ITEM: Financial Report – 2nd Quarter 2017 & June 2017 Financial Reports
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: Council adopted the 2017 budget on December 5, 2016.
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
30, 2017.
CASH POSITION:
- The market rate of return (ROR) is approximately 1.125% with an average maturity of 18
months. The federal markets improved significantly in the last half of year. St. Joseph’s rate of
return is slightly less than the treasury markets. The City tiers the maturity dates within the
boundaries of the Investment Policy. The tiered maturity dates has helped the City maintain a
higher rate of return than the current market.
- In March and June the Federal Open Market Committee \[FOMC\] increased the federal fund rates
to 1.0 to 1.25% citing improving economic activity. The economic outlook has excited investors.
The FOMC stated the outlook is positive and they predict three rate increases in 2017.
- Interest earnings for 2017 amounts to $20,492. The City’s policy is to hold investments until
maturity. GASB 30 requires the City to mark investments at the current market value as of the
close of each month. In doing so, earnings will show fluctuations.
- Overall, the cash and investments balance decreased $1,374,424 from the beginning of the year.
Bond proceeds for the government center are significantly spent down. Field Street bond
proceeds will be mainly spent in 2017. The CBD Alley project bonds are anticipated to be issued
in August. The first 70% of the first half tax settlementnwas received in June, the remaining
30% and first half LGA will be received in July. Working capital was sufficient to cover
expenditures until these settlements came in.
FUNDS REPORT:
- The General fund spent 44% of the 2017 expenditure budget and received 28% of the revenue
budget. Expenditures and revenues are mainly operational in nature. One area under budget is the
ice and snow removal. The winter time during the 2017 report year has been mild. Planning and
zoning shows over budget. The comp plan update was funded with excess building permit
revenues carried over from 2016. The budget will show over-spent as a result. City offices is
over budget due to unanticipated expenses for janitorial services. These services require 8-12
hours per week in the government center versus a couple hours a week the City contracted for in
the old city hall. There are also costs in staff time for moving and settling into the new facility
coded under city offices.
- The Enterprise Funds represent four months utility billing revenue collected while expenses
represent six months of activity. Water revenue is showing higher than expenses as expected.
Rates were increased to cover debt payment in May and Nov. The St. Cloud sewer debts are paid
monthly. There are also St. Cloud charges for the design costs of their NR2 Biosolids project.
Overall, 27% of expenses have been incurred (less depreciation); 28% of the revenue budget has
been received.
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 WAC and trunk fees for the
year have a balance of $89,000, including fees collected for six single family homes, O’Reilly’s auto parts
store, CSB athletic fields and a connection fee from a homeowner that was sewer only (final partial
payment). Water revenues represent 23%, expenses 14% of the budget at the end of June.
Sewer fund analysis (fund 602/502) – The enclosed spreadsheet shows an analysis of the sewer fund,
including the Sewer fund (602) and the Sewer Access fund (SAC-502). Sewer SAC/Trunk fees shows a
balance of $41,032. Sewer connections include six single family homes, O’Reilly’s, CSB athletic fields,
and CSB administrative/art buildings.. Sewer expenses are at 31% of the budget, while revenues are at
33% of the budget.
½ ¢ Sales Tax (fund 200): The sales tax fund has a balance of $1,536,920. The City anticipates
collecting $4,000,000 in sales tax revenue through 2018 ($3,372,754 original estimate); $3,484,510 was
collected to date. Collections have continually increased over the years, even during most of the
recession years. The anticipated remaining expenditures total $956,075 for the projects approved by
Council.
CIP REPORTS:
- There has been very little spending on capital equipment. The police department spent funds for
AED equipment for the squads using primarily donations, also purchased squad laptops and
printers. The Comp Plan update began in Jan.; $65,000 is available for the comp plan update
(contract and miscellaneous expenditures). The fire department received a donation to cover the
cost of personnel equipment replacements. One set of turnout gear was expensed. Some fire
department pagers were replaced.
- The Park Board is collecting dog park donations to begin that project. The Millstream park
shelter began construction in June.
- The government center construction is wrapping up, Field Street construction is on-going, and
the CBD Alley project will begin soon. The CR2 trail project will begin after the State completes
their review and bidding is done (anticipate fall construction).
BUDGET/FISCAL IMPACT: Information Only
ATTACHMENTS: Request for Council Action – Quarterly and December Financial Reports
2nd Quarter Reports:
Cash Position as of 6/30/17
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 Treasurer’s Reports:
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
Capital Improvement Summary Reports:
General Fund Capital Improvement Plan - Summary
General Fund Capital Improvement Plan - Fire
General Fund Capital Improvement Plan - EDA
Enterprise Capital Improvement Plan – Public Works
Capital Improvement Budget Summary – Park Board
REQUESTED COUNCIL ACTION: Accept the financial reports as presented.
avg
Total Sentry Bank
avg
Total CMCU
Total Deposits3,738,737$
avg
avg
Total MS
Total Investments3,680,532$
ağƩƉĻƷ
{ğǝźƓŭƭ
{ĻĭǒƩźƷźĻƭ
aƚƓĻǤ/5ƭ/5ƭ
ağƩƉĻƷ
/5ƭ
/ŷĻĭƉźƓŭaƚƓĻǤ.ğƓƉ.ƩƚƉĻƩĻķDƚǝĻƩƓƒĻƓƷ.ƩƚƉĻƩĻķ.ƩƚƉĻƩĻķ
ЍЎіЍЎі
Ͳ
ЎЎЌ
Ͳ
ЌЉЏ
Ͳ
ЌЌЉЏЎЎЌЌ
Љі
Ͳ
IƚƌķźƓŭƭ
ЏіЏі
БͲАЍА
ͲͲ
ЍЋЌͲЍЌБЍЋЌͲЍЌБ
Љі
Ͳ
LƓǝĻƭƷƒĻƓƷ
ЌͲЉАБ
ğƓķ
ЍіЍі
/ğƭŷ
ͲͲ
ЋВБͲЌЎЏЋВБͲЌЎЏ
ЍЎі
Ͳ
ЌͲЌАВͲЉВБ
BudgetActual
Budget
BudgetActual
ExpExpRevRevRev
$140,536
$323,020
Fund
751
,
$218,751$218
Revenues
&
$367,020
Expenditures
Actual
to
$767,553
Budget
FundFire
$2,749,455
Fire
009
,
&
241
,
General
$1241009$1
General
$2,794,765
$$
000
,
000
,
$500,000
$3,000,000$2,500,000$2000000$2$1,500,000$1,000,000
9ǣƦĻƓƭĻwĻǝĻƓǒĻ
υЍЎЍͲЎЍЍ
υЍАЍͲЉВЏ
υЎЉЉͲЉЉЉυͲ
υЍЎЉͲЉЉЉυͲ
υЍЉЉͲЉЉЉυͲ
υЌЎЉͲЉЉЉυͲ
υЋВЍͲВАЋ
Activity
υЌЉЉͲЉЉЉυͲ
υЋЌЌͲЎЍЉ
Funds
υЋЎЉͲЉЉЉυͲ
υЋЉЉͲЉЉЉυͲ
υЊЋВͲЌЋЍ
Enterprise
υЊЎЉͲЉЉЉυͲ
υЊЉЎͲЍЊЌ
υЊЉЉͲЉЉЉυͲ
ЏЋЍ
Ͳ
υЋБͲЌЉЏ
υЋБͲВЉЊ
υЋБͲАВЌ
υЊВЏЋЍυЊВ
υЎЉͲЉЉЉυͲ
υυ
er
t
a
Light
Sewer
WaterWtW
Refuse
Street
Storm
2017 Revenue Budget1,699,845.00 (includes fund 501)
2017 Expense Budget(1,699,345.00) (excludes depreciation, includes 501)
The balances represent the cash balance as of 6/30/17
2017 Revenue Budget1,494,805.00 (includes fund 501)
2017 Expense Budget(1,494,305.00) (excludes depreciation,includes fund 502)
The balances represent the cash balance as of 6/30/17.
As of June 30, 2017
$500,000 MSAS advanced
$40,000 Lion's donation
(2,000,000.00)$4M donations estimated
Totals
Less: Bonded Projects
Committed - to be funded
anticipated remaining 2017 sales tax revenues to collect315,000.00
Committed - to be funded
Anticipated 2017 June Balance including funding commitments
uncommitted annually (5 yr Average)
Projects that have been discussed for Sales
Tax Funding
Maximum Funding Available
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10100
GeneralG 101-10100$1,766,671.46$576,764.65$217,926.37$1,205,670.17
Employee Retirement ReserveG 102-10100$99,763.34$0.00$0.00$115,843.34
Fire FundG 105-10100$563,122.18$1,635.70$4,821.89$596,883.36
Cable Access FeeG 108-10100$25,893.55$656.88$0.00$29,538.41
Economic DevelopmentG 150-10100$123,620.69$29,580.09$3,260.33$126,708.83
TIF 3-1 CMCUG 152-10100$154.37$14,936.32$0.00$14,840.69
TIF 4-1 Fortitude Senior AptsG 153-10100$1.38$0.00$0.00$2,279.50
TIF 2-1 MillstreamG 157-10100$20,737.15$12,729.38$46.00$33,551.27
TIF 2-2 Meat MarketG 158-10100$316.33$2,933.47$74.61$3,127.19
TIF 2-3 Bayou Blues/Alley FlatG 159-10100$30.97$31.09$46.00-$683.94
State Collected Sales TaxG 200-10100$1,481,459.54$99,656.57$53,242.20$1,536,919.67
Park DedicationG 205-10100$120,162.18$8,625.32$94.00$120,488.71
Charitable GamblingG 215-10100$2,067.07$2.88$0.00$2,076.38
Lodging TaxG 220-10100$7,675.51$402.52$0.00$10,267.33
DEED CDAP GrantG 225-10100$0.00$10.24$0.00$11,090.90
Revolving Loan FundG 250-10100$25,212.38$1,030.84$0.00$36,509.20
2016 CIP Bonds \[govt center\]G 301-10100$56,584.50$82,618.87$0.00$93,763.68
2016 Street Impr \[Field St\]G 304-10100$1,376.01$1,661.77$0.00-$3,237.70
GO Improve Bonds \[CBD AlleysG 305-10100$0.00$6,188.69$0.00$6,188.69
2009A CrossoverRefunding BonG 318-10100$159,645.38$65,073.20$0.00$220,602.26
2011A Refunding Fire HallG 331-10100$22,252.66$6,442.18$0.00$37,978.43
2010B Refundin \[Hill/Clover\]G 333-10100$157,765.71$29,954.07$0.00$182,447.78
2011A CO Refund\[Interior St\]G 338-10100$116,941.10$33,969.82$0.00$146,411.60
2009B GO CIP BondsG 343-10100$5,746.75$23,295.05$0.00$26,780.63
2010B Street Impr \[16th Ave\]G 345-10100$195,202.21$7,964.40$0.00$197,721.29
2011A Pumper Truck CertificatG 346-10100$3,525.84$4,320.76$0.00$12,192.81
2011A GO CIP Bonds\[roof/gar\]G 347-10100$59.72$9,322.24$0.42$8,411.17
2013 Street Improve BondsG 348-10100$130,929.47$7,813.83$0.00$135,006.71
2013 Equipment CertificatesG 349-10100$7,430.98$20,427.69$0.00$26,997.62
2014 Street Impr \[ParkTerraceG 350-10100$182,088.00$38,149.73$0.00$196,034.21
2015 Street\[Clinton/Northland\]G 351-10100$31,684.84$49,992.55$0.00$77,304.58
2015 Equipment CertificatesG 352-10100$1,243.62$41,603.65$0.00$42,444.91
2015 Abatement Bonds\[KenneG 353-10100$12,168.01$0.00$3.57-$9,963.46
Debt Service ReliefG 390-10100$220,080.03$3,426.79$135.19$223,398.71
2016 Government CenterG 401-10100$663,617.86$3,020.15$26,959.08-$322,208.47
Community Center phase IG 402-10100$0.00$100.00$175.00$1,035.00
2016 Imp Field StG 404-10100$1,292,725.42$0.00$410,551.20$756,540.46
CBD Alley Improvements ph 1G 405-10100$0.00$0.00$1,325.45-$32,938.45
2014 Imp Park TerraceG 450-10100$174,269.28$0.00$0.00$174,269.28
2015 Street\[Clinton/Northland\]G 451-10100$208,291.12$0.00$98,032.80$109,395.48
2015 Equipment CertificatesG 452-10100$9,075.06$0.00$0.00$0.00
Capital OutlayG 490-10100$263,036.29$24,295.13$199.00$295,059.63
WAC FundG 501-10100$51,304.65$72,466.12$0.00$130,161.52
SAC FundG 502-10100$11,182.25$34,132.00$31.45$16,006.83
Water FundG 601-10100$60,868.49$91,043.23$36,875.25$244,889.46
Sewer FundG 602-10100$5,777.56$164,086.26$100,538.76$43,283.91
Refuse CollectionG 603-10100$247,661.61$31,216.99$30,641.51$255,326.13
Storm Water UtilityG 651-10100$241,498.11$10,855.07$2,759.58$262,924.63
Street Light UtilityG 652-10100$22,772.31$4,447.52$4,256.58$19,928.14
Last Dim 10100$8,793,692.94$1,616,883.71$991,996.24$7,419,268.48
MTDMTDCurrent
FUND DescrAccountBegin YrDebitCreditBalance
Last Dim 10200
GeneralG 101-10200$275.00$0.00$0.00$275.00
Last Dim 10200$275.00$0.00$0.00$275.00
$8,793,967.94$1,616,883.71$991,996.24$7,419,543.48
2017June2017
FUNDFUND DescrYTD Budget2017 AmtYTD Amt
101General$2,742,755.00$561,647.28$748,501.83
102Employee Retirement Reserve$0.00$0.00$16,080.00
105Fire Fund$323,020.00$1,622.47$140,536.15
108Cable Access Fee$6,700.00$656.88$2,971.26
150Economic Development$95,320.00$29,580.09$29,738.78
152TIF 3-1 CMCU$0.00$14,936.32$14,936.32
153TIF 4-1 Fortitude Senior Apts$0.00$0.00$0.00
157TIF 2-1 Millstream$275.00$12,729.38$12,755.53
158TIF 2-2 Meat Market$5.00$2,933.47$2,933.54
159TIF 2-3 Bayou Blues/Alley Flat$0.00$31.09$31.09
200State Collected Sales Tax$408,000.00$99,656.57$99,656.57
205Park Dedication$583,520.00$8,625.32$11,779.65
215Charitable Gambling$4,540.00$2.88$4.76
220Lodging Tax$0.00$402.52$2,213.29
225DEED CDAP Grant$0.00$10.24$11,090.90
250Revolving Loan Fund$10,500.00$1,030.84$2,647.57
3012016 CIP Bonds \[govt center\]$230,955.00$82,618.87$83,947.55
3042016 Street Impr \[Field St\]$63,585.00$1,661.77$3,832.23
305GO Improve Bonds \[CBD Alleys\]$0.00$6,188.69$6,188.69
3182009A CrossoverRefunding Bonds$199,480.00$65,073.20$65,133.33
3312011A Refunding Fire Hall$56,700.00$6,442.18$16,310.50
3332010B Refundin \[Hill/Clover\]$65,560.00$29,954.07$30,143.79
3382011A CO Refund\[Interior St\]$124,670.00$33,969.82$34,032.87
3432009B GO CIP Bonds$65,000.00$23,295.05$23,286.40
3452010B Street Impr \[16th Ave\]$42,285.00$7,964.40$8,183.42
3462011A Pumper Truck Certificate$45,365.00$4,320.76$10,768.29
3472011A GO CIP Bonds\[roof/gar\]$26,000.00$9,321.82$9,216.11
3482013 Street Improve Bonds$21,460.00$7,813.83$8,050.78
3492013 Equipment Certificates$57,075.00$20,427.69$20,423.57
3502014 Street Impr \[ParkTerrace\]$108,230.00$38,149.73$38,502.95
3512015 Street\[Clinton/Northland\]$61,305.00$49,992.55$50,217.29
3522015 Equipment Certificates$32,005.00$41,603.65$41,510.19
3532015 Abatement Bonds\[Kennedy\]$162,300.00-$3.57-$11.06
390Debt Service Relief$0.00$3,291.60$3,291.60
4012016 Government Center$0.00$0.00$14,016.84
402Community Center phase I$0.00$100.00$1,210.00
4042016 Imp Field St$0.00$0.00$0.00
405CBD Alley Improvements ph 1$0.00$0.00$0.00
4502014 Imp Park Terrace$0.00$0.00$0.00
4512015 Street\[Clinton/Northland\]$0.00$0.00$0.00
4522015 Equipment Certificates$0.00$0.00$0.00
2017June2017
FUNDFUND DescrYTD Budget2017 AmtYTD Amt
490Capital Outlay$87,080.00$24,295.13$37,695.13
501WAC Fund$291,490.00$72,466.12$89,062.54
502SAC Fund$96,590.00$34,100.55$40,963.62
601Water Fund$1,408,355.00$89,395.17$294,971.75
602Sewer Fund$1,398,215.00$163,803.60$454,543.63
603Refuse Collection$294,170.00$29,312.35$105,413.36
651Storm Water Utility$110,125.00$10,833.72$28,793.17
652Street Light Utility$64,240.00$4,437.14$19,623.71
$9,286,875.00$1,594,695.24$2,635,199.49
2017June2017
FUNDFUND DescrSOURCE DescrYTD Budget2017 AmtYTD Amt
FUND 101 General
101GeneralCurrent Ad Valorem Taxes$1,122,485.00$356,923.91$356,923.91
101GeneralSpecial Levy- City St. Joe$0.00$5.87$5.87
101GeneralState Sales Tax$0.00-$20.70$95.16
101GeneralGas Franchise$30,500.00$0.00$8,200.56
101GeneralElectric Franchise$55,800.00$1,878.99$18,105.34
101GeneralLicenses & Permits$0.00$0.00$4,500.00
101GeneralBeer$1,625.00$0.00$1,663.33
101GeneralLiquor$21,860.00$3,325.00$24,122.28
101GeneralOutdoor Liquor Permit$2,500.00$100.00$1,350.00
101GeneralGambling Permits$250.00$0.00$390.00
101GeneralAmusement/Hunt/Peddler/Golf$1,300.00$330.00$705.00
101GeneralExcavation Permit$500.00$0.00$150.00
101GeneralCigarette License$600.00$0.00$62.50
101GeneralCable Franchise Fee$33,300.00$1,270.88$10,851.42
101GeneralBuilding Permits$99,000.00$164,254.68$190,110.06
101GeneralAnimal License$3,400.00$2,040.00$2,440.00
101GeneralRental Housing Registration$26,000.00$11,420.00$12,373.28
101GeneralFederal Grants - Other$60,800.00$0.00$2,315.97
101GeneralState Grants and Aids$950.00$0.00$0.00
101GeneralLocal Government Aid$919,430.00$0.00$0.00
101GeneralPERA Rate Increase Aid$1,540.00$0.00$0.00
101GeneralPolice Training Reim$3,500.00$0.00$0.00
101GeneralState Municipal Funds Aid$50,000.00$0.00$24,980.50
101GeneralState Police Aid$60,000.00$0.00$0.00
101GeneralOther Grants/Aids$0.00$0.00$0.00
101GeneralOther Governmental Unit$10,000.00$0.00$5,000.00
101GeneralCounty Grants - Road Maint.$4,500.00$0.00$0.00
101GeneralZoning and Subdivision Fee$5,000.00$0.00$800.00
101GeneralLand Use Deposit Fee$4,000.00$0.00$1,000.00
101GeneralSale of Maps and Publications$50.00$2.50$3.50
101GeneralAssessments Search$2,750.00$490.00$2,770.00
101GeneralSpecial Hearing$5,000.00$1,700.00$4,800.00
101GeneralAdministration Reimb$12,635.00$14.96$30.32
101GeneralWeed Cutting$500.00$145.00$145.00
101GeneralAdmission Fee$0.00$0.00$0.00
101GeneralShelter/Room Rental Fees$8,200.00$560.00$4,349.30
101GeneralBall Field Donation$250.00$23.09$23.09
101GeneralSchneider Field Rental$1,500.00$0.00$75.00
101GeneralRents and Royalties$53,450.00$6,584.71$25,946.52
101GeneralKennel Fees$700.00$40.00$40.00
2017June2017
FUNDFUND DescrSOURCE DescrYTD Budget2017 AmtYTD Amt
101GeneralCounty Fines$28,000.00$5,622.28$18,904.88
101GeneralPolicy Fines$14,000.00$205.00$8,530.00
101GeneralAccident Report Fee$1,200.00$125.00$611.00
101GeneralSeized Property$1,000.00$0.00$157.25
101GeneralSpecial Assessments$3,000.00$1,747.08$1,899.46
101GeneralInterest Earnings$28,000.00$1,489.20$3,526.55
101GeneralInterest Charges$100.00$211.63$211.63
101GeneralCo-op Dividend - LMCIT$12,000.00$0.00$0.00
101GeneralWater Tower Antenna Lease$3,830.00$650.20$1,910.94
101GeneralAdvertising$1,700.00$0.00$200.00
101GeneralContributions - General$600.00$220.00$1,120.00
101GeneralContributions - Parks$1,200.00-$89.00$97.42
101GeneralSurplus Property$12,000.00$0.00$0.00
101GeneralReimbursement$32,250.00$377.00$7,004.79
101GeneralTransfers from Other Funds$0.00$0.00$0.00
FUND 101 General$2,742,755.00$561,647.28$748,501.83
FUND 102 Employee Retirement Reserve
102Employee Retirement ResTransfers from Other Funds$0.00$0.00$16,080.00
FUND 102 Employee Retirement Reserve$0.00$0.00$16,080.00
FUND 108 Cable Access Fee
108Cable Access FeeCable Franchise Fee$6,700.00$656.88$2,971.26
108Cable Access FeeTransfers from Other Funds$0.00$0.00$0.00
FUND 108 Cable Access Fee$6,700.00$656.88$2,971.26
FUND 150 Economic Development
150Economic DevelopmentCurrent Ad Valorem Taxes$93,920.00$29,432.16$29,432.16
150Economic DevelopmentFederal Grants - Other$0.00$0.00$0.00
150Economic DevelopmentTIF/MIF Deposit$0.00$0.00$0.00
150Economic DevelopmentInterest Earnings$1,400.00$147.93$306.62
150Economic DevelopmentTransfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$95,320.00$29,580.09$29,738.78
FUND 490 Capital Outlay
490Capital OutlayCurrent Ad Valorem Taxes$77,080.00$24,295.13$24,295.13
490Capital OutlayFederal Grants - Other$0.00$0.00$0.00
490Capital OutlayContributions - Parks$0.00$0.00$0.00
490Capital OutlaySurplus Property$10,000.00$0.00$13,400.00
490Capital OutlayReimbursement$0.00$0.00$0.00
490Capital OutlayTransfers from Other Funds$0.00$0.00$0.00
FUND 490 Capital Outlay$87,080.00$24,295.13$37,695.13
2017June2017
FUNDFUND DescrSOURCE DescrYTD Budget2017 AmtYTD Amt
$2,931,855.00$616,179.38$834,987.00
FUND2017June2017
FUNDDescrSOURCE DescrYTD Budget2017 AmtYTD Amt
FUND 601 Water Fund
601Water FundPenalties and Forfeited Disc$8,000.00$392.81$4,199.91
601Water FundCurrent Ad Valorem Taxes$23,500.00$8,489.63$8,097.07
601Water FundTransfers from Other Funds$290,990.00$0.00$0.00
601Water FundContributed Revenue$0.00$0.00$0.00
601Water FundMDS Test Fee$12,085.00$1,100.84$3,684.77
601Water FundWater Meter$5,000.00$3,930.00$6,440.00
601Water FundConnection/Reconnection fees$200.00$373.98$0.00
601Water FundUndesignated Funds$0.00$1,049.21$11,562.96
601Water FundBulk Water$2,500.00$430.75$786.25
601Water FundSpecial Assessments$400.00$0.00-$604.53
601Water FundReimbursement$0.00$0.00$0.00
601Water FundSurplus Property$0.00$0.00$0.00
601Water FundState Sales Tax$0.00-$53.27-$53.82
601Water FundWater Tower Antenna Lease$34,480.00$5,851.68$17,198.42
601Water FundAmortization of Bond Premium$0.00$0.00$0.00
601Water FundInterest Earnings$31,500.00$243.18$562.00
601Water FundRate Class One$705,100.00$41,652.08$151,906.51
601Water FundWater Line Charge$294,600.00$25,934.28$91,192.21
FUND 601 Water Fund$1,408,355.00$89,395.17$294,971.75
FUND 602 Sewer Fund
602Sewer FundSurplus Property$0.00$0.00$0.00
602Sewer FundContributions - General$0.00$74.25$169.60
602Sewer FundAmortization of Bond Premium$0.00$0.00$0.00
602Sewer FundInterest Earnings$500.00$2,355.08$4,597.73
602Sewer FundSpecial Assessments$300.00$0.00$0.00
602Sewer FundOther Grants/Aids$0.00$0.00$0.00
602Sewer FundContributed Revenue$0.00$0.00$0.00
602Sewer FundSanitary Sewer Service$799,645.00$94,099.92$267,345.87
602Sewer FundOther Governmental Unit$1,500.00$0.00$0.00
602Sewer FundPenalties and Forfeited Disc$7,075.00$480.09$4,013.57
602Sewer FundSewer Line Charge$493,105.00$52,930.17$164,552.77
602Sewer FundTransfers from Other Funds$96,090.00$0.00$0.00
602Sewer FundReimbursement$0.00$13,864.09$13,864.09
FUND 602 Sewer Fund$1,398,215.00$163,803.60$454,543.63
FUND 603 Refuse Collection
603Refuse CollectPenalties and Forfeifted Disc$5,700.00$280.35$2,710.30
603Refuse CollectReimbursement$2,515.00$0.00$1,467.90
603Refuse CollectContributions - General$0.00$0.00$0.00
603Refuse CollectSpecial Assessments$400.00$0.00$0.00
603Refuse CollectContributed Revenue$0.00$0.00$0.00
603Refuse CollectRefuse Collection Charges$263,205.00$25,826.63$85,704.06
603Refuse CollectLicenses & Permits$18,350.00$2,180.00$17,115.00
603Refuse CollectState Sales Tax$0.00$678.21-$2,252.11
603Refuse CollectInterest Earnings$4,000.00$347.16$668.21
FUND 603 Refuse Collection$294,170.00$29,312.35$105,413.36
FUND 651 Storm Water Utility
651Storm Water Development Fee$5,000.00$0.00$0.00
651Storm Water Transfers from Other Funds$0.00$0.00$0.00
FUND2017June2017
FUNDDescrSOURCE DescrYTD Budget2017 AmtYTD Amt
651Storm Water Penalties and Forfeifted Disc$2,090.00$120.84$804.20
651Storm Water Rate Class One$98,675.00$9,048.84$31,625.00
651Storm Water Contributed Revenue$0.00$0.00$0.00
651Storm Water Reimbursement$0.00$0.00$0.00
651Storm Water Special Assessments$360.00$1,316.49-$4,295.66
651Storm Water Interest Earnings$4,000.00$347.55$659.63
FUND 651 Storm Water Utility$110,125.00$10,833.72$28,793.17
FUND 652 Street Light Utility
652Street Light UTransfers from Other Funds$0.00$0.00$0.00
652Street Light USpecial Assessments$50.00$0.00$0.00
652Street Light UInterest Earnings$400.00$28.38$56.83
652Street Light UReimbursement$3,000.00$0.00$0.00
652Street Light URate Class One$60,190.00$4,360.18$18,984.77
652Street Light UPenalties and Forfeited Disc$600.00$48.58$582.11
FUND 652 Street Light Utility$64,240.00$4,437.14$19,623.71
$3,275,105.00$297,781.98$903,345.62
2017June2017
DescriptionYTD Budget2017 Amt YTD Amt
General$2,792,755.00$201,322.96$1,241,009.40
Employee Retirement Reserve$0.00$0.00$0.00
Fire Fund$367,020.00$4,808.66$56,187.09
Cable Access Fee$2,010.00$0.00$0.00
Economic Development$95,320.00$3,260.33$24,760.61
TIF 3-1 CMCU$795.00$0.00$250.00
TIF 4-1 Fortitude Senior Apts$0.00$0.00$0.00
TIF 2-1 Millstream$34,545.00$46.00$46.00
TIF 2-2 Meat Market$4,545.00$74.61$123.58
TIF 2-3 Bayou Blues/Alley Flat$795.00$46.00$46.00
State Collected Sales Tax$1,187,050.00$53,242.20$132,325.57
Park Dedication$653,350.00$94.00$11,591.95
Charitable Gambling$4,500.00$0.00$0.00
Lodging Tax$0.00$0.00$0.00
DEED CDAP Grant$0.00$0.00$0.00
Revolving Loan Fund$0.00$0.00$0.00
2016 CIP Bonds \[govt center\]$271,945.00$0.00$48,371.25
2016 Street Impr \[Field St\]$28,855.00$0.00$8,617.78
GO Improve Bonds \[CBD Alleys$0.00$0.00$0.00
2009A CrossoverRefunding Bon$360,350.00$0.00$5,075.00
2011A Refunding Fire Hall$76,700.00$0.00$750.00
2010B Refundin \[Hill/Clover\]$142,050.00$0.00$5,923.75
2011A CO Refund\[Interior St\]$144,830.00$0.00$7,115.00
2009B GO CIP Bonds$64,800.00$0.00$2,595.00
2010B Street Impr \[16th Ave\]$63,855.00$0.00$6,827.50
2011A Pumper Truck Certificate$44,560.00$0.00$2,180.00
2011A GO CIP Bonds\[roof/gar\]$22,320.00$0.00$1,060.00
2013 Street Improve Bonds$43,670.00$0.00$4,235.00
2013 Equipment Certificates$57,500.00$0.00$1,150.00
2014 Street Impr \[ParkTerrace\]$161,835.00$0.00$25,817.50
2015 Street\[Clinton/Northland\]$66,810.00$0.00$5,805.00
2015 Equipment Certificates$32,310.00$0.00$1,055.00
2015 Abatement Bonds\[Kenned$154,835.00$0.00$22,167.49
Debt Service Relief$141,000.00$0.00$0.00
2016 Government Center$0.00$23,938.93$804,462.95
Community Center phase I$0.00$175.00$175.00
2016 Imp Field St$0.00$410,551.20$476,948.43
CBD Alley Improvements ph 1$0.00$1,325.45$32,938.45
2014 Imp Park Terrace$0.00$0.00$0.00
2015 Street\[Clinton/Northland\]$0.00$98,032.80$20,551.70
2015 Equipment Certificates$0.00$0.00$9,075.06
2017June2017
DescriptionYTD Budget2017 Amt YTD Amt
Capital Outlay$87,080.00$199.00$6,994.00
WAC Fund$290,990.00$0.00$0.00
SAC Fund$96,090.00$0.00$0.00
Water Fund$1,808,355.00$35,227.19$233,539.73
Sewer Fund$1,848,215.00$100,256.10$474,096.11
Refuse Collection$298,675.00$28,736.87$129,324.26
Storm Water Utility$260,740.00$2,738.23$28,306.18
Street Light Utility$71,970.00$4,246.20$28,900.72
$11,783,025.00$968,321.73$3,860,398.06
2017June2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 101 General
GeneralCouncil$64,010.00$7,985.81$28,598.19
GeneralLegislative Committees$7,485.00$350.00$1,085.00
GeneralOrdinance & Proceedings$2,400.00-$7,296.40-$7,193.50
GeneralMayor$11,930.00$818.60$3,694.50
GeneralElections$750.00$0.00$1,291.19
GeneralGeneral Adminstration$249,295.00$17,795.25$117,202.67
GeneralFinance$130,230.00$8,870.07$53,898.82
GeneralAudit Service$28,000.00$0.00$27,450.00
GeneralAssessing$23,500.00$0.00$0.00
GeneralCity Attorney$18,000.00$1,741.25$2,766.25
GeneralPlanning and Zoning$71,925.00$5,168.12$73,770.15
GeneralGeneral Government$21,850.00$1,750.25$19,906.81
GeneralCity Offices$22,600.00$2,354.00$26,426.30
GeneralCable Access$10,950.00$645.90$3,272.86
GeneralCrime Control & Investigation$1,063,225.00$89,930.06$448,008.97
GeneralPolice Training$9,545.00$75.00$2,609.44
GeneralCommunication Service$12,390.00$1,025.47$5,560.13
GeneralAutomotive Services$54,050.00$4,600.87$15,695.18
GeneralBuilding Inspec. Admistration$94,000.00$7,500.00$37,500.00
GeneralEmergency Management$995.00$137.89$819.53
GeneralAnimal Control$815.00$0.00$275.50
GeneralStreet Maintanence$309,240.00$18,519.84$100,924.32
GeneralIce & Snow Removal$113,465.00$0.00$29,612.62
GeneralEngineering Fee$35,000.00$7,437.09$17,470.29
GeneralStreet Cleaning$13,800.00$733.70$7,479.70
GeneralSkate Park and Ice Rink$5,590.00$44.46$2,341.31
GeneralBall Park$1,750.00$202.03$298.60
GeneralMaintenance Shop$21,315.00$1,298.62$10,763.74
GeneralPark Areas$224,015.00$25,514.02$108,637.19
GeneralCommunity Center$68,115.00$4,121.06$25,913.44
GeneralOther Financing Uses$0.00$0.00$13,000.00
GeneralFire Protection$102,520.00$0.00$61,930.20
FUND 101 General$2,792,755.00$201,322.96$1,241,009.40
FUND 102 Employee Retirement Reserve
Employee Retirement ReservGeneral Adminstration$0.00$0.00$0.00
FUND 102 Employee Retirement Reserve$0.00$0.00$0.00
FUND 108 Cable Access Fee
Cable Access FeeCable Access$2,010.00$0.00$0.00
FUND 108 Cable Access Fee$2,010.00$0.00$0.00
2017June2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 150 Economic Development
Economic DevelopmentEconomic Development Authority$95,320.00$3,260.33$24,760.61
Economic DevelopmentOther Financing Uses$0.00$0.00$0.00
FUND 150 Economic Development$95,320.00$3,260.33$24,760.61
FUND 490 Capital Outlay
Capital OutlayGeneral Adminstration$9,350.00$199.00$199.00
Capital OutlayCrime Control & Investigation$3,450.00$0.00$0.00
Capital OutlayCommunication Service$7,350.00$0.00$0.00
Capital OutlayAutomotive Services$16,930.00$0.00$6,795.00
Capital OutlayEmergency Management$2,000.00$0.00$0.00
Capital OutlayStreet Maintanence$3,000.00$0.00$0.00
Capital OutlayIce & Snow Removal$7,800.00$0.00$0.00
Capital OutlayStreet Cleaning$6,000.00$0.00$0.00
Capital OutlayMaintenance Shop$7,000.00$0.00$0.00
Capital OutlayPark Areas$24,200.00$0.00$0.00
Capital OutlayCommunity Center$0.00$0.00$0.00
Capital OutlayOther Financing Uses$0.00$0.00$0.00
FUND 490 Capital Outlay$87,080.00$199.00$6,994.00
$2,977,165.00$204,782.29$1,272,764.01
2017June2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
FUND 601 Water Fund
Water FundBond Payment (P & I)$618,775.00$0.00$51,509.25
Water FundOther Financing Uses$36,770.00$0.00$770.00
Water FundPower and Pumping$18,690.00$1,186.10$2,301.58
Water FundPurification-Plant 1$348,985.00$1,729.12$12,463.94
Water FundPurification-Plant 2$86,210.00$8,419.45$32,121.19
Water FundDistribution$10,000.00$5,410.71$17,115.06
Water FundWellhead Protection$3,000.00$0.00$0.00
Water FundStorage-Tower 1$15,630.00$501.91$3,486.27
Water FundWater Maintenance$238,235.00$16,002.35$97,584.35
Water FundAdministration and General$32,060.00$1,977.55$16,188.09
Water FundDepreciation Expense$400,000.00$0.00$0.00
FUND 601 Water Fund$1,808,355.00$35,227.19$233,539.73
FUND 602 Sewer Fund
Sewer FundBond Payment (P & I)$234,320.00$0.00$22,058.75
Sewer FundOther Financing Uses$37,540.00$0.00$1,540.00
Sewer FundSanitary Sewer Maintenanc$216,790.00$26,279.90$89,808.55
Sewer FundLift Station-Baker Street$92,390.00$2,234.66$3,335.34
Sewer FundLift Station-Ridgewood/DBL$2,810.00$237.56$938.99
Sewer FundLift Station-Northland$4,425.00$120.65$797.74
Sewer FundLift Station-CR 121$4,650.00$147.07$967.28
Sewer FundLift Station-Main$769,100.00$69,320.22$338,278.24
Sewer FundAdministration and General$36,190.00$1,916.04$16,371.22
Sewer FundDepreciation Expense$450,000.00$0.00$0.00
FUND 602 Sewer Fund$1,848,215.00$100,256.10$474,096.11
FUND 603 Refuse Collection
Refuse CollectioWaste Collection$291,230.00$28,736.87$128,554.26
Refuse CollectioOther Financing Uses$770.00$0.00$770.00
Refuse CollectioDepreciation Expense$6,675.00$0.00$0.00
FUND 603 Refuse Collection$298,675.00$28,736.87$129,324.26
FUND 651 Storm Water Utility
Storm Water UtiOther Financing Uses$19,250.00$0.00$0.00
Storm Water UtiAdministration and General$16,580.00$906.38$9,257.10
Storm Water UtiStorm Water Maintenance$109,910.00$1,831.85$19,049.08
Storm Water UtiDepreciation Expense$115,000.00$0.00$0.00
FUND 651 Storm Water Utility$260,740.00$2,738.23$28,306.18
FUND 652 Street Light Utility
Street Light UtiliStreet Lighting$71,970.00$4,246.20$28,900.72
FUND 652 Street Light Utility$71,970.00$4,246.20$28,900.72
2017June2017
DescriptionDEPART DescrYTD Budget2017 Amt YTD Amt
$4,287,955.00$171,204.59$894,167.00
0.95
6,174.689,639.439,912.613,060.002,125.003,440.003,310.001,898.58
14,988.0423,201.1615,252.8412,185.0128,190.5599,992.2826,743.2818,564.9024,958.6889,819.8511,250.0025,177.6861,816.6223,970.0080,602.87
133,629.69348,381.86143,290.28145,188.86
683,382.85
750.00750.00750.00250.00500.00
5,000.001,100.007,500.003,450.007,350.004,200.001,500.002,000.002,000.006,000.007,800.007,000.003,600.002,000.00
15,100.0011,230.0029,730.0036,000.0018,600.0084,000.0048,600.0049,100.00
177,930.00
6/30
260.30260.30445.00445.00
1,291.192,987.306,795.009,782.30
41,798.8443,090.03
53,577.63
6/30through
201720172017Balance
Summary
2,971.262,971.261,120.00
(5,000.00)(5,000.00)
13,400.0014,520.00
12,491.26
2016
Plan
5,
2017
964.90
30,
4,685.015,424.688,056.735,295.957,912.611,060.001,375.003,190.005,250.001,310.001,398.58
Expenditures
15,529.2360,000.0014,152.8425,219.2919,393.2813,728.6855,352.1597,889.9917,377.6854,816.6220,370.0062,002.8799,245.28
Availablethrough 125,011.05264,642.16100,643.86
December
545,649.22
Improvement
June
of
Capital
As
adopted
Capital
2017
Final
Fund
General
CodeEquipmentBalanceGrant
ProjectBudgetReserveTransferred/SpentBudgetRemaining
DepartmentAccount
SoftwareProjects
EDAEDA
3,332.79 3,332.79 1,203.959,250.005,376.621,927.57 1,927.57
10,137.53 10,137.53 25,562.40 25,562.40 50,259.5875,823.7767,250.0071,000.0017,501.0012,592.1770,908.25 76,284.87 22,266.9220,491.9210,450.00 53,208.84
304,880.47475,334.47
788.53 788.53
1,978.95 1,978.95 2,119.95 2,119.954,887.43
k
2,500.00 2,500.002,500.00
750.00200.00 200.00 500.00
1,300.00 1,300.00 5,000.00 5,000.00 4,000.00 4,000.00 8,500.002,500.002,250.001,900.003,000.001,500.001,000.00 3,000.00
BudgetAdjustmentsSpentReserve
10,000.0010,000.0012,000.00 47,900.00 16,700.00 19,700.0081,100.00
er with new tan
g
last lon
2,032.79 7,116.48 7,116.48 7,000.00 1,727.57
y
21,562.40 21,562.4057,373.40 19,991.92 50,208.84
AvailableGrants/6/30Available256,600.42396,621.90
12/31/20166/30
#257,250.00
#359,000.00
#415,001.00
2028 - ma
Van41,759.58
Radios54,208.25
Truck65,823.77
Repairs20,766.92
Rig
Truck
Wheeler453.95
MHz
Computers2,032.79
Rescue
3
Replacement10,312.12Replacement3,165.15Replacement1,727.57
Building
PurchasedReserve
Building
Building2008Painting9,450.00
than
than
other
other
2017
ReserveReserve2011
Hardware/Software
Equipment20126EquipmentEquipment2012PumperEquipment2001LadderEquipment1997GrassEquipment1999TankerEquipment2013EquipmentEquipmentEquipment2012Equipment2001Equipment1999
Hardware/Software
EquipmentEquipment2007800EquipmentEquipment
Reserve
PayableImprovements
Equipment
Computer
for
Equipment
Equipment
Department
Building
Plan
OtherEquipmentEquipment
&
Fire
Services
BuildingEquipment
BuildingEquipmentBuildingImprovements
CǒƓķ
&&&
AdministrationFightingFightingFightingCommunicationsStation
ServicesOther
CźƩĻ
Joseph
FireFireFireFireFireMedicalFire
Improvement
AdministrationComputerFightingOtherFightingFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighterComm
unicationOtherCommunicationOtherStationStationStationFightingFirefighterFightingFirefighterFightingFirefighterFightingFirefighter
St.
TotalTotalTotalTotalTotalTotalTotal Fire
Capital
580Fire584Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire585Fire580Fire580Fire580Medical530Fire530Fire530Fire585Fire585Fire585Fire
LƒƦƩƚǝĻƒĻƓƷ
581/582Fire
CodeDepartmentObjectYearDescriptionFunds201720172017Funds
42220422204222042220422204222042220422204222042220422504225042270422804228042280422204222042220
/ğƦźƷğƌ
42210
Account
105105105105105105105105105105105105105105105105105105105
105
ƚƷğƌ
A
1,898.586,710.80
ED
53,339.5059,722.3110,000.0012,627.67
144,298.86
142,400.28
Plan
s
2016
2016
20,
6/30
4,
445.00
445.00445.00
July
Expenditure
Improvement
December
Capital
6/30through
Capital
Recommended:
(5,000.00)
(5,000.00)(5,000.00)
2017
Adopted
Fund
EDA
General
500.00
5,000.00
49,100.00
10,000.0023,600.0010,000.0048,600.00
1,398.586,710.80
43,339.5036,567.3112,627.6799,245.28
100,643.86
Availablethrough
12/31/2016
2017 - moved $5,000 budget to Great St. Cloud Partnership dues
CodeNumberEquipmentBalance201720172017Balance
ProjectProjectReserveBudgetGrants/AidsSpent2017
DepartmentAccount
0000000000400
000000
4
60.0060.0060.0060.00
4,750.05,250.07,560.09,200.09,200.05,692.62
7,000.0
5,752.62
11,250.022,500.017,500.034,000.035,802.4214,000.011,800.013,550.070,955.542,000.077,902.217,000.030,000.0
61,310.0017,000.0030,000.00
105,000.0
233,622.42204,467.7
Works
)
Public
6
s
201
6/302017
Plan
4,
of
(6,124.50
(6,124.50)
as
Expenditure
/
December
Capital
Improvement
2017
Adopted
0000000000000000
Capital
60.0060.0060.0060.00
500.00500.00500.00
2,000.01,250.05,000.05,000.02,000.07,000.02,300.02,300.02,200.02,000.01,000.01,000.06,000.0
1,060.006,000.00
15,000.020,000.012,000.0
13,810.0051,360.0015,560.00
Enterprise
0000000000000000400
4
2,750.05,560.06,500.06,900.06,900.09,600.04,692.62
4,692.62
10,750.019,000.028,802.4285,000.014,000.013,050.075,080.030,000.076,902.211,000.030,000.0
47,500.0011,000.0030,000.00
182,262.42195,032.2
12/31/2016Grants
)
S
LS
L
S
Terrace
L
g
S
r
L
s
S
St
e
L
(Park
Foamin
)
RidgewoodBakerNorthlandCR121
Main
(1/4
System
Programme Funding
Replacement4,000.0
Improvement
r
r
g
pumpspumpspumpspumps
g
BathroomsBathrooms
RoofLoader
))
Meter
Easements/Acquir
Project
UBUBUBUB
Repairs17,500.0Repairs12,500.0
Quality
LininTelevising/RootSample
SweepeLightin
ReplacementMapping
(1/4(1/4
End
12
#4/5
TruckPrinterHandheldKlinefelterWellWTPWTPTruckPrinterSewerSewerKlinefelterSewerPumpSubmersibleSubmersibleSubmersibleSubmersiblePrinterAerialWaterStreetPropertyPrinterFrontStreetCommunications
Residual
8
1401140140214031403140314031403
15031503
14031629140316291629140716291425
14011402140314031407
140414051406
1410
SSSSSSSL
PWPWWTWTWTWTPWPWPWPWPWPWWT
ENGWWWWENGWWWWWWWWWWWW
550582580530220580580550581530300530580580530530530530582530530580510581580530580
CodeNumberEquipmentBalance201720172017Balance
494404949049490494404941049420494214945049490494504945049450494804948049471494704947249473494904990049900499004990043230432304316043120
601601601601601601601602602602602602602602602602602602651651651651651603603652450
g
ProjectProjectReserveBudgetTransfersSpentAvailable
Lightin
DepartmentAccount
WaterSewerStormwaterRefuseSt.Streets
Millstream Shelter
Footgolf
Prairie Restoration
thru 7/5/17
This page intentionally left blank
1