Download State Purchasing Card Audit Guide

 Department of Administrative Services State Purchasing Division Process Improvement PROCEDURE FOR SPENDING LIMITS ANALYSIS The Spending Limits Analysis is designed to help you answer the question, “Could we reduce our risk of loss due to abuse while still providing our cardholders with the spending capacity they need in order to do their jobs?” This chapters provides guidance on what to look for in a spending limits analysis as well as how to do this using basic Excel skills. For advanced Excel users, the chapter also explains how to create the analysis pivot tables from scratch as well as how to use a pre‐
designed template available from the State Purchasing Division’s Process Improvement Team. It is highly recommended that you read these instructions through completely prior to beginning an analysis in order to ensure that you know where you are going with it. Refer to the Chapter on Evaluating Spending Limits for suggestions for your analysis. GETTING STARTED Download the following fields to a comma‐delimited text file from Works Payment Manager using a custom report. • Cardholder User Name • Last Four Digits (of the card number) • Amount • Purchase Date • Post Date • Merchant/Vendor Name • Merchant City • Merchant State • MCC • MCC Description • Card Profile Name • Group Name (cardholder group name) • Credit Limit P a g e | 13