Skip to main content

Reporting cash payments of POS in journal entries

This article introduces new foreign currency columns in the journal entry export for cash POS transactions, giving visibility into payments made in a currency different from the account's base currency.

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

none = same currency, manual = BO-configured rate, unresolved = foreign currency detected but no rate available.

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

Did this answer your question?