Hi Scott, if you have some hacking skills, you can test a beta Transaction Report which can display both report and original currency. With any luck it'll be ready for inclusion in the next release.
Are you able to follow https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report and install https://github.com/christopherlam/gnucash/blob/unstable-transaction-future/gnucash/report/standard-reports/transaction.scm ? It can show both KRW and USD on the same line, however, the exchange rate will be the *exact* rate that applies to each transaction rather than the weighted average rate. I don't use budget and can't help sorry. On 10 November 2017 at 11:36, Scott <scottsteven...@gmail.com> wrote: > Hello everyone, > > I've been reading the forum and resources online, but I can't seem to find > a > situation that matches mine. > > I work for a human rights NGO in Seoul, South Korea, so all of my > transactions are in KRW. That is, except for our USD drawdown payments from > one of our donors in the US. > > I've been using GNU cash to record all our expenses and keep a balanced > book, but I'm looking to make some progress on budgeting and reporting. Our > budgets for each account are set at the beginning of the year by our donor, > and we need to report quarterly in USD. I use a weighted average formula to > make sure that our KRW amount matches the USD amount so at the end of the > year we spend within the USD amount. > > So basically, I'd like to be able to *1) see my regular KRW transactions > alongside their value in USD (set to the weighted average rate)* and *2) be > able to set my budget in USD*. > > Up to this point I've just been keeping a KRW record and then manually > applying the USD exchange rates to find out how much we've spent in USD. > > There must be a better way! > > I've found two possible solutions, but I'm not sure if they're workable and > would greatly appreciate the community's input! > > 1) Record all transactions in KRW, export reports to xml, find a way to get > the xml to display in excel and apply exchange rates there. Drawbacks here > are that I can't see my budget or spending in USD live, without a time > consuming process. > > 2) Set my default currency to USD and apply my updated exchange rate at > each > transaction. The downside here is that I have no easy way to see my data in > KRW, which I need to report for Korean taxes etc. > > My first post is an essay, so thanks if you made it this far. Glad to join > the community! > > -Scott > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > _______________________________________________ > gnucash-user mailing list > gnucash-u...@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
