All guides
Invoicing

How to Make an Invoice in Word, Excel, or Google Docs (And When to Stop)

Invoity TeamJuly 9, 2026

Word, Excel, and Google Docs can all produce a professional invoice, and for your first few clients they might be all you need.

This guide shows how to build an invoice in each tool, how to save it as a PDF your client can't edit, and where each approach starts to fail: not on invoice number one, but on invoice number forty.

The quick version

To make an invoice in Word or Google Docs, create a document with your business details at the top, the word "Invoice" with a unique invoice number and date, the client's name and address, a table of line items with quantity, rate, and amount, then a subtotal, any tax, a total due, and your payment terms. In Excel or Google Sheets, build the same layout in cells and use formulas (=B5*C5 for line totals, =SUM for the subtotal) so the math calculates itself. In every tool, export the finished invoice as a PDF before sending: File > Save As > PDF in Word and Excel, File > Download > PDF in Google Docs. All three work fine for occasional invoicing; the manual upkeep is what becomes a problem at volume.

How to make an invoice in Word

Word is the natural choice if you think of an invoice as a document rather than a calculation. The structure to build:

  1. Header. Your business name (or your own name if you invoice without a company), address, email, and phone, plus your logo if you have one.
  2. The word "Invoice." Large, near the top. Below it, the invoice number (for example, INV-0042), issue date, and due date.
  3. Bill To block. Client's business name, contact person, and address.
  4. Line item table. Four columns: Description, Quantity, Rate, Amount. One row per service, like "Website homepage redesign, 1, $1,200.00, $1,200.00."
  5. Totals. Below the table, right-aligned: Subtotal, tax (if any), and Total Due in bold.
  6. Payment details and terms. How to pay, and terms like Net 30 or "Due on receipt."

Save the editable version as your template, then use File > Save As and choose PDF for the copy you send. Sending the .docx is a mistake: the client can edit it, fonts can shift, and it looks less final.

The catch with Word: it does not calculate anything. List 12 hours at $85, mistype the amount as $960 instead of $1,020, and nothing flags it. Every subtotal, tax line, and total is arithmetic you do and type in yourself.

How to make an invoice in Excel

Excel (or any spreadsheet) fixes Word's math problem. Build the same visual structure in cells:

  1. Reserve the top rows for your business details and the client's, just like the Word layout.
  2. Set up columns for Description, Quantity, Rate, and Amount, one row per line item.
  3. In the Amount column, use a formula instead of typing the number: if Quantity is in column B and Rate in column C, row 5 gets =B5*C5.
  4. Subtotal with =SUM(D5:D12) across your Amount cells.
  5. For tax, multiply the subtotal by the rate, for example =D13*0.0825 for 8.25 percent (rates vary by state and locality, so verify yours). Total Due is subtotal plus tax.
  6. Format the money cells as currency so $1,200 doesn't display as 1200.

A quick worked example: 3 items at $450, plus 6 hours at $95, gives line amounts of $1,350 and $570, a subtotal of $1,920, tax at 8.25 percent of $158.40, and a total due of $2,078.40. In Excel, changing the hours from 6 to 8 updates everything automatically. In Word, you'd recalculate three numbers by hand.

To send it, use File > Save As (or Export) and choose PDF, checking the print area first so the PDF doesn't spill onto a second page.

Excel's weakness is the inverse of its strength: formulas are powerful and fragile. Insert a row inside your line items and =SUM(D5:D12) may or may not expand to include it. Copy last month's file, delete old rows, and a formula can quietly reference the wrong cells. The invoice still looks right; the total is wrong.

How to make an invoice in Google Docs (and Sheets)

Google Docs works almost exactly like Word: same structure, same line item table, same manual math. Google Sheets works like Excel, same formulas. Two differences matter:

  • Access from anywhere. Your invoice lives in Drive, editable from any device.
  • Sharing risk. A shared link with edit access means your client (or anyone forwarded the link) can change the invoice. Always download as PDF: File > Download > PDF Document. Never send the live link as the invoice itself.

In either Google tool, keep a master template and use File > Make a Copy for each new invoice, renaming the copy with the invoice number and client name. That discipline is what prevents a folder of files named "invoice final v3 ACTUAL."

Where all three break down at volume

For your first handful of invoices, none of this matters much. Send fifteen a month and all of it does.

Manual numbering drift. Every invoice needs a unique sequential number, and in Word, Excel, or Docs the number is whatever you remember to type. Skip from INV-0041 to INV-0043, or issue two INV-0042s to different clients, and you won't notice until months later. A proper invoice numbering system helps, but the tools won't enforce it for you.

Math and formula errors. Word can't check your arithmetic at all. Excel checks it only while every formula points at the right cells, which duplicated and edited files quietly undermine. And if a total is wrong after sending, there's a right way to correct an invoice.

Version chaos. Each invoice is a separate file. Which one did you actually send? When a client disputes a March invoice in September, the answer lives somewhere in a folder of near-identical filenames.

No tax or discount logic. A 10 percent discount on one line but not others, tax that applies in one state but not another, a deposit already paid: in a document tool, each is manual math you redo per invoice. (General guidance only; sales tax rules vary by state and situation, so verify yours.)

Branding inconsistency. Your logo is larger on some invoices because you dragged a corner. The font changed when you edited on another computer. Individually trivial, collectively it reads as disorganized, and disorganized invoices are easier for clients to deprioritize. That matters: 56% of US small businesses are owed money from unpaid invoices, averaging about $17,500, and 47% report invoices already more than 30 days past due, per the Intuit QuickBooks 2025 US Small Business Late Payments Report. Anything that makes your invoice easier to ignore works against you.

Word vs Excel vs Google Docs vs a dedicated generator

A fair comparison, because each option genuinely wins somewhere:

WordExcelGoogle Docs/SheetsDedicated generator
CostIncluded if you own OfficeIncluded if you own OfficeFreeFree options exist
Setup time (first invoice)20-30 min30-45 min20-45 min2-5 min
Automatic mathNoYes, if formulas stay intactDocs no, Sheets yesYes, always
Sequential numberingManualManualManualAutomatic
Tax and discount handlingManualManual formulasManualBuilt in
Consistent brandingDepends on disciplineDepends on disciplineDepends on disciplineLocked to template
Version controlFile naming disciplineFile naming disciplineBetter (Drive history)Each invoice stored once
PDF outputSave As > PDFSave As > PDF, watch print areaDownload > PDFInstant
Best forOne-off, document-style invoicesCalculation-heavy line itemsWorking across devices, freeInvoicing regularly

The honest read: if you send an invoice or two a month, Word or Sheets is fine; the problems above compound with invoice count, not with time.

When it's worth switching

A reasonable rule of thumb: if you invoice more than a few times a month, or you've ever caught a numbering gap, a wrong total, or a wrong file version, the document-tool approach is costing more time than it saves. Getting documents out fast and correct is step one of getting paid on time.

If you want the structure handled without leaving the browser, a free invoice generator handles numbering, line-item math, tax and discounts, and consistent branding automatically, with instant PDF download and no signup to start. If you bill the same clients on a schedule, the multiple-invoices option generates a numbered series across dates in one pass, replacing the copy-rename-edit ritual. And a profession-specific invoice template beats rebuilding the layout each time.

None of that makes Word or Excel wrong; they're the right tool for a lower volume of work.

Frequently asked questions

Does Word have a built-in invoice template?

Yes. Word ships with invoice templates, and searching "invoice" in the template gallery surfaces more. They're a fine starting point, but you still handle numbering, math, and versioning manually, so check any template against a list of what to include on an invoice first.

How do I make an invoice calculate automatically in Excel?

Use a formula in each Amount cell that multiplies quantity by rate, such as =B5*C5, then total the column with =SUM(D5:D12). Add tax by multiplying the subtotal by your rate. Double-check formulas whenever you add or delete rows, since edits can break cell references without any visible error.

Should I send an invoice as a Word file or a PDF?

Always a PDF. A Word or Docs file can be edited by the recipient, may display differently on their machine, and looks less final. Keep the editable file as your template and export a PDF for every invoice you send.

Is it unprofessional to make invoices in Google Docs?

No. Clients care that the invoice is clear, accurate, and complete, not which tool produced it. A well-structured Google Docs invoice downloaded as a PDF is perfectly professional. The risks are operational, not cosmetic: manual numbering, manual math, and the temptation to share an editable link instead of a PDF.

iv
Written by the Invoity Team

The Invoity team publishes practical guidance about invoices, receipts, quotes, payment terms, and small-business records. Material factual claims are attributed where a direct source is available, and update dates change only after substantive edits.

Editorial standards and corrections

Create the invoice while the details are fresh

No signup to start. Free PDFs include a small Invoity watermark.

Open the invoice generator

Keep reading