ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Comments18.01.2019
2
IntroDoing taxes for crypto is so cumbersome. It's almost impossible to do it right yourself and paying for software solutions or tax accountants can be very expensive. With this tool, I'd like to help you calculate your capital gains taxes in a much easier way. Have fun!

Please find the original article here: https://medium.com/@Ha.Duong

If you're able to save a bit on tax accountants with this please consider a small donation :)
BTC: 18APi2Nk1p5L7iEmJM7aG5h6GUqxvWEUS7 & ETH: 0x0356fd48514D2EE84B13f06D741B62DEed351e23
3
Step by step instructions:1) Click on file > make a copy.
2) Enable your Google Sheet to run the importJSON() function. See instructions here: https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a (thanks to Paul Gambill).
3) On the “Prices” sheet you need to add the tickers for coins you want to track, pull the historic and current prices via the Cryptocompare API. If the API doesn't work (showing "#REF!") just update the cells: copy cell, delete cell, paste back into cell.
4) On the "Tax" sheet, insert your chronological crypto trades data as seen in the example (columns A, C, and F). If you did a crypto-to-crypto trade please file it as 2 rows: Treat as a) sell cryptoA for fiat and b) buy cryptoB with fiat at the same time.
5) Your taxes are shown below. Adjust formulas if necessary

Note:
- I use the FIFO principle and made this sheet with German policies in mind (if you hold your cryptoassets for longer than a year you can sell it tax-free, otherwise 26.375% tax rate).
- Prices are pulled via API for a certain time as specified on Cryptocompare. With daily volatilities, calculated spot prices may differ from the original rates when you executed your trades. Insert your more accurate pricing data where appropriate.
4
Tax Rate26.375%
5
2016 taxes€0.00
6
2017 taxes€1,533.79
7
2018 taxes€10,261.17
8
2019 taxes€0.00
9
Data sourcesCryptocompare API
10
About the authorHa is a Principal at Cambrial Capital - an institutional-grade investment firm deploying a fund of funds strategy exclusively focused on cryptoassets.

twitter.com/HaDuong_
linkedin.com/in/minhhaduong
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100