Skip to main content

Import the chart of accounts

The chart-of-accounts importer does two jobs:

M
Written by Michael Bollinger

The chart-of-accounts importer does two jobs:

  • It adds new categories and accounts. If you keep a chart of accounts in a spreadsheet, or you're moving from other software, you can load it into PayHOA from a file instead of adding each line by hand. One file can hold income and expense categories (with subcategories), assets, liabilities, equity accounts and bank accounts.

  • It updates the ones you already have. A row whose name matches a category or account in PayHOA changes that one instead of adding a second. Use it to add or change account numbers on your whole chart at once, move categories under a parent, or set starting balances, balance dates and classifications. One limit: PayHOA recognises a row by its name, so an import can change the number in front of a name and its capitalization, but not the words. See Update existing categories and accounts with the importer.

Don't use it for:

Before you start

  • Who can use it. Admins of the association only. In the chart of accounts, Import isn't in the Actions menu for board members or staff who aren't admins, even if they have Write on Budgets and can edit the chart of accounts. (This differs from Payments and Transactions, where the import button shows for people with Write but the importer still opens only for admins.)

  • Where it is. Click Budgets in the left menu, click Chart of accounts at the top of the page, then click Actions → Import.

  • File types and size. One CSV, XLS or XLSX file, up to 10 MB. There's no limit on the number of rows. In an Excel workbook only the sheet that was open when the file was last saved is read. PDFs and links to online spreadsheets aren't accepted; download the sheet as CSV or Excel first.

  • Sample file. The upload page has a Download the sample file link. It's a CSV with the columns PayHOA expects and 22 example rows.

  • What the AI does. PayHOA's AI Assistant looks at your column names and the first five rows to work out which column is which. That's all it does. It doesn't change your values, and it doesn't decide what's new and what's an update; PayHOA does that by comparing names. You check and correct the column matches before anything is saved.

  • What's created, updated and skipped. A row whose name matches an account you already have updates that account. A row that matches nothing adds a new account. A row with a problem is left out, and the rest still import. See "How PayHOA matches accounts you already have" below.

  • Emails and charges. Nothing is sent to owners and nothing is billed. You, the person who ran the import, get one summary email titled Chart of Accounts Import Complete.

  • No undo. Nothing is saved until you click Start import. After that there's no button that reverses an import. You fix it account by account. See "After the import".

On the older accounting version: the importer and every screen in this article are the same. What differs is what happens to starting balances afterwards. On the current version a starting balance is posted to your books as soon as the import finishes, with the other side in the Opening Balance equity account. On the older version the balance is saved on the account and shows on your balance sheet and general ledger when the ledger next updates (or when you click Update now); there's no Opening Balance account, and income and expense categories don't show a starting balance line on reports. See Accounting V2 and V1.

Your file

Use one row per category or account, with a header row naming each column. Your headers don't have to match the sample exactly. PayHOA matches columns by their name and contents, and you can correct any match on the next screen.

Sample column

Field in PayHOA

Required?

What to put in it

Example

If it's blank or wrong

Account Name

Account Name

Yes

The name of the category or account. Up to 255 characters, including the number if you add one.

Electric

Blank: the row isn't imported (Account name is required).

Account Code

Account Name (a second column)

No

Your account number. PayHOA has no separate number field, so it joins the code and the name with a dash. If you have this column, fill it in on every row.

5010

Blank: the row gets a warning triangle on the mapping screen (missing required field: Account Name), even though its name is filled in.

Type

Account Type

Yes

One of Income, Expense, Asset, Liability or Equity. Capitalization doesn't matter. See the list of other accepted words below.

Expense

Blank: the row isn't imported. Any other word: the row isn't imported (Account type "…" is not supported).

Parent Category

Parent Category

No

Income and expense rows only. The name of the top-level category this one sits under.

Utilities

Blank: the category is top-level. A name PayHOA doesn't have: a new top-level category with that name is created.

Starting Balance

Starting Balance

No

A number. $ signs and commas are fine. It can't be negative.

1,500.00

Blank: no starting balance on a new account; no change to an existing one. Text or a negative number: the row isn't imported.

Starting Balance Date

Starting Balance Date

No

The date the balance is as of. Use 2026-01-31 or month-first 1/31/2026.

2026-01-01

Blank on a new asset, liability or equity account: today's date is used. Blank on a new income or expense category: the balance is saved but not posted to your books. Blank on an account you already have: no change. A date PayHOA can't read, such as day-first 31/01/2026: the row isn't imported.

Account Classification

Account Classification

No

Asset and liability rows only. short-term or long-term. current and non-current also work.

long-term

Blank: a new account is Short-term; an existing one keeps what it has. On an income, expense or equity row, or any other word: the row isn't imported.

Routing Number

Routing Number

No

Asset rows only. The bank's 9-digit routing number. Fill it in only for a bank account, together with Account Number.

123456789

One without the other, or on a row that isn't an asset: the row isn't imported.

Account Number

Account Number

No

Asset rows only. The bank account number, 4 to 17 digits. This is not your chart-of-accounts number.

000012345678

See Routing Number.

Account Nickname

Account Nickname

No

Asset rows with bank details only. The name the bank account goes by in PayHOA. Up to 255 characters.

Operating Checking

Blank: the Account Name is used.

A column the importer has no field for, such as a description or notes column, is left out. The chart-of-accounts importer can't create custom fields or tags.

Account types

All five types import. Each kind of row lands on its own tab of the chart of accounts:

Type in your file

Other words PayHOA accepts

Where it goes

Income

Revenue, Sales

Income tab

Expense

Cost, COGS, Operating Expense

Expenses tab

Asset

Assets, Fixed Asset, Current Asset, Bank, Bank Account, Checking, Checking Account, Savings, Savings Account, Cash, Money Market, Money Market Account

Assets tab. With a routing number and account number, it's created as a bank account.

Liability

Liabilities, Current Liability, Long-term Liability, Payable

Liabilities tab

Equity

Capital, Retained Earnings, Owner's Equity, Owners Equity

Equities tab

Anything else stops the row from importing, including Expenses (plural), Other Income, Other Expense, Other Current Asset, Accounts Receivable, Accounts Payable and Credit Card. If you exported your chart from other accounting software, change those to one of the five words before you upload. A credit card or a loan is a Liability.

Your file must have a type column. PayHOA doesn't work the type out from the account number.

You can't change a row's type on the importer's screens. If a type is wrong, correct it in your file and upload it again. If you'd rather not put balance-sheet accounts or bank accounts in the file, leave those rows out and add them by hand. See Assets, liabilities, equity and bank accounts in the chart.

Account numbers

PayHOA has no separate account-number field; the number is part of the name. You have two choices:

  • Keep the number in its own column. Match both that column and your name column to Account Name. PayHOA joins them in the order the columns appear in your file, with a dash: 5010 - Electric. Give every row a number: a row with an empty cell in that column is marked as missing its Account Name on the mapping screen and isn't counted for import.

  • Type the number at the start of the name, for example 5010 Electric.

Only match a column to Account Number if it holds real bank account numbers. Account Number and Routing Number are for bank accounts.

Parent categories and subcategories

  • Put the parent's name in the subcategory's Parent Category cell, with or without its number: Utilities and 5000 - Utilities both find the same parent. A number on its own (5000) doesn't; PayHOA would create a new category called 5000.

  • List each parent on its own row above its subcategories. If a subcategory comes first, PayHOA creates the parent from the name in the Parent Category cell, and the parent's own row then only sets its name; a starting balance on that row is ignored.

  • A parent that isn't in your file and isn't in PayHOA is created for you as a top-level category of the same type as the subcategory.

  • A parent must be a top-level category of the same type. PayHOA has two levels, so don't name a subcategory as a parent.

  • Parent Category is ignored on asset, liability and equity rows. Balance-sheet accounts can't be nested.

How PayHOA matches accounts you already have

When it reads your file, PayHOA compares each row with your chart of accounts:

  • It matches on the name and the kind of account. An income row is compared with your income categories, an expense row with your expense categories, an asset row with your assets, and so on. An Insurance expense and an Insurance income are different accounts.

  • Capitalization, extra spaces and a leading account number are ignored. 5010 - Electric, 5010: Electric, 5010 Electric and electric all match a category called Electric, and Electric in your file matches 5010 Electric in PayHOA. A leading number between 1900 and 2100 followed by a space is treated as a year, so 2026 Reserve Study isn't shortened. 5010-Electric with no spaces isn't split either.

  • The number isn't matched by itself. Two rows with different numbers and the same name are the same account.

  • A match is an update. The account takes the name from your file, including the number, so you can add account numbers to an existing chart by importing it with a code column. It also takes the parent, starting balance, date and classification from the row. A blank cell never clears what's already there.

  • No match is a new account.

  • A bank account is also matched on its numbers. If an asset row has a Routing Number and Account Number and its name isn't one of your assets, PayHOA looks for a bank account with those numbers. If it finds one, it updates that account's name, starting balance, date and classification instead of adding a second one. The numbers are only compared when the import runs, so on the mapping screen this row shows New; the Import complete page counts it as updated.

  • The same account twice in one file doesn't create two. The first row creates it; the second only sets its name.

  • Deleted categories and accounts aren't matched. A row with the same name as something you deleted adds a new one, and the deleted one stays deleted. If you want the old one back with its history, restore it first, then import. See Add, edit, nest, delete and restore categories.

  • A row can't change an account's type. To move something from expense to income, add the new category and recategorize.

Important: Leave PayHOA's own system categories and accounts out of your file: Prepayments, Account Credits, Discounts, Bad Debt, Platform Fees, Absorbed fees, Accounts Receivable, Funds in Transit, Undeposited Funds, Prepaid Revenue, Accounts Payable, Opening Balance, Net Income, Retained Earnings, Excluded and Treasury Balance. A row with one of those names is treated as an update to the system account: it can rename it or put a starting balance on it. If your association doesn't have that system account yet, the row adds an ordinary account with the same name, and you end up with two once PayHOA creates its own. A row that would change Treasury Balance, or put a starting balance on Net Income, fails. See Chart of accounts overview for what each one is.

Starting balances

A starting balance is the amount in the account on the day you start using PayHOA. It's posted against the Opening Balance equity account, the same as when you type it on the chart of accounts page.

  • Enter each balance in one place only. If you've already typed a bank account's starting balance on Transactions, don't put it in the file as well.

  • Use the same date on every row, usually the day before your first month in PayHOA.

  • If the file changes the starting balance or date of an account you already have, PayHOA reverses the old opening entry and posts the new one.

  • When a row puts a balance on an asset, liability or equity account you already have, and the row has no Starting Balance Date, the account keeps the Balance as of date it has, and the balance is posted on that date. For an account that was added with no starting balance, that's the day it was added. The mapping screen doesn't warn about the missing date, so fill it in.

  • When a row is matched to a bank account you already have by its routing and account number, and the row has no Starting Balance Date, that account's balance date moves to today. Always fill in the date on bank account rows.

  • Owner balances don't belong in this file. Accounts Receivable is filled by the invoices on your units.

See Assets, liabilities, equity and bank accounts in the chart for where each kind of starting balance goes.

Update existing categories and accounts with the importer

The importer isn't only for setting up. A row that matches a category or account you already have changes it, so one file can change many of them in one go.

When to use it

  • Add account numbers to your whole chart, or change the numbers you have.

  • Move many categories under a parent, for example Electric, Water and Gas under Utilities.

  • Set or correct starting balances, balance dates or classifications on your assets and liabilities.

  • Tidy capitalization or spacing in many names at once.

If you only want to add account numbers, or starting balances on accounts that have none, there's a short recipe with the smallest file that works: Add account numbers or starting balances from a file.

It can't change the words of a name. See Names and numbers: worked examples.

Steps

  1. Click Budgets in the left menu, click Chart of accounts, then click Actions → Export All. Use Export All, not Export, which downloads only the tab you're on. A CSV downloads, named chart-of-accounts followed by today's date, with every tab in it: income categories first, then expense categories, assets, liabilities and equities. Its columns are Section, Name, Labels, Balance and Status. It includes everything you've deleted, even when Show deleted is off, so it can be much longer than the chart you see on the page. See Export the chart of accounts.

  2. Save a second copy of the export and leave it untouched. It's your record of the chart as it was.

  3. Get the working copy ready. Don't upload the export as it is; see the warning below for what happens if you do.

    • Delete the rows that must not be imported:

      • every row with Deleted in Status (the others say Active);

      • every row with anything other than Hidden in Labels. Those are PayHOA's own system categories and accounts. A system category has System Account there; a system account has its system name, such as Accounts Receivable, Undeposited Funds or Opening Balance. Go by the Labels column, not the name: a system account that was renamed or given a number, such as 1310 - Accounts Receivable, still has its label;

      • the Treasury Balance row if you have one.

    • Delete the rows you aren't changing. A row left in with nothing changed does no harm and shows No changes, but a shorter file is easier to check.

    • Rename the Section column to Type and change its values: Income Categories to Income, Expense Categories to Expense, Assets to Asset, Liabilities to Liability and Equities to Equity.

    • Rename the Name column to Account Name. Subcategories are listed under their parent and start with two dashes and a space, as in -- Electric. Remove the dashes and the space from each one.

    • Delete the Labels, Balance and Status columns.

    • Add a column for each thing you want to change: Parent Category, Starting Balance, Starting Balance Date or Account Classification. The export doesn't have them. See "Your file" above for what goes in each.

  4. Make your changes. Fill in or change only the cells that should change, and leave the rest blank. Leave Type and the words of each Account Name exactly as they are. Those two are how PayHOA recognises the row. A subcategory stays under its parent when its Parent Category cell is blank.

  5. On the Edit mapped account data screen, check the columns first. With the headers above, Type is matched to Account Type, Account Name to Account Name, and the columns you added to the fields of the same name. See Check the column matches.

  6. Check the Status column and the summary line, for example 10 records will be imported • 1 new • 3 updating • 6 no changes. Each row you meant to change should read Updating, not New. Click the New filter: it should list only accounts you meant to add. If a row you meant to update is there, its name or type no longer matches. Correct the file and upload it again.

  7. On each Updating row, point to the orange info icon in a changed cell to see Previous value:, for example Previous value: 5010 - Electric. A category that was top-level and is being moved under a parent shows Previous value: (blank) in its Parent Category cell. To leave one value as it is, click the X (Keep original value) beside it. The orange icon goes, a changed name goes back to the old name, and the X becomes an Undo arrow. If that was the row's only change, the row now reads No changes and the counts at the top change to match. See Check the rows.

  8. Click Start import. It saves straight away.

  9. Open the chart of accounts and check some of the rows you changed.

Warning: Don't upload the export as it is, and don't leave its Balance column in your file. Balance holds each account's balance today, not its starting balance, and PayHOA matches it to Starting Balance. It also matches Section to Account Type and Name to Account Name, so Start import is available. Here's what an unedited export then does:

  • Assets and liabilities are imported. Assets and Liabilities are accepted as types. An account whose balance today differs from its starting balance reads Updating, and the import would replace its starting balance with today's balance. An account you deleted reads New: the import would add it again, with its last balance as a starting balance. System accounts aren't left out either: a row named Accounts Receivable reads Updating.

  • Income, expense and equity rows are left out. Each has a warning triangle: Account type "Income Categories" is not supported. Use income, expense, asset, liability, or equity. A row with a negative balance also says Starting balance can't be negative.

  • Labels and Status aren't matched to anything, so nothing stops the deleted rows and the system rows.

How PayHOA decides a row is an update

PayHOA decides once, when it reads your file, in this order:

  1. Type. It looks only among accounts of the row's type: an income row among your income categories, an expense row among your expense categories, an asset row among your assets, a liability row among your liabilities, an equity row among your equity accounts.

  2. Name. Within that type, it looks for a name that's the same once capitalization, extra spaces and a number at the front are ignored. Deleted categories and accounts aren't looked at.

  3. Match or no match. A match makes the row Updating, or No changes if nothing differs. No match makes it New.

  4. Bank accounts only. When the import runs, an asset row with a Routing Number and Account Number that matched no asset by name is compared with your bank accounts. If one has the same numbers, the row updates that account. The mapping screen will have shown this row as New.

Nothing else is compared. The number in front of a name isn't, so two rows with different numbers and the same name are the same account. If two of your own categories differ only by their number, a row matches one of them and you can't choose which.

  • A row that matches: an Expense row named 5010 - Electric matches your expense category Electric.

  • A row added as new by mistake: an Expense row named Electricity, or an Income row named Electric. Neither matches the expense category Electric, so each adds a second category.

For every detail of the rule, see How PayHOA matches accounts you already have.

Names and numbers: worked examples

On a match, the account takes the name exactly as it is in your file. That's what lets you add, change or remove a number.

You want to

In PayHOA now

In your file

What happens

Add a number to a category that has none

Electric

5010 - Electric in Account Name. Or a code column with 5010, to the left of a name column with Electric, both matched to Account Name.

Updating. The category becomes 5010 - Electric.

Change a number

5010 - Electric

6010 - Electric in Account Name

Updating. The category becomes 6010 - Electric. Previous value: shows 5010 - Electric.

Change a number with a code column

5010 - Electric

A code column with 6010, to the left of a name column with Electric and no number

Updating. The category becomes 6010 - Electric. Both cells show the orange icon, and Previous value: shows 5010 - Electric.

Change a number, done wrong

5010 - Electric

A code column with 6010 beside a name column that still says 5010 - Electric

New. The two would be joined as 6010 - 5010 - Electric, which matches nothing, and you'd have both categories. The mapping screen shows the two cells as they are in your file, not the joined name, so New is the only sign.

Remove a number

5010 - Electric

Electric

Updating. The category becomes Electric.

Tidy capitalization

pool supplies

Pool Supplies

Updating. The category becomes Pool Supplies.

Rename a category

Electric

Electricity

New. A second category, Electricity, is added. Electric stays as it is, with its transactions and budget amounts.

  • Starting from the export, change the number inside the name. Type it at the front of the Account Name cell. Only add a separate code column when none of the names in the file has a number, or after you've taken the numbers out of the names. A code column must be to the left of the name column, because the two are joined in file order.

  • If you use a code column, fill it in on every row. A row with an empty code cell gets a warning triangle, This row won't be imported — missing required field: Account Name., even though its name cell is filled in, and it's counted as invalid (skipped). Take rows that have no number out of the file, or put the numbers in the names instead.

  • Write a number as 5010 - Electric: number, space, dash, space, name. That form always works. With only a space between them, as in 5010 Electric, the number must be all digits, at least three of them, and not between 1900 and 2100, which PayHOA reads as a year. 5010-Electric with no spaces isn't split.

  • If your file leaves the number off, the number is removed. To keep 5010 - Electric as it is, leave the name as it is, or click the X on that cell on the mapping screen.

  • To rename a category, do it on the chart of accounts page. It keeps its transactions, budget amounts and history. See Edit or rename a category.

What an update changes, and what it leaves alone

Field

What an update does

Account Name, including its number

Replaced with the name exactly as it is in your file.

Parent Category (income and expense categories)

Replaced when the cell is filled in: the category moves under that parent. The parent must be a top-level category of the same type, or the row fails. A parent name PayHOA doesn't have is added as a new top-level category.

Starting Balance

Replaced when the cell is filled in, including with 0.

Starting Balance Date

Replaced when the cell is filled in.

Account Classification (assets and liabilities)

Replaced when the cell is filled in. The mapping screen doesn't mark it: the cell has no orange icon and no X, and if it's the only thing that differs, the row shows No changes. The new classification is still saved. To leave a classification alone, leave the cell blank in your file.

Routing Number and Account Number

Never changed. They're only used to find a bank account you already have, or to create a new one.

Account Nickname

Not used on a row matched by name. On a bank account matched by its numbers, it becomes the account's name on the chart of accounts.

Account Type

Never changed.

Order in the list, budget amounts, transactions, whether the account is deleted, bank connections

Never changed by an import.

A blank cell never clears a value: the account keeps what it has. In this importer every field is either replaced or left alone. Nothing is filled in only when blank, and nothing is added to.

When a starting balance or its date changes, PayHOA reverses the old opening entry and posts the new one against Opening Balance. On the current accounting version that happens as soon as the import finishes. On the older version the new balance is saved on the account and shows on your balance sheet when the ledger next updates. An income or expense category that has no balance date yet needs a Starting Balance Date in the same row, or its balance is saved but not posted.

What you can't update this way

Check before you import

Important: New and Updating are worked out once, when your file is read. Changing a column's match on the mapping screen doesn't work them out again. If Account Name or Account Type is over the wrong column, rename the headers in your file to Account Name and Type, click Upload different file and upload it again.

Warning: There's no undo. Keep the untouched copy of your export. It has the old names and nesting, but not starting balances, balance dates or classifications. Note those down before you change them.

Important: Leave PayHOA's system categories and accounts out of the file. A row whose name matches one, for example an asset row named Accounts Receivable, updates it too: it can rename it or put a starting balance on it. The full list is under How PayHOA matches accounts you already have.

Warning: Changing a starting balance changes your balance sheet, for every date from the balance date on. Only change one to correct it. Run the balance sheet before and after, and check that Opening Balance holds the other side. See Balance sheet and trial balance.

Important: When a row is matched to a bank account by its routing and account number, and the row has no Starting Balance Date, that account's balance date moves to today. Fill in the date on every bank account row.

Important: Don't put a Parent Category on a category that has subcategories of its own. PayHOA has two levels, and the chart of accounts page doesn't allow this, but the importer doesn't check it.

The import, screen by screen

A tracker at the top of the importer shows three steps: Upload, Mapping and Complete.

1. Open the importer

What you see. The Chart of Accounts page, with the Budgets and Actions buttons at the top right. The Actions menu lists Import, Export and Export All.

What to do.

  1. Click Budgets in the left menu.

  2. Click Chart of accounts at the top of the page.

  3. Click Actions, then Import.

What happens next. The Import Chart of Accounts page opens. If you started an import earlier and didn't finish it, the You have an import in progress window opens on top of it; see screen 3.

Tip: Before a big import, click Actions → Export All first. The CSV is a record of your names and current balances as they were, which helps if you need to put names back. It doesn't list starting balances, balance dates or classifications; if you're changing those, note the old values down first.

2. Import Chart of Accounts: upload your file

What you see.

  • A back arrow at the top left. It returns you to the chart of accounts.

  • The step tracker, with Upload highlighted.

  • The heading Import Chart of Accounts 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: Upload a CSV or Excel file; AI analyzes your import data (Review column mappings and be sure it all looks right.); Finish the import. Under the first step: Not sure how to lay it out? and the Download the sample file link.

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

  • The My file has headers checkbox, ticked.

What to do.

  1. If you don't have a file yet, click Download the sample file. Replace the example rows with your own.

  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 an account; PayHOA then calls the columns Column 1, Column 2 and so on.

  3. Drag your file into the box, or click Browse files and choose it. The upload starts straight away.

Warning: The sample file's example rows include starting balances and two example bank accounts with routing and account numbers. Delete every example row before you import, or they'll be added to your books.

What happens next. A window opens while PayHOA reads the file (screen 4). If the file is the wrong type, over 10 MB or empty, a message says so and nothing is uploaded; see "If something goes wrong".

3. You have an import in progress

This window only appears when you open the importer and an earlier chart-of-accounts import of yours was left unfinished.

What you see. The heading You have an import in progress and Would you like to pick up where you left off, or start a new import? Below it:

  • Import type: Chart of Accounts

  • Records: the number of rows in that file, for example 22 rows

  • Current step: Mapping

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

and two buttons: Start fresh and Resume import.

What to do.

  • Click Resume import to go back to the mapping screen (screen 5) with your column matches as you left them.

  • Click Start fresh to throw the unfinished import away. You'll see Previous import cleared. Ready for a new file! for a moment at the top left, and the upload page is ready for a new file.

Neither button saves anything to your chart of accounts. An unfinished import belongs to the person who started it; another admin opening the importer won't see it. An import that has finished, or that ended with Import failed, isn't offered here; the importer opens on the empty upload page.

4. PayHOA reads your file

What you see. A small window with a sparkle icon, a message that changes every few seconds (Uploading your file…, Reading your columns…, Reading your file…, Lining up your columns…), your file's name, and a progress bar labelled Step 1 of 2 · Uploading, then Step 2 of 2 · Reading & mapping your file, with a percentage at its right end. The window has no buttons and can't be closed.

What to do. Wait. A small file takes about 10 seconds. If it runs past about 40 seconds, the message changes to Taking a little extra care with this one…; keep waiting.

What happens next. The window closes and the mapping screen opens. If PayHOA can't read the file, the window closes, an error message explains why, and you stay on the upload page.

At this point your file and its rows are stored with your unfinished import. Nothing has been added to your chart of accounts.

5. Edit mapped account data: check the columns and the rows

This one screen does two jobs: you confirm which column is which, and you review every row before it's imported.

What you see, top to bottom.

  • The heading Edit mapped account data.

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

  • A Required fields are not mapped warning, only when no column is matched to Account Name or Account Type. It names the missing fields.

  • A row of filter buttons across the page, each with a count in brackets, for example All records (8), New (7), Updating (1). The others are No changes, Skipped and Invalid. They appear when your file has more than one kind of row, and only for the kinds it has. A file whose rows are all new has no filter buttons.

  • A Search rows box. It searches every value in the table.

  • A summary line to the right of the search box, for example 22 records will be imported • 18 new • 3 updating • 1 no changes • 2 invalid (skipped). The first number leaves out the invalid rows. If every row matches an account that already has the same details, it says … records match your existing data. No changes will be made.

  • The table. The first column is Status. After it comes one column for each column in your file. Each heading shows your file's column name, an arrow, and a list showing the PayHOA field it's matched to. An empty cell shows a dash. The table scrolls sideways and up and down inside its own frame.

  • Upload different file (bottom left) and Start import (bottom right).

  • A legend under the table explaining the icons in use.

There's no back arrow on this screen. While the table is loading, or after you change a column match, grey placeholder rows show for a moment.

Check the column matches

Open the list above any column to see its choices. The list is longer than its box; scroll inside it to see the rest.

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

  • Account: Account Name* and Account Type*. The asterisk marks a required field.

  • Hierarchy: Parent Category.

  • Balance: Starting Balance and Starting Balance Date.

  • Classification: Account Classification.

  • Bank Account: Routing Number, Account Number and Account Nickname.

The field the column is matched to now has a tick. A field that's already matched to another column is greyed out and marked (mapped). Account Name is the exception: you can match it to two columns, such as a code and a name. Both headings then show a merge icon, and the legend says Multiple columns will be combined into this field.

A column PayHOA couldn't place shows Select a field.... It's left out of the import unless you pick a field for it. A column you set to Skip column (do not import) stays in the table with its values greyed out and struck through.

  1. Read across the headings and check each match against the values underneath.

  2. To change a match, open the list and pick the right field.

  3. To leave a column out, pick Skip column (do not import).

  4. Make sure Account Name and Account Type are both matched. Until they are, Start import is greyed out; point to it to see Map all required fields before importing.

Important: New and Updating are worked out once, when the file is first read. They aren't worked out again when you change a column match. If PayHOA picked the wrong column for Account Name or Account Type, don't fix it here. Rename the headers in your file to Account Name and Type, click Upload different file, and upload it again.

Check the rows

The table shows your file's own values. Dates show as MM/DD/YYYY and balances as dollar amounts; a date PayHOA couldn't read shows as you typed it. You can't type in the cells; to change a value, correct your file and upload it again.

The Status column shows what will happen to each row:

Status

What it means

New

A new category or account is added.

Updating

An account you already have is changed. Cells that will change show an orange info icon. When a code column and a name column are both matched to Account Name, both cells show it.

No changes

The row matches an account that already has these details.

Skipped

PayHOA couldn't read this row from the file. It isn't imported.

Warning triangle

The row has a problem and won't be imported. Point to the triangle to see why, for example This row won't be imported — Starting balance date must be a valid date. A row with a bad value, such as that date, is also greyed out and struck through. A row with a blank required cell, such as missing required field: Account Type, shows the triangle only. Both kinds are counted as invalid (skipped) and listed under Invalid.

Icons inside the cells:

Icon

Legend text

What it means and what you can do

Orange info icon with an X

Value updated

On an Updating row, this value differs from what PayHOA has now. Point to the icon to see Previous value:. Click the X (Keep original value) to leave that one value as it is. The X turns into an undo arrow; click it to apply the change again.

Green info icon

Mapped to existing entity

In the Parent Category column: the parent is a category you already have.

List icon with a plus, and an X

New entity to be created during import

In the Parent Category column: PayHOA has no category with this name yet. It shows for a parent that's a row in your own file, and also for a misspelt parent. Point to it to see New entity "…" will be added. Click the X (Don't create this entity) to import the row as a top-level category instead.

Merge icon in a heading

Multiple columns will be combined into this field.

Two columns are joined into Account Name.

Warning triangle

Row won't be imported. Hover the icon for the reason.

See the Status table above.

What to do.

  1. Click New and check that nothing in the list is an account you already have under a slightly different name. If it is, the import would add a second one. Change the name in your file to match and upload it again.

  2. Click Updating and point to each orange icon to see what would change. Click the X on any change you don't want.

  3. Look down the Parent Category column for the list icon. If it's on a name that should have matched an existing category, the parent is misspelt in your file.

  4. Click Invalid and read each reason. Either correct your file and upload it again, or carry on without those rows. You can't correct a row on this screen. When you upload the corrected file, the triangles and the Invalid filter are gone. Always correct rows with a blank Account Type first: PayHOA still tries to save them, and if they're more than half of the rows it tries, the import ends with Import failed (screen 9).

  5. When the summary line shows what you expect, click Start import.

Warning: Start import saves straight away. There's no confirmation window and no undo.

Leaving this screen. You can leave at any time before you click Start import. Your file, your column matches and your X choices are kept. The next time you open the importer, the You have an import in progress window (screen 3) offers to pick it up.

6. Upload different file?

What you see. After you click Upload different file: the heading Upload different file? with an X at its top right, the line This will discard your current import progress. You can start fresh with a new file., and the buttons Cancel and Start fresh.

What to do.

  • Click Start fresh to throw this import away and go back to the upload page. You'll see Previous import cleared. Ready for a new file! for a moment at the top left.

  • Click Cancel or the X to stay on the mapping screen.

Nothing has been saved to your chart of accounts either way.

7. Importing...

What you see. A spinner, the heading Importing... and Please wait while we process your records. This may take a few moments. The tracker still shows Mapping.

What to do. Stay on the page. Allow up to a minute, even for a short file: a six-row file can take about 50 seconds.

What happens next. An Import Complete: Your data has been imported successfully. message appears and the Import complete page opens. If more than half of the rows fail, you're returned to the mapping screen with an Import failed banner instead; see screen 9.

8. Import complete

What you see. The tracker on Complete, a check mark, the heading Import complete, and one card for each count above zero. A card with a count of 1 uses the singular, for example Asset account created:

  • Income/expense categories created and Income/expense categories updated

  • Asset accounts created and Asset accounts updated (bank accounts are counted here)

  • Liability accounts created and Liability accounts updated

  • Equity accounts created and Equity accounts updated

  • Chart of accounts skipped: rows left out because they had a problem on the mapping screen. If you reopen this page later, the same card is labelled Rows skipped.

  • Account imports failed: rows that were tried and couldn't be saved. Later labelled Rows failed.

Rows that showed No changes are counted as updated.

If some rows failed, a box above the cards says Some rows could not be imported. and lists the first 10 with the reason, as Row 3: …, then And 2 more. Row 1 is the first account in your file, so with a header row, Row 3 is line 4 of your spreadsheet.

What to do. Click Return to Chart of Accounts.

What happens next. You're back on the Chart of Accounts page with the new rows in place. PayHOA also emails you a summary titled Chart of Accounts Import Complete, with the same counts and up to 50 of the failed and skipped rows.

9. Import failed

What you see. The mapping screen again, with a red banner under the AI banner: Import failed and a line such as Import failed: 3 of 4 rows failed (75.0% failure rate exceeds 50% threshold). The same line also shows for a few seconds at the top left, titled Import Error.

This happens when more than half of the rows PayHOA tried to save failed. Rows that were left out for a problem PayHOA found when it read the file, such as a bad date, don't count. Rows with a blank Account Type do: they're tried, and they fail, even though the mapping screen had counted them as invalid (skipped). In the picture, the file had five rows: one good row, three with a blank type and one with a bad date. The mapping screen said 1 record will be imported • 1 new • 4 invalid (skipped), but four rows were tried and three failed.

Important: The rows that didn't fail have been saved. An import that ends with Import failed still adds and updates the accounts that were fine. Nothing is rolled back, and no summary email is sent.

What to do.

  1. Open the chart of accounts and see what was added.

  2. Correct the rows that failed in your file. The most common cause is a blank Account Type.

  3. Go back to the importer and upload the corrected file. Rows that already went in show as Updating or No changes, so they aren't added twice.

Clicking Start import again on the failed import doesn't work; it shows Cannot transition from failed to reviewing. Upload the file again instead. A failed import isn't kept as an unfinished one: the next time you open the importer, it starts on the empty upload page.

After the import

Where the new records are. Click Budgets → Chart of accounts. Income and expense categories are on the Income and Expenses tabs, with subcategories under their parents. Assets and bank accounts are on Assets (bank accounts have a bank icon), liabilities on Liabilities, equity accounts on Equities.

A code column and a name column are joined with a dash, as in 9101 - Grounds. New rows aren't slotted in by number. Straight after the import, new categories and assets are at the top of their tab; categories from an earlier import may have moved to the bottom of the list. A new liability sits in name order. If you can't see a new row, type part of its name in the search box. An asset or liability imported with no starting balance shows $0.00, with Balance as of set to the day of the import.

What to check.

  • Names and nesting. Open each tab and compare it with your file. Look for a parent you didn't expect; that's a misspelt Parent Category.

  • Order. Drag rows into the order you want on reports. See Chart of accounts overview.

  • Duplicates. Search for a few names. If you see two categories with almost the same name, one came from the file and one was already there. Recategorize and delete the extra one. See "Merge two categories" in Add, edit, nest, delete and restore categories.

  • Starting balances. Run the balance sheet as of your start date and check the bank, asset and liability balances, and that Opening Balance holds the other side. See Balance sheet and trial balance.

  • Bank accounts. On the Assets tab, check each bank account appears once, with a bank icon.

What was done for you.

  • New categories are ready to use on transactions, invoices and recurring charges, and appear as rows on your budget.

  • Starting balances are posted against Opening Balance.

  • A parent category named in your file but missing from PayHOA was created.

  • An asset row with a routing number and account number was created as a bank account.

What wasn't done.

  • Your existing transactions, invoices and payables aren't touched. They keep the categories they had. If the import renamed a category, they show the new name, including for past periods.

  • No budget amounts are set or changed. New categories start with no budget amount.

  • No bank feed is connected and no transactions are downloaded for an imported bank account. See Connect and manage bank accounts.

  • Nothing is deleted. Accounts that are in PayHOA but not in your file stay as they are.

  • Reports aren't rebuilt. They pick up the new names, accounts and starting balances the next time you run them.

Fix a mistake. There's no undo, so fix what's wrong directly:

What went wrong

How to fix it

A category or account you didn't want

Delete it. To remove several, tick them and click Delete selected. Deleting is reversible. See Add, edit, nest, delete and restore categories.

A wrong parent, starting balance or date, or a wrong number in front of a name

Click the row on the chart of accounts and edit it, or correct your file and import it again; matching rows are updated, not added twice.

A misspelt name

Rename it on the chart of accounts. Importing the corrected spelling would add a second account, because a row is matched by its name.

A starting balance that shouldn't be there

Edit the account and set Starting balance to 0, or import the row again with 0. The opening entry is reversed.

A bank account you didn't want

Delete its asset on the Assets tab. That deletes the bank account too. See Assets, liabilities, equity and bank accounts in the chart.

A category was renamed and you want the old name

Rename it on the chart of accounts. If you exported with Export All first, the old names are in that file.

A system account was renamed or given a balance

Contact PayHOA support with the account name and what changed.

If something goes wrong

Uploading the file

Message

What it means and what to do

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

Save the file as CSV, XLS or XLSX. PDFs, Numbers files and links to online spreadsheets aren't accepted; download the sheet as CSV or Excel first.

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

Remove unused sheets, columns and formatting, or save the sheet as CSV.

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

The file has no content. Check you picked the right one.

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

The first row is blank. Put your column names in row 1, or untick My file has headers.

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

The file has headers but no accounts under them. In Excel, make sure your accounts are on the sheet that's open when you save.

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.

Do what the message says.

Failed to read CSV headers. or Excel file is empty.

The file couldn't be opened as a spreadsheet. Open it, save it again as CSV and upload that.

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

Something went wrong on PayHOA's side or with your connection, or you've been signed out. Refresh the page and try again. If it keeps happening, contact PayHOA support with the file and the time you tried.

You are not authorized to view the requested page

You opened the chart of accounts importer from a link or a bookmark and you're not an admin of the association. (Import isn't in the Actions menu for anyone who isn't an admin.) Ask an admin to run the import.

On the mapping screen

Message

What it means and what to do

Required fields are not mapped The following required fields need to be mapped: Account Name, Account Type

No column is matched to the named field. Pick it in the list above the right column. If your file has no type column, add one and upload the file again.

Map all required fields before importing (on a greyed-out Start import)

The same.

A table full of Select a field...

The AI Assistant couldn't match your columns this time. Pick a field above each column yourself, or click Upload different file and try again.

Failed to load mapping data

Refresh the page. Your unfinished import is still there.

Failed to save mapping or Failed to save change

Your last change wasn't saved. Refresh the page and make it again.

No matching records found

Your search or filter hides every row. Clear the Search rows box or click All records.

Rows that won't be imported

Point to the warning triangle in the Status column. The message starts This row won't be imported — and ends with one or more of these:

Reason

What to do in your file

Account name is required

Fill in the name.

missing required field: Account Type (or Account Name)

Fill in the blank cell.

Account type "Other Income" is not supported. Use income, expense, asset, liability, or equity

Change the type to one of the five words. See "Account types".

Starting balance must be a number

Remove text such as n/a or TBD. Leave the cell blank for no balance.

Starting balance can't be negative

Enter the balance as a positive number. A loan or credit card balance is a positive number on a Liability row.

Starting balance date must be a valid date

Use 2026-01-31 or month-first 1/31/2026. Day-first dates such as 31/01/2026 aren't read.

Routing and account numbers apply only to asset/bank accounts. Remove them, or set this row's account type to asset

Clear the routing and account number, or change the type to Asset. If the number is really your chart-of-accounts number, match that column to Account Name instead of Account Number.

A routing number was provided without an account number. Both are required to import a bank account

Fill in both, or clear both.

An account number was provided without a routing number. Both are required to import a bank account

The same. This also happens when a chart-of-accounts number column was matched to Account Number by mistake.

The routing number must be 9 digits

Check the number with your bank. Leading zeros lost by Excel are put back for you.

The account number must be between 4 and 17 digits

Remove spaces and dashes.

Account classification "…" is not supported. Use short-term (current) or long-term (non-current)

Use short-term or long-term, or leave it blank.

Account classification only applies to asset and liability accounts

Clear the classification on income, expense and equity rows.

Account Name is 300 characters. It must be 255 characters or fewer (also Parent Category and Account Nickname)

Shorten the value.

This row could not be read from the file and was skipped

The row is damaged in the file. Retype it on a new line and upload again.

When you click Start import

Message

What it means and what to do

Import failed: 6 of 10 rows failed (60.0% failure rate exceeds 50% threshold)

More than half the rows failed. The rest were saved. See screen 9.

Cannot transition from failed to reviewing.

This import already ended with Import failed. Click Upload different file and upload your corrected file.

Cannot commit session in status: importing. Must be in 'reviewing' status.

The import is already running, usually because it was started twice. Wait a minute, then check the chart of accounts before trying again.

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

Do what the message says. Check the chart of accounts first, so you know what's already in.

Row 5: Account type is required

The Account Type cell is blank on that row.

Row 7: Invalid parent category. Parent must be a top-level category.

The row updates an existing category, and its Parent Category is a subcategory, a category of the other type, or a deleted category. Use a top-level category of the same type.

Row 7: Cannot set a category as its own parent.

The row's Parent Category is its own name. Clear it.

Row 9: This account is managed by Stripe Treasury and cannot be edited.

The row matches your Treasury Balance account, which is set by your PayHOA financial account. Remove the row from your file.

Row 9: Starting balances cannot be set on Net Income; it is computed from the current fiscal year.

Remove the starting balance, or the whole row. Put prior years' earnings on Retained Earnings.

Row 4: Category not found for update: … (or FixedAsset, Liability, Equity)

The account was deleted after PayHOA read your file. Upload the file again.

Common questions

Do I have to use the sample file? No. Any CSV or Excel file with a header row works. PayHOA matches your columns to its fields and you can correct the matches. The sample shows which columns are understood.

Can I import assets, liabilities, equity and bank accounts, or only categories? All of them. Set the Type to Asset, Liability or Equity. An asset row with a Routing Number and Account Number becomes a bank account. You can also leave them out and add them by hand; see Assets, liabilities, equity and bank accounts in the chart.

Where do my account numbers go? Into the name. Match your code column and your name column both to Account Name and they're joined as 5010 - Electric. There's no separate number field in PayHOA.

Will importing create duplicates of the categories PayHOA started me with? Not if the names match. A row is matched to an existing category of the same type by name, ignoring capitalization and any leading number, and updates it. The category then takes the name exactly as it is in your file, so Landscaping in your file renames 5004 Landscaping to Landscaping; click the X on that cell on the mapping screen to keep the old name. A different name, such as Lawn Care, is added as a new category. Rename the starter category first, or delete the ones you don't use after the import.

Can I change many categories or accounts at once? Yes. Export your chart with Actions → Export All, get the file ready, change the cells you want and import it. Rows that match what you already have show Updating and change those accounts. You can add or change account numbers, move categories under a parent, and set starting balances, dates and classifications. You can't change the words of a name this way. See Update existing categories and accounts with the importer.

My chart is already in PayHOA. Can I import again just to add account numbers or starting balances? Yes. The file needs only a Type column, an Account Name column and what you're adding: the number typed in front of each name, or Starting Balance and Starting Balance Date columns. Rows that match what you have show Updating and nothing is added twice. See Add account numbers or starting balances from a file.

Will importing my chart again create duplicates? Not for rows whose name and type still match: they show Updating or No changes. A row whose name you reworded, or whose type you changed, is added as a new account and the old one stays. Check the New filter on the mapping screen before you click Start import. See How PayHOA decides a row is an update.

Can I import the same file twice? Yes. The second time, every row matches what the first import created and shows No changes or Updating. Nothing is added twice.

Can I use the importer to rename or renumber my whole chart? You can renumber it. Import a file with the same names and the new number at the front of each one, such as 6010 - Electric; the rows show Updating. You can also correct capitalization. You can't change the words of a name this way, because the name is what PayHOA matches on: Electricity in your file doesn't match Electric, so it's added as a new category and Electric stays. Rename those on the chart of accounts page. See Names and numbers: worked examples.

Can a row move a category under a different parent? Yes. Put the new parent's name in Parent Category. The row shows Updating. A blank Parent Category doesn't move a subcategory to the top level; do that on the chart of accounts page.

Does it delete accounts that aren't in my file? No. The importer only adds and updates.

I deleted a category. Will importing the same name bring it back? No. It adds a new category with that name and leaves the old one deleted. To get the old one back, restore it on the chart of accounts page first. See Add, edit, nest, delete and restore categories.

Does importing change my existing transactions or my budget? No. Transactions keep their categories and budget amounts stay as they are. A renamed category shows its new name everywhere, and new categories appear as empty rows on your budget.

Can I undo an import? No. Before you click Start import you can leave or click Upload different file and nothing is saved. Afterwards, delete or edit the accounts it added. See "Fix a mistake" above.

Can I import a chart of accounts exported from QuickBooks or other software? Yes, with two changes first: make sure there's one row per account with a header row, and change each account's type to Income, Expense, Asset, Liability or Equity. Types such as Other Expense, Accounts Receivable and Credit Card aren't recognized. Leave out the accounts PayHOA keeps itself, such as accounts receivable, accounts payable and retained earnings.

Can two admins import at the same time? Each admin's unfinished import is separate, but both would be adding to the same chart. Have one person do it.

What's next

Did this answer your question?