7.3 General Ledger Allocation Accounts & Sharing

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:

1. Post vendor invoices to a central holding or clearing account during normal operations.
2. 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

---

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:

$\text{Line Proportion} = \frac{\text{Line Shares}}{\sum \text{Total 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 $\frac{1}{3}$ 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:

The Allocations Subpage & The Balance (B) Method

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

1. Vendor utility bills are posted throughout the month to a central holding account: 61100 Utilities Clearing.
2. At month-end, the accountant opens the Recurring General Journal.
3. 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).
4. The accountant selects Line -> Allocations to open the Allocations subpage.
5. 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.