Yes, you can do this with a file. When vendors already in PayHOA are missing an email, phone number, address, tax ID (EIN), 1099 setting, default category or custom field value, put the missing details in a spreadsheet and import it. The import adds to the vendors you have and doesn't make copies of them, provided PayHOA recognizes each row by its vendor name. You only need Vendor Name plus the columns you're adding, and a blank cell leaves the vendor as it is.
What you need in the file
The smallest file that works has two columns: Vendor Name and the detail you're adding.
VENDOR NAME | EIN | PHONE | |
ABC Landscaping | 12-3456789 | 859-555-0101 | |
Bluegrass Pool Care | 98-7654321 | ||
Lexington Electric Co | 859-555-0134 |
Vendor Name is the only column that identifies the vendor. It must be the same as the name in PayHOA, punctuation included: "ABC Landscaping, LLC" isn't "ABC Landscaping". Only capitals can differ.
Other headings: ADDRESS 1, ADDRESS 2, CITY, STATE, ZIP, CONTACT NAME, 1099 ELIGIBLE, DEFAULT CATEGORY, or the name of a custom field.
Values are saved as typed, without a check. Use two-letter state codes in capitals, and format the EIN and ZIP columns as text so Excel keeps a leading zero.
To get the names right, start from PayHOA's own list. Click Reports, then Vendor Overview under Expense Reports. The report lists every active vendor, including vendors you've never paid. Leave Vendor Name ticked and tick the fields you're filling; the report calls the email Contact Email and the phone Phone #. Untick Full Address, Full Contact Info, Total Checks and Total Amount, and untick Nickname and Account Number unless you're filling those. Click Show results, then Export CSV. The file shows which vendors have gaps. It has no 1099 or default category column; add those yourself. See Steps to update vendors.
Steps
Export your vendor list as above, and keep a spare copy.
Delete the rows of vendors you've deleted. The report lists some without marking them; Vendors → Show deleted shows which. Delete the rows you aren't adding to as well.
Type the missing details into the blank cells. Leave Vendor Name, and any cell that already has a value, as it is.
Save the file as CSV or Excel. Click Vendors, the arrow beside New vendor, then Import vendors, and upload the file.
On Edit mapped vendor data, check the dropdown above each column.
Check each row's Status and orange info icons, as described below. Click the X (Keep original value) beside any change you don't want.
Click Start import. It runs at once, with no confirmation. Import complete shows a Vendors updated card with the number of vendors that changed. Open a few vendors and check them.
What you'll see before you import
Updating is what you want. Each added detail has an orange info icon and an X beside it. Hover over the icon: Previous value: (blank) means the vendor had nothing there. Any other value is about to be replaced. A cell with no icon holds what the vendor already has, or is blank, and isn't changing (the 1099 Eligible column is the exception; see Watch out for).
No changes means the vendor already has what's in the row.
New means PayHOA didn't recognize the name, and importing adds a second vendor. Correct the name in your file and upload it again.
A warning triangle means the row won't be imported. Hover over it to see why.
Important: Default Category and custom fields aren't compared on this page. A row that only adds one of them reads No changes. If your file adds nothing else, the line above the table reads 3 records match your existing data. No changes will be made. Click Start import anyway: the values are saved.
What gets added, and what doesn't
In your file | What happens |
A value where the vendor has a different one | The file's value replaces it. To keep the vendor's, leave that cell blank, or click the X (Keep original value) on the mapping page. |
A blank cell, a column that isn't in the file, or a vendor that isn't in it | Left alone. An import never clears anything. |
1099 Eligible | Yes, Y, True or 1 turns it on. Any other text, No included, turns it off. A mark such as X counts as other text: it turns 1099 eligibility off, and the mapping page shows the cell as you typed it, with no warning. Blank leaves it as it is. |
Default Category | The vendor gets the category with that name, or a new expense category if there's none. |
A file can't add these:
Bank details for ACH. See Set up a vendor for ACH payments.
W-9s and other documents. Upload them under Documents on the vendor's page.
A separate mailing address or a phone extension. Edit the vendor. An imported address fills the main address only.
Watch out for
Warning: a row that isn't recognized is added as a second vendor. It reads New. Its name is spelled or punctuated differently, or you deleted that vendor. Never leave a name blank: if the row's email belongs to a vendor, the page says the row won't be imported, but that vendor is updated anyway.
Important: adding only tax IDs? Leave the 1099 column out. A filled-in 1099 Eligible cell makes its row read Updating even when the vendor already has that setting, and the cell never gets an icon. A row like that isn't counted on the Vendors updated card, so the card can show fewer vendors than the page said were updating.
Important: copy Default Category names from your chart of accounts. Copy the whole name as it's shown there, with the account number in front if it has one: 5310 - Landscaping, not Landscaping. A name PayHOA can't find, even a typo, becomes a new expense category without a warning. If an income and an expense category share a name, the vendor may get the income one; set that vendor's category by editing the vendor.
Warning: there's no undo. A replaced value is gone, so keep your spare copy.
Common questions
I already imported my vendors. Can I import again just to add tax IDs, emails or phone numbers? Yes. Upload a file with the Vendor Name column and a column for each detail you're adding. You don't need the other columns again: anything not in the file, and any blank cell, is left as it is on the vendor.
Will it create duplicates? Not if each name in your file is the same as the vendor's name in PayHOA, apart from capitals. A name spelled or punctuated differently reads New on the mapping page and would add a second vendor.
Some vendors already have an email or tax ID. Will the file overwrite it? Yes, if the file has a different value in that cell. To keep what the vendor has, leave the cell blank, or click the X (Keep original value) beside that change on the mapping page.
Does adding a vendor's email send them anything, or change how they're paid? No. Importing doesn't email or invite vendors, and it doesn't change bank details for ACH or any payment. The email is only saved on the vendor, where a later Let the vendor decide payment uses it to contact them.
Related
Import vendors: every screen, column and message
