What to Include in an Invoice Spreadsheet: The Columns That Matter
Published 13 November 2026. Where other products are mentioned we describe the kind of product and its pricing model, not figures, which change.
An invoice spreadsheet is only as useful as its columns. Too few and you cannot answer basic questions such as what is overdue or how much VAT you paid; too many and nobody fills them in. This is the set that earns its place, why each one is there, and what to leave out.
Quick answer
Record, at minimum: invoice date, supplier, invoice number, net amount, VAT, total and currency. Add due date and paid date if you track payment, a category or project if you analyse spend, and keep line items in a second linked sheet rather than extra columns.
The essential columns
| Column | Why it is there |
|---|---|
| Invoice date | Places the cost in a month, quarter and tax year. |
| Supplier | Lets you total and search by who you paid. |
| Invoice number | The only reliable way to find the original again and to spot the same invoice entered twice. |
| Net | The cost before tax — the figure most analysis is done on. |
| VAT | Kept separate so it can be reclaimed, reported or ignored as your position requires. |
| Total | What was actually payable. Check it equals net plus VAT. |
| Currency | One letter code per row. Never add different currencies into one total. |
Keep net, VAT and total as three separate number columns. A single "amount" column that is sometimes net and sometimes gross is the most common reason an invoice spreadsheet cannot be trusted.
Columns worth adding
- Due date and paid date: together they tell you what is outstanding and what is overdue, without a status column anyone has to keep up to date.
- Category or cost code: materials, labour, professional fees, utilities — whatever you report on. Use a fixed list, not free text.
- Project, job or property: if costs belong to more than one piece of work.
- VAT rate: useful when you buy at more than one rate, and a quick check on the VAT figure.
- Purchase order number: only if you raise purchase orders. Keep it apart from the invoice number.
- Notes: for the things that do not fit — a disputed amount, a credit to come.
Expect blanks
Not every invoice prints every field. In our field-by-field study of 87 published invoices, only 40% printed a due date and 54% a VAT rate. A blank cell is the right answer when the invoice does not say; do not fill it with a guess, because a guessed due date looks exactly like a real one six months later.
Where line items go
Line items — the individual things bought — do not belong in the invoice row. An invoice with nine items does not fit in one row, and adding "item 1, item 2, item 3" columns makes the sheet impossible to total or filter. Use a second sheet with one row per item: invoice number, description, quantity, unit price and line total. The invoice number links each item back to its invoice.
What to leave out
- A typed status column. Work status out from the due and paid dates instead; a typed status goes stale.
- Merged cells and subtotal rows inside the data. They break sorting, filtering and every formula that totals a column.
- One sheet per month or per supplier. Keep one table and filter it; separate sheets cannot be totalled or searched together.
- Supplier address and bank details on every row. If you need them, keep one row per supplier in a separate sheet.
A template to start from
The free invoice tracker template on this site has these columns set up, with status and days overdue calculated from the dates and a summary of what you owe. If the slow part is typing the invoices in, Invoices to Spreadsheets reads a batch of PDFs, scans and photos into exactly these columns, with line items in their own table, and exports to Excel or CSV.
Download the free invoice tracker template with these columns set up
What information should an invoice spreadsheet contain?
At minimum the invoice date, supplier, invoice number, net amount, VAT, total and currency. Add due date and paid date to track payment, and a category or project to analyse spend. Keep line items in a second sheet linked by invoice number.
Should net and VAT be in separate columns?
Yes. Keep net, VAT and total as three columns. A single amount column that mixes VAT-inclusive and VAT-exclusive figures cannot be totalled reliably or reconciled against the invoices.
How do I record line items?
In a second sheet with one row per purchased item — invoice number, description, quantity, unit price and line total. The invoice number connects each item to its invoice row, so you can total by invoice or search every item across all invoices.
What if an invoice has no due date?
Leave the cell blank. Many invoices print payment terms such as "30 days" rather than a date. If you want a date to chase against, add a separate column for the date you calculated, so a real printed due date is never confused with one you worked out.
7 days · 50 documents · No card needed
Try it on one invoice, no account needed · The full 14-tool comparison table · More guides · What Invoices to Spreadsheets is · Invoice to Excel