Spend analysis template: the columns you actually need

Published 17 September 2026 · 5 min read

Searching for a spend analysis template usually turns up a spreadsheet with forty columns, most of which you will never fill. The useful version is much smaller. Here is the minimum that works, what each optional column buys you, and how to lay it out.

The four columns you actually need

Supplier name — as it appears on the invoice. Normalise later, do not fix it during export.
Description — what was bought, in words. This is the single most valuable column and the one most often missing.
Amount — net of tax, as a number. No currency symbols, no thousands separators.
Date — any consistent format.

With those four you can classify, aggregate, run ABC, and produce a report. Everything else is enrichment.

Worth having if you can get it

Cost centre or department — lets you show spend by business unit, which is what stakeholders ask for first.
PO number — lets you measure off-contract buying by its absence. See PO vs invoice data.
Account code — your reconciliation anchor back to finance.
Quantity and unit — only useful for direct materials, where unit price comparison is meaningful.
Entity — essential if you are consolidating several companies.

Columns to leave out

Requester name, approver name, bank details, internal notes. They add nothing to the analysis and turn a commercial file into one carrying personal data, which changes how you have to handle it. See the data security checklist.

Layout rules that save hours

One header row, row 1. No merged cells, no title banner, no logo.
One row per transaction line. Not per invoice — a mixed invoice collapsed to one row is one category you cannot split.
No subtotals or blank separator rows. They break every pivot and every import.
Amounts as numbers, not text. Check for values like 5.0044E+11, which is Excel mangling a long part code.
Keep credit notes as negative values rather than deleting them, or your total will not reconcile.

Reconcile before you analyse

Sum the amount column and compare it to what finance reports for the same period. If they disagree, find out why now. The usual causes are intercompany charges, tax treatment, or a date-range mismatch.

Any conclusion built on an unreconciled file will be challenged the first time it reaches a CFO, and rightly.