3.2. LIBSR 08-01-2017 5,
6-08-2017 02:04 PM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: MAY 31ST, 2017
211-LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 429,153.50
211-1380 Interest Receivable 1,838.00
430,991.50
TOTAL ASSETS 430,991.50
--------------
LIABILITIES
211-2200 Deposits Payable 600.00
TOTAL LIABILITIES 600.00
EQUITY
211-2400 Fund Balance 428,065.37
TOTAL BEGINNING EQUITY 428,065.37
TOTAL REVENUE 30,752.55
TOTAL EXPENSES 28,426.42
TOTAL REVENUE OVER/(UNDER) EXPENSES 2,326.13
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 430,391.50
TOTAL LIABILITIES, EQUITY & REV,OVER/(UNDER) EXP, 430,991.50
6-08-2017 2:06 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: May-2017 THRU May-2017
DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE IRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====B CE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4219 Operating Supplies
B E G I N N I N G B A L A N C E 1,730.29
5/01/17 4/26 A72626 CHK: 101460 02607 BULK SALT 13048 81.20 1,811.49
STEP SAVER INC INV# 108697A /PO#
5/01/17 4/26 A72639 CHK: 101473 02607 LIGHTING 35861 679.90 2,491.39
VOSS LIGHTING INV# 15300329-00 /PO#
5/24/17 5/24 A73008 CHK: 101719 02625 SUPPLIES 15887 268.98 2,760.37
DACOTAH PAPER CO INV# 77701 /PO#
5/24/17 5/24 A73045 CHK: 101756 02625 BULK SALT 13048 67.20 2,827.57
STEP SAVER INC INV# 109214 /PO#
MAY ACTIVITY DB: 1,097.28 CR: 0.00 1,097.28
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321 Telephone
BEG I NN I NG BALANCE 274.67
5/08/17 5/08 A72729 CHK: 101516 02612 PHONE LINE CHGS 11102 91.10 365.77
WINDSTREAM INV# 040717 /PO#
5/24/17 5/24 A73056 CHK: 101767 02625 PHONE LINE CHCS 11102 92.34 458.11
WINDSTREAM INV# 050817 /PO#
MAY ACTIVITY DB: 183.44 CR: 0.00 183.44
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389 Utilities
B E G I N N I N G B A L A N C E 7,579.49
5/02/17 4/26 A72668 EFT: 000139 02609 APRIL RUBBISH SVCS 30851 58.35 7,637.84
RANDY'S ENVIRONMENTAL SER INV# 135818-04/19/17 /PO#
5/15/17 5/09 A72747 EFT: 000143 02620 WATER/ELEC 17700 2,812.63 10,450.47
ELK RIVER MUNICIPAL UTILI INV# 042417 /PO#
MAY ACTIVITY DB: 2,870.98 CR: 0.00 2,870.98
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401 Bldg Repair/Maint Services
B E G I N N I N G B A L A N C E 650.75
5/15/17 5/10 A72797 CHK: 101556 02614 EXTERIOR WINDOW CLNG 16448 205.00 855.75
DISTINCTIVE WINDOW CLEANI INV# 8771 /PO#
5/15/17 5/10 A72818 CHK: 101577 02614 GLASS INSTALLATION 10467 3,772.00 4,627.75
J & A GLASS, INC INV# 19041INV /PO#
5/15/17 5/10 A72880 CHK: 101639 02614 LAWN SERVICES 11661 91.26 4,719.01
SPEEDCUTTERS OUTDOOR MAIN INV# 4768 /PO#
MAY ACTIVITY DB: 4,068.26 CR: 0.00 4,068.26
6-08-2017 2:06 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: May-2017 THRU May-2017
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST BATE THAN # REFERENCE PACKET======DESCRIPTTON======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====J3ALANCE==--
____________________________________________________________________________________________________________________________________
4-5600-4405 Cleaning Services
B E G I N N I N G B A L A N C E 4,980.00
5/15/17 5/10 A72855 CHK: 101614 02614 MAY CLEANING SVCS 12651 1,245.00 6,225.00
PERFECTION PLUS, INC. INV# 1128033 /PO#
MAY ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00
-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4409 Contractual Services
B E G I N N I N G S A L A N C E 2,230.00
5/01/17 4/26 A72612 CHK: 101446 02607 REIMS PROGRAM SUPPLIES 13060 39.86 2,269.86
ROBIN SCHAIBLE INV# 05012017 /PO#
5/01/17 4/26 A72613 CHK: 101447 02607 PROGRAM 5/3 13060 40.00 2,309.86
ROBIN SCHAIBLE INV# 050317 /PO#
5/01/17 4/26 A72614 CHK: 101448 02607 PROGRAM 5/5 13060 40.00 2,349.86
ROBIN SCHAIBLE INV# 050517 /PO*
5/01/17 4/26 A72615 CHK: 101449 02607 PROGRAM 5/8 13060 40.00 2,389.86
ROBIN SCHAIBLE INV# 050817 /PO#
5/01/17 4/26 A72616 CHK: 101450 02607 PROGRAM 5/10 13060 40.00 2e429.86
ROBIN SCHAIBLE INV# 051017 /PO#
5/01/17 4/26 A72617 CHK: 101451 02607 PROGRAM 5/15 13060 40.00 2,469.86
ROBIN SCHAIBLE INV# 051517 /Poo
5/15/17 5/10 A72866 CHK: 101625 02614 PROGRAM 5/17 13060 40.00 2,509.86
ROBIN SCHAIBLE INV# 051717 /PO#
5/15/17 5/10 A72867 CHK: 101626 02614 PROGRAM 5/22 13060 40.00 2,549.86
ROBIN SCHAIBLE INV* 052217 /PO#
3/15/17 5/10 A72868 CHK: 101627 02614 PROGRAM 5/24 13060 40.00 2,589.86
ROBIN SCHAIBLE INV# 052417 /PO#
5/15/17 5/10 A72869 CHK: 101628 02614 PROGRAM 5/31 13060 40.00 2,629.86
ROBIN SCHAIBLE INV# 053117 /PO*
5/15/17 5/10 A72870 CHK: 101629 02614 PROGRAM 6/2 13060 40.00 2,669.86
ROBIN SCHAIBLE INV# 060217 /PO#
5/15/17 5/10 A72871 CHK: 101630 02614 PROGRAM 6/5 13060 40.00 2,709.86
ROBIN SCHAIBLE INV# 060517 /PO#
MAY ACTIVITY DB: 479.86 CR: 0.00 479.86
6-08-2017 2:06 PM D E T A I L L I S T I N G PAGE: 3
FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: May-2017 THRU May-2017
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
000 ERROR$ IN THIS REPORT!
** REPORT TOTALS --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 18,481.60 0.00
REPORTED ACTIVITY: 9,944.82 0.00
ENDING BALANCES: 28,426.42 0.00
TOTAL FUND ENDING BALANCE: 28,426.42
6-08-201`1 02:05 PM CITY OF ELK RIVER PAGE: I
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2017
211—LIBRARY
FINANCIAL SUMMARY 41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Library 87,500.00 0.00 30,752.55 35.15 56,747.45
TOTAL REVENUES 8"7,500.00 0.00 30,752.55 35.15 56,747.45
r.fl,i DI TURF '31:l"K P"
PO1AI., Culture t1 1 a` )}.( 1 c,r1 ,tL >;ap, 12 6, -2 27.
l.V11l
TOTAL 1lf'llk;NW"I°lJRES 'ia7 ,00,00 9,944,8 2 28,1.6,4 9,:16 4;U 073 -,8
REVENUES OVER/(UNDER) EXPENDITURES t 10,000.00) ( 9,944.82) 2,326.13 ( 12,326.13)
6-08-2017 02:05 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2017
211-LIBRARY
41.67% 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 53,650.00 0.00 0.00 0 00 53,650.00
TOTAL Taxes 53,650.00 0.00 0.00 0.00 53,650.00
Intergovernmental Rev
Charges for Services
Other Revenue
211-3-0000-3621 Interest Income 5,500.00 0.00 2,402.55 43.68 3,097.45
TOTAL Other Revenue 5,500.00 0.00 2,402.55 43.68 3,097.45
Transfers In
211-3-0000-3945 Transfer-Utilities 28,350.00 0.00 28,350.00 100.00 0.00
TOTAL Transfers In 28,350.00 0.00 28,350.00 100.00 0.00
TCl17V, ba)y 87,500.00 0.00 30,752.55 35.15 56,747.45
�JL,i,ary Proj4��:I.
Other Financing Sources
Transfers In
TOTAL REVENUE 87,500.00 0.00 30,752.55 35.15 56,747.45
6-08-2017 02:05 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2017
211-LIBRARY
Culture & Recreation 41.67% OF YEAR COMP.
Library
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
211-4-5600-4103 Part-time Pay 500.00 0.00 0.00 0.00 500.00
TOTAL Personal Services 500.00 0.00 0.00 0.00 500.00
Supplies
211-4-5600-4201 Office Supplies 100.00 0.00 0.00 0.00 100.00
211-4-5600-4219 Operating Supplies 9,650.00 1,097,28 2,827.57 29.30 6,822,43
TOTAL Supplies 9,750.00 1,097,28 2,827.57 29.00 6,922,43
Other Services & Charges
211-4-5600-4321 Telephone 1,100.00 183.44 458.11 41.65 641.89
211-4-5600-4331 Travel, Conferences & Schools 650.00 0.00 0.00 0.00 650.00
211-4-5600-4359 Publishing 1,500.00 0,00 0.00 0.00 1,500.00
211-4-5600-4361 Insurance 2,150.00 0.00 1,022,50 47.56 1,127.50
211-4-5600-4389 Utilities 29,450.00 2,870.98 10,450.47 35.49 18,999.53
211-4-5600-4401 Bldg Repair/Maint Services 16,050.00 4,068.26 4,719.01 29.40 11,330.99
211-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 13.90 5.56 236.10
211-4-5600-4405 Cleaning Services 15,000.00 1,245.00 6,225.00 41.50 8,775.00
211-4-5600-4409 Contractual Services 11,000.00 479.86 2,709.86 24.64 8,290.14
211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00
TOTAL Other Services & Charges 77,250.00 8,847.54 25,598.85 33.14 51,651.15
Capital Outlay
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 0.00 0.00 10,000.00
Transfers Out
_.- ....
TOTAL Library 97,500.00 9,944„82 28,426.42 29.16 69,073.58
TOTAL Culture & Recreation 97,500.00 9,944.82 28,426.42 29.16 69,073.58
TOTAL EXPENDITURES 97,500.00 9,944.82 28,426.42 29.16 69,073,58
REVENUES OVER/(UNDER) EXPENDITURES ( 10,000,00)( 9,944,82) 2,326.13 ( 12,326.13)
7-10-2017 09:57 AM CITY OF ELK RIVER PAGE° 1
BALANCE SHEET
AS OF: JUNE 30TH, 2017
211-LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 445,084.66
211-1380 Interest Receivable 1,838.00
446,922.66
TOTAL ASSETS 446,922.66
LIABILITIES
211-2200 Deposits Payable 500.00
TOTAL LIABILITIES 500.00
EQUITY
211-2400 Fund Balance 428,065.37
TOTAL BEGINNING EQUITY 428,065.37
TOTAL REVENUE 51,270.04
TOTAL EXPENSES 32,912.75
TOTAL REVENUE OVER/(UNDER) EXPENSES 18,357.29
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 446,422.66
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 446,922.66
7-10-2017 10: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: Jun-2017 THRU Jun-2017
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE IRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321 Telephone
B E G I N N I N G B A L A N C E 458.11
6/26/17 6/26 A73634 CHK: 102204 02648 PHONE LINE CHGS 11102 91.39 549.50
WINDSTREAM INV# 060717 /PO#
JUNE ACTIVITY DB: 91.39 CR: 0.00 91.39
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389 Utilities
B E G I N N I N G B A L A N C E 10,450.47
6/06/17 5/31 A73077 EFT: 000152 02634 MAY RUBBISH SVCS 30851 58.35 10,508.82
RANDY'S ENVIRONMENTAL SER INV# 135818-051917 /PO#
6/15/17 6/13 A73385 EFT: 000156 02643 WATER/ELEC 17700 2,263.88 12,772.70
ELK RIVER MUNICIPAL UTILI INV# 052217 /PO#
JUNE ACTIVITY DB: 2,322.23 CR: 0.00 2,322.23
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401 Bldg Repair/Maint Services
BEG I NN I NG B A L A N C E 4,719.01
6/05/17 5/31 A73269 CHK: 101948 02630 MOWING SVCS CONTRACT 11661 428.46 5,147.47
SPEEDCUTTERS OUTDOOR MAIN INV# 4779 /PO#
JUNE ACTIVITY DB: 428.46 CR: 0.00 428.46
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405 Cleaning Services
B E G I N N I N G B A L A N C E 6,225.00
6/19/17 6/14 A73494 CHK: 102109 02642 JUNE CLEANING SVCS 12651 1,245.00 7,470.00
PERFECTION PLUS, INC. INV# 1128084 /PO#
------------_-- JUNE ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4409 Contractual Services
B E G I N N I N G B A L A N C E 2,709.86
6/05/17 5/31 A73258 CHK: 101937 02630 PROGRAM 6/7 13060 40.00 2,749.66
ROBIN SCHAIBLE INV# 060717 /PO#
6/05/17 5/31 A73259 CHK: 101938 02630 PROGRAM 6/19 13060 40.00 2,789.86
ROBIN SCHAIBLE INV# 061917 /PO#
6/19/17 6/14 A73509 CHK: 102124 02642 PROGRAM 6/21 13060 40.00 2,829.86
ROBIN SCHAIBLE 1NV# 062117 /PO#
6/19/17 6/14 A73510 CHK: 102125 02642 PROGRAM 6/26 13060 40.00 2,869.86
ROBIN SCHAIBLE INV# 062617 /PO#
7-10-2017 10: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: Jun-2017 THRU Jun-2017
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE IRAN # REFERENCE PACKET---=--DESCRIPTION-=--- VEND INV/PO/JE # NOTE =====AMOUNT===- ====BALANCE==--
6/19/17 6/14 A73511 CHK: 102126 02642 PROGRAM 6/28 13060 40.00 2,909.86
ROBIN SCHAIBLE INV# 062817 /PO#
6/19/17 6/14 A73512 CHK: 102127 02642 PROGRAM 7/3 13060 40.00 2,949.86
ROBIN SCHAIBLE INV# 070317 /PO*
JUNE ACTIVITY DB: 240.00 CR: 0.00 240.00
000 ERRORS IN THIS REPORT!
** REPORT TOTALS --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 28,426.42 0.00
REPORTED ACTIVITY: 4,327.08 0.00
ENDING BALANCES: 32,753.50 0.00
TOTAL FUND ENDING BALANCE: 32,753.50
1..0-20 l i GI'di 7 01 ^..:"..0"1', CI ?B i"iit°�I!',, 1A,G-1: '.Y..
'?INTI„WNI¢ '� EXPENSE h NSE V!+W I hf'
211-LIBRARY
FINANCIAL SUMMARY 50.00% OF YEAR COMP,
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Library 87,500.00 19,402.40 51,270.04 58.59 36,229.96
TOTAL REVENUES 87,500.00 19,402.40 51,270.04 58.59 36,229.96
EXPENDITURE SUMMARY
Culture & Recreation
Library 97,500.00 4,486.33 32,912.75 33.76 64,587.25
TOTAL Culture & Recreation 97,500.00 4,486.33 32,912.75 33.76 64,587.25
TOTAL EXPENDITURES 97,500.00 4,486.33 32,912.75 33.76 64,587.25
------------- ------------- ------------- ------- -------------
REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00) 14,916.07 18,357.29 ( 28,357.29)
7-10-2017 09:59 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2017
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 53,650.00 19,402.40 19,402.40 36.16 34,247.60
TOTAL Taxes 53,650.00 19,402.40 19,402.40 36.16 34,247.60
Intergovernmental Rev
Charges for Services
Other Revenue
211-3-0000-3621 Interest Income 5,500.00 0.00 3,517.64 63.96 1,982.36
TOTAL Other Revenue 5,500.00 0.00 3,517.64 63.96 1,982.36
Transfers In
211-3-0000-3945 Transfer-Utilities 28,350.00 0.00 28,350.00 100.00 0.00
TOTAL Transfers In 28,350.00 0.00 28,350.00 100.00 0.00
TOTAL Library 87,500.00 19,402.40 51,270.04 58.59 36,229.96
Library Project
Other Financing Sources
Transfers In
TOTAL REVENUE 87,500.00 19,402.40 51,270.04 58.59 36,229.96
7-10-2017 09:59 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2017
211-LIBRARY
Culture & Recreation 50.00% OF YEAR COMP.
Library
CURRENT CURRENT YEAR TO DATE % OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
211-4-5600-4103 Part-time Pay 500.00 159.25 159.25 31.85 340.75
TOTAL Personal Services 500.00 159.25 159.25 31.85 340.75
Supplies
211-4-5600-4201 Office Supplies 100.00 0.00 0.00 0.00 100.00
211-4-5600-421.9 Operating Supplies 9,650.00 0.00 2,827.57 29.30 6,822.43
TOTAL Supplies 9,750.00 0.00 2,827.57 29.00 6,922.43
Other Services & Charges
211-4-5600-4321 Telephone 1,100.00 91.39 549.50 49.95 550.50
211-4-5600-4331 Travel, Conferences & Schools 650.00 0.00 0.00 0.00 650.00
211-4-5600-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00
211-4-5600-4361 Insurance 2,150.00 0.00 1,022.50 47.56 1,127.50
211-4-5600-4389 Utilities 29,450.00 2,322.23 12,772.70 43.37 16,677.30
211-4-5600-4401 Bldg Repair/Maint Services 16,050.00 428.46 5,147.47 32.07 10,902.53
211-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 13.90 5.56 236.10
211-4-5600-4405 Cleaning Services 15,000.00 1,245.00 7,470.00 49.80 7,530.00
211-4-5600-4409 Contractual Services 11,000.00 240.00 2,949.86 26.82 8,050.14
211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00
TOTAL Other Services & Charges 77,250.00 4,327.08 29,925.93 38.74 47,324.07
Capital Outlay
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 0.00 0.00 10,000.00
Transfers Out
TOTAL Library 97,500.00 4,486.33 32,912.75 33.76 64,587.25
TOTAL Culture & Recreation 97,500.00 4,486.33 32,912.75 33.76 64,587.25
TOTAL EXPENDITURES 97,500.00 4,486.33 32,912.75 33.76 64,587.25
REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00) 14,916.07 18,357.29 ( 28,357.29)