Setting Up the Chart of Accounts in Dynamics 365 Business Central: The Complete Guide

Why the Chart of Accounts (CoA) matters

The Chart of Accounts is the backbone of your financial management in Dynamics 365 Business Central (BC). Every journal entry, posting, and report flows through the CoA. A cleanly structured CoA means:

  • Accurate financial reporting

  • Easier compliance and audits

  • Smooth day-to-day posting

  • Reduced errors and rework


Where to find it

  • In BC, open Tell Me (Alt+Q) → search Chart of Accounts.

  • You’ll see a list of all general ledger (G/L) accounts, with filters and columns to drill down into balances, entries, and posting setups.


Step 1: Define your account structure

Before creating accounts, design a numbering and grouping strategy.

Example numbering structure

Number Range Purpose Example Accounts
10000–19999 Assets 10100 – Cash, 12000 – Accounts Receivable
20000–29999 Liabilities 21000 – Accounts Payable, 23000 – Loans
30000–39999 Equity 31000 – Share Capital, 32000 – Retained Earnings
40000–49999 Revenue 41000 – Sales, 42000 – Services Income
50000–59999 Cost of Goods Sold (COGS) 51000 – Materials, 52000 – Purchases
60000–69999 Operating Expenses 61000 – Salaries, 62000 – Rent
70000–79999 Non-operating Income/Expenses 71000 – Interest Income, 72000 – Interest Expense
80000–89999 Year-End Adjustments/Reserves 81000 – Depreciation Reserve

Tip: Leave gaps between numbers for future accounts. For example, start “Cash” at 10100, then you can add more accounts like 10110, 10120 without disrupting numbering.


Step 2: Create G/L accounts in Business Central

From Chart of Accounts → New, you’ll configure fields such as:

Field Purpose
No. Unique account code (e.g., 10100).
Name Clear description (e.g., “Cash – Main Bank”).
Income/Balance Choose Balance Sheet (Assets/Liabilities/Equity) or Income Statement (Revenue/Expenses).
Account Category Helps group accounts in financial statements (Assets, Liabilities, etc.).
Account Subcategory Adds more detail (e.g., “Cash and Cash Equivalents”).
Account Type Options: Posting, Heading, Total, Begin-Total, End-Total.
Direct Posting If checked, users can post directly to this account. Usually off for control accounts (e.g., Accounts Payable).

Step 3: Use account types correctly

Account types let you organize and calculate totals:

  • Posting – Can be posted to (used in journals and transactions).

  • Heading – Group header (e.g., “Current Assets”). Cannot post.

  • Total – Shows the sum of accounts in a range.

  • Begin-Total / End-Total – Used together to define summing ranges.

Example

No. Name Account Type Comment
10000 Assets Heading Top-level grouping
10100 Cash Begin-Total Start total block
10110 Cash – Main Bank Posting Can be posted
10120 Petty Cash Posting Can be posted
10190 Total Cash End-Total Sums 10110–10120

Step 4: Link posting groups

To simplify posting from subledgers, configure Posting Groups. These automatically direct transactions to the correct G/L accounts.

  • General Business Posting Groups – Classify customers/vendors (e.g., Domestic, EU, Export).

  • General Product Posting Groups – Classify items/resources (e.g., Raw Materials, Services).

  • General Posting Setup – Links the above two groups to revenue/expense accounts.

Example: A Domestic customer buys a Service item → mapped via posting groups → posts to Sales Revenue (41000) and Receivables (12000) automatically.


Step 5: Use categories & subcategories for reporting

  • Assign each account to an Account Category (e.g., Assets, Liabilities, Income, Expenses).

  • Refine with Account Subcategory (e.g., Current Assets → Cash).

  • This drives out-of-the-box financial reports and helps with account schedules.


Step 6: Control direct posting

Not all accounts should be posted to directly. Common practice:

  • Disable Direct Posting for:

    • Accounts Payable/Receivable (control via subledgers).

    • VAT/GST accounts (system-calculated).

    • Inventory accounts (controlled by item transactions).

  • Enable Direct Posting for:

    • Adjustment accounts (e.g., Bank Fees).

    • Non-integrated accounts (e.g., Miscellaneous Income).


Step 7: Test & validate

  1. Post a sample transaction (e.g., Sales Invoice) → confirm it hits the right G/L account.

  2. Run the Trial Balance report to ensure totals reconcile.

  3. Verify Balance Sheet and Income Statement categories display correctly.


Best practices

  • Plan before creating: Changing account numbers later is difficult.

  • Keep it lean: Too many accounts = complexity; use dimensions for detailed tracking (e.g., departments, projects).

  • Use totals & headings: Improves readability in the CoA and reports.

  • Standardize naming: Short, descriptive, consistent.

  • Lock down critical accounts: Disable direct posting to prevent errors.

  • Review regularly: Archive unused accounts, ensure categories align with financial reporting needs.


Go-live checklist

  • Numbering scheme finalized with room for growth

  • Posting groups mapped and tested

  • Account categories and subcategories assigned

  • Direct posting disabled where necessary

  • Test transactions posted and reconciled

  • Financial statements verified with accountants


Final thoughts

Setting up the Chart of Accounts in Dynamics 365 Business Central is more than a one-time data entry task—it’s the foundation of your financial reporting. A well-structured CoA, combined with posting groups and dimensions, makes your system scalable, accurate, and audit-ready.

Leave a Reply

Your email address will not be published. Required fields are marked *