Yearli Guide
Have questions? Our knowledge base has answers.
  1. Yearli Guide
  2. Yearli Desktop
  3. Import Data

Importing Corrected 1095-B or 1095-C Forms

Saving and Completing the Import File

  1. Click on the Import Data button.
  2. Choose Import via Excel. 
  3. Choose the 1095-B or 1095-C Correction form type.
  4. Click OK.
  5. Click Select Forms.
  6. Select the order number to correct. 
  7. Click Next.
  8. Select the recipients to correct.
  9. Click Next.
  10. Choose where to save the file.
  11. Name the file.
  12. Click Save.
  13. The import file will open automatically. Make changes to the information as needed.
  14. Save the file.

Editing the Import File

Some guidelines to keep in mind while completing the 1095 import file:

  • Column headings (Row 1) in the import file cannot be changed.
  • Red column headings are required in order to successfully import data.
  • Each row is equivalent to one form.
  • Payer information should be repeated on each row.
  • Only the first worksheet/tab in the Excel file will be imported.
  • Checking or unchecking checkboxes:
    • To check the box, enter a value of True, 1, or X in the cell.
    • To leave the box blank, enter a value of 0, False, or leave the cell blank.

Importing the Completed Import File

  1. Click on the Import Data button.
  2. Choose Import via Excel.
  3. Choose the 1095-B or 1095-C Correction form type.
  4. Click OK.
  5. Click the Browse For File button.
  6. Locate the saved import file.
  7. Click Open.
  8. If there are errors on the import file, the errors will be displayed on the Audit Report screen.
    • Go to the next section if errors are found during the import process.

Fixing Errors on the Excel File

  1. On the Audit Report screen, click on the Export Error File button.
  2. Choose where to save the file.
  3. Name the file.
  4. Click Save, and the file will open automatically.
  5. Refer to column A: "Error Description".
  6. Errors found on the import file will appear in the row in which the error was found.
    • For example, if there is an error description in row 2, the error will be found in row 2.
  7. Review the file for any fields highlighted in yellow.
    • Fields in yellow contain errors.
  8. After making the applicable changes, save the file.
  9. Attempt the import again, this time with the errors file saved in step 4.

For more steps on how to correct errors on the import file, please see the Troubleshooting Common Import Errors article.

Was this article helpful?
0 out of 0 found this helpful

Articles in this section