𝙺𝚛𝚢𝚙𝚝𝚘𝚛𝚎𝚠𝚊𝚛𝚍𝚜 𝚊𝚞𝚏 𝚐𝚎𝚝𝚚𝚞𝚒𝚗 𝚎𝚒𝚗𝚝𝚛𝚊𝚐𝚎𝚗
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.