Form 1095-C Import Spreadsheet | IRS TY2016

We know that ACA reporting can be cumbersome, so we’ve created a template for easy data import into Boomtax. We’ve outlined our Form 1095-C Import Spreadsheet Guidelines for using our Excel template below.

This format closely mirrors the 1095-C forms so your benefits/payroll provider may be able to provide the information required to populate the 1095-C import spreadsheet easily.

We have made a few changes to our template for Tax Year 2016 to help reduce some data entry for our customers please find linked below:

Download the BoomTax Excel Template

Changes for Tax Year 2016

To make importing your data into BoomTax even easier, we have made some updates to our TY2016 Form 1095-C Import Spreadsheet:

  • ‘Void’ and ‘Corrected’ field removed – we fill these out for you automatically when the data you import is changed.
  • ‘Number of Covered Individuals’ removed – we will calculate this based on the covered individuals provided in the spreadsheet.
  • ‘Is Self-Insured’ removed – we automatically check this box as ‘Yes’ if the spreadsheet shows any covered individuals for an employee.
  • ‘Plan Start Month’ now optional – we don’t include this column in our sheet since most customers don’t use it and since it remains optional for this year.
  • Added instructions for Part II Lines 14-16.

Entering Your Data into your 1095-C Import Spreadsheet

There are some key things to remember when completing your 1095-C import spreadsheet:

  • All columns in the 1095-C import spreadsheet must be present, although data is not required for every column. To see the required data, please see our ‘Required Columns’ section below.
  • The spreadsheet cannot have blank rows between employee records.
  • Employee last name and SSNs must match IRS records, or you will see TIN validation errors when you e-file.
  • Covered individual data is only required if the employee is enrolled in an employer self-funded plan. If the employee is not enrolled in an employer self-funded plan, then do not list covered individuals for this employee.
  • Numeric fields like #15 don’t have to include decimal points for whole numbers. (e.g. 3.00 can be 3)
  • SSNs can contain dashes or not, we’ll standardize it when it’s read in. (e.g. 123-45-6789 or 123456789 both work)
  • Plan start month is optional again for this year, but if you do provide a value it must be 1-12, which corresponds to the months of Jan-Dec.
  • Yes, true, or 1 are all acceptable for true/false type fields. (e.g. Covered all 12 months? Yes, true, or 1 all work here)
  • Zip codes are automatically read in as Zip+4 with or without a dash. (e.g. Zip code 784101234 or 78410-1234 will both work)

More in-depth validations are easier to find by simply submitting your data file. If you submit your data file and it breaks one of the IRS validations, we display which line had the issue along with a message to let you know what to fix. For example, a bad SSN would trigger an error like the following:

‘Line 3: Employee SSN must have exactly 9 digits’.

Required Columns

The following columns in our Form 1095-C Import Spreadsheet require data for all employees listed:

  • 1. Employee first name
  • 1. Last name
  • 2. Social security number (SSN)
  • 3. Street address
  • 4. City or town
  • 5. State or province
  • 6. Country code
  • 6. Zip or foreign postal code
  • 10. Employer contact phone number
  • 14. All 12 Months or values for each month
  • 15. May be required depending on values used in #14
  • 16. Highly recommended as this will reduce your tax liability.

Importing Your Data

View our step-by-step instructions on importing your Excel file to learn more.

If your 1095-C Import Spreadsheet is imported successfully, you will see a review of your filing after uploading. If not, you will see an error screen that will detail the type of error that occurred along with line numbers to help you correct the issue.

Need further assistance?

Our Knowledgebase is available to BoomTax customers 24/7. Still not finding the answers you need?  Contact our Support Team. We are always happy to assist!

If you’d like to learn more about ACA reporting, keep reading here:

BoomTax, The Boom Post, and its affiliates do not provide tax, legal or accounting advice. This material has been prepared for informational purposes only, and is not intended to provide, and should not be relied on for, tax, legal or accounting advice. You should consult your own tax, legal and accounting advisors prior to engaging in any transaction.

About Author