Invoice Generator Online Free Excel: Tips and Common Mistakes

What is Invoice Generator Online Free Excel?

It is a free, no-signup browser tool that assembles a proper A4 VAT invoice as you type and then hands you two things: a real editable .xlsx spreadsheet and a print-to-PDF copy. There is no account, no email capture and no stored history, so the file you download is your only record — save it somewhere sensible before you close the tab.

The interface is split: your inputs sit on the left, a live A4 preview renders on the right, and a totals bar stays pinned under the document. That matters because invoices are WYSIWYG documents — you should see the layout settle before you commit, not discover a wrapped address line after sending.

Defaults suit a UK sole trader straight away: A4 paper, GBP (£) currency, DD/MM/YYYY dates and 20% VAT. If you only need a handful of invoices a year, this sits in a different category from a subscription ledger — it's closer to a well-built form. You can find it alongside the rest of the OnlineFree.app free online tools.

How do you build an invoice in under a minute?

Start with the business block. It accepts up to 400 characters across a maximum of four lines, and the first line is required — put your trading name there, then address, postcode and contact details on the lines below. The client block works the same way, capped at 400 characters with the client name on line one.

Next, the invoice meta: an invoice number defaulting to INV-0001 and capped at 20 characters, an invoice date that defaults to today, and payment terms of 7, 14 or 30 days with 14 preselected. Then add line items — description, quantity and unit price — and the line total computes as you type.

Finish with VAT and currency, check the three figures in the totals bar (subtotal, VAT at the stated rate, total due), and hit Download .xlsx or Print / Save as PDF. The whole sequence is genuinely a typing exercise; the calculation and layout work happen underneath.

What are the most common invoicing mistakes?

Reusing or skipping invoice numbers is the classic one. HMRC expects a unique, sequential reference, and the 20-character limit here is easy to hit if you build long client codes into the number — keep it short (INV-0042, 2026-018) and keep a list somewhere outside the tool.

The second mistake is VAT treatment left on the default. The selector opens at 20%, which is correct for most UK services but wrong for a zero-rated or exempt supply, and wrong for anyone not VAT registered. If you're not registered, must not charge VAT at all, set the rate to 0%.

Third: your own VAT registration number has no dedicated field, so add it inside the business textarea (for example on line two or three) or it simply won't appear on the invoice. Two smaller traps: fractions of an hour need to be entered in decimals (7.5, not 7h30), and blank line items are ignored rather than left as empty rows.

How do you handle VAT on a UK invoice?

The VAT selector accepts 0%, 5%, 20% or a custom number between 0 and 100 with up to two decimal places. At 0% the preview shows the words "VAT not applicable" rather than a £0.00 VAT line, which is exactly what you want for an invoice from a business that isn't VAT registered.

Be precise about why the rate is zero, though. "Not applicable" is not the same statement as a zero-rated or exempt supply, and a VAT-registered business may need to say which applies. GOV.UK's guidance on VAT invoices lists what a valid VAT invoice must show, and it's worth reading once rather than guessing.

As of 2026, the UK VAT registration threshold is £90,000 of taxable turnover in any rolling 12-month period, per GOV.UK's guide to VAT registration. Cross that line and the invoice you issue changes shape — check the current rules rather than relying on any tool's defaults.

The .xlsx export writes values, not formulas

Download .xlsx gives you a genuine spreadsheet that opens in Excel, Google Sheets or LibreOffice — but the cells hold fixed values. Subtotal, VAT and total due are numbers, not SUM or percentage formulas. Change a quantity in the spreadsheet and nothing recalculates.

That is a deliberate trade-off: value-only cells import cleanly into bookkeeping software and paste into a client's template without dragging formula errors along. The cost is that the spreadsheet is a snapshot. If something's wrong, the honest fix is to correct the field in the builder and download again.

If you do edit the file, recalculate the three totals yourself and double-check that the VAT figure you typed matches the rate shown on the document. A mismatch between the stated rate and the arithmetic is the kind of detail an accountant spots immediately.

Print to PDF without breaking the A4 layout

The preview is sized to A4, so use the browser's Print / Save as PDF button and confirm the paper size is A4 with default margins. Leave scaling at 100% — choosing "fit to page" tends to shrink the type for no reason on a document that already fits.

Turn headers and footers off, or your PDF will carry the page URL, the date and a page number across the top or bottom. If your browser offers a background graphics option, enable it so any shading in the table survives the print.

Choose "Save as PDF" rather than sending to a printer, then send that PDF to the client. Keep the .xlsx for your own records or for a bookkeeper who explicitly asked for a spreadsheet — the PDF is the copy nobody can quietly edit.

References

• GOV.UK: VAT invoices — what they must show
• GOV.UK: When to register for VAT