Loading...
LIBSR TREAS REPORT 10-26-201010-09-2010 01:50 PM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: SEPTEMBER 30TH, 2010 211-LIBRARY ACCOUNT N ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 398,192.06 TOTAL ASSETS LIABILITIES EQUITY 211-2400 Fund Balance 909,323.95 TOTAL BEGINNING EQUITY 909,323.95 TOTAL REVENUE 46,510.29 TOTAL EXPENSES 57,691.68 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 11,181.39) TOTAL EQUITY & REV. OVER/(UNDER) EXP. TOTAL LIABILITIES, EQUITY b REV.OVER/(UNDER) EXP. 398,142.06 398,142.06 396.192.06 398,142.06 10-04-2010 01:50 PM CITY OF ELA RIVER PAGE: 1 REVENUE b EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 211-LIBRARY FINANCIAL SUMMARY 75 .00$ OF YEAR COMP. CURRENT CURRENT YEAR TO DATE & OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 95,350.00 2,109.71 96,510.29 98. 78 98,839.71 TOTAL REVENUES 95,350.00 2,109.71 96 510 29 98 78 , . . 98,839.71 EXPENDITURE SUMMARY Culture b Recreation Library 95,350 .00 10,865. 09 57,691. 66 60.51 37,658. 32 TOTAL Culture b Recreation 95,350 .00 10,865. 09 57,691. 68 60.51 37,658. 32 TOTAL EXPENDITURES 95,350 .00 10,865. 09 57,691. 68 60.51 37,658. 32 REVENUES OVER/(UNDER) EXPENDITURES 0. 00 ( 755 8 38)( 11 181 39 , . , . ) 11,181. 39 10-09-2010 01:50 PM CITY OF ELE RIVER PAGE: 2 REVENUE 6 EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 211-LIBRARY REVENUES Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 211-3-0000-3112 Delinquent Ad Valorem Taxes TOTAL Taxes Other Revenue 211-3-0000-3621 Interest Income 211-3-0000-3626 Contributions TOTAL Other Revenue TOTAL Library 95,350.00 2,109.71 96,510.29 98.76 48,839.71 75.00& OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 58,850.00 0.00 27,715.00 47.09 31,135.00 0.00 0.00 1,192.91 0.00 ( 1,192.91) 58,850.00 0.00 28,857.41 99.09 29,992.59 9,500. 00 0 .00 1,625 .97 17. 12 7,874 .03 27,000. 00 2,109. 71 16,026 .91 59. 36 10,973. 09 36,500. 00 2,109. 71 17,652 .88 48. 36 18,847 .12 TOTAL REVENUE 95,350.00 2,109.71 46,510.29 98.78 98,839.71 10-09-2010 01:50 PM CITY OF ELK RIVER PAGE: 3 REVENUE fi EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2010 211-LIBRARY Culture 6 Recreation Library DEPARTMENTAL EXPENDITURES 75.009 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE $ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies 211-4-5600-9201 Office Supplies 211-9-5600-9219 Operating Supplies TOTAL Supplies Other Services s Charges 211-4-5600-4321 Telephone 211-4-5600-9322 Postage 211-9-5600-4331 Travel, Conferences fi Schools 211-9-5600-9359 Publishing 211-9-5600-4361 Insurance 211-9-5600-9389 Utilities 211-4-5600-9401 Bldg Repair/Maint Services 211-9-5600-9904 Equip Repair/Maint Services 211-9-5600-4905 Cleaning Services 211-4-5600-9409 Contractual Services 211-4-5600-9433 Dues fi Subscriptions TOTAL Other Services d Charges 500.00 76.21 193.26 38.65 306.74 10,600.00 393.15 4,859.96 45.85 5,740.04 11,100.00 469.36 5,053.22 45.52 6,046.78 1,950. 00 128. 68 1,166. 49 80. 99 283. 56 so. oa o. oo a. oo o. aa so. oo l,soo. oo o. oo o. oo o. oo l,soo .oo 1,500. 00 0. 00 111. 68 7. 95 1,388 .32 2,900. 00 0. 00 1,291. 50 44. 53 1,608 .50 29,000. 00 2,209. 22 17,497. 73 60. 39 11,502 .27 13,950. 00 5,628 .80 9,733. 23 69. 77 4,216 .77 2,500. 00 200 .00 1,605. 69 69. 23 894 .31 20,150. 00 1,575 .00 19,932. 96 74. 11 5,217 .04 11,000. 00 654 .03 6,169. 28 56. 04 9,835 .72 250. 00 0 .00 139. 95 53. 98 115 .Os 84,250 .00 10,395 .73 52,636 .96 62 .98 31,611 .54 TOTAL Library 95,350.00 10,865.09 57,691.68 60.51 37,658.32 TOTAL Culture s Recreation 95,350.00 10,865.09 57,691.68 60.51 37,656.32 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 95,350. 00 10,865. 09 57,691 .68 60.51 37,658. 32 0. 00 ( 8,755. 38)( 11,181 .39) 11,181 .39 10-09-2010 1:51 PM D E T A I L L I S T I N G PAGE: 1 FUND 211 -LIBRARY ACTIVE ACCOUN TS ONLY PERIOD TO USE: Sep-2010 TH RU Sep- 2010 DEPT 5600 Library SUPPRESS Z EROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=== ==_= VEND INV/ PO/JE # NOTE =====AMOUNT== == === =BALANCE==== 9-5600-4201 Office Supplies __________ ___________________ ______________ _______ ___ B E G I N N I N G B A L A N C E 117. 05 9/07/10 9/03 A19000 CHK: 070045 00727 OFFICE SUPPLIES 33250 76 .21 193 .2fi MARGARET STOPPERS INV# 090710 /PO# ____________ _ SEPTEMBER ACTIVITY DB: 76.21 CR: 0.00 76. 21 9-5600-9219 Operating Supplies __ __ _____ ___ B E G I N N I N G 8 ALAN C E 9,466. 81 9/07/10 9/03 A18874 CHK: 069919 00727 PARTS/SUPPLIES 11116 171 .93 9,638 .79 DIVERSIFIED AIR, INC. INV# 35588 /PO# 9/20/10 9/16 A19129 CHK: 070111 00736 SUPPLIES 15887 39 .61 4,678 .35 DACOTAH PAPER CO INV# 12116 /PO# 9/20/10 9/16 A19129 CHK: 070111 00736 SUPPLIES 15887 109 .40 9,782 .75 DACOTAH PAPER CO INV# 12757 /PO# 9/20/10 9/16 A19181 CHK: 070163 00736 PARTS/SUPPLIES 25195 98 .79 4,831 .99 MENARDS - ELK RIVER INV# 083110 /PO# 9/20/10 10/O1 A19509 CHK: 009578 00759 BAL AUG SALES & USE TAX 26300 35 .33CR 4,796 .16 MN DEPT. OF REVENUE INV# 092010 /PO# 9/29/10 9/29 A19303 CHK: 070299 00744 PARTS/SUPPLIES 21600 63 .80 9,859 .96 HOME DEPOT CREDIT SERVICE INV# 091310 /PO# --------___ = SEPTEMBER ACTIVITY DB: 9 28.98 CR: 35.33CR 393. 15 9-5600-4321 Telephone B E G I N N I N G B ALAN C E 1, 037. 76 9/20/10 9/16 A19255 CHK: 070237 00736 PHONE LINE CHGS 11102 128 .68 1,166 .44 W INDST REAM INV# 97261211 /PO# ---------- - SEPTEMBER ACTIVITY DB: 1 28.68 CR: 0.00 128. 68 9-5600-9389 Utilities __ ___ ___ B E G I N N I N G B ALAN C E 15, 288.51 9/07/10 9/03 A18887 CHK: 069932 00727 WATER/ELEC SVC 17700 93 .38 15,331. 89 ELK RIVER MUNICIPAL UTILI INV# 082510. /PO# 9/07/10 9/03 A18972 CHK: 0700 P7 00727 AUG RUBBISH SVC 30851 56. 13 15,388. 02 RANDY'S ENVIRONMENTAL SER INV# 09072010. /PO# 9/07/10 10/O1 829578 01356 ELECTRIC - AUG JE# 008599 2,109. 71 17,997. 73 ------------- SEPTEMBER ACTIVITY DB: 2,209.22 CR: 0.00 2,209.22 10-09-2010 1:51 PM D E T A I L L I S T I N G PAGE: 3 FUND 211- LIBRARY ACTI VE ACCOUNTS ONLY PERIOD TO USE: Sep-2010 THRU Sep-2010 DEPT 5600 Library S UPPRESS ZEROS ACCOUNTS: ALL POST DATE IRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOU NT==== ====BAL ANCE==== 9/07/10 9/03 A18902 CHK: 069947 00727 PROGRAMS 9/13, 9/15 19336 80.00 5,694. 28 MICHELE FORSNAN INV# 090710. /PO# 9/20/10 9/16 A19151 CHK: 070133 00736 PROGRAME 9/20, 9/22 19336 80.00 5,729. 28 MICHELE FOASNAN INV# 092010 /PO# 9/20/10 9/16 A19152 CHK: 070134 00736 PROGRAM 9/21 19336 40.00 5,769 .28 MICHELE FORSNAN INV# 092010. /PO# 9/20/10 9/lfi A19153 CHK: 070135 00736 PROGRAMS 9/27, 9/29 19336 80.00 5,894 .28 MICHELE FORSMAN INV# 09202010 /PO# 9/20/10 9/16 A19169 CHK: 070151 00736 PROGRAM 9/23 23300 360.00 6,204 .28 RACHAEL KR00G INV# 092010 /PO# 9/30/10 9/30 A19329 VOID : 070139 00750 REVERSE VOIDED CHECK 19336 90.0008 6,169 .28 MICHELE FORSMAN INV# 092010. /PO# ____ _________ SEPTEMBER ACTIVITY OB: 699.03 CR: 40.0008 654.03 *-*-+-*-+- *-*- *-*-*-+- *-*- 000 ERRORS IN THIS REPORT! +_+_+_+_+_+_+ _+_+_._+_+_+_+ ** REPORT TOTALS * * --- DEBITS --- --- CREDITS --- BEGINNING BALANCES : 46,826.59 0. 00 REPORTED ACTIVITY: 10,940.92 75. 33CR ENDING BALANCES: 57,767.01 75. 33CR