As more organizations prepare to transition from Microsoft Dynamics GP to Business Central (BC), one of the most important foundational steps is revisiting — and often redesigning — the Chart of Accounts (COA). In our webinar, Moving to BC? Things to Think About – Episode 1: Chart of Accounts Clean-Up, Vice President Cheryl Simmons and Director of GP Services, Gina Bothun, walked through what companies should evaluate long before migration begins.

A clean, modern, and strategically structured Chart of Accounts (COA) doesn’t just make the move to Business Central smoother — it sets your financial system up for scalability, clarity, and long-term success.

Understanding Your Current GP Chart of Accounts

Dynamics GP uses a segmented account format that defines how all windows, reports, and ISV solutions reference account numbers. In many environments, this structure has evolved over years (or decades), creating inconsistencies, duplicates, and formatting challenges.

Key things GP users should review:

• Account structure and maximum lengths — GP allows up to 45 characters and 5 segments, but many companies don’t use them intentionally.
• Segment names and purposes — Properly naming segments helps ensure accounts are automatically and consistently named as they’re created.
• Use of segments for filtering — Segments can be powerful report filters — if they’re structured well.

Before moving to BC, take a critical look at whether your segments still make sense for reporting, departmental needs, and future growth.

Account Types in GP: Are You Using Them Effectively?

GP offers several account types, each serving a unique purpose. Cleaning these up now can prevent confusion later.

• Posting Accounts — Your standard accounts used for day-to-day financial activity.
• Unit Accounts — Track non-financial data (e.g., number of employees, units installed, square footage). These can become valuable dimensions in BC.
• Fixed Allocation Accounts — Used to automatically distribute transactions across multiple accounts based on predefined percentages.
• Variable Allocation Accounts — Use actual account balances — such as unit accounts — to allocate expenses proportionally.

Many companies discover unused, incorrectly configured, or outdated allocation accounts during COA cleanup. Fixing this early prevents messy financial data from migrating into BC.

Moving to Business Central: What Changes?

Business Central handles accounts very differently from GP, especially in how it handles segmentation and allocations.

• Statistical Accounts in BC — BC provides statistical accounts to store non-financial metrics. These are often used as allocation drivers — similar to unit accounts in GP, but with more power and better integration.
• Allocation Accounts — BC supports fixed and variable allocations, using:
  • Amounts
  • Quantities
  • Statistical account balances
  • Assigned dimensions

  This makes allocations more flexible and more visible within the financial data model.

Dimensions: The Biggest Shift from GP to BC

GP relies heavily on segments within the account string. BC, however, uses Dimensions to provide granularity.

Dimensions in BC include:

• 2 Global Dimensions that are always available on postings
• 8 Shortcut Dimensions that are quickly accessible throughout the system
• Unlimited dimension values for tracking customers, departments, projects, and more
• Rules, priorities, and blocked combinations for maintaining data quality

Why this matters:

Dimensions eliminate the need for overly long or overly segmented account structures. Instead of dozens of accounts representing every possible combination, BC streamlines your COA and lets dimensions handle the detail.

Chart of Accounts Considerations Before You Migrate

Our VP, Cheryl Simmons, and Director of GP Services, Gina Bothun, emphasized several critical questions every company should ask now, not later:

• Do you have multiple accounts with the same name? This is common in GP but creates confusion during migration.
• Have you marked inactive accounts — or are you carrying around years of unused ones? Clearing them out reduces clutter and improves mapping accuracy.
• How will your organization grow? Your new COA should support:
  • New locations
  • Growth in business units
  • New reporting expectations
  • Scalability in BC
• What do you want your NEW Chart of Accounts to look like? Designing it intentionally — instead of replicating GP’s structure — leads to cleaner reporting and more flexible financial insights.

Start Planning Your New COA Now

A migration to Business Central is the perfect time to:

• Redesign a modern, simplified COA
• Leverage dimensions for better reporting
• Clean up old, duplicate, or unused accounts
• Standardize naming, numbering, and allocation methods
• Reduce manual work and increase automation

The sooner these conversations begin, the smoother your migration will be.

Need Help Restructuring Your COA or Planning Your GP to BC Move?

Our GP and BC experts can help assess your current setup, design a modern Chart of Accounts, and ensure a seamless transition.

For consulting and technical guidance, contact: support@iscorp.biz
For solution discussions and migration planning: sales@iscorp.biz