HomeMy WebLinkAbout[04e] Treasurer Report crrryr OV 87..1cSt:rH Council Agenda Item 4(e)
MEETING DATE: September 17, 2018
AGENDA ITEM: Treasurer's Report—August 2018
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION:
Cash/investment reconciled through August 31, 2018. Budget to actual reports attached for Council
review.
The cash and investment balance increased$849,065 since the beginning of the year. The equipment
certificates(fund 406)proceeds were received in February. The capital outlay will spend down through
the year. The first half state aids and taxes were received with the balance due in December. Building
and development fees continue to exceed budget in 2018. The first half bond interest payments were
expended.
The General fund spent 66%of the expenditure budget and received 57%of the revenue budget at the end
of August. As stated above,building permit revenue is exceeding the budget for 2018. As of the end of
August,the revenue exceeded budget by$102,890. By the end of August, 17 new single family home
permits were issued. Other permit revenue came from CSB projects, Country Manor 2nd year
development agreement payments, and 24 College North. Other general revenues are fairly consistent
with budgeted amounts. Interest earnings are showing a deficit of$3,039. This is due to investments
shown at market rate that fluctuates throughout the life of the investments. Some months will be positive,
others negative. General expenditures are within budgeted amounts.
The Enterprise funds spent 48%(without depreciation)and received 47%of the revenue budget. The
utility bills represent six month's usage. Expenses represent eight months. The water plant one
reconditioning project has been ongoing. The plant shows over-budget for the capital expenses. The
bonds were issued in 2017. The project should be wrapped up soon. The CR121 lift station shows an
overage. This is due to the down payment for the Baker Street lift station currently being installed. Other
expenses are operational in nature.
BUDGET/FISCAL IMPACT: None—Information Only
ATTACHMENTS: Request for Council Action—Treasurer's Report
2018 Treasurer's Reports:
Cash Balances
Month End Revenue Summary
Month End Revenue Summary—General Fund
Month End Revenue Summary—Enterprise Funds
Month End Expenditure summary
Month End Expenditure Summary—General Fund
Month End Expense Summary—Enterprise Funds
REQUESTED COUNCIL ACTION: Accept the Treasurer's Report as presented.
City of St. Joseph 09/07/18 9:27 Al
Page
Council Month End Expenditure - General Fund
Current Period:August 2018
2018 August 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 101 General
General Council $64,605.00 $8,938.17 $41,155.03
General Legislative Committees $5,945.00 $8.21 $1,093.21
General Ordinance&Proceedings $2,600.00 $212.77 $1,261.75
General Mayor $11,845.00 $794.85 $6,489.31
General Elections $2,500.00 $1,431.05 $1,450.88
General General Adminstration $269,605.00 $26,455.24 $184,904.35
General Finance $139,945.00 $13,566.79 $88,653.45
General Audit Service $30,000.00 $0.00 $27,750.00
General Assessing $24,000.00 $0.00 $24,579.83
General City Attorney $18,000.00 $6,048.50 $13,208.71
General Planning and Zoning $76,065.00 $11,580.37 $66,010.37
General General Government $38,960.00 $4,457.39 $26,558.50
General City Offices $38,510.00 $2,858.52 $36,269.40
General Cable Access $6,390.00 $607.58 $2,829.99
General Crime Control&Investigation $1,127,945.00 $108,233.65 $695,276.39
General Police Training $9,545.00 $260.00 $5,874.33
General Communication Service $12,780.00 $941.14 $7,530.56
General Automotive Services $57,360.00 $4,567.10 $28,359.55
General Building Inspec.Admistration $95,200.00 $7,810.00 $56,399.45
General Emergency Management $975.00 $232.98 $1,679.25
General Animal Control $815.00 $0.00 $403.99
General Street Maintanence $302,290.00 $36,491.96 $190,777.00
General Ice&Snow Removal $115,235.00 $0.00 $60,128.45
General Engineering Fee $35,000.00 $7,436.22 $36,059.27
General Street Cleaning $14,095.00 $322.64 $6,893.25
General Skate Park and Ice Rink $5,410.00 $225.65 $3,615.14
General Ball Park $1,750.00 $17.57 $3,663.35 .
General Maintenance Shop $26,475.00 $1,273.45 $18,664.92
General Park Areas $230,050.00 $32,128.29 $174,724.69
General Community Center $63,115.00 $16,914.26 $39,404.26
General Other Financing Uses $0.00 $0.00 $5,000.00
General Fire Protection $134,405.00 $0.00 $99,729.24
FUND 101 General $2,961,415.00 $293,814.35 $1,956,397.87
FUND 102 Employee Retirement Reserve
Employee Retirement Resery General 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 Fee Cable Access $7,935.00 $0.00 $0.00
Cable Access Fee Other Financing Uses $0.00 $0.00 $36,000.00
City of St. Joseph 09/07/18 9:27 Ar
Page
Council Month End Expenditure - General Fund
Current Period:August 2018
2018 August 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 108 Cable Access Fee $7,935.00 $0.00 $36,000.00
FUND 150 Economic Development
Economic Development Economic Development Authority $119,025.00 $8,657.52 $58,000.49
Economic Development Other Financing Uses $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $8,657.52 $58,000.49
FUND 490 Capital Outlay
Capital Outlay General Adminstration $11,300.00 $0.00 $6,464.56
Capital Outlay Crime Control&Investigation $3,380.00 $0.00 $0.00
Capital Outlay Communication Service $4,875.00 $0.00 $0.00
Capital Outlay Automotive Services $13,595.00 $0.00 $2,459.25
Capital Outlay Emergency Management $1,500.00 $0.00 $0.00
Capital Outlay Street Maintanence $3,750.00 $0.00 $3,810.00
Capital Outlay Ice&Snow Removal $7,500.00 $992.86 $992.86
Capital Outlay Street Cleaning $2,750.00 $0.00 $0.00
Capital Outlay Maintenance Shop $5,000.00 $0.00 $0.00
Capital Outlay Park Areas $23,670.00 $992.85 $5,052.85
Capital Outlay Community Center $0.00 $0.00 $0.00
Capital Outlay Other Financing Uses $0.00 $0.00 $0.00
FUND 490 Capital Outlay $77,320.00 $1,985.71 $18,779.52
$3,165,695.00 $304,457.58 $2,069,177.88
City of St. Joseph 09/07/18 9:30 Al
Page
Council Month End Expense - Enterprise Funds
Current Period:August 2018
2018 August 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
FUND 601 Water Fund
Water Fund Bond Payment(P&I) $706,535.00 $5,800.00 $56,838.06 •
Water Fund Other Financing Uses $41,500.00 $0.00 $500.00
Water Fund Power and Pumping $28,925.00 $749.82 $2,000.89
Water Fund Purification-Plant 1 $31,170.00 $3,734.00 $270,944.81
Water Fund Purification-Plant 2 $85,300.00 $7,775.26 $55,193.25
Water Fund Distribution $10,000.00 $7,754.99 $17,030.57
Water Fund Wellhead Protection $3,000.00 $0.00 $0.00
Water Fund Storage-Tower 1 $15,890.00 $521.21 $3,995.59
Water Fund Water Maintenance $262,325.00 $21,430.39 $150,659.34
Water Fund Administration and General $27,905.00 $4,362.40 $29,822.34
Water Fund Depreciation Expense $400,000.00 $0.00 $0.00
FUND 601 Water Fund $1,612,550.00 $52,128.07 $586,984.85
FUND 602 Sewer Fund
Sewer Fund Bond Payment(P&I) $230,360.00 $0.00 -$17,593.00
Sewer Fund Other Financing Uses $7,500.00 $0.00 $500.00
Sewer Fund Sanitary Sewer Maintenanc $209,845.00 $17,474.95 $104,420.18
Sewer Fund Lift Station-Baker Street $5,865.00 $213.53 $2,586.10
Sewer Fund Lift Station-Ridgewood/DBL $2,695.00 $117.00 $1,051.90
Sewer Fund Lift Station-Northland $4,665.00 $82.83 $648.67
Sewer Fund Lift Station-CR 121 $5,340.00 $113.10 $38,729.76
Sewer Fund Lift Station-Main $813,930.00 $1,663.13 $396,898.54
Sewer Fund Administration and General $32,060.00 $1,879.73 $34,087.75
Sewer Fund Depreciation Expense $500,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,812,260.00 $21,544.27 $561,329.90
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $286,010.00 $24,177.63 $192,483.75
Refuse Collectio Other Financing Uses $500.00 $0.00 $500.00
Refuse Collectio Depreciation Expense $6,675.00 $0.00 $0.00
FUND 603 Refuse Collection $293,185.00 $24,177.63 $192,983.75
FUND 651 Storm Water Utility
Storm Water Uti Other Financing Uses $19,250.00 $0.00 $0.00
Storm Water Uti Administration and General $14,165.00 $1,047.80 $13,712.06
Storm Water Uti Storm Water Maintenance $107,930.00 $6,119.44 $63,423.44
Storm Water Uti Depreciation Expense $115,000.00 $0.00 $0.00
FUND 651 Storm Water Utility $256,345.00 $7,167.24 $77,135.50
FUND 652 Street Light Utility
Street Light Utili Street Lighting $80,975.00 $4,645.05 $47,562.72 •
FUND 652 Street Light Utility $80,975.00 $4,645.05 $47,562.72
City of St. Joseph 09/07/18 9:30 Ar
Page
Council Month End Expense - Enterprise Funds
Current Period:August 2018
2018 August 2018
Description DEPART Descr YTD Budget 2018 Amt YTD Amt
$4,055,315.00' $109,662.26 $1,465,996.72
City of St. Joseph 09/07/18 9:31 Al
Page
Council Month End Revenue -General Fund
Current Period:August 2018
2018 August 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 101 General
101 General Current Ad Valorem Taxes $1,282,660.00 $0.00 $608,969.60
101 General Special Levy-City St.Joe $0.00 $0.00 $0.00
101 General State Sales Tax $0.00 $104.18 $168.25
101 General Gravel Tax $0.00 $0.00 $0.00
101 General Solar Production Tax $0.00 $0.00 $0.00
101 General Gas Franchise $31,210.00 $7,342.84 $15,599.71
101 General Electric Franchise $58,335.00 $11,228.98 $31,642.12
101 General Licenses&Permits $10,000.00 $0.00 $10,200.00
101 General Beer $1,950.00 $0.00 $3,205.44
101 General Liquor $29,135.00 $0.00 $24,416.25
101 General Outdoor Liquor Permit $1,775.00 $750.00 $2,830.00
101 General Gambling Permits $375.00 $115.00 $315.00
101 General Amusement/Hunt/Peddler/Golf $1,400.00 $25.00 $315.00
101 General Excavation Permit $500.00 $0.00 $400.00
101 General Cigarette License $675.00 $0.00 $62.50
101 General Cable Franchise Fee $34,000.00 $1,236.60 $17,842.12
101 General Building Permits $115,000.00 $47,651.00 $217,890.29
101 General Animal License $3,400.00 $30.00 $2,925.00
101 General Rental Housing Registration $30,305.00 $8,455.00 $30,551.12
101 General Federal Grants-Other $12,000.00 $1,477.58 $1,873.65
101 General State Grants and Aids $1,100.00 $0.00 $0.00
101 General Local Government Aid $989,464.00 $0.00 $494,732.00 •
101 General PERA Rate Increase Aid $1,541.00 $0.00 $770.50
101 General Police Training Reim $3,500.00 $9,570.04 $9,570.04
101 General State Municipal Funds Aid $50,000.00 $0.00 $56,098.00
101 General State Police Aid $62,000.00 $576.50 $576.50
101 General Other Grants/Aids $0.00 $0.00 $0.00
101 General Other Governmental Unit $10,000.00 $0.00 $10,000.00
101 General County Grants-Road Maint. $6,500.00 $0.00 $0.00
101 General Zoning and Subdivision Fee $5,000.00 $0.00 $6,310.00
101 General Land Use Deposit Fee $4,000.00 $0.00 $4,100.00
101 General Sale of Maps and Publications $50.00 $0.00 $14.75
101 General Assessments Search $4,000.00 $660.00 $4,650.00
101 General Special Hearing $5,500.00 $0.00 $1,000.00
101 General Administration Reimb $12,745.00 $45.00 $59.40
101 General Weed Cutting $500.00 $0.00 $0.00
101 General Admission Fee $1,000.00 $0.00 $0.00
101 General Shelter/Room Rental Fees $7,500.00 $590.00 $8,445.00
101 General Ball Field Donation $100.00 $0.00 $0.00
101 General Schneider Field Rental $1,500.00 $0.00 $1,325.00
City of St. Joseph 09/07/18 9:31 Al
Page
Council Month End Revenue -General Fund
Current Period:August 2018
2018 August 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
101 General Rents and Royalties $53,450.00 $5,089.40 $40,715.20
101 General Kennel Fees $500.00 $0.00 $117.00
101 General County Fines $40,000.00 $2,397.32 $20,201.52
101 General Policy Fines $15,000.00 $1,396.95 $14,860.15
101 General Accident Report Fee $1,200.00 $40.00 $1,158.00
101 General Seized Property $500.00 $151.40 $2,268.05
101 General Special Assessments $3,000.00 $0.00 $3,963.95
101 General Interest Earnings $20,000.00 $2,397.50 -$3,039.40
101 General Interest Charges $200.00 $0.00 $14.27
101 General Co-op Dividend-LMCIT $14,000.00 $0.00 $0.00
101 General Water Tower Antenna Lease $3,930.00 $342.60 $7,475.64
101 General Advertising $1,200.00 $0.00 $600.00
101 General Contributions-General $500.00 $0.00 $5,396.00
101 General Contributions-Parks $500.00 $169.58 $259.74
101 General Surplus Property $0.00 $0.00 $0.00
101 General Reimbursement $28,715.00 $5,680.19 $24,891.36
101 General Insurance Recovery $0.00 $0.00 $4,418.53
101 General Transfers from Other Funds $0.00 $0.00 $0.00
FUND 101 General $2,961,415.00 $107,522.66 $1,690,157.25
FUND 102 Employee Retirement Reserve
102 Employee Retirement Res Transfers from Other Funds $6,500.00 $0.00 $6,500.00
FUND 102 Employee Retirement Reserve $6,500.00 $0.00 $6,500.00
FUND 108 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $7,935.00 $606.48 $4,364.08 '
108 Cable Access Fee Transfers from Other Funds $0.00 $0.00 $0.00
FUND 108 Cable Access Fee $7,935.00 $606.48 $4,364.08
FUND 150 Economic Development
150 Economic Development Current Ad Valorem Taxes $114,325.00 $0.00 $53,866.15
150 Economic Development Federal Grants-Other $0.00 $0.00 $0.00
150 Economic Development TIF/MIF Deposit $3,600.00 $0.00 $1,500.00
150 Economic Development Interest Earnings $1,100.00 $19.51 -$262.48
150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $119,025.00 $19.51 $55,103.67
FUND 490 Capital Outlay
490 Capital Outlay Current Ad Valorem Taxes $77,320.00 $0.00 $36,485.17
490 Capital Outlay Federal Grants-Other $0.00 $0.00 $0.00
490 Capital Outlay Surplus Property $0.00 $0.00 $3,500.00
FUND 490 Capital Outlay $77,320.00 $0.00 $39,985.17
City of St. Joseph 09/07/18 9:91 Al
Page
Council Month End Revenue -General Fund
Current Period:August 2018
2018 August 2018
FUND FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
$3,172,195.00 $108,148.65 $1,796,110.17
City of St. Joseph 09/07/18 9:26 Al
Page
Cash Balances Only
Current Period:August 2018
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
Last Dim 10100
General G 101-10100 $1,835,385.36 $109,625.73 $290,894.27 $1,448,356.69
Employee Retirement Reserve G 102-10100 $115,843.34 $0.00 $0.00 $122,343.34
Fire Fund G 105-10100 $521,806.17 $1,421.48 $15,148.75 $563,165.93
Cable Access Fee G 108-10100 $33,717.49 $606.48 $0.00 $2,734.35
Economic Development G 150-10100 $27,549.20 $169.50 $8,807.51 $23,176.48
TIF 3-1 CMCU G 152-10100 $2,759.65 $12.39 $1,419.36 $3,533.11
TIF 4-1 Fortitude Senior Apts G 153-10100 $2,136.02 $9.45 $1,999.36 $1,914.33
TIF 2-1 Millstream G 157-10100 $23,356.90 $41.04 $1,419.36 $23,444.02
TIF 2-2 Meat Market G 158-10100 $332.52 $1.28 $39.36 $388.36 •
TIF 2-3 Bayou Blues/Alley Flat G 159-10100 $119.95 $0.00 $1,419.90 -$1,324.93
State Collected Sales Tax G 200-10100 $961,315.04 $37,086.29 $5,302.95 $962,027.71
Park Dedication G 205-10100 $121,019.37 $222.33 $7,436.50 $113,772.22
Charitable Gambling G 215-10100 $2,084.77 $3.20 $0.00 $2,089.53
Lodging Tax G 220-10100 $20,177.02 $2,073.95 $0.00 $26,270.82
DEED CDAP Grant G 225-10100 $11,126.43 $22.64 $0.00 $17,497.74
Revolving Loan Fund G 250-10100 $205,554.66 $3,356.81 $0.00 $211,024.05
2016 CIP Bonds[govt center] G 301-10100 $17,890.40 $135.99 $0.00 $150,308.91
2017A CIP Bonds[Gov Center] G 303-10100 $55,005.64 $87.44 $500.00 $56,743.41
2016 Street Impr[Field St] G 304-10100 $190,459.50 $155.66 $2,388.50 $111,278.80
2017B Impr Bonds[CBD Alleys G 305-10100 $44,961.76 $161.86 $0.00 $56,265.04
2018 Equip Certificates G 306-10100 $0.00 $244.18 $0.00 $5,768.36
2010B Refundin[Hill/Clover] G 333-10100 $108,556.26 $193.82 $0.00 $141,742.29
2011A CO Refund[Interior St] G 338-10100 $100,177.59 $191.39 $0.00 $147,094.21
2009B GO CIP Bonds G 343-10100 $10,633.34 $41.01 $0.00 $39,818.81
2010B Street Impr[16th Ave] G 345-10100 $169,832.48 $6,645.45 $0.00 $182,236.98
2011A Pumper Truck Certificat G 346-10100 $27.97 $29.04 $0.00 $26,402.43
2011A GO CIP Bonds[roof/gar] G 347-10100 $3,319.92 $14.32 $0.00 $14,611.05
2013 Street Improve Bonds G 348-10100 $110,704.94 $172.43 $0.00 $116,776.59
2013 Equipment Certificates G 349-10100 $7,044.14 $36.26 $0.00 $36,699.74
2014 Street Impr[ParkTerrace G 350-10100 $249,175.21 $392.73 $0.00 $283,425.82
2015 Street[Clinton/Northland] G 351-10100 $146,996.79 $261.42 $0.00 $195,344.43
2015 Equipment Certificates G 352-10100 $1,527.89 $70.79 $0.00 $80,644.65 .
2015 Abatement Bonds[Kenne G 353-10100 $20,204.35 $244.76 $0.00 $159,648.03
Debt Service Relief G 390-10100 $392,280.94 $0.00 $0.00 $334,256.58
Community Center phase I G 402-10100 $1,884.67 $3.78 $0.00 $2,465.51
2017 CBD Alley Improve ph 1 G 405-10100 $62,955.96 $0.00 $168.50 $41,742.09
2018 Equip Certificates G 406-10100 $0.00 $10,000.00 $39,250.02 $138,199.60
Capital Outlay G 490-10100 $347,121.83 $0.00 $1,985.71 $366,597.27
WAC Fund G 501-10100 $241,291.01 $127,093.11 $0.00 $448,203.70
SAC Fund G 502-10100 $6,318.77 $22,944.69 $0.00 $62,248.69
Water Fund G 601-10100 $670,381.85 $142,479.81 $55,041.00 $748,252.95
Sewer Fund G 602-10100 $2,345.84 $119,863.06 $21,753.70 $251,421.10
Refuse Collection G 603-10100 $257,764.40 $33,567.50 $25,686.61 $249,723.61
Storm Water Utility G 651-10100 $280,964.44 $5,348.30 $7,317.23 $260,303.98
Street Light Utility G 652-10100 $23,576.76 $6,388.27 $4,645.05 $28,115.09
Last Dim 10100 $7,407,688.54 $631,419.64 $492,623.64 $8,256,753.47
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
City of St. Joseph 09/07/18 9:26 Ar
Page
Cash Balances Only
Current Period:August 2018
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
$7,407,963.54 $631,419.64 $492,623.64 $8,257,028.47
City of St. Joseph 09/07/18 9:29 Al
Page
Council Month End Expenditure -Summary
Current Period:August 2018
2018 August 2018
Description YTD Budget 2018 Amt YTD Amt
General $2,961,415.00 $293,814.35 $1,956,397.87
Employee Retirement Reserve $0.00 $0.00 $0.00 •
Fire Fund $346,465.00 $15,106.34 $125,380.78
Cable Access Fee $7,935.00 $0.00 $36,000.00
Economic Development $119,025.00 $8,657.52 $58,000.49
TIF 3-1 CMCU $795.00 $1,419.36 $20,891.05
TIF 4-1 Fortitude Senior Apts $0.00 $1,999.36 $17,780.24
TIF 2-1 Millstream $34,545.00 $1,419.36 $14,365.84
TIF 2-2 Meat Market $4,545.00 $39.36 $2,136.16
TIF 2-3 Bayou Blues/Alley Flat $795.00 $1,419.36 $1,593.06
State Collected Sales Tax $1,110,000.00 $5,302.95 $263,370.30
Park Dedication $143,190.00 $7,436.50 $18,271.50
Charitable Gambling $4,500.00 $0.00 $0.00
Lodging Tax $0.00 $0.00 $4,000.00
DEED CDAP Grant $0.00 $0.00 $1,834.00
Revolving Loan Fund $0.00 $0.00 $35.00
2016 CIP Bonds[govt center] $273,345.00 $0.00 $46,621.25
2017A CIP Bonds[Gov Center] $55,070.00 $500.00 $8,261.77
2016 Street Impr[Field St] $63,950.00 $2,388.50 $23,477.67
2017B Impr Bonds[CBD Alleys] $46,745.00 $0.00 $7,136.88
2018 Equip Certificates $0.00 $0.00 $11,258.00
2010B Refundin[Hill/Clover] $144,350.00 $0.00 $4,624.00
2011A CO Refund[Interior St] $141,730.00 $0.00 $5,815.00
2009B GO CIP Bonds $62,745.00 $0.00 $1,125.00
2010B Street Impr[16th Ave] $62,755.00 $0.00 $6,327.50
2011A Pumper Truck Certificate $43,660.00 $0.00 $1,780.00
2011A GO CIP Bonds[roof/gar] $21,820.00 $0.00 $860.00
2013 Street Improve Bonds $42,870.00 $0.00 $3,885.00
2013 Equipment Certificates $61,300.00 $0.00 $600.00
2014 Street Impr[ParkTerrace] $164,535.00 $0.00 $24,717.50
2015 Street[Clinton/Northland] $71,050.00 $0.00 $5,475.00
2015 Equipment Certificates $36,850.00 $0.00 $875.00
2015 Abatement Bonds[Kenned $152,235.00 $0.00 $21,067.50
Debt Service Relief $141,000.00 $0.00 $62,809.93
Community Center phase I $0.00 $0.00 $0.00
2016 Imp Field St $0.00 $0.00 $0.00
2017 CBD Alley Improve ph 1 $0.00 $168.50 $10,554.07
2018 Equip Certificates $0.00 $39,250.02 $133,260.80
Capital Outlay $77,320.00 $1,985.71 $18,779.52 .
WAC Fund $200,000.00 $0.00 $0.00
SAC Fund $96,090.00 $0.00 $0.00
City of St. Joseph 09/07/18 9:29 At
Page
Council Month End Expenditure - Summary
Current Period:August 2018
2018 August 2018
Description YTD Budget 2018 Amt YTD Amt
Water Fund $1,612,550.00 $52,128.07 $586,984.85
Sewer Fund $1,812,260.00 $21,544.27 $561,329.90
Refuse Collection $293,185.00 $24,177.63 $192,983.75 .
Storm Water Utility $256,345.00 $7,167.24 $77,135.50
Street Light Utility $80,975.00 $4,645.05 $47,562.72
$10,747,945.00 $490,569.45 $4,385,364.40
City of St. Joseph 09/07/18 9:30 AI
Page
Council Month End Revenue -Enterprise Funds
Current Period:August 2018
FUND 2018 August 2018
FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 601 Water Fund
601 Water Fund Penalties and Forfeited Disc $8,110.00 $2,009.28 $5,491.20
601 Water Fund Current Ad Valorem Taxes $22,500.00 $0.00 $11,662.92
601 Water Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00
601 Water Fund Transfers from Other Funds $207,000.00 $0.00 $0.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $12,250.00 $1,289.55 $5,917.07
601 Water Fund Water Meter $5,000.00 $650.00 $15,180.00
601 Water Fund Connection/Reconnection fees $0.00 $0.00 $0.00
601 Water Fund Undesignated Funds $0.00 $2,533.17 $578.19
601 Water Fund Bulk Water $2,500.00 $2,096.26 $3,319.09
601 Water Fund Special Assessments $400.00 $0.00 -$704.08
601 Water Fund State Sales Tax $0.00 -$50.14 -$2,699.17
601 Water Fund Water Fixed Charge $319,230.00 $34,726.52 $167,211.63
601 Water Fund State Grants and Aids $0.00 $0.00 -$48.00
601 Water Fund Usage Rate $635,545.00 $92,247.14 $310,288.36
601 Water Fund Interest Earnings $33,250.00 $918.61 -$332.30
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Water Tower Antenna Lease $35,385.00 $3,083.49 $23,833.79
601 Water Fund Surplus Property $0.00 $0.00 $0.00
601 Water Fund Reimbursement $0.00 $63.00 $63.00
FUND 601 Water Fund $1,281,170.00 $139,566.88 $539,761.70
FUND 602 Sewer Fund
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
602 Sewer Fund Sanitary Sewer Use Service $852,535.00 $66,913.97 $416,313.43
602 Sewer Fund Other Governmental Unit $0.00 $0.00 $0.00 •
602 Sewer Fund Special Assessments $400.00 $0.00 $61.90
602 Sewer Fund Interest Earnings $15,000.00 $1,901.93 -$333.97
602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00
602 Sewer Fund Contributions-General $0.00 $124.00 $440.00
602 Sewer Fund Surplus Property $0.00 $0.00 $0.00
602 Sewer Fund State Grants and Aids $0.00 $0.00 -$39.00
602 Sewer Fund Penalties and Forfeited Disc $7,500.00 $1,760.40 $5,580.97
602 Sewer Fund Sewer Fixed Charge $541,935.00 $48,953.33 $271,269.92
602 Sewer Fund Transfers from Other Funds $0.00 $0.00 $0.00
602 Sewer Fund Reimbursement $4,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,421,370.00 $119,653.63 $693,293.25
FUND 603 Refuse Collection
603 Refuse Collect Refuse Collection Charges $269,450.00 $29,095.16 $127,232.18
603 Refuse Collect Reimbursement $1,850.00 $0.00 $1,286.64
603 Refuse Collect Contributions-General $0.00 $0.00 $0.00
603 Refuse Collect Interest Earnings $3,000.00 $399.51 -$44.60
603 Refuse Collect Penalties and Forfeifted Disc $5,700.00 $527.29 $2,509.62
603 Refuse Collect Contributed Revenue $0.00 $0.00 $0.00
603 Refuse Collect State Grants and Aids $0.00 $0.00 -$5.00
603 Refuse Collect Licenses&Permits $0.00 $570.60 $23,915.60
603 Refuse Collect State Sales Tax $0.00 $1,465.96 -$1,521.44
603 Refuse Collect Special Assessments $200.00 $0.00 $12.40
FUND 603 Refuse Collection $280,200.00 $32,058.52 $153,385.40
City of St. Joseph 09/07/18 9:31 At
Page
Council Month End Revenue -Enterprise Funds
Current Period:August 2018
FUND 2018 August 2018
FUND Descr SOURCE Descr YTD Budget 2018 Amt YTD Amt
FUND 651 Storm Water Utility
651 Storm Water Storm Water Develop Fee $4,000.00 $0.00 $2,698.00
651 Storm Water Penalties and Forfeifted Disc $2,120.00 $73.93 $508.44
651 Storm Water Storm Water Use Service $51,920.00 $4,769.12 $27,254.83
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Interest Earnings $2,500.00 $355.26 -$129.05
651 Storm Water State Grants and Aids $0.00 $0.00 -$10.00
651 Storm Water Special Assessments $400.00 $0.00 -$1,392.95
FUND 651 Storm Water Utility $60,940.00 $5,198.31 $28,929.27
FUND 652 Street Light Utility
652 Street Light U Penalties and Forfeited Disc $1,000.00 $120.33 $457.49
652 Street Light U State Grants and Aids $0.00 $0.00 -$2.00
652 Street Light U Other Grants/Aids $0.00 $0.00 $571.00
652 Street Light U Special Assessments $50.00 $0.00 $2.02
652 Street Light U Interest Earnings $400.00 $174.15 $149.08
652 Street Light U Contributions-General $0.00 $0.00 $7,000.00
652 Street Light U Reimbursement $3,000.00 $0.00 $0.00
652 Street Light U Usage Rate $76,365.00 $6,093.79 $38,052.78
FUND 652 Street Light Utility $80,815.00 $6,388.27 $46,230.37
$3,124,495.00 $302,865.61 $1,461,599.99
City of St. Joseph 09/07/18 9:31 Al
Page
Council Month End Revenue Summary
Current Period:August 2018
2018 August 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
101 General $2,961,415.00 $107,522.66 $1,690,157.25
102 Employee Retirement Reserve $6,500.00 $0.00 $6,500.00
105 Fire Fund $342,995.00 $1,379.07 $219,023.25
108 Cable Access Fee $7,935.00 $606.48 $4,364.08
150 Economic Development $119,025.00 $19.51 $55,103.67 -
152 TIF 3-1 CMCU $0.00 $12.39 $21,660.55
153 TIF 4-1 Fortitude Senior Apts $0.00 $9.45 $17,556.01
157 TIF 2-1 Millstream $0.00 $41.04 $14,398.55
158 TIF 2-2 Meat Market $0.00 $1.28 $2,190.64
159 TIF 2-3 Bayou Blues/Alley Flat $0.00 -$0.54 $148.18
200 State Collected Sales Tax $425,000.00 $37,086.29 $179,209.73
205 Park Dedication $35,240.00 $222.33 $10,662.06
215 Charitable Gambling $0.00 $3.20 -$0.37
220 Lodging Tax $0.00 $2,073.95 $9,516.40
225 DEED CDAP Grant $0.00 $22.64 $8,186.31
250 Revolving Loan Fund $0.00 $3,356.81 $5,404.39
301 2016 CIP Bonds[govt center] $270,005.00 $135.99 $178,203.45
303 2017A CIP Bonds[Gov Center] $55,500.00 $87.44 $10,106.04
304 2016 Street Impr[Field St] $55,290.00 $155.66 $25,125.11
305 2017B Impr Bonds[CBD Alleys] $48,085.00 $161.86 $18,404.10
306 2018 Equip Certificates $0.00 $244.18 $17,026.36
333 2010B Refundin[Hill/Clover] $178,360.00 $193.82 $37,455.06
338 2011A CO Refund[Interior St] $118,950.00 $191.39 $51,895.51
343 2009B GO CIP Bonds $57,050.00 $41.01 $30,205.50
345 2010B Street Impr[16th Ave] $41,120.00 $6,645.45 $18,333.40
346 2011A Pumper Truck Certificate $43,660.00 $29.04 $28,226.08
347 2011A GO CIP Bonds[roof/gar] $23,035.00 $14.32 $12,186.41
348 2013 Street Improve Bonds $20,585.00 $172.43 $9,718.33
349 2013 Equipment Certificates $57,065.00 $36.26 $30,168.70
350 2014 Street Impr[ParkTerrace] $101,395.00 $392.73 $57,975.65
351 2015 Street[Clinton/Northland] $44,160.00 $261.42 $53,096.44
352 2015 Equipment Certificates $37,005.00 $70.79 $79,705.96
353 2015 Abatement Bonds[Kennedy] $160,185.00 $244.76 $160,493.44
390 Debt Service Relief $28,000.00 $0.00 $4,713.88
402 Community Center phase I $0.00 $3.78 $579.02
406 2018 Equip Certificates $0.00 $10,000.00 $271,460.40
490 Capital Outlay $77,320.00 $0.00 $39,985.17
501 WAC Fund $0.00 $127,093.11 $206,482.95
502 SAC Fund $162,500.00 $22,944.69 $55,890.51
601 Water Fund $1,281,170.00 $139,566.88 $539,761.70
602 Sewer Fund $1,421,370.00 $119,653.63 $693,293.25
City of St. Joseph 09/07/18 9:31 Ar
Page
Council Month End Revenue Summary
Current Period:August 2018
2018 August 2018
FUND FUND Descr YTD Budget 2018 Amt YTD Amt
603 Refuse Collection $280,200.00 $32,058.52 $153,385.40
651 Storm Water Utility $60,940.00 $5,198.31 $28,929.27
652 Street Light Utility $80,815.00 $6,388.27 $46,230.37
$8,601,875.00 $624,342.30 $5,103,118.16