Yes, you can do this with a file. If your categories and accounts are already in PayHOA, a short spreadsheet can put account numbers on them, or starting balances on accounts that have none. An import adds to what you have and doesn't make copies, as long as PayHOA recognizes each row. The file needs only the two columns that identify a row, plus what you're adding. A blank cell changes nothing.
Only an organization admin can import. The importer is under Budgets → Chart of accounts → Actions → Import.
What you need in the file
To add account numbers, two columns are enough. The number goes in front of the name, because PayHOA has no separate number field:
Type | Account Name |
Expense | 5010 - Electric |
Income | 4010 - Clubhouse Rental |
Asset | 1050 - Petty Cash |
Two things identify the row:
Type: Income, Expense, Asset, Liability or Equity.
Account Name: the words of the name exactly as PayHOA has them. Capitals and extra spaces don't matter. A changed word does: the row is added as a second category.
Write number, space, dash, space, name. See worked examples.
If your numbers are in their own column, put it left of the name column. With the headers Account Code and Account Name, PayHOA matches both to Account Name by itself and joins them as 5010 - Electric. Each heading then shows a merge icon, and on an Updating row both cells have the orange icon. Every row needs a code: a row without one gets a warning triangle and isn't counted for import. No name in the file may already contain a number: that row reads New. Typing the number inside the name is safer.
To add starting balances, use four columns, and fill in both the balance and the date:
Type | Account Name | Starting Balance | Starting Balance Date |
Asset | Petty Cash | 250.00 | 2026-12-31 |
Liability | Roof Loan | 48,000.00 | 2026-12-31 |
Every type can take one, categories included. A balance can't be negative. Write dates as 2026-12-31 or month-first 12/31/2026.
Important: Fill in the date. With a blank date, or no date column, an asset, liability or equity account keeps the Balance as of date it has now, and the balance is posted to your books on that date. For an account that was added with no starting balance, that's the day it was added, not today and not your start date. The mapping screen doesn't warn you about the missing date. A category with no date gets a balance that isn't posted to your books at all.
See Starting balances.
The easiest way to get types and names right is to start from Actions → Export All on the same page, then tidy it:
Delete rows with Deleted in Status, or with something other than Hidden in Labels.
Rename Section to Type and change its values to the five words above.
Rename Name to Account Name, and remove the two dashes and the space in front of each subcategory.
Delete the Labels, Balance and Status columns, and the rows you aren't adding to.
Steps
Export and tidy your chart as above. Keep a second, untouched copy. See the full steps.
Add what's missing. Type each number in front of its name, or fill in the balance and date. Change nothing else.
Upload the file under Actions → Import. See Upload your file.
Check the columns. Type should sit under Account Type and Account Name under Account Name. See Check the column matches.
Check the Status column. Every row you're adding to should read Updating, and the line above the table should say the same, for example 4 records will be imported • 3 updating • 1 no changes. See Check the rows.
Point to each orange icon to see Previous value:. Click the X beside a change you don't want.
Click Start import. It saves straight away. The Import complete page then shows a count, for example Income/expense categories updated 4. Rows that read No changes are counted in it.
Click Return to Chart of Accounts and check a few of the rows you changed.
What you'll see before you import
Updating: what you want. A number or balance added where there was none reads Updating here, not No changes. The changed cell has an orange info icon. Point to it to see what PayHOA has now, for example Previous value: Electric, or Previous value: 0.00 for a balance added where there was none.
New: wrong. PayHOA didn't recognize the row and would add a second category or account, because the type or the words of the name differ. Correct the file and upload it again.
No changes: the row already has that number or balance.
When the file has more than one kind of row, filter buttons such as All records (4), Updating (3) and No changes (1) appear above the table.
What gets added, and what doesn't
In PayHOA now | What the import does |
A name with no number | The number is added. Transactions and budget amounts stay. |
A name with a number | Replaced by the name in your file. A different number changes it. No number removes it. |
No starting balance | The balance and date are saved and posted against Opening Balance. With no date in the file, it's posted on the account's current Balance as of date. |
A starting balance already | Replaced when the cell is filled in, even with 0. The old opening entry is reversed. |
A blank cell in your file | Nothing changes. |
Anything that isn't in your file | Untouched. |
A filled-in Parent Category column moves a category under that parent. See Parent categories and subcategories. An import can't change the words of a name. See Edit or rename a category.
Watch out for
Warning: There's no undo. Keep the untouched export. It has the old names, but not starting balances.
Important: A file that adds numbers can also remove them. A name with no number in your file takes the number off a category that has one. Such a row reads Updating, and Previous value: shows the numbered name. Delete the rows that already have their number, or leave those names as exported.
Warning: For starting balances, "add" can become "overwrite". Delete the export's Balance column: it holds today's balance, not the starting balance. Leave a cell blank rather than typing 0. On the mapping screen, Previous value: 0.00 means the account had no starting balance. Another amount means it has one: click the X on the balance cell and the date cell to keep it.
Important: Leave PayHOA's system categories and accounts, such as Accounts Receivable, out of the file. They're the export rows with something in Labels. A row that matches one changes it too. To number one, rename it by hand. See the full list.
Common questions
My chart of accounts is already in PayHOA. Can I import again just to add account numbers? Yes. Import a file with a Type column and an Account Name column, with each number in front of its name, as in 5010 - Electric. PayHOA recognizes each row by its type and the words of its name, and adds the number to the category you already have.
Will it create duplicates? Not when the type and the words of the name are the same as in PayHOA. Such a row reads Updating on the mapping screen. A row that reads New would add a second category or account, so correct your file and upload it again.
Do I have to include every column, or every category, again? No. The file needs only Type, Account Name and the columns you're adding. Anything that isn't in the file is left as it is, and a blank cell changes nothing.
Some accounts already have a starting balance. Will the import overwrite it? Yes, if that row's Starting Balance cell is filled in, even with 0. Leave the cell blank for those accounts. On the mapping screen, Previous value: shows the balance an account has now, and the X beside it keeps that balance. There's no undo.
