LIBSR Financials 11-24-200911-OS-2009 09:09 AM
211-LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION CITY OF ELK RIVER
BALANCE SHEET
AS OF: OCTOBER 31ST, 2009
BALANCE PAGE: 1
ASSETS
211-1010 Cash - Library 386,860.39
386,860.34
TOTAL ASSETS 366,860.34
LIABILITIES
EQUITY
211-2400 Fund Balance 409,089.27
TOTAL BEGINNING EQUITY 909,084.27
TOTAL REVENUE 54,272.65
TOTAL EXPENSES 76,996.58
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 22,223.93)
TOTAL EQUITY & REV. OVER/(U NDER) EXP. 386,860.39
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
--
-- 386,860.34
------------
------------
11-OS-2009 9:07 AM D E T A I L L I S T I N G PAGE: 1
FUND 211 -LIBRARY PERIOD TO USE: Oct-2009 THRU Oct-2009
DEPT 5600 Library SUPPR ESS Z EROS ACCOUNTS: ALL
POST DATE TRAM # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
--------------
4-5600-4 -------
219 -------------
Operating -----------------------------
Supplies ----- ---------------- -------------- ---------------- ------------------
B E G I N N I N G B A L A N C E 7, 809.44
10/05/09 10/O1 A10577 CHK: 065590 00902 SUPPLIES 09995 32.43 7,841.87
A#1 BATTERY SOURCE INV# 2755 /PO#
10/05/09 10/O1 A10637 CHK: 065650 00402 PARTS/SUPPLIES 17890 27.55 7,869.92
ELK RIVER WINLECTRIC INV# 092509 /PO#
10/05/09 10/O1 A10696 CHK: 065659 00902 PROGRAM SUPPLIES 19336 60.32 7,929.74
MICHELE FORS MAN INV# 100509. /PO#
10/08/09 10/14 A10810 CHK: 009539 00918 CARROT TOP - SOLAR LIGHT 35099 110.18 8,039.92
US BANK INV# 092509 /PO#
10/19/09 10/16 A10891 CHK: 065862 00913 BULK SALT 18647 79.52 8,119.94
FINKEN'S WATER CENTERS INV# 1029380 /PO#
10/19/09 10/16 A10945 CHK: 065916 00413 PARTS/SUPPLIES 27920 39.38 8,158.82
N A P A OF ELK RIVER, I INV# 09302009 /PO#
10/19/09 10/16 A11020 CHK: 065991 00413 SIGN MATERIAL 36611 13.36 8,172.18
XPRESS GRAPHIX INV# 29421 /PO#
10/19/09 10/16 A11020 CHK: 065991 00913 SIGN MATERIAL 36611 19.24 8,191.92
XPRESS GRAPH IX INV# 29499 /PO#
10/20/09 10/20 A11071 CHK: 009535 00932 SEPT SALES & USE TAX 26300 7.57 8,198.99
MN DEPT. OF REVENUE INV# 102009 /PO#
____________ _ OCTOBER ACTIVITY DB: 389.55 CR: 0.00 389.55
----------------------
9-5600-9321 ------------
Telephone ------------------------------ ---- ---------------- -------------- ----------------- -----------------
B E G I N N I N G B ALAN C E 1, 082.26
10/05/09 10/O1 A10701 CHK: 065719 00902 PHONE LINE/LONG DISTANCE 28449 121.52 1,203.78
NORTHSTAR ACCESS INV# 6702781 /PO#
____________ _ OCTOBER ACTIVITY DB: 121.52 CR: 0.00 121.52
----------------------
4-5600-9361 -------------
Insurance ----------------------------- ----- --------------- --------------- ---------------- -----------------
B E G I N N I N G B A L A N C E 1,299.50
10/19/09 10/16 A10927 CHK: 065898 00913 OPEN MTG LAW ANNUAL PAY 23805 146.00 1,395.50
LEAGUE OF MN CITIES INS T INV# 32575 /PO#
_____________ OCTOBER ACTIVITY DB: 146.00 CR: 0.00 196.00
------------
9-5600-93 -------
89 -------------
Utilities ----------------------------- ----- ---------------- -------------- ---------------- -----------------
B E G I N N I N G B ALAN C E 16, 637.16
10/05/09 10/O1 A10633 CHK: 065696 00402 WATER/ELEC SVC 17700 27.25 16,664.91
ELK RIVER MUNICIPAL UTILI INV# 092509 /PO#
11-OS-2009 9:07 AM D E T A I L L I S T I N G PAGE: 2
FUND 211 -LIBRARY PERIOD TO USE: Oct-2009 THRU Oct-2009
DEPT 560 0 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
10/05/09 10/O1 A10720 CHK: 065733 00902 SEPT RUBBISH SVCS 30851 52.76 16,717.17
RANDY'S ENVIRONMENTAL SER INV# 10052009 /PO#
10/15/09 10/15 B13770
10/20/09 10/20 A11073 ERMU # 056437 00760 SALES TAX DONATED ELECTRIC JE#
CHK: 065995 00932 NATURAL GAS 13895 004900 77.99
10.50 16,794.66
16,805.16
CENTERPOINT ENERGY INV# 10062009 /PO#
_____________ OCTOBER ACTIVITY DB: 168.00 CR: 0.00 168.00
4-5600-4901 --------------------------
Bldg Repair/Maint Services ------------------- ---------------- -----------------
B E G I N N I N G B A L A N C E 10, 380.80
10/05/09 10/O1 A10633 CHK: 065696 00902 WATER/ELEC SVC 17700 696.86 11,027.66
ELK RIVER MUNICIPAL UTILI INV# 092509 /PO#
_____________ OCTOBER ACTIVITY DB: 696.86 CR: 0.00 646.86
9-5600-4905 ----------------------------
Cleaning Services ------------------- ---------------- -----------------
B E G I N N I N G B A LAN C E 15, 106.22
10/05/09 10/O1 A10606 CHK: 065619 00902 OCT CLEANING SVCS 13698 1,683.28 16,791.50
CARLSON BUILDING SERVICES INV# 28830 /PO#
_____________ OCTOBER ACTIVITY DB: 1,683.28 CR: 0.00 1,683.28
4-5600-9909
Contractual --------------------------------------
Services ------------------- ---------------- -----------------
B E G I N N I N G B A L A N C E 6, 933.15
10/05/09 10/O1 A10645 CHK: 065658 00902 PROGRAMS 10/5, 10/7 19336 80.00 7,013.15
MICHELE FORSMAN INV# 100509 /PO#
10/05/09 10/O1 A10647 CHK: 065660 00402 PROGRAMS 10/12, 10/14 19336 80.00 7,093.15
MICHELE FORSMAN INV# 10052009 /PO#
10/19/09 10/16 A10892 CHK: 065663 00413 PROGRAMS 10/19, 10/21 19336 80.00 7,173.15
MICHELE FORS MAN INV# 101909 /PO#
10/19/09 10/16 A10893 CHK: 065869 00913 PROGRAMS 10/26, 10/28 19336 80.00 7,253.15
MICHELE FORSMAN INV# 10192009 /PO#
10/19/09 10/16 A10899 CHK: 065865 00913 PROGRAM 10/20 19336 40.00 7,293.15
MICHELE FORSMAN INV# 102009 /PO#
10/19/09 10/16 A10986 CHK: 065957 00413 PROGRAM 10/29-AMAZING JE 32599 260.00 7,553.15
JEFF SMITH INV# 102909 /PO#
10/20/09 10/20 A11071 CHK: 009535 00932 SEPT SALES & USE TAX 26300 19.52 7,572.67
MN DEPT. OF REVENUE INV# 102009 /PO#
_____________ OCTOBER ACTIVITY DB: 639.52 CR: 0.00 639.52
11-OS-2009 9:07 AM D E T A I L L I S T I N G PAGE: 3
FUND 211-LIBRARY PERIOD TO USE: Oct-2009 THRU Oct-2009
DEPT 5610 Library Project SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
*-`-*'*-*-*-*-`-*-`-*-*-*- 000 ERRORS IN THIS REPORT! *-*-*-*-*-*-*-*-*-+_+_+_+_+
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 72,701.85 0.00
REPORTED ACTIVITY: 3,799.73 0.00
ENDING BALANCES: 76,496.58 0.00
11-OS-2009 09:08 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2009
211-LIBRARY
FINANCIAL SUMMARY
83.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENGE SUMMARY
Library
Library Project
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
Library Project
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
89,800.00 1,222.00 53,541.61 59.62 36,258.39
0.00 0.00 731.09 0.00 ( 731.04)
89,800.00 1,222.00 54,272.65 60.49 35,527.35
89,800.00 3,799.73 75,797.65 84.35 14,052.35
0.00 0.00 798.93 0.00 ( 748.93)
89,800.00 3,799.73 76,996.58 85.19 13,303.42
89,800.00 3,794.73 76,996.58 85.19 13,303.92
0.00 ( 2,572.73)( 22,223.93) 22,223.93
11-OS-2009 09:08 AM
211-LIBRARY
REVENUES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2009
PAGE: 2
83.33$ 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
Intergovernmental Rev
211-3-0000-3322 MV Credit
TOTAL Intergovernmental Rev
Other Revenue
211-3-0000-3621 Interest Income
211-3-0000-3626 Contributions
TOTAL Other Revenue
TOTAL Library
Library Project
Transfers In
211-3-5610-3927 Transfer-Govt Buildings Reserv
TOTAL Transfers In
TOTAL Library Project
70,900.00 0.00 33,336.97 97.02 37,563.53
0.00 0.00 677.76 0.00 ( 677.76)
70,900.00 0.00 34,019.23 97.97 36,885.77
0.00 1,222.00 1,222.00 0.00 ( 1,222.00)
0.00 1,222.00 1,222.00 0.00 ( 1,222.00)
3,000.00 0.00 3,120.83 109.03 ( 1X.83)
15,900.00 0.00 15,189.55 95.50 715.45
18,900.00 0.00 18,305.38 96.85 594.62
89,800.00 1,222.00 53,591.61 59.62 36,258.39
0.00 0.00 731.04 0.00 ( 731.09)
0.00 0.00 731.04 0.00 ( 731.04)
0.00 0.00 731.04 0.00 ( 731.09)
TOTAL REVENUE 89,800.00 1,222.00 54,272.65 60.49 35,527.35
11-OS-2009 09:08 AM
211-LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OE: OCTOBER 31ST, 2009
Personal Services
Supplies
211-9-5600-4201 Office Supplies
211-9-5600-9219 Operating Supplies
TOTAL Supplies
Other Services & Charges
211-9-5600-9321 Telephone
211-4-5600-4322 Postage
211-9-5600-9331 Travel, Conferences & Schools
211-4-5600-4359 Publishing
211-9-5600-9361 Insurance
211-4-5600-4389 Utilities
211-9-5600-4901 Bldg Repair/Maint Services
211-4-5600-9904 Equip Repair/Maint Services
211-4-5600-4905 Cleaning Services
211-4-5600-9909 Contractual Services
211-9-5600-4933 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
211-9-5600-9520 Buildings & Structures
TOTAL Capital Outlay
PAGE: 3
83.33 OE YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OE BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
500.00 0.00 130.34 26.07 369.66
16,700.00 389.55 6,198.99 99.10 8,501.01
17,200.00 389.55 8,329.33 48.43 8,870.67
0.00 121.52 1,203.78 0.00 ( 1,203.78)
50.00 0.00 0.00 0.00 50.00
1,500.00 0.00 560.00 37.33 990.00
1,000.00 0.00 112.20 11.22 887.80
3,350.00 146.00 1,395.50 41.66 1,954.50
21,900.00 168.00 16,805.16 76.74 5,099.89
15,300.00 646.86 11,027.66 72.08 9,272.39
2,200.00 0.00 1,321.00 60.05 879.00
16,050.00 1,683.28 16,791.50 109.62 ( 791.50)
11,000.00 639.52 7,572.67 68.89 3,927.33
250.00 0.00 134.95 53.98 115.05
72,600.00 3,405.18 56,929.92 78.91 15,675.58
0.00 0.00 10,493.90 0.00 ( 10,993.90)
0.00 0.00 10,993.90 0.00 ( 10,993.90)
TOTAL Library
89,800.00 3,794.73 75,747.65 89.35 19,052.35
11-OS-2009 09:08 AM CITY OF ELK RIVER PAGE: 9
REVENUE & EXPENSE REPOR T (UNAUDITED)
AS OF: OCTOBER 31ST, 2009
211-LIBRARY
Culture & Recreation
83.33 OF YEAR COMP.
Library Project
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
211-4-5610-4319 Other Professional Services 0.00 0.00 798
93 0
00
TOTAL Other Services & Charges
0.00
0.00 .
798.93 .
(
0.00 798.93)
( 798.93)
TOTAL Library Project 0.00 0.00 748.93 0.00 ( 798.93)
TOTAL Culture & Recreation 89,800.00 3,794.73 76,996.58 85.19 13,303.92
TOTAL EXPENDITURES 69,800.00 3,799.73 76,996.58 85.19 13,303.92
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 2,572.73)( 22,223.93) 22,223.93