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

DATABASICS Virtual Demo: Exploring Alternatives to Your P-Card Software

Educational Webinar: Taming the Amazon—Control the Beast Within Your Organization

Virtual Roundtable: Have You Heard? SURVEYS Are Your Best Bet for Growth

Educational Webinar: Securing Card on File eCommerce with New Tokenization Tools

Educational Webinar: Payment Strategies: Driving Costs Out and Bringing Revenue In

Copyright © 1999 - 2019 NAPCP - Advancing Commercial Card & Payment Practices Worldwide
Certified Purchasing Card Professional Credential 
The next application due date is September 3, 2019, to take the exam during the September 2019 testing period.
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