8.2 Year-End Close Configuration & General Ledger Balance Carryforward
Key Takeaways
- Year-End Close in Dynamics 365 Finance executes two primary accounting functions: carrying forward ending Balance Sheet balances as opening balances for the new fiscal year, and zeroing out Profit & Loss (P&L) balances into Retained Earnings.
- The modern Year-End Close service uses a template-driven framework under General ledger > Ledger setup > Year-end close configuration, supporting independent dimension carryforward rules for Balance Sheet vs. P&L accounts.
- Setting P&L dimension transfer to 'Close all' preserves full departmental and cost center granularity when sweeping net income into Retained Earnings, whereas 'Close single' or 'Close none' consolidates net income into summarized retained earnings balances.
- The Year-End Close process can be rerun multiple times for a closed fiscal year after posting audit adjustments; enabling 'Delete existing year-end entries when rerunning the year-end close' ensures opening balances reflect updated totals without duplicate voucher accumulation.
- Permanently closing a fiscal year ('Hard close' in Ledger calendars) is an irreversible action; organizations should keep prior periods 'On hold' during audits and only execute a hard close when financial statements are officially published.
8.2 Year-End Close Configuration & General Ledger Balance Carryforward
Quick Summary: At the conclusion of a fiscal year, organizations must execute the Year-End Close process to prepare the general ledger for the upcoming operating cycle. In Microsoft Dynamics 365 Finance, Year-End Close serves two fundamental accounting functions: (1) rolling forward ending Balance Sheet (Asset, Liability, Equity) balances into Opening Balances (Period 0) of the new fiscal year, and (2) zeroing out Profit and Loss (Revenue, Expense) accounts and transferring net income/loss into designated Retained Earnings equity accounts. Configured under General ledger > Ledger setup > Year-end close configuration and executed via General ledger > Periodic tasks > Year-end close, this high-performance service supports granular financial dimension carryforward rules and repeatable post-audit reruns.
1. Architectural Principles of Year-End Close
Dynamics 365 Finance handles year-end closing differently depending on the Main Account Type assigned to each account in the active Chart of Accounts:
+---------------------------------------------------------------------------------------------------------+
| Year-End Close Ledger Mechanics |
+---------------------------------------------------------------------------------------------------------+
| FISCAL YEAR 2026 (Ending Balances) FISCAL YEAR 2027 (Opening Balances) |
| |
| BALANCE SHEET ACCOUNTS (Asset, Liab, Equity) OPENING BALANCES (Period 0) |
| - Operating Bank (110110) ........ $150,000 (Dr) --------> - Operating Bank (110110) ..... $150,000 (Dr)|
| - Accounts Payable (210100) ..... $80,000 (Cr) ----------> - Accounts Payable (210100) .. $80,000 (Cr) |
| - Common Stock (300100) ......... $50,000 (Cr) ----------> - Common Stock (300100) ...... $50,000 (Cr) |
| |
| PROFIT & LOSS ACCOUNTS (Revenue, Expense) RETAINED EARNINGS (Equity Account 300200) |
| - Sales Revenue (400100) ........ $500,000 (Cr) --+ |
| - Consulting Revenue (400200) ... $200,000 (Cr) --+ |
| - Payroll Expense (600100) ...... $350,000 (Dr) --+------> - Net Income ($20,000 Cr) transferred into |
| - Rent Expense (600200) ......... $120,000 (Dr) --+ Retained Earnings (300200) Opening Balance. |
| - IT / Software Expense (600300) $210,000 (Dr) --+ (P&L accounts reset to $0.00 in 2027). |
| [Net P&L Balance = $20,000 Net Income (Cr)] | |
+---------------------------------------------------------------------------------------------------------+
Account Type Behaviors During Year-End Close
| Main Account Type | Year-End Close System Behavior | Opening Period (Period 0) Balance |
|---|---|---|
| Asset | Ending balance carries forward continuously. | Equals ending balance of prior year. |
| Liability | Ending balance carries forward continuously. | Equals ending balance of prior year. |
| Equity | Ending balance carries forward continuously. | Equals ending balance of prior year. |
| Revenue | Balances are summarized, cleared to $0.00, and transferred to Retained Earnings. | $0.00 |
| Expense | Balances are summarized, cleared to $0.00, and transferred to Retained Earnings. | $0.00 |
| Total / Header | Structural reporting accounts; no direct transactional carryforward. | $0.00 |
2. Configuring the Year-End Close Template
Year-End Close configuration is centralized in General ledger > Ledger setup > Year-end close configuration. Configuration templates are established per legal entity or shared across entities utilizing the same chart of accounts.
+---------------------------------------------------------------------------------------------------+
| Year-End Close Configuration Form Structure |
+---------------------------------------------------------------------------------------------------+
| Header / Template Properties: |
| - Name: `Global_YEC_Template` |
| - Chart of Accounts: `Shared_COA` |
| ----------------------------------------------------------------------------------------------- |
| Legal Entity Assignments & Retained Earnings Setup: |
| - Legal Entity: `USMF` |
| - Main Account for Retained Earnings: `300200` (Retained Earnings - Operations) |
| - Default Retained Earnings Account for Dimensions: `300200` |
| ----------------------------------------------------------------------------------------------- |
| Financial Dimension Carryforward Rules: |
| - Balance Sheet Dimensions: [ BusinessUnit: Close All ] [ Department: Close All ] |
| - Profit & Loss Dimensions: [ BusinessUnit: Close All ] [ Department: Close Single (000) ] |
+---------------------------------------------------------------------------------------------------+
Key Configuration Parameters
- Main Account for Retained Earnings: The target equity account that receives the net profit or loss balance cleared from all P&L accounts.
- Transfer Balance Sheet Dimensions: Governs whether balance sheet account ending balances maintain their specific financial dimension values (e.g., Cash - Dept 100) or are collapsed into un-dimensioned opening balances.
- Transfer Profit and Loss Dimensions: Determines how dimension combinations on revenue and expense accounts are handled when posting into Retained Earnings.
3. Financial Dimension Carryforward Rules Matrix
How financial dimensions roll forward into opening balances is one of the most critical architectural decisions for financial reporting. Dynamics 365 Finance provides three distinct transfer options per dimension:
+---------------------------------------------------------------------------------------------------+
| Financial Dimension Carryforward Rule Options |
+---------------------------------------------------------------------------------------------------+
| Option | Functional Mechanics | Reporting Impact |
| :------------------ | :-------------------------------------------- | :-------------------------- |
| **Close All** | Preserves every distinct dimension value | Granular multi-dimensional |
| | combination in opening balances. | opening balance reporting. |
| **Close Single** | Overrides all source dimension values with a | Consolidates balances into a|
| | single designated default dimension value. | single dimension bucket. |
| **Do Not Transfer** | Drops the financial dimension entirely; | Balances roll forward with |
| (Close None) | opening balance contains blank/null dimension.| blank dimension values. |
+---------------------------------------------------------------------------------------------------+
Concrete Example: P&L Dimension Carryforward into Retained Earnings
Assume company USMF earns $100,000 Net Income in 2026 across two departments:
- Department 100 (Sales): $70,000 Net Profit
- Department 200 (Marketing): $30,000 Net Profit
| Configuration on P&L Dimension (Department) | Opening Voucher Line(s) Generated in Period 0 (Account 300200) |
|---|---|
| Close All | Line 1: Account 300200-Dept 100 Credit $70,000<br/>Line 2: Account 300200-Dept 200 Credit $30,000 |
Close Single (Default: Dept 000) | Line 1: Account 300200-Dept 000 Credit $100,000 |
| Do Not Transfer | Line 1: Account 300200-Blank Credit $100,000 |
[!TIP] In most enterprise implementations, Balance Sheet dimensions are configured as Close All (to maintain asset/liability tracking by Business Unit and Department), while P&L dimensions are configured as Close All or Close None depending on whether the business tracks retained earnings equity by department.
4. Running the Year-End Close Batch Process
Once the configuration template is verified, the close process is initiated under General ledger > Periodic tasks > Year-end close.
+---------------------------------------------------------------------------------------------------------+
| Year-End Close Execution Wizard & Parameters |
+---------------------------------------------------------------------------------------------------------+
| Field Name | Value / Selection | Functional Description |
| --------------------------- | --------------------------- | ------------------------------------------ |
| **Year-End Close Template** | `Global_YEC_Template` | Selects active entity & dimension rules. |
| **Legal Entity** | `USMF` | Target legal entity to close. |
| **Fiscal Year** | `2026` | The fiscal year being closed. |
| **Voucher Number** | `YEC-2026-001` | Voucher assigned to closing/opening entries|
| **Batch Processing** | `Yes` | Executes asynchronously via batch service. |
+---------------------------------------------------------------------------------------------------------+
Step-by-Step Execution Sequence
- Pre-Close Verification:
- Ensure all subledger journals (AP, AR, Inventory, Fixed Assets, Bank) are fully posted for all 12 periods.
- Perform foreign currency revaluations on open AP, AR, and GL balances.
- Reconcile the General Ledger Trial Balance against subledger control accounts.
- Period Status Verification:
- Open
General ledger > Calendars > Ledger calendars. - Ensure Period 1 through Period 12 status is set to On Hold (to prevent new transactional entries during close processing).
- Ensure the upcoming fiscal year (2027) exists in the calendar and Period 0 (Opening) through Period 1 are Open.
- Open
- Execute Year-End Close:
- Navigate to
General ledger > Periodic tasks > Year-end close. - Select the template, specify fiscal year
2026, assign a voucher number, and submit to the batch queue.
- Navigate to
- Validate Opening Balances:
- Open
General ledger > Inquiries and reports > Trial balance. - Set date range to Period 0 (Opening Period) of 2027 and verify that Balance Sheet accounts match 2026 ending balances and P&L accounts reflect zero starting balances.
- Open
5. Rerunning Year-End Close for Post-Close Adjustments
In practical enterprise operations, external auditors frequently require post-closing adjusting journal entries (e.g., tax adjustments, impairment provisions, accrual true-ups) after the initial year-end close has already been executed.
+---------------------------------------------------------------------------------------------------------+
| Rerunning Year-End Close Workflow |
+---------------------------------------------------------------------------------------------------------+
| |
| 1. Reopen Period 12 (or Period 13 Closing Period) in Ledger Calendars (`On Hold` -> `Open`) |
| | |
| v |
| 2. Post Auditor Adjusting Journal Entry in Fiscal Year 2026 |
| (e.g., Debit Tax Expense $5,000 / Credit Tax Payable $5,000) |
| | |
| v |
| 3. Navigate to General ledger > Periodic tasks > Year-end close |
| | |
| v |
| 4. Select Template & Fiscal Year 2026 |
| - Feature: 'Delete existing year-end entries when rerunning the year-end close' |
| | |
| v |
| 5. Batch Engine Re-evaluates 2026 Ending Balances & Rebuilds 2027 Opening Balances |
| - Tax Payable Opening Balance in 2027 increases by $5,000 Cr |
| - Retained Earnings Opening Balance in 2027 adjusts by $5,000 Dr |
+---------------------------------------------------------------------------------------------------------+
[!IMPORTANT] When rerunning the year-end close, Dynamics 365 Finance leverages the feature Delete existing year-end entries when rerunning the year-end close. This prevents duplicate opening vouchers from accumulating in Period 0 and ensures the opening trial balance remains clean and reconciled.
6. Interaction with Ledger Settlements & Critical Exam Traps
Awareness Between Ledger Settlement and Year-End Close
When the feature Awareness between ledger settlement and year-end close is enabled in Feature Management:
- Settled transactions within a main account (e.g., cleared GR/IR lines) are summarized and rolled forward as a single net balance.
- Unsettled transactions roll forward into Period 0 with their original transaction details, vouchers, and financial tags intact, allowing accountants to settle them in the new fiscal year against subsequent matching entries.
Critical Exam Traps & Best Practices
| Exam Trap / Scenario | Common Misconception | Correct D365 Finance Behavior |
|---|---|---|
| Hard Close vs. On Hold | Setting a fiscal year to Closed can be undone if an audit adjustment is needed. | False. A Closed fiscal year is permanently locked and can NEVER be reopened. Always use On Hold until all audits and tax filings are final. |
| Missing Retained Earnings Setup | The system automatically posts net income to account 0000 if no account is configured. | False. The year-end close batch job fails immediately with a validation error if the Retained Earnings account is missing from the template. |
| P&L Balances in Period 1 | P&L accounts must be manually credited/debited via general journal to zero out. | False. The Year-End Close automated service clears P&L accounts to zero in Period 0 without requiring manual closing journals. |
| Opening Transactions Voucher | Opening transactions post to Period 1 of the new year. | False. Opening transactions post strictly into Period 0 (Opening period), ensuring Period 1 activity reflects only true new-year transactions. |
A multinational enterprise is configuring the Year-End Close template in Dynamics 365 Finance. Management requires that the opening trial balance in the new fiscal year retains detailed Business Unit and Department tracking for all Balance Sheet accounts, but they want all Profit and Loss revenue and expense account balances to be summarized into a single Retained Earnings equity balance without department dimensions. How should the Functional Consultant configure the template?
An enterprise completes the Year-End Close for fiscal year 2026. Two months later, external auditors require a post-closing adjusting entry in Period 12 of 2026 to accrue an additional $45,000 of legal expenses. The accounting manager changes the Period 12 status in Ledger calendars from 'On hold' to 'Open' and successfully posts the adjusting journal. What is the next required step to ensure fiscal year 2027 opening balances reflect this adjustment?
A financial controller attempts to reopen Period 12 in the Ledger calendar to post a late auditor adjustment, but discovers that the Period status is set to 'Closed'. What action can the controller take in Dynamics 365 Finance to change the status back to 'Open'?