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 Measurement Type

Investments can be classified based on how their value is measured in accounting records:

• 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 asset values, market movements, 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.

Price per Unit and Valuation

Each investment has a unit price, or simply a price.

• For quantity-based investments, such as shares, the price is expressed per unit.
• For nominal-value investments, such as bonds, the 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.
• Fair value adjustments, when recognized, are generally recorded directly in profit or loss as part of the period result.

No OCI or FVOCI model comparable to full IFRS is required.

Within the MAC-MA method:

• The moving average cost is used to determine the carrying amount of investments sold and the resulting realized gains or losses.
• Market value adjustments reflect changes in fair value while investments are held and give rise to unrealized gains or losses.

By contrast, MAC-MA is not an IFRS-defined measurement model. Under full IFRS, financial instruments must be classified and measured according to specific categories (such as amortized cost, FVTPL, or FVOCI), each with prescribed recognition and presentation rules.

Accordingly, the MAC-MA method cannot be applied directly for IFRS financial statements and requires appropriate adjustments or reconciliations when IFRS reporting is required.

User Responsibility, Disclosure, and Professional Assessment

The applicability of the MAC-MA method depends on the specific accounting framework, regulatory environment, and tax rules applicable to each entity. In addition, the investment valuation and cost attribution method applied should generally be disclosed in the presentation of the financial statements, in accordance with applicable accounting standards.

Users are therefore required to assess the suitability of the MAC-MA method in consultation with their auditors and tax advisors, taking into account their individual reporting, disclosure, and compliance requirements.

Asset Account and Book Value

Investments are assets that are part of the balance sheet. In financial accounting, unlike an inventory system, there is no direct tracking of quantity and price. Instead, financial transactions are recorded based on monetary amounts, requiring the use of specific accounts to track changes in investments.

When setting up the accounting system, you must create the necessary investment Asset Accounts in the Accounts table to track securities. If you hold investments in multiple currencies, you need one investment account per currency.

• When creating investment elements in the Items Table, you need to specify for each Item a valid Asset account specified in the Account table of the same currency.
• The Asset account of the Item serves as the link between financial accounting and investment accounting.
• For each transaction affecting an investment account, you must also associate the corresponding investment item (Item ID). 
  If you post an amount to an Asset account without specifying the Item ID, discrepancies will arise between financial accounting and the investment inventory system.

Book Value and Book Price

The Book Value is the accounting value of an investment position. It represents the value assigned to the investment in the accounting records.

The Book Price is the accounting value per unit of the investment. When a single unit book price applies to the position, it is calculated by dividing the Book Value by the quantity:

• Book Price = Book Value / Quantity

Therefore:

• Book Value = Book Price × Quantity

The Book Value changes when transactions or accounting adjustments affect the accounting value of the investment. Purchases and sales may change both the quantity and the Book Value, while valuation adjustments and other book value adjustments may change the Book Value without changing the quantity.

The Book Price depends on the cost attribution and valuation method used. It is particularly important when an investment is sold because it is used to determine the Book Value attributable to the quantity sold.

Reconciliation between Financial Accounting and Investment Accounting

Financial accounting and investment accounting must remain reconciled through the Asset Account:

• The opening balance of each Asset Account must equal the sum of the opening values of all Items linked to that Asset Account.
• The opening value of each Item is calculated as Opening Quantity × Opening Price.
• The current balance of each Asset Account must equal the sum of the current Book Values of all Items linked to that Asset Account.
• The current Book Value of each Item is determined by its opening value and by the transactions and adjustments recorded for that Item through its Asset Account.

Gains and Losses on Investments

Changes in the value of an investment may result in realized or unrealized gains and losses.

• A realized gain or loss arises when all or part of an investment is sold.
• An unrealized gain or loss arises when the Book Value of an investment is adjusted to a different valuation, such as its current Market Value, while the investment is still held.

Realized and unrealized gains and losses are recorded separately through the appropriate accounting transactions.

Realized Gains and Losses

A realized gain or loss arises when all or part of an investment is sold. It represents the difference between the Selling Value and the Book Value attributable to the quantity sold.

• If the Selling Price is higher than the Book Price, there is a realized gain.
• If the Selling Price is lower than the Book Price, there is a realized loss.

The Book Value attributable to the quantity sold is:

Book Value of Quantity Sold = Book Price × Quantity Sold

The realized gain or loss is:

Realized Gain/Loss = Selling Value − Book Value of Quantity Sold

or, when expressed using unit prices:

Realized Gain/Loss = (Selling Price − Book Price) × Quantity Sold

Accounting Treatment

When the sale is recorded in double-entry accounting, the amount received is debited to the bank account and credited to the Asset Account. The realized gain or loss is then recorded separately so that the balance of the Asset Account corresponds to the Book Value of the investment quantity that remains.

When the entire investment is sold, the remaining quantity is zero and the Book Value must also be zero. After recording the sale, but before recording the realized gain or loss:

• A remaining debit balance in the Asset Account represents a realized loss.
• A remaining credit balance in the Asset Account represents a realized gain.

The realized gain or loss is then recorded in the appropriate account so that the Asset Account balance returns to zero.

When only part of an investment is sold, the realized gain or loss relates only to the quantity sold. The remaining balance of the Asset Account must correspond to the Book Value of the quantity still held.

Example – Complete Sale

Assume an investment has:

• Quantity: 10 shares
• Book Value: $200
• Book Price: $20 per share

If all 10 shares are sold at $25 per share:

• Selling Value = 10 × $25 = $250
• Book Value of Quantity Sold = 10 × $20 = $200
• Realized Gain = $250 − $200 = $50
• Remaining Quantity = 0
• Remaining Book Value = 0

The $50 realized gain is recorded in the appropriate Realized Gain account.

If all 10 shares are sold at $18 per share:

• Selling Value = 10 × $18 = $180
• Book Value of Quantity Sold = 10 × $20 = $200
• Realized Loss = $200 − $180 = $20
• Remaining Quantity = 0
• Remaining Book Value = 0

The $20 realized loss is recorded in the appropriate Realized Loss account.

Example – Partial Sale

Using the same initial position, assume that 4 shares are sold.

If 4 shares are sold at $25 per share:

• Selling Value = 4 × $25 = $100
• Book Value of Quantity Sold = 4 × $20 = $80
• Realized Gain = $100 − $80 = $20
• Remaining Quantity = 6 shares
• Remaining Book Value = 6 × $20 = $120

If 4 shares are sold at $18 per share:

• Selling Value = 4 × $18 = $72
• Book Value of Quantity Sold = 4 × $20 = $80
• Realized Loss = $80 − $72 = $8
• Remaining Quantity = 6 shares
• Remaining Book Value = 6 × $20 = $120

The Calculate Sales Data command can calculate the realized gain or loss and create the corresponding accounting transactions.

Unrealized Gains and Losses

An unrealized gain or loss arises when the Book Value of an investment is adjusted to a different valuation, such as its current Market Value, while the investment is still held.

Unlike a realized gain or loss, no sale takes place and the quantity of the investment remains unchanged.

When an investment is adjusted to its Market Value:

• If the Market Value is higher than the Book Value, there is an unrealized gain.
• If the Market Value is lower than the Book Value, there is an unrealized loss.

The Market Value is:

Market Value = Market Price × Quantity

The unrealized gain or loss is:

Unrealized Gain/Loss = Market Value − Book Value

or, when expressed using unit prices:

Unrealized Gain/Loss = (Market Price − Book Price) × Quantity

The adjustment is recorded between the Asset Account and the appropriate Unrealized Gain or Loss account. The adjustment changes the Book Value without changing the quantity.

Example – Unrealized Gain

Assume an investment has:

• Quantity: 10 shares
• Book Value: $200
• Book Price: $20 per share
• Market Price: $25 per share

The Market Value is:

10 × $25 = $250

The unrealized gain is:

$250 − $200 = $50

After recording the $50 adjustment:

• Quantity = 10 shares
• Book Value = $250
• Book Price = $25 per share

Example – Unrealized Loss

If the Market Price is instead $18 per share:

• Market Value = 10 × $18 = $180
• Unrealized Loss = $200 − $180 = $20

After recording the $20 adjustment:

• Quantity = 10 shares
• Book Value = $180
• Book Price = $18 per share

The Create Adjustment Transactions command can calculate the required valuation adjustments and create the corresponding accounting transactions.

Revenues and Costs of Investments

A key function of an accounting system is to track both revenues (such as interest and dividends) and costs (such as commissions, bank fees, and broker expenses) associated with investments.

Revenues and costs related to investments are recorded as transactions linked to the investment (ItemId) but using accounts different from the Asset account. This ensures that these transactions do not affect the Book Value of the investment itself.

Each transaction can be assigned to an appropriate revenue or expense account, allowing for detailed reporting on all income and costs associated with a specific investment. This approach provides clear insights into the performance and profitability of investments while maintaining accurate financial records.

Impact of Exchange Rates on Investments

For investments denominated in foreign currencies, their valuation in accounting is influenced by both market price changes and exchange rate fluctuations. In addition to affecting the value of the investment in the accounting currency, exchange rate changes may give rise to unrealized or realized gains or losses that require appropriate accounting treatment.

Key Factors in Exchange Rate Impact

• Initial Exchange Rate at Purchase.
  The exchange rate used to record the investment at the time of acquisition.
• Current Exchange Rate at Reporting Date.
  The rate used to update the investment’s book value in financial statements.
• Market Price and Currency Interaction.
  A security's value may increase in its original currency, but if the exchange rate moves unfavorably, the gain may be reduced or turned into a loss when converted.
• Realized Gains/Losses on Sale. 
  When an investment is sold in a foreign currency, exchange rate differences can lead to additional gains or losses beyond market price changes.

Example of Exchange Rate Impact

• You purchase 100 shares of a stock at $200 per share, for a total cost of $20,000.
• At the time of purchase, the USD/EUR exchange rate is 1.10, meaning the recorded book value is €18,182.
• If the stock price remains at $200 but the exchange rate changes to 1.05, the book value in EUR would increase to €19,048, reflecting a gain purely due to currency fluctuation.

Because investments can be impacted by both market price movements and exchange rate variations, a proper Investment Accounting System ensures accurate financial reporting, helping investors and accountants manage risk and maintain compliance.

Impact of Exchange Rates on Investments and Adjustments 

For investments denominated in foreign currencies, their valuation in accounting is influenced by both market price changes and exchange rate fluctuations. These fluctuations impact both unrealized gains/losses (before sale) and realized gains/losses (after sale), requiring proper adjustments in financial reporting.

Key Factors in Exchange Rate Impact

• Initial Exchange Rate at Purchase
  • The exchange rate at the time of acquisition is used to record the investment's book value in the reporting currency.
• Current Exchange Rate at Reporting Date
  • At each financial reporting period (e.g., month-end, quarter-end, year-end), investments in foreign currencies must be revalued based on the latest exchange rate.
• Market Price and Currency Interaction
  • A security’s value may increase in its original currency, but if the exchange rate moves unfavorably, the gain could be reduced or even turned into a loss when converted to the reporting currency.
• Unrealized Gains/Losses Due to Exchange Rate Changes
  • Even if an investment is not sold, the difference in exchange rates between the purchase date and the reporting date can create unrealized foreign exchange gains or losses, which should be recorded separately.
• Realized Gains/Losses on Sale
  • When an investment is sold, the difference between:
    • The original exchange rate at purchase, and
    • The exchange rate at the time of sale,
      determines an additional realized gain or loss due to currency fluctuations.

Example of Exchange Rate Impact

• Step 1: Initial Investment Purchase
  • You buy 100 shares at $200 per share, for a total cost of $20,000.
  • At the time of purchase, the USD/EUR exchange rate is 1.10.
  • The recorded book value in EUR is 20,000 divided by 1.10, which equals €18,182.
• Step 2: Exchange Rate Adjustment at Reporting Date
  • At the reporting date, the stock price remains $200, but the exchange rate changes to 1.05.
  • The new book value in EUR is 20,000 divided by 1.05, which equals €19,048.
  • The unrealized foreign exchange gain is 19,048 minus 18,182, which equals €866.
  • This gain is recorded in the foreign exchange adjustment account as an unrealized gain.
• Step 3: Realized Foreign Exchange Gain/Loss on Sale
  • Later, you sell 100 shares at $210 per share, for a total of $21,000.
  • At the time of sale, the USD/EUR exchange rate is 1.08.
  • The converted sale amount in EUR is 21,000 divided by 1.08, which equals €19,444.
  • The initial book value was €18,182, so the total realized gain is 19,444 minus 18,182, which equals €1,262.
  • This realized gain includes both the market price gain (from $200 to $210) and the foreign exchange gain (due to currency movement from 1.10 to 1.08).

Accounting Treatment

• Unrealized Exchange Gains and Losses
  • At reporting periods, any changes in exchange rates affect the book value.
  • These adjustments are recorded in an exchange rate adjustment account.
• Realized Exchange Gains and Losses
  • When an investment is sold, the foreign exchange gain or loss is finalized and recorded in the profit and loss statement.

End of Year Exchange Rates

Different banks/custodians may use different exchange rates when preparing their reports.

• Due to the accounting principle of consistency, for the end of year revaluation you should always use the exchange rate defined in the Exchange Rate table.
• If, for auditing purposes, you need to reconcile the amounts reported by custodians or banks, you should create an Excel sheet and not change the values or exchange rates in the accounting records.

Double-Entry Investment Transactions

Investment account transactions are recorded in the Banana Accounting Transactions table. The Transactions table includes both standard double-entry accounting columns and additional columns used for investment tracking.

• Investment Id (Item or ItemId). 
  When recording a transaction that refers to an investment you always need to specify the Investment ID.
• Quantity.
  • If present, together with the Unit Price it is used to calculate the transaction amount.
  • When you enter a positive or negative quantity the program will update the existing quantity for the Investment in the Items Table.
  • When using quantities, you must always specify the security’s Asset Account as either the debit or credit account.
    If not, the Investment unit price (Balance divided by the quantity) will be wrong.  
  • Positive quantity values (123.00)
    • Will increase the existing quantity.
    • You will use when
      • Buying investments.
      • Stock split, which increases the quantity without affecting the value.
  • Negative values (-123.00)
    • Will decrease the existing quantity.
    • You will use when selling investments.
  • Neutral Values (±123.00) or zero quantity
    • Neutral Values will be used to calculate the transaction amount.
    • Neutral Values will not increment or decrement the existing quantity in the Item table.
    • They are used to record changes to the Investments without affecting the quantity.
      For example, Market price adjustments, the quantity remains the same, but the value of the investment (balance) is changed.
       
• Price per unit.
  If present, together with the Quantity it is used to calculate the transaction amount.
• Transaction amount
  • If you enter the Quantity and Unit Price, the program automatically calculates the Amount.
  • For market price adjustments the amount is entered without quantity or with a neutral quantity.
• Account Debit or Account Credit
  • Asset account
    • When changing the quantity or the balance of the investment you always need to enter as a debit or credit account that corresponds to the Asset account associated with the Investment.
  • Revenues and Cost accounts
    • When recording revenues and costs related to the investment, you specify the account that is related to the revenue or cost.
    • The program will create reports that calculate all the costs associated with a specific investment.

Examples of Double-Entry Transactions

The Transactions Table is where you enter investment transactions. Here is a brief explanation:

• When buying or selling investments, multiple lines are typically needed to enter the necessary accounts, quantity, and price. The date and item are repeated.
• The Item column (Investment ID) allows you to specify the investment, while the Qt. (quantity) and Unit Price columns provide the necessary information for inventory tracking.
• The Account Debit and Account Credit columns enable you to specify the accounts for bank transactions, asset accounts, revenues, costs, and realized or unrealized gains or losses, including those related to exchange rates.

Opening Value

When starting a new accounting or a new year you need to enter:

• Opening amounts for Investment accounts.
  As with any other accounts, enter the opening amount of each Investment account in the account currency. 
  • The program calculates the opening amount in the base currency using the opening exchange rate from the Exchange Rate table.
  • The opening balance should equal the sum of the opening values of all investments associated with that account.
• Opening Quantity and Price for Investments.
  For each investment, enter the opening quantity and opening price.
  • The program calculates the opening value by multiplying the opening quantity by the opening price.
  • The program also calculates the opening value in the base currency using the opening exchange rate.

Accounts and Investments Reconciliation

When an investment is entered in the Items table, it must be linked to the Asset Account where its accounting value is recorded.

For all investments linked to the same Asset Account, there must be full correspondence between:

• the opening balance of the Asset Account and the opening values of the linked investments
• the current balance of the Asset Account and the Book Values of the linked investments.

The command Reconciliation Report will calculate the book value of all accounts and check for the correspondence. If there are any differences it will notify you.