Proposal: Sub Root Type in Accounts for Improved Financial Data Classification and Grouping

[sanjay]

Recently I reviewed both Account Category and Financial Report Template, and observed that:

• Since both are user-configurable, we cannot rely on user-defined names or structures to ensure consistent account classification and grouping.
• Additionally, there does not appear to be any default Financial Report Template that can serve as a standardized input for processing data through the Financial Report Engine.

If we extract raw financial data from GL Entries (mapped with Accounts) and intend to use AI / BI tools for financial analysis, it may be challenging to accurately classify and group accounts into meaningful analytical categories such as:

• Direct Income
• Direct Expense
• Indirect Income
• Indirect Expense
• Current Assets
• Current Liabilities
• Long-term Loans
• Equity
• Reserves & Surplus

To improve the efficiency and accuracy of financial analysis using AI / BI tools, introducing a Sub Root Type within the Chart of Accounts (COA) could be beneficial.

Proposed Approach:

• Create a Sub Root Type DocType containing a root_type field.
• Add a Sub Root Type link field in the Account DocType (including Quick Entry), with filtering based on the selected root_type.
• Update existing standard COA JSON templates to include Sub Root Type mapping.

I’d appreciate your feedback on this proposal.

Account Category

@Aadhil_P_M first of all, thank you so much for adding this missing feature in COA. Currently Account Category is not linked to Root Type thus its difficult to identify the root type of Account Category for financial data analysis. I have below suggestions to make this feature more robust: Add Root Type in Account Category doctype Do not allow user to create/update Account Category by enabling User Cannot Create option in doctype properties. In Account doctype: toggle this field based on i…