aca, affordable care act, 1095-C, 1094-C, efiling, ACA reporting, irs, 1095-C Import Spreadsheet

BoomTax 1095-C Import Spreadsheet Format Guidelines

To help you quickly and easily import your employee data, we have created an Excel spreadsheet template that contains all of your 1095-C data in a standard format. This format closely mirrors the 1095-C forms, so your benefits / payroll provider should be somewhat familiar with the information required to populate this spreadsheet.

Download the BoomTax Excel Template

Entering Your Data

  • All columns in the sample spreadsheet must be present, although data is not required for every column. To see what data is required, please see our ‘Required Columns’ section below.
  • Blank rows are not allowed 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 you answer ‘Yes’ to ‘Is employer self insured?’. If the employer is not self insured, covered individuals should not be in your import.
  • 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.
  • Plan start month is optional for this year, but if you do provide a value it must be 1-12, which corresponds to the months of Jan-Dec. Again, we standardize this when read in to have a leading 0 as specified by the IRS. (e.g. 1 -> 01)
  • Yes, true, 1 are all acceptable for true/false type fields. (e.g. Is employer self insured?)
  • Zip codes are automatically read in as Zip+4 with or without dash

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 something like ‘Line 3: Employee SSN must have exactly 9 digits’.

Required Columns

Data is required in the following columns:

  • 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

Importing Your Data

To get started with importing your data, login to BoomTax, then enter the employer you’re filing for (also referred to as the payer). Once you’ve done this, either complete your 1094-C or skip it, and select ‘Import with Excel’ on the Add Eligible Employees screen. On the import screen, either drag and drop your file into the dashed area, or click browse and find the file manually. After this, click upload and wait for the system to read in your data.

After your data is read in, you will be taken to your filing if all data was imported correctly. If not, you will be taken to an error screen which will detail the type of error that occurred along with line numbers to help you correct the issue.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.