Symptom
Outgoing Bank Transfer XYZ is recorded in foreign currency - deviating from the Bank Account Currency. Subsequently this payment is confirmed in a bank statement allocating the entire amount.
In the resulting payment allocation journal entry you observe not only an exchange rate posting but also an entry only in Company Currency - however, not in the same Transaction Currency. Therefore you consider this entry to be inconsistent.
Reproducing the Issue
You can access relevant payment allocation(s) either in:
- Go to the Payment Management work center.
- Navigate to the Payment Allocations view.
- Select the relevant Payment Allocation in status Posted.
or via the posted bank statement:
- Go to the Liquidity Management work center.
- Open the Bank Statements view.
- Navigate to the relevant bank statement and Edit.
- Follow the Postprocessing: Not Required link to access the relevant payment allocation.
Cause
The applied exchange rate when recording the Outgoing Bank Transfer differs from the exchange rate applied in the Bank Statement. The Bank Statement transaction (Transaction Currency = Company Currency)already reflects this change in the recorded Bank Account Currency . Since the current exchange rate maintained in the system also tallies with the exchange rate applied in the Bank Statement - amounts match for Bank Account Currency, Company Currency and Transaction Currency - no exchange rate differences will have to be actively confirmed in the payment allocation for Cash-in-Transit-G/L Account ABC .
The original payment however has a different Transaction Currency. The clearing line in the resulting journal entry of type Techn. Clearing of Bank Clearing Account therefore shows different entries in Debit in Company Currency and Debit in Transaction Currency reflecting an exchange rate only in Company Currency and not the same Transaction Currency.
Example:
Company Currency: | EUR |
Bank Account Currency: | EUR |
Payment Currency: | USD |
- An outgoing bank transfer XYZ is issued on 15.07.2015 over 1000 USD.
- The effective exchange rate is 1,13 USD/EUR.
- The resulting journal entry therefore shows 884,96 EUR in Company Currency and Transaction Currency in Credit for Cash-in-Transit-G/L Account ABC.
G/L Account | Debit in Company Currency | Credit in Company Currency | Debit in Transaction Currency | Credit in Transaction Currency |
ABC - Cash in Transit | 884,96 EUR | 1.000,00 USD | ||
Expense Account | 884,96 EUR | 1.000,00 USD |
- In a Bank Statement this Outgoing Bank Transfer XYZ is confirmed on 02.08.2015 already reflecting the now effective exchange rate 1,00 USD/EUR.
- The amount in Transaction Currency therefore is 1000 EUR.
- In the journal entry resulting from the Payment Allocation the Cash-in-Transit-G/L Account ABC is credited with 1000 EUR in Company Currency (EUR) and Transaction Currency (EUR) - reflecting the actual disbursement on the EUR bank account on 02.08.2015.
- The Debit entry on Cash-in-Transit-G/L Account ABC reflecting the technical clearing of the outgoing bank transfer shows the original 884,96 EUR in Company Currency and 1000 EUR in Transaction Currency.
- A further Debit entry, accounting for the exchange rate loss of 115,04 EUR, only shows in Company Currency since this directly relates to the Credit entry recorded in the original Outgoing Bank Transfer in Company Currency.
G/L Account | Debit in Company Currency | Credit in Company Currency | Debit in Transaction Currency | Credit in Transaction Currency |
ABC - Cash in Transit | 1000,00 EUR | 1.000,00 EUR | ||
ABC - Cash in Transit | 884,96 EUR | 1.000,00 EUR | ||
Exchange Rates | 115,04 EUR |
The system behaves correctly.
Keywords
KBA , SRD-FIN-GL , General Ledger , How To