Items Table with Investments List

 Securities are listed in the Items table. The use of this table in portfolio accounting makes it possible to keep track of the quantity of securities bought, sold and current.

Enter all securities in the Items table. It works like Excel, so you can add, remove and duplicate rows.

• The id which is generally the ISIN of the security.
• The description
• The quantity and initial unit price.
• The Account specified in the Account Table where all movement related to this investment should be recorded. 
  It is the point of connection between Financial Accounting and Investment Accounting. 
  The sum of of the book value of all securities sharing the same account should equal the account balance.
  The Reconciliation Report check that the account and investments balance are the same. 
• The groupings, to have separate totals for stocks, bonds, funds or whatever you prefer.
  Usually for each grouping you use a different investment account. 
• Price Current 
  The current (market) value.
  You have to enter the market value manually (you can eventually paste from Excel).
• For multi-currency accounting you also set the currency of the security.
  In this case the accounting account must also be in the same currency.

The program calculates automatically:

• Initial value. 
  Opening quantity * Opening Value
• The current quantity.
  Initial value plus transaction's quantity minus/plus.
• Current V. 
  Total value * Current price.
• The totals for the different groups.

Grouping

We advise to create groups for different securities types, to have the total amount for each securities category. The groupings are also used in the portfolio valuation report as a reference for dividing the results into group types.