1095 C Excel Template

Column u part ii.
1095 c excel template. Import 1095 c data you should import 1095 c data before import 1095 c covered individuals data click the top menu import then click the sub menu import 1095c data to view data import screen. Column a form type. 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. In the spreadsheet import wizard source data screen select the appropriate client from the client name field.
If necessary click the ellipsis button in the client options column to specify filtering and. Do not change the format including the headers of. Mark the checkbox for each client for which you want to export a template spreadsheet. The 1095 c excel spreadsheet template that pro ware provides as a download from our website.
Here is a mapping tool to use when entering data into the 1095 b excel template. Column b j part i. Line 14 offer of coverage. Boomtax 1095 c import spreadsheet format guidelines.
Select the data file if the data file is opened by other application ie. All fields marked with an asterisk are required and must be completed before upload. As you get started importing your 1095 c data with expressirsforms template be sure to keep these points in mind to make your process as easy as possible. Applicable large employer member employer column k t part i.
Creating a 1095 c template spreadsheet choose file export 1095 c data to open the export 1095 c data screen. The 1095 b excel spreadsheet template that we provided as a download from our website. An excel spreadsheet that contains your employees information only one row for each employee. Here is a mapping tool to use when entering data into the 1095 c excel template.
Column v ah part ii. In the import file section click the browse button to navigate to the spreadsheet file to import and click open or enter the path and filename. Column a form type column b k part iii issuer or other coverage provider column l v part i.