These instructions for converting an FTX transaction history file to a CoinTracker-compatible CSV file demonstrates the instructions in this guide: How to Convert Your Transaction History into CoinTracker-Compatible CSV Format
If you downloaded your FTX US transaction history prior to FTX US shutting down, you can import those transactions to CoinTracker to calculate your capital gains and losses.
Note: This is only an option for users who were able to download their FTX US transactions prior to FTX closing. If you no longer have access to your FTX transaction history and these transactions aren't in CoinTracker, we recommend consulting a tax professional.
To import FTX US transactions to CoinTracker, there are essentially three steps:
- Convert your FTX transactions to the generic CoinTracker CSV format (a step-by-step guide for this is included below)
- Go to the FTX Add Wallet page
- Upload the reformatted CSV
How to Convert FTX Trade History CSV to CoinTracker-Compatible CSV
Once you have your FTX Trade History CSV, follow these instructions to upload it to CoinTracker. Recommended: Please save a copy of your FTX Trade History CSV so you have a record of your original file.
1. Import your trade history file to Google Sheets (or any spreadsheet tool, such as Excel). Note: All screenshots are from Google Sheets featuring our test transactions.
2. Delete the following columns, as these will not be necessary to import into CoinTracker:
-
-
- ID
- Order Type
- TWAP
-
3. Use the find and replace tool to find all commas (,) and replace them with an empty string (i.e. leave it blank):
4. Rename the Time column to Date and reformat to the following format: MM/DD/YYYY HH:MM:SS
This can be done on Google Sheets by selecting the column, selecting Format > Number > Custom date and time, and applying the following:
5. Add the following columns after the Date column:
- Received Quantity
- Received Currency
- Sent Quantity
- Sent Currency
6.For all ‘buy’ transactions:
- Enter the left asset of the Market column as the Received Currency column
- Cut and paste the Size value to the Received Quantity column
- Enter the right asset of the Market column as the Sent Currency column
- Cut and paste the Total amount into the Sent Quantity column
7. For all ‘sell’ transactions:
- Enter the left asset of the Market column as the Sent Currency column
- Cut and paste the Size value to the Sent Quantity column
- Enter the right asset of the Market column as the Received Currency column
- Cut and paste the Total amount into the Received Quantity column
Below is a screenshot of one 'buy' and one 'sell' transaction that have each been updated to the correct format- you will want to do this for all rows.
8. After all relevant rows have been moved into the new columns, we can delete the following columns:
- Market
- Side
- Size
- Price
- Total
9. Rename the Fee column header to Fee Amount
10. For all rows that have no Fee Amount, enter 0. Here is the final result:
11. Finally, download the file as a CSV and import here: https://www.cointracker.io/add_wallet?t=csv
Importing Other Transactions
For importing all other transactions including deposits, withdrawals, NFT transactions, conversions, airdrops, etc., please convert to the same generic CSV format as the trade history file above to import into CoinTracker. If your account already has a FTX US file imported, please make sure all subsequent files are imported into the same wallet from the Wallets page.
If you have any questions or issues, please reach out to our support team at https://www.cointracker.io/contact-us