How to Create Bulk Pay Stubs

Creating Bulk Pay Stubs from a Spreadsheet

Processing payroll means generating a pay stub for every employee each pay period — weekly, biweekly, or monthly. Doing this manually is slow and error-prone when your team grows beyond a handful of people. With Mergram, you upload a pay stub PDF template and a spreadsheet of payroll data, map the fields once, and generate every employee’s pay stub in a single operation. Each stub is personalized with that employee’s earnings, deductions, taxes, and net pay.

Prerequisites

Before you start, make sure you have:

• A pay stub PDF template — a designed pay stub layout saved as PDF, with blank areas for variable data
• An Excel or CSV file with your payroll data organized in columns and rows
• A Mergram account with credits for the number of pay stubs you need

Preparing Your Payroll Data

Organize your spreadsheet with one row per employee per pay period. Here is a recommended column structure:

Designing Your Pay Stub Template

Layout Structure

A well-designed pay stub typically includes these sections:

Placing Fields on the Canvas

For each column in your spreadsheet, drag it onto the canvas in the corresponding position:

1. Employee name and ID — Place in the employee info section, top-left of the stub
2. Pay period dates — Place PayPeriodStart and PayPeriodEnd next to each other in the header area
3. Gross pay — Place in the earnings section as the first and most prominent earnings field
4. Tax deductions — Place FederalTax, StateTax, SocialSecurity, and Medicare in the deductions column
5. Voluntary deductions — Place HealthInsurance, Retirement401k, and OtherDeductions below the tax deductions
6. Net pay — Place in a highlighted area with larger font — this is the most important number on the stub
7. Year-to-date totals — Place YTDGross and YTDNet in a separate row at the bottom

Adjust font sizes to match your template design — net pay should stand out clearly, while individual deduction line items can use a smaller, consistent size.

Custom Filename Templates

Use filename templates to keep your generated pay stubs organized by employee and pay period:

Consistent filenames make it easy to locate specific pay stubs in your archive, whether you store them in a shared drive, upload to payroll software, or email them to employees.

Password Protection for Pay Stubs

Pay stubs contain sensitive financial information — Social Security numbers, salary details, and banking information. Password protection is strongly recommended.

Set a password template in the merge dialog using merge fields that only the employee would know:

To use a custom field like SSN_Last4, add a column to your spreadsheet containing the last four digits of each employee’s SSN. Mergram uses that value as the password for that employee’s pay stub.

Sending Pay Stubs via Email Campaigns

Combine bulk pay stub generation with email delivery to send pay stubs directly to employees:

1. Set up SMTP — Configure your email provider in Settings → SMTP (Gmail, SendGrid, Mailgun, or any SMTP provider)
2. Map employee email — Ensure your spreadsheet has an EmployeeEmail column with each employee’s email address
3. Design email template — Use merge fields for personalization so each employee sees their own name and pay period
4. Attach pay stubs — Mergram automatically attaches each employee’s generated pay stub PDF to their individual email
5. Run the campaign — Review a preview, then send — each employee receives their own pay stub as a password-protected PDF attachment

Sample email template:

Subject: Your Pay Stub for [[PayPeriodStart]] – [[PayPeriodEnd]]

Hi [[EmployeeName]],

Your pay stub for the pay period of [[PayPeriodStart]] through [[PayPeriodEnd]] is attached.

The password to open your pay stub is your employee ID ([[EmployeeID]]).

If you have questions about your pay stub, please contact HR.

Best regards,
Payroll Team

Best Practices for Pay Stub Generation

1. Verify payroll calculations before merging — Double-check gross pay, all deductions, and net pay in your spreadsheet. A formula error propagates to every generated pay stub.
2. Standardize date formats — Use a consistent format like YYYY-MM-DD across all pay period columns to avoid confusion.
3. Include year-to-date totals — Employees and auditors expect YTD figures on every stub. Add YTDGross and YTDNet columns to your spreadsheet.
4. Test with 2–3 employees first — Generate a small batch, open the PDFs, and verify that every field is correctly placed and amounts match before running the full payroll.
5. Always password-protect — Pay stubs contain PII and salary data. Use a password template so only the intended employee can open their stub.
6. Archive each pay run — Download the generated pay stubs after each payroll cycle and store them in a secure, organized folder for compliance and audit purposes.

Common Issues and Troubleshooting

Currency symbols not rendering correctly: Ensure your spreadsheet cells are formatted as text or use consistent currency formatting. If the PDF displays unexpected characters, try using plain numbers without currency symbols and add the $ symbol as static text on the template.

Deductions with zero values showing blank: If an employee has no optional deductions (e.g., OtherDeductions is $0.00), the field may look empty. You can either place a static $0.00 label on the template or ensure your spreadsheet always contains a value — even zero — so the field renders consistently.

Employee names with special characters: Names containing accents (e.g., “José Martínez”), hyphens (e.g., “Mary-Jane Wilson”), or non-Latin characters (e.g., “Li Wei 李伟”) are fully supported. Ensure your CSV file is saved with UTF-8 encoding if exporting from Excel.

Pay stubs exceeding one page: If your template has many deduction categories, the layout may overflow. Reduce font sizes for deduction line items, or design your template with a compact two-column layout for earnings and deductions side by side.

Get Started

Upload your pay stub template and payroll spreadsheet to the Mergram editor. Map employee fields onto the canvas, preview with real data, enable password protection, and generate your entire batch of pay stubs in one click.