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 |
