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.
In this help article we look specifically at editing your existing structure and using Bulk Edit mode to re-map accounts within the existing structure.
Headers make up the main structure of the Profit and Loss and Balance Sheet layouts. They will help you create a hierarchy where you map your chart of accounts and later add calculations or KPIs.
Click the settings cog in line with the header you would like to edit.
Set header properties and click APPLY CHANGES
Location: the header will be added as a sub-header/child in the the selected location.
Account type: when adding to the root level where location is Profit and Loss or Balance Sheet you can set an Account Type. All sub-headers will inherit this account type. The account type property is used by report account type filters and also determines if values are displayed as negative or positive. For example, an expense account in an income type header will be displayed as a negative value.
Number: numbers are used for ordering accounts in your account tree.
Header name: the name that will be displayed on reports.
Summary only: toggle on if you do not wish to see the detailed account values added to this header.
Note: 💬 to add a new header click ADD->Header and set the properties as above.
Calculation rows allow you to insert running totals or other sub-totals like Gross Profit or Net Surplus.
Click the edit pencil next to calculation row you would like to edit.
Set the calculation properties and click ADD CALCULATION
Location: the calculation row will be shown after the details of the selected header. For example, in a standard P&L layout the Gross Profit calculation is added to the Cost of Sales header to display it after your Cost of Sales details.
Label for calculation: the label that will be displayed on your reports. For example, 'Gross Profit'.
Formula: to build a formula start typing in the formula area and use the auto-complete suggestions or insert using the running total, components and operators buttons.
RUNNING TOTAL: auto-creates a formula representing the running total of all headers in the tree up to this point.
COMPONENTS: use account headers or other calculations as variables in your calculations.
OPERATORS: maths operators like plus and minus.
Bulk Edit Mode
Bulk edit mode allows you to select and map multiple accounts that are already allocated in the tree to new header locations.
Click BULK ACTIONS and select Enter bulk edit.
Use a combination of Search and BULK ACTIONS to filter and Select all or click the checkboxes on the accounts you would like to map to a new location.
Click BULK ACTIONS and select Move selected to choose a target location.