Loading...
ITEM 3.1 Claims 1.22.2018COUNCIL ITEM CITY COUNCIL MEETING January 22, 2018 TO: Tami Loff Claims List is attached; please refer to the Check Registers for payment detail. CHECK REGISTERS: VOIDED CHECKS: PAYROLL: ITEM 3.1 $ 73,390.00 #61756 $ 225.00 #61757 $ 208,352.48 #61758 - 61807 Total $ 281,967.48 Total $ - $ 58,896.25 Total $ 58,896.25 GRAND TOTAL: $ 340,863.73 Please let me know if you have any questions or would like additional information. Thank yoi Julie Weiers Finance CITY OF OTSEGO Check Register - CLAIMS LIST Page: 1 Check Issue Dates: 1/9/2018 - 1/912018 Jan 09, 2018 02:47PM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount 61756 01/18 01/09/2018 61756 1394 C.W. HOULE INC 12192017 1 220-49490-530 DNR POND OUTLET -PAY #1/FINAL 73,390.00 73,390.00 Total 61756: 73,390.00 Grand Totals: 73,390.00 Summary by General Ledger Account Number GLAccount Debit Credit Proof 220-20200 .00 73,390.00- 73,390.00- 220-49490-530 73,390.00 .00 73,390.00 Grand Totals: 73,390.00 73,390.00- .00 CITY OF OTSEGO Check Register- CLAIMS LIST Page: 1 Check Issue Dates: 1/11/2018 - 1/17/2018 Jan 17, 2018 11:38AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount 61757 01118 01/17/2018 61757 300 ICMA RETIREMENT CORP 41549031 1 101-21705 PLAN 304185 PPE 01/13/2018 ck dtd 01/17/2018 225.00 225.00 Total 61757: 225.00 Grand Totals: 225.00 Summary by General Ledger Account Number GLAccount Debit Credit Proof .00 225.00- 225.00- 225.00 .00 225.00 225.00 225.00- .00 101-20200 101-21705 Grand Totals: CITY OF OTSEGO Check Register- CLAIMS LIST Page: 1 Check Issue Dates: 1/22/2018 - 1/22/2018 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount 61758 01/18 01/22/2018 61758 1423 ADMINISTRATIVE FREEDOM LLC 3255 1 101-45250-390 CLASS FOR SENIORS 40.00 40.00 Total 61758: 40.00 61759 01/18 01/22/2018 61759 16 ADVANCED ENGINEERING AND 56349 1 602-49450-302 SCHOOL LIFT STATION I&C 421.64 421.64 01/18 01/22/2018 61759 16 ADVANCED ENGINEERING AND 56350 1 601-49400-302 WELLHOUSE #4 CONTROLS IMPROVEMENT 2,586.76 2,586.76 01/18 01/22/2018 61759 16 ADVANCED ENGINEERING AND C175161 1 602-49450-390 EAST WWTF HEATER RELOCATION 1,900.00 1,900.00 Total 61759: 4,908.40 61760 01/18 01/22/2018 61760 17 AFFORDABLE SANITATION 1885 1 101-45200-390 PORTA RENTAL- JANUARY 2018 224.00 224.00 Total 61760: 224.00 61761 01/18 01/22/2018 61761 20 AIRGAS INC. 9950027462 1 101-43100-210 TORCH SUPPLIES 59.80 59.80 Total 61761: 59.80 61762 01/18 01/22/2018 61762 1174 ANCOM COMMUNICATIONS 75499 1 101-43240-390 RADIO REPAIRS 583.00 583.00 Total 61762: 583.00 61763 01/18 01/22/2018 61763 44 AVENET LLC 42068 1 101-41400-390 OTSEGO WEBSITE REDESIGN 2018 3,640.00 3,640.00 Total 61763: 3,640.00 61764 01/18 01/22/2018 61764 82 BULOW INC 9162KAEDIN 1 701-22410 REFUND PREPAID WAC - 9162 KAEDING AVE NE 2,850.00 2,850.00 Total 61764: 2,850.00 61766 01/18 01/22/2018 61765 113 CITY OF MONTICELLO 0020978 1 101-42710-390 NOV 2017 ANIMAL BOARDING 912.00 912.00 CITY OF OTSEGO Check Register - CLAIMS LIST Page: 2 Check Issue Dates: 1122/2018- 1/22/2018 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount Total 61765: 912.00 61766 01/18 01/22/2018 61766 114 CITY OF OTSEGO 27860 JAN 1 1 602-49450-322 5850 RANDOLPH AVE - E WWTF 456.99 456.99 01118 01/22/2018 61766 114 CITY OF OTSEGO 28030 JAN 1 1 602-49450-322 7551 LANCASTER -WEST WWTF 87.17 87.17 01/18 01/22/2018 61766 114 CITY OF OTSEGO 28040 JAN 1 1 602-49450-322 7551 LANCASTER -WEST WWTF 8.88 8.88 01/18 01/22/2018 61766 114 CITY OF OTSEGO 28050 JAN 1 1 602-49450-322 7551 LANCASTER -WEST W.NTF 207.95 207.95 01/18 01/22/2018 61766 114 CITY OF OTSEGO 28060 JAN 1 1 602-49450-322 7551 LANCASTER -WEST WWTF 411.33 411.33 Total 61766: 1,172.32 61767 01/18 01/22/2018 61767 116 CITY OF ROGERS 0033498 1 101-42200-390 2018 FIRE CONTRACT 37,938.20 37,938.20 Total 61767: 37,938.20 61768 01118 01/22/2018 61768 197 CONSOLIDATED COMMUNICATIONS 737757-0101 1 101-41945-320 JAN 2018 LAND LINE PHONES 407.41 407.41 01/18 01/22/2018 61768 197 CONSOLIDATED COMMUNICATIONS 737757-0101 2 601-49400-320 JAN 2018 LAND LINE PHONES 25.46 25.46 01118 01/22/2018 61768 197 CONSOLIDATED COMMUNICATIONS 737757-0101 3 602-49450-320 JAN 2018 LAND LINE PHONES 76.39 76.39 Total 61768: 509.26 61769 01/18 01/22/2018 61769 1092 CORNERSTONE FORD 15213018 1 101-43240-220 BRAKE LIGHT REPAIR 150.29 150.29 01/18 01/22/2D18 61769 1092 CORNERSTONE FORD 15213532 1 101-43240-220 BRAKE LIGHT REPAIR -RETURN 50.00- 50.00- Total 61769: 100.29 61770 01/18 01/22/2018 61770 810 COUNTRYSIDE SERVICES 1-100409 1 101-43240-220 PLOW REPAIRS 31.99 31.99 Total 61770: 31.99 61771 01/18 01/22/2018 61771 656 DESIGNKW LLC 11.17.17 1 101-45250-350 FLYER AND LOGO DESIGN 350.00 350.00 Total 61771: 350.00 CITY OF OTSEGO Check Register- CLAIMS LIST Check Issue Dates: 1/22/2018 - 1/22/2018 Page: 3 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount 61772 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 1000623 1 101-43100-220 CONTACT CLEANER 31.97 31.97 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100412 1 602-49450-227 GLOVES-SNOWBRUSH 77.90 77.90 01118 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100513 1 101-43100-220 GARDEN HOSE & TAPE 14.78 14.78 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100544 1 101-43240-220 ADAPTER 4.98 4.98 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100591 1 101-43240-220 GALVANIZED ELBOW 15.72 15.72 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100606 1 101-43100-210 IRON OUT 19.16 19.16 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100608 1 101-43100-220 SPRING BRACE 57.96 57.96 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100618 1 101-43100-220 HARDWARE 3.16 3.16 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100628 1 101-43100-220 SUPPLIES 3.22 3.22 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100657 1 101-43100-220 FASTENERS 3.83 3.83 01/18 01/22/2018 61772 168 DJ S TOTAL HOME CENTER 100661 1 101-43100-220 SHOP SUPPLIES 9.10 9.10 Total 61772: 241.78 61773 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 1 101-43240-210 VEHICLE TABS-2017 FORD -VIN 9831 16.00 16.00 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 2 101-43240-210 VEHICLE TABS - 2017 FORD - VIN 9836 16.00 16.00 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 3 101-43240-210 VEHICLE TABS - 2017 FORD - VIN 9837 16.00 16.00 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 4 101-43240-210 VEHICLE TABS -2016 FORD - VIN #3966 16.00 16.00 01118 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 5 101-43240-210 VEHICLE TABS - 2016 FORD - VIN #3944 16.00 16.00 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 6 101-43240-210 VEHICLE TABS-2016 FORD -VIN #3965 16.00 16.00 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 7 101-43240-210 VEHICLE TABS - 2014 MIDS -VIN #1018 16.00 16.00 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 8 101-43240-210 VEHICLE TABS - 2016 FORD - VIN #9940 16.00 16.00 01/18 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 9 101-43240-210 VEHICLE TABS - 2017 MACK- VIN #2457 16.00 16.00 01118 01/22/2018 61773 180 DVS RENEWAL FEB 2018 R 10 101-43240-210 VEHICLE TABS - 2016 MACK- VIN #2447 16.00 16.00 Total $1773: 160.00 61774 01118 01/22/2018 61774 184 ECM PUBLISHERS INC 561287 1 101-41400-350 ADVISORY COMMISSION PUBLICATION 72.00 72.00 01/18 01/22/2018 61774 184 ECM PUBLISHERS INC 562817 1 101-41400-350 PUBLIC HEARING - FLYNN 64.00 64.00 01/18 01/22/2018 61774 184 ECM PUBLISHERS INC 562818 1 101-41400-350 PUBLIC HEARING - FIRST CHOICE BUILDERS 64.00 64.00 Total 61774: 200.00 61775 01/18 01/22/2018 61775 219 FINKEN WATER SOLUTIONS 0001919-010 1 101-41940-210 JAN 2018 WATER 12.16 12.16 01/18 01122/2018 61775 219 FINKEN WATER SOLUTIONS 0001919-010 2 101-41945-210 JAN 2018 WATER 48.64 48.64 01/18 01/22/2018 61775 219 FINKEN WATER SOLUTIONS S203771 1 101-41940-220 WATER SOFTENER REPAIR 150.00 150.00 CITY OF OTSEGO Check Register - CLAIMS LIST Check Issue Dates: 1/22/2018 - 1/22/2018 Page: 4 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount Total 61775: 210.80 61776 01/18 01/22/2018 61776 236 G & K SERVICES 6043134217 1 101-43240-225 UNIFORM - DON/TOWELS 32.90 32,90 01118 01/22/2018 61776 236 G & K SERVICES 6043139958 1 101-43240-225 UNIFORM - DON/TOWELS 32.90 32.90 01/18 01/22/2018 61776 236 G & K SERVICES 6043145739 1 101-43240-225 UNIFORM - DON/TOWELS 32.90 32.90 01/18 01/22/2018 61776 236 G & K SERVICES 6043151474 1 101-43240-225 UNIFORM - DON/TOWELS 44.60 44.60 01118 01/22/2018 61776 236 G & K SERVICES 6043157245 1 101-43240-225 UNIFORM - DON/TOWELS 32.90 32.90 01/18 01/22/2018 61776 236 G & K SERVICES 6043162965 1 101-43240-225 UNIFORM - DON 34.40 34.40 Total 61776: 61777 01/18 01/22/2018 61777 290 HOME DEPOT 25161 01/18 01/22/2018 61777 290 HOME DEPOT 4025622 01/18 01/22/2018 61777 290 HOME DEPOT 974214 Total 61777: 61778 01/18 01/22/2018 61778 1387 INDEPENDENT SCHOOL DISTRICT728 01172018 Total 61778: 61779 01118 01/22/2018 61779 315 JOHN DEERE FINANCIAL P53661 Total 61779: 61780 1 601-49400-240 SHOP SUPPLIES 1 602-49450-240 WRENCH SET -BATTERIES 1 101-41945-220 RETURN PEX PLASTIC WATER -ICE LINE 1 403-43100-510 85TH STREET PROJECT- PARCEL 2 & 3 1 101-43240-210 60" EDGE - SHOE 01/18 01/22/2018 61780 480 LARSON COMPANIES 2504115966 1 101-43240-210 CHIPPER FILTERS Total 61780: 61781 01/18 01/22/2018 61781 1422 LHB INC 170692.00-1 1 701-22467 REDEVELOPMENT TIF REPORT Total 61781: 210.60 175.24 175.24 97.83 97.83 9.99- 9.99- 3,960.00 3,960.00 3,960.00 303.21 303.21 303.21 36.68 36.68 5,900.00 5,900.00 CITY OF OTSEGO Check Register- CLAIMS LIST Page: 5 Check Issue Dates: 1/22/2018- 1/22/2018 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount 61782 01/18 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 1 101-32260 BUILDING PERMIT REFUND 1,986.33 1,986.33 01/18 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 2 101-21801 BUILDING PERMIT REFUND 122.39 122.39 01118 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 3 101-32999 BUILDING PERMIT REFUND 25.00 25.00 01/18 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 4 601-34302 BUILDING PERMIT REFUND 403.00 403.00 01118 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 5 101-21802 BUILDING PERMIT REFUND 29.72 29.72 01/18 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 6 101-32261 BUILDING PERMIT REFUND 330.00 330.00 01/18 01/22/2018 61782 1424 M/1 HOMES OF MINNEAPOLIS 2017-01019 7 101-32262 BUILDING PERMIT REFUND 355.00 355.00 01/18 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 8 361-34407 BUILDING PERMIT REFUND 7,147.00 7,147.00 01/18 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 9 360-34406 BUILDING PERMIT REFUND 1,663.00 1,663.00 01/18 01/22/2018 61782 1424 M/I HOMES OF MINNEAPOLIS 2017-01019 10 101-34330 BUILDING PERMIT REFUND 150.00 150.00 Total 61782: 12,211.44 61783 01/18 01/22/2018 61783 392 MENARDS 48927 1 101-43100-220 MAILBOX REPAIRS 78.17 78.17 01/18 01/22/2018 61783 392 MENARDS 49064 1 101-41940-210 PAINTING SUPPLIES 475.04 475.04 01/18 01/22/2018 61783 392 MENARDS 49347 1 101-41945-220 BUILDING REPAIRS 41.95 41.95 01118 01/22/2018 61783 392 MENARDS 49351 1 101-41945-220 BUILDING REPAIRS 86.82 86.82 01/18 01/22/2018 61783 392 MENARDS 49391 1 101-45200-220 MISC PRAIRIE CENTER SUPPLIES 78.17 78.17 01/18 01/22/2018 61783 392 MENARDS 49446 1 601-49400-240 SHOP SUPPLIES 340.84 340.84 01/18 01/22/2018 61783 392 MENARDS 49446 2 602-49450-240 SHOP SUPPLIES 340.84 340.84 01/18 01/22/2018 61783 392 MENARDS 49522 1 601-49400-240 PLIERS -GREASE GUN 65.45 65.45 Total 61783: 1,507.28 61784 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50520 1 601-49400-355 2018 MMUA DUES 113.00 113.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50520 2 602-49450-355 2018 MMUA DUES 339.00 339.00 01118 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 1 101-41320-360 QTR 1 2018 SAFETY PROGRAM 41.00 41.00 01/18 01/22/2013 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 2 101-41400-360 QTR 12018 SAFETY PROGRAM 69.00 69.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 3 101-41600-360 QTR 1 2018 SAFETY PROGRAM 38.00 38.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 4 101-42410-360 QTR 1 2018 SAFETY PROGRAM 25.00 25.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 5 101-43100-360 QTR 1 2018 SAFETY PROGRAM 1,660.00 1,660.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 6 101-43240-360 QTR 12018 SAFETY PROGRAM 112.00 112.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 7 101-45200-360 QTR 12018 SAFETY PROGRAM 417.00 417.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 8 101-45250-360 QTR 1 2018 SAFETY PROGRAM 148.00 148.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 9 601-49400-360 QTR 1 2018 SAFETY PROGRAM 160.00 160.00 01/18 01/22/2018 61784 421 MINNESOTA MUNICIPAL UTILITIES ASSOC 50625 10 602-49450-360 QTR 1 2018 SAFETY PROGRAM 480.00 480.00 CITY OF OTSEGO Check Register - CLAIMS LIST Page: 6 Check Issue Dates: 1/22/2018 - 1/22/2018 Jan 18, 2018 11:49AM GL Check Check Vendor Period Issue Date Number Number Payee Invoice Inv Invoice Number Seq GLAccount Description Invoice Check Amount Amount Total 61784: 61785 01118 01J22/2018 61785 435 NAPA OF ELK RIVER INC 040312 1 101-43240-220 VEHICLE REPAIR SUPPLIES 01/18 01/22/2018 61785 435 NAPA OF ELK RIVER INC 940839 1 101-43240-220 VEHICLE REPAIR SUPPLIES 01/18 01/22/2018 61785 435 NAPA OF ELK RIVER INC 940898 1 101-43240-220 VEHICLE REPAIR SUPPLIES 01/18 01/22/2018 61785 435 NAPA OF ELK RIVER INC 941442 1 101-43240-220 VEHICLE REPAIR SUPPLIES Total 61785: 61786 01/18 01/22/2018 61786 441 NELSON ELECTRIC MOTOR REPAIR 8392 1 602-49450-390 GMH LIFT STATION REPAIR Total 61786: 61787 01118 01/22/2018 61787 705 NORTHLAND REFRIGERATION AND POWE 6575 1 101-41940-390 ANNUAL HVAC MAINTENANCE -PRAIRIE CENTER 01/18 01/22/2018 61787 705 NORTHLAND REFRIGERATION AND POWE 6579 1 101-41940-220 FURNACE FAN REPAIR -ICE RINK SHELTER Total 61787: 61788 01118 01/22/2018 61788 451 NORTHLAND SECURITIES 5159 1 375-47000-620 2017 CONTINUING DISCLOSURE 01/18 01/22/2018 61788 451 NORTHLAND SECURITIES 5159 2 380-47000-620 2017 CONTINUING DISCLOSURE 01/18 01/22/2018 61788 451 NORTHLAND SECURITIES 5159 3 385-47000-620 2017 CONTINUING DISCLOSURE 01/18 01/22/2018 61788 451 NORTHLAND SECURITIES 5159 4 399-47000-620 2017 CONTINUING DISCLOSURE 01/18 01/22/2018 61788 451 NORTHLAND SECURITIES 5159 5 360-47000-620 2017 CONTINUING DISCLOSURE 01/18 01/22/2018 61788 451 NORTHLAND SECURITIES 5159 6 361-47000-620 2017 CONTINUING DISCLOSURE Total 61788: 61789 01/18 01/22/2018 61789 454 NOVA COMMUNICATIONS 00001554 D 1 414-41945-525 NEW PHONE SYSTEM SETUP & INITIAL CHARGES 01/18 01/22/2018 61789 454 NOVA COMMUNICATIONS 00001554 JA 1 101-41945-320 JAN 2018 NOVA PHONE SERVICE 01/18 01/22/2018 61789 454 NOVA COMMUNICATIONS 00001554 JA 2 601-49400-320 JAN 2018 NOVA PHONE SERVICE 01/18 01/22/2018 61789 454 NOVA COMMUNICATIONS 00001554 JA 3 602-49450-320 JAN 2018 NOVA PHONE SERVICE 01/18 01/22/2018 61789 454 NOVA COMMUNICATIONS 119007 1 414-41945-525 PHONE HARDWARE UPGRADE 3,602.00 17.49 17.49 55.74 55.74 26.67 26.67 102.19 102.19 202.09 250.00 250.00 250.00 505.00 505.00 1,363.47 1,363.47 1,868.47 357.14 357.14 714.28 714.28 357.14 357A4 357.14 357.14 357.14 357.14 357.16 357.16 2,500.00 1,046.28 454.40 28.40 85.20 6,248.00 1,046.28 454.40 28.40 85.20 6,248.00 CITY OF OTSEGO Check Register- CLAIMS LIST Check Issue Dates: 1/22/2018 - 1/22/2018 Page: 7 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount Total 61789: 7,862.28 61790 01/18 01/22/2018 61790 1213 OFFICE DEPOT 9925051620 1 101-41400-201 OFFICE SUPPLIES 41.40 41.40 01118 01/22/2018 61790 1213 OFFICE DEPOT 99361170900 1 101-43100-201 PW SUPPLIES 16.62 16.62 01/18 01/22/2018 61790 1213 OFFICE DEPOT 99361170900 2 101-41400-201 ADMIN SUPPLIES 32.99 32.99 01/18 01/22/2018 61790 1213 OFFICE DEPOT 99361187600 1 101-41400-201 BINDERS 15.59 15.59 Total 61790: 106.60 61791 01/18 01/22/2018 61791 500 RANDY'S ENVIRONMENTAL SERVICES 121917 1 101-41940-325 8899 NASHUAAVE NE 96.27 96.27 01/18 01/22/2018 61791 500 RANDY'S ENVIRONMENTAL SERVICES 121917 2 101-41940-325 8899 NASHUAAVE NE 16.29 16.29 01/18 01/22/2013 61791 500 RANDY'S ENVIRONMENTAL SERVICES 121917 3 101-41945-325 13400 90TH ST NE 737,05 737.05 01/18 01/22/2018 61791 500 RANDY'S ENVIRONMENTAL SERVICES 121917 4 602-49450-325 7551 LAN CASTER AVE N E 462.46 462.46 01118 01/22/2018 61791 500 RANDY'S ENVIRONMENTAL SERVICES 121917 5 602-49450-325 5850 RANDOLPH AVE NE 237.51 237.51 Total 61791: 1,549.58 61792 01/18 01/22/2018 61792 512 RICOH USA INC 5051882772 1 101-41945-410 RECEPT AREA -MAIN FLOOR-ADDT'L COPIES DE 9.16 Total 61792: 61793 01118 01/22/2018 61793 1330 RITEWAY BUSINESS FORMS 17-34162 1 101-41600-201 AP CHECK STOCK 270.21 Total 61793: 61794 01/18 01/22/2018 61794 550 SHERWIN-WILLIAMS CO. 7294-3 1 101-41940-220 PRAIRIE CENTER PAINT 172.57 01/18 01/22/2018 61794 550 SHERWIN-WILLIAMS CO. 7726-0 1 101-41940-220 PRAIRIE CENTER PAINT 302.20 01/18 01/22/2018 61794 550 SHERWIN-WILLIAMS CO. 7917-5 1 101-41940-220 PAINT FOR PRAIRIE CENTER 30.30 01118 01/22/2018 61794 550 SHERWIN-WILLIAMS CO. 7954-8 1 101-41940-220 PAINT FOR BUILDING 44.55 Total 61794: 61795 01/18 01/22/2018 61795 1232 SMALL, ROBERT 01042018 1 601-49400-360 CERTIFICATION RENEWAL -WATER & WASTEWATE 23.00 9.16 9.16 270.21 270.21 172.57 302.20 30.30 44.55 549.62 23.00 CITY OF OTSEGO Check Register- CLAIMS LIST Check Issue Dates: 1/22/2018 - 1/22/2018 Page: 8 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount 01/18 01/22/2018 61795 1232 SMALL, ROBERT 01042018 2 602-49450-360 CERTIFICATION RENEWAL -WATER & WASTEWATE 23.00 23.00 Total 61795: 46.00 61796 01/18 01/22/2018 61796 948 SNAP -ON TOOLS - IL 11061764027 1 101-43240-240 SHOP TOOLS 77.50 77.50 Total 61796: 77.50 61797 01/18 01/22/2018 61797 556 SOFTRONICS INC. 2491 1 101-41650-390 DEC 2017 -IT SERVICES 3,025.00 3,025.00 01118 01/22/2018 61797 556 SOFTRONICS INC. 2491 2 101-41650-210 DEC 2017- IT SERVICES 133.87 133.87 01/18 01/22/2018 61797 556 SOFTRONICS INC. 2491 3 101-41650-501 DEC 2017 - IT SERVICES 189,99 189.99 Total 61797: 3,348.86 61798 01/18 01/22/2018 61798 87 TEGRETE 72500 1 101-41945-210 SUPPLIES -PAPER TOWELS/BATH TISSUE 109.64 109.64 01118 01/22/2018 61798 87 TEGRETE 72585 1 101-41945-389 JAN CLEANING 2018 825.00 825.00 Total 61798: 934.64 61799 01/18 01/22/2018 61799 592 THE UPS STORE #5093 144 1 101-45200-210 RETURN ON LIGHT FOR SKATING SHELTER 29.20 29.20 Total 61799: 29.20 61800 01118 01/22/2018 61800 609 TRACTOR SUPPLY CREDIT PLAN 100306198 1 602-49450-220 RUBBER STALL MATS 214.95 214.95 Total 61800: 214.95 61801 01118 01/22/2018 61801 997 TWIN CITIES AIR CLEANING SPECIALISTS] 12941 1 602-49450-220 FILTERS 237.33 237.33 Total 61801: 237.33 61802 01/18 01/22/2018 61802 620 ULINE ING. 93545456 1 101-41940-210 CLEANING SUPPLIES 906.01 906.01 CITY OF OTSEGO Check Register- CLAIMS LIST Page: 9 Check Issue Dates: 1122/2018- 1/22/2018 Jan 18, 2018 11:49AM GL Check Check Vendor Invoice Inv Invoice Description Invoice Check Period Issue Date Number Number Payee Number Seq GLAccount Amount Amount Total 61802: 906.01 61803 01/18 01/22/2018 61803 626 US BANK- VISA 01022018 1 101-41940-210 LIGHT BULBS 25.95 25.95 01/18 01/22/2018 61803 626 US BANK -VISA 01032018 1 101-45200-360 GREENS EXPO 135.00 135.00 01/18 01/22/2018 61803 626 US BANK- VISA 01032018 2 101-43100-360 GREENS EXPO 270.00 270.00 01/18 01/22/2018 61803 626 US BANK- VISA 050307 1 101-45250-445 SENIOR BINGO GIFT CARDS 100.00 100.00 01/18 01/22/2018 61803 626 US BANK- VISA 1 1 101-45250-445 LUNCH FOR COMPASS GROUP 119.71 119.71 01/18 01/22/2018 61803 626 US BANK- VISA 1049026032 1 101-41940-210 PORTABLE PROJECTOR SCREEN 83.99 83.99 01/18 01/22/2018 61803 626 US BANK- VISA 112-4372129 1 101-43240-240 LED LIGHT BARS FOR TRACTORS 149.66 149.66 01/18 01/22/2018 61803 626 US BANK -VISA 113-1675474 1 101-43100-210 BRINE HYDROMETER 38.33 33.33 01/18 01/22/2018 61803 626 US BANK- VISA 113-8433190 1 101-43100-240 CHAINSAW REPAIR 24.40 24.40 01/18 01/22/2018 61803 626 US BANK -VISA 120517 1 101-41100-360 2017 ADVISORY COMMISSION DINNER 800.00 800.00 01/18 01/22/2018 61803 626 US BANK- VISA 120517 2 101-41400-201 2017ADVISORY COMMISSION DINNER 131.23 131.23 01/18 01/22/2018 61803 626 US BANK- VISA 1207-JB-BKO 1 101-41100-360 ADVISORY COMMISSIONER DINNER 172.78 172.78 01118 01/22/2018 61803 626 US BANK- VISA 120817 1 101-41400-201 UPS- CODIFICATION PROJECT RETURN 34.60 34.60 01/18 01/22/2018 61803 626 US BANK- VISA 12082017 1 101-41100-360 EMPLOYEE RECOGNITION LUNCHEON SUPPLIES 16.03 16.03 01118 01/22/2018 61803 626 US BANK- VISA 121117 1 101-41100-360 SUPPLIES FOR EMPLOYEE LUNCHEON 80.30 80.30 01/18 01/22/2018 61803 626 US BANK -VISA 12272017 1 101-45250-201 ADOBEACROPRO 26.83 26.83 01/18 01/22/2018 61803 626 US BANK -VISA 12302017 1 101-43100-210 AMAZON PRIME MEMBERSHIP 10.99 1D.99 01/18 01/22/2018 61803 626 US BANK- VISA 1321.3046.7 1 101-41320-360 1-94 STATE OF CITIES REGISTRATION 50.00 50.00 01/18 01/22/2018 61803 626 US BANK- VISA 141130205 1 101-45250-445 SENIOR BINGO GIFT CARDS 100.00 100.00 01/18 01/22/2018 61803 626 US BANK- VISA 18946 1 101-41940-210 BROCHURE HOLDERS 97.89 97.89 01/18 01/22/2018 61803 626 US BANK- VISA 18959087 1 601-49400-360 MINNESOTA RURAL WATER 230.00 230.00 01/18 01/22/2018 61803 626 US BANK- VISA 28917839 1 101-41940-210 BROCHURE HOLDERS 105.69 105.69 01/18 01/22/2018 61803 626 US BANK- VISA 3073547022 1 101-41940-210 CLEANING SUPPLIES FOR PRAIRIE CENTER 63.06 63.06 01/18 01/22/2018 61803 626 US BANK- VISA 41631 1 101-43240-220 BRINE VALVE REPAIR 53.22 53.22 01/18 01/22/2018 61803 626 US BANK -VISA 525910 1 101-41600-360 GFOAWEBINAR-ADAM 135.00 135.OD 01118 01/22/2018 61803 626 US BANK- VISA 55 1 101-45250-445 SANTA DAY SUPPLIES 329.15 329.15 01/18 01/22/2018 61803 626 US BANK- VISA 5873547062 1 101-45250-210 TOYS FOR TOT TIME 36.85 36.85 01/18 01/22/2018 61803 626 US BANK- VISA 657626 1 101-41940-210 HANDICAP SIGNAGE FRONT DOOR 53.50 53.50 01118 01/22/2018 61803 626 US BANK- VISA 7353000000 1 414-41940-525 PRAIRIE CENTER AA/ PROJECTOR 848.00- 848.00- 01/18 01/22/2018 61803 626 US BANK- VISA 7354-2456-0 1 101-45250-445 SENIOR BINGO GIFT CARDS 200.00 200.00 01/18 01/22/2018 61803 626 US BANK- VISA 985206 1 101-45250-445 SENIOR BINGO GIFT CARDS 100.00 100.00 01/18 01/22/2018 61803 626 US BANK -VISA MNQBOA00 1 101-41600-360 2018 CPA LICENSE -ADAM 101.50 101.50 Total 61803: 3,027.66 CITY OF OTSEGO Check Register - CLAIMS LIST Page: 10 Check Issue Dates: 1/22/2018 - 1/22/2018 Jan 18, 2018 11:49AM GL Check Period Issue Date Check Number Vendor Number Payee Invoice Number Inv Seq Invoice GLAccount Description Invoice Amount Check Amount 61804 01118 01/22/2018 61804 636 VERIZON WIRELESS 9799002168 1 101-43240-320 JAN 2018 CELL PHONES/TABLETS 51.58 51.58 01/18 01/22/2018 61804 636 VERIZON WIRELESS 97990D2168 2 101-45200-320 JAN 2018 CELL PHONES/TABLETS 164.74 164.74 01/18 01/22/2018 61804 636 VERIZON WIRELESS 9799002168 3 101-45250-320 JAN 2018 CELL PHONES/TABLETS 51.58 51.58 01/18 01/22/2018 61804 636 VERIZON WIRELESS 9799002168 4 101-43100-320 JAN 2018 CELL PHONES/TABLETS 352.49 352.49 01/18 01/22/2018 61804 636 VERIZON WIRELESS 9799002168 5 101-43100-32D JAN 2018 CELL PHONES/TABLETS 329.25 329.25 01118 01/22/2018 61804 636 VERIZON WIRELESS 9799002168 6 101-41100-320 JAN 2018 CELL PHONES/TABLETS 175.05 175.05 01/18 01/22/2018 61804 636 VERIZON WIRELESS 9799002168 7 101-41400-320 JAN 2018 CELL PHONES/TABLETS 51.58 51.58 01/18 01/22/2018 61804 636 VERIZON WIRELESS 9799002168 8 101-41320-320 JAN 2018 CELL PHONES/TABLETS 51.58 51.58 Total 61804: 1,227.85 61805 01/18 01/22/2018 61805 646 WAGE WORKS INC 477092 1 101-41600-390 DEC 2017 - FLEX ADMIN 27.42 27.42 01/18 01/22/2018 61805 646 WAGE WORKS INC 477101 1 101-41600-390 DEC 2017 - FLEX ADMIN 50.58 50.58 Total 61805: 78.00 61806 01/18 01/22/2018 61806 665 WRIGHT COUNTY AUDITOR -TREASURER 86 NOV 17 R 1 101-42100-310 NOV 2017 COURT FINES 1,689.79 1,689.79 01/18 01/22/2018 61806 665 WRIGHT COUNTY AUDITOR -TREASURER DEC 2D17 1 101-42100-310 DEC 2017 COURT FINES 2,389.72 2,389.72 01/18 01/22/2018 61806 665 WRIGHT COUNTY AUDITOR-TREASU RER JANUARY 2 101-42100-390 JAN 2018 SHERIFF CONTRACT 96,360.00 96,360.00 Total 61806: 100,439.51 61807 01/18 01/22/2018 61807 672 XCEL ENERGY 575109028 1 101-45200-322 8899 NASHUA AVE STREET LIGHTS 234.73 234.73 01/18 01/22/2018 61807 672 XCEL ENERGY 576133813 1 101-43160-322 STREET LIGHTS 32.96 32.96 01/18 01/22/2018 61807 672 XCEL ENERGY 576158022 1 101-45200-322 5400 RANDOLPH - PARK 223.14 223.14 Total 61807: 490.83 Grand Totals: 208,352.48 Summary by General Ledger Account Number CITY OF OTSEGO Check Register- CLAIMS LIST Page: 11 Check Issue Dates: 1122/2018 - 1/22/2018 Jan 18, 2018 11:49AM GLAccount Debit Credit Proof 101-20200 59.99 167,378.67- 167,318.68- 101-21801 122.39 .00 122.39 101-21802 29.72 .00 29.72 101-32260 1,986.33 .00 1,986.33 101-32261 330.00 .00 330.00 101-32262 355.00 .00 355.00 101-32999 25.00 .00 25.00 101-34330 150.00 .00 150.00 101-41100-320 175.05 .00 175.05 101-41100-360 1,069.11 .00 1,069.11 101-41320-320 51.58 .00 51.58 101-41320-360 91.00 .00 91.00 101-41400-201 255.81 .00 255.81 101-41400-320 51.58 .00 51.58 101-41400-350 200.00 .00 200.00 101-41400-360 69.00 .00 69.00 101-41400-390 3,640.00 .00 3,640.00 101-41600-201 270.21 .00 270.21 101-41600-360 274.50 .00 274.50 101-41600-390 78.00 .00 78.00 101-41650-210 133.87 .00 133.87 101-41650-390 3,025.00 .00 3,025.00 101-41650-501 189.99 .00 189.99 101-41940-210 1,823.29 .00 1,823.29 101-41940-220 2,063.09 .00 2,063.09 101-41940-325 112.56 .00 112.56 101-41940-390 505.00 .00 505.00 101-41945-210 158.28 .00 158.28 101-41945-220 128.77 9.99- 118.78 101-41945-320 861.91 .00 861.81 101-41945-325 737.05 .00 737.05 101-41945-389 825.00 .00 825.00 101-41945-410 9.16 .00 9.16 101-42100-310 4,079.51 .00 4,079.51 101-42100-390 96,360.00 .00 96,360.00 101-42200-390 37,938.20 .00 37,938.20 101-42410-360 25.00 .00 25.00 101-42710-390 912.00 .00 912.00 101-43100-201 16.62 .00 16.62 101-4310 0-210 128.28 .00 128.28 101-43100-220 202.19 .00 202.19 CITY OF OTSEGO Check Register - CLAIMS LIST Check Issue Dates: 1/22/2018 - 1/22/2018 GLAccount Debit Credit Proof 101-43100-240 24.40 .00 24.40 101-43100-320 681.74 .00 681.74 101-43100-360 1,930.00 .00 1,930.00 101-43160-322 32.96 .00 32.96 101-43240-210 499.89 .00 499.89 101-43240-220 458.29 50.00- 408.29 101-43240-225 210.60 .00 210.60 101-43240-240 227.16 .00 227.16 101-43240-320 51.58 .00 51.58 101-43240-360 112.00 .00 112.00 101-43240-390 583.00 .00 583.00 101-45200-210 29.20 .00 29.20 101-45200-220 78.17 .00 78.17 101-45200-320 164.74 .00 164.74 101-45200-322 457.87 .00 457.87 101-45200-360 552.00 .00 552.00 101-45200-390 224.00 .00 224.00 101-45250-201 26.83 .00 26.83 101-45250-210 36.85 .00 36.85 101-45250-320 51.58 .00 51.58 101-45250-350 350.00 .00 350.00 101-45250-36 0 148.00 .00 148.00 101-45250-390 40.00 .00 40.00 101-45250-445 948.86 .00 948.86 360-20200 .00 2,020.14- 2,020.14- 360-34406 1,663.00 .00 1,663.00 360-47000-620 357.14 .00 357.14 361-20200 .00 7,504.16- 7,504.16- 361-34407 7,147.00 .00 7,147.00 361-47000-620 357.16 .00 357.16 375-2020D .00 357.14- 357.14- 375-47000-620 357.14 .00 357.14 380-20200 .00 714.28- 714.28- 380-47000-620 714.28 .00 714.28 385-20200 .00 357.14- 357.14- 385-47000-620 357.14 .00 357.14 399-20200 .00 357.14- 357.14- 399-47000-620 357.14 .00 357.14 403-20200 .00 3,960.00- 3,960.00- 403-43100-510 3,960.00 .00 3,960.00 414-20200 $48.00 7,294.28- 6,446.28- Page: 12 Jan 18, 2018 11:49AM CITY OF OTSEGO Check Register- CLAIMS LIST Check Issue Dates: 1/22/2018 - 1/22/2018 GLAccount Debit Credit Proof 414-41940-525 .00 848.00- 848.00- 414-41945-525 7,294.28 .00 7,294.28 601-20200 .00 4,151.15- 4,151.15- 601-34302 403.00 .00 403.00 601-49400-240 581.53 .00 581.53 601-49400-302 2,586.76 .00 2,586.76 601-49400-320 53.86 .00 53.86 601-49400-355 113.00 .00 113.00 601-49400-360 413.00 .00 413.00 602-20200 .00 6,416.37- 6,416.37- 602-49450-220 452.28 .00 452.28 602-49450-227 77.90 .00 77.90 602-49450-240 438.67 .00 438.67 602-49450-302 421.64 .00 421.64 602-49450-320 161.59 .00 161.59 602-49450-322 1,172.32 .00 1,172.32 602-49450-325 699.97 .00 699.97 602-49450-355 339.00 .00 339.00 602-49450-360 503.00 .00 503.00 602-49450-390 2,150.00 .00 2,150.00 701-20200 .00 8,750.00- 8,750.00- 701-22410 2,850.00 .00 2,850.00 701-22467 5,900.00 .00 5,900.00 Grand Totals: 210,168.46 210,168.46- .00 Report Criteria: Reporttype: GL detail Check.Type = {<>} "void" Page: 13 Jan 18, 2018 11:49AM