Robinhood csv file will not import

Describe the problem: The Robinhood CSV file will not import into Koinly. There were 2 threads last year and no resolution was ever posted.

**Which exchange/wallet is this regarding?**Robinhood

**How did you import data into this wallet?**CSV file provided by Robinhood

**What have you tried to fix this so far?**Delete and try again. Read this forum. No response from Koinly Support…please help

4 Likes

I’m having the exact same issue. Would be great to find out a solution… CSV files from other exchanges worked just fine, but RH not so much.

1 Like

Same issue over here. Has anyone given up and entered them manually?

1 Like

Does Koinly answer questions here- Robinhood import also isn’t working for me

1 Like

I am having the same exact issue, robinhood imports are not working

1 Like

I messaged Koinly regarding this and this is what they replied:

"Hi Yaron,

Thank you for your message.

Most users simply declare Robinhood separately since they are a regulated exchange and will give you tax documents, if you’re planning on using for example TurboTax then you can just upload the Robinhood file to it directly, along with the Koinly one.

You can create a Robinhood wallet in Koinly and upload a CSV file there, however unfortunately at the moment the file they provide is not properly formatted so you would need to create a custom CSV. This is because the file they give you contains your cost basis and other tax info that they already calculated for you.
It’s not an easy exchange to import data from as they’re a “closed system”.

We do have a guide in our blog regarding Robinhood that might be of interest so I’ll link it here:

Let me know if you need any more information :slightly_smiling_face:

Best regards,

Tami"

I am having the same problem and cannot find any solution or answer to my question. Is the only solution to just manually input every Robinhood transaction??

1 Like

I have successfully uploaded the csv properly into Coinly and now know what the headers need to look like. You need to do a little cell manipulation but I will work properly… If anyone still needs this solution please let me know.

Hi,
Can you please share this template ?

Hi, I’m interested in the solution as well. Do you input Robinhood deposits/withdrawals in the spreadsheet as well?

Great. Amazing. Would you mind sharing that sheet with the Koinly team so they can incorporate that for a standard import procedure for Robinhood data?

1 Like

Hi All,

Pardon this late response, and thank you for contributing your answers to help others. :raised_hands:

Robinhood is quite unique when it comes to tax reporting for a couple of reasons. When it comes to filing your capital gains from Robinhood, you have two options:

(update) Skip to Option 2 - Robinhood crypto is no longer a closed loop as of recent change. You can move crypto on and off of the service.

Option 1: Report Robinhood separately

Usually, you should always import all of your different wallets to Koinly but Robinhood is one of the few exchanges that can actually be excluded from Koinly.
The reason for this is that Robinhood does not allow any crypto deposits or withdrawals so all of your Robinhood activity will be isolated on the Robinhood platform and can therefore be tracked separately. Robinhood also provides a 1099-B tax form that can be used directly when filing your taxes so it’s often easier to report Robinhood separately and use Koinly for all of your other exchanges and wallets.
If you chose this method then you will essentially end up with two tax reports, one from Robinhood and one from Koinly.
This method is recommended if you are not able to get a transaction history from Robinhood or if you have traded anything other than cryptocurrencies on Robinhood (such as stocks) since Koinly will only be able to track your crypto transactions.

Option 2: Import Robinhood transactions to Koinly

Robinhood does not have a way to export the transaction history which makes importing your transactions to Koinly a bit tricky.
There are a few options available such as creating a custom CSV file or using an alternative method to extract the transaction history, such as this one (this involves installing a Github tool that links to Robinhood’s API which can be a bit complicated).
If you do manage to get your transaction history or create a custom CSV then you can import this to Koinly to include your Robinhood transactions in the Koinly reports. If you do this then you should not use your 1099-B form for tax reporting since those disposals will already be included in Koinly’s calculations

FAQ

Why can’t Koinly import the 1099-B that I received from Robinhood?

This is because the 1099-B is essentially a tax report but Koinly requires your actual transaction history. The 1099-B only contains your disposals but not the full transaction history

Why doesn’t Robinhood provide the transaction history?

That’s a good question but, unfortunately, we do not have the answer. It is a strange limitation of their product as it has been a highly requested feature for many years. We do hope that Robinhood adds this feature soon.

Why can’t Koinly integrate with the Robinhood API?

The Robinhood API seems to work quite well but it has not yet been publicly released. The main issue at the moment is that it would require users to give Koinly their Robinhood passwords as there is no way to generate read-only API keys for the API.

Have an awesome day!

Regarding option 1; Robinhood crypto isn’t a closed loop as of a month ago. People can move crypto on and off of it.

Cheers @B_B!

Thank you for this correction. :raised_hands:
I’ll use your fantastic mention to amend the instruction. Thank you for shining a light on this.

Have an awesome week (and beyond!)

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.