Export Transaction Logs

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:

	<tr id="471365f6-b8f3-43da-8357-451695923888">

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Column

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Transaction ID

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Affected Vault ID

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Affected Vault Name

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Affected Address
Name

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Affected Address ID

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Affected Vault
Address

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Chain

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Creation Time

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Created By (Name)

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Created By (Email)

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Blockchain Mine Time

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Transaction Source
Address

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Transaction Source
Name

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Transaction Destination
Address

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Transaction Destination
Name

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Transaction Hash

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Effect Type

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Effect Number

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Token Name

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Token ID

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Token Ticker

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Amount in base units
(Crypto)

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Amount in crypto

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Decimals

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Token address

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Token price at mined time

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

USD value at mined
time

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Effect source address

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Effect source name

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Effect destination address

		<th id="ec?&lt;" class="simple-table-header-color simple-table-header">

Effect destination
Name

`<strong>Bitcoin</strong>`	`<strong>EVM</strong>`	`<strong>Solana</strong>`	`<strong>Cosmos</strong>`
Transaction ID	Transaction ID	Transaction ID	Transaction 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.
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
The name of the address or leave empty for Account based chains.	Empty	Empty	Empty
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
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.
Bitcoin	The name of the chain	Solana	Cosmos or the name of the app-chain.
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.
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
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
Transaction mine time in the blockchain.	Transaction mine time in the blockchain.	Transaction mine time in the blockchain.	Transaction mine time in the blockchain.
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
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).
Empty	The destination blockchain address of the transaction	Empty	Empty
Empty	By this order: * Vault name * Contact name * Dapp name	Empty	Empty
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
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 `Credit` Fees	Effect Type: 1. Credit 2. Debit 3. Fees	Effect Type: 1. Credit 2. Debit 3. Fees	Effect Type: 1. Credit 2. Debit 3. Fees
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
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
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
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
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 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.
The decimals of the token	The decimals of the token	The decimals of the token	The decimals of the token
	The ID of the NFT token
Price in USD	Price in USD	Price in USD	Price in USD
Amount transferred in USD	Amount transferred in USD	Amount transferred in USD	Amount transferred in USD
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
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
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.
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