Setup step on the Balance control accounts page · General ledger

Set up Balance control accounts

Used to check that the funds in an account, such as a petty cash account, are enough before a journal posts, through the Balance control inquiry on general journals.

Used by: Accountant, Accounting manager, Accounting supervisor and 8 more roles
Business process: Develop chart of accounts strategy
Menu item: LedgerBalanceControlAccounts
Main table: LedgerBalanceControl
Data entity: LedgerBalanceControlEntity
Setup steps: 1 on this page

Show what matters for

Everyone

1What it is and why

What it is	Ledger accounts set up so that their current and expected balance can be monitored while transactions are entered in a journal.
What you do here	Used to check that the funds in an account, such as a petty cash account, are enough before a journal posts, through the Balance control inquiry on general journals.
Example	An accounts payable coordinator checks the expected balance of a bank account, including posted and unposted journals, to make sure it's enough to pay invoices.

Balance control accounts page in Dynamics 365 — The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business process	Define accounting policies › Develop chart of accounts strategy
Menu path	General ledger › Chart of accounts › Accounts › Balance control accounts
Set up first	Main accounts Microsoft Learn ↗
Used next by	General journals Microsoft Learn ↗
Related pages	Bank accounts Microsoft Learn ↗
In this process	← Set up Ledger account alias · Set up Treasurer's fund accounts →

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Balance control accounts1 screen

Used to check that the funds in an account, such as a petty cash account, are enough before a journal posts, through the Balance control inquiry on general journals.

Screen 1
Add the balance control account
Go to General ledger > Chart of accounts > Accounts > Balance control accounts
1. Select New
2. Choose main account 110100
1Main account 110100
Name Atlas test cash clearing
Show the full screen
page title tab to open what to set or check

1Main account	110100
Name	Atlas test cash clearing

Microsoft's steps

—

Field guide

Field	What it means	Worked example	Table column
Balance control	The check applied to the account's balance as journal lines are entered.Microsoft Learn ↗	—	—
Debit control	Makes sure journal transactions don't push the account's balance into credit.Microsoft Learn ↗	—	—
Main account	—	110100	`MainAccount`
Name	—	Atlas test cash clearing	—

Functional consultant

4Setup decisions

Setup step	Recommended value and why	Decision · common mistake · test
Set up Balance control accounts	—	—

Solution architect

5Design impact

Shared or per company	Per company: each legal entity has its own records. Microsoft data model ↗
Can it be undone	—
Feature or country	—
If you change it later	—

Technical architect

6Technical

Menu item	`LedgerBalanceControlAccounts` Checked in Dynamics 365
Form	`LedgerBalanceControlAccounts` Checked in Dynamics 365
Table	`LedgerBalanceControl`Shown as “Balance control accounts” in Record infoChecked in Dynamics 365
Data entities	`LedgerBalanceControlEntity`Balance control accounts Microsoft data model ↗
Who can open it	PrivilegesMaintain balance control accounts `LedgerBalanceControlAccountsMaintain`View balance control accounts `LedgerBalanceControlAccountsView`DutiesEnable general ledger process `LedgerGeneralLedgerProcessEnable`Review general ledger process performance `LedgerGeneralLedgerProcessPerfReview`Inquire into general ledger reference data `LedgerGeneralLedgerReferenceDataInquire`Enable general ledger process `RentalLedgerGeneralLedgerProcessEnable` 11 security roles Auditor `AuditPolicyManager`Budget manager `BudgetBudgetManager`Chief executive officer `CompanyChiefExecutiveOfficer`Chief financial officer `CompanyChiefFinancialOfficer`Accountant `LedgerAccountant`Accounting manager `LedgerAccountingManager`Accounting supervisor `LedgerAccountingSupervisor`Financial controller `LedgerFinancialController`Rental manager `RentalManager`Rental purchasing manager `RentalPurchasingManager`Rental sales manager `RentalSalesManager` Checked in Dynamics 365
Actions on the page	—

Developer

7Developer

Open it directly	`https://<your-environment>/?mi=LedgerBalanceControlAccounts`
Integrate with	`LedgerBalanceControlEntity` data entity Microsoft data model ↗
Table definition	`LedgerBalanceControl` columns and relations Microsoft data model ↗