3.2 LIBSR 07-27-2021•01-2021 11:48 AM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: APRIL 30TH, 2021
.-LIBRARY
:COUNT # ACCOUNT DESCRIPTION
;ETS
.-1010 Cash - Library
-1380 Interest Receivable
BALANCE
306,060.24
1,614.00
307,674.24
TOTAL ASSETS
kBILITIES
.-2020 A/P - Library 2,614.50
TOTAL LIABILITIES 2,614.50
I I TY
-2400 Fund Balance 384.665_R0
307,674.24
--------------
--------------
TOTAL BEGINNING EQUITY 384,665.80
TOTAL REVENUE 29,490.55
TOTAL EXPENSES 109,096.61
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 79,606.06)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 305,059.74
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 307,674.24
--------------
FUND 211-LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Apr-2021 THRU
Apr-2021
DEPT 5600 Library
SUPPRESS ZEROS
ACCOUNTS: ALL
'OST 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
1,147.64
'23/21 4/23 A13422
CHK: 117415
03970 SUPPLIES
21600
10.48
1,158.12
HOME DEPOT CREDIT SERVICE
INV#
6025032
/PO#
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N
C E
280.83
'19/21 4/15 A12824
CHK: 117403
03946 PHONE LINE CHGS
11102
93.72
374.55
WINDSTREAM
INV#
040721
/PO#
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
7,581.24
'05/21 4/01 A12445
EFT: 002026
03926 MAR RUBBISH SVCS
30851
61.25
7,642.49
RANDY'S ENVIRONMENTAL SER
INV#
135618-031921
/PO#
'19/21 4/15 A12926
CHK: 117319
03946 NATURAL GAS
13845
22.73
7,665.22
CENTERPOINT ENERGY
INV#
6781052-3 MAR
21 /PO#
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N
C E
420.00
'05/21 4/01 A12186
EFT: 001999
03926 FIRE EXTINGUISHER SVCS-L
11955
24.50
444.50
RICHFIELD FIRE EXTINGUISH
INV#
124975
/PO#
'05/21 4/01 A12206
CHK: 117201
03926 REPLACE/INSTALL TOGGLE S
12256
331.40
775.90
BLAINE LOCK & SAFE, INC
INV#
25274
/PO#
'19/21 4/15 A13102
CHK: 117392
03946 ANNUAL FIRE ALARM INSP-L
33444
245.00
1,020.90
SUMMIT COMPANIES
INV#
130006132
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N
C E
4,980.00
'19/21 4/15 A12873
CHK: 117374
03946 CLEANING SVCS - MAR
12651
2,490.00
7,470.00
PERFECTION PLUS, INC.
INV#
113618
/PO#
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4520
Buildings
& Structures
B
E G I N N I N G B A L A N
C E
54, 901.26
'19/21 4/15 A12950
CHK: 117305
03946 HVAC UPGRADES
14338
24,400.56
79,301.82
APEX FACILITY SOLUTIONS,
INV#
4
/PO#
FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Apr-2021 THRU Apr-2021
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
'OST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 81,416.97 0.00
REPORTED ACTIVITY: 27,679.64 0.00
ENDING BALANCES: 109,096.61 0.00
TOTAL FUND ENDING BALANCE: 109,096.61
SELECTION CRITERIA
;CAL YEAR: Jan-2021 / Dec-2021
fD: Include: 211
:IOD TO USE: Apr-2021 THRU Apr-2021
�NSACTIONS: BOTH
----------------------------------------------------------------------------------------------------------------------------------
:OUNT SELECTION
:OUNT RANGE: THRU ZZZZZZZZZZZZZZZ
'ARTMENT RANGE: - THRU -
'IVE FUNDS ONLY: YES
'IVE ACCOUNT ONLY: YES
:LUDE RESTRICTED ACCOUNTS: NO
;IT SELECTION: 4-????-42??????
4-????-43??????
4-????-44??????
4-????-45??????
----------------------------------------------------------------------------------------------------------------------------------
NT OPTIONS DETAIL
T ACCOUNTS WITH NO ACTIVITY: YES
NT ENCUMBRANCES: NO
NT VENDOR NAME: YES
NT PROJECTS: NO
NT JOURNAL ENTRY NOTES: NO
NT MONTHLY TOTALS: NO
NT GRAND TOTALS: NO
NT: INVOICE/PO #
;E BREAK BY: NONE
----------------------------------------------------------------------------------------------------------------------------------
END OF REPORT ***
•01-2021 12:50 PM
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2021
PAGE: 1
.-LIBRARY
fANCIAL SUMMARY
'ENUE SUMMARY
,ibrary
'AL REVENUES
ture & Recreation
,ibrary
TOTAL Culture & Recreation
'AL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
33.33% OF YEAR COMP.
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
106,500.00 0.00 29,490.55 27.69 77,009.45
106,500.00 0.00 29,490.55 27.69 77,009.45
116, OS 0.00 27,679.64 109.096.61 93.65 7,403.39
116, OS 0.00 27,679.64 109,096.61 93.65 7,403.39
116,500.00 27,679.64 109,096.61 93.65 7,403.39
'ENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 27,679.64)( 79,606.06) 69,606.06
•01-2021 12:50 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2021
.-LIBRARY
33.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
'ENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
Crary
.-3-0000-3111 Current Ad Valorem Taxes
TOTAL Taxes
ier Revenue
.-3-0000-3621 Interest Income
TOTAL Other Revenue
tnsfers In
.-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
tTAL Library
Crary Project
ter Financing Sources
71,500.00 0.00 0.00 0.00 71,500.00
71,500.00 0.00 0.00 0.00 71,500.00
7,000.00 0.00 1,490.55 21.29 5,509.45
7,000.00 0.00 1,490.55 21.29 5,509.45
28,000.00 0.00 28,000.00 100.00 0.00
28,000.00 0.00 28,000.00 100.00 0.00
106,500.00 0.00 29,490.55 27.69 77,009.45
'AL REVENUE 106,500.00 0.00 29,490.55 27.69 77,009.45
•01-2021 12:50 PM
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2021
PAGE: 3
.-LIBRARY
ture & Recreation
Crary
'ARTMENTAL EXPENDITURES
s
plies
.-4-5600-4219 Operating Supplies
TOTAL Supplies
ier Ziervicea & Charges
-4-5600-4321 Telephone
.-4-5600-4331 Travel, Conferences & Schools
.-4-5600-4359 Publishing
.-4-5600-4361 Insurance
.-4-5600-4389 Utilities
.-4-5600-4401 Bldg Repair/Maint Services
.-4-5600-4404 Equip Repair/Maint Services
.-4-5600-4405 Cleaning Services
.-4-5600-4409 Contractual Services
.-4-5600-4433 Dues & Subscriptions
TOTAL Other Services & Charges
)ital Outlay
.-4-5600-4520 Buildings & Structures
-4-5600-4560 Equipment
TOTAL Capital Outlay
33.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
10,000.00
10.48
1,158.12
11.58
8.841.88
10,000.00
10.48
1,158.12
11.58
8,841.88
1,100.00
93.72
374.55
34.05
725.45
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
1,506.00
47.06
1,694.00
30,000.00
83.98
7,665.22
25.55
22,334.78
17,550.00
600.90
1,020.90
5.82
16,529.10
200.00
0.00
0.00
0.00
200.00
30,000.00
2,490.00
7,470.00
24.90
22,530.00
13,700.00
100.00
0.00
0.00
10,600.00
0.00
77.37
0.00
3,100.00
100.00
96,500.00
3,268.60
28,636.67
29.68
67,863.33
0.00
24,400.56
79,301.82
0.00 (
79,301.82)
10,000.00
10,000.00
10,000.00
0.00
24,400.56
0.00
79,301.82
0.00
793.02 (
69,301.82)
)TAL Library 116,500.00 27,679.64 109,096.61 93.65 7,403.39
:TAL Culture & Recreation 116,500.00 27,679.64 109,096.61 93.65 7,403.39
'AL EXPENDITURES 116,500.00 27,679.64 109,096.61 93.65 7,403.39
'ENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 27,679.64)( 79,606.06) 69,606.06
•01-2021 11:53 AM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: MAY 31ST, 2021
.-LIBRARY
:COUNT # ACCOUNT DESCRIPTION
;ETS
.-1010 Cash - Library
-1380 Interest Receivable
BALANCE
282,426.54
1,614.00
284,040.54
TOTAL ASSETS
ABILITIES
-2020 A/P - Library 2,
TOTAL LIABILITIES 2.614.SU
TITY
-2400 Fund Balance 384,665.80
TOTAL BEGINNING EQUITY 384,665.80
TOTAL REVENUE 29,490.55
TOTAL EXPENSES 132,730.31
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 103,239.76)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 281,426.04
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
284,040.54
--------------
284,040.54
FUND
211-LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
May-2021 THRU May-2021
DEPT
5600
Library
SUPPRESS ZEROS
ACCOUNTS: ALL
'OST
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
1,158.12
'03/21
4/29
A13513
EFT: 002163
03973 SUPPLIES
11835
69.50
1,227.62
BATTERIES PLUS BULBS
INV#
P38725388
/PO#
'03/21
4/29
A13554
CHK: 117516
03973 BULK SALT
13048
103.60
1,331.22
STEP SAVER INC
INV#
144931
/PO#
'25/21
5/25
A14724
CHK: 117704
03996 SUPPLIES
21600
20.96
1,352.18
HOME DEPOT CREDIT SERVICE
INV#
6022572
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N
C E
374.55
'17/21
5/13
A14045
CHK: 117673
03984 PHONE LINE CHGS
11102
93.70
468.25
WINDSTREAM
INV#
050721
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
7,665.22
'03/21
4/29
A13670
EFT: 002181
03973 WATER/ELECTRIC
17700
2,096.90
9,762.12
ELK RIVER MUNICIPAL UTILI
INV#
041421
/PO#
'03/21
4/29
A13732
EFT: 002188
03973 APR RUBBISH SVCS
30851
61.25
9,823.37
RANDY'S ENVIRONMENTAL SER
INV#
135818-041921
/PO#
'25/21
5/25
A14698
CHK: 117692
03996 NATURAL GAS
13845
22.73
9,846.10
CENTERPOINT ENERGY
INV#
6781052-3 APR
21 /PO#
'25/21
5/25
A14714
EFT: 002251
03996 WATER/ELECTRIC
17700
1,604.61
11,450.71
ELK RIVER MUNICIPAL UTILI
INV#
051221
/PO#
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N
C E
1, 020.90
'17/21
5/13
A14067
CHK: 117655
03984 MOWING SVCS CONTRACT
11661
151.18
1,172.08
SPEEDCUTTERS OUTDOOR MAIN
INV#
13191
/PO#
'17/21
5/13
A14237
CHK: 117575
03984 PEST CONTROL
15191
75.00
1,247.08
RICHARD J MORGAN
INV#
10053
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N
C E
7,470.00
'25/21
5/25
A14683
CHK: 117718
03996 CLEANING SVCS - MAY
LIBR
12651
2,490.00
9,960.00
PERFECTION PLUS, INC.
INV#
113620
/PO#
FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY
PERIOD TO USE: May-2021 THRU
May-2021
DEPT 5600 Library SUPPRESS ZEROS
ACCOUNTS: ALL
'OST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_=
VEND INV/PO/JE
# NOTE =====AMOUNT====
====BALANCE====
•--------------------------------------------------------------------------------------------------------------------------------
4-5600-4520 Buildings & Structures
B E G I N N I N G B A L A N C E
79, 301. 82
'17/21 5/13 A14210 CHK: 117550 03984 HVAC UPGRADES
14338
16,844.27
96,146.09
APEX FACILITY SOLUTIONS, INV#
5
/PO#
-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** ---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
109,096.61
0.00
REPORTED ACTIVITY:
23,633.70
0.00
ENDING BALANCES:
132,730.31
0.00
TOTAL FUND ENDING BALANCE:
132,730.31
-------------------------------------------------
;CAL YEAR: Jan-2021 / Dec-2021
ID: Include: 211
;IOD TO USE: May-2021 THRU May-2021
,NSACTIONS: BOTH
•------------------------------------------------
:OUNT SELECTION
:OUNT RANGE: THRU ZZZZZZZZZZZZZZZ
'ARTMENT RANGE: - THRU -
'IVE FUNDS ONLY: YES
'IVE ACCOUNT ONLY: YES
:LUDE RESTRICTED ACCOUNTS: NO
,IT SELECTION: 4-????-42??????
4-????-43??????
4-????-44??????
4-????-45??????
NT OPTIONS DETAIL
T ACCOUNTS WITH NO ACTIVITY:
YES
NT
ENCUMBRANCES:
NO
NT
VENDOR NAME:
YES
:NT
PROJECTS:
NO
NT
JOURNAL ENTRY NOTES:
NO
NT
MONTHLY TOTALS:
NO
NT
GRAND TOTALS:
NO
NT:
INVOICE/PO #
;E BREAK
------------------------------------------------
BY: NONE
END OF REPORT ***
SELECTION CRITERIA
------------------
•01-2021 12:52 PM CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2021
PAGE: 1
.-LIBRARY
IANCIAL SUMMARY 41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
' .N Ft_jE SUMMARY
Library
'AL REVENUES
ture & Recreation
.ibrary
TOTAL Culture & Recreation
'AL EXPENDITURES
'ENUES OVER/(UNDER) EXPENDITURES
106,500.00 0.00 29,490.55 27.69 77,009.45
106,500.00 0.00 29,490.55 27.69 77,009.45
116, 05 0.00 23,63 .70 132,730.31 113.93
116,500.00 3 63 .70.70 132,730.31 113.93 ( 1_6.230,31)
116,500.00 23,633.70 132,730.31 113.93 ( 16,230.31)
( 10,000.00)( 23,633.70)( 103,239.76) 93,239.76
•01-2021 12:52 PM CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2021
.-LIBRARY
CURRENT CURRENT YEAR TO DATE
'ENUES BUDGET PERIOD ACTUAL
Irary
.-3-0000-3111 Current Ad Valorem Taxes
TOTAL Taxes
I r R V n 7
.-3-0000-3621 Interest Income
TOTAL Other Revenue
In f� eta In
.-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
ITAL Library
>rary Project
ier Financing Sources
PAGE: 2
41.67% OF YEAR COMP.
% OF BUDGET
BUDGET BALANCE
71,500.00 0.00 0.00 0.00 7�
71,500.00 0.00 0.00 0.00 71,500.00
7,000.00
7,000.00
0.00
0.00
1,490.55
1,490.55
21.29
21.29
5,509.45
5,509.45
28,000.00
0.00
0.00
28.000.00
100.00
100.00
0.00
28,000.00
28,000.00
0.00
106,500.00
0.00
29,490.55
27.69
77,009.45
'AL REVENUE 106,500.00 0.00 29,490.55 27.69 77,009.45
•01-2021 12:52 PM
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2021
PAGE: 3
.-LIBRARY
.ture & Recreation
,rary
'ARTMENTAL EXPENDITURES
s
))lies
.-4-5600-4219 Operating Supplies
TOTAL Supplies
i r Servicea & Charges
-4-5600-4321 Telephone
-4-5600-4331 Travel, Conferences & Schools
.-4-5600-4359 Publishing
.-4-5600-4361 Insurance
.-4-5600-4389 Utilities
.-4-5600-4401 Bldg Repair/Maint Services
.-4-5600-4404 Equip Repair/Maint Services
.-4-5600-4405 Cleaning Services
.-4-5600-4409 Contractual Services
.-4-5600-4433 Dues & Subscriptions
TOTAL Other Services & Charges
)ital Outlay
.-4-5600-4520 Buildings & Structures
.-4-5600-4560 Equipment
TOTAL Capital Outlay
CURRENT CURRENT
BUDGET PERIOD
41.67% OF YEAR COMP.
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
10,000.00
194.06
1,352.18
13.52
8,647.82
10,000.00
194.06
1,352.18
13.52
8,647.82
1,100.00
93.70
468.25
42.57
631.75
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
1,506.00
47.06
1,694.00
30,000.00
3,785.49
11,450.71
38.17
18,549.29
17,550.00
226.18
1,247.08
7.11
16,302.92
200.00
0.00
0.00
0.00
200.00
30,000.00
2,490.00
9,960.00
33.20
20,040.00
13,700.00
0.00
10,600.00
77.37
3,100.00
100.00
0.00
0.00
0.00
100.00
96,500.00
6,595.37
35,232.04
36.51
61,267.96
0.00
16,844.27
96,146.09
0.00 (
0.00
96,146.09)
10,000.00
10,000.00
0.00
16,844.27
0.00
96,146.09
961.46 (
10,000.00
86,146.09)
)TAL Library 116,500.00 23,633.70 132,730.31 113.93 ( 16,230.31)
)TAL Culture & Recreation
'AL EXPENDITURES
116,500.00 23,633.70 132,730.31 113.93 ( 16,230.31)
116,500.00 23,633.70 132,730.31 113.93 ( 16,230.31)
'ENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 23,633.70)( 103,239.76) 93,239.76
•01-2021 11:56 AM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: JUNE 30TH, 2021
.-LIBRARY
:COUNT # ACCOUNT DESCRIPTION BALANCE
:ETS
.-1010 Cash - Library 292,830.09
-1380 Interest Receivable 1,614.00
294,444.09
TOTAL ASSETS 294,444.09
LBILITIES
.-2020 A/P - Library 2,614.50
-2200 Deposits Payable 50.00
TOTAL LIABILITIES 2,664.50
1ITY
-2400 Fund Balance 384,665.80
TOTAL BEGINNING EQUITY 384,665.80
TOTAL REVENUE 55,754.95
TOTAL EXPENSES 148,641.16
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 92,886.21)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 291,779.59
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 294,444.09
--------------
FUND 211-LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Jun-2021 THRU
Jun-2021
DEPT 5600
Library
SUPPRESS ZEROS
ACCOUNTS: ALL
'OST 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
1,352.18
'21/21 6/16 A15595
CHK: 117882
04026 PLANTS
10149
763.50
2,:15.68
•---------------------------------------------------------------------------------------------------------------------------------
BACHMAN'S INV#
224928/50
/PO#
4-5600-4321
Telephone
BEG
I NN I NG BALANCE
468.25
'21/21 6/16 A15607
CHK: 117982
04026 PHONE LINE CHGS
11102
93.70
561.95
WINDSTREAM INV#
060721
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4361
Insurance
B
E G I N N I N G B A L A N C E
1,506.00
'21/21 6/16 A15819
CHK: 117933
04026 INSURANCE ALLOCATION
23805
860.00
2,366.00
LEAGUE OF MN CITIES INS T INV#
40002926 061021
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N C E
11, 450. 71
'07/21 6/02 A15235
EFT: 002294
03997 MAY RUBBISH SVCS
30851
61.25
11,511.96
RANDY'S ENVIRONMENTAL SER INV#
135818-051921
/PO#
'21/21 6/16 A15698
CHK: 117893
04026 NATURAL GAS
13845
20.51
11,532.47
CENTERPOINT ENERGY INV#
6781052-3 MAY 21 /PO#
'21/21 6/16 A15769
EFT: 002333
04026 WATER/ELECTRIC/SEWER
17700
1,538.04
13,070.51
ELK RIVER MUNICIPAL UTILI INV#
060921
/PO#
----------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N C E
1,247.08
'07/21 6/02 A14907
CHK: 117788
03997 SPRING START UP -LIBRARY
10107
304.00
1,551.08
GREAT NORTHERN LANDSCAPES INV#
14393
/PO#
'07/21 6/02 A15151
CHK: 117775
03997 EXTERIOR WINDOW CLNG
16448
205.00
1,756.08
DISTINCTIVE WINDOW CLEANI INV#
19575
/PO#
'11/21 6/11 A15520
CHK: 117870
04022 MOWING SVCS CONTRACT
11661
604.71
2,360.79
SPEEDCUTTERS OUTDOOR MAIN INV#
13306
/PO#
'24/21 6/24 A16135
CHK: 117998
04040 FIRE ALARM REPAIRS-LIBRA
33444
300.00
2,660.79
SUMMIT COMPANIES INV#
130013092
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N C E
9, 960.00
FUND
211-LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE: Jun-2021 THRU Jun-2021
DEPT
5600
Library
SUPPRESS ZEROS
ACCOUNTS: ALL
'OST DATE
TRAN #
REFERENCE
PACKET ------DESCRIPTION=====_=
VEND INV/PO/JE # NOTE =====AMOUNT====
===-BALANCE====
'07/21 6/02
A15001
CHK: 117817
03997 CLEANING SVCS - MAR
12651
2,490.00
12,450.00
PERFECTION PLUS, INC. INV#
113570
/PO#
'21/21 6/16
A15648
CHK: 117954
04026 CLEANING SVCS - JUN
12651
2,490.00
14,940.00
PERFECTION PLUS, INC. INV#
113715
/PO#
---------------------------------------------
4-5600-4409
Contractual
------------------------------------------------------------------------------------
Services
B
E G I N N I N G B A L A N C E
10, 600.00
'21/21 6/16
A15666
CHK: 117959
04026 TODDLER STORY TIME 06/21
13060
40.00
10,640.00
ROBIN D SCHAIBLE INV#
062121
/PO#
'21/21 6/16
A15667
CHK: 117960
04026 TODDLER STORY TIME 06/28
13060
40.00
10,680.00
ROBIN D SCHAIBLE INV#
062821
/PO#
•---------------------------------------------------------------------------------------------------------------------------------
4-5600-4520
Buildings
& Structures
B
E G I N N I N G B A L A N C E
96, 146.09
'21/21 6/16
A15714
CHK: 117877
04026 HVAC UPGRADES
14338
6,100.14
102,246.23
APEX FACILITY SOLUTIONS, INV#
6
/PO#
-*-*-*-*-*-*-*-*-*-*-*-
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** ---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
132,730.31
0.00
REPORTED ACTIVITY:
15,910.85
0.00
ENDING BALANCES:
148,641.16
0.00
TOTAL FUND ENDING BALANCE:
148,641.16
SELECTION CRITERIA
•------------------------------------------------------------------------
:CAL YEAR: Jan-2021 / Dec-2021
ID: Include: 211
:IOD TO USE: Jun-2021 THRU Jun-2021
LNSACTIONS: BOTH
•-------------------------------------------------------
:OUNT SELECTION
:OUNT RANGE: THRU ZZZZZZZZZZZZZZZ
'ARTMENT RANGE: - THRU -
'IVE FUNDS ONLY: YES
'IVE ACCOUNT ONLY: YES
:LUDE RESTRICTED ACCOUNTS: NO
;IT SELECTION: 4-????-42??????
4-????-43??????
4-????-44??????
4-????-45??????
---------------------------------------------------------
NT OPTIONS DETAIL
T ACCOUNTS WITH NO ACTIVITY: YES
NT ENCUMBRANCES: NO
:NT VENDOR NAME: YES
NT PROJECTS: NO
:NT JOURNAL ENTRY NOTES: NO
NT MONTHLY TOTALS: NO
NT GRAND TOTALS: NO
:NT: INVOICE/PO #
;E BREAK BY: NONE
END OF REPORT ***
•01-2021 12:53 PM CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2021
.-LIBRARY
fANCIAL SUMMARY
'ENUE 51MMAR
,ibrary
'AL REVENUES
.ture & Recreation
,ibrary
TOTAL Culture & Recreation
'AL EXPENDITURES
'ENUES OVER/(UNDER) EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
PAGE: 1
50.00% OF YEAR COMP.
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
106,500.00 26,264.40 55,754.95 52.35 50,745.05
106,500.00 26,264.40 55,754.95 52.35 50,745.05
116.500.00 15,910,85 148,641.1E 127.59 ( 32,141,16)
116,500.00 15,910.85 148,641,1.E 127.59 ( ,141,16)
116,500.00 15,910.85 148,641.16 127.59 ( 32,141.16)
( 10,000.00) 10,353.55 ( 92,886.21) 82,886.21
.01-2021 12:53 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2021
.-LIBRARY
50.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
'ENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
Crary
LU
.-3-0000-3111 Current Ad Valorem Taxes
TOTAL Taxes
ter Revenue
.-3-0000-3621 Interest Income
TOTAL Other Revenue
insfer,s In
.-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
tTAL Library
Crary Project
ier Financing Sources
71,500.00 26,264.40 26,264.40 36.73 45,235.60
71,500.00 26,264.40 26,264.40 36.73 45,235.60
7,000.00 0.00 1,490.55 21.29 5,509.45
7,000.00 0.00 1,490.55 21.29 5,509.45
26,000.00 0.00 28,000.00 100.00 _ 0.00
28,000.00 0.00 28,000.00 100.00 0.00
106,500.00 26,264.40 55,754.95 52.35 50,745.05
AL REVENUE 106,500.00 26,264.40 55,754.95 52.35 50,745.05
•01-2021 12:53 PM CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2021
.-LIBRARY
.ture & Recreation
)rary
CURRENT CURRENT YEAR TO DATE
'ARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL
s
)plies
.-4-5600-4219 Operating Supplies
TOTAL Supplies
)er Services & Charges
.-4-5600-4321 Telephone
-4-5600-4331 Travel, Conferences & Schools
-4-5600-4359 Publishing
.-4-5600-4361 Insurance
.-4-5600-4389 Utilities
.-4-5600-4401 Bldg Repair/Maint Services
.-4-5600-4404 Equip Repair/Maint Services
-4-5600-4405 Cleaning Services
.-4-5600-4409 Contractual Services
.-4-5600-4433 Dues & Subscriptions
TOTAL Other Services & Charges
)ital Outlay
.-4-5600-4520 Buildings & Structures
.-4-5600-4560 Equipment
TOTAL Capital Outlay
PAGE: 3
50.00% OF YEAR COMP.
% OF BUDGET
BUDGET BALANCE
10,000.00
763.50
2,115.68
21.16
7,884.32
10,000.00
763.50
2,115.68
21.16
7,884.32
1,100.00
93.70
561.95
51.09
538.05
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,200.00
860.00
2,366.00
73.94
834.00
30,000.00
1,619.80
13,070.51
43.57
16,929.49
17,550.00
1,413.71
2,660.79
15.16
14,889.21
200.00
0.00
0.00
0.00
200.00
30,000.00
4,980.00
14,940.00
49.80
15,060.00
13,700.00
100.00
80.00
0.00
10,680.00
0.09
77.96
0.00
3,020.00
96,500.00
9,047.21
44,279.25
45.89
100.00
52,220.75
0.00
10,000.00
6,100.14
0.00
102,246.23
0.00 (
102,246.23)
10,000.00
6,100.14
0.00
102,246.23
0.00
1,022.46 (
10,000.00
92,246.23)
)TAL
Library
116,500.00
15,910.85
148,641.16
127.59 (
32,141.16)
)TAL
Culture & Recreation
116,500.00
15,910.85
148,641.16
127.59 (
32,141.16)
'AL EXPENDITURES
116,500.00
15,910.85
148,641.16 127.59 (
32,141.16)
'ENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)
10,353.55 (
92,886.21)
82,886.21