Procurement spend cube: a practical guide and template

What a procurement spend cube means

A procurement spend cube groups purchasing transactions so you can examine the same expenditure from different angles. Instead of separate lists of supplier payments and departmental costs, you have a connected view. You can ask which suppliers serve a category, which business units buy from them and how that spending changes over time.

Spend analysis involves collecting, classifying and analysing expenditure data to understand visibility, compliance, risks and opportunities.^[1] The cube is a structure for doing that analysis, not a savings forecast. It helps identify questions to investigate; it does not tell you which supplier to replace or what discount a negotiation will achieve.

For the wider process, read our spend analysis overview. This page concentrates on building a usable cube and checking the data behind it.

Choose dimensions that answer your business questions

Supplier identifies whom you buy from

Use a consistent supplier name and retain the original supplier identifier in your source records. A group may contain several contracting entities, so do not assume every similar name belongs together. The tool trims whitespace and combines case differences, but it does not decide whether two legal entities are the same supplier.

Category identifies what you buy

Classify the purchase itself, not simply the supplier's industry. One supplier may provide hardware, software and support. Invoice-line detail gives you a better basis for separating those purchases than a supplier-level label. Keep categories useful for sourcing decisions and document any items that remain uncertain.

Business unit identifies where spending sits

A business unit, department, site or cost centre can show which part of the organisation owns the spend. Choose the dimension that matches the decisions you want to make. Avoid mixing site names and departments in the same column unless you have an agreed mapping that makes them comparable.

Time shows movement and recurring demand

Use a transaction date consistently across sources. Decide whether your baseline is invoice date, posting date or another accounting date, and record that choice. The tool groups accepted dates by month and lets you filter a date range. A monthly spike may be a renewal, stock build or credit adjustment, not a permanent increase.

Prepare a transaction-level extract

Use one row per transaction or invoice line. Bring together the relevant purchasing sources without including the same transaction twice. Keep source-system names, invoice references and transaction identifiers in your original file so you can investigate an unexpected total after aggregation.

• Supplier: a consistent name for the contracting entity.
• Category: the agreed classification for the purchase.
• Business unit: the department, site or cost centre you want to compare.
• Date: an Excel date, YYYY-MM-DD or DD/MM/YYYY.
• Amount GBP: a number with no more than two decimal places.

Remove report subtotals and grand totals before importing. They are not transactions and can double count the spend. Separate true zero-value entries from missing amounts. Include credit notes as negative values and decide how cancellations and reversals should appear in the baseline.

The tool uses one currency, GBP. If the source contains other currencies, convert them first using a documented method and keep the original amounts and rates outside the cube. Apply a consistent VAT treatment rather than comparing some purchases gross and others net.

Clean names and reconcile the totals

Consolidating source data and eliminating errors are part of preparing spend analysis; reviewing expenditure by cost centre, commodity and supplier helps make that information usable.^[1] Before building the cube, check empty labels, inconsistent date formats, amount columns containing text and supplier records that have changed names.

Keep a reviewed mapping from source names to reporting names. Do not remove rows just because supplier, amount and date match: repeated purchases can be legitimate. Check transaction identifiers and source records before treating a row as a duplicate. This tool deliberately leaves duplicate decisions to you.

After mapping the columns, review the issue list. Invalid rows are excluded and can be downloaded for correction. Compare the count and value of included rows with your source report, including credit notes and exclusions. A visually convincing pivot table is not reliable until those totals agree.

Use a category taxonomy you can maintain

Start with the purchasing categories your business already uses, where they support useful reporting. If financial account codes are too broad for sourcing, create a documented mapping to more specific procurement categories. Keep the original code so finance can trace the total back to its records.

A cross-industry classification or an industry-specific scheme may help if you need to compare across organisations. Do not select a taxonomy simply because it has more levels. Choose the detail that helps you make a decision and can be applied consistently to the information you actually have.

Give uncertain items an explicit review category rather than guessing. Set an owner for mapping changes and keep versions when categories are merged or split. The builder accepts your labels; it does not validate external classification codes or assign them automatically.

Read the cube without jumping to conclusions

The pivot view lets you choose two dimensions, such as supplier by category or category by business unit. Filters narrow the included transactions by supplier, category, unit and date. The full cube retains supplier, category, business unit and month together, while the transaction view lets you inspect the contributing rows.

High spend with one supplier is a prompt to understand dependency and terms, not evidence that the supplier is overpriced. A category spread across many suppliers may have a consolidation opportunity, or it may need specialist capability. Check the specification, service and risk before deciding.

Our supplier consolidation guide explains that trade-off. Our category management guide shows how to turn the evidence into a sourcing strategy.

Download a template or your filtered results

The Caventis Excel template contains a blank Data worksheet, instructions, a simple summary and a separate Example worksheet. The example is hypothetical and is not client data. Replace it with your own extract, keeping the required headers, or map your existing columns directly in the browser.

The template summary covers Data rows 2 to 1001; extend its range if you add more rows in Excel. Downloaded results use the current filtered data and include formula-based totals, the aggregated cube and your selected pivot. These are ordinary worksheet views, not a live connection to your accounting system. Rebuild the output when you refresh the data.

Downloaded files stay on your device. The builder does not store transaction data or send it to Caventis. Closing the page or clearing the data removes the working copy from the tool. Handle your downloads according to your business's information-security requirements.

Turn the output into a procurement workplan

Prioritise categories where the baseline is reliable, the requirement is understood and there is a clear commercial question. Assign an owner and check contracts, renewal dates and operational constraints before making changes. Keep realised savings separate from reductions caused by lower demand or a change in product mix.

Our spend analytics service helps build and interpret the baseline. Our cost reduction consultants then help review and renegotiate third-party contracts. Every engagement is managed by our founder, with objectives and commercial terms agreed before work starts.

Frequently asked questions