All Collections
Account Trees
Account Tree: Mapping Accounts
Account Tree: Mapping Accounts

Map your chart of accounts to the Account Tree structure of headers and sub-headers you've created for different reporting layouts.

Shem Bogusz avatar
Written by Shem Bogusz
Updated over a week ago

Account Trees in Calxa provide a truly flexible structure for mapping your chart of accounts from your accounting system to suit many different reporting requirements. You can regroup, rearrange and summarise your accounts, plus restructure the Profit and Loss and Balance Sheet layouts.

Tips 💡: See Account Tree: Create Structure to create the tree and add headers, sub-headers, Calculations and KPIs before mapping your accounts to that structure.

You can also Export and Import an Account Tree which creates the structure and maps your detail accounts.

  1. Navigate Reports -> Report Tools -> Account Trees

    Settings -> Organisation Settings -> Account Trees

  2. From the selected tree dropdown select the tree you would like to edit.

    Animation selecting tree from dropdown

View Options

Filter Organisations

If you've got more than one organisation you can filter which organisations accounts should be displayed when mapping for this Account Tree.

Shared accounts

Use the Shared accounts toggle to display accounts from multiple organisations as a merged list where one item represents the same account from multiple organisations.

Search accounts

Type in the Search accounts field to filter the list of accounts that match any part of the search text.

Expand all / Collapse all

Use the BULK ACTIONS menu to expand or collapse all headings in the list of accounts.

Show inactive / Hide inactive

Use the BULK ACTIONS menu to show or hide your inactive accounts in the list of accounts.

Select all checkbox

Use the select all checkbox to select all accounts that are currently visible in the view.

Tip: 💡use the select all checkbox in combination with the filter and search options to do bulk selections on specific groups of accounts.

Move to Tree (Mapping Accounts)

Move accounts from left to right. Accounts in the left column will be excluded from reports while accounts mapped to the tree structure on the right will be included in reports using this account tree.

  1. Tick the checkboxes on the accounts you want to map.

  2. Click MOVE TO TREE and choose a target location.

    Tip: 💡you can also drag and drop accounts, but this can only be done on a single account.

  3. Remember to SAVE CHANGES when you complete mapping all the required accounts.

New Accounts

Accounts that are added after you first create an Account Tree will be marked as New. New accounts can appear when syncing with your accounting system or if you add a new account for a manual organisation. To ensure you don't accidently exclude accounts from your reports all new accounts will be included in reports under their own headers, highlighting that you need to map them to the tree.

Use the SHOW NEW option to only show new accounts. You either need to remove the New tag to exclude them from reports or map them to the tree to include them in the correct position.

Auto-allocate selected

This method should only be used in a consolidated group where you already have the same accounts nominated. For example, you might have added a new organisation with a similar chart of accounts. If you select all and use the BULK ACTIONS -> Auto-allocate selected this will merge all the same accounts by allocating to the same position in the tree as the other organisations.

Note: 💬 accounts that don't match already allocated accounts will remain unmapped after clicking auto-allocate selected. You will then need to map those manually.

Did this answer your question?