Theoretical Introduction to Investment and Portfolio Accounting

Multi-currency investment accounting combines financial accounting, based on double-entry bookkeeping, with investment accounting, which uses inventory-like information such as quantities, unit prices, and investment values.

This combination makes it possible to manage both the accounting value of investments and the information required to track individual securities, including their quantities, prices, and valuations in different currencies.

Investment Accounting requires an understanding of both financial accounting and the specific principles used to track and value investments. This introduction provides a practical overview of these concepts and explains how they are applied in Banana Investment Accounting.

It covers key topics such as quantities and unit prices, book value and market value, investment valuation, realized and unrealized gains or losses, and the effects of exchange rate changes on investments denominated in foreign currencies.

This introduction provides a high-level overview of Investment Accounting and does not address specific accounting, regulatory, or tax requirements that may apply to individual circumstances or jurisdictions. Users should verify the appropriate accounting and tax treatment for their circumstances with their auditors or professional advisors.

Banana Investment Accounting can also be used by finance educators as a practical tool for teaching Investment Accounting.

Terminology

In the industry, several equivalent terms are used, which may vary depending on the context, such as Investment Accounting, Portfolio Accounting, and Securities Accounting. In this text, the term Investment Accounting will be used as a synonym for Securities Accounting. Portfolio Accounting, on the other hand, more specifically refers to information and trading systems for securities.

In Banana Accounting, investment accounting uses the inventory functionalities, specifically the Items table and the Item ID as the code for the security. Each Item therefore represents a security, although Items can also be used simply for other purposes, such as creating invoices.
When an Item is linked to an Asset Account, the program treats it as an asset with an accounting value. The term “asset” is therefore applicable to securities management, but it can also refer to other types of assets or, hypothetically, even to other balance sheet elements, including liabilities.
The use of different terminology can naturally be confusing, but this situation arises from the program’s flexibility, which allows the same features to be used in multiple ways. The investment accounting setup is therefore an additional extension of these core functionalities.

The Purpose of Investment Accounting

Online investment platforms provided by your bank or broker are designed to help you follow the market, compare assets, and make informed buy or sell decisions. However, they do not give you full control over your investments from an accounting perspective.

The purpose of Investment Accounting is to provide a comprehensive financial overview of your investments. It allows you to maintain an inventory of all your securities, track quantities and historical changes, and seamlessly integrate investment values, purchases, sales, and market fluctuations into your accounting records. Additionally, it ensures that revenues such as interest and dividends and costs like expenses and commissions are accurately reflected within your Balance Sheet and Income & Expense accounting.

Beyond financial tracking, Investment Accounting helps you optimize the fiscal impact of your investments, ensuring that tax-related aspects such as capital gains, withholding taxes, and deductions are properly accounted for. It also supports compliance and auditing, providing structured and transparent records that facilitate regulatory reporting and financial reviews.

Investment Accounting Goals and Future Developments

Over the years, we have refined the Investment Accounting solution in close collaboration with financial specialists, particularly those in the Swiss financial sector.
Our objective has always been aligned with their needs: to deliver a straightforward, reliable, and professional way to manage investments directly within financial accounting software. Traditionally, such functionality has only been available in specialized and costly financial systems.

With Banana Accounting, we have focused on creating a solution that is simple, intuitive, and efficient, yet powerful enough to give you full control over your investments while streamlining compliance and reporting.

We have also developed and introduced highly innovative features, such as the unique neutral numbers (±123.00) — exclusive to Banana Accounting. This groundbreaking concept makes it incredibly easy to record transactions that affect the value of investments without changing their quantity, ensuring both precision and simplicity in day-to-day accounting operations.

We highly value your feedback and suggestions, as they help us continuously improve the solution, its documentation, and this introduction.
Please use the form at the bottom of this page to get in touch with us — we’ll be glad to hear your thoughts and ideas. 

Learning Tool for Finance Students

In line with our company’s mission, we aim to provide a solution that enhances financial literacy and supports practical learning.
By integrating investment management directly into Banana Accounting, students of Finance, Accounting, and Auditing can explore how an investment accounting solution works, gain hands-on experience, and avoid time-consuming manual exercises.

Using a professional accounting tool, they can easily experiment with real-world and complex scenarios, from managing investments to recording transactions, and immediately see how each operation affects the Balance Sheet and the Income Statement.

Differentiating Investments from Bank Deposits & Cryptocurrency Holdings

From an accounting perspective, it is crucial to distinguish between bank deposits or cryptocurrency holdings and investments (securities) based on how they are recorded and valued.

Bank Deposits & Cryptocurrency Holdings – Tracked with an Accounting Balance

• Bank deposits and cryptocurrency holdings are monetary assets recorded as part of a company’s or individual’s cash or financial reserves.
• These holdings are easily tracked using a standard accounting balance, as they have a single value expressed in the account’s currency.
• If held in foreign currency or cryptocurrency, their value is adjusted using the exchange rate at the reporting date.
• Example: A bank account with $10,000 is recorded as a cash asset, converted into the base currency if needed (e.g., €9,090 at an exchange rate of 1.10).

Investments (Securities) – Require an Inventory-Like System

• Investments such as stocks, bonds, and mutual funds share similarities with inventory management, as they involve:
  • A quantity (e.g., number of shares or bond nominal value).
  • A unit price (e.g., market price per share or bond percentage value).
  • An exchange rate, if denominated in a foreign currency.
• Unlike bank holdings, investments cannot be tracked using a simple accounting balance because their value changes not just due to exchange rates but also due to market price fluctuations and transactions (buying, selling, reinvesting).
• Proper Investment Accounting ensures that each transaction and value change is accurately recorded, much like how an inventory system tracks stock levels and price variations over time.

Why Investment Accounting Matters

Because investments behave more like an inventory of financial instruments, traditional accounting methods used for bank balances are not sufficient to track them accurately. Instead, a dedicated investment accounting system is required to properly manage:

• Purchases & Sales – Tracking quantities and cost basis.
• Market Value Changes – Adjusting for price fluctuations.
• Revenues & Expenses – Including dividends, interest, and commissions.
• Exchange Rate Effects – Converting values in foreign currencies.

By structuring investment records similarly to inventory management, Investment Accounting ensures full control and accurate reporting of financial assets.

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 Investment Accounting Extensions to add specific functionalities for investment management, including profit and loss calculations, valuation reporting, and other analytical tools tailored to securities accounting.

The Investment Accounting Elements

To understand investment accounting, it is important to understand the following key elements:

• Accounting period.
• Information regarding the investment.
• Investment Classification by Measurement Type.
• The Quantity element.
• Price and valuation methods.
• Investment account.
  The connection between the financial accounting and the Investments Inventory System.
• Book Value and Book Price.
• Realized Gains and Losses
• Unrealized Gains and Losses
• Investments Revenues and Costs.
• Impact of exchange rates
• Double-Entry Investment Transactions.
• Investments and Account Reconciliation.
• Investments (Items) card.

Accounting period

Financial accounting is always relative to a specific period. In the accounting you specify the start and end date:

• The balance sheet is prepared for a specific date (instant).
  • The Balance at the beginning of the period (opening balance).
  • The current balance or the balance at the end of the period.
• The Profit & Loss is prepared for a period (duration).
  • Revenues, costs, gains, losses, and taxes are always related to a specific period.

Inventory systems do not have an accounting period concept. They record purchases and sales continuously over time.

There is a conceptual difference in the temporal logic between Financial Accounting, an Inventory system, and Portfolio management systems.

• Portfolio management systems
  • Only track events that affect the change in a position (purchase or sale).
  • The profit or loss is calculated based on the difference between purchase and sale.
• Accounting systems
  • Require an initial balance and therefore a specific valuation. Quantity and price per unit for each investment at the beginning of the period.
  • Require an end balance and a valuation of each investment. Quantity and price per unit for each investment at the end of the period.
    The end quantity and price will become the opening quantity and price for the following year.
  • Under the fair value method, the Investment Value is adjusted and recorded as an unrealized gain or loss.
    If the Investment Value increases over time, an increase in value and a gain are recorded for the period and contribute to the overall profit or loss.
  • When an investment is sold, the realized gain or loss is determined by comparing the value of the sale with the Book Value attributable to the quantity sold.

Information Regarding the Investments

To properly manage and account for investments, it is essential to record key identifying information and classify them based on their measurement type.

Every investment should be clearly defined with standard financial identifiers:

• Investment Id (ItemId):
  The ItemId is used to uniquely identify the Investment. You can use a ticker symbol or an ISIN as the ItemId.
• Ticker Symbol.
  The unique exchange-listed symbol for publicly traded securities (e.g., AAPL for Apple Inc.).
• ISIN (International Securities Identification Number). 
  A globally recognized unique identifier for financial instruments (e.g., US0378331005 for Apple Inc.).
• Description.
  The full name and type of the investment (e.g., "Apple Inc. – Common Stock" or "U.S. Treasury Bond 10Y").
• Investments can be grouped to provide clearer overviews and totals.

Investments are entered in the Items table.

Investment Classification by Quantity Type

Investments can be classified based on how their quantity and Unit Price are expressed:

• Investments Measured by Nominal Value (Asset Type = 2)
  (e.g., Bonds, Treasury Notes)
  • These securities are expressed in terms of face value (nominal value).
  • The Book Value is determined based on the purchase price, which may be different from the nominal value due to discounts or premiums.
  • Example: A €100,000 corporate bond might be acquired at 97% of face value, meaning the actual acquisition cost is €97,000.
• Investments Measured by Effective Quantity (Asset Type = 1)
  (e.g., Shares, ETFs, Mutual Funds)
  • These securities are recorded based on the number of units owned.
  • Each unit has a Market Price, and the total investment value fluctuates accordingly.
  • Example: 200 shares of XYZ Corp. at €50 per share have a Market Value of €10,000.

By properly identifying and classifying investments, Investment Accounting ensures accurate tracking of quantities, values, and financial reporting.

Quantity Element

Investment accounting shares similarities with inventory systems. When buying or selling investments, a quantity element is involved, which can be expressed as either an effective quantity or a nominal value.

The key quantities to manage include:

• Quantity at the beginning of the accounting period. Recorded in the Items Table.
• Quantity changes during the accounting period.
  Tracked through transactions.
• Current Quantity. 
  Calculated as the initial quantity plus increases and minus decreases.

Unit Price and Valuation

Each investment has a Unit Price, or simply a price.

• For quantity-based investments, such as shares, the Unit Price is expressed per unit.
• For nominal-value investments, such as bonds, the Unit Price is generally expressed as a percentage of nominal value.

The investment value is determined by multiplying the Quantity by the applicable Unit Price.

Cost Attribution Methods

Cost attribution methods determine how the historical cost of an investment is allocated to individual units when multiple purchases are made at different prices.
These methods affect the calculation of realized gains or losses, but do not determine the measurement basis of the investment itself.

• Weighted Average Cost (WAC)
  The cost per unit is calculated as a weighted average of all purchase prices.
  This method smooths price fluctuations over time and is commonly used for investment accounting.
• Moving Average Cost with Market Adjustments (MAC-MA)
  This method is based on the Weighted Average Cost approach but includes periodic adjustments to reflect market prices.
  It combines cost averaging with market valuation elements.
  This method is used by the Banana Accounting Investment Extension.
• First-In, First-Out (FIFO)
  The earliest purchased units are considered sold first.
  In rising markets, this often results in lower costs and higher reported profits.
• Last-In, First-Out (LIFO)
  The most recently purchased units are considered sold first.
  This method can reduce reported profits in rising markets but is rarely used for investments and is not permitted under IFRS.

FIFO

The FIFO (First-In, First-Out) method assumes that the investments purchased first are also the first to be sold.

FIFO is an accepted cost attribution method under IFRS and various national GAAP frameworks. In some jurisdictions, it may also be used for tax purposes when calculating realized gains on investment sales.

Banana Investment Accounting does not automatically calculate realized gains using the FIFO method, but the corresponding amounts can be calculated and recorded manually. 

Weighted Average Cost (WAC) 

The cost per unit is averaged over time with each purchase, smoothing price fluctuations. 

Moving Average Cost with Market Adjustments (MAC-MA)

Investments may be measured at fair value, in which case their accounting value is periodically adjusted to reflect market prices.

Banana Investment Accounting uses the Moving Average Cost with Market Adjustments (MAC-MA) method, which combines moving average cost calculations with periodic market value adjustments. This approach allows the Book Value of investments to be adjusted to reflect market prices while maintaining the quantity information required for investment tracking.

Example Calculation (MAC-MA)

Step 1: Purchases and Moving Average Cost

• Buy 100 shares @ $10 → Cost = $1,000
• Buy 50 shares @ $15 → Total Cost = $1,000 + $750 = $1,750
• Total Quantity = 150 shares
• Moving Average Cost per share = $11.67

Step 2: Market Value Adjustment

Assume the market price increases to $14 per share.

• Market Value = 150 × $14 = $2,100
• Current Book Value = $1,750
• Unrealized Gain = $2,100 − $1,750 = $350

After recording the market value adjustment:

• Quantity = 150 shares
• Book Value = $2,100
• Book Price = $14 per share
• The $350 increase is recorded as an unrealized gain.

Step 3: Sale of Investments

Assume 50 shares are then sold at $15 per share.

• Selling Value = 50 × $15 = $750
• Book Value of Quantity Sold = 50 × $14 = $700
• Realized Gain = $750 − $700 = $50

After the sale:

• Remaining Quantity = 100 shares
• Remaining Book Value = 100 × $14 = $1,400
• Remaining Book Price = $14 per share.

Investment Valuation Methods in Accounting

Investments can be accounted for using different measurement bases and different cost attribution methods.
These two concepts serve different purposes and should not be confused.

Measurement bases define the value at which investments are recognized in the financial statements, independently of how costs are attributed upon sale.

• Historical Cost
  Investments are recorded at their original purchase price, without considering subsequent market fluctuations, except in cases of impairment or disposal.
  Compatible with: WAC, FIFO
• Fair Value (Mark-to-Market)
  Investments are remeasured at their current market price, reflecting changes in market conditions in real time.
  Compatible with: MAC-MA.
• Lower of Cost or Market (LCM)
  Investments are measured at the lower of historical cost or current market value, applying a conservative valuation approach to prevent overstatement.
• Amortized Cost
  Used primarily for fixed-income securities.
  The investment value is adjusted over time based on interest income and principal repayments, using an effective interest method.
• Net Realizable Value (NRV)
  Investments are measured at the estimated selling price minus any costs necessary to complete the sale.
• Intrinsic Value
  The investment is valued based on fundamental analysis of its underlying economic value rather than observable market prices.
  This approach is typically used for analytical purposes rather than formal accounting measurement.
• Recoverable Amount
  The investment is measured at the higher of its fair value less costs to sell and its value in use.
  This basis is commonly applied in impairment testing.

Market value of an investment

The market value of an investment is the current price assigned to it in the financial market, and this price can fluctuate according to market conditions. When securities are bought or sold, the portfolio management system informs the holder of the exact market price at which each transaction occurred. Unlike the book value, which is determined by the accounting process, the market price is directly provided by the market and does not require any calculation by the holder.

Within the Investment Manager, the market value of an investment is entered in the "Price Current" column of the Items table. By entering this market price, you can use the valuation report feature to calculate any unrealized gains or losses, which represent the difference between the current Market Value and the Book Value of the investment. This provides a snapshot of the potential profit or loss if the securities were sold at the current market price, even though they have not yet been sold.

Fair Value Adjustments and Realized vs. Unrealized Results

When investments are measured at fair value, changes in market prices give rise to fair value adjustments. These adjustments reflect changes in the value of an investment after initial recognition and before its disposal.

Accounting standards differ in how these fair value changes are presented and whether a distinction is made between realized and unrealized gains and losses.

IFRS approach

Under full IFRS, a clear distinction is made between:

• Realized gains and losses, arising from the sale or disposal of an investment; and
• Unrealized gains and losses, arising from changes in fair value while the investment is still held.

Depending on the classification of the financial instrument, unrealized fair value changes may be recognized:

• in profit or loss, or
• in other comprehensive income (OCI), for financial instruments measured at fair value through other comprehensive income (FVOCI).

In all cases, unrealized results remain analytically distinct from realized gains and losses, even if they are recognized in equity rather than in profit or loss.

IFRS for SMEs, Swiss GAAP FER, and International GAAP Approach

Under IFRS for SMEs, Swiss GAAP FER, and most national GAAP frameworks worldwide (including European continental GAAPs as well as accounting systems in North America, Asia, and other jurisdictions), the accounting model for investments is deliberately simplified.

Although investments may be measured at fair value in specific circumstances, these frameworks generally do not require a formal separation between realized and unrealized gains and losses at the equity level and do not apply an OCI or FVOCI model comparable to full IFRS.

When fair value changes are recognized, they are typically recorded directly in profit or loss as part of the period result, without mandatory reclassification into realized, unrealized, or OCI components. The emphasis is placed on prudence, understandability, and practical application, rather than on detailed presentation structures designed primarily for capital-market reporting.

Implications of Using the MAC-MA Method

Banana Accounting uses the Moving Average Cost with Market Adjustments (MAC-MA) method to manage investment portfolios.
This method is compatible with the accounting approaches applied under IFRS for SMEs, Swiss GAAP FER, and most national GAAP frameworks worldwide, which are based on simplified valuation and presentation principles for investments.

Under these frameworks:

• Investments may be measured at fair value without a mandatory formal separation between realized and unrealized gains and losses at the equity level.