7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup

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

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:

1. Vendor Payment Generation: Settle vendor invoices and post payment journal: Debit Accounts Payable (210100) / Credit Cash in Transit Bridging (110990).
2. 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).
3. 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

$\text{Unrealized Gain/Loss} = (\text{Bank Foreign Balance} \times \text{New Spot Rate}) - \text{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

1. 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.
2. Configure Centralized Payment Organizational Hierarchy:
   • Under Organization administration > Organizations > Organization hierarchies, create a hierarchy with the purpose Centralized payments linking USMF, DEMF, and GBSI.
3. Configure Vendor / Customer Posting Profiles:
   • Ensure posting profiles in each legal entity map to the correct Accounts Payable / Receivable trade control accounts.
4. 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.