Crypto Tracking Spreadsheet
Download a crypto tracking spreadsheet built for wallet actions, approvals, source evidence, costs, exits, and review dates rather than price watching.
DeFi Farmer Research Desk
Dec 30, 2025 · 4 min read
In brief. Track each wallet action with its transaction hash, source, approval, exit condition, and next review date; a portfolio balance cannot reconstruct those facts.
On this page6 sections
A useful crypto tracking spreadsheet needs at least 15 fields: UTC date, wallet alias, chain, protocol, action, asset, amount, transaction hash, approval spender, approval limit, source URL, exit condition, next review time, status, and notes.
Download the crypto tracking spreadsheet CSV. It opens in Excel, Google Sheets, LibreOffice, and Numbers.
Crypto portfolio tracking spreadsheet fields
| Field | What to enter | Why it earns a column |
|---|---|---|
date_utc | ISO timestamp | Blockchains and campaign cutoffs use time zones precisely |
wallet_alias | Activity wallet name, never a seed phrase | Shows which key owns the action |
chain | Exact network | The same address can have different approvals per chain |
protocol | Product used | Groups positions and incidents |
action | Deposit, swap, bridge, approve, unstake, claim | Makes the record operational |
asset, amount | Token symbol and quantity | Reconstructs exposure without relying on today's USD price |
tx_hash | Explorer transaction hash | Verifiable execution evidence |
approval_spender, approval_limit | Contract and cap | Reveals permissions that survive the position |
source_url | Official rule or docs page | Preserves the reason for the action |
exit_condition | Observable trigger | Turns monitoring into a decision |
next_review_utc | Scheduled check | Prevents abandoned approvals and positions |
status | Planned, open, queued, closed, failed | Separates intent from execution |
A transaction hash alone is not a record. It shows what executed, not which rule you relied on, what you approved, or when you planned to exit.
Crypto trading spreadsheet formulas
Add four calculated columns when you need performance:
net_cash_flow = proceeds + rewards_sold - deposits - gas - bridge_fees - trading_fees - funding
net_pnl = current_exit_value + cumulative_net_cash_flow
roi = net_pnl / capital_deployed
capital_days = eligible_balance x days_eligible
Capital-days is more useful than points for cross-program comparison because dollars and days share a real unit; points from two protocols do not.
Keep realized rewards separate from displayed points. Until points can be claimed and sold, their realized value is $0.
Airdrop tracking spreadsheet example
Suppose wallet activity-01 bridges 500 USDC to Base, approves a lending market for 500 USDC, and deposits 450 USDC.
Use three rows, not one:
- Bridge: source transaction, bridge route, destination asset contract, $ cost.
- Approval: spender contract, allowance, and planned revoke date.
- Deposit: market contract, receipt asset, exit condition, and review time.
If the protocol changes its points rules, update the source and add a new dated note; do not overwrite the evidence used for the original decision.
Crypto tax spreadsheet limits
This template is an operational ledger, not a complete tax lot system. Tax accounting may need acquisition basis, disposal proceeds, lot-selection method, fair market value at receipt, transaction classification, and jurisdiction-specific treatment.
Do not infer tax basis from current wallet balances. Transfers between your own wallets can look like disposals to a naive importer, and DeFi receipt tokens can create transactions that require separate classification. Export raw exchange and wallet histories before a platform's retention period expires and consult a qualified local professional for tax treatment.
How to keep a crypto spreadsheet useful
- Use UTC and ISO dates such as
2026-07-18T14:30:00Z. - Use wallet aliases in shared files; keep addresses in a protected lookup if needed.
- Link official docs, not screenshots or influencer summaries.
- Never store seed phrases, private keys, API secrets, or recovery codes.
- Protect formulas and validation columns from accidental edits.
- Keep an append-only raw export separate from the working view.
- Review queued withdrawals and unlimited approvals weekly.
Our strongest opinion: price is the least irreplaceable field. A market data service can rebuild price history; it cannot recover a deleted rule page or explain why you approved an unknown spender.
Use crypto due diligence to define stop conditions and token approval checker for the permission audit.
Sources
Keep reading
Related research
Cardano Two-Layer Architecture Settlement Computation
Cardano settlement and computation explained accurately: the original CSL/CCL concept, today's eUTXO ledger, Plutus validation, consensus, and Layer 2.
S1 Safe
Is the SafePal S1 safe? A current threat-model review of its QR signing, secure element, firmware, recovery, supply-chain exposure, and daily use.
NBA Top Shot Class Action
NBA Top Shot class actions explained by case, court, class period, settlement amount, claim status, and the documents collectors should verify.
Dogechain Bridge
Use the Dogechain bridge with clear steps, custody and signer risks, the 100 DOGE minimum, confirmation rules, fees, and withdrawal troubleshooting.
Get the next field guide
New protocol research, risk checks, and practical DeFi tools.