P.A.Y.
Skip to content
P.A.Y.Payroll All Year

Free downloads · Excel templates

Free payroll and HR Excel templates

Eight Excel workbooks with working formulas, each built to go with a P.A.Y. guide. Every one opens on an Instructions sheet with the rules it applies and links to the official sources. Free with a P.A.Y. profile.

Written by Robert Hartigos, 20+ years in payroll, HRIS and benefits · Last reviewed November 15, 2026

See the templatesHow downloads work

Free profile

Download with your free profile

Reading this page is open to everyone. Downloads need a free P.A.Y. profile. Once you are signed in, a download button appears on every template below.

Checking your free profile. If nothing changes, open or create your free P.A.Y. profile.

Eight workbooks

The templates

Each card says what the workbook does, the rules it applies and the guide it goes with.

Excel workbook

Leave tracker with payroll handoff

Track each leave case, its notice due dates and the FMLA hours used in a rolling 12 months. Then hand payroll the leave hours by employee, pay code and pay period.

Sheets: Instructions, Cases, Weekly hours, Payroll handoff, Flags, Settings, Lists

Rules built in: Eligibility and designation notices are due within five business days, and WORKDAY counts them for you. FMLA gives 12 workweeks in a 12-month period, measured here backward from the as-of date. Sources: 29 CFR 825.300, Employer notice requirements (eCFR), Fact Sheet #28D: Employer Notification Requirements (DOL WHD), 29 CFR 825.200, Amount of leave (eCFR).

Goes with: Leave tracker and payroll handoff, How FMLA works, Leave and payroll, FMLA balance calculator

Free with a P.A.Y. profile. Sign in above to download.

Excel workbook

New York PFL and DBL benefit worksheet

Estimate the weekly New York Paid Family Leave benefit from the last eight weeks of wages. It also estimates the weekly Disability Benefits amount from the higher of two eight-week windows.

Sheets: Instructions, PFL benefit, DBL benefit, Rates

Rules built in: PFL pays 67 percent of the average weekly wage, capped at $1,228.53 a week in 2026. DBL pays 50 percent, up to $170 a week. Example: $9,000 over eight weeks is a $1,125 average and a $753.75 weekly PFL benefit. Sources: N.Y. Workers' Compensation Law section 204 (NY Senate), New York Paid Family Leave Updates for 2026, What are Disability Benefits (NY Workers' Compensation Board), N.Y. Workers' Compensation Law section 201(13) (NY Senate).

Goes with: NY Paid Family Leave calculator, State paid family and medical leave

Free with a P.A.Y. profile. Sign in above to download.

Excel workbook

Severance tracker

Work out severance weeks from a per-year-of-service formula with a floor and cap. Then get the total, the release dates, a lump sum or salary continuation schedule and the COBRA subsidy.

Sheets: Instructions, Employees, Payment schedule, Summary, Lists

Rules built in: Workers 40 and older get at least 21 days to consider a release, or 45 in a group program, and 7 days to revoke. Severance is wages for Social Security, Medicare, income tax withholding and FUTA. Sources: 29 U.S.C. 626(f) (GovInfo), Q&A: Understanding Waivers of Discrimination Claims in Employee Severance Agreements (EEOC), Publication 15 (2026), (Circular E), Employer's Tax Guide (IRS).

Goes with: Severance tracker (online), Severance agreements, COBRA after a job ends

Free with a P.A.Y. profile. Sign in above to download.

Excel workbook

Tip pool and tips worksheet

Split a tip pool by hours, points or role percent in whole cents, so the payouts equal the pool exactly. Also handles card fees on individual tips and the weekly tip credit check.

Sheets: Instructions, Tip pool, Role percents, Individual tips, Tip credit check

Rules built in: Managers and supervisors may not keep employees' tips, so the sheet flags them. In California, card tips are paid in full with no card fee deduction. Sources: DOL WHD Fact Sheet #15: Tipped Employees Under the FLSA, California DIR: Excerpts from the Labor Code (Section 351).

Goes with: Tip payout calculator, Tips Desk

Free with a P.A.Y. profile. Sign in above to download.

Excel workbook

Interim and blended-rate overtime worksheet

Find the regular rate for a week with two jobs at different rates, shift differentials and nondiscretionary bonuses. Compare it with overtime at the job rate, and spread a bonus over several weeks.

Sheets: Instructions, Workweek, Job rate method, Bonus spread

Rules built in: The regular rate is the weighted average of all pay for the week, with differentials and nondiscretionary bonuses included. Example: 30 hours at $20, 15 at $24, a $15 differential and a $45 bonus give a $22.6667 regular rate and $1,076.67 in total. Sources: eCFR 29 CFR Part 778 Subpart B (778.109 and 778.115), eCFR 29 CFR Part 778 Subpart C, Extra Compensation Paid for Overtime (778.207), eCFR 29 CFR Part 778 Subpart C, Bonuses (778.208 to 778.211).

Goes with: Interim overtime calculator, Interim pay

Free with a P.A.Y. profile. Sign in above to download.

Excel workbook

401(k) paycheck planner

See every 2026 paycheck: the deferral, the paycheck where the limit is reached, the match by tier and the match lost without a true-up. Then project the balance with the final 2027 IRS limits and a return you choose. Use the online 401(k) calculator for a 2027 paycheck schedule.

Sheets: Instructions, Planner, Paychecks, Projection, Limits

Rules built in: The 2026 deferral limit is $24,500, plus $8,000 at age 50 or older, or $11,250 for ages 60 to 63. Example: $300,000 at 15 percent reaches the limit on September 18, 2026 and loses $3,230.93 of match without a true-up. Sources: Notice 2025-67, 2026 Amounts Relating to Retirement Plans and IRAs (IRS), Retirement topics: Catch-up contributions (IRS).

Goes with: 401(k) calculator, How a 401(k) is calculated

Free with a P.A.Y. profile. Sign in above to download.

Excel workbook

Mileage reimbursement log

Log business trips and reimburse each one at the IRS rate for its date. If your policy pays more, the sheet splits out the taxable excess for payroll.

Sheets: Instructions, Trips, Employees, Summary, Rates

Rules built in: The IRS business rate is 72.5 cents a mile for trips before July 1, 2026 and 76 cents from July 1, 2026. Any excess over the federal rate that is not substantiated is wages. Sources: IRS Notice 2026-10, 2026 Standard Mileage Rates, Internal Revenue Bulletin 2026-29 (Announcement 2026-11), IRS Publication 15 (2026), Employer's Tax Guide (section 5).

Goes with: Expense reimbursements

Free with a P.A.Y. profile. Sign in above to download.

Excel workbook

Record retention schedule

List the payroll and HR records you keep and get a keep-until date for each one from the right start point. Anything on legal hold stays on hold.

Sheets: Instructions, Records, Rules

Rules built in: Keep a Form I-9 for 3 years after hire or 1 year after employment ends, whichever is later. Keep OSHA logs 5 years after the end of the year they cover. Sources: 10.0 Retaining Form I-9 (Handbook for Employers M-274, USCIS), 29 CFR 1904.33, Retention and updating (OSHA).

Goes with: Record retention, Government reporting

Free with a P.A.Y. profile. Sign in above to download.

Step by step

How downloads work

  1. Sign in or create your free P.A.Y. profile in the box above.
  2. Pick a template and select its Download button. The file saves as an .xlsx workbook.
  3. Open it in Excel and start on the Instructions sheet. It explains each sheet and lists the rules with links.
  4. Type only in the yellow cells. The white cells hold the formulas.
  5. Look at the fictional example rows, then delete them and add your own.

The workbooks use standard Excel functions, such as SUMIFS, WORKDAY, EDATE and EOMONTH. Each one was recalculated in LibreOffice Calc to check that the example rows give the worked-example results.

Prefer to work online? Most templates have a matching calculator or guide, linked under Goes with on each card.

Frequently asked questions

Are the Excel templates free?

Yes. Every template is free with a free P.A.Y. profile. Sign in or create one, then come back here. The download buttons appear once your profile is active. See how to sign in.

Do the templates use macros?

No. They use standard formulas such as SUMIFS, WORKDAY and EDATE. Nothing runs when you open a file. Read the download steps before you start.

Where do the rules in the templates come from?

Every rule comes from an official source, such as the IRS, the Department of Labor or a state agency. Each workbook lists its rules on the Instructions sheet with links. They were checked on November 9, 2026. See the official sources.

Can I use the templates for 2027?

The 401(k) workbook shows a 2026 paycheck schedule and uses final 2027 IRS limits in its projection. For a 2027 paycheck schedule, use the online 401(k) calculator. Check current mileage rates before using the mileage workbook for 2027. Watch the payroll compliance calendar for new dates.

Related guides

Official sources

Each figure, date and rule on this page was checked on these official pages on November 9, 2026. Each workbook lists the full set on its Instructions sheet.

General information, not legal, tax or benefits advice. The templates are starting points. Check the official sources and your own plan, policy and state rules before you rely on a result.