Calculate book profit/loss on sale

Enter the data for the security sold and automatically obtain the result of the sale to be recorded in the accounts.

Obtaining the book value of a security is more difficult than obtaining its market value, as it has to be searched for in the balance sheet. This feature saves a lot of time on calculations and searching for data in accounting documents.

Once you have sold the security via your securities management application, via your bank or whoever manages your portfolio, you should come into possession of some sales data such as the market price at which the security was sold or the quantity of securities sold.

In the Dialog, you choose the ISIN of the security you have sold (must be present in the Items table), complete the parameters with the data available to you and calculate the result. The values returned allow you to record the sale of the security in the accounts, updating its book value.

Parameters

•     Security id: Id (ISIN) of the security sold, the list of securities in the Items table is automatically proposed.
•     Quantity: The quantity of securities sold.
•     Current price: The current market price per security at which the security was sold (use '.' as decimal separator).
•     Current exchange rate: The exchange rate at which the security was sold (use the dot '.' as a decimal separator). If you are not using multi-currency accounting, you can simply enter 1.00 or leave the field blank.

After entering the parameters click on the Calculate results button.

Returned Values

•     Book value per unit: Current book value of the security sold.
•     Total book value: Total book value of the security sold, calculated on the basis of the quantity sold and the book value of the security.
•    Total at current price: Total market value of the security sold, calculated on the basis of the quantity sold and the market value per security.
•     Book profit/loss: Difference between the market value at which the security was sold and its book value.
•     Exchange rate profit/loss: Exchange rate result, may be an exchange rate gain or loss, in rare cases a breakeven. If you are not using multi-currency accounting, the result will only be 0.

Click OK when you have copied the values to close the dialog.