Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3.2. LIBSR 03-28-2017
5 . 2- 3-08-2017 02:10 PN. CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2016 211-LIBRARY ACCOUNT N ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 427,195.29 211-1070 Taxes Receivable 3,406.67 21.1-1380 Interest Receivable 1,838.00 432,439.96 TOTAL ASSETS 432,439.96 LIABILITIES 211-2020 A/P - Library 3,639.69 211-2200 Deposits Payable 200.00 211-2310 Unavailable Revenue - Tales 534.90 TOTAL LIABILITIES 4,374.59 EQUITY 211-2400 Fund Balance 415,177.84 TOTAL BEGINNING EQUITY 415,777.84 TOTAL REVENUE 94,485.53 TOTAL EXPENSES 82,198.00 TOTAL REVENUE OVER/(UNDER) EXPENSES 12,287.53 TOTAL EQUITY 4 REV. OVER/(UNDER) EXP. 428,065.37 TOTAL LIABILITIES, EQUITY b REV.OVER/(UNDER) EXP. 432,439:96 3-08-2017 2:12 PM DETAIL LISTING PAGE: 1 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Dec-2016 THRU Dec-2016 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET= --DESCRIPTION-'----_ VEND INV/PO/JE 9 NOTE ------AMOUNT---- - -===BALANCE--- 4-5600-4201 Office Supplies B EGIN N I N G BALANCE 51.67 12/31/16 2/01 A70068 CHK: 100108 02531 SUPPLIES . 17420 11.73 63.40 CASH INV# 123116. /80# DECEMBER ACTIVITY DB: 11.73 CR: 0.00 1.1.73 4-5600-4219 Operating Supplies B EGINNING BALANCE 7,586.3]. 12/19/16 12/15 A68549 CHK: 099626 02481 PARTS/SUPPLIES 25145 55.56 7,641.87 MENARDS - ELK RIVER INV# 113016 /20# 12/19/16 12/15 A68600 CHK: 099677 02481 BULK SALT 13048 77.00 7,718.87 STEP SAVER INC INV# 105205C /80# 12/19/16 12/15 A68623 011K; 099700 02481 LIGHTING 35861 119,10 7,837.97 VOSS LIGHTING INV# 15293960-00 /80# 12/31/16 12/29 A68835 CHK: 099758 02491 SUPPLIES 15887 44.83 7,882.80 DACOTAH PAPER CO INV# 10533 /80# 12/31/16 1/24 A69616 CHK; 100061 02520 BULK SALT 13048 65.80 7,948.60 STEP SAVER INC INV# 1060078 /80# DECEMBER ACTIVITY DB; 362.29 CR: 0.00 362.29 4-5600-4321 Telephone B EGINNING BALANCE 913.71 12/14/16 12/14 A68436 CHK: 099538 02480 PHONE LINE CHGS 11102 91.26 1,004.97 WINDSTREAM INV# 110816 /80# 12/27/16 12/27 A68689 CHK: 099722 02490 PHONE LINE CHGS 11102 93.67 1,098.64 WINDSTRE.AM INV# 120716 /80# DECEMBER ACTIVITY DB: 184.93 CR: 0.00 184.93 4-5600-4389 Utilities B EGINNING BALANCE 22,412.32 12/06/16 12/01 A68356 EFT: 000082 02474 NOV RUBBISH SVCS 30851. 58.35 22,470.67 RANDY'S ENVIRONMENTAL SER INV# 135818-11/19/16 /P08 12/15/16 12/14 A68403 EFT: 000083 02479 WATER/ELEC 17700 1,960.60 24,431.27 ELK RIVER MUNICIPAL UTILI INV# 112116 /PO8 12/31/16 12/29 A68917 EFT: 000091 02491 DEC RUBBISH SVCS 30851 58.35 24,489.62 RANDY'S ENVIRONMENTAL SER INV# 135818-12/19/16 /80# 12/31/16 1/13 A69538 EFT: 000097 02505 WATER/ELEC 17700 1,953.98 26,443.60 ELK RIVER MUNICIPAL UTILI INV# 123116 /80# DECEMBER DECEMBER ACTIVITY DB; 4,031.28 CR: 0.00 4,031.28 3-08-2017 2:12 PM DETAIL LISTING PAGE: 2 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Dec-2016 THRU Dec-2016 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAM 9 REFERENCE PACKET==- --DESCRIPTION======= VEND INV/PO/JE # NOTE a===-AMOUNT=--- ==^ BALANCE === 4-5600-4401 Bldg Repair/Maint Services B EGINNING BALANCE 1.8,350.30 12/31/16 12/29 A68930 CHK: 099838 02491 FIRE ALARM REPAIRS 33444 260.00 18,610.30 SUMMIT COMPANIES INV# 1160733 /PO8 --------===== DECEMBER ACTIVITY DB: 260.00 CR: 0.00 260.00 4-5600-4405 Cleaning Services B EGINNING BALANCE 12,430.00 12/19/16 12/15 A68568 CHK: 099645 02481 DEC CLEANING SVCS 12651 1,245.00 13,695.00 PERFECTION PLUS, INC. INV# 112659 /PC# 12/31/16 12/29 A68778 CHK: 099817 02491 JULY CLEANING SVCS 12651 1,245.00 14,940.00 PERFECTION PLUS, INC. INV# 112418 /90# _________-__= DECEMBER ACTIVITY DB: 2,490.00 CR: 0.00 2,490.00 4-5600-4409 Contractual Services B EGINNING BALANCE 10,462.34 12/05/16 12/01 A68239 CHK: 099404 02473 PROGRAM 12/7 13683 40.00 10,502.34 DEBORAH CARRON INV# 120716 /PO# 12/05/16 12/01 A68240 CHK: 099405 02473 PROGRAM 12/9 13693 40.00 10,542.34 DEBORAH CARRON INV# 120916 /PO6 12/05/16 12/01 A68241 CHK: 099406 02473 PROGRAM 12/14 13683 40.00 10,562.34 DEBORAH CARRON INV# 121416 /P0# 12/05/16 12/01 A68242 CON: 099407 02473 PROGRAM 1.2/16 13683 40.00 10,622.34 DEBORAH CARRON INV# 121616 /90# 12/05/16 12/01 A68312 CHK: 099477 02473 PROGRAM 12/12 13060 40.00 10,662,34 ROBIN SCHAIBLE INV# 121216 /PO9 12/05/16 12/01 A68313 CHK: 099478 02473 PROGRAM 12/19 13060 40.00 10,702.34 ROBIN SCHAIBLE INV# 121916 /PO4 12/19/16 12/15 A68468 CHK: 099565 02481 PROGRAM 12/21 13683 40.00 10,742.34 DEBORAH CARRON INV# 1.22116 /00# 12/19/16 12/15 A68489 CHK: 099566 02481 PROGRAM 12/23 13683 40.00 10,792.34 DEBORAH CARRON INV# 122316 /PO# 12/19/16 12/15 A68490 CHK: 099567 02481 PROGRAM 12/28 13683 40.00 10,822.34 DEBORAH CARRON INV# 122816 /P0# 12/19/16 12/15 0,68491 CHK: 099568 02481 PROGRAM 12/30 13683 40.00 10,862.34 DEBORAH CARRON INV# 123016 /P08 _ _-_= DECEMBER ACTIVITY DB: 400.00 CR: 0.00 400.00 3-08-2017 2:12 PM DET A I L LISTING PAGE: 3 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Dec-2016 THRU Pec-2016 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE: TRAM # REFERENCE PACKKr DESCRIPTION----•-_- VEND INV/PO/JE # NOTE -AMOUNT==== +-*-*-*-*-*-+-*-*-*-*-*- 000 ERRORS IN THIS REPORT! *-*-*_*_<_+_+_+_+_*_•_*_+_+ ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 74,352.55 0.00 REPORTED ACTIVITY: 7,740.23 0.00 ENDING BALANCES: 82,092.78 0.00 TOTAL FUND ENDING BALANCE: 82,092.78 3-08-2017 02:11 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2016 211-LIBRARY FINANCIAL SUMMARY 100.60% or YEAR COMP CURRENT CURRENT YEAR TO DATE I OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 91,750.00 29,127.42 94,485.53 102.98 ( 2,735.53) TOTAL REVENUES 91,750.00 29,127.42 94,485.53 102.98 ( 2,735.53) EXPENDITURE SUMMARY Culture & Recreation Library 110,750:00 7,740.23 82,198.00 74,22 28,552.00 TOTAL Culture & Recreation 110,750.00 7,740.23 82,198.00 74.22 28,552.00 TOTAL EXPENDITURES 110,750.00 7,740.23 82,198.00 74.22 28,552.00 REVENUES OVER/(UNDER) EXPENDITURES ( 19,000.00) 21,387.19 12,287.53 ( 31,287.53) 3-08-2017 02:11 PM CITY OF ELK RIVER PAGE: 2 REVENUE d EXPENSE REPORT (UNAUDITED( AS OF: DECEMBER 31ST, 2016 211-LIBRARY 100.00% OE YEAR CORP. CURRENT CURRENT YEAR TO DATE 9 OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 59,400.00 28,228.46 59,046.20 99.40 353.80 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 ( 86.55) 85.65 0.00 t 85.65) TOTAL Taxes 59,400.00 26,141.91 59,131.85 99.55 268.15 Intergovernmental Rev .. Charges fur Services Other Revenue 211-3-0000-3621 Interest Income 4,000.00 985.51 7,003.68 175.09 ( 3,003.68) TOTAL Other Revenue 4,000.00 985.51 7,003.68 175.09 ( 3,003.68) Transfers In 211-3-0000-3945 Transfer-Utilities 28,350.00 0.00 28,350.00 100.00 0.00 TOTAL Transfers In 28,350.00 0.00 28,350.00 100.00 0.00 TOTAL Library 91,750.00 29,127.42 94,485.53 102.98 ( 2,735.53) Library Project Other Financing Sources Transfers ln. TOTAL REVENUE 91,750,00 29,127.42 94,485.53 102.98 ( 2,735.53) 3-08-2017 02:11 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2016 211-LIBRARY Culture & Recreat.ior. 100.00% OF YEAR COMP. Library CURRENT CURRENT YEAR TO DATE I OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 211-4-5610-4103 Part-time Pay 500.00 0.00 91.36 18.27 400.64 211-4-5600-4104 ?ERA 0.00 0.00 6.86 0.00 ( 6.86) 211-4-5600-4105 FICA 0.00 0.00 5.67 0.00 ( 5.67) 211-4-5600-4107 Medicare 0.00 0,00 1.33 0.00 ( 1.33) TOTAL Personal Services 500.00 0.00 105.22 21.04 394.78 Supplies 211-4-5600-4201 Office Supplies 100.00 11.73 63.40 63.40 36.60 211-4-5600-4219 Operating Supplies 14,650.00 362.29 7,946.60 54.26 6,701.40 TOTAL Supplies 14,750.00 374.02 8,012.00 54.32 6,738.00 Other Services & Charges 211-4-5600-4321 Telephone 1,100.00 184.93 1,098.64 99.88 1.36 211-4-5600-4331 Travel, Conferences & Schools 650.00 0.00 0.00 0.00 650.00 211-4-5600-4361 Insurance 2,150.00 0.00 2,022.00 94.05 128.00 211-4-5600-4389 Utilities 29,450.00 4,031.28 26,443.60 89.79 3,006.40 211-4-5600-4401 Bldg Repair/Maint Services 16,050.00 260.00 18,610.30 115.95 ( 2,560.301 211-4-5600-4404 Equip Repair/Maint Services 1,000.00 0.00 103.90 10.39 896.10 211-4-5600-4405 Cleaning Services 15,000.00 2,490.00 14,940.00 99.60 60.00 211-4-5600-4409 Contractual Services 11,000.00 400.00 10,862.34 98.75 137.66 211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 76,500.00 7,366.21 74,080.78 96.84 2,419.22 Capital Outlay 211-4-5600-4560 Equipment 19,000.00 0.00 0.00 0.00 19,000.00 TOTAL Capital Outlay 19,000.00 0.00 0.00 0.00 19,000.00 Transfers Out TOTAL Library 110,750.00 7,740.23 82,198.00 74.22 28,552.00 TOTAL Culture & Recreation 110,750.00 3,740.23 82,198.00 74.22 28,552.00 TOTAL EXPENDITURES 110,750.00 7,740.23 82,198.00 74.22 28,552.00 REVENUES OVER/(UNDER) EXPENDITURES ( 19,000.00) 21,387.19 12,287.53 ( 31,287.53) 2-14-2017 01:25 PM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: JANUARY 31ST, 2017 211-LIBRARY - ""°""^a. ACCOUNT B ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 424,272.65 424,272.85 TOTAL ASSETS 424,272.85 LIABILITIES 211-2020 A/P - Library 11.73 211-2200 Deposits Payable 350.00 TOTAL LIABILITIES 361.73 EQUITY 211-2400 Fund Balance 415,777.84 TOTAL BEGINNING EQUITY 415,777.84 TOTAL EXPENSES 2,318.25 (WILL CLOSE TO FUND BAL.) 10,449.53 TOTAL REVENUE OVER/(UNDER) EXPENSES 8,133.28 TOTAL EQUITY S REV. OVER/(UNDER) EXP. 423,911.12 TOTAL LIABILITIES, EQUITY S REV.OVER/IUNDER) EXP. 424,272.85 2-14-2017 1:29 PM D E T A I L I STING PAGE: 1 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Jan-2017 THRU Jan-2017 DEPT : 5610 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAM # REFERENCE PACKET======DESCRIPTION===-=...: VEND INV/PO/JE 6 NOTE 3iiE..AMOUNT --_ ,... BALANCE., 4-5600-4361 Insurance BEGINNING BALANCE 0.7 1/01/17 2/07 B98123 05322 LMC - PROP/LIAB INS,JAN-MAR JE# 034945 511.25 511. _-__ _______= JANUARY ACTIVITY DB: 511.25 CR: 0.00 511.25 4-5600-4405 Cleaning Services BEGINNING BALANCE 0.( 1/23/17 1/24 A69641. CHK: 100048 02520 JAN CLEANING SVCS 12651 1,245.00 1,245. PERFECTION PLUS, INC. INV# 112708 /PO8 ___-___== u JANUARY ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00 4-5600-4409 Contractual Services BEGINNING BALANCE O.6 1/03/17 12/29 A68797 CHH: 099831 02491 PROGRAM 1/9 13060 40.00 40. ROBIN SCHAIBLE INV# 010917 /20# 1/03/17 12/29 A68820 CHK: 099747 02491 PROGRAM 1/4 13683 40.00 80. DEBORAH CARRON INV# 010417 /201 1/03/17 12/29 A68821 CHK: 099748 02491 PROGRAM 1/6 13683 40.00 120. DEBORAH CARRON INV# 010617 /P0# 1/03/17 12/29 A68822 CHK: 099749 02491 PROGRAM 1/11 13683 40.00 160. DEBORAH CARRON INV# 011117 /1,01 • 1/03/17 12/29 A68823 CHK: 099750 02491 PROGRAM 1/13 13683 40.00 200. DEBORAH CARRON INV# 011317 /P0# 1/17/17 1/11 A69204 CHK: 099944 02502 PROGRAM 1/23 13060 40.00 240. ROBIN SCHAIBLE INV# 012317 /PO8 1/17/17 1/11 A69205 CHK: 099945 02502 PROGRAM 1/30 13060 40.00 280. ROBIN SCHAIBLE INV# 013017 /P01 1/17/17 1/11 A69206 CHK: 099946 02502 PROGRAM 2/6 13060 40.00 320. ROBIN SCHAIBLE INV# 020617 /P06 1/17/1.7 1/11 A69222 CHK: 099872 02502 PROGRAM 1/18 13683 40.00 ,360. DEBORAH CARRON INV# 011817 /20# 1/17/17 1/11 A69223 CHK: 099873 02502 PROGRAM 1/20 13683 40.00 400. DEBORAH CARRON INV# 012017 /201 1/17/17 1/11 A69224 CNK: 099874 02502 PROGRAM 1/25 13683 40.00 440. DEBORAH CARRON INV# 012517 /PO# 1/17/17 1/11 A69225 CHIS: 099875 02502 PROGRAM 7./27 13683 40.00 480. DEBORAH CARRON INV# 0127177 /P08 • 1/17/17 1/11 A69226 CHK: 099676 02502 PROGRAM 2/1 13683 40.00 520. DEBORAH CARRON INV# 020117 /204 3/17/17 1/11 A69227 CHK: 099877 02502 PROGRAM 2/3 13683 40.00 560. DEBORAH CARRON INV# 020317 /201 ___- _____= JANUARY ACTIVITY DB: 560.00 CR: 0.00 560.00 2-14-2017 1:29 PM DETAIL L I STI N G PAGE: 2 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Jan-2017 TORO Jan-2017 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: 0.00 0.00 REPORTED ACTIVITY: 2,316.25 0.00 ENDING BALANCES: 2,316.25 0.00 TOTAL FUND ENDING BALANCE: 2,316.25 2-14-2017 01:27 ?M CITY OF ELK RIVER PAGE: 1 REVENUE 6 EXPENSE RE?ORT (UNAUDITED) AS OF: JANUARY 31ST, 2017 211-LIBRARY FINANCIAL SUMMARY 06.33% OF YEAR COMP,. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 87,500.00 0.00 0.00 0.00 87,500.00 TOTAL REVENUES 87,500.00 0.00 0.00 0.00 87,500.00 EXPENDITURE SUMMARY Culture 6 Recreation Library 97,500.00 2,316.25 2,316.25 2.36 95,183.75 TOTAI. Culture 6 Recreation 97,500.00 2,316.25 2,316.25 2.38 95,183.75 TOTAL EXPENDITURES 97,500.00 2,316.25 2,316.25 2,38 95,183.75 REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)!. 2,316.25)1 2,316.25) t 7,683.75) 2-14-2017 01:27 PM CITY OF ELK RIVER PAGE: 2 REVENUE a EXPENSE REPORT (UNAUDITED) AS OF; JANUARY 3180, 2017 211-LIBRARY 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE S OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 53,650.00 0.00 0.00 0.00 53,650.00 TOTAL Taxes 53,650.00 0.00 0.00 0.00 53,650.00 Intergovernmental Rev - Charges for Services .. Other Revenue 211-3-0000-3621 Interest Income 5,500.00 0.00 0.00 0.00 5,500.00 TOTAL Other Revenue 5,500.00 0.00 0.00 0.00 5,500.00 Transfers In 211-3-0000-3595 Transfer-Utilities 28,350.00 0.00 0.00 0.00 28,350.00 TOTAL Transfers Tn 28,350.00 0.00 0.00 0.00 28,350.00 TOTAL Library 87,500.00 0.00 0.00 0.00 87,500.00 Library Project Other Financing Sources - --- Transfers In TOTAL REVENUE 87,500.00 0.00 0.00 0.00 87,500.00 2-14-2017 01:27 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2017 211-LIBRARY Culture s Recreation 08.338 OF YEAR COMP. Library CURRENT CURRENT YEAR TO DATE 9 OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 211-4-5600-4103 Part-time Pay 500.00 0.00 0.00 0.00 500.00 TOTAL Personal Services 500.00 0.00 0.00 0.00 500.00 Supplies 211-4-5600-4201 Office Supplies 100.00 0.00 0.00 0.00 100.00 211-4-5600-4219 Operating Supplies 9,650.00 0.00 0.00 0.00 9,650.00 TOTAL Supplies 9,750.00 0.00 0.00 0.00 9,750.00 Other Services & Charges 211-4-5600-4321 Telephone 1,100.00 0.00 0.00 0.00 1,100.00 211-4-5600-4331 Travel, Conferences & Schools 650.00 0.00 0.00 0.00 650.00 211-4-5600-4359 Publishing 1,500.00 0.00 0.00 0.00 . 1,500.00 211-4-5600-4361 Insurance 2,150.00 511.25 511.25 23.78 1,638.75 211-4-5600-4389 Utilities 29,450.00 0.00 0.00 0.00 29,450.00 211-4-5600-4401 Bldg Repair/Maint Services 16,050.00 0.00 0.00 0.00 16,050.00 21.1-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 0.00 0.00 250.00 211-4-5600-4405 Cleaning Services 15,000.00 1,245.00 1,245.00 8.30 13,755,00 211-4-5600-4409 Contractual Services 11,000.00 560.00 560.00 5.09 10,440.00 211-4-5600-4433 Dues & Subscriptions :00.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 77,250.00 2,316.25 2,316.25 3.00 74,933.75 Capital Outlay 211-4-5600-4560 Equipment 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL Capital Outlay 10,000.00 0.00 0.00 0.00 10,000.00 Transfers Out TOTAL Library 97,500.00 2,316.25 2,316.25 2.38 05,183.75 TOTAL Culture & Recreation 97,500.00 2,316.25 2,316.25 2.38 95,183.75 TOTAL EXPENDITURES 97,500.00 2,316.25 2,316.25 2.38 95,183.75 REVENUES OVER!(UNDER) EXPENDITURES ( 10,000.001( 2,316.25)1 2,316.25) ( 7,683.75) 3-08-2017 11:06 AM CITY OF ELK RIVER PAGE: _ BALANCE SHEET AS OF: FEBRUARY 26TH, 2017 211-LIBRARY iw,,,,,u ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 419,152.09 211-1380 Interest Receivable 1,838.00 420,990.09 TOTAL ASSETS 420,990.09 LIABILITIES 211-2200 Deposits Payable 400.00 TOTAL LIABILITIES 400.00 EQUITY 211-2400 Fund Balance 415,777.84 TOTAL BEGINNING EQUITY 415,777.84 TOTAL REVENUE 362.05 TOTAL EXPENSES 7,837.33 (WILL CLOSE TO FUND BAL.) 12,287.53 TOTAL REVENUE OVER/(UNDER) EXPENSES 4,812.25 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 420,590.09 TOTAL LIABILITIES, EQUITY b REV.OVER/(UNDER) EXP. 420,990.09 3-08-2017 11:08 AM DETAIL L IST I N G PAGE: 1 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USC: Feb-2017 THRU Feb-2017 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN if REFERENCE PACKET---===DESCRIPTION===... VEND INV/PO/JE # NOTE -----AMOUNT---- ----BALANCE=--= 4-5600-4219 Operating Supplies BEGINNING BALANCE 0.00 2/06/17 2/01 A70032 CNK: 100119 02531 SUPPLIES 15887 268.98 268.98 DACOTAH PAPER CO INV# 26766 /PO4 2/06/17 2/01 A70037 CHK: 1.00119 02531 SUPPLIES 15887 321.01 589.99 DACOTAH PAPER CO INV# 30363 /P0# 2/13/17 2/14 A70453 CHK: 100280 02545 BULK SALT 13048 51.10 641.09 STEP SAVER INC INV# 106831 /PO# 2/21/17 2/14 A70694 CHK: 100314 02548 SUPPLIES 15887 43.88 684.97 DACOTAH PAPER CO INV# 33583 /00# 2/23/17 2/23 A71524 CNK: 100681 02565 PARTS/SUPPLIES 251.45 9.94 694.91 MENARDS - ELK RIVER INV# 013117 /P0# -____ --_--= FEBRUARY ACTIVITY DB: 694.91 CR: 0.00 694.91. 4-5600-4321 Telephone BEGINNING BALANCE 0.00 2/13/17 2/14 A70421 CHN: 100286 02545 PHONE LINE CHGS 11102 92.67 92.67 WINDSTREAM INV# 010617 /80# ----_- FEBRUARY ACTIVITY DB: 92.67 CR: 0.00 92.67 4-5600-4389 Utilities BE GI NNING BALANCE 0.00 2/06/17 2/01 A70146 EFT: 000110 02531 JAN RUBBISH SVCS 30851 58.35 58.35 RANDY'S ENVIRONMENTAL SER INV# 135818-01/19/17 /PO6 2/15/17 2/14 A70476 EFT: 000112 02545 WATER/ELEC 17700 2,785.15 2,843.50 ELK RIVER MUNICIPAL UTILI INV# 011917 /PO# -_= FEBRUARY ACTIVITY DB: 2,843.50 CR: 0.00 2,843.50 4-5600-4401 Bldg Repair/Maint Services BEGINNING BALANCE 0.00 2/21/17 2/14 A70712 CHK: 100324 02548 EXTERIOR WINDOW CLNG 16448 205.00 205.00 DISTINCTIVE WINDOW CLEANI INV# 7922 /P0# ---- ____ _. FEBRUARY ACTIVITY DB: 205.00 CR: 0.00 205.00 4-5600-4405 Cleaning Services BEGINNING B A LAN C E 1,245.00 3-08-2017 11:08 AM DETAIL LISTING PAGE: 2 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Feb-2017 THRU Feb-2017 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET------DESCRIPTION------- VEND INV/PO/JE # NOTE ----=AMOUNT===- ----BALANCE.-,,,, 2/21/17 2/14 A70622 CHK: 100375 02548 FEB CLEANING SVCS 12651 1,245.00 2,490.00 PERFECTION PLUS, INC. INV'# 112759 /BOO -------__ __= FEBRUARY ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00 4-5600-4409 Contractual Services BEG INNI NG BALANCE 560.00 2/06/17 2/01 A69986 CHK: 100214 02531 PROGRAM 2/13 13060 40.00 600.00 ROBIN SCHAIBLE INV# 021317 /P0# 2/06/17 2/01 A70016 CHK: 100103 02531 PROGRAM 2/8 13683 40.00 640.00 DEBORAH CARRON INV# 020817 /1,04 2/06/17 2/01 A70017 CHK: 100104 02531 PROGRAM 2/10 13683 40.00 680.00 DEBORAH CARRON INV# 021017 /PO4 2/06/11 2/01 A70018 CHK: 100105 02531 PROGRAM 2/15 13683 40.00 720.00 DEBORAH CARRON INV# 021517 /PO8 2/06/17 2/01 A70019 CHK: 100106 02531 PROGRAM 2/17 13683 40.00 760.00 DEBORAH CARRON INV# 021717 /504 2/21/17 2/14 A70642 CHK: 100385 02548 PROGRAM 2/22 13060 40.00 800,00 ROBIN SCHAIBLE '..NV# 022217 /90# 2/21/17 2/14 A70643 CHK: 100386 02548 PROGRAM 2/24 13060 40.00 840.00 ROBIN SCHAIBLE INV# 022417 /90# 2/21/17 2/14 A70644 CHM: 100387 02548 PROGRAM 2/27 13060 40.00 880.00 ROBIN SCHAIBLE INV# 022717 /90# 2/21/17 2/14 A70645 CHK: 100388 02548 PROGRAM 3/1 13060 40.00 920.00 ROBIN SCHAIBLE. INV# 030117 /904 2/21/17 2/14 A70646 CHK: 100309 02548 PROGRAM 3/3 13060 40.00 960.00 ROBIN SCHAIBLE INV# 030317 /904 2/21/17 2/14 A70647 CHK: 100390 02548 PROGRAM 3/6 13060 40.00 1,000.00 ROBIN SCHAIBLE INV# 030617 /PO# -- FEBRUARY ACTIVITY DB: 440.00 CR: 0.00 440.00 000 ERRORS IN THIS REPORT! +-+-•_,_ _-_+_«___+_+_+_+_« ** REPORT TOTALS " --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 2,316.25 0.00 REPORTED ACTIVITY: 5,521.08 0.00 ENDING BALANCES: 7,837.33 0.00 TOTAL FUND ENDING BALANCE: 7,837.33 3-08-2017 11.;06 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2017 211-LIBRARY FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE 8 OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 87,500.00 0.00 362.05 0.41 87,137.95 TOTAL REVENUES 87,500.00 0.00 362.05 0.41 87,137.95 EXPENDITURE SUMMARY Culture & Recreation Library 97,500.00 5,521.08 7,837.33 8.04 89,662.67 TOTAL Culture & Recreation 97,500.00 9,521.08 7,837.33 8,04 89,662.67 TOTAL EXPENDITURES 97,500.00 5,521.08 7,837.33 8.04 89,662.67 '.. REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 5,521.08)) 7,475.28) ( 2,524.72) 3-08-2017 1106 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2017 .... 211-LIBRARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Library ------ Taxes 211-3-0000-3111 Current Ad Valorem Taxes 53,650.00 0.00 0.00 0.00 53,650.00 TOTAL Taxes 53,650.00 0.00 0.00 0.00 53,650.00 Intergovernmental Rev Charges for Services - — Other Revenue . 211-3-0000-3021 Interest Income 5,500.00 0.00 362.05 6.58 5,137.95 TOTAL Other Revenue 5,500.00 0.00 362.05 6.58 5,137.95 Transfers In 211-3-0000-3945 Transfer-Utilities 28,350.00 0.00 0.00 0.00 28,350.00 TOTAL Transfers In 28,350.00 0.00 0.00 0.00 28,350.00 TOTAL Library 67,500.00 0.00 362.05 0.41 67,137.95 Library Project -------.--- Other Financing Sources Transfers In TOTAL REVENUE 87,500.00 0.00 362.05 0.41 87,137..95 3-08-2017 1.1.:06 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2017 211.-LIBRARY Culture & Recreation 16.67% OF YEAR COMP, Library CURRENT CURRENT YEAR TO DATE & OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 211-4-5600-4103 Part-time Pay 500.00 0.00 0.00 0.00 500.00 TOTAL Personal Services 500.00 0.00 0.00 0.00 500.00 Supplies 211-4-5600-4201 Office Supplies 100.00 0.00 0.00 0.00 100.00 211-4-5600-4219 Operating Supplies 9,650.00 694.9.1. 694.91 7.20 8,955.09 TOTAL Supplies 9,750.00 694.91 694.91 7.13 9,055.09 Other Services & Charges 211-4-5600-4321 Telephone 1,100.00 92.67 92.67 8.42 1,007.33 21.1.-4-5600-4331 Travel, Conferences & Schools 650.00 0.00 0.00 0.00 650.00 211-4-5600-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500,00 211-4-5600-4361 Insurance 2,150.00 0.00 511.25 23.78 1,638.75 211-4-5600-4389 Utilities 29,450.00 2,843.50 2,843.50 9.66 26,606.50 211-4-5600-4401 Bldg Repair/Maint Services 16,050.00 205.00 205.00 1.28 15,845.00 211-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 0.00 0.00 250.00 211-4-5600-4405 Cleaning Services 15,000.00 1,245.00 2,490.00 16.60 12,510.00 211-4-5600-4409 Contractual Services 11,000.00 440.00 1,000.00 9.09 10,000.00 211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 77,250.00 4,826.17 7,142.42 9.25 70,107.58 Capital Outlay 211-4-5600-4560 Equipment 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL Capital Outlay 10,000.00 0.00 0.00 0.00 10,000.00 Transfers Out TOTAL Library 97,500.00 5,521.08 7,837.33 8.04 89,662.67 TOTAL Culture & Recreation 97,500.00 5,521.08 7,837.33 8.04 89,662.67 TOTAL EXPENDTTURES 97,500.00 5,52.1.00 7,837.33 8.04 89,662.67 REVENUES OVER/(UNDER) EXPENDITURES ( 10,000,0011 5,521.081( 7,475.28) 1 2,524.721