๐บ๐๐ข๐๐๐๐๐๐ ๐๐๐๐ ๐๐๐ ๐๐๐๐๐๐๐ ๐๐๐๐๐๐๐๐๐
People keep asking here how to enter earnings from Staking or Lending and how to convert daily credits into Euro values without investing a lot of work / money.
Since there is currently no automated way to import the earnings into getquin, my advice would be to calculate and enter the earnings once a month. This way you have a monthly overview and don't clutter your account with countless transactions.
The main problem is that earnings are credited daily and for an accurate calculation you also need the euro value at the time of the credits. At the latest for the tax return this is advisable. How I get these values I explain in the last section. The entry on getquin I do as follows.
Create a new transaction "Dividend". As security you select the stake, for example ETH or ADA, if you have staked ETH or ADA. In Pieces you enter the number of coins that are staked. As date I choose the last day of the month. If you want to summarize quarterly or weekly, analogously the last day of the quarter or the week. Dividend per share is the sum of all earnings divided by the number of shares. If you have entered everything correctly, the amount of the dividend received corresponds to the sum of the credits of the period under consideration.
Now you create another transaction "Purchase". The security is again the stake. The pieces are the nominal sum of all received tokens/coins. Date as before. The price is the amount of the dividend divided by the nominal sum of all tokens/coins received.
๐๐ฒ๐ถ๐๐ฝ๐ถ๐ฒ๐น (notional numbers).
Stake: 5 ETH, sum of earnings 100โฌ, nominal sum of all received coins: 2
๐ฃ๐๐๐๐ฝ๐พ๐๐ฝ๐พ ๐ณ๐๐บ๐๐๐บ๐๐๐๐๐
Security: ETH
Pieces: 5
Dividend per share: 100โฌ / 5 = 20โฌ
Amount: 100โฌ
๐ช๐บ๐๐ฟ ๐ณ๐๐บ๐๐๐บ๐๐๐๐๐
Security: ETH
Pieces: 2
Price: 100โฌ / 2 = 50โฌ
Amount: 100โฌ
๐๐๐ฟ๐ผ๐๐ฒ๐ฟ๐๐ฒ ๐๐๐บ ๐ญ๐ฒ๐ถ๐๐ฝ๐๐ป๐ธ๐ ๐ฑ๐ฒ๐ฟ ๐๐๐๐๐ฐ๐ต๐ฟ๐ถ๐ณ๐
I personally use koinly for this. Main reason is that it is free and does almost all the work for me. Since a wide range of providers is supported it should be the easiest solution in many cases. Lending and Stakingrewards can be read out automatically via API interfaces and koinly determines the Euro values for you automatically. All you have to do is click on "sync wallet". The biggest disadvantage is of course that you give a third party insight into your crypto activities. Of course, you could create separate accounts at koinly for different providers so that they are not merged.
To pull the data out of koinly you don't need any great technical skills and once you understand it, it takes about 5 minutes. If you know how to use a word processor and a spreadsheet, you can do it. You go to the corresponding wallet. Then select the cryptocurrency and a time period, for example 01.03 to 31.03. Then set the number of entries per page to 25. Select from the first entry down to the last entry and copy it into a txtfile, copy the contents of the second page into the textfile as well.
Now you have all relevant data and you only have to put the data in form. The easiest way is to use the "replace all" function to delete everything you don't need. Then you also use the replace function to insert separators like a semicolon. Finally you have to adjust the line breaks. First I remove all line breaks and then I add line breaks so that there is one credit per line. Now it is quasi csv compliant and you can copy it into common spreadsheets. Depending on the separators you choose, they will be recognized automatically or you will be asked. Afterwards you can work with the data comfortably.
๐๐ฒ๐ถ๐๐ฝ๐ถ๐ฒ๐น ๐ง๐ฒ๐ ๐๐๐บ๐๐ฎ๐ป๐ฑ๐น๐๐ป๐ด (fictitious values)
Mar 31, 2022
Provider name
Rewardi
1:11 AM
Provider name
+ 0.00022222 ETH
โ โฌ3.14
This is what an entry looks like when you copy it from koinly into a txtfile (e.g. Notepad). With the all replace function (Ctrl+H) you can edit all text blocks at once. Everything we are not interested in we replace with nothing. So ''supplier name'', ''Rewardi'', ''โ โฌ''. Separators are inserted analogously. ''+ '', ''ETH'', are replaced by '';''.
To adjust the line changes you can use the following tool: [1].
"Remove all line breaks
Then "make new line break" before ''Mar''
At the end you have a list with the following formatting. Separator semicolon
Mar 31, 2022 1:11 AM ;0.00022222; 3.14
Mar 30, 2022 etc.
Depending on the settings of your spreadsheet, it might be necessary to replace the dot with a comma, so that the decimal places are recognized correctly. To do this, treat the corresponding column with Edit and Replace.
Basically, I do not recommend to buy Tax Plans from koinly, because you can extract all necessary information as described with little effort. I myself have never bought Tax Plans there and can not make any statement regarding their quality. Accordingly, no reflink.
[1] https://textmechanic.com/text-tools/basic-text-tools/addremove-line-breaks/
The tool has an IP based limitation, per day only 4 uses. More than sufficient for the described case, there are certainly alternatives.
