LIBSR TREAS REPORT 09-28-2010-19-2010 09:26 AM CITY OF ELA RIVER PAGE: 1
BALANCE SHEET
AS OF: AUGUST 31ST, 2010
L-LIBRARY
VT A ACCOUNT DESCRIPTION BALANCE
iETS
L-1010 Cash - Library 406,687.50
906,687.50
TOTAL ASSETS 906,687.50
'1BILITIES
JITY
L-2900 Fund Balance 909,323.95
TOTAL BEGINNING EQUITY 909,323.45
TOTAL REVENUE 99,190.69
TOTAL EXPENSES 96,826.59
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 2,635.95)
TOTAL EQUITY b REV. OVER/(UNDER) EXP. 906,687.50
TOTAL LIABILITIES, EQUITY b REV.OVER/UNDER) EXP. 906,687.50
______________
______________
9-19-2010 9:29 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: Aug-2010 TH RU Aug-2010
DEPT 560 0 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 3, 907.62
8/16/10 8/13 A18563 CHK: 069709 00715 PARTS 20300 992.22 4,399.89
GRAINGER INV# 9297329196 /PO#
8/16/10 8/13 A16597 CHK: 069738 00715 SIGN NATERIAL 24992 24.35 4,924.19
M-R SIGN CO., INC INV# 162889 /PO#
8/16/10 8/13 A18602 CHK: 069743 00715 PARTS/SUPPLIES 25145 32.70 9,456.89
MENARDS - ELK RIVER INV# 073110 /PO#
8/20/10 8/31 A18801 CHK: 009579 00726 JULY SALES & USE TAX 26300 9.92 9,966.81
MN DEPT. OF REVENUE INV# 082010. /PO#
____________ _ AUGUST ACTIVITY DB: 559.19 CR: 0.00 559.19
4-5600-9321
Telephone _ _______ _________________ ___________________ _________________ ________________
B E G I N N I N G B ALA N C E 909.78
8/16/10 8/13 A38691 CHK: 069832 00715 MONTHLY PHONE LINE CH GS 11102 127.98 1,037.76
W INDST REAM INV# 46598765 /PO#
_____________ AUGUST ACTIVITY OB: 127.98 CA: 0.00 127.98
9-5600-9389 Utilities
B E G I N N I N G B A L A N C E 12, 850.09
/10 7/30 A18321 CHK: 069999 00699 WATER/ELEC SVC 17700 32.88 12,882.97
ELK RIVER MUNICIPAL UTILI INV# 072510 /PO#
8/02/10 7/30 A18409 CHK: 069582 00699 JULY RUBBISH SVC 30851 56.13 12,939.10
RANDY'S ENVIRONMENTAL SER INV# 08022010 /PO#
8/02/10 9/03 823631 01306 ELECTRIC - JULY JE# 006289 2,239.72 15,178.82
8/25/10 8/25 A18785 CHK: 069852 00729 NATURAL GAS 13895 9.57 15,188.39
CENTERPOINT ENERGY INV# 080610 /PO#
8/27/10 8/27 B23213 ERMU # 05399 6 01300 DONATED ELEC TAX - JULY JE# 008293 100.12 15,288.51
_____________ AUGUST ACTIVITY DB: 2,438.92 CR: 0.00 2,438.92
9-5600-4901
Bldg Repair _________
/Maint Sex vices _____________ ___________________ _________________ ________________
B E G I N N I N G B A L A N C E 2, 885.19
8/02/10 7/30 A18268 CHK: 069496 00699 REPAIR CEILING MOTOR 10373 346.74 3,231.93
AID ELECTRIC CORPORATION INV# 34957 /PO#
8/02/10 7/30 A18319 CNK: 069992 00699 EXTERIOR GLASS CLEANING 16448 205.00 3,936.93
DISTINCTIVE WINDOW CLEANS INV# 79631 /PO#
8/02/10 7/30 A18359 CHK: 069532 00699 JUNE MOWING SVCS 22661 930.00 3,866.93
JEREMY'S LAWN SERVICE INV# 9865 /PO#
9-14-2010 9:29 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: Aug-2010 TH RU AucJ-2010
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAM p REFERENCE PACKET======DESCRIPTION== -== VEND INV/PO/JE q NOTE =====AMOUNT== == ====BALANCE====
5/10 8/13 A18509 CHK: 069650 00715 REPAIR LOCK ON LIBRARY D 12256 1fi2 .50 4,029 .43
BLA INE LOCK d SAFE, INC INV# 8552 /POp
8/lfi/10 8/13 A18525 CHK: 069666 00715 PEST CONTROL 15191 75 .00 9,109 .93
COUNTRY SIDE PEST CONTROL INV# 6139 /POp
_____________ AUGUST ACTIVITY D8: 1,219.29 CR: 0.00 1,219. 29
______________
4-5600-4 _______
909 __________________________________________
Equip Repair/Maim Services _____________________ ______________ ______________ ___ _____________ ___
B E G I N N I N G B A L A N C E 1,386. 00
8/16/10 8/13 A18643 CHK: 069784 00715 LIGHTING 31196 19 .69 1,905 .69
RIVER CITY DATA, INC INV# 87021 /POp
_____________ AUGUST ACTIVITY DB: 19.69 CR: 0.00 19. 69
9-5600-9 905 Cleaning Services
B E G I N N I N G B A L A N C E 11,782. 96
8/02/10 7/30 A18288 CHK: 069966 00699 AUG CLEANING SVCS 13648 1,575 .00 13,357 .96
CARLSON BUILDING SERVICES INVp 32599 /POp
------------= ADGUST ACTIVITY De: 1,575.00 CR: 0.00 1,575. 00
4-5600-9409 Contractual Services
B E G I N N I N G B ALAN C E 5,015.25
?/10 7/30 A18331 CHK: 069509 00699 PROGRAM 8/9 19336 90 .00 5,055. 25
MICHELE FORSNAN INVp 080210 /POq
8/02/10 7/30 A18332 CHK: 069510 00699 PROGRAM 8/9 19336 40 .00 5,095. 25
MICHELE FORSMAN INV# 080210. /PO#
8/02/10 7/30 A18333 CHK: 069511 00699 PROGRAM 8/11 19336 40 .00 5,135. 25
MICHELE FORSMAN INVq 08022010 /POq
8/02/10 7/30 A18396 CHK: 069529 00699 PROGRAM 6/12 20818 225. 00 5,360. 25
LYNN HALBROOK INVp 080210 /PO#
8/02/10 7/30 A18924 CHK: 069602 00699 PROGRAM 6/5 34369 110. 00 5,970. 25
THREE RIVERS PARK DISTAIC INVq 080210 /POq
8/16/10 8/13 A18553 CHK: 069699 00715 PROGRAM 8/17 19336 90. 00 5,510. 25
MICHELE FORSMAN INV# 081610 /PO#
------------- AUGUST ACTIVITY DB: 495.00 CR: 0.00 995.00
9-19-2010 09:27 AM CITY OF ELA RIVER PAGE: 1
REVENUE fi EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2010
211-LIBRARY
F"'^NCIAL SUMMARY
66.67$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture fi Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
95,350 .00 2,239 .72 99,190. 69 46. 35 51,159 .36
95,350. 00 2,239 .72 49,190. 69 46. 35 51,159 .36
95,350 .00 6,934 .52 46,826 .59 49.11 98,523 .91
95,350. 00 6,939 .52 96,826 .59 99.11 98,523 .91
95,350. 00 6,939. 52 96,826 .59 99.11 98,523 .41
0. 00 ( 4,194. 80)( 2,635. 95) 2,635. 95
9-19-2010 09:27 AM CITY OF ELK RIVER PAGE: 2
REVENUE d EXPENSE REPORT (UNAUDITED)
AS OF: AOGUST 31ST, 2010
211-LIERARY
REVENUES
6fi .67$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Library
Taxes
211-3-0000-3111 Current Ad Valorem Taxes
211-3-0000-3112 Delinquent Ad Valorem Taxes
TOTAL Taxes
Other Revenue
211-3-0000-3621 Interest Income
211-3-0000-3626 Contributions
TOTAL Other Revenue
58,850.00 0.00 27,715.00 97.09 31,135.00
0.00 0.00 1,192.41 0.00 ( 1,192.41)
58,850.00 0.00 28,857.41 49.09 29,992.59
9,500. 00 0 .00 1,916. 03 19. 91 8,083 .97
27,000. 00 2,239. 72 13,917. 20 51. 55 13,082 .80
36,500. 00 2,239 .72 15,333. 23 92. 01 21,166 .77
TOTAL Library 95,350.00 2,239.72 44,190.69 46.35 51,159.36
TOTAL REVENUE 95,350.00 2,239.72 94,190.64 96.35 51,159.36
9-19-2010 09:27 AM CITY OF ELK RIVER PAGE: 3
REVENUE d EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2010
211-LIBRARY
C~'~vre 6 Recreation
1 ry
DEPARTMENTAL EXPENDITURES
66.67& OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE 8 OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
Supplies
211-4-5600-4201 Office Supplies
211-9-5600-9219 Operating Supplies
TOTAL Supplies
Other Services & Charges
211-9-5600-4321 Telephone
211-9-5600-4322 Postage
211-9-5600-9331 Travel, Conferences & Schools
211-4-5600-9359 Publishing
211-9-5600-4361 Insurance
211-4-6600-4389 Utilities
211-9-5600-4901 Bltlg Repair/Maim Services
211-4-5600-9904 Equip Repair/Maim Services
211-9-5600-4905 Cleaning Services
211-4-5600-9409 Contractual Services
211-4-5600-4933 Dues d Subscriptions
'AL Other Services d Charges
500.00 0.00 117.05 23.41 382.95
10,600.00 559.19 4,966.81 92.19 6,133.19
11,100.00 559.19 9,563.86 41.30 6,616.19
1,950 .00 127 .98 1,037 .76 71 .57 912 .24
so .oa o .oo o .oo o .oo so .oo
l,soo .oo o .ao D. ao o .oo l,soo .oo
1,500 .00 0 .00 111. 68 7 .95 1,388 .32
2,900 .00 0 .00 1,291. 50 49 .53 1,608 .50
29,000 .00 2,938. 92 15,288. 51 52 .72 13,711 .49
13,950. 00 1,219. 29 9,104. 43 29. 42 9,895 .57
2,500. 00 19. 69 1,906. 69 56. 23 1,099. 31
20,150. 00 1,575. 00 13,357. 96 66. 29 6,792. 09
11,000. 00 995. 00 5,510. 25 50. 09 5,989. 75
250. 00 0. 00 134. 95 53. 98 115. 05
84,250. 00 5,875. 33 92,242. 73 50. 14 42,007. 27
TOTAL Library 95,350.00 6,934.52 96,826.59 99.11 98,523.41
TOTAL Culture & Recreation 95,350.00 6,439.52 96,826.59 49.11 48,523.41
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
95,350 .00 6,934 .52 96,826. 59 99.11 98,523. 91
0. 00 ( 4,194 .80)( 2,635. 95) 2,635. 95