by Carlos Lozano, Business Central Lead Consultant

Version 22 of Business Central introduced functionality for Statistical Accounts, a long-waited functionality already available in other accounting systems. It will allow you to post statistics that could be used in Financial Reporting.

Defining Statistical Accounts

Search Statistical Accounts and select the suggested link.

Click on the +New button to define a new account

In No., enter a code of up to 20 characters and a descriptive text in Name.

The No. could be a word or a numerical value, for example, 9001.

Use the Dimensions button to define default Dimension Values if required.

Posting Entries to Statistical Accounts

From the Statistical Accounts list, use the Statistical Accounts Journal, or use the global search to find it. Like other Journals, enter the Posting Date, Document No., Account No., and the quantity in the Amount field; the Description is a free entry; enter Dimension values if required.

Enter Dimension Values if required.

Once the data is ready, use Register to register the information on the Statistical Account Ledger Entries page.

If a mistake was made, the Statistical Account Ledger Entry page allows you to reverse entries; select the record(s) to reverse and click “Reverse Transaction.”

Using Statistical Accounts in Financial Reports

In Business Central’s Financial Reporting, select a report, for example, the Balance Sheet, and choose Edit Row Definition.

Alternatively, search “Row Definitions” and open the “Row Definition” to update. This update adds new rows to all reports using the same Row Definition.

For the Totaling Type, select Statistical Account.

Close the Row Definitions page and run the Financial Report to see the new rows.

Statistical Accounts in Analysis Views

In Analysis Views, you can also run an analysis on Statical Accounts. In Account Source, select “Statistical Account” and select the accounts in Accounts Filter, then add the Dimensions you want to use.

For more information about statistical accounts or how to maximize your Business Central investment you can reach out to us at Support@BondConsultingServices.com or click here to schedule a free consultation with one of our Dynamics experts.