Bulk invoice generation: from spreadsheet to PDF in 5 minutes
If you bill 10+ clients per month, typing each invoice by hand is sand in your gearbox. Here's the modern setup that takes 5 minutes per month, regardless of whether you bill 10 or 1,000 clients.
The end state
Once you set this up, your month-end billing looks like:
- Update one column in your billing sheet (the amount per client)
- Click Generate
- 50 invoices appear in Drive, each in its own personalized PDF
- Each client gets the invoice in their inbox automatically
Total: 5 minutes. Setup time: 30 minutes (one-time).
What you need
- A Google account (free)
- Sheet to PDF — install free (10 PDFs/month, or €5/mo for 300)
- 15 minutes to build the template once
Step 1: The billing sheet
Create a Google Sheet. Add these columns in row 1:
Client | Email | Address | InvoiceNumber | Date | DueDate | Description | Amount | VATRate | VAT | Total
For the VAT calc, use a formula: =H2*I2/100 in column J (VAT), and =H2+J2 in column K (Total).
Step 2: The invoice template
Use the built-in Invoice (EU) template (free), or for smart VAT logic use Smart invoice (Starter €5/mo, hides VAT line when 0).
Customize with your company info, logo, bank details, footer language. Save as a Google Doc.
Step 3: Generate
Open the sidebar in your sheet, pick the template, click Generate. PDFs save to a Drive folder named like Invoices/2026-05/.
Step 4: (Pro plan) Auto-email each one
Toggle Email each PDF. Pick the Email column as recipient. Subject: Invoice {{InvoiceNumber}} from Your Company. Body: short note saying the invoice is attached.
Each client gets their invoice. Replies go to your inbox automatically.
Bonus: track payment status
Add a PaidDate column. Next month, use a smart template:
{% if PaidDate %}
Last month's invoice was paid on {{PaidDate}}. Thank you.
{% else %}
Reminder: invoice {{LastInvoiceNumber}} is still outstanding. Please pay at your earliest.
{% endif %}
The same template handles new invoices and dunning reminders in one batch.
Year-end accounting
Your sheet is now your authoritative source of truth. Pivot tables by month, filters by client, sums by quarter — all the things spreadsheets are good at, plus generated PDFs you can hand to your accountant.