Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceInvestment TrackingCrypto Portfolio Tracker

SpreadsheetInvestment TrackingFree

Crypto Portfolio Tracker

Holdings built from your buys, sells and staking rewards, with average cost, unrealised and realised gains, allocation and rebalancing.

Shown with sample data

Colour

Crypto Portfolio Tracker

Holdings built from your buys, sells and staking rewards, with average cost, unrealised and realised gains, allocation and rebalancing.

Portfolio value
$49,891
Unrealised gain
$4,034
Realised gains this year
$1,270
Staking income this year
$433.71
Usually taxable as income
Largest position
46%
Total invested (buys)
$51,678
Sale proceeds
$7,525
Fees paid
$68
Allocation by coin
  • BTC$23,12546%
  • ETH$10,089.2820%
  • LINK$5,22010%
  • USDC$5,00010%
  • SOL$4,506.409%
  • ADA$1,9504%
Unrealised gain by coin
  • BTC$1,523.13
  • SOL$1,126.65
  • LINK$1,075.86
  • ADA$398.45
  • ETH-$89.71

How to use it

  1. 1Log every transaction on the Transactions sheet: type, coin, quantity, price per coin in dollars and any fee.
  2. 2On Holdings, update Current price for each coin when you review the portfolio.
  3. 3Set a target allocation for each coin; the shares should add up to 100%.
  4. 4Read Rebalance: Trim or Add show coins more than 5 points away from target.
  5. 5At tax time, total realised gains and staking income from the Transactions sheet and compare with your exchange reports.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Exchange dashboards only show what is on that exchange. Log every buy, sell, staking reward and coin fee across exchanges and wallets; the tracker builds your holdings, average cost per coin and cost basis, shows market value and unrealised gain at the prices you enter, calculates realised gain on each sale and staking income for tax time, and flags coins that have drifted from your target allocation.

Who it’s for

  • Holding coins across several exchanges and wallets
  • Keeping a cost-basis record for tax returns
  • Sticking to a target allocation instead of chasing prices

What’s included

  • Holdings sheet: What you hold, what it cost and what it is worth.
  • Transactions sheet: Every buy, sell, reward and coin fee.

How to use it

  1. 1Log every transaction on the Transactions sheet: type, coin, quantity, price per coin in dollars and any fee.
  2. 2On Holdings, update Current price for each coin when you review the portfolio.
  3. 3Set a target allocation for each coin; the shares should add up to 100%.
  4. 4Read Rebalance: Trim or Add show coins more than 5 points away from target.
  5. 5At tax time, total realised gains and staking income from the Transactions sheet and compare with your exchange reports.

Tips

  • Record staking and airdrop rewards at their dollar value on the day received; in the US that value is income and becomes the coin’s cost basis.
  • Transfers between your own wallets are not taxable; leave them out so quantities stay correct, but keep the records.
  • Never store seed phrases, private keys or exchange passwords in a spreadsheet.

Questions

How is cost basis calculated here?

Average cost: total spent on buys (including fees) plus the value of rewards, divided by coins acquired. Many tax authorities require FIFO or allow specific identification, so treat this as an estimate and use your tax software’s figures for filing.

Are crypto staking rewards taxable?

In the US and many other countries, rewards are taxed as income when you receive them, at their market value then. Selling them later creates a capital gain or loss.

Do I pay tax when I swap one coin for another?

Usually yes: in the US a swap is treated as selling the first coin. Record it here as a sell of one coin and a buy of the other at the same dollar value.

Related searchescrypto portfolio trackercryptocurrency tracker spreadsheetcrypto cost basisbitcoin portfolio trackercrypto gains calculatorcrypto tax tracker

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetInvestment TrackingFree

Crypto Portfolio Tracker

Holdings built from your buys, sells and staking rewards, with average cost, unrealised and realised gains, allocation and rebalancing.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More investment tracking templates

View all
Investment Portfolio Tracker2 sheets

Portfolio value

$74,144

Unrealised gain

$13,013

Total return

21%

Allocation by asset class
51%
  • US stocks
  • International stocks
  • Bonds
  • Real estate
SpreadsheetInvestment Tracking

Investment Portfolio Tracker

Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.

10 min setupPreview
Dividend Income Tracker3 sheets

Forward annual income

$1,439

Per month

$120

Portfolio yield

2%

Dividends by month
$183.04
$178.14
$172.74
$110.28
$106.08
SepJunMarOctJan
SpreadsheetInvestment Tracking

Dividend Income Tracker

Forward annual income, yield and yield on cost per holding, plus every payment logged by month.

10 min setupPreview
Asset Allocation & Rebalancing Planner3 sheets

Portfolio value

$117,300

Classes out of range

2

Largest drift

10%

ABCD
1Asset classTargetCurrent valueCurrent share
2Global equities55%$75,70065%
3Home equities10%$9,8008%
4Bonds20%$17,40015%
5Property5%$6,1005%
Allocation
SpreadsheetInvestment Tracking

Asset Allocation & Rebalancing Planner

Current holdings against your target mix, drift by asset class and the trades that bring you back.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ