The tutorial file contains practical examples of investment transactions where all investments are managed in the accounting base currency.

The template includes:

• Investment Balance Sheet Accounts for recording investment values;
• an Items table with sample shares and bonds;
• income and cost accounts for realized and unrealized gains and losses;
• example transactions covering the main investment operations.

This template is suitable for learning and practicing the basic principles of Investment Accounting without the additional complexity of foreign currencies.

This predefined multi-currency template provides a ready-to-use example for working with Banana Investment Accounting and its Investment Accounting Extensions.

It is intended for HNWI (High Net Worth Individual ) or UHNWI (Ultra High Net Worth Individual).

The template includes:

• Investment Balance Sheet Accounts for investments in different currencies;
• an Items table with examples of shares and bonds;
• a Transactions table with the columns required to enter the Item, Quantity, and Unit Price;
• income and cost accounts for realized and unrealized gains and losses;
• accounts for realized and unrealized exchange rate gains and losses;
• example transactions covering the main investment operations;
• an Exchange Rates table for managing investments denominated in foreign currencies.

The Item Price is configured with a precision of 12 decimal places.

This template is intended for Investment Accounting where investments are held and transactions are recorded in multiple currencies.

When Investment Accounting is managed in a separate file, the Banana Investment Accounting file contains the detailed information for each individual investment, while the general accounting contains the accounting values required for financial reporting.

In the Banana Investment Accounting file, you record the detailed investment transactions, including purchases, sales, income, costs, realized gains and losses, and, when applicable, value and exchange rate adjustments. Each transaction can be linked to the corresponding Item, allowing Banana Accounting to maintain quantities, Book Values, prices, and other investment-specific information.

In the general accounting, you do not need to reproduce the detailed information for each individual investment. You can record the corresponding accounting transactions using aggregated amounts by Investment Balance Sheet Account or investment category.

There are two possible approaches:

• Record each operation in both files. Purchases, sales, income, costs, gains and losses, and applicable adjustments are recorded in the Banana Investment Accounting file and also in the general accounting.
• Update the general accounting periodically. Detailed transactions are recorded in the Banana Investment Accounting file, while the general accounting is updated periodically with the accounting values required to keep the investment accounts and financial statements aligned.

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

The investment balances in the general accounting should be periodically reconciled with the corresponding Investment Balance Sheet Accounts in the Banana Investment Accounting file.

Related Resources

For more information about setting up and managing investments, see the Investment Accounting documentation.

To automate key investment accounting operations, such as calculating sales data, updating Market Prices, creating adjustment transactions, and preparing investment reports, see the Investment Accounting Extension.