Rss Categories

How do I get the Excel import template?

Views: 1222 Created: 2019-09-12 14:04 Last Updated: 2019-09-12 14:04


I would like to use the Excel import option on Yearli.  Where can I find the 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.


  • Yearli Core
  • Yearli Performance