Study guide

7.2 Account Categories, Subcategories & Financial Reporting

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.2 Account Categories, Subcategories & Financial Reporting

Key Takeaways Explain This Topic AI

G/L Account Categories (Page 570) structure general ledger accounts into six standardized main categories (Assets, Liabilities, Equity, Income, Cost of Goods Sold, Expense) with customizable subcategories.

Assigning categories and subcategories to G/L Account Cards establishes a bidirectional link with the G/L Account Categories table, and executing 'Generate Financial Reports' automatically updates standard financial statements.

Modern Financial Reporting (formerly Account Schedules) decouples reporting into independent Row Definitions (formatting, totaling types, row types) and Column Definitions (periods, comparison formulas, budgets).

Row Definitions utilize Row Types (Net Change, Balance at Date, Beginning Balance) and Totaling Types (Posting Accounts, Total Accounts, Formula) to calculate operational metrics like Gross Profit and Net Income.

Column Definitions leverage Comparison Date Formulas (e.g., -1Y) and Comparison Period Formulas (e.g., -1P) to generate multi-period variance analyses, budget comparisons, and rolling management forecasts.

Last updated: September 2026

7.2 Account Categories, Subcategories & Financial Reporting

Quick Summary: In Microsoft Dynamics 365 Business Central, G/L Account Categories (Page 570) provide a business-friendly classification layer that organizes accounts into six standard root categories: Assets , Liabilities , Equity , Income , Cost of Goods Sold , and Expense . Assigning subcategories to G/L account cards automatically links accounts to reporting lines, and executing the Generate Financial Reports action automatically updates the out-of-the-box financial statements. For advanced management reporting, Business Central provides modern Financial Reporting (formerly Account Schedules ). This engine separates reporting structure into two modular building blocks: Row Definitions (governing lines, totaling types, and mathematical formulas) and Column Definitions (governing reporting periods, budget comparisons, and variance formulas).

G/L Account Categories Architecture (Page 570)

While the Chart of Accounts serves technical and transactional posting needs, executive leadership and external auditors require structured financial statements. The G/L Account Categories page ( Alt+Q -> type G/L Account Categories , Page 570) bridges this gap by grouping accounts into intuitive reporting nodes. UI Navigation Path:

  • Tell Me (Alt+Q) -> G/L Account Categories (Page 570)
  • The Six Root Categories

Business Central enforces six permanent, hardcoded root categories:

  • Assets (Debit normal balance)
  • Liabilities (Credit normal balance)
  • Equity (Credit normal balance)
  • Income (Credit normal balance)
  • Cost of Goods Sold (Debit normal balance)
  • Expense (Debit normal balance)

Consultants cannot delete or alter these six root classifications. However, organizations can build deeply nested, customized subcategory hierarchies underneath each root.

Subcategory Hierarchy & Key Fields

On the G/L Account Categories page, each subcategory line contains critical configuration attributes:

Description: The human-readable name of the financial line item (e.g., Cash and Cash Equivalents , Trade Receivables , Prepaid Rent ).

Account Category: The parent root classification to which this line belongs.

Additional Report Definition: Maps the subcategory to standardized accounting roles for automated cash flow and equity reporting. Options include: Operating Activities , Investing Activities , Financing Activities , Cash Accounts , Retained Earnings , and Distribution to Shareholders .

G/L Accounts in Category: A drilldown field displaying all accounts assigned to this line.

Totaling: The filter expression defining the G/L accounts summarized by this category (e.g., 10100..10190|10250 ).

Balance: A real-time FlowField displaying the current consolidated balance of the category.

Bidirectional Account-to-Category Synchronization

Business Central maintains a synchronized relationship between the G/L Account Card and Account Categories:

If a consultant edits a G/L Account Card and populates the Account Category and Account Subcategory fields, Business Central automatically appends that account number to the Totaling range on the corresponding line in the G/L Account Categories table.

Conversely, if a consultant manually enters or expands an account range in the Totaling column on the G/L Account Categories page, Business Central automatically updates the Account Category and Subcategory fields on the underlying G/L Account Cards. Bidirectional Sync Flow:

  • G/L Account Card (Account 10150)
  • [Account Category: Assets] ◄──► G/L Account Categories Table
  • [Account Subcategory: Cash & Equiv] [Subcategory: Cash & Equiv -> Totaling: 10100..10190]
  • The "Generate Financial Reports" Action

Once the category structure and account mappings are established, selecting Action Bar: Process -> Generate Financial Reports initiates an automated compiler: Execution Path:

G/L Account Categories -> Process -> Generate Financial Reports

This routine scans the category hierarchy and automatically builds or synchronizes the four standard Microsoft financial reports:

  • M-BALANCE: Standard Balance Sheet
  • M-INCOME: Standard Income Statement
  • M-CASHFLOW: Statement of Cash Flows
  • M-RETAIN: Statement of Retained Earnings

Any structural change made to account subcategories or totaling ranges is instantly pushed into these standard financial report definitions upon running this action.

Modern Financial Reporting Architecture (Formerly Account Schedules)

In modern Business Central versions, Microsoft rebranded Account Schedules to Financial Reports ( Alt+Q -> type Financial Reports , Page 108). Financial Reports provide a multi-dimensional matrix reporting engine that decouples financial presentation into two independent, reusable building blocks: Financial Report Composition Architecture:

  • ┌──────────────────────────────────────┐ ┌──────────────────────────────────────┐
  • │ ROW DEFINITION │ │ COLUMN DEFINITION │
  • │ (Lines, Totaling Types, Formulas) │ │ (Periods, Actual vs Budget, Dates) │
  • └──────────────────┬───────────────────┘ └──────────────────┬───────────────────┘
  • │ │
  • └───────────────────────┬──────────────────────┘
  • ▼
  • ┌──────────────────────────────────────┐
  • │ FINANCIAL REPORT │
  • │ (Interactive View, Print, Excel) │
  • └──────────────────────────────────────┘

This modular decoupling allows a single Row Definition (e.g., Executive Income Statement Rows ) to be viewed with multiple Column Definitions (e.g., Monthly Trend , Actual vs. Budget , Year-over-Year Comparative ) without redefining report rows.

Designing Row Definitions: Lines, Formulas & Formatting

A Row Definition ( Row Definition page) dictates what rows appear on the report, how values are retrieved from the General Ledger, and what mathematical calculations are performed.

Core Configuration Fields on Row Definitions

Row No.: An alphanumeric code (e.g., 10 , 20 , REV , COGS ) assigned to the line. Row numbers serve as algebraic variables in mathematical row formulas.

Description: The text header displayed on the report.

Totaling Type: Dictates how Business Central populates the row value:

Posting Accounts: Sums the balances of standard G/L accounts listed in the Totaling field.

Total Accounts: Sums accounts of type Total or End-Total .

Formula: Performs algebraic math using other Row Nos. (e.g., 10-20 or 10..50 ).

Underline & Double Underline: Inserts single or double accounting rule lines.

Set View for Soft Closing: Configures advanced period view boundaries.

Totaling: Contains the account filter (e.g., 40100..40900 ) when Totaling Type is Posting Accounts , or the mathematical expression (e.g., 10-20 for Gross Profit ) when Totaling Type is Formula .

Row Type: Governs the time aggregation of transactional entries:

Net Change: Aggregates transactions strictly within the active Date Filter period (standard for Income Statement revenue and expense rows).

Balance at Date: Evaluates the cumulative balance from company inception through the report end date (standard for Balance Sheet asset and liability rows).

Beginning Balance: Evaluates the opening balance on the first day of the report period.

Amount Type: Restricts aggregation to Net Amount , Debit Amount , or Credit Amount .

Show: Governs row visibility: Yes (always visible), No (hidden calculation row used as an intermediate step in formulas), or If Any Row Has Balance (suppresses lines with zero balances).

Formatting Toggles: Bold , Italic , and New Page (page break insertion). Example Row Definition Layout: Income Statement

  • Row No. Description Totaling Type Totaling Row Type Show Bold
  • ──────────────────────────────────────────────────────────────────────────────────────────────────
  • 10 Operating Revenue Posting Accounts 40100..40990 Net Change Yes No
  • 20 Cost of Goods Sold Posting Accounts 50100..50990 Net Change Yes No
  • 30 ------------------------ Underline Net Change Yes No
  • 40 Gross Profit Formula 10-20 Net Change Yes YES
  • 50 Operating Expenses Posting Accounts 60100..69990 Net Change Yes No
  • 60 ======================== Double Underline Net Change Yes No
  • 70 Net Operating Income Formula 40-50 Net Change Yes YES
  • Designing Column Definitions: Periods, Comparisons & Budgets

A Column Definition ( Column Definition page) dictates what data appears across the horizontal columns of the report.

Core Configuration Fields on Column Definitions

Column No.: An alphanumeric identifier (e.g., C10 , C20 , 1 , 2 ) used in column formulas.

Column Header: Text displayed at the head of the column.

Column Type: Defines the temporal nature of the column:

Net Change: Movement strictly during the filtered date period.

Balance at Date: Cumulative balance through the end date.

Year to Date (YTD): Cumulative transactions from the start of the current fiscal year through the report end date.

Entire Fiscal Year: Total transactions across all periods of the fiscal year.

Formula: Calculates a mathematical expression combining other columns (e.g., 2-1 for variance).

Ledger Entry Type: Selects between Entries (actual general ledger entries) and Budget Entries (general ledger budget amounts).

Comparison Date Formula: A date formula offset (e.g., -1Y for prior year, -1M for prior month) that shifts the active Date Filter.

Comparison Period Formula: A period-based offset (e.g., -1P for prior accounting period, -1FY for prior fiscal year). Example Column Definition Layout: Actual vs. Budget Variance Analysis

  • Col No. Header Column Type Entry Type Comparison Date Formula Formula Show
  • ─────────────────────────────────────────────────────────────────────────────────────────────
  • 10 Actual MTD Net Change Entries Always
  • 20 Budget MTD Net Change Budget Entries Always
  • 30 $ Variance Formula 10-20 Always
  • 40 % Variance Formula (10-20)/20*100 Always
  • 50 Prior Year Net Change Entries -1Y Always
  • Management Reporting Execution & Dimensions Integration

When end users run a financial report from the Financial Reports page ( Tell Me -> Financial Reports ), they can dynamically filter by:

Date Filter: Restricting the reporting window (e.g., 01/01/2026..03/31/2026 for Q1).

Dimension Filters: Applying Department, Customer Group, or Project filters to analyze segment profitability.

Analysis Views: Linking the report to a pre-aggregated Analysis View optimizes reporting speed for massive transaction volumes and unlocks reporting on Shortcut Dimensions 3 through 8 .

Loading diagram... Modern Financial Reporting Engine: Decoupled Modular Architecture