How this QSEHRA budget planner works
This page helps small employers estimate the cash budget needed to support a Qualified Small Employer Health Reimbursement Arrangement (QSEHRA).
You enter your eligible headcount by coverage tier, the monthly allowance amounts you plan to offer, and an expected utilization rate (how much of the allowance employees typically claim).
The calculator then produces (1) a 12‑month forecast with inflation applied gradually through the year, (2) a summary of annual reimbursements and admin costs, and (3) a payroll comparison showing what it would cost to deliver the same dollars as taxable wages.
Who this is for (and what it is not)
This is a budgeting and scenario tool for owners, finance teams, and HR leaders who want a quick, consistent estimate.
It is not legal or tax advice and it does not determine eligibility, substantiation rules, or whether your allowance design complies with current IRS limits.
Use it to plan cash flow and to compare benefit strategies, then confirm compliance details with your benefits administrator or advisor.
- Eligible employees with single coverage and family coverage: the number of employees you expect to be eligible and participating in each tier.
- Monthly allowance (single/family): the maximum monthly amount you are willing to reimburse per employee in that tier.
- Expected reimbursement utilization: the percent of the allowance pool you expect to be claimed (e.g., 70–95% depending on plan design and employee behavior).
- Employer payroll tax rate: the employer-side payroll tax rate used for the wage comparison (often 7.65% for FICA, but your situation may differ).
- Administrative cost per month: a flat monthly cost for administration (TPA fees, platform fees, or internal time you want to budget).
- Annual medical trend / premium inflation: an annual percentage used to gently increase reimbursements across the year (compounded in the forecast).
The model starts with a monthly allowance pool and then scales it by utilization. In symbols:
Base monthly allowance pool = (Nsingle × Asingle) + (Nfamily × Afamily)
Expected monthly reimbursements = Base pool × (Utilization ÷ 100) × InflationMultiplier
Total monthly cost = Expected monthly reimbursements + Admin fee
Payroll-equivalent annual cost = Annual reimbursements × (1 + PayrollTaxRate)
The forecast applies inflation gradually using compound growth across the year (month 0 through month 11). This is a simplification; real premium changes can occur at renewal dates.
Worked example (matches the default inputs)
Suppose you have 8 single employees and 4 family employees. You offer $420/month for single and $860/month for family.
Your expected utilization is 82%, admin cost is $120/month, and you assume 5% annual inflation.
-
Base monthly allowance pool = (8 × 420) + (4 × 860) = 3,360 + 3,440 = $6,800
-
Expected reimbursements (before inflation) = 6,800 × 0.82 = $5,576 per month
-
Add admin fees: 5,576 + 120 = $5,696 for the first month (inflation then nudges later months upward)
After you click Project Budget, the forecast table shows each month’s reimbursements, admin fees, total cost, and cumulative cost.
The scenarios table then shows how annual reimbursements change if utilization is 10 points lower or higher than your assumption.
Limitations and assumptions
- Budgeting model: results are estimates for planning and do not guarantee actual claims behavior.
- No statutory cap enforcement: the calculator does not automatically enforce IRS annual QSEHRA limits; confirm your allowance design separately.
- Utilization is an average: real reimbursements can be lumpy (e.g., year-end receipt submissions).
- Inflation smoothing: inflation is applied gradually; real premium changes may occur at specific renewal dates.
- Payroll comparison scope: the wage comparison uses the employer payroll tax rate you enter and does not model income taxes or other benefit interactions.
Practical tips for better budgeting
If you are unsure about utilization, run three scenarios: conservative, expected, and stretch. Then compare the annual totals to your cash flow.
If you have seasonal hiring or expected turnover, consider re-running the calculator quarterly with updated headcounts.
Finally, keep admin fees realistic—many vendors price per employee per month, while internal administration can vary with claims volume.
Planning notes: what to check before you rely on the numbers
A QSEHRA forecast is most useful when it matches how your organization actually operates. Before you treat the output as a budget target,
confirm a few practical details. First, verify whether your allowances are intended to be calendar-year amounts or whether you plan
to start midyear. This calculator shows a 12‑month projection; if you start in April, you can still use it by interpreting the results as a
rolling 12‑month view and adjusting your internal budget period accordingly.
Second, decide whether your administrative cost is truly a flat monthly fee. Some administrators charge per employee per month,
which means admin spend grows with headcount. If your vendor charges per participant, you can approximate that by increasing the admin cost input
to reflect your expected average monthly fee. Third, consider whether your workforce mix changes during the year. If you expect hiring, layoffs,
or a shift from single to family coverage, run multiple scenarios and save the CSV outputs so you can compare them side by side.
How to interpret the forecast and scenarios
The forecast table is designed for cash planning. “Reimbursements” represent the expected amount employees will claim after applying
utilization and inflation. “Admin fees” are added on top. “Total monthly cost” is the amount you would plan to fund for that month, and
“Cumulative cost” is a running total that can be compared to your year-to-date ledger.
The utilization scenarios table is designed for sensitivity analysis. It holds headcount and allowances constant and changes only the
utilization percentage. If the conservative and stretch scenarios are far apart, that is a signal that utilization is a key uncertainty.
In that case, you may want to track claims monthly and update the utilization assumption as you gather real data.
Common input mistakes (and quick fixes)
- Mixing monthly and annual amounts: the allowance inputs are monthly. If you have an annual allowance, divide by 12 before entering it.
- Entering utilization as a decimal: enter 82 for 82%, not 0.82. The calculator converts the percentage internally.
- Forgetting admin fees: if you pay a platform fee, include it so the total cost reflects real cash outlay.
- Overstating payroll tax rate: the payroll comparison is only as accurate as the rate you enter. Use your employer-side rate for the wage comparison.
- Assuming inflation is a guarantee: inflation is a planning assumption. If your premiums renew once per year, actual changes may be stepwise rather than smooth.
Mini case study: budgeting for growth and midyear changes
Consider a small software consultancy that expects to grow from 10 to 14 employees over the next year. Today it has 7 single and 3 family
participants, but it expects two new hires to enroll with family coverage. A practical way to use this calculator is to run two forecasts:
one with today’s headcount and one with the expected average headcount for the year. The difference between the two totals is a rough estimate
of the additional cash you should reserve for growth.
You can also use the utilization scenarios to set a contingency buffer. For example, if your expected utilization is 80% but the stretch scenario
at 90% increases annual reimbursements by $12,000, you might decide to hold a $12,000 reserve or to set internal thresholds for reviewing the
allowance design midyear. The goal is not to predict the future perfectly; it is to make the tradeoffs visible so you can choose a benefit level
that is sustainable.
Compliance reminder (plain language)
QSEHRAs are governed by federal rules and require proper plan documentation, employee notices, and substantiation of expenses.
This calculator does not check eligibility rules, does not validate whether an expense is reimbursable, and does not enforce annual statutory caps.
Treat the output as a budgeting estimate and confirm plan design details with current IRS guidance and your administrator.
Background: why model Qualified Small Employer HRAs?
Qualified Small Employer Health Reimbursement Arrangements (QSEHRAs) let companies with fewer than fifty full‑time workers reimburse employees for eligible individual health insurance premiums and medical expenses on a tax‑free basis (when structured and administered correctly).
Many small employers like QSEHRAs because they can set a defined monthly allowance rather than committing to a group plan premium.
From a budgeting perspective, the key question is not only “What is the allowance?” but “What will we actually reimburse?”—because employees may not claim 100% of the available amount every month.
This planner focuses on the drivers that typically matter most for cash planning: headcount by tier, allowance levels, utilization, admin fees, and a simple inflation assumption.
It also includes a payroll comparison because reimbursements are generally not subject to employer payroll taxes, while wages are.
That comparison helps you estimate the additional employer cost you would incur if you tried to deliver the same after‑tax benefit value through taxable compensation.
If you want to use the output in a broader budget, export the CSV and paste it into your cash flow model.
The month‑by‑month view is especially useful when you want to set aside funds, evaluate affordability, or communicate expected spend to leadership.
Additional FAQs for employers
The questions below address common budgeting concerns that come up when teams move from “Should we offer a QSEHRA?” to “How do we fund it responsibly?”
They are written for planning purposes and are not a substitute for plan documents or professional advice.
- Should I budget at 100% utilization?
-
Budgeting at 100% is the most conservative approach, but it can overstate expected cash outlay if employees typically claim less than the full allowance.
Many employers start with a utilization estimate based on prior premium costs, then adjust after a few months of real claims data.
- Why does the forecast change month to month if headcount is constant?
-
The month-to-month change comes from the inflation input. The calculator applies inflation gradually (compounded) across the year to approximate rising premiums.
If you prefer a flat forecast, set inflation to 0%.
- What does “equivalent taxable payroll cost” mean?
-
It is a comparison number: if you paid the same dollars as wages instead of reimbursements, you would also pay employer payroll taxes.
The calculator adds your payroll tax rate to the reimbursement total to estimate that higher wage-based cost.
- How should I use the CSV download?
-
Use the CSV as documentation of assumptions and as an input to a larger budget model. For example, you can paste the monthly totals into a cash flow worksheet,
compare multiple scenarios, or share the forecast with an accountant or leadership team.
