The URL can be used to link to this page

3.2. LIBSR 01-23-201810-06-2017 02:07 PM 211 -LIBRARY ACCOUNT # ACCOUNT DESCRIPTION ASSETS CITY OF ELK RIVER B ' - AS OF: SEPTEMBER 30TH, 2017 BALANCE PAGE: 1 211-1010 Cash - Library 434,405.28 211-1380 Interest Receivable 1,838.00 436,243.28 TOTAL ASSETS 436,243.28 LIABILITIES 211-2200 Deposits Payable 300.00 TOTAL LIABILITIES 300.00 EQUITY 211-2400 Fund Balance 428,065.37 TOTAL BEGINNING EQUITY 428,065.37 TOTAL REVENUE 61,551.06 TOTAL EXPENSES 53,673.15 TOTAL REVENUE OVER/(UNDER) EXPENSES 7,877.91 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 435,943.28 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 436,243.28 -------------- -------------- 10-06-2017 2:09 PM D E T A I L L I S T I N G 3,854.86 PAGE: 2 40.00 FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep -2017 THRU Sep -2017 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL CHK: 103230 POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== 9/18/17 9/13 A75067 CHK: 103187 02707 EXTERIOR WINDOW CLNG 16448 INV# 205.00 10,588.67 4,054.86 /PO# DISTINCTIVE WINDOW CLEANI INV# 9910 /PO# SEPTEMBER ACTIVITY DB: 1,245.00 CR: 9/18/17 9/13 A75131 CHK: 103252 02707 MOWING SVCS CONTRACT 11661 Services 428.46 11,017.13 4,134.86 /PO# SPEEDCUTTERS OUTDOOR MAIN INV# 4908 /PO# B E G I N N I N G B A L A N C E _______ SEPTEMBER ACTIVITY DB: 1,690.71 CR: 0.00 1,690.71 CHK: ------------------------------------------------------------------------------- 4-5600-4405 Cleaning Services 3,854.86 40.00 3,894.86 /PO# B E G I N N I N G B A L A N C E 3,934.86 9/18/17 9/13 A75109 CHK: 103230 02707 SEPT CLEANING SVCS /PO# 12651 40.00 4,014.86 /PO# PERFECTION PLUS, INC. INV# 1128218 40.00 4,054.86 /PO# ------------- SEPTEMBER ACTIVITY DB: 1,245.00 CR: ------------------------------------------------------------------------------- 4-5600-4409 /PO# Contractual Services 40.00 4,134.86 /PO# B E G I N N I N G B A L A N C E /PO# 9/05/17 8/30 A74884 CHK: 103067 02698 PROGRAM 9/6 13060 0.00 360.00 ROBIN SCHAIBLE INV# 090617 9/05/17 8/30 A74885 CHK: 103068 02698 PROGRAM 9/8 13D60 ROBIN SCHAIBLE INV# 090817 9/05/17 8/30 A74886 CHK: 103069 02698 PROGRAM 9/11 13060 ROBIN SCHAIBLE INV# 091117 9/05/17 8/30 A74887 CHK: 103070 02698 PROGRAM 9/13 13060 ROBIN SCHAIBLE INV# 091317 9/05/17 8/30 A74888 CHK: 103071 02698 PROGRAM 9/18 13060 ROBIN SCHAIBLE INV# 091817 9/18/17 9/13 A75117 CHK: 103238 02707 PROGRAM 9/20 13060 ROBIN SCHAIBLE INV# 092017 9/18/17 9/13 A75118 CHK: 103239 02707 PROGRAM 9/25 13060 ROBIN SCHAIBLE INV# 092517 9/18/17 9/13 A75119 CHK: 103240 02707 PROGRAM 9/27 13060 ROBIN SCHAIBLE INV# 092717 9/18/17 9/13 A75120 CHK: 103241 02707 PROGRAM 10/2 13060 ROBIN SCHAIBLE INV# 100217 ------------= SEPTEMBER ACTIVITY DB: 360.00 CR: 9,960.00 1,245.00 11,205.00 /PO# 0.00 1,245.00 3,854.86 40.00 3,894.86 /PO# 40.00 3,934.86 /PO# 40.00 3,974.86 /PO# 40.00 4,014.86 /PO# 40.00 4,054.86 /PO# 40.00 4,094.86 /PO# 40.00 4,134.86 /PO# 40.00 4,174.86 /PO# 40.00 4,214.86 /PO# 0.00 360.00 10-06-2017 2:09 PM D E T A I L L I S T I N G PAGE: 1 FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep -2017 THRU Sep -2017 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,560.63 9/05/17 8/30 A74901 CHK: 103084 02698 BRINE TANK SUPPLIES 13048 1,100.91 4,661.54 STEP SAVER INC INV# 112292 /PO# 9/18/17 9/13 A75098 CHK: 103219 02707 PARTS/SUPPLIES 25145 11.35 4,672.89 MENARDS - ELK RIVER INV# 083117 /PO# SEPTEMBER ACTIVITY DB: 1,112.26 CR: 0.00 1,112.26 --------------------------------------------------------------------------------------------------- 4-5600-4321 Telephone BEG INNI NG BALANCE 733.22 9/25/17 9/25 A75230 CHK: 103305 02716 PHONE LINE CHGS 11102 91.33 824.55 WINDSTREAM INV# 090717 /PO# SEPTEMBER ACTIVITY DB: 91.33 CR: 0.00 91.33 ----------------------------------------------------------------------------------------------------- 4-5600-4361 Insurance B E G I N N I N G B A L A N C E 1,752.50 9/18/17 9/13 A75089 CHK: 103209 02707 INSURANCE ALLOCATION 23805 730.00 2,482.50 LEAGUE OF MN CITIES INS T INV# 090517 /PO# SEPTEMBER ACTIVITY DB: 730.00 CR: 0.00 730.00 ------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 16,948.79 9/06/17 8/30 A74758 EFT: 000209 02701 AUG RUBBISH SVCS 30851 58.35 17,007.14 RANDY'S ENVIRONMENTAL SER INV# 135818-081817 /PO# 9/15/17 9/13 A75019 EFT: 000215 02708 WATER/ELEC 17700 2,089.83 19,096.97 ELK RIVER MUNICIPAL UTILI INV# 082217 /PO# SEPTEMBER ACTIVITY DB: 2,148.18 CR: 0.00 2,148.18 ------------------------------------------------------------------------------------------------------- 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 9,326.42 9/05/17 8/30 A74820 CHK: 103003 02698 BRINE TANK REPAIRS 18647 120.00 9,446.42 FINKEN'S WATER CENTERS INV# CS01234 /PO# 9/05/17 8/30 A74835 CHK: 103018 02698 IRRIGATION REPAIRS 10107 440.25 9,886.67 GREAT NORTHERN LANDSCAPES INV# 12166 /PO# 9/18/17 9/13 A75057 CHK: 103177 02707 HVAC -HUMIDITY SENSOR 13024 497.00 10,383.67 CORPORATE MECHANICAL INC INV# W17880 /PO# 10-06-2017 2:09 PM D E T A I L L I S T I N G FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY-,-- PERIOD TO USE: PAGE: 2 Sep -2017 THRU Sep -2017 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE IRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NO.TE- 9/18/17 9/13 A75067 CHK: 103187 02707 EXTERIOR WINDOW CLNG 16448 205.00 10,586.6- DISTINCTIVE WINDOW CLEANI INV# 9910 /PO# 9/18/17 9/13 A75131 CHK: 103252 02707 MOWING SVCS CONTRACT 11661 428.46 11,017.13 SPEEDCUTTERS OUTDOOR MAIN INV# 4908 /PO# SEPTEMBER ACTIVITY DB: 1,690.71 CR: 0.00 1,690.71 --------------------------------------------------------------------------- 4-5600-9905 Cleaning Services B E G I N N I N G B A L A N C E 9,960.00 9/18/17 9/13 A75109 CHK: 103230 02707 SEPT CLEANING SVCS 12651 1,245.00 11,205.00 PERFECTION PLUS, INC. INV# 1128218 /PO# SEPTEMBER ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00 4-5600-4409, Contractual ------------------------------------------------------------------------ Services B E G I N N I N G B A L A N C E 3,854.86 9/05/17 8/30 A74884 CHK: 103067 02698 PROGRAM 9/6 13060 40.00 3,894.86 ROBIN SCHAIBLE INV# 090617 /PO# 9/05/17 8/30 A74885 CHK: 103068 02698 PROGRAM 9/8 13060 40.00 3,934.86 ROBIN SCHAIBLE INV# 090817 /PO# 9/05/17 8/30 A74886 CHK: 103069 02698 PROGRAM 9/11 13060 40.00 3,979.86 ROBIN SCHAIBLE INV# 091117 /PO# 9/05/17 8/30 A74887 CHK: 103070 02698 PROGRAM 9/13 13060 40.00 4,014.86 ROBIN SCHAIBLE INV# 091317 /PO# 9/05/17 8/30 A74888 CHK: 103071 02698 PROGRAM 9/18 13060 40.00 9,054.86 ROBIN SCHAIBLE INV# 091817 /PO# 9/18/17 9/13 A75117 CHK: 103238 02707 PROGRAM 9/20 13060 40.00 4,094.86 ROBIN SCHAIBLE INV# 092017 /PO# 9/18/17 9/13 A75118 CHK: 103239 02707 PROGRAM 9/25 13060 90.00 9,139.86 ROBIN SCHAIBLE INV# 092517 /PO# 9/18/17 9/13 A75119 CHK: 103240 02707 PROGRAM 9/27 13060 40.00 4,174.86 ROBIN SCHAIBLE INV# 092717 /PO# 9/18/17 9/13 A75120 CHK: 103241 02707 PROGRAM 10/2 13060 40.00 4,214.86 ROBIN SCHAIBLE INV# 100217 /PO# SEPTEMBER ACTIVITY DB: 360.00 CR: 0.00 360.00 10-06-2017 2:09 PM D E T A I L L I S T I N G PAGE: 3 FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep -2017 THRU Sep -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: 46,136.42 0.00 REPORTED ACTIVITY: 7,377.48 0.00 ENDING BALANCES: 53,513.90 0.00 TOTAL FUND ENDING BALANCE: 53,513.90 10-06-2017 02:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2017 _ 211 -LIBRARY FINANCIAL SUMMARY 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 87,500.00 0.00 61,551.06 70.34 25,948.94 87,500.00 0.00 61,551.06 70.34 25,948.94 97,500.00 7,377.48 53,673.15 55.05 43,826.85 97,500.00 7,377.48 53,673.15 55.05 43,826.85 97,500.00 7,377.48 53,673.15 55.05 43,826.85 ( 10,000.00)( 7,377.48) 7,877.91 ( 17,877.91) 10-06-2017 02:08 PM REVENUE 211 -LIBRARY REVENUES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2017 CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ACTUAL 75.00% % OF BUDGET PAGE: 2 OF YEAR COUP. BUDGET BALANCE Library Taxes 211-3-0000-31!1 Current Ad Valorem Taxes 53,650.00 0.00 27,718.31 51.67 25,931.69 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 ( 95.11) 0.00 95.11 TOTAL Taxes 53,650.00 0.00 27,623.20 51.49 26,026.80 Intergovernmental Rev Charges for Services Other Revenue 211-3-0000-3621 Interest Income 5,500.00 0.00 5,577.86 101.42 ( 77.86) TOTAL Other Revenue 5,500.00 0.00 5,577.86 101.42 ( 77.86) 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 87,500.00 0.00 61,551.06 70.34 25,948.94 Library Project --------------- --------------- Other Financing Sources Transfers In TOTAL REVENUE 87,500.00 0.00 61,551.06 70.34 25,948.94 10-06-2017 02:08 PM CITY OF ELK RIVER PAGE• 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2017 211 -LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services 211-4-5600-4103 Part-time Pay TOTAL 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-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 211-4-5600-4560 Equipment TOTAL Capital Outlay Transfers Out 75.00% OF YEAR COMP.' CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 500.00 0.00 159.25 31.85 340.75 500.00 0.00 159.25 31.85 34C.75 100.00 0.00 0.00 0.00 100.00 9,650.00 1,112.26 4,672.89 48.42 4,977.11 9,750.00 1,112.26 4,672.89 47.93 5,077.11 1,100.00 91.33 824.55 74.96 275.45 650.00 0.00 0.00 0.00 650.00 1,500.00 0.00 0.00 0.00 1,500.00 2,150.00 730.00 2,482.50 115.47 ( 332.50) 29,450.00 2,148.18 19,096.97 64.85 10,353.03 16,050.00 1,690.71 11,017.13 68.64 5,032.87 250.00 0.00 0.00 0.00 250.00 15,000.00 1,245.00 11,205.00 74.70 3,795.00 11,000.00 360.00 4,214.86 38.32 6,785.14 100.00 0.00 0.00 0.00 100.00 77,250.00 6,265.22 48,841.01 63.22 28,408.99 10,000.00 0.00 0.00 0.00 10,000.00 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL Library 97,500.00 7,377.46 53,673.15 55.05 43,826.85 TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 97,500.00 7.377.48 53.673.15 95_n5 Al P99 ae 97,500.00 7,377.48 53,673.15 55.05 43,826.85 ( 10,000.00)( 7,377.48) 7,877.91 ( 17,877.91) 11-08-2017 09:20 AM 211 -LIBRARY ACCOUNT # ACCOUNT DESCRIPTION CITY OF ELK RIVER ❑ T OLAS F:: OCTOBER 31ST, 2017 BALANCE PAGE: 1 ASSETS 211-1010 Cash - Library 420,396.74 211-1380 Interest Receivable 1,838.00 422,234.74 TOTAL ASSETS 422,234 74 LIABILITIES -------------- -------------- 211-2200 Deposits Payable 400.00 TOTAL LIABILITIES 400.00 EQUITY 211-2400 Fund Balance 428,065.37 TOTAL BEGINNING EQUITY 428,065.37 TOTAL REVENUE 61,927.85 TOTAL EXPENSES 68,158.48 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 6,230.63) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 421,834.74 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 422,234.74 -------------- -------------- 11-08-2017 9:22 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: Oct -2017 THRU Oct -2017 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 4,672.89 10/16/17 10/11 A75523 CHK: 103499 02727 SUPPLIES 15887 186.52 4,859.41 DACOTAH PAPER CO INV# 78368 /PO# 10/16/17 10/11 A75523 CHK: 103499 02727 SUPPLIES 15887 88.72 4,948.13 DACOTAH PAPER CO INV# 78848 /PO# 10/16/17 10/11 A75608 CHK: 103584 02727 BULK SALT 13048 126.00 5,074.13 STEP SAVER INC INV# 112418A /PO# OCTOBER ACTIVITY DB: 401.24 CR: 0.00 401.24 ------------------------------`----------------------------------------------------------------------------------------------------- 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 19, 096.97 10/03/17 9/27 A75397 EFT: 000228 02722 SEPT RUBBISH SVCS 30851 58.35 19,155.32 RANDY'S ENVIRONMENTAL SER INV# 135818-091917 /PO# 10/13/17 10/11 A75643 EFT: 000237 02731 WATER/ELEC 17700 1,972.86 21,128.18 ELK RIVER MUNICIPAL UTILI INV# 092017 /PO# OCTOBER ACTIVITY DB: 2,031.21 CR: 0.00 2,031.21 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services BEG I NN I NG B A L A N C E 11,017.13 10/02/17 9/27 A75277 CHK: 103334 02717 HVAC REP -HUMIDITY SENSOR 13024 452.20 11,469.33 CORPORATE MECHANICAL INC INV# W18338 /PO# 10/16/17 10/11 A75606 CHK: 103582 02727 MOWING SVCS CONTRACT 11661 428.46 11,897.79 SPEEDCUTTERS OUTDOOR MAIN INV# 4959 /PO# 10/16/17 10/11 A75627 CHK: 103603 02727 SECURITY MONITORING 36602 605.28 12,503.07 WRIGHT-HENNEPIN COOP ELEC INV# 092717 /PO# OCTOBER ACTIVITY DB: 1,485.94 CR: 0.00 1,485.94 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 11,205.00 10/16/17 10/11 A75577 CHK: 103553 02727 OCT CLEANING SVCS 12651 1,245.00 12,450.00 PERFECTION PLUS, INC. INV# 1128271 /PO# OCTOBER ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4409 Contractual Services BEG I NN I NG BALANCE 4,214.86 11-08-2017 9:22 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: Oct -2017 THRU Oct -2017 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE = AMOUNT=- -BALANCE=== 10/02/17 9/27 A75340 CHK: 103397 02717 PROGRAM 10/4 13060 40.00 4,254.86 ROBIN SCHAIBLE INV# 100417 /PO# 10/02/17 9/27 A75341 CHK: 103398 02717 PROGRAM 10/6 13060 40.00 4,294.86 ROBIN SCHAIBLE INV# 100617 /PO# 10/02/17 9/27 A75342 CHK: 103399 02717 PROGRAM 10/11 13060 40.00 4,334.86 ROBIN SCHAIBLE INV# 101117 /PO# 10/02/17 9/27 A75343 CHK: 103400 02717 PROGRAM 10/16 13060 40.00 4,374.86 ROBIN SCHAIBLE INV# 101617 /PO# 10/10/17 10/09 A75470 CHK: 103454 02729 SERVICE CALL 18647 120.00 4,494.86 FINKEN'S WATER CENTERS INV# CS01277 /PO# 10/16/17 10/11 A75591 CHK: 103567 02727 REIMS SUPPLIES 13060 108.78 4,603.64 ROBIN SCHAIBLE INV# 10162017 /PO# 10/16/17 10/11 A75592 CHK: 103568 02727 PROGRAM 10/18 13060 40.00 4,643.64 ROBIN SCHAIBLE INV# 101817 /PO# 10/16/17 10/11 A75593 CHK: 103569 02727 PROGRAM 10/23 13060 40.00 4,683.64 ROBIN SCHAIBLE INV# 102317 /PO# 10/16/17 10/11 A75594 CHK: 103570 02727 PROGRAM 10/25 13060 40.00 4,723.64 ROBIN SCHAIBLE INV# 102517 /PO# 10/16/17 10/11 A75595 CHK: 103571 02727 PROGRAM 10/30 13060 40.00 4,763.64 ROBIN SCHAIBLE INV# 103017 /PO# 10/16/17 10/11 A75596 CHK: 103572 02727 PROGRAM 11/1 13060 40.00 4,803.64 ROBIN SCHAIBLE INV# 110117 /PO# 10/16/17 10/11 A75597 CHK: 103573 02727 PROGRAM 11/3 13060 40.00 4,843.64 ROBIN SCHAIBLE INV# 110317 /PO# 10/16/17 10/11 A75598 CHK: 103574 02727 PROGRAM 11/6 13060 40.00 4,883.64 ROBIN SCHAIBLE INV# 110617 /PO# 10/19/17 10/19 A75745 CHK: 103671 02733 CURBING - B4 STYLE 31907 ' 8,584.00 13,467.64 SCHMIDT CURB CO., INC INV# 17-47C /PO# ------------= OCTOBER ACTIVITY DB: 9,252.78 CR: 0.00 9,252.78 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 53,583.06 0.00 REPORTED ACTIVITY: 14,416.17 0.00 ENDING BALANCES: 67,999.23 0.00 TOTAL FUND ENDING BALANCE: 67,999.23 11-08-2017 09:21 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 211 -LIBRARY FINANCIAL SUMMARY REVENUE SUY14ARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 87,500.00 0.00 87,500.00 0.00 61,927.85 70.77 25,572.15 61,927.85 70.77 25,572.15 97,500.00 14,416.17 68,158.48 69.91 29,34.52 97,500.00 14,416.17 68,158.48 69.91 29,341.52 97,500.00 14,416.17 68,158.48 69.91 29,341.52 ( 101000.00)( 14,416.17)( 6,230.63) ( 3,769.37) 11-08-2017 09:21 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 211 -LIBRARY 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Library Taxes 27,718.31 211-3-0000-3111 Current Ad Valorem Taxes 53,650.00 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 TOTAL Taxes 53,650.00 Intergovernmental Rev 27,623.20 Charges for Services 26,026.80 Other Revenue 211-3-0000-3621 Interest Income 5,500.00 TOTAL Other Revenue 5,500.00 Transfers In 454.65) 211-3-0000-3945 Transfer -Utilities 28,350.00 TOTAL Transfers In 28,350.00 TOTAL Library 87,500.00 Library Project --------------- --------------- Other Financing Sources Transfers In 0.00 27,718.31 51.67 25,931.69 0.00 ( 95.11) 0.00 95.11 0.00 27,623.20 51.49 26,026.80 0.00 108.27 ( 5,954.65 454.65) 0.00 5,954.65 108.27 ( 454.65) 0.00 28,350.00 100.00 0.00 0.00 28,350.00 100.00 0.00 0.00 61,927.85 70.77 25,572.15 TOTAL REVENUE 87,500.00 0.00 61,927.85 70.77 25,572.15 11-08-2017 09:21 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2017 211 -LIBRARY Culture & Recreation Library DEPARTMF:NTAT. EXPPNil7Ti7RRq Personal Services 211-4-5600-4103 Part-time Pay TOTAL Personal Services Supplies 211-4-5600-4201 Office Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Other Services & Charges 211-4-5600-4319 Other Professional Services 211-4-5600-4321 Telephone 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 211-4-5600-4560 Equipment TOTAL Capital Outlay Transfers Out 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE - OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 500.00 0.00 159.25 31.85 340.75 500.00 0.00 159.25 31.85 340.75 100.00 0.00 0.00 0.00 100.00 9,650.00 401.24 5,074.13 52.58 4,575.87 9,750.00 401.24 5,074.13 52.04 4,675.87 0.00 0.00 69.16 0.00 ( 69.16) 1,100.00 0.00 824.55 74.96 275.45 650.00 0.00 0.00 0.00 65C.00 1,500.00 0.00 0.00 0.00 1,500.00 2,150.00 0.00 2,482.50 115.47 ( 332.50) 29,450.00 2,031.21 21,128.18 71.74 8,321.82 16,050.00 1,485.94 12,503.07 77.90 3,546.93 250.00 0.00 0.00 0.00 250.00 15,000.00 1,245.00 12,450.00 83.00 2,550.00 11,000.00 9,252.78 13,467.64 122.43 ( 2,467.64) 100.00 0.00 0.00 0.00 100.00 77,250.00 14,014.93 62,925.10 81.46 14,324.90 10,000.00 0.00 0.00 0.00 10,000.00 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL Library 97,500.00 14,416.17 68,158,48 69.91 29,341.52 TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 97,500.00 14,416.17 68,158.48 69.91 29,341.52 97,500.00 14,416.17 68,158.48 69.91 29,341.52 ( 10,000.00)( 14,416.17)( 6,230.63) ( 3,769.37) 12-07-2017 12:14 PM 211 -LIBRARY ACCOUNT # ACCOUNT DESCRIPTION CITY OF ELK RIVER :CE SHEET AS OF: NOVEMBER 30TH, 2017 BALANCE ASSETS 211-1010 Cash - Library 415,714.78 211-1380 Interest Receivable 1,838.00 417,552.78 PAGE: 1 TOTAL ASSETS 417,552.78 -------------- LIABILITIES 211-2200 Deposits Payable 500.00 TOTAL LIABILITIES 500.00 EQUITY 211-2400 Fund Balance 428,065.37 TOTAL BEGINNING EQUITY 428,065.37 TOTAL REVENUE 62,297.44 TOTAL EXPENSES 73,310.03 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 11,012.59) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 417,052.78 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 417,552.78 -------------- 12-07-2017 12:16 PM D E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Nov-2017 THRU Nov-2017 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 5,074.13 11/06/17 11/02 A75951 CHK: 103829 02734 BULK SALT 13048 147.00 5,221.13 STEP SAVER INC INV# 113407B /PO# _______ NOVEMBER ACTIVITY DB: 147.00 CR: 0.00 147.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4321 Telephone BEG I NN I NG I B A L A N C E 824.55 11/06/17 11/02 A75970 CHK: 103848 02734 PHONE LINE CHGS 11102 92.00 916.55 WINDSTREAM INV# 100617 /PO# ------------- NOVEMBER ACTIVITY DB: 92.00 CR: 0.00 92.00 ---------------------------------------------------------------------------------- 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 11/07/17 11/02 A75995 EFT: 000259 02741 OCT RUBBISH SVCS 30851 RANDY'S ENVIRONMENTAL SER INV# 135818-101917 11/15/17 11/13 A76023 EFT: 000265 02746 WATER/ELEC 17700 ELK RIVER MUNICIPAL UTILI INV# 102117 NOVEMBER ACTIVITY DB: 2,274.09 CR: ---------------------------------------------------------------------------------- 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 11/06/17 11/02 A75849 CHK: 103727 02734 REM WIRES -PEDESTAL LIGHT 10373 AID ELECTRIC CORPORATION INV# 53709 11/06/17 11/02 A75874 CHK: 103752 02734 PEST CONTROL 15191 COUNTRY SIDE PEST CONTROL INV# 9422 11/06/17 11/02 A75948 CHK: 103826 02734 MOWING SVCS CONTRACT 11661 SPEEDCUTTERS OUTDOOR MAIN INV# 5005 11/06/17 11/02 A75953 CHK: 103831 02734 FIRE SPRINKLER INSP 33444 SUMMIT COMPANIES INV# 1217957 11/06/17 11/02 A75953 CHK: 103831 02734 FIRE ALARM INSP 33444 SUMMIT COMPANIES INV# 1218571 ------------= NOVEMBER ACTIVITY DB: 1,033.46 CR: ------------------------------------------------------------------- 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E /PO# /PO# 0.00 /PO# /PO# /PO# /PO# /PO# 0.00 58.35 2,215.74 2,274.09 115.00 75.00 428.46 190.00 225.00 1,033.46 21,128.18 21,186.53 23,402.27 21,207.07 21,322.07 21,397.07 21,825.53 22,015.53 22,240.53 12,450.00 12-07-2017 12:16 PM D E T A I L L I S T I N G PAGE: 2 FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Nov -2017 THRU Nov -2017 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =AMOUNT=== —BALANCE=== 11/20/17 11/16 A76183 CHK: 103997 02744 NOV CLEANING SVCS 12651 1,245.00 13,695.80 PERFECTION PLUS, INC. INV# 1128321 /PO# NOVEMBER ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4409 Contractual Services BEG I N N I NG BALANCE 4,763.64 11/06/17 11/02 A75937 CHK: 103815 02734 PROGRAM 11/8 13060 40.00 4,803.64 ROBIN SCHAIBLE INV# 110817 /PO# 11/06/17 11/02 A75938 CHK: 103816 02734 PROGRAM 11/13 13060 46.00 4,843.64 ROBIN SCHAIBLE INV# 111317 /PO# 11/06/17 11/02 A75939 CHK: 103817 02734 PROGRAM 11/15 13060 40.00 4,883.64 ROBIN SCHAIBLE INV# 111517 /PO# 11/06/17 11/02 A75940 CHK: 103818 02734 PROGRAM 11/20 13060 40.00 4,923.64 ROBIN SCHAIBLE INV# 112017 /PO# 11/20/17 11116 A76194 CHK: 104008 02744 PROGRAM 11/22 13060 40.00 4,963.64 ROBIN SCHAIBLE INV# 112217 /PO# 11/20/17 11/16 A76195 CHK: 104009 02744 PROGRAM 11/27 13060 40.00 5,003.64 ROBIN SCHAIBLE INV# 112717 /PO# 11/20/17 11/16 A76196 CHK: 104010 02744 PROGRAM 11/29 13060 40.00 5,043.64 ROBIN SCHAIBLE INV# 112917 /PO# 11/20/17 11/16 A76197 CHK: 104011 02744 PROGRAM 12/1 13060 40.00 5,083.64 ROBIN SCHAIBLE INV# 120117 /PO# 11/20/17 11/16 A76198 CHK: 104012 02744 PROGRAM 12/4 13060 40.00 5,123.64 ROBIN SCHAIBLE INV# 120417 /PO# ------------= NOVEMBER ACTIVITY DB: 360.00 CR: 0.00 360.00 *-'-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 67,999.23 0.00 REPORTED ACTIVITY: 5,151.55 0.00 ENDING BALANCES: 73,150.78 0.00 TOTAL FUND ENDING BALANCE: 73,150.78 12-07-2017 12:14 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 211 -LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 91.67% OF YEAR COMP, CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 87,500.00 0.00 62,297.44 71.20 87,500.00 0.00 62,297.44 71.20 25,202.56 25,202.56 97,500.00 5,151.55 73,310.03 75.19 24,189.97 97,500.00 5,151.55 73,310.03 75.19 24,189.97 97,500.00 5,151.55 73,310.03 75.19 24,189.97 ( 10,000.00)( 5,151.55)( 11,012.59) 1,012.59 12-07-2017 12:14 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 211 -LIBRARY 91.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 27,718.31 51.67 25,931.69 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 ( 95.11) 0.00 95.11 TOTAL Taxes 53,650.00 0.00 27,623.20 51.49 26,026.80 Intergovernmental Rev Charges for Services Other Revenue 211-3-0000-3621 Interest Income 5,500.00 0.00 6,324.24 114.99 ( 824.24) TOTAL Other Revenue 5,500.00 0.00 6,324.24 114.99 ( 824.24) 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 87,500.00 0.00 62,297.44 71.20 25,202.56 Library Project --------------- Other Financing Sources Transfers In TOTAL REVENUE 87,500.00 0.00 62,297.44 71.20 25,202.56 12-07-2017 12:14 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2017 211 -LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 211-4-5600-4103 Part-time Pay 500.00 0.00 159.25 31.85 340.75 TOTAL Personal Services 500.00 0.00 159.25 31.85 340.75 Supplies 211-4-5600-4201 Office Supplies 100.00 0.00 0.00 0.00 10C.00 211-4-5600-4219 Operating Supplies 9,650.00 147.00 5,221.13 54.10 4,428.87 TOTAL Supplies 9,750.00 147.00 5,221.13 53.55 4,528.87 Other Services & Charges 211-4-5600-4319 Other Professional Services 0.00 0.00 69.16 0.00 ( 69.16) 211-4-5600-4321 Telephone 1,100.00 92.00 916.55 83.32 183.45 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 0.00 2,482.50 115.47 ( 332.50) 211-4-5600-4389 Utilities 29,450.00 2,274.09 23,402.27 79.46 6,047.73 211-4-5600-4401 Bldg Repair/Maint Services 16,050.00 1,033.46 22,240.53 138.57 ( 6,190.53) 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 13,695.00 91.30 1,305.00 211-4-5600-4409 Contractual Services 11,000.00 360.00 5,123.64 46.58 5,876.36 211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 77,250.00 5,004.55 67,929.65 87.93 9,320.35 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,151.55 73,310.03 75.19 24,189.97 TOTAL Culture & Recreation 97,500.00 5,151.55 73,310.03 75.19 24,189.97 TOTAL EXPENDITURES 97,500.00 5,151.55 73,310.03 75.19 24,189.97 REVENUES OVER/(UNDER) EXPENDITURES ( 101000.00)( 5,151.55)( 11,012.59) 1,012.59