Loading...
LIBSR Financials 09-22-20099 -03-2009 1:59 PM D E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY PERIOD TO USE: Aug-2009 THRU Aug-2009 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE IRAN # REFERENCE PACKET======DESCRIPTION==== =_= UEND INU/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ---------------------- 4-5600-4201 ------------------------------------------ Office Supplies ---- ---------------- --------------- ---------------- ----------------- B EGINNING BALAN CE 50.56 8/03/09 7/30 A09439 CHK: 064758 00344 SIGN HOLDER 16275 28.64 79.20 DEMCO INU# 3599377 /PO# ____ _________ AUGUST ACTIUITY DB: 28.64 CR: 0.00 28.64 ---------------------- 4-5600-4219 ------------------------------------------ Operating Supplies ---- ---------------- --------------- ---------------- ----------------- B EGINNING BALAN CE 5,327.10 8/03/09 7/30 A09453 CHK: 064772 00344 SLATWALL SUPPLIES 19735 108.40 5,435.50 GAYLORD BROS INU# 1315452 /PO# 8/03/09 7/30 A09458 CHK: 064777 00344 AIR FILTERS 20300 231.62 5,667.12 GRAINGER INU# 9033702730 /PO# 8/03/09 7/30 A09458 CHK: 064777 00344 AIR FILTERS 20300 231.62 5,898.74 GRAINGER INU# 9035417220 /PO# 8/17/09 8/14 A09723 CHK: 064973 00367 BULK SALT 18647 94.91 5,993.65 FINKEN'S i~ATER CENTERS INU# 1015944 /PO# 8/17/09 8/14 A09726 CHK: 064976 00367 PROGRAM SUPPLIES 19336 71.88 6,065.53 MICHELE FORSMAN INU# 081709 /PO# 8/17/09 8/14 A09739 CHK: 064989 00367 RED CEDAR 10107 23.96 6,089.49 GREAT NORTHERN LANDSCAPES INU# 7143 /PO# 8/17/09 8/14 A09739 CHK: 064989 00367 RED CEDAR 10107 191.70 6,281.19 GREAT NORTHERN LANDSCAPES INU# 7144 /PO# 8/17/09 8/14 A09739 CHK: 064989 00367 RED CEDAR 10107 23.96 6,305.15 GREAT NORTHERN LANDSCAPES INU# 7145 /PO# 8/17/09 8/14 A09739 CHK: 064989 00367 RED CEDAR 10107 191.70 6,496.85 GREAT NORTHERN LANDSCAPES INU# 7146 /PO# 8/17/09 8/14 A09753 CHK: 065003 00367 REPLACEMENT PARTS 10278 684.00 7,180.85 J.H. CARSON COMPANY INU# 4232188-01 /PO# 8/17/09 8/14 A09773 CHK: 065023 00367 PARTS/SUPPLIES 25145 6.39 7,187.24 MENARDS - ELK RIUER INU# 073109 /PO# 8/20/09 8/21 A09912 CHK: 009528 00374 JUNE BAL SALES & USE TAX 26300 6.89 7,194.13 MN DEPT. OF REVENUE INU# 082009 /PO# ____ _________ AUGUST ACTIUITY DB: 1,867.03 CR: 0.00 1,867.03 ---------------------- 4-5600-4321 ------------- Telephone ----------------------------- ---- ---------------- --------------- ---------------- ----------------- B EGINNING BALAN CE 840.25 8/18/09 8/19 A09887 CHK: 065114 00371 PHONE LINE/LONG DISTANCE 28449 120.68 960.93 NORTHSTAR ACCESS INU# 6659030 /PO# ____ _________ AUGUST ACTIUITY DB: 120.68 CR: 0.00 120.68 9 -03-2009 1:59 PM D E T A I L L I S T I N G PAGE: 2 FUND 211-LIBRARY PERIOD TO USE: Aug-2009 THRU Aug- 2009 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE IRAN # REFERENCE PACKET======DESCRIPTION==== =_= VEND INU/PO/JE # NOTE =====AMOUNT==== === =BALANCE==== ---------------------- 4-5600-4389 -------------- Utilities ---------------------------- ---- ------- ----- ------------------- -------------------- ------------- B E G I N N I N G B A L A N C E 12, 744.05 8/03/09 7/30 A09521 CHK: 064840 00344 JULY RUBBISH SUCS 30851 52.76 12,796.81 RANDY'S ENVIRONMENTAL SER INU# 080309 . /PO# 8/17/09 8/14 A09681 CHK: 064931 00367 NATURAL GAS 13845 22.59 12,819.40 CENTERPOINT ENERGY INU# 080620 09 /PO# 8/17/09 8/14 A09713 CHK: 064963 00367 WATER/ELEC SUC 17700 33.42 12,852.82 ELK RIVER MUNICIPAL UTILI INU# 072509 /PO# 8/17/09 9/01 B12081 00677 ELECTRIC - JULY JE# 004382 1,869.88 14,722.70 8/27/09 8/28 B12022 ERMU # 056085 00673 SALES TAX FOR DONATED ELEC JE# 004368 95.22 14,817.92 _____________ AUGUST ACTIVITY DB: 2,073.87 CR: 0.00 2,073.87 ---------------------- 4-5600-4401 -------------- Bldg Repair/ ---------------------------- Maint Services ---- ------- ----- ------------------- -------------------- ------------- B E G I N N I N G B A L A N C E 7, 796.09 8/03/09 7/30 A09441 CHK: 064760 00344 EXTERIOR GLASS CLEANING 16448 219.09 8,015.18 DISTINCTIVE WINDOW CLEANI INU# 071555 /PO# 8/03/09 7/30 A09474 CHK: 064793 00344 MOWING SERVICES 22681 457.95 8,473.13 JEREMY'S LAWN SERVICE INU# 4298 /PO# 8/17/09 8/14 A09663 CHK: 064913 00367 RPZ TESTING 10950 190.00 8,663.13 B & D PLBG, HTG & AIR CON INU# 39205 /PO# 8/17/09 8/14 A09692 CHK: 064942 00367 PEST CONTROL 15191 80.16 8,743.29 COUNTRY SIDE PEST CONTROL INU# 5433 /PO# _____________ AUGUST ACTIVITY DB: 947.20 CR: 0.00 947.20 ---------------------- 4-5600-4405 -------------- Cleaning Ser ---------------------------- vices ---- ------- ----- ------------------- -------------------- ------------- BE GINNING BALAN CE 11,741.66 8/03/09 7/30 A09423 CHK: 064742 00344 AUG CLEANING SUCS 13648 1,683.28 13,424.94 CARLSON BUILDING SERVICES INU# 28186 /PO# _____________ AUGUST ACTIVITY DB: 1,683.28 CR: 0.00 1,683.28 ---------------------- 4-5600-4409 -------------- Contractual ---------------------------- Services ---- ------- ----- ------------------- -------------------- ------------- BE GINNING BALAN CE 5,977.95 8/03/09 7/30 A09452 CHK: 064771 00344 PROGRAMS 8/3, 8/5 19336 80.00 6,057.95 MICHELE FORSMAN INU# 080309 /PO# 8/03/09 7/30 A09465 CHK: 064784 00344 PROGRAM 8/6 20818 225.00 6,282.95 LYNN HALBROOK INU# 080609 /PO# 8/17/09 8/14 A09727 CHK: 064977 00367 PROGRAM 8/18 19336 40.00 6,322.95 MICHELE FORSMAN INU# 081809 /PO# 8/17/09 8/14 A09728 CHK: 064978 00367 PROGRAM 9/2 19336 40.00 6,362.95 MICHELE FORSMAN INU# 090209 /PO# 8/20/09 8/20 A09905 VOID: 064559 00375 REVERSE VOIDED CHECK 10556 200.OOCR 6,162.95 GARY HARBO INU# 072009 /PO# _____________ AUGUST ACTIVITY DB: 385.00 CR: 200.OOCR 185.00 9-03-2009 1:59 PM D E T A I L L I S T I N G PAGE: 3 FUND 211-LIBRARY PERIOD TO USE: Aug-2009 THRU Aug-2009 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE IRAN # REFERENCE PACKET======DESCRIPTION=====_= UEND INU/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4520 Buildings & Structures B E G I N N I N G B A L A N C E 10, 448.50 8/20/09 8/21 A09912 CHK: 009528 00374 JUNE BAL SALES & USE TAX 26300 45.40 10,493.90 MN DEPT. OF REVENUE INU# 082009 /PO# _____________ AUGUST ACTIUITY DB: 45.40 CR: 0.00 45.40 *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! *-*-*-*-*-*-*-*-*-*-*-*-*-* ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 58,492.74 0.00 REPORTED ACTIUITY: 7,151.10 200.OOCR ENDING BALANCES: 65,643.84 200.OOCR 9-03-2009 01:57 PM CITY OF ELK RIUER PAGE: 1 BALANCE SHEET AS OF: AUGUST 31ST, 2009 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 394,984.10 TOTAL ASSETS LIABILITIES EQUITY 211-2400 Fund Balance 409,084.27 TOTAL BEGINNING EQUITY 409,084.27 TOTAL REUENUE 51,343.67 TOTAL EXPENSES 65,443.84 TOTAL REUENUE OUER/(UNDER) EXPENSES ( 14,100.17) 394,984.10 TOTAL EQUITY & REU. OUER/(UNDER) EXP. 394,984.10 TOTAL LIABILITIES, EQUITY & REV.OUER/(UNDER) EXP. 394,984.10 -------------- -------------- 394,984.10 -------------- -------------- 9-03-2009 01:58 PM CITY OF ELK RIUER PAGE: 1 REUENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2009 211-LIBRARY FINANCIAL SUMMARY 66.67a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REUENUE SUMMARY Library 89,800.00 1,869.88 50,612.63 56.36 39,187.37 Library Project 0.00 0.00 731.04 0.00 ( 731.04) TOTAL REVENUES 89,800.00 ------------- - ------------- - 1,869.88 ------------ ------------ 51,343.67 ------------- ------------- 57.18 ------- ------- 38,456.33 ------------- ------------- EXPENDITURE SUMMARY Culture & Recreation Library 89,800.00 6,951.10 64,694.91 72.04 25,105.09 Library Project 0.00 0.00 748.93 0.00 ( 748.93) TOTAL Culture & Recreation 89,800.00 6,951.10 65,443.84 72.88 24,356.16 TOTAL EXPENDITURES 89,800.00 6,951.10 65,443.84 72.88 24,356.16 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- REUENUES OUER/(UNDER) EXPENDITURES 0.00 ( 5,081.22)( 14,100.17) 14,100.17 9-03-2009 01:58 PM REUENUE 211-LIBRARY REVENUES CITY OF ELK RIUER & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2009 CURRENT CURRENT BUDGET PERIOD EAR TO DATE ACTUAL 6.67a o OF BUDGET PAGE: 2 F YEAR COMP. BUDGET BALANCE Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 70,900.00 0.00 33,336.47 47.02 37,563.53 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 677.76 0.00 ( 677.76) TOTAL Taxes 70,900.00 0.00 34,014.23 47.97 36,885.77 Other Revenue 211-3-0000-3621 Interest Income 3,000.00 0.00 3,120.83 104.03 ( 120.83) 211-3-0000-3626 Contributions 15,900.00 1,869.88 13,477.57 84.76 2,422.43 TOTAL Other Revenue 18,900.00 1,869.88 16,598.40 87.82 2,301.60 TOTAL Library 89,800.00 1,869.88 50,612.63 56.36 39,187.37 Library Project --------------- --------------- Transfers In 211-3-5610-3927 Transfer-Govt Buildings Reserv 0.00 0.00 731.04 0.00 ( 731.04) TOTAL Transfers In 0.00 0.00 731.04 0.00 ( 731.04) TOTAL Library Project 0.00 0.00 731.04 0.00 ( 731.04) TOTAL REVENUE 89,800.00 1,869.88 51,343.67 57.18 38,456.33 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- 9-03-2009 01:58 PM 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES 66.67a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 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/Maim Services 211-4-5600-4404 Equip Repair/Maim 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 211-4-5600-4520 Buildings & Structures TOTAL Capital Outlay 500.00 28.64 79.20 15.84 420.80 16,700.00 1,867.03 7,194.13 43.08 9,505.87 17,200.00 1,895.67 7,273.33 42.29 9,926.67 0.00 120.68 960.93 0.00 ( 960.93) 50.00 0.00 0.00 0.00 50.00 1,500.00 0.00 0.00 0.00 1,500.00 1,000.00 0.00 112.20 11.22 887.80 3,350.00 0.00 1,249.50 37.30 2,100.50 21,900.00 2,073.87 14,817.92 67.66 7,082.08 15,300.00 947.20 8,743.29 57.15 6,556.71 2,200.00 0.00 1,321.00 60.05 879.00 16,050.00 1,683.28 13,424.94 83.64 2,625.06 11,000.00 185.00 6,162.95 56.03 4,837.05 250.00 0.00 134.95 53.98 115.05 72,600.00 5,010.03 46,927.68 64.64 25,672.32 0.00 45.40 10,493.90 0.00 ( 10,493.90) 0.00 45.40 10,493.90 0.00 ( 10,493.90) CITY OF ELK RIUER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2009 TOTAL Library 89,800.00 6,951.10 64,694.91 72.04 25,105.09 9-03-2009 01:58 PM 211-LIBRARY Culture & Recreation Library Project DEPARTMENTAL EXPENDITURES 66.67a OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 211-4-5610-4319 Other Professional Services TOTAL Other Services & Charges TOTAL Library Project TOTAL Culture & Recreation 0.00 0.00 748.93 0.00 ( 748.93) 0.00 0.00 748.93 0.00 ( 748.93) 0.00 0.00 748.93 0.00 ( 748.93) 89,800.00 6,951.10 65,443.84 72.88 24,356.16 TOTAL EXPENDITURES 89,800.00 ------------- -- ------------- -- 6,951.10 ----------- -- ----------- -- 65,443.84 72.88 ----------- ------- - ----------- ------- - 24,356.16 ------------ ------------ REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 5,081.22)( 14,100.17) 14,100.17 CITY OF ELK RIUER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2009