Assess the Quality of Your Freight Payment Data

See the four insights all shippers should have and deserve.

Download the PDF

Table of contents

    Table of contents



      In recent years, high-volume shipping organizations have been putting greater emphasis on gaining more precise visibility of their transportation costs in order to make better decisions and improve planning. One business process that has proven itself to be an invaluable source of transportation business intelligence is the freight audit and payment process.

      Now more than ever, companies are investing in their freight payment process. A best-in-class solution not only keeps costs under control by eliminating overcharges and duplicate payments, but also yields accurate and granular data that can be used to understand costs and drive efficiencies. It'll also help you meet the reporting requirements of other stakeholder groups.

      With a greater awareness of the value that can be realized from advanced freight invoice processing, shippers are scrutinizing their selection of freight audit and payment solutions more carefully. Organizations with millions of dollars in annual transportation spend cannot afford to:

      1. Continue manual processes that produce unreliable or inadequate data.
      2. Manage freight audit & payment using anything but best-in-class standards of performance.
      3. Under-invest in freight audit & payment or select a solution (software or outsourced) based on price alone.

      Quicker than ever, shippers are elevating their transportation spend management practices by moving away from outdated processing systems. Instead, they're investing more resources on the front end to implement a long-term, key enabler of its logistics strategy. Leading organizations are insisting on certain standards – and they're all aware of the potential that can be harnessed by continuous investments in their system.

      This article will help you evaluate your current solution/provider in terms of data outputs. Whether you're already aware of insufficiencies in your current system, or you're simply curious about what gaps might exist between your current state and freight payment best practices, you'll learn what other best-in-class companies are achieving.

      Evaluation criteria

      Evaluation Criteria

      Gaining oversight of your transportation data via a comprehensive freight payment process is critical for your business. Below, we've outlined 4 key insights your freight payment system must provide to be considered worthy of your investment.


      Criteria 1: You're Able to Calculate Landed Costs

      Calculate landed costs

      Many downstream decisions rest on the quality of your data, and there's one piece of data that several groups need: unit landed costs. Procurement needs it to make sourcing decisions. Product management may use it for pricing decisions. Sales management needs it to calculate margins and commissions.

      Unfortunately, unit landed costs are often some of the most challenging numbers to determine, due to either a lack of data or a lack of reliable data. Too often, then, financial decisions are based on estimates rather than facts. To determine landed costs, at the most basic level, you need to be able to match total costs for a move – or series of moves – to product quantity or weight in that load. You also need to know how these numbers change to calculate a working average, understanding the effects of volatile fuel prices and other cost elements that may vary. This analysis is necessary to track your progress in decreasing per-unit shipping expenditure.

      The freight accounting capabilities of your freight payment solution need to be advanced enough to manage cost allocations at whatever level your business requires. With a strong rules-based freight payment system that captures granular move and cost details, you'll know your line-item costs for the move, accessorials, and other fees. To achieve this, make sure your system can match multiple invoices to one shipment and accommodate complexities such as intermodal or interline moves (for example, when a load moves from port to drayage to truckload).

      A retailer with significant home delivery business had a limited understanding of its total shipping costs for home deliveries. It was therefore unable to determine profitability on an order-by-order basis. Its new freight payment solution from Cass helped its logistics team determine accurate shipping costs, allowing them to adjust home delivery fees accordingly.


      Criteria 2: The Data Leads to Significant Cost Savings Opportunities

      Saving opportunities

      With detailed business intelligence at their fingertips, logistics managers can discover opportunities to cut costs in a number of ways, including by taking a stronger stance in negotiations.

      Consider the following cost savings that these U.S. shippers achieved using data from their Cass freight payment solution:

      • Only after moving from a dated software solution did a Midwest equipment manufacturer discover that its most expensive traffic lane was valued at $30 million. Sharing this information with carriers led to aggressive competition for this business, and more favorable contracts reduced annual spend for this lane alone by $5 million.
      • A frozen food manufacturer used historical lane costs from its freight payment system, in conjunction with rating engine calculations, to determine where to locate a new distribution facility.
      • A Fortune 100 consumer products manufacturer cut $2 million off one accessorial cost after evaluating six months’ worth of historical, granular charge information.
      • A chemical producer added carrier metrics to its monthly carrier scorecards. Reviewing these scorecards with each carrier – as well as sharing that carrier’s ranking among its peers – continues to challenge them to achieve performance improvement goals.

      Many conditions must be met to produce such valuable data. Among them are sophisticated rules that enrich and normalize data and a multidimensional database structure.

      A multidimensional database structure, alongside powerful business analytics tools, are the standards of reporting when hundreds of data fields and high volumes of data must be integrated. Clearly, reporting that provides unlimited drill-down and filtering functionality is more powerful than a set of standard reports.

      Reporting should provide unlimited drill-down and filtering capabilities

      With these and many other technical capabilities (EDI, matchpay), best practice systems should capture and provide the following data:

      • Shipment details (including origin, destination, mode, weight, stop-off detail, etc.)
      • Line-item expense detail
      • Cost allocation detail for each move, commodity type/product class, SKU, etc.
      • Payment details (including ACH/check number, adjustment amount and reason, scheduled payments, etc.)
      • Invoice and supporting document images, including templates for invoices received electronically

      Criteria 3: Shipping Data Provides Insight Into Guideline Infractions

      Guideline compliance

      It’s for good reason that logistics groups create procedural guidelines and operating standards. For example, you may have a routing guide that vendors are instructed to follow. Documents like these lose effectiveness when they can’t be monitored and enforced. While you can’t always stop infractions before they occur, having systems in place that can report on infractions is the next best thing.

      Common infractions that shippers routinely seek to identify via data from their freight payment solution are unapproved carrier selection on inbound carrier selection and unnecessary service selections (parcel). Running a quick report of carrier usage will lead you to the source of problems quickly, giving you greater control over vendor/facility shipping decisions. Similarly, if you have minimum weight restrictions or similar guidelines, putting a few filters on a dynamic report would bring these to the surface so they can be addressed.

      Although one of our customers was self-insured, the data collected from their parcel invoices showed that employees were spending $600,000 per year insuring individual packages. Thankfully, it was easy for them to pinpoint the bulk of the problem to just a few locations. Through training and ongoing monitoring, 95% of the expense was eliminated.

      The bottom line: monitoring compliance can result in substantial savings that would have otherwise continued to slip through the cracks.


      Criteria 4: Your Internal Customers Have the Data They Need

      Internal customers

      Many groups within your company – non-logistics stakeholders like accounting, product management, finance, and procurement – rely on transportation and shipping data.

      You can assess the competency of your freight payment system on its ability to meet their information needs as much as any other criteria.

      Accounting has Accurate, Timely Allocations and Accruals

      Accounting relies on transportation to provide accurate expense, accrual, and general ledger information. When you compound these needs with the additional need for timeliness, many transportation executives find this as a challenging task.

      In order to satisfy accounting needs, your freight payment solution should:

      1. Be fully integrated with your company’s accounting/ERP system. Accounting files should be generated and transferred automatically from either your outsourced vendor or internal system. Transportation staff should spend very little time doing accounting work.
      2. Allow for a seamless transition from invoice approval to payment.
      3. Follow rules that allow for accurate cost allocations and accruals. Whether your accounting rules require general ledger coding based on commodity type, move type, destination, or any other piece of data (or combination thereof), a detailed, rules-based processing system should be able to handle the task without manual review. A rating engine that accommodates electronic rate uploads – in tandem with a matchpay system – should generate accruals automatically. With both these abilities in place, accounting will be able to rely on you for accruals and coded expenses in a timely fashion.
      4. Done right, automated processes replace time-consuming manual methods, and very little data transferred to accounting will require manual intervention.

      Supply Chain Analysts have Shipment Data

      Transportation data used in supply chain analysis typically includes unit volume data, destinations, and shipment frequencies.

      Often, your freight payment system is your only source of consolidated shipping and expense data. If your solution fails to properly consolidate and normalize these numbers, you'll be back to square one, searching multiple sources – many of which don’t contain actual spend data or other needed information.

      Procurement has Actual Spend Data

      When procurement is involved in carrier selection and negotiation, they expect a lot of data from you to support their efforts. If you cannot provide the following data points, they have to operate in handcuffs:

      1. Net transportation costs and all contributing factors
      2. Annual spend per lane
      3. Spend per carrier, broken into lane, accessorial, etc.
      4. Carrier performance measurements (some basic ones, such as percent of invoices with errors, should be easily available)

      Whatever the upstream roadmap for the data, your invoice payment system needs to be a reliable contributor to corporate analyses and reporting requirements.

      wrapping up

      Wrapping Up

      In this article, we’ve shown four ways the data derived from a best-practice freight payment process can provide significant value. Today’s leading shippers invest continually in process improvement to reach this state and hone it indefinitely. If you find a gap between your data assets and the ones described here, it's well worth investigating whether the deficiency is coming from process or system limitations, then block and tackle. Sometimes, even small improvements can go a long way.

      Time to Take Control of Your Freight Spend?

      Talk to us today about your transportation expense management goals and how we can help you achieve them.

      Schedule a call today