top of page
Writer's pictureMichelle Serna

How to Set Up and Use Statistical Accounts in Business Central

Statistical accounts in Microsoft Dynamics 365 Business Central allow businesses to track non-financial data that can be crucial for informed decision-making. These accounts can be used to monitor metrics such as headcount, square footage, production units, and other statistics that impact business operations but do not directly involve monetary transactions.


Setting Up Statistical Accounts in Business Central


Here’s a step-by-step guide on how to set up statistical accounts in Business Central:


Step 1: Create a Statistical Account

  1. Go to the search bar and type “Statistical Accounts."

  2. Click on “New” to create a new account.

  1. Enter Account Details:

  • No.: Assign a unique number to the account.

  • Name: Enter a descriptive name for the account.

  • Blocked: If you need to retire an account in the future.


Step 2: Assign Dimensions for Statistical Accounts

  1. Navigate to the Dimensions Button in the Toolbar.


2. Assign any default dimensions you may want assigned to the statistical account.



Using Statistical Accounts in Business Central

Once the statistical accounts are set up, you can start using them to track non-financial data.

Recording Data in Statistical Accounts

  1. Navigate to the Statistical Journal


2. Enter Journal Line Details:

  • Enter in any related information on the lines: Posting Date, Document No, Statistical Account Number, Description and the current amount.

  • I have two lines here with the same date, but two amounts. I have assigned a different department dimension to each line.

  • It is careful to note that the amount is not the current count, it is the increase or decrease from the previous amount. So, in this entry I have added a total count of 30 new staff since my previous entry.

  • Register your Journal Entries


Analyzing Statistical Data

  1. You can see now that we have registered our entries that the balance of our account has increased.

2. Navigate to the Statistical Account Balance to see the details. Keep in mind you can adjust your view to be viewed as net change, or even balance at date. In addition, choose the length of time your date is filtered on like monthly or quarterly.





3. You can even add Statistical Accounts to your Financial Reports!

  • Here is a quick Row definition to show how you can assign Statiscal Accounts to the Row

  • Imagine now having a column definition that has a dimension value filtered to each column like below


  • Then, when you run your financial report, get all the info you could dream of! Even drill down to see yoru entries!

Benefits of Using Statistical Accounts

  • Enhanced Decision-Making: Track key metrics that influence business decisions.

  • Comprehensive Reporting: Combine financial and non-financial data for a holistic view of business performance.

  • Operational Efficiency: Monitor and optimize various operational aspects like resource usage, production efficiency, and employee productivity.


I hope this helps you on your Statistical Account journey!

229 views0 comments

Comments


bottom of page