LIBSR TREASURE REPORT 05-22-20125-03-2012 01:19 PM CITY OF ELK RIVER PAOE: 1
EXPENDITURES REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2012
211-LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
33.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
PEYa0nd1 Services
Supplies
211-4-5600-4201 Office Supplies
211-9-5600-4219 Operating Supplies
TOTAL Supplies
Other Services d Charges
211-4-5600-9321 Telephone
211-4-5600-9322 Postage
211-4-5600-9331 Travel, Conferences 6 Schools
211-9-5600-9359 Publishing
211-9-5600-9361 Insurance
211-9-5600-9389 Vtilities
211-9-5600-4901 Bltlg Repair/Maint Services
211-4-5600-4409 Equip Repair /Maint Services
211-4-5600-9405 Cleaning Services
211-4-5600-9409 Contractual Services
211-4-5600-9433 Dues 6 Subscriptions
TOTAL Other Services 6 Charges
Capital Outlay
Transfers Out
500. 00 0 .00 0 .00 0 .00 500 .00
15,100. 00 223. 00 2,312 .57 15. 32 12,787. 43
15,600. 00 223. 00 2, 312 . s7 19 .82 13,287 .93
1,550. 00 83. 96 336 .10 21. 66 1,213 .90
so. oo O. oa o .ao o. oo so .oo
1,300. 00 0. 00 0 .00 0. 00 1,300. 00
1,500. 00 0. 00 0 .00 0. 00 1,500. 00
2,300. 00 0. 00 1,017 . s0 99. 29 1,282. 50
28,900. 00 2,587. 39 7,051 .91 29. 83 21,398. 09
12,700. 00 102. 50 382 .50 3. 01 12,317. 50
2,200. 00 0. 00 0 .00 0. 00 2,200. 00
20, 1s0. 00 1,575. 00 6,300 .00 31. 27 13,850. 00
11,000. 00 820. 00 2,372 .93 21. 57 8,627. 57
250. 00 0. 00 0. 00 0. 00 250. 00
81,400. 00 5,168. 85 17,960 .99 21. 45 63,939. 56
TOTAL Library 97,000.00 5,391.85 19,773.01 20.38 77,226.99
TOTAL Culture s Recreation 97,000.00 5, 391.BS 19,773.01 20.38 77,226.99
TOTAL EXPENDITURES 97,000.00 5,391.85 19,773.01 20.38 77,226.99
5-03-2012 1:22 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: Apr-2012 THRU Apr-2012
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/SE # NOTE =====AMOUNT==== ====BALANCE== ==
9/02/12 3/29 A32919 CHK: 077179 01209 APRIL CLEANING SVCS 13698 1,575 .00 6,300 .00
CARLSON BUILDING SERVICES INV# 39620 /PO#
---- --------- APRIL ACTIVITY DB: 1,578_00 CR: 0.00 1,575. 00
9-56 00-4409 Contractual Services
B E G I N N I N G B A L A N C E 1,552. 93
4/02/12 3/29 A32442 CHK: 077202 01209 PROGRAM 9/4 19336 40 .00 1,592 .43
MICHELE FORSNAN INV# 090212 /PO#
4/02/12 3/29 A32493 CHK: 077203 01204 PROGRAM 9/11 19336 40 .00 1,632 .93
MICHELE FORBMAN INV# 040212. /PO#
9/02/12 3/29 A32802 CHK: 077262 01209 PROGRAM 4/12 11629 500 .00 2,132 .93
EVE RETT SM ITHS ON INV# 040212 /PO#
9/02/12 3/29 A32529 CHK: 077289 01209 PROGRAM 4/9 11963 40 .00 2,172 .93
SANDRA WELTON-WOOD INV# 040212 /PO#
9/02/12 3/29 A32828 CHK: 077285 01209 PROGRAM 9/16 11983 40 .00 2,212 .93
SANDRA WELTON-WOOD INV# 090212. /PO#
4/16/12 9/13 A32691 CHK: 077352 01212 PROGRAM 9/18 19336 90 .00 2,252 .43
MICHELE FORSMAN INV# 091612 /PO#
9/16/12 9/13 A32692 CHK: 077353 01212 PROGRAM 4/25 19336 90 .00 2,292 .93
MICHELE FORSMAN INV# 041612. /PO#
9/16/12 4/13 A32643 CHK: 077354 01212 PROGRAM 5/2 19336 90 .00 2,332 .93
MICHELE FORSMAN INV# D9162012 /PON
4/16/12 4/13 A32761 CHK: 077972 01212 PROGRAM 5/7 11483 40 .00 2,372. 43
SANDRA WELTON-WOOD INV# 091612 /PO#
----- -------- APRIL ACTIVITY DB: 820.00 CR: 0.00 820. 00
*-*-*-*-*- *-*-*-*-*-*- *-*- 000 ERRORS IN THIS REPORT! *-+_._+_+_+_+ _+_+_+_+_+_+_+
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 14,381.16 0. 00
REPORTED ACTIVITY: 5,391.85 0. 00
ENDING BALANCES: 19,773.01 0. 00
5-03-2012 1:22 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: ApY-2012 TN RU ApI-2012
DEPT 5600 Library SUPPRESS 2EAOS ACCOUNTS: ALL
POST DATE TRAM # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMODNT==== ====BALANCE====
4-5600-9219 Operating Supplies
B E G I N N I N G B ALAN C E
4/06/12 9/18 A32786 CHK: 009645 01216 FREDS FLAGS - FLAG POLE 35099
US BANK INVq 032612 /PO#
4/26/12 9/26 A32875 CHK: 0]7505 01221 BULK SALT 18697
FINKEN'S WATER CENTERS INV# 769TB /pOq
_____________ APRIL ACTIVITY DB: 2 23.00 CR: 0 .00
9-5600-4321
Telephone ________________ _____ _______ ____ ____________ ___
B E G I N N I N G B ALAN C E
4/16/12 9/13 A32762 CHK: 077973 01212 PHONE LINE CNGS 11102
WINDST REAM INVq 032812 /PO#
_____________ APRIL ACTIVITY DB: 83.96 CR: 0 .00
4-5 600-4389 Utilities
B E G I N N I N G B A L A N C E
4/02/12 3/29 A32439 CHK: 077194 01204 WATER/ELEC 17700
ELK RIVER MUNICIPAL UTILI INV# 032212 /PO#
9/02/12 3/29 A32996 CHK: 077256 01209 MAR RUBBISH SVCS 30851
RANDY'S ENVIRONMENTAL SER INVq 0902201 2 /PO#
9/02/12 5/02 890861 02392 ELECTRIC - MARCH JEq 014660
9/06/12 4/09 840177 ERMU # 061991 02302 SALES TAX DONATED EL EC JE# 019363
4/23/12 9/23 A32890 CHK: 077985 01218 NATURAL GAS 13845
CENTE RPOINT ENERGY INVq 040512 /PO#
9/29/12 4/25 840710 ERMU # 062030 02329 ELEC SALES TAX - MARCH JE# 019551
_____________ APRIL ACTIVITY OB: 2,58].39 CA: 0. 00
9-5600-4401 B1d9 Repair/Maim Services
B E G I N N I N G B ALAN C E
9/16/12 9/13 A32610 CHK: 077321 01212 DOOR REPAIRS 12256
BLA INE LOCK & SAFE, INC INV# 10191 /POq
_____________ APRIL ACTIVITY DB: 10 2.50 CR: 0. 00
9-5600-9405 Cleaning Services
B E G I N N I N G B A L A N C E
125.00
98.00
223.00
83.96
83.96
27.00
57.18
2,267.69
119.74
26.12
89.66
2,587.39
102.50
102.50
2,089.57
2,214.57
2,312.57
252.19
336.10
9,469.52
4,991.52
9,548.70
6,816.39
6,936.13
6,962.25
7,051.91
280.00
382.50
9,725.00
5-03-2012 01:18 PM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: APRIL 30TH, 2012
211-LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 929,864.31
929,864.31
TOTAL ASSETS 929,869.31
LIABILITIES
EQUITY
211-2400 Funtl Balance 442,182.47
TOTAL BEGINNING EQUITY 442,182.47
TOTAL REVENUE 7,459.85
TOTAL EXPENSES 19,773.01
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 12,318.16)
TOTAL EQUITY 6 REV. OVER/(UNDER) EXP. 929,864.31
TOTAL LIABILITIES, EQUITY E REV.OVE R/(UNDER) EXP. 429,864.31