Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
LIBSR TREASURERS REPORT 11-27-2012
11-20-2012 08:59 AN CITY OF ELK RIVER PAGE, 1 BALANCE SHEET AS OF: OCTOBER 31ST, 2012 211-LIBRARY ACCOUNT 4 ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 432,304.28 432,304.28 TOTAL ASSETS 432,304.28 LIABILITIES EQUITY 211-2400 Fund Balance 492,182.47 TOTAL BEGINNING EQUITY 442,182.47 TOTAL REVENUE 52,761.05 TOTAL EXPENSES 62,639.24 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 9,578.19) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 432,304.28 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 432,304.28 11-20-2012 09:06 AM CITY OF ELK RIVER PAGE: 1 EXPENDITURES REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2012 211-LIBRARY Culture 6 Recreation 83.33% 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 24.57 4.91 475.43 211-4-5600-4219 Operating Supplies 15,100.00 7,009.26 12,312.54 81.54 2,787.46 TOTAL Supplies 15,600.00 7,009.26 12,337.11 79.08 3,262.09 Other Services 6 Charges 211-4-5600-4321 Telephone 1,550.00 85.38 834.11 53.81 715.89 211-4-5600-4322 Postage 50.00 0.00 0.00 0.00 50.00 211-4-5600-4331 Travel, Conferences 4 Schools 1,300.00 0.00 0.00 0.00 1,300.00 F 211-4-5600-4359 Publishing 1,500.00 441.79 441.79 29.45 1,058.21 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 2,209.26 18,873.25 66.46 9,526.75 211-4-5600-4401 Bldg Repair/Main Services 12,700.00 1,354.25 5,923.63 46.64 6,776.37 211-4-5600-4404 Equip Repair/Maint Services 2,200.00 0.00 1,337.00 60.77 863.00 211-4-5600-4405 Cleaning Services 20,150.00 1,575.00 15,750.00 78.16 4,400.00 211-4-5600-4409 Contractual Services 11,000.00 575.00 6,049.85 55.00 4,950.15 211-4-5600-4433 Dues 6 Subscriptions 250.00 0.00 75.00 30.00 175.00 TOTAL Other Services & Charges 81,400.00 6,290.60 50,302.13 61.80 31,097.87 Capital Outlay Transfers Out TOTAL Library 97,000.00 13,249.94 62,639.24 64.58 34,360.76 TOTAL Culture & Recreation 97,000.00 13,249.94 62,639.24 64.58 34,360.76 TOTAL EXPENDITURES 97,000.00 13,249.94 62,639.24 64.58 34,360.76 11-20-2012 9:09 AM D E T A I L L I S T I N G PAGE. 1 FUND : 211-LIBRARY PERIOD TO USE Oct-2012 THRU OCt-2012 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAM X REFERENCE PACKET DESCRIPTION VEND INV/PO/JE X NOTE AMOUNT•••■ =••=BALANCE=••= 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 5,303.28 10/01/12 9/27 A35592 CMX: 079465 01321 PLANTS 28904 48.05 5,351.33 101 MARKET INVX 1-300392 /PDX 10/15/12 10/12 A35891 COOK: 079702 01329 BULK SALT 18647 96.60 5,447.93 FINKEN'S WATER CENTERS INVX 28963TB /PDX 10/15/12 10/12 A35902 CHK: 079713 01329 AIR FILTERS 20300 260.88 5,708.81 GRAINGER INVX 9937755537 /PDX 10/15/12 10/12 A35907 CHK: 079718 01329 PAVER REPLACEMENTS-LIBRA 10107 6,600.00 12,308.81 GREAT NORTHERN LANDSCAPES INVX 8819 /PDX 10/15/12 10/12 A35930 CHK: 079741 01329 PARTS/SUPPLIES 25145 3.73 12,312.54 MENARDS - ELK RIVER INVX 093012 /P0# 4-5600-4321 Telephone B EG INN I NG BALANCE 748.73 10/15/12 10/12 A36016 CUR, 079827 01329 PHONE LINE CMGS 11102 85.38 834.11 III WINDSTREAM INVX 092712 /P0# 4-5600-4359 Publishing B E G I N N I N G BALANCE 0.00 10/15/12 10/12 A35876 CHK: 079687 01329 DISPLAY ADVERTISING 17000 441.79 441.79 E C M PUBLISHERS INC INVX IC000355798 /PO0 9-5600-9389 Utilities B E G I N N I N G BALANCE 16,663.99 10/09/12 10/08 A35814 011K: 079632 01328 WATER/ELEC 17700 30.24 16,694.23 ELK RIVER MUNICIPAL UTILI INVX 092512 /PDX 10/09/12 11/02 547692 02653 ELECTRIC -SEPT JO 016834 2,021.04 18,716.07 : 10/15/12 10/12 A35968 CHK: 079779 01329 SEPT RUBBISH SVCS 30851 57.18 18,773.25 RANDY'S ENVIRONMENTAL SER INVX 10152012 /PDX 10/18/12 10/19 B47101 Deposit 000000 02630 ELBC SALES TAX - SEPT SEX 016677 80.70 18,853.95 i 10/23/12 10/23 A36047 CHK: 079837 01333 NATURAL GAS 13845 19.30 18,873.25 CENTERPOINT ENERGY INVX 10082012 /PDX 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G BALANCE 4,569.38 i 10/01/12 9/27 A35613 CRK: 079506 01321 EXTERIOR GLASS CLEANING 16448 205.00 4,774.38 1 DISTINCTIVE WINDOW GLEAM INVX 81536 /PDX 10/09/12 10/08 A35814 CHK: 079632 01328 SEC MONITORING 17700 605.25 5,379.63 I ELK RIVER MUNICIPAL UTILI INVX 092512 /PDX 1 i 11-20-2012 9:09 AM D E T A I L L I S T I N G PAGE: 2 FUND 211-LIBRARY PERIOD TO USE: Oct-2012 THRU Oct-2012 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN p REFERENCE PACKET DESCRIPTION VEND INV/PO/JR 8 NOTE e..nAMOUNT•--- ....BALANCE-- 10/15/12 10/12 A35984 CHIC: 079795 01329 MOWING SVCS CONTRACT 11661 344.00 5,723.63 SPEEDCUTTBRS OUTDOOR MAIN INVI/ 3310 /Poll 10/15/12 10/12 A35988 CHK: 079799 01329 FIRE SPRINKLER INSPECTIO 33444 200.00 5,923.63 SUMMIT FIRE PROTECTION INVI/ 38173 /900 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 14,175.00 10/01/12 9/27 A35614 CHK: 079487 01321 OCT CLEANING SVCS 13648 1,575.00 15,750.00 CARLSON BUILDING SERVICES INVO 41717 /900 4-5600-4409 Contractual Services BEGINNING BALANCE 5,474.85 10/01/12 9/27 A35646 CHK: 079519 01321 PROGRAM 10/3 19336 40.00 5,514.85 MICHELE FOREMAN INVI/ 100112 /POI/ 10/01/12 9/27 A35647 CHK: 079520 01321 PROGRAM 10/10 19336 40.00 5,554.85 MICHELE FOREMAN INVO 100112. /POI/ 10/01/12 9/27 A35744 CHK: 079617 01321 PROGRAM 10/8 11483 40.00 5,594.85 SANDRA WELTON-W000 INVO 100112 /PO 10/01/12 9/27 A35745 CHK: 079618 01321 PROGRAM 10/15 11483 40.00 5,634.85 SANDRA WELTON-WOOD INVO 100112. /901 10/15/12 10/12 A35893 CHK: 079704 01329 PROGRAM 10/17 19336 40.00 5,674.85 MICHELE FOREMAN INVI/ 101512 /POI/ 10/15/12 10/12 A35894 CHIC; 079705 01329 PROGRAM 10/24 19336 40.00 5,714.85 MICHELE FOREMAN INVI/ 101512. /9011 10/15/12 10/12 A35895 CHK: 079706 01329 PROGRAM 10/31 19336 40.00 5,754.85 MICHELE FOREMAN INV* 10152012 /POI/ 10/15/12 10/12 A35947 CHK: 079758 01329 PROGRAM 10/30 27178 175.00 5,929.85 ■ GRAYLYN R. MORRIS INVI/ 971612 /P00 1 j 10/15/12 10/12 A36013 CHK: 079824 01329 PROGRAM 10/22 11483 40.00 5,969.85 SANDRA WELTON-WOOD INVO 101512 /POI/ 10/15/12 10/12 A36014 CHK: 079825 01329 PROGRAM 10/29 11483 40.00 6,009.85 SANDRA WELTON-WOOD INV$ 101512. /P0I/ 10/15/12 10/12 A36015 CHK: 079826 01329 PROGRAM 11/5 11483 40.00 6,049.85 SANDRA WELTON-WOOD INVI/10152012 /P0* 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- BEGINNING BALANCES: 49,389.30 0.00 REPORTED ACTIVITY: 13,249.94 0.00 i ENDING BALANCES: 62,639.24 0.00 1 1 I I 1 1 1 11-20-2012 08,59 AM CITY OP ELK RIVER PAGE, 1 BALANCE SHEET AS OP, SEPTEMBER 30TH, 2012 211-LIBRARY ACCOUNT R ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 443,532.38 443,532.38 TOTAL ASSETS 443,532.38 LIABILITIES EQUITY 211-2400 Fund Balance 442,182.47 TOTAL BEGINNING EQUITY 442,182.47 TOTAL REVENUE 50,739.21 TOTAL EXPENSES 49,389.30 TOTAL REVENUE OVER/(UNDER) EXPENSES 1,349.91 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 443,532.38 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 443,532.38 11-20-2012 09:05 AM CITY OP ELK RIVER PAGE, 1 EXPENDITURES REPORT (UNAUDITED) AS OF SEPTEMBER 30TH, 2012 F 211-LIBRARY Culture & Recreation 75.001 OP 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 24.57 24.57 9.91 475.43 211-4-5600-4219 Operating Supplies 15,100.00 164.32 5,303.28 35.12 9,796.72 TOTAL Supplies 15,600.00 188.89 5,327.85 34.15 10,272.15 Other Services & Charges 211-4-5600-4321 Telephone 1,550.00 86.36 748.73 48.31 801.27 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 2,232.61 16,663.99 58.68 11,736.01 211-4-5600-4401 Bldg Repair/Maint Services 12,700.00 907.32 4,569.38 35.98 8,130.62 211-4-5600-4404 Equip Repair/Main Services 2,200.00 0.00 1,337.00 60.77 863.00 211-4-5600-4405 Cleaning Services 20,150.00 1,575.00 14,175.00 70.35 5,975.00 211-4-5600-4409 Contractual Services 11,000.00 628.39 5,474.85 49.77 5,525.15 211-4-5600-4433 Dues & Subscriptions _ 250.00 0.00 75.00 30.00 175.00 TOTAL Other Services & Charges 81,400.00 5,429.68 44,061.45 54.13 37,338.55 Capital Outlay Transfers Out TOTAL Library 97,000.00 5,618.57 49,389.30 50.92 47,610.70 TOTAL Culture & Recreation 97,000.00 5,618.57 49,389.30 50.92 47,610.70 TOTAL EXPENDITURES 97,000.00 5,618.57 49,389.30 50.92 47,610.70 • I 1 II-20-2012 9:08 AM D E T A I L L I S T I N G PAGE: 1 FUND : 211-LIBRARY PERIOD TO USE: Sep-2012 THRU Sep-2012 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE IRAN It REFERENCE PACKET DESCRIPTION VEND INV/P0/SE X NOTE AMOUNT==== ====BALANCE==== 4-5600-4201 Office Supplies B EG I NN ING BALANCE 0.00 9/17/12 9/13 A35501 CHK: 079421 01313 LABEL MAKER CARTRIDGE 33250 24.57 24.57 MARGARET STOFFERS INVX 091712 /9010 4-5600-4219 Operating Supplies B EGINNING BALANCE 5,138.96 9/17/12 9/13 A35403 CHK: 079323 01313 PARTS/SUPPLIES 17890 48.09 5,187.05 ELK RIVER WINLECTRIC INVX 082512 /P010 9/17/12 9/13 A35456 CHK: 079376 01313 PARTS/SUPPLIES 25145 43.27 5,230.32 MENARDS - ELK RIVER INV! 083112 /PDX 9/17/12 9/13 A35514 CHK1 079434 01313 LIGHTING CREDIT 35861 5.88CR 5,224.44 VOSS LIGHTING INVX 15207342-00 /P0X 9/17/12 9/13 A35514 CHN: 079434 01313 LIGHTING 35861 78.84 5,303.28 VOSS LIGHTING INVX 15209793-00 /P00 4-5600-4321 Telephone '. B E G I N N I N G BALANCE 662.37 9/11/12 9/11 A35312 CHK: 079274 01312 PHONE LINE CHGS 11102 86.36 748.73 WINDSTREAM INVX 082812 /PDX 4-5600-4389 Utilities B EG I NN I NG BALANCE 14,431.38 9/04/12 8/30 A35210 CHK: 079218 01306 AUG RUBBISH SVCS 30851 57.18 14,488.56 RANDY'S ENVIRONMENTAL SER INVX 09042012 /PDX 9/11/12 9/11 A35306 CHK, 079268 01312 WATER/ELEC 17700 27.00 14,515.56 ELK RIVER MUNICIPAL UTILI INVX 082212 /PDX 9/11/12 10/03 846596 02562 ELECTRIC - AUGUST SEX 016515 2,038.05 16,553.61 9/19/12 9/24 846116 ERMU X 053446 02582 ELEC SALES TAX - AUG 3E0 016346 94.51 16,648.12 9/24/12 9/24 A35551 CHK: 079450 01320 NATURAL GAS 13845 15.87 16,663.99 CENTERPOINT ENERGY INVk 090612. /PDX 4-5600-4401 Bldg Repair/Maint Services B EG I NN I NG BALANCE 3,662.06 9/17/12 9/13 A35359 CHK: 079279 01313 WIRE FLAG LIGHT & POLE 10373 155.32 3,817.38 AID ELECTRIC CORPORATION INVN 39502 /PO# 9/17/12 9/13 A35496 CHN: 079416 01313 MOWING SVCS CONTRACT 11661 344.00 4,161.38 SPEEDCUTTERS OUTDOOR MAIN INVX 3264 /P0# 9/17/12 9/13 A35496 CHK: 079416 01313 LAWN SVCS 11661 408.00 4,569.38 SPEEDCUYTERS OUTDOOR MAIN INVX m890 /P0# 1 I i I 11-20-2012 9:08 AM D E T A I L L I S T I N G PAGE: 2 FUND : 211-LIBRARY PERIOD TO USE, Sep-2012 THRU Sep-2012 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS, ALL POST DATE TRAN P REFERENCE PACKET DESCRIPTION VEND INV/PO/JE P NOTE AMOUNT••== ="=°BALANCE°°' I Il 4-5600-4405 Cleaning Services B EGINNING BALANCE 12,600.00 i 9/04/12 8/30 A35117 CHK: 079125 01306 CLEANING SVCS 13648 1,575.00 14,175.00 i. i CARLSON BUILDING SERVICES INVP 41384 /POP 4-5600-4409 Contractual Services B EG I NN I NG BALANCE 4,846.46 • I 9/04/12 8/30 A35155 CHK: 079163 01306 PROGRAM 9/5 19336 40.00 4,886.46 MICHELE FORSMAN INVP 090412 /P0P 9/04/12 8/30 A35156 04K: 079164 01306 PROGRAM 9/12 19336 40.00 4,926.46 , MICHELE FORSMAN INVP 090412. /POP 9/04/12 8/30 A35222 04K: 079230 01306 PROGRAM 9/13 31950 225.00 5,151.46 SCIENCE MUSEUM OF MN INVM 090412 /POP 9/04/12 8/30 A35249 CHK: 079257 01306 PROGRAM 9/10 11483 40.00 5,191.46 SANDRA WELTON-WOOD INVP 090412 /POP 9/04/12 8/30 A35250 CHK: 079258 01306 PROGRAM 9/17 11483 40.00 5,231.46 SANDRA WELTON-WOOD INVP 090412. /POP 9/17/12 9/13 A35415 CHK1 079335 01313 PROGRAM 9/19 19336 40.00 5,271.46 MICHELE FORSMAN INVP 091712 /POP 9/17/12 9/13 A35416 CHK: 079336 01313 PROGRAM 9/26 19336 40.00 5,311.46 MICHELE FORSMAN INVP 091712. /POP j i 9/17/12 9/13 A35417 CHK: 079337 01313 PROGRAM SUPPLIES 19336 38.07 5,349.53 MICHELE FORSMAN INVP 09172012 /POP 9/17/12 9/13 A35515 CHK: 079435 01313 PROGRAM SUPPLIES 35920 45.32 5,394.85 PAM WAGMAN INVP 091712 /POP li 9/17/12 9/13 A35522 01K' 079442 01313 PROGRAM 9/24 11483 40.00 5,434.85 SANDRA WELTON-WOOD INVP 091712 /POP li 9/17/12 9/13 A35523 CHK: 079443 01313 PROGRAM 10/1 11483 40.00 5,474.85 I SANDRA WELTON-WOOD INV* 091712. /900 000 ERRORS IN THIS REPORTI "-'-*-"-`-"'-`'"' - ' - -` - _ I ** REPORT TOTALS "" --- BEGINNING BALANCES: 43,770.73 0.00 REPORTED ACTIVITY: 5,624.45 5.88CR ENDING BALANCES: 49,395.18 5.88CR i