2.3 Balance Control Accounts & Year-End Opening Account Setup

2.3 Balance Control Accounts & Year-End Opening Account Setup

Quick Summary: Balance control accounts expose the effect of unposted journal lines on a main account balance before posting, and the closing/opening account fields on each main account control how year-end close carries balances forward. Both are configured on the main account record rather than in a separate module.

---

1. Balance Control Accounts (Real-Time Journal Inquiries)

When accountants enter general journal entries affecting liquid assets, bank accounts, or payroll clearing accounts, they frequently need to know the current balance and the projected impact of their unposted voucher without navigating away to a separate trial balance inquiry.

Balance Control Accounts provide an interactive, real-time inquiry pane directly within the journal voucher entry window.

Navigation & Setup

• Balance Control Setup: General ledger > Chart of accounts > Accounts > Balance control accounts

To configure a balance control account:

1. Open the form and click New.
2. Select the Main account to monitor (e.g., 110110 - Operating Bank, 110150 - Petty Cash HQ, 210900 - Payroll Clearing).
3. Save the record.

+-----------------------------------------------------------------------------+
|                   General Journal Entry: Voucher JB-000102                  |
+-----------------------------------------------------------------------------+
| Line 1: Main Account 110110 (Operating Cash) | Credit: $15,000.00           |
+-----------------------------------------------------------------------------+
|                    Balance Control Information Window                       |
+---------------------------------------+-------------------------------------+
| Current Balance (Posted):             |                     $125,000.00 Dr  |
| Journal Total (Current Batch Debits): |                           $0.00     |
| Journal Total (Current Batch Credits):|                     -$15,000.00     |
+---------------------------------------+-------------------------------------+
| Projected Ending Balance:             |                     $110,000.00 Dr  |
+---------------------------------------+-------------------------------------+

Operational Value & Limitations

• Immediate Feedback: As lines are keyed or modified in the journal, the Balance control inquiry pane at the bottom or side of the journal updates dynamically, calculating Projected Balance = Beginning Posted Balance + Journal Debits - Journal Credits.
• Informational vs. Hard Control: It is vital for the MB-310 exam to understand that Balance Control Accounts are strictly informational inquiries. They do not act as hard budget controls or prevent journal posting if the projected balance becomes negative (overdrawn). Hard balance/spending controls must be configured through the Budget control framework.

2. Opening Account Configuration for Year-End Close

During the standard Year-End Close process in Dynamics 365 Finance, Profit and Loss accounts close into the primary Retained Earnings account configured in the Ledger setup (General ledger > Ledger setup > Ledger). However, specialized accounting scenarios require specific main account balances to close into distinct reserve or balance sheet accounts.

Configuring the Opening Account on Main Accounts

• Navigation: General ledger > Chart of accounts > Accounts > Main accounts > select account > General FastTab > Opening account field.

Primary Business Scenarios for Opening Accounts

1. Statutory Legal Reserves: Certain legal jurisdictions mandate that earnings from specific operations (such as statutory grant income or foreign export subsidies) must be transferred to a restricted statutory reserve equity account rather than general unappropriated retained earnings.
2. Closing WIP / Project Clearing Accounts: Specialized clearing or work-in-progress (WIP) accounts used during the fiscal year can be configured with an Opening Account to transfer their year-end residual balances directly into a capitalized balance sheet asset account.
3. Branch / Division Equity Carryforward: In multi-division organizations tracking discrete divisional equity, divisional P&L accounts can be mapped to distinct divisional equity opening accounts.

How Opening Accounts Function During Year-End Close

When the Year-end close job executes:

• If the Opening account field on a Main Account is blank, the system follows the default behavior: Balance sheet accounts carry forward into themselves in Period 0, and Profit & Loss accounts transfer their closing balance into the default Retained earnings account defined in the Ledger form.
• If an Opening account is specified, the system bypasses the default retained earnings account for that specific main account and routes the opening balance transfer directly into the designated opening account in Period 0 of the new fiscal year.

---

3. Summary Comparison Matrix

---

4. Exam Traps & Real-World Best Practices

[!WARNING] Exam Trap: Balance Control Accounts vs. Budget Control Questions on the MB-310 exam frequently ask how to prevent users from overdrawing cash accounts during journal entry. Selecting "Balance Control Accounts" is incorrect because Balance Control Accounts only display an informational balance calculation window. To actively block or warn users when transactions exceed available balances, you must implement Budget Control with budget checking enabled on ledger accounts.

[!TIP] Consultant Pro-Tip: Deploying Categories Prior to Financial Report Build Always finalize and populate Main Account Categories on all main accounts before authoring Financial Reporting (Management Reporter) row definitions. Building financial reports around Main Account Categories rather than explicit account number ranges cuts long-term maintenance by over 80% and ensures that new accounts added post-go-live automatically flow into financial statements.