Use G/L Accounts with report row definition

  • 4 min.

The Extended Financial Reports Module includes a feature that helps you more quickly define financial report rows through G/L Account Groups. This extends the standard functionality of Business Central financial reports, which relies on using account categories and subcategories in the row definition of financial reports. With the G/L Account Groups, you have the flexibility to specify your own groupings of G/L accounts to meet your specific needs.

Set up G/L Account Group captions

The first step is to specify the different groups that you need to create. You can create up to four groups, and you can give these groups customized captions to show in the chart of accounts and financial reporting pages.

Navigate to the Extended Financial Reports Setup page.

In the Account Groups FastTab, enter captions to describe the purpose for each of the G/L account groups.

Ext Fin Reports Setup Account Groups FastTab

Add G/L account group codes

Next you specify the codes for organizing the G/L accounts within each account group. You can create as many codes as you need, and assign multiple G/L accounts to the same code.

Navigate to the G/L Account Groups Setup page.

Select the relevant Code, then use the Edit List action to create new codes and add descriptions.

GL Account Groups Setup page

Link accounts to G/L account group codes

From the Chart of Accounts, you can see the four columns for the G/L account groups.

Note

The column captions in the Chart of Accounts are set up on the <function(o){return console.warn("Component "+t+" was not imported, exported, or provided by MDXProvider as global scope"),mdx("div",a({},o))}>Extended Financial Reports Setup</function(o){return console.warn("Component "+t+" was not imported, exported, or provided by MDXProvider as global scope"),mdx("div",a({},o))}> page.

You can add or remove G/L accounts for each code directly from the column fields in the Chart of Accounts.

Chart of Accounts Account Group columns

Alternatively, you can assign G/L account groups to an individual account from the account card. This saves you time when you create new G/L accounts, because no further setup is needed to ensure that the account is included in financial reports that use the G/L account groups.

GL Account Card Continia Finance FastTab Ext Fin Reports

Use G/L account groups in row definition

Once you have set up G/L account groups, you can use the account group codes in the row definitions of financial reports.

In the Totaling Type column, select the relevant G/L account group.

Then in the Totaling column, enter the relevant G/L account group code.

Fin Report Row Definition Totaling Type for GL Account Group

Scenario

Ester at Cronus needs to create a new, less detailed version of the profit and loss report for the board of directors.

She needs to complete these tasks:

  • Create a caption for a G/L account group
  • Set up codes for the G/L account group
  • Add accounts to the G/L account group codes
  • Set up financial report row definition to use the G/L account groups and codes

More resources

Working with G/L account groups (Continia Docs article)