---
title: "Spend analysis basics: from invoices to a spend cube"
description: "How to build a spend analysis from invoice lines: clean suppliers, items and units, assign categories, and read spend by category, supplier, item, month and site."
url: https://www.cureman.de/en/articles/spend-analysis-basics
language: en
updated: 2026-11-16
alternate_de: https://www.cureman.de/de/artikel/ausgabenanalyse-grundlagen.md
---

# Spend analysis basics: from invoices to a spend cube

> Spend analysis answers what is bought, from whom, at what price, when and for which site. Its raw material is the invoice line. Each line gets a supplier, an item, a unit, a category, a month and a delivery site; the net amounts are then added up along these dimensions, which is what a spend cube is. The work lies in the cleaning, not in the adding. A sound analysis also states what it cannot say, such as a year-on-year comparison when last year's invoices are incomplete, and it derives no saving from a benchmark.

Spend analysis is the answer to five questions about the money that went to suppliers: what was bought, from whom, at what price, when, and for which site. All five answers are on the invoices. The analysis consists of giving every invoice line a clean supplier, item, unit, category, month and site, and then adding up. The adding is trivial. The cleaning decides whether the result can be trusted.

## What a spend cube is

A spend cube is a table of invoice lines with dimensions. One row of it, with invented values:

| Dimension | Value |
| --- | --- |
| Supplier | Packaging supplier A |
| Item | Shipping carton 400 × 300 × 200 |
| Category | Packaging and shipping materials |
| Month | 2026-09 |
| Delivery site | Plant North |
| Quantity, unit, unit price | 450 boxes at 4.30 |
| Net amount | 1,935.00 |

Every view of spend is a sum of the net amount along one or two of these dimensions. Credit notes count negative, so that a returned delivery leaves the totals.

## Step 1: collect invoices at line level

Take twelve months of supplier invoices, with their lines, and the credit notes of the same period. Use net amounts, one currency, and the invoice date as the date. An invoice without line items can still enter as one line over its net total; it then counts in the views by supplier and month and is missing in the views by item.

Structured [e-invoices](https://www.cureman.de/en/articles/e-invoices-xrechnung-zugferd) give lines as data. PDFs have to be read, and whatever was read by software should be marked as such until a person has looked at it. Show how much of the spend rests on unreviewed readings, so that nobody takes the total for more certain than it is.

## Step 2: one supplier, one name

The same supplier appears as "ACME Verpackungen GmbH & Co. KG", "Acme Verpackungen" and "ACME Verpackung". Match by VAT identification number where the invoice has one. Otherwise compare names in a normalised form: lower case, punctuation removed, legal forms dropped from the end. Without this step the largest supplier is split in three and none of the three looks important.

## Step 3: items and units

A line belongs to an item through the supplier's article number or, without one, through its description with dates, periods and order numbers removed. Sizes and specifications stay. Units are normalised (`pcs`, `Stück` and `C62` are one unit), and prices are compared only within one unit. Lump sums have no unit price.

This step is what turns "we spend a lot with this supplier" into "we pay 4.30 for this carton here and 3.90 for the same carton there". It is also the basis for [finding price increases](https://www.cureman.de/en/articles/price-increases-on-invoices).

## Step 4: categories

A category says what kind of thing a line is: packaging, IT hardware, freight, cleaning, consulting. Keep the list short enough to remember, usually two to three dozen entries, and give each category keywords that place a line by its description. Mark categories that are not put out to tender, such as taxes, statutory fees or rent under a running lease, so that they do not show up as sourcing candidates.

Lines the keywords cannot place stay open and visible. Count them under the supplier's main category for the totals if you must, and show the open amount. A category is a label; assigning it never changes a figure.

## Step 5: read the views

| View | Question it answers | What follows |
| --- | --- | --- |
| By category | Where does the money go? How many suppliers serve one category? | Categories with many suppliers are candidates for bundling |
| By supplier, with ABC classes | Who are the few suppliers that make up most of the spend? | Negotiate with A, simplify the process for C |
| By item across suppliers | Is the same item bought at different prices? | Move volume to the cheaper source or ask the dearer one to match |
| By month | What recurs, what is a one-off, what is growing? | Recurring spend without a contract is worth an agreement |
| By delivery site or cost centre | Who buys what, and does one supplier bill sites differently? | Site-specific prices, or one agreement for all sites |
| Tail | How many suppliers lie below a small yearly amount? | See [tail spend](https://www.cureman.de/en/articles/tail-spend) |

Two derived figures need care. A supplier is *recurring* when it bills in most recent months; its monthly average times twelve is a run rate, which describes the present and forecasts nothing. A *comparison with the year before* is only valid when the invoices of that year are on record in full. If they start in the middle of the earlier year, show no comparison at all.

For site views, note where the site comes from: the delivery address printed on the invoice, or only the address the invoice is made out to. For a head office that receives its plants' invoices, the second is the wrong place. Buying for several plants is covered in [sourcing for multiple sites](https://www.cureman.de/en/articles/sourcing-for-multiple-sites).

## From analysis to action

A spend analysis produces three kinds of result, and they should not be mixed.

1. **Amounts that are arithmetic on invoices.** The same item cheaper at another supplier: quantity × (their average price − the lowest average price). An item under an agreement bought elsewhere for more: quantity × (paid − agreed).
2. **Costs that are not savings.** A price increase costs quantity × increase per year. It turns into a saving only if someone concedes it.
3. **Action items without a figure.** A large supplier with no agreed prices and no request for quotation in the last year is a candidate for one. What it will save is unknown until suppliers have quoted.

The third kind is where the analysis hands over to sourcing: items, yearly quantities and today's prices from the cube are exactly what a [request for quotation](https://www.cureman.de/en/articles/write-a-request-for-quotation) needs.

## What goes wrong

- **Benchmark savings.** "Category X usually yields so much" is a guess. A saving nobody has quoted or billed does not belong in the analysis.
- **Gross and net mixed**, or credit notes left out, which inflates suppliers with many returns.
- **Categories by supplier only.** A wholesaler sells office supplies, cleaning products and coffee. Categorise the line, not the supplier.
- **A cube built once.** Supplier names, items and categories drift. The cleaning rules have to run on every new invoice.

## How Cureman does it

Cureman builds the analysis from the invoices it has read and checked. Suppliers are matched by VAT identification number and then by normalised name, lines are matched to items, units are normalised, and lines are categorised by a keyword catalogue in English and German. Lines the keywords cannot place stay open; on request a model proposes a category from the list, which is a label and never a number. Every figure is a sum or a ratio of invoice lines over twelve months, credit notes negative: by month, category, supplier, cost centre and delivery site, with ABC classes, the tail, recurring suppliers with their run rate, and a comparison with the year before only when that year is covered. Spend resting on documents a model read and no person reviewed is shown separately.

From the same data it raises findings: an item bought from several suppliers at different prices, one supplier billing sites differently, purchases outside an agreement and price increases, each with its calculation, and tender candidates and the tail as action items without a figure. There are no benchmark percentages. The module is described under [invoice audit and spend analysis](https://www.cureman.de/en/modules/invoice-audit-and-spend-analysis).

## Questions and answers

### What is a spend cube?

A spend cube is the set of all invoice lines with a few dimensions attached to each, typically category, supplier, item, month and delivery site or cost centre. The measure is the net amount of the line. Any view of spend, such as spend per category per month, is a sum over this set along one or two dimensions.

### Which data is needed for a spend analysis?

Supplier invoices at line level for at least twelve months, including credit notes. Each line needs a description, a quantity, a unit, a unit price and a net amount, and each invoice a supplier, a date and, if possible, a delivery address or cost centre. Totals per invoice are enough for a view by supplier and month, but not for items and prices.

### Why use invoices and not purchase orders for spend analysis?

Invoices show what was billed, including everything bought without a purchase order. Orders show what was intended and miss purchases made by card, by phone or under a contract. Where both exist, invoices are the base and orders explain them.

### What is an ABC analysis of suppliers?

Suppliers are sorted by spend, largest first, and the cumulative spend is followed down the list. Class A is the few suppliers that together make up the bulk of spend, class B the next group, class C the many small ones at the end. Where the lines are drawn is a convention you set once and keep. The classes say where negotiation pays and where process simplification pays.

## The module that does this

[Invoice audit and spend analysis: every invoice read and checked](https://www.cureman.de/en/modules/invoice-audit-and-spend-analysis): The module takes invoices as PDFs, e-invoices or CSV, checks each line against its arithmetic, earlier invoices and agreed prices, and adds up the spend.

## Read next

- [Tail spend: how to see and bundle small purchases](https://www.cureman.de/en/articles/tail-spend): What tail spend is, how to measure it from invoices by supplier, invoice count and category, and how to bundle the purchases that repeat.
- [How to find price increases on supplier invoices](https://www.cureman.de/en/articles/price-increases-on-invoices): Build a unit price history per item and supplier from invoice lines, spot the increase, compute what it costs per year and check it against the agreement.
- [Sourcing for multiple delivery sites](https://www.cureman.de/en/articles/sourcing-for-multiple-sites): How to buy for several delivery sites: quantities per site from invoices, one request or several, comparing offers site by site with freight, and site prices.
