Study guide

7.3 General Ledger Allocation Accounts & Sharing

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.3 General Ledger Allocation Accounts & Sharing

Key Takeaways Explain This Topic AI

Modern Allocation Accounts (introduced in BC 23) operate as virtual routing accounts selectable directly on purchase, sales, and general journal lines, splitting amounts dynamically upon document posting.

Fixed Allocation Accounts distribute transactional amounts based on static percentages or integer shares across destination G/L accounts and dimensions, supporting full dimension inheritance and overrides.

Variable Allocation Accounts dynamically distribute amounts based on statistical accounts (e.g., headcount, square footage) or financial balances of breakdown G/L accounts across a designated calculation period.

The Redistribute Account Allocations action allows users to inspect, preview, and adjust calculated allocation lines directly on document lines prior to posting.

Traditional Recurring General Journals distribute shared corporate overhead (e.g., rent, utilities) via the Allocations subpage using % or Shares combined with Recurring Methods such as Balance (B).

Last updated: September 2026

7.3 General Ledger Allocation Accounts & Sharing

Quick Summary: In Microsoft Dynamics 365 Business Central, distributing shared overhead costs (such as rent, facility utilities, and corporate IT) across operational departments is managed through two primary architectures: modern Allocation Accounts (Page 267) and traditional Recurring General Journals (Page 283). Modern Allocation Accounts act as virtual routing accounts selectable directly on purchase orders, invoices, and sales lines. They support Fixed Allocations (distributing by fixed percentages or integer shares) and Variable Allocations (dynamically distributing costs based on statistical metrics like headcount or fluctuating account balances). In contrast, traditional Recurring Journals utilize the Allocations subpage paired with recurring methods—most notably the Balance (B) method—to clear central holding accounts and allocate accumulated balances across departments at month-end.

The Evolution of Cost Allocation in Business Central

Historically, allocating shared operational expenses in Business Central required a two-step periodic routine:

Post vendor invoices to a central holding or clearing account during normal operations.

Execute a Recurring General Journal at month-end to calculate balances and post allocation splits across departments.

Beginning in Business Central 2023 release wave 2 (BC 23), Microsoft introduced native Allocation Accounts ( Alt+Q -> type Allocation Accounts , Page 267). This modern framework allows allocations to occur in real time during document entry , eliminating the need for periodic clearing routines.

Architectural Comparison: Modern Allocation Accounts vs. Recurring Journals

Functional Capability Modern Allocation Accounts (Page 267) Traditional Recurring Journals (Page 283)

Transactional Availability Selectable on Purchase Orders, Invoices, Sales Orders, Sales Invoices, and General Journals. Restricted strictly to the Recurring General Journal page.

Execution Timing Distributed immediately upon posting the transactional document. Executed periodically (e.g., month-end close) via batch journal posting.

Allocation Mechanics Fixed (% or Shares) and Variable (dynamic based on breakdown/statistical accounts). Allocations subpage using Allocation % or Shares linked to line amounts or balances.

Document Line Modification Supported via Redistribute Account Allocations action prior to posting. Modifiable only within the journal line allocation subpage.

Use Case Profile Purchasing inventory/services shared across departments at point-of-sale. Month-end corporate overhead clearing, rent amortization, and reversing accruals.

Modern Allocation Accounts Architecture (Page 267)

An Allocation Account is configured on the Allocation Accounts page ( Alt+Q -> type Allocation Accounts ). It serves as an intelligent container that does not maintain a ledger balance itself. When entered on a document line where Account Type = Allocation Account , Business Central expands the container upon posting into discrete general ledger lines. UI Navigation Path:

  • Tell Me (Alt+Q) -> Allocation Accounts (Page 267)
  • Core Header Settings

No. & Name: Unique identifier (e.g., ALLOC-RENT , ALLOC-IT ) and descriptive name.

Account Type: Configured as either Fixed or Variable .

Document Redirection: Controls how document posting routes entries into the General Ledger.

Fixed Allocation Accounts: Percentages vs. Shares

A Fixed Allocation Account distributes transaction amounts across a predetermined set of destination accounts and dimension combinations.

Configuring Destination Lines

On the Destination Lines FastTab, consultants define the distribution grid:

Destination Account Type: Typically set to G/L Account .

Destination Account No.: The general ledger account receiving the distributed portion.

Global & Shortcut Dimensions: Destination-specific dimension tags (e.g., Department ADM , SALES , PROD ).

Allocation % vs. Shares:

Allocation %: Percentages entered numerically (e.g., 60.0 and 40.0 ). The total across all lines must equal exactly 100%.

Shares: Relative integer weights (e.g., 3 shares to Dept A, 2 shares to Dept B). Business Central calculates the proportion dynamically: Line Proportion = Line Shares ∑ Total Shares \text{Line Proportion} = \frac{\text{Line Shares}}{\sum \text{Total Shares}} Line Proportion = ∑ Total Shares Line Shares ​

Why Shares are Preferred: Shares eliminate recurring decimal rounding issues (e.g., splitting an expense equally across three departments requires 33.333%... which leaves an unallocated fraction of a cent. With Shares, setting each line to 1 share creates exact fractional splits of 1 3 \frac{1}{3} 3 1 ​ without rounding discrepancies).

Dimension Inheritance & Overrides

When a purchase invoice line uses an Allocation Account:

If a destination line specifies a dimension value (e.g., Department SALES ), that value overrides any department dimension entered on the invoice header.

If a destination line leaves a dimension blank, Business Central inherits the default dimension value from the document header or line.

Variable Allocation Accounts: Dynamic Metric-Driven Distribution

A Variable Allocation Account dynamically calculates allocation splits at the moment of posting, deriving distribution ratios from the real-time balances of specified Breakdown Accounts . Variable Allocation Dynamic Logic:

  • Transaction Line Amount: $10,000 Software License Expense
  • Breakdown Source: Statistical Account 99100 (Departmental Headcount)
  • Calculation Period: Last Quarter
  • Department Headcount Metric Calculated Proportion Allocated Expense
  • ──────────────────────────────────────────────────────────────────────────────────
  • Administration 10 Employees 10 / 50 = 20% $2,000
  • Production 25 Employees 25 / 50 = 50% $5,000
  • Sales 15 Employees 15 / 50 = 30% $3,000
  • ──────────────────────────────────────────────────────────────────────────────────
  • Total 50 Employees 100% $10,000
  • Core Parameters for Variable Allocations

Breakdown Account No.: The general ledger or statistical account whose balance determines the allocation ratio.

Breakdown Account Dimensions: Filters the breakdown account by specific dimension values (e.g., Department 100 , 200 , 300 ).

Calculation Period: Specifies the date window used to calculate the breakdown account balance:

  • Month
  • Quarter
  • Year
  • Accounting Period
  • Custom Date Range

Breakdown Collection: Defines whether Business Central evaluates the Net Change or Balance at Date of the breakdown account.

Tip

Statistical Accounts in Business Central: Statistical accounts are specialized general ledger accounts (often placed in the 90000 range) used to track non-monetary operational metrics (such as square footage, full-time equivalent [FTE] employee headcount, or machine hours). They provide the numerical foundation for Variable Allocation Accounts without corrupting financial statement totals.

Document Line Interaction: Redistribution & Preview Posting

When entering a purchase invoice, sales order, or general journal line, the user sets:

  • Type: Allocation Account
  • No.: ALLOC-FACILITIES
  • Amount: $12,000
  • The "Redistribute Account Allocations" Action

Before posting, the user can select Action: Line -> Redistribute Account Allocations on the document line. This opens a modal window displaying the exact distribution lines calculated by the allocation engine. From this screen, the user can:

Inspect the calculated percentages and destination dimension values.

Manually override amounts or dimensions for this specific transaction without altering the master Allocation Account template.

Validating via Preview Posting

Executing Preview Posting ( Action Bar: Posting -> Preview Posting ) allows the consultant to inspect the resulting G/L Entry table records. The preview verifies that Business Central expands the single document line into multiple balanced debit and credit entries tagged with appropriate departmental dimensions.

Traditional Recurring General Journal Allocations

While modern Allocation Accounts handle real-time transactional documents, the Recurring General Journal ( Alt+Q -> type Recurring General Journals , Page 283) remains the primary tool for period-end accounting routines. UI Navigation Path:

  • Tell Me (Alt+Q) -> Recurring General Journals (Page 283)
  • Recurring Methods

The Recurring Method field governs how the journal line behaves after posting:

Method Code Balance Retained After Posting? Automatic Reversal on Next Day?

  • Fixed F Yes (Amount remains on line for next cycle) No
  • Variable V No (Amount resets to zero after posting) No
  • Balance B No (Calculates line amount from G/L balance) No
  • Reversing Fixed RF Yes Yes (Reversal entry posted on next day)
  • Reversing Variable RV No Yes (Reversal entry posted on next day)
  • Reversing Balance RB No Yes (Reversal entry posted on next day)
  • The Allocations Subpage & The Balance (B) Method

To allocate shared corporate overhead (such as electricity or facility maintenance) at month-end:

Vendor utility bills are posted throughout the month to a central holding account: 61100 Utilities Clearing .

At month-end, the accountant opens the Recurring General Journal .

The journal line is configured with:

  • Recurring Method: B Balance
  • Recurring Frequency: 1M (repeats monthly)
  • Posting Date: 01/31/2026
  • Account No.: 61100 Utilities Clearing

Amount: Left blank or $0.00 (the B method dynamically retrieves the account balance).

The accountant selects Line -> Allocations to open the Allocations subpage.

On the Allocations subpage, destination lines are configured: Recurring Journal Allocations Subpage Setup:

  • Line Account No. Department Code Allocation % Shares
  • ─────────────────────────────────────────────────────────────
  • 1 61110 ADM 20.0 2
  • 2 61120 SALES 30.0 3
  • 3 61130 PROD 50.0 5
  • ─────────────────────────────────────────────────────────────
  • Total 100.0% 10
  • Execution Mechanics

When the recurring journal batch is posted:

Business Central calculates the total accumulated balance in account 61100 (e.g., $15,000).

It posts a credit entry of $15,000 to 61100 , clearing the holding account balance to zero .

It posts debit entries to 61110 ($3,000), 61120 ($4,500), and 61130 ($7,500) stamped with their respective Department dimensions.

The journal line automatically advances its Posting Date by the Recurring Frequency ( 1M -> 02/28/2026 ) and awaits the next closing cycle.

Loading diagram... Modern Allocation Accounts vs. Traditional Recurring Journal Allocation