Investment Accounting Software

An Investment Accounting system is specialized software that records, values, and reports investments such as shares, bonds, ETFs, and investment funds.

Unlike a traditional accounting system, it manages both the accounting value and the investment-specific information required to track securities over time, including quantities, prices, market values, exchange rates, and realized and unrealized gains and losses.

Typical functions include:

  • Recording purchases and sales of securities.
  • Calculating book value and cost basis.
  • Processing interest, dividends, and commissions.
  • Perfoming market and foreign currency valuations.
  • Calculating realized and unrealized gains and losses.
  • Preparing accounting and investment reports.

Professional investment accounting systems may also support multiple accounting frameworks, such as IFRS and GAAP, as well as tax, reconciliation, and compliance reporting.

Elements

Investment accounting software consists of sophisticated solutions that are usually based on general accounting software or ERP (Enterprise Resource Planning) systems. These solutions typically include several components.

These solutions include several components.

  • General ledger
    • Double-entry accounting engine (Accounting Book of Record, ABOR) – Records all investment-related debits/credits.
    • Multi-basis accounting – Supports IFRS, US GAAP, statutory, and tax accounting simultaneously.
    • Chart of accounts & financial statements – Provides Balance Sheet and Profit & Loss outputs.
    • Trade and transaction capture – Records purchases, sales, income events, fees, and settlements.
    • Cash and liquidity management – Tracks cash movements, forecasts, and balances.
  • Investment accounting
    • Investment Book of Record (IBOR) – Tracks real-time quantities, cash, and exposures.
    • Security master and reference data – Provides centralized instrument definitions and reference data, such as ISINs, coupons, and ratings.
    • Market data & pricing engine – Imports or calculates prices, FX rates, yields, and curves.
    • Valuation and revaluation logic – Calculates fair value, amortized cost, and unrealized gains and losses.
    • Performance measurement – Calculates returns and contributions and compares performance against benchmarks (optional).
    • Risk and exposure analytics – Provides duration, FX exposure, sensitivity, and VaR metrics (optional).
    • Regulatory & compliance reporting – Supports filings (e.g., Solvency II, NAIC, UCITS).
    • Reconciliation tools – Matches cash, positions, and transactions with custodians/brokers.
    • Client & portfolio reporting – Generates statements, holdings reports, and dashboards.

Accounting and Investment Book of Record 

  • Accounting Book of Record (ABOR)
    An ABOR is a double-entry accounting journal that records financial transactions.
  • Investment Book of Record (IBOR)
    • An IBOR is similar to an inventory system and records the quantities and prices of securities bought and sold.
    • It may be maintained in a separate database or as a subledger of the ABOR system.

Investment data from the IBOR is typically integrated into the ABOR through a process that creates double-entry accounting transactions at specified intervals, usually daily.

Single Book of Record

Instead of maintaining a separate IBOR, Banana Accounting uses a single ABOR journal that also integrates the information required for investment accounting.

  • Double-entry transactions include the information required for investment accounting, such as the Investment ID, quantity, price, and other details.

  • The Asset Account provides the connection between investment accounting and financial accounting. In the Accounts table, you define the Asset Accounts used to record the accounting value of the investments.

    • In the Items table, each investment is linked through the Asset Account column to one of the Asset Accounts defined in the Accounts table.

    • When entering transactions that change the quantity or value of an investment, you must use the Asset Account defined for that investment in the Items table. 

    • The opening balance of each Asset Account must match the sum of the opening values of all investments linked to that Asset Account. 

    • The current balance of each Asset Account must match the sum of the current values of all investments linked to that Asset Account.

Simplicity Through Innovation

Simplicity Through Innovation

Integrating investment management into a financial accounting system while keeping it simple to use is a significant technical challenge. Many investment accounting solutions rely on separate portfolio management systems or complex subledgers, making implementation and daily operation more complicated.

Banana Accounting follows a different approach by extending its standard accounting system with features specifically designed for investment accounting.

One of these is the integrated Items system, which allows investment information to be recorded directly in accounting transactions. Each transaction can include the Investment ID, quantity, and unit price, while the program automatically calculates the corresponding accounting amount. This makes it possible to manage investment movements without maintaining a separate investment journal.

Another distinctive feature is the support for neutral quantities (±). A neutral quantity is entered by typing ±123, which Banana Accounting automatically converts to ±123. Unlike positive or negative quantities, a neutral quantity does not change the number of securities held. Instead, it is used to calculate the accounting amount for transactions that modify the book value of an investment without affecting its quantity, such as market value adjustments, unrealized gains and losses, or other valuation entries.

These innovations allow Banana Accounting to manage complex investment accounting scenarios using the same transaction model employed for standard accounting, reducing complexity while maintaining complete integration between financial accounting and investment management.

Keeping Track of the Book Value

One of the most challenging aspects of investment accounting is maintaining the book value of each investment throughout its entire life cycle.

Unlike portfolio management systems, which primarily focus on market value, portfolio performance, and trading activities, investment accounting must determine and maintain the accounting value of each investment. The book value represents the accounting value of the investment and is used to determine realized and unrealized gains and losses. It may also be relevant for tax purposes, depending on the applicable tax rules.

To maintain the correct book value, every investment transaction must be recorded together with all the information that affects its accounting value. This includes:

  • purchases and sales;
  • quantities and unit prices;
  • commissions and transaction costs;
  • interest and dividends;
  • realized gains and losses;
  • unrealized gains and losses resulting from market value adjustments;
  • realized and unrealized exchange rate differences.

Traditional accounting software generally records only monetary amounts and does not manage the quantities and prices required for investment accounting. As a result, accountants often maintain separate spreadsheets to calculate book values, realized gains and losses, and year-end valuations, increasing both workload and the risk of errors.

Banana Investment Accounting integrates investment management directly into the accounting system. By recording quantities, prices, expenses, commissions, and other investment data together with the accounting entries, the information required to maintain the book value of each investment and calculate realized and unrealized gains and losses, including those arising from exchange rate fluctuations, remains integrated within the accounting system.

Using the Moving Average Cost with Market Adjustments (MAC-MA) method, Banana Accounting produces both financial accounting reports, such as the Balance Sheet and Profit & Loss Statement, and investment reports for monitoring securities, eliminating the need for separate spreadsheets and manual reconciliations.

Banana Investment Accounting: Professional Wealth Management for the Individual

Banana Investment Accounting integrates investment management directly into a double-entry accounting system. It allows you to manage securities, maintain their book values, and produce both investment reports and financial statements from a single accounting file.

Unlike traditional portfolio management software, Banana Accounting maintains both investment positions and their accounting book values within a single integrated system. Every investment transaction is reflected in both the investment data and the financial accounting, keeping investment information and the Balance Sheet and Profit & Loss Statement directly connected.

Key Benefits for the Professional Investor

  • Unified Financial View: Manage your assets, liabilities, revenues, and expenses within a single, integrated accounting environment. This provides a comprehensive view of your financial position and reduces the need to maintain information across separate systems.
  • Professional-Grade Accounting: Leverage a professional accounting solution used by companies, pension funds, and family offices. This ensures your records are structured, controlled, and audit-ready, providing a high level of financial transparency.
  • Integrated Reporting: Investment transactions update both the investment data and the financial accounting. This allows you to generate Balance Sheet, Profit & Loss, and investment reports from the same accounting data.
  • Complex Investment Management: Manage different types of investments, including shares, bonds, funds, ETFs, and cryptocurrencies, with support for multiple currencies.
  • Gain, Loss, and Valuation Calculations: The Investment Accounting Extension can calculate realized gains and losses when investments are sold. Investment values can also be adjusted to current market prices to calculate and record unrealized gains and losses.
  • Data Privacy and Control: Banana Accounting runs locally on your computer, and you decide where your accounting files are stored, whether locally or using a cloud storage service of your choice.

Ease of Use & Accessibility

  • Excel-Like Interface: Banana Accounting uses a table-based interface similar to Excel, where accounting and investment data is entered and displayed in tables. This makes it easy to view, search, select, and modify data.
  • Simple Installation: Banana Accounting can be installed directly on Windows, macOS, and Linux, without requiring a complex server setup.
  • Prerequisite Knowledge: A working knowledge of double-entry accounting is required to use the solution effectively.

How It Works: The Double-Entry Advantage

Banana Investment Accounting combines financial accounting, based on the double-entry method, with investment accounting, which uses information similar to inventory management, such as quantities and prices.

  • Accounts Table: This table contains the Chart of Accounts and shows the current balance of each account. Transactions entered in the Transactions table update the corresponding account balances according to the double-entry accounting method, providing the data used for the Balance Sheet and Profit & Loss Statement.
  • Items Table: In the Items table, you define your investments, such as shares, bonds, funds, and ETFs. Each investment is linked to an Asset Account defined in the Accounts table.
  • Transactions Table: Investment transactions, such as purchases, sales, dividends, and fees, are recorded here. Along with the standard double-entry information, such as debit and credit accounts and amounts, you also specify the Investment ID, quantity, and price.
  • Automatic Updates: The software automatically updates the quantities in the Items table and the balances in the Accounts table based on the transactions entered. The updated accounting data is reflected in the Balance Sheet and Profit & Loss Statement.
  • Investment Reporting: Use the Investment Accounting Extension to generate detailed reports on investments, including quantities, values, gains and losses, and other investment-related information.

Get Started

To get started with Banana Investment Accounting, download Banana Accounting and explore the available documentation, templates, and examples.

Detailed guides and tutorials are available in the Banana Accounting documentation to help you set up Investment Accounting and manage different investment accounting scenarios.

 

How Finance Professors Can Use Banana Investment Accounting to Enhance Investment Education

Teaching investment and accounting concepts can be challenging when students only see theory or isolated examples. Banana Investment Accounting provides a practical tool for applying these concepts in an accounting environment. By combining traditional double-entry accounting with investment management, the software allows professors to demonstrate how investment transactions, valuations, and market changes are reflected in financial accounting and financial statements.

Whether used in financial accounting, investment accounting, portfolio management, or auditing courses, Banana helps students develop practical skills and understand how accounting principles are applied to real-world investment scenarios.

Students learn not only how investment transactions are recorded, but also why they affect the Balance Sheet, the Profit & Loss Statement, and the book value of each investment. By applying accounting principles and workflows used in professional investment accounting, students can connect theoretical concepts with practical application.

Free for students:

Students can use the Banana Accounting Free plan and manage up to 70 transactions at no cost.

Teaching Benefits

Banana Accounting gives professors a practical tool that supports both traditional accounting education and investment-related courses.

Strengthens Core Accounting Skills

Students learn double-entry accounting through realistic investment transactions and practical examples. Each transaction, whether a purchase, sale, dividend, fee, or adjustment, shows its impact on the Balance Sheet and Profit & Loss Statement. This reinforces the fundamental accounting principles taught in introductory and intermediate accounting courses.

Helps Students Understand Investment Concepts

Banana integrates quantities, prices, book values, and market values directly into the accounting system..
Students can see how:

  • book values and market values are determined
  • realized and unrealized gains and losses are calculated and recorded
  • exchange rate differences affect financial results

This helps students connect investment accounting concepts with their practical accounting treatment.

Connects Theory With Real-World Practice

Students work with realistic investment scenarios, including:

  • Recording purchases and sales
  • Accounting for bond coupon accruals
  • Performing multi-currency valuations
  • Preparing year-end adjustments and reconciliations.

These exercises help students apply accounting concepts to situations they may encounter in professional accounting and finance roles.

Helps Reduce Teaching Workload

Ready-made templates, automated calculations, and reports such as the Appraisal, Security Card, and Reconciliation reports reduce the need to create complex spreadsheets and manual examples from scratch.

Suitable for Multiple Courses

Banana can be used across different accounting and finance courses:

  • Financial Accounting – Double-entry accounting, financial reporting, and adjustments
  • Investment Accounting – Book values, valuations, and realized and unrealized gains and losses
  • Investment and Portfolio Management – Investment transactions, market values, and foreign currency effects
  • Auditing – Transaction tracing, reconciliation, and accounting controls.

A single tool can therefore support different teaching and learning objectives.

What Professors Can Teach Using Banana Investment Accounting

This section explains concrete learning outcomes:

Securities Valuation and Book Value Tracking

Students learn:

  • the difference between book value and market value
  • the moving average cost method
  • how unrealized gains and losses are calculated and recorded
  • how to prepare year-end valuation adjustments using the Investment Accounting Extension.

Investment Transactions: From Theory to Double-Entry

Students practice recording:

  • Purchases
  • Sales
  • Commissions and fees
  • Accrued interest (for bonds)
  • Dividends and coupons
  • Realized gains and losses and exchange rate differences.

Multi-Currency Investment Accounting

Students learn how exchange rate changes affect:

  • book values
  • realized exchange rate gains and losses
  • year-end revaluations using the Exchange Rate Table
  • realized and unrealized exchange rate gains and losses.

Investment Reporting and Analysis

Using investment accounting reports, students can work with:

  • Appraisal report
  • Security Card Report
  • Reconciliation and Check Balances.

Students learn to analyze investment positions, valuations, gains and losses, and their relationship with the financial accounting data.

By combining double-entry accounting with integrated investment management, Banana Accounting provides a practical learning environment for teaching investment accounting, securities valuation, portfolio management concepts, financial reporting, and the accounting treatment of investment transactions.