Is it better to make an invoice in Excel or Word?

Use Excel (or Google Sheets) when you have multiple line items or want totals and tax to calculate automatically with formulas. Use Word (or Google Docs) for a simple, letter-style invoice with only a line or two, where layout control matters more than maths.

What formula calculates the total on an Excel invoice?

For each line, multiply quantity by unit price, e.g. =B2*C2. For the subtotal, sum the amount column with =SUM(D2:D10). For tax at 20%, use =D11*0.2, then add subtotal and tax for the grand total. Adjust the cell references and tax rate to match your layout.

Should I send the invoice as a Word/Excel file or a PDF?

Always send a PDF. The original .docx or .xlsx file can be edited by the recipient and may display differently on their device. Exporting to PDF locks the layout and your figures.

Are there free invoice templates for Excel and Word?

Yes. Word and Google Docs include a few basic invoice layouts in their template galleries, and InvoiceYard offers free downloadable templates plus a browser-based generator that exports to PDF, Excel, and Word — no sign-up required.

How to Make an Invoice in Excel, Word & Google Docs

Which Tool Should You Use?

Excel, Word, and Google Docs can all produce a perfectly professional invoice. The right one depends on what you already have open and how much maths is involved.

Excel (or Google Sheets) is best when you have several line items or you want totals and tax to calculate themselves. Word (or Google Docs) is best for a clean, letter-style invoice with just a few lines, where you'd rather control the layout than fiddle with formulas. Google's versions are the same idea, free, and live in your browser — handy if you switch between devices.

All three share one weakness: you rebuild the same document every month, and a stray click can break your formatting or your formula. If you bill regularly, a dedicated tool removes that friction — more on that at the end.

How to Make an Invoice in Excel

Excel shines when numbers need to add up on their own. Here's a layout that works:

1. Build the header. Merge a few cells across the top for your business name, then add your address, email, and phone beneath it. In the top-right, add three labelled cells: Invoice Number, Issue Date, and Due Date.

2. Add the client block. A few rows down on the left, label a small block "Bill To" and leave space for the client's name and address.

3. Create the line-item table. Use four columns: Description, Quantity, Unit Price, and Amount. Add a header row, then format the Unit Price and Amount columns as currency (Format Cells → Currency).

4. Let Excel do the maths. In the Amount column, multiply quantity by unit price. If Quantity is column B and Unit Price is column C, the first amount cell is =B2*C2. Copy that formula down the column.

Totals formulas: Subtotal = =SUM(D2:D10) (the range of your Amount column). Tax = =D11*0.2 for a 20% rate (swap in your own rate). Grand total = =D11+D12. Now the invoice recalculates itself whenever you change a line.

5. Format for print. Turn off gridlines (View → uncheck Gridlines) for a cleaner look, set the print area, and use Page Layout to fit everything on one page. Save as PDF before sending — never send the raw .xlsx, or the client can edit your figures.

How to Make an Invoice in Word

Word is the faster choice when you only have one or two lines and want it to look like a polished business letter.

1. Start from a table. Insert → Table and create a grid for your line items (Description, Qty, Rate, Amount). Tables keep columns aligned far better than tabs or spaces ever will.

2. Add your header and client details above the table as normal text. Put "INVOICE" in a large, bold font at the top so it's unmistakable.

3. Build the totals. Word won't calculate for you by default, so type your subtotal, tax, and total manually — or use Table Tools → Formula (=SUM(ABOVE)) if you want it semi-automatic. Double-check the arithmetic before sending; a manual total is the easiest thing to get wrong.

4. Save as PDF. File → Save As → PDF. This locks the layout and stops fonts shifting on the client's machine.

Watch out: Word's built-in invoice templates often include placeholder text you forget to replace ("Company Name", "[Street Address]"). Read the whole thing once before you send it — leftover placeholders look careless.

How to Make an Invoice in Google Docs or Sheets

Google's tools work just like Word and Excel, with two advantages: they're free, and everything autosaves to your Drive so you always have a copy.

Google Docs: open a blank document, insert a table for line items, and follow the same steps as Word. For a head start, open the template gallery from the Docs home screen — there are a couple of basic invoice layouts you can adapt.

Google Sheets: the Excel formulas above work unchanged — =B2*C2 for line amounts, =SUM(D2:D10) for the subtotal. Sheets uses the same syntax.

Exporting: File → Download → PDF Document. Always send the PDF, not a share link to the live file — a link lets the recipient edit it, and it can break if you later move or rename the file.

Don't Forget the Required Details

Whichever tool you use, a compliant invoice needs the same core fields: your business name and contact details, the client's details, a unique invoice number, the issue and due dates, an itemised list of what you're charging for, and the total.

If you're registered for VAT or GST, you must also show your tax number and the tax charged. UK VAT invoices need your VAT number and the applicable VAT rate(s) and amount(s) shown; Australian GST-registered businesses generally issue a tax invoice showing their ABN and enough detail to identify it as a tax invoice; Canadian invoices reference GST/HST. US invoices for services usually don't include sales tax, but it varies by state. Our guide to writing an invoice covers every field in detail.

The Faster Alternative

Spreadsheets and documents are fine for the occasional invoice. But if you bill every week, recreating the file, fixing a broken formula, and exporting to PDF adds up.

Our free invoice generator does all of this in your browser: it numbers invoices automatically, calculates totals and tax for your country, and exports a clean PDF, Excel, or Word file in one click. There's no sign-up, and nothing you type is uploaded anywhere. If you want a head start for your trade, browse the industry templates — each one comes pre-filled with realistic line items.