How to Create an Invoice in Word, Excel, and Google Docs (Free Templates)

You finished a job on Friday afternoon. Maybe a deck repair, a wedding shoot, a logo redesign, or a one-off consulting call. The customer is happy. They asked for an invoice. You sit down at your laptop and realize you have never made one.

The fastest free path is software you already own — Microsoft Word, an Excel invoice template, or Google Docs. None of them are designed for invoicing, but all three can produce a clean, professional invoice in about twenty minutes if you know what to type and where.

This guide walks you through creating an invoice in each of the three most common tools. You will see the exact fields to include, the formula tricks that turn Excel into a half-decent invoicing system, and the honest limits of every approach — what breaks when you grow past five clients a month, when version control turns into a nightmare, and when to graduate to a real invoicing app.

By the end, you will be able to send an invoice today and know what you will outgrow tomorrow.

What Every Invoice Needs (Before You Pick a Tool)

Whatever tool you use, every legitimate invoice contains the same fields. Skip these and you risk slow payment, tax problems, or both.

Header information:

The word “Invoice” clearly visible at the top
A unique invoice number
The issue date and the due date
Your business name and contact info — address, phone, email, website
Your client’s name and contact info

Body:

A clear list of line items — what you delivered, quantity, unit price, line total
A subtotal before tax
Tax (if applicable, with the rate clearly shown)
The grand total in bold and large enough to spot from across the room

Footer:

Payment terms — Net 15, Net 30, Due on Receipt
How to pay — bank details, payment link, check mailing address
A short thank-you note (optional, but it works)

A practical tip on invoice numbering: pick a sequence and stick with it. INV-2026-001, INV-2026-002, and so on works fine. Some accountants require strict sequential numbering with no gaps, so do not skip numbers. For a deeper dive, see our guide on invoice numbering best practices.

With the field list locked in, the tool is just a layout decision.

How to Create an Invoice in Word (Microsoft Word Tutorial)

Word is the right choice when you want a document that looks like a letter — clean typography, a logo at the top, plenty of white space, and no math beyond two or three line items. To create an invoice in Word, you start with a built-in template, replace placeholders, and save as PDF. It is the slowest of the three tools to update, but it produces the most polished result if you only invoice a few times a month.

Step 1: Start with a built-in template

Open Word and choose File → New. In the search box, type invoice. Word ships with at least a dozen invoice templates — basic, modern, blue, service, sales receipt. Pick one that matches your business style. If nothing fits, choose Blank document and build from scratch using the field list above.

For most service businesses, the Service Invoice or Basic Invoice template is the cleanest starting point.

Step 2: Replace the placeholder text

The template has placeholder fields like [Your Company Name], [Client Name], and [Description]. Click each one and type your real information. Be careful in the address blocks — Word’s templates often hide tab stops and table cells under placeholder text. If formatting jumps when you type, use View → Show Formatting Marks (the pilcrow icon on the Home ribbon) to see what is happening behind the scenes.

Step 3: Customize the line-item table

Most Word invoice templates include a four-column table: Description, Quantity, Unit Price, Line Total. To add a row, click in the last cell and press Tab. To delete a row, select it and right-click → Delete Rows.

Line totals do not calculate themselves. Word can do simple table math, but it is fragile — if you add a row and forget to update the formula, the total is wrong and you do not see it. The Excel section below covers the right way to handle formulas. In Word, the safer approach is to calculate totals on a calculator and type them in.

Step 4: Add your branding

Insert your logo with Insert → Pictures. Resize it so it does not dominate the page — about 1 inch tall is usually right. If you have brand colors, change the table header fill and heading font color to match. Do not use more than two fonts on the page.

Step 5: Save as PDF

This is the step most people skip. Word documents can be edited by anyone who receives them — including the person who is supposed to pay you. Always send your final invoice as a PDF.

Use File → Save As and choose PDF from the file format dropdown. Name it with the invoice number and client name, like INV-2026-014-Acme-Corp.pdf. This makes filing easier later when you are searching through dozens of invoices.

When Word works well

One-off projects, especially for clients who want a formal-looking document
Small monthly invoice volume (under 10)
Service businesses where each invoice has 1–5 line items and the math is simple
Solopreneurs who want their invoice to feel like correspondence

When Word breaks down

More than ten line items per invoice — Word’s tables get hard to read
Recurring invoices, where you want to copy last month’s invoice and only change a few values
Multiple tax rates or discounts — every change requires recalculating by hand
Tracking which invoices are paid — Word does not do that, full stop

How to Build an Excel Invoice Template (With Formulas)

Excel is the right choice when you have line items, tax math, and want totals that update automatically. An Excel invoice template looks less polished than Word out of the box, but it is far more practical for businesses that invoice five to twenty times a month. The same instructions apply to Google Sheets — formulas are identical and the menus look almost the same.

Step 1: Start with a template (or build clean rows)

Excel includes invoice templates under File → New → Search invoice. The Microsoft “Service Invoice” or “Sales Invoice” templates are decent starting points. If you want full control, open a blank workbook.

For a clean layout, leave Column A as a small margin (column width about 2), put your business info in B1:B4, the client info in F1:F4, and the line-item table starting at row 10.

Step 2: Build the line-item table with formulas

In row 10, add headers: Description, Quantity, Unit Price, Line Total.

Starting in row 11, fill in the first three columns by hand. The line-total column does the work for you. In cell E11, type:

=C11*D11

That multiplies quantity by unit price. Drag the formula down to cover as many rows as you need (10 to 20 rows of empty space is usually enough).

In the row below the last line item, add a Subtotal label and use:

=SUM(E11:E30)

(Adjust the range to match your line-item rows.)

Step 3: Add tax and total rows

Below the subtotal, add a Tax Rate cell (for example, 8.25% in cell D32 formatted as a percentage). Then a Tax Amount cell:

=E31*D32

Where E31 is your subtotal cell. Finally, the Grand Total:

=E31+E33

Format the grand total in bold, 14pt, and a brand color so the eye lands on it first.

Step 4: Use the right number formats

Select the unit price, line total, subtotal, tax, and grand total columns and apply currency formatting (Format → Currency, choose your country’s currency and 2 decimal places). This is the difference between an invoice that looks professional and one that looks like a homework assignment.

Step 5: Lock the formula cells (optional but smart)

If you reuse the same workbook every month, lock the formula cells so you do not accidentally type over the math. Review → Protect Sheet, choose what you want to allow, and set a password.

Step 6: Export to PDF

Like Word, never send an Excel file as your final invoice. The recipient can edit it, paste a different total, and claim that is what you sent.

Use File → Save As → PDF. Before saving, go to Page Layout → Print Area → Set Print Area and select just your invoice (so a stray cell on row 200 does not push your invoice onto a second page). Use Page Layout → Print Titles → Sheet → Fit to 1 page wide if your invoice is being chopped at the right margin.

When an Excel invoice template works well

Invoices with 5+ line items where typing totals by hand invites errors
Businesses with consistent tax rates that benefit from auto-calculating
Anyone tracking 5–20 invoices per month who wants a master spreadsheet listing them all
Owners who already live in spreadsheets

When Excel breaks down

Visual polish — even with formatting, an Excel invoice rarely looks as clean as a Word invoice or a templated invoice from an app
Mobile editing — Excel on a phone is painful, and field service pros invoicing from a truck cannot use it
Tracking payments across many clients — a “paid?” column works under 10 invoices, then breaks
Sending — you still attach the PDF to an email manually every time

How to Use a Google Docs Invoice Template

Google Docs is the right choice when you want the simplicity of Word but the convenience of cloud storage. A Google Docs invoice template is the most accessible of the three options — anyone with a Gmail account has it, and the templates are decent.

Step 1: Start with a template from the gallery

Go to docs.google.com, click the Template Gallery at the top, and scroll to the Work section. Look for Invoice — Google ships with a clean default. If you do not see the gallery, click the small icon at the top right of the templates row to expand it.

Open the template; it copies into your Drive automatically.

Step 2: Replace placeholders and customize

The template has placeholder text in brackets — [Your Company], [Address], [Invoice Number]. Click each and type your real information. Insert your logo via Insert → Image → Upload from computer and place it at the top.

The line-item table works the same way as Word’s. Click in the last cell and press Tab to add a row.

Step 3: Calculate totals (the awkward part)

Google Docs cannot do math inside a table the way Excel can. You have two choices:

Calculate by hand — fastest for short invoices.
Build the line-item table in Google Sheets — paste it back into the Doc as a linked table.

For option 2: open Google Sheets in another tab, build the line-item table there with formulas (same approach as the Excel section above), select the range, copy, and in your Google Doc choose Edit → Paste. Google offers to “Link to spreadsheet.” Click yes. Now when you change a number in the Sheet, click Update in the Doc and the table refreshes.

This is more steps than just using Sheets directly, but if you want the document to look like a letter rather than a spreadsheet, it is the cleanest workflow.

Google Docs is built for sharing. Click Share in the top right and either send a link directly or export to PDF via File → Download → PDF Document (.pdf).

If you share a link, set the permission to Viewer, not Editor — otherwise the client can edit your invoice. PDF is still safer because it travels through email without the recipient needing a Google account.

When a Google Docs invoice template works well

Cloud-first solo workers who want every document accessible from any device
Anyone who collaborates with a partner or bookkeeper — sharing is one click
Side hustlers and gig workers who do not own Microsoft Office
Teams that run on Google Workspace already

When Google Docs breaks down

Math inside the document — the Sheets workaround works but is fragile
Mobile invoicing in the field — the Google Docs phone app does not handle complex tables well
Templates locked to your branding — every invoice is a fresh document copy with the same manual tweaks
Audit trail — Google Docs keeps version history, but it is not designed for accounting

Honest Comparison: DIY Templates vs Invoicing Software

You can build perfectly legal, professional invoices in Word, Excel, and Google Docs. Millions of small businesses do, every day. So why does invoicing software exist?

It exists because three problems get worse the longer you stay on DIY templates.

Problem 1: Manual math errors

A wrong line total on an Excel invoice is a one-character typo. The customer pays the wrong amount. You catch it next month, refund or rebill, and now you have a paper trail full of corrections. Real invoicing software does the math automatically and shows the customer a fixed total.

Problem 2: Version control and “which version did I send?”

By month six, you have a folder of Invoice-Acme-final.docx, Invoice-Acme-final-v2.docx, Invoice-Acme-final-FINAL.docx. When the customer disputes a charge, you cannot tell which version went out. Software stores one canonical record per invoice and a clean history of edits.

Problem 3: Payment tracking

This is the big one. None of these tools track which invoices are paid. You can build a side spreadsheet, but as soon as you cross 20 active customers, it falls apart. You forget to follow up on a 60-day-old invoice. You stop knowing how much money you are actually owed.

Real invoicing software handles all of this in the background — payment status, automated reminders, partial payments, and payment links built into the invoice email. The minute you cross five active clients with overlapping payment cycles, the spreadsheet stops saving you time.

When DIY templates are the right answer

You invoice fewer than five clients per month
Most jobs are one-off (no repeat billing)
You do not accept online payments
You are testing the business and not ready to spend on tools yet

When DIY templates start costing more than they save

You spend more than thirty minutes a week chasing late invoices
You have re-issued an invoice with corrected math more than twice
A client has paid the wrong amount because of a template error
You are doing recurring work and rebuilding the invoice from scratch every month
You want to invoice from your phone, on a job site

Migrating From a Template to Invoicing Software

If you are at the second list, the move to dedicated invoicing software is usually a same-day project — not a quarter-long migration. Most invoicing apps let you keep your existing client list, copy your line-item descriptions, and start invoicing the same afternoon.

What you do not always get is automatic data import from your old templates. If you have hundreds of invoices in Word or Excel, you typically rebuild your client list and item catalog manually inside the new tool. Plan for an hour or two of typing. Many small businesses use that hour to clean up old client info anyway.

A practical migration order:

Pick the tool. Look for one that handles your specific workflow — mobile-first if you are in the field, multi-currency if you ship internationally, recurring billing if you have retainers.
Add your top ten active clients. Type or paste the contact info into the new app. Skip dormant clients — only add them when you have new work.
Build a small item catalog. Add the five to ten services or products you bill most often, with default descriptions and prices. Future invoices become 30-second jobs.
Run one invoice through the new tool, in parallel with your template. Send the new-tool version. Confirm it looks right and the customer can pay it without friction.
Switch over completely. Stop opening Word for new invoices. The templates remain in your archive for any historical lookups.

Pronto Invoice is built for this exact transition. The 5-step invoice flow takes about a minute to learn if you have ever filled out a Word or Excel template, the AI-powered chat lets you describe a job in natural language (“invoice ABC Construction for the deck repair, three hours at $95 plus $240 in materials”), and you can build, send, and accept payment from your phone — useful for field service work where the laptop is on a job site forty miles away. Free to start, with no invoice limits on paid plans.

If you only invoice twice a month and like the way Word looks, stay on Word. The honest answer is the tool fits the workload. The moment your workload outgrows the tool, switching is a Saturday afternoon project, not a business overhaul.

DIY Invoice FAQ

Are Word, Excel, and Google Docs invoices legally valid?

Yes. There is no legal requirement that an invoice come from specific software. As long as the document contains the required fields (invoice number, issue date, your business info, the client’s info, line items, and the amount due), it is legally valid. Some jurisdictions require additional fields — VAT registration numbers in the EU, GST numbers in India and Australia. Check your local rules.

Do I have to send invoices as PDFs?

Not legally, but practically yes. Sending a Word or Excel file means the recipient can edit your invoice. They can claim the total was different, change the due date, or alter your bank details. PDFs are static and timestamped; they hold up in any payment dispute. Always export to PDF before you send.

What is the cheapest way to send a professional invoice?

The free tools you already have. Microsoft Word and Excel come with most computer purchases. Google Docs and Sheets are free with any Google account. Free templates from any of the three will produce an invoice that looks just as legitimate as one from paid software, as long as you fill in the right fields.

When should I switch from a template to invoicing software?

Three signals: you spend more than thirty minutes a week chasing late payments, you have made math errors on more than one invoice, or you are sending more than ten invoices a month. Any one of those is a sign the template is now slowing you down more than it is helping you.

Can I track which invoices are paid in Word or Excel?

Word, no. Excel, sort of — you can add a “Paid?” column to a master sheet and update it manually. This works for under 10 active invoices. Past that, it falls apart because there is no automated reminder, no payment link, and no notification when a customer pays. This is the single most common reason small businesses outgrow templates.

Is Google Docs better than Microsoft Word for invoices?

Neither is better universally. Google Docs is better if you collaborate, work on multiple devices, or do not own Microsoft Office. Word is better if you want full offline control and slightly more layout precision. Both produce identical-looking PDFs to the customer, so the customer does not care which you use.

What about free online invoice generators?

There are dozens — InvoiceGenerator.com, Zoho Invoice’s free tier, and others. They are slightly faster than Word or Excel for one-off invoices because the layout is pre-built. They are usually weaker than dedicated invoicing software because they do not save your client list, do not track payment status, and often watermark the output unless you sign up. Useful for an emergency invoice; not a long-term system.

Key Takeaways

Every invoice needs the same fields regardless of the tool — header info, line items with totals, payment terms, and a due date. Get the fields right and the tool is a layout choice.
Word is the cleanest visual choice for low-volume, formal-looking invoices. Math is manual; the polish is high. Best for solopreneurs sending under 10 invoices a month.
An Excel invoice template is the right choice when you have multiple line items, tax math, or want auto-calculating totals. Less polished than Word, far more practical for 5–20 invoices a month.
A Google Docs invoice template is the cloud-first version of Word. Same strengths, same limits, plus easier sharing and easier multi-device access. Great for side hustlers without Microsoft Office.
Always export to PDF before sending. Sending an editable Word, Excel, or Google document is the fastest way to invite a payment dispute or a fraudulent edit.
DIY templates start costing more than they save when you cross five active clients, when payment tracking turns into a side spreadsheet, or when you want to invoice from your phone in the field.
Migrating to invoicing software is a Saturday-afternoon project, not a quarter-long migration — bring your top ten clients, build a small item catalog, run one invoice in parallel, then switch.

Templates are the right starting point for almost every new business. They become the bottleneck the moment volume picks up. Recognizing the moment of transition — and not staying on a template a year longer than you should — is what separates invoicing that supports your business from invoicing that gets in its way.

If you are crossing that line right now, Pronto Invoice is built for the move from templates to a real invoicing system without the migration headache. Free to start, no credit card required, and the first invoice takes about a minute.