Chart of Accounts Interface
This page explains the buttons and fields of the Accounts tab of Accounting Setup in Grid View and Tree View, how VAT is treated and its warnings. How the Chart of Accounts is organised is explained on Understanding the Chart of Accounts.

Buttons Explained
| Button | Description |
|---|---|
| Add/Edit | Adds new entries or edits existing ones. |
| Save | Saves any changes. |
| Actions | Changes multiple records. The options are:
|
| Output | Export: Exports the list in .xlsx, .htm or .csv format. |
| Menu | Layout |
| Add Default Accounts | Creates the main categories (e.g. Sales, Assets, Expenses) needed for a Chart of Accounts. Available only if no accounts exist yet. |
| Grid View / Tree View | Switches between the Grid View (spreadsheet format) and the Tree View (accounts nested under their financial statements). The + and – icons expand or collapse the Tree View. |
| Notes | Shows or hides the account notes. Grid View only. |
Fields Explained: Grid View

| Field | Description |
|---|---|
| Field Chooser (*) | Add or remove columns. |
| ID | The system-generated number for the entry. |
| Status | The account’s status: Active or Archive. |
| Parent | The parent financial statement (Statement of Profit or Loss or Statement of Financial Position). |
| Account | The account name. |
| Code | The account number (optional). |
| Lookup | The account’s lookup name (that is, the name entered when using the account in a transaction). ⚠️ Warning: If no lookup is entered, the account cannot be selected when creating transactions. |
| Type | The type of account (e.g. Asset, Expense). |
| Order ID | The order in which the account appears on the applicable financial statement in its group. |
| Default | Select the account’s default:
|
| Currency | Select a currency (bank accounts only). |
| Created | The date on which the entry was created. |
| Updated | The date on which the entry was last updated. |
| Updated By | The user who last updated the entry. |
| Level | A number indicating the nesting level (e.g. Statement of Financial Position > Assets > Current Assets > Bank is level 4). |
Fields Explained: Tree View
Fields marked in blue (✎) can be edited.

| Field | Description |
|---|---|
| Field Chooser (*) | Add or remove columns. |
| ID | The system-generated number for the entry. |
| Account | The account name. |
| Code | The account number. An account number is optional, but it helps with bank imports if you use the numbers as references when making or receiving payments. |
| Report | A code that shows the account’s report section (e.g. Summary, Section). |
| Lookup | The account’s lookup name (that is, the name entered when using the account in a transaction). ⚠️ Warning: If no lookup is entered, the account cannot be selected when creating transactions. |
| Type | The type of account (e.g. Asset, Expense). |
| Default | Select the account’s default:
|
| Bank Profile | Select the bank profile of the bank account. For the bank import to work, the account number must be part of the Lookup in the same format as on the bank statement (see the screenshot above). |
| Currency | Select a currency (bank accounts only). |
| ParentID | The system-generated number for the account’s parent. |
| Status | The account’s current status: Active or Archive. |
| Order ID | The system-generated number for the account’s order in its section. |
| Created | The date on which the entry was created. |
| Updated | The date on which the entry was last updated. |
| Updated By | The user who last updated the entry. |
| Level | A number indicating the nesting level (e.g. Statement of Financial Position > Assets > Current Assets > Bank is level 4). |
| Note | Enter a note about the account. |
A context menu (also opened by right-clicking an entry). The options differ depending on whether you clicked a Heading, an account on the Statement of Profit/Loss, or an account on the Statement of Financial Position.
|
How VAT Is Treated
If your business charges and claims VAT, reports show the VAT-exclusive amounts, except for these accounts:
- Receivables (the total of all customer accounts)
- Payables (the total of all supplier accounts)
- Bank accounts
The VAT Control account records the VAT portion of transactions where VAT Input or Output categories were used:
- VAT Input +: Debits the VAT Control account.
- VAT Input –: Debits the VAT Control account with a negative amount.
- VAT Output +: Credits the VAT Control account.
- VAT Output –: Credits the VAT Control account with a negative amount.
- VAT Payment: Debits the VAT Control account (Cr Bank). Use the VAT Type VAT 100%.
- VAT Refund Received: Credits the VAT Control account (Dr Bank). Use the VAT Type VAT 100%.
Once the payment is made, the account should be zero. For example, if the balance of the account at the end of July was a credit of 21 550.20, a payment of 21 550.20 must be made. That payment debits the account to bring it to zero (excluding transactions during August).
Warnings
Warnings appear at the top of the screen, highlighted in orange, when information is incomplete. Warnings are refreshed when you click Save (button).
- Mandatory Account Defaults not assigned: These defaults are mandatory:
- Receivables: Totals all the customer accounts on the financial reports.
- Payables: Totals all the supplier accounts on the financial reports.
- Retained Income: Posts the profit or loss to the Statement of Financial Position as calculated on the Statement of Profit or Loss.
- VAT Control: Required if you are registered for VAT.
- WHT Control: Required in countries where WHT is compulsory, such as Thailand.
- Bank: A currency is not assigned to the bank account. Applies if you use multiple currencies: each bank account must have a currency.
- Duplicates: Duplicate names, codes or lookups in the same group.
- Blank Names or Lookups: An account has no name or no lookup.