Crypto Tax & Cost-Basis Spreadsheet

FIFO cost basis, short- and long-term gains, a Form 8949-style disposal report and a staking/airdrop income summary by tax year.

$24Buy now, $24

Instant download + email. Works in Google Sheets and Excel.

Secure checkout by StripeApple PayGoogle Pay

If a file doesn’t work, we’ll fix it. If we can’t, you get a refund within 7 days. Because these are instant digital downloads, there are no refunds for change of mind.

  • Instant download + step-by-step setup guide
  • Works in Google Sheets and Excel
  • One-time price, no subscription
  • No bank login, nothing to connect
  • File won't open? We fix it or send a new copy

Try it free first: Crypto FIFO gains calculator.

Read the setup guide before you buy

Who it's for

Individual holders with a manageable number of trades who want a private, checkable record. Not for high-frequency traders, DeFi power users or businesses; use dedicated software or a professional for those.

Why it helps

Log every buy, sell, reward, transfer and fee once. The sheet matches each sale to your oldest coins first (FIFO) and builds a year-by-year report you can hand to a preparer. No exchange login, no API keys.

What it does

  • Transaction log for Buy, Sell, Income (staking, airdrops, rewards), Transfer and Fee
  • FIFO cost basis per sale, split into short-term (365 days or less) and long-term
  • Tax Report tab: every disposal in the chosen year in a Form 8949-style layout
  • Income tab: rewards valued at the USD price you type for the day received
  • Holdings with average cost, unrealized P/L and allocation chart
  • Checks that flag oversold coins and incomplete rows

What's included

One .xlsx workbook with 8 tabs: Start Here, Example, Holdings, Transactions, Gains, Tax Report, Income, DCA Planner. Sample data loaded. FIFO only (HIFO and specific ID are not supported). Plus a step-by-step setup guide PDF. Works in Google Sheets and Excel (also LibreOffice Calc).

Includes English, Spanish and French versions.

Every tab, with sample data

Real screenshots of each tab in the file, recalculated from the included sample data.

Crypto Tax & Cost-Basis Spreadsheet: Start Here tab
Start Here
Crypto Tax & Cost-Basis Spreadsheet: Example tab
Example
Crypto Tax & Cost-Basis Spreadsheet: Holdings tab
Holdings
Crypto Tax & Cost-Basis Spreadsheet: Transactions tab
Transactions
Crypto Tax & Cost-Basis Spreadsheet: Gains tab
Gains
Crypto Tax & Cost-Basis Spreadsheet: Tax Report tab
Tax Report
Crypto Tax & Cost-Basis Spreadsheet: Income tab
Income
Crypto Tax & Cost-Basis Spreadsheet: DCA Planner tab
DCA Planner

What happens after you buy

  1. Pay with Stripe (card, Apple Pay or Google Pay).
  2. Download right away on your download page; the link is also emailed to you. Each file can be downloaded 3 times within 24 hours.
  3. Follow the setup guide: a step-by-step PDF is included, and the same steps are on the setup page. The AI guide in the corner can walk you through it one step at a time.

10 min

Set up in 10 minutes, or Ava walks you through it free

Ava the Fox, our AI setup guide, takes you one step at a time and can hand you to a person if you get stuck.

Please note. Informational tool only. Not financial, tax, or legal advice. Estimates come from the numbers you type. If a file doesn’t work, we’ll fix it. If we can’t, you get a refund within 7 days. Because these are instant digital downloads, there are no refunds for change of mind.

Not tax advice. Not tax advice and not tax software. Estimates only; verify every figure with a qualified tax professional before filing.

FAQ

Can I file my taxes with this?

It is not tax software and not tax advice. It organizes your records and estimates FIFO gains; verify every figure with a qualified tax professional.

Does it support HIFO or specific identification?

No. It uses FIFO only, and says so in the file.

How are staking rewards handled?

Type them as Income with the USD value on the day received. They appear on the Income tab and become new cost-basis lots.

What do I get?

A download link right after checkout and by email, plus a step-by-step setup guide PDF. Spreadsheets are .xlsx: open in Excel, or upload to Google Drive and save as a Google Sheet.

Do I need a subscription or app?

No. One-time price. No macros, add-ons, or bank login.

Can I get a refund?

If a file doesn’t work, we’ll fix it. If we can’t, you get a refund within 7 days. Because these are instant digital downloads, there are no refunds for change of mind.

Is this financial or tax advice?

No. It is an informational tool. Results are estimates from the numbers you enter.

$24Buy now, $24

Instant download + email. Works in Google Sheets and Excel.

Secure checkout by StripeApple PayGoogle Pay

If a file doesn’t work, we’ll fix it. If we can’t, you get a refund within 7 days. Because these are instant digital downloads, there are no refunds for change of mind.

Bundle and save

Get the Crypto Bundle: Crypto Tracker, Crypto Tax & Cost-Basis and the AI Prompt Library for $39 instead of $53. Pairs well with the Crypto Portfolio + Gains Tracker ($17). Crypto Tax & Cost-Basis Spreadsheet is included in the Complete Money Toolkit: every spreadsheet plus the Notion hub and prompt library for $129 ($231 value).

Crypto Tax & Cost-Basis Spreadsheet$24
Buy now, $24

You may also like