How to Use Invoice Generator Online Free Excel: Step by Step

A free A4 invoice builder with a live preview

Invoice Generator Online Free Excel is a free, no-signup invoice builder that previews a proper A4 invoice while you type and exports it as an editable Excel (.xlsx) file, with a print-to-PDF copy alongside it. Nothing is installed and nothing is emailed to you: you open the page, fill in the fields and download.

The layout is deliberately split — controls on the left, a live A4 document on the right, and a totals bar pinned under the preview showing subtotal, VAT and total due, recalculated on every keystroke. That matters because invoices are WYSIWYG documents: you want to see how the itemised table sits on the page before it ever reaches a client.

It is a one-document tool, not an accounting system. There is no customer database, no recurring invoices and no payment tracking, so when you need a second invoice you change the number and start again. That is exactly what a sole trader who needs an invoice out today wants, and it sits comfortably beside the other free online tools on OnlineFree.app when there is one small job to finish.

How do you fill in the invoice step by step?

Open Invoice Generator Online Free Excel and work top to bottom: everything in the left-hand panel is an input, and the right-hand panel shows exactly what will print. For a one or two-line invoice the whole process takes well under a minute.

Start with the business block — up to 400 characters across four lines, name or trading name on the first line, then address, then email. If you are VAT registered, put your VAT number on one of those lines, because there is no separate field for it. Do the same for the client block, where the name line is required and the rest is free text.

Next comes the invoice meta: number (default INV-0001, maximum 20 characters), invoice date (defaults to today) and payment terms of 7, 14 or 30 days, defaulting to 14. Then add line items — description, quantity and unit price — with quantities up to 9,999 and prices up to 1,000,000, both to two decimal places, and a maximum of 60 rows. Blank rows are ignored, so you can leave one waiting at the bottom.

Finish with the VAT rate (0%, 5%, 20% or a custom figure between 0 and 100) and the currency (GBP, EUR or USD only), then check the totals bar and click Download .xlsx. A worked example: one homepage design at £450, four hours of copywriting at £65 and a £30 hosting setup give a subtotal of £740; at 20% the tool shows £148 of VAT and £888 total due. If an input is wrong, the preview is wrong — the preview is your check.

Does the tool get UK VAT and totals right?

VAT is applied as a single rate to the whole subtotal, defaulting to 20%, the standard UK rate. HMRC's guidance on VAT invoices lists what a valid VAT invoice must show — supplier name, address and VAT number, a unique invoice number, the date, a description of what you supplied, the total excluding VAT, the rate, the amount of VAT and the total including VAT. The builder gives you a slot for each of those, but it cannot know your VAT number, so type it in yourself.

Set the rate to 0% and the invoice prints “VAT not applicable” instead of a zero-rated VAT line. That is the correct wording for an unregistered sole trader; it is the wrong wording for a VAT-registered business making zero-rated supplies, where you should show 0% and still quote your registration number. If your turnover is approaching the registration threshold, check GOV.UK's registration guidance before you decide.

One arithmetic detail worth knowing: VAT is calculated on the subtotal as a single figure, not line by line. On fiddly jobs — many small items, or 5% on domestic fuel and power — an accounting package that rounds per line can differ by a penny or two from the tool's total. Reconcile anything unusual against your own records rather than assuming the two will always agree.

Send the Excel file or the PDF?

The .xlsx download is the format most bookkeepers and finance teams ask for, and it opens in Excel, LibreOffice Calc, Google Sheets, Numbers and most other spreadsheet apps. The cells hold plain values rather than formulas, so the totals are fixed numbers. That is deliberately simple, but it means editing a quantity in Excel will not recalculate anything — if the figures change, edit the line items in the tool and download again.

The PDF route is your browser's print dialog: choose Print / Save as PDF, set paper size to A4 and scaling to 100% so the preview and the printout match. Switch off headers and footers, or you will get the page URL and date stamped across your invoice, and leave background graphics on if you want any shading to survive.

For a one-off client who simply needs to pay you, send the PDF. For an agency, an accountant or a client with a purchase-order system, send the .xlsx as well. Neither file carries a digital signature or your logo, so if the recipient insists on a signed or branded invoice, confirm that before you send it.

Mistakes to avoid before you download

The most common error is reusing an invoice number. Each VAT invoice needs a unique, traceable number, so issuing INV-0001 twice creates an accounting headache — keep a short log of the numbers you have used. The 20-character limit is generous but not endless: INV-2026-0347 fits, INV-2026-03-17-001-client-X does not.

Watch the free-text blocks too. Four lines and 400 characters sounds like plenty until you paste a full registered address with a long building name; condense it rather than cutting off mid-postcode. Dates display as DD/MM/YYYY, which suits UK clients but can puzzle a US one, and the currency list stops at GBP, EUR and USD, so you cannot invoice in, say, Swedish kronor.

Keep copies. GOV.UK's VAT record-keeping guidance expects VAT records to be preserved for six years, and there is no account on the tool storing your invoices for you — the file on your disk is the only record. The builder validates required fields and ranges only, so check the VAT number, the client name and the totals yourself before sending. Treat the download as a verified draft, not as an authority.

References

• GOV.UK — VAT invoices
• GOV.UK — VAT record keeping