Skip to main content

How to Import Vendors

This article explains how to import vendor records into PayHOA, and how to use the same tool later to update those records in bulk.

Written by Rachel Cope

See a video of how to do this here.

Navigating to the Importer

  1. Click Vendors in the left-hand navigation.

  2. Click Import Vendors.

Preparing Your File

Before you upload, get your spreadsheet into a format the system can read.

  • Click the sample file link to see the format your spreadsheet should be in.

  • Confirm your file is one of the supported file types: CSV, XLS, or XLSX.

Uploading Your File

  1. Click Upload File to browse for your document, or drag and drop it into the box.

  2. Wait while the system analyzes your file. This usually takes a few seconds.

Mapping Your Columns

When the analysis finishes, you'll land on the mapping page.

  1. Look over the list and confirm each column header is matched correctly.

  2. Use the drop-down menu beside a header to change anything that's mapped to the wrong field.

  3. Click Start Import.

A green success banner confirms the import finished. Return to the Vendors tab to see your imported vendors.

Updating Vendor Records Later

The importer stays available after your initial import, so you can come back to it any time you need to change vendor records in bulk.

  1. Click Import Vendors again.

  2. Upload your revised file and let the system analyze it.

  3. On the mapping page, you'll see that the system recognizes these as updates to existing records rather than new fields. Review the mapping and adjust any column headers that need it.

  4. Click Start Import.

Once the import finishes, you'll see how many vendor records were successfully updated. Return to the Vendors page to view the records with your updates applied.

Did this answer your question?