Loading...
LIBSR FINANCIALS 07-24-20126 -18 -2012 08:30 AM CITY OF ELK RIVER PAGE: 1 EXPENDITURES REPORT (UNAUDITED) AS OF: MAY 31ST, 2012 211 - LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services Supplies 211 -4 -5600 -4201 Office Supplies 211 -4 -5600 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 211 -4 -5600 -4321 Telephone 211 -4 -5600 -4322 Postage 211 -4 -5600 -4331 Travel, Conferences & Schools 211 -4 -5600 -4359 Publishing 211 -4- 5600 -4361 Insurance 211 -4 -5600 -4389 Utilities 211 -4 -5600 -4401 Bldg Repair /Maint Services 211 -4 -5600 -4404 Equip Repair /Maint Services 211 -4 -5600 -4405 Cleaning Services 211 -4 -5600 -4409 Contractual Services 211 -4 -5600 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay Transfers Out TOTAL Library 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 500.00 0.00 0.00 0.00 500.00 15,100.00 1,170.92 3,483.49 23.07 11,616.51 15,600.00 1,170.92 3,483.49 22.33 12,116.51 1,550.00 84.44 420.54 27.13 1,129.46 50.00 0.00 0.00 0.00 50.00 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.50 44.24 1,282.50 28,400.00 1,587.52 8,639.43 30.42 19,760.57 12,700.00 484.00 866.50 6.82 11,833.50 2,200.00 0.00 0.00 0.00 2,200.00 20,150.00 1,575.00 7,875.00 39.08 12,275.00 11,000.00 496.10 2,868.53 26.08 8,131.47 250.00 75.00 75.00 30.00 175.00 81,400.00 4,302.06 21,762.50 26.74 59,637.50 97,000.00 5,472.98 25,245.99 26.03 71,754.01 TOTAL Culture & Recreation 97,000.00 5,472.98 25,245.99 26.03 71,754.01 TOTAL EXPENDITURES 97,000.00 5,472.98 25,245.99 26.03 71,754.01 7 -18 -2012 7:49 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: Jun -2012 THRU Jun-2012 DEPT 5600 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,483.49 6/04/12 6/01 A33485 CHK: 077958 01245 PARTS 18453 1.01 3,484.50 FASTENAL COMPANY INV# MNELK37126 /PO# 6/14/12 6/26 A33947 CHK: 009655 01264 MAY SALES & USE TAX 26300 18.91 3,503.41 MN DEPT. OF REVENUE INV# 061412 /PO# 6/18/12 6/15 A33776 CHK: 078156 01254 BULK SALT 18647 96.60 3,600.01 FINKEN'S WATER CENTERS INV# 8830TB /PO# 6/18/12 6/15 A33785 CHK: 078165 01254 AIR FILTERS 20300 160.08 3,760.09 GRAINGER INV# 9836481458 /PO# 6/18/12 6/15 A33785 CHK: 078165 01254 AIR FILTERS 20300 112.86 3,872.95 GRAINGER INV# 9838981703 /PO# JUNE ACTIVITY DB: 389.46 CR: 0.00 389.46 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4321 Telephone B E G I N N I N G B A L A N C E 420.54 6/18/12 6/15 A33892 CHK: 078272 01254 PHONE LINE CHGS 11102 79.24 499.78 WINDSTREAM INV# 052912 /PO# JUNE ACTIVITY DB: 79.24 CR: 0.00 79.24 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4389 Utilities B E G I N N I N G B A L A N C E 8,639.43 6/04/12 6/01 A33556 CHK: 078029 01245 MAY RUBBISH SVCS 30851 57.18 8,696.61 RANDY'S ENVIRONMENTAL SER INV# 06042012 /PO# 6/13/12 6/13 A33698 CHK: 078088 01255 WATER /ELEC 17700 27.00 8,723.61 ELK RIVER MUNICIPAL UTILI INV# 052312 /PO# 6/13/12 7/02 B43338 02428 ELECTRIC - MAY JE# 015435 1,563.03 10,286.64 6/26/12 6/26 A33950 CHK: 078285 01264 NATURAL GAS 13845 15.54 10,302.18 CENTERPOINT ENERGY INV# 060612. /PO# 6/28/12 7/02 B43299 ERMU # 062383 02439 ELEC SALES TAX - MAY JE# 015406 68.69 10,370.87 JUNE ACTIVITY DB: 1,731.44 CR: 0.00 1,731.44 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4401 Bldg Repair /Maint Services B E G I N N I N G B A L A N C E 866.50 6/04/12 6/01 A33495 CHK: 077968 01245 SPRING START UP 10107 88.00 954.50 GREAT NORTHERN LANDSCAPES INV# 8588 /PO# 6/04/12 6/01 A33576 CHK: 078049 01245 BROADLEAF SPRAY FOR WEED 11661 204.00 1,158.50 SPEEDCUTTERS OUTDOOR MAIN INV# M836 /PO# 7 -18 -2012 7:49 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: Jun -2012 THRU Jun -2012 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET = = = = == DESCRIPTION= = = = = == VEND INV /PO /JE # NOTE = = = == AMOUNT = = == = = == BALANCE = = == 6/04/12 6/01 A33582 CHK: 078055 01245 REIMB FOR CLOCK REPAIR 33250 37.50 1,196.00 MARGARET STOFFERS INV# 060412 /PO# 6/18/12 6/15 A33867 CHK: 078247 01254 MOWING SVCS CONTRACT 11661 344.00 1,540.00 SPEEDCUTTERS OUTDOOR MAIN INV# 3166 /PO# JUNE ACTIVITY DB: 673.50 CR: 0.00 673.50 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4405 Cleaning Services B E G I N N I N G B A L A N C E 7,875.00 6/04/12 6/01 A33453 CHK: 077926 01245 JUNE CLEANING SVCS 13648 1,575.00 9,450.00 CARLSON BUILDING SERVICES INV# 40319 /PO# JUNE ACTIVITY DB: 1,575.00 CR: 0.00 1,575.00 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4409 Contractual Services B E G I N N I N G B A L A N C E 2,868.53 6/04/12 6/01 A33488 CHK: 077961 01245 PROGRAM 6/6 19336 40.00 2,908.53 MICHELE FORSMAN INV# 060412 /PO# 6/04/12 6/01 A33489 CHK: 077962 01245 PROGRAM 6/13 19336 40.00 2,948.53 MICHELE FORSMAN INV# 060412. /PO# 6/04/12 6/01 A33603 CHK: 078076 01245 PROGRAM 6/11 11483 40.00 2,988.53 SANDRA WELTON -WOOD INV# 060412 /PO# 6/04/12 6/01 A33604 CHK: 078077 01245 PROGRAM 6/18 11483 40.00 3,028.53 SANDRA WELTON -WOOD INV# 060412. /PO# 6/04/12 6/01 A33605 CHK: 078078 01245 PROGRAM SUPPLIES 11483 13.78 3,042.31 SANDRA WELTON -WOOD INV# 06042012 /PO# 6/18/12 6/15 A33753 CHK: 078133 01254 PROGRAM 6/28 14725 225.00 3,267.31 COMO Z00 INV# 061812 /PO# 6/18/12 6/15 A33778 CHK: 078158 01254 PROGRAM 6/20 19336 40.00 3,307.31 MICHELE FORSMAN INV# 061812 /PO# 6/18/12 6/15 A33779 CHK: 078159 01254 PROGRAM 6/27 19336 40.00 3,347.31 MICHELE FORSMAN INV# 061812. /PO# 6/18/12 6/15 A33890 CHK: 078270 01254 PROGRAM 6/25 11483 40.00 3,387.31 SANDRA WELTON -WOOD INV# 061812 /PO# JUNE ACTIVITY DB: 518.78 CR: 0.00 518.78 7 -18 -2012 7:49 AM D E T A I L L I S T I N G PAGE: 3 FUND 211 - LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Jun -2012 THRU Jun -2012 DEPT 5600 Library 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: 25,245.99 0.00 REPORTED ACTIVITY: 4,967.42 0.00 ENDING BALANCES: 30,213.41 0.00 6 -18 -2012 08:29 AM 211 - LIBRARY ACCOUNT # ACCOUNT DESCRIPTION CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: MAY 31ST, 2012 BALANCE ASSETS 211 -1010 Cash - Library 426,159.61 426,159.61 TOTAL ASSETS 426,159.61 -------- LIABILITIES - - - - -- -------------- EQUITY 211 -2400 Fund Balance 442,182.47 TOTAL BEGINNING EQUITY 442,182.47 TOTAL REVENUE 9,223.13 TOTAL EXPENSES 25,245.99 TOTAL REVENUE OVER /(UNDER) EXPENSES ( 16,022.86) TOTAL EQUITY & REV. OVER /(UNDER) EXP. 426,159.61 TOTAL LIABILITIES, EQUITY & REV.OVER /(UNDER) EXP. 426,159.61 -------- - - - - -- -------------- 7 -18 -2012 07:47 AM CITY OF ELK RIVER BALANCE SHEET AS OF: JUNE 30TH, 2012 211 - LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211 -1010 Cash - Library 445,256.33 TOTAL ASSETS LIABILITIES EQUITY 211 -2400 Fund Balance 442,182.47 TOTAL BEGINNING EQUITY 442,182.47 TOTAL REVENUE 33,287.27 TOTAL EXPENSES 30,213.41 TOTAL REVENUE OVER /(UNDER) EXPENSES 3,073.86 TOTAL EQUITY & REV. OVER /(UNDER) EXP. TOTAL LIABILITIES, EQUITY & REV.OVER /(UNDER) EXP. 445,256.33 445,256.33 PAGE: 1 445,256.33 ------ -- - - - - -- -------------- 445,256.33 -------- - - - - -- -------------- 7 -18 -2012 07 :48 AM CITY OF ELK RIVER PAGE: 1 EXPENDITURES REPORT (UNAUDITED) AS OF: JUNE 30TH, 2012 211 - LIBRARY Culture & Recreation 50.00% OF YEAR COMP. Library CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies 211 -4 -5600 -4201 Office Supplies 500.00 0.00 0.00 0.00 500.00 211 -4 -5600 -4219 Operating Supplies 15,100.00 389.46 3,872.95 25.65 11,227.05 TOTAL Supplies 15,600.00 389.46 3,872.95 24.63 11,727.05 Other Services & Charges 211 -4 -5600 -4321 Telephone 1,550.00 79.24 499.78 32.24 1,050.22 211 -4 -5600 -4322 Postage 50.00 0.00 0.00 0.00 50.00 211 -4 -5600 -4331 Travel, Conferences & Schools 1,300.00 0.00 0.00 0.00 1,300.00 211 -4 -5600 -4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 211 -4 -5600 -4361 Insurance 2,300.00 0.00 1,017.50 44.24 1,282.50 211 -4 -5600 -4389 Utilities 28,400.00 1,731.44 10,370.87 36.52 18,029.13 211 -4 -5600 -4401 Bldg Repair /Maint Services 12,700.00 673.50 1,540.00 12.13 11,160.00 211 -4 -5600 -4404 Equip Repair /Maint Services 2,200.00 0.00 0.00 0.00 2,200.00 211 -4 -5600 -4405 Cleaning Services 20,150.00 1,575.00 9,450.00 46.90 10,700.00 211 -4 -5600 -4409 Contractual Services 11,000.00 518.78 3,387.31 30.79 7,612.69 211 -4 -5600 -4433 Dues & Subscriptions 250.00 0.00 75.00 30.00 175.00 TOTAL Other Services & Charges 81,400.00 4,577.96 26,340.46 32.36 55,059.54 Capital Outlay Transfers Out TOTAL Library 97,000.00 4,967.42 30,213.41 31.15 66,786.59 TOTAL Culture & Recreation 97,000.00 4,967.42 30,213.41 31.15 66,786.59 TOTAL EXPENDITURES 97,000.00 4,967.42 30,213.41 31.15 66,786.59 6 -18 -2012 8:31 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: May -2012 THRU May -2012 DEPT 5600 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 2,312.57 5/07/12 5/03 A33034 CHK: 077640 01220 RAIN GARDEN PLANTINGS 30075 96.19 2,408.76 PRAIRIE RESTORATIONS, INC INV# 19608 /PO# 5/08/12 5/18 A33392 CHK: 009651 01239 SECURITRON - LOCKSET 35099 275.00 2,683.76 US BANK INV# 4252012 /PO# 5/14/12 5/15 A33165 CHK: 009648 01233 APRIL SALES & USE TAX 26300 8.59 2,692.35 MN DEPT. OF REVENUE INV# 051412 /PO# 5/21/12 5/17 A33248 CHK: 077758 01235 PARTS /SUPPLIES 17890 171.56 2,863.91 ELK RIVER WINLECTRIC INV# 042512 /PO# 5/21/12 5/17 A33259 CHK: 077769 01235 REPAIR KITS 20113 24.13 2,888.04 GOODIN COMPANY INV# 1094023-00 /PO# 5/21/12 5/17 A33262 CHK: 077772 01235 EDGER RENTAL- RAINGARDEN 20317 55.62 2,943.66 GRAND RENTAL STATION INV# 186302 -1 /PO# 5/21/12 5/17 A33328 CHK: 077838 01235 EDGING FOR RAIN GARDEN 29846 539.83 3,483.49 PLAISTED LANDSCAPE SUPPLY INV# 12470 /PO# MAY ACTIVITY DB: 1,170.92 CR: 0.00 1,170.92 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4321 Telephone B E G I N N I N G B A L A N C E 336.10 5/21/12 5/17 A33365 CHK: 077875 01235 PHONE LINE CHGS 11102 84.44 420.54 WINDSTREAM INV# 042712 /PO# MAY ACTIVITY DB: 84.44 CR: 0.00 84.44 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4389 Utilities B E G I N N I N G B A L A N C E 7,051.91 5/07/12 5/03 A33038 CHK: 077644 01220 APRIL RUBBISH SVCS 30851 57.18 7,109.09 RANDY'S ENVIRONMENTAL SER INV# 05072012 /PO# 5/15/12 5/15 A33171 CHK: 077699 01233 WATER /ELEC 17700 28.50 7,137.59 ELK RIVER MUNICIPAL UTILI INV# 042412 /PO# 5/15/12 6/04 B42281 02374 ELECTRIC - APRIL JE# 014919 1,429.08 8,566.67 5/17/12 5/18 B41775 ERMU # 062186 02371 SALES TAX ELEC - APRIL JE# 014905 55.11 8,621.78 5/22/12 5/22 A33397 CHK: 077884 01240 NATURAL GAS 13845 17.65 8,639.43 CENTERPOINT ENERGY INV# 050412 /PO# MAY ACTIVITY DB: 1,587.52 CR: 0.00 1,587.52 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4401 Bldg Repair /Maint Services B E G I N N I N G B A L A N C E 382.50 6 -18 -2012 8:31 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: May -2012 THRU May -2012 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET = = = = == DESCRIPTION= = = = = == VEND INV /PO /JE # NOTE = = = == AMOUNT = = == = = == BALANCE = = == 5/07/12 5/03 A32946 CHK: 077552 01220 PEST CONTROL 15191 75.00 457.50 COUNTRY SIDE PEST CONTROL INV# 7183 /PO# 5/07/12 5/03 A32955 CHK: 077561 01220 EXTERIOR GLASS CLEANING 16448 205.00 662.50 DISTINCTIVE WINDOW CLEANI INV# 80232 /PO# 5/07/12 5/03 A33056 CHK: 077662 01220 LAWN SERVICES 11661 204.00 866.50 SPEEDCUTTERS OUTDOOR MAIN INV# M826 /PO# MAY ACTIVITY DB: 484.00 CR: 0.00 484.00 ------------------------------------------------------------------------------------------------------------------------------------ 4- 5600 -4405 Cleaning Services B E G I N N I N G B A L A N C E 6,300.00 5/07/12 5/03 A32937 CHK: 077543 01220 MAY CLEANING SVCS 13648 1,575.00 7,875.00 CARLSON BUILDING SERVICES INV# 39958 /PO# MAY ACTIVITY DB: 1,575.00 CR: 0.00 1,575.00 ------------------------------------------------------------------------------------------------------------------------------------ 4 -5600 -4409 Contractual Services B E G I N N I N G B A L A N C E 2,372.43 5/07/12 5/03 A32971 CHK: 077577 01220 PROGRAM 5/9 19336 40.00 2,412.43 MICHELE FORSMAN INV# 050712 /PO# 5/07/12 5/03 A32972 CHK: 077578 01220 PROGRAM 5/16 19336 40.00 2,452.43 MICHELE FORSMAN INV# 050712. /PO# 5/07/12 5/03 A33081 CHK: 077687 01220 PROGRAM 5/14 11483 40.00 2,492.43 SANDRA WELTON -WOOD INV# 050712 /PO# 5/07/12 5/03 A33082 CHK: 077688 01220 PROGRAM 5/21 11483 40.00 2,532.43 SANDRA WELTON -WOOD INV# 050712. /PO# 5/21/12 5/17 A33224 CHK: 077734 01235 PROGR SUPPL -1ST STEP TOU 13735 9.00 2,541.43 LAURA CASSIDAY INV# 052112 /PO# 5/21/12 5/17 A33255 CHK: 077765 01235 PROGRAM 5/23 19336 40.00 2,581.43 MICHELE FORSMAN INV# 052112 /PO# 5/21/12 5/17 A33256 CHK: 077766 01235 PROGRAM 5/30 19336 40.00 2,621.43 MICHELE FORSMAN INV# 052112. /PO# 5/21/12 5/17 A33341 CHK: 077851 01235 PROGRAM 5/31 11684 150.00 2,771.43 NATHAN STOCKWELL INV# 052112 /PO# 5/21/12 5/17 A33342 CHK: 077852 01235 SUMMER READING PROG SUPP 33250 41.61 2,813.04 MARGARET STOFFERS INV# 052112 /PO# 5/21/12 5/17 A33352 CHK: 077862 01235 PHOTO FUN ACTIVITIES SET 35550 15.49 2,828.53 UPSTART INV# 4589926 /PO# 5/21/12 5/17 A33364 CHK: 077874 01235 PROGRAM 6/4 11483 40.00 2,868.53 SANDRA WELTON -WOOD INV# 052112 /PO# MAY ACTIVITY DB: 496.10 CR: 0.00 496.10 6 -18 -2012 8:31 AM D E T A I L L I S T I N G PAGE: 3 FUND 211 - LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: May -2012 THRU May -2012 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET = = = = == DESCRIPTION= = = = = == VEND INV /PO /JE # NOTE = = = == AMOUNT = = == = = == BALANCE = = == -------------------------------------------------------------------------------------- 4 -5600 -4433 Dues & Subscriptions B E G I N N I N G B A L A N C E 5/07/12 5/03 A33012 CHK: 077618 01220 2012 MEMBERSHIP 26415 MINNESOTA LIBRARY ASSOC. INV# 042512 MAY ACTIVITY DB: 75.00 CR: --------------------------------------------- 0.00 75.00 75.00 /PO# 0.00 75.00 *- *- *- *- *- *- *- *- *- *- * - * - *- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** - -- DEBITS - -- - -- CREDITS - -- BEGINNING BALANCES: 19,773.01 0.00 REPORTED ACTIVITY: 5,472.98 0.00 ENDING BALANCES: 25,245.99 0.00