Information 11-21-2022Information
City
E
Memorandum
TO: Mayor and City Council
From: Lori Stich, Assistant Finance Director
Date: November 21, 2022
Subject: October 2022 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 October, actual revenues (excluding property taxes and transfers in) and
expenditures should run about 83% 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:
■ License & permit collections exceed budget estimates with October collections consisting
primarily of building -related permits.
■ Intergovernmental revenues are at about 102% of the estimated budget amount with
October collections consisting of the state market value credit.
■ Charges for services are about 104% of estimates with plan check fees, recreation fees, and
third quarter police liaison overtime making up the majority of collections in October.
■ Court fines which lag a month are about 82% of budget estimates including September
collections received by the county.
■ Transfers in consist of ERMU's 4% September electric revenues.
Expenditures:
■ Total departmental expenditures are about 79% of budget and most departments are within
or below budget estimates.
2022 Monthly Expenditures
$20,000
$18,000
$16,000
p $14,000
z
< $12,000
_ $10,000
~ $8,000
$6,000
$4,000
$2,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Actual $1,033 $2,333 $3,823 $5,548 $6,916 $8,361 1 $9,802 $11,218 $13,149 $14,901
Budget $1,576 $3,152 $4,728 $6,305 $7,881 $9,457 $11,033 $12,609 $14,185 $15,761 $17,338 $18,914
MULTIPURPOSE FACILITY
Through the end of October, expenditures of $1,131,908 exceed revenues of $823,364 by $308,544.
The majority of October collections consist of ice rental, facility rentals, advertising, and
sponsorships while expenditures are primarily attributable to personal services, utilities, and
maintenance.
ATTACHMENTS
■ General Fund Revenue & Expense Report
■ Multipurpose Facility - Budget to Actual
■ Enterprise Funds - Budget to Actual
■ Cash Report - All Funds
11-16-2022 04:20 PM CITY OF ELK RIVER PAGE: 1
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2022
101-GENERAL FUND
FINANCIAL SUMMARY 83.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
REVENUE SUMMARY
General Fund 18,913,650.00 335,925.58 12,093,723.65 63.94 6,819,926.35 11,352,918.62
TOTAL REVENUES 18,913,650.00 335,925.58 12,093,723.65 63.94 6,819,926.35 11,352,918.62
EXPENDITURE SUMMARY
General Government
City Council
189,250.00
5,867.09
168,551.09
89.06
20,698.91
151,302.86
Communications
412,750.00
29,591.14
294,564.31.
71.37
118,185.69
259,651.55
Administrative Services
618,500.00
48,715.78
490,166.73
79.25
128,333.27
479,385.98
Human Resources
376,600.00
22,490.58
291,039.25
77.28
85,560.75
271,787.36
Elections
48,700.00
3,09.2.25
24,969.54
51.27
23,730.46
6,300.00
Finance
686,150.00
46,418.94
568,328.38
82.83
117,821.62
530,325.87
Information Technology
542,550.00
32,731.05
412,094.18
75.96
130,455.82
359,509.75
Legal
255,000.00
21,198.29
193,997.53
76.08
61,002.47
179,116.30
Community Development
213,500.00
13,450.33
172,351.21
80.73
41,148.79
175,668.56
Planning
388,100.00
17,008.70
233,555.49
60.18
154,544.51
295,895.49
Building Maintenance
931,250.00
87,223.62
729,723.16
78.36
201,526.84
654,699.69
TOTAL General Government
4,662,350.00
327,787.77
3,579,340.87
76.77
1,083,009.13
3,363,643.41
Public Safety
Police Administration
994,200.00
180,861.69
928,550.56
93.40
65,649.44
835,860.57
Patrol
3,445,600.00
232,908.51
2,580,355.54
74.89
865,244.46
2,370,408.99
Investigations
1,306,250.00
99,908.95
995,207.36
76.19
311,042.64
906,392.03
Police Support Services
868,200.00
48,957.51
606,335.70
69.84
261,864.30
569,038.42
Police Reserves
16,250.00
119.59
5,022.59
30.91
11,227.41
3,027.56
Public safety building
158,100.00
24,762.92
176,716.70
111.78
( 18,616.70)
118,414.94
Fire Administration
1,097,600.00
340,417.32
1,019,553.59
92.89
78,046.41
886,362.48
Fire Operations
483,350.00
66,191.60
385,779.71.
79.81
97,570.29
338,973.82
Emergency Management
30,250.00
1,020.82
13,894.38
45.93
16,355.62
18,618.97
Building Safety
548,650.00
41,166.51
510,918.14
93.12
37,731.86
400,702.14
Code Enforcement
94,200.00
7,465.34
58,556.65
62.16
35,643.35
69,642.98
Environmental
62,500.00
11,994.10
84,816.23
135.71
( 22,316.23)
46,638.99
TOTAL Public Safety
9,105,150.00
1,055,774.86
7,365,707.15
80.90
1,739,442.85
6,564,081.89
Public Works
Street Maintenance
I,429,500.00
91,445.15
1,104,790.32
77.29
324,709.68
1,159,158.33
Snow Removal
338,000.00
2,125.00
222,717.92
65.89
115,282.08
223,015.95
Equipment Services
362,800.00
26,138.88
284,838.19
78.51
77,961.81
194,746.30
Engineering
493,450.00
32,383.48
340,089.52
68.92
153,360.48
321,137.66
TOTAL Public Works
2,623,750.00
152,092.51
1,952,435.95
74.41
671,314.05
1,898,058.24
11-16-2022 04:20 PM CITY OF ELK RIVER PAGE: 2
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2022
101-GENERAL FUND
FINANCIAL SUMMARY
Culture & Recreation
Parks Department
Parks & Rec Admin
Recreation Programs
Farmers Market
Sr Citizen Programs
TOTAL Culture & Recreation
Economic Development
Economic Development
Energy City
TOTAL Economic Development
General
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
83.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
1,548,700.00
147,553.28
1,199,239.32
77.44
349,460.68
1,104,743.58
621,000.00
43,361.84
507,150.53
81.67
113,849.47
431,584.01
171,300.00
1,740.61
92,835.03
54.19
78,464.97
81,362.46
8,750.00
16,230.92
44,405.64
507.49
(
35,655.64)
14,767.69
133,950.00
11,419.23
109,632.38
81.85
24,317.62
106,229.01
2,483,700.00
220,305.88
1,953,262.90
78.64
530,437.10
1,738,686.75
0.00
2,940.14
31,076.33
0.00
(
31,076.33)
27,378.09
38,700.00
1,944.04
19,667.79
50.82
19,032.21
19,597.68
38,700.00
4,884.18
50,744.12
131.12
(
12,044.12)
46,975.77
18,913,650.00 1,760,845.20 14,901,490.99 78.79 4,012,159.01 13,611,446.06
0.00 ( 1,424,919.62)( 2,807,767.34) 2,807,767.34 ( 2,258,527.44)
11-16-2022 04:20 PM CITY OF ELK RIVER PAGE: 3
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2022
101-GENERAL FUND
83.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
General Fund
faxes
101-3-0000-3111
Current Ad Valorem Taxes
13,109,300.00
0.00
6,733,435.45
51.36
6,375,864.55
6,468,789.85
101-3-0000-3112
Delinquent Ad Valorem Taxes
0.00
0.00
39,984.14
0.00
( 39,984.14)
31,598.70
101-3-0000-3121
Gravel Tax
180,000.00
68,264.86
138,985.74
77.21
41,014.26
178,540.54
101-3-0000-3131
Penalties/Interest
0.00
0.00
1,508.77
0.00
( 1,508.77)
2,622.32
TOTAL Taxes
13,289,300.00
68,264.86
6,913,914.10
52.03
6,375,385.90
6,681,551.41
Licenses
&
Permits
101-3-0000-3211
Liquor License
76,000.00
0.00
81,890.00
107.75
( 5,890.00)
65,430.00
101-3-0000-3213
Cigarette License
3,000.00
0.00
100.00
3.33
2,900.00
1,461.25
101-3-0000-3214
Rental License
65,000.00
3,320.00
53,025.00
81.58
11,975.00
56,583.00
101-3-0000-3216
Mining License
26,000.00
0.00
26,107.70
100.41
( 107.70)
25,849.37
101-3-0000-3217
Garbage Hauler License
2,000.00
0.00
125.00
6.25
1,875.00
420.00
101-3-0000-3218
Other Business License/Permit
16,000.00
760.00
12,435.00
77.72
3,565.00
10,215.00
101-3-0000-3229
NPDES Permit
22,000.00
525.00
15,079.51
68.54
6,920.49
21,700.00
101-3-0000-3231
Building Permit
500,000.00
25,560.80
483,321.85
96.66
16,678.15
543,294.69
101-3-0000-3.232
Plumbing/Heating Permit
140,000.00
14,252.26
173,577.28
123.98
( 33,577.28)
167,480.54
101-3-0000-3233
Permit Surcharge
700.00
(
237.43)
2,135.84
305.12
( 1,435.84)
2,919.65
101-3-0000-3235
Animal License
0.00
0.00
460.00
0.00
( 460.00)
350.00
101-3-0000-3237
Other Non -Business Lic/Permit
15,000.00
3,033.00
28,026.62
186.84
( 13,026.6.2)
22,500.00
TOTAL Licenses
& Permits
865,700.00
47,213.63
876,283.80
101.22
( 10,583.80)
918,203.50
Intergovernmental
Rev
101-3-0000-3311
Federal Grant
0.00
0.00
1,375.32
0.00
( 1,375.32)
0.00
101-3-0000-3322
MV Credit
6,000.00
2,947.25
2,947.25
49.12
3,052.75
2,877.79
101-3-0000-3323
Fire State Aid
215,000.00
0.00
255,657.77
118.91
( 40,657.77)
218,908.66
101-3-0000-3325
Police 20 Aid
315,000.00
0.00
320,525.85
101.75
( 5,525.85)
276,543.13
101-3-0000-3326
Police Training Reimb
32,000.00
0.00
33,488.96
104.65
( 1,488.96)
38,002.19
101-3-0000-3329
State Crime Prevention Grant
55,000.00
0.00
20,159.86
36.65
34,840.14
33,524.37
TOTAL Intergovernmental
Rev
623,000.00
2,947.25
634,155.01
101.79
( 11,155.01)
569,856.14
Charges
for Services
101-3-0000-3412
Planning & Zoning Fees
25,000.00
1,218.75
23,440.00
93.76
1,560.00
30,913.00
101-3-0000-3413
Plan Check Fee
250,000.00
5,761.13
223,150.95
89.26
26,849.05
258,917.08
101-3-0000-3415
Special Assessment Search
500.00
30.00
270.00
54.00
230.00
1,160.00
101-3-0000-3417
Copies
1,500.00
71.96
880.82
58.72
619.18
1,298.84
101-3-0000-3418
Other General Govt Services
500.00
0.00
13.00
2.60
487.00
0.00
101-3-0000-3430
Lockout Fees
5,500.00
240.00
2,865.00
52.09
2,635.00
3,180.00
101-3-0000-3431
Police Services
18,000.00
15,431.64
30,931.64
171.84
( 12,931.64)
50,213.53
101-3-0000-3432
School Liaison
162,000.00
0.00
170,581.63
105.30
( 8,581.63)
155,077.50
101-3-0000-3434
Animal Impound Fee
1,000.00
100.00
575.00
57.50
425.00
250.00
101-3-0000-3436
Fire Contracts
335,000.00
0.00
380,316.61
113.53
( 45,316.61)
289,661.96
101-3-0000-3437
Fire Services
6,000.00
0.00
1,393.50
23.23
4,606.50
0.00
101-3-0000-3451
Street Services
25,000.00
2,128.33
17,507.50
70.03
7,492.50
19,285.66
101-3-0000-3452
Engineering Services Reimb
20,000.00
0.00
12,375.08
61.88
7,624.92
14,793.17
11-16-2022 04:20 PM CITY OF ELK RIVER PAGE: 4
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2022
101-GENERAL FUND
83.33% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
101-3-0000-3461 Recreation Fees
101-3-0000-3462 Sr Center Activities
101-3-0000-3463 Farmer's Market
101-3-0000-3469 Elk RiverFest
101-3-0000-3472 Park Use Fee
101-3-0000-3483 Sewer Inspection Fee
101-3-0000-3484 Contractor License Check
TOTAL Charges for Services
Fines & Forfeits
101-3-0000-3510 Court Fines
101-3-0000-3512 Ordinance Violations
TOTAL Fines & Forfeits
Special Assessments
Other Revenue
101-3-0000-3621 Interest Income
101-3-0000-3625 Refunds & Reimbursements
101-3-0000-3626 Contributions
101-3-0000-3629 Miscellaneous Revenue
TOTAL Other Revenue
Transfers In
101-3-0000-3921 Transfers
101-3-0000-3924 Transfer - MPF
101-3-0000-3926 Transfer -Capital Outlay Resery
101-3-0000-3930 Transfer -Development
101-3-0000-3942 Transfer-WWTS
101-3-0000-3943 Transfer -Liquor
101-3-0000-3944 Transfer -Garbage
101-3-0000-3945 Transfer -Utilities
101-3-0000-3946 Transfer-Stormwater
101-3-0000-3948 Transfer-EDA
101-3-0000-3949 Transfer-HRA
TOTAL Transfers In
60,000.00
35,000.00
15,000.00
19,000.00
25,000.00
13,000.00
1,000.00
1,018,000.00
120,000.00
0.00
120,000.00
55.00
42,198.96
70.33
17,801.04
30,653.00
3,326.50
30,720.50
87.77
4,279.50
25,392.00
2,734.00
50,155.00
334.37
(
35,155.00)
21,792.01
0.00
20,845.00
109.71
(
1,845.00)
20,222.00
7,032.50
34,428.32
137.71
(
9,428.32)
21,202.79
2,460.00
13,760.00
105.85
(
760.00)
15,630.00
70.00
1,015.00
101.50
(
15.00)
1,125.00
40,659.81
1,057,423.51
103.87
(
39,423.51)
960,767.54
12,413.21 97,230.16 81.03 22,769.84 100,798.93
0.00 2,000.00 0.00 ( 2,000.00) 2,000.00
12,413.21 99,230.16 82.69 20,769.84 102,798.93
100,000.00
0.00
99,987.57
99.99
12.43
95,54.2.99
130,000.00
(
7.01)
2,061.16
1.59
127,938.84
20,412.10
20,000.00
(
220.00)
24,811.06
124.06
(
4,811.06)
19,000.00
10,000.00
213.38
10,031.16
100.31
(
31.16)
11,275.35
260,000.00
(
13.63)
136,890.95
52.65
123,109.05
146,230.44
0.00
140,000.00
50,000.00
10,650.00
165,000.00
750,000.00
54,000.00
1,355,000.00
135,000.00
43,000.00
35,000.00
2,737,650.00
0.00 1.,656.17 0.00
0.00 0.00 0.00
0.00 50,000.00 100.00
0.00 10,650.00 100.00
0.00 165,000.00 100.00
0.00 750,000.00 100.00
0.00 54,000.00 100.00
164,440.45 1,131,519.95 83.51
0.00 135,000.00 100.00
0.00 43,000.00 100.00
0.00 35,000.00 100.00
164,440.45 2,375,826.12 86.78
1,656.17) 460.00
140,000.00 0.00
0.00 0.00
0.00 10,600.00
0.00 160,000.00
0.00 500,000.00
0.00 52,000.00
223,480.05 1,046,550.66
0.00 121,000.00
0.00 41,000.00
0.00 41,900.00
361,823.88 1,973,510.66
TOTAL General Fund 18,913,650.00 335,925.58 12,093,723.65 63.94 6,819,926.35 11,352,918.62
TOTAL REVENUE 18,913,650.00 335,925.58 12,093,723.65 63.94 6,819,926.35 11,352,918.62
CITY OF ELK RIVER
MULTIPURPOSE FACILITY - BUDGET TO ACTUAL
MONTH ENDED OCTOBER, 2022
Current
Year to Date
% of
Budget
Actual
Budget
Revenues:
Ice Rental
$640,000
$341,098
53.30%
Admissions
30,000
13,338
44.46%
Dry Floor Events/Craft Shows
17,000
4,590
27.00%
Facility Rental
550,000
142,518
25.91%
Advertising/Naming Rights/Sponsorships
153,000
157,783
103.13%
Recreation fees (Skating/Hockey)
117,000
142,472
121.77%
Other Revenues (interest, vending, etc.)
41,200
21,566
52.34%
Total Revenues
$1,548,200
$823,364
53.18%
Operating expenses:
Personal services
$851,900
$616,264
72.34%
Supplies
55,500
89,220
160.76%
Service charges
374,700
426,425
113.80%
Capital Outlay
20,000
0
0.00%
Transfers Out
140,000
0
0.00%
Total Expenditures
$1,442,100
$1,131,908
78.49%
Revenues over/(under) expenditures
$106,100
($308,544)
FTCenter
October 2022
$1,800,000
$1,600,000 Budget, $1,548,200
Budget, $1,442,100
$1,400,000 Actual
$1, 200,000 $1,131,908
Actual
$1,000,000 $823,364
$800,000
$600,000
$400,000
$200,000
$0
Total Revenues Total Expenditures
J
Q
7
F
Q N
0 0
F N
W W w
m
0
J m O
WLL
'
o W 0
Z
F LL W
W F
Z
ILO
IL �
w
Z
w
0
0 0 0 0
o 0
0
o 0 o
0
N
N
V 0 00 O
O 00
(O
(O r 0
N
p
e
(O
r 00 O
(O V N 0
o0 (O
O
V
O O O
V N O
f�
N
m
I-
I- N
OP
O
O O? O
L
0)
t LO '
00 ' 00 LO '
M LO
(0 '
(0 ' O
' '
r
0
I-
to
00 ItLO
to Nt
0 00
lO O
O
Nt
0 a) 0
Nt lzt O
3
R
O,
(O
(O
r ol
O
0 ol to
LO
LO
MCl)
N
N lO M
Cl)
N
N
N
N
E
R
Y
COO
0 "
0 ' 0 0 0
0 O
0'
0 O ' O
O
' ' O
!_ y
O
O
O O LO O
O O Nt O
LO lO
Nt a
O
O
0 lO 0
O a O
lO
a
lO
a
` 0
N
LO� 0) LO
LO O
O
O O LO
lO
lO
'O
0)
0) N (0
0) O
a M
N
N
7
LO
LO LO It0)
co
lO
lO
u ro
0
0 0 0 0
0 0
0
0 0 0
0
N
"O
(0
LO 0) 0) V
O
V
V N 0
LO
O)
N 7 O (0
V M
V
V f- O
f�
e
r
r O 'It
V 00
Cl)
Cl) a) 0
m
r
r 0) M I-
r O
lO O O
co 0 '
co I- co (0 '
(0 f-
N '
N a) ' O
a)
' ' a)
N
R
0
Cl) I-
00 (0
O OO to 01
lO CO- (0
0 a)
N N
I-
(0
I- w0
(0 a) 0
w
a)
(O
a)
O j
N_
V (0 O
o0 (O
r-
r M V
a
a
t7
M
S
`
R Q
V
It N
N
0' '
0 000 O '
0 O
0'
0 O ' O
o
' ' O
c y
O
O
O 00 LO
O OO Nt N
LO LO
Nt W
O
O
0 LO 0
O W O
LO
W
LO
W
` 0
V
I- co
LO
LO 00 V
'O
M
M M N N
1n
1n to
O
O
� 7
00
00 01
01 �
�
U ro
o o o
o 0 0 0 0
0 0
0 0
0 0 0 0
0
'
0)
p O)
V O
(0 O lO
00 V LO O
O1 O (0 O
V
V O
(0 O
O1 (M
N (0 0
O
(O
Zt
e
V (0 0)
IT N 0) O
N fl
LO LO
.
00 f� (0 0
f-
mr
M I-
1-00 00 1-
It
O V
lO IQ M O
w
r
N O 00
0 00 00 '
(0
o0
I� N O
M
to O N
R
0
(0 00 Cl)
I- (1
00 I- 00 O
to M V d)
(0
r 00
LO I�
(3) 00
00 O O
O 00 O
fz
00 a)
Nt O (C
L
R
O
00 0)
00 0) 0) 0)
00 a)
LO
'It Cl)0 LO
a)
It It
3
t7
N M
00
(0 O N Cl)
d) (O N (0
I- 00
V
O r
CO N 00 (0
LO
M
M 0) 00
Nt M
G1
N Q
N
LO
C')
V)
0000
00000
o
o 0
0 0 o 0
0
0 0 0
y
0000
OIOOIO
0000!O
(M LOCH O
w
(C
0LOIO
O(0
o OO
(0 M OO
o
M
OO o
OO M
` i3I
0 LO
LOJ M M O
V M
0 00
00 f� 0 LO
N
O O N
'O
LO I :
N (0 I_ 0 V
00 lO
0 lO
lO 0 (0
00
(0 LO a)
j 7
N
(0 I� N o0 01
(
V 00
"
a) LO
lO
ss
ii m
N
N
V3
0 0
0 0
0 0 0 0 0
0 0
0
0 0 0
0
„
N
I- N
co (0
(0 0 V (0 0
(0 00
00
00 00 O
N
p O)
V
00 lO
lO N N O
(0 O�
00
OR r O
't
e
r (O
O 0)
0) 0 0) 0) O
It Cl)
O
0 00 0
wm
00 00
0) Cl)
Cl) 00 (0 I-
r N
r
I- O
0)
00
M ' ' O
0 00 N 0) '
0) Cl)
(0 '
(0 a) ' O
O ' O
ip
Q
I� (O
00 Nt
0 (0
Nt lO
(0 (0 0) N
lO V (M 0)
00 f�
I-
O
r
0 f- O
r 00 O
N
Cl) LO
M
L
O
R
0 7
O Cl)
I- Cl)
Cl) 00 00 O
r- M
(0
(0 a) O
O
O
7
t7
d) O
O
Cl) , 0)
V
LO
LO w 00
M
M
a
R Q
(0 V
N
J
}
�
0 So
'' O
o 00000
o
0'
0 0 0
0
0 o
y
000
o0o
00
O
O O LO 0
O CC (0000
LO LO
iO
O
O
0 LO 0
o iO o
LO
a
0 LO
o a
` i3I
'O
(O
O Cl)
to 0)
(0
0) It(O I- 0)
ItN (0 0)
I- wO
Cl) Cl)
00
O (O O
00 0
M
00
O M
O 00
j 7
0) (0
N
O M
LO f-
00 O
N
U m
n
N
6
V3
y
0)
a
y
R
�
C
otf
a
m
x
y 4:
!= y
O
N
'
0 Q
w �
y
r m
0
y
y
C O
N
y
y d
O
O
-
R N
`s
N
R
y
C
y
U
0) y
y a)x
y 21 0)
y
0)
c 0) �
�._
t7
0)
a)
C
_
y
y
�.
R
a) y In R a)
w
> %
w
O
O
a
w
FZ
Q y N o Q
c
c Q
y
M
N E
'O vRi y
`O
O) R 0)
0 0) R y 0) .� O
0)
R .� N C
O
0 O
0
R O N
R o
y° y (�
y N '� L
H R N fl L O H
R
0 0 0 H
y fl C
Dacno
F
a2�Um
co
0���
0
z
0
z
11-17-2022 09:34 AM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: OCTOBER 31ST, 2022
FUND ACCOUNT# ACCOUNT NAME
CLAIM ON CASH
BEGINNING
BALANCE
CURRENT CURRENT
ACTIVITY BALANCE
002-1010
Cash
- Section 125
10,250.29
45.24
10,.295.53
101-1010
Cash
- General Fund
7,092,295.75
(
1,297,380.50)
5,794,915.25
211-1010
Cash
- Library
231,266.58
(
8,127.08)
223,139.50
219-1010
Cash.-
Federal COVID Fund
2,770,554.60
6,608.91
2,777,163.51
221-1010
Cash
- Multipurpose Facility
( 384,351.73)(
19,448.56)(
403,800.29)
225-1010
Cash
- Park Dedication
1,595,120.39
18,038.02
1,613,158.41
228-1010
Cash
- Landfill
179,887.53
(
1,505.69)
178,381.84
231-1010
Cash.-
Landfill Const Debris
819,911.27
0.00
819,911.27
240-1010
Cash
- Micro Loan Fund
949,162.10
3,496.25
952,658.35
242-1010
Cash
- State DEED
384,231.09
3,138.13
387,369.22
245-1010
Cash
- Development Fund
275,773.74
(
6,907.26)
268,866.48
290-1010
Cash.-
Capital Outlay :Reserve
1,820,394.70
(
34,632.59)
1,785,762.11
291-1010
Cash
- Insurance Reserve
42,505.70
(
2,687.53)
39,818.17
292-1010
Cash
- Govt Bldgs Reserve
3, 987, 991.71
(
42,319.44)
3,945,672.27
294-1010
Cash
- Drug Forfeiture
40,905.87
104.56
41,010.43
295-1010
Cash.-
Severance Pay Reserve
80,105.61
0.00
80,105.61
296-1010
Cash
- GRE Reserve
850,079.90
0.00
850,079.90
301-1010
Cash
- 2020A GO CIP Bonds
4,229.09
0.00
4,229.09
302-1010
Cash
- 2021A GO CIP BONDS
97,465.21
0.00
97,465.21
333-1010
Cash.
- 20.20B (2010/2012) Bonds
816,677.85
0.00
816,677.85
343-1010
Cash
- 2019A Sales Tax Bonds
5,046,977.54
371,862.10
5,418,839.64
401-1010
Cash
- Pavement Mgmt.
6,607,336.72
87,096.14
6,694,432.86
403-1010
Cash
- Street Improvement
553,654.29
(
5,838.52)
547,815.77
406-1010
Cash.
- City Wide Trunk Util
2,664,169.29
(
5,685.50)
2,658,483.79
410-1010
Cash
- Equipment Replacement
1,601,473.29
(
181,.289.34)
1,420,183.95
420-1010
Cash
- Active ER
1,064,631.68
399,241.38
1,463,873.06
421-1010
Cash
- PS Building/Fire Sta 3
882,002.87
79,619.32
961,622.19
440-1010
Cash.-
Park Improvement
259,661.90
(
4,238.50)
255,4.23.40
463-1010
Cash
- TIF 423 Prof Powder
7,.211.39
0.00
7,211.39
465-1010
Cash
- TIF 25 Jackson Hills
7,447.25
0.00
7,447.25
602-1010
Cash
- Wastewater Treatment
9,012,299.88
106,498.56
9,118,798.44
603-1010
Cash.
- Liquor
4,254,882.48
37,484.14
4,292,366.62
605-1010
Cash
- Garbage
642,322.03
21,675.13
663,997.16
607-1010
Cash
- Storm Water
1,740,596.67
(
29,695.35)
1,710,901.32
801-1010
Cash
- Interest
0.00
61,654.88
61,654.88
821-1010
Cash.
- Developer Escrow
655,024.45
350,621.54
1,005,645.99
TOTAL CLAIM ON
CASH
56,664,148.98
(
92,571.56)
56,571,577.42
CASH IN BANK - POOLED CASH
999-1000 A/P BANK ACCOUNTS 186,195,643.55 1,173,509.84 187,369,153.39
999-1001 PY BANK ACCOUNT (157,913,684.13)( 1,266,081.40)(159,179,765.53)
999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56
SUBTOTAL CASH IN BANK - POOLED CASH 56,664,148.98 ( 92,571.56) 56,571,577.42