Skip to main content
Try for free

Chart of Accounts

Use the Account List to see your chart of accounts, add an account under the right parent, set how it reports, or load a whole chart from a spreadsheet.

Updated Nov 9 2026

Before you start

  • Account List is under Accounting > Chart/Ledger and needs the Accounting role (or Admin). Creating and editing accounts also needs Accounting.
  • Every account sits under one of six top-level accounts: Assets, Liabilities, Equity, Revenue, Expenses and Other Income And Expense. You can't add another top-level account.
  • Importing a chart uses Admin > APIs & More > Data Import, which needs the Can View API & Import Submenu permission (the API Access role by default).
  1. Find an account

    1. Go to Accounting > Chart/Ledger > Account List and click Submit. Only the six top-level accounts show, even though the count above the table (Displaying 1 - 86 of 86) includes every account.
    2. Click Show All Sub Accounts to open the whole tree.
    3. To jump to one account, start typing its name or number in Account, pick it from the list, and click Submit. Choices read (number) - Name [#id]; the #id is the Account ID column.
    4. Click an account name to open its Edit Ledger Account screen.
  2. Create an account

    1. On Accounting > Chart/Ledger > Account List, click Create Account.
    2. In Account Parent, pick the account the new one belongs under. Several accounts can share a name (two WO Expenses, for example), so check the number in brackets.
    3. Type the Account Name and the Account Number.
    4. Click Create. Cetec briefly shows "Account created." and lists the new account under its parent. The Account filter is now set to that parent, so clear it before you search for something else.
  3. Set how the account reports

    1. On Accounting > Chart/Ledger > Account List, click the account name. The Edit Ledger Account screen opens.
    2. Fill in Description and, if one fits, Account Type.
    3. For a bank account, fill in Bank Account Ref and Routing #. Printed checks drawn on this account use them in the bank line at the bottom of the check.
    4. Click Update. Cetec shows "Account Updated".
  4. Import a chart of accounts

    1. Go to Admin > APIs & More > Data Import. The page is headed Import Data To Cetec ERP. Use this, not Accounting > Chart/Ledger > Import, which imports journal entries.
    2. In Import Type, choose Chart Of Accounts. The Available Import Columns panel lists the columns under Required Columns, Suggested Columns and Optional Columns (open the last two to see them); click Download Template for a blank file.
    3. Fill in one row per account. Required: Account Name (account_name), External Key (external_key, your own unique id for the account) and Parent External Key (parent_external_key, the external key of the parent account). Suggested: Account Description, Account Type. Optional: Account Number, Bank Account Number, Routing Number.
    4. Rows for the six top-level accounts leave Parent External Key empty; they update the existing top-level account rather than create a new one.
    5. Leave the Import Options boxes (Update Related Data, Delete Related Data, Create Ledger Entries) unticked for a new chart. Click Choose File, pick the file, and click Import File. The Validate button and the preview appear only after the upload. Click Validate and fix any rows listed under Validation/Import Results.
    6. Click Import.

Related

How-tos
Blog Posts
Docs