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