Neste artigo
Banana Accounting offers a professional, simple and innovative software solution for managing your investments with precision and efficiency. Its integrated securities accounting feature allows you to handle bonds, shares, funds, and other financial instruments, even in multiple currencies, directly within your accounting file.
There is no need to use complex spreadsheets. everything is managed in one place, with the same accuracy, flexibility, and reliability expected from professional accounting software.
Banana Accounting, complements online portfolio solution focused on trading and let you maintain a complete, transparent, and professional record of your investment activities, ensuring clarity and full control over every financial detail, in any currency.
Ideal for
Banana Accounting offers a professional, powerful, and accessible investment accounting solution, developed in collaboration with financial specialists to meet the real needs of investors and accountants anywhere in the world. Already trusted by organizations managing assets from hundreds of thousands to hundreds of millions, it provides the accuracy, transparency, and flexibility required for professional portfolio management like:
- Family offices managing diversified investment portfolios.
- Independent accountants and bookkeepers offering investment accounting services.
- Non-profit organizations with investment or endowment funds.
- Small businesses and self-employed professionals managing their own investments.
- Pension funds overseeing large multi-asset portfolios.
Key Features
Investment accounting is traditionally available only through specialized and expensive solutions.
Banana Accounting, thanks to its highly innovative features, such as the unique neutral numbers system not offered by any other accounting software, stands out as one of the few international accounting solutions accessible to everyone. It provides a fully integrated investment accounting system that combines professional-grade functionality with the simplicity and flexibility that make it easy to use for any type of investor or organization anywhere in the world.
- Complete investment overview.
Keep a detailed list of all your investments — bonds, shares, ETFs, funds, and more — directly linked to specific asset accounts. - Multi-currency support.
Manage international portfolios with built-in currency conversion and automatic tracking of both unrealized and realized exchange rate gains and losses. - Detailed transaction recording.
Record quantities, prices, and exchange rates directly within standard accounting entries — no extra modules or steps required. - Accurate valuation tracking.
Maintain a precise record of the accounting value of your investments at all times. - Expense and income management.
Monitor commissions, management fees, dividends, and interest income with full transparency. - Automatic profit and loss calculation.
Instantly determine gains or losses when selling any investment. - Comprehensive reporting.
Generate detailed accounting and investment performance reports for complete financial insight.
Introduction to the Investment accounting
Multi-currency investment accounting is one of the most complex areas in accounting.
It combines two different accounting approaches: financial accounting, based on the double-entry method, and securities accounting, which resembles inventory management, involving quantities and purchase prices.
There are many aspects to consider — from valuation methods to profit and loss recognition — which is why we have prepared an Introduction to investment accounting.
This guide outlines the key challenges, including how to determine the book value of investments and how to calculate realized and unrealized gains and losses, both on securities and on exchange rate differences.
Structure of the Investment Accounting File
Banana Accounting is a highly modular financial accounting system that allows you to create files with features activated only when needed.
The multi-currency investment accounting setup is among the most advanced, as it combines double-entry financial accounting with inventory-style management for tracking securities, quantities, and valuations. A typical Investment Accounting template or file includes the following elements:
- File properties
- Company names, Currency and Accounting Period.
- Settings Specific to the Investment accounting .
- Accounts Table
- Contains the chart of accounts and defines how data is grouped for the Balance Sheet and Income Statement.
- Enter the Opening amounts.
- Items Table
- Lists and codes all investments, such as bonds, shares, and funds.
- The Asset Investment column links each security to its corresponding Balance Sheet account — a key element of the entire solution.
- Exchange Rate Table
Defines the currency codes and stores both opening and current exchange rates for accurate multi-currency management. - Transactions Table
- Records all investment transactions.
- Enter the double entry account, amounts and exchange rate for the financial accounting.
- Enter the Item code, quantity and price specific for the Investment accounting.
- Double-Entry Accounting Reports
Provides access to all standard accounting reports such as Balance Sheet, Income Statement, Account Cards, and more. - Investment Accounting Extensions
You need to install the Add specific functionalities for investment management, including profit and loss calculations, valuation reporting, and other analytical tools tailored to securities accounting.
Account Table
Within the Accounts Table you define all the accounts including the one necessary for the Investment accounting: Balance Sheet accounts for investments, Profit and Loss Accounts.
In the Account table you also enter the opening amounts and you see the current balance.
Items Table with all Investments
In the Items Table you enter the information for each investment.
Through the Asset Account each security is linked to the Investment account you have specified in the Table Accounts.
You also enter the opening quantity and price.
Transactions Table with Investments Details
The Transactions Table is the place where you enter Double entry accounting transactions.
For transactions regarding Investments you specify the Investment id, quantity and price.
You can easily manage all the information in one place (Purchase of investments, Sale of investments, Realized and unrealized gains or losses on investments, Realized and unrealized exchange rate gains or losses, Commissions, Expenses, etc.)
Balance Sheets & Income Statements
With fully customizable accounting plan and presentation, you can manage any kind of business, financial corporations, foundations, non-profit organization or private fortune. Get instantly Balance sheet, Income statements and all the other double entry reports ready for auditing.
Investments and Portfolio Reporting
The software makes available multiple reports.
Getting Started
- You can see how it works by using one of our templates.
- Adapt your current accounting in just a few steps.
- Use the extensions to calculate the profit or loss on the sale of securities and obtain various reports.
Documentation
Limitations
The current version has some limitations:
- There is no automatic update of market prices.
Current prices must be entered manually or imported from other tools. - The current account value of each item is available as a report, but it is not displayed in the Item table.
Improvements version 10.2.1
Enhancements in the Items Table
New specific columns have been added to the Items table to facilitate and strengthen the management of investments in Banana:
- AssetAccount: Balance sheet account for managing investments.
- AssetType: Identifies the type of investment.
New Validations
- In the Transactions table, for operations involving investments, the program now verifies that the correct account is used for a given security (Item).
- Using the command Actions → Check Accounting, it is now possible to verify that the opening values of investments in the Items table correspond to the balance of the assigned account.
Automatic Unit Price Calculation
In the Transactions table, it is now possible to automatically calculate the unit price based on the entered amount and quantity.
Extension Update
Together with this new program version, the Investment accounting extension will soon be updated and will be compatible only with version 10.2.1 or later of the program.
The new extension version includes:
- Adaptation to work with the new columns.
- Update to use the new neutral numbers.
- Fixes for several minor report-level bugs.
The new version of the extension will require users who are already managing investment accounting to follow the simple steps below to adapt their existing file. All the following changes must be made in the Items table:
- Copy all accounts from the “Account” column to the “Asset Account” column by simply copying and pasting the content of the column.
For simplicity, the “Account” column can be cleared if it is not used for other purposes, as it is no longer relevant for investment management. - Enter the asset type in the “Asset Type” column:
- 1 = Shares — previously, in the Units column, shares were identified using the symbol “S”.
- 2 = Bonds — previously, in the Units column, bonds were identified using the symbol “B”.
- The Units column can also be cleared (if not used for other purposes), since it is no longer used for investment management.
Is there more you need?
The solution is already in use by several customers, but we still consider it in development, as we continue to improve it based on user feedback and requests. Please feel free to reach out if you have any specific questions or requests. Given the time invested in development and the high value it provides to select customers, we may offer it through a specific subscription plan in the future.