Banana Investment Accounting

Banana Investment Accounting combines professional double-entry accounting with securities and investment accounting in a single, integrated solution. Manage stocks, bonds, funds, and other financial instruments in multiple currencies, either as a complete accounting system or as a separate investment subledger alongside your existing accounting software.

It makes advanced investment accounting capabilities, previously available mainly through expensive specialized software, accessible to businesses, accounting professionals, and private investors.

For businesses, accounting firms, and small family offices, this means new opportunities: manage investment accounting more efficiently, reduce time-consuming Excel-based processes, and produce accurate, high-quality financial reports. Accounting firms can also expand the services they offer to their clients.

If you're considering introducing investment accounting software but aren't yet familiar with the available solutions, Banana Investment Accounting is an excellent place to start. Its affordability and ease of use make it easy to learn investment accounting, gain practical experience, better understand your requirements, and make a more informed decision about whether you need a more specialized solution in the future.

Video Overview

Before reading the documentation we invite you to watch this video.  

• ▶ Banana Integrated Investment Accounting Overview (Short Video 3'15")
  Information dense overview of the investment accounting features, intended for viewers with a solid background in accounting and finance. 

From Investment Monitoring to Accounting

Technology has transformed the way financial investments are managed and monitored. Today, banks and asset managers provide sophisticated digital platforms that allow investors to access portfolio holdings, market prices, valuations, performance reports, and transaction histories, often in real time. Many also provide tax reporting and compliance services.

However, investment monitoring is not the same as investment accounting. Portfolio information does not always provide a complete accounting record of transactions, including management fees, transaction costs, foreign exchange expenses, and realized and unrealized gains and losses.

Banana Investment Accounting complements these platforms with an independent accounting solution, bringing together investments held with multiple banks and asset managers into a single, structured, and verifiable accounting system.

Who Uses Banana Investment Accounting

Banana Investment Accounting is used by accountants and financial professionals worldwide, both as a standalone accounting system and alongside existing accounting software.

Its users include:

• Companies and holding companies.
  Managing securities, financial investments, and investment income alongside regular business accounting.
• Pension funds.
  A large pension fund with assets exceeding CHF 400 million uses Banana to maintain detailed investment accounting records in multiple currencies. Its financial statements are audited annually by specialized auditors.
• Family offices.
  Integrating financial investments with other assets, liabilities, income, and expenses to provide a comprehensive view of personal and family wealth.
• Independent accountants and accounting firms.
  Providing investment accounting, reconciliation, and financial reporting services to clients.
• High-Net-Worth Individuals (HNWIs) and Ultra-High-Net-Worth Individuals (UHNWIs).
  Monitoring personal and family wealth, including investments, assets, liabilities, income, and changes in net worth over time.
• Foundations and non-profit organizations.
  Accounting for investment portfolios, endowments, and related financial activities.

The Benefits of Integrated Investment Accounting

Managing investments through separate spreadsheets or disconnected systems can make reconciliation and financial reporting complex, particularly when assets are held with multiple banks or custodians.

Banana Investment Accounting integrates securities management directly into double-entry accounting, keeping investment transactions, quantities, valuations, and accounting entries connected within a single system.

Key benefits and capabilities include:

• Centralized investment records.
  The Items table identifies shares, bonds, funds, and other investments, including their currency, Asset Account, opening quantities, and prices.
• Integrated transaction recording.
  The Transactions table records purchases, sales, dividends, interest, charges, and other operations, together with the corresponding accounting entries, quantities, prices, and exchange rates.
• Flexible multi-currency investment management.
  Manage investments denominated in different currencies using a single Asset Account in the accounting base currency, simplifying the Chart of Accounts and reducing the need for separate accounts for each currency.
• Automated gain and loss calculations.
  When investments are sold, the Investment Accounting extension can calculate realized gains or losses, including applicable exchange rate differences, and generate the related accounting entries.
• Market valuations.
  Market prices can be updated to calculate current investment values and unrealized gains or losses. Where appropriate, the extension can generate valuation adjustment entries.
• Up-to-date financial statements.
  Investment transactions are reflected in the Balance Sheet and Profit & Loss statement, maintaining consistency between investment records and financial accounting.
• Reliable reporting and reconciliation.
  Detailed investment and accounting information supports transaction verification, customized financial reports, and tax-related reporting.
• Investment cost and management fee monitoring.
  Track management fees, custody charges, transaction costs, and foreign exchange expenses to verify charges, compare costs across banks and asset managers, and assess their impact on investment returns.
• Control over your data.
  Banana Accounting runs locally on your computer, allowing you to choose where your accounting files are stored.

Investment Accounting Integrated with Financial Accounting

By integrating investment management directly into double-entry accounting, every investment transaction becomes part of your financial accounting. You can keep track of investments, Book Values, realized and unrealized gains or losses, and exchange rate differences, while maintaining an up-to-date Balance Sheet and Profit & Loss statement.

Each investment is linked to its corresponding Balance Sheet account, while quantities, prices, and other investment-specific information are managed alongside the accounting data. Purchases, sales, income, costs, and valuation adjustments are recorded within the same system, keeping the investment data and the related accounting entries connected.

This integrated approach makes it easier to reconcile investment positions with the corresponding accounting balances and reduces the need for separate spreadsheets or investment records.

Investment Accounting as a Separate Subledger

Banana Investment Accounting can also be maintained in a separate, simplified accounting file containing only the accounts and transactions required for securities accounting. This file serves as an investment subledger alongside the main financial accounting system.

It also provides a more structured and reliable alternative to Excel spreadsheets, which can become complex, difficult to maintain, and prone to errors when managing investment transactions.

This approach is particularly useful when:

• The main financial accounting is managed with another software solution.
• Detailed investment records need to be maintained separately from the general ledger.
• Only summarized accounting information needs to be transferred to the main accounting system, for example at year-end.

For more information, see Separate Investment Accounting (Subledger).

Investment Accounting 

Multi-currency investment accounting is one of the most complex areas in accounting.
It combines financial accounting, based on the double-entry method, with the need to track individual investments in a way that resembles inventory management, including quantities, purchase prices, book values, and market values.

• Introduction to Investment and Portfolio Accounting
  Professional accountants working in finance are generally familiar with investment accounting and its specific requirements. For those who are less familiar with this specialized area, investment accounting can be challenging. Therefore, we have prepared a theoretical guide that explains the key concepts and challenges, including how to determine the book value of investments and how to calculate realized and unrealized gains and losses, including those arising from exchange rate differences.
• How to start 
  A practical guide that explains the logic and workflow of Banana Investment Accounting. It covers the main steps:
  • Set up the accounting file and the information required for your investments.
  • Record daily investment transactions in chronological order and follow the appropriate workflow to ensure that book values are calculated correctly.
  • At the end of the year, update Market Prices and exchange rates and, when required by the applicable accounting treatment, record the corresponding valuation and exchange rate adjustments.
• Banana Investment Accounting can also be used by finance and accounting professors to improve investment accounting education.

How Investment Accounting Works in Banana

Banana Accounting combines a familiar, Excel-like interface with the structure and controls of a professional accounting system. Accounting and investment data are organized in tables, making it easy to view, enter, search, and update information.

If you are already familiar with investment accounting, this overview will help you quickly understand how Banana Accounting works and evaluate whether it meets your needs. Links to detailed documentation are provided throughout.

A typical Investment Accounting file includes the following tables, settings, and reporting tools:

• File properties
  • Company names, Currency and Accounting Period.
  • Settings specific to Investment accounting.
• Accounts Table
  • It contains the chart of accounts and defines how data is grouped for the Balance Sheet and Income Statement.
  • This is where you enter the Opening amounts.
• Items Table
  • It lists and identifies all investments, such as bonds, shares, and funds.
  • The Asset Account column links each Item to its corresponding Investment Balance Sheet Account, a key element of the entire solution.
• Exchange Rate Table
  It defines the currency codes and stores both opening and current exchange rates for accurate multi-currency management.
• Transactions Table
  • It records all investment transactions.
  • This is where you enter the double-entry account, amounts, and exchange rate for financial accounting.
  • This is where you enter the Item code, quantity, and price required for investment accounting.
• Double-Entry Accounting Reports
  The software provides access to all standard accounting reports, such as the Balance Sheet, Income Statement, Account Cards, and more.
• Investment Accounting Extensions
  You need to install the Investment Accounting Extension, which provides specific functionalities for investment management, including profit and loss calculations, valuation reporting, and other analytical tools tailored to securities accounting.

Accounts Table

Within the Accounts table you define all the accounts including the ones necessary for the Investment accounting: Balance Sheet accounts for investments, Profit and Loss Accounts.

• The accounting chart is fully customizable based on your specific needs.
• In the Account table you also enter the opening amounts and you see the current balance. 

Items Table with Investments

In the Items table, you enter the information for each investment. 
Using the Asset Account, each investment is linked to the corresponding investment account specified in the Accounts table.
You also enter the opening quantity and price. 

Transactions Table with Investment Details 

The Transactions table is the core of the accounting system, where you enter double-entry accounting transactions. 

• For investment transactions, you specify the investment ID, quantity, and price.
• You can easily manage all the information in one place, including purchases and sales of investments, realized and unrealized gains or losses on investments, realized and unrealized exchange rate gains or losses, commissions, expenses, and more.
• You can import transactions from bank statements and create rules that automatically complete them.

Balance Sheets & Income Statements

With a predefined, fully customizable chart of accounts and presentation, you can manage the accounting of any type of business, financial corporation, foundation, non-profit organization, or private fortune.

Instantly generate Balance Sheets, Income Statements, and all other double-entry accounting reports ready for auditing.

Investments and Portfolio Reporting 

The software provides multiple investment and portfolio reports. 

Documentation

• Templates
• Items Table
• Account table
• Adapt accounting
• Transactions
• Investment Accounting Extension
• Separate Investment Accounting (Subledger)

Current Limitations

The current version has some limitations:

• Market prices are not automatically retrieved from financial data providers. 
  Current market prices can be entered manually or imported using the Investment Accounting Extension.
• The current book value of each investment is not displayed directly in the Items table, as users might naturally expect. 
  Calculating these values involves several factors, so they are currently available only in the reports.
• Quantities and prices must be entered manually when recording purchases and sales in the Transactions table. 
  There is currently no dedicated import functionality for bank transaction data that includes securities quantities and prices.

Contrary to our expectations, we have received relatively few requests to automate transaction imports and market price updates. We believe this may be because most of our users manage portfolios with a relatively limited number of securities transactions. As a result, importing transaction data and manually completing the missing details generally does not require much time. Users handling large transaction volumes may, however, consider developing custom import extensions to automate the process.

Investment Accounting and Tax Reporting

Banana Investment Accounting focuses on financial accounting and does not provide country-specific reports or forms for investment tax compliance. However, its detailed accounting records, including investment income, realized gains and losses, and transaction costs, provide a reliable basis for preparing tax-related reports and supporting tax filings.

Specific tax requirements and reporting obligations should be handled using the appropriate tools or with the assistance of tax professionals.

Easy to Learn, with Support When Needed

Although investment accounting may seem complex, Banana Accounting is designed to be easy to learn and use. Its familiar spreadsheet-like interface allows users to enter, review, and modify accounting data at any time, much like working in Excel.

Specific training is generally not required. Most users quickly become comfortable with the software and work independently, without needing assistance.

For those who need guidance, Banana Accounting's support team is available to help.

Dedicated Newsletter

Subscribe to our newsletter to stay updated on new features and tips for Investment Accounting in Banana. Interested? Just write to us at info@banana.ch and mention that you’d like to subscribe to the Investment Accounting newsletter. 

Is there more you need?

The solution is already being used by several customers, but we still consider it an evolving product, as we continue to refine and enhance it based on user feedback and requests.

Please feel free to contact us if you have any questions, suggestions, or specific requirements.

Given the significant development effort involved and the value this solution offers to users with specialized investment accounting needs, we may introduce a dedicated subscription plan in the future.