INFORMATION 09-20-2021Information
City
E
Memorandum
TO: Mayor and City Council
From: Lori Stich, Assistant Finance Director
Date: September 20, 2021
Subject: August 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 August, actual revenues (excluding property taxes and transfers in) and
expenditures should run about 67% 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 have exceeded budget estimates with August collections
consisting primarily of building -related permits.
■ Intergovernmental revenues for August consist of the state reimbursement for police
training.
■ Charges for services are about 97% of budget estimates with August collections consisting
mainly of plan check fees.
■ Fines and forfeits, which lag a month for collections, are running about 67% of budget.
■ Transfers in consists of ERMU's 4% July electric revenues and the budgeted transfer from
HRA into the General Fund.
Expenditures:
■ Total departmental expenditures are about 60% 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
_ $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
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 $723,410 exceed revenues of $565,719 by $157,691.
The majority of August collections consist of ice rentals and facility rentals.
ATTACHMENTS
■ General Fund Revenue & Expense Report
■ Multipurpose Facility Revenue & Expense Report
■ Enterprise Funds - Budget to Actual
■ Cash Report - All Funds
9-14-2021 09:41 AM CITY OF ELK RIVER PAGE: 1
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2021
101-GENERAL FUND
FINANCIAL SUMMARY 66.67% 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 355,075.43 10,233,524.12 58.37 7,298,975.88 9,409,693.72
TOTAL REVENUES 17,532,500.00 355,075.43 10,233,524.12 58.37 7,298,975.88 9,409,693.72
EXPENDITURE SUMMARY
General Government
City Council
173,200.00
29,239.67
108,934.09
62.89
64,265.91
89,891.30
Communications
336,000.00
17,891.34
191,800.04
57.08
144,199.96
174,754.54
Administrative Services
593,150.00
45,326.49
358,933.76
60.51
234,216.24
350,590.77
Human Resources
355,750.00
39,173.57
220,001.72
61.84
135,748.28
196,732.64
Elections
6,800.00
0.00
6,300.00
92.65
500.00
52,210.89
Finance
655,800.00
44,501.62
420,904.58
64.18
234,895.42
412,229.28
Information Technology
489,800.00
34,843.96
272,862.20
55.71
216,937.80
277,417.91
Legal
255,000.00
22,433.14
126,954.12
49.79
128,045.88
137,020.45
Community Development
209,500.00
13,294.01
141,721.45
67.65
67,778.55
143,274.19
Planning
364,150.00
28,753.22
226,509.69
62.20
137,640.31
218,277.43
Building Maintenance
788,500.00
66,844.27
503,919.52
63.91
284,580.48
481,543.44
TOTAL General Government
4,227,650.00
342,301.29
2,578,841.17
61.00
1,648,808.83
2,533,942.84
Public Safety
Police Administration
925,200.00
51,069.21
645,065.19
69.72
280,134.81
584,046.90
Patrol
3,274,300.00
223,658.15
1,829,487.17
55.87
1,444,812.83
1,672,026.10
Investigations
1,238,700.00
80,815.59
688,190.35
55.56
550,509.65
605,279.93
Police Support Services
834,550.00
56,902.53
438,278.37
52.52
396,271.63
431,753.00
Police Reserves
16,750.00
36.00
2,973.56
17.75
13,776.44
1,659.53
Public safety building
160,600.00
18,452.57
107,238.23
66.77
53,361.77
98,528.11
Fire Administration
981,700.00
59,581.69
524,731.94
53.45
456,968.06
374,383.60
Fire Operations
422,200.00
25,922.36
243,922.34
57.77
178,277.66
273,755.31
Emergency Management
62,700.00
1,164.36
11,868.88
18.93
50,831.12
22,636.18
Building Safety
531,850.00
38,724.41
314,556.26
59.14
217,293.74
326,178.99
Code Enforcement
86,300.00
6,399.42
52,229.86
60.52
34,070.14
50,796.83
Environmental
58,300.00
4,818.82
35,474.62
60.85
22,825.38
33,586.61
TOTAL Public Safety
8,593,150.00
567,545.11
4,894,016.77
56.95
3,699,133.23
4,474,631.09
Public Works
Street Maintenance
1,462,850.00
141,394.36
909,396.12
62.17
553,453.88
913,247.01
Snow Removal
345,800.00
263.85
222,468.58
64.33
123,331.42
176,106.83
Equipment Services
254,050.00
is, 019.99
153,459.54
60.41
100,590.46
142,749.29
Engineering
492,800.00
31,233.95
245,886.29
49.90
246,913.71
205,963.73
TOTAL Public Works
2,555,500.00
190,912.15
1,531,210.53
59.92
1,024,289.47
1,438,066.86
9-14-2021 09:41 AM CITY OF ELK RIVER PAGE: 2
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 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
66.67% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
1,307,700.00
151,248.35
842,484.18
64.42
465,215.82
749,322.62
553,850.00
40,894.64
318,229.10
57.46
235,620.90
421,415.43
122,700.00
21,795.46
73,667.41
60.04
49,032.59
54,524.08
8,750.00
5,407.22
872.93
9.98
7,877.07
(
3,703.48)
129,300.00
12,779.30
80,223.41
62.04
49,076.59
106,769.95
2,122,300.00
232,124.97
1,315,477.03
61.98
806,822.97
1,328,328.60
0.00
6,737.71
24,732.56
0.00
(
24,732.56)
27,135.29
33,900.00
1,829.47
15,341.15
45.25
18,558.85
12,879.62
33,900.00
8,567.18
40,073.71
118.21
(
6,173.71)
40,014.91
17,532,500.00 1,341,450.70 10,359,619.21 59.09 7,172,880.79 9,814,984.30
0.00 ( 986,375.27)( 126,095.09) 126,095.09 ( 405,290.58)
9-14-2021 09:41 AM CITY OF ELK RIVER PAGE: 3
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2021
101-GENERAL FUND
66.67o 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
0.00 6,468,037.37
0.00 31,598.70
0.00 93,009.77
0.00 2,622.32
0.00 6,595,268.16
52.52 5,846,962.63 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.91 5,869,731.84 6,082,454.18
101-3-0000-3211
Liquor License
76,000.00
4,145.00
65,430.00
86.09
10,570.00
39,436.16
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
3,065.00
51,109.00
78.63
13,891.00
43,083.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
360.00
101-3-0000-3218
Other Business License/Permit
15,000.00
570.00
9,805.00
65.37
5,195.00
10,600.00
101-3-0000-3229
NPDES Permit
20,000.00
3,850.00
is, 900.00
94.50
1,100.00
13,153.25
101-3-0000-3231
Building Permit
450,000.00
50,675.60
492,076.09
109.35
(
42,076.09)
253,353.30
101-3-0000-3.232
Plumbing/Heating Permit
110,000.00
13,004.39
145,626.70
132.39
(
35,626.70)
47,193.31
101-3-0000-3233
Permit Surcharge
500.00
(
227.65)
3,856.22
771.24
(
3,356.22)
3,645.12
101-3-0000-3235
Animal License
0.00
100.00
350.00
0.00
(
350.00)
465.00
101-3-0000-3237
Other Non -Business Lic/Permit
12,000.00
2,175.00
20,150.00
167.92
(
8,150.00)
13,217.50
TOTAL Licenses
& Permits
778,500.00
77,357.34
835,008.63
107.26
(
56,508.63)
450,267.59
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
1,000.00
0.50
199,000.00
1,000.00
101-3-0000-3325
Police 20 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
34,002.19
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
34,002.19
61,809.82
10.26
540,690.IS
57,982.88
Charges
for Services
101-3-0000-3412
Planning & Zoning Fees
25,000.00
2,503.50
12,493.75
49.98
12,506.25
13,804.19
101-3-0000-3413
Plan Check Fee
220,000.00
26,389.84
234,607.95
106.64
(
14,607.95)
102,867.05
101-3-0000-3415
Special Assessment Search
500.00
210.00
920.00
184.00
(
420.00)
330.00
101-3-0000-3417
Copies
1,500.00
66.75
999.18
66.61
500.82
838.07
101-3-0000-3418
Other General Govt Services
500.00
0.00
0.00
0.00
500.00
13.00
101-3-0000-3430
Lockout Fees
5,500.00
240.00
2,500.00
45.45
3,000.00
3,045.00
101-3-0000-3431
Police Services
15,000.00
4,360.00
39,986.83
266.58
(
24,986.83)
9,997.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
50.00
250.00
10.00
2,250.00
550.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
1,760.00
17,610.66
70.44
7,389.34
12,731.00
101-3-0000-3452
Engineering Services Reimb
25,000.00
0.00
5,778.85
23.12
19,221.15
13,296.19
9-14-2021 09:41 AM CITY OF ELK RIVER PAGE: 4
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 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
66.67o
OF YEAR COMPLETED
CURRENT
CURRENT
YEAR TO DATE
o
OF
BUDGET
PRIOR FY
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
YID BALANCE
60,000.00
1,300.00
37,443.00
62.41
22,557.00
12,731.00
30,000.00
1,958.00
19,309.00
64.36
10,691.00
8,058.00
12,000.00
500.00
20,900.01
174.17
( 8,900.01)
10,555.00
10,000.00
0.00
20,262.00
202.62
( 10,262.00)
500.00
20,000.00
504.12
15,002.79
75.01.
4,997.21
17,078.19
12,000.00
2,795.00
12,165.00
101.38
( 165.00)
11,005.00
1,000.00
125.00
940.00
94.00
60.00
755.00
908,500.00
42,762.21
885,908.48
97.51
22,591.52
651,371.40
120,000.00
12,567.76
77,896.26
64.91
42,103.74
56,754.81
0.00
0.00
0.00
0.00
0.00
150.00
0.00
500.00
2,000.00
0.00
( 2,000.00)
0.00
120,000.00
13,067.76
79,896.26
66.58
40,103.74
56,904.81
75,000.00
0.00
50,192.66
66.92
24,807.34
84,110.82
130,000.00
4,295.00
15,478.76
11.91
114,521.24
(
1,480.14)
25,000.00
0.00
19,000.00
76.00
6,000.00
0.00
6,500.00
(
332.64)
9,220.74
141.86
(
2,720.74)
10,075.66
236,500.00
3,962.36
93,892.16
39.70
142,607.84
92,706.34
0.00
0.00
460.00
0.00
(
460.00)
475,56.2.97
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
142,023.57
754,780.61
55.70
600,219.39
731,143.55
121,000.00
0.00
121,000.00
100.00
0.00
1.5,500.00
41,000.00
0.00
41,000.00
100.00
0.00
39,500.00
41,900.00
41,900.00
41,900.00
100.00
0.00
40,700.00
2,421,500.00
183,923.57
1,681,740.61
69.45
739,759.39
2,018,006.52
TOTAL General Fund 17,532,500.00 355,075.43 10,233,524.12 58.37 7,298,975.88 9,409,693.72
TOTAL REVENUE 17,532,500.00 355,075.43 10,233,524.12 58.37 7,298,975.88 9,409,693.72
9-14-2021 09:41 AM CITY OF ELK RIVER PAGE: 1
REVENUE &. EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 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
66.67% OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE
1,521,850.00
35,149.08
457,180.52
30.04
1,064,669.48
150,290.84
61,000.00
2,135.00
87,412.34
143.30
( 26,412.34)
63,399.75
35,000.00
3,740.00
11,611.00
33.17
23,389.00
(
830.00)
139,300.00
0.00
9,515.63
6.83
129,784.37
16,395.14
1,757,150.00
41,024.08
565,719.49
32.20
1,191,430.51
229,255.73
1,324,300.00
109,712.42
689,007.85
52.03
635,292.15
385,738.86
30,150.00
12,385.23
30,258.48
100.36
(
108.48)
23,098.57
19,950.00
571.39
3,032.36
15.20
16,917.64
2,435.51
87,500.00
0.00
1,111.52
1.27
86,388.48
12,793.01
1,461,900.00
122,669.04
723,410.21
49.48
738,489.79
424,065.95
1,461,900.00
122,669.04
723,410.21.
49.48
738,489.7.9
424,065.95
295,250.00
(
81,644.96)(
157,690.72)
452,940.72
(
194,810.22)
J
Q
7
F
U _
0 N
O
F N
W W ~
» D
J m Q
W p
LL (n W
O 0 0
z z
F p W
LL =
U w F
(n z
a
w
w
z
W
0
0 0 0 0
o 0
0
o 0 0 0 o
0
0)
p 0)
N
O
I- O 00 O
O 00 co O
0)
0)
N'
(M
N LO 00 0
(M O O O O
f-
e
01
0) V V O
N N
N
N LO 000
a)
m
LO
LO N
IQ
00
00 IQ O
L
0) LO '
It 00 '
0) LO
O '
O ' ' ' O
'
a0+
ip
p
00 (0
M N
LO It(0
O V
O
lO
(O O
N O
(O
Cl!
(O
Cl!
3
R
O
0)
0)
r N
0)
0)
O
O
M
M
M
M
N
N
N N
N
O
O
R a
Y
COO
O "
O ' 0000
O
O'
O O " ' O
O
' ' O
s= y
O
O
O 0000
O O 01 O
O
01 a
O
O
O O O
O a O
O
O
00
LO
LO
'O
r
r N LO
o0 O
O N
N
N
7
LO
LO LO V
m
1n
U co
I
0
0 0 0 0 '
0 0
0
0 0 0 0 0
0
N
p 0)
Cl)(0
N
Cl)O
M OO to
N
O
Cl)
V
Cl) L 00 0
V U� O O O
(O
e
0)
0) N
N 00
LO
LO 0 00 O
00
m
to
to O O (0
(0 Cl)M
O
V O '
It 0) It r- '
O
co '
co f- ' ' ' O
f-
' f-
d
R
p
(0 Cl)o)
N V
(0 01 'It00
d) r-N
N
(0
It
(0 It
ITa) O
a)
a)
O j
r
00 O d) N
N (O
M
M a N
fz
fz
t7
O
O N
r
r to
N
N
`
d)LO
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 m M
LO 0
M
M N N
O
O
'O
M
M M - 00
M
O LO
In
1n
V
lO
N
U ro
o o o
o 0 0 0 0
0 0
0 0
0 0 o o o o
0
'
N
p 0)
I- O (O
V 00 0)
0) 00 O
V o0 N M O
V
V In
V V
r r
Cl) O 00 O O O
(O r 00 O
O
V
e
00 Cl)
0) 0) 00 (0 O
N M
'ItN
f- 00 00 O
a)
m
LO I: r
to to (O (O
Cl)o)
(0
LO N 0) O
O
O
r
0) 0) O
00 00 O '
00 O
O (0
(0 ' ' O
In
M O N
R
O
(0 LO
00 r
Cl) (0 O
r 0 r
LQ Nt
N
61 O
r 00
(M (0
O 00 O
M W r O
00
N
N (O
O
M O
L
R
O
,It It01
ItI: It(O
I- N
to r 00 O
w00
O f-
3
C)
I� 0)
M
(D "r �N
O
V It IT
o0 00
0- Cl)
V V
d) 00 d) O
N O
N
Cl!
"rIn
f-
N
co
0000
00000
o
o 0
0 o O" O
o
0 0 0
y
0000
O LO O
o O o o
lO 00V O
o O
M o
O O
O_
O O O O
a O O
O
a
00 O
O O a
O
O OO
M O O (O
O 0
Oo
O O O
O
LO In
LONVIt(0OItLOf-
L
O
a)
(M
I- N r (O
M 00
C\lO
(C
�
M
0 0
0 0
0 0 0 0 0
0 0
0
0 0 0 0 0
0
„
N
M I�
N LO
LO M LO LO O
ItI�
r V 00 0
M
p 0)
It00
I�
r V 00 N O
M (O
O O O
(O
e
M
00 (0
(0 LO It N O
Cl)V
Cl)
Cl)N (O O O
f-
I- r
r I-
I- (O (O 00
(O O
r
r O O
co M
O ' ' V
V (0 O '
I- r
(O '
(O Cl) ' ' ' O
M
O ' M
ip
Q
00
(M V
Cl) 00
O0 (O
00 r- d)
(O (O r O
r Cl)
V O
00
lO
00 N O
lO (C O
N
(C
O N
O (C
L
0
R
N to
(O Cl)
Cl) LO N N
O O
(0
(0 (O O
(O
00 00
7
y0
t7
Cl) It
(0 O0
00
r
Cl) LO
(O N
O a)
0) 00
Cl)
Cl) N LO
a)
rr
R Q
lO M
J
}
�
O So
" O
o 00000
O
O'
O O "' o
o
o o
y
000
LO LO
00
O e
LO O O O
0o uQ (° uQ O
LO in
(°
O
O
O in O
O O
LO
O LO
O
0) O)
O MIT
O
VV
(0
�d)(O V�
I� O N
O
N LO
O
N
O O O
N O LO
O
In
O O
M
j 7
(0 V
N
0) M T
V 00
0 r
U CO
r In
N
V3
N
0)
N
C
N
C
R
0)
N x
W 4:
!=
O
R
0)
0
0
0
y
N
C O
W
W d
O
O
R
N
y
O
y
] O Q
w
O
= O
c a
0)
0
o) °
N wR 0)
E
.S
> 2
w
C
co
0
0
w
y w.w0u
Q
Qw
y
w
'vORi
R°°
O 0) O
�
O)
x
icc)
I
Roo
O
U
aEQ
ROm
1)�2
ww
Rrn
c
o Ro
~ ~
R
a 2o
.`o
z
-o
°
Rn
an�o
a
°O
°
Em
U
0
0
z
U
0)O
z
�Na
a
R
°
m
a
`O
9-14-2021 09:39 AM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: AUGUST 31ST, 2021
FUND ACCOUNT# ACCOUNT NAME
CLAIM ON CASH
BEGINNING
BALANCE
CURRENT CURRENT
ACTIVITY BALANCE
002-1010
Cash
- Section 125
8,636.06
1,587.28
10,223.34
101-1010
Cash
- General Fund
8,847,627.97
(
852,746.02)
7,994,881.95
211-1010
Cash
- Library
291,529.22
(
32,811.97)
258,717.25
219-1010
Cash.
- Federal COVID Fund
0.00
1,333,984.96
1,333,984.96
221-1010
Cash
- Multipurpose Facility
105,530.89
(
84,453.67)
21,077.22
225-1010
Cash
- Park Dedication
917,714.11
40,517.73
958,231.84
228-1010
Cash
- Landfill
186,874.44
(
3,664.29)
183,210.15
231-1010
Cash.
- Landfill Const Debris
803,444.38
0.00
803,444.38
240-1010
Cash
- Micro Loan Fund
841,917.87
3,265.07
845,182.94
242-1010
Cash
- State DEED
187,203.83
4,149.90
191,353.73
245-1010
Cash
- Development Fund
1,798,798.09
(
15,315.49)
1,783,482.60
290-1010
Cash.-
Capital Outlay :Reserve
1,514,643.52
9,673.88
1,524,317.40
291-1010
Cash
- Insurance Reserve
25,654.11
9,954.11
35,608.22
292-1010
Cash
- Govt Bldgs Reserve
3,229,549.82
398,455.19
3,628,005.01
294-1010
Cash
- Drug Forfeiture
31,953.22
5,972.55
37,925.77
295-1010
Cash.
- Severance Pay Reserve
78,496.69
0.00
78,496.69
296-1010
Cash
- GRE Reserve
1,045,898.56
0.00
1,045,898.56
301-1010
Cash
- 2020A GO CIP Bonds
4,144.64
0.00
4,144.64
302-1010
Cash
- 2021A GO CIP BONDS
96,000.87
0.00
96,000.87
333-1010
Cash.
- 2020B (2010/2012) Bonds
787,097.33
(
37,541.67)
749,555.66
343-1010
Cash
- 2019A Sales Tax Bonds
2,430,318.30
333,217.07
2,763,535.37
401-1010
Cash
- Pavement Mgmt.
4,374,320.96
637,469.22
5,011,790.18
403-1010
Cash
- Street Improvement
436,282.09
(
19,242.98)
417,039.11
406-1010
Cash.
- City Wide Trunk Util
3,619,391.00
(
78,243.38)
3,541,147.62
410-1010
Cash
- Equipment Replacement
859,150.76
20,535.50
879,686.26
420-1010
Cash
- Active ER
5,081,176.91
(
238,583.27)
4,842,593.64
421-1010
Cash
- PS Building/Fire Sta 3
8,483,566.18
(
963,305.65)
7,520,260.53
440-1010
Cash.
- Park Improvement
419,141.68
8,366.00
427,507.68
463-1010
Cash
- FIT 423 Prof Powder
28,475.59
0.00
28,475.59
602-1010
Cash
- Wastewater Treatment
6,850,096.81
76,277.09
6,926,373.90
603-1010
Cash
- Liquor
4,572,153.89
59,563.69
4,631,717.58
605-1010
Cash.
- Garbage
451,150.85
16,498.36
467,649.21
607-1010
Cash
- Storm Water
1,260,766.46
36,075.27
1,296,841.73
801-1010
Cash
- Interest.
39,980.98
97,283.74
137,264.72
821-1010
Cash
- Developer Escrow
740,543.47
(
9,807.50)
730,735.97
TOTAL CLAIM ON
CASH
60,449,231.55
757,130.72
61,206,362.27
CASH IN BANK - POOLED CASH
999-1000
A/P BANK ACCOUNTS
170,975,736.02
1,819,495.00
172,795,231.02
999-1001
PY BANK ACCOUNT
(138,906,188.35)(
1,062,364.28)(139,968,552.63)
999-1002
POOLED INVESTMENTS
28,382,189.56
0.00
28,382,189.56
SUBTOTAL
CASH IN BANK - POOLED CASH
60,451,737.23
757,130.72
61,208,867.95