The tutorial file provides a ready-to-use example of integrated Investment Accounting, where the company's financial accounting and the detailed management of investments are maintained in the same Banana Accounting file.

All investments are managed in the accounting base currency, making this template suitable for learning and applying the basic principles of Investment Accounting without the additional complexity of foreign currencies.

The file includes a complete accounting structure for recording both the company's general business activities and its investment transactions. Investment-specific information, such as quantities, prices, Book Values, and Market Values, is managed alongside the corresponding accounting entries.

Chart of Accounts

The chart of accounts provides a complete double-entry accounting structure for high-net-worth individuals (HNWIs), integrating Investment Accounting with the management of real estate properties, other personal assets, liabilities, income, and costs.

Balance Sheet Accounts

The Balance Sheet Accounts are organized into the following main categories:

• Liquidity, including cash, bank accounts, and withholding tax receivables;
• Investments, with dedicated Investment Balance Sheet Accounts for securities and other financial investments;
• Other Assets, including cars, pension assets, furniture and art, and receivables;
• Real Estate Assets, with separate accounts for each owned property;
• Debts, including other debts, loans, and mortgages;
• Equity, including equity and the current year profit or loss.

This structure makes it possible to manage securities, real estate properties, and other personal assets and liabilities within the same accounting file.

Profit & Loss Accounts

The Profit & Loss statement is structured to record both investment results and the other income and costs related to the individual's assets and personal finances.

Investment income and results include accounts for realized gains and losses on securities, foreign exchange results, unrealized investment and exchange rate adjustments, interest, dividends, and investment-related expenses.

The Profit & Loss statement also includes:

• Employment income, such as salary and bonuses;
• Depreciation, including depreciation of cars and furniture;
• Personal and asset-related costs, including cars, insurance, administration, legal fees, interest, taxes, health, and family costs;
• Real Estate Revenue and Costs, organized separately for each property, allowing rental and other income to be compared with utilities, insurance, maintenance, condominium fees, and other property-specific costs.

The structure therefore makes it possible to determine the overall financial result while also keeping investment results and the results of individual real estate properties clearly identifiable.

Because Investment Accounting is integrated into the financial accounting, purchases, sales, investment income and costs, realized gains and losses, and valuation adjustments are recorded directly in the same accounting file and are reflected in the corresponding Balance Sheet and Profit & Loss accounts.

Managing Quantities, Prices, and Values

The details of individual investments are managed in the Items table. The tutorial file includes sample shares and bonds and shows how investment-specific information can be maintained alongside the financial accounting.

For each investment, the Items table contains information such as the Item identifier, description, Asset Account, Quantity, Unit Price, Book Value, Market Price, and Market Value.

For more information, see the Items page.

Transactions

Investment transactions are recorded directly in the same Transactions table used for the company's general accounting.

The tutorial file contains example transactions covering the main investment operations, such as purchases, sales, income, costs, realized gains and losses, and valuation adjustments.

Because the investment transactions are part of the double-entry accounting, their accounting effects are immediately reflected in the corresponding accounts and in the company's Balance Sheet and Profit & Loss statement.

For more information, see Investment Accounting Transactions.

Other Resources

Other Banana Accounting templates are available depending on how you want to manage your investments:

• Double-Entry Multi-Currency Accounting with Integrated Investment Accounting – for managing investments denominated in foreign currencies directly within multi-currency double-entry accounting.
• Multi-Currency Investment Accounting in a Separate File – for keeping detailed Investment Accounting in a separate Banana Accounting file that can be used as an investment subledger for your general accounting.

This template provides a ready-to-use example of multi-currency double-entry accounting for high-net-worth individuals (HNWIs), with integrated Investment Accounting.

The accounting structure is designed to manage the individual's overall personal wealth, not only securities and financial investments. Within the same Banana Accounting file, it is possible to manage cash and bank accounts in different currencies, securities, real estate properties, cars, pension assets, furniture and art, receivables, debts, mortgages, and equity.

The Profit & Loss Accounts complement the wealth management structure by recording investment results and income, employment income, depreciation, taxes, personal and family costs, and the revenue and costs associated with individual real estate properties.

This provides an integrated view of the individual's assets and liabilities, together with the income, costs, and financial results that affect the overall personal wealth.

Chart of Accounts

The chart of accounts is structured to manage the different components of personal wealth and the related income and costs within the same multi-currency accounting file.

Balance Sheet Accounts

The Balance Sheet Accounts provide the accounting structure for managing the individual's assets, liabilities, and equity.

They are organized into the following main categories:

• Liquidity, including cash, bank accounts in different currencies, derivative positions, and withholding tax receivables;
• Investments, with dedicated Investment Balance Sheet Accounts for securities and other financial investments in different currencies;
• Other Assets, including cars, pension assets, furniture and art, and receivables;
• Real Estate Assets, with separate accounts for each owned property;
• Debts, including other debts, loans, and mortgages;
• Equity, including equity and the current year profit or loss.

For Investment Accounting, each security maintained in the Items table is linked through its Asset Account to the corresponding Investment Balance Sheet Account. This makes it possible to maintain detailed information for individual securities while keeping their accounting values fully integrated into the Balance Sheet.

Profit & Loss Accounts

The Profit & Loss Accounts are structured to record the income, costs, and financial results associated with the individual's personal wealth and activities.

They include:

• Investment income and results, including realized gains and losses on securities, foreign exchange results, unrealized investment and exchange rate adjustments, interest, dividends, and investment-related expenses;
• Employment income, including salary, fees, bonuses, and related social security contributions;
• Depreciation, including depreciation of cars and furniture;
• Personal and asset-related costs, including car expenses, insurance, administration, legal fees, loan interest, taxes, health costs, family costs, and other personal expenses;
• Real Estate Revenue and Costs, with dedicated income and expense accounts for each property, including rent, other revenue, utilities, insurance, maintenance, condominium fees, and other property-specific costs.

This structure makes it possible to determine the overall financial result while keeping the results from investments and individual real estate properties clearly identifiable.

Other Resources

Other Banana Accounting templates are available depending on how you want to manage your personal accounting and investments:

• Double-Entry Accounting with Integrated Investment Accounting – for managing personal wealth and investments directly within double-entry accounting when securities are managed in the accounting base currency.
• Multi-Currency Investment Accounting in a Separate File – for keeping detailed multi-currency Investment Accounting in a separate Banana Accounting file that can be used as an investment subledger for your general accounting.

With Banana Accounting, you can also manage investments in a file separate from your general accounting.

If you use other software for your general accounting and currently manage investments with Excel or other separate tools, you can use Banana Accounting with the Investment Accounting extension to maintain complete and detailed Investment Accounting.

With the Investment Accounting extension, you can automate several operations, such as calculating realized gains and losses on sales, creating adjustments for unrealized gains and losses, updating Market Prices, and calculating exchange rate differences for investments in foreign currencies.

This solution is particularly useful if you use other software for your general accounting or if you want to keep detailed Investment Accounting separate from your general accounting.

The Banana file can be used as an investment subledger: it maintains the details of individual investments and their related transactions, while in the general accounting you can record the required accounting values, including aggregated amounts by account or investment category.

Investment Accounting is therefore managed on two levels:

• In the general accounting file, you record all general accounting transactions, including the accounting values related to investments that are required for preparing the financial statements.
• In the Banana Investment Accounting file, you maintain all the details of individual investments, including quantities, prices, Book Values, Market Values, realized and unrealized gains and losses, as well as the related accounting transactions.

The principle is simple: the Banana file maintains the details of the investments, while the general accounting receives the required accounting effects.

The following sections explain how the example file works and how to integrate the resulting accounting data into the general accounting.

Chart of Accounts

The chart of accounts in the example file is intentionally concise and has been created specifically for Investment Accounting and for using the functions provided by the Investment Accounting extension.

The Accounts table contains only the accounts required to record Investment Accounting transactions and obtain the related Balance Sheet and Profit & Loss statement values.

Balance Sheet

Asset Accounts

The Balance Sheet mainly includes bank accounts, investment accounts, and the withholding tax receivable account required for managing investments.

The example file includes separate accounts by currency to properly manage investments and their related multi-currency transactions.

The bank accounts in the Banana Investment Accounting file are technical accounts used as counterpart accounts for recording cash flows related to investments. Their balances do not necessarily correspond to the balances of the bank accounts in the general accounting, where the cash flows of the entire business are recorded.

Liability and Equity Accounts

These include Equity and the Current Year Profit or Loss required to complete the accounting structure of the file.

Profit & Loss Accounts

The Profit & Loss statement contains only the accounts required to record the income and expenses arising from investment transactions, such as interest, dividends, commissions and fees, realized gains and losses, unrealized value adjustments, and exchange rate differences.

Opening Balances

The opening balances of the Investment Balance Sheet Accounts are entered in the Accounts table. For each Investment Balance Sheet Account, the opening balance in the Banana file must correspond to the sum of the opening values of the Items linked to the same Asset Account.

Opening balance of the Investment Balance Sheet Account in the Banana file = Sum of the opening values of the linked Items

When the corresponding Investment Balance Sheet Account is also present in the general accounting, the opening balance from the Banana file must be consistent with the opening balance of the corresponding account in the general accounting:

Opening balance of the Investment Balance Sheet Account in the Banana file = Opening balance of the corresponding Investment Balance Sheet Account in the general accounting

Managing Quantities, Prices, and Values

The details of individual investments are managed in the Items table. For each investment, the table contains information such as the Item identifier, description, Asset Account, Quantity, Unit Price, Book Value, Market Price, and Market Value.

For more information, see the Items page.

Transactions

The example file contains transactions covering the main investment operations, including purchases, sales, dividends, interest, commissions and fees, realized gains and losses, value adjustments, and exchange rate differences.

The transactions contain both the standard double-entry accounting information and investment-specific information, such as Item, Quantity, and Unit Price.

For more information, see the Transactions page.

Updating and Reconciling the General Accounting

The Banana Investment Accounting file can be used as an investment subledger for your general accounting. It maintains the details of individual investments and their related transactions, while the required accounting values are recorded in the general accounting.

The transfer of these values is not automatic. You can update the general accounting in two main ways:

• Periodically, by keeping the detailed investment transactions in the Banana Investment Accounting file and transferring the required accounting values to the general accounting at regular intervals or when financial statements need to be prepared. This can be done, for example, at the end of a month, quarter, half-year, or year.

Important: When using periodic updates, it is not sufficient simply to record the difference between the opening and closing balance of an investment account. Purchases, sales, realized gains and losses, income, costs, and any applicable value or exchange rate adjustments must be transferred to the general accounting according to their accounting nature.

The values transferred to the general accounting can be recorded in aggregated form by investment account or category, provided that the required accounting information is maintained and the corresponding balances can be reconciled with the Banana Investment Accounting file.

• Transaction by transaction, by recording the corresponding accounting effects in the general accounting as the investment transactions are recorded in the Banana file.

After the required accounting values have been recorded in the general accounting, the Book Values resulting from the Banana file can be used to verify the corresponding investment account balances:

Book Value from the Banana file = Balance of the corresponding investment account in the general accounting

In this way, the Banana file maintains the detailed information for individual investments and their related transactions, while the general accounting contains the accounting values required for financial reporting.

Integrated Investment Accounting Templates

Other Resources

If you prefer to manage investments directly within your financial accounting instead of using a separate Investment Accounting file, you can use one of the following Banana Accounting templates with integrated Investment Accounting:

• Double-Entry Accounting with Integrated Investment Accounting
• Double-Entry Multi-Currency Accounting with Integrated Investment Accounting

The Accounts Settings dialog allows you to specify the accounts used for different investment transactions, such as sales, valuation adjustments, and other investment-related entries.

These accounts are used by the Investment Accounting extension when it automatically calculates or creates accounting transactions, ensuring that the appropriate accounts are used for each type of operation.

You do not need to specify every account, only those required for your accounting setup. The accounts entered in the dialog must exist in the Accounts table. If an account does not exist, the program displays an error message when you try to confirm the settings.

Sections in the Dialog and Account Usage

The dialog is divided into three main sections.

Balance Accounts

This section contains the Balance Sheet accounts associated with investments and other investment-related balances.

• Assets 
  Contains the accounts used to record investment assets.
  The first time you open the dialog, the program automatically fills this field with the Investment Balance Sheet Accounts specified in the Asset Account column of the Items table.
• Liabilities
  Contains the accounts used for investment-related liabilities, such as margin loans or other financial obligations.
   

Value Changing Accounts

This section contains the accounts used to record realized and unrealized gains and losses, exchange rate differences, and other adjustments affecting the value of investments.

• Realized Gain: Account for recording realized gains from investment sales.
• Realized Loss: Account for recording realized losses from investment sales.
• Unrealized Gain: Account for recording unrealized gains due to an increase in the market value of investments.
  Used by the Create adjustment transactions command.
• Unrealized Loss: Account for recording unrealized losses due to a decrease in the market value of investments.
  Used by the Create adjustment transactions command.
• Realized Exchange Rate Gain: Account for recording realized exchange rate gains arising from the sale of investments denominated in a foreign currency.
• Realized Exchange Rate Loss: Account for recording realized exchange rate losses arising from the sale of investments denominated in a foreign currency.
• 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 the accounts used to record income and expenses related to investment activities.

• Charges: Account for general investment-related charges and fees.
• Commissions: Account for broker or bank commissions on investment transactions.
• 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 investments.
• Other Income: Account for any additional investment-related income not classified elsewhere.
• Other Costs: Account for any additional investment-related costs not classified elsewhere.

Error Messages

• Account XXX not found in the Accounts table: The account entered does not exist in the Accounts table.
  • Add the account to your Accounts table.
  • Select the “Ignore warnings/errors” checkbox at the bottom of the dialog to ignore the error.

This command updates the current market prices of investments in the Items table. Market price data can be imported from a CSV file or from the clipboard.

Before applying the changes, Banana Accounting displays a preview in the Commit changes dialog. Once the changes are confirmed, the imported prices are entered in the Price Current column of the Items table.

Price Current Column

The Price Current column in the Items table contains the current market price used to calculate the current value of the investment.

You can update Price Current manually, by copying and pasting values into the Items table, or by using the Update market prices command to import prices for multiple investments.

When market prices are imported and the changes are confirmed, the command updates the Price Current column of the corresponding Items.

Prepare Current Market Price Data

Current market prices can be obtained from financial information providers and prepared in an Excel or CSV file for import.

For each investment, provide:

• the ISIN or other identifier used to identify the investment
• the corresponding current market price.

Make sure that the identifier used in the import data corresponds exactly to the identifier entered for the investment in the Items table.

File Format

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

US123456789;11.04873
IT000792468;10.98732
...

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

Import Procedure

You can import the data in two different ways.

Import *.csv File

1. Choose Extensions > Investment accounting > Update market prices.
2. Select the *.csv file.
3. Review the changes in the Commit changes dialog and confirm them.

Import from Clipboard

1. Choose Actions > Import to accounting and select the Import File option.
2. Select the extension to be used, in this case 2. Update market prices.
3. Open the Excel file, select the data, and copy it to the clipboard.
4. In the import dialog, select Import data from clipboard.
5. Click OK.
6. Review the changes in the Commit changes dialog and confirm them.

Error Messages

• Unrecognised *.csv file format: The format of the *.csv file you are trying to import does not match the required format.
  • Make sure that you selected the correct file.
  • Check that the data follows the format described in the File Format section above.
• Items table not found: The Items table is not present in the accounting file.
  • Add the Items table to the accounting file.
• Asset: XXX not found in the Items table: The identifier contained in the imported data does not correspond to an investment in the Items table.
  • Check that the identifier is correct and corresponds to the one entered in the Items table.
  • If the investment has not yet been defined, add it to the Items table before importing its market price.

The Calculate sales data dialog allows you to calculate the realized gain or loss resulting from the sale of an investment and, when required, create the related accounting transactions.

The dialog provides two main functions:

1. Calculate the Sale Result – Click Calculate profit or loss to preview the realized gain or loss based on the data entered in the dialog or automatically retrieved from the accounting file. No accounting transactions are created. This function can also be used without starting from the sale transaction row in the Transactions table.
2. Create the Sales Record – Click Create sales record to create the accounting transactions required to complete the sale recording. To use this function, start from the sale transaction row in the Transactions table that records the net proceeds from the investment sale.

Start from the Sale Transaction Row

When creating the sales record, the program needs to identify the transaction to be completed with the additional entries required to record the sale, such as charges, realized gains or losses, and exchange rate differences. Therefore, you must start from the transaction row that records the net proceeds from the investment sale.

If this row already includes:

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

The dialog retrieves this information automatically. Otherwise, you need to enter the missing information in the dialog.

The sale transaction row is the only row that must be entered manually. Once this row is available, the program can automatically create the additional entries required to complete the sale recording.

How to use the dialog

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

Enter or review the information required for the sale:

• 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 or nominal value of the investment being sold.
  • Current Price: Enter the price per unit at which the investment is being sold.
  • Current Exchange Rate: For investments denominated in a foreign currency, enter the exchange rate applicable to the transaction.
  • Bank Charges: Enter any bank charges related to the sale. If no amount is entered, the corresponding transaction is not created.
  • Other Charges: Enter any additional costs related to the sale. If no amount is entered, the corresponding transaction is not created.
  • Accrued Interests: For bonds, enter any accrued interest related to the sale. This field is enabled only for bonds.
• Results Preview: Once the required data is entered, click Calculate profit or loss to generate a preview showing:
  • Actual Quantity:  The quantity held before the sale.
  • Book Value per Unit: The current book value per unit of the investment.
  • Total Book Value: The book value of the investment quantity being sold.
  • Total at Current Price: The value of the investment quantity being sold at the entered Current Price.
  • Book Profit/Loss: The difference between the book value and the sale value.
  • Exchange Rate Profit/Loss: For investments denominated in a foreign currency, the gain or loss resulting from exchange rate differences.

Amounts are displayed using the number of decimal places defined for the corresponding columns in the Transactions table.

When you enter an amount in the dialog, make sure to use the local number format (for example, “1'234.56” in Switzerland), as this is the format expected by the program.

Recording the Sale

Once you are satisfied with the preview, click Create sales record to create the accounting entries required to complete the sale recording. The program displays a confirmation dialog showing the entries to be added or modified, allowing you to review them before applying the changes.

• Upon confirmation, the program updates the accounting records with the new or modified entries.
• If the quantity is zero or the calculated profit/loss is zero, no transaction is created.
• The program adds a transaction identifier to the ExternalReference column of both the original sale row and any newly created rows. This prevents duplicate entries if the command is run 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 procedure helps ensure that investment sales are correctly recorded while allowing you to review the accounting entries before they are applied.

In the example shown in the image, placeholder accounts are used. These are used when the corresponding accounts have not been defined in the Accounts Settings dialog.

The extension uses a neutral number (±123.00) in the Quantity column when recording the realized gain or loss. A neutral quantity does not change the quantity held but allows the amount of the realized gain or loss to be associated with the investment and its corresponding unit value to be shown in the Unit Price column. This is especially useful for investment funds and ETFs.

Error Messages

• Items table not found: The Items table is not present in the accounting file.
  • Add the Items table to your file.
• Asset: XXX not foun: The selected Asset does not exist in the Items table.
  • Add the Item to the Items table
  • A valid Asset must have an ID and an Asset Account
• Asset: XXX without assigned Asset Account: No Asset Account has been assigned to this Asset in the Items table.
  • Define an account in the Asset Account column for the Asset in the Items table.
• Asset: XXX without assigned type: No Asset Type has been defined for this Asset.
  • Define the Asset Type in the Items table.
• The selected row does not contain the Asset ID: The selected row does not contain a valid Asset ID. To create the sales record, the selected row must contain the ID of an Asset defined in the Items table.
• The selected row does not contain a valid sale Quantity: The selected row does not contain a valid quantity for an investment sale. The sale quantity must be negative. Check that the quantity is preceded by a minus sign (-) and that you have selected a sale row rather than a purchase row.
• The selected row in the Transactions table is not correct: The selected row does not correspond to the investment sale row required to create the sales record.
• The selected row in the Transactions table is not valid: The selected row in the Transactions table is not a valid transaction row.

This command automatically creates adjustment transactions to align the book value of investments with their current market value and, for investments denominated in a foreign currency, with current exchange rates. Adjustment transactions can be created multiple times during the year. For year-end adjustments, see Investment Accounting Opening and Closing the Year.

Define Current Market Values

Set Up the Current Prices

In the Items table, enter the current market price for each investment in the Price Current column.

You can:

• Enter the current prices manually, including only for the investments for which you want to create adjustment transactions.
• Use the Update Market Prices command to import and update current prices for multiple investments.

Current Exchange Rates

For investments denominated in a foreign currency, the current value in base currency is automatically calculated using the current exchange rate defined for the corresponding currency in the Exchange rates table.

The current exchange rate is the exchange rate entered without a specific date. For more information, see Items Table with Investments List.

Adjustment Transactions Dialog

When you run the Create adjustment transactions command, a dialog asks you to enter the date to be used for the adjustment transactions. By default, the current date is suggested.

All adjustment transactions created by the command are recorded with the specified date.

Commit Changes Dialog

Before the adjustment transactions are recorded, the Commit changes dialog displays a preview of all the transactions that will be created, allowing you to review them before confirming the changes.

Adjustement Transactions

Adjustment transactions are generated and grouped by investment. If both a market price adjustment and an exchange rate adjustment are required for the same investment, the corresponding transactions are kept together.

Adjustment transactions are recorded using the Asset Account defined for the investment in the Items table, increasing or decreasing its book value. The offsetting entry is recorded in the corresponding gain or loss account.

If the following accounts are defined in the Accounts Settings dialog, the program uses them to record the adjustments:

• Unrealized Gain / Unrealized Loss for market price adjustments.
• Unrealized Exchange Rate Gain / Unrealized Exchange Rate Loss for exchange rate adjustments.

If the required accounts are not defined in the Accounts Settings dialog, the program inserts descriptive placeholder accounts in the generated transactions.

Once the adjustment transactions have been recorded, verify that the balances of the Asset Accounts match the current values of the corresponding investments in the Items table. For more information, see Create Adjustment Transactions.

In the following cases, no adjustment transactions are created:

• The book value already corresponds to the current market value and, for investments denominated in a foreign currency, the book exchange rate corresponds to the current exchange rate.
• The investment has a current quantity of zero.
• No current market price is defined for the investment.

Error Messages

• Items table not found: The Items table is not present in the accounting file.
  • Add the Items table to your file.
• No Asset found in the Items table: The Items table does not contain any valid Assets.
  • Add Assets to the Items table.
  • A valid Asset must have an ID and an Asset Account.
• No Asset with current price found in the Items table: No Asset with a valid current price was found in the Items table.
• The carrying amounts are already aligned with the current market prices. No unrealized gains or losses have been generated: The book values of the investments are already aligned with their current market values and, where applicable, current exchange rates. No adjustment transactions are required.

The Check Balances report verifies that the values of individual investments are consistent with the balances of the Asset Accounts to which they are assigned.

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

• Opening and closing balances have been recorded correctly.
• The values of individual investments are consistent with the balances of their corresponding Asset Accounts.

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

Why Use This Report?

The report helps you:

• Identify discrepancies between investment values and the balances of the corresponding Asset Accounts.
• Verify that investments and their assigned Asset Accounts remain consistent.
• Check the consistency of balances after year-end closing.

The report can be exported and saved at any time. For more information, see Printouts/preview.

Error Messages

• Items table not found: The Items table is not present in the accounting file.
  • Add the Items table to your file.
• No Asset found in the Items table: The Items table does not contain any Asset.
  • Add Assets to the Items table.
  • A valid Asset must have an ID and an Asset Account.
• No Asset accounts found in the Items table: No Asset Accounts have been assigned to the Assets in the Items table.
  • Define an Asset Account for each Asset using the  Asset Account column. in the Items table.

The Reconciliation Report provides a detailed overview of the transactions recorded for investments and verifies that the balance of each Asset Account in the accounting records is consistent with the balance calculated from the transactions of the investments assigned to that account.

At the end of the report, a reconciliation summary shows the opening balance, the net change during the period, and the closing balance, allowing you to verify that the Asset Account balance matches the balance calculated from the corresponding investment transactions. Any differences are shown in the Differences fields, with the corresponding amounts highlighted in red.

Selection Dialog

Select the Asset Account(s) for which you want to generate the reconciliation report.

Report Structure

The structure of this report is similar to the Security Card report, as it lists the transactions for each investment assigned to the selected Asset Account.

For each selected Asset Account, a separate table is generated on a new page of the report.

Saving and Exporting the Report

The report can be exported and saved at any time. For more information, see Printouts/preview.

Error Messages

• Items table not found: The Items table is not present in the accounting file.
  • Add the Items table to your file.
• No Asset found in the Items table: The Items table does not contain any Asset.
  • Add Assets to the Items table.
  • A valid Asset must have an ID and an Asset Account.
• No Asset accounts found in the Items table: No Asset Accounts have been assigned to the Assets in the Items table.
  • Define an Asset account for each Asset in the Items table using the Asset Account column.

The Security Card report provides a detailed overview of all transactions recorded for a specific investment. Its structure is similar to the Account Card, but the report is filtered by investment and also shows how the quantity held and the book value change after each transaction.

Selection Dialog

Select the investment for which you want to generate the Security Card report. By default, the dialog displays the list of investments defined in the Items table.

If the selected investment is not found in the Items table, an error message is displayed. Make sure that the investment is correctly defined in the table.

When you reopen the dialog, the investment selected the last time is 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: No sign.
  • Sold: With minus '-' sign.
  • Neutral: With neutral number symbol: '±'.
• Unit Price (item Currency): purchase or sale (unit) price of the investment.
• Balance (item Currency): Balance amount in the item currency.
• Quantity Balance: Current quantity of securities.
• Book value per unit (item Currency): Current book value per unit of the investment.
• Debit (Base Currency): Debit amount in base currency.
• Credit (Base Currency): Credit amount in base currency.
• Balance (Base Currency): Balance amount in base currency.

Saving and Exporting the Report

The report can be exported and saved at any time. For more information, see Printouts/preview.

Error Messages

• Items table not found: The Items table is not present in the accounting file.
  • Add the Items table to your file.
• Asset: XXX not found: The selected Asset has not been found in the Items table.
  • Add the Asset in the Items table.
  • A valid Asset must have an ID and an Asset Account
• No Asset found in the Items table: The Items table does not contain any Asset.
  • Add Assets to the Items table.
  • A valid Asset must have an ID and an Asset Account.

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 investment with its current market value.
• Investment Accounting Transactions: Displays a detailed list of all transactions carried out for each investment.

Appraisal Report

The Appraisal Report helps 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 investment.

To obtain an up-to-date appraisal, enter the current market price for each investment in the Price Current column of the Items table.

• Type/Security: Name of the group or investment.
• ISIN: ISIN or other identification number of the investment.
• Currency: Currency in which the investment is denominated.
• Current quantity: Current quantity of the investment held.
• Book value per unit: Current book value per unit of the investment.
• Book value: Total book value of the investment.
• Market value per unit: Current market price per unit of the investment, as defined in the Price Current column of the Items table.
• Market value: Current market value of the investment.
• % of Port: Percentage of the total portfolio represented by the investment.
• Un.Gain or Loss: Unrealized gain or loss on the investment.
• % G/L: Ratio of the unrealized gain or loss to the market value.

Investment Accounting Transactions Report

The report summarises the accounting transactions recorded for each investment.

Saving and Exporting the Report

The report can be exported and saved at any time. For more information, see Printouts/preview.

Error Messages

• Items table not found: The Items table is not present in the accounting file.
  • Add the Items table to your file.
• No Asset found in the Items table: The Items table does not contain any Asset.
  • Add Assets to the Items table.
  • A valid Asset must have an ID and an Asset Account.