In my company I use 3 currencies: GBP, USD, and EUR.
When I exchange currencies between GBP and another currency everything is fine, I tag transactions as bank transfer between account, system finds transaction on another account and it records it correctly in GBP.
However, when I exchange between 2 non-GBP currencies (eg. EUR to USD) the suspense account shows 2 different amounts, eg. when I exchange 1000EUR to USD it will show 909.45 on the Credit and 910.89 on the Debit account.
Is there any way to fix it other then manually going through all translations?
@QFMathew I just tagged the EUR transaction as “Bank Transfer between accounts” and the system automatically found the USD transaction on the other end.
Could You help me to understand how to do it properly with GBP in the middle?
Please accept my apologies, and disregard my previous post.
This is supported, but has only been added recently.
The difference in the GBP values you’re seeing is because of the exchange rate. So where the exchange rate is different to the actual rate that day (e.g. because the source of the exchange was higher/lower), you end up with a currency gain/loss.
Some transfers, including the non-GBP to non-GBP transfers leave a trace in the Suspense Account, which is code 9998.
For example, I’ve just done a transfer of 100 EUR to 115 USD. But this doesn’t match the exchange rate, so there’s a discrepancy of £0.52 showing in the suspense account:
