Templates · Crypto
Free DeFi Yield Farming Tracker
Find out if your yield farming is actually making money after gas and impermanent loss. This tracker covers liquidity pools, lending, staking, and vault strategies — with columns for APY, rewards, gas costs, and your real net yield.
- Crypto
- Tracker
- Free template
What's included
This tracker includes 4 sections covering everything you need.
Active Positions
Everything you currently have deployed in DeFi, with APY and value tracking.
| Protocol | Chain | Strategy Type | Deposited Value | Current Value | APY | Rewards Token | Rewards Earned |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
Gas Cost Log
Every gas fee you paid to enter, claim, or exit a position.
| Date | Protocol | Action | Gas (ETH) | Gas (USD) | Chain |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Yield vs Cost Analysis
The real question: are you actually profitable after gas and impermanent loss?
| Protocol | Gross Yield (USD) | Gas Costs | Impermanent Loss | Net Yield | Effective APY |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Closed Positions
DeFi positions you have exited, with the final profit or loss.
| Protocol | Entry Date | Exit Date | Deposited | Withdrawn | Rewards | Gas Total | Net P&L |
|---|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- | --- |
How to use this template
Follow these steps to get the most out of this template.
- 1
When you enter a DeFi position, log the protocol, chain, deposit amount, and starting APY.
- 2
Track gas costs on every transaction — deposits, claims, compounding, withdrawals.
- 3
Record rewards as you claim them, noting the token and USD value at the time.
- 4
Periodically calculate impermanent loss by comparing your LP position to just holding the tokens.
- 5
When you exit, figure out your net P&L by subtracting gas and impermanent loss from rewards.
- 6
Compare effective APY (after all costs) across positions to see what is actually worth your time.
Who this template is for
Active yield farmers running positions across multiple DeFi protocols.
Liquidity providers who need to track impermanent loss alongside rewards.
DeFi users who want to know if their strategies are actually profitable after gas costs.
Crypto investors considering yield farming and wanting to model potential returns.
Why use Clarity instead?
This template is great for manual tracking, but Clarity automates everything for you. Connect your bank accounts, brokerages, exchanges, and wallets and see real-time data without entering a single number.
- Automatic transaction imports from 12,000+ institutions
- Real-time portfolio values and net worth tracking
- AI-powered spending insights and budget recommendations
- Tax-ready reports with automatic cost basis calculations
- One dashboard for banks, brokerages, crypto, and DeFi
Frequently Asked Questions
How do I calculate effective APY after gas costs?
Effective APY = (Net Yield / Principal) * (365 / Days Active) * 100. Net Yield = Gross Rewards minus Gas Costs minus Impermanent Loss. Heads up: many positions advertised at 50%+ APY deliver single-digit effective returns once you factor in gas, especially on Ethereum mainnet.
Is yield farming income taxable?
Yes. Rewards you earn are taxed as ordinary income at the fair market value when you receive them. On top of that, exiting a liquidity pool can trigger capital gains on the underlying tokens. Gas fees may be addable to your cost basis.
How do I track yield farming across multiple chains?
Use separate sections or tabs for each chain (Ethereum, Arbitrum, Solana, etc.) since gas structures are totally different. Clarity can connect to multiple chains and pull your DeFi positions together automatically.
Related templates
Other templates you might find useful.
Crypto Portfolio Tracker
See your entire crypto portfolio in one view, no matter how spread out it is across exchanges, wallets, and DeFi protocols. Track positions, cost basis per coin, overall allocation, and DeFi positions.
TaxCrypto Tax Worksheet
Get your crypto transactions organized for tax time. This worksheet covers buys, sells, swaps, and income events. It calculates short-term and long-term capital gains using FIFO and flags potential wash sales.
Ready to go beyond spreadsheets?
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.