SStructera

What is a spend cube?

Last updated: 23 May 2026

A spend cube is a three-dimensional view of your procurement spend, sliced by supplier, category, and time period. It's the atomic unit of procurement reporting: once you have one, nearly every question a CFO, COO, or category manager wants to ask becomes a pivot or filter on the cube.

The three dimensions

  • Supplier — who you bought from. Usually normalised so that “AWS”, “Amazon Web Services”, and “A.W.S.” all roll up to one entity.
  • Category — what you bought, mapped to a hierarchical taxonomy (Level 1 / Level 2 / Level 3). The category dimension is the one that takes the most work to get right because it requires classification.
  • Time period — month, quarter, or year. Trivial to compute once you have a clean date on every transaction.

What you can answer with a spend cube

  • Top 10 suppliers by category — supplier rationalisation candidates surface immediately.
  • Spend trend by category over time — budget forecasting, savings tracking, anomaly detection.
  • Tail spend per business unit — identify pockets of unmanaged spend that haven't been put through procurement.
  • Supplier consolidation opportunities — same category, multiple suppliers, no obvious reason for the duplication.
  • Compliance reporting — spend on minority-owned suppliers, regional spend distribution, etc.

How to build a spend cube (the long way)

  1. Extract the last 12-36 months of transactions from your ERP / accounting system as a flat file.
  2. Normalise supplier names — consolidate duplicate spellings, abbreviations, parent / subsidiary relationships.
  3. Build a taxonomy — agree on Level 1, Level 2, Level 3 categories that match how you want to manage spend.
  4. Classify every transaction against the taxonomy. This is the bottleneck — manually it's weeks of analyst time per hundred thousand rows.
  5. Load into a pivot tool (Excel, Power BI, Tableau, Looker) and start slicing.

How to build a spend cube (the short way)

Steps 3 and 4 are where most projects stall. Structera does both automatically: upload your normalised transactions, the system generates a 3-level taxonomy aligned to the global standards (UNSPSC, SIC, NAICS, NACE), and classifies a sample for free so you can review accuracy before committing budget. The output is an Excel workbook with a Summary sheet (one row per transaction with Level 1 / Level 2 / Level 3 assigned) that plugs directly into any BI tool.

See the five-step workflow or create a free account and run a sample of your own data.

Where spend cubes usually break down

  • Inconsistent taxonomy. If different analysts use different category names, rollups become meaningless. Anchoring Level 1 to a fixed vocabulary fixes this.
  • Drifting supplier names. Manual normalisation decays over time. Categorising from the item description rather than a hand-kept mapping table keeps results stable.
  • Stale data. A spend cube built once and never refreshed loses value within a quarter. Cubes need to be re-runnable on demand.

Related

  • Glossary — definitions of spend cube, tail spend, indirect spend, supplier rationalisation.
  • UNSPSC guide — the global standard most spend cubes use at the leaf level.
  • How Structera works — five steps from upload to classified export.
  • Pricing — pay-as-you-go from GBP 25.