DIY Tax-Loss Harvesting vs. Automation: Two Case Studies
Tax-loss harvesting can be done manually. The challenge is not the sell order—it is coordinating tax lots, replacement exposure, and every purchase during the wash-sale window.
These hypothetical case studies show where a spreadsheet can work and where monitoring software can reduce operational mistakes. Automation still does not decide whether a trade is appropriate or replace tax advice.
Case Study 1: A Reinvestment Creates a Partial Wash Sale
David owns 400 shares of a technology stock in a taxable account. One lot has a $16,000 unrealized loss, and he wants to sell it to offset realized gains.
He checks the account where he plans to trade, sees no recent purchase, and sells the lot. Ten days earlier, however, an automatic dividend reinvestment in another brokerage account purchased 8 shares of the same stock.
The result is not that the entire loss automatically disappears. The wash-sale rules generally match replacement shares to loss shares, so the loss attributable to 8 shares may be disallowed and added to the basis of the replacement shares. The remainder may still be deductible, subject to the full facts.
What a Better Workflow Would Do
- Aggregate transactions from every taxable and retirement account.
- Search both the 30 days before and the 30 days after the planned sale.
- Include dividend reinvestments, recurring buys, options, and a spouse's accounts.
- Estimate how many shares and how much loss may be affected.
- Preserve records needed for Form 8949 and basis tracking.
Software is valuable here because the error is easy to miss, not because the tax rule is simple.
Case Study 2: The Investor Sits in Cash
Jessica sells a broad-market fund at a $12,000 loss. She plans to wait 31 days and buy it back. During the waiting period, the market rises 6%, leaving her with less exposure than intended.
Her loss may still be valid, but the strategy created an investment problem. The missed return can exceed the tax benefit, especially when the investor has a long horizon and a modest tax rate.
What a Better Workflow Would Do
Before selling, Jessica would choose a replacement that maintains suitable exposure without relying on a claim that it is guaranteed to avoid the “substantially identical” standard. She would compare index methodology, holdings, concentration, fees, and tracking behavior.
She would also set a reminder for the end of the wash-sale window and decide in advance whether to keep the replacement or switch back. The goal is a deliberate portfolio, not simply being out of the original security for 31 days.
Where DIY Can Work
Manual harvesting may be practical when an investor has one taxable account, few positions, no automatic purchases, and a low trade frequency. A calendar plus a lot-level spreadsheet may be enough if it records:
- Account, security, quantity, and acquisition date.
- Cost basis and current value by lot.
- Proposed sale and replacement.
- Purchases during the full 61-day window.
- Realized short- and long-term results.
The process becomes harder with multiple brokers, separately managed accounts, equity compensation, or a spouse who trades the same securities.
What Automation Should—and Should Not—Do
A useful system should surface candidate lots, monitor cross-account purchases, model replacement exposure, and preserve an audit trail. It should show why a trade was flagged and let the investor approve or reject it.
It should not promise a guaranteed tax outcome, trade solely because a position is red, or assume every correlated replacement is safe under the wash-sale rule.
Compare available approaches in tax-loss-harvesting software, then use the multiple-account checklist before trading.
Bottom Line
DIY harvesting is possible, but the costliest errors usually occur outside the sell order: an unnoticed replacement purchase or an undisciplined reinvestment plan. Automation is most useful as a monitoring and decision-support layer, with the investor retaining control.
Official Source
