How do you conduct a spend analysis effectively?

To conduct a spend analysis effectively, gather all available expenditure data from across your organisation, clean and consolidate it into a single dataset, categorise it by supplier and spend type, then interrogate it to identify patterns, risks, and savings opportunities. The process works best when it is structured, repeatable, and tied to clear procurement objectives. The questions below walk through each stage in practical terms.

What data do you need to start a spend analysis?

To start a spend analysis, you need transactional expenditure data from your financial systems, typically covering at least 12 months of invoices, purchase orders, and payment records. This data should identify who you spent money with, how much you spent, when, and on what. Without this baseline, any analysis will be incomplete or misleading.

In practice, the data sources you will need to pull together include:

• Accounts payable records and general ledger exports
• Purchase order and invoice data from your ERP or finance system
• Procurement card and expense transactions
• Contract registers, where available
• Supplier master data, including supplier names, codes, and classification details

Many organisations find at this stage that their spend data is spread across multiple systems or departments, with no single consolidated view. This is normal, but it does mean that data collection itself requires careful coordination across finance, procurement, and operational teams before any meaningful analysis can begin.

The quality of your starting data directly determines the quality of your insights. Incomplete or poorly structured source data leads to gaps in spend visibility, which in turn means savings opportunities and supplier risks go undetected.

How do you clean and consolidate procurement spend data?

Cleaning and consolidating procurement spend data means standardising supplier names, removing duplicate records, correcting coding errors, and merging datasets from different source systems into a single, consistent view. This step is often the most time-consuming part of the spend analysis process, but it is essential before any meaningful categorisation or analysis can take place.

Common data quality issues to address include:

• Duplicate supplier entries: The same supplier appearing under multiple names or codes (for example, “BT Ltd”, “British Telecom”, and “BT Group plc” all referring to the same supplier)
• Miscoded transactions: Spend recorded under the wrong cost centre, department, or nominal code
• Missing fields: Transactions with no supplier name, no category code, or no date
• Currency inconsistencies: Particularly relevant for organisations with international spend

Once duplicates are resolved and records are standardised, the cleaned data should be consolidated into a single working dataset. A common approach is to use a structured spreadsheet or spend analytics tool that allows you to sort, filter, and aggregate by supplier, category, and time period.

It is worth noting that data cleansing is not a one-off task. Each time a spend analysis is refreshed, the same cleaning steps will need to be applied to new data. Building a consistent process from the outset saves significant time in future cycles.

What is the best way to categorise spend data?

The best way to categorise spend data is to apply a consistent taxonomy that groups expenditure by category and sub-category, aligned to how your organisation actually buys. A well-structured category hierarchy allows you to see total spend by type, identify which categories are fragmented across multiple suppliers, and prioritise where procurement effort will deliver the greatest return.

Most organisations use a two or three-level category structure. At the top level, spend is grouped into broad categories such as IT, professional services, facilities, marketing, and logistics. At the second level, these are broken down further, for example, IT hardware, IT software, and IT managed services. A third level can be added where volumes justify it.

There is no single universal taxonomy that works for every organisation. The right structure depends on the size and complexity of your spend, the sectors you operate in, and how your procurement function is organised. Public sector organisations often align their categories to established frameworks or the UN Standard Products and Services Code (UNSPSC), while private sector organisations tend to build taxonomies that reflect their own operational structure.

When categorising spend, two principles are worth keeping in mind. First, consistency matters more than perfection. A taxonomy that is applied consistently across all data is more useful than a theoretically ideal one that is only partially implemented. Second, categories should reflect commercial reality. If a category is too broad, it will mask important variation. If it is too narrow, it becomes difficult to manage and report against.

How do you identify savings opportunities from spend analysis?

Savings opportunities from spend analysis are identified by examining supplier fragmentation, contract coverage, pricing inconsistencies, and spend concentration within each category. The goal is to find areas where consolidation, renegotiation, or competitive tendering could reduce costs or improve value without compromising service quality.

The most productive areas to investigate include:

• Supplier fragmentation: Categories where spend is split across many suppliers for similar goods or services often indicate an opportunity to consolidate and negotiate better terms
• Maverick spend: Purchases made outside agreed contracts or preferred suppliers, which typically attract higher prices and create compliance risk
• Expired or uncontracted spend: Transactions with no active contract in place, leaving the organisation exposed on price and service levels
• Volume leverage: Categories where aggregating demand across departments or entities could strengthen your negotiating position
• Benchmarking gaps: Suppliers or contracts that have not been competitively tested in several years, where market pricing may have shifted significantly

Prioritisation is key. Not every savings opportunity identified in a spend analysis is worth pursuing immediately. Opportunities should be assessed against potential value, complexity, and strategic importance. A category with moderate savings potential but low risk and short lead time may be a better starting point than a high-value category that requires extensive stakeholder engagement and a lengthy tender process.

Industry experience shows that organisations conducting a structured procurement spend analysis for the first time frequently uncover savings potential that had not been visible to internal teams, precisely because the data had never been consolidated and interrogated in a systematic way.

How often should a spend analysis be repeated?

A spend analysis should be repeated at least annually, with many organisations choosing to refresh key categories on a rolling quarterly basis. The right frequency depends on the pace of change in your supply base, the volume of transactions you process, and how actively your procurement function is managing supplier relationships and contracts.

An annual full spend analysis gives you a comprehensive view of how expenditure has shifted over the year, whether savings initiatives have delivered as expected, and where new risks or opportunities have emerged. Quarterly or half-yearly reviews of high-value or high-risk categories allow you to respond to market changes, supplier performance issues, or internal demand shifts before they become significant problems.

Several circumstances should trigger an unplanned spend analysis refresh outside the regular cycle:

• A significant organisational change, such as a merger, restructure, or budget reduction
• A major contract renewal or re-tender approaching
• A new procurement strategy or cost reduction programme being launched
• Evidence of significant maverick spend or compliance failures

Spend visibility is not a project with a fixed end date. Organisations that treat spend analysis as an ongoing discipline rather than a one-off exercise are better positioned to make informed procurement decisions, respond to supplier market changes, and demonstrate value for money to their stakeholders.

How eXceeding helps with spend analysis

eXceeding supports organisations at every stage of the spend analysis process, from pulling together fragmented data sources to identifying and delivering measurable savings. Working as an extension of your team, eXceeding’s consultants bring the category expertise and analytical rigour needed to turn raw expenditure data into actionable procurement strategy.

• Consolidation and cleansing of spend data from multiple source systems
• Category taxonomy design aligned to your organisation’s structure and priorities
• Identification of savings opportunities, supplier consolidation targets, and maverick spend
• Prioritised savings roadmap with clear next steps for each category
• Ongoing spend visibility support as part of a wider procurement services engagement

Whether you are conducting your first spend analysis or looking to improve an existing process, eXceeding provides the independence and expertise to deliver results. Get in touch with the eXceeding team to discuss how we can support your organisation.

Related Articles

• What is tail spend and how should organisations manage it?
• Why is category management critical to cost reduction?
• Should you build an in-house procurement team or outsource?
• How do you evaluate the ROI of a procurement transformation?
• What are the signs your procurement function needs a transformation?