These templates allow you to manage securities and other investments directly within your financial accounting. Investment transactions, balances, income, and gains or losses are recorded in the same Banana Accounting file as your other financial activities.

Choose the template according to the currencies used for your investments:

• Double-Entry Accounting with Integrated Investment Accounting – Manage investments in the accounting base currency, with investment transactions recorded directly in double-entry accounting.
• Double-Entry Multi-Currency Accounting with Integrated Investment Accounting – Manage investments denominated in different currencies, including exchange rate differences, within the same multi-currency accounting file.

Both templates use CHF as the default accounting base currency.

Documentation

For more information about managing investments within your general accounting file, see the Investment Accounting documentation.

For instructions on setting up investment accounting and recording transactions, see How to Start.

These templates allow you to manage securities and other financial investments in a separate Banana Accounting file, independently of your general accounting.

The separate file acts as an Investment subledger, maintaining detailed information about individual investments, transactions, quantities, prices, Book Values, and Market Values. The corresponding accounting balances and financial results can be recorded in your general accounting, even when it is maintained using other software.

Choose the template according to the currencies used for your investments:

• Double-Entry Investment Accounting in a Separate File – Manage investments in the accounting base currency using a separate double-entry accounting file. (Template coming soon.)
• Multi-Currency Investment Accounting in a Separate File – Manage investments denominated in different currencies, including exchange rate differences, in a separate accounting file.

Both templates use CHF as the default accounting base currency.

For more information about how separate investment accounting works, including investment transactions and reconciliation with your general accounting, see the Separate Investment Accounting (Subledger) documentation.

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 foreign currencies, with current exchange rates.

Specifically, it:

• Updates investment book values to reflect current market prices and exchange rates.
• Records unrealized gains and losses in the corresponding Profit & Loss accounts.
• Generates the necessary double-entry transactions to adjust investment values.

Once the generated transactions are recorded, the Balance Sheet and Profit & Loss statement reflect the updated investment values and the corresponding unrealized gains and losses.

Adjustment transactions can be created at any time during the year to obtain an up-to-date Balance Sheet and Profit & Loss statement.

The command must be executed no later than the end of the accounting year, before preparing the year-end financial statements and opening the new accounting year. For more information see also Investment Accounting Opening and Closing the Year.

Update Market Prices and Exchange Rates

Update Investment 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.

Set 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.

Command: Create adjustment transactions 

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.

Adjustment 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.