The Accounts Settings dialog allows you to specify which accounts should be used for different investment transactions, such as sales, revaluations, and other portfolio-related entries.

These accounts are referenced when the program automatically generates accounting transactions, ensuring that all portfolio movements are correctly recorded.

You are not required to fill in every account, only those relevant to your specific accounting setup. Thse used accounts must exists in the Accounts table, otherwise the dialog will display a message error when you try to accept the changes

Sections in the Dialog and Account Usage

The dialog is divided into three main sections.

Balance Accounts

This section contains accounts used to record the value of securities and related balances in the accounting system. These accounts define where investment assets and liabilities are stored.

• Investments: Contains the accounts used for securities and investment holdings.
• Assets: Contains the accounts used for recording other investment-related assets.
• Liabilities: Contains the accounts used for investment-related liabilities, such as margin loans or other financial obligations.

Value Changing Accounts

This section includes accounts that track gains, losses, and valuation adjustments for investments. These accounts are used when a security is sold or its market value changes.

• Realized Gain: Account for recording realized profits from security sales.
• Realized Loss: Account for recording realized losses from security sales.
• Unrealized Gain: Account for recording unrealized profits due to an increase in the market value of securities.
• Unrealized Loss: Account for recording unrealized losses due to a decrease in the market value of securities.
• Realized Exchange Rate Gain: Account for gains resulting from foreign currency exchange rate fluctuations when selling a security.
• Realized Exchange Rate Loss: Account for losses resulting from foreign currency exchange rate fluctuations when selling a security.
• Unrealized Exchange Rate Gain: Account for recording unrealized currency gains due to favorable exchange rate movements.
• Unrealized Exchange Rate Loss: Account for recording unrealized currency losses due to unfavorable exchange rate movements.
• Depreciations: Account for recording investment depreciation adjustments, if applicable.
• Other Value Changing Costs: Account for miscellaneous expenses affecting the value of investments.
• Other Value Changing Income: Account for miscellaneous income affecting the value of investments.
• Rounding Differences: Account for small discrepancies due to rounding or decimal precision differences.

Profit and Loss Accounts

This section contains accounts that track income and expenses related to investment transactions. These accounts are used to record direct costs and revenues generated from investment activities.

• Charges: Account for general investment-related charges and fees.
• Commissions: Account for broker or bank commissions on security trades.
• Interest Earned: Account for interest income from bonds or other financial instruments.
• Interest Paid: Account for interest expenses related to investment loans or margin trading.
• Dividends Income: Account for dividend income received from stock holdings.
• Other Income: Account for any additional investment-related income not classified elsewhere.
• Other Costs: Account for any additional investment-related costs not classified elsewhere.

This command imports and updates the current market prices of your securities by reading data from either a CSV file or Excel. Once you confirm the operation, the new prices are written to the UnitPriceCurrent column in the Items table.

You can gather current market prices from various financial portals (e.g., Yahoo Finance, Google Finance, ecc), directly copying the latest quotes into an Excel or CSV file. Ensure each security’s ISIN and current price are correctly aligned with the required format (one ISIN-price pair per line). When you’re satisfied with the data, save it or copy it into the format required for importing. The ISIN must have the same format as the ISIN inserited into the Items table.

Data Format

The extension expects the data to be in the following two-column format, with ISIN and Current Price separated by a semicolon (;):

US123456789;11.04873
IT000792468;10.98732
...

• First column: The ISIN (or security identifier).
• Second column: The latest market price, without thousands separators and using a period (".") as the decimal separator.

How It Works

1. Open the command: Choose Import & Update Current Prices from the menu or toolbar.
2. Select the file: In the dialog, you can either browse to a CSV file or paste data directly from Excel containing ISIN and price pairs.
3. Preview and confirm: The extension parses the data, matching each ISIN to the corresponding security in your accounting file. You will see a confirmation dialog listing the changes, so you can verify them before they are applied.
4. Update current prices: Upon confirmation, the program updates the UnitPriceCurrent column in the Items table with the new market prices.

This command helps you determine the unit price when only the total amount and the quantity of the securities sold are known. It is particularly useful when a bank statement provides only these two values, but not the precise unit price.

How It Works

1. Select the security sale transaction row: This row should contain the total amount of the sale (the net proceeds), but no quantity or unit price yet.
2. Enter the quantity: When you run the Calculate Unit Price command, a dialog will ask you to enter the quantity of the securities sold.
3. Review the Preview: After the command calculates the unit price by dividing the total amount by the entered quantity, a preview of the updated row is displayed. You can accept or cancel these changes before they are applied.
4. Confirm the Changes: Once you confirm, the newly calculated unit price is applied to the transaction row, making it ready for any further actions (e.g., generating a final sale record or calculating profit or loss).

Troubleshooting

• The selected row does not contain the Security ID: This message is shown when you are trying to create sales records having selected a row without a valid security id. Each row on which changes are made must contain the valid id of a title in the Items table.
• The selected row does not contain a valid Amount: This message is shown when you are trying to create sales records having selected a row with a non valid amount.
• The selected row in the Transactions table is not valid: The selected row in the transactions table is not a valid row.

The Calculate sales data dialog allows you to determine the book profit or loss from a security sale. It provides two main functions within a single dialog:

1. Calculate the Sale Result (independent of the selected row): By clicking "Calculate profit or loss" button, you can immediately see a preview of the sale result based on the data entered (or automatically retrieved) without recording any transaction. This function works even if you are not starting from the net sale transaction row.
2. Create the Sales Record (requires the net sale transaction row): By clicking "Create sales record" button, you instruct the program to generate the necessary accounting entries for the sale. To do this, you must start from the sale transaction row in the Transactions table, which records the net sale of the security.

Start from the Sale Transaction Row

When creating the actual sales record, the program needs to know which transaction to update or supplement with additional entries (such as fees, net proceeds, exchange differences, etc.). Therefore, you must begin with the row that already documents the net sale of the security.

If this row already includes:

• Item (Security ID)
• Quantity
• Unit Price (Market Price)
• Exchange Rate (for multi-currency accounting)

The dialog retrieves them automatically. Otherwise, you will need to enter them in the dialog.

This sale transaction row is currently the only row that must be entered manually. Once it exists, the program can create and add all other entries automatically.

How to use the dialog

When you execute this command, a dialog titled "Calculate book profit/loss on sale" opens.

Here, you must enter specific details about the sale, including:

• Security Data:
  • Id (ISIN): Select the security from the dropdown.
  • Type: Displays whether the security is a Stock or a Bond
  • Quantity/Nominal Value: Enter the quantity of the security being sold.
  • Current Price: The market price per unit at which the security is being sold.
  • Current Exchange Rate: If applicable, enter the exchange rate for the transaction currency.
  • Bank Charges: Specify any bank fees related to the sale. If not present, the record line is not added
  • Other Charges: Enter any additional costs associated with the transaction, If not present, the record line is not added.
  • Accrued Interests: If selling bonds, include the accrued interest amount (enabled only with bonds).
• Results Preview: Once the required data is entered, clicking "Calculate profit or loss" generates a preview showing:
  • Actual Quantity:  The number of units held before the transaction.
  • Book Value per Unit: The average purchase price of the security.
  • Total Book Value: The total purchase value of the securities being sold.
  • Total at Current Price: The total market value of the securities at the entered price.
  • Book Profit/Loss: The difference between the book value and the sale value.
  • Exchange Rate Profit/Loss: If the security is in a different currency, the profit or loss due to exchange rate variations.

Amounts are shows using the number of decimals available in the column where the value would be placed in the Transactions table.

When entering an amount in the dialog, always use a period (".") as the decimal separator and do not use any thousands separators.

The Sale recording

Once you are satisfied with the preview, you can click "Create sales record" to finalize the transaction. The program will then present a confirmation dialog showing the entries to be added or modified, allowing you to review everything before proceeding.

• Upon confirmation, the program updates the accounting records with any new or modified entries.
• If the quantity is zero or the calculated profit/loss is zero, no transaction is created.
• The program also adds a transaction identifier to the ExternalReference column (both for the starting row and any newly added rows) to prevent duplications if you run the command multiple times on the same sale row.
• If the program detects an existing record for this sale, it will ask whether you want to overwrite it.

This feature ensures that securities sales are correctly recorded, while giving you full control over transactions before they are finalized.

In the example shown in the photo, placeholder accounts have been used. These are essentially used when no accounts are defined in the Accounts Settings dialog.

Troubleshooting

• The selected row does not contain the Security ID: This message is shown when you are trying to create sales records having selected a row without a valid security id. Each row on which changes are made must contain the valid id of a title in the Items table.
• The selected row does not contain a valid sale Quantity: This message is shown when you are trying to create sales records having selected a row with a positive quantity, this could happen if you forget to put the minus '-' sign before the quantity or if you selecte a purchase row.
• The selected row in the Transactions table is not correct: This message is shown when you are trying to create sales records having selected a row that is not the security sale row.
• The selected row in the Transactions table is not valid: The selected row in the transactions table is not a valid row.
• Item: CHXXX not found: The selected item does not exists in the Items table.
• Item: CHXXX without assigned type. Define the type in the Items table: This message is shown when you are trying to create sales records having selected an item for which a reference unit (ReferenceUnit column) has not been defined in the item table.

This extension allows you to generate accounting adjustment transactions for all securities by entering their market price in the dialog. To ensure correct input, the value must be entered without a thousands separator, and the decimal separator must be a period ("."). The program automatically proposes the list of securities found in the Items table.

Once you enter the market price, the program calculates the necessary adjustment by comparing the book value with the market value. The market price used for the adjustment is automatically inserted into the transaction description.

Before recording the transactions, a preview dialog is displayed, allowing you to review and confirm the adjustments. If the book value and the market value are identical, or if the security has a quantity of zero, no adjustment transaction is created.

The adjustment transaction is recorded using the cost or revenue account specified in the Account settings dialog under the "Other value changing income field". If no account is found, a placeholder is inserted instead.

This feature ensures that your securities are properly revalued while giving you full control over the adjustments before they are recorded. This operation could be performed multiple time in a year.

The Check Balances report verifies that the balances of individual securities match the balances of the accounts to which they are assigned.

This check is particularly useful at the beginning of a new accounting year to ensure that:

• Opening and closing balances have been recorded correctly.
• The balances of individual securities align with the total balances of their respective accounts.

Currently, this check is performed only for the current accounting year.

Why Use This Report?

• Helps detect discrepancies early, preventing accounting errors.
• Ensures that securities and their assigned accounts remain in sync.
• Provides a quick validation step after year-end closing.

This report provides the necessary information to reconcile accounting transactions related to securities. For each selected security account, it summarizes the movements associated with that security, allowing you to compare all recorded transactions with the totals calculated by the program.

Alongside the totals, there is a "Differences" field that highlights any discrepancies between the recorded transactions and the calculated totals. This amount should be zero; otherwise, it indicates that there is an inconsistency in the accounting records.

Selection Dialog

Select the account(s) for which you want to view the reconciliation

Report structure

The structure of this report is similar to that of the security card, as it includes all movements for each security. The only additional column identifies the accounting account associated with each security.

For each security account, the report provides summary totals after listing the movements:

• Opening Balance: Opening Balance of the security account
• Current Balance: Current balance of the security account returned by the program.
• Total securities movements: Sum of the total movements concerning the security (should correspond to the current Balance)
• Differences: Shows the difference between the balance reported in the field Current Balance and the total movements, if everything is correct the amount is equal to zero

This report creates a table that summarises all the movements regarding a certain security. The structure is similar to that of the account card, but besides being filtered by security, it also shows the variation of the quantity of securities over time and how the securities' book value changes after each operation.

The header of the table shows the id, description and currency of the security along with the current date.

Selection Dialog

Enter the id of the title for which you want to create a tab. If the title is not found in the Items table, an error message is displayed, in this case make sure that the title exists in the table. By default is shown the list of the securities existing in the Items table.

When you reopen the dialog the title you entered last time will be displayed again.

Report structure

• Date: Transaction date.
• Doc: Transaction number.
• Description: Transaction description.
• Debit (item Currency): Debit amount in the item currency.
• Credit (item Currency): Credit amount in the item currency.
• Quantity: Purchased or sold quantity.
• Unit Price (item Currency): purchase or sale (unit) price of the security.
• Balance (item Currency): Balance amount in the item currency.
• Quantity Balance: Current quantity of securities.
• Book value per unit (item Currency): Current average accounting cost of the security.
• Debit (Base Currency): Debit amount in base currency.
• Credit (Base Currency): Credit amount in base currency.
• Balance (Base Currency): Balance amount in base currency.

The report provides a comprehensive overview of your current investments. It is divided into two main sections:

• Appraisal Report: Offers a snapshot of your investments, comparing the book value of each security with its current market value.
• Investment accounting transactions: Displays a detailed list of all transactions carried out for each security.

Appraisal Report

The Appraisal Report is designed to help you quickly assess the situation of your investments. It displays key information such as book value, current market value, and any unrealized gains or losses for each security.

To use this report effectively, ensure you enter the latest market price for each security in the Items table under the Price Current column.

• Type/Security: Name of the group or security.
• ISIN: Isin or identification number of the security.
• Currency: Currency in which the value of the security is expressed.
• Current quantity: Quantity of securities.
• Book value per unit: Average unit cost of securities.
• Book value: Value of the securities.
• Market value per unit: The current unit price of the securities, to be entered manually in the Price Current column.
• Market value: Market value of the securities.
• % of Port: Percentage of investments represented by securities.
• Un.Gain or Loss: Unrealised Profit/Loss
• % G/L: Ratio of Unrealized Gain/Loss to Market Value.

Investment accounting transactions report

Summarises the accounting operations carried out for each security.