Study guide
7.1 Bank Groups, Bank Accounts & Ledger Integration
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)
7.1 Bank Groups, Bank Accounts & Ledger Integration
Key Takeaways Explain This Topic AI
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.
Last updated: August 2026
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 to General ledger > Chart of accounts > Accounts > Main accounts , locate account 110110 , 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.