After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 637467 - Add info to concepts of multi-currency
Add info to concepts of multi-currency
Status: RESOLVED DUPLICATE of bug 635386
Product: GnuCash
Classification: Other
Component: Documentation
unspecified
Other Windows
: Normal normal
: ---
Assigned To: Yawar Amin
Tom Bullock
Depends on:
Blocks:
 
 
Reported: 2010-12-17 14:24 UTC by Contact341
Modified: 2018-06-29 22:49 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Contact341 2010-12-17 14:24:59 UTC
When selecting an accounting package it's necessary to be sure that the package deals correctly with accounting requirements.

I've not found any low cost accounting s/w that deals with multi-currency correctly, or that deals with it effectively, and none state any useful details in their on-line documentation.  For example I've just had to try out two free trial of such packages and found that they were not satisfactory.

Of course I assume that GnuCash handles multi-currency correctly, but there's no documentation that I've found that demonstrates this.

I therefore recommend that you should additionally state some key principles of accounting for multiple currencies, and stating how GnuCash executes those principles.  These are I think fairly simple and will require only a few additional lines or an additional page (but I'm not an expert on multi-currency so I may of course be omitting something).

For example some principles are:
- when converting income and expense transactions from another currency into the default currency then the exchange rate that is used is that which applied at the date of the transaction (ie if today I want a report in my default currency of my historical income and expenses then for each transaction I use the exchange rate that applied at the date of the transaction)
- when converting asset and liability balances from another currency into the default currency then the exchange rate that is used is that which applied at the time the conversion was carried out (ie if today I want a report in my default currency of my current assets and liabilities then I use today's exchange rate)

For example what I would put about how GnuCash executes these principles is (and I'm making some assumptions based on what I've read in the documentation so these may be incorrect):
- GnuCash has a Price Editor where exchange rate details for each currency are recorded.  Details for each currency include the exchange rate and the date from which that exchange rate applied.  For each currency an exchange rate in the Price Editor will apply from the date that is recoded against it until (but not including) the date of the next exchange rate recorded in the Price Editor
- When converting foreign currency income and expense transactions, and assets and liability balances, GnuCash uses the appropriate exchange rate data recorded in the Price Editor.
- Therefore to report income and expense over a specified period (eg for the last 12 months) GnuCash will take each income and expense transaction and convert each transaction to the default currency using, from the Price Editor, the exchange rate that applied at the date of the transaction.  If this is being done for a summary report then all the converted values for each transaction within each income and expense account will be summed together to give the total value in the default currency for each income and expense account
- To report asset and liability balances for a given date  GnuCash will take each asset and liability balance for that date and convert each balance to the default currency using, from the Price Editor, the exchange rate that applied at that date.  If this is being done for a summary report then all the converted values for each balance for each account in each currency will be summed together to give the total value in the default currency for each asset and liability balance account

- Note that when entering transactions in a foreign currency it is not necessary to record the exchange rate as part of the entry for that transaction because GnuCash when needed will refer to the Price Editor. (Note I've included this statement because some low cost packages require an exchange rate to be entered against each transaction, time-consuming if you have lots of foreign-currency transactions and a poor way of executing the requirement.)

I hope that's a help.

Best regards

Reid
Comment 1 Tom Bullock 2010-12-17 14:58:01 UTC
Whatever GC decides on, GAAP (generally accepted accounting principles) should be reviewed so that the documentation can state clearly that GC follows the principles fully, or if for whatever reason it differs from them, such differences can be clearly stated and illustrated by examples.
Comment 2 Yawar Amin 2010-12-18 17:29:08 UTC
Hi Reid, we have a bug 635386 open for this, which is being worked on now. In particular, it references Peter Selinger's tutorial [1] for GnuCash multiple-currency accounting. I'm marking this one as a duplicate of that.

[1] http://www.mathstat.dal.ca/~selinger/accounting/gnucash.html

*** This bug has been marked as a duplicate of bug 635386 ***
Comment 3 John Ralls 2018-06-29 22:49:32 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=637467. Please update any external references or bookmarks.