All Collections
Importing Your Data
Manual Import
How to Import Incoming Transactions
How to Import Incoming Transactions
Import crypto acquired through mining, staking, interest, hard forks, airdrop rewards, gifts, or crypto income from a job.
David Kemmerer avatar
Written by David Kemmerer
Updated over a week ago

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:

    • Interest, Staking, Mining, Gift, Airdrop, Interest, Hard Fork or other Income

    • (VERY IMPORTANT to only include these specific transaction types)

Step 3

Navigate to Step 1. Import and click Add Account. Next, search for Manual. 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 through the Manual Import 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 Import or the Review stage

To filter for your manual imports within the Review stage, select the specific Manual import account that you used to import the file. Then filter for the income type (Interest income, Airdrop, etc.) This will filter for all the income transactions that you imported under a Manual import tab.

In the example above, two different manual import sources are selected, labeled as Manual and Manual #2. You can change the label of your manual import source by selecting Edit name on the manual import tab in Step 1.

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

Did this answer your question?