Skip to main content

​
Overview

Transactions are the foundation of InvestSync’s daily valuation engine. Every buy, sell, dividend, interest payment, fee, or revaluation you record automatically triggers a recomputation of the investment’s daily time series, ensuring your portfolio valuations are always up to date.

​
Transaction Types

InvestSync supports the following transaction types:
  • Buy: Purchase transactions with units, price, fees, and taxes
  • Sell: Sale transactions with automatic cost basis calculation
  • Dividend: Dividend payments received
  • Interest: Interest payments from bonds or deposits
  • Fee: Management fees, transaction fees, or other charges
  • Other: Miscellaneous transactions
  • Revaluation: Manual market value adjustments (useful for unlisted investments)

​
Recording Transactions

​
From an Investment Detail Page

  1. Navigate to Investments and select an investment
  2. Click “Add Transaction” on the investment detail page
  3. Fill in the transaction details:
    • Date: Transaction date
    • Type: Select from Buy, Sell, Dividend, Interest, Fee, Other, or Revaluation
    • Units: Number of shares/units (for Buy/Sell transactions)
    • Price: Price per unit
    • Currency: Transaction currency
    • Fees: Any transaction fees
    • Taxes: Any applicable taxes
    • Broker: Optional broker information
    • Notes: Additional context or reference numbers
  4. Click “Save” - daily valuations update automatically

​
From the Transactions Page

  1. Navigate to Investments > Transactions from the main menu
  2. Click “Add Transaction”
  3. Select the investment this transaction relates to
  4. Fill in the transaction details as above
  5. Save the transaction

​
Automatic Daily Valuation Updates

When you record a transaction, InvestSync automatically:
  1. Recomputes the daily time series for that investment from the transaction date forward
  2. Fetches historical prices from Yahoo Finance (for listed investments with tickers)
  3. Applies FX conversion using Frankfurter rates to convert to your organisation’s reporting currency
  4. Calculates metrics:
    • Market value (units × price × FX rate)
    • Cost basis (including fees and taxes)
    • Unrealised gains/losses
  5. Updates all dashboards and reports with the new data
The daily valuation engine processes transactions deterministically, ensuring consistent calculations across your portfolio. Each transaction affects the investment’s position and cost basis going forward.

​
Transaction History

View the complete transaction history for any investment:
  1. Navigate to an investment’s detail page
  2. Scroll to the Transactions section
  3. See all transactions listed chronologically with:
    • Date and type
    • Units and price
    • Total value
    • Fees and taxes
    • Broker information
    • Notes

​
Editing and Deleting Transactions

​
Editing Transactions

  1. Navigate to the investment’s detail page
  2. Find the transaction in the Transactions section
  3. Click “Edit” on the transaction
  4. Make your changes
  5. Save - the daily time series will be recomputed automatically
Editing a transaction will recompute the entire daily time series from that transaction’s date forward. This may affect all subsequent valuations and reports.

​
Deleting Transactions

  1. Navigate to the investment’s detail page
  2. Find the transaction in the Transactions section
  3. Click “Delete” on the transaction
  4. Confirm the deletion
  5. The daily time series will be recomputed automatically
Deleting a transaction will remove it from the investment’s history and recompute all daily valuations. This action cannot be undone.

​
AI-Powered Transaction Extraction

Instead of manually entering transactions, you can use AI to extract them from documents:
  1. Upload a document (PDF format) to an investment or to the Documents section
  2. Analyse the document using the AI document processor
  3. Review extracted transactions - AI will identify:
    • Transaction date
    • Type (Buy, Sell, Dividend, etc.)
    • Units and price
    • Currency
    • Fees and taxes
    • Broker details
  4. Review and correct any extracted data
  5. Attach to investment - the transaction is posted and daily valuations update
AI extraction saves time but always review extracted data for accuracy before posting transactions.

​
Best Practices

1

Record Promptly

Record transactions as they occur to maintain accurate daily valuations
2

Include All Details

Enter fees, taxes, and broker information for complete records and accurate cost basis calculation
3

Use Consistent Dates

Use the actual transaction date, not the settlement date, for accurate time series
4

Review Regularly

Periodically review transaction history to ensure accuracy and catch any errors early
5

Link Documents

Upload supporting documents (statements, confirmations) and link them to transactions for audit trails

​
Transaction Filters

On the Transactions page, you can filter transactions by:
  • Investment: View transactions for a specific investment
  • Type: Filter by transaction type (Buy, Sell, Dividend, etc.)
  • Date Range: Filter by transaction date
  • Entity: View transactions for investments owned by a specific entity
  • Category: View transactions for investments in a specific category

​
Exporting Transaction Data

You can export transaction data for accounting or analysis:
  1. Navigate to Investments > Transactions
  2. Apply any desired filters
  3. Click “Export”
  4. Choose format: Excel, CSV, or PDF
  5. The export includes all transaction details including dates, types, amounts, fees, taxes, and broker information
All transaction data is stored securely and is included in your organisation’s audit trail. Transactions cannot be permanently deleted, only marked as inactive for compliance purposes.