Transaction Properties Reference

Below you will find a list of transaction properties you can choose when mapping CSV columns when importing custom files.

TransactionsCopy

• Date: Date & Time of the transaction

• Time: Time of the transaction. Used when it's a separate column. Overrides the time in Date

• Account: Account this transaction belongs to

• Asset: Asset this transaction is about

• Type: Type of Transaction

• Quantity: Transacted quantity (for Buy, Sell, Transfer) or date's balance (for Account Balance)

• Quantity (Buy or Sell): Sets two properties at once - Quantity and Type. If the value is positive - a Buy is created, when negative - it's a Sell

• Price: Transacted price per share (for Buy, Sell, Transfer) or income per share (for Dividend, Interest, Rent)

• Value: Monetary value of the transaction. Can be used instead of the Price (Price will be calculated)

• Fee: Fees paid

• Tax Paid: eg. Withholding Tax (WHT)

• Transaction Tags: Tags applied to the transaction (not to the Asset or Account)

• Note: Notes in markdown format

• Fee currency: Currency of the Fee (defaults to Asset's currency)

• Value currency: Currency of the Value (defaults to Asset's currency)

• Value & Fee currency: Currency of both Fee and Value

• Tags

• Unconfirmed

• Reference: Transaction's reference ID (eg. broker's transaction ID)

Dividends onlyCopy

• Dividend Payment Date: Date when dividend was paid out to you. The transaction's Date becomes the dividend's execution date if this is provided.

• Div Income as Quantity: If dividend was reinvested or was paid out in shares - the amount of shares reinvested or received

• Div Income as Residual Cash: If dividend was reinvested or was paid out in shares - the residual cash you received

AssetsCopy

• Type: Asset type is required

• Name

• Currency: Main asset's currency. Required

• Symbol

• ISIN

• Icon

• Market

• Country

• Tags

• Market Data Source: Market symbol used for pricing and dividend information

• Price Interpolation: Should prices for dates without values be interpolated linearly between adjacent dates (common for real estate, interest-based assets), or should the last available date be used instead (common for market-traded assets)?

AccountsCopy

• Name

• Country

• Icon

• Tax Preset

• Tags