LIBSR TREASURERS REPORT 01-24-2012-06-2011 09:02 AM CITY OF ELK RIVER PAGE: 1 ~~+~' w '~
BALANCE SHEET
AS OF: NOVEMBER 30TH, 2011
L-LIBRARY
:COUNT M ACCOUNT DESCRIPTION
BALANCE
iETS
L-1010 Cash - Library 914,115.94
TOTAL ASSETS
'9B IL ITIES
JITY
L-2400 Fund Balance 423,355.65
TOTAL BEGINNING EQUITY 923,355.65
TOTAL REVENUE 55,394.62
TOTAL EXPENSES 64,589.33
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 9,239.71)
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
TOTAL LIABILITIES, EQUITY 6 REV.OVER/(UNDER) EXP.
919,115.94
419,115.99
919,115.99
914,115.99
12-06-2011 9:05 AM D ETA I L L I S T I N G PAGE: 1 "~~
FUN D 211- LIBRARY ACTIVE ACCOUNT S ONLY PER IOD TO USE: Nov-2011 THRV Nov- 2011
DEPT 5600 Library SUPPRESS 2ER05 ACCOUNTS : ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT---- --- -BALANCE====
9-5600-9201 Office Suppli es
B E G I N N I N G B A L A N C E 101.19
11/07/11 11/09 A28716 GHK: 075478 01078 SUPPLIES 29650 10 .09 111. 28
TERRY PFLEGHAAR INV# 110711 /PO#
11/21/17 11/18 A28999 CHK: 075fi82 01089 CARTRIDGE FOR LABEL MAKE 33250 25 .69 136 .92
MARGARET STOPPERS INV# 112111 /PO#
_____________ NOVEMBER ACTIVITY DB: 35.73 CR: 0. 00 35. 73
9-5600-4219 Operating Supplies
B E G I N N I N G B A L A N C E 7,719. 91
11/07/11 11/09 A28698 CHK: 075410 01078 BULK SALT 18647 101 .08 7,820 .99
FINKEN'S WATER CENTERS INV# 76539TA /PO#
11/21/11 11/18 A28693 CHK: 075581 01089 ICE MELTER 13866 83 .79 7,909 .28
CENTRAL IRRIGATION SUPPLY INV# 6020898-00 /PO#
11/21/11 11/18 A29000 CHK: 075688 01069 LIGHTING CREDIT 35861 29 .3DCR 7,879 .98
VOSS LIGHTING INV# 15189791-00 /PO#
11/21/11 11/18 A29000 CNK: 075688 01089 LIGHTING 35861 29 .30 7,904 .28
VOSS LIGHTING INV# 15188605-00 /PO#
11/21/11 11/18 A29000 CHK: 075688 01089 LIGHTING 35861 52 .50 7,956 .78
VOSS LIGHTING INV# 15188650-00 /PO#
11/21/11 11/18 A29000 CHK: 075688 01089 LIGHTING 35861 72 .50 8,029 .28
VOSS LIGHTING INV# 15189940-00 /PO#
_____________ NOVEMBER ACTIVITY OB: 339.17 CR: 24. 30CR 309. 87
4-5600-4 321 Telephone
B E G I N N I N G B ALAN C E 927. 09
11/21/11 11/18 A29008 CHK: 075696 01089 PHONE LINE CHGS 11102 89 .25 1,011 .34
WINDST REAM INV# 102711 /PO#
_____________ NOVEMBER ACTIVITY OB: 89.25 CR: 0. 00 84. 25
9-5600-9 389 Utilities
B E G I N N I N G B A L A N C E 19, 989. 77
11/04/11 11/07 836979 ERMU # 053446 02029 ELEC SALES TAX - SE PT JE# 012660 70 .85 20,060 .62
11/07/11 11/09 A28632 CHK: 075399 01078 WATER/ELEC 17700 92 .50 20,103 .12
ELK RIVER MUNICIPAL UTILI INV# 102511 /PO#
11/07/11 11/09 A28728 CHK: 075490 01078 OCT RUBBISH SVCS 30851 57 .18 20,160 .30
AANDY'S ENVIRONMENTAL SER INV# 11072011 /PO#
11/07/11 12/02 837359 02068 ELECTRIC - OCT JE# 012932 1,759 .58 21,919 .88
12-06-2011 9:05 AM
FUND 211-LIBRARY
DEPT 5600 Library
POST DATE TARN # REFERENCE
11/29/11 11/29 A29054 CHK: 075705
D E T A I L L I S T I N G PAGE: 2
ACTIVE ACCOUNTS ONLY PERIOD TO USE: Nov-2011 THRU Nov-2011
SUPPRESS ZEROS ACCOUNTS: ALL
PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
01095 NATURAL GAS 13895 18.18 21,938.0E
CENTERPOINT ENERGY INV# 110911 /PO#
NOVEMBER ACTIVITY DB: 1,948.29 CR: 0.00 1,948.29
9-5600-4901 Bldg Repair/Maint Services
B E G I N N I N G H ALAN C E
11/07/11 11/04 A28591 CHK: 075353
11/07/11 11/04 A28619 CHK: 075381
11/07/11 11/04 A28626 CHK: 075388
11/21/11 11/18 A28932 CHK: 075620
11/21/11 11/18 A28992 CHK: 075630
11/21/11 11/18 A28979 CHK: 075667
01078 FIRE ALARM REPAIR
BAN-KOE SYSTEMS INC
01078 PEST CONTROL
COUNTRY SIDE PEST CONTROL
01078 EXTERIOR GLASS CLEi
DISTINCTIVE WINDOW CLEANI
01089 WINTERIZATION SVCS
GREAT NORTHERN LANDSCAPES
01089 OCT MOWING SVCE
JEREMY'S LAWN SERVICE
01089 LAWN MAINT
JOHN R HOPKO
NOVEMBER ACTIVITY OB:
11139
INV# 63803
15191
INV# 6895
~N ING 16448
INV# 78676
10107
INV# 8943
22681
INV# 5839
30260
INV# 299333
2,683.45 CR
9-5600-9405 Cleaning Services
B E G I N N I N G B A L A N C E
11/07/11 11/09 A28609 CHK: 075371 01078 NOV CLEANING SVCS 13698
CARLS ON BUILDING SERVICES INV# 37729
_____________ NOVEMBER ACTIVITY DB: 1,575.00 CR:
/PO#
/PO#
/PO#
/PO#
/PO#
/PO#
0.00
/PO#
0.00
4-5600-9909 Contractual Services
B E G I N N I N G B A L A N C E
11/07/11 11/04 A28652 CHK: 075919
11/07/11 11/09 A28653 CHK: 075415
11/07/11 11/04 A28659 CHK: 075916
11/07/11 11/09 A28731 CHK: 075993
11/07/11 11/09 A28771 CHK: 075533
11/07/11 11/09 A28771 CHK: 075533
01078 PROGRAM SUPPLIES
MICHELE FORSMAN
01078 PROGRAM 11/9
MICHELE FORSMAN
01078 PROGRAM 11/16
MICHELE FORSMAN
01078 PROGRAM 11/17
RAPTOR CENTER
01078 PROGRAM SUPPLIES
SANDRA WELTON-WOOD
01078 PROGRAM SUPPLIES
SANDRA WELTON-WOOD
19336
INV# 110711
19336
INV# 110711.
19336
INV# 11072011
30855
INV# 110711
11983
INV# 110711
11983
INV# 110711
/PO#
/PO#
/PO#
/PO#
/PO#
/PO#
952.95
75.00
205.00
121.00
930.00
900.00
2,683.95
1,575.00
1,575.00
32.52
90.00
90.00
275.00
11.76
14.47
4,379.77
5,332.22
5,407.22
5,612.22
5,733.22
6,163.22
7,063.22
15,750.00
17,325.00
5,653.90
5,685.92
5,725.92
5,765.92
6,040.92
6,052.68
6,067.15
12-06-2011 9:05 AM D E T A I L L I S T I N G PAGE: 3
FUND 211-LIBRARY ACTIVE ACCOUN TS ONLY PERIOD T O USE: Nov-2011 THRU Nav-2011
DEPT 5600 Libiaiy SUPPRESS Z EROS ACCOUNTS : ALL
POST DATE TRAN k REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE k NOTE =====AMOU NT==== ====BALANCE====
11/07/11 11/09 A28772 CHK: 075539 01078 PROGRAM 11/19 11483 40 .00 6,107. 15
SANDRA WELTON-WOOD INV# 110711. /POd
11/07/11 11/04 A28773 CHK: 075535 01078 PROGRAM 11/21 11483 90 .00 6,147. 15
SANDRA WELTON-WOOD INV# 11072011 /PO#
11/21/11 11/18 A28925 GHK: 075613 01089 PROGRAM 11/23 19336 40 .00 6,187. 15
MICHELE FORSNAN INV# 112111 /POk
11/21/11 11/18 A28926 CHK: 075619 01089 PROGRAM 11/30 19336 90 .00 6,227. 15
MICHELE FORSMAN INVk 112111. /PO#
11/21/11 11/18 A29005 CHK: 075693 01089 PROGRAM 11/28 11483 40 .00 6,267. 15
SANDRA WELTON-WOOD INVk 112111 /PO#
11/21/11 11/18 A29006 CHK: 075694 01089 PROGRAM 12/5 11983 40 .00 6,307. 15
SANDRA WELTON-WOOD INV# 112111. /PO#
_____ ________ NOVEMBER ACTIVITY DB: fi 53.75 CR: 0. 00 653. 75
*'*-*-*'*'*-*-* -*'*-*-*-*- 000 ERRORS IN THIS REPORTt +_+_+_+_+_+_+ _+_s_+_+ _+_+_+
** REPORT TOTALS ** --- DEBITS --- --- C REDITS ---
BEGINNING BALANCES: 57,293.99 0. 00
REPORTED ACTIVITY: 7,319.69 24. 30CR
ENDING BALANCES: 64,608.63 29 . 30CR
12-06-2011 09:03 AM
211-LIBRARY
Culture b Recreation
Library
DEPARTMENTAL EXPENDITURES
PAGE: 1
91.fi7$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
Supplies
211-9-5600-4201 Office Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other Services 6 Charges
211-9-5600-4321 Telephone
211-4-5600-9322 Postage
211-9-5600-4331 Travel, Conferences & Schools
211-4-5600-9359 Publishing
211-9-5600-4361 Insurance
211-4-5600-9389 Utilities
211-9-5600-4901 Bldg Repair/Maim Services
211-9-5600-9409 Equip Repair/Maim Services
211-4-5600-4905 Cleaning Services
211-9-5600-9409 Contractual Services
211-9-5600-4933 Dues b Subscriptions
TOTAL Other Services 6 Charges
Capital Outlay
Transfers Out
500 .00 35 .73 136 .92 27 .38 363 .08
19,350 .00 309 .87 8,029 .28 55 .95 fi, 320 .72
14,850. 00 345 .60 8,166 .20 59 .99 6,683 .80
1,950. 00 89. 25 1,011 .39 69 .75 438. 66
50. 00 0. 00 0 .00 0 .00 50. 00
1,500. 00 0. 00 0 .00 0 .00 1,500. 00
1,500. 00 0. 00 337. 86 22 .52 1,162. 14
2,950. 00 0. 00 1,059. 50 35 .92 1,890. 50
28,400. 00 1,998. 29 21,938. 06 77 .25 6,961. 99
12,700. 00 2,683. 95 7,063. 22 55. 62 5,636. 78
2,200. 00 0. 00 1,301. 00 59. 14 899. 00
20,150. 00 1,575. 00 17,325. 00 85. 98 2,825. 00
11,000. 00 653. 75 6,307. 15 57. 34 4,692. 85
250. 00 0. 00 75. 00 30. 00 175. 00
82,150. 00 6,944. 74 56,918. 13 68. 68 25,731. 87
CITY OF ELK RIVER
EX PENOIT URES REPORT (UNAUDITED)
AS OF: NOVEMBER 30TH, 2011
`['f `D
TOTAL Library 97,000.00 7,290.34 64,589.33 66.58 32,915.67
2012 BUDGET DETAIL SHEET
1/18/2012
1/18/2012
2012 BUDGET DETAIL SHEET
1/18/2012
Dept: Library
Acct lnnationlDetap of Su
Ex
llea or Services 2009 2010 2011 BUDGET 2012 BUDGET
No. p
pp Actual :.!Actual Detail :Total Detail .Total
4405 Cleaning Services 20,158 19,585 '
Cleanin contract Cadson Bld Services 20,150 20,150
4409 Contractual Services 8,423 7,737
Libra ro rams 11,000 11,000
4433 Dues/SubscrlpUons 165 135
MN Libra Assn 250 250
4560 TOTAL OTHE[i SERVICES 8 CHARGES
CAPITAL OUTLAY
Equipment i 66,029 71,000 4 82,150 `81,400
TOTAL CAPITAL OUTLAY
TOTAL LIBRARY
99,072
'.. 77,843
97,000
.',97,000
1/16/2012