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 line items 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, line items, amounts, 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

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/new

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