Export csv for taxes

[bitcoinranger]

I use gatehub and would like to export a csv of my activity for tax purposes.

is this possible?

[Woestekip]

WoW that is goud question @enej Or @gregor     

[Mercury]

5 minutes ago, bitcoinranger said:

I use gatehub and would like to export a csv of my activity for tax purposes.

is this possible?

This has been asked multiple times. Short answer is no, not currently, but if there is enough support a gateway might add it as a feature

[bitcoinranger]

I wouldn't have used the platform if I had been made aware.

[Bejzbox]

It's supposed to be something they are working on..  'for ages'

[Guest]

Export is now available. If there is improvements you need for this tool comment here and we will update it.

[kanaas]

Export is now available. If there is improvements you need for this tool comment here and we will update it.

Thanks Gregor! Going to seek it out!

[ThomasTheTGV]

@gregor Thanks a lot if been waiting for this functionality!

It is in plain sight if you know where to look. The fields are Time,TX hash,Type,Amount,Currency,Currency Issuer Address,Currency Issuer Name,Balance.

Performance was really good I exported transactions from 1-1-201x to 31-12-201x within seconds, but I'm not actively trading so there is not a lot to export.

[ThomasTheTGV]

@gregorWhile testing I noticed you have separated the column Time with comma's between date, year and time. 

If I import the csv in excel and use comma as the separator, this places the headers on the wrong column.

Solution use semicolon as separator for the headers.

[Xrphunter]

8 hours ago, gregor said:

Export is now available. If there is improvements you need for this tool comment here and we will update it.

Thank you

[ThomasTheTGV]

@gregorDate notation isn't consistent

[ThomasTheTGV]

@gregor Amount notation isn't correct which makes the export a lot less/not useful. 

[ThomasTheTGV]

@gregor user questions:

1. What can I do/see with the lines with the type exchange
2. Which Balance do we see on lines with type payment?
3. Is there a way to see what balance was for all coins I owned on a certain date (e.g. 1-1 or 31-12)?

[T8493]

12 hours ago, ThomasTheTGV said:

@gregorWhile testing I noticed you have separated the column Time with comma's between date, year and time. 

If I import the csv in excel and use comma as the separator, this places the headers on the wrong column.

Solution use semicolon as separator for the headers.

There is an option that treats text between two quotation marks as one column (in this case comma won't "split" the column in two columns).

@gregor, maybe you could output dates and times in ISO 8601 format with timezone. Your date/time format is non-standard and cannot be easily parsed, sorted, etc.

[velmet]

56 minutes ago, T8493 said:

There is an option that treats text between two quotation marks as one column (in this case comma won't "split" the column in two columns).

@gregor, maybe you could output dates and times in ISO 8601 format with timezone. Your date/time format is non-standard and cannot be easily parsed, sorted, etc.

Even though one can use commas in CSV between double-quotes, personally I think it is a bad idea to do that as well as date formats with months in letters (like "Dec", "Sep" etc.). Date and time in separate columns in formats like 2017-12-14 and 13:14:59 respectively (with seconds and no time zone info needed as it should be in UTC). That way if one needs ISO date, with some column concatenation it is easy to get ISO date in Excel.

Edited September 16, 2017 by velmet