Knowledge base

Clear answers for your next step.

Back to Support
On this page

Imports & validation

Import a spreadsheet with your own column names

Use Advanced Import to match your spreadsheet columns to the fields on the form.

Updated

Upload the file and choose where it belongs

  1. Open Recipients → Imports → Spreadsheets & 1220 and choose your spreadsheet.
  2. Check Completion Email, then continue into Advanced Import.
  3. Choose Current active filer or Create a new filer. For a new filer, enter its details and choose the tax year.
  4. Select Next: Form and choose the form you are importing.

Match and review the columns

  1. Select Next: Map columns and review the suggested matches. Use Business Name for businesses, or First Name and Last Name for people.
  2. Check any AI updated or Needs review labels. Adjust the matches as needed and review the sample rows, especially names, Tax IDs and amounts.
  3. Use Next: Review to check the mapping and sample forms. If a reminder lists unused spreadsheet columns, decide whether they should be mapped.
  4. Select Next: Import, confirm the filer and year, then select Launch Import.

Check the imported forms

When processing finishes, open Recipients → Manage. Review the forms and fix any Validation Issues before ordering.

If you create a new filer during setup, finish or save the available setup steps before leaving. Closing or reloading the page can discard choices you have not saved or launched.

More guidance

Still need help?

Contact our team1-877-836-6680