Transaction Properties Reference

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

Transactions

• 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

• Cash tracking: Whether cash should be tracked or not (defaults to tracking)

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

Dividends only

• 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

Interest only

• Amortized Quantity: Quantity to be repaid along with the interest (positive for investments and negative for liabilities)

Convert/Move only

• Target Asset: Asset to convert to (if not set, it will be a move)

• Target Account: Account to convert/move to

• Target Quantity: Quantity to convert to (if not set, it will be the same as Quantity)

Assets

• 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)?

Accounts

• Name

• Country

• Icon

• Tax Preset

• Tags