Invoices and spend

Spend analysis basics: from invoices to a spend cube

Updated 6 min readMarkdown
In short

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:

DimensionValue
SupplierPackaging supplier A
ItemShipping carton 400 × 300 × 200
CategoryPackaging and shipping materials
Month2026-09
Delivery sitePlant North
Quantity, unit, unit price450 boxes at 4.30
Net amount1,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 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.

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

ViewQuestion it answersWhat follows
By categoryWhere does the money go? How many suppliers serve one category?Categories with many suppliers are candidates for bundling
By supplier, with ABC classesWho are the few suppliers that make up most of the spend?Negotiate with A, simplify the process for C
By item across suppliersIs the same item bought at different prices?Move volume to the cheaper source or ask the dearer one to match
By monthWhat recurs, what is a one-off, what is growing?Recurring spend without a contract is worth an agreement
By delivery site or cost centreWho buys what, and does one supplier bill sites differently?Site-specific prices, or one agreement for all sites
TailHow many suppliers lie below a small yearly amount?See 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.

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 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.

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.