5.5 Ledger Allocation Rules & the Four Allocation Methods

Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: MB-310 Exam Overview & Financial Architecture

1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework

2 Chapter 2: Chart of Accounts & Main Accounts

2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions

3 Chapter 3: Financial Dimensions & Account Structures

3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates

4 Chapter 4: Ledgers, Calendars & Currencies

4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

5 Chapter 5: General Ledger Journals & Allocations

5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals

6 Chapter 6: Intercompany Accounting & Settlements

6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing

7 Chapter 7: Cash and Bank Management

7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting

8 Chapter 8: Periodic Closing & Financial Consolidations

8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules

9 Chapter 9: Sales Tax & Withholding Tax

9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting

10 Chapter 10: Accounts Receivable Setup & Invoicing

10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts

11 Chapter 11: Credit Management & Collections

11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

12 Chapter 12: Subscription Billing & Revenue Deferrals

12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)

13 Chapter 13: Accounts Payable & Invoice Processing

13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation

14 Chapter 14: Vendor Payments & Expense Management

14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses

15 Chapter 15: Budgeting & Budget Control

15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries

16 Chapter 16: Fixed Assets Configuration & Transactions

16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)

5.5 Ledger Allocation Rules & the Four Allocation Methods

Key Takeaways Explain This Topic AI

A ledger allocation rule has a source (what to allocate), a destination (where it goes), and an allocation method that determines the split.

The four allocation methods are Basis, Fixed percentage, Fixed weight, and Equally.

The Basis method allocates in proportion to actual balances in a chosen basis account and dimension set, so the split changes every period.

Fixed weight allocates by relative weights that need not total 100, while Fixed percentage requires the destination lines to total exactly 100 percent.

Last updated: August 2026

5.5 Ledger Allocation Rules & the Four Allocation Methods

Quick Summary: In enterprise financial management, indirect operating costs—such as corporate facility rent, shared IT infrastructure, human resources overhead, and executive administration—are typically captured in centralized cost pools. Ledger Allocation Rules automate the mathematical reallocation of these pools to benefiting operational departments or business units. Simultaneously, Periodic Journals provide reusable recurring transaction templates for predictable periodic expenses.

1. Ledger Allocation Rules Architecture

Ledger Allocation Rules define how monetary balances are extracted from a Source account/dimension pool, mathematically calculated, and posted to Destination accounts/dimensions, while creating balanced Offset entries.

Navigation

Path: General ledger > Allocations > Ledger allocation rules +-----------------------------------------------------------------------------+

| Ledger Allocation Rule Record |
| Rule ID: ALLOC-RENT-HQ Allocation Method: Basis |
| Description: Monthly HQ Rent Allocation Target Journal: ALLOC-MO |
+-----------------------------------------------------------------------------+
| 1. SOURCE FASTTAB: |
| - Main Account: 620100 (Facility Rent) | Department: 000 (Unallocated) |
| - Amount to allocate: 100% of balance | Period: Current Period |
+-----------------------------------------------------------------------------+
| 2. DESTINATION FASTTAB: |
| - Main Account: 620100 (Facility Rent) |
| - Destination Departments: 022 (Sales), 023 (R&D), 024 (Admin) |
+-----------------------------------------------------------------------------+
| 3. OFFSET FASTTAB: |
| - Main Account: 620100 (Source Account) or 620199 (Allocation Offset) |
| - Department: 000 (Clears the source cost pool) |
+-----------------------------------------------------------------------------+
Core Structural Components of an Allocation Rule

Header Parameters:

Rule: Alphanumeric identifier (e.g., RENT-ALLOC , IT-SHARE ).

Status: Active (eligible for processing), Draft (under configuration), or Hold (temporarily disabled).

Allocation method: Dictates the mathematical distribution algorithm ( Basis, Fixed percentage, Fixed weight, Spread even ).

Journal name: An allocation journal name (Journal type = Allocation ) where the generated voucher lines will be written.

Intercompany rule: Toggle enabling cross-company allocation vouchers between multiple legal entities.

Source FastTab: Defines the criteria used to collect funds from the General Ledger. You specify the Chart of Accounts, Main Account filters (e.g., 620100 ), Financial Dimension filters (e.g., Department = 000 ), and whether to accumulate balances across the Current period , Fiscal year to date , or Specific date range .

Destination FastTab: Defines the target accounts and financial dimensions that will receive the allocated debit (or credit) amounts.

Offset FastTab: Defines where the balancing credit (or debit) is posted to relieve the source cost pool. Organizations can offset directly to the Source account or route to a dedicated Allocation Offset Account (e.g., 620199 - Rent Allocation Offset ) to maintain gross expenditure visibility on financial statements.

2. The Four Allocation Methods & Mathematical Calculations
Dynamics 365 Finance provides four powerful allocation algorithms: +---------------------------------+
| Allocation Method Selection |
+---------------------------------+
|
+--------------------+-----------------+-----------------+--------------------+
| | | |
v v v v
[ 1. BASIS ] [ 2. FIXED PERCENTAGE ] [ 3. FIXED WEIGHT ] [ 4. SPREAD EVEN ]

Dynamic Ratio: Predetermined Static %: Relative Ratio: Equal Division:

Actual Balances Must sum <= 100% Arbitrary Weight 1 / N per Line
or Statistical (e.g., 40%, 35%, 25%) Units (e.g., 12, 8, 4) (e.g., 25% each)
Dimensions
Method 1: Basis (Mathematical / Statistical Dynamic Distribution)

Mechanism: The system calculates allocation percentages dynamically by querying the live transactional balances of a designated Basis Account (which can be a financial expense account or a statistical Reporting account like Headcount or Square Footage).

Formula: Allocation Share i = Source Cost Pool × ( Basis Account Balance i ∑ j = 1 n Basis Account Balance j ) \text{Allocation Share}_i = \text{Source Cost Pool} \times \left( \frac{\text{Basis Account Balance}_i}{\sum_{j=1}^{n} \text{Basis Account Balance}_j} \right) Allocation Share i = Source Cost Pool × ( ∑ j = 1 n Basis Account Balance j Basis Account Balance i )

Mathematical Worked Example:

Source Pool: HQ Facility Rent (Account 620100 , Dept 000 ) = $120,000.00 .

Basis Driver: Statistical Main Account 900100 (Department Square Footage):

Department 022 (Retail Sales): 6,000 sq ft
Department 023 (Engineering): 4,000 sq ft
Department 024 (Executive): 2,000 sq ft

Total Basis Sum: 6 , 000 + 4 , 000 + 2 , 000 = 12 , 000 sq ft 6,000 + 4,000 + 2,000 = 12,000\text{ sq ft} 6 , 000 + 4 , 000 + 2 , 000 = 12 , 000 sq ft

Calculated Allocation Lines:

Dept 022: $120,000.00 * (6,000 / 12,000) = $60,000.00 (50.00%)
Dept 023: $120,000.00 * (4,000 / 12,000) = $40,000.00 (33.33%)
Dept 024: $120,000.00 * (2,000 / 12,000) = $20,000.00 (16.67%)
Offset (Dept 000): Credit -$120,000.00
Method 2: Fixed Percentage

Mechanism: Allocates the source pool based on static, hardcoded percentage values assigned to each destination line. Total percentages cannot exceed 100%.

Mathematical Worked Example:

Source Pool: Centralized IT Software Licenses = $80,000.00 .

Percentages: BU01 = 45%, BU02 = 35%, BU03 = 20% (Total = 100%).

Calculations:

BU01: $80,000.00 * 0.45 = $36,000.00
BU02: $80,000.00 * 0.35 = $28,000.00
BU03: $80,000.00 * 0.20 = $16,000.00
Method 3: Fixed Weight

Mechanism: Allocates amounts based on arbitrary assigned numerical weights (e.g., relative server capacity, project complexity points, or estimated service tiers).

Formula: Destination Share i = Source Cost Pool × ( Weight i ∑ Weights ) \text{Destination Share}_i = \text{Source Cost Pool} \times \left( \frac{\text{Weight}_i}{\sum \text{Weights}} \right) Destination Share i = Source Cost Pool × ( ∑ Weights Weight i )

Mathematical Worked Example:

Source Pool: Corporate Legal Retainer = $90,000.00 .

Weights Assigned: Division North = 15, Division South = 10, Division West = 5. (Total Weight = 30).

Calculations:

Division North: $90,000.00 * (15 / 30) = $45,000.00 (50.0%)
Division South: $90,000.00 * (10 / 30) = $30,000.00 (33.33%)
Division West: $90,000.00 * (5 / 30) = $15,000.00 (16.67%)
Method 4: Spread Even

Mechanism: Divides the source pool equally ( 1 / N 1/N 1/ N ) across all active destination lines.

Mathematical Worked Example:

Source Pool: Annual External Audit Fee = $100,000.00 across 4 Business Units.

Calculation: $100,000.00 / 4 = $25,000.00 allocated to each Business Unit.

Allocation Methods Comparison Matrix

Allocation Method Calculation Driver Flexibility / Adaptability Maintenance Overhead Typical Business Scenario

Basis Dynamic ledger or statistical account balances Dynamic: Adjusts automatically each month as basis balances change Low (Maintained via monthly statistical entries) Facilities rent by sq ft, HR overhead by headcount, IT support by server calls

Fixed Percentage Static percentage figures Static: Requires rule edits if operational shares shift Moderate (Requires manual update when % changes) Joint venture expense sharing, fixed management service contracts

Fixed Weight Relative numerical weights Semi-Static: Automatically normalizes when weights are added/edited Moderate (Update weights periodically) Product line marketing allocation by relative complexity points

Spread Even Count of destination rows ( 1 / N 1/N 1/ N ) Static: Even mathematical split across defined nodes Low Shared board of directors expenses, uniform subsidiary compliance fees