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 _______________________________________________ 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.
