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

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

  1. Log into your Yearli account.
  2. Select Import Forms / Templates.
  3. Select the Yearli Excel Import option.
  4. Click on the W-2 or 1099-MISC link under Templates to download the template.

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?
1 out of 1 found this helpful