Home › Templates › Crypto airdrop tracker

Crypto Airdrop Tracker Spreadsheet

A free airdrop tracker for Excel and Google Sheets with a US tax layout. Log each airdrop or hard-fork token at the moment you could first sell or move it, with its fair market value then. The sheet works out the ordinary income and cost basis of each lot, links later sales to the lot, splits short-term and long-term gains, totals everything by tax year, and keeps a checklist of unclaimed airdrops and deadlines.

Download Excel template (.xlsx) 222 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 5 Nov 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no wallet connection, no price feed: you type each value from a block explorer or your exchange's records.

Not tax advice. The template follows published IRS guidance as of 5 Nov 2026 and is for record keeping. Tax treatment depends on your facts, and guidance changes. Check the sources below and ask a tax professional before you file.

Preview: the Example tab. Tokens FICT-A to FICT-Z, their chains, wallets, prices and dates are fictional.
$1,690.00ordinary income from 6 lots, 2024–2026
−$213.00net short-term gain / loss
$29.00net long-term gain / loss
1lot with no verified official source
LotTypeReceivedToken (fictional)QtyFMV / tokenOrdinary incomeQty leftOfficial source verified
EX-001Hard fork2024-03-12 14:05FICT-F25$2.00$50.000Yes
EX-002Airdrop2024-09-03 09:30FICT-A1,200$0.45$540.000Yes
EX-003Hard fork2025-02-18 18:20FICT-B300$1.80$540.00100Yes
EX-004Airdrop2025-07-01 00:00FICT-C5,000$0.012$60.000Yes
EX-005Airdrop2026-01-15 11:45FICT-D80$6.25$500.0050Yes
EX-006Other2026-04-02 08:10Unknown token (FICT-Z)10,000$0.00$0.0010,000No
−$400−$200$0$200$400$6002024 Ordinary income: $590.00$5902024 Short-term gain / loss: $10.50$10.502024 Long-term gain / loss: $0.00$020242025 Ordinary income: $600.00$6002025 Short-term gain / loss: −$328.00−$3282025 Long-term gain / loss: $29.00$2920252026 Ordinary income: $500.00$5002026 Short-term gain / loss: $104.50$104.502026 Long-term gain / loss: $0.00$02026

Ordinary income (FMV at receipt)Short-term gain / lossLong-term gain / loss

Which sheet do you need? This one is for tokens you received for free: airdrops and hard forks. For every buy, sell and swap across all coins, use the crypto tax spreadsheet or the cost basis spreadsheet. Staking rewards have their own staking rewards tracker.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, the rules the formulas follow, what the IRS has said, scam-safety notes, limits, disclaimer
Airdrops (300 rows)Type (Airdrop / Hard fork / Other), date and time received, token, chain, wallet, quantity, FMV per token in USD, FMV source, official source verified (Y/N), notesLot ID, ordinary income, cost basis per token, tax year, quantity disposed and remaining, basis remaining, a status check
Disposals (500 rows)Date and time, Lot ID (dropdown), quantity, gross proceeds in USD, fees, where, Form 1099-DA received (Yes / No / Not expected)Token, date received, cost basis, net proceeds, gain or loss, days held, short-term or long-term, tax year, a status check (unknown lot, sale before receipt, over-sold lot)
Claims (200 rows)Project, chain, eligible wallet, snapshot date, claim opens, claim deadline, official link, source verified (Y/N), claimed (Y/N), Lot ID once logged; an as-of date (TODAY() by default)Days to the deadline and a status: Open, Due within 7 days, Verify the official source first, Deadline passed, Claimed: add it to the log, Claimed and logged
SummaryTax years in column A (2017–2032 preset)Per year: lots received, ordinary income, disposals, net proceeds, cost basis, short-term and long-term gain or loss, gross proceeds on 1099-DA rows; a year check, a checks panel and a bar chart
ExampleNothingThe four blocks filled with fictional data: 6 lots, 7 disposals, 6 claims

How to use it

  1. Airdrops: add one row each time tokens arrive. Type the date and time you could first transfer, sell or exchange them. If an exchange credits a fork token days after the fork, use the credit time.
  2. Look up the US-dollar price per token at that moment on a block explorer or your exchange's records, type it in the FMV column, and note where it came from. If you find no market price, record that in the FMV source column.
  3. Type Y in Official source verified? only after you checked the claim on the project's own site or docs. The cell stays amber until you do.
  4. Disposals: when you sell, swap or spend airdropped tokens, pick the Lot ID, then the date, quantity, gross proceeds in USD and fees. A sale that uses two lots needs two rows.
  5. Claims: list airdrops you may qualify for, with the snapshot date and claim deadline. Mark Claimed Y and add the Lot ID once the tokens are in the log.
  6. Summary: read the totals for each tax year and fix anything the checks panel counts. Keep the file with your tax records.

Do not sort or delete rows in the Airdrops log. Lot IDs follow the row number and the Disposals tab points at them. To remove a lot, clear its yellow cells.

What the IRS has said about airdrops

RuleSourceWhere it is in the sheet
An airdrop of new cryptocurrency after a hard fork gives "gross income, ordinary in character". A hard fork with no new tokens received is not income.Rev. Rul. 2019-24, holdings 1 and 2Airdrops, column L
Income is the fair market value when the airdrop is recorded on the ledger, "provided you have dominion and control" so you can "transfer, sell, exchange, or otherwise dispose of" it.IRS virtual currency FAQ, A24Airdrops, columns C and H
If an exchange does not credit the new token at once, you receive it when you later get "the ability to transfer, sell, exchange, or otherwise dispose of" it.Rev. Rul. 2019-24Airdrops, column C
Basis equals the amount included in income.IRS FAQ A25Airdrops, column M
The holding period "begins the day after it is received"; held more than one year = long-term.IRS FAQ A29, A6Disposals, columns O and P
On Form 1040, answer Yes to the digital asset question if you received digital assets from "an airdrop as it relates to a hard fork".IRS, Digital assetsSummary, lots received
Brokers report gross proceeds on Form 1099-DA for transactions on or after 1 Jan 2025, and basis on certain transactions on or after 1 Jan 2026.IRS, Digital assets; About Form 1099-DADisposals, column H; Summary, column J
From 1 Jan 2025, unused basis is allocated to the digital assets in each wallet or account.Rev. Proc. 2024-28Airdrops, column F (wallet)

What is not settled. Rev. Rul. 2019-24 covers an airdrop that follows a hard fork. The IRS has not issued a separate ruling for airdrops with no fork, such as project token launches. The template records them the same way so you have the numbers in one place; how they are taxed is a question for a tax professional. The IRS FAQ also says it "generally appl[ies] to transactions involving digital assets completed before Jan. 1, 2025", so check the IRS digital assets page for later updates.

The formulas, explained

Ordinary income = quantity × FMV per token at receipt. Each lot's basis per token is that same FMV. A disposal's cost basis = quantity sold × the lot's basis per token; gain or loss = proceeds − fees − cost basis. A disposal is long-term when its date is later than the same calendar date one year after receipt, which matches "held more than one year" with the holding period starting the day after receipt. Dates compare by calendar day; the time of day only documents when you received the tokens. Exact formulas from row 6 of each tab:

TabFieldFormula
AirdropsOrdinary income (L6)=IF($S6=1,G6*H6,"")
AirdropsCost basis per token (M6)=IF($S6=1,H6,"")
AirdropsTax year received (N6)=IF($S6=1,YEAR(C6),"")
AirdropsQuantity disposed (O6)=IF($S6=1,SUMIFS(Disposals!$D$6:$D$505,Disposals!$C$6:$C$505,A6,Disposals!$S$6:$S$505,1),"")
AirdropsQuantity remaining (P6)=IF($S6=1,G6-O6,"")
DisposalsLot row, helper (T6)=IF(OR(A6="",C6=""),"",IFERROR(MATCH(C6,Airdrops!$A$6:$A$305,0),""))
DisposalsCost basis (L6)=IF($S6=1,D6*K6,"")
DisposalsNet proceeds (M6)=IF($S6=1,E6-N(F6),"")
DisposalsGain or loss (N6)=IF($S6=1,M6-L6,"")
DisposalsDays held (O6)=IF($S6=1,INT(B6)-INT(J6),"")
DisposalsTerm (P6)=IF($S6=1,IF(INT(B6)>EDATE(INT(J6),12),"Long-term","Short-term"),"")
ClaimsDays to deadline (L6)=IF(OR(COUNTA(A6:K6)=0,I6="Y",NOT(ISNUMBER(F6)),NOT(ISNUMBER(Claims!$B$3))),"",INT(F6)-INT(Claims!$B$3))
SummaryOrdinary income in a year (C5)=IF(ISNUMBER($A5),SUMIFS(Airdrops!$L$6:$L$305,Airdrops!$N$6:$N$305,$A5,Airdrops!$S$6:$S$305,1),"")
SummaryShort-term gain or loss in a year (G5)=IF(ISNUMBER($A5),SUMIFS(Disposals!$N$6:$N$505,Disposals!$Q$6:$Q$505,$A5,Disposals!$P$6:$P$505,"Short-term",Disposals!$S$6:$S$505,1),"")

Column S on each log is a 1/0 helper that marks a complete, valid row. Only valid rows feed the totals, so a half-typed row never changes the Summary. The status column says what to fix: a missing date or token, a quantity of 0, a lot ID that does not exist, a sale dated before the lot was received, or disposals that add up to more than the lot.

Worked example from the sample data

All names and numbers below are fictional.

DisposalDateLotQtyNet proceedsCost basisGain / lossDays heldTermForm 1099-DA
EXD-0012024-11-20EX-001 (FICT-F)10$30.50$20.00$10.50253Short-termNot expected
EXD-0022025-03-13EX-001 (FICT-F)15$59.00$30.00$29.00366Long-termYes
EXD-0032025-01-10EX-002 (FICT-A)1,200$298.00$540.00−$242.00129Short-termYes
EXD-0042025-12-01EX-003 (FICT-B)100$94.00$180.00−$86.00286Short-termYes
EXD-0052026-02-18EX-003 (FICT-B)100$258.50$180.00$78.50365Short-termYes
EXD-0062026-03-05EX-004 (FICT-C)5,000$34.50$60.00−$25.50247Short-termNot expected
EXD-0072026-09-30EX-005 (FICT-D)30$239.00$187.50$51.50258Short-termYes
Tax yearLots receivedOrdinary incomeDisposalsShort-termLong-termTotal gain / lossGross proceeds, 1099-DA rows
20242$590.001$10.50$0.00$10.50$0.00
20252$600.003−$328.00$29.00−$299.00$455.00
20262$500.003$104.50$0.00$104.50$500.00
Total6$1,690.007−$213.00$29.00−$184.00$955.00

Claims checklist and scam safety

The Claims tab tracks airdrops before they reach your wallet. Each row shows the days left to the deadline from the as-of date (today, unless you type a date) and one status. A source you have not verified is flagged before the countdown; only a completed claim or a passed deadline outranks it. The example, as of 5 Nov 2026:

Project (fictional)SnapshotDeadlineSource verifiedClaimedDays leftStatus
FICT-B fork2025-02-022025-05-18YesYes—Claimed and logged
FICT-D2025-12-012026-04-15YesYes—Claimed and logged
FICT-E2026-09-012026-11-10YesNo5Due within 7 days
FICT-G2026-10-012027-01-31NoNo87Verify the official source first
FICT-H2026-05-012026-08-31YesNo-66Deadline passed
FICT-J2026-10-15—YesNo—Open, no deadline entered

Airdrops are a common lure because they promise something for free. Regulators' general warnings apply:

Practical habits the checklist builds in: find the claim link on the project's own site or docs, never through a direct message, a reply or the name of a token that appeared in your wallet; never type a seed phrase into a claim page; read what a wallet approval allows before signing it.

Common mistakes

Limits

FAQ

Are crypto airdrops taxable in the US?

For an airdrop that follows a hard fork, yes. Rev. Rul. 2019-24 holds that a taxpayer who receives new cryptocurrency in that situation has "gross income, ordinary in character", equal to its fair market value when received. A hard fork with no new tokens received is not income. The IRS has not published a separate ruling for other airdrops; this template records them the same way so none are missed. Ask a tax professional how yours should be treated.

How do I find the fair market value of an airdrop?

Use the US-dollar value at the date and time you could first sell or move the tokens. The IRS FAQ says that for a transaction on an exchange the value is the amount the exchange recorded, and that it "will accept as evidence of fair market value the value as determined by a cryptocurrency or blockchain explorer" at the exact date and time (A26, A27). Note the source in the FMV source column. The sheet does not fetch prices.

What is the cost basis of airdropped crypto, and when does the holding period start?

Basis is the amount you included in income, which is the fair market value when received (IRS FAQ A25). The holding period "begins the day after it is received" (A29), and tokens held more than one year give a long-term gain or loss (A6). In the example, a lot received on 12 Mar 2024 and sold on 13 Mar 2025 is long-term; one received on 18 Feb 2025 and sold on 18 Feb 2026 is still short-term.

Will I get a Form 1099-DA for airdropped tokens?

Possibly, when you sell through a broker. The IRS says brokers report gross proceeds for transactions on or after 1 Jan 2025 and basis on certain transactions on or after 1 Jan 2026. The 2026 Form 1099-DA instructions treat a digital asset transferred in to the broker, or acquired before 2026, as a noncovered security, so tokens claimed in your own wallet may show proceeds without basis. Your log supplies the basis.

What should I do with unknown tokens that appear in my wallet?

Do not visit sites named in the token, connect your wallet or sign approvals to claim them. Get claim links only from a project's own site or documentation. The CFTC tells the public to "be cautious of calls, text messages, letters, or emails from people or companies they've never contacted". Log the token with the official-source column set to N so it is on record, and ask a tax professional how to treat it.

Does this airdrop tracker work in Google Sheets?

Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. The file uses only AND, COUNTA, COUNTIF, COUNTIFS, EDATE, IF, IFERROR, INDEX, INT, ISNUMBER, MATCH, N, NOT, OR, ROW, SUM, SUMIFS, SUMPRODUCT, TEXT, TODAY, YEAR, which exist in Excel 2016+, Google Sheets and LibreOffice. No macros, no add-in, no wallet connection.

Related templates and tools

Educational template only, not tax, legal or investment advice. Example data is fictional: tokens FICT-A to FICT-Z, chains, wallets, prices and dates are made up to show the formulas. IRS rules are quoted from Rev. Rul. 2019-24, the IRS virtual currency FAQ (page reviewed 30 Jun 2026), the IRS digital assets page (reviewed 2 Sep 2026), the Form 1099-DA page and 2026 instructions, and Rev. Proc. 2024-28; scam guidance from the FTC and CFTC; all retrieved on 5 November 2026. Check irs.gov for later changes.