There are two ways to organise your Chart of Accounts in Joiin, you can create a universal account mapping that applies to all reports, or you can create mappings for individual reports. 


Universal account mappings: Useful when you want to permanently align accounts that appear in multiple entities, with slight naming or coding differences.


Individual account mappings: Useful when you want to group similar accounts for a specific report, for example, grouping all staff costs expenses into a single sub-group. (see bottom of the page) 



 

Universal account mappings



  1. COA Suggestion (AI-Powered)

    • This AI-powered feature tidies up accounts with similar names.

    • It aligns accounts that have the same name but different account types.

  2. Manual Selection

    • Manually select GL accounts using the tick box.

    • Click Consolidate 2 Accounts to merge them.

Steps to Use the AI-powered COA Suggestion Feature:

  1. Click the Settings icon (top right corner) and select Chart of Accounts.


  2. Click COA Suggestions. Joiin will analyse your GL accounts and suggest amendments. 


  3. Choose the most appropriate Account type or Account group name, the two options are shown below

  4. Click Accept Suggestions to confirm your selection. Joiin will move to the next suggestion.



  5. You can apply suggestions one at a time or process all and apply multiple at once.


Steps to Use the Manual COA Selection Feature:


  1. Click the Settings icon (top right corner) and select Chart of Accounts.


  2. Tick off the accounts you want to consolidate together.


  3. Tap on the button 'Consolidate 2 Accounts.'


  4. Choose the one account that will be set as a primary account. The other accounts will be merged into the primary account.

  5. Tap on the 'Merge' button.



Individual account mappings


Once your accounts have been merged, these will always appear on all reports as a single line item.


 If you would like the option to split this consolidation to see the individual GL account details, or would like to apply a consolidation to a specific report only, a different method can be used. This involves the Nested Groups option in custom layouts.


For more information on creating Nested groups, see this article.


After you have created a nested group the following steps can be taken to make this appear as a GL account:


  1. Edit your Nested Group by clicking the 3 Dot Menu beside it's name and then Edit
  2. From the Group options, enable Collapse and Show Total as well as Style as an Account
  3. Save the changes you have made by clicking Accept at the bottom of the editing window


The nested group you have created can then be expanded/collapsed by clicking on it's name after running the report.