Capital Gains Tax Tracking for Stocks and Crypto: Cost Basis Worksheet and Year-End Checklist
capital-gainscost-basiscrypto-taxesinvesting-taxestax-recordkeeping

Capital Gains Tax Tracking for Stocks and Crypto: Cost Basis Worksheet and Year-End Checklist

TTaxman Editorial Team
2026-11-20
7 min read

Track stock and crypto cost basis, gains, losses, income, and transfers with a practical worksheet and year-end tax checklist.

Tracking investment taxes is much easier when every purchase, sale, transfer, and income event is recorded as it happens. This guide provides a repeatable cost-basis worksheet, a process for reconciling stock and crypto activity, and a year-end checklist for separating gains, losses, and taxable income before filing.

Overview

A capital gain or loss generally begins with a simple comparison: the amount you received when you disposed of an asset minus its adjusted cost basis. The difficult part is making sure both numbers are complete and assigned to the correct asset lot. Brokerage accounts may track basis for many securities, but the information can be incomplete after transfers, corporate actions, reinvested distributions, or activity across several platforms. Crypto records often require even more manual reconciliation because purchases, swaps, transfers, staking, and sales may occur in separate wallets or exchanges.

Your records should answer five questions for every potentially taxable transaction:

  • What asset was acquired or disposed of?
  • When did the acquisition and disposal occur?
  • How many units were involved?
  • What was the proceeds amount and adjusted basis, including eligible fees?
  • Was the result a short-term or long-term gain or loss, or ordinary income from an activity such as staking or dividends?

For many U.S. filers, sales of capital assets are summarized using information from brokerage statements and may flow through Form 8949 and Schedule D. Your forms and reporting obligations can vary by asset type, account, transaction, and tax year, so use the instructions for the specific year you are filing. A tax statement supplied by a platform is useful evidence, but it is not a substitute for reviewing your complete activity.

How to estimate your gains and losses

Start with a single master transaction file rather than trying to calculate tax from separate platform summaries. A spreadsheet is sufficient if it is organized and backed up. Use one row per acquisition, disposal, income event, or transfer that needs review.

A practical capital gains tax worksheet can use these columns:

  • Date and time of transaction
  • Platform, brokerage, wallet, or account
  • Transaction type: buy, sell, exchange, transfer, dividend, staking, mining, or other
  • Asset name and ticker or token symbol
  • Quantity acquired or disposed of
  • Price per unit and gross amount
  • Trading fee, commission, or network fee
  • Adjusted cost basis
  • Net proceeds
  • Holding period and short-term or long-term classification
  • Gain or loss
  • Source document and reconciliation status

For a disposal, the basic estimate is:

Gain or loss = net proceeds − adjusted cost basis

Do not mix an asset transfer with a sale. Moving shares between your own brokerage accounts or crypto between wallets you control is generally recorded as a transfer for tracking purposes, not automatically as a disposal. Record the date, quantity, sending account, receiving account, and original basis so that the receiving account does not treat the transfer as a new purchase. If you exchange one crypto asset for another, however, review the tax treatment for the relevant year rather than labeling it a simple transfer.

For stocks and funds, identify which tax lots were sold. The same security may have several purchase dates and prices. Use the lot-selection method shown on your broker statement or the method you elected, and retain evidence of that selection. For crypto, document how units were matched to disposals and apply a consistent method that is permitted for the transaction and tax year.

Inputs and assumptions

Your cost basis tracker is only as reliable as its inputs. Gather original trade confirmations, annual brokerage statements, dividend and distribution records, exchange exports, wallet histories, and records of transfers between platforms. If a platform no longer provides older data, check downloaded files, emails, bank statements, and prior tax returns.

Pay particular attention to these adjustments:

  • Fees: Determine whether a commission, trading fee, or other transaction cost belongs in basis or reduces proceeds under the applicable reporting rules. Avoid subtracting the same fee twice.
  • Reinvested dividends: Reinvested distributions may create a new tax lot rather than disappearing from your records. Include the reinvested amount and acquisition date.
  • Corporate actions: Splits, mergers, spin-offs, and ticker changes can alter the number of units and basis. Compare your records with the broker's adjusted basis information.
  • Transfers: Preserve the original acquisition date and basis when moving an asset between accounts or platforms you control.
  • Income events: Dividends, staking rewards, mining income, and similar receipts may need separate treatment from later capital gains. Record the date, quantity, fair value used, and supporting statement.
  • Loss limitations and wash-sale review: For securities, review whether a loss sale was followed by a substantially identical purchase within the relevant period. Brokerage reporting may not capture every account or related transaction. Crypto transactions should not automatically be treated as identical to stock transactions; rules can differ and may change, so confirm the treatment for the tax year.

Separate short-term from long-term gains by comparing the acquisition date with the disposal date under the rules for the asset and tax year. Do not assume that a platform's label is correct when the basis or acquisition date is missing. Also keep a separate summary of ordinary income, since adding staking or dividend receipts to capital-gain totals can distort your estimate.

Tax rates, income thresholds, deductions, credits, contribution limits, and reporting requirements can change. Use current-year instructions and forms when preparing a return. If records are materially incomplete, transactions are complex, or you received assets through compensation, lending, gifts, inheritance, or a business, professional review may be appropriate.

Worked examples

Stock sale with two purchase lots

Assume you bought 10 shares of a fund for $40 per share in January and another 10 shares for $55 per share in July. You sell 12 shares in December for $70 per share, after a $12 selling fee. If your selected lots are five shares from January and seven shares from July, the basis is calculated separately for those lots:

  • January lot basis: 5 × $40 = $200
  • July lot basis: 7 × $55 = $385
  • Total basis: $585
  • Net proceeds: 12 × $70 − $12 = $828
  • Estimated gain: $828 − $585 = $243

The holding period for each portion must be checked separately. Some shares could be short-term while others are long-term, even though they were sold in one order.

Crypto sale after a transfer

Suppose you bought a token on Exchange A, transferred it to Wallet B, and later sold it through Exchange C. The transfer itself is entered as a movement of the original lot, not a new purchase. Your worksheet should connect the original acquisition date and basis to the eventual disposal. If the transfer fee reduced the quantity received, document the fee and how it was handled rather than silently changing the basis or quantity.

Staking reward followed by a sale

If you received two units through staking and recorded their value as income when received under the applicable rules, that value may become the starting basis for a later sale. Record the income event and the later disposal as separate rows. A later sale can produce a capital gain or loss even when the original receipt was recorded as income.

When to recalculate

Do not wait until filing season to discover that a wallet export is missing. Reconcile monthly or quarterly, especially if you trade frequently. Revisit the worksheet immediately after transferring assets between platforms, closing an account, receiving staking or dividend income, exercising an investment right, or changing the way you select tax lots.

At year-end, complete this checklist:

  1. Download statements and complete transaction exports from every brokerage, exchange, wallet, and payment service.
  2. Match deposits and withdrawals to platform records so transfers are not mistaken for purchases or sales.
  3. Find missing acquisition dates, unknown basis, duplicate rows, and unmatched quantities.
  4. Review every loss sale for potential wash-sale or related transaction issues.
  5. Separate short-term and long-term disposals, ordinary income, and non-taxable transfers.
  6. Compare your totals with available tax statements and investigate differences instead of overwriting them.
  7. Save the final worksheet, source documents, and a note explaining assumptions or unresolved items.

Keep the completed file with your broader household records. An annual financial review can help you check accounts and beneficiaries at the same time, while a tax deduction and credit checklist keeps investment records from being treated as your entire tax file. Update your capital gains tax worksheet whenever the underlying activity changes, and verify current forms and instructions before filing.

Related Topics

#capital-gains#cost-basis#crypto-taxes#investing-taxes#tax-recordkeeping
T

Taxman Editorial Team

Personal Finance and Tax Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.