Difference between revisions of "Trading Accounts"

From GnuCash
Jump to: navigation, search
(Add links to image files.)
m ({{URL:Sel}})
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Since version 2.3.8 resp. 2.4.0 GnuCash supports trading accounts as described in [http://www.mscs.dal.ca/~selinger/accounting/tutorial.html Tutorial on multiple currency accounting] and [http://www.mscs.dal.ca/~selinger/accounting/gnucash.html Multiple currency accounting in GnuCash] by P. Selinger. In short their benefit is to ''avoid imbalances'' caused by ''trading commodites''.
+
[[Category:Multi Currency Accounting]]
 +
Since version 2.3.8 resp. 2.4.0 GnuCash supports the ''internal'' mechanism of '''trading accounts''' as described in [{{URL:Sel}}tutorial.html Tutorial on multiple currency accounting] and [{{URL:Sel}}gnucash.html Multiple currency accounting in GnuCash] by P. Selinger. In short their benefit is to ''avoid imbalances'' caused by ''trading commodites''.
  
 
Before there was some discussion, because they show ''unrealized gains'' and should not be part of the income. So they got their own type and are placed at the top level of the account hierachy.
 
Before there was some discussion, because they show ''unrealized gains'' and should not be part of the income. So they got their own type and are placed at the top level of the account hierachy.
Line 10: Line 11:
 
== Overview ==
 
== Overview ==
  
Trading Accounts are used to represent the imbalances caused by a transaction involving two different currencies, as described in the [http://www.mscs.dal.ca/~selinger/accounting/tutorial.html Tutorial]. There will be one such account for each currency which is involved in the Gnucash file.  
+
Trading Accounts are used to represent the imbalances caused by a transaction involving two different currencies, as described in the [{{URL:Sel}}tutorial.html Tutorial]. There will be one such account for each currency which is involved in the Gnucash file.  
  
 
These accounts are created automatically when a transaction is entered which has a debit to an account in one currency and a credit to an account in a different currency.
 
These accounts are created automatically when a transaction is entered which has a debit to an account in one currency and a credit to an account in a different currency.
Line 18: Line 19:
 
To use Trading Accounts, first ensure that the accounts you are using are denominated in the desired currencies. For example, you might have an asset account 'Canadian Cash' denominated in CAD and an account 'U.S. Cash' denominated in USD.  
 
To use Trading Accounts, first ensure that the accounts you are using are denominated in the desired currencies. For example, you might have an asset account 'Canadian Cash' denominated in CAD and an account 'U.S. Cash' denominated in USD.  
  
Then simply enter a transaction which exchanges amounts between the two accounts, starting in the account with the currency you wish to express the initial value in. For example, to exchange 120 CAD for 100 USD, start in the 'Canadian Cash' account and enter a transaction where the Transfer account is 'U.S. Cash'. After entering the amount to spend, press the Enter button, and you will be presented with a Transfer Funds dialog, like the following:
+
Then simply enter a transaction which exchanges amounts between the two accounts, starting in the account with the currency you wish to express the initial value in.  
 +
 
 +
The following is example 4.4 from P. Selinger's [{{URL:Sel}}tutorial.html Tutorial on multiple currency accounting].
 +
To exchange 120 CAD for 100 USD, start in the 'Canadian Cash' account and enter a transaction where the Transfer account is 'U.S. Cash'. After entering the amount to spend, press the Enter button, and you will be presented with a Transfer Funds dialog, like the following:
  
 
[[File:Trading_xferFundspng.png]]
 
[[File:Trading_xferFundspng.png]]
Line 28: Line 32:
 
[[File:Screen_Shot_2013-04-28_at_12.41.36_PM.png]]
 
[[File:Screen_Shot_2013-04-28_at_12.41.36_PM.png]]
  
== Example ==
+
Afterwards, the transaction in the CAD account will look like the following when viewing full splits:
 +
 
 +
[[File:Trading_fullSpilt.png]]
 +
 
 +
Or in the USD account without splits:
  
The following is example 4.4 from P. Selinger's [http://www.mscs.dal.ca/~selinger/accounting/tutorial.html Tutorial on multiple currency accounting].
+
[[File:Trading_USDonlyView.png]]

Latest revision as of 09:22, 7 February 2022

Since version 2.3.8 resp. 2.4.0 GnuCash supports the internal mechanism of trading accounts as described in Tutorial on multiple currency accounting and Multiple currency accounting in GnuCash by P. Selinger. In short their benefit is to avoid imbalances caused by trading commodites.

Before there was some discussion, because they show unrealized gains and should not be part of the income. So they got their own type and are placed at the top level of the account hierachy.


Setup

Trading Accounts are not enabled by default, and must be explicitly enabled for Gnucash. To do so, use the File->Properties->Account settings tab, and check Use Trading Accounts.

Overview

Trading Accounts are used to represent the imbalances caused by a transaction involving two different currencies, as described in the Tutorial. There will be one such account for each currency which is involved in the Gnucash file.

These accounts are created automatically when a transaction is entered which has a debit to an account in one currency and a credit to an account in a different currency.

Usage

To use Trading Accounts, first ensure that the accounts you are using are denominated in the desired currencies. For example, you might have an asset account 'Canadian Cash' denominated in CAD and an account 'U.S. Cash' denominated in USD.

Then simply enter a transaction which exchanges amounts between the two accounts, starting in the account with the currency you wish to express the initial value in.

The following is example 4.4 from P. Selinger's Tutorial on multiple currency accounting. To exchange 120 CAD for 100 USD, start in the 'Canadian Cash' account and enter a transaction where the Transfer account is 'U.S. Cash'. After entering the amount to spend, press the Enter button, and you will be presented with a Transfer Funds dialog, like the following:

Trading xferFundspng.png

At the bottom, you may enter either the rate of exchange, of the amount of USD dollars corresponding to the other side of the transaction.

After clicking OK, a new top level 'Trading' placeholder account is created, with a sub-account named 'Currency' and two sub-accounts of this, one for USD and the other for CAD. Transactions are automatically created in these accounts, corresponding to the imbalances. These are split transactions, similar to those shown here:

Screen Shot 2013-04-28 at 12.41.36 PM.png

Afterwards, the transaction in the CAD account will look like the following when viewing full splits:

Trading fullSpilt.png

Or in the USD account without splits:

Trading USDonlyView.png