HomeMy WebLinkAbout5A, Claims and Payroll i
,- R EEN_ HILLS
5A
Request for Council Action
Prepared By: Ashley Bertrand, Sue Iverson Council Meeting Date: January 13,2013
Motion to Approve Consent Agenda Item—Claims and Payroll
Budgeted Amount: Actual Amount: Funding Source:
NA NA NA
Recommendation:
1. Motion to Approve Consent Agenda Item—Claims and Payroll
Supporting Documents:
Payroll
2012 Payroll#26 $78,966.26
2013 Payroll#1 $96,506.44
Total Payroll $ 175,472.70
Accounts Payable Claims Through 01/11/2013
Paid Claims (Check No. 0 US Bank EFT) $ 2,302.48
Paid Claims (Check No. 41174 thru Check No. 41203) $ 20,110.88
Paid Claims (Check No.41204 thru Check No. 41232) $ 49,713.33
Paid Claims (Check No.41234 thru Check No. 41253) $ 24,280.20
Paid Claims (Check No. 41254 thru Check No. 41261) $ 4,533.18
Paid Claims (Check No. 41262 thru Check No. 41286) $ 17,573.67
Paid Claims (Check No. 41290 thru Check No. 41295) $ 7,963.55
Paid Claims (Check No.41233 thru Check No. 41233) $ 1,000,000.00
Paid Claims (Check No. 41287 thru Check No.41289) $ 115,109.41
Paid Claims (Check No. 41296 thru Check No. 41300) $ 565,329.54
Total Claims $ 1,806,916.24
CITY OF ARDEN HILLS
PAYROLL#26
CHECKS DATED: 12/21/12
Biweekly: 12/01/12 TO 12/14/12
P1 tJ! )C bEDUGTI NS ?[ AWT is RI''i'B>Cl-W I C H. Pa`:i iet t MetF adi i
FIT 7,785.97 : ><:»»:<::>> »::>::>:.;:.;:.;: < .i EFT
SIT 3,106.17
FICA Oasdi 2,621.65 3,870.06 EFT
FICA Medicare 968.18 968.18 EFT
TOTAL TAXES 14,481.97 4,838.24
Health Premium 1,312.56 0.00 A/P Check"
Dental Premium 0.00 A/P Check"
FSA Health Care Reimb. 225.00:: : , A/P Check"
FSA Dependent Care Reimb. 526.28;:;; ,.:;.;.;;i
A/P Check
TOTAL FLEXIBLE SPENDING 1 2,063.84 0.00
HSA Health Savin 705.16 0.00
TOTAL HEALTH SAVINGS 705.161 0.00
PERA 3,954.52 4,587.22 EFT
ICMA 2,250.70 327.76 A/P Check*
x
Central Pension Fund-Union 614.40 '>> > >> ><> > > A/P Check*
.................... ...
TOTAL RETIREMENT I 6,819.62 4,914.98
IUOE 49 Dues Union 130.00 << > < A/P Check*
LTD/STD Insurance 0.00 » _ ....<'>:A/P Check*
PERA Life Insurance
Life/Addl/Dep Life 199.20 100M.. Check*
Mn Child Support 323.02 ;>> < i<':I'.'.>€<'> > > , : A/P Check*
TOTAL VOLUNTARY 692.221 0.00
Total Employee Deductions 24; 62:81: PR Check# 17374-17382
Net Payroll 3,755.01 EFT
Direct Deposit 40,695.22
Gross Payroll Tie-Out 69,213.04
STD/LTD Gross-Up 0.00
Plus City Paid Benefit >9;753:22
TOTAL PAYROLL COST 78,966.26
Gross Payroll 69 213:04:
Less Total FSA
Plus Employer Match ICMA Q:OQ
Plus ICMA Benefit Held
Net P/R Subject to FICA
FICA Oasdi @ 6.20%
11FICA Medicare P.1.45% 96i:1:g:
Note:Federal and State Payroll Tax obligations are satisfied by means
of utilizing the "Taxtel" Electronic Tax Deposit Service.Trans-
fers are typically made two business days after the payroll date.
*A/P Checks can be found on the ACCOUNTS PAYABLE Check Approval report.
Checks may be paid this week or the following week.
CITY OF ARDEN HILLS
PAYROLL#1
CHECKS DATED: 01/04/13
Biweekly: 12/15/12 TO 12/28/12
)Es1kII'I QYE;IIE I1C2IQN5itilYCITY'BENEF.iT ?a.iti�nlMetttgd
FIT 9,005.84 >`: : :;:> <:.;>`: >;;<> EFT
SIT 3,123.96:>«:::<:» :::::>::«;::::>::»':::>::>::> EFT
FICA Oasdi 4,107.91 4,107.91 EFT
FICA Medicare 960.73 960.73 EFT
TOTAL TAXES 17,198.44 1 5,068.64
Health Premium 1,336.59 13,441.33 A/P Check*
Dental Premium 919.13 A/P Check*
FSA Health Care Reimb. 177.08 [< <>><<> ><>> >i> <A/P Check*
FSA Dependent Care Reimb. 416.66 ><si < >; >s# >; A/P Check*
TOTAL FLEXIBLE SPENDING 1,930.33 14,360.46
HSA Health Saving 508.17 3,772.46
Health Care savings Plan 39.55
TOTAL HEALTH SAVINGS 508.171 3,812.01
PERA 3,856.82 4,473.88 EFT
ICMA 2,268.60 327.76 A/P Check*
Central Pension Fund-Union 614.40 ;< "<`<>>2? A/P Check*
MN State Retirement System 311.57 >:z: A/P Check*
TOTAL RETIREMENT 7,051.39 4,801.64
1U0E 49 Dues (Union) 130.00 " << A/P Check*
LTD/STD Insurance 1,226.85 ;.`:;:_. A/P Check*
PERA Life Insurance 40.00 >:;::;;::;::;:;;::;:: A/P Check*
Life/Addl/Dep Life 123.30 96.20 A/P Check*
MN Child Support 323.02... >;. . A/P Check*
Public Em to ee Long Term Care 81.20 A/P Check*
UNUM 132.38 «:>.; A/P Check*
Avesis-Vision Care 8.94:::;;;:.;;:; A/P Check*
TOTAL VOLUNTARY 2,065.69 96.20
Total Employee Deductions 28;751::02:
Net Payroll 2,623.53 PR Check#17383-17389
Direct Deposit 36,989.94 EFT
Gross Payroll Tie-Out 68,367.49
STD/LTD Gross-Up 0.00
Plus City Paid Benefit 28;k38:95
TOTAL PAYROLL COST 96,506.44
Gross Payroll 6$;3k7; 9
Less Total FSA :193Q.33:
Plus Employer Match ICMA
Plus ICMA Benefit Held
Net P/R Subject to FICA fi6;43?..I6:
FICA Oasdi P,6.20%
11FICA MedicyL2 1.45% 960:73
Note:Federal and State Payroll Tax obligations are satisfied by means
of utilizing the "Taxtel" Electronic Tax Deposit Service.Trans-
fers are typically made two business days after the payroll date.
*A/P Checks can be found on the ACCOUNTS PAYABLE Check Approval report.
Checks may be paid this week or the following week.
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:47AM
Check Number Check Date Amount
0602-US BANK Line Item Account
0 01/09/2013
Inv Freyberger
Line Item Date Line Item Description Line Item Account
12/06/2012 MN Pollution Control Agency Conference 602-49490-44325 300.00
Inv Freyberger Total 300.00
Inv Frid
Line Item Date Line Item Description Line Item Account
11/23/2012 Uniform Allowance-Frid 727-49700-42111 188.92
Inv Frid Total 188.92
Inv Grant
Line Item Date Line Item Description Line Item Account
11/18/2012 Senior Cinema 101-45120-42170 2.57
11/19/2012 Schools Out Supplies 101-45120-42170 15.53
11/18/2012 Schools Out Supplies 101-45120-42170 8.91
12/10/2012 Breakfast with Santa Supplies 101-45120-42170 14.93
12/10/2012 Holiday Gift Making 101-45120-42170 27.85
11/30/2012 City Hall Decorations 101-41500-42010 43.06
Inv Grant Total 112.85
Inv Iverson
Line Item Date Line Item Description Line Item Account
11/20/2012 GOFA Meeting 101-41500-44325 187.20
12/10/2012 You Send It License 728-49900-44330 14.99
11/20/2012 HR Training 101-41500-44325 99.00
Inv Iverson Total 301.19
Inv Mooney
Line Item Date Line Item Description Line Item Account
11/21/2012 PW Supplies-Pad Locks 727-49700-42400 526.20
11/21/2012 PW Supplies-Battery Tenders 727-49700-42400 104.26
12/06/2012 PW Supplies-Hand Tools 727-49700-42400 68.22
12/06/2012 PW Supplies-Hand Tools 727-49700-42400 54.64
Inv Mooney Total 753.32
AP-Check Detail(1/11/2013- 9:47 AM) Pagel
Check Number Check Date Amount
Inv Olson
Line Item Date Line Item Descri tp ion Line Item Account
12/07/2012 City Hall Decorations 101-41500-42010 36.42
12/07/2012 Building Key Copies 101-41940-42010 23.07
11/21/2012 Tree Care Registry License 101-45200-44330 25.50
11/30/2012 Breakfast with Santa Supplies 101-45120-42170 31.60
Inv Olson Total 116.59
Inv Scherbel
Line Item Date Line Item Description Line Item Account
11/16/2012 10,000 Lakes Membership Dues 101-42400-44330 255.00
11/16/2012 10,000 Lakes Membership Dues-Refund 101-42400-44330 -170.00
11/20/2012 Rodent Control 101-41940-44390 52.91
Inv Scherbel Total 137.91
Inv Schifsky
Line Item Date Line Item Description Line Item Account
11/23/2012 PW Supplies 727-49700-42230 301.71
Inv Schifsky Total 301.71
Inv Winkel
Line Item Date Line Item Description Line Item Account
11/23/2012 Uniform Allowance-Winkel 727-49700-42111 89.99
Inv Winkel Total 89.99
0 Total: 2,302.48
0602-US BANK Total: 2,302.48
Total: 2,302.48
AP-Check Detail(1/11/2013- 9:47 AM) Page 2
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:53AM
Check Number Check Date Amount
ALPI-Allegra Print&Imaging Line Item Account
41174 12/21/2012
Inv 135285
Line Item Date Line Item Description Line Item Account
11/21/2012 December 2012 Newsletter 101-41100-43540 1,305.73
Inv 135285 Total 1,305.73
41174 Total: 1,305.73
ALPI-Allegra Print&Imaging Total: 1,305.73
ARAM-Aramark Uniform Service Line Item Account
41175 12/21/2012
Inv 629-7626011
Line Item Date Line Item Description Line Item Account
11/20/2012 December 2012 Mat Service 101-41940-43840 263.01
Inv 629-7626011 Total 263.01
41175 Total: 263.01
ARAM-Aramark Uniform Service Total: 263.01
6060-Batteries Plus Line Item Account
41176 12/21/2012
Inv 029-479343
Line Item Date Line Item Description Line Item Account
11/20/2012 PW Supplies 727-49700-42400 104.21
Inv 029-479343 Total 104.21
Inv 029-479415
Line Item Date Line Item Description Line Item Account
11/21/2012 PW Supplies 727-49700-42400 104.21
Inv 029-479415 Total 104.21
41176 Total: 208.42
AP-Check Detail(1/11/2013- 9:53 AM) Pagel
Check Number Check Date Amount
6060-Batteries Plus Total: 205.42
0131-Beisswenger's How-To Store Line Item Account
41177 12/21/2012
Inv 247021
Line Item Date Line Item Description Line Item Account
11/28/2012 PW Supplies 727-49700-42400 15.37
Inv 247021 Total 15.37
41177 Total: 15.37
0131-Beisswenger's How-To Store Total: 15.37
0296-City of Arden Hills Line Item Account
41178 12/21/2012
Inv 11302012
Line Item Date Line Item Description Line Item Account
11/30/2012 November 2012 Petty Cash 101-41910-42030 11.12
11/30/2012 November 2012 Petty Cash 101-41500-42010 73.54
11/30/2012 November 2012 Petty Cash 101-41100-42010 15.93
11/30/2012 November 2012 Petty Cash 101-41500-42010 9.97
11/30/2012 November 2012 Petty Cash 101-45120-42170 88.68
Inv 11302012 Total 199.24
41178 Total: 199.24
0296-City of Arden Hills Total: 199.24
UNST-Department of Treasury Line Item Account
41179 12/21/2012
Inv 12142012
Line Item Date Line Item Description Line Item Account
12/14/2012 Arden Hills Foundation 101-41100-44901 300.00
Inv 12142012 Total 300.00
41179 Total: 300.00
UNST-Department of Treasury Total: 300.00
6954-Emergency Apparatus Maintenance Line Item Account
41180 12/21/2012
Inv 65150
Line Item Date Line Item Description Line Item Account
AP-Check Detail(1/11/2013- 9:53 AM) Page 2
Check Number Check Date Amount
11/21/2012 Vehicle#212 DOT Inspection 727-49700-44040 127.98
Inv 65150 Total 127.98
41180 Total: 127.98
6954-Emergency Apparatus Maintenance Total: 127.98
0339-Ferguson Waterworks 2516 Line Item Account
41181 12/21/2012
Inv 0002687-1
Line Item Date Line Item Description Line Item Account
11/27/2012 PW Supplies 601-49440-42245 316.32
Inv 0002687-1 Total 316.32
Inv 0003827-1
Line Item Date Line Item Description Line Item Account
11/27/2012 PW Supplies 601-49440-42245 191.10
Inv 0003827-1 Total 191.10
Inv 0004996
Line Item Date Line Item Description Line Item Account
11/27/2012 PW Supplies 601-49440-42245 345.32
Inv 0004996 Total 345.32
41181 Total: 852.74
0339-Ferguson Waterworks 2516 Total: 852.74
5055-Green Mill Line Item Account
41182 12/21/2012
Inv 833-C
Line Item Date Line Item Description Line Item Account
11/19/2012 Credit from Invoice 833 10141100-44325 -52.48
Inv 833-C Total -52.48
Inv 886
Line Item Date Line Item Description Line Item Account
12/10/2012 CC Mtg 12.10.12 101-41100-44325 74.25
Inv 886 Total 74.25
41182 Total: 21.77
AP-Check Detail(1/11/2013- 9:53 AM) Page 3
Check Number Check Date Amount
5055-Green Mill Total: 21.77
0382-ICMA Retirement Trust-106944 Line Item Account 101-00000-21740
41183 12/21/2012
Inv 12192012-PK
Line Item Date Line Item Description Line Item Account
12/19/2012 Klaers PR 26 Contribution 101-00000-21740 610.31
Inv 12192012-PK Total 610.31
41183 Total: 610.31
0382-ICMA Retirement Trust-106944 Total: 610.31
0387-ICMA Retirement Trust-#302482 Line Item Account 101-00000-21742
41184 12/21/2012
Inv 12192012-CS
Line Item Date Line Item Description Line Item Account
12/19/2012 PR 26 Contributions 101-00000-21742 1,968.15
Inv 12192012-CS Total 1,968.15
41184 Total: 1,968.15
0387-ICMA Retirement Trust-#302482 Total: 1,968.15
IDAI-Ideal Advertising,Inc Line Item Account
41185 12/21/2012
Inv 34878
Line Item Date Line Item Description Line Item Account
09/29/2012 Fall Adult Softball Championship T Shirts 101 45120-42172 317.00
Inv 34878 Total 317.00
41185 Total: 317.00
IDAT-Ideal Advertising,Inc Total: 317.00
8059-Iverson,Sue Line Item Account
41186 12/21/2012
Inv 12212012
Line Item Date Line Item Description Line Item Account
12/21/2012 Tuition Reimbursement Spring 2012 101-41500-44323 2,816.00
Inv 12212012 Total 2,816.00
AP-Check Detail(1/11/2013- 9:53 AM) Page 4
Check Number Check Date Amount
41186 Total: 2,816.00
8059-Iverson,Sue Total: 2,816.00
0214-LTG Power Equipment Line Item Account
41187 12/21/2012
Inv 160903
Line Item Date Line Item Description Line Item Account
11/13/2012 PW Supplies 727-49700-42400 621.93
Inv 160903 Total 621.93
Inv 160953
Line Item Date Line Item Description Line Item Account
11/14/2012 PW Supplies 727-49700-42400 244.11
Inv 160953 Total 244.11
Inv 160984
Line Item Date Line Item Description Line Item Account
11/15/2012 PW Supplies 727-49700-42400 141.23
Inv 160984 Total 141.23
Inv 160995
Line Item Date Line Item Description Line Item Account
11/15/2012 PW Supplies 727-49700-42400 98.93
Inv 160995 Total 98.93
41187 Total: 1,106.20
0214-LTG Power Equipment Total: 1,106.20
1197-McFarland Hanson Inc.Line Item Account
41188 12/21/2012
Inv 229810
Line Item Date Line Item Description Line Item Account
11/13/2012 CH Supplies 101-41940-42010 81.52
Inv 229810 Total 81.52
41188 Total: 81.52
1197-McFarland Hanson Inc.Total: 81.52
0242-Met Council Environ.Service-SAC Line Item Account
AP-Check Detail(1/11/2013- 9:53 AM) Page 5
Check Number Check Date Amount
41189 12/21/2012
Inv 10312012
Line Item Date Line Item Description Line Item Account
10/31/2012 SAC Charges October&November 2012 602-49490-43851 4,730.00
Inv 10312012 Total 4,730.00
41189 Total: 4,730.00
0242-Met Council Environ.Service-SAC Total: 4,730.00
MNCS-Minnesota Child Support Payment Center Line Item Account 101-00000-21780
41190 12/21/2012
Inv 12192012-MNCS
Line Item Date Line Item Description Line Item Account
12/19/2012 Frid PR 26 Deduction 101-00000-21780 323.02
Inv 12192012-MNCS Total 323.02
41190 Total: 323.02
MNCS-Minnesota Child Support Payment Center Total: 323.02
6349-Nosek,Mary Line Item Account
41191 12/21/2012
Inv 12182012
Line Item Date Line Item Description Line Item Account
12/18/2012 December 2012 Arden Hills Notes 101-41100-43540 120.00
Inv 12182012 Total 120.00
41191 Total: 120.00
6349-Nosek,Mary Total: 120.00
7084-OmniSite Line Item Account
41192 12/21/2012
Inv 34767
Line Item Date Line Item Description Line Item Account
11/20/2012 LS Security Thru 12.31.2012 601-49440-44010 95.27
11/20/2012 LS Security Thru 12.31.2012 602-49490-44010 95.27
Inv 34767 Total 190.54
41192 Total: 190.54
AP-Check Detail(1/11/2013- 9:53 AM) Page 6
Check Number Check Date Amount
7084-OmniSite Total: 190.54
1074-Precision Landscape&Tree Line Item Account
41193 12/21/2012
Inv 21848
Line Item Date Line Item Description Line Item Account
11/21/2012 Floral Park Tennis Court 101-45200-44050 1,374.37
Inv 21848 Total 1,374.37
41193 Total:
1,374.37
1074-Precision Landscape&Tree Total: 1,374.37
4467-Robinson Landscaping Line Item Account
41194 12/21/2012
Inv 12012012
Line Item Date Line Item Description Line Item Account
12/01/2012 Water Dept Repair 601-49440-44040 38.15
Inv 12012012 Total 38.15
41194 Total: 38.15
4467-Robinson Landscaping Total: 38.15
7064-Rotary Club of Arden Hills/Shoreview Line Item Account
41195 12/21/2012
Inv 1076
Line Item Date Line Item Description Line Item Account
12/16/2012 Q1 2013 Dues 250-47300-44330 178.10
Inv 1076 Total 178.10
41195 Total: 178.10
7064-Rotary Club of Arden Hills/Shoreview Total: 178.10
6257-S&S Tree&Hortic.Spec.,Inc.Line Item Account
41196 12/21/2012
Inv 66417
Line Item Date Line Item Description Line Item Account
11/24/2012 Floral Drive/HamlineAve Trail 101-45200-44050 478.27
11/24/2012 Floral Drive/Hamlin Ave Trail 227-48205-44050 478.26
Inv 66417 Total 956.53
AP-Check Detail(1/11/2013- 9:53 AM) Page 7
Check Number Check Date Amount
41196 Total: 956.53
6257-S&S Tree&Horde.Spec.,Inc.Total: 956.53
1193-SelectAccount Line Item Account
41197 12/21/2012
Inv 905388
Line Item Date Line Item Description Line Item Account
12/02/2012 December 2012 Participant Fee 101-41300-44370 43.92
Inv 905388 Total 43.92
41197 Total: 43.92
1193-SelectAccount Total: 43.92
0925-T-Mobile Line Item Account
41198 12/21/2012
Inv 12222012
Line Item Date Line Item Description Line Item Account
12/22/2012 December 2012 Cell Phone Charges 728-49900-43210 1,055.66
12/22/2012 December 2012 Cell Phone Charges 728-49900-43210 -110.70
Inv 12222012 Total 944.96
41198 Total: 944.96
0925-T-Mobile Total: 944.96
8524-Twin City Hams,LLC Line Item Account
41199 12/21/2012
Inv 20983.22
Line Item Date Line Item Description Line Item Account
12/17/2012 CC Work Session 12.17.12 101-41100-44325 121.47
Inv 20983.22 Total 121.47
41199 Total: 121.47
8524-Twin City Hams,LLC Total: 121.47
0208-UniSelect USA Line Item Account
41200 12/21/2012
Inv 039118585
Line Item Date Line Item Description Line Item Account
11/21/2012 PW Supplies 727-49700-42400 134.76
AP-Check Detail(1/11/2013- 9:53 AM) Page 8
Check Number Check Date Amount
Inv 039118585 Total 134.76
41200 Total: 134.76
0208-UniSelect USA Total: 134.76
4468-Walton,Bill Line Item Account
41201 12/21/2012
Inv 12192012
Line Item Date Line Item Description Line Item Account
12/19/2012 Trail Root Cutting Damage Repair Costs 101-45200-42230 343.04
Inv 12192012 Total 343.04
41201 Total: 343.04
4468-Walton,Bill Total: 343.04
1115-WSB&Associates,Inc.Line Item Account
41202 12/21/2012
Inv 01771-050-1
Line Item Date Line Item Description Line Item Account
12/13/2012 TCAAP Engineering Fees 101-41600-43030 237.50
Inv 01771-050-1 Total 237.50
41202 Total: 237.50
1115-WSB&Associates,Inc.Total: 237.50
0940-Zee Medical Services Line Item Account
41203 12/21/2012
Inv 54053389
Line Item Date Line Item DescriRtion Line Item Account
10/18/2012 Medical Supplies 727-49700-42010 120.93
10/18/2012 Medical Supplies 101-41500-42010 60.15
Inv 54053389 Total 181.08
41203 Total: 181.08
0940-Zee Medical Services Total: 181.08
AP-Check Detail(1/11/2013- 9:53 AM) Page 9
Check Number Check Date Amount
Total: 20,110.88
AP-Check Detail(1/11/2013- 9:53 AM) Page 10
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:50AM
Check Number Check Date Amount
0600-315800-NCPERS Minnesota Line Item Account 101-00000-21734
41204 12/28/2012
Inv 3158113
Line Item Date Line Item Description Line Item Account
12/19/2012 December 2012 Payroll Deductions 101-00000-21734 80.00
Inv 3158113 Total 80.00
41204 Total: 80.00
0600-315800-NCPERS Minnesota Total: 80.00
ANDL-Anderberg Line Item Account
41205 12/28/2012
Inv 122542-01
Line Item Date Line Item Description Line Item Account
12/04/2012 Winter 2012 Rec Guide 101-45120-43540 2,361.94
Inv 122542-01 Total 2,361.94
Inv 122701-01
Line Item Date Line Item Description Line Item Account
12/04/2012 Winter 2012 Rec Guide 101-45120-43540 790.88
Inv 122701-01 Total 790.88
41205 Total: 3,152.82
ANDL-Anderberg Total: 3,152.82
ARAM-Aramark Uniform Service Line Item Account
41206 12/28/2012
Inv 629-7645232
Line Item Date Line Item Description Line Item Account
12/18/2012 December 2012 Mat Service 101-41940-43840 298.06
Inv 629-7645232 Total 298.06
41206 Total: 298.06
AP-Check Detail(1/11/2013- 9:50 AM) Page 1
Check Number Check Date Amount
ARAM-Aramark Uniform Service Total: 298.06
1125-Bolton&Menk,Inc.Line Item Account
41207 12/28/2012
Inv 0152694
Line Item Date Line Item Description Line Item Account
11/30/2012 LS 13 October 2012 Engineering Services 602-48401-43030 160.00
Inv 0152694 Total 160.00
41207 Total: 160.00
1125-Bolton&Menk,Inc.Total: 160.00
CPF1-Central Pension Fund Line Item Account 101-00000-21772
41208 12/28/2012
Inv 12312012
Line Item Date Line Item Description Line Item Account
12/31/2012 December 2012 Contributions 101-00000-21772 1,228.80
Inv 12312012 Total 1,228.80
41208 Total: 1,228.80
CPFI-Central Pension Fund Total: 1,228.80
0277-City of New Brighton Line Item Account
41209 12/28/2012
Inv 12032012
Line Item Date Line Item Description Line Item Account
12/03/2012 Q4 2012 Cable Services 228-41960-43100 1,455.00
Inv 12032012 Total 1,455.00
41209 Total: 1,455.00
0277-City of New Brighton Total: 1,455.00
0319-City of Roseville Line Item Account
41210 12/28/2012
Inv 0216827
Line Item Date Line Item Description Line Item Account
12/05/2012 IT Tech Support December 2012 728-49900-43081 2,294.16
Inv 0216827 Total 2,294.16
AP-Check Detail(1/11/2013- 9:50 AM) Page 2
i
Check Number Check Date Amount
Inv 0216859
Line Item Date Line Item Description Line Item Account
12/05/2012 December 2012 Phone Bill 728-49900-43210 472.50
Inv 0216859 Total 472.50
Inv 0216902
Line Item Date Line Item Description Line Item Account
12/10/2012 2012 Laserfiche Maintenance 728-49900-43081 985.57
Inv 0216902 Total 985.57
41210 Total: 3,752.23
0319-City of Roseville Total: 3,752.23
0155-Dept.of Administration Line Item Account
41211 12/28/2012
Inv W12110678
Line Item Date Line Item Description Line Item Account
12/19/2012 November 2012 Phone Services 728-49900-43210 704.65
Inv W 12110678 Total 704.65
41211 Total: 704.65
0155-Dept.of Administration Total: 704.65
1785-EcoEnvelopes Line Item Account
41212 12/28/2012
Inv 12212012
Line Item Date Line Item Description Line Item Account
12/21/2012 Q4 2012 UB Postage 601-49440-43222 298.63
12/21/2012 Q4 2012 UB Postage 602-49490-43222 298.63
12/21/2012 Q4 2012 UB Postage 604-49550-43222 298.64
Inv 12212012 Total 895.90
41212 Total: 895.90
1785-EcoEnvelopes Total: 895.90
0490-EDAM Line Item Account
41213 12/28/2012
Inv 12272012
Line Item Date Line Item Description Line Item Account
12/27/2012 2013 Membership Renewal 101-41910-44330 395.00
AP-Check Detail(1/11/2013- 9:50 AM) Page 3
Check Number Check Date Amount
Inv 12272012 Total 395.00
41213 Total: 395.00
0490-EDAM Total: 395.00
2129-Elfering&Associates Line Item Account
41214 12/28/2012
Inv 1745
Line Item Date Line Item Description Line Item Account
12/19/2012 694 Project/TCAAP Utility Analysis 411-48319-43030 6,465.00
12/19/2012 694 Project/TCAAP Utility Analysis 101-41600-43030 600.00
Inv 1745 Total 7,065.00
Inv 1746
Line Item Date Line Item Description Line Item Account
12/19/2012 2011 PMP Engineering Charges 411-48510-43030 4,602.50
Inv 1746 Total 4,602.50
Inv 1747
Line Item Date Line Item Description Line Item Account
12/19/2012 Fox Ridge Escrow Engineering Charges 101-00000-22000 2,405.00
Inv 1747 Total 2,405.00
Inv 1748
Line Item Date Line Item Description Line Item Account
12/19/2012 Valentine Park Engineering Costs 604-48315-43030 895.00
Inv 1748 Total 895.00
Inv 1749
Line Item Date Line Item Description Line Item Account
12/19/2012 LS 1&12 Reconstruction Engineering Fees 602-48402-43030 562.50
Inv 1749 Total 562.50
Inv 1750
Line Item Date Line Item Description Line Item Account
12/19/2012 2013 PMP Engineering Fees 411-48511-43030 227.50
Inv 1750 Total 227.50
41214 Total: 15,757.50
2129-Elfering&Associates Total: 15,757.50
AP-Check Detail(1/11/2013- 9:50 AM) Page 4
Check Number Check Date Amount
4470-GLTC Premium Payments Line Item Account
41215 12/28/2012
Inv 1150254
Line Item Date Line Item Description Line Item Account
12/20/2012 PR#1 Long Term Care Deduction 101-00000-21752 81.20
Inv 1150254 Total 81.20
41215 Total: 81.20
4470-GLTC Premium Payments Total: 81.20
0766-Greatland Corporation Line Item Account
41216 12/28/2012
Inv 4013489 RI
Line Item Date Line Item Description Line Item Account
12/14/2012 1099/W2 Forms 101-41500-42010 103.82
Inv 4013489 RI Total 1031.82
41216 Total: 103.82
0766-Greatland Corporation Total: 103.82
KEGC-Kennedy&Graven Line Item Account
41217 12/28/2012
Inv 111377
Line Item Date Line Item Description Line Item Account
10/31/2012 Cottage Filla TIT Legal Fees 253-4730543040 38.00
Inv 111377 Total 38.00
41217 Total: 38.00
KEGC-Kennedy&Graven Total: 38.00
1197-McFarland Hanson Inc.Line Item Account
41218 12/28/2012
Inv 229871
Line Item Date Line Item Description Line Item Account
11/29/2012 CH Supplies 101-41940-42010 82.49
Inv 229871 Total 82.49
41218 Total: 82.49
AP-Check Detail(1/11/2013- 9:50 AM) Page 5
Check Number Check Date Amount
1197-McFarland Hanson Inc.Total: 82.49
3371-Midwest Testing LLC Line Item Account
41219 12/28/2012
Inv 2665
Line Item Date Line Item Description Line Item Account
11/28/2012 2012 Water Meter Replacement 601-48517-45600 1,205.00
Inv 2665 Total 1,205.00
41219 Total: 1,205.00
3371-Midwest Testing LLC Total: 1,205.00
0257-Minnesota Dept.of Health Line Item Account
41220 12/28/2012
Inv 11142012
Line Item Date Line Item Description Line Item Account
11/14/2012 Q4 2012 Water Connection Service Fee 601-49440-43821 4,102.00
Inv 11142012 Total 4,102.00
41220 Total: 4,102.00
0257-Minnesota Dept.of Health Total: 4,102.00
6252-Office Depot Line Item Account
41221 12/28/2012
Inv 1529759900
Line Item Date Line Item Description Line Item Account
12/03/2012 Rec Supplies 101-45120-42010 43.31
Inv 1529759900 Total 43.31
41221 Total: 43.31
6252-Office Depot Total: 43.31
7084-OmniSite Line Item Account
41222 12/28/2012
Inv 34767
Line Item Date Line Item Description Line Item Account
11/20/2012 LS Security December 2012 601-49440-44010 95.27
11/20/2012 LS Security December 2012 602-49490-44010 95.27
Inv 34767 Total 190.54
AP-Check Detail(1/11/2013- 9:50 AM) Page 6
Check Number Check Date Amount
41222 Total: 190.54
7084-OmniSite Total: 190.54
0316-Oriental Trading Co.,Inc.Line Item Account
41223 12/28/2012
Inv 654647294-01
Line Item Date Line Item Description Line Item Account
11/28/2012 Rec Supplies 101-45120-42170 391.84
Inv 654647294-01 Total 391.84
41223 Total: 391.84
0316-Oriental Trading Co.,Inc.Total: 391.84
0292-Oxygen Service Company,Inc.Line Item Account
41224 12/28/2012
Inv 03211914
Line Item Date Line Item Description Line Item Account
11/30/2012 PW Supplies 727-49700-42210 7.70
Inv 03211914 Total 7.70
41224 Total: 7.70
0292-Oxygen Service Company,Inc.Total: 7.70
1074-Precision Landscape&Tree Line Item Account
41225 12/28/2012
Inv 21847
Line Item Date Line Item Description Line Item Account
11/21/2012 Trail Tree Maintenance 101-45200-44050 1,092.01
Inv 21847 Total 1,092.01
41225 Total: 1,092.01
1074-Precision Landscape&Tree Total: 1,092.01
1208-Premium Waters,Inc Line Item Account
41226 12/28/2012
Inv 610207-11-12
Line Item Date Line Item Description Line Item Account
11/30/2012 CH Supplies 101-41940-42010 33.94
AP-Check Detail(1/11/2013- 9:50AM) Page 7
Check Number Check Date Amount
Inv 610207-11-12 Total 33.94
Inv 613317-11-12
Line Item Date Line Item Description Line Item Account
11/30/2012 CH Supplies 101-41940-42010 87.53
Inv 613317-11-12 Total 87.53
41226 Total: 121.47
1208-Premium Waters,Inc Total: 121.47
0811-Ramsey County Line Item Account
41227 12/28/2012
Inv EMCOM-002271
Line Item Date Line Item Description Line Item Account
12/21/2012 December 2012 Fleet Support Fee 101-42300-44330 24.96
Inv EMCOM-002271 Total 24.96
Inv PRRRV-000552
Line Item Date Line Item Description Line Item Account
12/27/2012 Q3&Q4 Election Contract Payment 101-41410-43100 7,750.00
Inv PRRRV-000552 Total 7,750.00
41227 Total: 7774.96
0811-Ramsey County Total: 7,774.96
SRFC-SRF Consulting Group,Inc.Line Item Account
41228 12/28/2012
Inv 07946.00-1
Line Item Date Line Item Description Line Item Account
11/30/2012 PC 12-019 Escrow Charges 101-00000-22000 3,367.98
Inv 07946.00-1 Total 3,367.98
41228 Total: 3,367.98
SRFC-SRF Consulting Group,Inc.Total: 3,367.98
1387-Standard Insurance Company Line Item Account
41229 12/28/2012
Inv 147490-012013
Line Item Date Line Item Description Line Item Account
12/17/2012 January 2013 STD/LTD/Life Insurance 101-00000-21733 1,582.45
AP-Check Detail(1/11/2013- 9:50 AM) Page 8
Check Number Check Date Amount
Inv 147490-012013 Total 1,582.45
41229 Total: 1,582.45
1387-Standard Insurance Company Total: 1,582.45
0327-Staples Business Advantage Line Item Account
41230 12/28/2012
Inv 3187502082
Line Item Date Line Item Description Line Item Account
12/01/2012 Office Supplies 101-41500-42010 542.42
Inv 3187502082 Total 542.42
41230 Total: 542.42
0327-Staples Business Advantage Total: 542.42
1175-TNT Cleaning and Consulting,INC Line Item Account
41231 12/28/2012
Inv 263212
Line Item Date Line Item Description Line Item Account
11/30/2012 December 2012 Cleaning-Floors 101-41940-43840 80.16
Inv 263212 Total 80.16
Inv 263266
Line Item Date Line Item Description Line Item Account
12/10/2012 December 2012 Cleaning 101-41940-43840 903.09
Inv 263266 Total 903.09
41231 Total: 983.25
1175-TNT Cleaning and Consulting,INC Total: 983.25
0478-Truck Utilities Mfg.Company Line Item Account
41232 12/28/2012
Inv 0246676
Line Item Date Line Item Description Line Item Account
11/28/2012 PW Parts 727-49700-42150 122.93
Inv 0246676 Total 122.93
41232 Total: 122.93
AP-Check Detail(1/11/2013- 9:50 AM) Page 9
Check Number Check Date Amount
0478-Truck Utilities Mfg.Company Total: 122.93
Total: 49,713.33
AP-Check Detail(1/11/2013- 9:50 AM) Page 10
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:48AM
Check Number Check Date Amount
AIRY-A-1 Hydraulic Sales&Service Line Item Account
41234 01/04/2013
Inv 0098516-IN
Line Item Date Line Item Description Line Item Account
12/20/2012 PW Parts 727-49700-42210 128.57
Inv 0098516-IN Total 128.57
41234 Total: 128.57
A1HY-A-1 Hydraulic Sales&Service Total: 128.57
1223-Adam's Pest Control,Inc.Line Item Account
41235 01/04/2013
Inv 1702851
Line Item Date Line Item Description Line Item Account
12/13/2012 December 2012 Pest Control Services 101-41940-44010 66.84
Inv 1702851 Total 66.84
41235 Total: 66.84
1223-Adam's Pest Control,Inc.Total: 66.84
0131-Beisswenger's How-To Store Line Item Account
41236 01/04/2013
Inv 250144
Line Item Date Line Item Description Line Item Account
12/06/2012 PW Supplies 727-49700-42210 7.56
Inv 250144 Total 7.56
Inv 250592
Line Item Date Line Item Description Line Item Account
12/07/2012 PW Supplies 727-49700-42210 88.90
Inv 250592 Total 88.90
Inv 253583
Line Item Date Line Item Description Line Item Account
AP-Check Detail(1/11/2013- 9:48 AM) Page 1
Check Number Check Date Amount
12/13/2012 PW Supplies 727-49700-42210 13.08
Inv 253583 Total 13.08
41236 Total: 109.54
0131-Beisswenger's How-To Store Total: 109.54
0755-Boyer Trucks,Inc.Line Item Account
41237 01/04/2013
Inv 695732
Line Item Date Line Item Description Line Item Account
12/04/2012 PW Parts 727-49700-42400 36.49
Inv 695732 Total 36.49
41237 Total:
36.49
0755-Boyer Trucks,Inc.Total: 36.49
1033-Comcast Line Item Account
41238 01/04/2013
Inv 44271-122012
Line Item Date Line Item Description Line Item Account
12/11/2012 December 2012 TV Services 228-41960-43100 6.76
Inv 44271-122012 Total 6.76
41238 Total:
6.76
1033-Comcast Total: 6.76
0453-Continental Research Corp.Line Item Account
41239 01/04/2013
Inv 379465-CRC-1
Line Item Date Line Item Description Line Item Account
12/06/2012 PW Maintenance Materials 727-49700-42245 873.07
Inv 379465-CRC-1 Total 873.07
41239 Total: 873.07
0453-Continental Research Corp.Total: 873.07
EATI-Emergency Automotive Tech,Inc Line Item Account
41240 01/04/2013
AP-Check Detail(1/11/2013- 9:48 AM) Page 2
Check Number Check Date Amount
Inv AW120712-12
Line Item Date Line Item Description Line Item Account
12/10/2012 PW Supplies 727-49700-42400 99.84
Inv AW 120712-12 Total 99.84
41240 Total: 99.84
EATI-Emergency Automotive Tech,Inc Total: 99.84
1195-Eureka Recycling Line Item Account
41241 01/04/2013
Inv 11399
Line Item Date Line Item Description Line Item Account
12/21/2012 November 2012 Recycling Costs 603-49520-36276 -707.88
12/21/2012 November 2012 Recycling Costs 603-49520-43860 7,820.80
Inv 11399 Total 7,112.92
41241 Total: 7,112.92
1195-Eureka Recycling Total: 7,112.92
0339-Ferguson Waterworks 2516 Line Item Account
41242 01/04/2013
Inv 0006029
Line Item Date Line Item Description Line Item Account
12/04/2012 PW Supplies 601-49440-42210 128.35
Inv 0006029 Total 128.35
41242 Total: 128.35
0339-Ferguson Waterworks 2516 Total: 128.35
0887-Force America,Inc.Line Item Account
41243 01/04/2013
Inv 01396313
Line Item Date Line Item Description Line Item Account
12/07/2012 PW Supplies 727-49700-42400 96.13
Inv 01396313 Total 96.13
41243 Total: 96.13
0887-Force America,Inc.Total: 96.13
AP-Check Detail(1/11/2013- 9:48 AM) Page 3
Check Number Check Date Amount
0192-Grainger,Inc Line Item Account
41244 01/04/2013
Inv 9011459436
Line Item Date Line Item Description Line Item Account
12/04/2012 PW Supplies 727-49700-42400 242.82
Inv 9011459436 Total 242.82
41244 Total: 242.82
0192-Grainger,Inc Total: 242.82
3117-Hutmacher,Jill Line Item Account
0 01/04/2013
Inv 12272012
Line Item Date Line Item Description Line Item Account
12/27/2012 Expense/Mileage Reimbursement 101-41910-43310 96.57
12/27/2012 Expense/Mileage Reimbursement 101-41910-44325 21.00
Inv 12272012 Total 117.57
0 Total: 117.57
3117-Hutmacher,Jill Total: 117.57
KEGC-Kennedy&Graven Line Item Account
41245 01/04/2013
Inv 111745
Line Item Date Line Item Description Line Item Account
11/30/2012 TCAAP Legal Expense-November 2012 101-41600-43041 5,720.70
Inv 111745 Total 5,720.70
41245 Total: 5,720.70
KEGC-Kennedy&Graven Total: 5,720.70
0222-League of Minnesota Cities Line Item Account
41246 01/04/2013
Inv 09012012
Line Item Date Line Item Description Line Item Account
09/01/2012 2012 Membership Dues 101-41100-44330 30.00
Inv 09012012 Total 30.00
41246 Total: 30.00
AP-Check Detail(1/11/2013- 9:48 AM) Page 4
Check Number Check Date Amount
0222-League of Minnesota Cities Total: 30.00
6148-M&H Supply Line Item Account
41247 01/04/2013
Inv 1279
Line Item Date Line Item Description Line Item Account
12/04/2012 PW Repair Parts 727-49700-42245 1,923.75
Inv 1279 Total 1,923.75
41247 Total: 1,923.75
6148-M&H Supply Total: 1,923.75
0731-MIDWAY FORD Line Item Account
41248 01/04/2013
Inv 154028
Line Item Date Line Item Description Line Item Account
12/10/2012 PW Supplies 727-49700-42400 108.07
Inv 154028 Total 108.07
Inv 353560
Line Item Date Line Item Description Line Item Account
12/07/2012 PW Repair 727-49700-44040 56.65
Inv 353560 Total 56.65
41248 Total: 164.72
0731-MIDWAY FORD Total: 164.72
1995-Minnesota Department of Natural Resources Line Item Account
41249 01/04/2013
Inv 894034
Line Item Date Line Item Description Line Item Account
12/11/2012 Trail Signs 101-45200-42245 28.64
Inv 894034 Total 28.64
41249 Total: 28.64
1995-Minnesota Department of Natural Resources Total: 28.64
0413-Newman Traffic Signs Line Item Account
41250 01/04/2013
AP-Check Detail(1/11/2013- 9:48 AM) Page 5
Check Number Check Date Amount
Inv TI-0256622
Line Item Date Line Item Description Line Item Account
12/03/2012 Street Signs 101-43100-42245 243.25
Inv TI-0256622 Total 243.25
41250 Total: 243.25
0413-Newman Traffic Signs Total: 243.25
0292-Oxygen Service Company,Inc.Line Item Account
41251 01/04/2013
Inv 07638616
Line Item Date Line Item Description Line Item Account
12/03/2012 PW Supplies 727-49700-42210 136.84
Inv 07638616 Total 136.84
41251 Total: 136.84
0292-Oxygen Service Company,Inc.Total: 136.84
0811-Ramsey County Line Item Account
41252 01/04/2013
Inv EMCOM-002318
Line Item Date Line Item Description Line Item Account
12/21/2012 December 2012 911 Dispatch 101-42150-43121 4,101.62
Inv EMCOM-002318 Total 4,101.62
Inv PUBW-012375
Line Item Date Line Item Description Line Item Account
12/10/2012 November 2012 Fuels 727-49700-42120 2,524.18
Inv PUBW-012375 Total 2,524.18
41252 Total: 6,625.80
0811-Ramsey County Total: 6,625.80
0208-UniSelect USA Line Item Account
41253 01/04/2013
Inv 039121038
Line Item Date Line Item Description Line Item Account
12/04/2012 PW Parts 727-49700-42400 59.34
Inv 039121038 Total 59.34
AP-Check Detail(1/11/2013- 9:48 AM) Page 6
Check Number Check Date Amount
Inv 039121066
Line Item Date Line Item Description Line Item Account
12/04/2012 PW Parts 727-49700-42400 127.31
Inv 039121066 Total 127.31
Inv 039121712
Line Item Date Line Item Description Line Item Account
12/06/2012 PW Parts 727-49700-42400 51.17
Inv 039121712 Total 51.17
Inv 039121899
Line Item Date Line Item Description Line Item Account
12/07/2012 PW Parts 727-49700-42400 138.64
Inv 039121899 Total 138.64
Inv 039122877
Line Item Date Line Item Description Line Item Account
12/12/2012 PW Parts 727-49700-42400 11.14
Inv 039122877 Total 11.14
41253 Total: 387.60
0208-UniSelect USA Total: 387.60
Total: 24,280.20
AP-Check Detail(1/11/2013- 9:48 AM) Page 7
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:47AM
Check Number Check Date Amount
6896-APA Minnesota Line Item Account
41254 01/04/2013
Inv 263064-12114
Line Item Date Line Item Description Line Item Account
12/28/2012 Hutmacher 2013 Membership Dues 101-41910-44330 360.00
Inv 263064-12114 Total 360.00
41254 Total: 360.00
6896-APA Minnesota Total: 360.00
4889-Community Footworks Line Item Account
41255 01/04/2013
Inv 1018
Line Item Date Line Item Description Line Item Account
01/04/2013 January 2013 Foot Clinic 101-45120-43070 244.80
Inv 1018 Total 244.80
41255 Total: 244.80
4889-Community Footworks Total: 244.80
0382-ICMA Retirement Trust-106944 Line Item Account 101-00000-21740
41256 01/04/2013
Inv 01032013-PK
Line Item Date Line Item Description Line Item Account
01/03/2013 PR#1 ICMA Contributions 101-00000-21740 610.31
Inv 01032013-PK Total 610.31
41256 Total: 610.31
0382-ICMA Retirement Trust-106944 Total: 610.31
0387-ICMA Retirement Trust-#302482 Line Item Account 101-00000-21742
41257 01/04/2013
AP-Check Detail(1/11/2013- 9:47 AM) Page 1
Check Number Check Date Amount
Inv 01032013-CS
Line Item Date Line Item Description Line Item Account
01/03/2013 PR#I Contributions 101-00000-21742 1,986.05
Inv 01032013-CS Total 1,986.05
41257 Total: 1,986.05
0387-ICMA Retirement Trust-#302482 Total: 1,986.05
0390-INT'L Union Operating Engineers-Union Dues Line Item Account 101-00000-21771
41258 01/04/2013
Inv 0102013
Line Item Date Line Item Description Line Item Account
12/05/2012 January 2013 Union Dues 101-00000-21771 260.00
Inv 0102013 Total 260.00
41258 Total: 260.00
0390-INT'L Union Operating Engineers-Union Dues Total: 260.00
MNCS-Minnesota Child Support Payment Center Line Item Account 101-00000-21780
41259 01/04/2013
Inv 01032013-MNCS
Line Item Date Line Item Description Line Item Account
01/03/2013 PR#I Deductions 101-00000-21780 323.02
Inv 01032013-MNCS Total 323.02
41259 Total: 323.02
MNCS-Minnesota Child Support Payment Center Total: 323.02
0266-Minnesota Recreation&Park Assn.Line Item Account
41260 01/04/2013
Inv 12282012
Line Item Date Line Item Description Line Item Account
12/28/2012 2013 MRPA Membership Dues 101-45120-44325 367.00
12/28/2012 2013 MRPA Membership Dues 101-45200-44325 132.00
Inv 12282012 Total 499.00
41260 Total: 499.00
0266-Minnesota Recreation&Park Assn.Total: 499.00
AP-Check Detail(1/11/2013- 9:47 AM) Page 2
Check Number Check Date Amount
TCCC-Twin Cities North Chamber of Commerce Line Item Account
41261 01/04/2013
Inv 009-2341
Line Item Date Line Item Description Line Item Account
12/01/2012 2013 Membership Dues 101-41100-44330 250.00
Inv 009-2341 Total 250.00
41261 Total: 250.00
TCCC-Twin Cities North Chamber of Commerce Total: 250.00
Total: 4,533.18
AP-Check Detail(1/11/2013- 9:47 AM) Page 3
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:46AM
Check Number Check Date Amount
0131-Beisswenger's How-To Store Line Item Account
41262 01/11/2013
Inv 255668
Line Item Date Line Item Description Line Item Account
12/18/2012 PW Supplies 727-49700-42400 9.39
Inv 255668 Total 9.39
Inv 255834
Line Item Date Line Item Description Line Item Account
12/18/2012 PW Supplies 727-49700-42400 1,730.91
Inv 255834 Total 1,730.91
41262 Total: 1,740.30
0131-Beisswenger's How-To Store Total: 1,740.30
0342-City of Shoreview Line Item Account
41263 01/11/2013
Inv 00005092
Line Item Date Line Item Description Line Item Account
12/10/2012 2012 Semaphore Billing:3850 Lexington Ave 101-43100-43810 208.65
Inv 00005092 Total 208.65
41263 Total: 208.65
0342-City of Shoreview Total: 208.65
6562-Davanni's Line Item Account
41264 01/11/2013
Inv 211795-C
Line Item Date Line Item Description Line Item Account
12/19/2012 Employee Recognition Lunch 101-41100-44390 333.30
Inv 211795-C Total 333.30
41264 Total: 333.30
AP-Check Detail(1/11/2013- 9:46 AM) Page 1
Check Number Check Date Amount
6562-Davanni's Total: 333.30
4846-Davidson,Rob Line Item Account
41265 01/11/2013
Inv 12172012
Line Item Date Line Item Description Line Item Account
12/17/2012 Escrow Release PC 12-009 101-00000-22000 686.41
Inv 12172012 Total 686.41
41265 Total: 686.41
4846-Davidson,Rob Total: 686.41
EATI-Emergency Automotive Tech,Inc Line Item Account
41266 01/11/2013
Inv CS121812-16
Line Item Date Line Item Description Line Item Account
12/18/2012 PW Supplies 727-49700-42210 65.84
Inv CS 121812-16 Total 65.84
41266 Total: 65.84
EATI-Emergency Automotive Tech,Inc Total: 65.84
0376-FirstLab Line Item Account
41267 01/11/2013
Inv 00593930
Line Item Date Line Item Description Line Item Account
12/13/2012 Training 727-49700-44395 100.00
Inv 00593930 Total 100.00
41267 Total: 100.00
0376-FirstLab Total: 100.00
0176-Frattallone's Hardware,Inc.Line Item Account
41268 01/11/2013
Inv 051259-A
Line Item Date Line Item Description Line Item Account
11/05/2012 PW Supplies 727-49700-42400 16.02
Inv 051259-A Total 16.02
AP-Check Detail(1/11/2013- 9:46 AM) Page 2
Check Number Check Date Amount
Inv 051859-A
Line Item Date Line Item Description Line Item Account
12/14/2012 PW Supplies 727-49700-42400 65.13
Inv 051859-A Total 65.13
Inv 051996-A
Line Item Date Line Item Description Line Item Account
12/26/2012 PW Supplies 727-49700-42400 5.64
Inv 051996-A Total 5.64
41268 Total: 86.79
0176-Frattallone's Hardware,Inc.Total: 86.79
0192-Grainger,Inc Line Item Account
41269 01/11/2013
Inv 9018659772
Line Item Date Line Item Description Line Item Account
12/12/2012 PW Supplies 727-49700-42400 7.31
Inv 9018659772 Total 7.31
Inv 9021749867
Line Item Date Line Item Description Line Item Account
12/17/2012 PW Supplies 727-49700-42400 120.45
Inv 9021749867 Total 120.45
41269 Total: 127.76
0192-Grainger,Inc Total: 127.76
7501-Kelly&Lemmons,P.A.Line Item Account
41270 01/11/2013
Inv 37465
Line Item Date Line Item Description Line Item Account
12/31/2012 December 2012 Legal Fees 101-41300-43040 60.00
12/31/2012 December 2012 Legal Fees 101-41300-43045 2,317.08
Inv 37465 Total 2,377.08
41270 Total: 2,377.08
7501-Kelly&Lemmons,P.A.Total: 2,377.08
AP-Check Detail(1/11/2013- 9:46 AM) Page 3
Check Number Check Date Amount
1450-League of MN Cities Inc.Trust(SP)Line Item Account
41271 01/11/2013
Inv 01092013
Line Item Date Line Item Description Line Item Account
01/09/2013 Q3 2012 Restitution Payment C#11053070 101-41300-36270 564.00
Inv 01092013 Total 564.00
Inv 01102013
Line Item Date Line Item Description Line Item Account
01/10/2013 Q4 2012 Restitution Payment C#11053070 101-41300-36270 564.00
Inv 01102013 Total 564.00
41271 Total: 1,128.00
1450-League of MN Cities Inc.Trust(SP)Total: 1,128.00
0147-Moundsview Public Schools Line Item Account
41272 01/11/2013
Inv 4827
Line Item Date Line Item Description Line Item Account
01/07/2013 November-December 2012 Facility Rental Fees 101-45120-44125 198.52
Inv 4827 Total 198.52
41272 Total: 198.52
0147-Moundsview Public Schools Total: 198.52
6252-Office Depot Line Item Account
41273 01/11/2013
Inv 1533033584
Line Item Date Line Item Description Line Item Account
12/13/2012 Office Supplies 101-41500-42010 34.61
Inv 1533033584 Total 34.61
Inv 1534622926
Line Item Date Line Item Description Line Item Account
12/18/2012 Office Supplies 101-41500-42010 15.26
Inv 1534622926 Total 15.26
41273 Total: 49.87
6252-Office Depot Total: 49.87
AP-Check Detail(1/11/2013- 9:46 AM) Page 4
Check Number Check Date Amount
8032-Pace Analytical Field Svc Line Item Account
41274 01/11/2013
Inv 121212033
Line Item Date Line Item Description Line Item Account
12/17/2012 November 2012 Water Testing Fees 601-49440-43821 554.50
Inv 121212033 Total 554.50
Inv 121212059
Line Item Date Line Item Description Line Item Account
12/17/2012 December 2012 Water Testing Fees 601-49440-43821 689.50
Inv 121212059 Total 689.50
41274 Total: 1,244.00
8032-Pace Analytical Field Svc Total: 1,244.00
4445-Pioneer Rim and Wheel Co.Line Item Account
41275 01/11/2013
Inv 1-182944
Line Item Date Line Item Description Line Item Account
12/13/2012 PW Supplies 727-49700-42400 405.09
Inv 1-182944 Total 405.09
41275 Total: 405.09
4445-Pioneer Rim and Wheel Co.Total: 405.09
1110-Pitney Bowes Line Item Account
41276 01/11/2013
Inv 12232012
Line Item Date Line Item Description Line Item Account
12/23/2012 December 2012 Postage 101-41100-43220 524.68
12/23/2012 December 2012 Postage 101-41500-43220 19.99
Inv 12232012 Total 544.67
41276 Total: 544.67
1110-Pitney Bowes Total: 544.67
2151-Ramsey Conservation District Line Item Account
41277 01/11/2013
AP-Check Detail(1/11/2013- 9:46 AM) Page 5
Check Number Check Date Amount
Inv 122112AE
Line Item Date Line Item Description Line Item Account
12/21/2012 Q4 2012 Erosion Inspections-Fox Ridge 2011-01198 101-00000-22000 234.19
12/21/2012 Q4 2012 Erosion Inspections-Pres Homes 2012-01294 101-00000-22000 234.19
12/21/2012 Q4 2012 Erosion Inspections-2026 Thom Dr 2012-00647 101-00000-22000 126.10
12/21/2012 Q4 2012 Erosion Inspections-1958 Thom Dr 2012-00870 101-00000-22000 126.10
12/21/2012 Q4 2012 Erosion Inspections-Belair/Arden Plaza 2012-00239 101-00000-22000 144.12
12/21/2012 Q4 2012 Erosion Inspections-Land O Lakes 2012-00677 101-00000-22000 108.09
12/21/2012 Q4 2012 Erosion Inspections-Arden Hills Park 227-48315-43101 144.12
Inv 122112AE Total 1,116.91
41277 Total: 1,116.91
2151-Ramsey Conservation District Total: 1,116.91
0811-Ramsey County Line Item Account
41278 01/11/2013
Inv PRRLG-001013
Line Item Date Line Item Description Line Item Account
07/07/2013 2012 Truth in Taxation Reimbursement 101-41500-43510 622.05
Inv PRRLG-001013 Total 622.05
Inv PRRRV-000558
Line Item Date Line Item Description Line Item Account
12/27/2012 2012 Voting System Payment 101-41410-43100 1,704.55
Inv PRRRV-000558 Total 1,704.55
41278 Total: 2,326.60
0811-Ramsey County Total: 2,326.60
5561-Rick Johnson Deer and Beaver Inc.Line Item Account
41279 01/11/2013
Inv 01012013
Line Item Date Line Item Description Line Item Account
01/01/2013 Deer Removal December 2012 101-43100-44040 115.00
Inv 01012013 Total 115.00
41279 Total: 115.00
5561-Rick Johnson Deer and Beaver Inc.Total: 115.00
0751-Short Elliott Hendrickson,Inc.Line Item Account
41280 01/11/2013
AP-Check Detail(1/11/2013- 9:46 AM) Page 6
Check Number Check Date Amount
Inv 264090
Line Item Date Line Item Description Line Item Account
12/17/2012 T-Mobile Red Fox Escrow Charges November 2012 101-00000-22000 612.93
612.93
Inv 264090 Total
612.93
41280 Total:
0751-Short Elliott Hendrickson,Inc.Total: 612.93
0327-Staples Business Advantage Line Item Account
41281 01/11/2013
Inv 3188022899
Line Item Date Line Item Description Line Item Account
12/13/2012 Office Supplies 101-41500-42010 234.64
Inv 3188022899 Total 234.64
Inv 3188064512
Line Item Date Line Item Description Line Item Account
12/14/2012 Office Supplies 101-41500-42010 85.48
Inv 3188064512 Total 85.48
Inv 3188064513
Line Item Date Line Item Description Line Item Account
12/14/2012 Office Supplies 101-41500-42010 374.05
Inv 3188064513 Total 374.05
694.17
41281 Total:
0327-Staples Business Advantage Total: 694.17
8372-Stephens,Stephen Line Item Account
41282 01/11/2013
Inv 01102013-SS
Line Item Date Line Item Description Line Item Account
01/10/2013 Fall 2012 Photo Project 228-41960-43100 750.00
Inv 01102013-SS Total 750.00
750.00
41282 Total:
8372-Stephens,Stephen Total: 750.00
0576-TimeSaver Off Site Secretarial Line Item Account
AP-Check Detail(1/11/2013- 9:46 AM) Page 7
Check Number Check Date Amount
41283 01/11/2013
Inv M19490
Line Item Date Line Item Description Line Item Account
12/14/2012 11.28.12 Planning Commission Meeting 101-41910-43110 227.20
Inv M 19490 Total 227.20
41283 Total: 227.20
0576-TimeSaver Off Site Secretarial Total: 227.20
0478-Truck Utilities Mfg.Company Line Item Account
41284 01/11/2013
Inv 0247460
Line Item Date Line Item Description Line Item Account
12/12/2012 PW Parts 727-49700-42400 133.74
Inv 0247460 Total 133.74
41284 Total: 133.74
0478-Truck Utilities Mfg.Company Total: 133.74
0285-Xcel Energy Line Item Account
41285 01/11/2013
Inv 350276024
Line Item Date Line Item Description Line Item Account
12/11/2012 November 2012 Utility Bill 601-49440-43810 371.07
Inv 350276024 Total 371.07
Inv 351402616
Line Item Date Line Item Description Line Item Account
12/19/2012 November 2012 Utility Bill 101-41940-43810 1,805.85
Inv 351402616 Total 1,805.85
Inv 351792822
Line Item Date Line Item Description Line Item Account
12/24/2012 November 2012 Utility Bill 601-49440-43810 54.36
Inv 351792822 Total 54.36
41285 Total: 2,231.28
0285-Xcel Energy Total: 2,231.28
AP-Check Detail(1/11/2013- 9:46 AM) Page 8
Check Number Check Date Amount
6009-Ziegler,Inc.Line Item Account
41286 01/11/2013
Inv PC050114054
Line Item Date Line Item Description Line Item Account
12/27/2012 PW Parts 727-49700-42210 69.56
Inv PC050 1 1 4054 Total 69.56
41286 Total: 69.56
6009-Ziegler,Inc.Total: 69.56
Total: 17,573.67
AP-Check Detail(1/11/2013- 9:46 AM) Page 9
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:45AM
Check Number Check Date Amount
2597-AARP Line Item Account
41290 01/11/2013
Inv 2000
Line Item Date Line Item Description Line Item Account
01/08/2013 January 2012 AARP Class 101-45120-42170 140.00
Inv 2000 Total 140.00
41290 Total: 140.00
2597-AARP Total: 140.00
CANON-Canon Business Solutions,Inc Line Item Account
41291 01/11/2013
Inv 12422119
Line Item Date Line Item Description Line Item Account
01/01/2013 January 2013 Contract Charge 101-41500-44150 879.37
01/01/2013 January 2013 Contract Charge 228-41960-44150 155.18
Inv 12422119 Total 1,034.55
41291 Total: 1,034.55
CANON-Canon Business Solutions,Inc Total: 1,034.55
0447-LU.O.E Local 49 Benefit Fund-Insurance Line Item Account 101-00000-21732
41292 01/11/2013
Inv 01152013
Line Item Date Line Item Description Line Item Account
01/15/2013 February 2013 Benefits 101-00000-21732 1,067.00
Inv 01152013 Total 1,067.00
41292 Total: 1,067.00
0447-I.U.O.E Local 49 Benefit Fund-Insurance Total: 1,067.00
JOHC-Johnson Controls Line Item Account
41293 01/11/2013
AP-Check Detail(1/11/2013- 9:45 AM) Page 1
i
Check Number Check Date Amount
Inv 00072360101
Line Item Date Line Item Description Line Item Account
01/03/2013 2013 Service Agreement 101-41940-44010 1,101.00
Inv 00072360101 Total 1,101.00
Inv 1-6250755687
Line Item Date Line Item Description Line Item Account
01/02/2013 2013 Service Agreement 101-41940-44010 4,401.00
Inv 1-6250755687 Total 4,401.00
41293 Total: 5,502.00
JOHC-Johnson Controls Total: 5,502.00
5322-MBPTA-C/O Julie Hultman Line Item Account
41294 01/11/2013
Inv 01102013
Line Item Date Line Item Description Line Item Account
01/10/2013 2013 Membership Dues 101-42400-44330 100.00
Inv 01102013 Total 100.00
41294 Total: 100.00
5322-MBPTA-C/O Julie Hultman Total: 100.00
1143-Office of the Secretary of State-Notary Line Item Account
41295 01/11/2013
Inv 01092013
Line Item Date Line Item Description Line Item Account
01/09/2013 November 2012 Utility Bill 101-41500-44330 120.00
Inv 01092013 Total 120.00
41295 Total: 120.00
1143-Office of the Secretary of State-Notary Total: 120.00
Total: 7,963.55
AP-Check Detail(1/11/2013- 9:45 AM) Page 2
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:50AM
Check Number Check Date Amount
AFFI-Affinity Plus Fed Credit Union Line Item Account
41233 12/28/2012
Inv 12282012
Line Item Date Line Item Description Line Item Account
12/28/2012 Transfer to Investments 101-00000-10100 1,000,000.00
Inv 12282012 Total 1,000,000.00
41233 Total: 1,000,000.00
AFFI-Affinity Plus Fed Credit Union Total: 1,000,000.00
Total: 1,000,000.00
AP-Check Detail(1/11/2013- 9:50 AM) Page 1
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 9:46AM
Check Number Check Date Amount
5560-Commercial Roofing and Sheet Metal Inc.Line Item Account
41287 01/11/2013
Inv 12-0012
Line Item Date Line Item Description Line Item Account
09/26/2012 Sewer Roof Repair a Booster 602-49490-45200 14,614.00
Inv 12-0012 Total 14,614.00
41287 Total: 14,614.00
5560-Commercial Roofing and Sheet Metal Inc.Total: 14,614.00
0495-Lake Johanna Fire Department Inc.Line Item Account
41288 01/11/2013
Inv 413
Line Item Date Line Item Description Line Item Account
12/11/2012 2012 Capital Reimbursement-Replace Ceiling Tiles 412-48120-45800 1,345.00
Inv 413 Total 1,345.00
Inv 416
Line Item Date Line Item Description Line Item Account
12/18/2012 2012 Capital Reimbursement-TV Replacement 412-48120-45800 533.41
Inv 416 Total 533.41
41288 Total: 1,878.41
0495-Lake Johanna Fire Department Inc.Total: 1,878.41
0811-Ramsey County Line Item Account
41289 01/11/2013
Inv PRMG-001837
Line Item Date Line Item Description Line Item Account
12/14/2012 Annual Rent-2012 101-41940-44120 98,617.00
Inv PRMG-001837 Total 98,617.00
41289 Total: 98,617.00
AP-Check Detail(1/11/2013- 9:46 AM) Page 1
Check Number Check Date Amount
0811-Ramsey County Total: 98,617.00
Total: 115,109.41
AP-Check Detail(I/11/2013- 9:46 AM) Page 2
Accounts Payable
Check Detail
User: ashley.bertrand
Printed: 01/11/2013- 10:16AM
Check Number Check Date Amount
BOND-Bond Trust Services Corp Line Item Account
41296 01/11/2013
Inv 18036
Line Item Date Line Item Description Line Item Account
12/13/2012 GO Tax Increment Funding Bonds 325-47010-46110 13,647.50
12/13/2012 GO Tax Increment Funding Bonds 325-47010-46010 260,000.00
Inv 18036 Total 273,647.50
41296 Total: 273,647.50
BOND-Bond Trust Services Corp Total: 273,647.50
0447-I.U.O.E Local 49 Benefit Fund-Insurance Line Item Account 101-00000-21732
41297 01/11/2013
Inv 01.15.2013
Line Item Date Line Item Description Line Item Account
01/15/2013 February 2013 PW Benefits 101-00000-21732 7,536.00
Inv 01.15.2013 Total 7,536.00
41297 Total: 7,536.00
0447-I.U.O.E Local 49 Benefit Fund-Insurance Total: 7,536.00
0495-Lake Johanna Fire Department Inc.Line Item Account
41298 01/11/2013
Inv 420
Line Item Date Line Item Description Line Item Account
01/02/2013 1st Payment:2013 Contract 101-42100-43130 207,270.47
Inv 420 Total 207,270.47
41298 Total: 207,270.47
0495-Lake Johanna Fire Department Inc.Total: 207,270.47
0243-Met Council Environ.Service-Waste Water Line Item Account
41299 01/11/2013
AP-Check Detail(1/11/2013-10:16 AM) Page 1
Check Number Check Date Amount
Inv 0001006659
Line Item Date Line Item Description Line Item Account
01/03/2013 February 2013 Wastewater Service Charges 602-49490-43850 52,889.26
Inv 0001006659 Total 52,889.26
41299 Total: 52,889.26
0243-Met Council Environ.Service-Waste Water Total: 52,889.26
0716-Springbrook Software Line Item Account
41300 01/11/2013
Inv INV23700
Line Item Date Line Item Description Line Item Account
10/31/2012 2013 Annual Maintenance Agreement 728-49900-43080 23,986.31
Inv INV23700 Total 23,986.31
41300 Total: 23,986.31
0716-Springbrook Software Total: 23,986.31
Total: 565,329.54
AP-Check Detail(1/11/2013-10:16 AM) Page 2