Difference between revisions of "Lots GUI"

From GnuCash
Jump to: navigation, search
m (test link)
(screenshot after scrubbing)
Line 1: Line 1:
 
Here is a relatively simple demo on how the Lots page functions.
 
Here is a relatively simple demo on how the Lots page functions.
  
The account transactions are illustrated in the image below.
+
The account transactions are illustrated in the following [https://imgur.com/NOBTWUl image].
 
 
https://i.imgur.com/NOBTWUl.png
 
 
 
 
There are two purchase and two sale transactions involved.
 
There are two purchase and two sale transactions involved.
  
Opening the Actions -> View Lots menu item will display the Lots in Account window.
+
Opening the Actions -> View Lots menu item will display the [https://imgur.com/KcMtwU8 Lots in Account] window.
 
 
https://i.imgur.com/KcMtwU8.png [https://imgur.com/KcMtwU8]
 
  
 
At this point, you can use the Scrub Account option. This will do the following:
 
At this point, you can use the Scrub Account option. This will do the following:
Line 16: Line 11:
 
* match the units from the sale transactions to the purchase transactions,
 
* match the units from the sale transactions to the purchase transactions,
 
* calculate capital gains and create the related transactions records
 
* calculate capital gains and create the related transactions records
 +
 +
The results of account scrubbing can be seen [https://imgur.com/1V0TgRe here].
  
 
All of these steps can also be performed manually. In this case, you would have to create lots and add the purchase transactions into them. Then divide the sale transactions into splits that match the (portions of) the purchase transactions and include them into appropriate lots. Once the matches are made, you need to Scrub the selected lot in order to calculate the capital gains and create the related transaction.
 
All of these steps can also be performed manually. In this case, you would have to create lots and add the purchase transactions into them. Then divide the sale transactions into splits that match the (portions of) the purchase transactions and include them into appropriate lots. Once the matches are made, you need to Scrub the selected lot in order to calculate the capital gains and create the related transaction.
Line 21: Line 18:
 
The Capital Gains transaction will be created separately to the sale transaction but will be linked to it via Lot. This way it will not be recreated if a split is moved out of a lot and/or back into it.  
 
The Capital Gains transaction will be created separately to the sale transaction but will be linked to it via Lot. This way it will not be recreated if a split is moved out of a lot and/or back into it.  
 
However, the capital gains transaction will also not be removed if any split is moved out of the lot. This you would have to do manually in the account register.
 
However, the capital gains transaction will also not be removed if any split is moved out of the lot. This you would have to do manually in the account register.
 +
 +
Let's look at the details.

Revision as of 02:24, 21 January 2018

Here is a relatively simple demo on how the Lots page functions.

The account transactions are illustrated in the following image. There are two purchase and two sale transactions involved.

Opening the Actions -> View Lots menu item will display the Lots in Account window.

At this point, you can use the Scrub Account option. This will do the following:

  • create Lots for all the purchase transactions,
  • match the units from the sale transactions to the purchase transactions,
  • calculate capital gains and create the related transactions records

The results of account scrubbing can be seen here.

All of these steps can also be performed manually. In this case, you would have to create lots and add the purchase transactions into them. Then divide the sale transactions into splits that match the (portions of) the purchase transactions and include them into appropriate lots. Once the matches are made, you need to Scrub the selected lot in order to calculate the capital gains and create the related transaction.

The Capital Gains transaction will be created separately to the sale transaction but will be linked to it via Lot. This way it will not be recreated if a split is moved out of a lot and/or back into it. However, the capital gains transaction will also not be removed if any split is moved out of the lot. This you would have to do manually in the account register.

Let's look at the details.