Yearli Excel - How do I get the Excel import template?

The Excel import can be used to import any W-2, 1099, or 1095 form on the Yearli site.  To obtain the Excel import template:

  1. Log into your Yearli account.
  2. Select Start New Forms.
  3. Select Import Data.
  4. Choose the Yearli option.
  5. Choose the form type you'd like to import.
  6. Select the link to download the Excel Template and Instructions.

The template file on the Yearli site must be used in order to import data.  The template will allow the Yearli site to automatically map the data to the correct field(s) on the form(s).

When creating the Excel file, here are some things to be aware of:

  • No periods or commas should be included in the names.  Ampersands "&" are allowed.
  • A TIN is required for each payer and recipient record.
  • An address is required for each payer and recipient record. 
  • It is required to have at least one dollar amount type per recipient included in the Excel file for the import to complete.
Was this article helpful?
7 out of 15 found this helpful