Information 02-16-2021Information
Memorandum
To: Mayor and City Council
From: Lori Stich, Assistant Finance Director
Date: February 16, 2021
Subject: January 2021 Monthly Financial Report
This report is designed to provide summary information regarding the overall level of revenues and
expenditures in the General Fund, the Multipurpose Facility Special Revenue Fund, and the
Enterprise Funds. These funds provide an important picture of the city’s financial health.
For the month of January, actual revenues (excluding property taxes and transfers in) and
expenditures should run about 8% of the annual budget. It is natural for some of the items to vary
from month to month, such as exceeding budget for Supplies but being below budget for Services.
This is not considered serious as long as the total expenditure budget amount is not overspent.
Significant variances from budget are highlighted below accompanied with a general discussion for
the variance.
GENERAL FUND
Revenues:
Property taxes, our largest revenue source, are received in July and December.
License & permit collections are 9% of budget estimates consisting primarily of building-
related permits.
Charges for services are about 13% of estimates with plan check fees and the first-half
school liaison contract making up the majority of collections.
Revenue collections in January are typical for this time of year.
Transfers in will be recorded mid-year.
Expenditures:
Total departmental expenditures are about 7% of budget.
January expenditures reflect the first quarter premium for both workers’ comp and liability
insurance premiums.
Also included in many departments’ expenditures are their respective annual software
maintenance contracts.
2021 Monthly Expenditures
$20,000
$18,000
$16,000
$14,000
$12,000
$10,000
$8,000
$ THOUSANDS
$6,000
$4,000
$2,000
$0
JanFebMarAprMayJunJulAugSepOctNovDec
Actual
$1,240
Budget
$1,461$2,922$4,383$5,844$7,305$8,766$10,227$11,688$13,149$14,610$16,071$17,533
MULTIPURPOSE FACILITY
Through the end of January, expenditures of $55,244 exceed revenues of $29,006 by $26,238. The
majority of January collections consist of facility rentals and hockey game admissions revenues while
expenditures are primarily attributable to personal services.
ATTACHMENTS
General Fund Revenue & Expense Report
Multipurpose Facility Revenue & Expense Report
Enterprise Funds – Budget to Actual
Cash Report – All Funds
2-09-2021 02:44 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2021
101-GENERAL FUND
FINANCIAL SUMMARY 08.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT
CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET
PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET
BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
__________________________________________________________________________________________________________________________________
REVENUE SUMMARY
General Fund 17,532,500.00 410,179.46 410,179.46 2.3417,122,320.54 60,586.35
TOTAL REVENUES 17,532,500.00 410,179.46 410,179.46 2.34 17,122,320.54 60,586.35
============= ============= ============= ======= ============= =============
EXPENDITURE SUMMARY
General Government
Mayor & Council 173,200.00 17,790.85 17,790.85 10.27 155,409.15 12,934.08
Communications 336,000.00 23,928.31 23,928.31 7.12 312,071.69 14,096.03
Administrative Services 593,150.00 43,744.86 43,744.86 7.38 549,405.14 30,343.47
Human Resources 355,750.00 17,720.79 17,720.79 4.98 338,029.21 11,436.74
Elections 6,800.00 0.00 0.00 0.00 6,800.00 21.51
Finance 655,800.00 43,134.53 43,134.53 6.58 612,665.47 42,260.73
Information Technology 489,800.00 28,407.28 28,407.28 5.80 461,392.72 14,066.07
Legal 255,000.00 0.00 0.00 0.00 255,000.00 0.00
Community Development 209,500.00 47,757.78 47,757.78 22.80 161,742.22 9,128.35
Planning 364,150.00 26,893.35 26,893.35 7.39 337,256.65 17,833.02
Building Maintenance 788,500.00 55,774.75 55,774.75 7.07 732,725.25 39,206.90
TOTAL General Government 4,227,650.00 305,152.50 305,152.50 7.22 3,922,497.50 191,326.90
Public Safety
Police Administration 925,200.00 141,370.61 141,370.61 15.28 783,829.39 124,050.59
Patrol 3,274,300.00 197,727.55 197,727.55 6.04 3,076,572.45 159,364.23
Investigations 1,238,700.00 78,757.82 78,757.82 6.36 1,159,942.18 46,688.71
Police Support Services 834,550.00 50,364.62 50,364.62 6.03 784,185.38 35,568.27
Police Reserves 16,750.00 0.00 0.00 0.00 16,750.00 57.44
Public safety building 160,600.00 3,546.87 3,546.87 2.21 157,053.13 2,889.39
Fire Administration 981,700.00 60,917.13 60,917.13 6.21 920,782.87 34,972.81
Fire Operations 422,200.00 24,910.30 24,910.30 5.90 397,289.70 19,599.60
Emergency Management 62,700.00 169.84 169.84 0.27 62,530.16 128.20
Building Safety 531,850.00 34,951.73 34,951.73 6.57 496,898.27 32,122.71
Code Enforcement 86,300.00 6,341.15 6,341.15 7.35 79,958.85 4,269.65
Environmental 58,300.00 4,248.11 4,248.11 7.29 54,051.89 2,814.01
TOTAL Public Safety 8,593,150.00 603,305.73 603,305.73 7.02 7,989,844.27 462,525.61
Public Works
Street Maintenance 1,462,850.00 65,516.50 65,516.50 4.48 1,397,333.50 56,589.96
Snow Removal 345,800.00 80,979.25 80,979.25 23.42 264,820.75 85,650.36
Equipment Services 254,050.00 16,918.63 16,918.63 6.66 237,131.37 11,708.39
Engineering 492,800.00 30,149.68 30,149.68 6.12 462,650.32 19,459.72
TOTAL Public Works 2,555,500.00 193,564.06 193,564.06 7.57 2,361,935.94 173,408.43
2-09-2021 02:44 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2021
101-GENERAL FUND
FINANCIAL SUMMARY 08.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT
CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET
PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET
BALANCE YTD BALANCE BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
__________________________________________________________________________________________________________________________________
Culture & Recreation
Parks Department 1,307,700.00 71,257.79 71,257.79 5.45 1,236,442.21 56,945.66
Parks & Rec Admin 553,850.00 43,171.62 43,171.62 7.79 510,678.38 43,164.56
Recreation Programs 122,700.00 4,775.03 4,775.03 3.89 117,924.97 1,751.63
Farmers Market 8,750.00 21.50 21.50 0.25 8,728.50 0.00
Sr Citizen Programs 129,300.00 7,412.32 7,412.32 5.73 121,887.68 8,825.33
TOTAL Culture & Recreation 2,122,300.00 126,638.26 126,638.26 5.97 1,995,661.74 110,687.18
Economic Development
Economic Development 0.00 9,881.68 9,881.68 0.00 ( 9,881.68) 19,185.62
Energy City 33,900.00 1,703.68 1,703.68 5.03 32,196.32 1,143.57
TOTAL Economic Development 33,900.00 11,585.36 11,585.36 34.18 22,314.64 20,329.19
General ________________________________________________________________________
TOTAL EXPENDITURES 17,532,500.00 1,240,245.91 1,240,245.91 7.07 16,292,254.09 958,277.31
============= ============= ============= ======= ============= =============
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 830,066.45)( 830,066.45) 830,066.45 ( 897,690.96)
2-09-2021 02:44 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2021
101-GENERAL FUND
08.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT
CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET
PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET
BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
__________________________________________________________________________________________________________________________________
General Fund
============
Taxes
101-3-0000-3111 Current Ad Valorem Taxes 12,315,000.00 208,827.69 208,827.69 1.70 12,106,172.31 4.06
101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 7,531.39 7,531.39 0.00 ( 7,531.39) 0.00
101-3-0000-3121 Gravel Tax 150,000.00 0.00 0.00 0.00 150,000.00 0.00
101-3-0000-3131 Penalties/Interest 0.00 484.98 484.98 0.00 ( 484.98) 0.00
TOTAL Taxes 12,465,000.00 216,844.06 216,844.06 1.74 12,248,155.94 4.06
Licenses & Permits
101-3-0000-3211 Liquor License 76,000.00 0.00 0.00 0.00 76,000.00 0.00
101-3-0000-3213 Cigarette License 3,000.00 0.00 0.00 0.00 3,000.00 0.00
101-3-0000-3214 Rental License 65,000.00 6,903.00 6,903.00 10.62 58,097.00 6,063.00
101-3-0000-3216 Mining License 25,000.00 0.00 0.00 0.00 25,000.00 0.00
101-3-0000-3217 Garbage Hauler License 2,000.00 420.00 420.00 21.00 1,580.00 360.00
101-3-0000-3218 Other Business License/Permit 15,000.00 355.00 355.00 2.37 14,645.00 890.00
101-3-0000-3229 NPDES Permit 20,000.00 1,050.00 1,050.00 5.25 18,950.00 525.00
101-3-0000-3231 Building Permit 450,000.00 52,535.45 52,535.45 11.67 397,464.55 12,313.85
101-3-0000-3232 Plumbing/Heating Permit 110,000.00 6,734.85 6,734.85 6.12 103,265.15 4,494.69
101-3-0000-3233 Permit Surcharge 500.00 2,881.18 2,881.18 576.24 ( 2,381.18) 721.92
101-3-0000-3235 Animal License 0.00 150.00 150.00 0.00 ( 150.00) 315.00
101-3-0000-3237 Other Non-Business Lic/Permit 12,000.00 1,100.00 1,100.00 9.17 10,900.00 1,110.00
TOTAL Licenses & Permits 778,500.00 72,129.48 72,129.48 9.27 706,370.52 26,793.46
Intergovernmental Rev
101-3-0000-3322 MV Credit 5,500.00 0.00 0.00 0.00 5,500.00 0.00
101-3-0000-3323 Fire State Aid 200,000.00 0.00 0.00 0.00 200,000.00 0.00
101-3-0000-3325 Police 2% Aid 305,000.00 0.00 0.00 0.00 305,000.00 0.00
101-3-0000-3326 Police Training Reimb 32,000.00 0.00 0.00 0.00 32,000.00 0.00
101-3-0000-3329 State Crime Prevention Grant 60,000.00 0.00 0.00 0.00 60,000.00 0.00
TOTAL Intergovernmental Rev 602,500.00 0.00 0.00 0.00 602,500.00 0.00
Charges for Services
101-3-0000-3412 Planning & Zoning Fees 25,000.00 1,675.00 1,675.00 6.70 23,325.00 2,220.00
101-3-0000-3413 Plan Check Fee 220,000.00 30,583.13 30,583.13 13.90 189,416.87 5,814.84
101-3-0000-3415 Special Assessment Search 500.00 60.00 60.00 12.00 440.00 60.00
101-3-0000-3417 Copies 1,500.00 13.00 13.00 0.87 1,487.00 124.00
101-3-0000-3418 Other General Govt Services 500.00 0.00 0.00 0.00 500.00 0.00
101-3-0000-3430 Lockout Fees 5,500.00 220.00 220.00 4.00 5,280.00 520.00
101-3-0000-3431 Police Services 15,000.00 0.00 0.00 0.00 15,000.00 60.00
101-3-0000-3432 School Liaison 151,000.00 75,832.50 75,832.50 50.22 75,167.50 0.00
101-3-0000-3434 Animal Impound Fee 2,500.00 0.00 0.00 0.00 2,500.00 100.00
101-3-0000-3436 Fire Contracts 286,000.00 0.00 0.00 0.00 286,000.00 0.00
101-3-0000-3437 Fire Services 6,000.00 0.00 0.00 0.00 6,000.00 0.00
101-3-0000-3451 Street Services 25,000.00 5.00 5.00 0.02 24,995.00 710.00
101-3-0000-3452 Engineering Services Reimb 25,000.00 0.00 0.00 0.00 25,000.00 0.00
101-3-0000-3461 Recreation Fees 60,000.00 1,055.00 1,055.00 1.76 58,945.00 1,175.00
2-09-2021 02:44 PM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2021
101-GENERAL FUND
08.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT
CURRENT YEAR TO DATE % OF BUDGET PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET
PRIOR FY CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET
BALANCE YTD BALANCEREVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
__________________________________________________________________________________________________________________________________
101-3-0000-3462 Sr Center Activities 30,000.00 2,125.00 2,125.00 7.08 27,875.00 6,094.00
101-3-0000-3463 Farmer's Market 12,000.00 6,700.00 6,700.00 55.83 5,300.00 1,630.00
101-3-0000-3469 Elk RiverFest 10,000.00 0.00 0.00 0.00 10,000.00 0.00
101-3-0000-3472 Park Use Fee 20,000.00 1,342.00 1,342.00 6.71 18,658.00 2,865.00
101-3-0000-3483 Sewer Inspection Fee 12,000.00 520.00 520.00 4.33 11,480.00 520.00
101-3-0000-3484 Contractor License Check 1,000.00 50.00 50.00 5.00 950.00 15.00
TOTAL Charges for Services 908,500.00 120,180.63 120,180.63 13.23 788,319.37 21,907.84
Fines & Forfeits
101-3-0000-3510 Court Fines 120,000.00 0.00 0.00 0.00 120,000.00 0.00
101-3-0000-3511 Parking Fines 0.00 0.00 0.00 0.00 0.00 150.00
TOTAL Fines & Forfeits 120,000.00 0.00 0.00 0.00 120,000.00 150.00
Special Assessments
101-3-0000-3610 Special Assmts-County 0.00 0.00 0.00 0.00 0.00 401.76
TOTAL Special Assessments 0.00 0.00 0.00 0.00 0.00 401.76
Other Revenue
101-3-0000-3621 Interest Income 75,000.00 0.00 0.00 0.00 75,000.00 11,270.00
101-3-0000-3625 Refunds & Reimbursements 130,000.00 0.00 0.00 0.00 130,000.00 0.00
101-3-0000-3626 Contributions 25,000.00 0.00 0.00 0.00 25,000.00 0.00
101-3-0000-3629 Miscellaneous Revenue 6,500.00 1,025.29 1,025.29 15.77 5,474.71 59.23
TOTAL Other Revenue 236,500.00 1,025.29 1,025.29 0.43 235,474.71 11,329.23
Transfers In
101-3-0000-3924 Transfer - MPF 140,000.00 0.00 0.00 0.00 140,000.00 0.00
101-3-0000-3930 Transfer-Development 10,600.00 0.00 0.00 0.00 10,600.00 0.00
101-3-0000-3942 Transfer-WWTS 160,000.00 0.00 0.00 0.00 160,000.00 0.00
101-3-0000-3943 Transfer-Liquor 500,000.00 0.00 0.00 0.00 500,000.00 0.00
101-3-0000-3944 Transfer-Garbage 52,000.00 0.00 0.00 0.00 52,000.00 0.00
101-3-0000-3945 Transfer-Utilities 1,355,000.00 0.00 0.00 0.00 1,355,000.00 0.00
101-3-0000-3946 Transfer-Stormwater 121,000.00 0.00 0.00 0.00 121,000.00 0.00
101-3-0000-3948 Transfer-EDA 41,000.00 0.00 0.00 0.00 41,000.00 0.00
101-3-0000-3949 Transfer-HRA 41,900.00 0.00 0.00 0.00 41,900.00 0.00
TOTAL Transfers In 2,421,500.00 0.00 0.00 0.00 2,421,500.00 0.00
____________________________________________________________________________________________
TOTAL General Fund 17,532,500.00 410,179.46 410,179.46 2.34 17,122,320.54 60,586.35
__________________________________________________________________________________________________________________________________
TOTAL REVENUE 17,532,500.00 410,179.46 410,179.46 2.34 17,122,320.54 60,586.35
============= ============= ============= ======= ============= =============
2-10-2021 09:48 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2021
221-MULTIPURPOSE FACILITY221-MULTIPURPOSE FACILITY
FINANCIAL SUMMARY 08.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
___________________________________________________________________________________________________________________
REVENUE SUMMARY
Multipurpose Facility 1,521,850.00 26,152.70 26,152.70 1.72 1,495,697.30
Hockey 61,000.00 0.00 0.00 0.00 61,000.00
Skating 35,000.00 2,368.00 2,368.00 6.77 32,632.00
Concessions 139,300.00 485.52 485.52 0.35 138,814.48
TOTAL REVENUES 1,757,150.00 29,006.22 29,006.22 1.65 1,728,143.78
============= ============= ============= ======= =============
EXPENDITURE SUMMARY
Culture & Recreation
Multipurpose Facility 1,324,300.00 55,200.21 55,200.21 4.17 1,269,099.79
Hockey 30,150.00 0.00 0.00 0.00 30,150.00
Skating 19,950.00 6.99 6.99 0.04 19,943.01
Concessions 87,500.00 36.68 36.68 0.04 87,463.32
TOTAL Culture & Recreation 1,461,900.00 55,243.88 55,243.88 3.78 1,406,656.12
TOTAL EXPENDITURES 1,461,900.00 55,243.88 55,243.88 3.78 1,406,656.12
============= ============= ============= ======= =============
REVENUES OVER/(UNDER) EXPENDITURES 295,250.00 ( 26,237.66)( 26,237.66) 321,487.66
------
0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
% of
Budget
- - - - - - - - - - - - - - - - - - - - -
Actual
$
Year to Date
Stormwater
- - - - - - - - -
1,0005,0005,000
575,000575,000 522,900458,000981,900
(406,900) (401,900) (121,000) (522,900) (522,900)
Budget
Current
$
- -----
0.00%0.00%7.64%0.00%0.30%0.45%0.00%0.00%0.00%0.00%0.00%
-3.45%-3.40%-4.58%
% of
Budget
------------
1717
2,4874,4006,887
(6,870)(6,870)(6,870)(6,870)
Actual
$
Year to Date
Garbage
--------
3,0003,000
32,55019,400
(52,000)
199,150202,150150,150150,150
1,735,0001,735,000 1,483,9001,535,850
Budget
Current
$
--
0.00%0.00%0.00%8.02%2.46%1.16%0.00%2.21%8.42%0.00%0.00%0.00%6.98%0.00%0.00%0.00%
19.40%
% of
-18.37%
280.02%
Budget
- - - - - - - - - - -
9797
6,3918,131
59,67474,196
(74,099) (74,099)
280,020 205,921205,921
Actual
Sewer
$
Year to Date
- -
500
50,000
120,000743,800260,100700,400100,000
(879,800) (231,100) (181,100) (160,000) (135,000) (440,000)
CITY OF ELK RIVER
2,350,0002,470,500 1,646,0003,350,300
Budget
Current
(1,060,900) (1,120,900) (1,695,900)
$
MONTH ENDED JANUARY, 2021
------
ENTERPRISE FUNDS - BUDGET TO ACTUAL
8.19%2.34%6.65%6.65%8.42%1.51%7.13%0.00%7.31%0.00%0.00%0.00%0.00%0.00%
46.83%44.23%
22.13%
% of
265.17%
Budget
-----------
319319 296
(9,000)
81,75621,863
628,110501,747103,915 398,151398,151398,151389,151
(126,363)
Actual
Liquor
$
Year to Date
-------
4,8004,800
19,60050,00050,000
(20,000)
971,550306,500124,000 850,150900,150150,150130,150
(750,000)
7,670,5002,267,0001,421,650
Current
Budget
(5,403,500)
$
Sales and cost of sales: Sales Cost of sales Gross profit Operating revenues: User charges Delinquency collections Other Total operating revenues Operating expenses:
Personal services Supplies Other service charges Depreciation * Total operating expenses Operating income (loss)Nonoperating revenues (expenses): Interest income Interest
expense Total nonoperating revenues (expenses)Income (loss) before contributions & transfers Contributions - connection feesSale of assetsTransfers inTransfers out NET INCOME (LOSS)Items
reclassified to balance sheet at year end: Capital Outlay Bond Payment Revenues over/(under) expenditures * Recorded at yearend
2-09-2021 04:27 PM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: JANUARY 31ST, 2021
BEGINNING CURRENT CURRENT
FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE
__________________________________________________________________________________________________________________
CLAIM ON CASH
002-1010 Cash - Section 125 17,413.25 ( 1,176.03) 16,237.22
101-1010 Cash - General Fund 8,790,615.82 ( 772,832.76) 8,017,783.06
211-1010 Cash - Library 383,394.91 ( 10,431.97) 372,962.94
221-1010 Cash - Multipurpose Facility 236,781.35 ( 68,691.03) 168,090.32
225-1010 Cash - Park Dedication 550,835.91 255,817.40 806,653.31
228-1010 Cash - Landfill 206,870.22 ( 1,260.50) 205,609.72
231-1010 Cash - Landfill Const Debris 794,793.48 0.00 794,793.48
240-1010 Cash - Micro Loan Fund 829,008.68 2,588.06 831,596.74
242-1010 Cash - State DEED 156,581.81 4,149.90 160,731.71
245-1010 Cash - Development Fund 1,492,817.14 2,538.60 1,495,355.74
290-1010 Cash - Capital Outlay Reserve 1,263,491.63 ( 9,653.37) 1,253,838.26
291-1010 Cash - Insurance Reserve 76,843.50 ( 4,453.83) 72,389.67
292-1010 Cash - Govt Bldgs Reserve 2,960,904.24 376,439.00 3,337,343.24
294-1010 Cash - Drug Forfeiture 32,969.40 ( 98.83) 32,870.57
295-1010 Cash - Severance Pay Reserve 77,651.47 0.00 77,651.47
296-1010 Cash - GRE Reserve 1,928,048.25 0.00 1,928,048.25
301-1010 Cash - 2020A CIP Bonds 4,114.04 0.00 4,114.04
333-1010 Cash - 2010A GO Cap Imp Bonds 2,353,537.17 122,661.44 2,476,198.61
343-1010 Cash - 2019A Sales Tax Bonds 1,210,297.44 230,482.95 1,440,780.39
345-1010 Cash - 2012A CIP Bonds-PW 4,536,618.01 ( 18,264.00) 4,518,354.01
401-1010 Cash - Pavement Mgmt 5,164,965.48 ( 31,768.75) 5,133,196.73
403-1010 Cash - Street Improvement 764,652.97 ( 14,854.40) 749,798.57
406-1010 Cash - City Wide Trunk Util 4,337,962.82 ( 9,678.50) 4,328,284.32
410-1010 Cash - Equipment Replacement 206,418.76 28,450.53 234,869.29
420-1010 Cash - Active ER 6,257,281.92 ( 167,383.62) 6,089,898.30
421-1010 Cash - PS Building/Fire Sta 3 9,562,382.40 ( 277,738.70) 9,284,643.70
440-1010 Cash - Park Improvement 104,136.53 1,175.00 105,311.53
462-1010 Cash - TIF #22 Downtown Redev 0.00 ( 51.55)( 51.55)
463-1010 Cash - TIF #23 Pref Powder 5,641.26 0.00 5,641.26
464-1010 Cash - TIF #24 Beaudry Truck 0.00 222.78 222.78
602-1010 Cash - Wastewater Treatment 6,148,491.81 342,908.22 6,491,400.03
603-1010 Cash - Liquor 4,883,663.30 5,286.94 4,888,950.24
605-1010 Cash - Garbage 430,250.99 2,076.14 432,327.13
607-1010 Cash - Storm Water 1,146,298.97 46,505.45 1,192,804.42
801-1010 Cash - Interest 147,103.38 49,281.05 196,384.43
821-1010 Cash - Developer Escrow 746,230.72 ( 226,485.53) 519,745.19
TOTAL CLAIM ON CASH 67,809,069.03 ( 144,239.91) 67,664,829.12
=============== ============== ==============
CASH IN BANK - POOLED CASH
999-1000 A/P BANK ACCOUNTS 169,270,571.22 999,726.66 170,270,297.88
999-1001 PY BANK ACCOUNT (129,844,393.75)( 1,143,264.57)(130,987,658.32)
999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56
SUBTOTAL CASH IN BANK - POOLED CASH 67,808,367.03 ( 143,537.91) 67,664,829.12