1095-C Reporting Without the Spreadsheet: What Employers Still Do by Hand

Every January, someone at your company opens a spreadsheet and starts filling in months.

That’s how 1095-C reporting works at a lot of businesses, including plenty that already pay a provider to handle it. The forms get filed on time. The question is how much manual work happens before they do, and whether the numbers going in were ever verified by anything other than a person’s memory.

Last updated: September 2026

Your payroll system files W-2s. It may not file 1095-Cs

A private school with about 128 active staff found this out the hard way. Their accounting software handles payroll and files W-2s without complaint, but it doesn’t produce 1095-Cs at all. So the HR coordinator pays a separate filing service directly, then populates that service’s spreadsheets, pulling over all twelve months for every employee by hand. Two years running.

The assumption that trips people up is reasonable enough. Year-end filing feels like one category. It isn’t. W-2 filing and ACA filing are usually separate products, sometimes from separate vendors, often at a separate price. Nobody tells you that until the first January.

Paying for ACA support and building the spreadsheet anyway

Here’s the version that frustrates people more. A wholesale distributor with roughly 50 employees pays an add-on fee for ACA support on top of their base payroll cost. The provider still requires them to supply a spreadsheet listing the minimum employee cost for coverage. Their accounting manager’s assessment was blunt: it’s aggravating to pay for something and still have that much involvement, especially when the add-on isn’t cheap.

Same company, related problem. Benefit eligibility dates live on one person’s calendar. Not a system, a calendar. If she’s out, nobody knows who just became eligible.

Eligibility trending is where 1095-C reporting actually breaks

Filing the form is the easy part. Knowing what belongs on it is not.

A multi-location restaurant group runs payroll in one platform and benefits administration in another. Each cycle, their HR lead reviews how employees are trending toward the hours threshold, pushes anyone who has crossed from ineligible to eligible, then opens the second system and changes that same person’s status there too. Her description of it was simple: it is not an automatic thing, it is very manual.

That’s the real exposure. A 1095-C is a month-by-month record of what you offered and when. If the month someone became eligible was tracked by hand in two places, the form is only as accurate as whoever was watching, and penalties under the employer mandate attach to the months you got wrong.

The populations nobody plans for

Standard ACA setups assume a stable roster of employees. Real ones rarely look like that.

• Board directors and other non-employees. A community bank with twelve staff needed 1095-C handling for its directors, a group that never appears on a normal payroll register.
• Substitutes and seasonal staff. That same private school issues 256 W-2s a year against 128 active employees, thanks to substitutes, summer camp workers and contractors. Every one of them affects the full-time equivalent count.
• Employees enrolled outside payroll. A recreation organization enrolls people manually through a broker portal but still needs the ACA report generated from payroll data, which means the two have to reconcile.

Per the IRS guidance on applicable large employer status, the 50 full-time-equivalent threshold counts part-time hours in aggregate. Seasonal spikes are exactly where employers miscount, and the count determines whether you owe the filing at all.

What removes the spreadsheet from 1095-C reporting

• Hours of service measured from the time data you already collect, rather than from a separate report someone exports and interprets
• Eligibility status that changes on its own when an employee crosses the measurement threshold, with the specific month recorded automatically
• One record of what coverage was offered, so benefits administration and payroll aren’t each holding half the answer
• Affordability calculated from actual employee contributions, not from a minimum-cost figure typed into a vendor’s template once a year
• Direct filing of both the 1094-C and the 1095-C, without a second vendor and a second data entry pass
• A way to handle non-employee populations such as directors or retirees who still need a form

The filing isn’t the work. The tracking is

None of the businesses above struggled to submit a form. They struggled because the data the form needs was scattered across a payroll platform, a broker portal, a personal calendar and a vendor’s spreadsheet, and somebody had to reconcile all four before January.

When benefits administration and payroll and tax share one employee record, eligibility tracking stops being a monthly chore and becomes a byproduct of running payroll. The hours are already there. The contributions are already there. Pairing that with time and attendance data from the same system is what turns 1095-C reporting from an annual reconstruction project into a report you run.

Frequently Asked Questions

This guide reflects publicly available product information and independent reviewer data (G2, Capterra, Trustpilot, Yelp, Better Business Bureau, Reddit, Software Advice, GetApp) as of 2026. Feature availability and pricing may vary by plan. Contact each provider for current details.

Disclaimer: Any product roadmap or future plans provided herein are for informational purposes only. They do not represent a commitment to deliver any material, code, feature, or functionality. Plans may change without notification. The development, release and timing of any features or functionality described remain at the sole discretion of Netchex, its affiliates, and partners. Netchex does not give legal, tax, or accounting advice. You are responsible for ensuring your use of Netchex product meets your individual business and compliance requirements.

Print this page