Invoices & Billing

Free Invoice Template for Google Docs (Mail Merge Ready)

A clean, minimal invoice template for freelancers and small businesses — with line items, subtotal, tax, and total. Copy it into a Google Doc, connect a Google Sheet, and generate a personalized PDF invoice for every client in one click.

The template

Everything in {{double braces}} is a merge tag. Each tag matches a column header in your Google Sheet, and Batch Merge fills in the value from each row automatically — one finished invoice per row.

INVOICE {{Your Company Name}} {{Your Address}} {{Your Email}} ──────────────────────────────────────── Invoice Number: {{Invoice Number}} Invoice Date: {{Invoice Date}} Due Date: {{Due Date}} BILL TO {{Client Name}} {{Client Address}} {{Client Email}} ──────────────────────────────────────── DESCRIPTION AMOUNT {{Description}} {{Amount}} ──────────────────────────────────────── Subtotal: {{Subtotal}} Tax ({{Tax Rate}}): {{Tax}} TOTAL DUE: {{Total}} ──────────────────────────────────────── PAYMENT Please pay by {{Due Date}} via {{Payment Method}}. Questions? Reply to {{Your Email}} — we're happy to help. Thank you for your business! {{Your Company Name}}

Shortcut: a ready-made version of this invoice ships inside the add-on. In Google Sheets, open Extensions → Batch Merge → Open Batch Merge and pick Invoice from the built-in template library — it creates the Doc and a sample sheet for you.

Set up your Google Sheet

Create one column per merge tag. Column headers must match the tag names exactly (they're case-sensitive). Each row becomes one invoice:

Client Name	Client Email	Invoice Number	Invoice Date	Due Date	Description	Subtotal	Tax Rate	Tax	Total
Acme Design Co.	billing@acme.co	INV-2041	Jul 1, 2026	Jul 31, 2026	Brand refresh — June	$2,400.00	8%	$192.00	$2,592.00
Northwind LLC	ap@northwind.com	INV-2042	Jul 1, 2026	Jul 31, 2026	Consulting retainer	$1,800.00	8%	$144.00	$1,944.00

Tip: use Google Sheets formulas for the math columns — e.g. Tax = =G2*0.08 and Total = =G2+I2 — then format the columns as currency. Batch Merge inserts the displayed value.

Generate one invoice per row

Copy the template into a Google Doc. Click Copy template above, paste into a new Doc, and style it however you like — fonts, colors, your logo. Tags survive formatting.

Install Batch Merge free from the Google Workspace Marketplace, then open your sheet and choose Extensions → Batch Merge → Open Batch Merge.

Pick your template. Select the invoice Doc with the file picker. Batch Merge scans it and shows every tag as a pill — green when it matches a column header, amber when it doesn't. Fix any amber pills by renaming columns or tags.

Choose PDF output and run. Pick PDF (or DOCX / Google Doc), choose a Drive folder, and click Run. Batch Merge writes a status per row and a Merge Log so you always know what was generated.

On the free plan you get 25 merge runs per month — each run can process your whole sheet. Email delivery (send each invoice straight to {{Client Email}}), scheduling, and Google Slides templates are on Pro.

FAQ

Can I add my logo and brand colors?

Yes. The template is a normal Google Doc — add images, tables, headers, and styling freely. Batch Merge only replaces the {{tags}}; everything else is preserved in the output.

Can I email each invoice automatically?

Yes — on the Pro plan, add an email column and Batch Merge attaches each generated PDF to a personalized email per row.

What about multiple line items per invoice?

The one-row-per-invoice pattern works best with a summary description. For itemized invoices, add columns like Item 1, Item 2, Item 3 with matching tags in the Doc's table — unused tags can be left blank in the sheet.

Related templates

Generate every invoice in one click

Batch Merge is free to install — 25 merge runs per month, no credit card.

Install Batch Merge Free