Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3.2. LIBSR 07-24-2018
7-15-2018 10:41 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: JUNE 30TH, 2018 211-IfBRARY ACCOUNT ACCOUNT DESCRIPTION BALANCE ASSETS ====== 211-1010 Cash - Library 446,332.47 211-1380 Interest Receivable 2,086.00 448,418.4% TOTAL ASSETS 448,418.47 LIABILITIES 211-2200 Deposits Payable 330.00 TOTAL LIABILITIES 350.00 EQUITY 211-2400 Fund Balance 437,086.72 TOTAL BEGINNING EQUITY 437,086.72 TOTAL REVENUE 52,215.20 TOTAL EXPENSES 41,233.45 TOTAL REVENUE OVER! UNDER) EXPENSES 10,981.75 TOTAL EQUITY & REV. OVER/(UN)ER) EXP. 448,068.47 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 448,418.47 7-05-201.8 10:46 AM DETAIL LISTING PAGE: 1 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Jun-2018 THRU Jun-2018 DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKE^_=a====DESCRIPTION=====_= VEND INV/PO/JE 4 NOTE AMOUNT==== ====BALANCE==== 4-5600-4219 Operating Supplies BEGINNING BALANCE 3,749.07 6/18/18 6/13 A81259 CHK: 106568 02928 SUPPLIES 15887 178.86 3,927.93 DACOTAH PAPER CO INV$ 46835 /Pp# JUNE ACTIVITY DB: 178.86 CR: 0.00 178.86 4-5600-4321 Telephone BEGINNING 3 A LAN C E 367.15 6/04/18 5/30 A81122 CEK: 106484 02921 PHONE LINE CHCS 11102 91.80 458.95 WINDSTREAM INV# 050718 /2O# 6/22/18 6/21 A81462 CHK: 106710 02938 PHONE LINE 01105 11102 91.62 550.57 NINDSTREAM INV# 060718 /PO# __= JUNE ACTIVITY DB: 183.42 CR: C.00 183.42 4-5600-4389 Uti_ities BEGINNING BALANCE 13,784.50 6/05/18 5/30 A81145 EFT: 000362 02924 MAY RUBBISH SVCS 30851 58.35 13,842.85 RANDY'S ENVIRONMENTAL SER INV# 135818-051918 /POA --------- JUNE ACTIVITY DB: 58.35 CR: 0.1C 58.35 4-5600-4401 Bldg Repair/Maint Services BEGINNING BALANCE 3,045.00 6/04/18 5/30 A81001 CHK: 106363 02921 REPLACE FIXTURE 10373 626.18 3,671.1.8 AID ELECTRIC CORPORATION INV4 55381 /30# 6/04/18 5/30 A81099 CNK: 1064661 02921. MOWING SVCS CONTRACT 11661. 428.46 4,099.64 SPEEDCUTTERS OUTDOOR MAIN INV# 5317 /PO4 6/18/18 6/13 A81315 CHK: 106624 02928 VEGETATION MANAGEMENT 30075 211.70 4,311.34 PRAIRIE RESTORATIONS, INC INV# 11634 /PO# ----- JUNE ACTIVITY DB: 1,266.34 CR: 0.00 1,266.34 4-5600-4409 Contractual Services BEGINNING BALAN C E 10,821.86 6/04/18 5/30 A81090 CHK: 106452 02921 PROGRAM 6/18 13060 40.00 10,661.86 ROBIN SCHAIBLE INV# 061818 /P0# 6/18/18 6/13 A81321 CHK: 106630 02928 PROGRAM 6/25 13060 40.00 10,901.8E ROBIN SCHAIBLE INV4 062518 /P0# JUNE ACTIVITY DB: 80.00 CR: 0.00 80.00 7-0S-2016 10:43 AM CITY CO ELK RIVER PAGE: 1 REVENUE & EXPCNSE REPORT (UNAJ;I`PEO) AS OF: JUNE 30:.H, 21128 211-LIBRARY FINANCIAL SUMMARY 50.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 88,850.00 19,821.70 52,215.20 58.77 36,6634,80 TOTAL REVENUES 88,850.00 19,821.70 52,215.20 58.77 36,634.80 EXPENDITURE SUMMARY Culture & Recreation Library 118,850.00 1,766.97 41,233.45 34,69 77,616.55 TOTAL Culture & Recreation 118,850.00 1,766.97 41,233.45 34.69 77,616.55 TOTAL EXPENDITURES 118,850.00 1,766.97 41,233.45 34.69 77,616.55 REVENUES OVER/(UNDER) EXPENDITURES ( 30,000,00) 18,054.73 10,981.75 ( 40,981.75) 7-05-2018 10:43 AM CITY OF ELK RIVER ?AGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2018 211-LIBRARY Culture & Recreation 50.00% OF YEAR C0M?. Library CURRENT CURRENT YEAR TO DATE S OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 211-4-5600-4103 Part-time ?ay 500.00 0.00 0.00 0.00 500.00 TOTAL Personal Services 500.00 0.00 C.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 178.86 3,927.93 40.29 5,822.07 TOTAL Supplies 9,850.00 178.86 3,927.93 39.88 5,922.07 Other Services & Charges 211-4-5600-432: Telephone 1,100.00 183.42 550.57 50.05 549.43 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 1,460.00 66.36 740.00 211-4-5600-4389 Utilities 28,250.00 58.35 13,842.85 49.00 14,407.15 211-4-5600-4401 Bldg Repair/Maint Services 14,750.00 1,266.34 4,311.34 29.23 10,438.66 211-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 13.90 5.56 236.10 211A-5600-4405 Cleaning Services 17,500.00 0.00 6,225.00 35.57 11,275.00 211-4-5600-4409 Contractual Services 13,200.00 80,00 10,901.86 82.59 2,298.14 211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 78,500.00 1,588.11 37,305.52 47.52 41,194.48 Capital Outlay 211-4-5600-4560 Equipment 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL Capital Outlay 30,000.00 0.00 0.30 0.00 30,000.00 Transfers Out TOTAL Library 17.8,850.00 1,766.97 41,233.45 34.69 77,616,55 TOTAL Culture & Recreation 116,850.00 1,756.97 41,233.45 34.69 77,616.55 TOTAL EXPENDITURES 118,850.00 1,766.97 41,233.45 34.69 77,616.55 REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00) 18,054.73 10,981.75 ( 40,.0 81.75) 6-06-2018 10:42 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: MAY 31ST, 2018 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 427,142.07 211-1380 Interest Receivable 2,086.00 429,228.07 TOTAL ASSETS 429,228.07 LIABIL-TIES 211-2200 Deposits Payable 400.00 TOTAL LIABILITIES 400.00 EQUITY 211-2400 Fund Balance 437,086.72 TOTAL BEGINNING EQUITY 437,086.72 TOTAL REVENUE 31,207.83 TOTAL EXPENSES 39,466.48 TOTAL REVENJE OVER/(UNDER) EXPENSES 8,258.65) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 426,828.07 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 429,228.07 - - _ -06-2019 :.0:44 AM DETAiL LISTING PAGE: 1 FUND : 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: May--2+018 THRG May-20.8 DEFT : 5600 Library SUPPRESS 10R0S ACCOUNTS: ALL POST 0099 TRAN 4 REFERENCE SAOKET---= -D,SCR_.:CION' - - VEND 1641.113E 4 NOTE --==AMOUNT_==- == 'BALANC',- =-560;1--421.9 Operating Supplies B EGINNING 11 6 3 0 0 0 8 3,028.97 5/0-7/1.8 5/03 A80542 CHK: 106055 02962 SUPPLIES 15887 250.87 3,279.84 DACOTAN PAPER CO 1:NV4 22787 /PO4 5/01/18 5/03 A80551 CFO: 106064 02902 SUPPLIES 17810 18.17 3,298.61. .11K RIVER W%.NIECTRTC 16V3 27549900 /204 5/17/1.8 5/03 080551 CNK: I86064 02902 SUPPLIES 1789(7 115.76 3,414.37 ELK RIVER WIN EOTRIC. INV- 2760141:1 /803 /1'',18 5/033 780633 CHIC: 106146 02902 E3111" SALT 130148 161.00 3,515.37 STEP SAVER T60 'INV4 7.185648 /PO4 5/14/19 ..,14 041134 CNK: 106194 • 92912 LIGHTING 35:211 65.40 3,640.77 ,OSS LIGHT:NG TKV4 15312343-00 /70(1 5/1.4/18 5/14 280734 ('3I 1661.94 02912 LIGHTING 335861 .5.90 3,716.67 VOSS LIGHTING INV= 15312946-0C /804 5/21/18 5/17080779 CHK: 106225 0291; 038103IES 15887 32.40 3,749,01 DACOTA0 PAPER CO 03/4 29257 /PO4 __= MAY ACTIVITY DB: 720.1.0 Ci: 0.00 726.1.0 4-5600-4389 0:3litiaa B EGINNING BALANCE 8,886.31 ./'01/16 4130 A90494 EFT: 000341 62904 NATER/ETEC 17743 2,f75.58 11,461.89 :LK RIVER MV-NICIFAL :T_.1.,I. 11104 3411,01 /404 5/08/18 5/31 A80680 EFT: 090348 92903 APRIL R'UDSIS 3 SVCS 30851 56.35 1_,52{'-'.29 RA.NDY'S ENVIRONMENTAL SER INV* 135818-04191.8 /704 5/30/18 5/21 080994 E8T: 000358 02925 SA'.0/ 7L ^, 17700 2,264.26 13,784.50 ELK RIVER MUNICIPAL UTILI INY4 05091.8 /804 --- . ._ MAY ACTIVITY DB: 4,898.19 CR: 0.00 4,898.19 4-5690_.4401. 'Bldg Repa /.rMain.:. 5ervicss B EGINNING BALANCE 2,765.00 5/21/1.8 5/:17 A80773 CHK: 106219 02913 PEST CONTROL 1519: 75.00 2,840,00 COUNTRY SIDE. FEST CONTROL 163%4 9586 /BOW 5/21/16 5/17 A80785 CRK: 106231 02913 EXTERIOR WINOOW CLEANING 16448 205.89 3,945.00 DISTINCTIVE ;4INDOW CLEAN1 130/4 12127 /704 -- - - MAY ACTIVITY DR: 280.00 CR: 0.00 28' .00 I, 4-5600-4405 Cleaning Services B EGINNING S A L I. N C E 4,960.0C 6-06-2018 10:42 AM CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPOR: (UNAUDITED) AS OF: MAY 31ST, 2018 211-LIBRARY FINANC:AL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TC DATE P OF BUDGET BUDGET PERIOD ACTUAL BUDGET 3ALANCE _ . • REVENUE SUMMARY Library 88,850.00 0.00 31,207.83 35.12 57,642.17 TOTAL REVENUES 88,850.00 0.00 31,207.83 35.12 57,642.17 EXPENDITURE SUMMARY Culture & Recreation Library 118,850.00 7,263.29 39,466.48 33.21 79,383.52 TOTAL Culture & Recreation 118,550.00 7,263.29 39,466.48 33.21 79,383.52 TOTAL EXPENDITURES 118,850.00 7,263.29 39,466.48 33.21 79,383.52 REVENUES OVER/(UNDER) EXPENDITURES ( 30,000.00) ( 7,263.29) ) 8,258.65) ( 21,741.35) 6-06-2018 10:42 AN CITY OF ELK RIVER PAGE: 3 REVENUE. & EXPENSE REPORT {UNAUDITED) AS OF: MAY 31ST, 2018 21_-LIBRARY Culture & Recreation 91.67a OF YEAR COMP. Library CURRENT CURRENT YEAR TO DATE a 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 00D.00 Supplies 211-4-5600-4231 Office Supplies 100.00 0.01 0.00 0.00 100.00 211-4-5600-4219 Operating Supplies 9,750.00 720.10 3,7 9.07 36.45 6,000.93 TOTAL Supplies 9,850.00 720.10 3,749.07 38.06 6,100.93 Other Services & Charges 211-4-5600-4321 Telephone 1,100.00 0.00 367.15 33.38 732.85 211-4-5600-4331 Travel, Conferences & Schools 65D.O0 0.00 C.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 1,460.00 66.36 790.00 211-4-5600-4389 Utilities ?.9,250.00 4,898.19 13,784.50 48.79 14,465.50 211-4-5600-4411 Bldg Repair/Maint Services 14,750.00 280.00 3,095.00 20.64 11,705.03 211-4-5600-4404 Equip Repair/Maint Services 250.00 0.00 13.90 5.56 236.10 211-4 5600-4405 Cleaning Services 17,500.00 1,245.00 6,225.00 35.57 11,275.00 211-4-5600-4409 Contractual Services 13,X0.00 120.00 10,821.86 81.98 2,378.14 211-4-5600-4433 Dues & Subscriptions 100.00 0.00 0.00 0.00 100.00 TOTAL Other Services & Charges 78,500.00 6,541.19 35,717.41 45.50 42,782.59 Capital Outlay 211-4-5600-4560 Equipment 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL Capital Outlay 30,000.00 0.00 0.00 0.00 30,000.00 Transfers Out TOTAL Library 118,850.00 7,263.29 39,466.98 33.21 79,383.52 TOTAL Culture & Recreation 118,850.00 7,263.29 39,466.48 33.21 79,383.52 TOTAL EXPENDITURES 118,850.00 7,263.29 39,466.48 33.21 79,383.52 REVENUES CVOR/CUNDER) EXPENDITURES ( 30,000.O0) ) 7,"1.63.29) ( 8,'1.58.65} ( 21,741.35)