r/tezos•
tekdemon

Calculating taxes for self-baking

Having a lot of difficulties with this because of not being able to easily generate a CSV of rewards by date. Has anybody figured this out? It seems much easier if you delegated because the APIs can just spit out whatever you received, but if you baked yourself you need to get every reward for every endorsement and baked block and have a date to go along with it. I'm having trouble finding an explorer that provides that data.

Posted Jan 27, 2020, 6:06 AM UTC

610
MAGA_THYME2•
4
myonk•

“Highest level of conduct and standards”

My sides ache

1
Lexxor79•

I have done that, but not completely finalised yet ! if you are interested, please PM me !

2
tekdemonOP•

So I ended up doing a hacky copy and paste from tzstats then cleaning it all up in Excel by using the offset function to put everything into columns. If you're going to go this route just realize that a bunch of random characters and spaces will get copied and pasted and it doesn't seem to be the usual space from just typing on a keyboard. So you have to filter those out for calculations to work in Excel. I kept trying to figure out why I couldn't sum anything.

Then you can put all that into cointracking.info to get the USD values after getting the date format into the specific format they require, which was a lot more find and replace work and editing the cell format.

I really hope that someone comes up with a way to export a CSV compatible with cointracking or something.

2
Lexxor79•

Now working on CoinGecko API in order to get the $ price when rewards are unfrozen !

2
Onecoinbob•

Cointracking should add tezos wallet import

0
Lexxor79•

I did a Visual Basic Macro in order to get all the data from the API automatically.

1
spiice_melange•

Hope this project gets funding u/wisercharlie

1
bobo1984i•

Is baking a taxable event? Wouldn’t it be if/when it’s sold for fiat?

1