Study guide
15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries
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)
15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries
Key Takeaways Explain This Topic AI
Budget plan scenarios hold parallel versions of the same plan, such as Requested, Recommended, and Final approved.
Top-down planning distributes a parent target down the hierarchy; bottom-up planning aggregates departmental proposals upward.
Allocation methods and transformation schedules move amounts between scenarios, periods, and hierarchy levels.
An approved budget plan becomes an actual budget only when budget register entries are generated from it into a budget model.
Last updated: August 2026
15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries
Quick Summary: Scenarios let one budget plan carry several competing versions, allocation schedules move amounts across periods and hierarchy levels, and the approved result is pushed into a budget model as budget register entries. This section covers the full top-down and bottom-up cycle.
1. Top-Down vs. Bottom-Up Planning Methodologies
Dynamics 365 Finance fully supports both major corporate budgeting methodologies: +---------------------------------------------------------------------------------------------------------+
- | Top-Down vs. Bottom-Up Planning Comparison Matrix |
- +---------------------------------------------------------------------------------------------------------+
- | Dimension / Feature | Top-Down Planning | Bottom-Up Planning |
- | :--------------------------- | :---------------------------------- | :--------------------------------- |
- | **Starting Point** | Executive C-Suite sets total target | Department managers enter requests |
- | **Data Flow** | Parent Org Node -> Child Nodes | Child Org Nodes -> Parent Node |
- | **Primary Allocation Method**| **Distribute** Allocation Schedule | **Aggregate** Allocation Schedule |
- | **Department Autonomy** | Low (Allocated fixed targets) | High (Grassroots cost requests) |
- | **Typical Use Case** | Capital constraints / Cost capping | Operational detailed budgeting |
- | **Workflow Direction** | Cascading distribution workflow | Upward approval routing workflow |
- +---------------------------------------------------------------------------------------------------------+
- Detailed Execution Steps
- A. Top-Down Planning Workflow
Executive finance creates a single high-level budget plan at the root node (e.g., $20,000,000 corporate OPEX target in scenario EXEC_TARGET ).
The system executes a Distribute allocation schedule across the organization hierarchy.
The distribution engine evaluates historical actuals or fixed weights and creates child budget plans for each department (e.g., IT receives $2M, Sales receives $10M, Mfg receives $8M).
Department managers receive their pre-allocated targets and enter line-item breakdowns matching the allocated sum.
B. Bottom-Up Planning Workflow
Department managers create child budget plans at the leaf nodes of the hierarchy, entering detailed line-item requests in scenario DEPT_REQ .
When department managers submit plans to workflow, an Aggregate allocation schedule automatically sums line amounts from all child plans into a single parent consolidated plan at the VP / Executive level.
Executive leadership reviews the consolidated plan, makes adjustments, and approves the overall budget.
2. Allocation Methods & Transformation Schedules
Allocation schedules ( Budgeting > Setup > Budget planning > Budget planning configuration > Allocation schedules ) automate the movement and mathematical adjustment of scenario data: +---------------------------------------------------------------------------------------------------+
- | Budget Planning Allocation Methods Breakdown |
- +---------------------------------------------------------------------------------------------------+
- | Allocation Method | Mathematical Mechanics | Practical Scenario |
- | :------------------------- | :----------------------------------- | :---------------------------- |
- | **Copy from scenario** | `Target = Source Scenario × Factor` | `2026_BASE = 2025_ACTUAL × 1.05`|
- | | (e.g., 5% inflation uplift applied). | (Add 5% inflation to actuals). |
- | -------------------------- | ------------------------------------ | ----------------------------- |
- | **Distribute** | Splits parent plan scenario total | Top-down executive target |
- | (Top-Down) | into child plans using weights. | allocated to departments. |
- | -------------------------- | ------------------------------------ | ----------------------------- |
- | **Aggregate** | Sums child plan scenario lines into | Bottom-up consolidation of |
- | (Bottom-Up) | parent organizational plan. | 50 department budget plans. |
- | -------------------------- | ------------------------------------ | ----------------------------- |
- | **Periodic allocation** | Spreads annual scenario total across | Spreads $120k annual target |
- | | 12 monthly period columns. | into $10k monthly columns. |
- | -------------------------- | ------------------------------------ | ----------------------------- |
- | **Allocate across** | Uses General Ledger allocation rules | Spreads facility overhead |
- | **dimensions** | to reallocate across cost centers. | across all cost centers. |
- +---------------------------------------------------------------------------------------------------+
- 3. Budget Plan Worksheets, Layouts & Excel Integration
Worksheet Layouts determine how budget data is rendered on screen and in Microsoft Excel for functional planners. +---------------------------------------------------------------------------------------------------------+
- | Budget Plan Matrix Worksheet Layout |
- +---------------------------------------------------------------------------------------------------------+
- | Layout ID: [ OPEX_MODEL_2026 ] Target Org Unit: [ Dept 020 - Information Technology ] |
- +---------------------------------------------------------------------------------------------------------+
- | Row: Account-Dimension String | Col 1: 2025 Actuals | Col 2: 2026 Dept Request | Col 3: 2026 Approved |
- | :----------------------------- | :------------------ | :----------------------- | :------------------- |
- | `601100-020-100 (Hardware)` | $42,500.00 | $55,000.00 | $50,000.00 |
- | `601200-020-100 (Software)` | $78,200.00 | $90,000.00 | $85,000.00 |
- | `601300-020-100 (Consulting)` | $25,000.00 | $35,000.00 | $30,000.00 |
- | **TOTAL DEPARTMENT PLAN** | **$145,700.00** | **$180,000.00** | **$165,000.00** |
- +---------------------------------------------------------------------------------------------------------+
- The Dynamics 365 Microsoft Excel Add-in Workflow
Inside a Budget Plan, the user clicks Worksheet > Open in Excel .
The system dynamically generates an authenticated .xlsx workbook bound via OData to the Dynamics 365 Data Connector.
Users can leverage native Excel formulas ( SUM , VLOOKUP , AVERAGE ), apply macro models, or paste data from external forecasting tools.
Clicking Publish in the Excel Add-in task pane validates the data against active account structures and writes changes back into the BudgetPlanLine table in real-time.
4. Generating Budget Register Entries from Approved Plans
Once all budget planning stages and executive approval workflows are complete, the approved scenario data must be transferred to the General Ledger as official Budget Register Entries . +---------------------------------------------------------------------------------------------------------+
- | Generate Budget Register Entries from Budget Plan |
- +---------------------------------------------------------------------------------------------------------+
- | Navigation: `Budgeting > Periodic > Generate budget register entries from budget plan` |
- +---------------------------------------------------------------------------------------------------------+
- | Source Parameters: |
- | - **Budget Planning Process:** [ FY2026_CORP_PLAN ] |
- | - **Budget Plan Scenario:** [ 2026_APPROVED ] |
- | - **Organization Hierarchy:** [ Corporate Management Planning Hierarchy ] |
- | - **Hierarchy Node:** [ Root Node: Corporate (Includes All Sub-Departments) ] |
- +---------------------------------------------------------------------------------------------------------+
- | Target Parameters: |
- | - **Target Budget Model:** [ FY2026_MASTER ] |
- | - **Budget Code:** [ ORIG_BUD (Original Budget) ] |
- | - **Default Date / Period:** [ 2026-01-01 ] |
- | - **Document Status:** [ Completed (Auto-post) or Draft (Requires Manual Review) ] |
- +---------------------------------------------------------------------------------------------------------+
- Output and Integration
The periodic job scans all approved budget plan lines under the selected hierarchy node.
It groups lines and creates header and line records in Budget Register Entries ( Budgeting > Budget register entries ).
If Completed is selected, it immediately updates the Budget balances subledger, activating real-time Budget Control and enabling Financial Reporting variance tracking against operational actuals.
5. Exam Traps & Real-World Best Practices
Warning
Exam Trap: Organization Hierarchy Purpose Assignment If department managers cannot see or create budget plans for their organizational units, the most common root cause tested on the MB-310 exam is that the Organization Hierarchy was not assigned the Budget planning purpose under Organization administration > Organizations > Organization hierarchy purposes .
Important
Consultant Pro-Tip: Historical Actuals Load via Periodic Tasks To populate the baseline scenario ( Previous Year Actuals ), navigate to Budgeting > Periodic > Generate budget plan from general ledger . This batch engine queries closed General Ledger transactions for the prior fiscal year, maps them to the appropriate financial dimensions, and writes them directly into the budget plan's baseline scenario.
Loading diagram... Budget Planning Lifecycle: Top-Down Target Distribution, Bottom-Up Proposal Aggregation & Register Generation