Invoice Template for Mail Merge
A professional invoice template designed for bulk generation with Mergram. Upload the PDF, connect your billing data, and generate hundreds — even thousands — of personalized invoices in a single batch. Whether you bill monthly, quarterly, or on a project basis, this template eliminates the repetitive work of creating individual invoices by hand.
When to Use This Template
This invoice template is ideal whenever you need to produce a high volume of invoices that share the same layout but contain different client data. Specific scenarios include:
- Monthly billing cycles — Generate all client invoices at once from your accounting spreadsheet
- Freelancer batch invoicing — Send invoices to multiple clients for different projects simultaneously
- Agency retainer billing — Produce standardized invoices for dozens of retainer clients
- Subscription or membership renewals — Create renewal invoices with individual amounts and dates
- Service-based businesses — Invoice for completed work orders with varying line items and totals
If you currently copy-paste client details into the same invoice layout every month, this template will save you hours of manual work.
Template Fields
| Field | Description | Example | Spreadsheet Column |
|---|---|---|---|
| Client Name | Recipient company or person | Acme Corp | client_name |
| Client Address | Billing address | 123 Main St, New York, NY | client_address |
| Invoice Number | Unique identifier | INV-2025-0042 | invoice_number |
| Invoice Date | Issue date | January 15, 2025 | invoice_date |
| Due Date | Payment deadline | February 15, 2025 | due_date |
| Items | Line items (use multiple columns) | Web Design - $2,500 | items |
| Subtotal | Pre-tax total | $2,500.00 | subtotal |
| Tax | Tax amount | $250.00 | tax |
| Total | Grand total | $2,750.00 | total |
Field Mapping Guide
Field mapping connects each column in your spreadsheet to a specific position on the invoice PDF. Here is how to set it up:
- Prepare your spreadsheet — Each row represents one invoice. Column headers should match the field names above (e.g.,
client_name,invoice_number). If your headers differ, Mergram’s fuzzy matching will suggest the closest field. - Place fields on the canvas — Drag each field from the sidebar onto the PDF at the exact position where the data should appear. Resize fields to control text wrapping and alignment.
- Choose render types — Most fields use plain text. Use the QR code type for payment links or invoice verification URLs. Use the barcode type if you scan invoices in your warehouse.
- Preview before merging — Click Preview to see a real rendered invoice using your first row of data. Check that addresses wrap correctly and totals are positioned properly.
Tip
Use a consistent column naming convention in your spreadsheet. Names like client_name or invoice_number make auto-detection more reliable and reduce manual mapping effort.
Customization Tips
The visual appearance of your invoices is entirely controlled by your PDF template. Mergram overlays dynamic data onto the PDF without altering the underlying design:
- Replace the logo — Swap the placeholder logo with your company branding before uploading, or leave space on the template and add the logo as a static image
- Change fonts — Upload custom
.ttf,.otf, or.woff2fonts to match your brand guidelines. Apply them to any text field on the canvas - Add payment QR codes — Place a QR code field linked to a column of payment URLs (PayPal, Venmo, or banking links). Each invoice gets a unique, scannable code
- Custom filename templates — Auto-name output files using patterns like
invoice-[[client_name]]-[[invoice_number]].pdfso you never have to rename files manually - Multi-page invoices — If your template spans multiple pages (for detailed line items), Mergram supports field placement on any page
- Color-coded due dates — Use conditional formatting in your spreadsheet to highlight overdue amounts, then map that field to a prominent position on the invoice
Common Use Cases
Freelancer monthly billing: A freelance graphic designer sends 15–20 invoices per month. Each invoice has a different client, project description, and amount. By maintaining a single spreadsheet and a branded PDF template, all invoices are generated in under a minute.
Agency retainer invoices: A digital marketing agency bills 50 retainer clients on the first of every month. Each invoice includes the client name, retainer fee, any additional hours, and a unique invoice number. The spreadsheet is updated once, and 50 invoices are generated in one batch.
SaaS subscription renewals: A software company sends annual renewal invoices with individual pricing tiers, discount codes, and pro-rata adjustments. The invoice template includes a QR code linking to the online payment portal.
Service order completion: A landscaping company invoices clients after each job. The spreadsheet contains the service date, items performed, and total. Invoices are emailed as PDF attachments directly from Mergram.
Best Practices
- Pre-calculate in your spreadsheet — Use spreadsheet formulas for subtotal, tax, and total columns. Mergram places the final calculated values onto the PDF, so your spreadsheet is the single source of truth for all numbers
- Use consistent date formatting — Format date columns as text (e.g.,
January 15, 2025) in your spreadsheet to ensure they render exactly as intended - Test with a small batch first — Generate 3–5 invoices and review them carefully before running a full batch of hundreds
- Archive your spreadsheet — Keep a copy of the data file used for each billing cycle for audit purposes
- Set filename templates — Use
[[invoice_number]]in your filename pattern to guarantee unique file names and easy lookup later - Email delivery — Configure SMTP settings to send invoices directly as PDF attachments. Use the
[[client_name]]merge tag in the email subject line for personalized delivery
Get Started
Upload any invoice PDF and start merging at Mergram. Connect your billing spreadsheet, place your fields, and generate your first batch of invoices in minutes.