Within the top level structure of Categories and Running Totals you can create a hierarchy of Header Accounts for grouping and summarising the Detail Accounts from your accounting system. For example within your Assets Category on your balance sheet you might create headers for Current Assets and Non-Current Assets, then below Current Assets you might want to add Cash, Accounts Receivable and Inventory. You can continue this hierarchy mapping to a depth of 10.
- To add a new Header click the Add Header button
- Populate the following header properties and click Add Header.
- Header number: this is the primary means of sorting headers. You can use numbers or letters and the header accounts will be sorted alphanumerically by this field.
- Summary only: toggle this option on to summarise all the allocated accounts to one row in reports. When toggled off the detail accounts are also shown in reports.
- Header name: the name of the header account which will be shown in reports. This is also the secondary sort field if no numbers or duplicate numbers are provided.
- Category: determines which category you will add the new header to. You can drag and drop this header to any location after that.
- First you may need to expand the category that contains the header.
- Now click the settings cog of the header you would like to edit.
- Edit the properties and click Apply. See details on the available properties in Add Header above.
- Using your mouse you can drag and drop header accounts onto another header to create a parent-child relationship. In the example below we drag the Cash header account onto the Current Assets header account to group Cash below Current Assets.
- Now click the plus sign to next to the header to show its sub accounts.
- Repeat this process until you have the required structure.
Detail accounts are the individual accounts synced from your accounting system. You will need to map these accounts to the new structure you've created in Calxa.
- Using your mouse you can drag and drop detail accounts onto the Header or Category to create a parent-child relationship. These accounts may be in the Unallocated accounts column on the left or you can move accounts within this structure on the Allocated accounts column also.
- Repeat this process until you have the required structure. Make sure to Save Changes.