tax-loss-harvesting
$
npx mdskill add anthropics/financial-services/tax-loss-harvestingMaximize tax savings by harvesting losses and replacing securities.
- Identifies underperforming positions to offset capital gains.
- Calculates optimal harvest amounts based on current tax brackets.
- Selects replacement assets to avoid wash sale restrictions.
- Delivers actionable reports with estimated tax savings.
SKILL.md
.github/skills/tax-loss-harvestingView on GitHub ↗
--- name: tax-loss-harvesting description: Identify tax-loss harvesting opportunities across taxable accounts. Finds positions with unrealized losses, suggests replacement securities, and tracks wash sale windows. Triggers on "tax-loss harvesting", "TLH", "harvest losses", "tax losses", "unrealized losses", or "year-end tax planning". --- # Tax-Loss Harvesting ## Workflow ### Step 1: Identify Candidates Scan taxable accounts for positions with unrealized losses: | Security | Asset Class | Cost Basis | Current Value | Unrealized Loss | Holding Period | % Loss | |----------|-----------|-----------|---------------|-----------------|---------------|--------| | | | | | | ST / LT | | **Prioritize by:** 1. Largest absolute loss (biggest tax benefit) 2. Short-term losses first (offset short-term gains taxed at ordinary income rates) 3. Positions with the largest % loss (less likely to recover quickly) ### Step 2: Gain/Loss Budget Calculate the client's tax situation: | Category | Amount | |----------|--------| | Realized short-term gains YTD | | | Realized long-term gains YTD | | | Realized losses YTD | | | Net gain/(loss) position | | | Carryforward losses from prior years | | | **Target harvesting amount** | | **Tax savings estimate:** - Short-term losses × marginal ordinary income rate - Long-term losses × capital gains rate - Up to $3,000 net loss deduction against ordinary income - Excess carries forward ### Step 3: Replacement Securities For each harvest candidate, suggest a replacement that: - Maintains similar market exposure (same asset class, sector, geography) - Is NOT "substantially identical" (wash sale rule) - Has similar risk/return characteristics | Sell | Replace With | Reason | Tracking Error Risk | |------|-------------|--------|-------------------| | SPDR S&P 500 (SPY) | iShares Core S&P 500 (IVV) | Same index, different fund family | Minimal | | Vanguard Total Intl (VXUS) | iShares MSCI ACWI ex-US (ACWX) | Similar exposure, different index | Low | | Individual stock ABC | Sector ETF (XLK) | Broader exposure, no wash sale risk | Moderate | ### Step 4: Wash Sale Check Before executing, verify no wash sales: - Check ALL accounts in the household (taxable, IRA, Roth, spouse accounts) - 30-day lookback: Did we buy substantially identical securities in the last 30 days? - 30-day forward: Block repurchase of the same security for 30 days - Check for dividend reinvestment plans (DRIPs) that could trigger wash sales - Document the wash sale window for each trade | Security Sold | Wash Sale Window Start | Window End | DRIP Active? | Risk | |--------------|----------------------|-----------|-------------|------| | | | | | | ### Step 5: Execution Plan | Trade # | Account | Action | Security | Shares | Est. Proceeds | Est. Loss | Replacement | Notes | |---------|---------|--------|----------|--------|--------------|-----------|-------------|-------| | | | Sell | | | | | | | | | | Buy | | | | | | | **Summary:** - Total estimated losses harvested: $ - Estimated tax savings: $ (at marginal rate of %) - Net portfolio impact: minimal (replacement securities maintain exposure) - Wash sale window management: [dates] ### Step 6: Post-Harvest Tracking After 30+ days, optionally: - Swap back to original securities (if preferred) - Maintain replacement securities (if no reason to switch back) - Update cost basis records - Document for tax reporting ### Step 7: Output - Harvest opportunity list (Excel) - Trade execution sheet - Wash sale tracking calendar - Tax savings estimate summary - Replacement security rationale ## Important Notes - Wash sale rules are strict — violations disallow the loss AND adjust cost basis - Substantially identical means same security, not same asset class — ETFs tracking different indexes are generally fine - Always coordinate across all household accounts including retirement accounts - Consider the long-term cost basis step-down — harvesting resets cost basis, which means more gains later - Year-end is prime harvesting season but opportunities exist throughout the year - Mutual fund capital gains distributions in December can create additional harvesting urgency - Document everything for tax reporting and compliance - Not all losses are worth harvesting — transaction costs and tracking error have real costs
More from anthropics/financial-services
- 3-statement-modelComplete, populate and fill out 3-statement financial model templates (Income Statement, Balance Sheet, Cash Flow Statement) . Use when asked to fill out model templates, complete existing model frameworks, populate financial models with data, complete a partially filled IS/BS/CF framework, or link integrated financial statements within an existing template structure. Triggers include requests to fill in, complete, or populate a 3-statement model template
- accrual-scheduleBuild the period-end accrual schedule — for each accrual, compute the entry, cite the support, and draft the JE. Use during month-end close; the JE is a draft for controller approval, not a posting.
- ai-readinessScan the portfolio for the highest-leverage AI opportunities and rank where to deploy operating-partner time. Ingests quarterly updates and financials across multiple portfolio companies, identifies quick wins at each, and stacks them into a single ranked action list. Use during quarterly portfolio reviews, annual planning, or when deciding which companies get AI investment first. Triggers on "AI readiness", "AI opportunity scan", "where should we deploy AI", "AI across the portfolio", "AI quick wins", or "which portcos are ready for AI".
- audit-xlsAudit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model (including financial-model integrity checks like BS balance, cash tie-out, and logic sanity). Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreadsheet", "sanity check this", "debug model", "model check", "model won't balance", "something's off in my model", "model review".
- bond-futures-basisAnalyze the bond futures basis by pricing futures, identifying the cheapest-to-deliver, and comparing with yield curves to assess delivery option value and basis trading opportunities. Use when analyzing bond futures, computing the basis, identifying CTD bonds, calculating implied repo rates, or evaluating basis trades.
- bond-relative-valuePerform relative value analysis on bonds by combining pricing, yield curve context, credit spreads, and scenario stress testing. Use when analyzing bond richness/cheapness, computing spread decomposition, comparing bonds, assessing bond value vs curves, or running rate shock scenarios.
- break-traceRoot-cause a reconciliation break to its source transaction or posting — follow the audit trail from the break row back to the originating entry on each side and state what differs and why. Use after gl-recon has classified a break.
- buyer-listBuild and organize a universe of potential acquirers for sell-side M&A processes. Identifies strategic and financial buyers, assesses fit, and prioritizes outreach. Use when preparing for a sell-side mandate, building a buyer universe, or evaluating potential partners. Triggers on "buyer list", "buyer universe", "potential acquirers", "who would buy this", "strategic buyers", or "financial sponsors".
- catalyst-calendarBuild and maintain a calendar of upcoming catalysts across a coverage universe — earnings dates, conferences, product launches, regulatory decisions, and macro events. Helps prioritize attention and position ahead of events. Triggers on "catalyst calendar", "upcoming events", "what's coming up", "earnings calendar", "event calendar", or "catalyst tracker".
- cim-builderStructure and draft a Confidential Information Memorandum for sell-side M&A processes. Organizes company information into a professional, investor-ready document with consistent formatting and narrative flow. Use when preparing sell-side materials, drafting a CIM, or organizing company data for a sale process. Triggers on "CIM", "confidential information memorandum", "offering memorandum", "info memo", "draft CIM", or "sell-side materials".