G/L Account Categories in Microsoft Dynamics 365 Business Central allow you to group accounts in your chart to specific categories used for reporting. They’re required to be set up in order to use Power BI Gold for Finance.

What do I need to set up?

For each posting account in the Chart of Accounts, an Account Category and Account Sub Category need to be set. Totalling accounts do not require this to be set up.

How do I assign G/L Accounts to categories?

The Account Category and Account Subcategory can be assigned directly to the G/L Account via the G/L Account Card.

Alternatively, the G/L Account Categories summary page can be used.

Can I create my own categories?

Yes. However you must leave the following top level categories as-is:

  • Assets
  • Liabilities
  • Equity
  • Income
  • Cost of Goods Sold
  • Expense

Sub Categories can be created through the G/L Account Categories screen, in conjunction with the Indent, Outdent, Move Up and Move Down actions.

What is the standard configuration?

This standard configuration is the default mapping of Business Central G/L account categories to the corresponding parameters in the Power BI Gold for Finance dataset.

Level 1 Categories

Power BI Gold ParameterBusiness Central Category
Assets (Level 1 Category)Assets
Liabilities (Level 1 Category)Liabilities
Equity (Level 1 Category)Equity
Revenue (Level 1 Category)Income
Cost of Goods Sold (Level 1 Category)Cost of Goods Sold
Expense (Level 1 Category)Expense

Level 2 Categories

Power BI Gold ParameterBusiness Central Category
Current Assets (Level 2 Category)Current Assets
Current Liabilities (Level 2 Category)Current Liabilities
Shareholder’s Equity (Level 2 Category)Common Stock
Interest Expense (Level 2 Category)Interest Expense
Tax Expense (Level 2 Category)Tax Expense
Extraordinary Expense (Level 2 Category)Extraordinary Expense
FX Losses Expense (Level 2 Category)FX Losses Expense
Depreciation and Amortization (Level 2 Category)Depreciation and Amortization
Interest Revenue (Level 2 Category)Interest Income
FX Gains Revenue (Level 2 Category)FX Gains Income
Extraordinary Revenue (Level 2 Category)Extraordinary Income
Fixed Assets (Level 2 Category)Fixed Assets
Payroll Liabilities (Level 2 Category)Payroll Liabilities
Longterm Liabilities (Level 2 Category)Long Term Liabilities

Level 3 Categories

Power BI Gold ParameterBusiness Central Category
Inventory (Level 3 Category)Inventory
Accounts Payable (Level 3 Category)Accounts Payable
Accounts Receivable (Level 3 Category)Accounts Receivable
Purchases (Level 3 Category)Purchases
Purchase Prepayments (Level 3 Category)Prepaid Expenses
Liquid Assets (Level 3 Category)Cash