Hive Tax CSV – Free and Open Source Application by mightpossibly

View this thread on: hive.blog | peakd.com | ecency.com

hive-167922 · @mightpossibly · 2024-04-13T14:01:33+00:00

$3.48

Hive Tax CSV – Free and Open Source Application

 https://img.inleo.io/DQmX16KueFke7y9acDfVRsMnBufp7KBvC4Ad1PNmM6o3k6u/image.png 

As I was doing my taxes last week I wanted to eliminate as much manual work as possible, so with the help of AI I attempted to develop a very simple application that would scan my account for all relevant L1 transactions of Hive throughout the year and output them in a tidy CSV. And what do you know, after only an hour or so of prompting and testing, I had a working program.

The application is open source and available on my github account:  
- https://github.com/mp-hive/Hive-Tax-CSV

### How it works (copy/paste from the Readme)
**Hive Tax CSV** is a simple Python application that will fetch tax relevant L1 transactions for a specific Hive account within a given [time](https://inleo.io/@leoglossary/leoglossary-time) period. The application will scan your Hive account between the dates you set and output a .csv file that can be further processed and then imported into the tax [software](https://inleo.io/@leoglossary/leoglossary-software) of your choice.

The application will fetch the following transactions:
- Claimed rewards (HP)
- Claimed rewards (HBD)
- HIVE/HBD Conversions
- HIVE/HBD Internal Market Trades
 
### How to use
1. Download and edit the file **fetchTransactions.py** and input your username and the desired time period.
```
account_name = "your-account-name"  # Replace with your Hive account name
start_date = datetime.strptime("2024-01-01", "%Y-%m-%d")
end_date = datetime.strptime("2024-4-11", "%Y-%m-%d")
```
2. Run the script. It will take a few seconds to a few minutes to complete, depending on the amount of transactions you've done in the selected time period. When the script is done it will output a CSV file to the same directory as where you placed/ran the script.

*If you don't know how to run a Python script, don't worry it's super easy. Ask ask any LLM (for instance ChatGPT) and you'll have it set up in no time*

### Here's an example output
 https://img.inleo.io/DQmTUa5dKhiZMqXviX5Dco6SjgQEM7A7TNrUg226habFZfv/image.png 

### Got questions?
If you have any questions at all, have no idea how to run a Python [script](https://inleo.io/@leoglossary/leoglossary-script) or whatever else, make sure to reach out in the comments' section below, and I'll try to help out as best I can.

---

<center> If you found this useful, feel free to leave a comment, upvote or reblog.

https://i.imgur.com/r815k0y.gif

Thank you for reading!</center>

---

### What is Hive?
To learn more about Hive, this article is a good place to start: [What is Hive?](https://inleo.io/@leoglossary/leoglossary-what-is-hive). If you don't already own a Hive account, [go here to get one](https://inleo.io/signup?referral=mightpossibly).

---

@leoglossary links added using [LeoLinker](https://inleo.io/@kendewitt/what-is-leolinker).




Posted Using [InLeo Alpha](https://inleo.io/@mightpossibly/hive-tax-csv-free-and-open-source-application)

👍 steemcleaners, taskmaster4450le, rtonline, pouchon, dkid14, michupa, tokenizedsociety, eddie-earner, diverse, a-quarius, hive.helps, cranium, thisisawesome, lbi-token, coolguy123, globalcurrencies, mightyrocklee, smartvote, crazyphantombr, hykss.leo, relf87, steemmatt, binance2, steemflow, darmst5339, marcocasario, palasatenea, lisamgentile1961, coyotelation, ovey10, shawnnft, ciderjunkie, russellstockley, danielhuhservice, lnakuma, we-are, harpreetjanda, voter000, msp-makeaminnow, voter001, eturnerx, imfarhad, heutorybr, pouchon.tribes, arc7icwolf, town-hall-voter, rubenglz24, chmoen, tydynrain, fredhill, rodent, rubilu, kalkulus, foreverhero, elderdark, maddogmike, bradleyarrow, ijat, fatman, vault3, wine-club, oakshieldholding, khan.dayyanz, elgatoshawua, and 94 others

properties (23)vote details (158)

voter	rshares	pct
alz190	692,115,213	25%
steemcleaners	2,319,736,773,284	80%
catotune	5,767,522,179	20%
bigtakosensei	3,003,864,026	2.5%
bp9930	5,372,226,946	85%
culturearise369	3,764,540,841	100%
pouchon	339,136,927,854	25%
frankydoodle	653,106,234	5%
joeyarnoldvn	469,064,678	1.47%
eturnerx	20,624,802,543	1.9%
cranium	135,722,079,693	50%
fatman	9,092,490,907	2%
steemmatt	65,691,374,504	100%
msp-makeaminnow	21,284,567,101	25.3%
rodent	11,196,307,923	45%
rtonline	468,929,031,106	100%
coolguy123	105,478,676,453	50%
dkid14	325,337,161,664	100%
coyotelation	42,203,230,902	100%
diverse	175,215,742,494	100%
steemflow	60,444,503,855	30%
tariksaran	562,772,877	6%
mytechtrail	5,752,262,395	5%
a-quarius	170,299,572,225	100%
digna	1,195,436,325	100%
alinequeiroz	653,258,437	100%
ericburgoyne	2,909,679,581	5%
russellstockley	35,901,845,494	30%
teutonium	804,029,188	25%
flaxz	1,766,797,570	1.5%
we-are	21,434,510,210	92.8%
crystalhuman	998,783,483	100%
gaottantacinque	595,454,779	100%
smartvote	79,728,282,903	3.4%
gasaeightyfive	696,258,417	100%
marcocasario	55,304,622,538	8.49%
oakshieldholding	6,948,384,706	50%
voter001	21,270,793,252	20.7%
voter000	21,311,065,993	45.4%
cribbio	1,491,371,437	100%
palasatenea	54,396,051,868	42.5%
guurry123	906,910,973	3%
harpreetjanda	21,342,875,444	50%
aiuna	2,586,031,649	47.5%
khan.dayyanz	6,737,115,656	5%
jacuzzi	6,396,781,437	12.5%
binance2	60,763,697,982	35%
vault3	8,022,657,945	35%
thisisawesome	125,067,902,006	15%
gurseerat	1,959,641,626	8%
freemonster	471,456,631	20%
mindtrap-leo	1,751,547,238	50%
awesomecuration	2,844,499,340	100%
taskmaster4450le	1,941,451,262,317	50%
maddogmike	9,891,272,626	8%
lisamgentile1961	47,967,947,404	15%
curtawakening	795,458,154	10%
iamraincrystal	5,867,713,132	5%
successchar	764,644,683	6.5%
bradleyarrow	9,570,701,057	10%
pouchon.tribes	18,129,838,917	40%
an-sich-wachsen	1,273,494,153	10%
lnakuma	25,145,013,148	50%
rcaine	4,692,574,487	3%
wine-club	7,693,844,076	100%
bilpcoinbpc	1,113,498,397	5%
chmoen	13,402,071,164	80%
hirohurl	928,419,487	2.5%
keys-defender	5,680,744,211	100%
thepavsalford	265,211,480	100%
danielhuhservice	28,969,389,253	10%
imfarhad	19,903,287,019	20%
globalcurrencies	89,335,494,598	35%
ciderjunkie	36,586,351,284	50%
invest4free	5,312,033,950	15%
balvinder294	4,984,926,151	20%
diego1306	814,827,042	100%
aslehansen	3,394,881,583	10%
cmplxty.leo	1,730,943,189	25%
eddie-earner	175,344,205,697	50%
mightyrocklee	85,013,349,367	5%
heruvim1978	3,085,840,522	5%
lbi-token	119,293,889,506	50%
hive-112281	1,007,519,855	5%
godfather.ftw	3,760,977,867	5%
pvmihalache	4,480,637,591	10%
hykss.leo	75,816,310,320	7.5%
elgatoshawua	6,625,413,135	25%
bprmedia	583,329,208	100%
alokkumar121.leo	1,259,254,424	100%
leoball	3,151,270,591	50%
jim-crypto	474,528,851	11.87%
hive-defender	408,884,790	100%
darmst5339	58,088,322,785	66%
robmojo.leo	894,669,048	25%
darmst	734,170,817	100%
perfectionist25	0	0.1%
giono	514,676,009	5%
trillemille	1,161,183,136	100%
jocieprosza.leo	3,528,161,372	50%
darmstrong	4,708,956,980	100%
lyon-89	42,534,753	100%
ovey10	41,764,616,114	100%
foreverhero	10,528,463,119	100%
elyelma	3,839,341,203	100%
elderdark	10,425,260,255	47.5%
rzc24-nftbbg	1,403,320,616	5%
alovely088	1,131,075,359	2%
logen9f	712,660,282	1%
ijat	9,284,573,373	68%
arc7icwolf	15,696,342,815	30%
michupa	277,300,524,582	95%
beffeater	4,700,268,289	47.5%
rubenglz24	13,449,850,758	100%
tydynrain	12,850,421,045	10%
relf87	70,958,369,174	100%
catotenor	249,046,512	20%
tokenizedsociety	213,083,958,806	50%
kalkulus	10,695,695,397	85%
heutorybr	18,572,068,931	47.5%
addnode	226,152,978	20%
crypto-shots	0	50%
vyb.pob	918,659,455	23.75%
crazyphantombr	78,562,198,445	75%
vyb.curation	515,111,515	23.75%
amakauz	1,263,756,333	5%
jmis101	2,005,125,158	5%
cryptoshots.nft	1,045,710,080	100%
fredhill	11,613,229,411	100%
karizma	3,633,194,662	10%
buzzking	469,257,995	50%
shawnnft	38,731,190,654	39%
sabajfa	3,732,954,002	25%
youdontknowme	1,227,845,258	6.25%
dutchchemist	474,617,226	100%
cryptoshots.play	0	10%
protokkol	1,091,576,244	50%
abreusplinter	3,754,841,508	47.5%
rtonline.leo	286,569,679	100%
cryptoshotsdoom	0	10%
rubilu	11,179,328,905	50%
psyskiff	244,494,955	20%
eosdios	258,013,407	20%
modestscavo	235,236,653	20%
actordontee	3,233,160,628	25%
beauty197	3,571,732,902	25%
sammyhive	494,099,968	3%
herculeand	1,530,566,486	10%
countrysid	1,360,618,957	100%
orkangel	404,750,999	15%
luchyl	1,877,632,778	10%
karina.gpt	0	100%
susieisclever	774,915,719	10%
mr-chuks	987,642,422	7.5%
samueluche07	1,263,816,577	25%
town-hall-voter	14,291,315,647	50%
kaveira	1,365,831,938	47.5%
hive.helps	161,095,060,890	100%

@crazyphantombr · 2024-04-16T20:23:09+00:00

$0.04

Hello my friend!
How are you? Hope you're well!

Wow, who are you my noble friend? Where were you hiding that I hadn't met you yet? What incredible material your blog has! Congratulations on the extremely relevant content you have brought to the blockchain!

I want to note that I will "check" your posts in search of teaching content on the use of computational tools. I will learn a lot from them!

But what brought me here is another subject...
I noticed you recently used the #freecompliments community tag while posting your threads! Thank you very much for the mention!

In our community we have a support program that rewards members, and in this way you are missing the opportunity to receive incentives.

A few days ago we were looking for someone qualified to extract some data from the blockchain, so we paid for the service performed. The position has already been filled, but who knows, who knows, the next one could be yours?

I would like to invite you to join the **FreeCompliments** community, the most welcoming community on *Hive*. There is certainly a place for your posts!

We have a manual curation program and a rewards program for using *threads* and posting positive comments!

We have themed days for you to post throughout the week, we have monthly competitions and a team to support the mental health initiative.

It's a lot, isn't it?

<h3>Join us! </h3>

Find us through the links on your current *frontend*:
<br>
<center>


[InLeo](/communities/hive-140084) | [Ecency](/created/hive-140084) | [Peakd](https://peakd.com/c/hive-140084/created)


[![Freecompliments](https://i.imgur.com/KWnGAZC.gif)](/created/hive-140084)
</center>

I'll follow you, and if you want, you can follow me too!

👍 mightpossibly

`author`	crazyphantombr
`permlink`	re-mightpossibly-zs718q3g
`category`	hive-167922
`json_metadata`	{"app":"leothreads/0.3","format":"markdown","tags":["leofinance"],"canonical_url":"https://inleo.io/@crazyphantombr/re-mightpossibly-zs718q3g","links":["https://peakd.com/c/hive-140084/created)","https://i.imgur.com/KWnGAZC.gif)](/created/hive-140084)"],"images":[],"isPoll":false,"pollOptions":{},"dimensions":[]}
`created`	2024-04-16 20:23:09
`last_update`	2024-04-16 20:23:09
`depth`	1
`children`	1
`last_payout`	2024-04-23 20:23:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.020 HBD
`curator_payout_value`	0.020 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,718
`author_reputation`	226,539,688,666,902
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,907,027
`net_rshares`	91,733,263,417
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mightpossibly	0 B		91,733,263,417	10%

@mightpossibly · 2024-04-21T13:32:15+00:00

Thanks for your nice comment. Glad you like my stuff! I'm planning to do another app like this, but for L2 (Hive-Engine) transactions as well.

properties (22)

`author`	mightpossibly
`permlink`	re-crazyphantombr-39rxbgh9j
`category`	hive-167922
`json_metadata`	{"app":"leothreads/0.3","format":"markdown","tags":["leofinance"],"canonical_url":"https://inleo.io/@mightpossibly/re-crazyphantombr-39rxbgh9j","isPoll":false,"pollOptions":{},"dimensions":[]}
`created`	2024-04-21 13:32:15
`last_update`	2024-04-21 13:32:15
`depth`	2
`children`	0
`last_payout`	2024-04-28 13:32:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	142
`author_reputation`	44,290,979,624,996
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	133,010,666
`net_rshares`	0

@hive.helps · 2024-04-13T20:01:39+00:00

$0.04

That is nice. Exactly what I was searching for since 2 years. Would be great if it could as well read out all the L2 transactions on hive-engine. But this is a great start.

👍 mightpossibly

`author`	hive.helps
`permlink`	re-mightpossibly-sbwczg
`category`	hive-167922
`json_metadata`	{"tags":["hive-167922"],"app":"peakd/2024.4.1"}
`created`	2024-04-13 20:01:39
`last_update`	2024-04-13 20:01:39
`depth`	1
`children`	2
`last_payout`	2024-04-20 20:01:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.018 HBD
`curator_payout_value`	0.018 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	173
`author_reputation`	10,266,864,574,804
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,837,107
`net_rshares`	90,354,362,698
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mightpossibly	0 B		90,354,362,698	10%

@mightpossibly · 2024-04-13T20:45:36+00:00

$0.07

Glad to hear it and appreciate the feedback! I'm planning to do a similar one for L2-transactions. It shouldn't be too difficult, just need time to sit down with it

👍 hive.helps

`author`	mightpossibly
`permlink`	re-hive-helps-rculhs7z
`category`	hive-167922
`json_metadata`	{"app":"leothreads/0.3","format":"markdown","tags":["leofinance"],"canonical_url":"https://inleo.io/@mightpossibly/re-hive-helps-rculhs7z","isPoll":false,"pollOptions":{},"dimensions":[]}
`created`	2024-04-13 20:45:36
`last_update`	2024-04-13 20:45:36
`depth`	2
`children`	0
`last_payout`	2024-04-20 20:45:36
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.036 HBD
`curator_payout_value`	0.036 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	164
`author_reputation`	44,290,979,624,996
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,837,856
`net_rshares`	174,962,031,384
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
hive.helps	0 B		174,962,031,384	100%

@hivebuzz · 2024-04-13T14:05:57+00:00

Congratulations @mightpossibly! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)

<table><tr><td><img src="https://images.hive.blog/60x70/https://hivebuzz.me/@mightpossibly/upvotes.png?202404112226"></td><td>You distributed more than 66000 upvotes.<br>Your next target is to reach 67000 upvotes.</td></tr>
</table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@mightpossibly) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>

properties (22)

`author`	hivebuzz
`permlink`	notify-1713017157
`category`	hive-167922
`json_metadata`	{"image":["https://hivebuzz.me/notify.t6.png"]}
`created`	2024-04-13 14:05:57
`last_update`	2024-04-13 14:05:57
`depth`	1
`children`	0
`last_payout`	2024-04-20 14:05:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	648
`author_reputation`	367,940,838,471,523
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,830,525
`net_rshares`	0

@hivebuzz · 2024-04-16T00:12:30+00:00

Congratulations @mightpossibly! You received a personal badge!

<table><tr><td>https://images.hive.blog/70x70/https://hivebuzz.me/badges/lpud.png</td><td>You powered-up at least 150 LEO on Leo Power Up Day!<br>Thank you for participating in the Leo challenge.</td></tr></table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@mightpossibly) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub>

properties (22)

`author`	hivebuzz
`permlink`	notify-1713226351
`category`	hive-167922
`json_metadata`	{"image":["https://hivebuzz.me/notify.t6.png"]}
`created`	2024-04-16 00:12:30
`last_update`	2024-04-16 00:12:30
`depth`	1
`children`	0
`last_payout`	2024-04-23 00:12:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	446
`author_reputation`	367,940,838,471,523
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,887,426
`net_rshares`	0

@shawnnft · 2024-04-13T15:31:18+00:00

$0.04

very nice will share this to some friends that were looking for a tool like this

👍 mightpossibly

`author`	shawnnft
`permlink`	re-mightpossibly-sbw0fz
`category`	hive-167922
`json_metadata`	{"tags":["hive-167922"],"app":"peakd/2024.4.1"}
`created`	2024-04-13 15:31:18
`last_update`	2024-04-13 15:31:18
`depth`	1
`children`	6
`last_payout`	2024-04-20 15:31:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.018 HBD
`curator_payout_value`	0.018 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	80
`author_reputation`	287,785,494,368,546
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,832,223
`net_rshares`	90,024,831,841
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mightpossibly	0 B		90,024,831,841	10%

@mightpossibly · 2024-04-13T19:23:33+00:00

Awesome :) Thanks for sharing

👍 shawnnft

`author`	mightpossibly
`permlink`	re-shawnnft-bdm5fuxp
`category`	hive-167922
`json_metadata`	{"app":"leothreads/0.3","format":"markdown","tags":["leofinance"],"canonical_url":"https://inleo.io/@mightpossibly/re-shawnnft-bdm5fuxp","isPoll":false,"pollOptions":{},"dimensions":[]}
`created`	2024-04-13 19:23:33
`last_update`	2024-04-13 19:23:33
`depth`	2
`children`	4
`last_payout`	2024-04-20 19:23:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	29
`author_reputation`	44,290,979,624,996
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,836,505
`net_rshares`	4,754,766,273
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
shawnnft	0 B		4,754,766,273	5%

@shawnnft · 2024-04-14T03:55:33+00:00

no problem its useful people need it lol<div><a href="https://engage.hivechain.app">![](https://i.imgur.com/XsrNmcl.png)</a></div>

properties (22)

`author`	shawnnft
`permlink`	re-1713066932459
`category`	hive-167922
`json_metadata`	{"app":"engage"}
`created`	2024-04-14 03:55:33
`last_update`	2024-04-14 03:55:33
`depth`	3
`children`	0
`last_payout`	2024-04-21 03:55:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	130
`author_reputation`	287,785,494,368,546
`root_title`	"Hive Tax CSV – Free and Open Source Application"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	132,843,747
`net_rshares`	0

@shawnnft · 2024-04-14T03:55:48+00:00

no problem its useful people need it<div><a href="https://engage.hivechain.app">![](https://i.imgur.com/XsrNmcl.png)</a></div>

properties (22)