Invoice Generator Online Free Excel: A Free UK VAT Invoice Builder
Reviewed by the OnlineFree.app team · Updated
Key points
- Invoice Generator Online Free Excel builds a live A4 invoice and exports an editable .xlsx without a signup.
- Totals recalculate on every keystroke: subtotal, VAT at the chosen rate, and total due.
- The Excel download holds finished values, not formulas, so update totals by hand after edits.
- It stores no invoice history, so keep your own numbered copies for at least six years.
- One VAT rate and GBP, EUR or USD per invoice — mixed-rate jobs need separate documents.
What is Invoice Generator Online Free Excel?
It's a browser-based invoice builder that turns four short inputs — your business details, the client, invoice meta and line items — into a finished A4 invoice you can download as an editable .xlsx file or print to PDF. There is no account, no email confirmation and no paywall.
The screen is split: controls on the left, a live A4 preview on the right, and a totals bar pinned under the preview. Every keystroke recalculates the subtotal, the VAT at the rate you selected (20% by default) and the total due. Because the preview is the document, you never have to guess what the export will look like.
It sits inside a wider collection of OnlineFree.app free online tools, and the whole workflow is deliberately narrow: type business details, one or two line items, download. Invoice Generator Online Free Excel is built for the sole trader or micro-business owner who needs an invoice out today and whose bookkeeper or client asked specifically for a spreadsheet.
How it compares to other invoice options
A manually formatted Excel or Word template is free and familiar, but you pay for it in time: retyping your address, re-aligning columns and re-checking the VAT formula on every invoice. Accounting platforms such as Xero or QuickBooks do far more — recurring invoices, bank feeds, client records — but they want an account, and usually a subscription, before you can send anything.
Most free online invoice generators sit in between: fast to fill in, but often PDF-only, watermarked, or gated behind an email address before the download unlocks. This tool is aimed at one narrow job — produce a clean .xlsx your bookkeeper or client specifically asked for, plus a print-to-PDF copy, with no signup.
Where it loses, honestly: it keeps no invoice history, cannot schedule recurring invoices, does not email your client or take payment, and applies a single VAT rate to the whole document. If you issue dozens of invoices a month to repeat clients, proper accounting software will save you more time than it costs.
How do you build a VAT invoice in 30 seconds?
Start with your own details. The business block has a hard four-line limit, so keep it tight: 'Northline Design' / '12 Example Street, London, EC1A 1AA' / '[email protected]' / 'VAT No: GB123456789'. Only the first line is required by the form, but a VAT-registered invoice needs your VAT number somewhere in that block, and this is the natural place.
Now add line items. 'Website design — 5 page build', qty 1, unit price £450.00, produces a line total of £450.00. 'Copywriting', qty 3, unit price £85.00, produces £255.00. The totals bar immediately reads Subtotal £705.00, VAT 20% £141.00, Total due £846.00. Switch the VAT select to 5% and it becomes £35.25 and £740.25; set it to 0% and the invoice prints 'VAT not applicable'.
Finally the meta: invoice number (default INV-0001, up to 20 characters), the invoice date (today by default, shown DD/MM/YYYY) and payment terms of 7, 14 or 30 days. With 14-day terms and a date of 12/03/2026, payment is due by 26/03/2026. Then download the .xlsx, or use Print / Save as PDF — the preview is the document, so what you see is what ships.
What a UK VAT invoice must show
Only VAT-registered businesses issue VAT invoices, and as of 2026 you must register once taxable turnover passes £90,000 in any rolling 12-month period — check the current figure on GOV.UK before relying on it. Below that threshold you can still issue ordinary invoices; just don't call them VAT invoices or quote a VAT number you don't hold.
For a compliant document, GOV.UK's VAT invoice guidance requires a unique invoice number, the invoice date (and the tax point if it differs), your business name, address and VAT number, the client's name and address, a description of what you supplied, the unit price excluding VAT, the VAT rate and amount, and the total excluding and including VAT.
The builder covers all of that except the VAT number, which you type into the business block, and the 'total excluding VAT' line, which appears as Subtotal in the totals bar and the itemised table. If you are not VAT-registered, leave the select at 0% so the document reads 'VAT not applicable' rather than showing a pointless £0.00 tax line.
What the .xlsx download actually contains
Clicking the button writes a genuine .xlsx workbook — no macro, no password, no PDF dressed up as a spreadsheet. It opens in Excel, LibreOffice Calc and Google Sheets, and because the content is plain values rather than formulas, nothing breaks when a client's finance system imports it.
That design choice cuts both ways. Change a quantity inside the spreadsheet and the line total, subtotal and VAT figure will not update themselves; you would edit those by hand. If you need the change reflected everywhere, regenerate the invoice in the tool and download again — it takes seconds.
The print button hands the same A4 layout to your browser's print dialog, where 'Save as PDF' gives you a flat copy to email to clients who want something they can't edit. HM Revenue & Customs expects VAT records to be kept for at least six years, so file both copies somewhere findable — see GOV.UK's record keeping rules.
Common mistakes and honest limitations
Two things trip people up most: leaving the default INV-0001 in place, and leaving VAT at 20% when the business isn't VAT-registered. The builder has no memory — every fresh session starts at INV-0001 — so numbering is entirely your job, and unbroken sequential numbering is what a VAT officer expects to see.
The structural limits are worth knowing before you commit. There is one VAT rate per invoice, so a job mixing standard-rated (20%) and reduced-rated (5%) work needs two invoices or a manual edit of the spreadsheet. Currency is limited to GBP, EUR and USD, line items are capped at 60 rows, and quantities and prices accept two decimal places.
Treat the totals as a convenience, not an authority. The arithmetic is simple — line totals, subtotal, VAT, total — but check the figures before sending, particularly on large or multi-currency invoices. The same no-signup approach runs across the other free online tools on OnlineFree.app, including the Calculator For Protein Intake — a completely different job, same browser-only workflow.
Frequently asked questions
Is Invoice Generator Online Free Excel free, and do I need to sign up?
Yes, it is free and requires no account, email address or signup. You fill in the form, download the .xlsx file or use Print / Save as PDF, then close the tab. There is no dashboard storing your invoice history, so save your own numbered copies somewhere you can find them later.
Does the downloaded Excel file recalculate totals with formulas?
No. The export writes finished values, not live formulas: line totals, subtotal, VAT and total arrive as plain numbers you can edit directly. That keeps the file predictable in Excel, LibreOffice and Google Sheets, but if you change a quantity in the spreadsheet you must update the totals yourself or regenerate the invoice in the tool.
Can I use it to create a VAT invoice HMRC will accept?
The tool produces the document; HMRC's rules decide what must appear on it. For a UK VAT invoice include your VAT number, a unique sequential invoice number, the invoice date, both addresses, a clear description of the supply, unit prices excluding VAT, the VAT rate and amount, and the total excluding and including VAT.
Which invoice number and currency should I use?
The tool defaults to INV-0001 and does not remember previous invoices, so replace it with the next number in your own sequence and keep that sequence unbroken across the tax year. Currency is limited to GBP (£), EUR (€) and USD ($), and the chosen symbol is applied to every figure on the invoice.
What happens if I set VAT to 0%?
Selecting 0% prints 'VAT not applicable' instead of a £0.00 VAT line, which suits non-registered sole traders billing UK clients. If you are VAT-registered and making zero-rated supplies, that wording may be too blunt — zero-rated invoices should still state the VAT rate and value, so add a note or edit the spreadsheet before sending.