Bulk Invoice Generation

What Is Bulk Invoice Generation?

Bulk invoice generation is the process of producing hundreds or thousands of personalized invoices from a single template and a billing spreadsheet. Instead of creating each invoice manually — typing client names, amounts, dates, and invoice numbers one by one — you upload your template once, connect your data, and generate every invoice in a single batch.

Mergram’s visual editor lets you drag data fields directly onto your invoice layout — client names, amounts, dates, payment QR codes, and barcodes. Each row in your spreadsheet produces a separate, professional invoice PDF ready to send.

One invoice template + one billing spreadsheet = hundreds of personalized invoices.

Who Uses This?

• Freelancers — Monthly invoices for multiple clients with different rates and terms
• Agencies — Batch client invoices with project-specific services and amounts
• Accounting firms — End-of-month billing documents for dozens of clients
• E-commerce businesses — Order confirmations, receipts, and packing slips
• SaaS companies — Recurring billing statements and renewal invoices
• Service providers — Consulting, legal, and creative services invoicing

How to Create Bulk Invoices

Step 1 — Design Your Invoice Template

Create your invoice layout in Canva, Microsoft Word, Google Docs, InDesign, or any tool that exports to PDF. Your template defines the static elements — your company logo, business name, address, payment terms boilerplate, and the overall layout structure.

Leave blank spaces where dynamic data will appear: client name and address, invoice number, dates, the line-item table, totals, and any per-invoice details.

Step 2 — Prepare Billing Data

Create a spreadsheet with one row per invoice. Common columns for billing:

Upload as Excel (.xlsx, .xls, .ods), CSV (.csv, .tsv), or connect a Google Sheet directly.

Step 3 — Map Fields to the Template

Upload your PDF template and spreadsheet to Mergram. The visual canvas editor displays your invoice layout. Drag column headers from the sidebar onto the canvas:

• Text fields — Place ClientName at the top, InvoiceNumber in the header, Total at the bottom. Set font, size, and alignment per field.
• Barcode fields — Map InvoiceNumber to a Code 128 barcode for tracking and scanning.
• QR code fields — Map PaymentLink to a QR code so clients can scan to pay.

Step 4 — Preview and Generate

Use the row selector to preview any invoice with real data — rendered directly in your browser, no server round-trip needed. Verify that amounts align, dates are correct, and QR codes are readable.

When you’re satisfied, generate your invoices:

• Individual PDFs — One file per client, packaged as a ZIP download
• Combined PDF — All invoices concatenated into one document (useful for internal records)
• Email delivery — Send each invoice as a personalized email attachment directly to clients

Real Line Items with a Repeat Block

Invoices rarely have the same number of lines. Instead of a fixed set of Item1, Item2, … columns, keep one row per line item and let a repeat block lay them out:

1. Open the Repeat Block tab in the editor sidebar, click Add repeat block, and size it over the line-item table.
2. Drag Description, Qty, and Amount into the first slot. The other slots preview how lines will fill.
3. Under One PDF per, choose InvoiceNumber.
4. Under Totals, choose Amount, drag Sum below the table, and set it to show on the last page.

Each invoice number becomes one PDF with all of its lines. Long invoices continue onto extra pages automatically, and you can show fields like the payment terms only on the last page. Billing is one credit per invoice PDF.

Email Delivery for Invoices

Skip the download-and-attach workflow. Connect your SMTP server and Mergram sends each invoice directly to the client:

1. Configure SMTP — Connect Gmail, SendGrid, Mailgun, Amazon SES, or any SMTP provider
2. Compose the email body — Use rich text with merge field placeholders: Dear [[ClientName]], please find your invoice [[InvoiceNumber]] attached. Payment of [[Total]] is due by [[DueDate]].
3. Generate and send — Mergram creates each invoice PDF and emails it as an attachment in one operation

Every send is tracked — see delivery status, opens, and bounces per recipient.

Payment QR Codes

Make it easy for clients to pay by adding a scannable QR code to each invoice:

• Add a PaymentLink column to your spreadsheet with the payment URL for each invoice
• Place a QR code field on the template and map it to that column
• Clients scan the QR code with their phone to open the payment page directly

QR codes are generated at high resolution and embedded as PNG images — sharp and readable even when printed.

You can also use QR codes for:

• Payment confirmations — Link to a payment portal
• Invoice details — Link to an online version of the invoice
• Support — Link to a support or contact page

Invoice Tracking with Barcodes

Add machine-readable barcodes to invoices for internal processing and scanning:

Map any spreadsheet column to a barcode field. Barcodes scale to cover the field bounding box width and are embedded directly in the PDF — no images to manage.

Best Practices

1. Standardize your spreadsheet columns — Use consistent column names across billing cycles so you can reuse the same template without re-mapping fields.
2. Preview the longest values — Check that the longest client name, description, and amount fit within their fields without overlapping or clipping.
3. Use filename templates — Set Invoice_[[InvoiceNumber]]_[[ClientName]].pdf for organized, searchable output files.
4. Test with a small batch first — Generate 3–5 invoices, verify formatting and email delivery, then run the full batch.
5. Save your template — After mapping all fields, save the template. Next billing cycle, just upload updated data and re-merge.
6. Connect Google Sheets for recurring billing — Use a live Google Sheet so you can update client data and re-merge without re-uploading files.

Get Started

Generate your first batch of invoices in under 10 minutes. Upload a PDF invoice template, connect a billing spreadsheet, map your fields, and generate — no accounting software integration required.

What you need:

• A PDF invoice template — designed in Canva, Word, Google Docs, or any tool that exports to PDF
• A billing spreadsheet — Excel, CSV, or Google Sheets with one row per invoice
• A free Mergram account — sign up at mergram.com/try

No credit card required. Start with your first batch for free.