Stake Rewards Overview for your Tax Report

Hello everyone :v:
In many countries the income from staking has to be taxed. In this post I will show you how to create a simple and quick overview of your staking rewards with Pooltool.io and Excel.


Overview

  1. Get your wallet data
  2. Import your .csv to Excel
  3. Reduce to what you need
  4. Make the data useable
  5. Provide clarity to the overview

Get your wallet data

Visit Pooltool.io and select the function ‘EXPORT REWARDS DATA FOR TAXES’.
Insert your wallet address click on the magnifier and follow the blue right arrow button.

Scroll down to the bottom to ‘Export Tool’.
Choose ‘Generic(CSV)’ as format.
Select your national currency and time period.
Download your data.


Import your .csv to Excel

Create a new workbook in Excel.
Import your .csv with ‘Data’ -> ‘From Text/CSV’

3

Use ‘comma’ as delimiter and ‘Do not detect data types’ as data type detection.
Click on ‘Transform Data’.

4


Reduce to what you need

Remove columns you don’t need.
Mark them -> Right-click -> remove columns


Make the data useable

To get usable decimal numbers mark the columns stake, stake_rewards, rate and stake_rewards_value.
Click on ‘Transform’ -> ‘Parse’ -> JSON

Click on ‘Close & Load’


Provide clarity to the overview

Through the transformation we have lost some column names.
Column 3: stake
Column 6: total rewards
Column 8: rate
Column 11: value

Use appropriate formats for your values. Mark the column -> right-click -> Format Cells
My recommendation:
‘stake’ + ‘total rewards’: one decimal place
‘rate’: national currency with 3-4 decimal places
‘value’: national currency with 2 decimal places

10

To complete the overview you can insert an AutoSum function for the ‘value’ and ‘total rewards’ column.

11


Note

Pooltool.io makes no warranty for the accuracy of the exported data.
Check your data for plausibility.
All data used here is from a randomly selected wallet.

7 Likes

Thanks @Chris28 for that guide! :slight_smile:

2 Likes

“It’s been a while since we’ve seen @Chris28” :)) Great to see you again.

2 Likes