Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Learn More
NAPCP Search
Commercial Card News Brought to You by the NAPCP: NAPCP New Resources

Transforming Your Transaction Data for Better Spend Analysis

Tuesday, February 26, 2019   (0 Comments)
Posted by: Terri Brustad

One of the benefits of Commercial Cards is the spend data it provides and ease with which it can be turned into meaningful information. Sometimes however the transactional data comes with a lot of “noise,” think PayPal and airline tickets.

Shelley Shearer, CPCP, of the George Washington University, offers practical advice and steps through some “how-to” examples as to how she cleanses the data. Specific examples included are related to merchant name. The full name of the merchant shows up in “Merchant Description” field rather than “Merchant.” Shelley takes you through the steps, formulas and processes she uses to manipulate the data, resulting in meaningful reporting. 

Members >> Read more.
Not a member? Join the NAPCP today.

Sign In

Event Calendar

4/15/2019 » 4/18/2019
2019 NAPCP Annual Commercial Card and Payment Conference - Miami

2019 Full Day Pre-Conference Workshops: Travel Cards 101 and Pathway to an Effective P-Card Program

2019 Pre-Conference Workshop: Travel Cards 101: Everything You Need to Know

2019 Pre-Conference Workshop: Pathway to an Effective Purchasing Card Program for Beginners

Strategies for Communication

Copyright © 1999 - 2018 NAPCP - Advancing Commercial Card & Payment Practices Worldwide
Certified Purchasing Card Professional Credential 
The next application due date is April 15, 2019, to take the exam during the June 2019 testing period.
Complimentary resource for all website visitors.
Executive Summary complimentary fo subscribers and members. Join today to access full report.
NAPCP's dedicated IP address for e-mail is Please add this IP address, and to approved/"safe sender" list to ensure you receive NAPCP news & event notifications. 
You MUST log in to your profile to choose your preferences: Unsubscribe | Choose Email Preferences | Request Removal