Procurement teams are under continual pressure to deliver greater value from their contracts and vendor relationships. Without accurate and timely information, decision making is a hit-and-miss affair.  Historical spend data is sometimes not readily available, is poorly classified and it is often ridden with errors. At worst, it is not accessible at all.

If this sounds familiar, then read on for some practical tips to improve the visibility of your spend.

Spend analysis is a window into your business.  So what are you seeing currently?

Historical data is often patched together from accounts payable transactions or by totalling general ledger categories to provide a rough overview. This may give you a rough idea, but isn’t detailed enough to make reasoned decisions from.

What you need to know is:

•Who is spending it and on what, and with whom

  1. What the total controllable third-party expenditure really is
  2. Which vendors supply more than one business unit
  3. Which business units buy the same or similar goods and services at different rates
  4. How many payment transactions were made and the associated administrative cost

These insights will highlight wasteful expenditure and provide opportunities for consolidation, leading to cost savings.

For example, one aim of spend analysis is to identify how much of your spend is with critical vendors. This in turn can help you focus on getting the best value from those critical vendors and consolidating those relationships.

Look at the past twelve months’ data and expect to be surprised.  If your business is of a reasonable size, there are likely to be many low-value transactions, with multiple vendors, across many business units.

Before you make any decisions… 

Adding up the payments to vendors through your regular procure-to-pay (P2P) channel does not always tell the full story.  Purchases are often made on credit cards and large foreign transactions may have been made directly through treasury.

The key is to ensure that all data sources are included and that data is “cleansed”, i.e. there are no errors in the coding of transactions and that any mis-spellings, vendor duplications and abbreviations have been fixed.

Having the full picture is vital to ensure you’re making the right decisions.

So where to start? •

Mapping your spend into category “buckets” is the first step to gaining some visibility.  If you don’t already have a formal procurement category structure in place, you can start by creating broad groupings of commodities.

One approach is to divide the historical spend into two groups, one for direct spend (this is expenditure that is directly linked to your core business) and one for indirect spend (goods and services necessary to support the business).

Direct spend refers to the purchases of goods and services that are directly incorporated into a product being manufactured or are goods for immediate resale.   Examples include raw materials, subcontracted manufacturing services and component parts.

Indirect spend is needed to support your business operations.  It is likely to include some or all of these:   I.T., utilities, communications, facilities management, travel, marketing services, transport and logistics.

The next step would be to develop your spend map by dividing commodities and services into sub-groups.  You can choose your own category hierarchy or use an existing coding method such as UNSPSC.

This will allow you to find cost-saving opportunities and identify risks.   Here is an example of how you could approach the information technology category.

Example of an image to use here

The results are illuminating

Immediately you can see what portion of your spend is with your core vendors (e.g. top 10% by value).  The total number of one-off and small value vendors (the tail spend) will be greater than you imagine.  This information can be used to make decisions about streamlining and leveraging spend by identifying contract leakages and maverick spending.

Ideally, you should aim to reduce the number of vendors in each category.  Value is obtained by aggregating your spend rather than splitting it and this also reduces your administration costs.

Five tips to better spend analysis

  1. Access all spend-data sources within and outside your business. Sometimes your vendors or affiliates have better data than you.
  2. Cleanse your data. Payments are often made outside your financial system, through third parties or to one-time vendors.
  3. Do your spend analysis down to the most detailed level. This should be such that you can identify the buying entity, the item bought and who from. Aim for 95% accuracy.
  4. Increase the frequency of your analysis. The business environment is dynamic and prices change, vendors fail and contracts expire.
  5. Continuously improve your spend analysis and automate where possible. Spend data is a work in progress.

When there is reliable, accurate and timely spend data available use it effectively.

Get a march on your competitors whose windows may not be as clear as yours.

This article was first published on