Study guide

7.1 Chart of Accounts Structure & G/L Account Cards

Microsoft Dynamics 365 Business Central Functional Consultant MB-800

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Company Creation & Data Migration

1.1 Creating Companies & Assisted Setup Wizards 1.2 Configuration Packages & RapidStart Worksheets 1.3 Opening Balances & Data Migration Strategies

2 Chapter 2: Security, Profiles & Auditing

2.1 Users, User Setup & Role Center Profiles 2.2 Permission Sets & Security Group Management 2.3 Security Filters, Change Log & Security Auditing

3 Chapter 3: Core System Configuration, Number Series & Copilot

3.1 Company Information, Number Series & Job Queues 3.2 Report Layout Management & Copilot AI Capabilities

4 Chapter 4: Dimensions Architecture & Governance

4.1 Dimension Concepts & Dimension Values 4.2 Global Dimensions vs Shortcut Dimensions 4.3 Default Dimensions, Combinations & Priorities

5 Chapter 5: Workflows & Approvals

5.1 Native Workflow Templates & Approval Hierarchy 5.2 Workflow User Groups & Notification Configuration

6 Chapter 6: Financial Setup, Periods & Currencies

6.1 General Ledger Setup & Accounting Periods 6.2 Payment Terms, Payment Methods & Deferrals 6.3 Multi-Currency Setup & Exchange Rates

7 Chapter 7: Chart of Accounts, Categories & Allocations

7.1 Chart of Accounts Structure & G/L Account Cards 7.2 Account Categories, Subcategories & Financial Reporting 7.3 General Ledger Allocation Accounts & Sharing

8 Chapter 8: Posting Groups & Posting Setup

8.1 Specific Posting Groups: Customer, Vendor, Bank & Inventory 8.2 General Posting Groups & General Posting Setup Matrix 8.3 Inventory Posting Setup & Alternative Posting Groups

9 Chapter 9: General Journals & Recurring Methods

9.1 Bank Account Cards & Posting Setup 9.2 General Journal Templates, Batches & Number Series 9.3 Recurring General Journals & Allocation Methods

10 Chapter 10: Accounts Payable & Accounts Receivable Setup

10.1 Purchases & Payables Setup & Vendor Master 10.2 Sales & Receivables Setup & Customer Master 10.3 Payment Journals, Cash Receipts & Payment Registration Setup

11 Chapter 11: Fixed Assets Setup & Depreciation Books

11.1 Fixed Asset Setup, Classes & Depreciation Books 11.2 Fixed Asset Cards, Main/Component Assets & Depreciation Methods

12 Chapter 12: Inventory Setup, Costing & Locations

12.1 Inventory Setup, Item Types, Categories & Variants 12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture 12.3 Locations, Transfer Routes & Stockkeeping Units (SKUs)

13 Chapter 13: Logistics Master Data, Pricing & Discounts

13.1 Shipping Agents, Locations & Vendor Lead Times 13.2 Sales Prices, Purchase Prices & Price Lists 13.3 Line Discounts, Invoice Discounts & Thresholds

14 Chapter 14: User Interface, Views, Inspection & Excel

14.1 Personalization, Profile Customization & Designer 14.2 Searching, Advanced Filters, Saved Views & Page Inspection 14.3 Edit in Excel, OneDrive & Data Analysis Mode

15 Chapter 15: Purchase & Sales Order Execution

15.1 Purchase Orders, Receiving, Over-Receipt & Undo 15.2 Purchase Invoicing, Recurring Lines & Blanket Orders 15.3 Sales Quotes, Availability Checks & Order Conversion 15.4 Sales Shipping, Invoicing, Undo & Blanket Orders

16 Chapter 16: Invoices, Credit Memos & Document Corrections

16.1 Direct Invoices, Credit Memos & Document Reopening 16.2 Correct, Cancel & Corrective Credit Memo Procedures 16.3 Combined Shipments/Receipts & Prepayment Workflows

17 Chapter 17: Cash Management, Bank Reconciliation & Ledger Applications

17.1 Processing Payment Journals & Cash Receipt Registrations 17.2 Applying, Unapplying & Reversing Customer/Vendor Entries 17.3 Bank Account Reconciliation & Statement Matching Rules

18 Chapter 18: Operational Adjustments, Inventory & Asset Accounting

18.1 Exchange Rate Adjustments & Dimension Corrections 18.2 Inventory Adjustments, Transfers & Physical Counting 18.3 Fixed Asset Acquisitions, Depreciation Runs & Disposals

7.1 Chart of Accounts Structure & G/L Account Cards

Key Takeaways Explain This Topic AI

The Chart of Accounts (Page 16) organizes the general ledger into a hierarchical structure, classifying each account as either a Balance Sheet or an Income Statement account.

G/L Account Types comprise Posting, Heading, Total, Begin-Total, and End-Total; the Indent Chart of Accounts routine automatically indents nested accounts and populates Totaling formulas on End-Total accounts.

Totaling formulas support continuous ranges (e.g., 1000..1990) and compound union filters (e.g., 1000..1090|1200..1290), aggregating financial activity dynamically without duplicating transactional ledger entries.

Direct Posting MUST be disabled (set to No) on subledger control accounts (Accounts Receivable, Accounts Payable, Bank, and Inventory) to prevent desynchronization between the general ledger and operational subledgers.

SIFT FlowFilters dynamically toggle financial views between Net Change (activity occurring strictly within the filtered date interval) and Balance at Date (cumulative financial position from inception through the upper date bound).

Last updated: September 2026

7.1 Chart of Accounts Structure & G/L Account Cards

Quick Summary: The Chart of Accounts (Page 16) forms the financial backbone of Microsoft Dynamics 365 Business Central. Every general ledger account card defines whether an account belongs to the Balance Sheet (retaining cumulative balances across fiscal years) or the Income Statement (zeroed out annually by the Close Income Statement batch job). Accounts are structured using five distinct Account Types : Posting , Heading , Total , Begin-Total , and End-Total . Executing the Indent Chart of Accounts routine automatically applies hierarchical indentation and calculates the mathematical Totaling ranges for End-Total accounts. Crucially, the Direct Posting toggle must be disabled on all subledger control accounts (Accounts Receivable, Accounts Payable, Bank, and Inventory) to prevent catastrophic reconciliation variances between subledgers and the General Ledger.

Chart of Accounts Architecture & Numbering Schemes

In Dynamics 365 Business Central, the Chart of Accounts page ( Alt+Q -> type Chart of Accounts , Page 16) displays the master list of all general ledger accounts. It presents both transactional accounts that receive journal entries and summary/heading lines that structure the financial statements. UI Navigation Path:

  • Tell Me (Alt+Q) -> Chart of Accounts (Page 16)
  • Tell Me (Alt+Q) -> G/L Account Card (Page 17)
  • Account Numbering Conventions

Business Central supports alphanumeric account numbers up to 20 characters, but standard financial implementations follow structured numeric block numbering (typically 4 to 8 digits). A standard numerical band structure organizes accounts into recognizable financial statement categories:

  • 10000 – 19999: Assets (Current assets, cash, accounts receivable, inventory, fixed assets)
  • 20000 – 29999: Liabilities (Current liabilities, accounts payable, accrued expenses, notes payable)
  • 30000 – 39999: Equity (Common stock, additional paid-in capital, retained earnings)
  • 40000 – 49999: Revenue / Income (Operational sales revenue, service income, discounts granted)
  • 50000 – 59999: Cost of Goods Sold (COGS) (Direct material costs, direct labor, applied overhead)
  • 60000 – 79999: Operating Expenses (Payroll, rent, utilities, marketing, depreciation)
  • 80000 – 89999: Other Income & Expense (Interest income, interest expense, foreign exchange gains/losses)
  • 90000 – 99999: Income Taxes & Allocation Clearing (Corporate taxes, internal clearing accounts)
  • Income / Balance Classification: Impact on Year-End Closing

On the G/L Account Card , the Income / Balance field designates the account's fundamental accounting role:

Classification Balance Carried Forward? Behavior during Year-End Close

Balance Sheet Yes Cumulative balance carries forward continuously into subsequent fiscal years. Balances are never zeroed out during fiscal year close.

Income Statement No Balances represent periodic activity. When the Close Income Statement batch job is run, Business Central generates closing entries on a special Closing Date (e.g., C12/31/2026 ) that zero out these accounts and transfer net income or loss into Retained Earnings.

Important

Exam Trap: Misclassifying an operational expense account as a Balance Sheet account prevents the Close Income Statement batch job from zeroing out the account at year-end, causing prior-year expenses to bleed into new fiscal years. Conversely, classifying an asset or liability as an Income Statement account will cause the year-end closing routine to wipe out actual asset or debt balances into Retained Earnings.

G/L Account Types & Structural Indenting

To construct a readable, professional chart of accounts, Business Central provides five discrete Account Types on the G/L Account Card:

Account Type Allows Direct Posting? Totaling Field Required? Operational Purpose & Indentation Behavior

Posting Yes No Standard operational account that receives transactional general ledger entries (e.g., Cash, Trade Sales, Rent Expense).

Heading No No Informational line used to title a section or group of accounts (e.g., Current Assets ). It does not calculate or display balances.

Total No Yes (Manual) Summarizes a custom range or compound combination of accounts specified in the Totaling field (e.g., 10100..10900 ).

Begin-Total No No Marks the beginning of an account grouping to be summarized and indented. Does not hold a totaling formula itself.

End-Total No Yes (Automated) Marks the conclusion of an account grouping initiated by a matching Begin-Total . Displays the summarized balance of all accounts in the group.

Totaling Formulas & Syntax Rules

Business Central features a powerful totaling filter syntax utilized across Total accounts, End-Total accounts, and Financial Reports: Totaling Syntax Operators:

  • Continuous Range (..): 10100..10990 (Sums all accounts from 10100 through 10990 inclusive)
  • Union / Logical OR (|): 10100|10200|10500 (Sums accounts 10100, 10200, and 10500 only)
  • Compound Interval: 10100..10190|10500..10590 (Combines two discrete ranges)
  • Wildcard Match (*): 40* (Sums every account number starting with '40')
  • Exclusion Filter (<>): 10100..10990&<>10500 (Sums range 10100-10990 while excluding account 10500)
  • The Automated "Indent Chart of Accounts" Routine

Rather than manually calculating totaling formulas and visual indentations, consultants rely on the automated Indent Chart of Accounts routine ( Action Bar: Process -> Indent Chart of Accounts ). Execution Path:

Chart of Accounts -> Process -> Indent Chart of Accounts

When executed, the system runs a sequential validation algorithm:

Scans the Chart of Accounts from top to bottom, tracking Begin-Total and End-Total pairs.

Matches each End-Total with its corresponding preceding Begin-Total at the same hierarchical depth.

Automatically calculates the exact account range between the Begin-Total and End-Total and writes that range into the Totaling field of the End-Total account card.

Visually indents the account descriptions of all intermediate accounts by one tab stop (or multiple tab stops for nested groupings).

Note

Running Indent Chart of Accounts overwrites any existing values in the Totaling fields of End-Total accounts. However, standalone Total accounts are left untouched by the routine, preserving any custom manual totaling formulas.

Critical Governance Controls on the G/L Account Card

The Posting FastTab of the G/L Account Card houses security and governance toggles that prevent data corruption and enforce accounting integrity.

1. Direct Posting: Subledger Synchronization Governance

The Direct Posting boolean toggle governs whether users can manually select the G/L account on journal lines, purchase documents, or sales documents.

Direct Posting = Yes: The account is open for manual debit and credit entries in General Journals, Purchase Invoices, and Sales Invoices. Appropriate for standard operational expense and revenue accounts.

Direct Posting = No (MANDATORY for Subledger Controls): The account cannot be selected manually on journal lines or document lines. It can only receive financial postings automatically generated by Business Central's posting routines through Posting Groups. Subledger Desynchronization Hazard (Why Direct Posting MUST be 'No'):

Scenario: Direct Posting mistakenly left set to 'Yes' on Account 10400 (Accounts Receivable Control)

  • User Posts General Journal Entry: Debit: $5,000 to G/L Account 10400 (Directly)
  • Credit: $5,000 to G/L Account 40100 (Sales)

Database Consequence:

  • ├── General Ledger Entry Table: Account 10400 balance INCREASES by $5,000
  • └── Customer Ledger Entry Table: NO ENTRY CREATED (No Customer No. was referenced!)

Resulting Discrepancy:

  • ├── G/L Trial Balance (Account 10400): $105,000
  • ├── Aged Accounts Receivable Report: $100,000
  • └── RECONCILIATION VARIANCE: $5,000 (Permanent audit failure)

To ensure flawless subledger reconciliation, Direct Posting must be set to No on all control accounts linked to:

  • Customer Posting Groups (Accounts Receivable control)
  • Vendor Posting Groups (Accounts Payable control)
  • Bank Account Posting Groups (Cash/Bank control accounts)
  • Inventory Posting Setup (Inventory Asset, WIP, and Inventory Adjustment accounts)
  • 2. Reconciliation Account

Enabling the Reconciliation Account boolean flag makes the account visible in the Reconciliation pane of General Journals, Payment Journals, and Cash Receipt Journals. As an accountant enters journal lines, the pane dynamically displays:

The account's starting balance.

The net change resulting from unposted journal lines.

The projected post-posting balance.

This is widely used for petty cash, bank clearing accounts, and payroll withholding accounts.

3. Blocked Status & Deletion Constraints

Setting Blocked = Yes immediately freezes the account. Business Central will reject any posting attempt targeting a blocked account with a validation error.

Warning

Deletion Constraint: Business Central enforces strict relational database integrity. A G/L account cannot be deleted if it has any posted entries in the G/L Entry table, or if it is currently specified in any posting setup table (General Posting Setup, Customer Posting Groups, etc.). If an account is obsolete or retired, the consultant must set Blocked = Yes rather than attempting deletion.

4. Debit/Credit Posting Restrictions

The Debit/Credit field restricts posting directions:

Both (Default): Permits both debit and credit transactions.

Debit: Rejects any transaction that attempts to post a credit amount to the account.

Credit: Rejects any transaction that attempts to post a debit amount to the account.

This is typically applied to revenue accounts (Credit only) or expense accounts (Debit only) to prevent accidental data entry errors.

Dynamic Reporting with SIFT FlowFilters

Business Central calculates general ledger balances in real time using Sum Index Field Technology (SIFT) rather than maintaining static balance counters. The Chart of Accounts leverages two fundamental FlowFields influenced by user-applied FlowFilters : FlowFilter Application Matrix:

Active Date Filter = 01/01/2026..01/31/2026

  • FlowField Column Calculation Scope Accounting Usage
  • ─────────────────────────────────────────────────────────────────────────────────────────────
  • Net Change SUM(Debits - Credits) Income Statement analysis;

Strictly between 01/01/26 and 01/31/26 evaluates period operational activity.

Balance at Date SUM(Debits - Credits) Balance Sheet position;

Cumulative from inception to 01/31/26 evaluates financial snapshot at date.

In addition to Date Filters, consultants can apply Global Dimension 1 Filter and Global Dimension 2 Filter to instantly analyze departmental or divisional performance directly from the Chart of Accounts page without running external reports.

Loading diagram... Chart of Accounts Structure, Indentation & Subledger Control Isolation