Upload your chart of accounts from a CSV to add lots of accounting codes at once, update existing codes, or replace your whole list. Your codes then appear in the Accounting Code drop-down when you map categories. To change just one or two codes, it's quicker to add, edit or delete them individually.
Before you start
You will need:
- Owner, Admin or Accountant access
- A manual chart of accounts. CSV upload isn't available if your business is connected to Xero, MYOB AccountRight, QuickBooks, NetSuite or Business Central. Manage your codes in your accounting software instead.
- A CSV that matches our template: two columns, Account_ID and Account_Name, with up to 200 rows and a file size of up to 100KB.
Steps
To upload your chart of accounts:
- Go to Settings > Chart of Accounts.
- Click Manage accounting codes in the top right.
- In the Accounting codes panel, click Upload a CSV.
- Click Download template to get the standard format. Replace the example rows with your own Account_ID and Account_Name values, then save the file as a CSV.
- If you already have accounting codes, choose how the file changes them:
- Add and update codes — codes in the file are added, and any existing codes with the same Account_ID are renamed. All other codes stay as they are.
- Replace all codes — your current list is deleted and replaced by the file.
- Drag and drop your CSV into the upload area, or click choose from your files.
- Weel checks your file and shows what will change before anything is saved. For example: "3 added · 1 renamed · 40 unchanged. Nothing removed."
- Click Update accounting codes, or Replace accounting codes if you chose to replace.
What happens next
A banner at the top of the Accounting codes panel confirms what was added, updated or removed. Your codes are available straight away in the Accounting Code drop-down, so you can map them to your categories.
Important: If you choose Replace all codes, any category mapped to a removed code loses its accounting code. Nothing in that category will export until you map it to another code.
If your upload doesn't work
File must be a CSV and match our template
Check the file is saved as a .csv and has exactly two columns, Account_ID and Account_Name.
File must be smaller than 100 KB
Split the file or remove rows you don't need. You can upload up to 200 rows at a time.
We couldn't import this CSV. Please try again.
Your file was fine, but the upload didn't finish. Try again, and contact Support if it keeps happening.
Things to remember
- Match your accounting software exactly — Weel can't check codes against your accounting system, and mismatched Account IDs or names can cause errors when you export.
- Use Add and update for regular changes — it never removes codes, so your existing category mappings stay in place.