3.2 LIBSR 07-23-20196-05-2019 09:18 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: MAY 31ST, 2019
BALANCE
409,517.38
2,000.00
411,517.38
TOTAL ASSETS 411,517.38
--------------
--------------
LIABILITIES
211-2200 Deposits Payable 250.00
TOTAL LIABILITIES 250.00
EQUITY
211-2400 Fund Balance 430,472.66
TOTAL BEGINNING EQUITY 430,472.66
TOTAL REVENUE 30,696.13
TOTAL EXPENSES 49,901.41
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 19,205.26)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 411,267.38
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 411,517.38
--------------
--------------
6-05-2019 9:20 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:
May -2019 THRU
May -2019
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
BEG
INN I N G BALANCE
5,013.22
5/06/19 5/02 A88082
CHK: 110348
03161 SUPPLIES -TOILET SEAT 20113
49.79
5,063.01
GOODIN COMPANY
INV# 1885060-00
/PO#
5/20/19 5/16 A88297
CHK: 110514
03169 PARTS/SUPPLIES
25145
29.86
5,092.87
MENARDS - ELK RIVER
INV# 043019
/PO#
5/20/19 5/16 A88335
CHK: 110552
03169 BULK SALT
13048
121.80
5,214.67
STEP SAVER INC
INV# 128069
/PO#
MAY ACTIVITY DB:
201.45
CR:
0.00
201.45
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
BEG
INN I N G BALANCE
367.77
5/20/19 5/16 A88350
CHK: 110567
03169 PHONE LINE CHGS
11102
91.51
459.28
WINDSTREAM
INV# 050719
/PO#
MAY ACTIVITY DB:
91.51
CR:
0.00
91.51
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
10, 056.93
5/07/19 5/02 A88024
EFT: 000593
03163 APR RUBBISH SVCS
30851
58.35
10,115.28
RANDY'S ENVIRONMENTAL SER
INV# 135818-041919
/PO#
MAY ACTIVITY DB:
58.35
CR:
0.00
58.35
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint
Services
B
E G I N N I N G B A L A N
C E
2,157.52
5/06/19 5/02 A88056
CHK: 110322
03161 PEST CONTROL
15191
75.00
2,232.52
COUNTRY SIDE PEST CONTROL
INV# 9645
/PO#
5/20/19 5/16 A88260
CHK: 110477
03169 EXTERIOR WINDOW CLNG 16448
205.00
2,437.52
DISTINCTIVE WINDOW CLEANI
INV# 14848
/PO#
MAY ACTIVITY DB:
280.00
CR:
0.00
280.00
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N
C E
7,470.00
5/20/19 5/16 A88309
CHK: 110526
03169 MAY CLEANING SVCS
12651
2,490.00
9,960.00
PERFECTION PLUS, INC.
INV# 1129252
/PO#
-------------
MAY ACTIVITY DB:
2,490.00
CR:
0.00
2,490.00
6-05-2019 9:20 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: May -2019
THRU
May -2019
DEPT 5600 Library SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_=
VEND INV/PO/JE # NOTE =====AMOUNT====
====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409 Contractual Services
B E G I N N I N G BALANCE
10,829.55
5/06/19 5/02 A88119 CHK: 110385 03161 PROGRAM 5/13
13060
40.00
10,869.55
ROBIN DEEANN SCHAIBLE INV#
051319
/PO#
5/06/19 5/02 A88120 CHK: 110386 03161 PROGRAM 5/20
13060
40.00
10,909.55
ROBIN DEEANN SCHAIBLE INV#
052019
/PO#
MAY ACTIVITY DB:
80.00 CR:
0.00
80.00
*-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** ---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
46,700.10
0.00
REPORTED ACTIVITY:
3,201.31
0.00
ENDING BALANCES:
49,901.41
0.00
TOTAL FUND ENDING BALANCE:
49,901.41
6-05-2019 09:19 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2019
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
41.67% OF YEAR COMP.
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
101,500.00
0.00
30,696.13
30.24
70,803.87
101,500.00
0.00
30,696.13
30.24
70,803.87
116,000.00
3,201.31
49,901.41 43.02
116,000.00
3,201.31
49,901.41 43.02
116,000.00
3,201.31
49,901.41 43.02
( 14,500.00)(
3,201.31)(
19,205.28)
66,098.59
66,098.59
66,098.59
4,705.28
6-05-2019 09:19 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2019
211 -LIBRARY
REVENUES
Library
41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Taxes
211-3-0000-3111 Current Ad Valorem Taxes
66,000.00
0.00
0.00
0.00
66,000.00
TOTAL Taxes
66,000.00
0.00
0.00
0.00
66,000.00
Intergovernmental Rev
Charges for Services
Other Revenue
211-3-0000-3621 Interest Income
7,500.00
0.00
2,696.13
35.95
4,803.87
TOTAL Other Revenue
7,500.00
0.00
2,696.13
35.95
4,803.87
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
101,500.00
0.00
30,696.13
30.24
70,803.87
Library Project
---------------
---------------
Other Financing Sources
Transfers In
TOTAL REVENUE 101,500.00 0.00 30,696.13 30.24 70,803.87
6-05-2019 09:19 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2019
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
211-4-5600-4201 Office Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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 Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
100.00
0.00
0.00
0.00
100.00
8,000.00
201.45
5,214.67
65.18
2,785.33
8,100.00
201.45
5,214.67
64.38
2,885.33
1,100.00
91.51
459.28
41.75
640.72
650.00
0.00
0.00
0.00
650.00
500.00
0.00
0.00
0.00
500.00
2,800.00
0.00
1,302.00
46.50
1,498.00
28,250.00
58.35
10,115.28
35.81
18,134.72
16,550.00
280.00
2,437.52
14.73
14,112.48
250.00
0.00
170.50
68.20
79.50
30,000.00
2,490.00
9,960.00
33.20
20,040.00
13,200.00
80.00
10,909.55
82.65
2,290.45
100.00
0.00
0.00
0.00
100.00
93,400.00
2,999.86
35,354.13
37.85
58,045.87
14,500.00
0.00
9,332.61
64.36
5,167.39
14,500.00
0.00
9,332.61
64.36
5,167.39
TOTAL Library 116,000.00 3,201.31 49,901.41 43.02 66,098.59
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
116,000.00
3,201.31
49,901.41 43.02
66,098.59
116,000.00
3,201.31
49,901.41 43.02
66,098.59
( 14,500.00)(
3,201.31)(
19,205.28)
4,705.28
7-09-2019 09:29 AM
CITY OF ELK RIVER
PAGE: 1
BALANCE SHEET
AS OF: JUNE 30TH, 2019
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
BALANCE
ASSETS
211-1010 Cash - Library
428,004.90
211-1380 Interest Receivable
2,000.00
430,004.90
TOTAL ASSETS
--------------
430,004.90
LIABILITIES
--------------
211-2200 Deposits Payable
100.00
TOTAL LIABILITIES
100.00
EQUITY
211-2400 Fund Balance
430,472.66
TOTAL BEGINNING EQUITY
430,472.66
TOTAL REVENUE
55,525.81
TOTAL EXPENSES
56,093.57
TOTAL REVENUE OVER/(UNDER)
EXPENSES ( 567.76)
TOTAL EQUITY & REV. OVER/(UNDER)
EXP.
429,904.90
TOTAL LIABILITIES, EQUITY
& REV.OVER/(UNDER) EXP.
--------------
--------------
430,004.90
7-09-2019 9:31 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:
Jun -2019 THRU Jun -2019
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
BEG
I NN I N G BALANCE
5,214.67
6/07/19 6/13 A88805
CHK: 009984
03186 100013ULBS - SUPPLIES 35099
226.00
5,440.67
US BANK
INV# 05272019
/PO#
6/21/19 6/21 A88847
CHK: 110888
03189 PARTS/SUPPLIES
21600
19.97
5,460.64
HOME DEPOT CREDIT SERVICE
INV# 061319
/PO#
JUNE ACTIVITY DB:
245.97 CR:
0.00
245.97
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
BEG
I N N I N G BALANCE
459.28
6/21/19 6/21 A88877
CHK: 110918
03189 PHONE LINE CHGS
11102
91.56
550.84
WINDSTREAM
INV# 060719
/PO#
JUNE ACTIVITY DB:
91.56 CR:
0.00
91.56
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
10,115.28
6/04/19 5/29 A88571
EFT: 000605
03178 WATER/ELEC
17700
2,036.54
12,151.82
ELK RIVER MUNICIPAL UTILI
INV# 051519
/PO#
6/04/19 5/29 A88572
EFT: 000606
03178 MAY RUBBISH SVCS
30851
58.35
12,210.17
RANDY'S ENVIRONMENTAL SER
INV# 135818-051719
/PO#
JUNE ACTIVITY DB:
2,094.89 CR:
0.00
2,094.89
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N
C E
2,437.52
6/03/19 5/29 A88536
CHK: 110685
03172 MOWING SVCS CONTRACT 11661
426.46
2,865.98
SPEEDCUTTERS OUTDOOR MAIN
INV# 11305
/PO#
6/17/19 6/12 A88690
CHK: 110784
03183 SPRING START UP -LIBRARY 10107
497.05
3,363.03
GREAT NORTHERN LANDSCAPES
INV# 13276
/PO#
6/17/19 6/12 A88736
CHK: 110830
03183 VEGETATION MGMT
30075
224.23
3,587.26
PRAIRIE RESTORATIONS, INC
INV# 17773
/PO#
JUNE ACTIVITY DB:
1,149.74 CR:
0.00
1,149.74
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N
C E
9,960.00
6/17/19 6/12 A88728
CHK: 110822
03183 JUNE CLEANING SVCS
12651
2,490.00
12,450.00
PERFECTION PLUS, INC.
INV# 1129293
/PO#
JUNE ACTIVITY DB:
2,490.00 CR:
0.00
2,490.00
7-09-2019 9:31 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: Jun -2019
THRU
Jun -2019
DEPT 5600 Library SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET=== =DESCRIPTION=====_=
VEND INV/PO/JE # NOTE ====AMOUNT====
====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409 Contractual Services
B E G I N N I N G B A L A
N C E
10,909.55
6/07/19 6/07 A88620 CHK: 110719 03182 PROGRAM 6/17
13060
40.00
10,949.55
ROBIN DEEANN SCHAIBLE
INV#
061719
/PO#
6/17/19 6/12 A88743 CHK: 110837 03183 PROGRAM 6/21
13060
40.00
10,989.55
ROBIN DEEANN SCHAIBLE
INV#
062119
/PO#
6/17/19 6/12 A88744 CHK: 110838 03183 PROGRAM 6/24
13060
40.00
11,029.55
ROBIN DEEANN SCHAIBLE
INV#
062419
/PO#
JUNE ACTIVITY DB:
120.00 CR:
0.00
120.00
*-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT!
** REPORT TOTALS **
---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
49,901.41
0.00
REPORTED ACTIVITY:
6,192.16
0.00
ENDING BALANCES:
56,093.57
0.00
TOTAL FUND ENDING BALANCE:
56,093.57
7-09-2019 9:31 AM
D E T A I L L I S T I N G
SELECTION CRITERIA
---------------------------------------------------------------------------
FISCAL YEAR: Jan -2019 / Dec -2019
FUND: Include: 211
PERIOD TO USE: Jun -2019 THRU Jun -2019
TRANSACTIONS: BOTH
---------------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: NO
ACTIVE ACCOUNT ONLY: YES
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4 -????-45??????
4 -????-46??????
---------------------------------------------------
PRINT OPTIONS DETAIL
OMIT ACCOUNTS WITH NO ACTIVITY: YES
PRINT ENCUMBRANCES: NO
PRINT VENDOR NAME: YES
PRINT PROJECTS: NO
PRINT JOURNAL ENTRY NOTES: NO
PRINT MONTHLY TOTALS: YES
PRINT GRAND TOTALS: NO
PRINT: INVOICE/PO #
PAGE BREAK BY: NONE
*** END OF REPORT ***
PAGE: 3
7-09-2019 09:30 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2019
211 -LIBRARY
FINANCIAL SUMMARY
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
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
101,500.00
23,509.95
55,525.81
54.71
101,500.00
23,509.95
55,525.81
54.71
45,974.19
45,974.19
116,000.00
6,192.16
56,093.57 48.36
59,906.43
116,000.00
6,192.16
56,093.57 48.36
59,906.43
116,000.00
6,192.16
56,093.57 48.36
59,906.43
( 14,500.00)
17,317.79 (
567.76) (
13,932.24)
7-09-2019 09:30 AM
CITY OF ELK
RIVER
PAGE: 2
REVENUE 6 EXPENSE REPORT (UNAUDITED)
AS OF: JUNE
30TH, 2019
211 -LIBRARY
50.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 66,000.00
23,509.95
23,509.95
35.62
42,490.05
TOTAL Taxes
66,000.00
23,509.95
23,509.95
35.62
42,490.05
Intergovernmental Rev
Charges for Services
Other Revenue
211-3-0000-3621 Interest Income
7,500.00
0.00
4,015.86
53.54
3,484.14
TOTAL Other Revenue
7,500.00
0.00
4,015.86
53.54
3,484.14
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 101,500.00 23,509.95 55,525.81 54.71 45,974.19
Library Project
Other Financing Sources
Transfers In
TOTAL REVENUE 101,500.00 23,509.95 55,525.81 54.71 45,974.19
7-09-2019 09:30 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: NNE 30TH, 2019
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
50.00% OF YEAR COMP.
OF BUDGET
BUDGET BALANCE
211-4-5600-4201
Office Supplies
100.00
0.00
0.00
0.00
100.00
211-4-5600-4219
Operating Supplies
8,000.00
245.97
5,460.64
68.26
2,539.36
TOTAL Supplies
8,100.00
245.97
5,460.64
67.42
2,639.36
Other Services
& Charges
211-4-5600-4321
Telephone
1,100.00
91.56
550.84
50.08
549.16
211-4-5600-4331
Travel, Conferences & Schools
650.00
0.00
0.00
0.00
650.00
211-4-5600-4359
Publishing
500.00
0.00
0.00
0.00
500.00
211-4-5600-4361
Insurance
2,800.00
0.00
1,302.00
46.50
1,498.00
211-4-5600-4389
Utilities
28,250.00
2,094.89
12,210.17
43.22
16,039.83
211-4-5600-4401
Bldg Repair/Maint Services
16,550.00
1,149.74
3,587.26
21.68
12,962.74
211-4-5600-4404
Equip Repair/Maint Services
250.00
0.00
170.50
68.20
79.50
211-4-5600-4405
Cleaning Services
30,000.00
2,490.00
12,450.00
41.50
17,550.00
211-4-5600-4409
Contractual Services
13,200.00
120.00
11,029.55
83.56
2,170.45
211-4-5600-4433
Dues & Subscriptions
100.00
0.00
0.00
0.00
100.00
TOTAL Other
Services & Charges
93,400.00
5,946.19
41,300.32
44.22
52,099.68
Capital Outlay
211-4-5600-4560
Equipment
14,500.00
0.00
9,332.61
64.36
5,167.39
TOTAL Capital Outlay
14,500.00
0.00
9,332.61
64.36
5,167.39
Transfers Out
TOTAL Library
116,000.00
6,192.16
56,093.57
48.36
59,906.43
TOTAL Culture & Recreation
116,000.00
6,192.16
56,093.57 48.36
59,906.43
TOTAL EXPENDITURES
116,000.00
6,192.16
56,093.57 48.36
59,906.43
REVENUES OVER/(UNDER) EXPENDITURES
( 14,500.00)
17,317.79 (
567.76) (
13,932.24)