Pay Stub Template

Pay Stub Template for Mail Merge

A professional pay stub template designed for bulk generation with Mergram. Upload your pay stub PDF, connect your payroll spreadsheet, and generate personalized pay stubs for your entire team in a single batch. Each pay stub displays earnings, itemized deductions, tax withholdings, and net pay — all pulled directly from your data. Whether you run payroll weekly, biweekly, or monthly, this template removes the tedious work of producing individual pay stubs one at a time.

Pay stubs are an essential part of payroll compliance. Employees rely on them to verify compensation, understand deductions, and maintain personal financial records. Providing clear, accurate, and professionally formatted pay stubs builds trust and reduces payroll inquiries.

When to Use This Template

This pay stub template is ideal whenever you need to produce a high volume of pay stubs that share the same layout but contain different employee and payroll data. Common scenarios include:

• Regular payroll processing — Generate pay stubs for all employees after each pay run, with earnings, taxes, and deductions specific to each person
• Contractor payments — Produce payment statements for independent contractors showing gross compensation and any applicable withholdings
• Commission statements — Create detailed pay stubs that break down base pay, commissions, bonuses, and adjustments for sales teams
• Freelance payment records — Issue payment advices for freelance or gig workers with project-level earning details
• Year-end reconciliation — Generate final pay stubs of the fiscal year with complete year-to-date totals for each employee

If you currently export pay stubs one by one from your payroll system or manually fill in PDF templates, this workflow will save you significant time each pay cycle.

Template Fields

Field Mapping Guide

Field mapping connects each column in your payroll spreadsheet to a specific position on the pay stub PDF. Here is how to set it up:

1. Prepare your spreadsheet — Each row represents one employee’s pay stub for the current pay period. Column headers should match the field names above (e.g., employee_name, gross_pay, net_pay). Mergram’s fuzzy matching will suggest the closest field if your headers differ from the standard names.
2. Place fields on the canvas — Drag each field from the sidebar onto the PDF at the exact position where the data should appear. Group related fields logically: employee information at the top, earnings in the upper section, deductions in the middle, and net pay prominently at the bottom.
3. Choose render types — Most fields use plain text. Use the QR code type for employee portal links or direct deposit confirmation URLs. Use the barcode type for check numbers or employee IDs if your system scans pay stubs for record-keeping.
4. Preview before merging — Click Preview to see a rendered pay stub using your first row of data. Verify that dollar amounts align properly, deduction labels match your template, and year-to-date totals are positioned correctly.

Customization Tips

The visual appearance of your pay stubs is entirely controlled by your PDF template. Mergram overlays dynamic data onto the PDF without altering the underlying design:

• Add your company logo — Include your company logo in the PDF template before uploading. Position it in the header area for a professional, branded look
• Custom fonts — Upload .ttf, .otf, or .woff2 fonts to match your corporate branding. Apply them to any text field on the canvas for consistent typography across all pay stubs
• Password protection — Pay stubs contain sensitive financial data. Use the password template feature with patterns like [[employee_id]] to encrypt each pay stub with a unique, employee-specific password. This ensures only the intended recipient can open the file
• Custom filename templates — Auto-name output files using patterns like paystub-[[employee_name]]-[[pay_period_end]].pdf so files are organized by employee and pay period without manual renaming
• QR codes for pay portals — Place a QR code field linked to a column of employee self-service portal URLs. Each pay stub gets a unique, scannable code that directs employees to their online payroll dashboard
• Multi-page pay stubs — For detailed breakdowns that span more than one page (e.g., multiple earning categories, itemized benefits), Mergram supports field placement on any page of the PDF

Best Practices

• Pre-calculate in your spreadsheet — Use spreadsheet formulas for gross pay, all tax withholdings, deduction totals, and net pay. Mergram places the final computed values onto the PDF, so your spreadsheet is the single source of truth for all dollar amounts
• Encrypt pay stubs with unique passwords — Financial documents deserve strong protection. Use the [[employee_id]] merge field in your password template so each employee’s pay stub is locked with a personal identifier they already know
• Standardize date formatting — Format pay period dates as text (e.g., January 15, 2025) in your spreadsheet to ensure they render consistently on every pay stub
• Include year-to-date totals — Always add ytd_gross and ytd_net fields. Employees expect to see running totals on each pay stub for tax planning and personal budgeting
• Test with a small batch first — Generate 3–5 pay stubs and review alignment, amounts, and formatting before running a full batch for your entire team
• Use email delivery for direct deposit — Configure SMTP settings and email each pay stub as an encrypted PDF attachment. Use the [[employee_name]] merge tag in the email subject line for personalized delivery

Get Started

Upload any pay stub PDF and start merging at Mergram. Connect your payroll spreadsheet, place your fields, and generate your first batch of professional pay stubs in minutes.