Multi-currency on expense voucher

[Keith A. Milner]

On Friday 09 November 2007 14:14:16 Derek Atkins wrote:
> "Keith A. Milner" <kamilner at superlative.org> writes:

<SNIP>

> >
> > ISSUE 1: The vouchers don't support multi-currency entry, either mixed
> > currency on a voucher, or even a voucher with a single currency.
>
> The former is true.  The latter is not.  You can have multiple currencies
> in multiple vouchers..  It pulls the currency from the "owner" when you
> choose the owner and then caches that currency.  So what you need to do
> is set your Employee Currency to EUR, then create the voucher -- and then
> that voucher will be in EUR.

Ah, OK. I'll give that a try. Many thanks.

>
> > 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.
>
> Correct..  It wont do that.  BUT you can go edit the transaction after
> the fact and apply the exchange rate.

This didn't work for me. I'll give it another go because there's a strong 
possibility I'm wrong, but it wouldn't let me do anything to the resulting 
transaction except delete it.


> > *** 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
>
> Sounds like you need to write a report.  :-D

Actually, it's an import. I want to take external business data (a voucher) on 
a spreadsheet and import it into GnuCash.

regards,


-- 
Keith Milner