7.1 Bank Groups, Bank Accounts & Ledger Integration
Key Takeaways
- A bank group represents the financial institution and carries defaults such as address, registration numbers, and default electronic statement formats.
- Each bank account links to a balance sheet main account, which is how the Cash and bank subledger reconciles to the general ledger.
- Bank account currency, and the option to allow only that currency, controls which transactions may be posted against the account.
- Cash and bank management parameters set global behaviours such as check number sequences and whether the bank balance may go negative.
7.1 Bank Groups, Bank Accounts & Ledger Integration
Quick Summary: The Cash and Bank Management module in Microsoft Dynamics 365 Finance serves as the financial hub for managing company liquidity, electronic payment processing, banking relationships, and treasury controls. A robust banking implementation requires establishing Bank Groups for financial institution governance, linking subledger Bank Accounts to Chart of Accounts balance sheet assets, deploying Electronic Reporting (ER) payment models (ISO 20022, NACHA, SEPA), configuring Positive Pay anti-fraud workflows, executing subledger Foreign Currency Revaluation, and setting up Centralized Shared Payments across enterprise legal entities.
1. Bank Groups & Cash and Bank Management Parameters
Before creating operational bank accounts, organizations must configure the structural rules governing banking operations.
Navigation
- Bank Groups:
Cash and bank management > Bank accounts > Bank groups - Parameters:
Cash and bank management > Setup > Cash and bank management parameters
+-----------------------------------------------------------------------------+
| Bank Groups Architecture |
| Bank Group: JPMC-US (JPMorgan Chase USA) |
| - Routing Number: 021000021 - Currency: USD |
| - Clearing House: FedACH - Bank Facility Group: CREDIT-LINE |
+-----------------------------------------------------------------------------+
| |
v v
+--------------------------------+ +--------------------------------+
| Bank Account: OPER-USD | | Bank Account: PAYROLL-USD |
| - Main Account: 110110 | | - Main Account: 110120 |
| - Positive Pay: JPMC_PosPay | | - Positive Pay: JPMC_PosPay |
| - IBAN / SWIFT Configured | | - Check Format: Check_US |
+--------------------------------+ +--------------------------------+
Purpose of Bank Groups
Bank Groups categorize operational bank accounts by financial institution or banking syndicate. Rather than redefining routing numbers, clearing house identifiers, and general contact details for every individual account, Bank Groups serve as master templates:
- Default Transit Information: Automatically populates routing transit numbers (ABA/Routing numbers in the US, Sort codes in the UK, BLZ in Germany) to child bank accounts.
- Credit Limit & Bank Facility Governance: Integrates with Bank Facilities (Letter of Credit, Bank Guarantees, and Credit Line facilities) to monitor aggregate corporate exposure across all accounts held at a single banking institution.
- Bank Statement Format Defaults: Associates default electronic statement parsing formats (CAMT.053, MT940, BAI2) for statements imported from that specific banking partner.
Critical Cash and Bank Parameters
| Parameter Setting | Location / Tab | Functional Behavior & Exam Impact |
|---|---|---|
| Allow bank account revaluation | General Tab | Enables the subledger Foreign Currency Revaluation periodic process for bank accounts holding foreign currency balances. |
| Positive pay format | Positive Pay Tab | Defines the default Electronic Reporting or XML format used when generating outbound anti-fraud check registers. |
| Use advanced bank reconciliation | Advanced Reconciliation Tab | Globally activates the Advanced Bank Reconciliation (ABR) engine, enabling electronic statement import and automated matching rules. |
| Ledger account validation | General Tab | Restricts users from manually posting general ledger journal lines directly to bank-linked main accounts without selecting the Bank Account subledger. |
2. Bank Account Master Setup & Ledger Integration
Operational bank accounts (Cash and bank management > Bank accounts > Bank accounts) maintain the bridge between physical banking relationships and the General Ledger.
+---------------------------------------------------------------------------------------------------+
| Bank Account Configuration Anatomy |
+---------------------------------------------------------------------------------------------------+
| Field Name | Selected Value | Architectural & Control Purpose |
| ------------------ | ------------------ | ----------------------------------------------------- |
| **Bank account** | `OPER-USD` | Unique subledger identifier for the bank account. |
| **Bank group** | `JPMC-US` | Inherits routing, clearing house, and facility links. |
| **Main account** | `110110` | Target Balance Sheet Asset account in Chart of Accounts.|
| **Currency** | `USD` | Denomination currency (locks or opens multi-currency).|
| **IBAN / SWIFT** | `US12JPMC...` | International bank identifiers for cross-border wires. |
| **Account status** | `Active` | Operational state (Active, Inactive, No new trans). |
| **Positive Pay** | `JPMC_NACHA_PP` | Format code used to transmit check issuance files. |
+---------------------------------------------------------------------------------------------------+
Main Account Mapping & Subledger Integrity
Every Bank Account must be mapped to exactly one Main account in the Chart of Accounts (110110 - Operating Bank).
[!IMPORTANT] Reconciliation Best Practice: To eliminate reconciliation drift between the General Ledger trial balance and the Bank Subledger (
BankAccountTrans), navigate toGeneral ledger > Chart of accounts > Accounts > Main accounts, locate account110110, and set Do not allow manual entry to Yes. This guarantees that all transactions affecting the cash balance must originate through subledger documents (Customer Payment Journals, Vendor Disbursement Journals, Bank Journals), completely preventing unlinked ledger entries.
Bank Account Status Lifecycle
- Active: The account is fully operational for payment generation, deposits, and statement reconciliation.
- Inactive: Completely disables the bank account from appearing in lookup dialogs or receiving new postings.
- No new transactions: Allows existing unposted journals containing this bank account to be posted and open checks to be cleared, but blocks users from creating new transaction lines targeting the account.
Positive Pay Anti-Fraud Setup
Positive Pay is a fraud-prevention service offered by commercial banks to protect companies against altered or counterfeit checks. When the finance team prints and posts physical checks, D365 generates an electronic Positive Pay text/XML file containing the Check Number, Account Number, Transaction Date, Amount, and Payee Name.
- Under Manage payments > Positive pay, assign the Positive pay format (configured via Electronic Reporting or legacy data entities).
- Specify the Positive pay start date.
- In daily operations, users navigate to
Cash and bank management > Bank accounts > Manage payments > Positive pay, generate the file, mark the batch as sent, and securely upload the file to the bank's portal.
A financial controller at an enterprise with multiple legal entities discovers that the General Ledger balance for main account 110110 (Operating Bank USD) does not match the ending balance on the Bank Reconciliation summary report. An audit reveals that an accountant manually entered a general journal adjustment directly to main account 110110 without specifying a Bank subledger account. What configuration setting should the Functional Consultant implement to permanently prevent this issue?
A consultant is setting up a new operating account at a bank that already supplies two other accounts to the legal entity. Which setup element carries the institution-level information such as address, registration numbers, and the default electronic statement format?