Investments — Complete User Guide — Two Accounts Web

Comprehensive guide for managing investments, recording market prices, performing revaluations, and analyzing realized and unrealized gains


Table of Contents

  1. What Are Investments?
  2. Enabling the Investments Tab via Customize Menu
  3. System Accounts Setup
  4. Field-by-Field Guide for Creating an Investment
  5. Field-by-Field Guide for Investment Revaluation
  6. Settings Configuration
  7. Opening Balances for Investments
  8. Recording Investment Transactions
  9. Investment Revaluation
  10. Reports
  11. How Balances Are Calculated
  12. Sample Data and Report Output
  13. Key Considerations
  14. Accounting Regulation Compliance

1. What Are Investments?

Investments represent financial assets held by a business for capital appreciation, dividend income, or strategic purposes. They may include:

  • Equity securities — shares, stocks, equity interests in other entities
  • Debt securities — bonds, debentures, fixed-income instruments
  • Other financial instruments — mutual funds, unit trusts, investment certificates

In the system, investments are tracked with the following attributes:

  • Quantity — number of shares, bonds, or units held
  • Cost basis — total amount paid to acquire the investment
  • Average cost — cost per unit, calculated using the weighted average method
  • Market price — current market price per unit
  • Market value — total current value (quantity × market price)
  • Unrealized gain/loss — difference between market value and cost basis
Key Concept: Investments appear on the Balance Sheet as assets. Their carrying amount equals cost plus or minus any revaluation adjustments. The difference between cost and market value is recognized as unrealized gains or losses on the Profit and Loss Statement. When investments are sold, the realized gain or loss is recorded separately.

2. Enabling the Investments Tab via Customize Menu

To make the Investments section visible in the navigation bar:

  1. Open the Customize Menu by clicking the customize button on the top-right of the navigation bar
  2. Find "Investments" in the list of available tabs
  3. Toggle it to Visible
  4. Click Save or Apply

Once enabled, you will see the following items under the Investments tab:

  • Investments — main listing of all investments with current positions
  • Investment Revaluations — list of revaluation entries posted
  • Investment Market Prices (under Settings) — record market prices for each investment
  • Control Account for Investments (under Settings > Control Accounts) — manage the control account linked to investments

3. System Accounts Setup

The system uses five specialized accounts to manage investments. Some are created automatically when you first add an investment; others may need to be configured manually.

3.1 Control Account for Investments

Type: Balance Sheet (Asset)

Purpose: This is a custom control account that groups individual investments under one Balance Sheet line. When you create an Investment record, you can assign it to a Control Account. If no custom control account is specified, the system uses the default "Investments, at cost" account.

  • Code — optional short identifier
  • Name — display name (e.g., "Equity Investments", "Bond Portfolio")
  • Group — Balance Sheet group placement (e.g., "Non-Current Assets" or "Current Assets")
  • Position — sort order within the group
  • Inactive — mark as inactive to hide from dropdowns

3.2 Balance Sheet Investments at Cost Account

Type: Balance Sheet (Asset)

Purpose: The default account that holds the cost of all investments when no custom Control Account is assigned. This account is created automatically.

  • Name — defaults to "Investments, at cost"
  • Code — optional
  • Group — Balance Sheet group
  • Cash Flow Statement Investing Activity Group — cash flow classification

3.3 Balance Sheet Investments Market Value Increment Account

Type: Balance Sheet (Asset)

Purpose: Holds the cumulative unrealized gain or loss from investment revaluations. This account appears alongside the cost account on the Balance Sheet, so the total carrying value equals cost plus market value increment.

  • Name — defaults to "Investments, market value increment"
  • Code — optional
  • Group — Balance Sheet group

3.4 Profit and Loss Realized Capital Gains Account

Type: Profit and Loss (Income)

Purpose: Records realized gains or losses when investments are sold. When the system calculates a disposal, it automatically creates a journal entry to post the gain or loss to this account.

  • Name — defaults to "Realized investment gains (losses)"
  • Code — optional
  • Group — Profit and Loss group

3.5 Profit and Loss Unrealized Investment Gains/Losses Account

Type: Profit and Loss (Income/Expense)

Purpose: Records unrealized gains or losses from investment revaluations. When you post a revaluation entry, the system debits or credits this account.

  • Name — defaults to "Unrealised investment gains (losses)"
  • Code — optional
  • Group — Profit and Loss group
Tip: The system automatically creates "Investments, at cost" and "Realized investment gains (losses)" when the first Investment record is added. "Investments, market value increment" and "Unrealised investment gains (losses)" are created when the first Investment Revaluation is posted.

4. Field-by-Field Guide for Creating an Investment

To create a new Investment, navigate to Investments > Add and fill in the following fields:

Field Type Required Description
Code Short Text No A short alphanumeric identifier for the investment (e.g., ABC-001, BOND-XYZ). Used in reports and dropdowns for quick reference.
Name Text Yes The display name of the investment. This is shown in all reports, transactions, and drill-down views (e.g., "ABC Corporation Shares", "XYZ 5% Bonds 2030").
Control Account Dropdown No Select a Control Account for Investments to group this investment under a specific Balance Sheet line. If left blank, the investment uses the default "Investments, at cost" account. The dropdown filters to show only Control Account for Investments records.
Inactive Checkbox No Mark the investment as inactive to hide it from dropdowns and prevent new transactions. Existing historical data is preserved.
Custom Fields Configurable No Additional fields can be added via Settings > Custom Fields to capture investment-specific data such as ISIN, CUSIP, maturity date, coupon rate, sector, or broker information.

5. Field-by-Field Guide for Investment Revaluation

The Investment Revaluation form records a revaluation of one or more investments to their current market value. Navigate to Investment Revaluations > Add.

Field Type Description
Date Date The date of the revaluation. This is the date used for the general ledger posting.
Reference Text Manual or auto-generated reference number. If Automatic Reference is enabled in settings, the system generates the next sequential number.
Description Long Text Optional description of the revaluation (e.g., "Quarter-end fair value adjustment — June 2026").
Lines Table Each line represents one investment being revalued.

Lines Sub-Table

Column Type Description
Investment Dropdown Select the investment to revalue. Lists all active investments.
Unrealized Gains Decimal The unrealized gain or loss amount. Positive for gains (market value exceeds cost), negative for losses (market value below cost). The system's Investment Revaluation Worksheet can pre-calculate this value based on current market prices.
Accounting Impact: When an Investment Revaluation is saved, the system creates two general ledger transactions:
  1. Debit or Credit the Balance Sheet Investments Market Value Increment account (adjusts the carrying value on the Balance Sheet)
  2. Credit or Debit the Profit and Loss Unrealized Investment Gains/Losses account (recognizes the gain or loss on the Profit and Loss Statement)
Both entries are linked to the specific Investment record for drill-down tracking.

6. Settings Configuration

6.1 Chart of Accounts Settings

The five investment-related accounts can be renamed, regrouped, or repositioned via Settings > Chart of Accounts. Look for:

  • Balance Sheet > Investments, at cost — the default cost account
  • Balance Sheet > Investments, market value increment — the revaluation adjustment account
  • Profit and Loss > Realized investment gains (losses) — capital gains on disposals
  • Profit and Loss > Unrealised investment gains (losses) — revaluation gains and losses

Click any of these to edit its name, code, group assignment, or position. Changes take effect immediately across all reports.

6.2 Investment Market Prices

Navigate to Settings > Investment Market Prices to record market prices for your investments.

Field Type Description
Date Date The date of the market price quotation.
Investment Dropdown The investment to which this price applies.
Currency Dropdown Optional. If the investment trades in a foreign currency, select the currency. The system will convert the price to the base currency for reporting.
Market Price Decimal The market price per unit in the selected currency.
Exchange Rate Decimal Auto-fill or manually enter the exchange rate between the foreign currency and the base currency. Only shown when a currency is selected.
Exchange Rate Is Inverse Toggle When enabled, the system uses division instead of multiplication for currency conversion. Only shown when a currency is selected.
Tip: The Investment Summary and Investment Revaluation Worksheet reports use market prices to calculate market values and unrealized gains. Keeping market prices up to date ensures accurate reporting.

7. Opening Balances for Investments

To set the opening balance for an investment at the start of a financial year:

  1. Navigate to Settings > Opening Balances
  2. Click Add
  3. Select an account that has investments enabled (a Control Account for Investments or the Balance Sheet Investments at Cost Account)
  4. The Investment field appears — select the specific investment
  5. The Quantity field appears — enter the number of shares, bonds, or units held
  6. Enter the Amount and Debit/Credit direction (Dr for asset increases, Cr for asset decreases)
  7. If the investment is in a foreign currency, select the Currency and enter Amount in Currency and Exchange Rate
Important: The Quantity field must be populated for opening balance entries on investment-related accounts. A zero quantity (default) means the opening balance will not be counted in quantity tracking, though the monetary amount will still be included in the general ledger balance.

What happens behind the scenes:

  • The system creates a general ledger transaction with the investment's control account, linking it to the selected Investment record and including the specified quantity
  • The offset entry goes to Retained Earnings (as with all opening balance entries)
  • Both the quantity and cost are included in the running position tracked by reports
  • If a disposal occurs later, the opening balance shares are included in the average cost calculation for determining realized gains

8. Recording Investment Transactions

8.1 Purchasing Investments

To record a purchase of investments:

  1. Go to Receipts > Add (or Payments > Add depending on the flow of funds)
  2. Select the bank account from which the funds are drawn
  3. On a transaction line, select an account that Is Control Account for Investments (the control account or the "Investments, at cost" default)
  4. The Investment field appears — select the specific investment being purchased
  5. Enter the Quantity of shares/bonds/units being purchased
  6. Enter the Total Amount (price × quantity, including any brokerage fees or transaction costs)
  7. Complete and save the receipt
Accounting Entry:
Dr  Investments — ABC Corporation Shares     50,000
    Cr  Bank Account                             50,000
(Purchase of 1,000 shares @ 50.00 each)

8.2 Selling Investments

To record a sale of investments:

  1. Go to Receipts > Add (cash received from sale)
  2. Select the bank account that receives the proceeds
  3. On a transaction line, select the same investment control account
  4. The Investment field appears — select the investment being sold
  5. Enter the Quantity as a negative number (indicating reduction)
  6. Enter the Total Amount (proceeds received)
  7. Complete and save the receipt
Important: When a sale is recorded:
  • The system automatically calculates the realized gain or loss using the weighted average cost method
  • The realized gain or loss is automatically posted to the Realized Capital Gains Profit and Loss account
  • This happens as part of the background calculation — you do not need to create a separate journal entry

8.3 Using Journal Entries

Journal Entries can also be used to record investment movements. When you select an investment control account on a journal entry line, the Investment and Quantity fields appear, enabling you to enter journal-based adjustments to investment positions.


9. Investment Revaluation

Investment Revaluation is the process of adjusting the carrying value of investments to reflect their current market value. This is required for fair value accounting under IFRS 9.

Workflow

  1. Record market prices — Enter current market prices via Settings > Investment Market Prices
  2. Generate the worksheet — Go to Reports > Investment Revaluation Worksheet, select a date, and generate the report. The worksheet compares current market prices against carrying values and suggests revaluation amounts
  3. Post the revaluation — Click the "New Investment Revaluation" button on the worksheet. The system pre-populates a new Investment Revaluation form with the calculated unrealized gains/losses for each investment. Review and save
  4. Verify impact — Check the Unrealized Investment Gains Summary report to confirm the revaluation has been recorded correctly
Accounting Impact of Revaluation:
If market value exceeds cost (gain):
    Dr  Investments, Market Value Increment    12,400
        Cr  Unrealized Investment Gains           12,400

If market value is below cost (loss):
    Dr  Unrealized Investment Losses            5,000
        Cr  Investments, Market Value Increment    5,000

10. Reports

10.1 Investment Listing

The Investments page (navigation tab) displays a comprehensive listing of all investments with the following columns:

Column Description Calculation
Code Investment code Directly from the Investment record
Name Investment name Directly from the Investment record
Control Account The control account or default cost account linked to this investment Resolved from the Investment's Control Account field, or falls back to the default "Investments, at cost" account
Market Price Latest market price per unit From the most recent Investment Market Price record for this investment, displayed in the original currency and the base currency equivalent
Qty Total units held Sum of all quantities from general ledger transactions for this investment
Average Cost Weighted average cost per unit Total cost base ÷ quantity held.
Formula: TotalCost ÷ Qty
Total Cost Total cost basis of the position Sum of all cost-related general ledger amounts for this investment. Clicking this value drills into the Investment Transactions view showing every transaction affecting this investment
Market Value Total current market value Latest market price × quantity held.
Formula: MarketPrice × Qty
Unrealized Gains Unrealized gain or loss Market value − total cost.
Formula: MarketValue − TotalCost

10.2 Investment Summary Report

Navigate to Reports > Investment Summary. This report provides a snapshot of all investment positions as at a specified date.

Column Description
Qty Total units held as at the report date
Average Cost Weighted average cost per unit. Calculated as total cost base divided by quantity, rounded to the base currency's decimal places
Total Cost Total cost basis. Sum of all general ledger amounts posted to the investment control account up to the report date. Includes opening balances, purchases, and adjustments from realized gain calculations
Market Price The most recent market price per unit, converted to base currency. Only shown when market prices have been recorded
Market Value Total current market value. Calculated as quantity × market price per unit
Unrealized Gains Difference between market value and total cost. A positive value indicates an unrealized gain; a negative value indicates an unrealized loss

10.3 Realized Investment Gains Summary

Navigate to Reports > Realized Investment Gains Summary. This report shows the gains and losses from investment sales within a date range.

Column Description
Qty Total number of units sold during the period
Average Cost Weighted average cost per unit at the time of disposal. This is the cost basis used to calculate the gain or loss
Total Cost Total cost of the disposed units. Calculated as average cost multiplied by quantity disposed
Consideration Received Total proceeds received from the sale
Realized Gains (Losses) The gain or loss realized on disposal. Calculated as consideration received minus total cost of disposed units. A positive value is a gain; a negative value is a loss

10.4 Unrealized Investment Gains Summary

Navigate to Reports > Unrealized Investment Gains Summary. This report shows the unrealized gains and losses from investment revaluations within a date range, split into opening balance, period movements, and closing balance.

Column Description
Qty Total units held at the end of the period
Market Price Average carrying value per unit (total price including revaluations divided by quantity)
Market Value Total carrying value (cost plus revaluation adjustments)
Average Cost Average cost per unit excluding revaluation adjustments
Total Cost Total cost basis excluding revaluation adjustments
Opening Unrealized Gains/Losses Unrealized gains from revaluations posted before the report's start date
Increments (Decrements) for the Period Unrealized gains from revaluations posted during the report's date range
Closing Unrealized Gains/Losses Total unrealized gains from all revaluations up to the report date. This equals opening + period movements

10.5 Investment Revaluation Worksheet

Navigate to Reports > Investment Revaluation Worksheet. This interactive worksheet helps you determine the revaluation adjustments needed for each investment.

Column Description
Current Value The current carrying value (cost plus any previously posted revaluations) as at the worksheet date
Qty Total units held
Market Price The latest market price per unit (from Investment Market Prices)
Recalculated Value Market price multiplied by quantity
Unrealized Gains The difference between recalculated value and current value. If non-zero, a "New Investment Revaluation" button appears to create the revaluation entry
Interactive Feature: When the worksheet identifies a non-zero unrealized gain, clicking the pre-populated button creates a new Investment Revaluation entry with the correct amounts already filled in for each investment.

10.6 Other Financial Statements

Investment data flows into several other reports:

  • Balance Sheet — shows investments at cost plus market value increment under assets
  • Profit and Loss Statement — shows realized and unrealized gains/losses on investments
  • Trial Balance — includes all investment-related account balances
  • Cash Flow Statement — investment purchases and sales are classified as Investing Activities
  • General Ledger Transactions/Summary — includes all investment-related entries
  • Statement of Changes in Equity — includes investment revaluation gains/losses through profit or loss

11. How Balances Are Calculated

11.1 Average Cost Method

The system uses the weighted average cost method to determine the cost basis of investments. This is calculated as:

Average Cost = Total Cost of All Units ÷ Total Units Held

The average cost is recalculated after every purchase and after every sale:

  • After purchase: New total cost = previous total cost + purchase cost. New total quantity = previous quantity + purchased quantity. Average cost = new total cost ÷ new total quantity.
  • After sale: The cost of disposed units = average cost × quantity sold. Remaining total cost = previous total cost − cost of disposed units. The average cost of remaining units stays the same.
Example:
Purchase 1,000 units @ 50.00 = 50,000.00 total cost
Average cost = 50,000 ÷ 1,000 = 50.00

Purchase 500 units @ 55.00 = 27,500.00 total cost
New total cost = 50,000 + 27,500 = 77,500.00
New total qty = 1,000 + 500 = 1,500
New average cost = 77,500 ÷ 1,500 = 51.67

Sell 300 units:
Cost of sold = 51.67 × 300 = 15,500.00 (rounded)
Remaining cost = 77,500 − 15,500 = 62,000.00
Remaining qty = 1,500 − 300 = 1,200
Average cost stays = 62,000 ÷ 1,200 = 51.67

11.2 Realized Gain/Loss Calculation

When an investment is sold, the system:

  1. Determines the cost of sold units: average cost per unit × quantity sold
  2. Calculates the realized gain or loss: proceeds from sale − cost of sold units
  3. Creates an automatic general ledger entry to recognize the gain or loss in the Realized Capital Gains Profit and Loss account
Realized Gain/Loss = Proceeds − Cost of Sold Units

If proceeds exceed cost = Realized Gain (income)
If cost exceeds proceeds = Realized Loss (expense)

11.3 Unrealized Gain/Loss Calculation

The unrealized gain or loss represents the difference between the current market value and the carrying amount:

Unrealized Gain/Loss = Market Value − Total Cost

Where:
  Market Value = Latest Market Price × Quantity Held
  Total Cost = Sum of all purchase costs − cost of sold units

Unrealized gains are recognized through the Investment Revaluation process, which updates the Balance Sheet Investments Market Value Increment account and the Profit and Loss Unrealized Investment Gains/Losses account.


12. Sample Data and Report Output

Sample Data in Base Currency (BDT)

The following sample data uses base currency (BDT) for all transactions. See the next section for a foreign currency example.

Setup

Item Details
Base Currency BDT (Bangladeshi Taka)
Control Account "Equity Investments" (custom Control Account for Investments)
Default Cost Account "Investments, at cost"
Investment 1 ABC Corporation Shares (Code: ABC-001)
Investment 2 XYZ 5% Bonds 2030 (Code: BOND-XYZ)

Transactions During the Period (01-Jan-2026 to 30-Jun-2026)

Date Type Investment Qty Price/Unit Total Amount Dr/Cr
01-Jan-2026 Opening Balance ABC Corp 1,000 50.00 50,000.00 Dr
01-Jan-2026 Opening Balance XYZ Bonds 200 200.00 40,000.00 Dr
15-Mar-2026 Purchase (Payment) ABC Corp 500 55.00 27,500.00 Dr
01-Apr-2026 Purchase (Payment) XYZ Bonds 100 210.00 21,000.00 Dr
20-Jun-2026 Sale (Receipt) ABC Corp −300 60.00 18,000.00 Cr
30-Jun-2026 Sale (Receipt) XYZ Bonds −50 220.00 11,000.00 Cr

Market Prices (as at 30-Jun-2026)

Investment Market Price per Unit (BDT)
ABC Corporation Shares 62.00
XYZ 5% Bonds 2030 225.00

Calculations — Step by Step

ABC Corporation Shares

Step Calculation Result
After opening balance and purchase Total cost = 50,000.00 + 27,500.00 = 77,500.00
Total qty = 1,000 + 500 = 1,500
Average cost = 77,500.00 ÷ 1,500 = 51.67
1,500 units @ avg 51.67
= 77,500.00
Sale on 20-Jun — cost of sold units 300 units × 51.67 = 15,500.00
(Rounded: 77,500 ÷ 1,500 × 300 = 15,500.00)
Cost: 15,500.00
Sale — realized gain Proceeds: 300 × 60.00 = 18,000.00
Gain = 18,000.00 − 15,500.00 = 2,500.00
Realized Gain: 2,500.00
After sale — remaining position Remaining cost = 77,500.00 − 15,500.00 = 62,000.00
Remaining qty = 1,500 − 300 = 1,200
Average cost = 62,000.00 ÷ 1,200 = 51.67
1,200 units @ avg 51.67
= 62,000.00
Market value (at 62.00 BDT) 1,200 × 62.00 = 74,400.00 Market Value: 74,400.00
Unrealized gain 74,400.00 − 62,000.00 = 12,400.00 Unrealized Gain: 12,400.00

XYZ 5% Bonds 2030

Step Calculation Result
After opening balance and purchase Total cost = 40,000.00 + 21,000.00 = 61,000.00
Total qty = 200 + 100 = 300
Average cost = 61,000.00 ÷ 300 = 203.33
300 units @ avg 203.33
= 61,000.00
Sale on 30-Jun — cost of sold units 50 bonds × 203.33
= 61,000.00 ÷ 300 × 50 = 10,166.67 (rounded)
Cost: 10,166.67
Sale — realized gain Proceeds: 50 × 220.00 = 11,000.00
Gain = 11,000.00 − 10,166.67 = 833.33
Realized Gain: 833.33
After sale — remaining position Remaining cost = 61,000.00 − 10,166.67 = 50,833.33
Remaining qty = 300 − 50 = 250
Average cost = 50,833.33 ÷ 250 = 203.33
250 units @ avg 203.33
= 50,833.33
Market value (at 225.00 BDT) 250 × 225.00 = 56,250.00 Market Value: 56,250.00
Unrealized gain 56,250.00 − 50,833.33 = 5,416.67 Unrealized Gain: 5,416.67

Report Output — Investment Summary (as at 30-Jun-2026)

Investment Qty Avg Cost Total Cost Mkt Price Market Value Unrealized
ABC Corporation Shares 1,200 51.67 62,000.00 62.00 74,400.00 12,400.00
XYZ 5% Bonds 2030 250 203.33 50,833.33 225.00 56,250.00 5,416.67
Total 112,833.33 130,650.00 17,816.67

Calculation verification:

Total Cost:      62,000.00 + 50,833.33 = 112,833.33
Market Value:    74,400.00 + 56,250.00 = 130,650.00
Unrealized:      12,400.00 +  5,416.67 =  17,816.67

Verification:   130,650.00 − 112,833.33 = 17,816.67 ✓

Report Output — Realized Investment Gains Summary (01-Jan-2026 to 30-Jun-2026)

Investment Qty Sold Avg Cost Total Cost Consideration Realized Gain
ABC Corporation Shares 300 51.67 15,500.00 18,000.00 2,500.00
XYZ 5% Bonds 2030 50 203.33 10,166.67 11,000.00 833.33
Total 25,666.67 29,000.00 3,333.33

Calculation verification:

ABC:  Avg cost = 77,500.00 ÷ 1,500 = 51.67
      Cost of sold = 51.67 × 300 = 15,500.00
      Realized gain = 18,000.00 − 15,500.00 = 2,500.00 ✓

XYZ:  Avg cost = 61,000.00 ÷ 300 = 203.33
      Cost of sold = 203.33 × 50 = 10,166.67
      Realized gain = 11,000.00 − 10,166.67 = 833.33 ✓

Total realized gain = 2,500.00 + 833.33 = 3,333.33

Investment Revaluation — Posting the Adjustment

Based on the market prices at 30-Jun-2026, the following unrealized gains are identified:

Investment Market Value Cost Basis Unrealized Gain
ABC Corporation Shares 74,400.00 62,000.00 12,400.00
XYZ 5% Bonds 2030 56,250.00 50,833.33 5,416.67
Total 112,833.33 17,816.67

Revaluation journal entry posted to the general ledger:

Dr  Balance Sheet — Investments, Market Value Increment    17,816.67
    Cr  Profit and Loss — Unrealized Investment Gains          17,816.67
(To record fair value adjustment of investments to market value
 as at 30-Jun-2026)

After revaluation, the Balance Sheet carrying values become:

Investment Cost Market Value Increment Total Carrying Value
ABC Corporation Shares 62,000.00 12,400.00 74,400.00
XYZ 5% Bonds 2030 50,833.33 5,416.67 56,250.00
Total 17,816.67 130,650.00

Report Output — Unrealized Investment Gains Summary (01-Jan-2026 to 30-Jun-2026)

After posting the revaluation entry above:

Investment Qty Carrying Value/Unit Total Carrying Value Avg Cost Total Cost Opening Unrealized Period Movement Closing Unrealized
ABC Corp 1,200 62.00 74,400.00 51.67 62,000.00 0.00 12,400.00 12,400.00
XYZ Bonds 250 225.00 56,250.00 203.33 50,833.33 0.00 5,416.67 5,416.67
Total 130,650.00 112,833.33 0.00 17,816.67 17,816.67

Calculation verification:

ABC:  Carrying value = 62,000.00 + 12,400.00 = 74,400.00
      Carrying value/unit = 74,400.00 ÷ 1,200 = 62.00 ✓
      Closing unrealized = 12,400.00 − 0.00 = 12,400.00 ✓

XYZ:  Carrying value = 50,833.33 + 5,416.67 = 56,250.00
      Carrying value/unit = 56,250.00 ÷ 250 = 225.00 ✓
      Closing unrealized = 5,416.67 − 0.00 = 5,416.67 ✓

Total closing = 12,400.00 + 5,416.67 = 17,816.67 ✓

Report Output — Investment Revaluation Worksheet (as at 30-Jun-2026, before posting revaluation)

Investment Current Value Qty Market Price Recalculated Value Unrealized Gain
ABC Corporation Shares 62,000.00 1,200 62.00 74,400.00 12,400.00
XYZ 5% Bonds 2030 50,833.33 250 225.00 56,250.00 5,416.67
Total 130,650.00 17,816.67

Calculation verification:

ABC:  Current value = 62,000.00 (cost basis)
      Recalculated = 62.00 × 1,200 = 74,400.00
      Unrealized = 74,400.00 − 62,000.00 = 12,400.00 ✓

XYZ:  Current value = 50,833.33 (cost basis)
      Recalculated = 225.00 × 250 = 56,250.00
      Unrealized = 56,250.00 − 50,833.33 = 5,416.67 ✓
Result: The worksheet detects 17,816.67 BDT in unrealized gains. Clicking the "New Investment Revaluation" button creates a pre-populated revaluation entry with these amounts. After posting, the worksheet would show zero unrealized gains (current value equals recalculated value).

Cash Flow Impact

Transaction Cash Flow Category Amount Direction
Purchase of ABC shares (15-Mar) Investing Activities 27,500.00 Outflow
Purchase of XYZ bonds (01-Apr) Investing Activities 21,000.00 Outflow
Sale of ABC shares (20-Jun) Investing Activities 18,000.00 Inflow
Sale of XYZ bonds (30-Jun) Investing Activities 11,000.00 Inflow
Net Cash from Investing Activities −19,500.00

Sample Data with Foreign Currency (USD)

The following scenario demonstrates how the system handles investments denominated in a foreign currency. The same ABC Corporation Shares used in the main sample are now presented with a USD market price to illustrate the foreign currency flow through all reports.

Additional Setup

Item Details
Base Currency BDT (Bangladeshi Taka)
Investment ABC Corporation Shares — purchased in BDT, market price available in USD
Original cost basis 62,000.00 BDT (1,200 shares at average cost 51.67 BDT each — from previous transactions)
Market Price record $62.00 per share, Exchange Rate = 110.00 BDT/USD (not inverse)
Spot rate in Settings > Currency > Exchange Rates 115.00 BDT/USD (may differ from market price exchange rate)
Key Concept: The market price record carries its own exchange rate (110.00 in this example), which can differ from the spot rate in Settings > Currency > Exchange Rates (115.00). The system uses the exchange rate from the market price record for conversion, not the general spot rate.

Market Price Display

The Investments list and Investment Market Prices page display the price in both the original currency and the base currency equivalent:

Market Price column shows:  $62.00 = ৳ 6,820.00

Calculation: $62.00 × 110.00 = 6,820.00 BDT per share

Investment Summary Report (as at 30-Jun-2026)

Investment Qty Avg Cost Total Cost Market Price Market Value Unrealized
ABC Corporation Shares 1,200 51.67 62,000.00 6,820.00 8,184,000.00 8,122,000.00

Calculation:

Market Price per share (converted):  $62.00 × 110.00 = 6,820.00 BDT
Market Value:                         1,200 × 6,820.00 = 8,184,000.00 BDT
Unrealized Gain:                      8,184,000.00 − 62,000.00 = 8,122,000.00 BDT

The unrealized gain of 8,122,000.00 BDT includes TWO components bundled together:
  1. Price appreciation: ($62.00 − $50.17) × 1,200 × 110.00  ≈ 1,561,956 BDT
  2. Exchange rate component: embedded in the conversion at 110.00

  (Where $50.17 ≈ 51.67 BDT ÷ 110.00 is the approximate USD-equivalent cost per share)

There is NO separate "Foreign exchange gain/loss" line for investments.
Per IAS 21 Section 16, investments in equity instruments are NON-MONETARY items.
The entire gain (price change + FX change) flows through the investment gain/loss.

Investment Revaluation Worksheet (as at 30-Jun-2026)

Investment Current Value Qty Market Price Recalculated Value Unrealized Gain
ABC Corporation Shares 8,184,000.00 1,200 6,820.00 8,184,000.00 0.00
Note: The current value (8,184,000.00 BDT) already reflects the revaluation to market price. The worksheet shows zero unrealized gain because the investment has already been revalued. If the revaluation had NOT been posted yet, the current value would show 62,000.00 BDT (cost basis only) and the worksheet would suggest a revaluation of 8,122,000.00 BDT.

Unrealized Investment Gains Summary (01-Jan-2026 to 30-Jun-2026)

Investment Qty Carrying Value/Unit Total Carrying Value Avg Cost Total Cost Opening Period Movement Closing
ABC Corp 1,200 6,820.00 8,184,000.00 51.67 62,000.00 0.00 8,122,000.00 8,122,000.00

Calculation verification:

Carrying value per unit:  8,184,000.00 ÷ 1,200 = 6,820.00 ✓
Closing unrealized:       8,122,000.00 − 0.00 = 8,122,000.00 ✓

Realized Investment Gains Summary (unchanged)

The realized gain calculation is unaffected by the FC market price because realized gains are computed from actual disposal proceeds at the historical exchange rate. The disposal was already processed at the BDT amount before the FC market price was set.

Profit and Loss Statement Impact

After posting the revaluation entry, the P&L shows:

Unrealised investment gains (losses):    8,122,000.00   (Income)
Foreign exchange gains (losses):         Not affected    (investments are non-monetary)
Important — Exchange Rate Missing: If a market price record has a foreign currency set but the exchange rate is missing (zero or empty), the system cannot compute the converted price. In this case:
  • The Investments list shows blank values for Market Value and Unrealized Gains columns
  • The Investment Summary report shows blank values for Market Price, Market Value, and Unrealized Gains
  • The Revaluation Worksheet shows blank values for Recalculated Value and Unrealized Gains
  • No revaluation entry is suggested
This prevents misleading $0 valuations that could lead to incorrect financial statements. Always ensure the exchange rate is entered whenever a foreign currency is selected on a market price record.

Cash Flow Statement Treatment

The purchase and sale of investments in FC appear on the Cash Flow Statement at the amount converted at historical exchange rates. The FC market price does not affect cash flow classification — investments always appear under Investing Activities.


Sample Data with Multi-Period

This scenario extends the sample data into Year 2 to demonstrate.

Year 1 Recap (Period Ended 30-Jun-2026)

Date Event Unrealized Gain Recorded
30-Jun-2026 Revaluation posted: ABC + XYZ marked to market +8,127,416.67

Year 2 Events (01-Jul-2026 to 30-Jun-2027)

Date Event Investment Details
01-Jul-2026 Carried forward ABC Corp 1,200 shares at carrying value 8,184,000.00 BDT
01-Jul-2026 Carried forward XYZ Bonds 250 bonds at carrying value 56,250.00 BDT
31-Dec-2026 Market price increase ABC Corp Market price rises to $68.00 @ rate 115 = 7,820.00 BDT/unit
31-Dec-2026 Market price increase XYZ Bonds Market price rises to 235.00 BDT/unit
15-Jun-2027 Sale of 50 bonds XYZ Bonds 50 bonds sold at 240.00 BDT each = 12,000.00 Cr (realized gain 1,833.33)
30-Jun-2027 New revaluation posted ABC Corp New fair value: 1,200 × 7,820 = 9,384,000.00 BDT
30-Jun-2027 New revaluation posted XYZ Bonds New fair value: 200 × 235 = 47,000.00 BDT

Column-by-Column Calculation

Column ABC Corp XYZ Bonds Formula
Qty 1,200 200 Sum of all quantities from GL transactions
Market Price (carrying/unit) 7,820.00 235.00 Total carrying value ÷ qty
Market Value (total carrying) 9,384,000.00 47,000.00 Sum of all GL amounts (cost + revaluations)
Average Cost 51.67 203.33 Total cost ÷ qty (excluding revaluations)
Total Cost 62,000.00 40,666.66 Sum of all GL amounts excluding revaluation entries
Opening Unrealized 8,122,000.00 5,416.67 Revaluation entries with Date < FromDate
Period Increment 1,200,000.00 916.67 Revaluation entries with Date >= FromDate
Closing Unrealized 9,322,000.00 6,333.34 Total carrying value − total cost

Report Output — Investment Summary (as at 30-Jun-2027)

Investment Qty Avg Cost Total Cost Mkt Price Market Value Unrealized
ABC Corporation Shares 1,200 51.67 62,000.00 7,820.00 9,384,000.00 9,322,000.00
XYZ 5% Bonds 2030 200 203.33 40,666.66 235.00 47,000.00 6,333.34
Total 102,666.66 9,431,000.00 9,328,333.34

Calculation verification:

ABC:  Avg cost = 62,000.00 ÷ 1,200 = 51.67  ✓
      Market value = 1,200 × 7,820.00 = 9,384,000.00  ✓
      Unrealized = 9,384,000.00 − 62,000.00 = 9,322,000.00  ✓

XYZ:  Avg cost = 40,666.66 ÷ 200 = 203.33  ✓
      Market value = 200 × 235.00 = 47,000.00  ✓
      Unrealized = 47,000.00 − 40,666.66 = 6,333.34  ✓

Total: Unrealized = 9,322,000.00 + 6,333.34 = 9,328,333.34  ✓

Report Output — Realized Investment Gains Summary (01-Jul-2026 to 30-Jun-2027)

Investment Qty Sold Avg Cost Total Cost Consideration Realized Gain
XYZ 5% Bonds 2030 50 203.33 10,166.67 12,000.00 1,833.33
Total 10,166.67 12,000.00 1,833.33

Calculation verification:

XYZ Sale: 50 bonds @ 240.00 BDT = 12,000.00 proceeds
  Avg cost before sale = 50,833.33 ÷ 250 = 203.33
  Cost of sold = 203.33 × 50 = 10,166.67  ✓
  Realized gain = 12,000.00 − 10,166.67 = 1,833.33  ✓

After sale — remaining XYZ position:
  Remaining cost = 50,833.33 − 10,166.67 = 40,666.66  ✓
  Remaining qty = 250 − 50 = 200  ✓

Auto-generated entries by the system:
  Synthetic 1 (control account adjustment): Dr 1,833.33
  Synthetic 2 (P&L gain recognition): Cr 1,833.33
  DR = CR: 1,833.33 + (−1,833.33) = 0  ✓

Report Output — Unrealized Investment Gains Summary (01-Jul-2026 to 30-Jun-2027)

Investment Qty Carrying/Unit Total Carrying Avg Cost Total Cost Opening Unrealized Period Increment Closing Unrealized
ABC Corp 1,200 7,820.00 9,384,000.00 51.67 62,000.00 8,122,000.00 1,200,000.00 9,322,000.00
XYZ Bonds 200 235.00 47,000.00 203.33 40,666.66 5,416.67 916.67 6,333.34
Total 102,666.66 8,127,416.67 1,200,916.67 9,328,333.34

Calculation verification:

ABC Corp:
  Opening Unrealized = 8,122,000.00   ← Year 1 revaluation carried forward
  Period Increment   = 9,384,000 − 8,184,000 = 1,200,000.00  ✓
  Closing Unrealized = 8,122,000 + 1,200,000 = 9,322,000.00  ✓
  Cross-check: 9,384,000 − 62,000 = 9,322,000.00  ✓

XYZ Bonds:
  Opening Unrealized = 5,416.67   ← Year 1 revaluation carried forward
  Period Increment   = 47,000 − 46,083.33 = 916.67  ✓
  Closing Unrealized = 5,416.67 + 916.67 = 6,333.34  ✓
  Cross-check: 47,000 − 40,666.66 = 6,333.34  ✓

Total:
  Opening = 8,122,000.00 + 5,416.67 = 8,127,416.67  ✓
  Period  = 1,200,000.00 + 916.67 = 1,200,916.67  ✓
  Closing = 9,322,000.00 + 6,333.34 = 9,328,333.34  ✓

Report Output — Investment Revaluation Worksheet (as at 30-Jun-2027, before posting revaluation)

Investment Current Value Qty Market Price Recalculated Value Unrealized Gain
ABC Corporation Shares 8,184,000.00 1,200 7,820.00 9,384,000.00 1,200,000.00
XYZ 5% Bonds 2030 46,083.33 200 235.00 47,000.00 916.67
Total 9,431,000.00 1,200,916.67

Calculation verification:

ABC:  Current value = 62,000 (cost) + 8,122,000 (Year 1 reval) = 8,184,000
      Recalculated = 1,200 × 7,820 = 9,384,000
      Unrealized = 9,384,000 − 8,184,000 = 1,200,000  ✓

XYZ:  Current value = 40,666.66 (cost) + 5,416.67 (Year 1 reval) = 46,083.33
      Recalculated = 200 × 235 = 47,000
      Unrealized = 47,000 − 46,083.33 = 916.67  ✓

Total unrealized = 1,200,000.00 + 916.67 = 1,200,916.67  ✓
Worksheet Button: The Revaluation Worksheet detects 1,200,916.67 BDT in total unrealized gains. Clicking "New Investment Revaluation" creates a pre-populated revaluation entry with:
  • ABC Corp: 1,200,000.00 unrealized gain
  • XYZ Bonds: 916.67 unrealized gain
After posting, the Closing Unrealized in the Unrealized Gains report matches the new fair values.

What Happened to Each Investment — Year 2 Summary

Item 30-Jun-2026 (After Year 1) 30-Jun-2027 (After Year 2) Change
ABC — carrying value 8,184,000.00 9,384,000.00 +1,200,000.00
ABC — unrealized gain 8,122,000.00 9,322,000.00 +1,200,000.00
XYZ — qty 250 200 −50 (sold)
XYZ — realized gain 1,833.33 +1,833.33
XYZ — carrying value 56,250.00 47,000.00 −9,250.00
XYZ — unrealized gain 5,416.67 6,333.34 +916.67
Total unrealized 8,127,416.67 9,328,333.34 +1,200,916.67

13. Key Considerations

  • Market prices must be entered before running reports that show market values. The Investment Summary and Revaluation Worksheet reports depend on up-to-date market prices.
  • Quantity must be entered for opening balances on investment accounts. If quantity is left as zero, the opening balance amount is still posted to the general ledger but the investment position will not track the quantity.
  • Sales trigger automatic gain/loss calculation based on the weighted average cost method. The system posts the realized gain or loss automatically — no manual journal entry is needed.
  • Revaluations are optional but recommended for fair value accounting. The Investment Revaluation Worksheet helps identify whether a revaluation is needed.
  • Investment transactions appear under Investing Activities on the Cash Flow Statement, distinguishing them from operating and financing activities per IAS 7.
  • Custom control accounts allow grouping investments by type (e.g., equities, bonds, real estate) for separate presentation on the Balance Sheet.
  • Average cost is recalculated after every purchase and sale. Each transaction updates the running average cost per unit.

14. Accounting Regulation Compliance

14.1 IFRS 9 — Financial Instruments

Requirement (§4.1-4.4): Financial assets are classified based on the business model and contractual cash flow characteristics. Equity instruments are measured at fair value through profit or loss (FVTPL) or fair value through other comprehensive income (FVTOCI).

How this system complies: The system supports fair value measurement by enabling users to record market prices and post revaluation entries. Unrealized gains and losses are recognized through profit or loss, consistent with the FVTPL classification. The realized gains and losses on disposal are automatically calculated and posted.

14.2 IAS 32 — Financial Instruments: Presentation

Requirement (§15-18): Financial assets and liabilities must be classified and presented appropriately in the financial statements.

How this system complies: Investments are classified as assets on the Balance Sheet. The cost component and the market value increment component are presented separately, providing transparency about the original cost and the revaluation adjustment.

14.3 IAS 7 — Statement of Cash Flows

Requirement (§16): Investing activities include the acquisition and disposal of long-term assets and other investments.

How this system complies: All investment purchases and sales are classified as Investing Activities on the Cash Flow Statement. The investment accounts carry a Cash Flow Statement Investing Activity Group classification that determines their placement in the cash flow report.

14.4 IFRS 13 — Fair Value Measurement

Requirement (§93): Fair value measurements must be determined using market-based inputs where available.

How this system complies: The system uses actual market prices entered by the user (Level 1 inputs in the fair value hierarchy) when calculating market values and unrealized gains. The Investment Revaluation Worksheet provides a systematic process for determining and recording fair value adjustments.

14.5 IAS 1 — Presentation of Financial Statements

Requirement (§54): Investment property and financial assets must be presented separately on the face of the Balance Sheet.

How this system complies: Investments appear as a separate line item on the Balance Sheet through their dedicated control account. The cost and market value increment are distinguishable, providing the disaggregated presentation required by IAS 1.

14.6 DR = CR Verification for Key Transactions

Example 1: Purchase of 500 ABC shares @ 55.00
  Dr  Investments — ABC Corp (Control Account)    27,500.00
      Cr  Bank Account                                27,500.00
  Sum: +27,500.00 + (−27,500.00) = 0 ✓

Example 2: Sale of 300 ABC shares @ 60.00 + auto realized gain
  Dr  Bank Account                                  18,000.00
      Cr  Investments — ABC Corp (Control Account)    18,000.00

  Auto-generated (cost adjustment):
  Dr  Investments — ABC Corp (Control Account)       2,500.00
      Cr  P&L — Realized Capital Gains                  2,500.00

  Combined effect on control account:
  −18,000.00 + 2,500.00 = −15,500.00 (cost of sold ✓)
  Sum: +18,000.00 + (−18,000.00) + 2,500.00 + (−2,500.00) = 0 ✓

Example 3: Revaluation adjustment
  Dr  BS — Investments, Market Value Increment       17,816.67
      Cr  P&L — Unrealized Investment Gains             17,816.67
  Sum: +17,816.67 + (−17,816.67) = 0 ✓

14.7 Relevant but Not Applicable

  • IFRS 15 (Revenue): Investment transactions are capital in nature, not revenue transactions. Gains and losses are classified as investing activities, not operating revenue.
  • IAS 16 (Property, Plant and Equipment): Investments are financial assets, not tangible fixed assets. They follow IFRS 9 measurement rules, not IAS 16.
  • NBR VAT Act 2012: Investment transactions involve financial instruments, not goods or services. They are generally outside the scope of VAT and the system correctly does not apply tax codes to investment control account lines.

End of Investments Guide