[GNC] Importing a CSV with transactions in another currency

[boldstripe]

In the end I could not import either CSV or OFX/QFX from one currency to
another in Gnucash. I have since given up the goal of a single 'worldwide'
Gnucash file, choosing instead to run two (in my case) national files, one
based in each currency. That way, OFX imports work well, and scheduling,
budgeting and reporting make sense.

There are good Gnucash report options that compute totals so you can
manually transfer individual account totals from one set of books to the
other (for example, entering the foreign total as a single transaction on
Dec 31 each year). In particular, one Report Option checkbox can display
expense account totals in both currencies.

I did convert a foreign-currency CSV into a base-currency CSV using a
spreadsheet. This works for simple expense account totals for tax purposes.
But for everyday use, the transactions don't make sense in a 'foreign'
currency; and more advanced Gnucash functions like budgeting, scheduling and
reporting--for both countries--are difficult/confusing/impossible from a
single two-currency file.

So my suggestion for anyone contemplating a single set of 'worldwide' books:
it may be better to separate your bookkeeping into two files, two
currencies.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html