Transaction fields exported to CSV

When you export a collection of address or account transactions, you will get a CSV file with these values for each transaction:

Field Description Type
txn_id The internal transaction ID number numeric
portfolio_id The internal portfolio ID which owns this account/address numeric
address_id The internal address ID numeric
account_id The internal account ID numeric
wallet The name of the account wallet, e.g. "bitstamp" string
address_currency The name of the address currency, e.g. "btc" string
txn_at The time that the transaction occurred, in UTC time
txn_type The transaction type, e.g. "transfer" string
currency The currency of the transaction, e.g. "btc" string
delta The transaction value; positive if incoming, negative if outgoing decimal
fee The value of the fee, if any, in the currency of the txn decimal or empty
reference The external reference. This may be the cryptocurrency transaction hash, or an exchange internal reference. Multiple identical references may be connected, e.g. a trade from one currency to another. string or empty
comment User-defined comment. string or empty
source The key of the source used to construct this transaction, e.g. "blocktrail" string or empty
updated_at When this transaction was last updated by CryptFolio, in UTC time
valuation The defined valuation of the transaction, if any. decimal or empty
valuation_currency The currency used in the defined valuation of the transaction, if any. string or empty

This exported list of transactions can also be imported back into CryptFolio.

Converted columns

If you're also converting each transaction into another target currency, you'll also get these following columns. If a transaction or balance could not be converted - for example, there was not enough historical exchange data - the fields will be empty.

Field Description Type
converted_currency The target currency that the transaction has been converted into, e.g. "nzd". string
converted_delta The transaction value in the target currency. Equals delta * converted_rate. decimal or empty
converted_rate The composite rate used to convert the source currency (currency) into the target currency (converted_currency). decimal or empty
converted_date The date that the composite rate is from (see exchanges_used), in UTC. Rates are selected from the close value of daily tickers (00:00 UTC to 23:59 UTC) on the date of the transaction. time or empty
exchanges_used A helpful summary of the exchanges used to generate the composite rate, e.g. "coinbase: usd -> nzd, bitstamp: btc -> usd". string or empty
balance_before The balance of this account, ONLY in the source currency, before this transaction was applied, converted into the target currency. Equals (previous_balance - delta) * converted_rate. decimal or empty
balance_currency Equals converted_currency. string or empty
balance_rate Equals converted_rate. decimal or empty
balance_date Equals converted_date. time or empty
balance_exchanges_used Equals exchanges_used. string or empty
balances_sum_before The balance of this account, in ALL currencies, before this transaction was applied, converted into the target currency. decimal or empty
balances_sum_currency Equals converted_currency. string
balances_sum_date The latest time used to generate the composite rate (see balances_sum_exchanges_used), in UTC. This should always be on the same day as converted_date, but may have a later time. time or empty
balances_sum_exchanged_used A helpful summary of the exchanges used to generate the composite rate, e.g. "coinbase: ltc -> btc, coinbase: usd -> nzd, bitstamp: btc -> usd". string or empty
used_valuation Whether this transaction used a defined valuation in the process of calculating the transaction value. boolean
Was this article helpful?
1 out of 1 found this helpful