Nsls.info

Document 8.1 MLS -- RAILS Board July 21, 2011 METROPOLITAN LIBRARY SYSTEM GENERAL FUND BALANCE SHEET 06/30/2011 CASH 71,339.62 INVESTMENTS 1,157,897.01 MEMBER RECEIVABLES (43,747.40) OTHER RECEIVABLES 25,565.27 DUE FROM COMPUTER FUND 54,247.67 DUE FROM OTHER FUNDS (480,322.31) DUE FROM SWAN 29,519.30 PREPAID EXPENSES 988.52 ______________ ACCOUNTS PAYABLE 76,562.72 ______________ TOTAL LIABILITIES 76,562.72 BEGINNING FUND BALANCE 1,492,681.56 RESULTS FROM OPERATIONS (753,756.60) ______________ ENDING FUND BALANCE 738,924.96 ______________ TOTAL LIABILITIES AND FUND BALANCE 815,487.68 ============== Metropolitan Library System
General Fund
Revenue & Expenditure Report
For Period Ending June 30, 2011
Year-to-Date
Total Revenue
1,362,128
2,825,321
2,825,321
Expenditures
Personnel Salaries & Wages Library Professionals Payroll Taxes & Benefits Social Security Travel, Meeting & Continuing Education In State Travel Metropolitan Library System
General Fund
Revenue & Expenditure Report
For Period Ending June 30, 2011
Year-to-Date
Supplies, Postage & Printing Computer Supplies Under $5,000 Equipment Rental, Repair & Maint.
Equipment Rental Contractual Services Information Service Costs 2,115,889
2,644,342
2,644,342
(194,454)
(753,761)
METROPOLITAN LIBRARY SYSTEM REIMBURSEMENT FUND BALANCE SHEET 06/30/2011 TRANSMITTAL INVENTORY 1,185.93 ______________ DUE TO / FROM GENERAL FUND 12,326.89 ACCOUNTS PAYABLE 59.95 ______________ TOTAL LIABILITIES 12,386.84 BEGINNING FUND BALANCE 619.18 RESULTS FROM OPERATIONS (11,820.09) ______________ ENDING FUND BALANCE (11,200.91) ______________ TOTAL LIABILITIES AND FUND BALANCE 1,185.93 ______________ Metropolitan Library System
Reimbursement Fund
Revenue & Expense Report
For Period Ending June 30, 2011
Year-to-Date
Total Revenue
Expenses
Travel, Meeting & Continuing Education Registration, Meeting & Other Contractual Services Agreements w/System Libs & Others Total Expenses
Total Revenue over Expenses
(11,821)
METROPOLITAN LIBRARY SYSTEM
REVENUE & EXPENSE STATEMENTS FOR OTHER FUNDS
FOR THE PERIOD ENDING 5/31/11
MARC OF QUALITY
BOBBY RUSH
BOBBY RUSH
BUILDING
AUTOMATION
IMLS EXPANSION
IMLS EXPANSION
IMPROVEMENTS
FY2009-FY2011
FY2010-FY2012
GRANT REVENUE
FEES FOR SERVICES & MATERIALS
REIMBURSEMENTS
MISCELLANEOUS
TRANSFER IN
TOTAL REVENUE
EXPENSES
SALARIES
CONTRACTUAL SERVICES
PUBLICITY & PUBLIC RELATIONS
COMPUTER SUPPLIES
OFFICE SUPPLIES
TELECOMMUNICATIONS
INFORMATION RETRIEVAL
LIBRARY MATERIALS
PRINT MATERIALS
PERIODICALS/SERIALS
TRAVEL IN STATE
MAINTENANCE AGREEMENTS
CONSULTING
INFORMATION SERVICE COSTS
OUTSIDE PRINTING
SERVICES
COMPUTER EQUIPMENT > $500
BUILDING IMPROVEMENTS
MISCELLANEOUS
ADMINISTRATION
TOTAL EXPENSES
TOTAL REVENUE OVER EXPENSES
METROPOLITAN LIBRARY SYSTEM
BALANCE SHEETS FOR OTHER FUNDS
BUILDING
BOBBY RUSH
IMPROVEMENTS
IMLS EXPANSION
FY2010-FY2012
GRANT RECEIVABLE
TRANSMITTAL INVENTORY
PREPAID EXPENSE
DUE FROM GENERAL FUND
TOTAL ASSETS
5,070.08
10,000.00
LIABILITIES
ACCOUNTS PAYABLE
ACCRUED PAYROLL
DUE TO (FROM) GENERAL FUND
DEFERRED REVENUE
TOTAL LIABILITIES
BEGINNING FUND BALANCE
RESULTS FROM OPERATIONS
ENDING FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
5,070.08
10,000.00
Metropolitan Library System
Transfer of funds from The Illinois Funds / Max Safe Money Market/ Grants Checking
6/21/2011 - 7/21/2011
EFT/Check #
General Fund:
07/01/11
750,000.00
750,000.00
06/22/11
Metropolitan Library System
19,017.53
07/07/11
Metropolitan Library System
28,698.72
47,716.25
Metropolitan Library System
Check Recapitulation
6/21/2011 - 7/21/2011
Machine processed checks - 6/15/2011
$63,259.39
Check numbers 28925-28954
This check run completed prior to the last board meeting but after the board packet was distributed.
Machine processed checks - 6/17/2011
Check number 28955
This check run completed prior to the last board meeting but after the board packet was distributed.
Machine processed checks - 6/22/2011
Check number 28956
Machine processed checks - 6/30/2011
$31,918.45
Check numbers 28957-28975
$95,720.68
This recap covers check numbers 28925-28975
Run date: 07/20/2011 @ 18:04 METROPOLITAN LIBRARY SYSTEM Run: 3213 Date: 06/21/2011Bus date: 06/30/2011 Reprint Check Register OTRREG.L10 Page 1 Vendor Obligat'n Description Check Control Amount Invoice number========= ========= ============================== ======= ======= ============== =============== 347618 Michael Schmitt 28925 28925 75078 Fuel reimbursement *** Total *** 75.00 06152011 347619 LIMRiCC Purchase Health Insurance 28926 28926 75077 ComPsych Family Source 492.84 06152011*Warning* 75079 06152011 - Possible Duplicate 75079 Compsych 492.84 06152011*Warning* 75077 06152011 - Possible Duplicate 347619 LIMRiCC Purchase Health Insurance *** Total *** 985.68 347175 ADT Security Services INC 28927 28927 75044 Building security *** Total *** 280.61 49173805 346851 AMERICAN FIRST AID SERVICES, INC 28928 28928 75047 Supplies for First Aid Ki *** Total *** 31.44 119084 346457 ANGEL FOOD CATERING 28929 28929 75046 Catering for MLS Event *** Total *** 1,000.65 21781 346889 ARAMARK REFRESHMENT SERVICES 28930 28930 75048 Coffee Supplies 160.47 335954 75049 Coffee Supplies 48.16 254572 346889 ARAMARK REFRESHMENT SERVICES *** Total *** 208.63 346236 ARIN 28931 28931 75045 IP Address *** Total *** 100.00 141684 346180 DELL MARKETING, L.P. 28932 28932 75050 Web server contract *** Total *** 400.09 XFC3MRP84 130122 DUPAGE LIBRARY SYSTEM 28933 28933 75051 Merger consulting McGladrey 4,676.93 5497 75052 Merger Consulting-HR/MAI 382.50 5501 130122 DUPAGE LIBRARY SYSTEM *** Total *** 5,059.43 347461 Exelon Energy 28934 28934 75053 Utilities-Electric *** Total *** 6,826.66 100401900200-06 150103 FED EX 28935 28935 75055 Overnight Mailing *** Total *** 44.16 7-506-96266 Run date: 07/20/2011 @ 18:04 METROPOLITAN LIBRARY SYSTEM Run: 3213 Date: 06/21/2011Bus date: 06/30/2011 Reprint Check Register OTRREG.L10 Page 2 Vendor Obligat'n Description Check Control Amount Invoice number========= ========= ============================== ======= ======= ============== =============== 347603 FIA CARD SERVICES 28936 28936 75054 Misc charges *** Total *** 939.84 061511 160148 GENE'S TIRE SERVICE INC 28937 28937 75056 Service on Van *** Total *** 1,291.92 91623 346661 THE HARTFORD 28938 28938 75059 Workman's Comp Insurance *** Total *** 4,274.88 06152011 346152 HELMS LAWN AND LANDSCAPE 28939 28939 75060 Lawn Maintenance *** Total *** 250.00 22813 347590 HUB International Limited 28940 28940 75057 Commercial Insurance Package 1,513.00 188859 75058 Umbrella Package 495.00 188860 347590 HUB International Limited *** Total *** 2,008.00 180149 ILLINOIS PAPER COMPANY 28941 28941 75062 copy overages *** Total *** 263.75 8193293-06 346791 IRON MOUNTAIN 28942 28942 75061 Off site storage *** Total *** 256.62 103221939 346185 LIMRiCC-PHIP 28943 28943 75063 Health Insurance *** Total *** 18,128.96 06152011 346454 THE MARC OF QUALITY 28944 28944 74920 OCLC 4,100.00 2784 75064 OCLC Batches 4,100.00 2884 346454 THE MARC OF QUALITY *** Total *** 8,200.00 347534 Oak Consulting Inc 28945 28945 75067 Outplacement services *** Total *** 6,435.00 3816 346552 OFFICE DEPOT 28946 28946 75065 Misc supplies *** Total *** 121.50 566815160001-06 240112 ORKIN EXTERMINATING COMPANY, INC. 28947 28947 75066 Building Exterminating Se *** Total *** 67.30 6480347 Run date: 07/20/2011 @ 18:04 METROPOLITAN LIBRARY SYSTEM Run: 3213 Date: 06/21/2011Bus date: 06/30/2011 Reprint Check Register OTRREG.L10 Page 3 Vendor Obligat'n Description Check Control Amount Invoice number========= ========= ============================== ======= ======= ============== =============== 250106 PITNEY BOWES GLOBAL 28948 28948 75068 Meter lease *** Total *** 237.00 564151 346945 AT&T LONG DISTANCE 28949 28949 75043 Long Distance Phone *** Total *** 71.02 818161870-06 346366 SHELL FLEET PLUS 28950 28950 75070 Fuel for Fleet *** Total *** 2,257.62 065230674105 346384 SPEEDWAY SUPERAMERICA LLC 28951 28951 75069 Fuel for Fleet *** Total *** 1,651.85 1000371490*Warning* 67452 1000371490 - Possible Duplicate*Warning* 74606 1000371490 - Possible Duplicate 347016 STIVERS STAFFING SERVICES 28952 28952 75071 Temp employee 369.53 1444 75072 Temp employee 530.60 9641994 75073 Temp Employee 454.80 9642031 347016 STIVERS STAFFING SERVICES *** Total *** 1,354.93 290107 TRUGREEN-HICKORY 28953 28953 75074 Lawn Treatment *** Total *** 59.00 27912 120101 WASTE MANAGEMENT ILLINOIS - METRO 28954 28954 75075 recycle 135.44 20438090-06 75076 garbage services 242.41 2042407-06 120101 WASTE MANAGEMENT ILLINOIS - METRO *** Total *** 377.85 Run date: 07/20/2011 @ 18:07 METROPOLITAN LIBRARY SYSTEM Run: 3214 Date: 06/17/2011Bus date: 06/30/2011 Reprint Check Register OTRREG.L10 Page 1 Vendor Obligat'n Description Check Control Amount Invoice number========= ========= ============================== ======= ======= ============== =============== 347619 LIMRiCC Purchase Health Insurance 28955 28955 75080 Compsych July 2010-June 2 *** Total *** 492.84 4915 Run date: 07/20/2011 @ 18:08 METROPOLITAN LIBRARY SYSTEM Run: 3215 Date: 06/22/2011Bus date: 06/30/2011 Reprint Check Register OTRREG.L10 Page 1 Vendor Obligat'n Description Check Control Amount Invoice number========= ========= ============================== ======= ======= ============== =============== 310100 VILLAGE OF BURR RIDGE 28956 28956 75081 Registration fee's for RA *** Total *** 50.00 06222011 Run date: 07/20/2011 @ 18:09 METROPOLITAN LIBRARY SYSTEM Run: 3217 Date: 06/30/2011Bus date: 06/30/2011 Reprint Check Register OTRREG.L10 Page 1 Vendor Obligat'n Description Check Control Amount Invoice number========= ========= ============================== ======= ======= ============== =============== 347141 Automated Logic Chicago 28957 28957 75096 HVAC sensor and controlle *** Total *** 747.00 81506851 347014 ACTUAL SOFTWARE INC 28958 28958 75097 Broadcast Fax *** Total *** 18.30 06302011 347112 AT&T Datacom 28959 28959 75095 Smartnet Contract *** Total *** 7,523.16 482-034024 347252 AT&T 28960 28960 75092 MLS Phone 765.43 630R26067706-06 75093 Poly-Com T-1 259.99 312Z89441406-06 75094 Optiman-Phone 931.59 630Z99233006 347252 AT&T *** Total *** 1,957.01 347604 Chicago Metropolitan Fire Preventio 28961 28961 75098 Quarterly Billing Radio 198.00 154348 75099 Radio Maintenance 148.00 153612 347604 Chicago Metropolitan Fire Preventio *** Total *** 346.00 347051 COMPLETE CLEANING 28962 28962 75100 Cleaning Supplies 528.26 1276651 75101 Building Cleaning 950.00 1276459 347051 COMPLETE CLEANING *** Total *** 1,478.26 346543 DUKE OF OIL 28963 28963 75105 Fleet Oil Change *** Total *** 39.78 13195 130122 DUPAGE LIBRARY SYSTEM 28964 28964 75102 Merger Legal Fee's 4,520.80 5508 75103 Merger Consulting McGladrey 7,312.20 5516 75104 Merger Consulting IFf 340.00 5512 130122 DUPAGE LIBRARY SYSTEM *** Total *** 12,173.00 150103 FED EX 28965 28965 75106 Misc Shipping *** Total *** 200.52 753693888 180149 ILLINOIS PAPER COMPANY 28966 28966 75107 Copier Staples *** Total *** 99.35 593836 347463 Key Equipment Finance 28967 28967 75108 Copier Lease *** Total *** 1,385.25 591233653-06 Run date: 07/20/2011 @ 18:09 METROPOLITAN LIBRARY SYSTEM Run: 3217 Date: 06/30/2011Bus date: 06/30/2011 Reprint Check Register OTRREG.L10 Page 2 Vendor Obligat'n Description Check Control Amount Invoice number========= ========= ============================== ======= ======= ============== =============== 347471 NICOR 28968 28968 75114 Utilities Natural Gas *** Total *** 159.12 06302011 346552 OFFICE DEPOT 28969 28969 75110 Supplies 88.75 569197311001 75111 Office supplies 47.47 568942275001 75112 Copier Toner 213.98 568942323001 75113 Supplies 78.58 568036142001 346552 OFFICE DEPOT *** Total *** 428.78 270105 RELIABLE FIRE EQUIPMENT CO. 28970 28970 75115 Halon Inspection Battery *** Total *** 54.00 564404 346635 SIKICH LLP 28971 28971 75117 Fiscal Constulting-Delgad *** Total *** 3,995.00 129520 347016 STIVERS STAFFING SERVICES 28972 28972 75116 Temp Staff-Delivery Dept *** Total *** 397.95 9642138 347572 Mary Tucker-Minott 28973 28973 75109 Mileage *** Total *** 11.00 4937 347323 Unique Management Services 28974 28974 75118 Transmittals *** Total *** 205.85 209872 320101 WEST TOWN REFRIGERATION CORP. 28975 28975 75119 HVAC Supplies 285.12 198166 75120 HVAC Maintenance 414.00 198579 320101 WEST TOWN REFRIGERATION CORP. *** Total *** 699.12

Source: http://www.nsls.info/sites/default/files/Document%208.1%20MLS%20June%202011%20Financial%20Report.pdf