TABLE OF CONTENTS
At it's simplest level an Account Tree helps you build different Profit & Loss and Balance Sheet report layouts. An Account Tree defines the rows and how they will be grouped and displayed on your reports including the running totals like Gross Profit or Operating Profit. These groupings may also be used to provide segments in Calxa charts.
1. Create Categories & Running Totals
First create the overall structure using Categories and Running Totals. See the article Account Tree: Categories & Running Totals for more details but in short this is the first level of your account tree.
In the example below we have categories named Revenue, Cost of Goods Sold, Variable Costs, etc where Running Totals are configured on the Cost of Goods Sold and Fixed Costs groups as Gross Profit and EBITDA respectively.
2. Create Header & Sub Header Accounts
Within each category you can further group and or summarise your accounts using Headers. See the article Account Tree: Headers & Detail Accounts for more details but in short this is where you can create a hierarchy of accounts up to 10 levels deep.
In the example below we have created Grants as a header with sub headers as Commonwealth, State and Local. Likewise Fundraising has sub headers of Gifts and Contributions.
3. Allocate your Detail Accounts
Synced from your Account System we have your Chart of Accounts. These include detail accounts and may also include header accounts. See the article Account Tree: Headers & Detail Accounts for more details but in short you simply need to drag and drop these accounts onto the desired headers to create your mapping.
In the example below we have allocated 3 detail accounts to the header account called Commonwealth.
4. Edit Mapping
To edit where accounts are mapped to you can just drag and drop into the new position within the Allocated Accounts Section, drop individual accounts or groups of accounts onto the header you wish to move them to. An orange outline will appear to drop the account into.
If you have a large Chart of Accounts it may be easier to drag the accounts you wish to change back into the Unallocated section, and then open up the Allocated section to make it easier to drop into the correct place.
Please note that for the reports to run correctly ALL the accounts should be allocated in the Account Tree.
SAVE CHANGES regularly as you progress, to ensure your work is not lost to a time out.