How to configure G/L Account Categories?

Prerequisite: Please make sure you have installed the Power BI Insights Connector App. 

In Dynamics 365 Business Central search for G/L Account Categories. 

Search-GL-Account-Categories.png

Here you can create new categories and/or rename existing ones.

In the G/L Account Categories screen, you will find two extra fields: Account Subcategory (Power BI) and Account Subcategory 2 (Power BI). For each G/L Account Category please select the appropriate Account Subcategory (Power BI) and also Account Subcategory 2 (Power BI) where required.

 

These two fancy fields will be used by Power BI to calculate financial ratios and KPIs (and some other smacking ratios that would make any accountant a little steamy under the collar 😉) including efficiency, debt, leverage, liquidity and profitability ratios. 

You need to make sure that all your G/L Accounts are classified correctly into groups.

GL-Account-Categories.png

If you haven’t fallen asleep, you should be ready to create some of the most beautiful finance reports around.

You can find more information about Account Categories here.