Export Transaction Logs
You can download a log showing all the completed transactions that were made in the organization."
Transaction logs can be useful in performing risk analysis, reconciling your company's expenses, and more.
Crypto ecosystems
Currently, Fordefi supports logs for transactions done in the following crypto ecosystems: Bitcoin, EVM, Solana, and Cosmos.
Download a transaction log for the organization
Open the Fordefi web console.
In the side menu, click Transactions.
The Transactions screen opens, displaying the default All tab and a list of all transactions.Apply filters, as required.
Click Export in the upper right corner.
The transactions that correspond to the filters you have set are downloaded in a .csv file.
Understand the transaction log
The transaction log is a spreadsheet that you can sort and filter. The log is structured so that each line displays a single effect on a vault's balance. Several lines can thus make up a single transaction. For example:
Here is a description of the columns in the .csv file, depending on the ecosystem in which the transactions were performed:
| Column | Bitcoin | EVM | Solana | Cosmos |
|---|---|---|---|---|
| Transaction ID | Transaction ID | Transaction ID | Transaction ID | Transaction ID |
| Affected Vault ID | - Incoming: The affected vault ID of the receiving address - Outgoing: The affected vault ID of the source address Internal: There are two entries in the report - each vault on its own line. | - Incoming: The affected vault ID of the receiving address - Outgoing: The affected vault ID of the source address Internal: There are two entries in the report - each vault on its own line | - Incoming: The affected vault ID of the receiving address - Outgoing: The affected vault ID of the source address Internal: There are two entries in the report - each vault on its own line. | - Incoming: The affected vault ID of the receiving address - Outgoing: The affected vault ID of the source address Internal: There are two entries in the report - each vault on its own line. |
| Affected Vault Name | - Incoming: The receiving vault name - Outgoing: The source vault name Internal: There are two entries in the report - each vault on its own line. | - Incoming: The receiving vault name - Outgoing: The source vault name Internal: There are two entries in the report - each vault on its own line. | - Incoming: The receiving vault name - Outgoing: The source vault name Internal: There are two entries in the report - each vault on its own line | - Incoming: The receiving vault name - Outgoing: The source vault name Internal: There are two entries in the report - each vault on its own line |
| Affected Address Name | The name of the address or leave empty for Account based chains. | Empty | Empty | Empty |
| Affected Address ID | Since each row is per input or output, there can be only a single address, hence here we will put the address ID. | Empty | Empty | Empty |
| Affected Vault Address | The receiving of the output for incoming transactions or the source address of the input for managed transactions | The address of the Vault | The address of the Vault | The address of the chain of that transaction. |
| Chain | Bitcoin | The name of the chain | Solana | Cosmos or the name of the app-chain. |
| Creation Time | Time of the creation of the transaction on the platform. | Time of the creation of the transaction. For incoming, the mined time of the tx block. | Time of the creation of the transaction. For incoming, the mined time of the tx block. | Time of the creation of the transaction. For incoming, the mined time of the tx block. |
| Created By (Name) | Name of the user creating the transaction | Name of the user creating the transaction, empty for incoming | Name of the user creating the transaction | Name of the user creating the transaction |
| Created By (Email) | The email of the user that signed the transaction, empty for incoming | The email of the user that signed the transaction, empty for incoming | The email of the user that signed the transaction, empty for incoming | The email of the user that signed the transaction, empty for incoming |
| Blockchain Mine Time | Transaction mine time in the blockchain. | Transaction mine time in the blockchain. | Transaction mine time in the blockchain. | Transaction mine time in the blockchain. |
| Transaction Source Address | Empty | The signer of the transaction blockchain address | The signer of the transaction blockchain address. In case of multiple signers, concatenation of those with , in between. | The signer of the transaction blockchain address |
| Transaction Source Name | Empty | The signer of the transaction address name if exists (on Fordefi's platform, that is, vault name or address book name). | The signer of the transaction address name if exists (on Fordefi's platform, that is, vault name or address book name). | The signer of the transaction address name if exists (on Fordefi's platform, that is, vault name or address book name). |
| Transaction Destination Address | Empty | The destination blockchain address of the transaction | Empty | Empty |
| Transaction Destination Name | Empty | By this order: * Vault name * Contact name * Dapp name | Empty | Empty |
| Transaction Hash | The hash of the transaction on the blockchain | The hash of the transaction on the blockchain | The hash of the transaction on the blockchain | The hash of the transaction on the blockchain |
| Effect Type | For managed transaction: - Input is Debit- Any output that goes to a vault in the same org or a change output is Credit- For incoming transactions: - Output is CreditFees | Effect Type: 1. Credit 2. Debit 3. Fees | Effect Type: 1. Credit 2. Debit 3. Fees | Effect Type: 1. Credit 2. Debit 3. Fees |
| Effect Number | First counting inputs then outputs | The index number of the balance effect in regard to the same tx_id/tx hash | The index number of the balance effect in regard to the same tx_id/tx hash | |
| Token Name | Bitcoin | The name of the token transferred in the current effect | The name of the token transferred in the current effect | The name of the token transferred in the current effect |
| Token ID | The internal ID of the BTC transferred | The internal ID of the token transferred | The internal ID of the token transferred | The internal ID of the token transferred |
| Token Ticker | BTC | The ticker (symbol) of the token transferred in the current effect | The ticker (symbol) of the token transferred in the current effect | The ticker (symbol) of the token transferred in the current effect |
| Amount in base units (Crypto) | Crypto amount transferred in base asset. | Crypto amount transferred in base asset. | Crypto amount transferred in base asset. | Crypto amount transferred in base asset. |
| Amount in crypto | Amount in the principal asset, that is, ETH, USDC, or BTC. | Amount in the principal asset, that is, ETH, USDC, or BTC. | Amount in the principal asset, that is, ETH, USDC, or BTC. | Amount in the principal asset, that is, ETH, USDC, or BTC. |
| Decimals | The decimals of the token | The decimals of the token | The decimals of the token | The decimals of the token |
| Token address | The ID of the NFT token | |||
| Token price at mined time | Price in USD | Price in USD | Price in USD | Price in USD |
| USD value at mined time | Amount transferred in USD | Amount transferred in USD | Amount transferred in USD | Amount transferred in USD |
| Effect source address | - Only for outgoing: the address the used input was sent to. - Nothing for output - Not address of incoming transactions | Source of the transfer effect | Source of the transfer effect | Source of the transfer effect |
| Effect source name | The name of the address according to the resolution described above | The name of the address according to the resolution described above | The name of the address according to the resolution described above | The name of the address according to the resolution described above |
| Effect destination address | - Input: Nothing - Output: The destination of this output | The address from/to of the transfer effect (like in Etherscan) Empty for fee effect. | The address from/to of the transfer effect (like in Etherscan) | The address from/to of the transfer effect (like in Etherscan). Empty for fee efect. |
| Effect destination Name | The name of the address according to the resolution described above | The name of the address according to the resolution described above | The name of the address according to the resolution described above | The name of the address according to the resolution described above |