3.2. LIBSR 05-22-20185-14-2018 09:20 AM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: APRIL 30TH, 2018
211-LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
_____________________________________________________________________________________________
ASSETS
======
211-1010 Cash - Library 433,958.44
211-1380 Interest Receivable 2,086.00
436,044.44
TOTAL ASSETS 436,044.44
==============
LIABILITIES
===========
211-2200 Deposits Payable 450.00
TOTAL LIABILITIES 450.00
EQUITY
======
211-2400 Fund Balance 437,086.72
TOTAL BEGINNING EQUITY 437,086.72
TOTAL REVENUE 30,710.91
TOTAL EXPENSES 32,203.19
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 1,492.28)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 435,594.44
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.436,044.44
==============
5-14-2018 9:22 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: Apr-2018 THRU Apr-2018
DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4219 Operating Supplies
B E G I N N I N G B A L A N C E 2,295.17
4/06/18 4/06 A80195 CHK: 105801 02888 EXTREME DUTY BLUE 13251 67.73 2,362.90
ORGANIX SOLUTIONS INV# 25279 /PO#
4/16/18 4/12 A80224 CHK: 105820 02895 SUPPLIES-BATTERIES 11835 30.60 2,393.50
BATTERIES PLUS BULBS INV# 033-946140 /PO#
4/16/18 4/12 A80263 CHK: 105859 02895 SUPPL-FLOOR OUTLET COVER 17890 479.20 2,872.70
ELK RIVER WINLECTRIC INV# 27505500 /PO#
4/16/18 4/12 A80294 CHK: 105890 02895 PARTS/SUPPLIES 25145 5.07 2,877.77
MENARDS - ELK RIVER INV# 033118 /PO#
4/16/18 4/12 A80333 CHK: 105929 02895 BULK SALT 13048 151.20 3,028.97
STEP SAVER INC INV# 116899B /PO#
============= APRIL ACTIVITY DB: 733.80 CR: 0.00 733.80
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321 Telephone
B E G I N N I N G B A L A N C E 183.43
4/02/18 3/29 A80127 CHK: 105776 02880 PHONE LINE CHGS 11102 91.58 275.01
WINDSTREAM INV# 030718 /PO#
4/24/18 4/24 A80479 CHK: 106017 02900 PHONE LINE CHGS 11102 92.14 367.15
WINDSTREAM INV# 040618 /PO#
============= APRIL ACTIVITY DB: 183.72 CR: 0.00 183.72
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4361 Insurance
B E G I N N I N G B A L A N C E 730.00
4/16/18 4/12 A80287 CHK: 105883 02895 INSURANCE ALLOCATION 23805 730.00 1,460.00
LEAGUE OF MN CITIES INS T INV# 40001014.2-2018 /PO#
============= APRIL ACTIVITY DB: 730.00 CR: 0.00 730.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389 Utilities
B E G I N N I N G B A L A N C E 5,974.11
4/03/18 3/29 A80147 EFT: 000331 02882 WATER/ELEC 17700 2,853.85 8,827.96
ELK RIVER MUNICIPAL UTILI INV# 031418 /PO#
4/03/18 3/29 A80150 EFT: 000334 02882 MARCH RUBBISH SVCS 30851 58.35 8,886.31
RANDY'S ENVIRONMENTAL SER INV# 135818-031918 /PO#
============= APRIL ACTIVITY DB: 2,912.20 CR: 0.00 2,912.20
5-14-2018 9:22 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: Apr-2018 THRU Apr-2018
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 1,365.00
4/02/18 3/29 A80078 CHK: 105727 02880 HEAT PUMP REPAIRS 12078 295.00 1,660.00
MASSMANN GEOTHERMAL INV# 1000332 /PO#
4/02/18 3/29 A80078 CHK: 105727 02880 HEAT PUMP REPAIRS 12078 125.00 1,785.00
MASSMANN GEOTHERMAL INV# 1000333 /PO#
4/16/18 4/12 A80246 CHK: 105842 02895 HVAC REPAIRS 13024 980.00 2,765.00
CORPORATE MECHANICAL INC INV# W23415 /PO#
============= APRIL ACTIVITY DB: 1,400.00 CR: 0.00 1,400.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4404 Equip Repair/Maint Services
B E G I N N I N G B A L A N C E 0.00
4/02/18 3/29 A80094 CHK: 105743 02880 FIRE EXTINGUISHER SVCS 11955 13.90 13.90
RICHFIELD FIRE EXTINGUISH INV# 112433 /PO#
============= APRIL ACTIVITY DB: 13.90 CR: 0.00 13.90
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405 Cleaning Services
B E G I N N I N G B A L A N C E 2,490.00
4/02/18 3/29 A80086 CHK: 105735 02880 MARCH CLEANING SVCS 12651 1,245.00 3,735.00
PERFECTION PLUS, INC. INV# 1128545 /PO#
4/24/18 4/24 A80455 CHK: 105993 02900 APRIL CLEANING SVCS 12651 1,245.00 4,980.00
PERFECTION PLUS, INC. INV# 1128596 /PO#
============= APRIL 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 10,320.00
4/02/18 3/29 A80100 CHK: 105749 02880 PROGRAM 4/9 13060 40.00 10,360.00
ROBIN SCHAIBLE INV# 040918 /PO#
4/02/18 3/29 A80101 CHK: 105750 02880 PROGRAM 4/13 13060 40.00 10,400.00
ROBIN SCHAIBLE INV# 041318 /PO#
4/02/18 3/29 A80102 CHK: 105751 02880 PROGRAM 4/16 13060 40.00 10,440.00
ROBIN SCHAIBLE INV# 041618 /PO#
4/16/18 4/12 A80320 CHK: 105916 02895 PROGRAM 4/23 13060 40.00 10,480.00
ROBIN SCHAIBLE INV# 042318 /PO#
4/16/18 4/12 A80321 CHK: 105917 02895 PROGRAM 4/30 13060 40.00 10,520.00
ROBIN SCHAIBLE INV# 043018 /PO#
4/16/18 4/12 A80322 CHK: 105918 02895 PROGRAM 5/4 13060 40.00 10,560.00
ROBIN SCHAIBLE INV# 050418 /PO#
5-14-2018 9:22 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: Apr-2018 THRU Apr-2018
DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
4/16/18 4/12 A80323 CHK: 105919 02895 PROGRAM 5/7 13060 40.00 10,600.00
ROBIN SCHAIBLE INV# 050718 /PO#
4/24/18 4/24 A80459 CHK: 105997 02900 REIMB SUPPLIES 13060 101.86 10,701.86
ROBIN SCHAIBLE INV# 040118 /PO#
============= APRIL ACTIVITY DB: 381.86 CR: 0.00 381.86
*-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! *-*-*-*-*-*-*-*-*-*-*-*-*-*
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 23,357.71 0.00
REPORTED ACTIVITY: 8,845.48 0.00
ENDING BALANCES: 32,203.19 0.00
TOTAL FUND ENDING BALANCE: 32,203.19
5-14-2018 09:21 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2018
211-LIBRARY
FINANCIAL SUMMARY 33.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
___________________________________________________________________________________________________________________
REVENUE SUMMARY
Library 88,850.00 0.00 30,710.91 34.56 58,139.09
TOTAL REVENUES 88,850.00 0.00 30,710.91 34.56 58,139.09
============= ============= ============= ======= =============
EXPENDITURE SUMMARY
Culture & Recreation
Library 118,850.00 8,845.48 32,203.19 27.10 86,646.81
TOTAL Culture & Recreation 118,850.00 8,845.48 32,203.19 27.10 86,646.81
TOTAL EXPENDITURES 118,850.00 8,845.48 32,203.19 27.10 86,646.81
============= ============= ============= ======= =============
REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00)( 8,845.48)( 1,492.28) ( 28,507.72)
5-14-2018 09:21 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2018
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 54,000.00 0.00 0.00 0.00 54,000.00
TOTAL Taxes 54,000.00 0.00 0.00 0.00 54,000.00
Intergovernmental Rev _____________ _____________ _____________ _______ _____________
Charges for Services _____________ _____________ _____________ _______ _____________
Other Revenue
211-3-0000-3621 Interest Income 6,500.00 0.00 2,360.91 36.32 4,139.09
TOTAL Other Revenue 6,500.00 0.00 2,360.91 36.32 4,139.09
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 88,850.00 0.00 30,710.91 34.56 58,139.09
Library Project
===============
Other Financing Sources _____________ _____________ _____________ _______ _____________
Transfers In _____________ _____________ _____________ _______ _____________
_____________________________________________________________________________
___________________________________________________________________________________________________________________
TOTAL REVENUE 88,850.00 0.00 30,710.91 34.56 58,139.09
============= ============= ============= ======= =============
5-14-2018 09:21 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2018
211-LIBRARY
Culture & Recreation 33.33% 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 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,750.00 733.80 3,028.97 31.07 6,721.03
TOTAL Supplies 9,850.00 733.80 3,028.97 30.75 6,821.03
Other Services & Charges
211-4-5600-4321 Telephone 1,100.00 183.72 367.15 33.38 732.85
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,200.00 730.00 1,460.00 66.36 740.00
211-4-5600-4389 Utilities 28,250.00 2,912.20 8,886.31 31.46 19,363.69
211-4-5600-4401 Bldg Repair/Maint Services 14,750.00 1,400.00 2,765.00 18.75 11,985.00
211-4-5600-4404 Equip Repair/Maint Services 250.00 13.90 13.90 5.56 236.10
211-4-5600-4405 Cleaning Services 17,500.00 2,490.00 4,980.00 28.46 12,520.00
211-4-5600-4409 Contractual Services 13,200.00 381.86 10,701.86 81.07 2,498.14
211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00
TOTAL Other Services & Charges 78,500.00 8,111.68 29,174.22 37.16 49,325.78
Capital Outlay
211-4-5600-4560 Equipment 30,000.00 0.00 0.00 0.00 30,000.00
TOTAL Capital Outlay 30,000.00 0.00 0.00 0.00 30,000.00
Transfers Out _____________ _____________ _____________ _______ _____________
___________________________________________________________________________________________________________________
TOTAL Library 118,850.00 8,845.48 32,203.19 27.10 86,646.81
___________________________________________________________________________________________________________________
TOTAL Culture & Recreation 118,850.00 8,845.48 32,203.19 27.10 86,646.81
___________________________________________________________________________________________________________________
TOTAL EXPENDITURES 118,850.00 8,845.48 32,203.19 27.10 86,646.81
============= ============= ============= ======= =============
REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00)( 8,845.48)( 1,492.28) ( 28,507.72)