Invoice template for Excel and Google Sheets

Why people invoice in Excel or Sheets

Excel and Google Sheets are familiar and strong at arithmetic. Their price and offline availability depend on the product and plan, but either can turn quantities and unit prices into totals and export a presentable PDF.

The catch is that a spreadsheet is only as controlled as the workbook and process you build. It can hold a register, formulas, protected cells and version history, yet an ad hoc file does not automatically allocate invoice numbers, lock an issued copy or track payment. Treat calculation and record keeping as separate design problems.

Setting up the invoice grid

Start with a clean layout. Put your business name, address and contact details in the top rows, the customer block just below, and the invoice number and dates to the right. Leave space for the line-item table, then a block for subtotal, tax and total. The basic formulas below work in Excel and Google Sheets, although locale settings can change decimal marks and formula separators.

Header block

Your name/company, address, VAT or tax number, email and a logo cell if you want branding.

Bill-to block

Customer name, address and their VAT number where the transaction needs it.

Invoice meta

Invoice number, issue date and due date - typically cells like F4, F5, F6.

Line-item table

Columns for Description, Quantity, Unit price and Line total (for example A10 to D25).

Totals block

Subtotal, VAT/tax and grand total stacked in the lower-right, each driven by a formula.

Formula 1: line totals (quantity x price)

Each row multiplies quantity by unit price. If quantity is in column B and unit price in column C, the line total in D10 is =B10*C10. Copy the formula down the item range.

To leave an unused row blank, use =IF(B10="","",B10*C10). Format values for the invoice currency, but do not assume every currency or tax calculation uses two decimal places. Set the precision and rounding point required for the transaction.

Formula 2-4: subtotal, VAT row and grand total

With line totals in D10:D25, =SUM(D10:D25) gives a subtotal. If one 21% rate applies to that entire base and the rules call for two-decimal invoice-level rounding, a tax example is =ROUND(D27*0.21,2). The grand total is =D27+D28. Change the rate, precision and whether tax rounds per line or per invoice to match the applicable rules.

Subtotal

<code>=SUM(D10:D25)</code> - totals every line in the item table. Identical in Excel and Sheets.

VAT / tax example

<code>=ROUND(D27*0.21,2)</code> - one 21% rate with two-decimal invoice-level rounding. Adapt both values.

Multiple tax rates

Group tax bases by rate or use a tested Rate column. Confirm whether the jurisdiction rounds each line, each rate group or the invoice total.

Grand total

<code>=D27+D28</code> - subtotal plus tax. This is the amount due you put in large type.

Amount in words (optional)

Excel has no built-in function; some templates use a long nested formula or a small macro. Sheets needs a script.

Where spreadsheets genuinely help

For the maths, a spreadsheet is flexible. Change an input and dependent cells recalculate. You can model a percentage discount, shipping, deposits and different rate groups, provided the formulas and rounding method are tested.

A spreadsheet can also be a system of record if it is deliberately engineered and controlled. The risk comes from treating a copied ad hoc file as if those controls already exist.

Where an ad hoc spreadsheet needs extra controls

Excel and Sheets can protect ranges, keep versions and support sophisticated workflows. A basic copied template does none of that automatically. Check these gaps before using it for issued invoices:

No shared number allocator by default

A copied workbook does not coordinate a legal series across users or files. Build one controlled register and reconcile every issuing channel.

Version chaos

invoice_final.xlsx, invoice_final_v2.xlsx, invoice_FINAL_real.xlsx. With no central record you lose track of which version you actually sent and what was paid.

PDF setup is manual

A branded spreadsheet can print well, but page ranges, repeating headers, scaling and breaks must be configured and tested.

Version history is not finalisation

Cloud versions can show changes, but you still need a process that preserves the exact issued copy and prevents silent replacement.

Tax-rounding pitfalls

Displayed precision can differ from stored values. Round at the point and scale required by the applicable tax and currency rules, then reconcile the shown figures.

Broken formulas

Rows added outside a referenced range, overwritten formulas and copied references can leave amounts out. Use a controlled table or dynamic range and test the totals.

No client or status model by default

You can build client and payment registers, but a one-page invoice template does not provide them automatically.

The free-generator alternative

A dedicated free invoice generator can handle line totals, subtotal, configurable tax and the grand total from the values you enter, then produce a consistent PDF. The no-account guest generator is a transient draft: you enter the invoice number and customer each time, and it does not create a saved billing record on the server. If you enable draft saving, the draft can remain in that browser for up to seven days.

With a signed-in FreeBillGen workspace, invoices and clients can be saved and the next number can be suggested from the saved sequence; you still retain voids and reconcile invoices created elsewhere. Use the guest generator when you only need calculation and a PDF, and sign in when you need reusable records.

Excel invoice template questions

What is the formula for an invoice line total in Excel?

Multiply quantity by unit price. If quantity is in B10 and unit price in C10, the line total is =B10*C10. To keep empty rows blank, use =IF(B10="","",B10*C10). Then total all the lines with =SUM(D10:D25) for the subtotal.

How do I add VAT or sales tax in a spreadsheet invoice?

For one 21% rate and two-decimal invoice-level rounding, an example is =ROUND(D27*0.21,2), followed by =D27+D28. That is only an example. Use the rate, precision and line-versus-invoice rounding method required for your currency and tax system.

Do the formulas differ between Excel and Google Sheets?

The basic SUM, IF, ROUND and SUMPRODUCT functions are available in both. Locale settings can change separators, and advanced automation differs, such as Excel VBA versus Apps Script. Test the workbook in the product and locale that will issue it.

Why does my spreadsheet VAT total come out a cent wrong?

Cells may store more precision than they display. Round at the legally required calculation point, not mechanically in every cell, and use the currency scale the invoice requires. Then confirm that the displayed line, tax-group and grand totals reconcile.

Can a spreadsheet handle sequential invoice numbers?

Not across separate files by default. You can engineer a shared allocator or controlled register, but a copied template does not provide one. FreeBillGen guests enter their own number; a signed-in workspace can suggest the next number from saved records, while you still reconcile external documents and retain voids.

Is a spreadsheet invoice legally valid?

The software does not decide validity. A spreadsheet invoice can work if it contains the required particulars and format, the calculations are correct, and the issued version is retained. Some e-invoicing mandates require structured data that a PDF or ordinary sheet does not provide.