Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3.2. LIBSR 11-27-2018
10-09-2018 12:13 PM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: SEPTEMBER 30TH, 2018 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 426,012.74 211-1380 Interest Receivable 2,086.00 428,098.74 TOTAL ASSETS 428,098.74 a LIABILITIES 211-2200 Deposits Payable 200.00 TOTAL LIABILITIES 200.00 EQUITY 211-2400 Fund Balance 437,086.72 TOTAL BEGINNING EQUITY 437,086.72 TOTAL REVENUE 64,072.97 TOTAL EXPENSES 73,260.95 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 9,187.98) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 427,898.74 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 428,098.74 10-09-2018 12:15 PM DETAIL LISTING PAGE: 1 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep-2018 THRU Sep-2018 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAM # REFERENCE PACKET==== DESCRIPTION.----= VEND INV/PO/JE # NOTE =====AMOUhiT==== ====BALANCE==== 4-5600-4219 Operating Supplies BEGINNING BALANCE 5,856.09 9/04/18 8/29 A82672 CHK: 107577 02979 BULK SALT 13048 154.00 6,010.09 STEP SAVER INC INV# 121018E /PO# 9/17/18 9/13 A82825 CHN: 107667 02990 SUPPLIES 15887 331.13 6,341.22 DACOTAH PAPER CO INV# 17590 JPO# == SEPTEMBER ACTIVITY DB: 485.13 CR: 0.00 485.13 4-5600-4361 Insurance BEGINNING BALANCE 1,460,00 9/17/18 9/13 A82864 CHK: 107706 02990 INSURANCE ALLOCATION 23805 1,302.00 2,762.00 LEAGUE OF MN CITIES INS T INV# 40001014.3-2018 /PO# ------------- SEPTEMBER ACTIVITY DB: 1,302.00 CR: 0.00 1,302.00 4-5600-4389 Utilities BEGINNING BALANCE 21,053.99 9/05/18 8/29 A82722 EFT: 000429 02985 AUG RUBBISH SVCS 30851 58.35 21,112.34 RANDY'S ENVIRONMENTAL SEA INV# 135818-081718 /PO# ____=__-== = SEPTEMBER ACTIVITY DB: 58.35 CR: 0.00 58.35 4-5600-4401 Bldg Repair/Maint Services BEGINNING BALANCE 5,788.22 9/04/18 8/29 A82593 CHK: 107498 02979 EXTERIOR WINDOW CLNG 16448 205.00 5,993.22 DISTINCTIVE WINDOW CLEANI INV# 12987 /PO# 9/17/18 9/13 A82910 CNN: 107752 02990 MOWING SVCS CONTRACT 11661 428.46 6,421.68 SPEEDCUTTERS OUTDOOR MAIN INV# 10841 /PO# ============ SEPTEMBER ACTIVITY DB: 633.46 CR: 0.00 633.46 4-5600-4409 Contractual Services BEGINNING BALANCE 11,284.43 9/04/18 8/29 A82656 CHK: 107561 02979 PROGRAM 9/10 13060 40.00 11,324.43 ROBIN SCHAIBLE INV# 091018 /PO# 9/04/18 8/29 A82657 CHK: 107562 02979 PROGRAM 9/17 13060 40.00 11,364.43 ROBIN SCHAIBLE INV# 091718 /PO# 9/17/18 9/13 A82901 CHK: 107743 02990 PROGRAM 9/24 13060 40.00 11,404.43 ROBIN SCHAIBLE INV# 092418 /PO# 10-09-2018 12:15 PM DETAIL L I STING PAGE: 2 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep-2018 THRU Sep-2018 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAM # REFERENCE PACKET=—===DESCRIPTION===-- VEND INV/PO/JE # NOTE ====AMOUNT=—= ==BALANCE =x 9/17/18 9/13 A82902 CHK: 107744 02990 PROGRAM 10/1 13060 40.00 11,444.43 ROBIN SCHAIBLE INV# 100118 /P01 -__ - SEPTEMBER ACTIVITY DB: 160.00 CR: 0.00 160.00 4-5600-4560 Equipment BEGINNING BALANCE 5,025.91 9/17/18 9/13 A82835 CHK: 107677 02990 PARKING LOT EXTERIOR LTG 17890 1,559.34 6,585.25 ELK RIVER WINLECTRIC INV# 27996301 /PO# 9/17/18 9/13 A82835 CHK: 107677 02990 PARKING LOT EXTERIOR LTG 17890 4,164.23 10,749.48 ELK RIVER WINLECTRIC INV# 27996302 /PO# ===_= SEPTEMBER ACTIVITY DB: 5,723.57 CR: 0.00 5,723.57 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 64,898.44 0.00 REPORTED ACTIVITY: 8,362.51 0.00 ENDING BALANCES: 73,260.95 0.00 TOTAL FUND ENDING BALANCE: 73,260.95 10-09-2018 12:14 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 211-LIBRARY FINANCIAL SUMMARY 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 88,850.00 0.00 64,072.97 72.11 24,777.03 TOTAL REVENUES 88,850.00 0.00 64,072.97 72.11 24,777.03 EXPENDITURE SUMMARY Culture & Recreation Library 118,850.00 8,362.51 73,260.95 61.64 45,589.05 TOTAL Culture & Recreation 118,850.00 8,362.51 73,260.95 61.64 45,589.05 TOTAL EXPENDITURES 118,850.00 8,362.51 73,260.95 61.64 45,589.05 REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00) ( 8,362.51) ( 9,187.98) ( 20,812.02) 10-09-2018 12:14 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TN, 2018 211-LIBRARY 75.00% 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 54,000.00 0.00 28,318.11 52.44 25,681.89 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 158.48 0.00 ( 158.48) TOTAL Taxes 54,000.00 0.00 28,476.59 52.73 25,523.41 Intergovernmental Rev Charges for Services Other Revenue 211-3-0000-3621 Interest Income 6,500.00 0.00 6,496.38 99.94 3.62 211-3-0000-3629 Miscellaneous Revenue 0.00 0.00 750.00 0.00 ( 750.00) TOTAL Other Revenue 6,500.00 0.00 7,246.38 111.48 ( 746.38) 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 88,850.00 0.00 64,072.97 72.11 24,777.03 Library Project Other Financing Sources Transfers in TOTAL REVENUE 88,850.00 0.00 64,072.97 72.11 24,777.03 10-09-2018 12:14 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 211-LIBRARY Culture & Recreation 75.00% 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,750,00 485.13 6,341.22 65.04 3,408.78 TOTAL Supplies 9,850.00 485.13 6,341.22 64.38 3,508.78 Other Services & Charges 211-4-5600-4321 Telephone 1,100.00 0.00 734.80 66.80 365.20 211-4-5600-4331 Travel, Conferences & Schools 650.00 0.00 0.00 0.00 650.00 211-4-5600-4359 Publishing 500.00 0.00 0.00 0.00 500.00 211-4-5600-4361 Insurance 2,200.00 1,302.00 2,762.00 125.55 ( 562.00) 211-4-5600-4389 Utilities 28,250.00 58.35 21,112.34 74.73 7,137.66 211-4-5600-4401 Bldg Repair/Maint Services 14,750.00 633.46 6,421.68 43.54 8,328.32 211-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 0.00 0.00 250.00 211-4-5600-4405 Cleaning Services 17,500.00 0.00 13,695.00 78.26 3,805.00 211-4-5600-4409 Contractual Services 13,200.00 160.00 11,444.43 86.70 1,755.57 211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100,00 TOTAL Other Services & Charges 78,500.00 2,153.81 56,170.25 71.55 22,329.75 Capital Outlay 211-4-5600-4560 Equipment 30,000.00 5,723.57 10,749.48 35.83 19,250.52 TOTAL Capital Outlay 30,000.00 5,723.57 10,749.48 35.83 19,250.52 Transfers Out TOTAL Library 118,850.00 8,362.51 73,260.95 61.64 45,589.05 TOTAL Culture & Recreation 118,850.00 8,362.51 73,260.95 61.64 45,589.05 TOTAL EXPENDITURES 118,850.00 8,362.51 73,260.95 61.64 45,589.05 REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00) ( 8,362.51)( 9,187.98) ( 20,812.02) 11-09-2018 10:50 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: OCTOBER 31ST, 2018 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 41fi 635.70 211-1380 Interest Receivable 2,086.00 418,721.70 TOTAL ASSETS 418,721.70 LIABILITIES -====- -- 211-2200 Deposits Payable 250.00 TOTAL LIABILITIES 250.00 EQUITY 211-2400 Fund Balance 437,086.72 TOTAL BEGINNING EQUITY 437,086.72 TOTAL REVENUE 64,493.94 TOTAL EXPENSES 83,108.96 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 18,615.02) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 418,471.70 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 418,721.70 11-09-2018 10:54 AM DETAIL LISTING PAGE: 1 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Oct-2018 THRU Oct-2018 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET=====DESCRIPTION=-===_. VEND INV/PO/JE # NOTE AMOUNT=R= ---BALANCE=== 4-5600-4219 Operating Supplies BEGINNING BALANCE 6,341.22 10/15/18 10/11 A83326 CHK: 108016 03009 SUPPLIES 15887 33.99 6,375.21 DACOTAH PAPER CO INV# 31704 /PO# 10/15/18 10/11 A83394 CHK: 108084 03009 PARTS/SUPPLIES 25145 4.25 6,379.46 MENARDS - ELK RIVER INV# 093018 /PO# ____=-_.___= OCTOBER ACTIVITY DB: 38.24 CR: 0.00 38.24 4-5600-4321 Telephone BEGINNING BALANCE 734.80 10/01/18 9/27 A83206 CHK: 107937 03004 PHONE LINE CHGS 11102 91.68 826.48 WINDSTREAM INV# 090718 /PO# 10/24/18 10/24 A83599 CHK: 108219 03017 PHONE LINE CHGS 11102 92.02 918.50 WINDSTREAM INV# 100818 /PO# -------=G=_= OCTOBER ACTIVITY DB: 183.70 CR: 0.00 183.70 4-5600-4389 Utilities BEGINNING BALANCE 21,112.34 10/02/18 9/27 A83071 EFT: 000451 03006 WATER/ELEC 17700 2,147.01 23,259.35 ELK RIVER MUNICIPAL UTILI INV# 091218 /PO# 10/02/18 9/27 A83072 EFT: 000452 03006 SEPT RUBBISH SVCS 30851 58.35 23,317.70 RANDY'S ENVIRONMENTAL SER INV# 135818-091916 /PO# ____= OCTOBER ACTIVITY DB: 2,205.36 CR: 0.00 2,205.36 4-5600-4401 Bldg Repair/Maint Services BEGINNING BALANCE 6,421.68 10/01/18 9/27 A83084 CHK: 107815 03004 REPLACE CAN LIGHTS W/LED 10373 598.50 7,020.18 AID ELECTRIC CORPORATION INV# 56366 /PO# 10/01/18 9/27 A83110 CHK: 107841 03004 SERVICE CONTRACT 13024 449.80 7,469.98 CORPORATE MECHANICAL INC INV# W27294 /PO# 10/15/18 10/11 A83448 CHK: 108138 03009 MOWING SVCS CONTRACT 11661 428.46 7,898.44 SPEEDCUTTERS OUTDOOR MAIN INV# 10879 /PO# 10/15/18 10/11 A83467 CHK: 108157 03009 SECURITY MONITORING 36602 541.68 8,440.12 WRIGHT-HENNEPIN COOP ELEC INV# 092718 /PO# ` OCTOBER ACTIVITY DB: 2,018.44 CR: 0.00 2,018.44 11-09-2018 10:54 AM DETAIL LISTING PAGE: 2 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Oct-2018 THRU Oct-2018 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAM # REFERENCE PACKET===—DESCRIPTION=�==== VEND INV/PO/JE # NOTE =—AMOUNT-=== - -BALANCE==== 4-5600-4405 Cleaning Services BEGINNING BALANCE 13,695.00 10/09/18 10/09 A83267 CHK: 107964 03013 SEPT CLEANING SVCS 12651 2,490.00 16,185.00 PERFECTION PLUS, INC. INV# 1128874 /POI 10/24/18 10/24 A83586 CHK: 108206 03017 OCT CLEANING SVCS 12651 2,490.00 18,675.00 PERFECTION PLUS, INC. INV# 1128933 /PO# OCTOBER ACTIVITY DB: 4,980.00 CR: 0.00 4,980.00 4-5600-4409 Contractual Services BEGINNING BALANCE 11,444.43 10/01/18 9/27 A83180 CHK: 107911 03004 PROGRAM 10/8 13060 40.00 11,484.43 ROBIN SCHAIBLE INV# 100818 /PO# 10/01/18 9/27 A83181 CHK: 107912 03004 PROGRAM 10/15 13060 40.00 11,524.43 ROBIN SCHAIBLE INV# 101518 /PO# 10/15/18 10/11 A83433 CHK: 108123 03009 PROGRAM 9/07 13060 40.00 11,564.43 ROBIN SCHAIBLE INV# 090718 /PO# 10/15/18 10/11 A83434 CHK: 108124 03009 PROGRAM 10/5 13060 40.00 11,604.43 ROBIN SCHAIBLE INV# 100518 /PO# 10/15/18 10/1] A83435 CHK: 108125 03009 REINS PROGRAM SUPPLIES 13060 102.27 11,706.70 ROBIN SCHAIBLE INV# 100918 /PO# 10/15/18 10/11 A83436 CHK: 108126 03009 PROGRAM 10/22 13060 40.00 11,746.70 ROBIN SCHAIBLE INV# 102218 /PO# 10/15/18 10/11 A83437 CHK: 108127 03009 PROGRAM 10/29 13060 40.00 11,786.70 ROBIN SCHAIBLE INV# 102918 /PO4 10/15/18 10/11 A83438 CHK: 108128 03009 PROGRAM 11/2 13060 40.00 11,826.70 ROBIN SCHAIBLE INV# 110218 /PO# 10/15/18 10/11 A83439 CHK: 108129 03009 PROGRAM 11/5 13060 40.00 11,866.70 ROBIN SCHAIBLE INV# 110518 /PO# ___�_@= OCTOBER ACTIVITY DB: 422.27 CR: 0.00 422.27 +-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! *_*_*_*_*_ -*_+_*_*_*_*_*_* ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 73,260.95 0,00 REPORTED ACTIVITY: 9,848.01 0.00 ENDING BALANCES: 83,108.96 0.00 TOTAL FUND ENDING BALANCE: 83,108.96 11-09-2018 10:51 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2018 211-LIBRARY FINANCIAL SUMMARY 83.33€ OF YEAR COMP, CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 88,850.00 0.00 64,493.94 72.59 24,356.06 TOTAL REVENUES 88,850.00 0.00 64,493.94 72.59 24,356.06 EXPENDITURE SUMMARY Culture & Recreation Library 118,850.00 9,848.01 83,108.96 69.93 35,741.04 TOTAL Culture & Recreation 118,850.00 9,848.01 83,108.96 69.93 35,742.04 TOTAL EXPENDITURES 118,850.00 9,848.01 83,108.96 69.93 35,741.04 REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00)( 9,848.01) ( 18,615.02) ( 11,384.98) 11-09-2018 10:51 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2018 211-LIBRARY 83.33% 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 54,000.00 0.00 28,318.11 52.44 25,681.89 211-3-0000-3112 Delinquent'Ad Valorem Taxes 0.00 0.00 158.48 0.00 ( 158.48) TOTAL Taxes 54,000.00 0.00 28,476.59 52.73 25,523.41 Intergovernmental Rev Charges for Services Other Revenue 211-3-0000-3621 Interest Income 6,500.00 0.00 6,917.35 106.42 ( 417.35) 211-3-0000-3629 Miscellaneous Revenue 0.00 0.00 750.00 0.00 ( 750.00) TOTAL Other Revenue 6,500.00 0.00 7,667.35 117.96 ( 1,167.35) 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 88,850.00 0.00 64,493.94 72.59 24,356.06 Library Project Other Financing Sources Transfers In TOTAL REVENUE 88,850.00 0.00 64,493.54 72.59 24,356.06 11-09-2018 10:51 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2018 211-LIBRARY Culture & Recreation 83.33% 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,750.00 38.24 6,379.46 65.43 3,370.54 TOTAL Supplies 9,850.00 38.24 6,379.46 64.77 3,470.54 Other Services & Charges 211-4-5600-4321 Telephone 1,100.00 183.70 918.50 83.50 181.50 211-4-5600-4331 Travel, Conferences & Schools 650.00 0.00 0.00 0.00 650.00 211-4-5600-4359 Publishing 500.00 0.00 0.00 0.00 500.00 211-4-5600-4361 Insurance 2,200.00 0.00 2,762.00 125.55 ( 562.00) 211-4-5600-4389 Utilities 28,250.00 2,205.36 23,317.70 82.54 4,932.30 211-4-5600-4401 Bldg Repair/Maint Services 14,750.00 2,018.44 8,440.12 57.22 6,309.88 211-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 0.00 0.00 250.00 211-4-5600-4405 Cleaning Services 17,500.00 4,980.00 18,675.00 106.71 ( 1,175.00) 211-4-5600-4409 Contractual Services 13,200.00 422.27 11,866.70 89.90 1,333.30 211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 78,500.00 9,809.77 65,980.02 84.05 12,519.98 Capital Outlay 211-4-5600-4560 Equipment 30,000.00 0.00 10,749.48 35.83 19,250,52 TOTAL Capital Outlay 30,000.00 0.00 10,749.48 35.83 19,250.52 Transfers Out TOTAL Library 118,850.00 9,848.01 83,108.96 69.93 35,741.04 TOTAL Culture & Recreation 118,850.00 9,848.01 83,108.96 69.93 35,741.04 TOTAL EXPENDITURES 118,850.00 9,848.01 83,108.96 69.93 35,741.04 REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00)( 9,248.01) ( 18,615.02) ( 11,384.98)