Free Excel Templates · US Federal Taxation
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.
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| Tab Name | Primary Purpose | Key Live Outputs |
|---|---|---|
| Controls | Editable federal STCG (40.80%), LTCG (23.80%), NIIT (3.80%), 61-day window, and Executive Dashboard | 10 live KPIs linked across all sheets |
| 61_Day_Wash_Engine | Cluster 1 partial wash sale & Dec 10 tacking; Cluster 2 pre-sale & post-sale chronological lot matching | Adj. basis $73,800.00, $1,224.00 tax saved |
| Reconciliation_8949 | Line-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_Shorts | Rev. 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_TLH | 5-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 |