[GNC] closing of books and multiple currencies: a question on exchanges

Andrea Borgia andrea at borgia.bo.it
Sat Mar 27 12:14:20 EDT 2021


Hello, David.


Finally had time to go over your explanation with the books open, I'm 
adding my observations inline.


> If I read it correctly you will have paid originally in totally €320.44 for
> the laptop (€313.21 cost of the laptop + US$7.23 shipping/commission fees,
> which would have been a total cost in € which was presumable expensed
> against Costi:Euro:Elettronica/Fotografia in the purchase transaction.

It's even weirder than that, actually: the defective laptop costed 
313.21EUR inclusive shipping but they did not reimburse the amount paid, 
rather the base cost of the laptop plus what I spent to send it back, 
that's why they had to make an extra payment on top of the paypal 
reversal. I can understand the logic, I'm fine with it.


> Technically it would have been better to have recorded that at the time of
> the refund not during the closing operation by using a multicurrency
> transaction refund to Costi:Euro:Elettronica/Fotografia rather than
> Costi:Dollari:Elettronica/Fotografia in 04  which would have forced the
> currency exchange at that point. Then in 06 you would only have to close the
> fees and commissions $0.69 to Risultatao:Dollari.

I think I'll have to keep the two transactions separate because the 
dates, one day apart, would not match the respective entries in Paypal 
but I will retroactively change the currency as you suggest.

I had always naively assumed that income / expense accounts had to match 
the currency of the asset, not because some limitation of gnucash, 
rather because that was "The One True Way" to do it.


> My preference would be to keep all expense accounts in € (including the fees
> and commissions) and force the currency conversions at the time they
> occurred in 04. Then there would be no closing transactions from any foreign
> currency accounts. Whether this is possible for you may depend on your
> jurisdictional rules for recording  transactions in foreign currencies. You
> may need to consult a local accountant to advise you on this.

My current setup is perhaps a consequence of my life: I began using it 
in 1999 here in Italy (ITL at the time), then I spent nearly all of 2001 
in Finland, right before the changeover to EUR. Since I was paid in FIM, 
it came naturally to me to create income / expense accounts in FIM and 
well. When I travelled to Estonia on holiday, I recorded the expenses 
against EEK-denominated expense accounts and of course the EEK result 
was a net negative. I still had some FIM left when I came back to Italy 
and the finnish bank later did the FIM-EUR conversion for me. Anyway, to 
cut to the chase, that's how I got the idea of using the same currency 
for expenses as the asset I used.


Thanks for the detailed explanation, I have a followup question: this 
year I bought shares in a mutual funds which is listed in USD. 
Naturally, there were 9 dollars of commission on the trade. At the 
moment I have used a USD expense account for that. I'll have to move 
this as well if I don't want a funny result like above, right?


Andrea.





More information about the gnucash-user mailing list