Stat (Statutory/Statistical) Accounts for D365 Finance

For use with Microsoft Dynamics 365 Finance. 

If you ever want to include information such as a departmental head count, hours, or units produced on your financial reports Statistical Accounts are what you need to use for D365.

Posted transactions using Statistical Accounts will allow users to pull data into D365 Financial Reporter. This data can be used to create reports that track performance, measure productivity or other information that you might use for reporting purposes, and to perform calculations on the financial reports.

Things to Consider Before Creating your Statistical Accounts

The Microsoft recommended approach is to start the account numbers with a “9” so that it is easier to separate them from financial accounts; however any number sequence specific to the stat accounts will work. This way you can easily identify the non-financial accounts and to run reports against them using an account range.

Selecting a Main Account type:

• Do you want to have the amounts reset to zero at the end of the year? Or maybe you don’t? This will determine what you will select as the Main Account type; either Balance Sheet or Profit and Loss.
• Main Account type must be the same for the Statistical Account and its corresponding Offset account.
  
  

How to Setup Statistical Accounts

Setting up Statistical Accounts within the Main Accounts. 

General Ledger > Chart of Accounts > Main Account

Statistical Account Setup

• Main Account type:
  • Balance Sheet (if you don’t want the amounts reset to zero)
  • Profit and Loss (if you want to have the amounts reset to zero at the end of the year)
• Main Account Category:
  • Statistical
• Offset Account:
  • Enter the offset account you created for this Statistical Account

Offset Account Setup

• Each Statistical Account will need the offset account filled in with a Statistical Offset account so that when you create a journal entry and use a Statistical Account, the entries will automatically balance.
• This will ensure a net 0 impact on the Trial Balance and to Retained Earnings at Year End.
• Main Account type:
  • Balance Sheet (if you don’t want the amounts reset to zero)
  • Profit and Loss (if you want to have the amounts reset to zero at the end of the year)
• Main Account Category:
  • Statistical
• Offset Account:
  • Enter the corresponding Statistical Account

Account Structure

• Make sure to confirm that any new accounts being added are included in the valid account structures in the ledger setup.

Here’s an example of a journal entry using the Statistical Account; the offset account is populated automatically:

Oak Hall Group provides implementation and support services to Microsoft Dynamics 365 users, companies, partners, and Microsoft. Our team has over 50 combined years of experience with the product and implementations. Contact us for Implementation and Support Services. 

Oak Hall Group
3379 Peachtree Rd NE
Suite 555
Atlanta, GA 30326
770-821-1610
[e-mail]
www.oakhallgroup.com