FTX - File Import Guide

How to import your FTX transactions into CoinLedger

Lucas Wyland avatar
Written by Lucas Wyland
Updated over a week ago

IMPORTANT NOTE: FTX and FTX.US have filed for bankruptcy and may not be available in your market. FTX customers have reported successfully signing into the claims portal at claims.ftx.com using their FTX account credentials. After verifying your email and completing recovery KYC, you can download a CSV of your transaction history from Step 4 (Balances and Transactions). To import your transactions into CoinLedger, be sure that you only import the "main_deposits, main_withdrawals, and main_trades" files. Alternatively, you can use our Universal Manual Import template.

For all questions related to this process, please reach out to FTX's Customer Support.

Legacy Import Instructions

Files exported from FTX will be in the same language as your set preferences. Before you start exporting make sure that the language is set to English.

FTX does not export an "All Transactions" file that includes all transaction types. Instead, FTX exports four different file types: Withdrawals, Deposits, and Fills. Each of these files contains completely separate transactions.

For this reason, it is very important to carefully review all transaction types that you had on FTX and then export each file that contains these transaction types. This guide includes descriptions of the data included in each file as well as step-by-step instructions for importing each file into CoinLedger.

Fills File

The Fills file contains crypto-to-crypto spot trades that were placed as market or limit orders. These market or limit orders incur additional transaction fees. The Fills file also contains fiat sells (exchanging crypto for fiat currency such as USD)

Important note: There is a limitation with the way that FTX handles stable coin deposits. When certain stablecoins (USDC, USDP, BUSD, TUSD) are transferred into FTX, these assets are automatically converted into a USD fiat balance that you can exchange for other assets. (The only stablecoin that is not affected by this is USDT as FTX does not automatically convert USDT into USD.)

Due to this change, any transactions resulting from that initial stablecoin deposit will be exported as Fiat Buy (fiat currency for crypto) on the Fills file. The main impact this has on report calculations is that it won't accurately show that the stablecoin asset was disposed for the other crypto asset.

In order to fix this, you can edit the Fiat Buy transaction within CoinLedger and change the USD amount to the amount of stablecoin disposed, and then classify the transaction as a Trade. Making this change will deduct the stablecoin that you disposed and your global wallet balance for the stablecoin will be more accurate.


Deposits File

The Deposits file contains fiat deposits from ACH bank wire and crypto transferred into FTX.

Important note: fiat currency deposited into FTX through ACH gets automatically converted into a stablecoin. This stablecoin gets exported as a one-sided transaction in the Deposits file. FTX does not provide data in the Deposits file that shows the fiat-stablecoin swap. This can cause a Missing Cost Basis warning later on when the stablecoin is traded away, because the software does not know how the stablecoin was acquired.

To fix this, after you import the Deposits file, review your Deposit transactions from FTX within CoinLedger. If you see any stablecoin deposits that resulted from transferring fiat currency on to FTX, you can edit the Deposit transaction and change it to a Fiat buy. Then enter in the amount of fiat currency you originally transferred in as the Sent asset. Keep the Received asset as the stablecoin currency.

Withdrawals File

The Withdrawals file contains crypto and fiat withdrawals.

Fills CSV Export

Deposits and Withdrawals CSV Export

Step-by-Step Import Instructions

Step 1:

Login to your FTX account.

Step 2:

Navigate to Wallet page by clicking on Wallet on page header, and then on Portfolio.

Step 3:

Choose a subaccount from which transactions will be exported. You will need to export transactions for each subaccount.

Step 4:

Click on Deposits to list all deposits. Check the box Show time in UTC and then click Download CSV (cloud icon).

Step 5:

Click on Withdrawals to list all deposits. Check box Show time in UTC and then click Download CSV (cloud icon).

Step 6:

Click on Fills to list all trades. Check box Show time in UTC and then click Download CSV (cloud icon).

Step 7:

Repeat steps 4, 5, and 6 for each subaccount.

Step 8:

You will receive files in .csv format. Navigate to Step 1. Import. Select Add Account then choose the FTX tab on CoinLedger. Click on Upload File and drag each of your CSV files into the box to import your transactions.

Did this answer your question?