Loading...
3.2. LIBSR 05-23-20174-11-2017 08:59 AM 211 -LIBRARY ACCOUNT # ACCOUNT DESCRIPTION CITY OF ELK RIVER BALANCE SHEET AS OF: MARCH 31ST, 2017 BALANCE ASSETS 211-1010 Cash Library 414,239.65 211-1380 Interest Receivable 1,838.00 TOTAL ASSETS LIABILITIES 211-2200 Deposits Payable 350.00 TOTAL LIABILITIES EQUITY 211-2400 Fund Balance 428,065.37 TOTAL BEGINNING EQUITY 428,065.37 TOTAL REVENUE 1,701.29 TOTAL EXPENSES 14,039.01 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 12,337.72) TOTAL EQUITY & REV. OVER/(UNDER) EXP. TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 416,077.65 350.00 415,727.65 PAGE: 1 416,077.65 -------------- -------------- 416,077.65 -------------- -------------- 3.A 4-11-2017 9:01 AM D E T A I L L I S T I N G PAGE: FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Mar -2017 THRU Mar -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 694.91 3/06/17 3/01 A71616 CHK: 100697 02573 SUPPLIES 11835 11.49 706.40 BATTERIES PLUS BULBS INV# 033-927232 /PO# 3/06/17 3/01 A71633 CHK: 100714 02573 SUPPLIES 15887 581.52 1,287.92 DACOTAH PAPER CO INV# 40159 /PO# 3/20/17 3/15 A71866 CHK: 100896 02577 SUPPLIES 15887 44.83 1,332.75 DACOTAH PAPER CO INV# 46470 /PO# 3/20/17 3/15 A71951 CHK: 100981 02577 BULK SALT 13048 64.40 1,397.15 STEP SAVER INC INV# 107743B /PO# MARCH ACTIVITY DB: 702.24 CR: 0.00 702.24 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 92.67 3/06/17 3/01 A71739 CHK: 100820 02573 PHONE LINE CHGS 11102 91.00 183.67 WINDSTREAM INV# 020717 /PO# 3/24/17 3/24 A72042 CHK: 101035 02584 PHONE LINE CHGS 11102 91.00 274.67 WINDSTREAM INV# 030717 /PO# 14ARCH ACTIVITY DB: 182.00 CR: 0.00 182.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4361 Insurance B E G I N N I N G B A L A N C E 511.25 3/20/17 3/15 A71901 CHK: 100931 02577 INSURANCE ALLOCATION 23805 511.25 1,022.50 LEAGUE OF MN CITIES INS T INV# 54949 /PO# MARCH ACTIVITY DB: 511.25 CR: 0.00 511.25 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 2,843.50 3/07/17 3/01 A71763 EFT: 000123 02575 FEB RUBBISH SVCS 30851 58.35 2,901.85 RANDY'S ENVIRONMENTAL SER INV# 135818--02/16/17 /PO# 3/15/17 3/13 A71832 EFT: 000124 02579 WATER/ELEC 17700 2,557.84 5,459.69 ELK RIVER MUNICIPAL UTILI INV# 022117 /PO# MARCH ACTIVITY DB: 2,616.19 CR: 0.00 2,616.19 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 205.00 4-11-2017 9:01 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: Mar -2017 THRU Mar -2017 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== 3/13/17 3/13 A71791 CHK: 100835 02578 PEST CONTROL 15191 75.00 280.00 COUNTRY SIDE PEST CONTROL INV# 9260 /PO# MARCH ACTIVITY DB: 75.00 CR: 0.00 75.00 ----------------------------------------------------------------------------------------------------------------------------------- 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 2,490.00 3/20/17 3/15 A71927 CHK: 100957 02577 MARCH CLEANING SVCS 12651 1,245.00 3,735.00 PERFECTION PLUS, INC. INV# 112810 /PO# MARCH 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 1,000.00 3/06/17 3/01 A71710 CHK: 100791 02573 PROGRAM 3/8 13060 40.00 1,040.00 ROBIN SCHAIBLE INV# 030817 /PO# 3/06/17 3/01 A71711 CHK: 100792 02573 PROGRAM 3/13 13060 40.00 1,080.00 ROBIN SCHAIBLE INV# 031317 /PO# 3/06/17 3/01 A71712 CHK: 100793 02573 PROGRAM 3/15 13060 40.00 1,120.00 ROBIN SCHAIBLE INV# 031517 /PO# 3/06/17 3/01 A71713 CHK: 100794 02573 PROGRAM 3/20 13060 40.00 1,160.00 ROBIN SCHAIBLE INV# 032017 /PO# 3/20/17 3/15 A71939 CHK: 100969 02577 PROGRAM 3/22 13060 40.00 1,200.00 ROBIN SCHAIBLE INV# 032217 /PO# 3/20/17 3/15 A71940 CHK: 100970 02577 PROGRAM 3/27 13060 40.00 1,240.00 ROBIN SCHAIBLE INV# 032717 /PO# 3/20/17 3/15 A71941 CHK: 100971 02577 PROGRAM 3/29 13060 40.00 1,280.00 ROBIN SCHAIBLE INV# 032917 /PO# 3/20/17 3/15 A71942 CHK: 100972 02577 PROGRAM 4/3 13060 40.00 1,320.00 ROBIN SCHAIBLE INV# 040317 /PO# 3/20/17 3/15 A71975 CHK: 101005 02577 PROGRAM 3/30 13215 550.00 1,870.00 ZORONGO FLAMENCO INC INV# 033017 /PO# MARCH ACTIVITY DB: 670.00 CR: 0.00 870.00 *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 7,837.33 0.00 REPORTED ACTIVITY: 6,201.68 0.00 ENDING BALANCES: 14,039.01 0.00 TOTAL FUND ENDING BALANCE: 14,039.01 4-11-2017 09:00 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2017 211 -LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 87,500.00 0.00 1,701.29 1.94 85,798.71 87,500.00 0.00 1,701.29 1.94 85,798.71 97,500.00 6,201.68 14,039.01 14.40 83,460.99 97,500.00 6,291.68 14,039.01 14.40 83,460.99 97,500.00 6,201.68 14,039.01 14.40 83,460.99 ( 10,000.00)( 6,201.68)( 12,337.72) 2,337.72 4-11-2017 09:00 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2017 211 -LIBRARY REVENUES Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes TOTAL Taxes Intergovernmental Rev Charges for Services Other Revenue 211-3-0000-3621 Interest Income TOTAL Other Revenue Transfers In 211-3-0000-3945 Transfer -Utilities TOTAL Transfers In TOTAL Library Library Project --------------- Other Financing Sources Transfers In 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 53,650.00 0.00 0.00 0.00 53,650.00 53,650.00 0.00 0.00 0.00 53,650.00 5,500.00 0.00 1,701.29 30.93 3,798.71 5,500.00 0.00 1,701.29 30.93 3,798.71 28,350.00 0.00 0.00 0.00 28,350.00 28,350.00 0.00 0.00 0.00 28,350.00 87,500.00 0.00 1,701.29 1.94 85,798.71 TOTAL REVENUE 87,500.00 0.00 1,701.29 1.94 85,798.71 4-11-2017 09:00 AM CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 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 TOTAL Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES PAGE: 3 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 500.00 0.00 0.00 0.00 500.00 500.00 0.00 0.00 0.00 500.00 100.00 0.00 0.00 0.00 100.00 91650.00 702.24 1,397.15 14.48 8,252.85 9,750.00 702.24 1,397.15 14.33 8,352.85 1,100.00 182.00 274.67 24.97 825.33 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 511.25 1,022.50 47.56 1,127.50 29,450.00 2,616.19 5,459.69 18.54 23,990.31 16,050.00 75.00 280.00 1.74 15,770.00 250.00 0.00 0.00 0.00 250.00 15,000.00 1,245.00 3,735.00 24.90 11,265.00 11,000.00 870.00 1,870.00 17.00 9,130.00 100.00 0.00 0.00 0.00 100.00 77,250.00 5,499.44 12,641.86 16.36 64,608.14 10,000.00 0.00 0.00 0.00 10,000.00 10,000.00 0.00 0.00 0.00 10,000.00 97,500.00 97,500.00 97,500.00 6,201.68 14,039.01 14.40 83,460.99 6,201.68 6,201.68 14,039.01 14,039.01 14.40 14.40 83,460.99 83,460.99 97,500.00 6,201.68 14,039.01 14.40 83,460.99 ( 10,000.00)( 6,201.68)( 12,337.72) 2,337.72 5-09-2017 09:22 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: APRIL 30TH, 2017 211 -LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 438,666.26 211-1380 Interest Receivable 1,838.00 440,504.26 TOTAL ASSETS 440,504.26 -------------- -------------- LIABILITIES 211-2200 Deposits Payable 550.00 TOTAL LIABILITIES 550.00 EQUITY 211-2400 Fund Balance 428,065.37 TOTAL BEGINNING EQUITY 428,065.37 TOTAL REVENUE 30,370.49 TOTAL EXPENSES 18,481.60 TOTAL REVENUE OVER/(UNDER) EXPENSES 11,888.89 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 439,954.26 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 440,504.26 -------------- -------------- 5-09-2017 9:24 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: Apr-2017 THRU Apr-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 1,397.15 4/17/17 4/12 A72312 CHK: 101217 02597 SUPPLIES 15887 249.42 1,646.57 DACOTAH PAPER CO INV# 59906 /PO# 4/24/17 4/24 A72474 CHK: 101323 02605 SUPPLIES-FLAGS 12787 83.72 1,730.29 ALL FLAGS LLC INV# 356967 /PO# APRIL ACTIVITY DB: 333.14 CR: 0.00 333.14 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 5,459.69 4/04/17 3/29 A72190 EFT: 000128 02589 MARCH RUBBISH SVCS 30851 58.35 5,518.04 RANDY'S ENVIRONMENTAL SER INV# 135818-03/17/17 /PO# 4/17/17 4/12 A72427 EFT: 000132 02595 WATER/ELEC 17700 2,061.45 7,579.49 ELK RIVER MUNICIPAL UTILI INV# 032017 /PO# APRIL ACTIVITY DB: 2,119.80 CR: 0.00 2,119.80 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 280.00 4/03/17 3/29 A72176 CHK: 101145 02586 HVAC REPAIRS 36620 370.75 650.75 YALE MECHANICAL LLC INV# 179437 /PO# APRIL ACTIVITY DB: 370.75 CR: 0.00 370.75 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4404 Equip Repair/Maint Services B E G I N N I N G B A L A N C E 0.00 4/03/17 3/29 A72139 CHK: 101108 02586 FIRE EXTINGUISHER SVC 11955 13.90 13.90 RICHFIELD FIRE EXTINGUISH INV# 108591 /PO# APRIL ACTIVITY DB: 13.90 CR: 0.00 13.90 ----------------------------------------------------------------------------------------------------------------------------------- 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 3f735.00 4/17/17 4/12 A72368 CHK: 101273 02597 APRIL CLEANING SVCS 12651 1,245.00 4,980.00 PERFECTION PLUS, INC. INV# 112770 /PO# ------------= APRIL ACTIVITY DB: 1,245.00 CR: 0.00 1,245.00 5-09-2017 9:24 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: Apr -2017 THRU Apr -2017 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4409 Contractual Services 8 E G I N N I N G B A L A N C E 1,870.00 4/03/17 3/29 A72145 CHK: 101114 02586 PROGRAM 4/5 13060 40.00 1,910.00 ROBIN SCHAIBLE INV# 040517 /PO# 4/03/17 3/29 A72146 CHK: 101115 02586 PROGRAM 4/7 13060 40.00 1,950.00 ROBIN SCHAIBLE INV# 040717 /PO# 4/03/17 3/29 A72147 CHK: 101116 02586 PROGRAM 4/10 13060 40.00 1,990.00 ROBIN SCHAIBLE INV# 041017 /PO# 4/03/17 3/29 A72148 CHK: 101117 02586 PROGRAM 4/12 13060 40.00 2,030.00 ROBIN SCHAIBLE INV# 041217 /PO# 4/03/17 3/29 A72149 CHK: 101118 02586 PROGRAM 4/17 13060 40.00 2,070.00 ROBIN SCHAIBLE INV# 041717 /PO# 4/17/17 4/12 A72378 CHK: 101283 02597 PROGRAM 4/19 13060 40.00 2,110.00 ROBIN SCHAIBLE INV# 041917 /PO# 4/17/17 4/12 A72379 CHK: 101284 02597 PROGRAM 4/24 13060 40.00 2,150.00 ROBIN SCHAIBLE INV# 042417 /PO# 4/17/17 4/12 A72380 CHK: 101285 02597 PROGRAM 4/26 13060 40.00 2,190.00 ROBIN SCHAIBLE INV# 042617 /PO# 4/17/17 4/12 A72381 CHK: 101286 02597 PROGRAM 5/1 13060 40.00 2,230.00 ROBIN SCHAIBLE INV# 050117 /PO# APRIL ACTIVITY DB: 360.00 CR: 0.00 360.00 *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 14,039.01 0.00 REPORTED ACTIVITY: 4,442.59 0.00 ENDING BALANCES: 18,481.60 0.00 TOTAL FUND ENDING BALANCE: 18,481.60 5-09-2017 09:23 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 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 CURRENT CURRENT BUDGET PERIOD 33.33% OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 87,500.00 28,350.00 30,370.49 34.71 57,129.51 87,500.00 28,350.00 30,370.49 34.71 57,129.51 97,500.00 4,442.59 18,481.60 18.96 79,018.40 97,500.00 4,442.59 18,481.60 18.96 79,018.40 97,500.00 4,442.59 18,481.60 18.96 79,018.40 ( 10,000.00) 23,907.41 11,888.89 ( 21,888.69) 5-09-2017 09:23 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 211 -LIBRARY REVENUES Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes TOTAL Taxes Intergovernmental Rev Charges for Services Other Revenue 211-3-0000-3621 Interest Income TOTAL Other Revenue Transfers In 211-3-0000-3945 Transfer -Utilities TOTAL Transfers In TOTAL Library Library Project Other Financing Sources Transfers In 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 53,650.00 0.00 0.00 0.00 53,650.00 53,650.00 0.00 0.00 0.00 53,650.00 5,500.00 0.00 2,020.49 36.74 3,479.51 5,500.00 0.00 2,020.49 36.74 3,479.51 28,350.00 28,350.00 28,350.00 100.00 0.00 28,350.00 28,350.00 28,350.00 100.00 0.00 87,500.00 28,350.00 30,370.49 34.71 57,129.51 TOTAL REVENUE 87,500.00 28,350.00 30,370.49 34.71 57,129.51 5-09-2017 09:23 AM REVENUE 211 -LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ACTUAL 33.33% % OF BUDGET PAGE: 3 OF YEAR COMP. BUDGET BALANCE Personal Services 18,481.60 18.96 79,018.40 ( 10,000.00) 23,907.41 11,888.89 ( 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 333.14 1,730.29 17.93 7,919.71 TOTAL Supplies 9,750.00 333.14 1,730.29 17.75 8,019.71 Other Services & Charges 211-4-5600-4321 Telephone 1,100.00 0.00 274.67 24.97 825.33 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 1,022.50 47.56 1,127.50 211-4-5600-4389 Utilities 29,450.00 2,119.80 7,579.49 25.74 21,870.51 211-4-5600-4401 Bldg Repair/Maint Services 16,050.00 370.75 650.75 4.05 15,399.25 211-4-5600-4404 Equip Repair/Maint Services 250.00 13.90 13.90 5.56 236.10 211-4-5600-4405 Cleaning Services 15,000.00 1,245.00 4,980.00 33.20 10,020.00 211-4-5600-4409 Contractual Services 11,000.00 360.00 2,230.00 20.27 8,770.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,109 45 16,751.31 21.68 60,498.69 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 4,442.59 18,481.60 18.96 79,018.40 TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 97,500.00 4,442.59 18,481.60 18.96 79,016.40 97,500.00 4,442.59 18,481.60 18.96 79,018.40 ( 10,000.00) 23,907.41 11,888.89 ( 21,888.89)