Study guide
7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup
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.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup
Key Takeaways Explain This Topic AI
Electronic payment formats are delivered as Electronic Reporting configurations (ISO 20022 credit transfer, NACHA, SEPA, BACS) and attached to a method of payment.
Bank foreign currency revaluation restates foreign-currency bank account balances at period end and posts unrealized gain or loss.
Shared payment setup lets one paying legal entity settle invoices belonging to other legal entities in a single payment run.
Centralized payments generate the intercompany due-to and due-from entries automatically between the paying entity and the invoice owner.
Last updated: August 2026
7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup
Quick Summary: This section covers the electronic payment format layer built on Electronic Reporting, foreign currency revaluation of bank accounts, and shared payment setup that enables one treasury entity to disburse on behalf of the group.
1. Electronic Payment Formats & Electronic Reporting (ER)
Dynamics 365 Finance executes modern outbound payments and inbound remittance advices through the Electronic Reporting (ER) framework ( Workspace: Electronic reporting ), superseding legacy code-based payment engines. +---------------------------------------------------------------------------------------------------------+
- | Electronic Payment Format Architecture |
- +---------------------------------------------------------------------------------------------------------+
- | Electronic Reporting Repository (LCS / Global Repository) |
- | - Model: Payment Model (ISO 20022 / NACHA / SEPA) |
- | └── Format Mapping: ISO 20022 Credit Transfer (pain.001.001.03) |
- | └── Format Mapping: NACHA ACH (CCD+, PPD, CTX) |
- | └── Format Mapping: SEPA Credit Transfer / Direct Debit (pain.008.001.02) |
- +---------------------------------------------------------------------------------------------------------+
- | |
- v v
- +--------------------------------+ +--------------------------------+
- | Accounts Payable Method of Pay | | Accounts Receivable Method Pay |
- | - Payment Type: Electronic | | - Payment Type: Direct Debit |
- | - Export Format Config: pain.001| | - Export Format: pain.008 |
- | - Bridging Account: 110990 | | - Bridging Account: 110980 |
- +--------------------------------+ +--------------------------------+
- Primary International Payment Formats
Payment Standard Format Identifier Operational Domain Key Data Requirements
ISO 20022 Pain.001 pain.001.001.03 / .08 Vendor Credit Transfer (EFT/Wire) Initiating Party ID, Vendor IBAN/SWIFT, Structured Remittance Info (RmtInf).
ISO 20022 Pain.008 pain.008.001.02 Customer Direct Debit (AR) Mandate ID, Date of Signature, Creditor Scheme ID, Customer IBAN/BIC.
NACHA ACH NACHA (US) US Domestic ACH (Direct Deposit/Vendor) Immediate Destination/Origin (Routing), Standard Entry Class (CCD/PPD/CTX), Company ID.
SEPA Credit Transfer SEPA Credit Transfer (EU) Eurozone Single Euro Payments Area Currency EUR, Valid SEPA Country Code, Debtor & Creditor IBAN/BIC.
BACS BACS (UK) UK Automated Clearing System 6-digit Sort Code, 8-digit Account Number, Processing Date.
Bridging Accounts in Payment Processing
When issuing electronic payments or recording credit card receipts, companies frequently post to an interim Bridging Account (e.g., 110990 - Cash in Transit / Bridging ) rather than directly crediting or debiting the primary operational bank account:
Vendor Payment Generation: Settle vendor invoices and post payment journal: Debit Accounts Payable (210100) / Credit Cash in Transit Bridging (110990) .
Bank Clearance via Bank Statement: When the electronic bank statement imports and confirms the wire settlement, the bridging transaction is cleared: Debit Cash in Transit Bridging (110990) / Credit Operating Bank (110110) .
Benefit: Prevents discrepancy between the physical bank ledger and cleared funds while payments are in transmission.
2. Bank Foreign Currency Revaluation
When a bank account is denominated in a currency other than the legal entity's Accounting Currency (for example, a USD-accounting company maintaining an account denominated in EUR), fluctuations in exchange rates require periodic revaluation.
Subledger vs. General Ledger Revaluation Mechanics +---------------------------------------------------------------------------------------------------+
- | GL Revaluation vs. Bank Subledger Revaluation |
- +---------------------------------------------------------------------------------------------------+
- | Attribute | GL Foreign Currency Revaluation | Bank Foreign Currency Revaluation |
- | --------------------- | --------------------------------- | ------------------------------------ |
- | **Navigation Path** | General ledger > Periodic tasks > | Cash and bank management > Periodic |
- | | Foreign currency revaluation | tasks > Foreign currency reval |
- | **Target Records** | Main Accounts (Ledger balances) | Bank Accounts (Subledger balances) |
- | **Subledger Update** | Does NOT update Bank Subledger! | Updates `BankAccountTrans` records! |
- | **Execution Rule** | Revalues non-subledger accounts | Mandatory for Bank Accounts |
- +---------------------------------------------------------------------------------------------------+
Caution
Critical Exam Rule: If you execute GL Foreign Currency Revaluation on a Main Account linked to a Bank Account, the General Ledger updates but the Bank Subledger does not , causing an irreconcilable variance between the trial balance and the Bank Reconciliation report! Always execute Bank Foreign Currency Revaluation under Cash and Bank Management for bank accounts, and configure the linked main account to be excluded from standard GL revaluation.
Calculation Formula & Ledger Posting Unrealized Gain/Loss = ( Bank Foreign Balance × New Spot Rate ) − Current Balance in Accounting Currency \text{Unrealized Gain/Loss} = (\text{Bank Foreign Balance} \times \text{New Spot Rate}) - \text{Current Balance in Accounting Currency} Unrealized Gain/Loss = ( Bank Foreign Balance × New Spot Rate ) − Current Balance in Accounting Currency
Example: Account holds €100,000 EUR. Original accounting value = $108,000 USD (Rate: 1.08). At month-end, the new spot exchange rate is 1.12 ($112,000 USD value).
Voucher Generated: Debit Bank Account (110110) $4,000 USD / Credit Unrealized FX Gain (800100) $4,000 USD .
3. Shared Payment Setup (Centralized Payments Across Legal Entities)
In enterprise environments, organizations establish Shared Service Centers (SSC) where a single corporate headquarters legal entity (e.g., USMF ) executes vendor disbursements or collects customer receipts on behalf of multiple operational subsidiaries ( DEMF , GBSI , USRT ). +---------------------------------------------------------------------------------------------------------+
- | Centralized Shared Payment Architecture |
- +---------------------------------------------------------------------------------------------------------+
- | PAYING LEGAL ENTITY: USMF (Shared Services / Treasury HQ) |
- | - Bank Account: OPER-USD (110110) |
- | - Executes single combined wire / check payment: $25,000 Total |
- | |
- | +---------------------------------------------------------------------------------------------------+ |
- | | Voucher USMF-PAY-01 | |
- | | - Credit: Operating Bank USD (110110) ............................................... $25,000.00 | |
- | | - Debit: Due From DEMF (Asset 130500) ............................................... $15,000.00 | |
- | | - Debit: Due From GBSI (Asset 130600) ............................................... $10,000.00 | |
- | +---------------------------------------------------------------------------------------------------+ |
- | | | |
- | Intercompany | Intercompany | |
- | Due-To/Due-From| Due-To/Due-From| |
- | v v |
- | SUBSIDIARY 1: DEMF (Operating Subsidiary) | SUBSIDIARY 2: GBSI (Operating Subsidiary) |
- | +-----------------------------------------+ | +-----------------------------------------+ |
- | | Counter-Voucher DEMF-0091 | | | Counter-Voucher GBSI-0044 | |
- | | - Debit: Accounts Payable (210100) | | | - Debit: Accounts Payable (210100) | |
- | | Vendor V-1001 ..... €13,650 | | | Vendor V-2004 ..... £7,800 | |
- | | - Credit: Due To USMF (210500) €13,650 | | | - Credit: Due To USMF (210500) £7,800 | |
- | +-----------------------------------------+ | +-----------------------------------------+ |
- +---------------------------------------------------------------------------------------------------------+
- Step-by-Step Configuration Requirements
Configure Pairwise Intercompany Accounting:
Navigate to General ledger > Posting setup > Intercompany accounting .
Define directional rules between USMF -> DEMF and USMF -> GBSI specifying valid Due-To and Due-From main accounts and destination Daily journal names.
Configure Centralized Payment Organizational Hierarchy:
Under Organization administration > Organizations > Organization hierarchies , create a hierarchy with the purpose Centralized payments linking USMF , DEMF , and GBSI .
Configure Vendor / Customer Posting Profiles:
Ensure posting profiles in each legal entity map to the correct Accounts Payable / Receivable trade control accounts.
Executing Centralized Payment Proposals:
In USMF , open Accounts payable > Payments > Vendor payment journal .
Click Payment proposal > Create payment proposal .
On the Target legal entities FastTab, select DEMF and GBSI .
The proposal engine scans open invoices across all selected legal entities, aggregates due invoices, and pulls them into the USMF payment journal.
Upon posting, D365 simultaneously settles the vendor subledgers in DEMF and GBSI , credits cash in USMF , and posts balancing intercompany Due-To/Due-From vouchers in real time.
4. Exam Traps & Real-World Best Practices
Warning
Exam Trap: Revaluation Drift between GL and Bank Subledger A favorite MB-310 scenario describes a situation where the General Ledger cash balance does not match the Bank Statement subledger balance following a month-end close. The culprit is almost always that the accounting team ran General Ledger > Periodic tasks > Foreign currency revaluation on the bank's main account instead of running Cash and bank management > Periodic tasks > Foreign currency revaluation . GL revaluation does not create records in BankAccountTrans , breaking subledger reconciliation!
Tip
Consultant Best Practice: Check Layout & Number Sequence Management When configuring physical check printing under Bank accounts > Setup > Check , set the Check number method to Fixed if using pre-printed check stock with pre-assigned check numbers from the bank. Use Free only when blank check stock is fed into specialized MICR toner printers where D365 assigns and generates the check numbers.