Author

Topic: Google sheet compute taxes from coinbase csv (Read 144 times)

staff
Activity: 3304
Merit: 4115
December 17, 2020, 07:40:08 PM
#7
Get an accountant. Export your entire history, and give it to them. I would only recommend not relying on a third party if you understand the laws, and know how to calculate the tax, which a lot of people don't know the ins, and outs of tax declaration, and can either face fines, or losing out on more money, since accountants know exactly what to do to save you money.

If you don't want to rely on a third party due to privacy reasons, then I suggest you do extensive research on your local laws, and tax declaration. Then, use a spreadsheet system that isn't hosted online, since that would also be relying on a third party.
full member
Activity: 546
Merit: 159
December 17, 2020, 01:28:52 AM
#6
Google sheet, I don't recommend you to use Google sheet that is connected to Google data base and online threats are around.

Instead of Google sheet, you can you Excel sheet on your computer. It is safer and you can control your personal identities and tax data. You don't need to trust Google to protect your information hence you must keep your computer clean of digitalised threats and don't do stupid things when you are online.
newbie
Activity: 21
Merit: 8
December 14, 2020, 04:58:13 PM
#5
From the link you show me. I quote:

"According to guidelines from the Direction générale des Finances publiques (DGFP, General Directorate for Public Finance), capital gains from the sale of cryptocurrency are subject to taxation.[31]  These gains will be taxed differently depending on whether the taxpayer’s acquisition and sale of cryptocurrency is an occasional activity (in which case it will be taxed as “non-commercial profit”) or a habitual activity (in which case it will be taxed as “industrial and commercial profit”).[32]  Additionally, cryptocurrencies are taken into account when calculating the basis for the French wealth tax, and the free transfer of cryptocurrencies from one person to another may be subject to the gift tax.[33]  Beyond these guidelines, however, tax experts have commented that there still are a number of ambiguities that will need to be clarified by the government.[34]"

So baiscally, in France they don't seem really concern of tax related to crypto. I mean if there is ambiguity.. How do you diferentiate precisely occasional activity  from habitual activity?
newbie
Activity: 21
Merit: 8
December 14, 2020, 04:40:19 PM
#4
Thank you.

The problemis I don't quite understand the fees in coinbase report: https://i.imgur.com/Rw7ZMwf.png

If you look the blue line, there is 2086 euros fees for 0.3btc at 8k6 euro each for converting into eth. Basically it's 2k euro fees for 3k euro of btc converted !

I wonder what EUR Fees and EUR Total (inclusive of fees) actually means.
legendary
Activity: 1512
Merit: 4795
Leading Crypto Sports Betting & Casino Platform
December 14, 2020, 04:07:08 PM
#3
There is an article created by Ratimov that can help you, or you can start by watching the video on the article which the link is also posted below.

[Tutorial] Crypto taxes for beginners
https://bitcointalksearch.org/topic/--5275952

Video about crypto taxes
https://m.youtube.com/watch?v=NBFCvVBpscA&feature=youtu.be

But you will still need to relate it to the crypto regulations in your country by finding out the percentage gain you are going to pay in taxes.

Just know that deposit will not be taxed, crypto sent to recipient will not be tax. Only the profit you make before withdrawal and after trading will be taxed.
copper member
Activity: 2856
Merit: 3071
https://bit.ly/387FXHi lightning theory
December 14, 2020, 03:59:42 PM
#2
I just imported it into sql.

Can you get a csv of your deposits and a csv of your withdrawals individually?

Current balance - deposits + withdrawals should be taxed if positive and over a threshold.
newbie
Activity: 21
Merit: 8
December 14, 2020, 03:53:00 PM
#1
Hello,

I am French and I love baguette.

It has been 9 months since I started trading, and I want to know how much taxes I have to pay so far.
I have been on coinbase so I decided to download the csv report.
I took a look on github for existing google sheet that take a csv and see nothing really.

Do you have any recommandation to do my homework.

Also for 6 months of trading I didn't know that after every withdrawal in my portfolio it was considered to be declared.
So I am clearly scared because I most likely lost more than I earned.

cheers,
Jump to: