: tax-focused CSVs for Terra blockchain

Heyo - Just wanted to introduce, a simple website for Terra CSVs.

As a Terra user, tax integration support seemed non-existent early on. So I wrote some software to do my own taxes (because who has time to stare at spreadsheets to PAY money). Figured others might have the same need so I decided to make it into a website. It’s grown more comprehensive now bit by bit, with great user feedback.

It has CSVs with: anchor earn interest! (just made this update), swaps, airdrops, staking rewards, LP longfarm/shortfarm/stake/unstake/rewards, bond/unbond, transfers, borrow/repay (please do shout out needs/wants–it really helps gear where to put efforts).

Hope folks check it out!


hey mate I’ve been using it for a couple of weeks and so far it’s excellent. I noticed one bug potentially, and one sort of error-not-error.

the bug - strictly for ANC-UST-LP records, where it put the currency label in the units column, and the units in the label column. I just manually swapped them back around. I think it was the part that detailed the pool (LP token creation).

the other one… when swapping LUNA to other tokens like ANC, the CSV records this as swapping UST to ANC for example. Consequently, when importing in to tax software you end up with craaaaazy figures like negative balances of UST and incorrect (too large) balances of LUNA. I’m manually editing my spreadsheet to fix this.

The only other issue I have, is that Koinly is not coping with it yet. lol. But I am trying to work through my many hundreds of TXs one by one to make any edits, add notes and yeah, try to get it 100%. I’ve hounded Koinly about it on their forums lol.

Anyway, thank you, tremendous effort and I think its really good. So glad you’ve been able to do this and provide this to the community!

1 Like

Oi, apologies for the painful bug. I fixed the 1st bug (I think) a few days ago and the 2nd bug just now after seeing this post. Definitely going to be reviewing/testing swap CSV records …

Thanks for the invaluable feedback.

that’s awesome. i’ll go re-do my CSVs then on your site hehe :stuck_out_tongue: thank you so much!

Thanks very much for making this. This will save everyone a good amount of time in the future.

@podger One thing that is still needed is the USD or fiat conversion of assets at the transaction time.

1 Like

Hi @podger , you’re gonna love or hate me haha sorry, I found another bug.

I am an LPer as well as a Borrower, I collect all rewards together. It seems that the spreadsheet reports only the LP ANC unit count for the reward transaction, not the Borrow, nor the combined amount of ANC.

For instance, I pull for example 39 ANC down in a reward claim, with 17 from my borrow and 22 from my LP, the CSV export from only shows the 22 ANC reward claim :wink:

hehe. sneaky one that one ; )
Many, many many thanks mate. We appreciate your work!

1 Like

I used the tool to prepare taxes and it was absolutely wonderful, but I went all the way back to the launch of Anchor and obviously, I can’t remember exactly what I did back then but I found at one point I sold more ANC than what was in my account at the time according to the csv. Obviously that can’t happen so I figured the tool must miss something. This is probably what I experienced.

1 Like