Multi-currency on expense voucher
Keith A. Milner
kamilner at superlative.org
Wed Nov 7 15:25:07 EST 2007
I did a search of the mailing list and bug reports, and couldn't find
anything. I seem to have hit an issue with multi-currency support on the
employee expense vouchers.
Basically, it doesn't seem to support it. There are potentially two issues
(which I will highlight)
My situation is I'm from the UK so all my normal accounts (A/c receivable,
expense accounts, etc.) are GBP, but I'm doing some work which involves me
being in Europe.
My normal practice is as follows: I register company expenses (e.g. hotels) as
vendor bills, and personal expenses (cash) as employee vouchers. Both of
these are marked against a job so I can recharge them on my invoices.***
As I was working in Europe, all my expenses are in Euros. So, I thought, easy:
create some EUR expense accounts mirroring the GBP ones, book all my expenses
against these, and then let Gnucash sort out the conversion.
So I started entering my expenses into a voucher in EUR amounts. Halfway
through I noticed that the total at the bottom was all in GBP, with no
conversion.
ISSUE 1: The vouchers don't support multi-currency entry, either mixed
currency on a voucher, or even a voucher with a single currency.
Anyway, I went back and did the conversion myself and entered the voucher
values as GBP against my GBP expense accounts. All fine!
Now the next twist is that I had prepared for this trip by taking out some
funds from the company and exchanging them into Euros. I accounted for this
as an exchange transaction between my GBP bank account and a EUR asset
account called "Petty Cash (Euros)". The idea was to use this to pay my
expenses, as most of them (including 2 weeks accommodation) were in cash.
So, I submitted the personal expense voucher and attempted to pay this "bill"
from the "Petty Cash (Euros)" account. This seemed to work, but didn't. I was
expecting the exchange rate druid to pop up, but it didn't.
However, I noticed that whilst the bill had been "paid" and the A/c Payable
had decreased, the Petty Cash account did not decrease. Looking at the split
transaction, the part that took the funds from the Petty Cash account was
blank, but the other half that credited Accounts Payable had a value in it.
Effectively I had created a single-entry transaction and an imbalance and
this hadn't been spotted by Gnucash.
ISSUE 2: Paying a voucher "bill" in one currency from an account in another
currency causes an inconsistancy
Have I found a bug, or is this merely an unsupported operation? Is there
something I did incorrectly?
This is Gnucash 2.2.1 r16462 running on Mandriva 2008.
regards,
--
Keith Milner
*** Incidentally, this works really nicely and, with the correct expense
headings, allows me to capture P11D information for personal tax purposes -
the biggest downside is I end up entering this info twice: firstly into
my "personal expense form" which is a spreadsheet that each employee of the
company uses to claim expenses and which separates out ipurely internal
expenses from rechargeable ones, and then this information has to be copied
into Gnucash. It would be great if I could somehow export the data
More information about the gnucash-user
mailing list