3.2 LIBSR 01-25-20223.2
1-19-2022 03:21 PM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: OCTOBER 31ST, 2021
211 -LIBRARY
ACCOUNT $ ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 220,985.40
211-1380 Interest Receivable 1,614.00
222,599.40
TOTAL ASSETS
LIABILITIES
211-2200 Deposits Payable 250.00
TOTAL LIABILITIES
EQUITY
211-2400 Fund Balance 384,665.80
TOTAL BEGINNING EQUITY 384,665.80
TOTAL REVENUE 69,451.42
TOTAL EXPENSES 231,767.82
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 162,316.40)
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
250.00
222,349.40
222,599.40
222,599.40
--------------
--------------
1-19-2022 03:27 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2021
211 -LIBRARY
FINANCIAL SUMMARY
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
83.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
106,500.00
190.27
69,451.42
65.21
37,048.58
106,500.00
190.27
69,451.42
65.21
37,048.58
116,500.00
5,701.24
231,767.82 198.94 (
115,267.82)
116,500.00
5,701.24
231,767.82 198.94 (
115,267.82)
116,500.00
5,701.24
231,767.82 198.94 (
115,267.82)
( 10,000.00)(
5,510.97)(
162,316.40)
152,316.40
1-19-2022 03:27 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2021
211 -LIBRARY
REVENUES
Library
Taxes
CURRENT CURRENT
BUDGET PERIOD
83.33% OF YEAR COMP.
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
211-3-0000-3111
Current Ad Valorem Taxes
71,500.00
0.00
37,529.74
52.49
33,970.26
211-3-0000-3112
Delinquent Ad Valorem Taxes
0.00
0.00
195.18
0.00 (
195.18)
TOTAL Taxes
71,500.00
0.00
37,724.92
52.76
33,775.08
Other Revenue
211-3-0000-3621
Interest Income
7,000.00
190.27
3,726.50
53.24
3,273.50
TOTAL Other
Revenue
7,000.00
190.27
3,726.50
53.24
3,273.50
Transfers In
211-3-0000-3945
Transfer -Utilities
28,000.00
0.00
28,000.00
100.00
0.00
TOTAL Transfers
In
28,000.00
0.00
28,000.00
100.00
0.00
TOTAL Library 106,500.00 190.27 69,451.42 65.21 37,048.58
Library Project
---------------
Other Financing Sources
TOTAL REVENUE 106,500.00 190.27 69,451.42 65.21 37,048.58
1-19-2022 03:27 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2021
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Services & Charges
211-4-5600-4321 Telephone
211-4-5600-4331 Travel, Conferences & Schools
211-4-5600-4359 Publishing
211-4-5600-4361 Insurance
211-4-5600-4389 Utilities
211-4-5600-4401 Bldg Repair/Maint Services
211-4-5600-4404 Equip Repair/Maint Services
211-4-5600-4405 Cleaning Services
211-4-5600-4409 Contractual Services
211-4-5600-4433 Dues & Subscriptions
TOTAL Services & Charges
Canital Outlay
211-4-5600-4520 Buildings & Structures
211-4-5600-4560 Equipment
TOTAL Capital Outlay
TOTAL Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
83.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
10,000.00
26.60
2,815.52
28.16
7,184.48
10,000.00
26.60
2,815.52
28.16
7,184.48
1,100.00
92.75
935.59
85.05
164.41
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,200.00
0.00
3,226.00
100.81 (
26.00)
30,000.00
1,912.38
12,868.06
42.89
17,131.94
17,550.00
1,179.51
21,687.23
123.57 (
4,137.23)
200.00
0.00
0.00
0.00
200.00
30,000.00
2,490.00
19,920.00
66.40
10,080.00
13,700.00
0.00
10,880.00
79.42
2,820.00
100.00
0.00
0.00
0.00
100.00
96,500.00
5,674.64
69,516.88
72.04
26,983.12
0.00
0.00
159,435.42
0.00 (
159,435.42)
10,000.00
0.00
0.00
0.00
10,000.00
10,000.00
0.00
159,435.42
1,594.35 (
149,435.42)
116,500.00
5,701.24
231,767.82
198.94 (
115,267.82)
116,500.00
5,510.97?(
5,701.24
231,767.82
198.94 (
115,267.82)
116,500.00
5,701.24
231,767.82 198.94 (
115,267.82)
------------
! 101000.00)!
5,510.97?(
162,316.40)
152,316.40
1-19-2022 3:32 PM
D E T A I L L I
S T
I N G
PAGE: 1
FUND 211-LIBRARY
ACTIVE ACCOUNTS
ONLY
PERIOD TO USE:
Oct-2021 THRU
Oct-2021
DEPT 5600 Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE IRAN #
REFERENCE
PACKET======DESCRIPTION=====_=
VEND
INV/PO/JE # NOTE
=====AMOUNT====
====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4219
Operating Supplies
B E
G I N N I N G B A L A N
C E
2,788.92
10/08/21 10/08 A21094
CHK: 119049
04169 BULK SALT
13048
26.60
2,815.52
STEP SAVER INC
INV#
146383
/PO#
OCTOBER ACTIVITY DB:
26.60
CR:
0.00
26.60
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B E
G I N N I N G B A L A N
C E
842.84
10/18/21 10/14 A21172
CHK: 119167
04170 PHONE LINE CHGS
11102
92.75
935.59
WINDSTREAM
INV#
100621
/PO#
OCTOBER ACTIVITY DB:
92.75
CR:
0.00
92.75
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B E
G I N N I N G B A L A N
C E
10, 955.68
10/04/21 9/30 A20750
EFT: 002729
04156 WATER/ELECTRIC/SEWER
17700
1,830.61
12,786.29
ELK RIVER MUNICIPAL UTILI
INV#
091521
/PO#
10/04/21 9/30 A20829
EFT: 002734
04156 SEP RUBBISH SVCS
30851
61.26
12,847.55
RANDY'S ENVIRONMENTAL SER
INV#
135818-091921
/PO#
10/25/21 10/26 A21792
CHK: 119176
04187 NATURAL GAS
13845
20.51
12,868.06
CENTERPOINT ENERGY
INV#
6781052-3 SEP
21 /PO#
OCTOBER ACTIVITY DB:
1,912.38
CR:
0.00
1,912.38
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B E
G I N N I N G B A L A N
C E
20, 507.72
10/04/21 9/30 A20576
CHK: 119010
04156 MOWING SVCS CONTRACT
11661
604.71
21,112.43
SPEEDCUTTERS OUTDOOR MAIN
INV#
13823
/PO#
10/08/21 10/08 A21113
CHK: 119050
04169 SECURITY MONITORING
36602
239.40
21,351.83
WRIGHT-HENNEPIN COOP ELEC
INV#
093021
/PO#
10/08/21 10/08 A21113
CHK: 119050
04169 FIRE PANEL MONITORING
36602
335.40
21,687.23
WRIGHT-HENNEPIN COOP ELEC
INV#
093021
/PO#
OCTOBER ACTIVITY DB:
1,179.51
CR:
0.00
1,179.51
------------------------------------------------------------------------------------------------------------------------------------
4.5600-4405
Cleaning Services
B E
G I N N I N G B A L A N
C E
17, 430.00
10/25/21 10/26 A21785
CHK: 119194
04187 CLEANING SVCS - OCT
12651
2,490.00
19,920.00
PERFECTION PLUS, INC.
INV#
113906
/PO#
OCTOBER ACTIVITY DB:
2,490.00
CR:
0.00
2,490.00
1-19-2022 3:32 PM D E T A I L L I S T I N G PAGE: 2
FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Oct -2021 THRU Oct -2021
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
*-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 226,066.58 0.00
REPORTED ACTIVITY: 5,701.24 0.00
ENDING BALANCES: 231,767.82 0.00
TOTAL FUND ENDING BALANCE: 231,767.82
1-19-2022 03:22 PM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: NOVEMBER 30TH, 2021
BALANCE
213,820.41
1,614.00
215,434.41
TOTAL ASSETS 215,434.41
--------------
LIABILITIES
211-2200 Deposits Payable 200.00
TOTAL LIABILITIES 200.00
EQUITY
211-2400 Fund Balance 384,665.80
TOTAL BEGINNING EQUITY 384,665.80
TOTAL REVENUE 69,748.96
TOTAL EXPENSES 239,180.35
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 169,431.39)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 215,234.41
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 215,434.41
1-19-2022 3:33
PM
D E T A I L L I
S T I N G
PAGE: 1
FUND 211 -LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Nov -2021 THRU Nov -2021
DEPT 5600
Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE TRAN #
REFERENCE
PACKET======DESCRIPTION=====_=
VEND INV/PO/JE
# NOTE
=====AMOUNT====
====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4219
Operating Supplies
B
E G I N N I N G B A L A N
C E
2,815.52
11/15/21 11/10 A22553
CHK: 119427
04203 BULK SALT
13048
169.40
2,984.92
STEP SAVER INC
INV# 148098
/PO#
NOVEMBER ACTIVITY DB:
169.40 CR:
0.00
169.40
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N
C E
935.59
11/15/21 11/10 A22482
CHK: 119439
04203 PHONE LING CHGS
11102
93.94
1,029.53
WINDSTREAM
INV# 110821
/PO#
NOVEMBER ACTIVITY DB:
93.94 CR:
0.00
93.94
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
12, 868.06
11/01/21 10/28 A22066
EFT: 002846
04188 WATER/ELECTRIC/SEWER 17700
1,719.91
14,587.97
ELK RIVER MUNICIPAL UTILI
INV# 101321
/PO#
11/01/21 10/28 A22145
EFT: 002853
04188 OCT RUBBISH SVCS
30851
61.25
14,649.22
RANDY'S ENVIRONMENTAL SER
INV# 135818-101921
/PO#
11/23/21 11/23 A23080
CHK: 119455
04216 NATURAL GAS
13845
21.65
14,670.87
CENTERPOINT ENERGY
INV# 6781052-3 OCT
21 /PO#
11/23/21 11/23 A23102
EFT: 002917
04216 WATER/ELECTRIC/SWR
17700
1,890.67
16,561.54
ELK RIVER MUNICIPAL UTILI
INV# 111021
/PO#
NOVEMBER ACTIVITY DB:
3,693.48 CR;
0.00
3,693.48
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N
C E
21, 687.23
11/01/21 10/28 A21915
CHK: 119284
04188 MOWING SVCS CONTRACT 11661
604.71
22,291.94
SPEEDCUTTERS OUTDOOR MAIN
INV# 13964
/PO#
11/15/21 11/10 A22451
CHK: 119368
04203 WINTERIZATION SVCS -LIBRA
10107
361.00
22,652.94
GREAT NORTHERN LANDSCAPES
INV# 14603
/PO#
NOVEMBER ACTIVITY DB:
965.71 CR:
0.00
965.71
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N
C E
19, 920.00
11/23/21 11/23 A23057
CHK: 119480
04216 CLEANING SVCS - NOV
12651
2,490.00
22,410.00
PERFECTION PLUS, INC.
INV# 113959
/PO#
NOVEMBER ACTIVITY DB:
2,490.00 OR,
0.00
2,490.00
1-19-2022 3:33 PM D E T A I L L I S T I N G PAGE: 2
FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Nov -2021 THRU Nov -2021
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 231,767.82 0.00
REPORTED ACTIVITY: 7,412.53 0.00
ENDING BALANCES: 239,180.35 0.00
TOTAL FUND ENDING BALANCE: 239,180.35
1-19-2022 03:30 PM
CITY OF ELK RIVER
7,412.53
239,180.35 205.31 (
PAGE: 1
TOTAL Culture & Recreation
REVENUE & EXPENSE REPORT
(UNAUDITED)
239,180.35 205.31 (
122,680.35)
TOTAL EXPENDITURES
116,500.00
========== ----------------
AS OF: NOVEMBER
30TH, 2021
122,680.35)
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
211 -LIBRARY
169,431.39)
159,431.39
FINANCIAL SUMMARY
91.67%
OF YEAR COMP.
CURRENT
CURRENT
YEAR TO DATE
% 0£
BUDGET
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
REVENUE SUMMARY
Library
106,500.00
297.54
69,748.96
65.49
36,751.04
TOTAL REVENUES
106,500.00
------------- -------------
297.54
69,748.96
-------------
65.49
-------
36,751.04
-------------
EXPENDITURE SUMMARY
Culture & Recreation
Library
116,500.00
7,412.53
239,180.35 205.31 (
122,680.35)
TOTAL Culture & Recreation
116,500.00
7,412.53
239,180.35 205.31 (
122,680.35)
TOTAL EXPENDITURES
116,500.00
========== ----------------
7,412.53
-------------
239,180.35 205.31 (
------- -------------
122,680.35)
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
7,114.99)(
169,431.39)
159,431.39
1-19-2022 03:30 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: NOVEMBER 30TH, 2021
211 -LIBRARY
REVENUES
Library
Taxes
211-3-0000-3111 Current Ad Valorem Taxes
211-3-0000-3112 Delinquent Ad Valorem Taxes
TOTAL Taxes
Other Revenue
211-3-0000-3621 Interest Income
TOTAL Other Revenue
Transfers In
211-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
91.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
71,500.00 0.00 37,529.74 52.49 33,970.26
0.00 0.00 195.18 0.00 ( 195.18)
71,500.00 0.00 37,724.92 52.76 33,775.08
7,000.00 297.54 4,024.04 57.49 2,975.96
7,000.00 297.54 4,024.04 57.49 2,975.96
28,000.00 0.00 28,000.00 100.00 0.00
28,000.00 0.00 28,000.00 100.00 0.00
TOTAL Library 106,500.00 297.54 69,748.96 65.49 36,751.04
Library Project
Other Financing Sources
TOTAL REVENUE 106,500.00 297.54 69,748.96 65.49 36,751.04
1-19-2022 03:30 PM
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: NOVEMBER 30TH, 2021
91.67°% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
211-4-5600-4219
Operating Supplies
10,000.00
169.40
2,984.92
29.85
7,015.08
TOTAL Supplies
10,000.00
169.40
2,984.92
29.85
7,015.08
Services & Charges
211-4-5600-4321
Telephone
1,100.00
93.94
1,029.53
93.59
70.47
211-4-5600-4331
Travel, Conferences & Schools
150.00
0.00
0.00
0.00
150.00
211-4-5600-4359
Publishing
500.00
0.00
0.00
0.00
500.00
211-4-5600-4361
Insurance
3,200.00
0.00
3,226.00
100.81 (
26.00)
211-4-5600-4389
Utilities
30,000.00
3,693.48
16,561.54
55.21
13,438.46
211-4-5600-4401
Bldg Repair/Maint Services
17,550.00
965.71
22,652.94
129.08 (
5,102.94)
211-4-5600-4404
Equip Repair/Maint Services
200.00
0.00
0.00
0.00
200.00
211-4-5600-4405
Cleaning Services
30,000.00
2,490.00
22,410.00
74.70
7,590.00
211-4-5600-4409
Contractual Services
13,700.00
0.00
10,880.00
79.42
2,820.00
211-4-5600-4433
Dues & Subscriptions
100.00
0.00
0.00
0.00
100.00
TOTAL Services & Charges
96,500.00
7,243.13
76,760.01
79.54
19,739.99
Capital Outlay
211-4-5600-4520
Buildings & Structures
0.00
0.00
159,435.42
0.00 (
159,435.42)
211-4-5600-4560
Equipment
10,000.00
0.00
0.00
0.00
10,000.00
TOTAL Capital Outlay
10,000.00
0.00
159,435.42
1,594.35 (
149,435.42)
TOTAL Library
116,500.00
7,412.53
239,180.35
205.31 (
122,680.35)
TOTAL Culture & Recreation
116,500.00 7,412.53 239,180.35 205.31 ( 122,680.35)
TOTAL EXPENDITURES
116,500.00
7,412.53
239,180.35 205.31 (
122,680.35)
------------
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
7,114.99)(
169,431.39)
159,431.39
1-19-2022 03:24 PM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: DECEMBER 31ST, 2021
BALANCE
241,214.41
1,614.00
242,828.41
TOTAL ASSETS 242,828.41
--------------
--------------
LIABILITIES
211-2020 A/P - Library 2,632.23
211-2200 Deposits Payable 100.00
TOTAL LIABILITIES 2,732.23
EQUITY
211-2400 Fund Balance 384,665.80
TOTAL BEGINNING EQUITY 384,665.80
TOTAL REVENUE 102,211.72
TOTAL EXPENSES 246,781.34
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 144,569.62)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 240,096.18
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 242,828.41
1-19-2022 03:30 PM CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: DECEMBER 31ST, 2021
211 -LIBRARY
FINANCIAL SUMMARY
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
PAGE: 1
100.00% OF YEAR COMP.
% OF BUDGET
BUDGET BALANCE
106,500.00
32,462.76
102,211.72
95.97
4,288.28
106,500.00
32,462.76
102,211.72
95.97
4,288.28
116,500.00
7,600.99
246,781.34 211.83 (
130,281.34)
116,500.00
7,600.99
246,781.34 211.83 (
130,281.34)
116,500.00
7,600.99
246,781.34 211.83 (
130,281.34)
( 10,000.00)
24,861.77 (
144,569.62)
134,569.62
1-19-2022 03:30 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: DECEMBER 31ST, 2021
211 -LIBRARY
100.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
Library
Taxes
211-3-0000-3111
Current Ad Valorem Taxes
71,500.00
32,483.12
70,012.86
97.92
1,487.14
211-3-0000-3112
Delinquent Ad Valorem Taxes
0.00 {
20.36)
174.82
0.00 (
174.82)
TOTAL Taxes
71,500.00
32,462.76
70,187.68
98.16
1,312.32
Other Revenue
211-3-0000-3621
Interest Income
7,000.00
0.00
4,024.04
57.49
2,975.96
TOTAL Other
Revenue
7,000.00
0.00
4,024.04
57.49
2,975.96
Transfers In
211-3-0000-3945
Transfer -Utilities
28,000.00
0.00
28,000.00
100.00
0.00
TOTAL Transfers
In
28,000.00
0.00
28,000.00
100.00
0.00
TOTAL Library 106,500.00 32,462.76 102,211.72 95.97 4,288.28
Library Project
---------------
---------------
Other Financia Sources
TOTAL REVENUE 106,500.00 32,462.76 102,211.72 95.97 4,288.28
1-19-2022 03:30 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: DECEMBER 31ST, 2021
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Services & Charges
211-4-5600-4321 Telephone
211-4-5600-4331 Travel, Conferences & Schools
211-4-5600-4359 Publishing
211-4-5600-4361 Insurance
211-4-5600-4389 Utilities
211-4-5600-4401 Bldg Repair/Maint Services
211-4-5600-4404 Equip Repair/Maint Services
211-4-5600-4405 Cleaning Services
211-4-5600-4409 Contractual Services
211-4-5600-4433 Dues & Subscriptions
TOTAL Services & Charges
Capital Outlay
211-4-5600-4520 Buildings & Structures
211-4-5600-4560 Equipment
TOTAL Capital Outlay
10,000.00
459.38
3,444.30
100.00%
OF YEAR COMP.
CURRENT
CURRENT
YEAR TO DATE
% OF
BUDGET
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
10,000.00
459.38
3,444.30
34.44
6,555.70
10,000.00
459.38
3,444.30
34.44
6,555.70
1,100.00
92.62
1,122.15
102.01 (
22.15)
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,200.00
0.00
3,226.00
100.81 (
26.00)
30,000.00
2,563.99
19,125.53
63.75
10,874.47
17,550.00
1,995.00
24,647.94
140.44 (
7,097.94)
200.00
0.00
0.00
0.00
200.00
30,000.00
2,490.00
24,900.00
83.00
5,100.00
13,700.00
0.00
10,880.00
79.42
2,820.00
100.00
0.00
0.00
0.00
100.00
96,500.00
7,141.61
83,901.62
86.94
12,598.38
0.00
0.00
159,435.42
0.00 (
159,435.42)
10,000.00
0.00
0.00
0.00
10,000.00
10,000.00
0.00
159,435.42
1,594.35 (
149,435.42)
TOTAL Library 116,500.00 7,600.99 246,781.34 211.83 ( 130,281.34)
TOTAL Culture & Recreation
116,500.00 7,600.99 246,781.34 211.83 ( 130,281.34)
TOTAL EXPENDITURES
116,500.00
7,600.99
246,781.34 211.83 (
130,281.34)
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)
24,861.77 (
144,569.62)
134,569.62
1-19-2022 3:34 PM
D E T A I L L I
S T
I N G
PAGE: 1
FUND 211
-LIBRARY
ACTIVE ACCOUNTS
ONLY
PERIOD TO USE:
Dec -2021 THRU
Dec -2021
DEPT 5600 Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE IRAN #
REFERENCE
PACKET======DESCRIPTION=====_=
VEND INV/PO/JE # NOTE
=====AMOUNT==—
====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4219
Operating
Supplies
B
E G I N N I N G B A L A N
C E
2,984.92
12/20/21 12/16 A24147
CHK: 119646
04241 SUPPLIES
15887
148.68
3,133.60
DACOTAH PAPER CO
INV#
19114
/PO#
12/20/21 12/16 A24151
CHK: 119646
04241 GLOVES, TOWEL ROLLS,CLNR
15887
310.70
3,444.30
DACOTAH PAPER CO
INV#
19478
/PO#
DECEMBER ACTIVITY DB:
459.38
CR:
0.00
459.38
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N
C E
1,029.53
12/20/21 12/16 A23969
CHK: 119741
04241 PHONE LINE CHGS
11102
92.62
1,122.15
WINDSTREAM
INV#
120721
/PO#
------------=
DECEMBER ACTIVITY DB:
92.62 CR:
0.00
92.62
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
16,561.54
12/06/21 12/02 A23609
EFT: 002968
04221 NOV RUBBISH SVCS
30851
61.25
16,622.79
RANDY'S ENVIRONMENTAL SER
INV#
135818-111921
/PO#
12/20/21 12/16 A24087
CHK: 119637
04241 NATURAL GAS
13845
20.51
16,643.30
CENTERPOINT ENERGY
INV#
6781052-3 NOV
21 /PO#
12/31/21 12/29 A24997
EFT: 003111
04261 WATER/ELECTRIC/SWR
17700
2,420.98
19,064.28
ELK RIVER MUNICIPAL UTILI
INV#
121521
/PO#
12/31/21 1/11 A25366
EFT: 003131
04279 DEC RUBBISH SVCS
30851
61.25
19,125.53
RANDY'S ENVIRONMENTAL SER
INV#
135818-122021
/PO#
DECEMBER ACTIVITY DB:
2,563.99
CR:
0.00
2,563.99
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N
C E
22, 652.94
12/06/21 12/02 A23519
CHK: 119524
04221 EXTERIOR WINDOW CLNG
16448
205.00
22,857.94
DISTINCTIVE WINDOW CLEANI
INV#
20420
/PO#
12/06/21 12/02 A23579
CHK: 119551
04221 INSTALL PREFINISHED
CAP
25031
1,790.00
24,647.94
MCDOWALL COMPANY
INV#
17059
/PO#
DECEMBER ACTIVITY DB:
1,995.00 CR:
0.00
1,995.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N
C E
22, 410.00
1-19-2022 3:34 PM
D E T A I L L I S T I N G
PAGE: 2
FUND
211 -LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE: Dec -2021 THRU Dec -2021
DEPT
5600 Library SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE
TRAN # REFERENCE
PACKET======DESCRIPTION=====_- VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
12/20/21 12/16
A24007 CHK: 119704
04241 CLEANING SVCS - DEC 12651
2,490.00 24,900.00
PERFECTION PLUS, INC. INV# 114017
/PO#
DECEMBER ACTIVITY DB: 2,490.00 CR:
0.00 2,490.00
*-*-*-*-*-*-*-*-*-*-*-*-*-
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS ---
--- CREDITS ---
BEGINNING BALANCES: 239,180.35
0.00
REPORTED ACTIVITY: 7,600.99
0.00
ENDING BALANCES: 246,781.34
0.00
TOTAL FUND ENDING BALANCE: 246,781.34