How Per-Pay-Period Deductions Are Calculated in the Payroll Deduction Report

Purpose

The Payroll Deduction Report tells you how much to deduct from each enrolled employee per paycheck for their benefits. For tax-saving products such as an HSA or FSA, the amount is not simply the annual election divided by the number of paychecks in a year. UZIO divides the amount still owed by the paychecks still to come, and it counts the paychecks left using the cutoff dates in your payroll calendar. This article explains that calculation, the enrollment events that change it, and why the report's YTD tab can differ from its main tab.

This is a benefits report. It is driven by enrollments and your payroll calendar, not by pay runs, and you use it whether or not you process payroll in UZIO. You find it under Reports, and it can be downloaded on demand or set to run on a schedule (see Running and Scheduling Standard Reports).

Who needs this: anyone reconciling the Payroll Deduction Report against what they expected to see, typically the benefits or payroll administrator.

Prerequisite: a complete payroll calendar

The calculation depends on a complete payroll calendar. Complete means paycheck dates and cutoff dates for the whole benefit period, for every pay frequency in your census. The first cutoff date must fall after the earliest benefit effective date. An incomplete calendar makes UZIO fall back to the default paycheck count for the frequency, and the numbers stop matching your payroll.

The core rule: expired cutoff dates

Every change (a new enrollment, a Life Status Change) is assigned to the next cutoff date after it happens.

Remaining paychecks = paychecks in the plan year minus the cutoff dates that have already passed.

Worked example. Bi-weekly frequency, 26 checks, plan year starting January 1, first pay date January 19 with a cutoff of January 11.

Scenarios

Enrollment at plan start. $1,000 annual HSA election, weekly pay (52 checks): $1,000 ÷ 52 = $19.23 per paycheck.

Mid-year new hire. Hired May 1, elects $1,000, weekly pay, 34 paychecks left in the plan year: $1,000 ÷ 34 = $29.42.

Election increased by a Life Status Change (LSC). $2,400 annual, bi-weekly (26 checks), so $92.31 per check at first. In mid-June an LSC raises the election to $3,000 with 14 checks left. Already deducted: $92.31 × 12 = $1,107.72. Still owed: $3,000 − $1,107.72 = $1,892.28. New per-check amount: $1,892.28 ÷ 14 = $135.16.

Retroactive LSC. Same arithmetic, but the new amount starts from the current date, not from the retroactive event date. UZIO does not catch up missed retroactive deductions through the per-check amount.

LSC after the plan year's last cutoff. The remaining amount (new election minus old election) is shown as a single amount, effective from the day after the last cutoff to the plan year end.

Off-cycle plan year (for example April 1 to March 31). Everything runs on the plan year, not the calendar year.

Non-default paycheck count. If your payroll calendar saves a different number of paychecks (for example 24 for a bi-weekly group), the saved count drives every calculation for that calendar.

Why the YTD Deduction Report tab can differ

The YTD Deduction Report tab estimates year-to-date deductions from the same expired cutoff dates. Use it to work out final adjustment amounts for payroll.

For non-tax-saving benefits (Medical, Dental, Vision, Voluntary Life/AD&D, Voluntary Supplemental) the main Payroll Deductions tab does not use your payroll calendar. It uses the default paycheck counts: Weekly 52, Bi-Weekly 26, Semi-Monthly 24, Monthly 12. If your calendar's paycheck count differs from the default, the two tabs will not match for those benefits.

Rules and edge cases

• Tax-saving calculations follow the plan year of that specific benefit.
• After an enrollment reset, a mid-year proposal edit, or with an incomplete calendar, UZIO falls back to the default paycheck count for the group's frequency.
• If an LSC reduces an election so far that the per-check amount would be negative, the report shows $0.
• A future-effective LSC applies from its effective date.
• If the final paycheck falls in the next plan year, the calculation stops at the plan year end date.
• No proration is applied. Employer contributions are never affected. Commuter plans are excluded.

When a number looks wrong, check these first

1. Is the payroll calendar complete for that employee's pay frequency, with cutoff dates covering the whole plan year?
2. Did the employee have an LSC or a mid-year hire date? Count the cutoff dates that had passed at that point.
3. Is the benefit tax-saving (calendar-driven) or not (default counts)?
4. Was the calendar saved with a non-default paycheck count?
5. Has the plan been reset or the proposal edited mid-year?

Still stuck?

If a deduction is still unexplained after those checks, please reach out to us at support@uzio.com or call +1-571-601-1752. Send the employee's name or ID, the benefit and plan year, the annual election, the pay frequency, the date of any LSC or hire, the amount the report shows and the amount you expected.

Related articles

• FAQ: When Is My Payroll Calendar "Complete"?
• Understanding and Setting Up Pay Groups
• Managing Life Status Changes
• Running and Scheduling Standard Reports