HomeMy WebLinkAbout6A - Claims Listing O� PRIO
ti
U 4646 Dakota Street SE
Prior Lake,MN 55372
�INNESD�P
CITY COUNCIL AGENDA REPORT
MEETING DATE: NOVEMBER 24, 2014
AGENDA#: 6A
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.
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 the
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
questions.
An Invoice GL Distribution Report has been attached for the following claims
period:
Claims Period 10/31/14— 11/14/14
Total Claims Paid $121,227.89
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
11/17/2014 12:41 PM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 1/6 A
User: Janet POST DATES 11/01/2014 - 11/14/2014
DB: Prior Lake JOURNALIZED
PAID
GL Number Vendor Invoice Desc. Invoice Due Date Amount
Fund 101 GENERAL FUND
Dept 00000.00 GENERAL
101-00000.00-21706.00 PRUDENTIAL INSURANCE Nov COBRA - Kansier November 2014 11/14/14 31.42
101-00000.00-21713.00 MEDICA Nov health insurance premiums C0036014439 11/10/14 52,230.54
101-00000.00-21714.00 ALLIANCE BENEFIT GROUP 2014 HRA Reimbursements 11/05/2014 11/07/14 1,034.20
101-00000.00-21714.00 ALLIANCE BENEFIT GROUP 2014 HRA Reimbursement 11/12/2014 11/14/14 1,064.97
Total For Dept 00000.00 GENERAL 54,361.13
Dept 41130.00 ORDINANCE
101-41130.00-53510.00 SOUTHWEST NEWSPAPERS Oct legal notices 100431 10/31/201 11/20/14 335.88
Total For Dept 41130.00 ORDINANCE 335.88
Dept 41320.00 ADMINISTRATION
101-41320.00-52010.00 OFFICE MAX CONTRACT INC Toner 964932 11/23/14 146.00
101-41320.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 85.77
Total For Dept 41320.00 ADMINISTRATION 231.77
Dept 41410.00 ELECTIONS
101-41410.00-51100.07 ZIEMANN, KEN 2014 General Election Judge 2014 General 11/14/14 180.00
101-41410.00-51100.07 ADAIR, JACOB 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 ALEXANDER LACKIE 2014 General Election Judge 2014 General 11/14/14 70.00
101-41410.00-51100.07 ANDERSON, ARDYTH 2014 General Election Judge 2014 General 11/14/14 180.00
101-41410.00-51100.07 ARNOLD, CHARLES 2014 General Election Judge 2014 General 11/14/14 170.00
101-41410.00-51100.07 ARNOLD, KATHIE 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 BADEN, DAVE 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 BADEN, RITA 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 BLINDERMAN, DOVID 2014 General Election Judge 2014 General 11/14/14 165.00
101-41410.00-51100.07 CHRISSINGER, DENNIS 2014 General Election Judge 2014 General 11/14/14 155.00
101-41410.00-51100.07 CHRISTENSEN, MARILYN 2014 General Election Judge 2014 General 11/14/14 165.00
101-41410.00-51100.07 DICKENSON, NANCY 2014 General Election Judge 2014 General 11/14/14 170.00
101-41410.00-51100.07 EVERMANN, CAROL 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 FELCH, JUANITA 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 FREEMON, CANDACE 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 FROME, JAMES 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 FULLER, MARY SUE 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 GARBORG, CLARICE 2014 General Election Judge 2014 General 11/14/14 170.00
101-41410.00-51100.07 GARBORG, TRYGVE 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 GRENDAHL, ELAINE 2014 General Election Judge 2014 General 11/14/14 170.00
101-41410.00-51100.07 GRENDAHL, JERRY 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 GRODAHL, BARBARA 2014 General Election Judge 2014 General 11/14/14 155.00
101-41410.00-51100.07 HOFFMAN, JOSEPHINE 2014 General Election Judge 2014 General 11/14/14 155.00
101-41410.00-51100.07 HOPPE, CINDY 2014 General Election Judge 2014 General 11/14/14 170.00
101-41410.00-51100.07 IVERSON, TIFFANI 2014 General Election Judge 2014 General 11/14/14 155.00
101-41410.00-51100.07 JONES, MARLYS 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 KORMANIK, CHERYL 2014 General Election Judge 2014 General 11/14/14 165.00
101-41410.00-51100.07 LAWMAN, DENNIS 2014 General Election Judge 2014 General 11/14/14 165.00
101-41410.00-51100.07 MANNION, TIMOTHY 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 MATYJA, ALEXANDRA 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 MISGEN, JANET 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 MURRAY, JOHN 2014 General Election Judge 2014 General 11/14/14 170.00
101-41410.00-51100.07 MURRAY, SHARON 2014 General Election Judge 2014 General 11/14/14 155.00
101-41410.00-51100.07 MYCKA, MARGIE 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 NAU, RHONDA 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 OLDENBURG, DAVE 2014 General Election Judge 2014 General 11/14/14 190.00
101-41410.00-51100.07 PAQUETTE, LADONNA 2014 General Election Judge 2014 General 11/14/14 160.00
11/17/2014 12:41 PM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 2/6
User: Janet POST DATES 11/01/2014 - 11/14/2014
DB: P£ior Lake JOURNALIZED
PAID
GL Number Vendor Invoice Desc. Invoice Due Date Amount
Fund 101 GENERAL FUND
Dept 41410.00 ELECTIONS
101-41410.00-51100.07 REHMER, LOREN 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 REHMER, MARGARET 2014 General Election Judge 2014 General 11/14/14 155.00
101-41410.00-51100.07 RITTENOUR, CHAD 2014 General Election Judge 2014 General 11/14/14 145.00
101-41410.00-51100.07 RUEDY, KRISTIN 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 SCHOOT, ARTHUR 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 SCHROEDER, DIANE 2014 General Election Judge 2014 General 11/14/14 170.00
101-41410.00-51100.07 SPIEKER, LYNN 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 STEVEN, LOREN 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 VOMACKA, KATHY 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 WAHL, ROGER 2014 General Election Judge 2014 General 11/14/14 150.00
101-41410.00-51100.07 WEISGURT, ROCHELLE 2014 General Election Judge 2014 General 11/14/14 155.00
101-41410.00-51100.07 WENNER, BARBARA 2014 General Election Judge 2014 General 11/14/14 165.00
101-41410.00-51100.07 WENNER, EUGENE 2014 General Election Judge 2014 General 11/14/14 160.00
101-41410.00-51100.07 ZIEMANN, DIANE 2014 General Election Judge 2014 General 11/14/14 175.00
Total For Dept 41410.00 ELECTIONS 8,080.00
Dept 41820.00 HUMAN RESOURCES
101-41820.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 50.76
Total For Dept 41820.00 HUMAN RESOURCES 50.76
Dept 41830.00 COMMUNICATIONS
101-41830.00-53520.00 POSTMASTER Postage for 2040 Vision mailing 2040 Vision 11/10/14 2,340.56
Total For Dept 41830.00 COMMUNICATIONS 2,340.56
Dept 41910.00 COMMUNITY DEVELOPMENT
101-41910.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 50.76
Total For Dept 41910.00 COMMUNITY DEVELOPMENT 50.76
Dept 41920.00 INFORMATION TECHNOLOGY
101-41920.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 50.76
101-41920.00-54020.00 MICROSOFT 2014 Office 365 Licenses E040000IYKF 11/25/14 1,044.00
Total For Dept 41920.00 INFORMATION TECHNOLOGY 1,094.76
Dept 41940.00 FACILITIES - CITY HALL
101-41940.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 7,762.35
Total For Dept 41940.00 FACILITIES - CITY HALL 7,762.35
Dept 42100.00 POLICE
101-42100.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 813.12
101-42100.00-53230.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 385.11
101-42100.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 3,620.34
101-42100.00-54010.05 COMMERCIAL STEAM TEAM 2015 Carpet Cleaning 12010 11/09/14 1,275.00
Total For Dept 42100.00 POLICE 6,093.57
Dept 42200.00 FIRE
101-42200.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 50.76
101-42200.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 1,043.40
Total For Dept 42200.00 FIRE 1,094.16
Dept 42400.00 BUILDING INSPECTION
101-42400.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 238.05
Total For Dept 42400.00 BUILDING INSPECTION 238.05
Dept 42500.00 EMERGENCY MANAGEMENT
11/17/2014 12:41 PM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 3/6
User: Janet POST DATES 11/01/2014 - 11/14/2014
DB: Ptior Lake JOURNALIZED
PAID
GL Number Vendor Invoice Desc. Invoice Due Date Amount
Fund 101 GENERAL FUND
Dept 42500.00 EMERGENCY MANAGEMENT
101-42500.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 36.35
Total For Dept 42500.00 EMERGENCY MANAGEMENT 36.35
Dept 43050.00 ENGINEERING
101-43050.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 250.80
Total For Dept 43050.00 ENGINEERING 250.80
Dept 43100.00 STREET
101-43100.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 104.18
101-43100.00-53840.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 6,639.69
Total For Dept 43100.00 STREET 6,743.87
Dept 43400.00 CENTRAL GARAGE
101-43400.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 104.18
101-43400.00-54810.00 BOYER FORD TRUCKS INC Vendor Repair, outside shop 643050 11/21/14 1,291.31
Total For Dept 43400.00 CENTRAL GARAGE 1,395.49
Dept 45100.00 RECREATION
101-45100.00-53120.20-REC TRANSFIRST Oct merchant fees 10/31/2014 11/10/14 78.85
101-45100.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 23.90
101-45100.00-54010.05 COMMERCIAL STEAM TEAM 2015 Carpet Cleaning in Oct 2014 12000 11/08/14 150.00
101-45100.00-54010.05 COMMERCIAL STEAM TEAM 2015 Carpet Cleaning in Oct 2014 12001 11/08/14 150.00
Total For Dept 45100.00 RECREATION 402.75
Dept 45200.00 PARKS
101-45200.00-52050.00 PRIOR LAKE AGGREGATE INC Course Sand 1014014 11/01/14 861.77
101-45200.00-52200.02 MONNENS SUPPLY INC Lumber Supplies 3048 11/22/14 90.00
101-45200.00-52200.02 MONNENS SUPPLY INC Lumber Supplies 3069 11/24/14 380.00
101-45200.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 434.94
101-45200.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 994.68
101-45200.00-53850.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 825.29
Total For Dept 45200.00 PARKS 3,586.68
Dept 45500.00 LIBRARIES
101-45500.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 2,073.57
Total For Dept 45500.00 LIBRARIES 2,073.57
Total For Fund 101 GENERAL FUND 96,223.26
Fund 260 DAG Special Revenue Fund
Dept 43600.00 DEVELOPMENT PROJECTS
260-43600.00-55050.00-A24 UPS Postage 5 shipping OOOOWR5623424 11/18/14 11.67
Total For Dept 43600.00 DEVELOPMENT PROJECTS 11.67
Total For Fund 260 DAG Special Revenue Fund 11.67
Fund 601 WATER FUND
Dept 41520.00 FINANCE
601-41520.00-53120.10 PAYMENT SERVICE NETWORK INC 10/01/2014 - 10/31/2014 93811 12/04/14 101.25
601-41520.00-54020.00 PAYMENT SERVICE NETWORK INC 10/01/2014 - 10/31/2014 93811 12/04/14 44.98
Total For Dept 41520.00 FINANCE 146.23
Dept 49400.00 WATER
601-49400.00-52010.00 OFFICE MAX CONTRACT INC General Office Supplies 860940 11/17/14 252.76
601-49400.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 571.27
11/17/2014 12:41 PM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 4/6
User: Janet POST DATES 11/01/2014 - 11/14/2014
DB: Piior Lake JOURNALIZED
PAID
GL Number Vendor Invoice Desc. Invoice Due Date Amount
Fund 601 WATER FUND
Dept 49400.00 WATER
601-49400.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 12,196.77
601-49400.00-54010.05 COMMERCIAL STEAM TEAM 2015 Carpet Cleaning in Oct 2014 12002 11/08/14 150.00
Total For Dept 49400.00 WATER 13,170.80
Total For Fund 601 WATER FUND 13,317.03
Fund 602 STORM WATER UTILITY
Dept 49420.00 WATER QUALITY
602-49420.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 52.09
Total For Dept 49420.00 WATER QUALITY 52.09
Total For Fund 602 STORM WATER UTILITY 52.09
Fund 604 SEWER FUND
Dept 41520.00 FINANCE
604-41520.00-53120.10 PAYMENT SERVICE NETWORK INC 10/01/2014 - 10/31/2014 93811 12/04/14 101.25
604-41520.00-54020.00 PAYMENT SERVICE NETWORK INC 10/01/2014 - 10/31/2014 93811 12/04/14 44.97
Total For Dept 41520.00 FINANCE 146.22
Dept 49450.00 SEWER
604-49450.00-52200.80 WM MUELLER & SONS INC Asphalt 197975 11/06/14 58.00
604-49450.00-52200.80 WM MUELLER & SONS INC Asphalt 198061 11/08/14 146.16
604-49450.00-53210.00 VERIZON WIRELESS 9/24/2014 - 10/23/2014 9734340754 11/18/14 316.68
604-49450.00-53810.00 XCEL ENERGY Oct Electric Bills 10/14/2014 11/10/14 956.78
Total For Dept 49450.00 SEWER 1,477.62
Total For Fund 604 SEWER FUND 1,623.84
Fund 801 AGENCY FUND
Dept 00000.00 GENERAL
801-00000.00-20204.00 BRANDL ANDERSON 14-0363 16720 Markley Lake Drive 16720 Markley La 11/14/14 2,500.00
801-00000.00-20204.00 DR HORTON 14-0135 3538 Hickory Circle 3538 Hickory Cir 11/14/14 2,500.00
801-00000.00-20204.00 GBI Homes 14-0560 16541 Snell Lane 16541 Snell Lane 11/14/14 2,500.00
801-00000.00-20204.00 RYAN REAL ESTATE 14-0178 5602 Mount Curve Blvd 5602 Mount Curve 11/14/14 2,500.00
Total For Dept 00000.00 GENERAL 10,000.00
Total For Fund 801 AGENCY FUND 10,000.00
11/17/2014 12:41 PM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 5/6
User: Janet POST DATES 11/01/2014 - 11/14/2014
DB: 'piior Lake JOURNALIZED
PAID
GL Number Vendor Invoice Desc. Invoice Due Date Amount
Fund Totals:
Fund 101 GENERAL FUND 96,223.26
Fund 260 DAG Special Revenue Fund 11.67
Fund 601 WATER FUND 13,317.03
Fund 602 STORM WATER UTILITY 52.09
Fund 604 SEWER FUND 1,623.84
Fund 801 AGENCY FUND 10,000.00
Total For All Funds: 121,227.89
--- TOTALS BY GL DISTRIBUTION ---
101-00000.00-21706.00 Nov COBRA - Kansier 31.42
101-00000.00-21713.00 Nov health insurance premiums 52,230.54
101-00000.00-21714.00 2014 HRA Reimbursements 2,099.17
101-41130.00-53510.00 Oct legal notices 335.88
101-41320.00-52010.00 Toner 146.00
101-41320.00-53210.00 9/24/2014 - 10/23/2014 85.77
101-41410.00-51100.07 2014 General Election Judge 8,080.00
101-41820.00-53210.00 9/24/2014 - 10/23/2014 50.76
101-41830.00-53520.00 Postage for 2040 Vision Mailing 2,340.56
101-41910.00-53210.00 9/24/2014 - 10/23/2014 50.76
101-41920.00-53210.00 9/24/2014 - 10/23/2014 50.76
101-41920.00-54020.00 Office 365 Licenses 1,044.00
101-41940.00-53810.00 Oct Electric Bills 7,762.35
101-42100.00-53210.00 9/24/2014 - 10/23/2014 813.12
101-42100.00-53230.00 9/24/2014 - 10/23/2014 385.11
101-42100.00-53810.00 Oct Electric Bills 3,620.34
101-42100.00-54010.05 2015 Carpet Cleaning Police Department 1,275.00
101-42200.00-53210.00 9/24/2014 - 10/23/2014 50.76
101-42200.00-53810.00 Oct Electric Bills 1,043.40
101-42400.00-53210.00 9/24/2014 - 10/23/2014 238.05
101-42500.00-53810.00 Oct Electric Bills 36.35
101-43050.00-53210.00 9/24/2014 - 10/23/2014 250.80
101-43100.00-53210.00 9/24/2014 - 10/23/2014 104.18
101-43100.00-53840.00 Oct Electric Bills 6,639.69
101-43400.00-53210.00 9/24/2014 - 10/23/2014 104.18
101-43400.00-54810.00 Vendor Repair #K06805 1,291.31
101-45100.00-53120.20-REC14-MMERCH Oct merchant fees 78.85
101-45100.00-53210.00 9/24/2014 - 10/23/2014 23.90
101-45100.00-54010.05 2015 Carpet Cleaning Lakefront Pavilion 300.00
101-45200.00-52050.00 Course Sand 861.77
101-45200.00-52200.02 Lumber Supplies 470.00
101-45200.00-53210.00 9/24/2014 - 10/23/2014 434.94
101-45200.00-53810.00 Oct Electric Bills 994.68
101-45200.00-53850.00 Oct Electric Bills 825.29
101-45500.00-53810.00 Oct Electric Bills 2,073.57
260-43600.00-55050.00-A2414-000001 Postage - TMobile Escrow Agreements 11.67
601-41520.00-53120.10 10/01/2014 - 10/31/2014 Bank fees 101.25
601-41520.00-54020.00 10/01/2014 - 10/31/2014 Gateway Fee 44.98
601-49400.00-52010.00 General Office Supplies 252.76
601-49400.00-53210.00 9/24/2014 - 10/23/2014 571.27
601-49400.00-53810.00 Oct Electric Bills 12,196.77
601-49400.00-54010.05 2015 Carpet Cleaning Maint Center 150.00
602-49420.00-53210.00 9/24/2014 - 10/23/2014 52.09
604-41520.00-53120.10 10/01/2014 - 10/31/2014 Bank fees 101.25
604-41520.00-54020.00 10/01/2014 - 10/31/2014 Gateway Fee 44.97
604-49450.00-52200.80 Asphalt 204.16
604-49450.00-53210.00 9/24/2014 - 10/23/2014 316.68
604-49450.00-53810.00 Oct Electric Bills 956.78
11/17/2014 12:41 PM INVOICE GL DISTRIBUTION REPORT FOR CITY OF PRIOR LAKE Page: 6/6
User: Janet POST DATES 11/01/2014 - 11/14/2014
A",: 'rior Lake JOURNALIZED
0 PAID
GL Number Vendor Invoice Desc. Invoice Due Date Amount
601-00000.00-20204.00 14-0363 16720 Markley Lake Drive 10,000.00