Finance

Importing Accounts

Bulk-upload a Chart of Accounts from a spreadsheet — migrate from another system or set up a new business in minutes.

The Chart of Accounts import lets you create many accounts from a spreadsheet in one action. Use it when migrating from another accounting system, setting up a new entity with a known structure, or adding a large batch of accounts at once.

Import Chart of Accounts — drop the file, match the four columns, review the preview, fix refused rows, import.

Navigate to: Finance → Chart of Accounts → Import

Accepted Formats

Format	Extension	Notes
CSV (Comma-Separated Values)	.csv	Most compatible. Column headers must be in the first row.
Excel Workbook	.xlsx	The first sheet in the workbook is used.
Excel Legacy	.xls	The first sheet is used.

Columns

Column	Required?	Format / Values
Account Name	Yes	Free text. The name that appears in the list and on every report.
Type	Yes	Must match an account type name exactly as it appears in the app — e.g. "Cash", "Accounts receivable", "Operating Expenses". The full list is on Account Types & Hierarchy. An unknown value fails that row ("Account type not found").
Description	No	Free text description of the account's purpose.
Sub Account	No	The name of an existing account to file this one under as its parent.

💡TIP

Click Download Template in the modal before building your file. It contains the headers and sample rows in the expected format — keep the column order and names.

Import Workflow

Open the modal

Click Import on the Chart of Accounts page. The "Import Chart of Accounts" modal opens on its Upload step with a drop zone and the template download.

Upload your file

Drop the .csv, .xlsx or .xls file, or pick it from your device. It is parsed immediately; a file that cannot be read shows an upload error and you can try again.

Review the preview

The Preview step shows every row as the system read it. Rows that fail validation are flagged with the reason — most often a Type that does not match an account type name, or a missing Account Name.

Resolve errors

Fix the source file and upload again, or remove the failing rows from the preview so only valid rows are imported.

Import

Confirm the import. The accounts are created and appear immediately in the list with a Custom badge.

What the Import Does Not Do

Limitation	Why	What To Do
Does not set the statement group or element	The import matches Type only; the IFRS statement group is not inferred from it	Open each imported account (edit) and pick its element and statement group so it lands in the right section of the Balance Sheet or P&L
Does not import opening balances	Balances are posted, never imported with the chart	After importing accounts, use Opening Balances (customers and vendors) and a manual journal against Opening Balance Equity for the rest
Does not assign centers	Locations are set per account	After import, edit each account to add its Locations if you use center restrictions
Does not create sub types	Only Account Name, Type, Description and Sub Account are read	Set the Sub Type from the account's edit modal

✅NOTE

The import creates accounts only. It does not post any transactions — every imported account starts with a zero balance.

Type Values

The Type column must use one of these names, spelled exactly as in the app:

Element	Type values
Asset	Cash · Accounts receivable · Inventory · Prepayments · Short-term Investments · Other Current Assets · Fixed assets · Intangible Assets · Long-term investments · Other Long-term Assets
Liability	Accounts payables · Accruals · Tax Payable · Short-term Loans · Other Payables · Other Current Liabilties · Long term debts and leases · Deffered tax liabilities · Provisions · Other Non-current Liabilties
Equity	Share Capital · Retained Earnings · Other Equity Items
Income	Operating Income · Non-operating Income
Expense	Cost of sales · Operating Expenses · Non-operating expenses

Common values from other systems and their Trabalance equivalent:

Common Import Value	Trabalance Type
Bank	Cash
Current Asset	Other Current Assets
Fixed Asset	Fixed assets
Trade Debtors	Accounts receivable
Trade Creditors	Accounts payables
VAT Control	Tax Payable
Revenue	Operating Income
COGS	Cost of sales
Overheads	Operating Expenses

Chart of Accounts — the classification system every report draws from
Custom accounts — creating, editing and disabling your own accounts
Account types & hierarchy — the five elements and what sits beneath them
Importing journals — bulk-load entries from a spreadsheet
Opening balances — starting your books at the right position