CoinLedger 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.

Important Note: 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 template using Google Sheets (all fields are required)

  • Coin Symbol: The ticker symbol for the cryptocurrency received

  • Amount: The quantity of crypto received

  • Timestamp: The UTC timestamp of the transaction

    • This should be in the format of: mm/dd/yyyy hh:mm:ss

    • (VERY IMPORTANT to ensure your dates are in UTC)

  • Incoming Type: The transaction type can be either:

    • Income, Mining, Gift, Airdrop, Interest, Hard Fork

    • (VERY IMPORTANT to only include these specific transaction types, and to include them EXACTLY as they are written above with the first letter capitalized)

Step 3

Navigate to Step 1. Import and click Add Account. Next, search for Other Account. Once you've selected this tab, click Upload File and import the CSV template that you prepared into the outlined box.

All manual imports for incoming transactions, as well as trades, and outgoing transactions can all be imported in through the Other Account tab.

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

Step 4

Review your imported incoming transactions in Step 1. Import.

You can also review these transactions in Step 3. Review. Under the Accounts section, select the specific Manual tab that you used to import the file. This will filter for all the income transactions that you imported under the Manual tab.

Be sure to reach out to our Support Team at anytime for advice or guidance on importing your Incoming Transactions!

Did this answer your question?