Import 1095-C Data

This page shows the order of data used for importing data into IRS Form 1095-C software.

To start, take a look at the attached PDF showing Form 1095-C with element names. This PDF shows Form 1095-C and each field used in the form. The excel file you develop follows the form starting with Void, then Corrected, then PersonFirstNm, PersonMiddleNm and so on. The 1st column in the excel file is Void. The 2nd column is Corrected. The 3rd column has PersonFirstNm and so on. Fields can be blank. The layout is as follows:

Void (enter a 1 or YES to check)
Corrected
1 PersonFirstNm
1 PersonMiddleNm
1 PersonLastNm
1 SuffixNm
2 SSN
3 AddressLine1Txt
3 AddressLine2Txt
4 CityNm
5 StateCd or ForeignProvinceNm (enter 2 character code)
6 CountryCd (leave blank if US)
6 ZipCd
7 BusinessNameLine1Txt
7 BusinessNameLine2Txt
8 EIN
9 AddressLine1Txt
9 AddressLine2Txt
10 ContactPhoneNm
11 CityNm
12 StateCd or ForeignProvinceNm (enter 2 character code)
13 CountryCd (leave blank if US)
13 ZipCd

Now enter employeee offer and coverage for each month.

14 AnnualOfferofCoverageCd (enter required code)
14 JanOfferCd
14 FebOfferCd
14 MarOfferCd
14 AprOfferCd
14 MayOfferCd
14 JuneOfferCd
14 JulyOfferCd
14 AugOfferCd
14 SepOfferCd
14 OctOfferCd
14 NovOfferCd
14 DecOfferCd
15 AnnualShrLowestCostMthlyPremAmt
15 JanAmt
15 FebAmt
15 MarAmt
15 AprAmt
15 MayAmt
15 JuneAmt
15 JulyAmt
15 AugAmt
15 SepAmt
15 OctAmt
15 NovAmt
15 DecAmt
16 AnnualSafeHarborCd (enter required code if applicable)
16 JanSafeHarborCd
16 FebSafeHarborCd
16 MarSafeHarborCd
16 AprSafeHarborCd
16 MaySafeHarborCd
16 JuneSafeHarborCd
16 JulySafeHarborCd
16 AugSafeHarborCd
16 SepSafeHarborCd
16 OctSafeHarborCd
16 NovSafeHarborCd
16 DecSafeHarborCd

Now list each covered individual. Fill out Boxes A through E as follows:

a PersonFirstNm
a PersonMiddleNm
a PersonLastNm
a SuffixNm
b SSN
c BirthDt
d CoveredIndividualAnnualInd (enter a 1 or 0 or leave blank; a 1 puts a check in that box)
e JanuaryInd
e FebruaryInd
e MarchInd
e AprilInd
e MayInd
e JuneInd
e JulyInd
e AugustInd
e SeptemberInd
e OctoberInd
e NovemberInd
e DecemberInd

Form 1095-C provides 6 lines for covered individuals. If you import in more than 6 covered individuals, the software continues the 7th covered individual on new 1095-C form.

The excel file you develop follows the form itself until you get to Boxes 17 through 22 where they then start stacking in the excel file.

Please send an e-mail to support@1099fire.com with any feedback, comments or questions. Call or e-mail anytime.