How to export your Bitstamp transaction history for your crypto tax report

How to export your Bitstamp history

1. 1

   Open your transaction history

   Sign in on the Bitstamp website. Look for the user icon in the top-right corner, then Activity, then Transaction history (sometimes shown as the Transactions page).

2. 2

   Open the export options

   Look for an Export or Open export options button near the top right of the transactions list.

3. 3

   Select everything, for all dates

   Choose All transaction types and All currencies, and a date range from your first transaction to the end of the tax year you are reporting.

4. 4

   Pick the newer CSV format if offered

   If you’re asked to choose a CSV format, look for the newer option (labelled along the lines of RFC 4180 (new)). Both layouts can be imported, but the newer one is cleaner.

5. 5

   Export and keep the file as it is

   Click the export button (for example Export selection or Export all) and save the CSV. Don’t open and re-save it in a spreadsheet program before importing.

6. 6

   Import it into CryptoTaxOwl

   Drop the CSV into the crypto tax calculator. It is read in your browser; nothing is uploaded.

What the columns mean

Columns of the newer layout as seen in open-source importers; we could not find them listed on an official Bitstamp page. The older layout has fewer columns (Type, Datetime, Account, Amount, Value, Rate, Fee, Sub Type), with the currency written inside each cell, such as “0.5 BTC”. Check the header row of your own file.

Quirks to know

• Two layouts. The older layout puts the currency in the same cell as the number (0.5 BTC); the newer layout splits them into Amount and Amount currency, and so on.
• Trades are one row. A Market row with Subtype Buy means you received Amount and paid Value; Sell is the reverse.
• Everything in one file. Deposits, withdrawals, trades and rewards are all in the same export, so one file is usually enough.
• Older XRP types. Long histories can include legacy types such as Ripple deposit and Ripple payment.

How CryptoTaxOwl reads this file

CryptoTaxOwl recognises the Bitstamp file by its header fingerprint and picks the parser for the older or newer layout automatically.

• Market rows become trades, with the fee taken from Fee and Fee currency.
• When a trade is against a fiat currency, Value is used as the trade’s value. Values in the file always come first; the bundled daily prices are only a fallback.
• Deposits and withdrawals become transfer candidates, so they can be matched with your other wallets.
• Staking rewards are suggested as income, which you can review.
• Any type the parser doesn’t know becomes an “Unknown type” issue for you to resolve. It is never quietly treated as taxable or non-taxable.

For crypto you moved to or from your own wallets, see transfers between your own wallets.

Known issues and gaps

• Missing cost basis. Crypto bought elsewhere and deposited to Bitstamp has no purchase cost in this file. Import the other source too, or resolve the issue when it appears.
• Unsupported products. Any margin, derivatives or lending rows are flagged as unsupported and excluded by default. Derivatives profit and loss is out of scope in this version.
• Rewards and other credits. Reward and earn types you haven’t classified appear in the issues queue rather than being guessed.
• Several exports. If you downloaded more than one file, import them together. Overlapping rows are flagged as duplicates.

If your file isn’t recognised

If the import says your Bitstamp file isn’t recognised:

• Use the column mapper in the crypto tax calculator. For the older layout, the mapper reads numbers written together with a currency, such as 0.5 BTC.
• Or convert the file with the crypto CSV converter into the CryptoTaxOwl template.

See how it works for the template and import checks.

Bitstamp export: frequently asked questions