Tax‑Loss Harvesting Playbook: Year‑End Checklist and Spreadsheet Template for Investors

Overview

Tax-loss harvesting is the practice of selling an investment in a taxable brokerage account for less than its tax basis, then using the realized loss to help offset realized capital gains or, subject to applicable rules and limits, other taxable income. The strategy is not a reason to sell a sound investment simply because its price fell. It is a portfolio-management decision that combines taxes, asset allocation, transaction costs, and your investment time horizon.

The central trade-off is straightforward: realizing a loss may create a tax benefit today, but selling can change your exposure to a company, sector, fund, or asset class. A replacement investment should preserve the role the original holding plays in your portfolio while remaining sufficiently different to avoid a wash sale. Before acting, confirm the rules that apply to your account, tax jurisdiction, filing status, and other household accounts. Tax rules can change, and a qualified tax professional can help with unusual situations.

For a broader review of gains, losses, and portfolio positioning, use this tax-loss harvesting checklist alongside your records. A net worth tracker can also help separate taxable investments from retirement accounts and other assets.

What a reusable spreadsheet should contain

Create one row for each potential harvest candidate. Useful columns include:

• Account and owner: Identify the taxable account and account holder.
• Ticker, fund name, or security description: Record exactly what is being sold.
• Shares and purchase date: Use the broker's tax-lot information rather than an estimate.
• Cost basis and current value: Include the basis method and any adjustments shown by the broker.
• Estimated realized loss: Calculate expected proceeds minus adjusted basis, before commissions or fees.
• Short-term or long-term classification: Confirm how the broker expects the lot to be classified.
• Existing realized gains and losses: Update this column as trades occur.
• Replacement security: Note the proposed substitute and why it fits the allocation.
• Sale date, repurchase date, and monitoring end date: Track the wash-sale review window.
• Action, notes, and documents: Save confirmations, research, and decisions.

This is a planning worksheet, not a substitute for the official tax forms or your broker's year-end tax documents. Reconcile the spreadsheet with the broker's records before filing.

Checklist by scenario

Scenario 1: You have realized gains to offset

1. Export or review tax-lot data. Look for positions below their adjusted basis, not merely holdings with a negative total return. Reinvested distributions, corporate actions, and previous transactions can affect basis.
2. List realized gains and losses. Include sales already made during the tax year and note whether the gains or losses are short-term or long-term. Do not assume a portfolio-level gain or loss tells the full tax story.
3. Rank candidates by portfolio purpose. Consider holdings that are overweight, no longer fit your plan, or can be replaced with a comparable but not substantially identical exposure. A tax benefit should not override diversification or risk management.
4. Estimate the benefit conservatively. Compare the expected realized loss with gains you may offset, your applicable tax situation, trading costs, bid-ask spreads, and the possibility that the replacement investment performs differently.
5. Choose the replacement before selling. Write down the replacement, its role, expense structure, risk, and target weight. Avoid making a rushed choice after the sale.
6. Execute and document. Save the order confirmations and record the sale date, shares, proceeds, and tax lot. Verify the trade settled as expected.
7. Monitor the wash-sale window. Review purchases in the selling account and other accounts you control, including recurring investment instructions. Do not rely solely on an automatic broker alert.

Scenario 2: You have losses but few or no gains

A loss may still be relevant, but its immediate usefulness depends on your tax situation and applicable limits. Do not sell solely to generate a deduction without considering whether the position remains appropriate. If you harvest, record the loss carefully and understand how unused losses may be treated under the rules that apply to you. Your tax professional or tax software can determine how the loss flows through your return.

Scenario 3: You want to change an investment permanently

This is often the cleanest situation. If a fund is too concentrated, expensive, volatile, or inconsistent with your target allocation, selling at a loss may both improve the portfolio and create a potential tax benefit. Compare the proposed replacement with the original by exposure, diversification, fees, liquidity, tracking approach, and risk—not just by ticker symbol.

Scenario 4: You are near a planned withdrawal or rebalancing event

Coordinate harvesting with your wider plan. A position you intend to sell soon may be a natural candidate, while a position needed for a near-term expense may not be suitable for a riskier substitute. Use an asset allocation calculator or your investment policy statement to check that the trade will not push the portfolio away from its intended mix.

What to double-check

Wash-sale timing and substantially identical securities

The wash-sale rule is designed to limit recognition of a loss when an investor sells a security and acquires the same or a substantially identical security within the relevant period around the sale. The review should cover purchases before and after the sale, not just the next trade. Consider automatic dividend reinvestment, recurring contributions, options or other related transactions, and purchases in accounts held by a spouse or other household members where applicable.

Replacement choices require judgment. Selling one broad-market fund and buying another may or may not be treated as substantially identical depending on the securities and circumstances. An ETF and a mutual fund with similar objectives are not automatically interchangeable for tax purposes. If the holding is in or connected to an IRA, Roth IRA, or another retirement account, obtain specific tax guidance before proceeding; retirement-account interactions can produce results that differ from a taxable-account trade.

Tax lots and basis

Confirm which lots you are selling and whether your broker permits specific-lot identification. A position can contain both gains and losses, and selling the wrong lots may create a different tax result than intended. Check adjusted basis after reinvested distributions, mergers, splits, transfers, or prior wash-sale adjustments.

Portfolio exposure

A tax substitute should not create an unintended concentration, excessive turnover, or a materially different risk profile. Compare the replacement's holdings, sector weights, geographic exposure, duration, credit risk, volatility, and liquidity. If the replacement is only temporary, write down the earliest date you may reconsider it and the conditions that would justify a change.

Filing records

Keep trade confirmations, basis records, replacement-security rationale, and notes about the wash-sale review. Broker reporting is valuable but may not capture every transaction across accounts or institutions. Reconcile your spreadsheet with tax documents and correct discrepancies before filing.

Common mistakes

• Buying the same security immediately: A quick repurchase can undermine the intended tax treatment.
• Ignoring automatic investing: Recurring purchases and dividend reinvestment can create an unexpected replacement transaction.
• Confusing a paper loss with a tax loss: A decline in account value is not realized until the position is sold, and basis determines the result.
• Chasing the tax benefit: A small estimated benefit is not worth a major change in risk, a wide spread, or avoidable trading costs.
• Using a poorly matched substitute: A replacement should maintain the portfolio's intended exposure without being assumed identical merely because it belongs to the same category.
• Forgetting household accounts: Review relevant accounts and standing orders that could affect the wash-sale analysis.
• Waiting until the final trading day: Last-minute trades leave less time to verify execution, settlement, tax lots, and replacement orders.
• Assuming all losses have the same value: The usefulness of a loss depends on gains, income, holding period, filing circumstances, and applicable rules.

Tax-loss harvesting should fit a written investment plan. For investors comparing funds before selecting a replacement, this guide to ETF versus mutual fund costs, taxes, and trading provides a framework. If the position is an income-oriented stock, also review the assumptions behind your dividend investing strategy.

When to revisit

Run the checklist before your annual tax-planning deadline, but do not limit the review to the end of the calendar year. A large market decline, a portfolio rebalance, a change in employment or income, a major withdrawal, or a decision to replace a fund can all justify an earlier review.

At the start of each planning cycle, refresh your spreadsheet with current tax-lot data, realized transactions, account locations, recurring purchases, and replacement candidates. Recheck official tax guidance and your broker's reporting procedures whenever rules or forms change. Update the article's own assumptions if tax law, wash-sale interpretations, or retirement-account guidance changes.

Practical next step: Create a copy of the spreadsheet structure above, import your current taxable-account lots, and mark each row as “review,” “do not sell,” or “candidate.” For every candidate, record the investment purpose, expected loss, proposed replacement, wash-sale monitoring dates, and documentation needed. Then pause before trading long enough to confirm that the transaction improves the portfolio after taxes, costs, and risk are considered.