Skip to main content

Import vendors

The vendor importer does two jobs:

M
Written by Michael Bollinger

The vendor importer does two jobs:

  • It adds new vendors. Upload a spreadsheet and PayHOA adds every vendor in it in one go. Use it when you first move to PayHOA, or whenever you have more than a handful of vendors to add.

  • It updates the vendors you already have. Upload a file with their names and the details that should change, such as new addresses, emails, tax IDs or 1099 settings. PayHOA changes those vendors and doesn't add them a second time. See Update existing vendors with the importer.

One file can do both. PayHOA reads your file, matches each column to a vendor field, and shows you every row, marked new, updating or not importable, before anything is saved.

Add or edit a vendor one at a time when you have only a few, or when you want to enter bank details for ACH as you go. See Add, edit and delete vendors.

The importer can't add or change:

  • Bank details for ACH. Add those vendor by vendor. See Set up a vendor for ACH payments.

  • W-9s or other documents. Upload them on each vendor's page. See The vendor page: documents, notes and history.

  • A separate mailing address. The address columns fill the vendor's main (physical) address. If a vendor's checks should go somewhere else, edit the vendor afterwards and untick Mailing address is the same as the physical address.

  • A phone extension. There's no column for Ext.; add it on the vendor.

  • Your own logo files. There's no logo column. PayHOA only adds a logo it finds from the vendor's website (see What happens to websites and logos).

  • Payment history, unpaid bills or 1099 amounts. Create payables for bills you still owe. See Create a payable.

Before you start

Who can import. Admins can always import vendors. Anyone else needs the Vendors permission set to Read + write. The Payables permission on its own isn't enough: someone with Read + write on Payables but not on Vendors sees Import vendors on the Vendors page, but clicking it returns them to the dashboard with You are not authorized to view the requested page. An admin sets permissions on the person's page. See Give board members and staff access.

Where it is. Click Vendors in the left menu, then the arrow beside New vendor, then Import vendors. The importer is only on the Vendors page; there's no vendor import under Other Tools.

Your file.

  • A CSV, XLS or XLSX file, up to 10 MB. PDFs aren't accepted. For Google Sheets or Numbers, download the sheet as CSV or Excel first.

  • One file at a time.

  • In an Excel workbook, PayHOA reads one sheet: the one that was open when the workbook was last saved. Put your vendors on that sheet, or save the sheet you want as its own file.

  • The first row should hold column names. If your file has no header row, you can say so on the upload page.

  • Completely empty rows are ignored.

Sample file. The upload page has a Download the sample file link. It downloads payhoa-sample-vendors.csv: the 17 columns PayHOA knows, with five example vendors.

AI reads your column names. The page calls this the AI Assistant. It looks at your column headers, the first five rows, and the names of your vendor custom fields, and suggests which vendor field each column belongs to. It doesn't decide what gets imported: you see every match and can change it. If the AI can't be reached, the columns simply come up unmatched and you match them yourself.

What gets created, updated or left alone.

Your row

What PayHOA does

The vendor name isn't in your vendor list (and the email isn't either)

Adds a new vendor.

The vendor name matches a vendor you have, or the email does

Updates that vendor. Only the cells you filled in change. A blank cell never clears a value.

It matches a vendor and nothing is different

Leaves the vendor as it is.

It has no vendor name, or a value is too long

Doesn't import the row, and tells you why.

A Default Category name that isn't in your chart of accounts

Creates a new expense category with that name.

A column you matched to Create new custom field

Creates that vendor custom field.

To change vendors you already have, follow Update existing vendors with the importer.

Nothing is sent to your vendors. Importing doesn't email, invite or pay anyone, and it doesn't cost anything. When the import finishes, PayHOA emails a summary to you, the person who ran it.

An import can't be undone. There's no undo or roll-back. Nothing is saved until you click Start import, so check the rows carefully first. To reverse a mistake afterwards, edit or delete the vendors one at a time, or import a corrected file to overwrite the values.

Your file

Your column headers don't have to match these names, and the columns can be in any order. PayHOA matches columns by their name and contents, and you can fix any match before you import. Only Vendor Name is required.

Field in PayHOA

Sample file header

Required?

What to enter

Example

If it's blank or wrong

Vendor Name

VENDOR NAME

Yes

Up to 40 characters. This is the name printed on checks.

ABC Landscaping

Blank: the row isn't imported. Over 40 characters: the row isn't imported.

Nickname

NICKNAME

No

Up to 255 characters. Put a longer legal name or DBA here.

ABC

Blank: left empty.

Account Number

ACCOUNT NUMBER

No

Your account number with the vendor. Up to 255 characters.

ACC-001

Blank: left empty.

EIN / Tax ID

EIN

No

The vendor's EIN, or SSN for an individual. Up to 255 characters. PayHOA doesn't check the format; the vendor form uses 12-3456789.

12-3456789

Saved exactly as typed. Correct it on the vendor before you file a 1099.

Mail Stop Code

MAIL STOP CODE

No

The department, attention line or mail stop. Up to 255 characters. It fills Department / attention / mail stop code on the vendor.

ATTN: Accounts

Blank: left empty.

Address Line 1

ADDRESS 1

No

Street address. Up to 50 characters, and no more than 50 together with Address Line 2.

123 Main Street

Too long: the row isn't imported. Blank: see the note below.

Address Line 2

ADDRESS 2

No

Suite or unit. Counts toward the same 50 characters.

Suite 100

Too long: the row isn't imported.

City

CITY

No

Up to 255 characters.

Lexington

Blank: left empty.

State

STATE

No

The two-letter code in capitals (KY) or the full state name (Kentucky). PayHOA doesn't check it at import.

KY

Anything else is saved as typed. The vendor form then shows the state as empty, and a mailed check can be rejected.

ZIP Code

ZIP

No

Up to 31 characters. Imported exactly as it is in the file.

40507

Over 31 characters: the row isn't imported.

Contact Name

CONTACT NAME

No

Up to 255 characters.

John Smith

Blank: left empty.

Email

EMAIL

No

One email address. Also used to find an existing vendor when the name doesn't match. PayHOA doesn't check the format at import.

A mistyped address is saved as typed. The vendor form checks it the next time you save that vendor.

Website

WEBSITE

No

Up to 255 characters. PayHOA uses it to look for the vendor's logo.

Blank: no logo is looked up.

Phone

PHONE

No

Up to 255 characters. Saved as typed.

859-555-0101

Blank: left empty.

Fax

FAX

No

Up to 255 characters. Saved as typed.

859-555-0102

Blank: left empty.

1099 Eligible

1099 ELIGIBLE

No

Yes, Y, True or 1 turns it on. No, N, False or 0 turns it off.

Yes

Any other text turns it off. Blank: a new vendor is off, an existing vendor is unchanged.

Default Category

DEFAULT CATEGORY

No

The name of a category as your chart of accounts shows it, with the account number in front if it has one (5310 - Landscaping), spelled exactly (capitals don't matter). Up to 255 characters.

Landscaping

A name PayHOA can't find becomes a new expense category. See the warning below.

A vendor custom field

(any other column)

No

Any text. Match the column to an existing vendor custom field, or create one.

LIC-1001

Blank: nothing is saved for that vendor.

Important: check your Default Category names before you import. PayHOA doesn't warn you on screen when a category name isn't found; it creates a new top-level expense category with that name when the import runs. A typo ("Landscapng") or a slightly different name ("Landscape" for "Landscaping") leaves you with an extra category. Compare the names in your file with your chart of accounts first. PayHOA also uses the first category it finds with that name, whatever its type, so if you use the same name for an income category and an expense category, the vendor may get the income one. Rename one of them, or set the default category on the vendor afterwards. See Chart of accounts overview.

Important: the State column isn't checked. A misspelled state ("Kentuky") or a lower-case code ("ky") imports without a warning. You only find out later: the vendor form shows State / province as empty and won't save until you pick one, and a check mailed to that vendor can be rejected, which sends the payable back as Declined. Use the two-letter code in capitals.

Note: the address is optional here, but not on the vendor form. The importer accepts a vendor with only a name. The vendor form needs Address 1, City, State / province and Zip code before it will save, and a mailed check needs a complete, deliverable address. Import the full address if you have it.

Tip: A business name over 40 characters can't be used as Vendor Name. Use a shorter form the vendor's bank will accept on a check, and put the full name in Nickname.

Tip: ZIP codes that start with 0 lose the zero if Excel treats the column as a number. Format the ZIP column as text before you save the file.

Rules for the whole file

  • One row per vendor. One header row at the top, then a row for each vendor.

  • One column per field. Each vendor field can be matched to only one column. If your street address is split across two columns, use Address Line 1 and Address Line 2, or combine them in your file first.

  • Blank cells never clear anything. For an existing vendor, a blank cell leaves the current value alone. You can't use an import to empty a field.

  • Text is imported as typed. Spaces at the start and end of a cell are removed; nothing else is reformatted.

How PayHOA matches existing vendors

PayHOA looks for an existing vendor with the same Vendor Name. Capitals don't matter, and spaces before or after the name are ignored, but the rest must be the same: "ABC Landscaping LLC" doesn't match "ABC Landscaping". If no vendor has that name, or the name cell is blank, and the row has an Email, it looks for a vendor with that email. The full rule, with examples, is in How PayHOA decides a row is an update.

  • Matched by name: the vendor is updated with the cells you filled in. If only the capitals in the name differ, the vendor's name takes the capitals in your file.

  • Matched by email: the vendor is updated, and its name changes to the name in your file. Check these rows carefully. If two different vendors share an email address, the wrong one can be renamed.

  • A deleted vendor isn't matched. Importing that name adds a second vendor, and the deleted one stays deleted. (If the row also has an email that belongs to a vendor you still have, that vendor is updated and renamed instead.) To bring the old one back instead, restore it first: on Vendor List, turn on Show deleted, then click ⋯ → Restore vendor.

  • The same new vendor twice in one file: the first row adds the vendor, and the second row fails with A vendor named '…' already exists in this organization.

  • Two rows for the same existing vendor: both update it, in file order, so the lower row wins.

What happens to websites and logos

If a row has a Website, PayHOA looks for that vendor's logo online while it reads your file, and saves the logo when the import runs. It never replaces a logo a vendor already has. The finished import shows how many logos it saved. Because each website is looked up, a long list with websites takes longer to read.

Update existing vendors with the importer

The importer isn't only for new vendors. When a row's vendor name matches a vendor you already have, PayHOA changes that vendor and doesn't add another one. That makes it the quickest way to change many vendors at once.

When to use it.

  • Several vendors have moved or changed their contact details, and you have the new addresses, emails or phone numbers in a spreadsheet.

  • You're getting ready for 1099s and need to fill in EIN / Tax ID and turn on 1099 Eligible for a list of vendors.

  • You want to give many vendors a Default Category, a nickname, an account number or a value in a vendor custom field.

If you only want to fill in details your vendors are missing, such as emails, phone numbers or tax IDs, there's a shorter guide: Add missing vendor details from a file.

For one or two vendors, editing is quicker. See Add, edit and delete vendors.

Steps to update vendors

  1. Get your current vendor list out of PayHOA. The Vendors page has no export button. Use one of these:

    • The Vendor Overview report. Best when you're changing many vendors. You need Reports access. Click Reports in the left menu, then Vendor Overview under Expense Reports. The report opens with some columns already ticked and the results already showing. Under Step 2: Pick your columns, in the Vendor fields list, leave Vendor Name ticked and tick each field you plan to change: Nickname, Account Number, EIN, Address Line 1, Address Line 2, City, State, Zip, Contact Name, Contact Email, Phone #, Fax # or Website, or a field under Vendor custom fields. Untick Full Address, Full Contact Info, Total Checks and Total Amount, which are ticked to start, and leave Vendor ID unticked (it's empty in the file); the importer has no field for any of them. Click Show results, then Export CSV. The file is named vendor-overview_ followed by the day's date, for example vendor-overview_2026-11-11.csv. See Expense and vendor reports.

    • The importer's sample file. Best for a handful of vendors. On the importer's upload page, click Download the sample file and delete the five example rows. Then type each vendor's name as it appears on Vendor List, and fill in only the cells you're changing. Leave every other cell blank, including 1099 ELIGIBLE. The file already has a column for every field the importer knows, and only the vendors you typed, so steps 4, 5 and 7 don't apply. See 2. Import Vendors: the upload page.

  2. Save a copy of that file before you edit it, and keep the copy. It's your only record of the old values.

  3. Leave the Vendor Name column exactly as it is. The name is how PayHOA recognises each vendor. Fill it in on every row.

  4. Take out everything you aren't changing. The report lists every vendor, and it can't be narrowed to a few: the search box on the report page finds fields, not vendors. Delete the rows for vendors you aren't changing, and the columns you aren't changing. A column that isn't in the file is left alone on every vendor. So is a blank cell.

  5. Delete the rows for vendors you've deleted. The report includes a deleted vendor if it has a payable, or a payment in the report's dates, and nothing in the file marks it as deleted. To see which they are, click Vendors and turn on Show deleted; the list then shows only your deleted vendors. See Check before you import for what these rows do if you leave them in.

  6. Change only the cells that should change. Leave every other value as the report gave it.

  7. Add a column for any field the report doesn't have. Use these headers: MAIL STOP CODE, 1099 ELIGIBLE (Yes or No) or DEFAULT CATEGORY (the category's name, spelled exactly).

  8. Save the file as CSV or Excel. In PayHOA, click Vendors, then the arrow beside New vendor, then Import vendors, and upload it.

  9. On the Edit mapped vendor data page, check the dropdown above each column. The report's headers differ a little from the importer's field names: Contact Email belongs to Email, Phone # to Phone, Fax # to Fax, EIN to EIN / Tax ID and Zip to ZIP Code. PayHOA usually matches all of the report's columns, and the three added headers in step 7, on its own. The AI matches columns afresh for every file, so check anyway, and correct any that are wrong. See 8. Change which field a column goes to.

  10. Read down the Status column. Every row should read Updating or No changes. None should read New. A New row adds a vendor; see Check before you import. A row that changes only a Default Category or a custom field reads No changes, and the change is still made.

  11. Click the Updating filter. (The filters appear only when your file has more than one kind of row.) Each cell that will change has a small orange info icon beside the new value. Hover over it to see Previous value: and what the vendor has now. A row with no icon on any cell isn't changing, unless it has a filled-in 1099 Eligible cell (see the note below). Click the X (Keep original value) beside any single change you don't want: the cell goes back to the vendor's current value, and the X becomes an arrow (Undo) that brings your change back. See 10. Rows that update a vendor you already have.

  12. If any row shows a change to Vendor Name, stop and check it. Either only the capitals differ, or the row was matched by its email and that vendor is about to be renamed.

  13. Click Start import. The Import complete page shows a Vendors updated card with the number changed. Open two or three of those vendors and check them.

Note: If you upload the report's file with Vendor ID, Full Address, Full Contact Info, Total Checks or Total Amount still in it, those columns come up with an empty dropdown and aren't imported. They do no harm, but they make the page harder to read.

Note: When the Vendor Overview report opens, an Error pop-up reading Please select at least one field to view a report. can appear at the top left even though columns are ticked and the results are showing. Ignore it.

Tip: Deleting the columns you aren't changing also protects you from your spreadsheet program. Excel can drop the leading zero from a ZIP code or rewrite a long account number, and PayHOA would read that as a change you asked for.

Note: Don't start from the Vendor Directory report. It puts both address lines in one Address column and reformats phone numbers, so importing it would rewrite addresses and phone numbers you didn't mean to touch.

Note: If your file has a filled-in 1099 Eligible column, every matching row reads Updating, even when nothing differs. This is harmless: a vendor that already has that setting isn't changed. The orange info icon shows the real changes. The 1099 cell itself never gets an icon, so check that column in your file by eye, or leave it out unless 1099 eligibility is what you're changing.

How PayHOA decides a row is an update

PayHOA checks every row once, when it reads your file, in this order:

  1. By vendor name. It looks for a vendor in your association with the same name as the row's Vendor Name. Capitals don't matter, and spaces before or after the name are ignored. Everything else must be identical: every word, the spaces between words, and all punctuation, such as commas, full stops, "&" and "LLC".

  2. By email, only if step 1 finds nothing. If no vendor has that name, or the name cell is blank, and the row has an Email, it looks for a vendor with that email address. Capitals don't matter.

  3. Otherwise the row is new. PayHOA adds a vendor.

Deleted vendors are never matched.

  • A row that matches: your vendor is "ABC Landscaping". A row with the name "abc landscaping" and a new phone number reads Updating, and only the phone number changes (and the capitals in the name).

  • A row added as new by mistake: a row named "ABC Landscaping, LLC" or "A.B.C. Landscaping", with no email, reads New. Importing it gives you a second vendor.

When a row is matched by email, the vendor's name is replaced by the name in your file. See How PayHOA matches existing vendors for deleted vendors and for the same vendor listed twice in one file.

What an update changes, and what it leaves alone

Field

What an update does

Vendor Name

Replaced with the file's value. On a match by name, that can only change the capitals. On a match by email, the vendor is renamed.

Nickname, Account Number, EIN / Tax ID, Mail Stop Code, Address Line 1, Address Line 2, City, State, ZIP Code, Contact Name, Email, Website, Phone, Fax

Replaced with the file's value.

1099 Eligible

Replaced. Yes, Y, True or 1 turns it on. Anything else you type turns it off.

Default Category

Replaced with the category that has that name. PayHOA takes the first category it finds with the name, whatever its type, and capitals don't matter. If there's none, it creates a new expense category with that name and gives the vendor that one.

Vendor custom fields

Replaced with the file's value. A column matched to Create new custom field creates the field first.

Logo

Filled in only when blank. PayHOA saves a logo only if the vendor has none and it finds one from the row's Website.

Separate mailing address, phone extension (Ext.), bank details for ACH, documents and W-9s, notes, payables and payment history

Never changed by an import.

A blank cell never clears anything. It leaves the vendor's current value as it is, and so does a column that isn't in your file.

What you can't update this way

You want to

Do this instead

Add or change bank details for ACH

Enter them on the vendor. See Set up a vendor for ACH payments.

Add a W-9 or another document

Upload it under Documents on the vendor's page. See The vendor page: documents, notes and history.

Change a separate mailing address

Edit the vendor. The address columns change the main (physical) address only. If a vendor has a separate mailing address, mailed checks keep going there. See Add, edit and delete vendors.

Add or change a phone extension

Edit the vendor and fill in Ext.

Replace a logo

Edit the vendor and click Change logo on the Logo card.

Rename a vendor

Edit the vendor and change Vendor name. In a file, a changed name no longer matches, so the row is added as a new vendor. The one exception is a row whose Email belongs to an existing vendor: that vendor is renamed. Don't rely on it, because two vendors can share an email.

Empty a field

Edit the vendor and clear it.

Delete, restore or combine vendors

Check before you import

Warning: a row that reads New adds a vendor. If a vendor you already have reads New, its name in the file isn't the same as its name in PayHOA, and importing gives you a duplicate. Correct the name in your file and upload it again. In a file exported from Vendor Overview, a New row can also be a vendor you deleted: the report lists deleted vendors that have payables, or payments in the report's dates, without marking them, and deleted vendors are never matched. Remove those rows.

Warning: a deleted vendor's row can also read Updating. If a deleted vendor in your file has the same email as a vendor you still have, PayHOA finds no vendor with that name, matches the row by email, and marks it Updating. Importing it renames the vendor you still have to the deleted vendor's name. You can spot it by the orange info icon beside the Vendor Name: hover over it to see Previous value: and the name the vendor has now. Delete the deleted vendors' rows from your file before you upload it (step 5).

Important: changing a column's match doesn't re-check the rows. New and Updating are worked out once, from the columns as they were matched when the file was read. If you change which column is Vendor Name or Email on the mapping page, the statuses stay as they were. Rename the column header in your file to "Vendor Name" (or "Email"), click Upload different file, then Start fresh, and upload it again.

Important: always fill in the Vendor Name column. A row with a blank name is shown with a warning triangle and This row won't be imported — missing required field: Vendor Name. But if that row's Email belongs to a vendor you already have, the import updates that vendor with the row's other values anyway. Fill in the name on every row, and delete any row you don't want applied.

Warning: there's no undo. An update overwrites the old values, and PayHOA keeps no copy to go back to. Keep the copy you saved in step 2 until you've checked the result. To put a value back, import the old value again or edit the vendor.

A misspelled Default Category isn't flagged either: it becomes a new expense category. See the warning under Your file.

The import, screen by screen

The importer has three steps, shown across the top of the page: Upload, Mapping and Complete. Nothing is added to your vendor list until you click Start import on the Mapping step.

1. The Vendors page: open the importer

What you see. The Vendors page opens on the Vendor List tab. At the top right is the New vendor button with a small arrow beside it. If you only have read access, the button isn't there.

What to do.

  1. Click Vendors in the left menu.

  2. Click the arrow beside New vendor.

  3. Click Import vendors.

If your association has no vendors yet, the page shows Add your first vendor instead of a list. Click Import vendors there.

What happens next. The Import Vendors page opens. If you started an import earlier and didn't finish it, you see You have an import in progress first (screen 3).

2. Import Vendors: the upload page

What you see.

  • A back arrow at the top left, which returns you to Vendors, and the three steps: Upload, Mapping, Complete.

  • The heading Import Vendors and the line Upload your file and AI Assistant will automatically map your columns.

  • A Quick guide card, with an AI-powered mapping badge and three steps:

    1. Upload a CSV or Excel file — Not sure how to lay it out? Download the sample file

    2. AI analyzes your import data — Review column mappings and be sure it all looks right.

    3. Finish the import

  • The Upload your file box: Drag & drop your file here, or click to browse, with a Browse files button. Under it: CSV, XLS or XLSX, up to 10 MB.

  • A My file has headers checkbox, ticked to begin with.

What to do.

  1. If you want a starting point, click Download the sample file. Delete the five example rows, add your own vendors, and save.

  2. Leave My file has headers ticked if the first row of your file holds column names. Untick it if the first row is already a vendor. PayHOA then names the columns Column 1, Column 2 and so on, and you match each one yourself.

  3. Drag your file into the box, or click Browse files and pick it.

What happens next. PayHOA starts reading the file straight away (screen 4). There's no separate upload button.

If the file is the wrong type, too big or empty, a message says so, in red inside the upload box (the box's outline turns red too) or as a pop-up at the top left of the page, and nothing is uploaded. See If something goes wrong.

To leave: click the back arrow or any item in the left menu. Nothing has been saved yet.

3. You have an import in progress

You only see this window if you uploaded a vendor file earlier, got as far as the Mapping step, and left without importing. PayHOA keeps that unfinished import for you. It's kept per person: another admin opening the importer doesn't see yours.

What you see. The heading You have an import in progress and the question Would you like to pick up where you left off, or start a new import? Then four facts about the saved import:

  • Import type — Vendors

  • Records — the number of rows in the file, for example 6 rows

  • Current step — Mapping (or Review if you had clicked Start import and the import didn't run)

  • Last updated — the date and time you last worked on it

There's no X to close this window. You have to choose one of the two buttons.

What to do.

  • Click Resume import to go back to the Edit mapped vendor data page with your file and column matches as you left them.

  • Click Start fresh to throw the saved import away. A Cleared pop-up, Previous import cleared. Ready for a new file!, confirms it, and you're back on the upload page.

Note: A resumed import still shows each row as New or Updating as it was when you uploaded the file. If you've added or changed vendors since then, click Start fresh and upload the file again so the statuses are right.

4. Reading your file

What you see. A small window with a sparkle icon and a line of text that changes every few seconds: Uploading your file…, Reading your columns…, Finding your headers…, then Reading your file…, Lining up your columns… and Getting every row ready to match…. Under it is your file name and a progress bar with a percentage, labelled Step 1 of 2 · Uploading, then Step 2 of 2 · Reading & mapping your file.

If it takes longer than about 40 seconds, you may also see Taking a little extra care with this one… or Big file, careful work. Hang tight….

What to do. Wait. This window has no buttons and can't be closed. A list of six or seven vendors takes between 5 and 20 seconds; a long list with a Website column takes longer, because PayHOA looks up each website for a logo.

What happens next.

  • If the file is read, the window closes and the Mapping step opens. If some columns didn't match a vendor field, you're asked about them first (screen 5).

  • If the file can't be read, the window closes and an Upload Error pop-up says why. You stay on the upload page and can try another file.

5. Columns need your input

You see this window only if your file has a column that isn't one of the standard vendor fields and looks worth keeping, for example a license number or an ID from your old system.

Note: The AI doesn't answer the same way every time. Uploading the same file twice can bring this window up once and not the next time. When it doesn't appear, the AI may have matched the column to one of your existing vendor custom fields instead (the column's dropdown then shows, for example, Insurance ID (custom field)), or left it unmatched with an empty dropdown. Either way, check that column on the mapping page (screen 8).

What you see. The heading tells you how many columns: 1 column needs your input or 3 columns need your input, with the line We analyzed the values and have recommendations. Choose how to handle each column. Each column has its own card:

  • The column name from your file.

  • Up to three example values from that column, and + 1 more (or + 2 more, and so on) if there are others.

  • A suggestion, such as AI recommends: Custom Field - each record has different data.

  • A dropdown with two choices: Custom Field and Skip this column. It starts on the suggested choice.

At the bottom are Skip — I'll map manually and Continue. Clicking outside the window doesn't close it.

What to do.

  1. For each column, choose Custom Field to keep the values on each vendor, or Skip this column to leave them out.

  2. Click Continue.

Or click Skip — I'll map manually to close the window without deciding. Those columns then have an empty dropdown on the mapping page, and aren't imported unless you match them there.

What happens next. For each column you set to Custom Field, the Add custom field window opens, one column at a time (screen 6). Columns you skipped show Skip column (do not import) on the mapping page, with their values crossed out.

6. Add custom field

What you see. The heading Add custom field and the line This field will appear on each vendor record and can be exported via the custom report under the reports tab. Then:

  • Column — the column from your file.

  • Sample values — up to three values from it.

  • Field name (required) — filled in with the column name. Change it to the name you want to see on the vendor.

  • Cancel and Save, and an X at the top right.

What to do.

  1. Type the Field name you want.

  2. Click Save.

What happens next. A Custom Field Created message says Custom field "…" will be created during import. On the mapping page the column now shows your field name followed by (custom field) and an asterisk. The field isn't created yet. It's created when the import runs, and only if at least one imported row has a value in that column. If a vendor custom field with exactly that name already exists, PayHOA uses it instead of creating another.

If you click Cancel or the X, no field is set up. A column you were asked about in the previous window is left unmatched: its dropdown on the mapping page is empty, and it isn't imported unless you pick a field for it there.

7. Edit mapped vendor data: the mapping page

This is the page where you check everything. It shows your whole file as a table, with the PayHOA field each column is matched to and what will happen to each row.

What you see.

  • The heading Edit mapped vendor data.

  • A note at the top: AI analyzed the file, formatted your data, and matched columns. Review column mappings and see which records are new vs updates.

  • A Search rows box. Type any part of a name, city or other value to show only the rows that contain it. If nothing matches, the table is empty; click the X in the box to see every row again.

  • A summary line on the right, for example 6 records will be imported • 6 new. It can also list updating, no changes, skipped and invalid (skipped) counts (the invalid count is in orange). The first number counts the rows marked No changes as well as the new and updating ones. If every row matches a vendor that already has those details, it reads 2 records match your existing data. No changes will be made.

  • The table:

    • A Status column, with a badge for each row (see Row statuses).

    • One column for each column in your file. The header shows your column name, a small info icon (hover over it to see the limit, such as max 40 characters; 1099 Eligible and columns with no vendor field don't have one), an arrow, and under them a dropdown showing the PayHOA field the column is matched to. A red asterisk marks the required field, Vendor Name.

    • Every row of your file. An empty cell shows -. Long values are shortened; hover to see the whole value. 1099 Eligible shows the cell as it is in your file, such as Yes or No; other text, such as X, is shown as typed, with nothing to warn you that it turns 1099 eligibility off.

  • Upload different file at the bottom left and Start import at the bottom right.

  • Under the table, a key to any icons in use, such as Value updated, Mapped to existing entity, Custom field will be created when import completes. and Row won't be imported. Hover the icon for the reason. When every row is new there's no key. Mapped to existing entity is listed whenever a row matches a vendor you already have; no cell in a vendor import carries that icon, so you can ignore it.

The table is wider than the page. About four of your columns fit at a time, so scroll sideways to see the rest. The Status column and the vendor names scroll out of view as you go, so check one row at a time, or use Search rows to narrow the list first.

What to do.

  1. Read across the column headers, scrolling sideways to reach them all. Check that each of your columns is matched to the right field, especially any column the AI matched to a custom field (screen 8 shows how to change one).

  2. Read down the Status column. Make sure the rows marked New really are new vendors, and that the rows marked Updating are the vendors you meant to change (screen 10). Deal with any row showing a warning triangle (screen 9).

  3. When everything is right, click Start import.

Important: You can't edit a cell on this page. To fix a value, correct your file, click Upload different file, then Start fresh, and upload it again.

Warning: Start import is the point of no return. There's no confirmation window: the import runs as soon as you click.

To leave without importing: click Vendors (or anything else) in the left menu. Your file and column matches are kept, and the next time you open Import vendors you're asked whether to resume (screen 3). To throw the import away now, click Upload different file (screen 11).

Row statuses

Status

What it means

What happens when you import

New

No vendor has this name or email.

A new vendor is added.

Updating

The row matches a vendor, and at least one value is different.

That vendor is changed.

No changes

The row matches a vendor that already has these details.

Nothing changes.

Skipped

PayHOA couldn't read this row from the file.

The row is left out.

Warning triangle, no badge

The row has no vendor name, or a value is over its limit.

The row isn't imported, with one exception (see screen 9). Hover over the triangle to see why.

Note: Default Category and custom fields aren't compared on this page. A row that only changes a vendor's default category or a custom field shows No changes, but the change is still made when you import.

Note: A filled-in 1099 Eligible cell always counts as a change. A row that matches a vendor shows Updating whenever its 1099 cell says Yes or No, even if the vendor already has that setting and nothing else is different, and no cell on the row is marked as changed. In the picture above, the two Updating rows are identical to the vendors they match; the two No changes rows are too, but their 1099 cells are blank. This is harmless: a vendor that already has that setting isn't changed, and isn't counted on the Vendors updated card. To see what a row really changes, look for the orange info icon beside a value (screen 10).

When your file has more than one kind of row, a row of filters appears above the search box and table: All records, New, Updating, No changes, Skipped and Invalid, each with its count, for example All records (7), New (3), Updating (1), Invalid (3). Only the kinds your file has are shown. Click one to see just those rows.

8. Change which field a column goes to

What you see. Click the dropdown in any column header. The list opens at the field the column is matched to, with a tick beside it; scroll up and down for the rest. It has:

  • Skip column (do not import) at the top.

  • The vendor fields in four groups: General (Vendor Name, Nickname, Account Number, EIN / Tax ID, Mail Stop Code), Address (Address Line 1, Address Line 2, City, State, ZIP Code), Contact (Contact Name, Email, Website, Phone, Fax) and Accounting (1099 Eligible, Default Category). A field already used by another column is greyed out and marked (mapped).

  • Vendor Custom Fields: your existing vendor custom fields, any you've just added, and Create new custom field.

A column matched to one of your vendor custom fields shows the field's name followed by (custom field), for example Insurance ID (custom field). A column that PayHOA couldn't match has an empty dropdown. It isn't imported unless you pick a field for it.

What to do.

  • To change a match: pick the right field. If that field is greyed out, first set the column that's using it to something else.

  • To leave a column out: pick Skip column (do not import). The column fades and its values are crossed out.

  • To keep a column PayHOA has no field for: pick one of your vendor custom fields, or Create new custom field (screen 6).

What happens next. The table reloads for a moment and shows the values under the new match. Each change is saved as you make it.

Important: If you change which column is Vendor Name or Email, the New and Updating statuses aren't worked out again. They still reflect the columns as they were when the file was read. Click Upload different file, then Start fresh, and upload the file again. If the AI didn't find your name column at all, rename that column's header to "Vendor Name" in your file first.

Required fields are not mapped

If no column is matched to Vendor Name, a warning box appears above the table: Required fields are not mapped — The following required fields need to be mapped: Vendor Name. The summary line disappears, Start import is greyed out, and hovering over it shows Map all required fields before importing. The rows keep their badges. Open the dropdown above the column that holds your vendor names and pick Vendor Name.

9. Rows that won't be imported

What you see. A row with a problem has an orange warning triangle in the Status column instead of a badge. Hover over the triangle to read the reason. A row with a value that's too long is also greyed out, with its values crossed out; a row with no vendor name isn't. The summary line counts these rows as invalid (skipped), an Invalid filter appears, and the key under the table shows Row won't be imported. Hover the icon for the reason.

The reasons you can see here:

Reason shown

What's wrong

This row won't be imported — missing required field: Vendor Name.

The vendor name cell is empty.

This row won't be imported — Vendor Name is 58 characters. It must be 40 characters or fewer. Move extra text such as a DBA to Nickname.

The name is too long for a check.

This row won't be imported — Address Line 1 and Address Line 2 together are 60 characters. They must be 50 characters or fewer combined.

The two address lines together are too long.

This row won't be imported — Address Line 1 is 55 characters. It must be 50 characters or fewer.

One value is over its limit. The same message appears for any field, with that field's limit: 50 for an address line, 31 for ZIP Code, 255 for the others.

For a row that matches an existing vendor, a value that's already on the vendor isn't counted against the limit. Only values the row would change are checked.

What to do.

  1. Hover over each triangle and note the reason.

  2. Fix those rows in your file.

  3. Click Upload different file, then Start fresh, and upload the corrected file.

Warning: Don't import around the problem rows if there are many of them. Although the summary line calls them invalid (skipped), rows with a triangle count as failed when the import runs, and if more than half of your rows fail, PayHOA reports the whole import as Import failed (screen 14). Fix the file first.

Warning: One kind of row with a triangle is imported anyway. If a row has no vendor name but its Email belongs to a vendor you already have, the page says This row won't be imported — missing required field: Vendor Name, yet the import still updates that vendor with the row's other values. You can tell these rows apart because their cells carry the small change icons described in screen 10. Before you import, either fill in the vendor name on those rows, so they show as Updating, or delete them from your file. Then upload it again.

Some mistakes aren't flagged on this page at all: a misspelled Default Category (it becomes a new category), a misspelled State, a mistyped email, and the same new vendor listed twice (the second row only fails when the import runs). Check for these yourself.

10. Rows that update a vendor you already have

What you see. A row that matches an existing vendor shows Updating. This is what you want when you're using the importer to change vendors you already have. Each cell that would change has two small icons beside the new value:

  • A small orange info icon. Hover over it to see Previous value: and what the vendor has now (or (blank) if it's empty, as in the picture).

  • An X (Keep original value). Click it to leave that one value as it is on the vendor. The cell goes back to the current value (or - if the vendor has none) and the X becomes an undo arrow; click the arrow (Undo) to bring your change back.

Cells with no icons aren't changing, except a filled-in 1099 Eligible cell, which is applied without being marked (see the note under Row statuses). The key under the table shows Value updated.

What to do.

  1. Click the Updating filter to see only these rows.

  2. For each one, hover over the info icons and check that every change is one you want.

  3. Click the X on any single change you don't want. If you undo every change on a row, its status becomes No changes, and the Updating filter and the summary line change to match.

  4. If a row shows a change to Vendor Name, either only the capitals differ, or the row was matched by email. If it was matched by email, make sure it's the same vendor before you go on.

Note: No in the 1099 Eligible column turns 1099 eligibility off for a vendor that has it on. If that's not what you want, click the X on that cell, or leave the cell blank in your file.

To update vendors in bulk: upload a file with the vendor names and only the columns you want to change. Everything else on each vendor is left alone. For the whole job, from getting your current list out of PayHOA to checking the result, see Update existing vendors with the importer.

11. Upload different file?

What you see. Clicking Upload different file on the mapping page opens Upload different file? — This will discard your current import progress. You can start fresh with a new file. — with Cancel and Start fresh, and an X at the top right.

What to do.

  • Click Start fresh to discard this upload and its column matches. A Cleared pop-up, Previous import cleared. Ready for a new file!, appears at the top left and you're back on the upload page.

  • Click Cancel to stay on the mapping page.

Nothing has been added to your vendor list at this point, so there's nothing to undo.

12. Importing

What you see. When you click Start import, the table is replaced by a spinner, the heading Importing... and the line Please wait while we process your records. This may take a few moments. The steps at the top still show Mapping.

What to do. Wait, and keep the page open. Six vendors take about five seconds. Don't click Start import for the same file in another tab. Vendors are saved one row at a time, top to bottom. A long list, or one with many websites, takes longer because each logo is downloaded as its vendor is saved.

What happens next. The Import complete page (screen 13), or the Import failed message (screen 14).

13. Import complete

What you see. The steps at the top move to Complete. Under them is a check mark and the heading Import complete, with a brief Import Complete pop-up at the top left: Your data has been imported successfully. Then one card for each count above zero:

Card

What it counts

New vendors added

Vendors created.

Vendors updated

Existing vendors that were changed.

Vendors skipped

Rows PayHOA couldn't read from the file.

Vendor imports failed

Rows that weren't imported: the ones with a warning triangle, plus any that failed while saving.

Logos downloaded

Logos found from a website and saved.

If nothing needed changing, there are no cards. A note reads No vendors needed changes. Every row already matched.

If any rows failed, an error box headed Some rows could not be imported. lists the first 10 with the reason, as Row 3: A vendor named 'ABC Landscaping' already exists in this organization, then And 2 more. Row 1 is the first vendor in your file, so with a header row, Row 3 is line 4 of your spreadsheet.

At the bottom is Return to Vendors, which takes you back to the Vendors page.

Note: If you refresh this page or come back to it later, the same results are shown with slightly different card names: New vendors added, Vendors updated, Vendors unchanged, Logos downloaded, Rows skipped and Rows failed.

What to do.

  1. Note any failed rows and their reasons.

  2. Click Return to Vendors.

  3. Fix the failed rows in your file and import them again, or add those vendors by hand. Importing the whole file again is safe: vendors already in show as No changes, or as Updating if your file has a 1099 Eligible column, and end up with the same values either way.

The email. PayHOA also emails you a summary with the subject Vendors Import Complete, sent in your association's name. It lists the totals (Vendors Created, Vendors Updated, Logos Downloaded, Unchanged (No Changes), Rows Skipped, Rows Failed) and up to 50 of the rows that failed, each with its reason. Only you get it.

14. Import failed

What you see. If more than half of your rows fail, there's no Import complete page. After the Importing... screen you're returned to the mapping page with a red box above the filters: Import failed — Import failed: 4 of 7 rows failed (57.1% failure rate exceeds 50% threshold). A brief Import Error pop-up at the top left shows the same text. The table looks as it did before: the rows keep their New badges and triangles, the summary line still says how many records "will be imported", Start import is still blue, and nothing on the page says which rows failed or why.

Important: "Import failed" doesn't mean nothing was saved. Every row is tried before the failures are counted, so the rows that were fine have already been added or updated. In the import pictured above, both rows marked New were added to the vendor list. Nothing is rolled back, and no summary email is sent.

What to do.

  1. Don't click Start import again. This import is finished, and clicking it only shows Cannot transition from failed to reviewing.

  2. Go to Vendors and see which vendors were added.

  3. Work out why the rows failed. The usual causes are rows that had a warning triangle, a file where most rows have no vendor name (often the wrong column matched to Vendor Name), and vendors that already exist.

  4. Fix the file, open Import vendors again and upload it. A failed import isn't offered for resuming, so you start on the upload page. Rows that already went in show as No changes (or Updating, if your file has a 1099 Eligible column).

After the import

Where your vendors are. Click Vendors in the left menu. New vendors are on the Vendor List tab straight away.

What to check.

  • Open a few vendors and compare them with your file, especially names and addresses.

  • Addresses. A mailed check needs a complete, deliverable address: without one, the check is rejected when PayHOA sends it to be printed, and the payable comes back Declined with a message asking you to correct the vendor address. Checks go to the vendor's main address unless you enter a separate mailing address on the vendor.

  • States. Open any vendor whose state you weren't sure of and click Edit vendor. If State / province is empty, pick the right one and save. The Vendors page shows an imported state as you typed it (KY); the vendor form shows the same state by name (Kentucky).

  • New categories. Open your chart of accounts and look for expense categories you didn't expect. If a Default Category didn't match, PayHOA created it. Rename, nest or delete it as needed. See Add, edit, nest, delete and restore categories.

  • Default categories. Check that each vendor's Default category is an expense category, not an income category with the same name.

  • 1099 settings. Make sure 1099 eligible? is on for each vendor you'll file a 1099 for, and that their Vendor EIN is right. See File 1099s for your vendors.

  • Duplicates. If a vendor now appears twice, the name in your file didn't exactly match the one in PayHOA. Delete the one you don't want, or contact PayHOA support to combine two vendors that both have history.

What the import didn't do.

  • It didn't email or invite your vendors.

  • It didn't set up ACH. If your association has the PayHOA financial account, add each vendor's bank details. See Set up a vendor for ACH payments.

  • It didn't store W-9s. Upload each one under Documents on the vendor's page. See The vendor page: documents, notes and history.

  • It didn't create any payables, payments or ledger entries.

  • It didn't enter a separate mailing address or phone extension.

How to fix a mistake.

Mistake

Fix

A wrong value on a few vendors

Click ⋯ → Edit vendor info, correct it and click Save vendor.

A wrong value on many vendors

Correct your file and import it again. Matching vendors are updated. See Update existing vendors with the importer.

A value that should be empty

Edit the vendor. An import can't clear a field.

A vendor that shouldn't have been added

Click ⋯ → Delete vendor. See Add, edit and delete vendors.

A category that shouldn't have been created

Fix each vendor's Default category, then delete the category in your chart of accounts.

A custom field that shouldn't have been created

Manage it under Settings (the gear icon at the top right) → Custom Fields.

The wrong file imported altogether

There's no undo. Delete the vendors it added. If it changed many existing vendors and you can't tell what changed, contact PayHOA support.

If something goes wrong

Opening the importer

Message

What it means

What to do

You are not authorized to view the requested page

You don't have Read + write on the Vendors permission. You're sent back to the dashboard.

Ask an admin to give you Read + write on Vendors. Payables access alone isn't enough. See Give board members and staff access.

There's no New vendor button or Import vendors option

You have read-only access to vendors.

As above.

You have an import in progress

You started a vendor import earlier and didn't finish it.

Click Resume import to continue, or Start fresh to discard it.

Uploading the file

Message

What it means

What to do

Unsupported file type. Please upload a CSV, XLS, XLSX file.

The file isn't a CSV or Excel file.

Save or export it as CSV, XLS or XLSX. PDFs and links to Google Sheets aren't accepted.

File is too large. The maximum file size is 10MB.

The file is over 10 MB.

Remove columns you don't need, or split the list into smaller files and import them one at a time.

That file is empty. Please upload a file that contains data.

The file has nothing in it.

Check you picked the right file.

Could not detect column headers in the file. Please check the file format.

PayHOA found no column names in the first row.

Add a header row naming each column.

No data rows found in the file. Please check the file contains data.

The file has a header row and no vendors under it. In Excel, the vendors may be on a different sheet.

Add your vendors, or save the workbook with the vendor sheet open.

The first row of this file looks like data, not column headers. Add a header row naming each column, or uncheck "My file has headers", then upload it again. Otherwise that first record would be lost.

The first row looks like a vendor (numbers, emails or dates), not column names.

Add a header row, or untick My file has headers and upload again.

Failed to read CSV headers.

The first line of the CSV is blank.

Delete the blank line so the column names are on line 1.

Excel file is empty.

The sheet PayHOA read has nothing on it.

Save the workbook with the vendor sheet open.

Failed to process file. Please try again.

Something went wrong on PayHOA's side while reading the file.

Try again. If it happens twice, contact PayHOA support with the file and the time you tried.

Failed to process file. Check the file type and size, then try again.

The upload didn't get through, or took too long.

Check your connection and try again. If the file has a Website column and many rows, try it in smaller parts.

Any other Upload Error message

The file couldn't be opened as a spreadsheet. It may be damaged or password-protected, or have the wrong file extension.

Open it in Excel or Google Sheets, save it again as CSV, and upload that.

You do not have permission to import vendors for this organization.

Your Vendors permission was changed while you were importing.

Ask an admin for Read + write on Vendors.

On the mapping page

Message

What it means

What to do

Required fields are not mapped — The following required fields need to be mapped: Vendor Name

No column is matched to Vendor Name. Start import is greyed out (Map all required fields before importing).

Pick Vendor Name in the dropdown above the column that holds your vendor names.

This row won't be imported — missing required field: Vendor Name.

That row's vendor name is empty.

Add the name in your file and upload again, or leave the row out.

This row won't be imported — Vendor Name is 52 characters. It must be 40 characters or fewer. Move extra text such as a DBA to Nickname.

The name is too long to print on a check.

Shorten the name in your file and put the rest in Nickname.

This row won't be imported — Address Line 1 and Address Line 2 together are 62 characters. They must be 50 characters or fewer combined.

The two address lines are too long together.

Shorten the address, for example "Ste" for "Suite".

This row won't be imported — Address Line 1 is 55 characters. It must be 50 characters or fewer. (also Address Line 2, 50; ZIP Code, 31; every other field, 255)

One value is over its limit.

Shorten the value in your file.

A column's dropdown is empty

PayHOA couldn't match the column to a vendor field, or you cancelled Add custom field for it.

Pick a field, pick or create a custom field, or leave it. An unmatched column isn't imported.

A column shows a field name followed by (custom field) that you didn't choose

The AI matched the column to one of your existing vendor custom fields.

If it's the wrong field, pick another, or Skip column (do not import).

A field in the dropdown is greyed out with (mapped)

Another column is already matched to that field.

Change the other column first.

Failed to load mapping data

The page couldn't load your upload.

Refresh the page. If it still fails, open Import vendors again and choose Start fresh.

Failed to save mapping or Failed to save change

Your last change to a column match, or to a single value on an Updating row, wasn't saved.

Check your connection and make the change again.

When the import runs

Message

What it means

What to do

Import failed: 4 of 7 rows failed (57.1% failure rate exceeds 50% threshold)

More than half the rows failed. The rows that were fine have still been saved.

See screen 14. Fix the file and upload it again.

Row 3: A vendor named 'ABC Landscaping' already exists in this organization

Your file lists the same new vendor twice, or the vendor was added after you uploaded the file.

Remove the extra row. To update the existing vendor, upload the file again so the row is matched to it.

Row 3: Vendor name is required

The row has no vendor name.

Add the name in your file and import that row again.

Row 3: Vendor Name is 52 characters. It must be 40 characters or fewer. … (or another length message)

The row had a warning triangle on the mapping page.

Shorten the value in your file and import that row again.

Row 3: Vendor not found for update: …

The vendor this row matched was deleted after you uploaded the file.

Restore the vendor, or upload the file again to add it as new.

Cannot transition from failed to reviewing.

You clicked Start import on an import that has already failed.

Click Upload different file, then Start fresh, and upload your corrected file.

This import session can no longer be run — it may have already completed or failed. Upload the file again to start a new import.

The saved import can't be run again.

Upload the file again.

Some rows could not be imported.

Shown on Import complete with the first 10 failed rows.

Fix those rows and import them again.

Common questions

Do I have to use the sample file? No. Any CSV or Excel file with one row per vendor and a header row works. The sample just shows the columns PayHOA knows.

Will importing my list again create duplicates? No, as long as the vendor names in the file are the same as in PayHOA. Vendors that are already in show as No changes and aren't touched. If your file has a 1099 Eligible column they show as Updating instead, and end up with the same values. Either way it's safe to fix a few rows and upload the whole file again. A row whose name is spelled or punctuated differently shows as New and would add a second vendor. See How PayHOA decides a row is an update.

Can I change many vendors at once? Yes. Updating is one of the importer's two jobs. Upload a file with the vendor names and only the columns you want to change, such as new addresses, emails, tax IDs, 1099 settings or default categories. Only filled-in cells are changed. A blank cell never clears a value. See Update existing vendors with the importer.

I already imported my vendors. Can I import again just to add emails, phone numbers or tax IDs? Yes. Upload a file with the Vendor Name column and a column for each detail you're adding. PayHOA adds the details to the vendors with those names and doesn't add the vendors again. Columns you leave out and blank cells are left as they are. See Add missing vendor details from a file.

Can I export my vendors to a spreadsheet, change it and import it back? Yes. The Vendors page has no export, so run the Vendor Overview report under Reports and click Export CSV. Keep the Vendor Name column as it is, and delete the columns you aren't changing. See Steps to update vendors.

Can I rename a vendor with an import? Not reliably. A changed name no longer matches, so the row is added as a new vendor. Rename the vendor by editing it. See What you can't update this way.

Why did I get two of the same vendor? The names didn't match exactly. "ABC Landscaping LLC" and "ABC Landscaping" are two vendors to PayHOA. It also happens when the vendor had been deleted: deleted vendors aren't matched. Before importing, make the names in your file the same as the names in PayHOA.

Can I undo an import? No. Check the mapping page carefully before you click Start import. Afterwards, edit or delete vendors one at a time, or import a corrected file.

Does importing email my vendors? No. Vendors aren't contacted. Only you get an email, with the results.

Can I import bank details so vendors can be paid by ACH? No. Bank details are entered on each vendor. See Set up a vendor for ACH payments.

Can I import W-9s or mark W-9s as received? No. Upload each W-9 under Documents on the vendor's page. You can import the EIN / Tax ID and 1099 Eligible columns.

Can I import a separate mailing or remit-to address? No. The address columns fill the vendor's main address. Enter a different mailing address by editing the vendor.

Can I import a PDF vendor list? No. The vendor importer takes CSV, XLS and XLSX files only. Export the list as a spreadsheet from the system it came from.

How do I move my vendors from QuickBooks or another system? Export the vendor list from that system to Excel or CSV and upload it. You don't need to rename the columns; match them on the mapping page.

I manage several associations. Can I import one vendor list into all of them? Each association has its own vendor list. Switch to each association and import the file there.

I closed the page halfway through. Did I lose my work? No, as long as you'd reached the mapping page. Open Import vendors again and click Resume import. If you had already clicked Start import, check your vendor list and your email for the results first.

Why does a row say No changes when I changed its category? The mapping page doesn't compare Default Category or custom fields. The change is still made when you import.

Where did this new expense category come from? A Default Category in your file didn't match the name of any category, so PayHOA created it. See the warning under Your file.

Is there a limit on the number of vendors? The only limit is the 10 MB file size. Very long lists take longer to read, especially with a Website column.

What's next

Did this answer your question?