Introduction to Investments Manager for Accounting

Investments Manager is a comprehensive solution designed to help you efficiently manage bonds, shares, funds, and other securities within Banana Financial Accounting. It provides the tools needed to track your investments with precision while ensuring compliance with accounting standards.

This introduction not only presents the features of Investments Manager Solution but also helps you understand how securities accounting works. Whether you're an investor, accountant, or auditor, this guide will provide valuable insights into the financial and accounting aspects of investment management.

After reading this page, you will be able to manage your investments effectively, prepare accurate financial statements, and facilitate auditing with confidence.

Purpose of an 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 Investments Manager 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.

Investments Manager Goals and Future Developments

Over the years, we have refined the Investments Manager solution based on feedback from Banana Accounting users who needed an efficient way to manage securities. Our goal aligns with their requests: to provide a straightforward solution for managing investments directly within financial accounting software. Typically, such integration is offered only by specialized financial-sector tools. Our focus is to keep the solution simple while delivering essential functionalities that give you control over your investments and streamline compliance. Rather than replicating the complexity of specialized platforms, we prioritize ease of use and core investment management features.

Many customers are already using the Investment Manager. Based on the valuable feedback we have received, we have identified several improvements for the solution. As it continues to evolve, we will finalize the documentation once the new enhancements are implemented.

We highly value your feedback and suggestions, as they help us improve the solution further. Kindly use the form at the bottom of this page to share your requests or any other input with us.

Learning Tool for Finance Students

In line with our company’s mission, we aim to provide a solution that enhances financial literacy. By integrating investment management directly into Banana Accounting, students in Finance, Accounting, and Auditing can engage with more complex topics and gain hands-on experience. This approach allows them to experiment with real-world scenarios, understanding how different operations impact the Balance Sheet, Income Statement, and overall financial performance.

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.

The Investment Accounting Elements

The Investments Accounting is composed from this elements:

• Accounting period.
• Information regarding the investment.
  Including Identifying information.
• Investment Classification by Measurement Type.
• The Quantity element.
• Price and evaluation methods.
• Investment account.
  The connection between the financial accounting and the Investments Inventory System.
• Book Value and Book Price.
• Realized Profit and Loss
• Unrealized Profit and Loss
• Investments Revenues and Costs.
• Impact of exchange rates
• Double Entry Investments 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 begin of the period (opening balance).
  • The current or end of period Balance.
• The Profit & Loss is prepared for a period (duration).
  • The revenues, costs, gain and loss, and the tax are always referred to a period. 

Inventory systems have not a period concept. They record buy and sell and continue over the time. 

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

• Portfolio management systems
  • Only track events that affect the change in a position (buy or sale).
  • The profit or loss is calculated based on the difference between buying and sale.
• Accounting systems
  • Require an initial balance and therefore a specific valuation. Quantity and price per unit for each investments at the begin of the period.
  • Require an end balance and a valuation of each investment. Quantity and price per unit for each investments at the end of the period.  
    The end quantity and price will become the begin quantity and price for the following year.
  • With fair value method the Investment value is adapted and booked as unrealized profit or loss. 
    If the Investment value grows over time, each year a value increase and a gain is recorded and appears as revenue and contribute to the total profit and loss.
  • The profit and loss on the investment is the difference between the current Book value and the price of the transaction.
    It is therefore the change in value relative to the being of the period and the sale of the investment.

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 the Ticker Symbol, or ISIN as an 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").
• Group different investments together to have a better view and also totals.

The Items Table where investments are inserted.

Investment Classification by Measurement Type

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

• Investments Measured by Nominal Value 
  (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 
  (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 Evaluation

Each Investment has the element Price per unit or simply the price. 

• For quantity type (shares) is simple the Price.
• For nominal type (bonds) is a percentage.  

The price multiplied by the quantity give the value of the Investment.

Investment Valuation Methods in Accounting

There are different methods for evaluating an investment.

• Historical Cost 
  Investments recorded at the original purchase price, without considering market fluctuations.
• Fair Value (Mark-to-Market)
  Assets are revalued at their current market price, reflecting real-time changes.
• Lower of Cost or Market (LCM)
  The investment is valued at the lower of its historical cost or market value to prevent overstatement.
• Weighted Average Cost (WAC) 
  The cost per unit is averaged over time with each purchase, smoothing price fluctuations.
• Moving Average Cost with Market Adjustments
  Uses WAC but adjusts the value periodically based on market price changes.
• First-In, First-Out (FIFO) 
  The oldest purchases are considered sold first, often leading to lower costs and higher profits in rising markets.
• Last-In, First-Out (LIFO) 
  The most recent purchases are considered sold first, often reducing taxable income but rarely used for investments.
• Amortized Cost 
  Used for fixed-income securities, adjusting the value gradually based on interest income and principal repayments.
• Net Realizable Value (NRV) 
  The investment is valued at the estimated selling price minus disposal costs.
• Intrinsic Value 
  Based on the fundamental analysis of the asset’s true worth rather than market fluctuations.
• Recoverable Amount 
  The higher of an asset’s fair value minus selling costs or its value in use, often used in impairment tests.

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 based on market conditions. When securities are bought or sold, the portfolio manager informs the securities holder of the exact market price at which each transaction occurred. Unlike book value, which is determined by the accounting process, the market price is readily provided by the market itself and doesn't require the holder to calculate it.

Within the Investment Manager the the market value of the investment is entered in the 'Price Current' column within the Items table. By entering this market price, you can use the valuation report feature to calculate any unrealized gains or losses—the difference between the current market value and the original purchase price 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 haven’t been sold yet.

FIFO 

The FIFO (First In First Out) method means that the inventory or investments are evaluated based on the value of purchase, that the the investments purchased first are also sold first. FIFO method is a valid method in IFRS and in the GAAP of other countries.  FIFO is also a method used in recognizing revenues for tax fir private investors, in countries where realized gains on sale of investments are taxable.  
Investments Manager does not automatically calculate the realized gains using the FIFO method, but you can calculate and record it manually.  

Moving Average Cost with Market Adjustments

Most companies evaluate investment at the Fair value. This means that investments value is adjusted regularly to the market price. 
Therefore the Investments Manager allows to calculate based on the Moving Average Cost with Market Adjustments method (MAC-MA). It is an investment valuation method that combines the Weighted Average Cost (WAC) with fair value market adjustments to reflect market price changes. It balances the stability of average cost valuation with the accuracy of market-based adjustments.

Example Calculation

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

• Market price rises to $14 per share → Total Market Value = $2,100 (150 × $14)
• Adjustment = $2,100 - $1,750 = $350
• The increase is recorded as an unrealized gain.

Step 3: Sale of Investments

• Sell 50 shares → Cost = 50 × $11.67 = $583.50
• If sold at $14, the realized gain = (50 × $14) - $583.50 = $116.50
• Remaining shares (100) retain the adjusted cost.

Investment Account and Book Value

Investment are assets that are part of the balance sheet. In financial accounting, unlike an inventory systems, 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 investment accounts to track securities. If you hold investments in multiple currencies, you need at least one investment account per currency.

The investment account serves as the link between financial accounting and investment accounting. When creating investment records in the Items Table, each investment must be associated with an investment account of the same currency.

For each transaction affecting an investment account, you must also associate the corresponding investment item (Item ID). If you post an amount to an investment account without specifying the Item ID, discrepancies will arise between financial accounting and the investment inventory system.

Investment Value and Investment Unit Price

The Book Value, or Investment Value, is the balance of an investment account, representing the sum of all debit and credit transactions recorded for a specific investment. The Investment  balance is the amount displayed on the Balance Sheet, making it the key financial measure for investment valuation.

Unlike inventory systems, where quantity and price per unit are explicitly recorded, investment accounts may include transactions that affect the balance without changing the quantity (e.g., adjustments, revaluations, dividends, or fees).

To determine the Investment Price per unit, the Investment Value (balance of the Investment) is divided by the investment’s quantity.

Profit and Loss on Investments

When you sell an investment you will get a gain if the price is above the book value price and have a loss is the price is below the the book price. 
The sale if The gain is recorded 

Realized Profit and Loss

When you sell an investment you will get a gain if the price is above the book value price and have a loss is the price is below the the Investment price.  When you register the selling transactions in the double entry accounting you will debit the bank account and credit the Investment account for the amount of the sale. 
Assuming you have sold all your stock the balance, the quantity will be zero and the balance of the account will be the gain or loss of the investments. Without any quantity the balance should be zero, so what you have to do is to record the profit or loss as a revenue or cost. 

• If the balance is positive (debit) it means you have a loss. 
  You will have to record a realized loss, by debiting the Realized loss account (Cost) and crediting the Investment account.
• If the balance is negative (credit) it means you have a gain. 
  You have sold the investment to an higher a remaining investment value. 
  You will have to record a realized gain, by debiting Investment account and crediting the Realized gain account (Revenue). 

We can also see how the profit or loss per share is calculated when you sell all the shares:

• Investment Value is the balance of the account, prior to the sale divided by the quantity. 
  Assuming we had a balance of $ 200 and quantity of 10 the book price would be $ 20 per shares.
• Selling all 10 shares at $ 25 per share the transactions value would be of $ 250.
  • After recording the transaction (Bank to Investment account) the balance would be in credit of $ 50.
  • The gain per share would be $ 5 per 10 share = $ 50.
  • We will record Investment account to Realized gains $ 50.
• Selling all 10 shares at $ 18 per shares the transactions value would be of $ 180.
  • After recording the transaction (Bank to Investment account) the balance would be in debit of $ 20.
  • The loss per share would be $ 2 per 10 share = $ 20.
  • We will record Realized Loss to Investment account $ 20. 

Partial sales. If you have not sold all the investments but you still have the quantity, you need to record the profit or loss relative to the investments you have sold. Basically it means that the remaining balance should be equal to the quantity multiplied by the same price per unit, prior to the sale. 

• Investment Values is the balance of the account, prior to the sale divided by the quantity. 
  Assuming we had a balance of $ 200 and quantity of 10 the book price would be $ 20 per shares.
• Selling 4 shares at $ 25 per share the transactions value would be of $ 100.
  • After recording the transaction (Bank to Investment account) the balance would be in debit of $ 100 ($200 - $100).
  • The remaining value should be 6 shares at $ 20 = $ 120.
  • The gain per share would be $ 5 per 4 shares = $ 20.
  • We will record Investment account to Realized gains $ 20.
  • The new balance of the Investment account would be $120 ($100 + $ 20) or exactly 6 @ $20.
• Selling 4 at $ 18 per share the transactions value would be of $ 72.
  • After recording the transaction (Bank to Investment account) the balance would be in debit of $ 128 ($200 - $72).
  • The remaining value should be 6 shares at $ 20 = $ 120.
  • The loss per share would be $ 2 per 4 shares = $ 8.
  • We will record Realized Loss to Investment account $ 8.
  • The new balance of the Investment account would be $120 ($128 - $ 8) or exactly 6 @ $20.

The command "Sale transactions" automatically calculate the Profit or Loss and create the appropriate transactions. 

Unrealized Profit and Loss

Fair Value accounting requires to adjust investments value based on the market price. There are also fiscal regulation that require that investments are evaluated at year end at a price defined by the tax authority. These adjustments, increase or decrease the value of the investments in the Balance Sheet, and that are usually recorded in the Income & Expenses as unrealized  profit or loss. Adjustments have consequences for the profit and loss calculation and therefore effect the tax calculation.

• Book Price Values is the balance of the account, prior to the adjustment divided by the quantity. 
  Assuming we had a balance of $ 200 and quantity of 10 the book price would be $ 20 per shares.
• If the market price is $ 25 per share the market value $ 25 @ 10 = $ 250.
  • The unrealized gain is $ 250 - $ 200 = $50.
  • The gain per share is $ 50 divided 10 = $ 5 per share.
  • The gain per share is also be calculated $ 25 minus $20 = $ 5.
  • We will record "Investment account to Unrealized gains $ 50".
  • The new balance of the Investment account would be $250 ($200 + $ 50) or exactly 10 @ $25.
• If the market price is $ 18 per share the market value $ 18 @ 10 = $ 180.
  • The unrealized loss is $ 200 - $ 180 = $20.
  • The loss per share is $ 20 divided 10 = $ 2 per share.
  • The loss per share is also be calculated $ 20 minus $18 = $ 2.
  • We will record "Unrealized loss to Investment account $ 20".
  • The new balance of the Investment account would be $180 ($200 - $ 20) or exactly 10 @ $18.

The command "Adjust to current value" automatically calculate the adjustments and create the 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 investment 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 affected by exchange rate fluctuations, which must be considered alongside market price changes.

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/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/Losses
  • When an investment is sold, the foreign exchange gain or loss is finalized and recorded in the profit and loss statement.

Double entry Investments Transactions

Investments accounts transactions are recorded in the Banana Accounting Transactions table. As you will see the Transactions table, next to the typical double entry elements has also columns that can be used for the inventory: 

• Investment Id (Item or ItemId). 
  When recording a transaction that refers to an Investments you always need to specify the Investment Id.
• Quantity. 
  When you enter a quantity the program will update the existing quantity for the Investment in the Table Article.
  • When using quantities you always need to specify the Investment account as debit or credit account.
    If not, the Investment unit price (Balance divided by the quantity) will be wrong.  
  • Positive values will increase the existing quantity. 
    You will use when
    • buying investments.
    • Split stock, that increase the quantity without affecting the value.
  • Negative values will decrease the existing quantity.
    You will use when selling investments.
  • Zero quantity
    It is used to record changes to the Investments without effecting the quantity.
    For example Market price adjustments, the quantity remains the same, but the value of the investment (balance) is changed.
  • Neutral values (zero).
    Will not increment or decrement the existing quantity, but the value will be used to calculate the transactions amount.  
• Price per unit.
  It is used to calculate the transactions Amount.
• Amount of the transactions.
  • If you enter a quantity or a Unit Price the program will automatically calculate the quantity.
  • For market price adjustments the amount is entered without quantity or with a neutral quantity.
• Account Debit or Account Credit
  • Investment account
    • When changing the quantity or the balance of the investment you always need to enter as a debit or credit account the Investment 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 Investments.

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, investment 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 Investments accounts.
  Like for any other accounts you have to enter the opening amount of the Investments accounts in the account currency.
  • The program will calculate the opening amount in basic currency, using the opening exchange rate (Exchange rate table).
  • The opening balance should be equal the the sum of the value of the opening values of all the investments associated with this accounts.
• Quantity and Price at the investments.
  For each investment you will have to enter the opening quantity and the price at the begin.
  • The program will calculate the begin value, multiplying quantity and price.
  • The program will also calculate the begin value in basic currency, using the opening exchange rate. 

Accounts and Investments reconciliation

When you insert a new Investment in the Items table you need specify the Account where the value of the investment is booked used the double entry accounting methodology.

Therefore, for all Investments that use the same account, there should be a full correspondence  for:

• The opening amount of the account and the opening value of the investments.
• The balance of the account and the book value of all the 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 to you.