Investment Management

​

Overview

Investment Management is the core of InvestSync, allowing you to track all your investments across different asset classes, currencies, and entities. Each investment automatically maintains a daily time series of positions, market value, cost basis, and unrealised gains, all converted to your organisation’s reporting currency.

​

Key Capabilities

​

Listed and Unlisted Investments

InvestSync supports both listed and unlisted investments:

• Listed Investments: Stocks, ETFs, bonds with ticker symbols
  • Automatic price fetching from Yahoo Finance
  • Historical price data for accurate valuations
  • Real-time market quotes
• Unlisted Investments: Private equity, property, direct investments
  • Manual price entry or revaluations
  • Flexible valuation methods
  • Support for alternative asset classes

​

Daily Valuation Engine

When you record a transaction, InvestSync automatically:

1. Recomputes the daily time series for that investment
2. Fetches historical prices from Yahoo Finance (for listed investments)
3. Applies FX conversion using Frankfurter rates
4. Calculates market value, cost basis, and unrealised gains
5. Updates all dashboards and reports

​

Transaction Types

For each investment, you can record various 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)

​

Getting Started

​

Adding Investments

1. Navigate to Investments in the main menu
2. Click “Add Investment”
3. Fill in the investment details:
   • Name: Investment name (e.g., “Apple Inc.”)
   • Ticker: Stock symbol (e.g., “AAPL”) - optional for listed investments
   • Short Code: Optional identifier for quick reference
   • Category: Select from your configured categories
   • Subcategory: Optional, for more granular classification
   • Entity: Which entity owns this investment
   • Listed: Toggle for listed vs unlisted investments

​

Recording Transactions

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

​

Viewing Investment Details

Each investment has a comprehensive detail page showing:

• Value Over Time: Chart showing market value, cost basis, and unrealised gains over time
• Holding Metrics: Current position, average cost, latest market value
• Latest Snapshot: Most recent daily valuation data
• Entity Details: Which entity owns this investment
• Transactions: Complete transaction history
• Documents: Linked investment documents
• Tags: Investment tags for filtering and organisation

​

Document Management

​

Uploading Documents

1. Navigate to an investment’s detail page
2. Go to the Documents section
3. Click “Upload Document” and select your PDF file
4. Documents are securely stored in S3 with organisation-level access controls

​

AI Document Processing

InvestSync uses AI to automatically process uploaded documents:

1. Document Classification: AI classifies documents as:
   • Transaction
   • Statement
   • Corporate Action
   • Event
   • Newsletter
   • Other
2. Transaction Extraction: For transaction documents, AI extracts:
   • Date
   • Currency
   • Units
   • Price
   • Fees
   • Taxes
   • Broker details
3. Review and Post: Review the extracted data, make any necessary corrections, and attach transactions to investments. Daily valuations update automatically.

​

Organisation Dashboard

The organisation dashboard provides a high-level view of all investments:

• Total Market Value: Sum of all investment market values in reporting currency
• Total Cost Basis: Sum of all investment cost bases
• Unrealised Gains: Total unrealised gains/losses
• Period Change: Performance change over selected time period
• Top Holdings: Investments with highest market value
• Category Breakdown: Allocation across investment categories
• Currency Exposure: Breakdown by investment currency

​

Filtering and Tagging

• Filter by Entity, Category, Subcategory, Listed Status
• Filter by investment tags for custom dimensions
• Combine multiple filters for focused analysis
• Clear visual indicators for active filters

​

Investment Dashboard

Each investment has its own dashboard showing:

• Value Over Time Chart: Visual representation of market value, cost basis, and unrealised gains
• Current Position: Latest snapshot with position size, average cost, market value
• Performance Metrics: Period change, returns, and other key metrics
• Transaction History: Complete list of all transactions
• Linked Documents: All documents associated with this investment
• Entity Information: Details about the owning entity

​

AI Assistant

The AI Assistant provides natural-language summaries of your investments:

• Organisation Overview: Summary of recent performance and top holdings
• Investment Insights: Analysis of individual investment performance
• Quick Reporting: Generate summaries for stakeholders in NZ English

Click the assistant icon on any dashboard to get instant insights.

​

Best Practices

​

Integrations

​

Market Data

• Yahoo Finance: Live and historical prices for listed investments
• Frankfurter: FX rates for currency conversion

​

Accounting

• Xero: Connect your Xero accounting software to sync chart of accounts and map investments to accounting entries. See the Xero Integration documentation for details.