3.2 Library Financial Summary7-06-2023 01:34 PM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: APRIL 30TH, 2023
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 244,196.10
211-1380 Interest Receivable 1,126.00
245,322.10
TOTAL ASSETS
LIABILITIES
EQUITY
211-2400 Fund Balance
241,203.19
TOTAL BEGINNING EQUITY
241,203.19
TOTAL REVENUE
29,007.68
TOTAL EXPENSES
24,888.77
TOTAL REVENUE OVER/(UNDER) EXPENSES
4,118.91
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
245,322.10
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER)
EXP.
245,322.10
--------------
245,322.10
--------------
--------------
7-06-2023 01:35 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2023
211 -LIBRARY
FINANCIAL SUMMARY
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
CURRENT
BUDGET
33.33% OF YEAR COMP.
CURRENT YEAR TO DATE % OF BUDGET
PERIOD ACTUAL BUDGET BALANCE
108,000.00
0.00
29,007.66
26.86
78,992.32
118,000.00
108,000.00
0.00
29,007.68
26.86
78,992.32
116,000.00
7,437.85
24,868.77 21.09
93,111.23
118,000.00
7,437.85
24,888.77 21.09
93,111.23
118,000.00
7,437.85
24,888.77 21.09
93,111.23
( 10,000.00)(
7,437.85)
4,118.91 (
14,114.91)
7-06-2023 01:35 PM
CITY OF ELK RIVER
PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2023
211 -LIBRARY
33.33%
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
TOTAL Taxes
Other Revenue
211-3-0000-3621 Interest Income
TOTAL Other Revenue
Transfers In
211-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
TOTAL Library
Library Project
---------------
Other Financinu Sources
TOTAL REVENUE
75,000.00 0.00 0.00 0.00 75,000.00
75,000.00 0.00 0.00 0.00 75,000.00
5,000.00 0.00 1,007.68 20.15 3,992.32
5,000.00 0.00 1,007.68 20.15 3,992.32
28,000.00 0.00 28,000.00 100.00 0.00
28,000.00 0.00 28,000.00 100.00 0.00
108,000.00 0.00 29,007.68 26.86 78,992.32
108,000.00 0.00 29,007.68 26.86 78,992.32
7-06-2023 01:35 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2023
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-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
TOTAL Services & Charges
Capital outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
TOTAL Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
CURRENT
BUDGET
33.33% OF YEAR COMP,
CURRENT YEAR TO DATE % OF BUDGET
PERIOD ACTUAL BUDGET BALANCE
6,000.00
0.00
933.03
15.55
5,066.97
6,000.00
0.00
933.03
15.55
5,066.97
1,200.00
100.42
406.54
33.88
793.46
500.00
0.00
0.00
0.00
500.00
7,000.00
0.00
2,655.90
37.94
4,344.10
31,100.00
3,044.18
6,952.55
22.36
24,147.45
19,800.00
3,993.25
13,340.75
67.38
6,459.25
200.00
0.00
0.00
0.00
200.00
35,000.00
0.00
0.00
0.00
35,000.00
7,200.00
300.00
600.00
8.33 _
6,600.00
102,000.00
7,437.85
23,955.74
23.49
76,044.26
10,000.00
0.00
0.00
0.00
10,000.00
10,000.00
0.00
0.00
0.00
10,000.00
118,000.00
7,437.85
24,888.77
21.09
93,111.23
118,000.00 7,437.85 24,888.77 21.09 93,111.23
118,000.00
-------------
7,437.85
24,888.77 21.09
93,111.23
( 10,000.00)(
7,437.85)
4,118.91 (
14,118.91)
7-06-2023 1:36 PM D E T A I L L I S T
I N G
PAGE:
1
FUND 211 -LIBRARY
PERIOD TO USE: Apr -2023 THRU
Apr -2023
DEPT 5600 Library SUPPRESS
ZEROS
ACCOUNTS: 3-0000-3111
THRU
4-5600-4560
POST DATE TRAN #
REFERENCE PACKET======DESCRIPTION=====_=
VEND
INV/JE #
NOTE =====AMOUNT====
====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B E G I N N I N G B A L A N C E
306.12
4/17/23 4/13 A45587
CHK: 124187 04863 PHONE LINE CHGS
11102
040523
100.42
406.54
APRIL ACTIVITY DB:
100.42
CR:
0.00
100.42
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B E G I N N I N G B A L A N C E
3,908.37
4/03/23 3/30 A45152
EFT: 004706 04853 WATER/ELECTRIC/SEWER
17700
031523
2,956.58
6,864.95
4/17/23 4/13 A45572
CHK: 124160 04863 MAR COMM GARBAGE SVC
10407
899-004179045
61.25
6,926.20
4/17/23 4/13 A45686
CHK: 124104 04863 NATURAL GAS
13845
6781052-3 MAR 23
26.35
6,952.55
------------- APRIL ACTIVITY DB: 3,044.18
CR:
0.00
3,044.18
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B E G I N N I N G B A L A N C E
9,347.50
4/03/23 3/30 A45015
EFT: 004689 04853 FIRE EXTINGUISHER SVCS
11955
137014
39.00
9,386.50
4/03/23 3/30 A45148
CHK: 123978 04853 EXTERIOR WINDOW CLNG
16448
22736
228.00
9,614.50
4/17/23 4/13 A45634
CHK: 124153 04863 CLEANING SVCS - APR
12651
214652
2,490.00
12,104.50
4/24/23 4/24 A46068
CHK: 124202 04880 MOWING SVCS CONTRACT FAL 11661
14561
1,236.25
13,340.75
------------- APRIL ACTIVITY DB: 3,993.25
CR:
0.00
3,993.25
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409
Contractual Services
B E G I N N I N G B A L A N C E
300.00
4/17/23 4/13 A45731
CHK: 124115 04863 STORYTIME WITH CRAFT -APR 14941
042423
300.00
600.00
APRIL ACTIVITY DB: 300.00
CR:
0.00
300.00
*-*-*-*-*-*-*-*-*-*-*-*-*-
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** ---
DEBITS
---
--- CREDITS ---
BEGINNING BALANCES:
17,450.92
29,007.68CR
REPORTED ACTIVITY:
7,437.85
0.00
ENDING BALANCES:
24,888.77
29,007.68CR
TOTAL FUND ENDING BALANCE:
4,118.91CR
7-06-2023 01:37 PM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: MAY 31ST, 2023
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
TOTAL ASSETS
LIABILITIES
EQUITY
211-2400 Fund Balance
TOTAL BEGINNING EQUITY
TOTAL REVENUE
TOTAL EXPENSES
TOTAL REVENUE OVER/(UNDER) EXPENSES
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
BALANCE
227,933.97
1,126.00
229,059.97
241,203.19
241,203.19
29,007.68
41,150.90
( 12,143.22)
229,059.97
229,059.97
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 229,059.97
7-06-2023 01:38 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2023
211 -LIBRARY
FINANCIAL SUMMARY
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
108,000.00
0.00
29,007.68
26.86
78,992.32
16,262.13
41,150.90 34.87
108,000.00
0.00
29,007.68
26.86
78,992.32
118,000.00
16,262.13
41,150.90 34.87
76,849.10
118,000.00
16,262.13
41,150.90 34.87
76,849.10
118,000.00
16,262.13
41,150.90 34.87
76,849.10
( 10,000.00)(
16,262.13)(
12,143.22)
2,143.22
7-06-2023 01:38 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2023
211 -LIBRARY
REVENUES
Library
Taxes
211-3-0000-3111 Current 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
TOTAL Library
Library Project
--------------
---------------
Other Financing Sources
75,000.00
0.00
41.67%
OF YEAR COMP.
CURRENT
CURRENT YEAR TO DATE
% OF
BUDGET
BUDGET
PERIOD ACTUAL
BUDGET
BALANCE
75,000.00
0.00
0.00
0.00
75,000.00
75,000.00
0.00
0.00
0.00
75,000.00
5,000.00
0.00
1,007.68
20.15
3,992.32
5,000.00
0.00
1,007.68
20.15
3,992.32
28,000.00.
0.00
28,000.00
100.00
0.00
28,000.00
0.00
28,000.00
100.00
0.00
108,000.00 0.00 29,007.68 26.86 78,992.32
TOTAL REVENUE 108,000.00 0.00 29,007.68 26.66 78,992.32
7-06-2023 01:38 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2023
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-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
TOTAL Services & Charges
Capitallay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
6,000.00
6,272.20
7,205.23
120.09 (
1,205.23)
6,000.00
6,272.20
7,205.23
120.09 (
1,205.23)
1,200.00
100.42
506.96
42.25
693.04
500.00
0.00
0.00
0.00
500.00
7,000.00
0.00
2,655.90
37.94
4,344.10
31,100.00
5,342.28
12,294.83
39.53
18,805.17
19,800.00
659.96
14,000.71
70.71
5,799.29
200.00
0.00
0.00
0.00
200.00
35,000.00
2,490.00
2,490.00
7.11
32,510.00
7,200.00
1,397.27
1,997.27
27.74
5,202.73
102,000.00
9,989.93
33,945.67
33.28
66,054.33
10,000.00
0.00
0.00
0.00
10,000.00
10,000.00
0.00
0.00
0.00
10,000.00
TOTAL Library
118,000.00
16,262.13
41,150.90 34.87
76,849.10
TOTAL Culture & Recreation
118,000.00
16,262.13
41,150.90 34.87
76,849.10
TOTAL EXPENDITURES
118,000.00
16,262.13
41,150.90 34.87
-------------
76,849.10
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
16,262.13)(
12,143.22)
2,143.22
7-06-2023 1:38
PM
D E T A I L L I S T I
N G
PAGE: 1
FUND
211 -LIBRARY
PERIOD TO USE:
May -2023 THRU May -2023
DEPT
5600
Library
SUPPRESS ZEROS
ACCOUNTS: 3-0000-3111
THRU 4-5600-4560
POST
DATE TRAN #
REFERENCE
PACKET======DESCRIPTION=====_=
VEND INV/PO/JE #
NOTE
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4219
Operating Supplies
B E G I N N I N G B A L A N C E
933.03
5/01/23
4/27 A46243
CHK: 124219
04883 BULK SALT
13048
165.00
1,098.03
STEP SAVER INC INV#
163371
/PO#
5/01/23
4/27 A46420
CHK: 124257
04883 SUPPLIES
27000
416.44
1,514.47
MINVALCO, INC INV#
283304
/PO#
5/15/23
5/11 A46740
CHK: 124343
04897 REUPHOLSTER CHAIRS -LIBRA
10299
5,550.00
7,064.47
COLBATH UPHOLSTERY SERVIC INV#
34479
/PO#
5/15/23
5/11 A47008
EFT: 004854
04897 SUPPLIES
20300
44.76
7,109.23
GRAINGER INV#
9689229756
/PO#
5/25/23
5/26 A47471
CHK: 124459
04917 SUPPLIES
15867
96.00
7,205.23
DACOTAH PAPER CO INV#
60052
/PO#
-------------
MAY ACTIVITY DB: 6,272.20 CR:
0.00
6,272.20
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N C E
406.54
5/15/23
5/11 A46780
CHK: 124440
04897 PHONE LINE CHGS
11102
100.42
506.96
WINDSTREAM INV#
050323
/PO#
MAY ACTIVITY DB: 100.42 CR:
0.00
100.42
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N 1 N G B A L A N C E
6,952.55
5/01/23
4/27 A46343
EFT: 004800
04883 WATER/ELECTRIC/SEWER
17700
2,535.66
9,488.21
ELK RIVER MUNICIPAL UTILI INV#
041223
/PO#
5/15/23
5/11 A46743
CHK: 124415
04897 APR COMM GARBAGE SVC
10407
61.25
9,549.46
REPUBLIC SERVICES #899 INV#
899-004197786
/PO#
5/15/23
5/11 A46903
CHK: 124337
04897 NATURAL GAS
13845
278.23
9,827.69
CENTERPOINT ENERGY INV#
6781052-3 APR 23
/PO#
5/16/23
5/16 A47352
VOID- 123829
04910 REVERSE VOIDED CHECK
13845
43.80CR
9,783.89
CENTERPOINT ENERGY INV#
6761052-3 FEB 23
/PO#
5/16/23
5/16 A47358
CHK: 124442
04911 NATURAL GAS
13845
43.80
9,827.69
CENTERPOINT ENERGY INV#
6781052-3 02/23
/PO#
5/25/23
5/26 A47476
EFT: 004876
04917 WATER/ELECTRIC/SEWER
17700
2,467.14
12,294.83
ELK RIVER MUNICIPAL UTILI INV#
051023
/PO#
------------
MAY ACTIVITY DB: 5,386.08
CR:
43.80CR
5,342.28
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N C E
13, 340.75
7-06-2023 1:38 PM
D E T A I L L I S T
I N G
PAGE:
2
FUND
211 -LIBRARY
PERIOD TO USE: May -2023
THRU
May -2023
DEPT
5600
Library SUPPRESS ZEROS
ACCOUNTS: 3-0000-3111
THRU
4-5600-4560
POST DATE
TRAN #
REFERENCE
PACKET======DESCRIPTION------=
VEND INV/PO/JE
# NOTE =====AMOUNT====
====BALANCE====
5/15/23 5/11
A46937
CHK:
124331 04897 PEST CONTROL -LIBRARY
14717
82.50
13,423.25
BLACKHAWK PEST CONTROL, L INV#
16058
/PO#
5/15/23 5/11
A47109
EFT:
004865 04897 REPAIR PIPE
36620
577.46
14,000.71
YALE MECHANICAL LLC INV#
245001
/PO#
-------------
MAY ACTIVITY DB: 659.96 CR:
0.00
659.96
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B E G I N N I N G B A L A N C E
0.00
5/25/23 5/26
A47438
CHK:
124486 04917 CLEANING SVCS - MAY
12651
2,490.00
2,490.00
PERFECTION PLUS, INC. INV#
214693
/PO#
-------------
MAY ACTIVITY DB: 2,490.00 CR:
0.00
2,490.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409
Contractual Services
B E G I N N I N G B A L A N C E
600.00
5/01/23 4/27
A46317
CHK:
124271 04883 STORY TELLER -JAMES GANG
14969
200.00
800.00
CHARLES THOMAS RYTHER INV#
050623
/PO#
5/01/23 4/27
A46318
CHK:
124271 04883 STORY TELLER -HIST OF JOU
14969
200.00
1,000.00
CHARLES THOMAS RYTHER INV#
051323
/PO#
5/15/23 5/11
A46797
CHK:
124425 04897 IRRIGATION SVC -LIBRARY
11661
378.00
1,378.00
SPEEDCUTTERS OUTDOOR MAIN INV#
24561
/PO#
5/15/23 5/11
A46798
CHK:
124425 04897 IRRIGATION SVC -LIBRARY
11661
319.27
1,697.27
SPEEDCUTTERS OUTDOOR MAIN INV#
24562
/PO#
5/15/23 5/11
A46942
CHK:
124346 04897 STORYTIME WITH CRAFT -MAY
14941
300.00
1,997.27
MARILYN L DIRKSWAGER INV#
052223
/PO#
MAY ACTIVITY DB: 1,397.27 CR:
0.00
1,397.27
*-*-*-*-*-*-*-*-*-*-*-*-*-
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** ---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
24,888.77
29,007.68CR
REPORTED ACTIVITY:
16,305.93
43.80CR
ENDING BALANCES:
41,194.70
29,051.48CR
TOTAL FUND ENDING BALANCE:
12,143.22
7-06-2023 01:39 PM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
TOTAL ASSETS
LIABILITIES
EQUITY
211-2400 Fund Balance
TOTAL BEGINNING EQUITY
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: NNE 30TH, 2023
BALANCE
218,478.04
1,126.00
219,604.04
241,203.19
241,203.19
TOTAL REVENUE 29,007.68
TOTAL EXPENSES 50,606.83
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 21,599.151
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 219,604.04
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
219,604.04
219,604.04
7-06-2023 01:40 PM
CITY OF ELK
RIVER
PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2023
211 -LIBRARY
FINANCIAL SUMMARY
50.00%
OF YEAR COMP.
CURRENT
CURRENT
YEAR TO DATE
% OF
BUDGET
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
REVENUE SUMMARY
Library
108,000.00
0.00
29,007.68
26.86
78,992.32
TOTAL REVENUES
108,000.00
-------------
0.00
-------------
29,007.68
-------------
26.86
-------
78,992.32
-------------
EXPENDITURE SUMMARY
Culture & Recreation
Library
118,000.00
9,455.93
50,606.83
42.89
67,393.17
TOTAL Culture & Recreation
118,000.00
9,455.93
50,606.83
42.89
67,393.17
TOTAL EXPENDITURES
118,000.00
9,455.93
50,606.83
42.89
67,393.17
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
9,455.93)(
21,599.15)
11,599.15
7-06-2023 01:40 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2023
211 -LIBRARY
REVENUES
Library
Taxes
211-3-0000-3111 Current 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
TOTAL Library
Library Project
Other Financing Sources
TOTAL REVENUE
50.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
75,000.00
0.00
0.00
0.00
75,000.00
75,000.00
0.00
0.00
0.00
75,000.00
5,000.00
0.00
1,007.68
20.15
3,992.32
5,000.00
0.00
1,007.68
20.15
3,992.32
26,000.00
0.00
28,000.00
100.00
0.00
28,000.00
0.00
28,000.00
100.00
0.00
108,000.00
0.00
29,007.68
26.86
78,992.32
108,000.00 0.00 29,007.68 26.86 78,992.32
7-06-2023 01:40 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2023
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-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
TOTAL Services & Charges
Capital outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
TOTAL Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
50.00°% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
6,000.00
21.99
7,227.22
120.45 (
1,227.22)
6,000.00
21.99
7,227.22
120.45 (
1,227.22)
1,200.00
100.42
607.38
50.62
592.62
500.00
0.00
0.00
0.00
500.00
7,000.00
0.00
2,655.90
37.94
4,344.10
31,100.00
4,913.95
17,208.78
55.33
13,891.22
19,800.00
0.00
14,000.71
70.71
5,799.29
200.00
0.00
0.00
0.00
200.00
35,000.00
2,490.00
4,980.00
14.23
30,020.00
7,200.00
1,929.57
3,926.84
54.54
3,273.16
102,000.00
9,433.94
43,379.61
42.53
58,620.39
10,000.00 0.00 0.00 0.00 10,000.00
10,000.00 0.00 0.00 0.00 10,000.00
118,000.00
9,455.93
50,606.83 42.89
67,393.17
118,000.00
9,455.93
50,606.83 42.89
67,393.17
118,000.00
9,455.93
50,606.83 42.89
67,393.17
( 10,000.00)(
9,455.93)(
21,599.15)
11,599.15
7-06-2023 1:40
PM
D E T A I L L I S T I N G
PAGE: 1
FUND 211 -LIBRARY
PERIOD TO USE:
Jun -2023 THRU Jun -2023
DEPT 5600
Library
SUPPRESS ZEROS
ACCOUNTS: 3-0000-3111
THRU 4-5600-4560
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
7,205.23
6/05/23 6/01 A47977
EFT: 004918
04918 SUPPLIES 25145
21.99
7,227.22
MENARDS - ELK RIVER INV# 043023-1
/PO#
------------=
JUNE ACTIVITY DB: 21.99 CR:
0.00
21.99
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B E
G I N N I N G B A L A N C E
506.96
6/20/23 6/15 A48368
CHK: 124744
04935 PHONE LINE CHGS 11102
100.42
607.38
WINDSTREAM INV# 060523
/PO#
-------------
JUNE ACTIVITY DB: 100.42 CR:
0.00
100.42
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B E
G I N N I N G B A L A N C E
12,294.83
6/08/23 6/09 A48197
CHK: 124624
04934 MAY COMM GARBAGE SVC 10407
61.25
12,356.08
REPUBLIC SERVICES #899 INV# 899-004224667
/PO#
6/20/23 6/15 A48500
CHK: 124655
04935 NATURAL GAS 13845
1,208.70
13,564.78
CENTERPOINT ENERGY INV# 6781052-3 MAY
23 /PO#
6/26/23 6/27 A49008
EFT: 004981
04951 WATER/ELECTRIC/SEWER 17700
3,644.00
17,208.78
ELK RIVER MUNICIPAL UTILI INV# 061423
/PO#
JUNE ACTIVITY DB: 4,913.95 CR:
0.00
4,913.95
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B E
G I N N I N G B A L A N C E
2,490.00
6/20/23 6/15 A48423
CHK: 124714
04935 CLEANING SVCS - JUN 12651
2,490.00
4,980.00
PERFECTION PLUS, INC. INV# 314736
/PO#
JUNE ACTIVITY DB: 2,490.00 CR:
0.00
2,490.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409
Contractual
Services
B E G I N N I N G B A L A N C E
1,997.27
6/20/23 6/15 A48534
CHK: 124665
04935 STORYTIME WITH CRAFT -JUN 14941
150.00
2,147.27
MARILYN L DIRKSWAGER INV# 063023
/PO#
6/20/23 6/15 A48543
CHK: 124666
04935 BEADING WORKSHOP 6/24/23 15009
700.00
2,847.27
DEBRA EDWARDS INV# 062423
/PO#
6/26/23 6/27 A48954
CHK: 124792
04951 MOWING & FERTILIZER SVCS 11661
654.57
3,501.64
SPEEDCUTTERS OUTDOOR MAIN INV# 24771
/PO#
7-06-2023 1:40 PM
D E T A I L L I S T
I N G
PAGE: 2
FUND 211 -LIBRARY
PERIOD TO USE: Jun -2023 THRU Jun -2023
DEPT 5600 Library SUPPRESS ZEROS
ACCOUNTS: 3-0000-3111 THRU 4-5600-4560
POST DATE TRAN # REFERENCE
PACKET======DESCRIPTION=======
VEND INV/PO/JE
# NOTE =====AMOUNT==== ====BALANCE----
6/26/23 6/27 A48991 CHK: 124794
04951 WILDLIFE SHOW 7/10/23
14895
425.00 3,926.84
SUSTAINABLE SAFARI INV#
5334
/PO#
JUNE ACTIVITY DB: 1,929.57
CR:
0.00 1,929.57
*-*-*-*-*-*-*-*-*-*-*-*-*-
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** ---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
41,150.90
29,007.68CR
REPORTED ACTIVITY:
9,455.93
0.00
ENDING BALANCES:
50,606.83
29,007.68CR
TOTAL FUND ENDING BALANCE:
21,599.15
10-17-2023 10:53 AM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
TOTAL ASSETS
LIABILITIES
EQUITY
211-2400 Fund Balance
TOTAL BEGINNING EQUITY
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: JULY 31ST, 2023
BALANCE
251,528.05
1,126.00
252,654.05
241,203.19
241,203.19
TOTAL REVENUE 70,086.25
TOTAL EXPENSES 58,635.39
TOTAL REVENUE OVER/(UNDER) EXPENSES 11,450.86
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 252,654.05
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 252,654.05
252,654.05
10-17-2023 10:56 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2023
211 -LIBRARY
FINANCIAL SUMMARY
58.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Library 108,000.00 12,348.92 70,086.25 64.89 _ 37-913.15
TOTAL REVENUES 108,000.00 12,348.92 70,086.25 64.89 37,913.75
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
118,000.00
8,028.56
58,635.39 49.69
59,364.61
118,000.00
8,028.56
58,635.39 49.69
59,364.61
118,000.00
--------------------------
8,028.56
--------
58,635.39 49.69
==-=---------------------
59,364.61
( 10,000.00)
4,320.36
11,450.86 (
21,450.86)
10-17-2023 10:56 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2023
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
TOTAL Library
Library Project
Other Financing Sources
58.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
75,000.00 11,655,47 38,830.92 51.77 36,169.08
0.00 165.69 165.69 0.00 ( 165.69)
75,000.00 11,821.16 38,996.61 52.00 36,003.39
5,000.00 527.76 3,089.64 61.79 1,910.36
5,000.00 527.76 3,089.64 61.79 1,910.36
28,000.00
0.00
26,000.00
100.00
0.00
28,000.00
0.00
28,000.00
100.00
0.00
108,000.00 12,348.92 70,086.25 64.89 37,913.75
TOTAL REVENUE 108,000.00 12,348.92 70,086.25 64.89 37,913.75
10-17-2023 10:56 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2023
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-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
TOTAL Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlav
58.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
6,000.00
364.14
7,591.36
126.52 (
1,591.36)
6,000.00
364.14
7,591.36
126.52 (
1,591.36)
1,200.00
100.51
707.89
58.99
492.11
500.00
0.00
0.00
0.00
500.00
7,000.00
0.00
2,655.90
37.94
4,344.10
31,100.00
4,173.91
21,382.69
68.75
9,717.31
19,800.00
675.00
4,715.71
23.82
15,084.29
200.00
0.00
0.00
0.00
200.00
35,000.00
2,490.00
17,430.00
49.80
17,570.00
7,200.00
225.00
4,151.84
57.66
3,048.16
102,000.00
7,664.42
51,044.03
50.04
50,955.97
10,000.00
0.00
0.00
0.00
10,000.00
10,000.00
0.00
0.00
0.00
10,000.00
TOTAL Library 118,000.00 6,028.56 58,635.39 49.69 59,364.61
TOTAL Culture & Recreation
118,000.00 8,028.56 58,635.39 49.69 59,364.61
TOTAL EXPENDITURES
118,000.00
8,028.56
58,635.39 49.69
59,364.61
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)
4,320.36
11,450.86 (
21,450.86)
10-17-2023 10:58 AM
D E T A I L L I
S T I N G-
PAGE: 1
FUND 211 -LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Jul -2023 THRU Jul
-2023
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
7,227.22
7/10/23 7/10 A49239
CHK: 124868
04957 BULK SALT
13048
162.00
7,389.22
STEP SAVER INC
INV# 164517
/PO#
7/10/23 7/10 A49288
CHK: 124820
04957 SUPPLIES
15867
202.14
7,591.36
DACOTAH PAPER CO
INV# 81122
/PO#
JULY ACTIVITY DB:
364.14
CR:
0.00
364.14
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B E
G I N N I N G B A L A N
C E
607.38
7/17/23 7/13 A49501
CHK: 124979
04958 PHONE LINE CHGS
11102
100.51
707.89
WINDSTREAM
INV# 070623
/PO#
-----------_=
JULY ACTIVITY DB:
100.51
CR:
0.00
100.51
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B E
G I N N I N G B A L A N
C E
17, 208.78
7/17/23 7/13 A49489
CHK: 124960
04958 JUN COMM GARBAGE SVC
10407
61.25
17,270.03
REPUBLIC SERVICES #899
INV# 899004246172
/PO#
7/17/23 7/13 A49628
CHK: 124889
04956 NATURAL GAS
13845
864.14
18,154.17
CENTERPOINT ENERGY
INV# 6781052-3
JUN
23 /PO#
7/24/23 7/25 A50193
EFT: 005075
04974 WATER/ELECTRIC/SEWER 17700
3,226.52
21,382.69
ELK RIVER MUNICIPAL UTILI
INV# 071223
/PO#
JULY ACTIVITY DB:
4,173.91
CR:
0.00
4,173.91
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B E
G I N N I N G B A L A N
C E
4,040.71
7/17/23 7/13 A49566
CHK: 124951
04958 CLEANING SVCS - JUL
12651
2,490.00
6,530.71
PERFECTION PLUS, INC.
INV# 314763
/PO#
7/17/23 7/13 A49647
CHK: 124963
04958 ROOF LEAK REPAIRS
14328
675.00
7,205.71
ROSENQUIST CONSTRUCTION I
INV# 40946
/PO#
7/17/23 10/06 B45674
09562 CLEANING SVCS - JUL
JE# 060186
2,490.00CR
4,715.71
JULY ACTIVITY DB:
3,165.00
CR:
2,490.00CR
675.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B E
G I N N I N G B A L A N
C E
14, 940.00
10-17-2023 10:58 AM D E T A I L L I S T I N G PAGE: 2
FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Jul -2023 THRU Jul -2023
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
7/17/23 10/06 845674 09562 CLEANING SVCS - JUL JE# 060186 2,490.00 17,430.00
------------- JULY ACTIVITY DB: 2,490.00 CR: 0.00 2,490.00
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4409 Contractual Services
B E G I N N I N G B A L A N C E 3,926.84
7/17/23 7/13 A49666 CHK: 124897 04958 STORYTIME WITH CRAFT-JUL 14941 225.00 4,151.84
MARILYN L DIRKSWAGER INV# 073123 /PO#
------------- JULY ACTIVITY DB: 225.00 CR: 0.00 225.00
*-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 50,606.83 0.00
REPORTED ACTIVITY: 10,518.56 2,490.00CR
ENDING BALANCES: 61,125.39 2,490.00CR
TOTAL FUND ENDING BALANCE: 58,635.39
10-17-2023 10:54 AM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1C10 Cash - Library
211-1380 Interest Receivable
TOTAL ASSETS
LIABILITIES
EQUITY
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: AUGUST 31ST, 2023
BALANCE
234,687.25
1,126.00
235,813.25
211-2400 Fund Balance 241,203.19
TOTAL BEGINNING EQUITY 241,203.19
TOTAL REVENUE 70,086.25
TOTAL EXPENSES 75,476.19
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 5,389.94)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 235,813.25
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
235,813.25
235,813.25
10-17-2023 10:56 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2023
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
BUDGET PERIOD
66.67% OF YEAR COMP.
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
108,000.00 0.00 70,086.25 64.89 37,913.75
108,000.00 0.00 70,086.25 64.89 37,913.75
118,000.00
16,840.80
75,476.19 63.96
42,523.81
118,000.00
16,840.80 _
7476.19 63.96
42,523.81
118,000.00
16,840.80
75,476.19 63.96
42,523.81
( 10,000.00)(
16,840.80)(
5,389.94) (
4,610.06)
10-17-2023 10:56 AM
CITY OF ELK RIVER
38,830.92
PAGE: 2
36,169.08
REVENUE & EXPENSE REPORT (UNAUDITED)
0.00
165.69
0.00 (
AS OF: AUGUST 31ST, 2023
75,000.00
0.00
211 -LIBRARY
52.00
36,003.39
5,000.00
0.00
3,089.64
66.67%
OF YEAR COMP.
5,000.00
CURRENT CURRENT YEAR TO DATE
8 OF
BUDGET
REVENUES
BUDGET PERIOD ACTUAL
BUDGET
BALANCE
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
TOTAL Library
Library Project
Other Financing Sources
75,000.00
0.00
38,830.92
51.77
36,169.08
0.00
0.00
165.69
0.00 (
165.69;
75,000.00
0.00
38,996.61
52.00
36,003.39
5,000.00
0.00
3,089.64
61.79
1,910.36
5,000.00
0.00
3,089.64
61.79
1,910.36
28,000.00
0.00
28,000.00
100.00
0.00
28,000.00
0.00
28,000.00
100.00
0.00
108,000.00
0.00
70,086.25
64.89
37,913.75
TOTAL REVENUE 108,000.00 0.00 70,086.25 64.89 37,913.75
10-17-2023 10:56 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2023
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Services & Charues
211-4-5600-4321 Telephone
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
TOTAL Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
TOTAL Library
TOTAL Culture & Recreation
118,000.00 16,840.80 75,476.19 63.96 42,523.81
118,000.00 16,840.80 75,476.19 63.96 42,523.81
TOTAL EXPENDITURES 118,000.00 16,840.80 75,476.19 63.96 42,523.81
REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 16,840.80)( 5,389.94) ( 4,610.06)
66.67%
OF YEAR COMP.
CURRENT
CURRENT
YEAR TO DATE
% OF
BUDGET
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
6,000.00
10,338.24
2,746.88
172.30
( 4,338.24)
6,000.00
2,746.88
10,338.24
172.30
( 4,338.24)
1,200.00
100.51
808.40
67.37
391.60
500.00
0.00
0.00
0.00
500.00
7,000.00
1,558.00
4,213.90
60.20
2,786.10
31,100.00
2,526.53
23,909.22
76.88
7,190.78
19,800.00
4,917.50
9,633.21
48.65
10,166.79
200.00
0.00
0.00
0.00
200.00
35,000.00
2,490.00
19,920.00
56.91
15,080.00
7,200.00
2,501.38
6,653.22
92.41
546.78
102,000.00
14,093.92
65,137.95
63.86
36,862.05
10,000.00
0.00
0.00
0.00
10,000.00
10,000.00
0.00
0.00
0.00
10,000.00
118,000.00 16,840.80 75,476.19 63.96 42,523.81
118,000.00 16,840.80 75,476.19 63.96 42,523.81
TOTAL EXPENDITURES 118,000.00 16,840.80 75,476.19 63.96 42,523.81
REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 16,840.80)( 5,389.94) ( 4,610.06)
10-17-2023 10:59 AM
D E T A I L L I
S T
I N G
PAGE: 1
FUND
211 -LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Aug -2023 THRU
Aug -2023
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
7,591.36
8/07/23 8/03
A50643
CHK: 125081
04961 SUPPLIES
15887
452.22
8,043.58
DACOTAH PAPER CO
INV#
19141
/PO#
8/07/23 8/03
A50644
CHK: 125081
04981 SUPPLIES
15887
48.22
8,091.80
DACOTAH PAPER CO
INV#
19142
/PO#
8/21/23 8/17
A51509
EFT: 005174
05010 MORTO & AIR FILTERS
20300
1,306.72
9,398.52
GRAINGER
INV#
9792956709
/PO#
8/21/23 8/17
A51512
CHK: 125260
05010 DEHUMIDIFIER
20317
28.34
9,426.86
GRAND RENTAL STATION
INV#
258297
/PO#
8/21/23 8/17
A51560
EFT: 005179
05010 PARTS/SUPPLIES
25145
12.38
9,439.24
MENARDS - ELK RIVER
INV#
073123
/PO#
8/21/23 8/17
A51560
EFT: 005179
05010 SUPPLIES -REFRIGERATOR
25145
899.00
10,338.24
MENARDS - ELK RIVER
INV#
073123
/PO#
AUGUST ACTIVITY DB:
2,746.88
CR:
0.00
2,746.88
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N
C E
707.89
8/11/23 8/11
A51043
CHK: 125215
04999 PHONE LINE CHGS
11102
100.51
808.40
WINDSTREAM
INV#
080323
/PO#
-------------
AUGUST ACTIVITY DB:
100.51 CR:
0.00
100.51
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4361
Insurance
B
E G I N N I N G B A L A N
C E
2,655.90
8/07/23 8/03
A50736
CHK: 125118
04981 LIAB INS-JUN/SEP 2023
23805
1,558.00
4,213.90
LEAGUE OF MN CITIES INS T
INV#
40002926 071723
/PO#
-------------
AUGUST ACTIVITY DB:
1,558.00
CR:
0.00
1,558.00
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
21, 382.69
8/11/23 8/11
A51038
CHK: 125208
04999 JUL COMM GARBAGE SVC
10407
61.26
21,443.95
REPUBLIC SERVICES #899
INV#
899-004266674
/PO#
8/11/23 8/11
A51074
CHK: 125180
04999 NATURAL GAS
13845
32.53
21,476.48
CENTERPOINT ENERGY
INV#
6781052-3 JUL 23
/PO#
8/21/23 8/17
A51494
EFT: 005170
05010 WATER/ELECTRIC/SEWER
17700
2,432.74
23,909.22
ELK RIVER MUNICIPAL UTILI
INV#
080923
/PO#
AUGUST ACTIVITY DB:
2,526.53 CR:
0.00
2,526.53
10-17-2023 10:59 AM
D E T A I L L I
S T
I N G
PAGE: 2
FUND
211 -LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Aug -2023 THRU Aug -2023
DEPT
5600 Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE
TRAN #
REFERENCE
PACKET======DESCRIPTION== ==_=
VEND INV/PO/JE
# NOTE
=====AMOUNT====
====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B E
G I N N I N G B A L A N
C E
4,715.71
8/21/23 8/17
A51400
CHK: 125322
05010 MAINTENANCE -LIBRARY
14328
4,310.00
9,025.71
ROSENQUIST CONSTRUCTION I
INV#
39848
/PO#
8/21/23 8/17
A51415
CHK: 125231
05010 PEST CONTROL -LIBRARY
14717
82.50
9,108.21
SLACKHAWK PEST CONTROL, L
INV#
16735
/PO#
8/21/23 8/17
A51447
CHK: 125289
05010 COMPRESSOR REPAIRS
15068
525.00
9,633.21
ELLIS GEOTHERMAL INC.
INV#
13392
/PO#
-------------
AUGUST ACTIVITY DB:
4,917.50
CR:
0.00
4,917.50
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B E
G I N N I N G B A L A N
C E
17, 430.00
8/25/23 8/24
A51899
CHK: 125355
05016 CLEANING SVCS - AUG
12651
2,490.00
19,920.00
PERFECTION PLUS, INC.
INV#
314813
/PO#
-------------
AUGUST ACTIVITY DB:
2,490.00
CR:
0.00
2,490.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409
Contractual
Services
B E
G I N N I N G B A L A N
C E
4,151.84
8/07/23 8/03
A50453
EFT: 005084
04981 MOWING & FERTILIZER
11661
671.19
4,823.03
SPEEDCUTTERS OUTDOOR MAIN
INV#
25049
/PO#
8/07/23 8/03
A50704
CHK: 125101
04981 ENTERTAINMENT 8/14/23
20818
350.00
5,173.03
LYNN HALBROOK
INV#
081423
/PO#
8/21/23 8/17
A51269
EFT: 005144
05010 MOWING & FERTILIZER
11661
671.19
5,844.22
SPEEDCUTTERS OUTDOOR MAIN
INV#
25241
/PO#
8/21/23 8/17
A51433
CHK: 125251
05010 STORYTIME WITH CRAFT -AUG
14941
300.00
6,144.22
MARILYN L DIRKSWAGER
INV#
082823
/PO#
8/21/23 8/17
A51505
CHK: 125258
05010 REPTILE SHOW
19850
220.00
6,364.22
JAMES GERHOLDT
INV#
072123
/PO#
8/21/23 8/17
A51506
CHK: 125237
05010 BUG PRESENTATION
19934
289.00
6,653.22
BRUCE L GIEBINK
INV#
080223
/PO#
-------------
AUGUST ACTIVITY DB:
2,501.38
CR:
0.00
2,501.38
10-17-2023 10:59 AM D E T A I L L I S T I N G PAGE: 3
FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Aug -2023 THRU Aug -2023
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: 58,635.39 0.00
REPORTED ACTIVITY: 16,840.80 0.00
ENDING BALANCES: 75,476.19 0.00
TOTAL FUND ENDING BALANCE: 75,476.19
10-17-2023 10:55 AM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: SEPTEMBER 30TH, 2023
BALANCE
223,173.54
1,126.00
224,299.54
TOTAL ASSETS
LIABILITIES
EQUITY
211-2400 Fund Balance 241,203.19
TOTAL BEGINNING EQUITY 241,203.19
TOTAL REVENUE 70,086.25
TOTAL EXPENSES 86,989.90
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 16,903.65)
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
224,299.54
224,299.54
------------
224,299.54
10-17-2023 10:57 AM
CITY OF ELK RIVER
PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
Library
108,000.00
0.00
AS OF: SEPTEMBER 30TH, 2023
64.89
37,913.75
211 -LIBRARY
TOTAL REVENUES
108,000.00
FINANCIAL SUMMARY
70,086.25
75.00%
OF YEAR COMP.
EXPENDITURE SUMMARY
CURRENT CURRENT YEAR TO DATE
% OF
BUDGET
BUDGET PERIOD ACTUAL
BUDGET
BALANCE
REVENUE SUMMARY
Library
108,000.00
0.00
70,086.25
64.89
37,913.75
TOTAL REVENUES
108,000.00
0.00
70,086.25
64.89
37,913.75
EXPENDITURE SUMMARY
Culture & Recreation
Library
118,000.00
11,513.71
66,989.90
73.72
31,010.10
TOTAL Culture & Recreation
118,000.00
11,513.71
86,989.90
73.72
31,010.10
TOTAL EXPENDITURES
118,000.00
11,513.71
86,989.90
73.72
31,01D.10
REVENUES OVER/(UNDER) EXPENDITURES
10,000.00)(
11,513.71)(
16,903.65)
6,903.65
10-17-2023 10:57 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2023
211 -LIBRARY
REVENUES
Library
Taxes
211-3-0000-3111 Current Ad Valorem Taxes
75,000.00
75.00%
OF YEAR COMP.
CURRENT
CURRENT YEAR TO DATE
% OF
BUDGET
BUDGET
PERIOD ACTUAL
BUDGET
BALANCE
211-3-0000-3111 Current Ad Valorem Taxes
75,000.00
0.00
38,830.92
51.77
36,169.08
211-3-0000-3112 Delinquent Ad Valorem Taxes
0.00
0.00
165.69
0.00 (
165.69)
TOTAL Taxes
75,000.00
0.00
38,996.61
52.00
36,003.39
Other Revenue
211-3-0000-3621 Interest Income
5,000.00
0.00
3,089.64
61.79
1,910.36
TOTAL Other Revenue
5,000.00
0.00
3,089.64
61.79
1,910.36
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
Library Project
Other Finarcino Sources
TOTAL REVENUE
108,000.00 0.00 70,086.25 64.89 37,913.75
108,000.00 0.00 70,086.25 64.89 37,913.75
10-17-2023 10:57 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2023
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-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
TOTAL Services & Charges
Capital Outla•r
211-4-5600-4560 Equipment
TOTAL Capital Outlay
75.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
6,000.00
424.36
10,762.60
179.38 (
4,762.60)
6,000.00
424.36
10,762.60
179.38 (
4,762.60)
1,200.00
100.51
908.91
75.74
291.09
500.00
0.00
0.00
0.00
500.00
7,000.00
1,558.00
5,771.90
82.46
1,228.10
31,100.00
81.77
23,990.99
77.14
7,109.01
19,800.00
5,979.50
15,612.71
78.85
4,187.29
200.00
0.00
0.00
0.00
200.00
35,000.00
2,490.00
22,410.00
64.03
12,590.00
7,200.00
879.57
7,532.79
104.62 (
332.79)
102,000.00
11,089.35
76,227.30
74.73
25,772.70
10,000.00 0.00 0.00 0.00 10,000.00
10,000.00 0.00 0.00 0.00 10,000.00
TOTAL
Library
118,000.00
-------------
11,513.71
73.72
-------
86,989.90
73.72
31,010.10
TOTAL
Culture & Recreation
118,000.00
11,513.71
86,989.90
73.72
31,010.10
TOTAL EXPENDITURES
118,000.00
------------- -------------
11,513.71
-------------
86,989.90
73.72
-------
31,010.10
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
11,513.71)(
16,903.65)
6,903.65
10-17-2023 11:00 AM
D E T A I L L I
S T I N G
PAGE: 1
FUND 211-LIBRARY
ACTIVE ACCOUNTS ONLY PERIOD TO USE:
Sep-2023 THRU Sep-2023
DEPT 5600 Library
SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAM #
REFERENCE
PACKET======DESCRIPTION=====_= VEND INV/PO/JE #
NOTE
=====AMOUNT===-
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4219
Operating
Supplies
B
E G I N N I N G B A L A N
C E
10, 338.24
9/18/23 9/14 A52662
CHK: 125585
05038 BULK SALT
13048
148.50
10,486.74
STEP SAVER INC
INV# 166496
/PO#
9/18/23 9/14 A52789
CHK: 125499
05038 SUPPLIES
15887
240.22
10,726.96
DACOTAH PAPER CO
INV# 43091
/PO#
9/18/23 9/14 A52872
EFT: 005286
05038 SUPPLIES
25145
35.64
10,762.60
MENARDS - ELK RIVER
INV# 083123
/PO#
SEPTEMBER ACTIVITY DB:
424.36 CR:
0.00
424.36
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N
C E
806.40
9/18/23 9/14 A52589
CHK: 125595
05038 PHONE LINE CHGS
11102
100.51
908.91
WINDSTREAM
INV# 090623
/PO#
------------=
SEPTEMBER ACTIVITY DB:
100.51 CR:
0.00
100.51
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4361
Insurance
B
E G I N N I N G B A L A N
C E
4, 213.90
9/18/23 9/14 A52859
CHK: 125531
05038 INSURANCE ALLOCATION
23805
1,558.00
5,771.90
LEAGUE OF MN CITIES INS T
INV# 40002926 090523
/PO#
-------------
SEPTEMBER ACTIVITY DB:
1,558.00 CR:
0.00
1,558.00
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
23, 909.22
9/11/23 9/12 A52466
CHK: 125469
05034 AUG COMM GARBAGE SVC
10407
61.26
23,970.48
REPUBLIC SERVICES #899
INV# 899-004287957
/PO#
9/11/23 9/12 A52483
CHK: 125459
05034 NATURAL GAS
13845
20.51
23,990.99
CENTERPOINT ENERGY
INV# 6781052-3 AUG 23
/PO#
_____________
SEPTEMBER ACTIVITY DB:
81.77 CR:
0.00
81.77
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint
Services
B
E G I N N I N G B A L A N
C E
9,633.21
9/05/23 8/31 A52058
CHK: 125385
05024 REPLACED TOILET-LIBRARY 12765
1,288.00
10,921.21
DUSTY'S DRAIN CLEANING IN
INV# N23-411
/PO#
9/05/23 8/31 A52135
CHK: 125438
05024 ROOF LEAK REPAIRS-LIBRAR
14328
3,204.00
14,125.21
ROSENQUIST CONSTRUCTION I
INV# 39849
/PO#
10-17-2023 11:00 AM
D E T A I L L I S T I N G
PAGE: 2
FUND
211 -LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Sep -2023 THRU
Sep -2023
DEPT
5600 Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE
TRAN #
REFERENCE
PACKET======DESCRIPTION=====_= VEND
INV/PO/JE # NOTE
=====AMOUNT====
====BALANCE====
9/11/23 9/12
A52493
CHK: 125463
05034 EXTERIOR WINDOW CLNG 16448
228.00
14,353.21
DISTINCTIVE WINDOW CLEANS INV# 23271
/PO#
9/18/23 9/14
A52752
EFT: 005272
05038 PEST CONTROL -LIBRARY 14717
82.50
14,435.71
BLACKHAWK PEST CONTROL, L INV# 17442
/PO#
9/26/23 9/26
A53215
CHK: 125607
05054 GEOTHERMAL PLANT SVC 11926
345.00
14,780.71
HUMERATECH INV# 230638
/PO#
9/26/23 9/26
A53234
CHK: 125609
05054 BATHROOM REPAIRS -LIBRARY 23107
832.00
15,612.71
KISER CONSTRUCTION INV# 12118
/PO#
SEPTEMBER ACTIVITY DB: 5,979.50
CR: 0.00
5,979.50
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B E
G I N N I N G B A L A N C E
19, 920.00
9/18/23 9/14
A52630
CHK: 125560
05038 CLEANING SVCS - SEP 12651
2,490.00
22,410.00
PERFECTION PLUS, INC. INV# 314865
/PO#
-------------
SEPTEMBER ACTIVITY DB: 2,490.00
CR: 0.00
2,490.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409
Contractual
Services
B E
G I N N I N G B A L A N C E
6,653.22
9/18/23 9/14
A52604
EFT: 005246
05038 MOWING & FERTILIZER 11661
654.57
7,307.79
SPEEDCUTTERS OUTDOOR MAIN INV# 25432
/PO#
9/18/23 9/14
A52761
CHK: 125502
05038 STORYTIME WITH CRAFT -SEP 14941
225.00
7,532.79
MARILYN L DIRKSWAGER INV# 091123
/PO#
-------------
SEPTEMBER ACTIVITY DB: 879.57
CR: 0.00
879.57
000 ERRORS IN THIS REPORT
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 75,476.19 0.00
REPORTED ACTIVITY: 11,513.71 0.00
ENDING BALANCES: 86,989.90 0.00
TOTAL FUND ENDING BALANCE: 86,989.90