The journal entry export now includes foreign currency information for cash POS transactions where the customer pays in a different currency than the account's base currency (e.g., a CHF-priced product paid with EUR cash).
Previously, the journal entry only showed the base currency amounts. There was no visibility into what currency the customer actually paid in, the exchange rate used, or the foreign currency amount.
New columns in the journal entry export
Column | Description |
Base Currency | The account's main currency (e.g., CHF). Always shown. |
Debit (FC) | Debit amount in the customer's payment currency. Blank for same-currency transactions. |
Credit (FC) | Credit amount in the customer's payment currency. Blank for same-currency transactions. |
Foreign Currency | The currency the customer paid in (e.g., EUR). Blank for same-currency transactions. |
Exchange Rate | The manually configured BO rate used at the time of the transaction. Blank for same-currency or unresolved. |
Exchange Rate Date | Date the rate was applied. Blank for same-currency or unresolved. |
Exchange Rate Source |
|
Provided Cash Bill | The cash amount the customer handed over (in foreign currency). Informational. |
Amount Returned | Change given back to the customer. Informational. |
What stays the same
Debit and Credit values (now referred to as base currency values) remain unchanged and correct — they already reflect the product price in the account's base currency.
All existing columns (accounts, dates, dimensions, etc.) are unchanged.
Non-cash and same-currency transactions are not affected — the new columns will simply be blank for them.
Examples
A CHF account where a customer pays EUR via POS cash with a configured rate of 1.12:
Debit | Credit | Base Currency | Debit (FC) | Credit (FC) | Foreign Currency | Exchange Rate | Source |
12.50 | 12.50 | CHF | 14.00 | 14.00 | EUR | 1.12 | manual |
A CHF account where a customer pays CHF via any channel:
Debit | Credit | Base Currency | Debit (FC) | Credit (FC) | Foreign Currency | Exchange Rate | Source |
12.50 | 12.50 | CHF |
|
|
| none | none |
A CHF account where the product currency is EUR and the customer pays EUR via any channel:
Debit | Credit | Base Currency | Debit (FC) | Credit (FC) | Foreign Currency | Exchange Rate | Source |
|
| CHF | 12.50 | 12.50 | EUR | unresolved | unresolved |
