CryptoTrader.Tax makes importing mining income, staking income, interest income, gifts, and other crypto income easy using our Incoming Transactions CSV Template. These transactions are treated differently than crypto trades for tax purposes.

(We recommend using Google Sheets to fill out this template. Excel will often format timestamps incorrectly)

Step 1:

Make a copy of the The Incoming Transactions CSV Template.

Step 2:

Fill out the CSV file using Google Sheets (all fields are required)

  • Coin: The ticker symbol for the cryptocurrency received

  • Amount: The quantity of crypto received

  • Type: The transaction type. Can be either: Income, Mining, Gift, Airdrop, Interest, Staking, Hard Fork

  • Timestamp: The UTC timestamp of the transaction (VERY IMPORTANT to ensure your dates are in UTC)
    - Make sure to convert the local time to UTC.
    - This should be in the format of: mm/dd/yyyy hh:mm:ss

Step 3:

Upload your completed file into the Incoming Transactions section.

Note - If your formatted spreadsheet is failing to import, please take a look at this troubleshooting help guide.

Step 4:

You can also add your Incoming Transactions directly into the app by clicking Add Transaction. After you enter the data make sure to click the Save icon on the right side.

Did this answer your question?