Investments
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
- What Are Investments?
- Enabling the Investments Tab via Customize Menu
- System Accounts Setup
- Field-by-Field Guide for Creating an Investment
- Field-by-Field Guide for Investment Revaluation
- Settings Configuration
- Opening Balances for Investments
- Recording Investment Transactions
- Investment Revaluation
- Reports
- How Balances Are Calculated
- Sample Data and Report Output
- Key Considerations
- 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
2. Enabling the Investments Tab via Customize Menu
To make the Investments section visible in the navigation bar:
- Open the Customize Menu by clicking the customize button on the top-right of the navigation bar
- Find "Investments" in the list of available tabs
- Toggle it to Visible
- 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
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. |
- Debit or Credit the Balance Sheet Investments Market Value Increment account (adjusts the carrying value on the Balance Sheet)
- Credit or Debit the Profit and Loss Unrealized Investment Gains/Losses account (recognizes the gain or loss on the Profit and Loss Statement)
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. |
7. Opening Balances for Investments
To set the opening balance for an investment at the start of a financial year:
- Navigate to Settings > Opening Balances
- Click Add
- Select an account that has investments enabled (a Control Account for Investments or the Balance Sheet Investments at Cost Account)
- The Investment field appears — select the specific investment
- The Quantity field appears — enter the number of shares, bonds, or units held
- Enter the Amount and Debit/Credit direction (Dr for asset increases, Cr for asset decreases)
- If the investment is in a foreign currency, select the Currency and enter Amount in Currency and Exchange Rate
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:
- Go to Receipts > Add (or Payments > Add depending on the flow of funds)
- Select the bank account from which the funds are drawn
- On a transaction line, select an account that Is Control Account for Investments (the control account or the "Investments, at cost" default)
- The Investment field appears — select the specific investment being purchased
- Enter the Quantity of shares/bonds/units being purchased
- Enter the Total Amount (price × quantity, including any brokerage fees or transaction costs)
- Complete and save the receipt
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:
- Go to Receipts > Add (cash received from sale)
- Select the bank account that receives the proceeds
- On a transaction line, select the same investment control account
- The Investment field appears — select the investment being sold
- Enter the Quantity as a negative number (indicating reduction)
- Enter the Total Amount (proceeds received)
- Complete and save the receipt
- 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
- Record market prices — Enter current market prices via Settings > Investment Market Prices
- 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
- 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
- Verify impact — Check the Unrealized Investment Gains Summary report to confirm the revaluation has been recorded correctly
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 |
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.
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:
- Determines the cost of sold units: average cost per unit × quantity sold
- Calculates the realized gain or loss: proceeds from sale − cost of sold units
- 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 ✓
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) |
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 |
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)
- 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
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 ✓
- ABC Corp: 1,200,000.00 unrealized gain
- XYZ Bonds: 916.67 unrealized gain
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