HomeMy WebLinkAbout5A - Claims Listing 0� PRIO('" +P
U 4646 Dakota Street SE
Prior Lake. MN 55372
CITY COUNCIL AGENDA REPORT
MEETING DATE: DECEMBER 8, 2014
AGENDA#: 5A
PREPARED BY: JANET RINGBERG, ACCOUNTING SPECIALIST
PRESENTED BY: JERILYN ERICKSON, FINANCE DIRECTOR
AGENDA ITEM: CONSIDER APPROVAL OF CLAIMS LISTING
DISCUSSION: Introduction
The purpose of this agenda item is to provide the City Council with a listing of in-
voices that have been paid within a specific time period.
History
Staff has provided a claims listing from the UST legacy financial software in the
Scheduled Invoice Summary format which was a listing of invoices paid by the
department for which they were expensed. In addition, manual descriptions were
handwritten for the invoices over$1,000.00.
Current Circumstances
The claims listing from our new BS&A software has a new look. It shows payments
made for each Fund and Department. In addition, it includes the account charged,
the vendor paid, a general description of the invoice, invoice number and amount of
the invoice. It covers payments made by check, ACH, wire and EFT.
Councilmembers are welcome to call or e-mail Finance Director Erickson (952-447-
9841) or City Manager Boyles (952-447-9801) before the meeting if there are any
questions.
An Invoice GL Distribution Report has been attached for the following claims period:
Claims Period 11/15/14— 11/30/14
Claims Paid $1,455,825.15
Conclusion
The Council should consider approving the attached report on claims paid as part of
the consent agenda.
Phone 952.447.9800 / Fax 952.447.4245/www.cityofpriorlake.com
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 1/10 c A
User: Janet POST DATES 11/15/2014 - 11/30/2014 cJ
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund 101 GENERAL FUND
Dept 00000.00 GENERAL
101-00000.00-21714.00 2014 HRA Reimbursement ALLIANCE BENEFIT GROUP 2014 HRA Reimbursement 188.16 808
Total For Dept 00000.00 GENERAL 188.16
Dept 41110.00 MAYOR & COUNCIL
101-41110.00-53310.10 10/13/2014 Council work session LUND FOOD HOLDINGS INC 10/13/2014 Council work session dinne 124.44 92502
101-41110.00-53310.10 10/27/2014 Council work session THE POINTE 10/27/2014 Council work session dinne 178.17 92502
101-41110.00-53310.10 City Council Dinner 11/24/2014 FONG'S City Council Dinner 11/24/2014 840.00 92524
Total For Dept 41110.00 MAYOR & COUNCIL 1,142.61
Dept 41320.00 ADMINISTRATION
101-41320.00-52010.00 Flemming, Peterson name plates EXECUTIVE OCEAN Flemming, Peterson name plates 61.20 92448
101-41320.00-53310.10 Coffee CARIBOU COFFEE Coffee 38.44 92502
101-41320.00-53310.10 Donuts - staff recognition EDELWEISS BAKERY Donuts - staff recognition 13.75 92502
101-41320.00-53310.10 SCALE refreshments LUND FOOD HOLDINGS INC SCALE refreshments 102.95 92502
Total For Dept 41320.00 ADMINISTRATION 216.34
Dept 41330.00 BOARDS & COMMISSIONS
101-41330.00-53310.10 10/27/2014 Agenda Review KH, MM ARTISAN COFFEE BISTRO 10/27/2014 Agenda Review KH, MM, FB 40.20 92502
Total For Dept 41330.00 BOARDS & COMMISSIONS 40.20
Dept 41520.00 FINANCE
101-41520.00-54310.00 Ringberg annual membership SAM'S CLUB Recreation supplies 45.00 92487
Total For Dept 41520.00 FINANCE 45.00
Dept 41820.00 HUMAN RESOURCES
101-41820.00-54320.00 Oct HRA fees ALLIANCE BENEFIT GROUP Oct HRA fees 227.50 808
101-41820.00-54320.00 Nov HSA fees ALLIANCE BENEFIT GROUP Nov HSA fees 288.00 816
101-41820.00-54320.00 Nov 2014 admin fees SELECT ACCOUNT Nov 2014 admin fees 122.31 812
Total For Dept 41820.00 HUMAN RESOURCES 637.81
Dept 41830.00 COMMUNICATIONS
101-41830.00-53520.00 Big Fish lifestyle guide SOUTHWEST NEWSPAPERS Big Fish lifestyle guide 374.00 92491
101-41830.00-53520.00 Nov Wavelength delivery to City CASH CYCLE SOLUTIONS INC Nov UB mailing - Past dues, Finals 29.90 92427
101-41830.00-53520.00 2040 Vision and Strategic Plan CREATIVE GRAPHICS 2040 vision and Strategic Plan docume 2,091.46 92517
101-41830.00-54320.00 Oct drug testing FIRST ADVANTAGE LNC OCC Oct drug testing 266.00 92450
Total For Dept 41830.00 COMMUNICATIONS 2,761.36
Dept 41920.00 INFORMATION TECHNOLOGY
101-41920.00-53100.80 ERP Project Management Consulta BERRY DUNN ERP Project Management Consultant 4,732.00 92422
101-41920.00-53100.80 Data Conversion for UST COMPUTER INTEGRATION TEC Data Conversion for UST 1,560.00 92515
101-41920.00-53210.00 11/05/2014 - 12/04/2014 INTEGRA TELECOM 11/05/2014 - 12/04/2014 59.95 809
101-41920.00-54030.00 Repair Ricoh 5000C - parts & la RICOH USA Repair Ricoh 5000C 1,149.11 92483
Total For Dept 41920.00 INFORMATION TECHNOLOGY 7,501.06
Dept 41940.00 FACILITIES - CITY HALL
101-41940.00-52200.02 Boot Brush CHASEBURG MANUFACTURING Boot Brush 45.95 92502
101-41940.00-52200.02 Downtown building repair suppli CARLSON HARDWARE COMPANY Misc Supplies 96.85 92426
101-41940.00-52200.02 Misc repair parts NAPA AUTO PARTS October 2014 Statement 60.54 92475
101-41940.00-52200.02 Bldg repair supplies PRIOR LAKE HARDWARE Misc supplies 42.24 92481
101-41940.00-53210.00 11/05/2014 - 12/04/2014 INTEGRA TELECOM 11/05/2014 - 12/04/2014 1,361.29 809
101-41940.00-54010.02 Service - Trouble Call MINNESOTA ELEVATOR INC Service - Trouble Call 474.00 92472
101-41940.00-54010.02 Flowers Naturally Lighting HAYES ELECTRIC INC Electrical Repairs 311.88 92460
101-41940.00-54010.05 2015 Carpet Cleaning City Hall COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 1,840.71 92434
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 2/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund 101 GENERAL FUND
Dept 41940.00 FACILITIES - CITY HALL
101-41940.00-55560.00 Trash Cans for City Hall ULINE Trash Cans for City Hall 442.05 92499
Total For Dept 41940.00 FACILITIES - CITY HALL 4,675.51
Dept 42100.00 POLICE
101-42100.00-52051.00 Oct 2014 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 149.66 811
101-42100.00-52200.01 Radar calibration & certifcatio TACTICAL SOLUTIONS Radar calibration & certifcation 550.00 92540
101-42100.00-52200.01 Marking paint CARLSON HARDWARE COMPANY Misc Supplies 36.94 92426
101-42100.00-52200.02 Electrical repair parts CARLSON HARDWARE COMPANY Misc Supplies 81.46 92426
101-42100.00-52200.02 Misc repair parts NAPA AUTO PARTS October 2014 Statement 9.59 92475
101-42100.00-53100.80 10/01/2014 - 10/31/2014 WEST PAYMENT CENTER 10/01/2014 - 10/31/2014 151.54 92545
101-42100.00-53210.00 11/05/2014 - 12/04/2014 INTEGRA TELECOM 11/05/2014 - 12/04/2014 182.32 809
101-42100.00-53310.10 Fuel for training - city vehicl STANGER, JOHN J Fuel for training - city vehicle 15.00 806
101-42100.00-53310.10 Griffin - Pursuit refresher 11/ DAKOTA CTY TECH COLLEGE Griffin - Pursuit refresher 11/3/14 225.00 92437
101-42100.00-53310.10 Kuecker - evidence training INT'l ASSN FOR PROPERTY Kuecker - evidence training 325.00 92463
101-42100.00-53310.10 Meeting refreshments PETTY CASH Petty cash reimbursemnt 28.21 92480
101-42100.00-54010.02 PD Service - Bad Heating Actuat YALE MECHANICAL INC PD Service - Bad Heating Actuator on 809.06 92507
101-42100.00-54010.02 Office Lights PD HAYES ELECTRIC INC Electrical Repairs 320.00 92460
101-42100.00-54010.04 Shredding FIRST-SHRED LLC Shredding 58.00 92451
101-42100.00-54010.05 2015 Carpet Cleaning PD COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 87.66 92434
101-42100.00-54060.00 12/7/14 - 1/6/15 RICOH USA INC Rent - MPC3501 323.00 92484
Total For Dept 42100.00 POLICE 3,352.44
Dept 42200.00 FIRE
101-42200.00-52010.00 Laminating roll PETTY CASH Petty cash reimbursemnt 6.04 92480
101-42200.00-52050.00 Glass cleaner A SCHOMMER GLASS INC Glass cleaner 42.00 92414
101-42200.00-52050.00 1 Water softener salt COMMERS THE WATER COMPAN 1 Water softener salt 8.95 92435
101-42200.00-52050.00 6 Water softener salt COMMERS THE WATER COMPAN 6 Water softener salt 43.70 92435
101-42200.00-52050.00 LP gas TRACTOR SUPPLY CREDIT PL Misc supplies 7.77 92497
101-42200.00-52050.00 Plyers CARLSON HARDWARE COMPANY Misc Supplies 31.98 92426
101-42200.00-52050.00 Cement, duct tape PRIOR LAKE HARDWARE Misc supplies 33.46 92481
101-42200.00-52051.00 Oct 2014 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 33.04 811
101-42200.00-52200.02 Plunger CARLSON HARDWARE COMPANY Misc Supplies 11.65 92426
101-42200.00-52400.10 2.5 inch hose MES INC Fire Hose 5,273.54 92529
101-42200.00-53210.00 11/05/2014 - 12/04/2014 INTEGRA TELECOM 11/05/2014 - 12/04/2014 322.60 809
101-42200.00-53210.00 11/07/2014 - 12/06/2014 CENTURY LINK 11/07/2014 - 12/06/2014 264.34 92513
101-42200.00-53310.10 Tow 4 cars to FS #1 ALLEN'S SERVICE INC Tow 4 cars to FS #1 600.00 92512
101-42200.00-53810.00 Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 779.27 810
101-42200.00-54010.02 25 Water softener salt TRACTOR SUPPLY CREDIT PL Misc supplies 144.75 92497
101-42200.00-54010.05 2015 Carpet Cleaning FS#2 COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 244.13 92434
101-42200.00-54010.05 2015 Carpet Cleaning FS #1 COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 878.06 92434
101-42200.00-55570.00 Motorola XTS 2500 Radios and eq MOTOROLA Motorola XTS 2500 Radios and equipmen 7,340.88 92531
Total For Dept 42200.00 FIRE 16,066.16
Dept 42400.00 BUILDING INSPECTION
101-42400.00-52051.00 Oct 2014 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 6.80 811
101-42400.00-52400.10 Tape measure CARLSON HARDWARE COMPANY Misc Supplies 13.99 92426
101-42400.00-53310.10 Baumgartner - code seminar MN DEPT OF LABOR & INDUS Baumgartner - code seminar 85.00 92502
101-42400.00-53310.10 Baumgartner - code seminar MN DEPT OF LABOR & INDUS Baumgartner - code seminar 85.00 92502
101-42400.00-53310.10 Hutchins - code seminar MN DEPT OF LABOR & INDUS Hutchins - code seminar 85.00 92502
101-42400.00-53310.10 Hutchins, Chard - code seminar MN DEPT OF LABOR & INDUS Hutchins, Chard - code seminar 170.00 92502
Total For Dept 42400.00 BUILDING INSPECTION 445.79
Dept 42500.00 EMERGENCY MANAGEMENT
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 3/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund 101 GENERAL FUND
Dept 42500.00 EMERGENCY MANAGEMENT
101-42500.00-53810.00 Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 73.20 810
101-42500.00-53810.00 Oct Electric Bills SHAKOPEE PUBLIC UTILITIE Oct Electric Bills 6.00 813
Total For Dept 42500.00 EMERGENCY MANAGEMENT 79.20
Dept 43050.00 ENGINEERING
101-43050.00-52050.00 Power hammer pin CARLSON HARDWARE COMPANY Misc Supplies 13.99 92426
101-43050.00-52050.00 Marking paint PRIOR LAKE HARDWARE Misc supplies 62.30 92481
101-43050.00-52051.00 Oct 2014 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 3.89 811
Total For Dept 43050.00 ENGINEERING 80.18
Dept 43100.00 STREET
101-43100.00-52050.00 Mag lite LED flashlights NORTHERN SAFETY CO INC Mag lite LED flashlights 272.69 92478
101-43100.00-52051.00 Oct 2014 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 142.38 811
101-43100.00-52052.00 Steel swivel caster TRACTOR SUPPLY CREDIT PL Misc supplies 119.96 92497
101-43100.00-52200.01 Sander repair parts TRACTOR SUPPLY CREDIT PL Misc supplies 26.85 92497
101-43100.00-52200.01 Pleasant Street Sidewalk CEMSTONE PRODUCTS COMPAN Pleasant Street Sidewalk 566.52 92429
101-43100.00-52200.01 Sign Order 30 - Stop, 35 - Spee NEWMAN TRAFFIC SIGNS Sign Order - 30 Stop Signs, 15 Speed 1,771.10 92477
101-43100.00-52400.10 Concrete forming tools CARLSON HARDWARE COMPANY Misc Supplies 39.95 92426
101-43100.00-52400.10 Brine maker pipe repair parts PRIOR LAKE HARDWARE Misc supplies 36.84 92481
101-43100.00-53840.00 Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 7,946.91 810
101-43100.00-53840.00 Oct Electric Bills SHAKOPEE PUBLIC UTILITIE Oct Electric Bills 661.05 813
Total For Dept 43100.00 STREET 11,584.25
Dept 43400.00 CENTRAL GARAGE
101-43400.00-52050.00 Misc repair parts NAPA AUTO PARTS October 2014 Statement 223.46 92475
101-43400.00-52050.00 Nuts, washers PRIOR LAKE HARDWARE Misc supplies 4.25 92481
101-43400.00-52200.01 Hurco spray gun TRACTOR SUPPLY CREDIT PL Misc supplies 88.97 92497
101-43400.00-52200.01 Throttle Cable CUSHMAN MOTOR COMPANY IN Throttle Cable 103.89 92518
101-43400.00-52200.01 Pro Battery FACTORY MOTOR PARTS COMP Pro Battery 318.45 92523
101-43400.00-52200.01 Harness and Valve FORCE AMERICA Harness and Valve 120.33 92525
101-43400.00-52200.01 Pipe Supply MINNESOTA PIPE & EQUIPME Pipe Supply 442.35 92530
101-43400.00-52200.01 Spacer MTI DISTRIBUTING INC Spacer 28.63 92532
101-43400.00-52200.01 Mini Limit Switch TRUCK BODIES & EQUIPMENT Mini Limit Switch 133.32 92542
101-43400.00-52200.01 Weather Strip TURFWERKS INC Weather Strip 52.68 92543
101-43400.00-52200.01 1" Electric Valve TURFWERKS INC 1" Electric Valve 232.49 92543
101-43400.00-52200.01 Spacer, Oil, Friction Oil WOLF MOTOR CO INC Spacer, Oil, Friction Oil 109.84 92546
101-43400.00-52200.01 Glass, Adhesive, Filters, Wiper ZIEGLER INC Glass, Adhesive, Filters, Wipers, Bla 540.48 92548
101-43400.00-52200.01 Misc repair parts NAPA AUTO PARTS October 2014 Statement 1,385.77 92475
101-43400.00-52200.01 Sander Auger Motors FORCE AMERICA Sander Auger Motors 1,010.00 92453
101-43400.00-52400.10 LED Work Light and Booster Pack DELEGARD TOOL CO LED Work Light and Booster Pack 169.81 92519
101-43400.00-52400.10 Misc repair parts NAPA AUTO PARTS October 2014 Statement 46.63 92475
101-43400.00-53830.00 Tire off of rim LIBERTY TIRE RECYCLING L Tire off of rim 120.00 92528
101-43400.00-54810.00 Unit #518 tow ALLEN'S SERVICE INC Tow Unit #518 to Boyer 175.00 92512
101-43400.00-54810.00 Repair 2002 Sterling - Drive Sh BOYER FORD TRUCKS INC Drive Shaft 2002 Sterling 1,036.98 92423
101-43400.00-54810.00 2009 Sterling Repair Low Power BOYER FORD TRUCKS INC 2009 Sterling Repair Low Power Engine 1,192.18 92423
101-43400.00-54810.00 Unit #0502 Engine Repair HONEST AL'S Unit #0502 Engine Repair 4,864.38 92462
Total For Dept 43400.00 CENTRAL GARAGE 12,399.89
Dept 45100.00 RECREATION
101-45100.00-34731.00 Oct 2014 Sales Tax MN DEPT OF REVENUE Oct 2014 Sales Tax (5.15) 811
101-45100.00-34740.00 Oct 2014 Sales Tax MN DEPT OF REVENUE Oct 2014 Sales Tax 18.22 811
101-45100.00-52050.00-REC1 Laminating Rolls Amazon.com Laminating Rolls 61.52 92502
101-45100.00-52050.00-REC1 Snowman party favor sacks ETSY Snowman party favor sacks 3.00 92502
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 4/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund 101 GENERAL FUND
Dept 45100.00 RECREATION
101-45100.00-52050.00-REC1 Holiday Show musician 12/3/14 MILLAR, STEVE Holiday Show musician 12/3/14 125.00 92471
101-45100.00-52050.00-RECl Musicians 12/4/14 ROE FAMILY SINGERS LLC Musicians 12/4/14 400.00 92486
101-45100.00-52050.00-RECl 10/23/2014 Wellness speaker NUTRITIONAL WEIGHT & WEL 10/23/2014 Wellness speaker 375.00 92534
101-45100.00-52050.00-REC1 Club Prior supplies SAM'S CLUB Recreation supplies 73.12 92487
101-45100.00-52056.00-RECl Mileage for MRPA meeting KELSEY KES Mileage for MRPA meeting 33.60 814
101-45100.00-52056.00-REC1 Autumn gathering concessions & SAM'S CLUB Recreation supplies 134.40 92487
101-45100.00-52056.00-RECl Pumpkin painting supplies MICHAEL'S Pumpkin painting supplies 62.25 92502
101-45100.00-52056.00-RECl Hot chocolate - Autumn gatherin PANERA Hot chocolate - Autumn gathering 96.13 92502
101-45100.00-52056.00-RECl Glow bean bag materials KES, KELSEY Glow bean bag materials 24.00 805
101-45100.00-52056.00-RECI Decemberrr Dazzle sign BUILD A SIGN Decemberrr Dazzle sign 56.30 92502
101-45100.00-52056.00-REC1 Playground balls, trash bag hol LTD COMMODITIES Playground balls, trash bag holders 39.80 92502
101-45100.00-52056.00-REC1 Krylon paint PETTY CASH Petty cash reimbursemnt 20.97 92480
101-45100.00-52056.00-RECl Decemberrrr Dazzle Iced Carver CHRISTENSEN, JOSEPH Decemberrrr Dazzle Iced Carver 1,000.00 92514
101-45100.00-52056.00-REC1 Decemberrr Dazzle Reindeer KENDALLVILLE FARM Decemberrr Dazzle Reindeer 995.00 92527
101-45100.00-52056.00-REC1 Decemberrr Dazzle Ice Carver SCHOLLJEGERDES, ADAM Decemberrr Dazzle Ice Carver 1,000.00 92536
101-45100.00-52056.00-REC1 Decemberrr Dazzle Pony Rides SCOTT BIXBY Decemberrr Dazzle Pony Rides 350.00 92537
101-45100.00-52056.00-RECl Halloween candy SAM'S CLUB Recreation supplies 81.80 92487
101-45100.00-53210.00 11/05/2014 - 12/04/2014 INTEGRA TELECOM 11/05/2014 - 12/04/2014 49.99 809
101-45100.00-54010.05 2015 Carpet Cleaning Club Prior COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 20.64 92434
101-45100.00-54310.00 Barstad, Kes, Doran annual memb SAM'S CLUB Recreation supplies 135.00 92487
Total For Dept 45100.00 RECREATION 5,150.59
Dept 45200.00 PARKS
101-45200.00-52051.00 Oct 2014 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 96.70 811
101-45200.00-52200.50 Holidazzle cutout supplies CARLSON HARDWARE COMPANY Misc Supplies 64.26 92426
101-45200.00-52200.50 Misc supplies PRIOR LAKE HARDWARE Misc supplies 52.91 92481
101-45200.00-53310.10 Pesticide Training Manuals UNIVERSITY OF MINNESOTA Pesticide Training Manuals 53.45 92502
101-45200.00-53810.00 Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 9.01 810
101-45200.00-53810.00 Oct Electric Bills SHAKOPEE PUBLIC UTILITIE Oct Electric Bills 182.48 813
101-45200.00-53850.00 Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 5,494.79 810
101-45200.00-54010.50 Repair Time Clock Tennis Courts HAYES ELECTRIC INC Repair Time Clock Tennis Courts Light 471.02 92460
101-45200.00-54070.00 Mini Hoe Rental CDE SERVICES INC Mini Hoe Rental 300.00 92428
Total For Dept 45200.00 PARKS 6,724.62
Dept 45500.00 LIBRARIES
101-45500.00-53210.00 11/05/2014 - 12/04/2014 INTEGRA TELECOM 11/05/2014 - 12/04/2014 196.91 809
101-45500.00-54010.02 Library Light Fixtures HAYES ELECTRIC INC Electrical Repairs 315.00 92460
101-45500.00-54010.05 2015 Carpet Cleaning Library COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 6,277.38 92434
Total For Dept 45500.00 LIBRARIES 6,789.29
Dept 46100.00 NATURAL RESOURCES
101-46100.00-54010.50 3907 Trail Point Ct - Tree Remo COLLINS TREE CARE 3907 Trail Point Ct - Tree Removal 600.00 92432
Total For Dept 46100.00 NATURAL RESOURCES 600.00
Total For Fund 101 GENERAL FUND 80,480.46
Fund 260 DAG Special Revenue Fund
Dept 43600.00 DEVELOPMENT PROJECTS
260-43600.00-55090.00-DEVO Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 8.80 810
Total For Dept 43600.00 DEVELOPMENT PROJECTS 8.80
Total For Fund 260 DAG Special Revenue Fund 8.80
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 5/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund 316 PARKS REFERENDUM '97
Dept 47000.00 DEBT SERVICE
316-47000.00-56010.00 GO Refunding Bonds 2005 DEPOSITORY TRUST COMPANY Bond Principal and Interest 645,000.00 817
316-47000.00-56110.00 GO Refunding Bonds 2005 DEPOSITORY TRUST COMPANY Bond Principal and Interest 70,556.25 817
Total For Dept 47000.00 DEBT SERVICE 715,556.25
Total For Fund 316 PARKS REFERENDUM 197 715,556.25
Fund 350 WATER REVENUE - PW BLDG
Dept 47000.00 DEBT SERVICE
350-47000.00-56010.00 GO Refunding Bonds 2005 DEPOSITORY TRUST COMPANY Bond Principal and Interest 170,000.00 817
350-47000.00-56110.00 GO Refunding Bonds 2005 DEPOSITORY TRUST COMPANY Bond Principal and Interest 4,037.50 817
Total For Dept 47000.00 DEBT SERVICE 174,037.50
Total For Fund 350 WATER REVENUE - PW BLDG 174,037.50
Fund 410 REVOLVING EQUIPMENT FUND
Dept 42100.06 POLICE FORFEITURES
410-42100.06-54350.00 Storage - Dodge Charger #656362 ALLEN'S SERVICE INC Storage - Dodge Charger #656362 300.00 92416
410-42100.06-54350.00 2005 Volvo XC9 #150755 SCOTT COUNTY ATTORNEY 2005 Volvo XC9 #150755 148.00 92490
410-42100.06-54350.00 2007 Dodge Charger #656362 SCOTT COUNTY ATTORNEY 2007 Dodge Charger #656362 901.54 92490
410-42100.06-54350.00 2005 Volvo XC9 #150755 STATE TREASURER 2005 Volvo XC9 #150755 73.99 92494
410-42100.06-54350.00 Misc repair parts NAPA AUTO PARTS October 2014 Statement 100.02 92475
410-42100.06-54350.00 Title - 14006266 PETTY CASH Petty cash reimbursemnt 79.25 92480
410-42100.06-54350.00 Storage - 2005 VolvoXC9 #15075 ALLEN'S SERVICE INC Storage - 2005 Volvo XC9 #150755 1,800.00 92416
410-42100.06-54350.00 2005 Ford Ranger #47153 SCOTT COUNTY ATTORNEY 2005 Ford Ranger #47153 2,961.70 92539
410-42100.06-54350.00 2010 Lexus #043696 SCOTT COUNTY ATTORNEY 2010 Lexus #043696 2,945.78 92539
Total For Dept 42100.06 POLICE FORFEITURES 9,310.28
Dept 43400.00 CENTRAL GARAGE
410-43400.00-55550.00 Utility Box for Unit #548 ABM EQUIPMENT & SUPPLY Utility Box for Unit #548 38,491.00 92511
Total For Dept 43400.00 CENTRAL GARAGE 38,491.00
Total For Fund 410 REVOLVING EQUIPMENT FUND 47,801.28
Fund 601 WATER FUND
Dept 00000.00 GENERAL
601-00000.00-11500.00 101870-01 4358 Pleasant St SE Brian & Kim Reiman UB Refund 45.80 92424
601-00000.00-11500.00 103649-00 16180 West Ave SE David Graham UB Refund 9.99 92439
601-00000.00-11500.00 304870-01 14130 Bluebird Tr NE David Schmidt UB Refund 60.00 92440
601-00000.00-11500.00 406274-00 3851 Raspberry Rdg N Deron Hoffineier UB Refund 47.95 92441
601-00000.00-11500.00 102572-01 6089 150th ST SE Detloff Management UB Refund 25.07 92442
601-00000.00-11500.00 208149-00 3375 Winfield Way SW DR HORTON UB Refund 8.88 92444
601-00000.00-11500.00 101059-01 5201 Frost Point Cir Dream Horizon LLC UB Refund 64.78 92445
601-00000.00-11500.00 202374-04 3206 Vale CIr SW Dustin Dahlberg UB Refund 29.46 92446
601-00000.00-11500.00 405668-00 3415 Glynwater Tr NW Greg Benson UB Refund 7.39 92458
601-00000.00-11500.00 207785-01 3770 Turner Dr SW Lesley Hollenbeck UB Refund 27.31 92465
601-00000.00-11500.00 107373-01 17786 Cleary Tr SE Matthew Grabow UB Refund 5.25 92467
601-00000.00-11500.00 300161-00 5715 Birchwood Ave N Nancy Carlson UB Refund 10.74 92474
601-00000.00-11500.00 404800-00 16039 Northwood Rd N Robert Groenvelt UB Refund 60.00 92485
601-00000.00-11500.00 407961-01 3905 Station PL NW TARA KINGSLEY UB Refund 19.27 92496
601-00000.00-20810.00 Oct 2014 Sales Tax MN DEPT OF REVENUE Oct 2014 Sales Tax 2,410.96 811
Total For Dept 00000.00 GENERAL 2,832.85
Dept 41520.00 FINANCE
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 6/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund 601 WATER FUND
Dept 41520.00 FINANCE
601-41520.00-53220.00 Nov UB Postage fees CASH CYCLE SOLUTIONS INC Nov UB mailing - Past dues, Finals 289.86 92427
601-41520.00-53430.00 Nov UB Printing fees CASH CYCLE SOLUTIONS INC Nov UB mailing - Past dues, Finals 71.84 92427
Total For Dept 41520.00 FINANCE 361.70
Dept 49400.00 WATER
601-49400.00-37170.00 Oct 2014 Sales Tax MN DEPT OF REVENUE Oct 2014 Sales Tax 866.50 811
601-49400.00-37175.00 Oct 2014 Sales Tax MN DEPT OF REVENUE Oct 2014 Sales Tax 179.47 811
601-49400.00-52051.00 Oct 2014 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 26.73 811
601-49400.00-52200.02 Drill bits CARLSON HARDWARE COMPANY Misc Supplies 24.22 92426
601-49400.00-52200.60 Dessicant Drying Agent IN-SITU INC Dessicant Drying Agent 65.50 92502
601-49400.00-52200.60 PVC, primer, batteries CARLSON HARDWARE COMPANY Misc Supplies 79.71 92426
601-49400.00-52200.60 Oil for Compressor at WTP JOHN HENRY FOSTER MN INC Oil for Compressor at WTP 111.69 92464
601-49400.00-52200.60 Hwy 13 Watermain Repair UNITED RENTALS INC Hwy 13 Watermain Repair 186.00 92501
601-49400.00-52200.60 Razorback Trenching/Ditching Sh ZACKS INCORPORATED Razorback Trenching/Ditching Shovel 27.25 92508
601-49400.00-52200.60 Well #7 VFD Repair AUTOMATIC SYSTEMS CO Well #7 VFD Repair 1,366.00 92420
601-49400.00-52200.60 Utility Heater GRAINGER INC Utility Heater 431.80 92526
601-49400.00-53100.20 10/23/14 Recheck Hydrants 2590 WATER CONSERVATION SVCS 10/23/14 Recheck Hydrants 2590 Spring 290.32 92505
601-49400.00-53100.20 Oct Groundwater Monitoring SAMPLETECH 2014 GROUNDWATER QUALITY MONITORING 1,600.00 92488
601-49400.00-53210.00 11/05/2014 - 12/04/2014 INTEGRA TELECOM 11/05/2014 - 12/04/2014 1,277.04 809
601-49400.00-53210.00 11/07/2014 - 12/06/2014 CENTURY LINK 11/07/2014 - 12/06/2014 213.04 92513
601-49400.00-53310.10 Public Works Certificate Progra STEPHES, ANDREW Public Works Certificate Program 726.36 807
601-49400.00-53310.10 Tuition Reimbursement MEGER, DANIEL Tuition Reimbursement 726.36 815
601-49400.00-53810.00 Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 31.82 810
601-49400.00-54010.01 Wire for Dump Valve - Bulk Wate HAYES ELECTRIC INC Wire for Dump Valve - Bulk Water Stat 876.02 92460
601-49400.00-54010.01 Concrete Removal 14301 Shady Be CONCRETE CUTTING & CORIN Concrete Removal 14301 Shady Beach Tr 350.00 92516
601-49400.00-54010.02 Repair lights and controls at M HAYES ELECTRIC INC Repair lights and controls at Mainten 830.44 92460
601-49400.00-54010.02 CO detection test at WTP TOXALERT INC CO detection test at WTP 170.00 92541
601-49400.00-54010.05 2015 Carpet Cleaning Maint Cent COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 10.32 92434
Total For Dept 49400.00 WATER 10,466.59
Total For Fund 601 WATER FUND 13,661.14
Fund 602 STORM WATER UTILITY
Dept 49420.00 WATER QUALITY
602-49420.00-52010.00 Tree index cards CREATIVE GRAPHICS Tree index cards 262.87 92517
602-49420.00-52010.00 Cupcakes - Clean up day AMBER BROOKS-MOHLER Reimbursement 28.96 92417
602-49420.00-52200.70 Protected Area Signs GOPHER SIGN COMPANY Protect Area Signs 1,046.32 92455
602-49420.00-53100.80 WCA Prof Ser 01100-930 WSB & ASSOCIATES INC Professional Services Sept 1-30, 2014 258.00 92506
602-49420.00-53100.80 WCA 01100-940 Prof Ser 9/1-9/30 WSB & ASSOCIATES INC WCA 01100-940 Prof Ser 9/1-9/30/14 193.50 92506
Total For Dept 49420.00 WATER QUALITY 1,789.65
Total For Fund 602 STORM WATER UTILITY 1,789.65
Fund 603 TRANSIT SERVICES
Dept 49804.00 TRANSIT SERVICES
603-49804.00-58000.00 MVTA Start Up Costs MVTA MVTA Start Up Costs 410,000.00 92473
Total For Dept 49804.00 TRANSIT SERVICES 410,000.00
Total For Fund 603 TRANSIT SERVICES 410,000.00
Fund 604 SEWER FUND
Dept 41520.00 FINANCE
604-41520.00-53220.00 Nov UB Postage fees CASH CYCLE SOLUTIONS INC Nov UB mailing - Past dues, Finals 289.86 92427
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 7/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund 604 SEWER FUND
Dept 41520.00 FINANCE
604-41520.00-53430.00 Nov UB Printing fees CASH CYCLE SOLUTIONS INC Nov UB mailing - Past dues, Finals 71.85 92427
Total For Dept 41520.00 FINANCE 361.71
Dept 49450.00 SEWER
604-49450.00-52051.00 Oct 2044 Fuel Tax MN DEPT OF REVENUE Oct 2014 Fuel Tax 26.73 811
604-49450.00-53810.00 Oct Electric Bills MINNESOTA VALLEY ELECTRI Oct Electric Bills 2,101.63 810
Total For Dept 49450.00 SEWER 2,128.36
Total For Fund 604 SEWER FUND 2,490.07
Fund 801 AGENCY FUND
Dept 00000.00 GENERAL
801-00000.00-20204.00 14-0486 3375 Winfield Way DR HORTON 14-0486 3375 Winfield Way 2,500.00 92443
801-00000.00-20204.00 14-0137 3535 Hickory Circle SW DR HORTON 14-0137 3535 Hickory Circle SW 2,500.00 92443
801-00000.00-20204.00 14-0358 5430 Snell Court GBI HOMES 14-0358 5430 Snell Court 2,500.00 92454
801-00000.00-20204.00 13-0839 5344 Candy Cove PINNACLE FAMILY HOMES 13-0839 5344 Candy Cove 2,500.00 92535
Total For Dept 00000.00 GENERAL 10,000.00
Total For Fund 801 AGENCY FUND 10,000.00
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 8/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
Fund Totals:
Fund 101 GENERAL FUND 80,480.46
Fund 260 DAG Special R 8.80
Fund 316 PARKS REFEREN 715,556.25
Fund 350 WATER REVENUE 174,037.50
Fund 410 REVOLVING EQU 47,801.28
Fund 601 WATER FUND 13,661.14
Fund 602 STORM WATER U 1,789.65
Fund 603 TRANSIT SERVI 410,000.00
Fund 604 SEWER FUND 2,490.07
Fund 801 AGENCY FUND 10,000.00
Total For All Funds: 1,455,825.15
--- TOTALS BY GL DISTRIBUTION ---
101-00000.00-21714.00 2014 HRA Reimbursement 188.16
101-41110.00-53310.10 City Council Dinner 11 1,142.61
101-41320.00-52010.00 Flemming, Peterson nam 61.20
101-41320.00-53310.10 Coffee 155.14
101-41330.00-53310.10 10/27/2014 Agenda Revi 40.20
101-41520.00-54310.00 Ringberg annual member 45.00
101-41820.00-54320.00 Oct HRA fees 637.81
101-41830.00-53520.00 Nov Wavelength deliver 2,495.36
101-41830.00-54320.00 Oct drug testing 266.00
101-41920.00-53100.80 ERP Project Management 6,292.00
101-41920.00-53210.00 11/05/2014 - 12/04/201 59.95
101-41920.00-54030.00 Repair Ricoh 5000C - p 1,149.11
101-41940.00-52200.02 Downtown building repa 245.58
101-41940.00-53210.00 11/05/2014 - 12/04/201 1,361.29
101-41940.00-54010.02 Flowers Naturally Ligh 785.88
101-41940.00-54010.05 2015 Carpet Cleaning C 1,840.71
101-41940.00-55560.00 Trash Cans for City Ha 442.05
101-42100.00-52051.00 Oct 2014 Fuel Tax 149.66
101-42100.00-52200.01 Marking paint 586.94
101-42100.00-52200.02 Electrical repair part 91.05
101-42100.00-53100.80 10/01/2014 - 10/31/201 151.54
101-42100.00-53210.00 11/05/2014 - 12/04/201 182.32
101-42100.00-53310.10 Griffin - Pursuit refr 593.21
101-42100.00-54010.02 Office Lights PD 1,129.06
101-42100.00-54010.04 Shredding 58.00
101-42100.00-54010.05 2015 Carpet Cleaning P 87.66
101-42100.00-54060.00 12/7/14 - 1/6/15 323.00
101-42200.00-52010.00 Laminating roll 6.04
101-42200.00-52050.00 Glass cleaner 167.86
101-42200.00-52051.00 Oct 2014 Fuel Tax 33.04
101-42200.00-52200.02 Plunger 11.65
101-42200.00-52400.10 2.5 inch hose 5,273.54
101-42200.00-53210.00 11/07/2014 - 12/06/201 586.94
101-42200.00-53310.10 Tow 4 cars to FS #1 600.00
101-42200.00-53810.00 Oct Electric Bills 779.27
101-42200.00-54010.02 25 Water softener salt 144.75
101-42200.00-54010.05 2015 Carpet Cleaning F 1,122.19
101-42200.00-55570.00 Motorola XTS 2500 Radi 7,340.88
101-42400.00-52051.00 Oct 2014 Fuel Tax 6.80
101-42400.00-52400.10 Tape measure 13.99
101-42400.00-53310.10 Baumgartner - code sem 425.00
101-42500.00-53810.00 Oct Electric Bills 79.20
101-43050.00-52050.00 Power hammer pin 76.29
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 9/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
101-43050.00-52051.00 Oct 2014 Fuel Tax 3.89
101-43100.00-52050.00 Mag lite LED flashligh 272.69
101-43100.00-52051.00 Oct 2014 Fuel Tax 142.38
101-43100.00-52052.00 Steel swivel caster 119.96
101-43100.00-52200.01 Pleasant Street Sidewa 2,364.47
101-43100.00-52400.10 Concrete forming tools 76.79
101-43100.00-53840.00 Oct Electric Bills 8,607.96
101-43400.00-52050.00 Misc repair parts 227.71
101-43400.00-52200.01 Throttle Cable 4,567.20
101-43400.00-52400.10 LED Work Light and Boo 216.44
101-43400.00-53830.00 Tire off of rim 120.00
101-43400.00-54810.00 Unit #518 tow 7,268.54
101-45100.00-34731.00 Oct 2014 Sales Tax (5.15)
101-45100.00-34740.00 Oct 2014 Sales Tax 18.22
101-45100.00-52050.00-REC14-ASUPPL Laminating Rolls 61.52
101-45100.00-52050.00-REC14-XCTOTS Snowman party favor sa 3.00
101-45100.00-52050.00-REC14-ZCPMUS Holiday Show musician 525.00
101-45100.00-52050.00-REC14-ZCPSPE 10/23/2014 Wellness sp 375.00
101-45100.00-52050.00-REC14-ZCPSUP Club Prior supplies 73.12
101-45100.00-52056.00-REC14-AMEETS Mileage for MRPA meeti 33.60
101-45100.00-52056.00-REC14-EAUTUM Pumpkin painting suppl 292.78
101-45100.00-52056.00-REC14-EDAZZL Decemberrr Dazzle sign 3,486.07
101-45100.00-52056.00-REC14-ETRICK Halloween candy 81.80
101-45100.00-53210.00 11/05/2014 - 12/04/201 49.99
101-45100.00-54010.05 2015 Carpet Cleaning C 20.64
101-45100.00-54310.00 Barstad, Kes, Doran an 135.00
101-45200.00-52051.00 Oct 2014 Fuel Tax 96.70
101-45200.00-52200.50 Holidazzle cutout supp 117.17
101-45200.00-53310.10 Pesticide Training Man 53.45
101-45200.00-53810.00 Oct Electric Bills 191.49
101-45200.00-53850.00 Oct Electric Bills 5,494.79
101-45200.00-54010.50 Repair Time Clock Tenn 471.02
101-45200.00-54070.00 Mini Hoe Rental 300.00
101-45500.00-53210.00 11/05/2014 - 12/04/201 196.91
101-45500.00-54010.02 Library Light Fixtures 315.00
101-45500.00-54010.05 2015 Carpet Cleaning L 6,277.38
101-46100.00-54010.50 3907 Trail Point Ct - 600.00
260-43600.00-55090.00-DEV02-000001 Oct Electric Bills 8.80
316-47000.00-56010.00 GO Refunding Bonds 200 645,000.00
316-47000.00-56110.00 GO Refunding Bonds 200 70,556.25
350-47000.00-56010.00 GO Refunding Bonds 200 170,000.00
350-47000.00-56110.00 GO Refunding Bonds 200 4,037.50
410-42100.06-54350.00 Storage - 2005 VolvoXC 9,310.28
410-43400.00-55550.00 Utility Box for Unit # 38,491.00
601-00000.00-11500.00 101870-01 4358 Pleasa 421.89
601-00000.00-20810.00 Oct 2014 Sales Tax 2,410.96
601-41520.00-53220.00 Nov UB Postage fees 289.86
601-41520.00-53430.00 Nov UB Printing fees 71.84
601-49400.00-37170.00 Oct 2014 Sales Tax 866.50
601-49400.00-37175.00 Oct 2014 Sales Tax 179.47
601-49400.00-52051.00 Oct 2014 Fuel Tax 26.73
601-49400.00-52200.02 Drill bits 24.22
601-49400.00-52200.60 Well #7 VFD Repair 2,267.95
601-49400.00-53100.20 Oct Groundwater Monit 1,890.32
601-49400.00-53210.00 11/07/2014 - 12/06/201 1,490.08
601-49400.00-53310.10 Tuition Reimbursement 1,452.72
601-49400.00-53810.00 Oct Electric Bills 31.82
601-49400.00-54010.01 Concrete Removal 14301 1,226.02
601-49400.00-54010.02 Repair lights and cont 1,000.44
12/01/2014 11:28 AM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 10/10
User: Janet POST DATES 11/15/2014 - 11/30/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Invoice Line Desc Vendor Invoice Description Amount Check #
601-49400.00-54010.05 2015 Carpet Cleaning M 10.32
602-49420.00-52010.00 Cupcakes - Clean up da 291.83
602-49420.00-52200.70 Protected Area Signs 1,046.32
602-49420.00-53100.80 WCA Prof Ser 01100-930 451.50
603-49804.00-58000.00 MVTA Start Up Costs 410,000.00
604-41520.00-53220.00 Nov US Postage fees 289.86
604-41520.00-53430.00 Nov US Printing fees 71.85
604-49450.00-52051.00 Oct 2044 Fuel Tax 26.73
604-49450.00-53810.00 Oct Electric Bills 2,101.63
801-00000.00-20204.00 14-0486 3375 Winfield 10,000.00