How to Create Statistical Accounts in Business Central?

Statistical accounts in Business Central let you track non-monetary, number-based data (employee headcount, square footage, units produced, ticket sales) alongside your financial data, so you can build metrics like revenue-per-employee directly into a financial report. Statistical accounts have been a native, built-in Business Central module since the 2023 release wave 1 update (BC22), with no third-party add-on required. You create the account, post amounts through the Statistical Account Journal, and reference the account in a financial report's row definition.

If you've read a guide that says statistical accounts "aren't included in Business Central's native capabilities" and points you toward a paid add-on, that information is out of date. Microsoft shipped a dedicated, free Statistical Accounts module, with its own pages, journal, and ledger, starting with the April 2023 release. This guide walks through the native process from start to finish.

What Are Statistical Accounts, and Why Use Them?

Standard general ledger accounts only store monetary amounts. But finance teams frequently need to pair financial figures with non-financial context to get a useful metric, for example:

• Revenue per employee (needs headcount)
• Rent expense per square foot (needs building square footage)
• Cost per unit produced (needs production volume)
• Average ticket price (needs ticket count)

Before statistical accounts existed as a real module, people worked around this by flagging a regular G/L account as "statistical" in the chart of accounts, essentially faking a non-monetary account inside the financial ledger. That workaround still shows up in some older tutorials and paid add-ons. It works, but it mixes non-financial data into your chart of accounts and trial balance structure, which isn't ideal.

The native Statistical Accounts module, by contrast, keeps this data in its own separate ledger, entirely outside your chart of accounts and trial balance, while still letting you pull it into financial reports.

Statistical Accounts Are Native: What Changed and When

Quick clarification, since this causes real confusion in search results:

• Before April 2023: No dedicated statistical accounts feature existed. Teams either faked it using a specially flagged G/L account, or used a third-party add-on.
• Since the 2023 release wave 1 update (BC22, April 2023): Business Central ships a standalone Statistical Accounts module with three dedicated pages: Statistical Accounts, Statistical Account Journal, and Statistical Account Ledger Entries. It runs on its own separate ledger, independent of the base application's G/L, and is included in Business Central at no extra cost.

If your current process still involves flagging a regular Balance Sheet G/L account as "Statistical Account" and posting through a general journal, you're using the pre-2023 workaround. It's worth migrating to the native module, described below.

Step 1: Create a Statistical Account

1. Select Search (Alt+Q), enter Statistical Accounts, and choose the related link.
2. Choose New to open a blank statistical account card.
3. On the General FastTab, enter a No. and Name. Hover over any field for a short description.
4. Optionally, set default dimensions for the account (for example, Department or Business Unit) so entries posted to it automatically inherit those dimensions.

Naming tip: Keep statistical account numbers visually distinct from your regular chart of accounts, for example using a letter prefix (S-0010 for headcount) or a dedicated number range. This makes it immediately obvious when you're looking at a statistical account versus a financial one.

Step 2: Post Amounts Through the Statistical Account Journal

Once the account exists, you post data to it the same way you'd post to a general journal, except there's no debit/credit balancing requirement; you just enter the amount.

1. From the Statistical Accounts page, choose the Statistical Accounts Journal action.
2. In the Posting Date field, enter the last date of the period you're recording (for example, month-end).
3. Optionally, enter a Document No. if you want to tie the entry to a specific source document.
4. In the Statistical Account No. field, select the account you created.
5. In the Description field, note what you're recording.
6. In the Amount field, enter the value, for example, 100 for an initial headcount of 100 employees.
7. Optionally, fill in dimension fields (like Department Code) if you want to slice this data further in reporting later.
8. Post the journal.

To update the balance later, for example after hiring 20 more employees, post another journal entry for the change (20), not the new total; statistical accounts accumulate the same way financial accounts do.

Step 3: Verify the Balance

On the Statistical Accounts page, use the Statistical Accounts Balance action to confirm the registered amounts are correct for each period. This is worth checking before you rely on the account in a financial report, especially the first time you set one up.

You can also drill into the Statistical Account Ledger Entries for full detail on every posted transaction behind the current balance.

Step 4: Add the Statistical Account to a Financial Report

This is where statistical accounts earn their keep, letting you build a metric like "revenue per employee" or "rent per square foot" directly into a report your finance team already runs.

1. Select Search, enter Financial Reports, and choose the related link.
2. Open an existing report (like your income statement) or create a new one.
3. Choose Edit Row Definition.
4. Add a new row. In the Row No. field, place it where you want it to appear.
5. In the Description field, label it clearly (for example, "Employee Headcount").
6. In the Totaling Type field, choose Statistical Accounts.
7. In the Totaling field, select the statistical account you created.
8. In the Row Type field, choose whether to show the balance as of the posting date, the balance at the start of the period, or the net change during the period.
9. To calculate a combined metric (like revenue per employee), add a second row with Totaling Type set to Formula, referencing both your revenue row and your statistical account row, for example P0001 / P0002.

Once set up, running the report shows your financial figures side by side with the operational metric, without any manual pivot tables or exports.

Choosing Balance Sheet vs. Income Statement Type

When you add a statistical account to a financial report, think about whether the row should behave like a balance-sheet figure or an income-statement figure:

• Use a point-in-time (Balance Sheet-style) view for data where the current total matters more than the change during the period, like current headcount or current square footage under lease.
• Use a period-based (Income Statement-style) view for data that represents activity during a specific period, like tickets sold this month or units produced this quarter.

Mixing these up is a common setup mistake. For example, if you post the full current headcount every single period and treat the row as a period total, your year-to-date figures will be wrong, since the same number effectively gets added up across periods instead of representing a snapshot.

Common Use Cases by Industry

Best Practices

1. Use the native module, not the legacy workaround: If you're currently flagging regular G/L accounts as statistical, plan a migration to the dedicated Statistical Accounts module so this data stops living inside your financial chart of accounts.
2. Establish a clear numbering convention that visually separates statistical accounts from financial ones.
3. Decide Balance Sheet vs. period-based treatment before you start posting, not after; changing it later means re-checking every prior entry.
4. Use dimensions on statistical entries if you'll want to break metrics down by department, location, or business unit later. It's much easier to add this at setup than to retrofit it.
5. Verify balances with Statistical Accounts Balance after your first few postings, before building formulas on top of the data.
6. Document who owns the monthly posting: Statistical accounts don't get updated automatically from transactions; someone needs to post headcount, square footage, or similar figures manually or via integration each period.

Final Thoughts

Statistical accounts close a real gap in financial reporting: the ability to pair operational, non-monetary data with financial figures in the same report, without spreadsheets on the side. And unlike what some older guides suggest, this is built into Business Central today at no extra cost, not something you need to buy an add-on to unlock.

The setup itself is quick. The part worth getting right is the thinking around it: choosing sensible account numbers, deciding period vs. point-in-time treatment upfront, and being clear on who's responsible for posting the data each month. Get those three things right and statistical accounts become one of the lowest-effort, highest-value additions to your financial reporting.

If your team is still using the old chart-of-accounts workaround, or paying for functionality that Business Central now includes natively, it's worth a quick review of what's changed. Dynamics Square can walk through your current setup and show you exactly what migrating to native statistical accounts would look like for your reports. 

Curious what else in your Business Central setup might now have a native alternative? Click here to send us a quick overview of your current add-ons and we'll flag anything worth revisiting.