PDF Mail Merge for Pay Stubs

What Is Pay Stub Mail Merge?

Pay stub mail merge is the process of producing personalized pay stubs for every employee in a single batch operation. Instead of creating each pay stub manually — copying employee names, earnings, taxes, and deductions one at a time — you upload a pay stub template once, connect your payroll spreadsheet, and generate all pay stubs in one run.

Mergram’s visual editor lets you drag data fields directly onto your pay stub layout — employee names, gross pay, tax breakdowns, deductions, net pay, and year-to-date totals. Each row in your spreadsheet produces a separate, professional pay stub PDF ready for distribution.

One pay stub template + one payroll spreadsheet = personalized pay stubs for your entire team.

Who Uses This?

• HR departments — Distribute pay stubs to all employees every pay period without manual effort
• Payroll companies — Produce pay stubs for multiple client companies in bulk
• Small businesses — Generate professional pay stubs without expensive payroll software
• Accountants and bookkeepers — Batch produce pay stubs for clients who process payroll in-house
• Staffing agencies — Create pay stubs for temporary and contract workers across different placements
• Nonprofits and churches — Issue pay stubs for part-time staff, stipends, and honorariums

How to Create Bulk Pay Stubs

Step 1 — Design Your Pay Stub

Create your pay stub 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, and the overall layout structure. Leave blank spaces where dynamic data will appear.

A well-structured pay stub template typically includes these sections:

Step 2 — Prepare Payroll Data

Create a spreadsheet with one row per employee. Include every data point that appears on the pay stub. Here is a typical column structure:

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 pay stub layout. Drag column headers from the sidebar onto the canvas:

• Text fields — Place EmployeeName at the top, NetPay prominently at the bottom, GrossPay and TotalDeductions in the summary area. Set font, size, and alignment per field to match your pay stub design.
• Barcode fields — Map EmployeeID to a Code 128 barcode for scanning and tracking purposes. Useful for filing systems and HR document management.
• QR code fields — Map a column with a payroll portal URL so employees can scan to view their pay history online.

Step 4 — Preview and Generate

Use the row selector to preview any employee’s pay stub with real data — rendered directly in your browser, no server round-trip needed. Verify that dollar amounts align, dates are correct, and all earnings and deductions are accounted for.

When you are satisfied, generate your pay stubs:

• Individual PDFs — One file per employee, packaged as a ZIP download for easy distribution
• Combined PDF — All pay stubs concatenated into one document (useful for internal records and audits)
• Email delivery — Send each pay stub as a personalized email attachment directly to employees with password protection

Password Protection

Pay stubs contain sensitive financial and personal information — earnings, tax withholdings, Social Security contributions, and retirement contributions. Always password-protect pay stubs before distributing them.

Mergram encrypts each pay stub PDF using 128-bit encryption. Set a password template based on your spreadsheet data:

Email Delivery

Skip the download-and-forward workflow. Connect your SMTP server and Mergram sends each pay stub directly to the employee:

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 [[EmployeeName]],
   
   Your pay stub for the period [[PayPeriodStart]] – [[PayPeriodEnd]]
   is attached. Your net pay is [[NetPay]].
   
   This document is password-protected for your security.
   
   Regards,
   Payroll Team

3. Generate and send — Mergram creates each pay stub PDF, encrypts it, and emails it as an attachment in one operation

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

Best Practices

1. Always password-protect pay stubs — Pay stubs contain sensitive personal and financial data. Use a password template based on information only the employee knows, such as [[EmployeeID]] or [[SSN_Last4]].
2. Standardize your spreadsheet columns — Use consistent column names across pay periods so you can reuse the same template without re-mapping fields every cycle.
3. Preview the largest values — Check that the longest employee name, the highest dollar amounts, and the widest deduction descriptions fit within their fields without overlapping or clipping.
4. Include year-to-date totals — Employees and auditors expect YTD figures on pay stubs. Add YTD columns to your spreadsheet and place them as separate fields on the template.
5. Test with a small batch first — Generate 3–5 pay stubs, verify formatting, amounts, and email delivery, then run the full batch.
6. Save your template — After mapping all fields, save the template. Next pay period, just upload the updated spreadsheet and re-merge. No re-mapping needed.

Get Started

Generate your first batch of pay stubs in under 10 minutes. Upload a PDF pay stub template, connect your payroll spreadsheet, map your fields, and generate — no payroll software integration required.

What you need:

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

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