Building one in Excel or Google Sheets
If you want the spreadsheet itself — because you track invoices in it, or you work offline — here is a layout that works.
Reserve the top block for identity
Your details in the top left, the word INVOICE and the number, date, due date and terms in the top right.
Two blocks for the parties
From and Bill To side by side, merged cells or a fixed column each.
An item table with room to grow
Columns for description, quantity, rate and amount. Leave more rows than you need and hide the empty ones rather than inserting rows later — that is what breaks the formulas.
Amount column
=B12*C12, filled down the whole table including the blank rows.Totals block
Subtotal
=ROUND(SUM(D12:D40),2), then discount, then tax on the discounted value, then the total.Format numbers as currency with two decimals
Formatting only changes what is displayed — use
ROUNDin the formula if you want the stored value rounded too.Set the print area
One page, portrait, fit to width, and check the preview before you export.
Export to PDF
Never send the spreadsheet itself.
The formulas most likely to bite you
| Problem | Cause | Fix |
|---|---|---|
| Total misses the last line | A row inserted outside the SUM range | Sum a range wider than the table, or use a named table |
| Invoice is one cent out | Formatting to 2dp without rounding the value | Wrap line amounts in ROUND(...,2) |
| Tax overcharged | Tax applied to the pre-discount subtotal | Apply the discount first, then tax the remainder |
| Old rate still applied | A tax rate hard-coded into the formula | Put the rate in a labelled cell and reference it |
| Layout shifts | A long description widening a column | Enable wrap text and fix the column width |
| Duplicate invoice numbers | Copying last month’s file | Keep a numbering log outside the template |
A spreadsheet can be edited, may re-flow on the recipient’s machine, and often carries hidden rows, other tabs, comments and edit history you did not intend to share. Export to PDF.
When a spreadsheet is the wrong tool
- You send more than a handful of invoices a month and maintaining the file is now a task.
- You need different tax rates on different lines.
- You invoice in more than one currency.
- You need it on a phone, on site.
- You have ever sent an invoice whose figures did not add up.
At that point a tool that owns the arithmetic is simply less work. The free invoice creator does the calculations and outputs the PDF directly; building a reusable template covers keeping your standing details.
Need the invoice now? The free invoice creator does the arithmetic and downloads a PDF. No signup.
Keeping the spreadsheet for tracking
A perfectly good hybrid: create and send invoices with a tool, and keep a spreadsheet as your ledger — number, date, customer, amount, due date, paid. That gives you a searchable record and running totals without the template maintenance.
Invoice & Quotation Generator for AndroidNo formulas to maintain, and every document kept together.
Install free
Questions
Is Excel good for invoicing?
It is fine at low volume if you are careful with the formulas and always export to PDF. It becomes a liability once you need per-line tax rates, multiple currencies or mobile access.
What formula calculates an invoice line total?
=ROUND(quantity*rate,2). Round each line, then sum the rounded values so the printed lines add to the printed total.
How do I stop my SUM formula breaking?
Sum a range larger than your table and hide unused rows instead of inserting new ones, or convert the range to a proper table so the formula expands with it.
Can I email an Excel invoice?
You can, but you should not. Export to PDF — a spreadsheet is editable and can carry hidden tabs, comments and edit history.
Keep reading
Make the document: invoice creator · receipt maker · quotation maker · waybill maker · Word templates