Move forward with fleet data.

Is your organization taking advantage of data to manage fuel and fleet expenses? Have you identified your data needs? How would you rate your fleet program in terms of cost savings, security, and control? Recharged Education recently found the perfect content to help your organization take a fresh look at its fleet. In the article, “Data-driven Visibility into Fleet Card Programs,” Jeffrey Pape, Senior Vice President, U.S. Bank Transportation Solutions, examines the benefits of fleet-related data and provides recommendations your organization can act on.

The following article was originally published August 4; reprinted with permission from U.S. Bank.

Data-driven Visibility into Fleet Card Programs

by Jeffrey Pape, Senior Vice President, U.S. Bank Transportation Solutions

Data. It’s the watchword for succeeding in today’s business environment. More and more, we’re being told to let the data be the guide. Quality improvement initiatives stress the importance of making decisions based on verifiable data rather than assumptions and guesswork. Nowhere is this truer than in fleet management, where there is a growing need to optimize data in order to enhance security, reduce cost and improve overall visibility.

The fuel card is an important part of this equation. When it comes to focused fuel cards over non-fuel-focused solutions, the ideal fuel-focused solution is designed to provide the fleet manager with data and control, and the fleet with efficiency and accountability.

Industry best practices call for taking advantage of the fuel-focused card for the significant benefits it offers fleet managers and drivers:

  • The power of a secure, established network that ensures widespread acceptance
  • The ability to limit purchases based on pre-authorized parameters
  • The ability to capture detailed transaction data that can be flagged for exceptions, audited regularly and allocated appropriately across the organization

The key is having data-driven visibility into your fleet program, at the level that your organization needs. The technology behind today’s best fleet and fuel card programs can help integrate that data into your internal systems for greater visibility and control.

Assessing Your Data Needs

The first step in gaining more visibility is figuring out what kind of data you need, at what level of detail and granularity. If your fleet department operates out of a general fund, you may not need to know much more than the total of how much you spent on fuel or maintenance this month, for overall expense management. However, more and more organizations are moving toward a structure of internal service funds, where each department is its own operating center with its own budget to manage. In that environment, there’s greater need for accountability, and that requires more robust and more detailed data.

For example, you may need to track costs not only on a vehicle or equipment basis, but also on a line-item basis where each transaction is brought into your system and the costs allocated out to the departments that own them. Rather than just knowing that Driver X had $100 in fuel expenses this week, you may want to drill down to what kind of fuel was purchased and where, what the odometer reading was, and whether these things correlate appropriately. That way you have the data you need to allocate costs appropriately, but you can also assess the potential for fraud, and identify whether additional communication or training is required.

Data-driven visibility into maintenance expenses is also a critical part of effective fleet management, especially when there are regulatory reporting requirements involved. If the Department of Transportation comes in and wants to verify tire purchases or inspection dates, having that data available from your card provider is imperative.

A good fleet card program can help you manage your spend and set controls to match your internal policies, so that you can manage by exception.

Move forward with identifying the fleet data you need and then incorporate it into your program.

Move forward with identifying the fleet data you need and then incorporate it into your program.

Data Integration Powers Results

When it comes to managing that level of data, a good dashboard is imperative. The key is being able to define and easily access the data you’re looking for. You might have multiple pieces of information floating around—purchasing card data, corporate travel card data, and fuel card data—and trying to compile everything into one place can be difficult. A portal that can aggregate this information provides you with simplicity.

Having that overall dashboard view of your fleet card data gives you an important ability to see the macro view—a valuable tool for senior management looking for the big picture. Integrating the data further into the organization’s financial management system can help you see—and adjust—how your fleet is affecting overall company profitability and other metrics.

Improved Fleet Management for Cost Savings, Security and Control

One of the best things you can do for cost control is to make sure that the people who are actually spending the money actually get the reports and see where their money is going.

For example, perhaps data shows that fleet drivers are buying premium unleaded fuel when regular unleaded would suffice for their vehicles. Significant cost savings could be achieved by addressing that situation through additional training and education to reinforce appropriate fuel purchasing criteria, and ensuring that the fleet organization is doing what’s best for the company.

When retail fuel prices vary considerably from station to station, price and site locators can help guide drivers to an optimal fueling route. Additional data-driven visibility into fuel card spending allows you to score and evaluate drivers on how they are complying with those parameters, and provide valuable corrective feedback to improve performance.

Best practices call for fleet managers to use the fuel-card data to check for unusual product codes, inconsistent fuel quantity, and unusually large transaction amounts. Exceptions can then be addressed with the driver.

Next Steps and Recommendations

What can your organization do to move the needle in the right direction?

  1. Determine your data requirements
  2. Review your options for fuel and fleet card solutions
  3. Implement a program that provides the greatest value
  4. Monitor and refine over time for maximum results

To learn more about how fuel cards came impact your fleet and your bottom line, visit bankonus.usbpayment.com.


External Sources/Guest Bloggers

Please contact Recharged Education if you are interested in contributing to the blog. Content must be educational. 

Subscribe to the
Recharged Education Blog

Receive notice of new blog posts.

Can you explain your program data?

If, without warning, senior management asks you to explain one or more pieces of your card program data, would you be prepared? No matter the topic, you do not want to be fumbling around for an answer. Memorizing key metrics is a good start, but understanding what is behind the numbers is more meaningful. This post describes four things your management may wonder or ask about, and what you should know to shine in the spotlight of their scrutiny.   

Process Savings from Card Usage

Sharing your organization’s process savings via your Intranet and/or in a report to management showcases the value of your P-Card program, so be ready to explain:

  • how you calculated the process savings 
  • how P-Cards save time and money for your organization compared to your other internal purchase-to-pay processes
  • why your organization’s savings are higher or lower than industry averages (RPMG Research is a great resource)

Card Spend

Relaying progress toward goals and how the current year compares to past years helps keep management informed; see examples below. Ensure you can explain any dips and/or upward spikes.

As a program manager, I once had to ask the organization president to sign off on the payment to our card issuer due to the unusual large dollar amount. While face to face in his office, he asked why the total was so high. Fortunately, I had researched that before approaching him, so I was able to answer.  

Revenue Share

Announcing the revenue share (rebate) received from the issuer is always exciting, but do not stop with the dollar total. Include a note about where your organization stands, based on your current contract terms. Are you maximizing the revenue share opportunity? Why or why not?

Internal Fraud/Compliance

Apprising management of the compliance level with card policies and procedures is equally important.

  • If you do not have issues, it is something to highlight, including the reasons for the success. Perhaps you maintain a current risk assessment that drives you to close any control gaps.
  • If you have had internal fraud and/or compliance issues, be able to articulate the contributing factors and related remedies. Also, if there are more compliance problems today than in the past, determine why. Has compliance always been on the poor side, but new/better auditing is uncovering more now?

Internal fraud data, as well as process savings, are two things included within the P-Card Risk Analysis Template from Recharged Education. It is available for purchase or, by attending next week’s virtual workshop, you will receive a complimentary copy.

Ensure you can answer "yes" if management asks whether you can explain a particular piece of card program data.

Ensure you can answer "yes" if management asks whether you can explain a particular piece of card program data.

Analysis without interpretation is just numbers.
— Included in an ad for Emory University, Goizueta Business School

More Resources

Visit the P-Card Metrics webpage for related information.


About the Author

Blog post author Lynn Larson, CPCP, is the founder of Recharged Education. With more than 15 years of Commercial Card experience, her mission is to make industry education readily accessible to all. Learn more

Subscribe to the Blog

Receive notice of new blog posts.

Interface file creation 101.

Uncertainty. Pressure. A faster heart rate. These are just some of the things people feel when they have to develop a new, electronic Commercial Card interface file for a particular system (finance or other). Even if you relish the challenge, formulating a plan can take time. Through personal experience and by helping others, I have learned it is best to break down the project into manageable steps. The following offers direction on four key aspects associated with interface file development. Keep this handy for the next time you face this situation.

Four Key Aspects

  1. Determine what you need the interface file to do/accomplish.
  2. Identify the system into which the interface file will be uploaded, and the related specifications.
  3. Select the relevant card-related data to be included in the interface file.
  4. “Map” where each piece of card data belongs in the interface file, based on system specifications.

In reality, you might work on these aspects concurrently. Remember to build time into your project for file testing purposes. 

Breaking It Down 

1. What Do You Want the File to Accomplish?

What are you seeking and why? Will you need to add or modify fields in the system used for transaction reconciliation? For example, is there a piece of data you need to capture in the interface file that would need to be supplied by cardholders?

Most commonly, an interface file is needed for the finance system, but you need to decide which one—AP system or general ledger. Further, there is more than one way to approach it. For example, will the interface file serve to initiate a payment to the card issuer? Maybe; maybe not. It could depend on how often you pay the issuer, how often cardholders reconcile transactions, and/or other factors.

2. Where Will the Card Data Go?

Can the identified system (#2 above) accommodate a file upload? If so, what are the requirements and specifications? Elements to explore include: fields to be populated, field length and type (e.g., alpha, numeric, or either), any prohibited characters that could cause problems during the file upload, etc. You may need to consult with the system provider/vendor.

Also, your card issuer might be able to offer some insight if any of their other end-user clients have an interface file for the same system. 

Do not let an interface file project overwhelm you. Break it down into manageable stages.

Do not let an interface file project overwhelm you. Break it down into manageable stages.

3. What Card Data is Available?

There are three broad categories of card-related data:

  • Transaction information, such as date, amount, sales tax, and line-item detail (if available); may also include any data entered by the cardholder during reconciliation
  • Supplier information, such as name, address, and merchant category code (MCC)
  • Cardholder/card information, such as name, zip code, and account number

You likely do not need every piece of available data. Determine the information that best supports what you want to accomplish.

4. Where Does Each Piece of Card Data Belong?

The system into which you will upload the file probably does not have field names that exactly match the names of card-related data. You need to figure out what to put where.

Lastly, some data might need to be automatically added to the interface file—to satisfy certain field requirements—versus originating from the card activity. For example, the file specifications might include a field designated as “Payment Type” for which you want a constant default of “PCARD” each time the interface file is downloaded. 

Resources

For an introduction to interface files and information about finance system options, visit the Interface Files webpage. If you are seeking external expertise, contact Recharged Education to inquire about consulting services.


About the Author

Blog post author Lynn Larson, CPCP, is the founder of Recharged Education. With more than 15 years of Commercial Card experience, her mission is to make industry education readily accessible to all. Learn more

Subscribe to the Blog

Receive notice of new blog posts.