HomeMy WebLinkAboutCOW 2011-11-14 Item 5C - Resolution - Procurement Card (PCard) ProcessCOUNCIL AGENDA SYNOPSIS
Initials ITEM NO.
Meeting Date Prepared by I Maor f reviev Council review
11/14/11 CZ 11-V11K C N`)
11/21/11 CZ 5.C.
ITEM INFORMATION
CAS NUnrBi ;R: STAFF SPONSOR: CRAIG ZELLERHOFF O1tIGINrA, AGP:NDA DA'Z'E: 11/14/11
A(,FNDA I'rr_,m Trr7,I_? A resolution of the City Council of the City of Tukwila, Washington, approving and
adopting a Procurement Card (PCard) Program.
CATEGORY Discussion ,Motion Resolution Ordinance BidAward Public Hearing Other
D1tg Date 11/14/11 l�tg Date Mtg Date 11/21/11 [l�tg Date Mtg Date [17tg Date Mtg Date
SPONSOR Council JAIlayor HR DCD Finance Fire IT P6R Police Pir/
SPONSOR'S Pursuant to RCW 43.09.2855, the implementation of a Credit Card Program must be
SU�MINIAFZY adopted by the City Council. The Council is being asked to consider and approve the
resolution.
RI A'rF,WED BY COW Mtg. CA &P Cmte F &S Cmte Transportation Cmte
Utilities Cmte Arts Comm. Parks Comm. Planning Comm.
DATE: 11/8/11 COMMITTEE CHAIR: HOUGARDY
RECOMMENDATIONS:
SPONSOR /ADMIN. Finance
Com:M"Fl" T' Unanimous Approval; Forward to Committee of the Whole
COST IMPACT FUND SOURCE
FtPENDI'1'URL; RL;c )U]RL;D
$N /A
AMOUNT BUDGETED
$N /A
APPROPRIATION REQUIRED
$N /A
Fund Source:
Comments:
MTG. DATE
11/14/11
RECORD OF COUNCIL ACTION
MTG. DATE I ATTACHMENTS
11/14/11 Informational Memorandum dated 11/01/11
Resolution in draft format, with Attachment A
Minutes from the Finance and Safety Committee meeting of 11/8/11
11/21/11
21
22
City of Tukwila
Jim Haggerton, Mayor
INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Craig Zellerhoff, Fiscal Coordinator Payroll and Accounts Payable
DATE: November 1, 2011
SUBJECT: A Resolution adopting a Procurement Card (PCard) Program
ISSUE
The State Auditor's Office reviewed the City of Tukwila's PCard Program during the 2010 CAFR
Audit and found all aspects of the program to be in place with the exception of Council approval
pursuant to RCW 43.09.2855.
RCW 43.09.2855 states "The legislative body (Council) shall adopt a system for:
The distribution of the credit cards;
The authorization and control of the use of credit card funds;
The credit limits available on the credit cards;
Payment of the bills; and
Any other rule necessary to implement or administer the system under this section
BACKGROUND
The PCard Program was implemented City wide in September 2010. At the time of
implementation the City of Tukwila was already using credit cards for payment of certain
purchases by selected individuals. Due to the PCard's being similar in nature to credit cards, the
Finance Department didn't feel the need to submit for approval from the Council.
DISCUSSION
The PCard program has been well received by City of Tukwila employees and vendors. It has
streamlined the purchasing process, reduced purchase orders and the use of petty cash. As a
result, the Finance Department was able to reduce the Accounts Payable processing by two Full
Time Equivalent (FTE) positions. The PCard now makes up 70% of City purchases, virtually
eliminating the small dollar transactions from being processed by Purchase Order.
Purchasing Card Benchmark Survey results estimate a purchase made by a traditional
Purchase Order cost on average $89 per transaction. With the use of PCard's the transaction
cost is reduced to $19 or a savings of $70 per transaction. In addition the City has received
rebates totaling $47,464.11 for the period of September 2010 June 2011. We expect an
estimated rebate in the amount of $11,000 for the period of July 2011 September 2012.
RECOMMENDATION
The Council is being asked to consider this item at the November 14, 2011 Committee of the
Whole meeting and subsequent November 21, 2011 Regular meeting.
ATTACHMENTS
-Draft Resolution, with Attachment A
-2011 Purchasing Statistics September 2011
23
C
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
TUKWILA, WASHINGTON, APPROVING AND ADOPTING A
PROCUREMENT CARD (PCARD) PROGRAM.
WHEREAS, for operational efficiency, the Finance Department has prepared and
implemented a Procurement Card (PCard) Policy in the form attached hereto as Exhibit A,
"Procurement Card (PCard) Policy," and recommends the PCard Program be approved and
adopted by the City Council for implementation; and
WHEREAS, pursuant to RCW 43.09.2855, "Local Governments —Use of Credit Cards,"
the legislative body must approve and adopt the Procurement Card Program; and
WHEREAS, it is intended for this resolution to retroactively extend approval of the
Procurement Card (PCard) Program to September 1, 2010;
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF TUKWILA,
WASHINGTON, HEREBY RESOLVES AS FOLLOWS:
Procurement Card (PCard) Program Adopted. The Tukwila PCard Program Policy,
a copy of which is attached hereto as Exhibit A and by this reference fully incorporated
herein, is hereby retroactively approved and adopted, effective September 1, 2010. City
staff is hereby authorized and directed to implement the program in accordance with its
terms.
PASSED BY THE CITY COUNCIL OF THE CITY OF TUKWILA, WASHINGTON, at a
Regular Meeting thereof this day of 2011.
ATTEST /AUTH ENTICATED:
Christy O'Flaherty, CMC, City Clerk
APPROVED AS TO FORM BY:
Shelley M. Kerslake, City Attorney
Allan Ekberg, Council President
Filed with the City Clerk:
Passed by the City Council:
Resolution Number:
Attachment: Exhibit A, Procurement Card (PCard) Policy
W: \Word Processing- City \Resolutions \PCard Program Adopted 11 -1 -11
CZ: m rh
Page 1 of 1
25
26
0
ppi
Boa
n
PROCUREMENT CARD (PCard)
POLICY
2010
27
W.*
J
y�
Procurement Card Manual
Introduction 3
Whatis a procurement card? ..............................3
Consideration for departments ..............................3
How Ret a card ..............................3
PCardLimits ..............................4
PCardApplication ..............................5
PCard
6
Cardholder................................................................................................................................... ..............................7
Reconciler..................................................................................................................................... ..............................7
Department Director /Delegated Approver ..............................8
PCardAdministrator ..............................8
Accountabilitv. Ethics Control .............................10
PurchasingEthics .............................10
PurchasingOrdinance and Rules .............................10
SplitPurchasin2 .............................10
Agreement Si2natures .............................10
EmployeeTransfers .............................10
Accountabilitv& Controls .............................10
PurchasingObstacles .............................11
Lost Stolen or Cancelled PCard .............................11
A Sample of items that can be purchased with a PCard .............................12
M odi f vine Transaction Limits or De
13
PCard Use While Tr
14
Misuse Car
15
O nline Transaction Ma
16
USBank Online Setup .............................16
OnlineAccount Lo2in .............................21
Updatingthe GL Account Code .............................23
Change the GL Account Code by Ouery .............................26
Change a GL Account Code for multiple transactions .............................31
Apply multiple GL Account Codes to a transaction .............................34
Printingmonthly statements .............................36
R econcili at ion Process
41
StatementReconciliation .............................41
A p p rova I
42
FinanceReview .............................43
PCardPavment .............................43
RandomPhvsical Audit .............................43
Lost Receipt .............................43
Who to contact
44
Appendix
PCardFlowchart ..............................A
PCardApplication ..............................B
PCardTransaction Log ..............................0
PCardAffidavit
D
PCardProcessing Calendar
E
Page 2 of 45 29
30
J
LL
y�
Procurement Card Manual
INTRODUCTION
What is a Procurement Card (PCard)
The City of Tukwila procurement card is a commercial credit card to be used specifically for
purchasing goods and services for the City. The function of the PCard is confined to official use
only and must never be used for personal expenditures.
The City of Tukwila Procurement Card Program is designed to:
expand purchasing options
generate revenue for the City of Tukwila through a rebate
reduce the use of petty cash funds
streamline the small dollar purchasing process by making it simpler and faster
reduce the number of requests for special checks
reduce paperwork, transactions and checks associated with standard purchasing
and payments
eliminate the need to use personal funds
allows for some purchases under emergency conditions with approval
What to consider when determining a PCard cardholder.
What type of purchases will the department be making with the PCards?
What are the needs within a department?
Who will be purchasers and who will be reconcilers in a department?
When the PCard is used, is there a fee attached to using the card?
Who is responsible for the allocation of the appropriate budget object coding
for each purchase?
How to get a PCard
A Department Director will make the assessment of who receives a PCard by determining
the purchasing needs within their department. The employee will need to complete a City
of Tukwila Procurement Card Application and have their Department Director approve the
application. The completed form is submitted to the PCard Administrator who will request
the PCard online through US Bank. All employees of the City of Tukwila must attend a PCard
training session conducted by the Finance Department before receiving their PCard. The
training session will be held at regular intervals based on need. Contact the PCard
Administrator by email at QcardadminC@ci.tukwila.wa.us for questions about the PCard
program.
Page 3 of 45 31
J
y�
Procurement Card Manual
INTRODUCTION
PCard Limits
PCard Limits can be assigned transaction limit as well as a monthly total spending limit. The
limits are important controls to reduce unnecessary purchases, maintain purchasing
authority by individual and limits fraud or abuse. Limits are assigned by the Department
Director when approving the Application form. There are five limit levels, four are
predetermined with a set per transaction limit and total spending per month (see table
below.) The fifth level can be assigned an amount needed for the purchasing needs of the
PCardholder.
l
501
500 2,500
$1 $5
1 10,000
$2,500 25, 000
32 Page 4 of 45
0
J
d
y�
Procurement Card Manual
INTRODUCTION
PCard Application
The PCard Application form will contain the terms and conditions required of the
cardholder. The PCard is to be used only for official City of Tukwila purchases as authorized
by this policy. Under no circumstances shall personal purchases be charged to the City's
procurement card, even if the intent is to reimburse the City for such charges. Although the
card is issued to a specific employee, it remains City property and may be rescinded at any
time. The PCard application can be found on TukNet under the Finance Department (See
appendix "B" for sample form).
City of Tukwila
Procurement Gard (PCard) Application
This form Is used to apply for update or cancel a City PCard All fields are required unless otherwise noted. If you have
questions, please contact the PCard administrator by±email at pcandadnim( ei.t.lkarila.wa.41s.
Request Type. Apply for PCard Update Existing PCard Cancel PCard
Employee Ilnformatlon;
F�Y•st Name Middle 1,1,ar Last Name
Emoloy Ndumn•er ❑snanment Div sic!a.. Email address
Emplo P 1C and User .fig reeme nt. (Far cart appficarior£ o my Enoec not appip to cart up:+da ?ea or carrcedfataonc,i
By signing below I Indicate that I understand these term and agree to be bound by and comply with the City of Tukwila
PCard poHries. including, but not limited to each of the following, as a condition of receiving and continuing to have
authority to use a City of Tukwila PCard:
Select the check box next to each statement to indicate you have read each of the fofiowrfrig:
I am the only person authorized to use the card and will only charge City of Tukw fla business- related purchases. Use of
card for personal purchases, may constitute fraud and could result in disciplinary action, including termi- nation.
I will review my account regulad'y {vieek.ly review recommended), allocate charges, to other than default budget, if
necessary. resolve any discrepancies with supplies andior the card provider, and forward all receipts to the
reconcileriapprover for monthly purchases charged to my card: anthin 2 drays of the statement close date.
m the event my PCard 1s bosh, stolen or compromised, I will immediately contact US Bands Customer Service
at 817+0.344.5656 and the PCard Administrator by e-mail to pcarc1aamin o@ci tukwila.wa.!us.
I will use my PCard to purchase Items within my assigned spending limit and approvals as determined by
my departnr nt. Splitting of purchases to circumventtransactaon limits are pmhi'bited and•w,ill result in
cancellation of the card.
In the event my employment with the City of Tukwria ceases for any reason I will return my PCard
immediately to the Finance Department.. I also agree to surrender my PCard Upon request or if my reporting
relationship changes and I no longer need a PC and.
I have printed and read the PCard Manual.
II acknowledge that this card may be used for the purposes as described above, and any use for personal
purchases or any other unauthorized use with violate the state ethics law, chapter 42.52 RCLtid and City Policy. II
expressly permat the City of Tukwila to deduct from my paycheck any amount charged on the card- for an
unauthorized purchase.
Emplcy-- aig :,alure fF :mt. KII. Last NAarnei Date
Manager Approval
By approving this application I acknowledge that
I agree this spending Innat is at or below the aelthorized spending limits for this mclividual
I .sill review and approve this individuals PCard activity statement each month within the prescribed time frame
I will promptly investigate and take proper action to stop misuse or muse of the card
I will notify the Finance Department mirnediately if this cardholders employment is terminated for any reason in
advance of such termination, if practicable
PCa ^a Lmit iLava•,' Fire requires Grtyr'dnxini ;trafnr. 'Finance Dlrector Apprvaafl
Le•.e One 5500 per transackc.. 52.5470 #tai per month Level Three 5!,500 peg tran saction S ;0,000 total pex n
Levu Tkv� V,0,4 per transaction :55,CCQ total pert nno -th Level Four $2,5170 per Rrasactrz 5[5,1]x4 total per nw lh
Level Fkve- S per transactor: 5 instal per rent
U Huc get Ndum,DS7 I manger a,ppmvai and Date
Deaartment u irectc- Approval and Date I �Inance D €rect€- �r, ;h�ti_;ard kdm rtlzrrat^at.5np va. and Lrate
Page 5 of 45 33
IL
0a
Procurement Card Manual
ROLES
Procurement Card Roles and Responsibilities
There are four roles within the PCard process. They are the cardholder, reconciler, approver
and PCard administrator. The duties and responsibilities of each role are listed below.
34 Page 6 of 45
J
LL
y�
Procurement Card Manual
ROLES
Cardholders Are the department purchasing agents responsible for appropriate
purchases, obtaining sufficient documentation for purchases and performing the first
level of transaction review of their PCard purchasing account.
Responsibilities:
Attend a PCard training session.
Familiarize yourself with the City's administrative policies and procedures for
purchasing goods and services.
Make responsible and appropriate purchases.
Maintain online transactions. Make GL account code corrections. (If a computer
is available.)
Maintain all supporting documentation (receipts) /confirmations for each
transaction.
Print the online statement and match all supporting documentation paperwork
to the transactions listed on the statement.
Provide your department reconciler with all the necessary paperwork to prepare
PCard Packet for approval. (If computer is not available for printout, provide
reconciler with supporting documentation for each transaction.)
If Cardholder prepares own PCard Packet, cardholder must match statement to
PCard Transaction Log and submit to Department Director by the end of day on
workday three (WD3).
Reconcilers Are responsible for collecting card holders' supporting documentation
at the end of each transaction period. They will reconcile cardholder PCard purchases as
determined by the Department Director. This includes ensuring each transaction has the
correct supporting documentation attached and the correct General Ledger (GL)
account Code listed on the statement. They will work directly with the accounts payable
team.
Responsibilities:
Attend a PCard training session.
Familiarize yourself with the City's administrative policies and procedures for
purchasing goods and services.
Develop procedures within your department for managing and gathering all data
pertaining to a PCard purchase.
Help manage those individual accounts where computer access is not available.
Print all online statements for all card users who do not have online access.
Collect all department PCard statements and supporting documentation for all
cardholders within your department.
Page 7 of 45 35
J
LL
y�
Procurement Card Manual
ROLES
Reconcile all statements to the PCard Transaction Log and verify supporting
documentation is attached.
Submit statements to department director for approval by the end of day on
workday three (WD3).
Turn in all documentation to the Finance Department (accounts payable) by end
of the day on work day five (WD5).
Liaison to Accounts Payable Department to ensure all statements are collected
and answer questions related to specific purchases.
Department Director /Delegated Approver: Is responsible for
expenditures within their responsibility, and is ultimately responsible for the
management and success of the PCard Program in their Department. The Department
Director or delegate approver will have the final approval of all PCard purchases for
their department.
Responsibilities:
Attend a PCard training session.
Should be familiar with the City's administrative policies and procedures for
purchasing goods and services.
Makes determination of who should have a PCard within their department.
Provides the authorizing signature for each PCard agreement form and assigns a
default GL Account Code.
Delegate PCard roles and responsibilities for the department.
Establish internal procedures and identifying PCard responsibilities for
participating department individual.
Upon request, the administrator can monitor all department cardholder activity.
Approves monthly statements for purchases and proper G/L accounting.
Confirms purchased items are received and used for City of Tukwila business
purposes only.
PCard Administrator The PCard Administrator oversees and manages the PCard
program for the City of Tukwila. They are responsible for program functions and training
of the PCard process and working directly with US Bank.
Responsibilities:
Maintains and establishes guidelines /training for PCard program.
Establishes the policies and procedures for the PCard process.
Maintains all PCard user agreement forms.
Requests all new PCards through US Bank.
Maintains all cardholder information through the US Bank online program.
36 Page 8 of 45
J
y�
Procurement Card Manual
ROLES
Upon request from a Department Director, this individual will make a change to
a card holder's monthly or individual transaction limit.
Page 9 of 45
37
J
y�
Procurement Card Manual
ACCOUNTABLILITY, ETHICS CONTROLS
Purchasing Ethics
As a public employee, you are responsible for following the City of Tukwila and State of
Washington's ethics rules. Do not conduct any business with members of your family or with
businesses with which you have a financial interest. Any questions about this should be
directed to your supervisor or department head.
Purchasing Ordinance and Rules
Normal requirements (when applicable) for written quotes, competitive bidding, waiver
justification, dollar limits, necessary approvals, etc., cannot be circumvented by use of a
procurement card. The PCard does not relieve City employees from prudent expenditure of
City funds and obtaining the best value for goods and services.
Split Purchasing
Split purchases to circumvent transaction limits are prohibited. A split purchase is defined as
multiple transactions with the same vendor for a single purchase on the same date when the
combined purchase exceeds the single transaction limit on a card. Contact the PCard
Administrator if you require a temporary change to PCard single purchase limits.
Agreement Signatures
Do not sign any supplier agreement. If the supplier requires a standard form to be signed, send
the agreement to the Finance Department for review. Supplier agreements protect their
interests, and may need to be revised in order to protect the City.
Employee Transfers
An employee who has an existing card and transfers to another City position under a different
supervisor or budget authorization requires an updated card approval to change default
accounting, approver contacts and card authorizations. It is not necessary to reissue new cards
for transfer and receiving supervisors. The cardholder is responsible for assuring card transfers
are completed in a timely manner.
Accountability Controls
The PCard Program empowers departments and their personnel to purchase and pay for
certain goods and services quickly and easily. Within the general constraints of the policy,
departments have discretion to determine who is assigned cards and the level of procurement
authority given to individual employees.
38 Page 10 of 45
J
LL
y�
Procurement Card Manual
ACCOUNTABLILITY, ETHICS CONTROLS
Accountability for proper oversight, establishing internal controls, assuring compliance by
employees, and maintaining necessary records and documentation of PCard activity are
primarily department responsibilities.
Cardholders, designated PCard approvers and Department Directors are responsible for the
proper safeguarding of the card and to ensure its proper use, including appropriate and timely
review /approval of transactions and payments, reconciliation of statements, maintenance of
records and documentation, and compliance with the PCard Policy. Department Directors
should establish appropriate internal control and monitoring procedures that provide for
review of a cardholder's transactions, proper receiving of goods ordered and periodic review of
overall PCard program activity for their department. Each department's internal policies may
va ry.
Purchasing Obstacles
When making a purchase, there are procedures to keep in mind.
Know your 3 digit PIN on the back of your card.
When asked for an address by a merchant, always provide them with the City of
Tukwila's main address of 6200 Southcenter Blvd, Tukwila, WA 98188.
When asked for a zip code at point of purchase, use 98188.
If a purchase is declined, call US Bank customer service at 1- 800 344 -5696 or email
pcardadmin @ci.tukwila.wa.us.
Lost, Stolen or Cancelled Cards
The City of Tukwila is liable for all transactions until the PCard is reported compromised, lost or
stolen. However, it is the responsibility of the cardholder to immediately report fraudulent
charges, lost or stolen cards to both the bank and the PCard Administrator. To cancel a card,
email the PCard Administrator at Pcardadmin@ci.tukwila.wa.us.
Page 11 of 45 39
J
y�
Procurement Card Manual
ACCOUNTABLILITY, ETHICS CONTROLS
A Sample of items that can be purchased with a PCard
Advertising (no monetary limit when pre- approved)
Airfare
Books or manuals
Car rental
Conference services /registrations
Copier rentals/ monthly maintenance agreements
Event planning
Food (when allowed by City policy, per diem is not allowed if PCard is used to purchase food
while in travel status)
Fuel (while in travel status for rental vehicles if employee doesn't have a "Pacific Pride" card)
Express mail
Lodging
Mat cleaning
Materials and supplies
Memberships
Office Supplies
Postage
Printing /Copying services
Professional licenses
Registrations
Software (must have IT approval before purchasing)
Tools
Training
Utilities
Water service
40 Page 12 of 45
J
LL
y�
Procurement Card Manual
TRANSACTION LIMITS OR DEFAULTS
Modifying PCard Transaction Limits or Defaults
All requests for increasing single or monthly transaction limits need to be approved by a
Department Director and emailed to the PCard Administrator.
Temporary monthly limit increases requires written approval of a Department
Director or department personnel with delegated department budget authority in their
absence. This can be accomplished by an email request from the Department Director
and is forwarded to the PCard Administrator.
Temporary single transaction limit increase requires a written approval of a
Department Director or department personnel with delegated department budget
authority in their absence. This can be accomplished by an email request from the
Department Director and is forwarded to the PCard Administrator.
Permanent monthly or single transaction limit increases requires completing the
PCard Application form for changes and sending it to the PCard Administrator. This
request must come from the Department Director or a person with budget authority.
Changing default budget code requires completing the PCard Application form and
sending to the PCard Administrator. This request must come from the Department
Director or a person with budget authority.
Changing employee profile information can be accomplished by emailing the Finance
PCard Administrator with the information request.
Reconciling access requests need to be requested with the approval of a Department
Director or an employee with delegated department budget authority. The Department
Director or designated employee sends an email request to the PCard Administrator,
noting required access changes.
Page 13 of 45 41
J
y�
Procurement Card Manual
USE OF CARD IN TRAVEL STATUS
PCards should be used for the following travel expenses
Conference registration
Airfare
Lodging
Room rental for meetings
Meals when per diem is not requested (employee is responsible for purchase amount
greater than allowed for geographic area of travel and must reimburse City at time of
reconciliation)
Required transportation (i.e. rental cars, taxi, bus, shuttle)
Fuel
Parking
Tolls and ferries
PCards cannot be used for the following expenses
Meals when a per diem meal allowance is requested by the traveler
Boot allowances /reimbursements
All listed permissible travel related purchases MUST be accompanied by an itemized receipt.
not just the credit card receipt. All City personnel in travel status are accountable for travel
policy compliance. See Policies and Procedures, Finance 03 -06, "Travel Expenses While on City
Business
When not using a per diem for meals, the City policy needs to be strictly adhered to. A tip of no
more than 15% in total can be added to any meal receipt. No alcoholic beverages at anytime
can be charged on a City credit card. All expenses not approved must be paid back to the City in
a timely manner or deducted immediately from an employee's pay check.
When a receipt of any type is lost, a PCard Affidavit (see appendix "D form needs to be
completed by the cardholder and signed by a Department Director and PCard Administrator.
Affidavit can be found on TukNet under Finance.
Employees must be sensitive to public expectations regarding the use of public funds and
employees are expected to use good judgment when conducting City business. Improper use
will result in your card privileges being revoked.
42 Page 14 of 45
Card Misuse
Although the City is liable for the Procurement Card Program and card activity, the cardholder is
responsible for the safekeeping of the card and its proper usage. By using the PCard, the
cardholder is accountable for the expenditure and use of City funds. Misuse of the PCard that is
determined as personal, will result in the cancellation of the PCard and disciplinary proceedings
including termination as appropriate.
Cardholder Misuse includes:
Personal purchases
Allowing others to use an individual card
Using card in violation of policies, directives or procedures
Allowing improper charges to go undetected or unresolved
Using card to make purchases through a merchant that may constitute a conflict of
interest (ethics violation)
Repeated incidents of missing receipts, disputed charges, lost or stolen cards
Splitting charges
Delivery of goods to location other than city work station
Not maintaining necessary documentation of card transactions and purchases
Not submitting documentation in a timely manner for transaction approvals
Not properly and promptly reviewing /reconciling transactions prior to payment
Using card to circumvent other City ordinances, policies, rules or procedures
Since the card is issued in the cardholder's name, all purchases are assumed to be made by the
cardholder. Be aware that improper use may result in your card privileges being revoked. The
PCard Administrator is the final authority in revoking an employee's card.
Page 15 of 45 43
J
LL
y�
Procurement Card Manual
US BANK ONLINE SETUP
US BANK Online Access
Cardholders and reconcilers are required to setup an account with US Bank Access online at
httr)s: access .usbanl<.com /cPsAppl /index.isp to manage purchases. The US Bank website is
used to review and update transactions with GL Account Codes or to dispute a purchase.
How to set up an online account
v i https ushank.
File Edit Oew Favorites Tools Help Select
Favorites
Welcome to Access Gnline
U.S. BenkAccesV online
g ii Page Safety Tools (0-
a
M
Login into website Password:
given above
Click "register im
online"
Fnrnn, vnnr nasswnrd?
Ranictar inlina
N!PhsitaJRmrvaer Renuirp.ri
d)
Ali of serving youP
Done
v
Internet ",100%
44 Page 16 of 45
Pb ank
Welcome to Access Online!
condsc€ u
Please enter the inforimation below and login to begin.
,..odli7
urgeniatian Shad Naime:
Reeister Online
user to
Login into website Password:
given above
Click "register im
online"
Fnrnn, vnnr nasswnrd?
Ranictar inlina
N!PhsitaJRmrvaer Renuirp.ri
d)
Ali of serving youP
Done
v
Internet ",100%
44 Page 16 of 45
kL.6 :.�1'r� tC
Q
Gl
e https usbank,com
File Edit View Favorites Tools Help 4�,Convert Select
J Favorites 49
Add Accounts
US, Rank. Access. Online
Procurement Card Manual
US BANK ONLINE SETUP
cj
I
ft Page Safety Tools d
!Mbank Online Registration
Add Accounts
Contact Us
Lo in To join .CCes's' Online 4ou vill need a rninirnum of ona slid accountnumher. 'Register This :croimC' ,vill
g
validate a single account. 'Additional Account" ,+gill alla,w multiple accounts to he included in the registration
process.
required
„PwN Orgam�ti7n �h�rtflame "`"M,,,,
L
1 COTU
2 A.ccountPJumher`"
;-Bacicto Lorai Page
AI I of setving you
account Expiration Date:
t:luntW Year
.Jan V 2010
Done
Internet 1 ^t, 1001
Setup Login
1. Enter "COTUK" under Organization Short Name
2. Enter the 16 digit PCard number and expiration date on front of PCard
I Click "Register This Account"
Page 17 of 45 45
J
LL
y�
v P, https usbankmm
File Edit View Favorites Tools Help q�k onvert 'select
Favorites
Licensing Agreement
U.S. Bank Access=' Online
.W
rat Page Safety Tools
n
CITY OF TUKIWILA.
Licensine Aereement
Read Licensing Agreement
Click "I accept" at the bottom of page to use online services. This is required to
use the PCard
Procurement Card Manual
US BANK ONLINE SETUP
46 Page 18 of 45
Licensing Agreement
Please read and 3CCeptthe Licensing A'.greementt0 COntin Lle
Access 09711ne Terms of Service
1 A•.Ck.N .VLED3hr1ENT AND ACCEPTANCE 1 F TER1r15 1 F ACCESS 1 NLINE
Access unline, owned and operated hr U S 63nk National Association i "U S 631W";, is provided to the
Customer under the terms and conditions ofthis Access mline Terms of Oerdi ce 1ATO; which incorporates hr
reference any operating rules or policies that i he published by U S 63nk The A'.TS 3s it i hereafter he
amended or modified without notice, comprises the entire agreement between Customer and U S 6311E and
sllpersedes 311 prior agreements between the parties regarding the SUbjeut matter Contained herein. 6y
logging on to Access 1nline and clicking the "1 Accept" Dutton, you are indicating Customer's agreement to he
hound Dy 311 ofthe terms and conditions ofthe A'.TS and that you have the 31-Ithorityto so agree on behalf Of m
Customer
In consideration for access to Access Online, Customer agrees to 11j provide certain Current, complete, and
accurate information Shout Customer 3s pro mpted to do so hr A'.ccess 0 nIine, and i2j maintain and update
this information as required to keep it current, complete and accurate All information requested on original
Sign LIP Shall be referred t0 as registration data i "Registration Data FLlrtherm Ore, CLIstomer gr3nts U S
3310. the right to disclose to third parties certain Registration Data 31DOLIt Customer in the aggregate, however,
such disclosures will exclude CLstomers 113me, mailing address, a -m311 3ddress, 3CCOLInt and phone
111-lmber Unless 11; CLIstomer expressly directs U S Bank, Or 311V Other person CLIstomer m3y spe CIfiC311y
designate t0 disclose such information or 92; U S 6311k is required to disclose such information Dy any
3pp1ic31Dle I3W or legal process served on U S 6310
If any infor1r13tion provided Dy Customer is inaccurate, U S 630 retains the right to terminate Customer's
;Done
Internet A 1%100%
Licensine Aereement
Read Licensing Agreement
Click "I accept" at the bottom of page to use online services. This is required to
use the PCard
Procurement Card Manual
US BANK ONLINE SETUP
46 Page 18 of 45
J
Online Registration
User ID
Procurement Card Manual
US BANK ONLINE SETUP
e https .1...
File Edit View Favorites Tools Help convert ti select
Favorites
P
Password and Contact Information j car Page Safety Tools
Enter a User ID U.S. Bank Acces
Online
7-12 alpha characters long bank.
Onfine Registration
Enter a password in the
Pa —word and cant -t inf-riatimin
Password field
Confirm your password by re-
User ID N—e.
entering the new password
Authentication
Select a question from the
Authentication Question
Enter your answer
Contact
Information
Enter your name as shown on
Auth E ntiC 3ti Gil
the PiCard
For address use
6200 Southcenter Blvd,
Tukwila, WA 98188
Enter your work phone and
fax number
Enter your work email
address
Finish
Make sure all red asterisk
boxes are filled in
Click the "Continue" button
The "Client Home Page" will
display
All of IZ7 servig you
Done Internet 65%
r r
Page 19 of 45 47
J
LL
y�
Procurement Card Manual
US BANK ONLINE SETUP
U.S. Bank. Access=' Online
I
(User ID has heetn successfully added.
Transaction Management Message(s) from Access Online
Account Information .v :'el colnne to Access mllnel Stretch VOUr pfogf3m limits 3nd stfe3mllne 33finent processes with -'.cce ss
Reporting mllne, OUr InnoV3tive pfogf3m rnan3gernent 3nd reporting tool. This''weh- en3hled tool effefs 3 fe3tLlfe -fl ch
My Personal Information 313tfofinn that c3n he e3SiIV CO nflg Ured 3nd deplo to meet ti011f LInigUe needs. Access 4'OUr 33Yl rent
solutions anytime, 3nvvhere With •.ceess online
Home xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx .xxxxxxxxx. xxxxxxxxx. xxxxxxxxx. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx .xxxxxxxxx
Contact Us Bianvpnlla silt A.ccass Onlinal Rapnllssa7 las limitas de vntre prngrannma at simplifia7 les pmcasslls de
331ement 3vec .ccess Online, notre outil 113V3terr d'et3hlisserinent de r3pports et de gestion de progf31
Get Ortil Internet offre rile 313te -forme riche en fondionn3lites qri pert titre 3iserinent confgrree et deplofee
p OUr fepondfe 3 Vos hesolns p3rtl CLlllefs A'.ccede 7 3 VOS sOILltlons de p3iement en tort temps, OU qUe VOLIs
soye7 3vec Access mline
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxx. xxxxxxxxxxxxxxxxxxx. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx .xxxxxxxxx
All of 4 s rving you°
e
Gone Internet
Client Home Paee
Transaction Manaeement
Review Transactions
Change Account Coding
Dispute a charge
Account Information
Statement
Account profile
Be porting
Review transactions in PDF or Excel format
My Personal Information
Change password
Change contact information
Manage Accounting Code Favorites
CITY OF TIJI4
Language Selection
Arnefic3n English v
R CARD
1
3
a
too
48 Page 20 of 45
J
LL
y�
Procurement Card Manual
ACCOUNT LOGIN
Account Login
The "Transaction Management" link allows cardholders and reconcilers to view current and
past PCard purchases. It also enables the cardholder or reconciler to change the GL Account
Code from the default accounting code. The following steps provide examples of how to view a
transaction and update GL Account Codes.
t ,eq. Welcome to Access Online gf, U t Page
U.S. Ban Acce55' OnHne
Account Login
Go to website
httr)s://access.usbanl<.com
/cr)sArml /index.isr)
Save as favorite
Enter personal login
information
Click "Login"
View Transactions
Click on Transaction
Management
�EMbank. Welcome to Access 0ini iniel
Contact us Please enter the information below and login to begin.
n
O Short flame:
V
User to
Welcome To Access Online ri Page Tools
t
A
U,, Barak Access° Online
Mbank, Message(s) from Access Online
'elcorne to Access Online! stretch your program limits and streamline
aun d #n niaMww�� Online, our innovative program management and reporting tool. This ,v
Transaction Pilanagemegt platform that Lan be easily corifigtued and deployed to meet your tlniqu
`AccoW� MffTf ter' solutions anytime, any with Access Online
Reporting a RaKKKRaKK KKRRaKKRa KRaKKKRaK RaKKRaKKK KKRaKKRRa RaaKKRaKKKRaKKKR
Data Exchange
My Personal Information Dienvanue surAccess Online! Repotlsse_les imites de votre program
paiement avecA.ccess Online. notre outil novateur d'etahlissernent de r
Get outil Internet offre Line plate -forme riche en foncti onnalites gtli peut
Home p our repondre a vos laesoins particuIiers. Acrede_a vas solutions de p
Contact Us soye; avec Access Online
a
w
:Done Internet ;100 I
Page 21 of 45 49
Procurement Card Manual
ACCOUNT LOGIN
Transaction Management 9 fii Page Tools
U.S. Bank Accessr Online
View Transactions
Click on
"Transaction List"
Management
Account A.dministration
and add comments to
Transaction List transaction inforrination.
Account Infori-nation VIRW PrRVMIIq (.Vr.IR
Reporting Data resents the Transaction list for the previOLIS
My Personal Information cvcle
H—o
Contact Us
Account Search
Enter the last name
of cardholder to
view their account
All of serving you
Transaction Management Account Search
U.S. Bark Access= 0I
Inv--i rk inn-/. 4
rWj Tools
A
M bank.
Transaction, Management
Search and Select an Account
Account Ad ministration
Transaction Management
;111 1
Cardholder Account Search
Account Information
Reporting.
Search for 3n 3CCOUnt DYCadholder Account Number. N 3rne. Of Social 380.jrity Nun niter. You can also find a
Data Exchange
cardholder 3ccount L, frst q.p., for a Ibinaninn Account.
Ty Personal Information
ACCOUnt 111.1ni
me
Contact Us Narne Name
Mir
Done
Internet t 1001
50 Page 22 of 45
J
LL
y�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
Updating the GL Account Code
The US Bank transaction management web page allows viewing of PCard
transactions /purchases for the "open" billing cycle. Current transactions can be viewed and GL
Account Coding changed through WD2 after the statement close date. Past billing cycles can be
viewed by selecting the "Billing Cycle Close Date" function as shown below.
All purchases are assigned a default GL Account Code by PCard as assigned by the Department
Director. All GL Account Codes should be changed to the actual GL Account Coding by the
cardholder or reconciler once a transaction is available online, generally in 24 hours.
The following are examples of how to make single and multiple GL Account Coding changes for
a transaction.
e httpsifaccessusbankmmfcpsApplfUSE ComServlet
File Edit View Favorites Tools Help
r. Card Account Summary with Transaction List
Data Exchange 1 Card Account Summary
My Personal Information
ccaunt Number 9319
Home. Pcwllnt PJame: P ""'q, 13 EELLERHOFF
Contact us Billing I,rele Close Elite Pen v
1 +I Search Criteria
1 -1 Transaction List
sY A
I I V I r� ,J Page ,f Tools
.vwm ww
This page shoNvs an
J ar
open billing cycle. Past
billing c� -c les can be
shown by nsing the
a1ToNv down function
and then clicking the
Re¢ni -F
c ir., A11 shave
I unms d ?JI °h nun
Sdect Status
Trams
merdmt
(III
Amount
Detail f
Accouffling Code
Date D ate
07719 07121
COf.1PLETE OFFICE
296- 6289959, oN
$227.76
si 598408
EIAAA AS n14 240 31 MI,
07119 07!21
COMPLETE OFFICE
206 6289959. iN,A
$152.21
k i i 599573
EIAAA A5 F14 2R0 3l AAI,
07716 0719
COf.1PLETE OFFICE
206 6280059, oN
$589.11
iii 599376
EI000.05.514230.31.001
0714 0716
COMPLETE OFFICE
206- 6280059,iIiA
$1,240.09
tai; 598408
EI00.05.514.230.31.001
W715 07.16
PUGET SOUND FIN.ANCEOFFIC PIJY�LLUP, dA
$159.90
0 3 3
dul tll]IP
iU! Cispct Ary Rasllccstsd JU (yiUl
Tr Ceteil Lxvel
Internet
0
Page 23 of 45 51
J
LL
y�
}.ccmmtPJumher 0 .9818
Home AcI.UntNaOn GR?.IGZELLERHOFF
Contact 0s Billing CAR Close Date Open
D "t
1 +1 Search Criteria R= t— r.W
I I Transaction List
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
eLti Ei Rurchai
07!19
OlE1
COMPLETE OFFICE
206 6280059 a?
$227.76
9 99376
Pinion OF F14 2 �1 001
A) 598408
Eino op F14 DO �i on i
07119
07 ?21
COMPLETE 0FFICE
2066266059 Nx
$152.21
07116
0719
COMPLETE OFFICE
206- 6289069.
$589.11
07,'14
0770
COMPLETE OFFICE
2061 '"Ai
$1,240.09
07115
0T16
PUGET SOUND FINANCE OFFIC
PUY,ALLUP, t ^J?.
$150.00
iq1 cin t_o
Al Reeiic tso
H) ni7
T-- cet9ii --,-1
R_=-1
zts
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
eLti Ei Rurchai
Wi Aoeoun Code
98408
'it)
9 99376
Pinion OF F14 2 �1 001
A) 598408
Eino op F14 DO �i on i
o
Hilift
Internet a 100°!
Undate Individual Transaction GL Account Code
To change the GL Account Code on a individual transaction, select a line
item by:
Clicking the check box to the left of the transaction to be changed and
then click on the "Reallocate button" on the bottom of screen.
OR
Click on the Accounting Code to go directly to the reallocation page.
52 Page 24 of 45
J
LL
y�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
P hops ilaccess usdank mmicpsApplil156Com5ervlet g
File Edit View Favorites Tools Help
W Transactmn Management- Reallocation Worksheet yj CC;![ Page Tools
n
U.S. Bank Access< Online CITY OF TUKINILA
Tob ank Transaction Management
Home
Contact Us required
0A'2312010 COMPLETE OFFICE '03.21 Add kllnn �E Q 1101010.10E.514.230.31 01
Q Les,
"'141 o rJ9t: ",Y!J
o
Fackt0Trairsaction List
All of 7 serving you
Internet
Undate Individual Transaction GL Account Code
Change the GL Account Code and or Project Account Code (only valid
values are accepted)
Click "Save Allocations"
4, 100%
Page 25 of 45 53
Reallocation Worksheet
Account Administration
I Cab Account number 21 A, uR.:l 1a ZELLERRCFF F'.Ait Acne.
Tran saction Management
Card kcccunt List
Reallocate transactions by changing the accounting information to allocate the amminita a different cast
caliber. Tu allocate to additional accuuiding Ludes, LliLk.ihe -.00 Alluc link..
A—um Information
Reporting
after modifying the allocations, click the "Cade 4.3cations button to save changes. ELClUde transactions from
Data Exchaxge
the save by selecting "Remove Trar iorns',' checkhozes and aptionallP clicking the Remove Transaction
My Personal information
c. button
Home
Contact Us required
0A'2312010 COMPLETE OFFICE '03.21 Add kllnn �E Q 1101010.10E.514.230.31 01
Q Les,
"'141 o rJ9t: ",Y!J
o
Fackt0Trairsaction List
All of 7 serving you
Internet
Undate Individual Transaction GL Account Code
Change the GL Account Code and or Project Account Code (only valid
values are accepted)
Click "Save Allocations"
4, 100%
Page 25 of 45 53
J
LL
y�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
Change a GL Account Code by Query
Valid City of Tukwila GL Account Codes are available for lookup on the US Bank website if you
are unsure of correct GL Account.
08!13 08116
SEA. LIGHT MET4 ",ANTE4r1 208- 684 -3000,
1%A..
$418.86
08113 08116
SEA LIGHT METkMNTE -111 20C -684 -3000,
1NA
$9.18
08}13 0916
SEA. LIG HT 11 ETkANTE -4,1 200 684 -3000,
AIA
$2421
08113 08116
SEA LIGHT 1JETAVANTE -I'd '205- 584- 3000,
WA
$'29.59
08113 09,
SEA LIG HT ICI ETNvANTE -1,1 206684- 3000,NA
FI000 OF. 114 ^M 31 001
$8174
0813 08116
SEA LIGHTMETMANTE -10 206 684- 3000.1NA
$9.18
00113 0 T1 6
SEA. LIG HT M ET VA.NTE -1,1 206- 604 -3000,
0'%'A.
$461.70
08113 08116
SEA LIGHT I,IFT4V..ANTF -1,1 206 684 -3000..
'A'A
34,64874
08113 08116
SEA LIGHT NETAwANTE -kl 266- 684 -3000,
NA.
$2,197.32
00117 00116
SEA LIG HT U ETKMNTE -h1 206- 604 -3000,
NA
$77.10
0813 08116
SEA LIGHT MET4 ",ANTE4u1 208 -684 -3000
'A
$2,803.08
08111 08113
COMPLETE OFFICE 206 6280059,
-.'F.A
$540.84
00110 00.12
COMPLETE OFFICE 206- 6200059.
62,27749
08_110 08112
COMPLETE OFFICE 2 0 6 62 8 0 0 59
.v'{A
$44..35
08110 OT11
IJOUNTAIN HIST 253 5355447
o'(A
$67076
00110 0711
S EA LI G HT U ETkMNTE-U 206-6N-J000,
NA
3125 JD
Ili Cis rte,
P =911 t n �,1
T C L 1
0109045E
FIAAA 01114 2M 11 001
S 01090451
EIOI111 111 5 1 4 2 311 3 1 MI
01090450
F1000 05 315 230.31.001
.i 111 0 9 114 4 9
PAN At 514230.31.001
01090448
RAM 01. 114 21011 MI
�n1 01090447
FI000 A' 1147M 31 001
01090446
E1000055152M.11001
(li? 010904.45
FI000 OF. 114 ^M 31 001
01090442
EIOM 05.514 2i0 91 001
S 01090441
E1000 08 5142, 2 0 31 001
!1 010904.40
FIMA A5114 2W 11 MI
pt} 007948
EIOI111111. 514 231A 31 011
60 7940
;1i.}
E1000055152 ^0.11.011
..Se 607901
F1 AAA f1111421f111 All
.J0 X5[081019150117
EIMO 01. 314 2M 11 MI
1T 01019561
E1000.16542.670.47. 001
Internet 'I!"100%
a
Chanee a GL Account Code by Query
Not sure of the correct GL Account Code, a query can be run to find a City of
Tukwila valid GL Account Code.
On the transaction page, identify the GL Account Code to be changed
Click on the GL Account Code
54 Page 26 of 45
J
LL
y�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
r htt henk,wn R IHSBCun Servlet
ps:Ifeuess us Ices PP f
File Edit View Favorites Tools Help
`OV ;iP Trans action Management Allocations Tab j`; 0,1j Page S Tools
Data Exchange Transaction summary a.
My Personal Information
Status r; Posthai r r AoDountuatinCode
Home 08113 08115 SEA LIGHT METAV'ANTE -fl 205 -584 -3000 NA 82,803.08 0310 01000440 E1050.05.514.230.31Ag
Comsat us i j Cisr-i a°'. `1 T eersil Laal '.e' Rxellccsi,
summary I Allccaticns I User Lineftems
The Alocations tah provides the ability to reallocate a transaction hP changing the accounting information to
allocate an alnountto a dr1erent cost renter. The reallocation can he to one orto multiple accounting codes.
You can allocate amounts hP dollar amount or percentage. Total allocation amaunta muot equal 10055 otthe transaction. To allocate to additional accounting codes, elickthe -dd"
butler.
After adding, Todifying ar deleting allocations. clickthe "Save Allocations button to save changes.
required Allocation Source'. Default ACA Code Lact uhanged W: 54ctem
s l 21303,03 'DR 1 100.00 IE C, }11.00 `4
°Vera
go
Total Allocated: sI 2863.03 I 100.00 z; APPIr Accounting Cade: v
maunt Remaining'. sI 0.06 I 0.0014 Additional 4-3catiomsCl 1
Mute: Rowe marked for deletion are Subtracted Ton Total Allocated and Anount Remaining'valuec.
3
Chanee a GI Account Code by Query
Enter a partial GI_ Account Code (see 411.00 as example)
Click on the magnifying glass
Results in a list of valid City of Tukwila GI_ Account Codes
C, Add as Favorlta
v
Internet 'a 100 /o
Page 27 of 45 55
J
LL
y�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
Chanee a GI_ Account Code by Query
Find the correct GL Account Code from the list
Click on "Select"
56 Page 28 of 45
https:ffaccess us6ank .mmfcpsApplfIJSEComServlet
n
File Edit
View Favorites Tools Help
n 1;
6 Search &Select Valid Value
Cfl Page a Tools
Raleci 411 An F76 6Rn 4n n1
BGiOD BORNE PATHOREIIR
Select 411.00.576.580.64.01
INTERFUNDTAXES ADOIISEIONT.AXES
Select 411 00 5 76.581.12 00
E;iTRA'. LABOR
Select 411 00 576.691.24 00
INDUSTRIAL INSURANCE
Select 411 00 5 76.681.26 00
UIIEHPLOIMENTCOI1PEIISU.TION
Select 511 101) 57b.581.28 101)
UNIFORM CLOTHING
Select 511 00.576.681.31.00
OFFI CE 9 OPERATINd SUPPLIES
Select 311.00.576.581.31.01
BUILDING SUPPLIES
Select 411.00. h71i. Fl .31.U2
RENTAL SUPPLIES'
Select 411 00 576.691.3104
REPAIR SUPPLIES
Select 411 00 5 715.581.34 01
PRO SHOP SUPPLIES IRESA.LE'.
Aalert 411 In F76 6R1 41 011
PROFFRRIONAL �ERVICER
Select 411 00 576.691.42 00
COMMUNICATION
Select 411 00 576.581.43 00
TRAVEL
Select 411 00 676.691.44 00
bDVERTISING
Select 411 00 576.081.45 00
OPERATING RENTALS LEASES
@..�,,411.00.57b.581.45.U1
POA'7ER',ART RENTALiLE 4SESt
Select ..7411.00.576.581.17.00
PUBLIC UTILITY SERvICES
Select 411 00 570.681.48 00
REPAIRS AIJD MAINTENANCE
Select 411.110. b75.681:48.111
GULF FiJUIPNENT REPAIRS GUST
Select 411 00 676.691.40 00
MISCELLANEOUS
Select 411 00 576.581.49 01
PRINTING
Releri 411 In F766R14n n2
RF74IJR*JT REROCER iIONTRS.CT
R—ct iP to eJ 81
Fne 1121_I'_
Rqrktn Tim u.Ilnratlnns
v
Done
Internet °1
Chanee a GI_ Account Code by Query
Find the correct GL Account Code from the list
Click on "Select"
56 Page 28 of 45
J
LL
ry�
RPrlr in Tran.PPrllnn 1 i.et
UPDATING THE GL ACCOUNT CODE
[s
Procurement Card Manual
Internet 'l'I ti
Chanee a GIL Account Code by Query
The selected GL Account Code is now displayed in GL account code box
Click on "Save Allocation"
This will direct you back to the main transaction page
Page 29 of 45 57
http> II ur» u. b..1 Ilp>ApplIUSK 5rivlrt
File. Edit
VI— FBVft i", T-1, Help
yY a
Transaction Management Allocations Tab
col L?;W3 'Page
nC Tools
U8118 U806 SEA LIGHT METAVA.NTE 1V 2U6 U843000... 82 8U8 .US
Ul UJU44U
EIUUU.U5.h14ZL U.81.UUJ
Nome
1r1
C —t.a us
Tuns cenil —1 aealI —o
—,rcn• I �oceanena I U- 1-Insft—
The All actions tali pruviUes the ahilitl�to reallocate a transaction hZ changing the a— Linting IWchinaticn to
al luiate an ainuunttu e tlitfe -It 111t 'enter The reallu,-etiull —1 he to une ur to InUltiple utles.
Y- ran allnrate 3mn1 ints try duller snnnnt nr p,—ht3g, Tntal allnrahnn annnnts nnst e. q-1 1111 PA of the
Lanserhnn Tn allnratP L,
atldltinnal 3rrnnn4ng -des didr the '-.dd'
hnnnn
Liter adding, 111utlif'inq ur deletinq a 11 —tun, li,k the "Salle ill— fiwiia huttn to seae hangea_
required Allncation Scurce' [PieUlt nay rude Last Changed hr' System
.1R ACC OUNT
E] 3) LUU:i.UU 7UU.l1U v, E `Q 1#ll.l}L`.F76'. &ill'17.1}L`
`Q.
t •D
Q ddd at Fa:rnrlta
awr
Tufal Lll ted_ $I 20L, UU I IUU.UY/ P5 gpplY Accounting Code'.
Llnount Remaining'. $I 111111 1 Hhl'r Lddli Lllu tL s I 1
Ilnro R bs m3 rb: Pd i r dP.IP.tirrn are sllhtraftP.d (ruin TTtal 4 -atPd and LlYlinllnt RP.melning Jdll IP.s
�4.n•� rNm�wa4'
[s
Procurement Card Manual
Internet 'l'I ti
Chanee a GIL Account Code by Query
The selected GL Account Code is now displayed in GL account code box
Click on "Save Allocation"
This will direct you back to the main transaction page
Page 29 of 45 57
J
LL
y�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
httPS,��acce sbanl '..com�cPSAPPl�U2Brom2ervlet I '''S 1. W
Eile Edit View Favorites Tools H.IP
-drd A.... t S.--y -h T..n.e.ti— L,,t Page T-11
08113 08716
SE4 LIGHT HIETA'NANTE -10 206 684 -3000, NA
$418 66
0M3 08116
SEA LIGHT VET.AVA.NTE -10 206 6843000. W
$9.18
08113 0811
SE, LIGHT HETAVAHTE -III 206 6843000. ul..
$24.21
08.1'.'. 0811E
SE.ti LIGHT HIET.AVANTE 1,1 206 U64SOOU, &I,
$29.09
00_1:' 00:1
UE+'. LIGHT H1ETPVSNTE -H1 20 -5.4 -000. 'JV,
W .74
IimiS IIn115
rEA LIGHT HIETAV4NTE -1,1 211H- nn4flimll A-
SHIn
IWV IIn�1H
TEA. LIGHT HIET4VANTE -bt 2n11.- nllY'lllnn W:
54161 in
Hn115 IIn115
!;EA LIGHT HIETAV4NTE -1,1 211H- nn4flimlh A-
$4.n41n4
061 061
SEr. LIGHT HIETAVANTE-H1 200 -564 -±000. 'C;1.
$2.1-7.32
00 Mir
LE+t LIIHTb1ETAV NTE 11 2115 -b 4 JUOU A,
fin79nl
'1:1 II^ 1
EA LIGHT PETA1 NTE H1 2nH n 4 IIIIn
s2. II In!
nn711 IIn71.
COMPLETES OFFICE 2115 -M12l ll111 +441.4
$n411114
111m IIn�12
-',O MPLETE 1FFICE 2nii- n'[I11111; ^.4 'f.
277 4LI
nnVIn nn ?12
COMPLETE OFFICE 2n6 52ndlll
$44.5
win nR'11
Iv1i 111NTA.IN HOIST 2. fi 6447
$ii?Il?fi
11 S—r
nRi111 nR111
I Lna,e a.'..II S'ncron
SEd LIGHT HIETA1iANTE HI 2nn 5R4 annn L ^fA
$125. RR
01090462
Flnnn n^ ^14. can 11 nnl
01090451
Flm nF X14 `%3n R1 nnl
01090459
Flnnn n^ ^14. nIn
01090449
Flnllll 11 14 S1 VIII
U1U9U440
Flnllll lt- 14 "'lll'!11111I
5 111nRn447
Flnllll IN 1 14 1 VIII
11111L11144R
FIIIIIII II1 `.14 "'111 '!1 11111
111nRn44
FI0111110-. h14' {1n 1I IIIII
UlUYU442
FIIIIIII 11-- 14' +11 +111111
I2 U1090441
11 I1111 LI114411
ql HII 7R4n
.n
Flu I1 t. !�.�4'i�,n ;111111
n117L1411
n
FIIIIIII 11:^. .`.14 "III "11111
fin79nl
Flnnn n5 514 n .1 n'll
52n R1n1n161111?
Flnnn n5514 ^:n ?l nnl
n1nli551
n
Flnnn In n4i 6 �Il ST nnl
inrernet :a too r
Chanee a GIL Account Code by Query
The GL Account Code change was successful
To log out of system, click on "Logout" at top of page
Do not use the internet explorer back arrow, as you will get a "webpage
has expired" notice
58 Page 30 of 45
`r
d�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
Change a GL Account Code for multiple transactions
Need the GL Account Code changed for more than one transaction and don't want to change
them individually.
H Transaction List Rmt- t, f°°
Che &All.c -,,y., I m_, All °Noun
All of serving you
Internet 100%
Chanee a GL Account Code for multiple transactions
Select the transactions for updating by clicking on the check box.
Click the "Mass Reallocate" button
Page 31 of 45 59
07 6T26 '01,1PLETE OFFICE
20662866 11p.
$93.21
emu,
599376
Fiona 6.. 114230.31 nit
s°
0�
67123 67126 COMPLETE OFFICE
nr
266 -62866 9 .A
66
$294.,,h GR
Ir
599376
EIM0 0 014.23(13100
a
t
6 7 '122 67128 COMPLETE
PLETE OFFICE
tr
266 -62866 1, p
$294.53 CP
Ii
5993 ?6
EI660 6F. 14236.31 nor
67119 67121 COMPLETE OFFICE
266- 6266659,'N.A
$227.76
5i
598466
Fiona 65 514.23n 31001
E]
67119 67121 COMPLETE OFFICE
206-628009 .,;;ry
$102.21
V
599573
E1606.65a14.236.31.00
97(16 9709 COMPLETE OFFICE
21)M2899H
$589.11
599375
EIO00Y51423021n2
a
Y
0_14 9711E OOMPLETEOFFICE
20u628009'A
$124009
J
x98409
EIM05514 230 71 00 1
67119 67116 PUGETSMIDFINPICEOFFIC
PUYALLUP 5A
$15600
M118
\Ui Cis�tta� 'R}
R�alltatzd (16l,. Iy1ti T,arca Catail Laval
^.hcce ?JI ChC.Lyn
I,�m =_All F.Hewn
W�VI
nm!w.na�
All of serving you
Internet 100%
Chanee a GL Account Code for multiple transactions
Select the transactions for updating by clicking on the check box.
Click the "Mass Reallocate" button
Page 31 of 45 59
J
LL
y�
required
Naas Reallocation Action:
Replace Existing 4 11ocations
J Add 1l3inmon Allocations
n in IF
v
GGO
Selected Transaction List
Transactiensthat mll he effected h'vthe actientaken ahaue,
Summary
Tutal PJwnher ut Trauaadiuns.� 6
nil
Add'
v
Internet 100%
Change a GL Account Code for multiple transactions
Change the percent to 100%
Change the GL Account Code
Click "Save Allocations"
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
60 Page 32 of 45
0
J
LL
y�
7 7 1 ban k Are You Sure?
Account Ad ministration You have chosen to Replace all selected transaction allocations with the same common allocatmms'.
Transaction Management This will elect 6 transactions totaling $1,620.05. The following will replace each selected transaction
Card Ac�uunt List
30C3110n'.
Account Information
Rep6rtlNg
Rata Exchange r
My Personal W. —atian 100.00% 1]1000.0 ;.514230.31 A1I
Home 3crolldo•,vn to review ,vhatthe selected transactions would looklike withthe change applied.
Contact us Lre asp Qu. aunt to change these allocations'
v to t;'Att1V�
Detail of Charged Transactions
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
0 7!23!2010 COMPLETE OFFICE
$204.;6 7R
E1000.05.514230.31 Al
(i COMPLETE OFFICE
$204.56 CR
E1000.05.514. 230.31.011
0 71 T2010 COMPLETE OFFICE
$22 776
E1000.0 ;.614230.31 Al
1012010 COMPLETE OFFICE
$152.21
E1000.05.514. 230.31.011
0 71 312010 COMPLETE OFFICE
$;80.11
E1000.0 ;.614230.31 Al
0 711412010 COMPLETE OFFICE
$1,240.09
E1000.05.514,230,31,01
All of servinq you
Chanee a GL Account Code for multiple transactions
mtemet too./.
Verify the transaction GL Account Code changes
Click "Yes, Save Allocations"
Page 33 of 45 61
,R https:ffes�ess us6enk wnifspsApp1fl15BC�niSeivkt r�l P'y ;4
File Edih View Favnril— Tnnlc HP.Ip
<a. :ard Account nary with Transaction List i I t Page Tools
iX
Data Exchange I-1 Card Account Summary
My Personal Information
a,ccaunt Number: .9318
Home Aecaunt Name: DR?IG 2ELLERHOFF
C,ntact OR B Cycle Close Gate Open v.
o 0—A n[
1 +1 Search Criteria
1 -1 Transaction List
ADDIV Multiple GI_ Account Codes to a Transaction
This is hoax the
acconntin.- code
looks after the
reallocation has
been done
w
To reallocate a purchase to multiple GL Account Codes, click on the select
box at the left of the transaction
Click "Reallocate"
OR
Click on the unallocated Accounting Code
62 Page 34 of 45
Delail
Pul ID
Aomuri Code
Date r,
97123 0 712 6
COMPLETE OFFICE
996 5280059.
1,L..
$9321
599375
rta
E1000 65514230.31 011
07123 07126
C0MPLETE OFFICE
2.05 5280059,
NA
$294.55 CR
i
599375
F10100 0 514220 31.011
07129 07126
COMPLETEOFFICE
206 5280059.
1,L..
$294.55 CR
�Ll
590375
rta
E100005514230. 31011
07119 07121
C0MPLETE OFFICE
205- 5280050,
tgrA
$227.75
cli)
598408
E100005.514220. 31 011
07.!10 07121
COMPLETEOFFICE
206 5280059.
1,L..
$152.21
590573
rta
E100005514230. 31011
07115 07f19
C0MPLETE OFFICE
205 5280050,
tgrA
$589.11
cli)
599376
E100005.514220. 31 011
,um �s,
07 14 07 +16
COMPLETE OFFICE
206- 52800 9.
x.
81,240.09
598408
rta
E1000 0 514 23I) 21 011
4a
07115 07116
PUGET SOUND FINANCE OFFIG PUYALLUP eq
$150.00
ia`�
�3�
v�'" IdulllDle
G L so
Rsell�cyt TO
T'er= Cats I L=v
Inherneh '✓`,inn
ADDIV Multiple GI_ Account Codes to a Transaction
This is hoax the
acconntin.- code
looks after the
reallocation has
been done
w
To reallocate a purchase to multiple GL Account Codes, click on the select
box at the left of the transaction
Click "Reallocate"
OR
Click on the unallocated Accounting Code
62 Page 34 of 45
Cl
J
LL
Cl
y�
Procurement Card Manual
UPDATING THE GL ACCOUNT CODE
https,ffaccess ushanl .,comfcpsApplJIJTBCom�ervlet of e� ,Fu
File Edit View Favorites Tools Help
m,. Tan jinn Manage.mi Allnrahinns Tab Page f Tools
`MYfeesnn1rhforimetion rr
n• r
Home 0715 OT15 PUGET EOUND FINANCE CFFIC PUYALLUP,VVA $150.00 Sit a lelultlple
cnriljx
mr ciss.rc -b' +!w T C -ii L-1 +ti= R-llz w
Summary I -llccau- I User Line items
The Allocations tall provides the ability to reallocate a transaction by Changing the 3CCOLInting information to
allocate an 2MOL111 to a different cast center. The reallocation can he to one orto multiple accounting codes.
Yuu can allocate amULdri Li tlullar anmuntor percentage. Total allucatiwi arnouutamust equal 1005 ofthe trausadiun. To allocate to additional accounting codes, Uick.the "odd`
bufian.
After adding ,modifying r deleting alloca5mm,clickAhe "Save+,lloca5mia l i lu Save chaligea.
required Allnratinn Hmlrre User Last nhangsd hY tellerhnff Craig
I 1DOGC 'DR 66.67 E CL (GOO .05.51423C.49.GO 4, Odd as Favorite
I 50.00 'DR I 33.33 ¢y rE q. IGG0.04.516200.49.GO 4dd as Favorite
d�sf9
Change either Laded/ 15000 1 100001 pPl, L..ce01.111i Code
amount box or D v
MAN,, I 000 I 006
G :4
percentage box ltional Ihcahun e 'Ar
��w,.,,,„r..,
Ro,vo marketl ter deletion ara suhlracte�i from Tctal �Ilocated antl Amount
u4YW`$`tialol3s.
AL
Done V g} Internet
Aooly Multiole GI_ Account Codes to a Transaction
The transaction can be allocated by using an amount, percentage or adding
additional allocation lines up to a maximum of 99.
Amount change the amount and GL Account Code for
each line item for the transaction
Percentage change the percentage and GL Account Code
for each line item for the transaction
Additional Allocation Input the number of additional lines
and then change the amount or percentage and GL Account
Code for each line
Click "Save Allocations" button when finished
v
H' §100%
Page 35 of 45 63
J
LL
y�
PRINTING ONLINE MONTHLY STATEMENTS
Printing Monthly Statement
At the end of a billing cycle, each cardholder will need to print out a statement from the US
Bank website. (See appendix "E" for PCard Statement Processing Schedule) A hard copy
statement will not be sent to the City of Tukwila. This statement is matched to all transaction
backup and given to the department Reconciler.
Procurement Card Manual
0 https:JJaccess us6ank.comIcp,AppliL
File Edit View Favorites Tools Help
s ,y Welcome To Access Online tit Page u Tools
U.S. Bank Access-; Online
i oein Message(s) from Access online
1
t0 Ac0ess mllnel Stretch YOLIr pr0gr3m limits and stre3nlllne 334ment
Account Administration online, our inr10V3tive program In3n3gement and reporting tool. This wel enalbl€
Click Account Transaatian M ariaqement pl3tform that 0311 he easily C011figUred and deplored t0 meet Your Llnlglle needs
Information On ccount lntormatlan SOILItIOnS anrti n e 3ny here'With Access nllne
4, e�
Data Exchange
the menu log M Personal Intarrnat on Bienvenue SUrAccess a mlinel Rep0L1sse7 les limites de votre progr31111ne et sill
p3iement aver Access online, notre OUtll n0'V3te Ur d et3hlisserllent de rapporls e
Cet outil Internet offre Line 313te -forme riche en fonctionnalites qui peat titre 3isei
Home pour repondre a aos hesoins 33rticuliers '=.ccedez a vos solutions de 133iement
Contact Us soyez a'vecAccess a online
v
,Gone Internet 4 "100%
Cardholder Statement
Under Statement
column, click on
"Cardholder Accouni
Statement"
t https: JJaccess ,ushank,com�cpsAppl�l>°...__
File Edit View Favorites Tools Help y�
AccountInformation i y* yy
„j Page y al` Tools
i
a is i f l i. 1
Stat ement l
;•'ie =h account st3tementls`.
Cardholder Account St3tement'>
vhT
Diversion A.000llllt St3telllellt
Account Profile
View account demographics, limits 3rcoullting code, and other related
information.
Cardholder A:000U11t Profile
fdnnnnilln Arrnllnt Prnfila
Di'ip.minn A.crnullt Prnfila
s
Internet 4 100%
64 Page 36 of 45
e https i�access..ushank comicpsApplJUSBCom5ervlet
File Edit View Favorites Tools Help
w. Search G Select an Account II 'j r Page y' Tools
A
U.S Bank. Access Saline
Search for Account Cardholder Account Statement
Search Select an Account
dministration
"last Management Insert the last name age Vivwriivvrsion +iawrAananinnACCOiint
of the person whose Cardholder Account Search
,ra..file
Statement is to be g,.,. Search for an account hr Cardholder 4 .cc0u nt idumher, Na Ine, or Social Se L'LI FIN Number. YO LI can also
Ar"Mange cardholder account hr first Searchinn for a Mananinn Acco1 nt.
viewed printed. Peroonal Information
A.cc0unt Number
Home
Contact bs K.w. La St Name for Vehl Ci 1'J First Name epa
OR zellerhoff
Sucie�ecuntr IJiirnber
R
3
Internet 1001
Select Billine Cvcle
Go to the "Select
Billing Cycle" box and
select a billing cycle
Use drop down arrow
for a list of all billing
cycles
Once billing date is
selected, Click on the
"View statement"
button
ne
)nta Us
I I
X ll of serving you
i
Done
V
a
Internet 1 ,100%
Page 37 of 45 65
J
y�
Procurement Card Manual
PRINTING ONLINE MONTHLY STATEMENTS
Windows Internet Explorer message
Cdr Page y Tools s
Imp.mel +r�tnn
When you click on the "View Statement" button, a pop up message
appears
Right click on the message for options
Pick the option "download file" and do not close message screen
Click on "View Statement" one more time to view the actual statement
4 rT r V1 r xt{ np AY #R u !!r u xU u4 fia rr Srn ntr1V 1Ukr1 "a r rqt d!n �b�Si
t' r; t,.W ,.0 �16r
e httpi usbank mmfcpsApp1fD5BCom5ervlet
,pselerrryde.
U.S. Bank Access =J Cril
CITY OF TUGIVICA
Account Information
Cardholder Account Statement
,s
A—unt Adminis$ra4iun
n r w To help protect your security. Internet Explorer blocked this site From downloading X
Tra —cti.n Managecnenfl Card Acwunt Number. .:�;t9, �R.:I ED}, RHr FF
files to your computer hck here For options..,
Account Information
T9 veiJ3 etatemBllt. eeBnl B Cf0B and OIOk, the 'view She
acwunt Profile he usedforremittance afpaYmemc itisfardisplaYpurpos
Repmiing Select SIIIIIIq Crcle:
Data Exchange 07 1e +21710 v
My Personal Information
Home
Contact Ns
All of'' serving you'
1u3
Ill
66 Page 38 of 45
I, Done Internet
J
LL
y�
Procurement Card Manual
PRINTING ONLINE MONTHLY STATEMENTS
File Edit �n Document Tools Wndow Help x
PDF of Statement
Print statement
Reconcile the statement amount to receipts and /or purchase confirmations
Verify the purchase amount(s) on the statement matches to the receipt(s)
Attach all appropriate backup to statement
Receipts smaller than 8 X 11 must be taped to a blank 8 X 11 sheet of paper
Page 39 of 45 67
0 1 Uj i 1 i (w, 50% is L�
a
J
LL
y�
Procurement Card Manual
PRINTING ONLINE MONTHLY STATEMENTS
ccauntNUnnber: .9318
Home I coo
untName. CF ZELLERHOFF
Contact Us
Billing Cyele Close Date R" v
I +1 Search Criteria RFt t
1 1 Transaction List RFt t
R w 1 -8 d8
ch-A.II erica, I �..a? -'11 ehm'
UP2P U7;26
;UNIPLETE UFFICE
2U6- 62800 ^.1.
Aip..
893.21
0723 07126
COMPLETE OFFICE
206- 6280059,A.A
n*
$294.56 GR
07!22 07'26
MMPLETE OFFICE
206- 6280059,
INA.
$294.56 CR
07,'19 07121
COMPLETE OFFICE
206- 6280059,
NA
$22776
07119 07121
COMPLETE OFFICE
206 6280059.
AP..
$152.2'1
0716 07119
COMPLETE OFFICE
206- 6280059,A.A
$589.11
07!14 07'16
MMPLETE OFFICE
206- 6280059,
INA
$1,240.09
07,'15 07116
PUGET SOUND FINANCE OFFIC PUYALLUP, NA
$150.00
illy Ci:pi, t=a 0
R =allc^at:a lE! i,Ilp
T—z Cztsil L=M
'To 59937x:
EIUUU On t14.23U_31 U1I
fil 599376
n+
F10100 05 514220 21 011
PTO 599376
EIMO OF F142u0 1011
fiu 598408
n*
EIMO AF 514 20 31 011
1} 599573
A�
E1000.05514.230 31 011
To 599376
n+
E1000.05.514220.21.011
n) 598408
EIMO OF F142u0 1011
is}
nom
MAD
Y
Internet 1001
Tins /Reminders for Statement orocessing
Maintain transactions weekly to ensure timely processing of
monthly statements.
See the PCard Statement Processing Schedule for dates when
online statements are available to print.
68 Page 40 of 45
kL.4
J
LL
y�
0a 'S
Procurement Card Manual
RECONCILATION PROCESS
The reconciliation process consists of three stages over 8 working days. The process begins with
the reconciliation of the statement, then approvals and followed by audit and review. The
PCard statements will close on the 27 of each month. See the PCard Reconciliation schedule
on Tuknet for the reconciliation processing dates by month (see appendix "E" for 2010 Process
Calendar).
nw ..nen.......
`aaR� tA�imtW liNliNtl�liNlNitl�liNlNitNN
n
1 I Ili II
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
Statement Reconciliation
During the open statement period, the cardholder or reconciler should frequently monitor all
cardholder transactions online to maintain their personal online account in a timely fashion.
Page 41 of 45 69
J
y�
Procurement Card Manual
Not maintaining the GL Account Coding online within the reconciliation period in a timely
manner may result in the PCard being revoked.
GL Accounting Codes
GL Account Code changes are required to be corrected by the end of the day on WD2
after the statement closes. If the default GL Account Code is not correct, follow the
directions for online Ur)dating the GL Account Code, previously covered in this manual.
Failure to change the GL account before the deadline will mean the cardholder or
reconciler will need to request Finance to complete a journal entry to move the charge.
Such request must be approved by the Department Director and PCard Administrator.
7���P►I 1��II# Jff7TfI "IL9
Statement
The City of Tukwila PCard monthly statement closing date is the 27 of the month.
When the last day of the month falls on a weekend or banking holiday, the last posting
day for transactions is the next business day. The morning after the statement closes;
the online statement is available for printing.
PCard Packet Preparation
The cardholder or reconciler prepares the PCard Packet, which includes the PCard
Transaction Log, PCard Statement and Supporting Documentation. The PCard Packet is
to account for purchase transactions made by a cardholder, obtain approval and provide
documentation to Finance. The PCard Packet includes:
PCard Transaction Log distributed by the Finance Department on WD3. (see
appendix "C" for sample)
PCard Statement printed online statement from the US Bank website for
each cardholder. A hard copy via U.S. mail will not be provided. (See Monthly
Statement section of manual for example on how to print out statement)
Supporting Documentation includes a receipt or confirmation for each
transaction listed on the US Bank online statement. Examples include:
Receipts
Invoices
Email receipts or confirmations
A copy of the "Training Attendance Request" (TAR) form needs to be
attached for registration and travel receipts
All meal receipts for meetings must include where the event took
place, who attended and an agenda
70 Page 42 of 45
J
LL
y�
Procurement Card Manual
Approval
The completed PCard Packet is given to the Designated Approver or Department Director for
signature (see roles and responsibilities). The approved PCard Packet is forwarded to the
Finance department by the end of WD5.
Page 43 of 45 71
J
y�
Procurement Card Manual
RECONCILATION PROCESS
Finance Review
Finance will review cardholder PCard Packets for:
Use tax
Acceptable receipts
Correct account coding
Correct splitting of charges
Appropriate use of card
Fraud
Personal use
Approval signatures, etc...
Purchase transactions are uploaded to Eden and posted to the transaction month in which the
purchase took place.
PCard Payment
Payment for purchases made by PCardholders is processed by US Bank through automatic
withdrawal from the City bank account two days after the statement close date (27 of each
month). The payment time frame is supported by the reconciliation and review process
ensuring each purchase is supported by an invoice or receipt and reviewed by the Department
Director.
Random Physical Audit
Random physical audits are to ensure items purchased with the PCard remain on City of Tukwila
property and used for business purposes. On a periodic basis the Fiscal Coordinator Payroll and
Accounts Payable is responsible for performing a physical audit based on a random selection of
purchased items. Results of the audit are documented and reported to the PCard
Administrator.
Lost Receipt
An "Affidavit of Lost or Destroyed Receipts" need to be completed by the cardholder and
signed by a Department Director and PCard Administrator for any lost or stolen receipt.
Multiple lost receipts will result in cancellation of the PCard. The affidavit form is available on
TukNet, under the Finance department. See appendix "D" for sample of form.
72 Page 44 of 45
pcardadmin @ci.tukwila.wa.us
Procurement Card (PCard) online HELP!
PCard User Manual
PCard Application
PCard Affidavit
PCard Training Slides
Finance Department Contacts
Peggy McCarthy PCard Administrator
Finance Director
206 433 -1839
peggv.mccarthvCcDtul<wilawa.gov
Craig Zellerhoff PCard Administrator
Fiscal Coordinator Payroll AP
206 433 -1836
craig.zellerhoffCcDtul<wilawa.gov
Diane Jaber
Fiscal Specialist Accounts Payable
206 433 -1871
diane.iaberCcDtukwiIawa.gov
Page 45 of 45 73
x
Issued ('cards
326
JAN
1,314,677
67
19,622
81
16,231
11
576
324,006
563
Active ('cards
114
FEB
1,997,837
181
11,038
334
5,982
38
776
296,005
381 r.
MAR
2,122,735
195
10,886
348
6,100
52
774
408,860
528
2011
APR
2,134,454
215
9,928
386
5,530
74
818
253,762
310 s
AR Spend
33,057,93.6
MAY
5,813,588
407
14,284
615
9,453
45
780
369,715
474
Pcard Spend
2,955,495
JUN
5,292,568
222
23,840
410
12,909
40
723
323,707
448
Pcard Rebate
32,510
JUL
3,980,352
212
18,775
396
10,051
39
791
343,856
435
Total Invoices
9,850
AUG
6,134,619
305
20,114
302
20,313
50
748
366,122
489'
Pcard Invoices
6,633
SEP
4,267,087
169
25,249
345
12,368
28
647
269,462
416
Pcard Invoices
67,34%
OCT
NOV
AR Spersd
13,853,385
Pcard Spend
1,845,281
Pcard Rebate
23,079
Total Invoices
5,029
Pcard Invoices
2,247
Pcard Invoices
44.68%
Savings per transactional over traditional PO (per 2010 benchmark study) 70.58
PCard vs. PO Savings 468,157
Rebate Earned 32,510
2011 City of Tukwila PCard Savings 500,668
PCard statements include transactions posted by the 27th of each month
City wide PCard program began 9/1/2010
Monthly Spending
$7,000,000 900
$6,000,000 800
700
$5,000,000
600
$4,000,000 500
$3,000,000 400
300
$2,000,000
200
$1,000,000
100
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Invoice Purchases PCard Purchases
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
Average Payment
$0
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Checks Invoices PCard I
450
400
350
300
O
V 250
R
N 200
Monthly Transactions
r
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Checks -Invoices -PCard Purchase Orders
PCard Transactions by Dollar Spend
C
R
100.,�,
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
..<$100 $100 200 aaaw$200 -500 $500 1000 $1,000 -5,000 >$5,000
75
76
Top 25 Vendors by Transactions
Transactions (Vendor Name
467
SEA LIGHT M ETAVANTE-M
348
NAPA STORE 3767007
301
COMPLETE OFFICE
198
LOWES #00010*
159
SPRINT *WIRELESS
130
BLUMENTHAL UNIFORMS AND E
107
THE HOME DEPOT 4705
92
GOGGLE *GOOG2461729549
84
CASHNCARRY56152105616
83
HONEY BUCKET /FLOHAWKS
79
GOGGLE *2461729549
67
GOGGLE *ADWS2461729549
60
EUREST /THOMPSON DINING
59
WW GRAINGER
56
ALARM CENTER INC
50
CPM DEVELOPMENT CORP
49
FACE BOOK.COM *ADS
41
HORIZON DISTRIBUTOR -540
41
CARQUEST 01037621
40
HIGHLINE WATER DISTRICTO
40
AMERICAN HOSE AND FI
39
CINTAS #460
38
NATIONALSAFETYINC-
34
OFFICE DEPOT #984
29
BOWEN SCARFF FORD SALES I
Top 25 Vendors by Dollar Spend
Transactions (Vendor Name
13
MITEL NETWORKS INC
467
SEA LIGHT M ETAVANTE-M
159
SPRINT *WIRELESS
5
CTY OF RENTON FIN DIV #1
7
DMI* DELL K- 12/GOVT
301
COMPLETE OFFICE
19
INTEGRA TELECOM
2
DATEC, INC
92
GOGGLE *GOOG2461729549
8
UNITED PIPE SUPPLY 23
67
GOGGLE *ADWS2461729549
79
GOGGLE *2461729549
4
DESTINATION MEDIA ALLIANC
21
MCKINSTRY CO LLC
1
COMP MANAGEMENT
2
FLINTTRADING, INC.
348
NAPA STORE 3767007
13
MERIT MECHANICAL INC
130
BLUMENTHAL UNIFORMS AND E
50
CPM DEVELOPMENT CORP
17
SEA WESTERN INC
1
SPECIAL ASPHALT PROD
4
KIRO AM KBSG FM KTTH A
13
FERGUSON ENT #3156
2
QWEST *INTERPRISE
S
S
Top 25 Vendor Categories by Transactions
Amount Transactions I Vendor Category
233,462.57
537
AUTOMOTIVE PARTS,ACCESSO
28,439.15
535
UTILITIES ELECTRIC, GAS, WA
56,285.16
360
ADVERTISING SERVICES
10,654.15
329
WHOLESALE OFFICE SUP
85,596.34
322
HOME SUPPLY WAREHOUSE STORES
27,835.72
286
WHOLSALE INDUSTSUPP
10,110.95
177
TELECOM SVC /CRED CRD CALL
46,195.28
174
BUSINESS SERVICES -OTHER
15,209.80
170
MISCELLANEOUS AND SPECIAL
11,584.06
162
GROCERY STORES,SUPERMARK
39,500.00
153
EATING PLACES AND RESTAURANTS
40,822.16
141
PROFESSIONAL SERVICES
954.77
141
WHOLESALE UNIFORMS
8,491.53
125
SPORTING GOODS STORES
7,959.12
118
WHOLESALE CONSTRUCT
26,791.60
116
HEATING, PLUMBING, AIR CO
1,460.68
87
CHARITABLE /SOCIAL SERVICE
9,857.89
86
OTHER DIRECT MARKETER
2,207.40
76
WHOLESALE COMMERCIAL
3,811.95
73
FAST FOOD RESTAURANTS
3,153.95
69
AUTO TRUCK DEALERS,NEW
3,217.91
67
GOVERNMENT SERVICES -OTHER
16,471.76
66
CLOTHING-RENTAL COSTUME
2,562.09
65
PUBLISHING /PRINTING
7,005.33
63
MEMBERSHIP ORGANIZATIONS
Top 25 Vendor Categories by Dollar Spend
Amount Transactions I Vendor Category
243,559.41
60
TELECOM EQUIPMENT
233,462.57
535
UTILITIES ELECTRIC, GAS, WA
85,596.34
360
ADVERTISING SERVICES
70,631.10
174
BUSINESS SERVICES -OTHER
66,634.82
286
WHOLSALE INDUSTSUPP
56,285.16
177
TELECOM SVC /CRED CRD CALL
54,882.47
170
MISCELLANEOUS AND SPECIAL
54,223.28
76
WHOLESALE COMMERCIAL
46,195.28
67
GOVERNMENT SERVICES -OTHER
45,995.94
25
WHOLESALE COMPUTERS/
40,822.16
23
COMPUTER REPAIR /MAIN
39,500.00
86
OTHER DIRECT MARKETER
37,072.00
329
WHOLESALE OFFICE SUP
34,362.03
537
AUTOMOTIVE PARTS,ACCESSO
31,619.49
125
SPORTING GOODS STORES
29,445.37
116
HEATING, PLUMBING, AIR CO
28,439.15
118
WHOLESALE CONSTRUCT
28,090.22
28
GENERAL CONTRACTORS RES
27,835.72
141
PROFESSIONAL SERVICES
26,791.60
65
PUBLISHING /PRINTING
24,768.81
55
WHOLESALE DURABLE GO
24,279.44
141
WHOLESALE UNIFORMS
24,000.00
36
WHOLESALE PLUMBING /H
23,739.19
43
CATALOG MERCHANT
23,558.13
44
WHOLESALE HARDWARE /S
S
S
Amount
61,511.47
239,138.61
179,996.01
62,319.59
25,860.83
132,215.67
93,549.69
154,169.38
89,403.95
17,999.94
8,256.30
39,930.68
31,510.65
60,982.02
48,207.76
55,736.87
23,203.09
65,505.82
87,015.42
2,857.19
21,222.90
80,166.43
5,367.14
39,778.21
10,368.95
Amount
307,999.90
239,138.61
179,996.01
154,169.38
132,215.67
93,549.69
89,403.95
87,015.42
80,166.43
77,304.30
73,522.89
65,505.82
62,319.59
61,511.47
60,982.02
55,736.87
48,207.76
42,980.17
39,930.68
39,778.21
36,956.89
31,510.65
30, 749.81
29,774.77
28,899.23
NWIN Pcard Personal .April I, May I June
Pcard
Missing
Personal
Personal
Personal
January I
July I
February
August I
March
Limit
Missing
Personal
Use
Trans
Dollars
Dollars I
Trans
Dollars I
Trans
Dollars
Department
Increase
Receipt
Use
Repaid
Trans
Dollars
4
Dollars I
Trans
Dollars I
Trans
Dollars
Council
32
5,338.09
7
817.79
12
1,618.42
13
2,901.88
Mayor
1
259
127,179.15
77
32,357.61
95
30,384.16
87
64,437.38
Human Resources
1
14
4,771.12
7
2,525.76
5
1,378.26
2
867.10
Finance
294
364,627.31
71
161,062.60
132
82,038.61
91
121,526.10
Recreation
2
2
32.33
(32.33)
193
36,562.87
49
7,092.12
81
15,808.35
63
13,662.40
DCD
53
15,319.60
10
4,151.07
18
2,779.47
25
8,389.06
Court
48
4,741.45
16
1,437.57
19
2,181.91
13
1,121.97
Police
6
207
73,715.07
47
10,500.06
60
10,778.01
100
52,437.00
Fire
116
50,357.20
36
21,425.54
40
17,227.30
40
11,704.36
IT
2
47
60,537.44
12
29,773.06
12
14,317.64
23
16,446.74
-'PW
7
48.44
(48.44)
700
231,941.31
204
47,450.74
245
98,059.93
251
86,430.64
Park
56
8,720.08
11
1,886.40
22
2,578.93
23
4,254.75
Park
56
9,992.58
18
2,130.33
16
2,419.49
22
5,442.76
Golf
1
107
43,787.57
22
3,282.07
41
17,013 22
44
23,492.28
Totals
20
2
80.77
(80.77)
2126
1,028,870.76
324,006.32
776
296,004.77
774
408,859.67_
NWIN Pcard Personal .April I, May I June
1, El I
Limit
Missing
Personal
Use
Personal
July I
August I
September
Increase
Receipt
Use
Repaid
Trans
Dollars
Dollars I
Trans
Dollars I
Trans
Dollars
Council
:Department
19
7,135.19
4
128.63
13
6,894.06
2
112.50
Mayor
2
23.70
(23.70)
284
141,784.64
94
39,653.12
85
46,688.37
105
55,443.15
Human Resources
1
36
7,570.02
8
1,424.42
19
3,077.97
9
3,067.63
468
2
40
Mayor
1
270
130,603.45
97
Finance
1
293
284,467.88
100
60,786.77
91
123,580.61
102
100,100.50
Recreation
5
1
299
73,292.53
112
20,316.40
99
28,800.56
88
24,175.57
DCD
2
58
14,884.68
17
1,917.42
21
8,684.72
20
4,282.54
Court
40
12,809.75
16
8,472.46
11
2,775.46
13
1,561.83
Police
1
1
222
63,013.09
88
21,331.64
65
19,140.26
69
22,541.19
Fire
96
41,504.81
24
8,654.45
39
14,953.00
33
17,897.36
IT
3
42
45,241.12
11
3,155.07
22
24,790.65
9
17,295.40
PW
2
26.19
(26.19)
718
189,213.16
271
62,310.60
240
70,140.09
207
56,762.47
Park
56
8,720.08
11
1,886.40
22
2,578.93
23
4,254.75
Golf
1
1
158
57,547.39
62
23,725.07
53
17,609.89
43
16,212.43
y Totals
16
5
49.89
(49.89)
2,321
947,184.34;
818
253,762.45
780
369,714.57
723
323,707.32
1, El I
Pcard
Personal
July I
August I
September
Limit
Missing
Personal
Use
I
I
am
'Department
Increase
Receipt
Use
Repaid
Trans
Dollars :I
Trans
Dollars
Trans
Dollars
Trans
Dollars
Council
5
508.30
3
468
2
40
Mayor
1
270
130,603.45
97
45,504.65
96
44,352.19
77
40,746.61
Human Resources
25
5,841.83
7
2,144.40
7
2,621.11
11
1,076.32
Finance
1
9.42
(9.42)
279
132,518.48
90
41,336.83
110
55,241.98
79
35,939.67
Recreation
4
250
62,356.70
88
22,867.30
72
16,292.56
90
23,196.84
DCD
2
54
20,086.97
12
10,049.85
16
4,593.79
26
5,443.33
Court
31
6,294.15
14
3,580.71
12
1,513.36
5
1,200.08
Police
1
1
254
68,397.51
106
26,528.09
74
17,497.71
74
24,371.71
Fire
3
112
59,730.76
38
11,588.26
37
30,247.13
37
17,895.37
IT
2
1
59
109,100.53
20
54,080.12
18
48,521.56
21
6,498.85
PW
11
0.52
(0.52)
668
317,389.64
244
96,749.17
238
122,070.88
186
98,569.59
Park
43
8,022.01
20
5,521.95
15
1,692.62
8
807.44
Golf
1
136
58,589.89
55
23,904.73
50
21,008.64
31
13,676.52
Totals
24
4
9.94
(9.94)
2;186
979,440.21
791
343;856.06
748
366,121.83
647
269,462.33
OR
City of Tukwila
Finance and Safety Committee
FINANCE AND SAFETY COMMITTEE DRAFT
Meeting Minutes
November 8, 2011— 4:00 p.m.; Conference Room 43 *.,?VOTE: Special Start Time
PRESENT
Councilmembers: Kathy Hougardy, Chair; Joan Hernandez and Dennis Robertson
Staff: Peggy McCarthy, Craig Zellerhoff, Mike Villa, David )P& and Joyce Trantina, Bob Giberson,
Gail Labanara, Derek Speck, Katherine Kertzman, ,Rick 'StiII
Others: Chuck Parrish, Ellen Gengler
CALL TO ORDER: Chair Hougardy called the meeting to order at 4:00 P.
I. PRESENTATIONS
No presentations.
II. BUSINESS AGENDA
A. Rock `N' Roll Marathon Sponsorship
Staff is seeking Council approval to enter into a sponsorship ;agreement with Competitors Group for the
2012 Rock `N' Roll Seattle Marathon affi'/2M arathon in the amount of $50,000. This is largely due to a
change in the route for the Marathon giving tliegrorap /sponsors aia.,opportunity to grow the size of the
event. The City received good visibility `from the :event, as well .as good practice for emergency
management activities Tli'
yswrll ajointmarketing. roJe&sponsomflp with Seattle Southside Visitors
Services between th ecrtles of Tukwila, SeaTae; Keata0d Des Mgtnes and the Tukwila portion of the cost
is $16,500 which wild =be funded from the lodging tai fund.
UNANIMOUS APPROVAL�FORWARD TO NOVEMBER 14 COW FOR DISCUSSION.
B. Resol.utioji:'Procur8 i4Card Process
Stafffi's seeking Councrl`approval df a resolution thatedopts the City's Procurement Card Program.
The purpose of the PCard ;grogram was Io increase efficiencies by streamlining the purchasing process,
reduce purchase orders and the use of petty cash. The City also gets a rebate from the bank (about
$48K /year. Based on a recent audit, it was discovered that City Council needs to approve the new
process, per the�driffted ResolutiM"
UNANIMOUS APP OVAL. FORWARD TO NOVEMBER 14 COW FOR DISCUSSION.
C. Ordinances: 2012 Tax Levv %F'
Staff is seeking Council approval of an ordinance increasing the City's Regular Property Tax Levy from
the previous year and an ordinance levying the General Taxes.
After discussion regarding the tax levy, it was suggested that staff consider combining these two
resolutions into one combined resolution in future years. Dennis asked that staff investigate how far the
property tax would have to go before the City actually sees a decline in revenues, since the property
assessments have not shifted in a positive direction yet.
UNANIMOUS APPROVAL. FORWARD TO NOVEMBER 14 COW FOR PUBLIC HEARING
AND DISCUSSION.
79
:1