How to export my transactions as a CSV file?

How to create a backup of all my transactions?

The download button for your transaction history can be found under the menu item Transactions.
As you can see in the picture below, you can download a backup of your transactions for each tax year.


A valid Blockpit license is required per tax year to download your transactions.


Can the transaction export be used for proofs of funds?

Common proofs of funds are tax reports, screenshots of your exchange and wallet transactions, and if necessary a more detailed description of your transaction history.
The more evidence you can provide to your exchange, bank or tax authority, the better.

Just download the corresponding transaction histories in Blockpit and attach them as evidence. It is also recommended to submit the CSV or Excel format as a PDF document.

Note, however, that a correct evidence base is always a complete transaction history (no missing, duplicate or incorrect transactions). A good indicator for this is a transaction list without displayed warnings.


What data is included in the exported CSV file?

The CSV file contains all transactions of the selected tax year.

The transaction export is not directly comparable to the CSV/Excel import, which is available for uploading data to a Blockpit depot.
Individual columns such as Transaction timestamp, Account, Inflow asset, Inflow amount, Outflow asset, Fee asset, Fee amount, Transaction type and Note can be used specifically for the upload via CSV/Excel import though.

Also transactions that have been manually excluded from the tax report, as shown in the image below, will not be exported.



The following transaction details are provided via the export:

Blockpit ID: Enables the ranking of individual transactions by IDs.
Transaction timestamp: Enables the ranking of individual transactions by timestamp (UTC).

Source ID: If available, the internal transaction ID of the exchange or the public transaction hash of the wallet is displayed here.
Data source: Describes the type of Import or depot in the form of the exchange- or wallet name. Unsynced accounts are marked as manual.
Data source ID: Blockpit Interface ID.

Account: Designation or name of your depot.
Account ID: Unique Depot ID.

Inflow asset: Short name of the incoming asset (ticker).
Inflow asset ID: Blockpit Asset-ID.
Inflow amount: Total amount of the incoming asset (total Amount).
Inflow value (EUR): Value of the incoming asset amount in euros.

Outflow asset: Short name of the outgoing asset (ticker).
Outflow asset ID: Blockpit Asset-ID.
Outflow amount: Total amount of the outgoing asset (total Amount).
Outflow value (EUR): Value of the outgoing asset amount in euros.

Fee asset: Short name of the outgoing fee asset (ticker).
Fee asset ID: Blockpit Asset-ID.
Fee amount: Total amount of the outgoing fee asset (total Amount).
Fee value (EUR): Value of the outgoing fee asset in euros.

Transaction type:
Type of transaction
Transaction type ID:
Blockpit Asset-ID.
Transaction Note.
Linked transaction ID:
Enables tracing of linked transactions by transaction ID.

Inflow/Outflow and Fee values (EUR) are based on price data that are independent of the tax report and should therefore not be used for direct comparison between tax report and CSV export.


Example of exported transaction list (Excel):

Table part 1:


Table part 2:OUT.jpg


Simplified matching with the transaction history of your exchange or wallet:

If your transaction history shows Warnings for "missing assets", the transaction export can help you to compare your transaction history. For this purpose, it is best to filter by the affected depot and asset. You can read more about this in this article.

Was this article helpful?