Script to create a CSV file with all financial transactions (i.e. for tax purposes) by pharesim

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

hive-139531 · @pharesim · Aug 22 '24

$51.78

Script to create a CSV file with all financial transactions (i.e. for tax purposes)

My accountant asked me for a list of transactions on Hive. I searched a bit, but didn't find anything that could help with that, so I wrote a script to create a CSV file.

https://github.com/pharesim/hive_tx_to_csv/

<center>
![data aggregation](https://files.peakd.com/file/peakd-hive/pharesim/245w8y2AsVWL7HGBSgQeU6j99teWBY2vN9VTiDEcA3uAz5HDNKAATmACvWFhz3NUFyghN.webp)
</center>

Thanks to @mahdiyari's HAFSQL it's possible to convert VESTS to HP using the ratio at the time, which was the biggest issue in this project. It's all simple and straight forward, all you need is python with beem and pandas. 

Download the file, edit the parameters on top with the account you want to get the data for and the start and end date. Be aware that it can take a long time to run, as it has to iterate through all transactions in the specified timeframe. The preset is hbdstabilizer with about 1700 transactions in one day, which takes a little over 2 minutes on my system. Getting a year's worth of data for my own account took about 4 hours. If you're not a witness it'll probably be a lot quicker.

First I thought about creating a paid service, but free is better ;) Please open a ticket or comment here if you encounter any issues.

Enjoy, and if you consider my work useful please drop me a witness vote!

👍 trafalgar, resonator, yabapmatt, galenkp, slobberchops, stickupcurator, traf, oflyhigh, fw206, legionsupport, jarvie, lemouth, fredrikaa, smasssh, revisesociology, ausbitbank, nuthman, v4vapid, louis88, mahdiyari, borran, gigel2, coldbeetrootsoup, roelandp, farm1, m31, ash, kvinna, raindrop, kaerpediem, hivecuba, godfish, hatoto, lemony-cricket, ace108, danielsaori, dera123, foodchunk, forsakensushi, silversaver888, taskmaster4450, bitcoinflood, santigs, pishio, mengao, cst90, informationwar, ecency, gadrian, deepdives, atma.love, shasta, jim888, nrg, woelfchen, hmvf, softworld, kendewitt, blue.rabbit, bil.prag, pardinus, seckorama, petrvl, penguinpablo, and 429 others

`author`	pharesim
`permlink`	script-to-create-a-csv-file-with-all-financial-transactions-ie-for-tax-purposes
`category`	hive-139531
`json_metadata`	{"app":"peakd/2024.8.6","format":"markdown","tags":["hive","transactions","accounting","taxes"],"users":["mahdiyari"],"image":["https://files.peakd.com/file/peakd-hive/pharesim/245w8y2AsVWL7HGBSgQeU6j99teWBY2vN9VTiDEcA3uAz5HDNKAATmACvWFhz3NUFyghN.webp"]}
`created`	2024-08-22 23:09:21
`last_update`	2024-08-22 23:09:21
`depth`	0
`children`	32
`last_payout`	2024-08-29 23:09:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	25.910 HBD
`curator_payout_value`	25.866 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,303
`author_reputation`	239,352,620,843,716
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,469,495
`net_rshares`	191,741,276,942,966
`author_curate_reward`	""

properties (23)vote details (493)

voter	rshares	pct
ash	809,500,863,554	100%
kevinwong	105,193,990,856	50%
leprechaun	20,843,386,590	100%
churdtzu	24,242,374,003	33%
juanmiguelsalas	7,258,015,683	10%
paradise-paradox	1,453,303,479	100%
good-karma	11,248,535,021	1%
roelandp	920,077,935,236	50%
bryanj4	607,995,603	25%
ausbitbank	1,982,369,481,309	40%
mrwang	845,406,830	25%
jeffjagoe	4,655,184,102	0.3%
meesterboom	194,897,729,307	5%
kendewitt	301,518,874,762	100%
ubg	28,439,826,068	100%
quigua	12,733,205,300	100%
ace108	538,931,133,183	12%
sazbird	834,114,556	5%
kaykunoichi	1,029,877,265	50%
timcliff	141,872,146,102	100%
joele	4,257,597,814	100%
oflyhigh	3,719,842,828,553	100%
anarcist69	5,217,220,794	7.5%
borran	1,200,079,312,387	100%
treaphort	723,005,276	15%
lemouth	2,775,959,770,355	100%
elamental	923,469,686	9.9%
stevescoins	5,202,758,594	50%
wisbeech	528,167,185	5%
catherinebleish	11,442,706,104	50%
steevc	157,852,837,260	5%
netaterra	162,652,750,519	15%
jlufer	18,794,520,512	100%
brightstar	5,466,314,807	15%
penguinpablo	223,746,373,222	14%
wakeupnd	133,113,938,330	50%
tftproject	2,700,944,134	15%
jimbobbill	1,785,258,599	15%
petrvl	228,835,299,503	20%
seckorama	233,466,021,789	63%
appalachain	2,724,764,965	7.5%
funnyman	1,406,194,634	5.6%
nelyp	2,719,116,554	100%
jang	123,446,830,185	100%
dylanhobalart	76,066,055,311	11%
ura-soul	173,320,709,875	100%
makinstuff	67,510,352,340	50%
nikv	34,270,302,445	50%
oleg326756	40,761,404,128	100%
esteemapp	2,537,344,992	1%
wagnertamanaha	40,933,463,966	50%
v4vapid	1,773,347,633,322	11%
darth-azrael	148,014,344,917	50%
darth-cryptic	24,290,198,930	50%
evildeathcore	10,975,161,769	100%
steven-patrick	11,860,184,699	100%
danielsaori	529,490,739,468	100%
trafalgar	45,353,494,740,171	100%
itinerantph	1,878,623,171	50%
freebornsociety	5,527,814,748	10%
haileyscomet	768,613,626	20%
miniature-tiger	17,737,157,016	100%
dickturpin	19,492,626,687	25%
raindrop	703,447,336,062	100%
tbnfl4sun	48,075,490,453	50%
bloomberg215	5,006,423,640	100%
passion-fruit	12,013,868,949	92%
jdc	769,996,991	15%
fortune-master	11,772,996,512	92%
smasssh	2,348,875,375,280	50%
frankydoodle	3,531,764,391	25%
batman0916	2,073,667,372	11.25%
amberyooper	5,175,274,410	20%
grider123	17,753,098,169	50%
whatamidoing	9,628,388,346	4%
jagged	1,411,825,452	50%
rt395	2,290,007,948	1.5%
uruiamme	1,699,458,600	15%
kilianmiguel	2,110,842,049	10%
nrg	339,300,813,108	100%
newsflash	946,970,612	2.75%
fredrikaa	2,393,266,296,251	100%
bitcoinflood	457,233,400,408	31%
belahejna	40,267,650,053	20%
sircork	7,153,685,176	100%
slefesteem	1,200,078,533	50%
alphacore	7,161,860,168	7.12%
galenkp	7,219,229,344,803	100%
mahdiyari	1,372,596,297,902	100%
firstamendment	189,289,282,262	100%
hhayweaver	38,761,277,371	50%
techken	44,092,878,015	50%
joeyarnoldvn	529,427,443	1.66%
warfeed	718,672,564	50%
thegreens	6,404,202,381	50%
m31	835,996,699,946	100%
makrotheblack	8,191,066,659	100%
derekrichardson	1,405,038,837	2.25%
godfish	622,889,872,928	50%
lenasveganliving	9,558,346,324	50%
heart-to-heart	12,845,478,359	20%
hairyfairy	10,694,386,122	10%
nikdo	5,369,654,798	25%
shasta	368,159,701,513	100%
resiliencia	11,099,155,641	100%
holisticmom	1,457,660,955	3%
avesa	3,310,661,746	33%
nuthman	1,788,743,752,563	50%
aafeng	215,696,240,614	25%
zyx066	63,653,477,695	30%
tribesteemup	209,183,210,561	100%
santigs	455,621,035,706	53%
floatinglin	7,561,997,436	100%
nurhayati	2,341,815,774	50%
raj808	2,842,811,959	30%
solarsupermama	2,197,948,315	11%
taskmaster4450	473,661,000,790	25%
revisesociology	2,237,828,917,854	100%
silversaver888	476,677,498,472	100%
espoem	7,888,836,886	2.5%
bipolar	2,519,192,052	33%
insanityisfree	2,056,141,895	100%
yabapmatt	24,888,387,314,013	100%
risemultiversity	7,509,938,585	50%
miprimerconcurso	4,966,478,898	100%
canadianrenegade	10,484,153,447	5%
esteem.app	313,152,863	1%
ferod23	1,280,191,029	100%
kieranpearson	1,778,045,526	33%
melonman0	0	100%
fulcrumleader	7,779,994,768	100%
petrolinivideo	3,927,298,088	50%
informationwar	401,624,647,933	100%
der-prophet	11,110,408,185	5%
devosdevosi	3,469,184,712	100%
bluntsmasha	1,508,670,963	12.75%
libertyepodcast	593,745,432	50%
maxinpower	142,004,627,229	100%
trucklife-family	196,639,502,683	30%
belleamie	5,527,390,194	25%
citizensmith	13,761,927,336	5%
mytechtrail	18,631,653,135	15%
traf	3,943,987,293,935	100%
b00m	11,073,542,698	5%
elderson	482,532,989	7.5%
fixedbydoc	1,798,904,242	3%
esaia.mystic	3,860,511,661	60%
nathen007	155,975,939,205	100%
markaustin	795,966,102	5%
spiritabsolute	35,397,220,352	100%
dmwh	42,071,486,207	50%
wiseagent	15,613,674,186	15%
cryptonized	235,796,364	14%
joankii	1,780,376,336	100%
eaglespirit	9,745,820,078	5%
jim888	355,549,865,039	8%
phortun	13,944,385,045	100%
kaerpediem	680,768,728,498	100%
sagescrub	1,449,342,176	25%
mountainjewel	4,397,344,516	5%
hetty-rowan	104,219,139,943	50%
hijosdelhombre	64,807,139,363	50%
moxieme	1,397,475,466	20%
soufianechakrouf	1,214,303,777	50%
leslierevales	6,878,441,443	50%
patricklancaster	12,826,667,384	70%
gokhan83kurt	3,546,809,831	100%
empress-eremmy	47,511,687,804	50%
aagabriel	2,327,304,639	65%
jarvie	2,777,418,648,916	100%
atongis	25,337,964,813	10%
fieryfootprints	123,289,882,258	40%
newageinv	144,177,558,983	10%
lemony-cricket	561,662,061,911	100%
fantasycrypto	70,074,217,979	100%
atma-yoga	731,185,398	50%
blog-beginner	35,814,159,313	100%
turkishcrew	273,059,615	100%
hempress	1,013,442,739	11%
catharsis	474,032,167	0.5%
rubelynmacion	42,299,466,345	100%
nataboo	1,331,858,201	50%
onlavu	164,373,307,899	100%
vegan.niinja	4,561,142,708	22%
cst90	402,300,863,078	100%
eugenekul	892,145,381	22%
melvin7	130,812,595,648	40%
lisfabian	9,541,537,697	50%
homestead-guru	40,344,947,974	50%
jagoe	715,506,762	0.3%
wildarms65	8,475,122,668	100%
photobook	15,417,830,540	100%
tonytrillions	2,125,202,943	60%
backinblackdevil	41,857,121,689	100%
josemalavem	32,427,227,553	40%
mindszai	490,676,844	50%
bil.prag	247,014,303,850	25%
sapphic	1,867,359,292	7.5%
celestialcow	5,433,145,785	22%
rivalzzz	74,564,950,912	100%
sanderjansenart	10,118,321,739	5%
ronaldoavelino	4,697,083,888	20%
louis88	1,617,403,746,749	75%
reversehitler88	14,360,861,995	100%
dera123	524,590,385,534	100%
rambutan.art	37,576,781,805	100%
gadrian	388,736,051,091	30%
gifty-e	887,823,193	100%
kgakakillerg	20,574,595,602	10%
steemer-x	543,087,830	50%
el-dee-are-es	4,186,029,410	10%
thomaskatan	1,741,039,953	70%
indigoocean	24,673,121,788	50%
retard-gamer-de	1,342,042,610	50%
lemcriq	1,305,725,356	100%
veteranforcrypto	1,555,245,982	7.5%
fw206	3,417,093,328,680	44%
slobberchops	6,617,652,801,731	100%
hatoto	603,755,150,817	100%
crystalhuman	997,983,807	100%
annemariemay	500,749,911	50%
truthabides	1,480,030,622	7.5%
cambridgeport90	14,599,057,941	50%
commonlaw	5,537,049,496	35%
insaneworks	114,271,385,624	50%
kstop1	14,203,210,242	100%
solarwarrior	89,619,723,550	100%
gregorypatrick	567,316,780	33%
the.rocket.panda	2,834,996,265	25%
smarmy	894,464,449	50%
mlgcrypto	536,239,481	50%
haccolong	2,362,020,208	25%
newsnownorthwest	1,948,671,273	15%
mannacurrency	20,355,370,984	10%
frugal-fun	1,996,264,182	100%
drsensor	2,289,261,947	80%
steemulant	93,546,259	6.63%
nickhans	2,521,750,969	100%
thedailysneak	464,189,197	0.58%
phillyc	2,035,234,780	50%
pardinus	240,320,723,664	100%
withered-freddy	2,578,603,380	100%
goblinknackers	88,722,215,241	8%
hoaithu	7,200,899,392	21.25%
aconsciousness	2,708,394,883	95%
deepdives	378,557,688,671	100%
goingbonkers	67,627,302,835	100%
skylinebuds	752,953,083	15%
anhvu	4,742,235,147	20%
bengiles	26,372,315,443	3.75%
bagpuss	643,101,857	5%
tipsybosphorus	5,818,254,296	90%
wonderlamp	857,035,934	50%
chike4545	971,775,653	100%
reteem	989,086,805	25%
canna-curate	40,640,106,989	15%
darkprince66	580,749,087	100%
canna-collective	960,288,472	3%
courtneyjensen	1,401,173,808	100%
pocketjs	86,495,676	6.63%
riskneutral	11,982,052,450	100%
thrasher666	2,544,778,892	60%
milky-concrete	166,594,421,015	100%
nmcdougal94	1,466,887,952	10%
deadcountry	492,926,951	10%
iovoccae	5,076,611,030	100%
captain.future	2,203,981,081	50%
sbi10	53,029,885,746	25.03%
dfroberg	857,575,146	50%
bia.birch	7,807,810,356	50%
steemlandia	5,052,594,925	100%
maajaanaa	1,145,823,258	20%
starrouge	984,393,142	50%
retrodroid	14,534,118,033	50%
wherein	24,313,741,043	100%
equipodelta	148,138,086,578	80%
zerofive	827,827,909	50%
northmountain	26,108,599,335	100%
jacuzzi	677,652,459	1.4%
primeradue	876,664,459	50%
johan.norberg	89,520,866,597	100%
cnstm	118,666,260,916	100%
likuang007	597,200,305	100%
lianjingmedia	902,912,850	100%
broxi	2,191,630,890	7.5%
steemtelly	2,143,879,905	6.63%
photoparadise	3,347,254,827	12.5%
goodcontentbot	807,418,449	15%
hungrybear	612,782,143	14%
bluemaskman	1,800,018,863	7.5%
croyston117	17,417,726,778	100%
thelogicaldude	11,765,405,148	25%
hungryharish	25,137,308,192	100%
maxsieg	16,264,756,443	100%
hungryanu	3,405,521,072	50%
photographercr	509,826,359	20%
blue.rabbit	249,779,623,658	50%
cesky.donator	8,525,652,763	80%
bigmoneyman	909,602,308	50%
tenkminnows	209,489,677,647	50%
deeanndmathews	69,093,217,453	100%
matildamoment	89,775,799,448	50%
clownworld	4,748,921,535	50%
leighscotford	9,629,119,924	12.5%
weedcash	849,077,410	4.95%
steemindian	4,274,321,976	100%
davidtron	3,176,923,983	50%
waraira777	2,023,962,988	50%
farm1	874,770,502,486	100%
sbi-tokens	804,385,478	1.17%
the.unicorn	573,585,721	100%
oratione	946,978,935	100%
gigel2	1,057,485,343,072	100%
therealyme	12,016,778,857	2.25%
bilpcoin.pay	542,882,685	10%
an-sich-wachsen	1,393,584,349	10%
fenngen	3,658,174,832	50%
apineda	10,416,943,430	100%
rockface	5,924,746,739	100%
thecontesttrain	1,239,027,623	50%
galenkp.aus	1,184,222,809	100%
bpcvoter	464,004,743	50%
inigo-montoya-jr	2,535,382,621	85%
atma.love	376,389,143,994	50%
dec.entralized	20,624,417,985	100%
julesquirin	10,380,870,791	20%
ugochill	42,924,642,040	100%
danielhuhservice	28,950,200,310	10%
thehockeyfan-at	136,772,508,780	20%
hivewatchers	1,902,864,752	55%
abundance.tribe	7,855,458,261	100%
thisismylife	140,252,654,191	100%
softworld	304,441,740,000	49%
ninnu	552,297,112	50%
ecency	390,496,410,988	1%
kingneptune	1,293,722,688	50%
woelfchen	330,119,941,507	100%
devpress	25,617,098	12.5%
jagged71	2,646,878,291	50%
dannewton	120,429,116,642	25%
dobro2020	7,885,881,265	100%
quinnertronics	50,255,510,987	33%
olaunlimited	584,524,543	45%
ecency.stats	352,033,579	1%
earthsea	15,876,364,049	50%
liz.writes	1,060,059,566	50%
r-nyn	156,160,871,317	100%
hive-168869	7,594,059,138	100%
barbyjr	4,947,301,799	50%
bluepluto	540,717,996	50%
kattycrochet	80,833,821,498	50%
bulkathos	60,441,742,857	100%
netaterra.leo	964,915,691	13.5%
libertytokens27	785,004,605	100%
eldritchspig	765,643,169	50%
altor	56,163,155,635	100%
tabs1250	4,549,183,405	100%
zdigital222	2,131,288,397	100%
cowboyphylosophy	26,556,059,658	75%
wend1go	24,080,772,375	100%
drricksanchez	41,818,409,773	7.5%
happyfrog420-new	93,632,277,595	90%
mrhoofman	4,248,792,713	25%
janettbrito76	519,966,200	40%
reidenling90	2,516,112,585	100%
okluvmee	89,584,468,343	50%
awakening-along	1,482,337,366	15%
louis.pay	1,277,686,176	75%
hive.friends	916,578,031	50%
brume7	670,757,796	40%
shanhenry	4,297,768,358	100%
magnacarta	5,226,907,492	12.5%
photolovers1	559,689,776	0.5%
meesterbrain	1,905,852,759	100%
cowboyzlegend27	28,430,844,822	100%
jessicaossom	16,627,305,694	50%
pizzadalek	87,958,819,261	50%
celeste413	1,144,513,986	100%
delver	47,568,568,433	100%
pishio	449,730,081,844	10%
menzo	796,025,214	2.5%
altryx	10,767,021,165	100%
tanzil2024	11,281,836,543	100%
ralphmarcuss	7,648,484,279	100%
snoopgoat	708,178,618	100%
snaqz	1,791,629,751	75%
marsupia	2,107,420,294	50%
amatorrs	20,357,163,017	100%
eolianpariah2	1,251,213,586	0.5%
forsakensushi	491,439,585,223	100%
isdarmady	7,842,539,293	70%
keeper-of-eden	16,134,529,072	50%
brandonperez	0	100%
maroone	22,139,334,845	100%
mengao	422,504,763,493	100%
tillmea	589,601,013	100%
tydynrain	13,546,984,410	10%
gaposchkin	9,451,499,139	100%
famoushade1	423,596,319	32.5%
ssebasv	2,346,954,046	100%
uncorked-reality	2,928,458,736	50%
dkidfit	7,625,658,972	100%
pompeylad	22,326,070,529	100%
promokahka	23,557,507,767	89%
svanbo	8,127,886,622	5%
saboin.weed	435,125,368	22.5%
stickupcurator	5,505,851,144,022	100%
jomancub	1,003,254,492	30%
kvinna	782,796,091,292	49%
blocktunes	9,436,266,708	50%
woodathegsd	787,420,387	7.5%
eduard20	491,383,686	40%
zihadlo	859,556,575	50%
wannatrailwithme	2,749,896,591	50%
karelnt	1,616,436,363	30%
nicklewis	13,047,519,893	25%
mario89	14,734,380,246	38%
kheldar1982	80,917,518,812	65%
abelfotografia	37,510,981,447	12%
duja	6,451,213,196	100%
tgarcialvarez	953,353,851	30%
amakauz	12,003,317,701	50%
hivecuba	678,193,668,927	30%
karizma	3,322,476,226	10%
noakmilo	105,974,806,071	15%
jfuji	145,447,840,138	75%
flummi97	1,093,895,036	69%
yennysferm71	28,076,301,797	40%
demoad	548,631,421	15%
sirclucksalot	15,139,007,673	100%
ricardoeloy	533,820,059	15%
androliuben	2,769,363,737	15%
mdasein	2,127,624,904	10%
resonator	34,157,611,956,878	100%
hmvf	323,820,901,363	50%
cannaworms	6,821,785,991	100%
abrunet	9,487,071,012	50%
coldbeetrootsoup	993,458,362,133	100%
tzae	1,661,932,365	100%
njn	30,929,317,651	100%
revise.spk	676,304,916	100%
kumagaro	636,081,085	50%
pacobeta365	1,094,606,809	6%
hayleysv	3,160,818,338	40%
jagjnr	1,777,664,527	50%
queercoin	191,597,810,457	100%
celestegray	29,298,166,818	50%
hive-132595	1,734,239,177	100%
bank-of-hive	43,879,459,977	100%
brain71	2,235,859,690	50%
theoneblog	1,052,745,493	15%
agrante	3,063,868,269	100%
gornat	5,371,302,251	30%
elnauta	24,459,211	100%
stephenezike	4,972,028,994	100%
lucky7ace	923,687,592	25%
wendy23	8,299,806,244	15%
actordontee	6,516,149,201	50%
blocktunesdao	858,677,660	50%
dovycola	3,704,880,022	100%
ecencypoints	6,171,476,760	25%
wearelegion	65,095,522,090	100%
gollumkp	2,419,435,930	20%
freiheitsammler	181,676,023,119	100%
hive-learn.more	722,587,116	100%
foodchunk	506,600,257,348	100%
david17-sw	438,307,385	100%
coinjoe	29,389,207,724	20%
samueluche07	2,444,709,091	50%
hpud.wettbewerb	3,414,335,327	100%
mita3	1,778,788,994	30%
yummycruz1	5,768,797,812	100%
edeyglezsosa	1,724,744,173	6%
like2cbrs	627,842,880	100%
cbrsphilanthropy	77,559,847,535	100%
ligobregon	0	100%
bibana	4,405,671,843	100%
revolverocelotyt	1,008,172,239	100%
justinmora	72,287,332,171	100%
pollodlp	2,037,703,392	100%
setpiece	848,822,418	100%
frgnholding	56,313,300,764	100%
hive.helps	210,334,705,599	100%
leopard0	736,761,074	30%
brayanmcy	3,469,877,799	100%
tecnotronics	8,394,991,959	100%
legionsupport	3,145,175,286,450	100%
hive-world-champ	3,474,415,292	10%
spltrader	3,838,185	100%
swtzyserrah	0	100%
cocinator	513,112,456	100%
laziadri	0	100%
noke	0	100%

@beerlover · Aug 22 '24

<div class='pull-right'>https://files.peakd.com/file/peakd-hive/beerlover/yiuU6bdf-beerlover20gives20BEER.gif<p><sup><a href='https://hive-engine.com/?p=market&t=BEER'>View or trade </a> <code>BEER</code>.</sup></p></div><center><br> <p>Hey @pharesim, here is a little bit of <code>BEER</code> from @pardinus for you. Enjoy it!</p> <p>Learn how to <a href='https://peakd.com/beer/@beerlover/what-is-proof-of-stake-with-beer'>earn <b>FREE BEER</b> each day </a> by staking your <code>BEER</code>.</p> </center><div></div>

properties (22)

`author`	beerlover
`permlink`	re-pharesim-script-to-create-a-csv-file-with-all-financial-transactions-ie-for-tax-purposes-20240822t234048489z
`category`	hive-139531
`json_metadata`	{"app":"beerlover/3.0","language":"rust","developer":"wehmoen"}
`created`	2024-08-22 23:40:48
`last_update`	2024-08-22 23:40:48
`depth`	1
`children`	0
`last_payout`	2024-08-29 23:40:48
`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`	521
`author_reputation`	25,761,421,138,206
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,469,878
`net_rshares`	0

@dobro2020 · Aug 23 '24

Niceee i would like do the same in javascript

properties (22)

`author`	dobro2020
`permlink`	re-pharesim-2024822t224242100z
`category`	hive-139531
`json_metadata`	{"content_type":"general","type":"comment","tags":["hive-139531","hive","transactions","accounting","taxes"],"app":"ecency/3.1.5-mobile","format":"markdown+html"}
`created`	2024-08-23 01:42:42
`last_update`	2024-08-23 01:42:42
`depth`	1
`children`	0
`last_payout`	2024-08-30 01:42:42
`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`	46
`author_reputation`	65,342,077,586,891
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,471,347
`net_rshares`	0

@edina76 · Feb 15

Vielen Dank! Deine Version mit Github überstieg meinen technischen Verständniss, aber die waivio-Seite konnte ich gut nutzen! Genau das, was ich suchte. Vielen Dank fürs Teilen!

properties (22)

`author`	edina76
`permlink`	re-pharesim-srqlww
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2025.2.3","image":[],"users":[]}
`created`	2025-02-15 18:26:54
`last_update`	2025-02-15 18:26:54
`depth`	1
`children`	0
`last_payout`	2025-02-22 18:26:54
`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`	177
`author_reputation`	43,801,270,070,253
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	140,813,233
`net_rshares`	0

@hive.helps · Aug 23 '24

Great thank you. Will test it after my vacation. Good that people invest their time and effort to help the community.

properties (22)

`author`	hive.helps
`permlink`	re-pharesim-siov0i
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-23 20:45:48
`last_update`	2024-08-23 20:45:48
`depth`	1
`children`	0
`last_payout`	2024-08-30 20:45:48
`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`	118
`author_reputation`	34,141,636,746,765
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,489,166
`net_rshares`	0

@hivebuzz · Aug 23 '24

Congratulations @pharesim! 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/@pharesim/replies.png?202408230304"></td><td>You got more than 7000 replies.<br>Your next target is to reach 7250 replies.</td></tr>
</table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@pharesim) 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-1724382462
`category`	hive-139531
`json_metadata`	{"image":["https://hivebuzz.me/notify.t6.png"]}
`created`	2024-08-23 03:07:42
`last_update`	2024-08-23 03:07:42
`depth`	1
`children`	0
`last_payout`	2024-08-30 03:07:42
`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`	623
`author_reputation`	369,197,217,943,406
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,472,220
`net_rshares`	0

@hivebuzz · Sep 20 '24

Congratulations @pharesim! You received a personal badge!

<table><tr><td>https://images.hive.blog/70x70/https://hivebuzz.me/badges/hivefest-9.s5.png?202409201440</td><td>HiveFest 9 Attendee</td></tr></table>

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

properties (22)

`author`	hivebuzz
`permlink`	notify-1726844405
`category`	hive-139531
`json_metadata`	{"image":["https://hivebuzz.me/notify.t6.png"]}
`created`	2024-09-20 15:00:06
`last_update`	2024-09-20 15:00:06
`depth`	1
`children`	0
`last_payout`	2024-09-27 15:00:06
`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`	372
`author_reputation`	369,197,217,943,406
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	137,228,655
`net_rshares`	0

@holdonla · Sep 27 '24

$0.15

Thank you very much. It works great.

👍 zekepickleman

`author`	holdonla
`permlink`	re-pharesim-skgq3c
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.7"}
`created`	2024-09-27 08:26:00
`last_update`	2024-09-27 08:26:00
`depth`	1
`children`	0
`last_payout`	2024-10-04 08:26:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.076 HBD
`curator_payout_value`	0.076 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	36
`author_reputation`	47,464,467,397,162
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	137,448,765
`net_rshares`	561,549,162,859
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
zekepickleman	0 B		561,549,162,859	100%

@latinowinner · Aug 23 '24

we should consider to go temporarily to tax crypto heavens like Vanuatu or El salvador

properties (22)

`author`	latinowinner
`permlink`	re-pharesim-2024823t11024663z
`category`	hive-139531
`json_metadata`	{"tags":["hive","transactions","accounting","taxes"],"app":"ecency/3.2.0-vision","format":"markdown+html"}
`created`	2024-08-23 01:00:24
`last_update`	2024-08-23 01:00:24
`depth`	1
`children`	0
`last_payout`	2024-08-30 01:00:24
`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`	86
`author_reputation`	2,806,502,129,785
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,470,844
`net_rshares`	0

@oblivioncubed · Aug 23 '24

$0.03

Fantastic! There is an option on the wavio UI that lets you download a bunch of transactions as well but it requires some editing to work with something like... Koinly or whatever that tax service is.

👍 pharesim

`author`	oblivioncubed
`permlink`	re-pharesim-sin9hs
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-23 00:03:30
`last_update`	2024-08-23 00:03:30
`depth`	1
`children`	2
`last_payout`	2024-08-30 00:03:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.016 HBD
`curator_payout_value`	0.017 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	200
`author_reputation`	168,954,521,354,471
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,470,160
`net_rshares`	127,659,962,565
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
pharesim	0 B		127,659,962,565	10%

@pharesim · Aug 23 '24

Very interesting, thanks for sharing. I didn't check out Koinly yet, but will soon probably. I assume that platform works better with all individual transactions like waivio outputs it. My script aggregates the data into fewer rows so my accountant doesn't get a heart attack. Unfortunately it's missing the producer rewards there, which are of course very important for me. 

Good to have different tools available to fit different needs! 
To save those interested some googling work, here's a link:
https://www.waivio.com/@hbdstabilizer/transfers/table

properties (22)

`author`	pharesim
`permlink`	re-oblivioncubed-sina4y
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-23 00:17:24
`last_update`	2024-08-23 00:17:24
`depth`	2
`children`	1
`last_payout`	2024-08-30 00:17:24
`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`	554
`author_reputation`	239,352,620,843,716
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,470,362
`net_rshares`	0

@oblivioncubed · Aug 23 '24

Thanks for adding the link! I meant to but it's difficult with a 4 week old napping on me 😂

properties (22)

`author`	oblivioncubed
`permlink`	re-pharesim-sinaf7
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-23 00:23:30
`last_update`	2024-08-23 00:23:30
`depth`	3
`children`	0
`last_payout`	2024-08-30 00:23: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`	91
`author_reputation`	168,954,521,354,471
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,470,408
`net_rshares`	0

@pardinus · Aug 22 '24

This seems incredibly useful, thanks a ton for sharing! !BEER

properties (22)

`author`	pardinus
`permlink`	re-pharesim-sin8fs
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-22 23:40:39
`last_update`	2024-08-22 23:40:39
`depth`	1
`children`	0
`last_payout`	2024-08-29 23:40:39
`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`	61
`author_reputation`	378,515,499,733,692
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,469,875
`net_rshares`	0

@ratel · Aug 23 '24

Oh, it's a very useful tool! Need it, I added in the bookmarks.

properties (22)

`author`	ratel
`permlink`	re-pharesim-2024823t93043884z
`category`	hive-139531
`json_metadata`	{"tags":["hive","transactions","accounting","taxes"],"app":"ecency/3.2.0-vision","format":"markdown+html"}
`created`	2024-08-23 02:30:45
`last_update`	2024-08-23 02:30:45
`depth`	1
`children`	0
`last_payout`	2024-08-30 02:30:45
`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`	64
`author_reputation`	718,439,179,586,955
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,471,778
`net_rshares`	0

@sanjeevm · Aug 23 '24

I have not tried to do any work on calculating my earnings in hive, because, in actual, unless I convert them and take to my bank account, it's not earned, isn't that right ?

properties (22)

`author`	sanjeevm
`permlink`	re-pharesim-sioery
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-23 14:55:12
`last_update`	2024-08-23 14:55:12
`depth`	1
`children`	3
`last_payout`	2024-08-30 14:55:12
`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`	174
`author_reputation`	673,709,868,747,685
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,481,488
`net_rshares`	0

@pharesim · Aug 23 '24

Depends on where you live, but most countries tax crypos same as stocks or other assets by now.

properties (22)

`author`	pharesim
`permlink`	re-sanjeevm-siof3q
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-23 15:02:18
`last_update`	2024-08-23 15:02:18
`depth`	2
`children`	2
`last_payout`	2024-08-30 15:02:18
`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`	95
`author_reputation`	239,352,620,843,716
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,481,635
`net_rshares`	0

@sanjeevm · Aug 23 '24

Ya, even my country does impose a 30% tax, but unless you convert to fiat, its not our earnings, isn't it ?

properties (22)

`author`	sanjeevm
`permlink`	re-pharesim-sioj3t
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-23 16:28:42
`last_update`	2024-08-23 16:28:42
`depth`	3
`children`	1
`last_payout`	2024-08-30 16:28:42
`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`	108
`author_reputation`	673,709,868,747,685
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,483,073
`net_rshares`	0

1 reply

@sircork · Aug 24 '24 (edited)

Nice one. People seem to be responding to this really well. I'm jelly compared to how hard it is to get eyes and project supporting upvotes on the things I am building and posting updates about. :P 

Are you going to publish this on public facing tools site anywhere? My public free hive tools server is just a little vps with some php apps on it and my big server for hivestreams.live is very purpose built for laravel, react and node, and is all tied up in being the rtmp streaming server so its not good for a tools site loading up the ram with big chain pulls either. 

But this seems like something you could slap keychain on, ask for a username and spit out pretty PDFs for people without too much effort, and I am sure the community would love it if you did. Github, python and beem and APIs and RPCs and web services, are sort of an advanced class for the typical account holder around here after all, I bet the crowd would love an easy button for this. 

Granted it, as you said, is load heavy, but it seems feasible to productize it. People who have big money tax concerns would probably pay a few hive for a pretty printing report too. maybe paywall it to cover the ram and cpu. 

Just up from a day sleep after coding on my own projects for like 24 hours straight to solve and rush features out, and drinking coffee and spitballing here about ideas for this very useful tool you made.

properties (22)

`author`	sircork
`permlink`	re-pharesim-sipmmg
`category`	hive-139531
`json_metadata`	{"tags":"hive-139531"}
`created`	2024-08-24 06:42:18
`last_update`	2024-08-24 06:42:57
`depth`	1
`children`	14
`last_payout`	2024-08-31 06:42:18
`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`	1,397
`author_reputation`	40,884,085,696,666
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,495,669
`net_rshares`	0

@pharesim · Aug 24 '24

> Nice one. People seem to be responding to this really well. I'm jelly compared to how hard it is to get eyes and project supporting upvotes on the things I am building and posting updates about. :P

I'm a little surprised too, but even more that nobody did it before. How's everyone been keeping their books?

Your suggestion with the webinterface and pay to download was what I meant saying I thought about a paid service. But for now I got a long enough backlog with some missing wiki functions, and hiveinvite _really_ needs a complete overhaul. 
Selling stuff also comes with further complications like VAT and possible liabilities. Maybe at a later stage, if the community starts growing again at some point it might be worth it. 
I wouldn't mind someone else sets that up in the meantime though.

👍 sircork

`author`	pharesim
`permlink`	re-sircork-sipt4j
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-24 09:02:54
`last_update`	2024-08-24 09:02:54
`depth`	2
`children`	13
`last_payout`	2024-08-31 09:02:54
`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`	804
`author_reputation`	239,352,620,843,716
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,496,941
`net_rshares`	7,045,474,121
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
sircork	0 B		7,045,474,121	100%

@sircork · Aug 24 '24

I don't know python well and I am starting to immerse in my own pile of to-dos and user requests for what I am building already but I should know python, I started making money in the industy with Perl in 1990 or so, and did PHP for a couple decades now, and a couple other stacks I am at least basically literate in enough to get an app up, but never picked up Python for some reason. Probably because coming from PHP it didn't really offer me much more that I needed. I am not a data scientist and that's where python seems really strong, industry wise. 

But I hear you on selling stuff. I have no idea how I am going to "sell" anything for HiveStreams.Live, or how I will fund it's operations. I am taking the "Uber" approach. Build a thing, figure out how to make money with it later, maybe, hopefully, somehow. Cause SirCork gets soo hungry when he's broke. :)

properties (22)

`author`	sircork
`permlink`	re-pharesim-sipthp
`category`	hive-139531
`json_metadata`	{"tags":["hive-139531"],"app":"peakd/2024.8.6"}
`created`	2024-08-24 09:10:36
`last_update`	2024-08-24 09:10:36
`depth`	3
`children`	12
`last_payout`	2024-08-31 09:10:36
`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`	867
`author_reputation`	40,884,085,696,666
`root_title`	"Script to create a CSV file with all financial transactions (i.e. for tax purposes)"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	136,497,027
`net_rshares`	0

12 replies