So the Cafe’s price was CHF 5.70?
Your card was debited GBP 4.67?
The Expense:Coffee account is set to EUR?
First, yes, you’ll need Trading Accounts turned on.
Second, open the price db and fetch rates, then check the EUR-GBP rate, you’ll
need it later. (I don’t see a way around this at present) For this example,
we’ll use 1.0957 which I fetched just now.
Third, start your transaction by entering the following to ‘fund’ the card with
CHF:
Cr. Transferwise GBP 4.67
Dr. Transferwise_CHF CHF 5.70
(GnuCash will prompt for a GBP-CHF exhange rate, use the ‘debit’ radio button
and field and enter the CHF amount, in this case, “-5.70")
The transaction should now read something like:
-----
Account Debit Credit
Assets:Current Assets:Transferwise 4.67
Assets:Current Assets:Transferwise_CHF SFr.5.70
-----
(the 4.67 has no currency symbol because it is in the account’s currency - GBP)
Fourth, enter the actual expense part of the transaction:
Dr. Expenses:Coffee EUR 5.12
The EUR 5.13 price is based on today’s rate between EUR-GBP above and
calculated either on the side, or directly in the debit-entry field. (enter as:
GBP*rate or 4.67*1.0957) We’re using the EUR-GBP instead of CHF-EUR because
this transaction is being entered in the Transferwise (GBP) account.
When GnuCash prompts for the exchange rate, simply commit the FX window. We
couldn’t wait to fetch the rate here, because we’d have to back out and
re-enter the amount in the register to match.
Now, the transaction reads like this:
-----
Account Debit Credit
Assets:Current Assets:Transferwise 4.67
Assets:Current Assets:Transferwise_CHF SFr.5.70
Expenses:Coffee €5.12
-----
Fifth, you need to balance this with CHF funds taken from the card:
Cr. Transferwise_CHF 5.70
(GnuCash will again prompt for exchange rate, use ‘debit’ and “5.70” for the
amount)
The transaction now looks like this:
-----
Account Debit Credit
Assets:Current Assets:Transferwise 4.67
Assets:Current Assets:Transferwise_CHF SFr.5.70
Expenses:Coffee €5.12
Assets:Current Assets:Transferwise_CHF SFr.5.70
-----
Sixth, since you have Trading Accounts turned on, when you hit `Enter` to
commit this transaction GnuCash will add the balancing splits so your
transaction looks like this in final form:
-----
Account Debit Credit
Assets:Current Assets:Transferwise_CHF SFr.5.70
Expenses:Coffee €5.12
Trading:CURRENCY:GBP £4.67
Assets:Current Assets:Transferwise 4.67
Assets:Current Assets:Transferwise_CHF SFr.5.70
Trading:CURRENCY:EUR €5.12
-----
You can of course, make the transaction more ‘complete’ (or complicated as per
your perspective) by also using actual CHF-GBP and CHF-EUR rates and accounting
for the conversion fee rather than using the ‘debit’ option for those two
splits.
You could also separate this into two transactions, one to ‘fund’ the CHF, then
another to spend that on Coffee.
Note, that I tried doing this from the Expense account, but it was messy. I
also couldn’t find a way to get GnuCash to calculate the EUR price of the
transaction for me using the fetched rate. Maybe someone else has a trick up
their sleeve.
Regards,
Adrien
> On Aug 15, 2019, at 9:38 AM, Jeff Abrahamson <j...@p27.eu> wrote:
>
> I purchased a coffee in Switzerland using my GBP-based Transferwise
> card. That card could hold a CHF balance, but on that day it held only
> GBP. My local currency is EUR. So I can think of my coffee purchase as
> two FX transactions: funding (GBP -> CHF) and an expense (CHF -> EUR).
>
> What Transferwise tells me is the amount of the purchase and the amount
> of the transaction. (I can also poke further and find the exchange rate
> they used and the minuscule fee, but the important point to me is the
> the two endpoints.)
>
> Now what makes sense to me based on reading about accounting principles
> for multiple currencies is that I should make one transaction thus:
>
> Coffee (CHF) <-- Bank (GBP) # This is the funding part of
> the transaction.
> Expense acct <-- Coffee (CHF) # Here I'm tracking the actual
> expense.
>
> I put those in a single transaction for easier understanding later.
> Here I've created a bank account for Transferwise (GBP) as well as
> subaccounts of that called Transferwise_CHF and some others, denominated
> in the indicated currencies. Those three accounts are transfer
> accounts: I usually expect them to have zero balance.
>
> Transferwise_CHF <-- Transferwise (GBP) # This is the
> funding part of the transaction.
> Expense/cafe <-- Transferwise_CHF # Here I'm tracking
> the actual expense.
>
> Gnucash asks me for some exchange rates, and I answer for the CHF - GBP
> part with the specific numbers provided by Transferwise and for the GBP
> - EUR part with the exchange rate I've downloaded for that date.
>
> I expect to see this in the account Transferwise_CHF
>
> 5.70 <-- 5.70 # This is the funding part of the transaction.
> 5.70 <-- 5.70 # Here I'm tracking the actual expense.
>
> and this in the Transferwise (GBP) account
>
> 4.67 <-- 4.67 # This is the funding part of the transaction.
> 4.67 <-- 4.67 # Here I'm tracking the actual expense.
>
> and something similar looking at the splits in the (euro-denominated
> expense account).
>
> But what I see (from the perspective of the CHF account) is this, which
> makes no sense to me:
>
> Gnucash has entered the 2.80, and deleting that split just makes it pop
> up again. Something is terribly wrong if any account's view of the
> transaction doesn't balance. (This is gnucash 3.4, ubuntu, build id
> 3.4+ (2018-12-30).
>
> Is this my error or a bug in gnucash? Any pointers?
>
>
> Somewhat related, I thought to import historical currencies, as I'm back
> filling some data for analysis purposes. I grabbed 10 years of daily
> quotes and imported them (3600 or so rows of data per currency). All ok
> for GBP - EUR. When I do the same for CHF - EUR, gnucash says it's done
> it, but the price database doesn't show more than a handful. When I do
> it for JPY - EUR, gnucash says it's done but the price editor shows none
> of them. The proposed exchange rates when entering transactions are
> consistent with what the price editor thinks it knows.
>
> Is there a limit on FX rates? (This is about 4000, which doesn't strike
> me as terribly large.)
>
> --
>
> Jeff Abrahamson
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
