Information #1 10-18-2021Information
City
E
Memorandum
TO: Mayor and City Council
From: Lori Stich, Assistant Finance Director
Date: October 18, 2021
Subject: September 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 September, actual revenues (excluding property taxes and transfers in) and
expenditures should run 75% 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 are at 111% of budget with collections for September
consisting primarily of building -related permits.
■ Intergovernmental revenues are at about 92% of budget estimates. September collections
consist of fire and police state aid payments.
■ Charges for services are at the estimated budget amount with collections for September
consisting mainly of plan check fees and planning and zoning fees.
■ Fines and forfeits, which lag a month for collections, are running about 78% of budget.
■ Transfers in consists of ERMU's 4% August electric revenues.
Expenditures:
■ Total departmental expenditures are about 67% of budget and most departments are within
or below budget estimates.
2021 Monthly Expenditures
$20,000
$18,000
$16, 000
p $14,000
z
$12,000
O $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,240 $2,094 $3,408 $5,009 $6,224 $7,743 $9,036 $10,360 $11,686
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 August, expenditures of $806,040 exceed revenues of $612,548 by $193,492.
The majority of September collections consist of ice rentals, facility rentals and
sponsorships/naming rights.
ATTACHMENTS
■ General Fund Revenue & Expense Report
■ Multipurpose Facility Revenue & Expense Report
■ Enterprise Funds — Budget to Actual
■ Cash Report — All Funds
10-13-2021 09:05 AM CITY OF ELK RIVER PAGE: 1
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2021
101-GENERAL FUND
FINANCIAL SUMMARY 75.00o OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
REVENUE SUMMARY
General Fund 17,532,500.00 712,320.24 10,973,058.51 62.59 6,559,441.49 9,646,268.28
TOTAL REVENUES 17,532,500.00 712,320.24 10,973,058.51 62.59 6,559,441.49 9,646,268.28
EXPENDITURE SUMMARY
General Government
City Council
173,200.00
38,567.23
147,501.32
85.16
25,698.6.8
124,085.96
Communications
336,000.00
23,956.42
215,756.46
64.21
120,243.54
195,604.77
Administrative Services
593,150.00
54,190.47
413,124.23
69.65
180,025.77
402,702.30
Human Resources
355,750.00
22,368.05
242,369.77
68.13
113,380.23
213,927.33
Elections
6,800.00
0.00
6,300.00
92.65
500.00
52,479.56
Finance
655,800.00
44,726.25
465,630.83
71.00
190,169.17
447,628.24
Information Technology
489,800.00
36,460.85
309,323.05
63.15
180,476.95
321,988.59
Legal
255,000.00
32,673.99
159,628.11
62.60
95,371.89
158,535.65
Community Development
209,500.00
13,585.16
155,306.61
74.13
54,193.39
156,476.91
Planning
364,150.00
28,708.19
255,217.88
70.09
108,932.12
245,026.27
Building Maintenance
788,500.00
63,816.71
567,736.23
72.00
220,763.77
541,337.17
TOTAL General Government
4,227,650.00
359,053.32
2,937,894.49
69.49
1,289,755.51
2,859,792.75
Public Safety
Police Administration
925,200.00
117,746.46
762,811.65
82.45
162,388.35
666,340.68
Patrol
3,274,300.00
220,290.59
2,049,777.76
62.60
1,224, 522
.24
1,881,665.74
Investigations
1,238,700.00
89,238.69
777,429.04
62.76
461,270.96
685,293.87
Police Support Services
834,550.00
52,871.94
491,150.31.
58.85
343,399.69
487,019.13
Police Reserves
16,750.00
54.00
3,027.56
18.07
13,722.44
2,117.93
Public safety building
160,600.00
821.14
108,059.37
67.28
52,540.63
108,759.83
Fire Administration
981,700.00
65,756.51
590,488.45
60.15
391,211.55
416,961.60
Fire Operations
422,200.00
40,709.79
284,632.13
67.42
137,567.87
303,455.37
Emergency Management
62,700.00
4,144.06
16,012.94
25.54
46,687.06
23,466.97
Building Safety
531,850.00
35,918.94
350,475.20
65.90
181,374.80
369,217.76
Code Enforcement
86,300.00
6,604.93
58,834.79
68.17
27,465.21
57,241.08
Environmental
58,300.00
4,971.47
40,446.09
69.38
17,853.91
38,505.42
TOTAL Public Safety
8,593,150.00
639,128.52
5,533,145.29
64.39
3,060,004.71
5,040,045.38
Public Works
Street Maintenance
1,462,850.00
99,180.97
1,008,577.09
68.95
454,272.91
1,013,227.79
Snow Removal
345,800.00
271.98
222,740.56
64.41
123,059.44
178,241.23
Equipment Services
254,050.00
18,730.16
172,189.70
67.78
81,860.30
158,399.47
Engineering
492,800.00
31,427.88
277,314.17
56.27
215,485.83
226,252.73
TOTAL Public Works
2,.555,500.00
149,610.99
1,680,821.52
65.77
874,678.48
1,576,12.1.22
10-13-2021 09:05 AM CITY OF ELK RIVER PAGE: 2
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2021
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
75.00o OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
1,307,700.00
117,536.08
960,020.26
73.41
347,679.74
845,024.03
553,850.00
46,801.31
365,030.41
65.91
188,819.59
453,117.65
122,700.00
2,830.85
76,498.26
62.35
46,201.74
62,842.47
8,750.00
3,930.82
5,059.84
57.83
3,690.16
(
578.28)
129,300.00
11,068.51
91,291.92
70.60
38,008.08
117,904.65
2,122,300.00
182,167.57
1,497,900.69
70.58
624,399.31
1,478,310.52
0.00
(
5,283.14)
19,449.42
0.00
(
19,449.42)
28,483.23
33,900.00
1,881.69
17,222.84
50.80
16,677.16
15,910.01
33,900.00
(
3,401.45)
36,672.26
108.18
(
2,772.26)
44,393.24
17,532,500.00 1,326,558.95 11,686,434.25 66.66 5,846,065.75 10,998,663.11
0.00 ( 614,238.71)( 713,375.74) 713,375.74 ( 1,352,394.83)
10-13-2021 09:05 AM CITY OF ELK RIVER PAGE: 3
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2021
101-GENERAL FUND
75.00o 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
101-3-0000-3112 Delinquent Ad Valorem Taxes
101-3-0000-3121 Gravel Tax
101-3-0000-3131 Penalties/Interest
TOTAL Taxes
Licenses & Permits
12,315,000.00
0.00
150,000.00
0.00
12,465,000.00
752.48 6,468,789.85
0.00 31,598.70
0.00 93,009.77
0.00 2,622.32
752.48 6,596,020.64
52.53 5,846,210.15 5,978,653.37
0.00 ( 31,598.70) 35,310.99
62.01 56,990.23 67,524.51
0.00 ( 2,622.32) 965.31
52.92 5,868,979.36 6,082,454.18
101-3-0000-3211
Liquor License
76,000.00
0.00
65,430.00
86.09
10,570.00
28,867.41
101-3-0000-3213
Cigarette License
3,000.00
0.00
1,436.25
47.88
1,563.75
0.00
101-3-0000-3214
Rental License
65,000.00
1,775.00
52,884.00
81.36
12,116.00
43,733.00
101-3-0000-3216
Mining License
25,000.00
0.00
25,849.37
103.40
(
849.37)
25,760.95
101-3-0000-3217
Garbage Hauler License
2,000.00
0.00
420.00
21.00
1,580.00
485.00
101-3-0000-3218
Other Business License/Permit
15,000.00
275.00
10,080.00
67.20
4,920.00
10,860.00
101-3-0000-3229
NPDES Permit
20,000.00
350.00
19,250.00
96.25
750.00
15,253.25
101-3-0000-3231
Building Permit
450,000.00
15,728.60
507,804.69
112.85
(
57,804.69)
292,767.15
101-3-0000-3.232
Plumbing/Heating Permit
110,000.00
11,439.94
157,066.64
142.79
(
47,066.64)
57,360.98
101-3-0000-3233
Permit Surcharge
500.00
(
2,071.69)
1,784.53
356.91
(
1,284.53)
3,487.57
101-3-0000-3235
Animal License
0.00
0.00
350.00
0.00
(
350.00)
465.00
101-3-0000-3237
Other Non -Business Lic/Permit
12,000.00
1,200.00
21,350.00
177.92
(
9,350.00)
17,447.50
TOTAL Licenses
& Permits
778,500.00
28,696.85
863,705.48
110.94
(
85,205.48)
496,487.81
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
217,908.66
218,908.66
109.45
(
18,908.66)
1,000.00
101-3-0000-3325
Police 2% Aid
305,000.00
276,543.13
276,543.13
90.67
28,456.87
0.00
101-3-0000-3326
Police Training Reimb
32,000.00
0.00
38,002.19
118.76
(
6,002.19)
29,168.23
101-3-0000-3329
State Crime Prevention Grant
60,000.00
0.00
2.2,807.63
38.01
37,192.37
16,244.54
101-3-0000-3330
Other State Grants
0.00
0.00
0.00
0.00
0.00
11,570.11
TOTAL Intergovernmental
Rev
602,500.00
494,451.79
556,261.61
92.33
46,238.39
57,982.88
Charges
for Services
101-3-0000-3412
Planning & Zoning Fees
25,000.00
14,498.75
26,992..50
107.97
(
1,992.50)
16,204.19
101-3-0000-3413
Plan Check Fee
220,000.00
6,172.11
240,780.06
109.45
(
20,780.06)
121,564.98
101-3-0000-3415
Special Assessment Search
500.00
60.00
980.00
196.00
(
480.00)
390.00
101-3-0000-3417
Copies
1,500.00
10.2.96
1,102.14
73.48
397.86
1,035.15
101-3-0000-3418
Other General Govt Services
500.00
0.00
0.00
0.00
500.00
52.00
101-3-0000-3430
Lockout Fees
5,500.00
340.00
2,840.00
51.64
2,660.00
3,465.00
101-3-0000-3431
Police Services
15,000.00
588.00
40,574.83
270.50
(
25,574.83)
10,953.41
101-3-0000-3432
School Liaison
151,000.00
0.00
155,077.50
102.70
(
4,077.50)
147,072.00
101-3-0000-3434
Animal Impound Fee
2,500.00
0.00
250.00
10.00
2,250.00
650.00
101-3-0000-3436
Fire Contracts
286,000.00
0.00
289,661.96
101.28
(
3,661.96)
280,007.80
101-3-0000-3437
Fire Services
6,000.00
0.00
0.00
0.00
6,000.00
6,137.50
101-3-0000-3451
Street Services
25,000.00
490.00
18,100.66
72.40
6,899.34
13,721.00
101-3-0000-3452
Engineering Services Reimb
25,000.00
0.00
5,778.85
23.12
19,221.15
18,371.57
10-13-2021 09:05 AM CITY OF ELK RIVER PAGE: 4
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2021
101-GENERAL FUND
REVENUES
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-3511 Parking 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 - MIT
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
75.00o
OF YEAR COMPLETED
CURRENT
CURRENT
YEAR TO DATE
o
OF
BUDGET
PRIOR FY
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
YID BALANCE
60,000.00
(
7,213.00)
30,230.00
50.38
29,770.00
13,481.00
30,000.00
3,307.00
22,616.00
75.39
7,384.00
8,058.00
12,000.00
568.00
21,468.01
178.90
( 9,468.01)
11,722.00
10,000.00
0.00
20,262.00
202.62
( 10,262.00)
500.00
20,000.00
2,540.00
17,542.79
87.71
2,457.21
20,096.99
12,000.00
1,365.00
13,530.00
112.75
( 1,530.00)
12,780.00
1,000.00
100.00
1,040.00
104.00
( 40.00)
890.00
908,500.00
22,918.82
908,827.30
100.04
( 327.30)
687,152.59
120,000.00
13,311.66
91,207.92
76.01
28,792.08
62,646.98
0.00
0.00
0.00
0.00
0.00
150.00
0.00
0.00
2,000.00
0.00
( 2,000.00)
0.00
120,000.00
13,311.66
93,207.92
77.67
26,792.08
62,796.98
75,000.00
0.00
77,406.81
103.21
(
2,406.81)
91,328.63
130,000.00
4,183.34
19,662.10
15.12
110,337.90
(
2,477.19)
25,000.00
0.00
19,000.00
76.00
6,000.00
0.00
6,500.00
1,107.93
10,328.67
158.90
(
3,828.67)
10,487.67
236,500.00
5,291.27
126,397.58
53.45
110,102.42
99,339.11
0.00
0.00
460.00
0.00
(
460.00)
481,376.79
140,000.00
0.00
0.00
0.00
140,000.00
0.00
10,600.00
0.00
10,600.00
100.00
0.00
10,600.00
160,000.00
0.00
160,000.00
100.00
0.00
155,000.00
500,000.00
0.00
500,000.00
100.00
0.00
500,000.00
52,000.00
0.00
52,000.00
100.00
0.00
50,000.00
1,355,000.00
146,897.37
901,677.98
66.54
453,322.02
867,377.94
121,000.00
0.00
121,000.00
100.00
0.00
15,500.00
41,000.00
0.00
41,000.00
100.00
0.00
39,500.00
41,900.00
0.00
41,900.00
100.00
0.00
40,700.00
2,421,500.00
146,897.37
1,828,637.98
75.52
592,862.02
2,160,054.73
TOTAL General Fund 17,532,500.00 712,320.24 10,973,058.51 62.59 6,559,441.49 9,646,268.28
TOTAL REVENUE 17,532,500.00 712,320.24 10,973,058.51 62.59 6,559,441.49 9,646,268.28
10-13-2021 09:06 AM CITY OF ELK RIVER PAGE: 1
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2021
221-MULTIPURPOSE FACILITY
FINANCIAL SUMMARY
REVENUE SUMMARY
Multipurpose Facility
Hockey
Skating
Concessions
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Multipurpose Facility
Hockey
Skating
Concessions
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
75.00o OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
1,521,850.00
42,906.38
500,219.27
32.87
1,021,630.73
170,029.61
61,000.00
18.00
87,430.34
143.33
( 26,430.34)
63,399.75
35,000.00
3,772.00
15,383.00
43.95
19,617.00
(
290.00)
139,300.00
0.00
9,515.63
6.83
129,784.37
19,042.65
1,757,150.00
46,696.38
612,548.24
34.86
1,144,601.76
252,182.01
1,324,300.00
81,675.48
770,683.33
58.20
553,616.67
436,100.25
30,150.00
25.2.25
30,510.73
101.20
(
360.73)
23,523.14
19,950.00
702.21
3,734.57
18.72
16,215.43
2,435.51
87,500.00
0.00
1,111.52
1.27
86,388.48
16,129.37
1,461,900.00
82,629.94
806,040.15
55.14
655,859.85
478,188.27
1,461,900.00
82,629.94
806,040.15
55.14
655,859.85
478,188.27
295,250.00
(
35,933.56)(
193,491.91)
488,741.91
(
2.26,006.26)
J
Q
7
F
Q O
O N
F �
W W CO
>(72
0 w
Y a
J m W
W '
LL
O Z w
F LL z
U w
W =
z
IL 0
W 2
w
z
W
0
0 0 0 0
o 0
0
o 0 0 0 o
0
N
p OI
0)
LO
Cl) O (0 O
(0 0O r O
0) LO
r
It
V
It0 0 0
V r O O O
N
a�
e
r
r V V O
M Cl)
(0
(0 r 00 O
00
m
(0
(0 N
(Q
LO
LO (Q O
N
N
N
L
Cl) LO '
00 ' 00 V '
N w
N '
N 00 ' ' ' O
00
' 00
N
R
Cl) (0
O N
0) V V
0O V
01 O
V Zt
N
0O
N N O
M N O
N
Cl!
N
Cl!
3
0
00
00 01
01 a)
�
N N
00
M
00
M
N In
N
� N
N
In
In
R a
Y
COO
O "
O ' 0 0 0
0 O
O'
O O " ' O
O
' ' O
s= am'
O
O
O 0000
O O 01 O
O
01 a
O
O
O O O
O a O
O
a
O
a
00
'0
r
r N LO
o0 O
O N
N
N
7
LO
LO LO V
01 V
V
U ro
0
0 0 0 0
0 0
0
0 0 0 0 0
0
O)
p OI
LO
0O
M (0 0) N
O) 0O lO lO
V
01 a�
r
0O
r 1n 00 O
0O (O O O O
t-
e
I-
r 0) N O
O V
01
01 w 00 O
00
m
(O
(O (O O r
r V
lO V O
N
O)
to O '
LO N (0 '
0) W
(0 '
(0 N ' ' ' O
N
' N
G1
R
0
M
V
(0 V O
lO r 01 V
LO O
O 1n
0)
I-
0) O O
I- Cl) O
O
Cl)
O
Cl)
0 7
r
00 N d) (O
d) Gi
V
V V N
N
N
(0
t7
r
r N V
O
co 0o
O
a) to
V
V
S
R Q
O "
O 000 '
O O
O
O O " ' O
O
' O
c y
O
O
O LO O O
O lO V 01
LO
o0
O
O
O O
O O
L�
Lo
` 0
LO
LO N 01 M
LO a)
M
M N N
O
O
'0
M
M M - co
M
O LO
In
Ln
7
r
r V
lO
N
U ro
o o o
o 0 0 0 0
0 0
0 0
0 0 o o o o
0
'
w
10 OI
LO O (0
0000000
M N V O
d) OOO
O V
LO O
M (0
to O)
N In 0000
01 LO OOO
V
r
e
(O M O
00 r to 0) O
LO In
V
a) O 00 O
N
m
(0 �: 0)
(0 (0 r (O
M IQ
O
V C? N O
N
�
r
(O 0) M
0o O O '
N W
M (0
M It O
In
M O N
R
O
0o (0 M
00 00 0
0o 0) 00 to
r O (0 r
N w
to N
(0 CO
N--
N V O O
01 M lO O
V
00
M O
r O
L
R
0
O 01
O LO (0 I-
01
r M
to ui O O
w
I- O co
3
C7
r O
LO -
0o O T 00
(0 LO V
00
V
(O V
r N (0
V
r
M
(O V w
0o
_
co
r
va
0000
00000
O
O O
O O O " O
O
O O O
y
0000
O LO O
O O O O
lO 0O,- V O
O O
M Do
O O
O�_
O O O O
a O O
O
a
00 O
O O a
` O
O 00
M O O IDO
al
O
O O O
O
LO O In
'0
LO N
r It(0 O It
LO r
to M
o0 w O (0
N
M V 0
j 7
(M
V r N r (O
M 0o
N
O
It
i.i m
N
N 1-
M
�
V3
0 0
0 0
0 0 0 0 0
0 0
0
0 0 0 0 0
0
„
w
00 V
O lO
lO It Cl)N O
It V
(0
(0 a 000
w
p OI
Cl)r
Cl) �
� N M (O O
N W
r
r 00 O O O
N
e
N O
(O V
V It O O
0)
0) O 00 O
Lo
m
00 00
00 01
01 1—(O 0)
r
01
01 O
(O
O ' ' 01
01 (0 I- to '
00
N '
N Cl) ' ' ' O
M
O ' M
R
0
r 00
(0
01
V lO
01 O V
lO N r r
V (O
r N
00
0O
00 V O
0O O
V
O V
O
L
0
R
d) N
(0 V
V M r
N 00
01
01 00 O
00
00 O
y0
t7
(0
M (M
LO
01
N r
r N
V
O a)
V
V a) In
a r
V
N
Cl)
�-' N
r
�
R Q
(0 V
�
O So
" O
o 00000
O
O'
O O "' o
o
o o
y
000
LO LO
00
O DO
u1 O O O
oo uQ (° uQ O
LO in
(°
O
O
O in O
O O
in
O LO
o
'0
O
(0
V d) (O V
O N
� O
N In
O
LO
O O O
LOO LO
O
In
O O
M
j 7
(0 V
N
d) M
V 00
r
V3
N
O)
N
C
N
C
R
0)
N x
0 4:
!=
o
R
01
0
0
0
y
N
C O
W d
O
O
R
N
y
O
y
] O Q
w
0
O
O
c am
0
H
w o
21 °
N wR 0)
a'U cLi
E
o
.S
> 2
2° 0-
w
s
C
o
co
0
-J
0
a>
w
Q Q
y w.w'
CL
H
zu
'ytR3
O 0) O
�
Of
x
icc)
I
Roo
O
U
aEa
ROm
1)�2
wa
c
o Ro
~ ~
R
a 2o
w
.`o
z
-o
°
Rn
an�o
a
°O
°
E
Um
0
0
0
z
U
0)
z
�a
a
R
°
m
a
`O
10-13-2021 10:07 AM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: SEPTEMBER 30TH, 2021.
FUND ACCOUNT# ACCOUNT NAME
CLAIM ON CASH
BEGINNING
BALANCE
CURRENT CURRENT
ACTIVITY BALANCE
002-1010
Cash
- Section 125
10,223.34
1,271.44
11,494.78
101-1010
Cash
- General Fund
8,029,256.01
(
615,114.30)
7,414,141.71
211-1010
Cash
- Library
259,490.54
(
33,358.05)
226,132.49
219-1010
Cash.
- Federal COVID Fund
1,333,985.24
17.70
1,334,002.94
221-1010
Cash
- Multipurpose Facility
21,209.59
(
37,936.58)(
16,726.99)
225-1010
Cash
- Park Dedication
960,958.54
0.00
960,958.54
228-1010
Cash
- Landfill
183,741.12
(
906.31)
182,834.81
231-1010
Cash.
- Landfill Const Debris
805,759.46
0.00
805,759.46
240-1010
Cash
- Micro Loan Fund
847,615.50
2,457.11
850,072.61
242-1010
Cash
- State DEED
191,901.61
4,149.90
196,051.51
245-1010
Cash
- Development Fund
1,788,634.59
99,810.39
1,888,444.98
290-1010
Cash.-
Capital Outlay :Reserve
1,528,701.44
86,590.25
1,615,291.69
291-1010
Cash
- Insurance Reserve
35,702.40
(
17,608.81)
18,093.59
292-1010
Cash
- Govt Bldgs Reserve
3,638,121.02
(
9,743.27)
3,628,377.75
294-1010
Cash
- Drug Forfeiture
38,030.03
4,305.48
42,335.51
295-1010
Cash.
- Severance Pay Reserve
78,722.84
0.00
78,722.84
296-1010
Cash
- GRE Reserve
1,048,912.22
0.00
1,048,912.22
301-1010
Cash
- 2020A GO CIP Bonds
4,156.59
0.00
4,156.59
302-1010
Cash
- 2021A GO CIP BONDS
96,277.50
0.00
96,277.50
333-1010
Cash.
- 20.20B (2010/2012) Bonds
751,747.29
0.00
751,747.29
343-1010
Cash
- 2019A Sales Tax Bonds
2,772,.218.63
315,341.78
3,087,560.41
401-1010
Cash
- Pavement Mgmt.
5,025,690.84
2,311,185.20
7,336,876.04
403-1010
Cash
- Street Improvement
430,801.12
(
94,282.85)
336,518.27
406-1010
Cash.
- City Wide Trunk Util
3,551,417.54
(
44,523.91)
3,506,893.63
410-1010
Cash
- Equipment Replacement
882,203.58
31,000.00
913,203.58
420-1010
Cash
- Active ER
4,829,646.31
(
657,055.87)
4,172,590.44
421-1010
Cash
- PS Building/Fire Sta 3
7,520,260.53
(
957,340.03)
6,562,920.50
440-1010
Cash.
- Park Improvement
421,295.05
1,9.21.39
423,216.44
463-1010
Cash
- TIF 423 Prof Powder
28,475.59
0.00
28,475.59
465-1010
Cash
- TIF 25 Jackson Hills
2,505.68
0.00
2,505.68
602-1010
Cash
- Wastewater Treatment
6,946,267.10
75,973.86
7,022,240.96
603-1010
Cash.-
Liquor
4,645,162.29
54,487.04
4,699,649.33
605-1010
Cash
- Garbage
468,982.70
13,021.80
482,004.50
607-1010
Cash
- Storm Water
1,300,547.91
47,261.16
1,347,809.07
801-1010
Cash
- Interest
0.00
69,712.25
69,712.25
821-1010
Cash.-
Developer Escrow
730,735.97
(
2,498.75)
728,237.22
TOTAL CLAIM ON
CASH
61,209,357.71
648,138.02
61,857,495.73
CASH IN BANK - POOLED CASH
999-1000 A/P BANK ACCOUNTS 172,795,720.78 1,834,963.77 174,630,684.55
999-1001 PY BANK ACCOUNT (139,968,552.63)( 1,186,825.75)(141,155,378.38)
999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56
SUBTOTAL CASH IN BANK - POOLED CASH 61,209,357.71 648,138.02 61,857,495.73