Every finance team eventually wants to answer questions that the Chart of Accounts (COA) was never designed for. How much did we spend on this grant? What did that marketing campaign cost? Which region is most profitable once shared costs are included?
In Microsoft Dynamics GP, the usual answer is to add another account segment. But segments have limits, and every new one multiplies the number of accounts you need. Analytical Accounting (AA) offers a different approach: it lets you tag transactions with extra information without changing your chart of accounts at all.
In this guide, we explain what Analytical Accounting does, how to set it up, and, just as importantly, when it is the right tool and when it is not.
What Is Analytical Accounting?
Analytical Accounting is a GP module that adds extra layers of analysis to your transactions. Instead of building a department or project into the account number, you record that information as a separate transaction dimension on each distribution line.
For example, a $1,000 travel expense might be posted to account 6200 Travel, then tagged with:
- Project: Website Redesign
- Region: North
- Funding source: Grant 2026-04
The General Ledger stays simple, while reports can slice the same transaction many different ways.
It also helps to recognize the key building blocks:
- Transaction dimensions: the categories you want to analyze, such as Project or Region.
- Transaction dimension codes: the values within each dimension, such as individual project codes.
- Data types: dimensions can be alphanumeric (a list of codes), numeric (a quantity such as hours or headcount), date (such as a service date) or Boolean (yes or no).
- Accounting classes: groups of GL accounts that share the same dimension rules.
- Aliases: saved combinations of dimension codes that speed up data entry.
When Analytical Accounting Makes Sense
We want to emphasize that Analytical Accounting is powerful, but not every organization needs it. It is a good fit when:
- You need more analysis than your segments allow. Adding a new segment to GP is a major change. AA lets you add analysis categories without touching the account structure.
- The categories change often. Projects, grants, campaigns and events come and go. Creating a new dimension code is far easier than creating dozens of new accounts.
- Only some accounts need the extra detail. With accounting classes, you can require a project code on expense accounts but not on balance sheet accounts.
- You need non-financial data alongside amounts. Numeric, date and yes/no dimensions let you record quantities, dates or flags with each transaction.
- You need to split one line across several categories. A single distribution can be divided by amount or percentage across different dimension codes.
Common users include nonprofits tracking grants and programs, professional services firms tracking projects or clients, and organizations analyzing costs by region, product line or campaign.
When It Might Not Be the Right Choice
- Your existing segments already do the job: If departments and divisions are stable and well defined, segments are simpler.
- You use Project Accounting: For detailed project costing and billing, GP Project Accounting may be the better tool.
- You rely heavily on intercompany transactions: Analytical Accounting does not fully integrate with GP’s intercompany feature. Microsoft notes that AA details must be added manually to the batch in the destination company, as we cover in our Dynamics GP intercompany setup guide.
- You plan to move to Business Central soon: Business Central has dimensions built in, so it may be better to wait and design them properly there.
Before You Start
A little preparation goes a long way, because activation is a significant step:
- Plan your dimensions: Decide which dimensions you need, their data types, and which accounts each one applies to. This is a finance decision, not just an IT task.
- Take a full backup of both the system database and each company database. Activation changes your data, and treating it as permanent is the safest approach.
- Make sure all users are logged out of every company in the same GP system. Activation will fail if anyone is still logged in.
- Log in as sa or another administrator with full rights.
- Register the module in GP if it is not already registered.
Step-by-Step: Setting Up Analytical Accounting
Step 1: Create default records
Open the Analytical Accounting Setup Wizard from Administration > Setup > Company > Analytical Accounting > Setup and run the Create Default Record routine. This must be done once for each company that will use AA.
Step 2: Check posting setup
Review the posting options for Analytical Accounting in the Posting Setup window. Your GP partner can help confirm the right settings for your series and origins.
Step 3: Activate Analytical Accounting
In the same wizard, mark Activate Analytical Accounting and follow the steps. Activation is done per company and transfers your current account balances into the Analytical Accounting tables. You cannot enter analysis information until AA is activated, although you can prepare setup records beforehand.
Step 4: Define transaction dimensions
Create each dimension, choose its data type, and set options such as whether a code is required when adjusting posted entries later.
Step 5: Create dimension codes
For alphanumeric dimensions, create the list of codes, such as each project or grant. Keep codes short, consistent and meaningful.
Step 6: Set up accounting classes
Group GL accounts into accounting classes, then decide how each dimension behaves for that class:
- Required: a code must be entered.
- Fixed: a default code is applied and cannot be changed.
- Optional: a code can be entered if wanted.
- Not allowed: the dimension cannot be used.
Each account can belong to only one accounting class, so plan the grouping carefully. Only accounts linked to a class open the analysis window during entry.
Step 7: Set up relations and aliases
Use relations and code combinations to control which dimension codes can be used together, and create aliases for combinations your team uses often.
Step 8: Grant user access
Give users access to the alphanumeric dimension codes they need. This adds another layer of control on top of GP’s normal security roles.
Entering and Reporting on Analytical Data
Once AA is active, users see an Analytical Accounting button or window when entering General Ledger, Payables, Receivables and other transactions on accounts linked to a class. They select dimension codes (or an alias) for each distribution line and can split the amount across several codes.
If something was coded incorrectly, the Edit Analysis option lets you adjust dimension codes on posted transactions without reversing the journal.
For reporting, Analytical Accounting offers its own inquiries and reports, SmartLists, and support in Management Reporter. You can read more about the options in our Dynamics GP reporting tools comparison and our guide on creating and sharing SmartLists.
Common Pitfalls
- Too many dimensions: Every required dimension adds data entry work. Start with the few that support real decisions.
- Poorly planned accounting classes: Because an account can only sit in one class, a rushed design is hard to undo.
- Activating without a backup: Always take a full backup first.
- Forgetting integrations: Imports and integrations need to supply dimension data too, or transactions will be incomplete.
- Intercompany surprises: Remember the manual step needed in the destination company.
Frequently Asked Questions
Is Analytical Accounting included with Dynamics GP?
It is part of the GP financial modules, but it must be registered under your license and activated for each company that uses it.
Can I turn Analytical Accounting off after activating it?
You should treat activation as permanent. The reliable way to undo it is to restore the backup taken before activation, which is why that backup is essential.
What is the difference between account segments and Analytical Accounting?
Segments are part of the account number, so every combination is a separate account. Analytical Accounting keeps the account simple and records extra analysis as dimensions on each transaction line.
Does Analytical Accounting data move to Business Central?
Not as standard. Microsoft’s cloud migration tool converts GP account segments into Business Central dimensions, but AA dimensions need separate planning. Our post on the GP to Business Central cloud migration tool explains what the tool covers.
Looking Ahead: Dimensions in Business Central
With GP support ending on December 31, 2029, it is worth knowing that Dynamics 365 Business Central has dimensions built into every transaction, with no separate module to activate. Many of the ideas behind Analytical Accounting, such as rules for required dimensions and blocked combinations, are standard features there. Our guide on moving from GP account segments to Business Central dimensions explains how to design them well, and our Dynamics GP to Business Central migration service can help you bring your analysis structure across.
How Nevas Technologies Can Help
At Nevas Technologies, we have more than two decades of experience with Microsoft Dynamics. Our Dynamics GP support team can help you decide whether Analytical Accounting is right for your organization, design dimensions and accounting classes, and activate it safely. Our Dynamics GP training helps your team enter and report on analytical data with confidence.
Considering Analytical Accounting? Contact our team, or schedule a demo to see how dimensions work in Business Central.