Free Excel Templates · US Federal Taxation

Section 1091 Wash Sale and Tax-Loss Harvesting Calculator (Excel)

Five linked tabs covering the 61-day wash sale engine, Section 1091(d) basis and Section 1223(3) tacking, Form 1099-B vs Form 8949 Code W reconciliation, Rev. Rul. 2008-5 IRA traps, and 5-year Direct Indexing tax alpha.

Direct Download (No Account, No Macros, 100% Unlocked)

Pre-loaded with the Tax Year 2026 Meridian Family Wealth Portfolio (-$170,000.00 gross losses, +$56,000.00 Form 8949 Code W gap) and a 5-year $1,000,000.00 Direct Indexing simulation ($30,875.24 liquidation advantage, $65,281.45 Section 1014 step-up advantage).

Download Section_1091_Wash_Sale_Calculator.xlsx Read the Full Handbook

What Is Inside the 5 Linked Tabs

Tab NamePrimary PurposeKey Live Outputs
ControlsEditable federal STCG (40.80%), LTCG (23.80%), NIIT (3.80%), 61-day window, and Executive Dashboard10 live KPIs linked across all sheets
61_Day_Wash_EngineCluster 1 partial wash sale & Dec 10 tacking; Cluster 2 pre-sale & post-sale chronological lot matchingAdj. basis $73,800.00, $1,224.00 tax saved
Reconciliation_8949Line-by-line Form 1099-B Box 1g ($32,800.00) vs Taxpayer Section 1091 ($88,800.00)+$56,000.00 Code W gap; $19,448.00 audit risk
IRA_Options_ShortsRev. Rul. 2008-5 IRA trap, Sec. 1091(f) call options & Rev. Rul. 85-87 DITM put test, Sec. 1091(e) short sales$4,760.00 perm. IRA tax loss; $13,800.00 call basis
Direct_Indexing_TLH5-year $1,000,000.00 simulation comparing Buy-and-Hold vs Active Direct Indexing with harvesting decay+49 bps liquidation alpha; +98 bps step-up alpha

Companion Technical Guides