Tax-Loss Harvesting Spreadsheet

Regular price $19.00

Wishlist

Description

Track Tax-Loss Harvesting Opportunities With a Structured Educational Spreadsheet

Tax-Loss Harvesting Spreadsheet is an official companion resource created to support, extend, and enhance the implementation of The Wealth Builder's Guide. This Excel workbook helps investors organize taxable investment lots, track buy and sell transactions, identify potential loss positions, estimate possible tax benefits, and review wash sale risk flags before taking action.

This spreadsheet is designed for educational tax-loss harvesting planning. Users can configure tax assumptions, enter individual tax lots, log trades across accounts, review harvest candidates, and monitor a summary dashboard showing available losses, estimated tax benefits, loss positions, wash sale warnings, and short-term vs. long-term tax impact. It is not tax, legal, financial, or investment advice, and users should consult a qualified tax professional before making investment decisions.

Includes a Start Here user guide explaining what tax-loss harvesting is and how it may help offset capital gains or up to $3,000 of ordinary income annually.
Explains that tax-loss harvesting is most beneficial in taxable brokerage accounts, not IRAs or 401(k)s.
Includes wash sale rule guidance, including the 30-day before/after window and the 61-day period where purchases can trigger the rule.
Reminds users that purchases in any account, including IRA, 401(k), taxable accounts, and spouse accounts, may create wash sale risk.
Provides a Settings tab for tax year, federal marginal tax rate, state tax rate, short-term capital gains rate, long-term capital gains rate, combined long-term rate, and wash sale window.
Includes replacement security mapping notes, with example pairs such as VTI → SCHB, VOO → SPLG, and QQQ → QQMG.
Provides a Lots_Holdings sheet for entering each tax lot separately, including ticker, asset name, purchase date, shares, cost per share, current price, and notes.
Uses formulas to calculate total cost basis, current value, unrealized gain/loss, unrealized gain/loss percentage, holding period, and term classification.
Includes a Trade_Log sheet for recording buy, sell, dividend, contribution, withdrawal, or other transaction activity by date, ticker, action, shares, price, and account.
Includes a Harvest_Candidates sheet designed to show loss positions, applicable tax rate, estimated tax benefit, wash sale risk flag, and action notes.
Includes a Summary_Dashboard showing key metrics, top harvest candidates, wash sale warnings, and a tax impact summary.

Use this spreadsheet to create a more organized educational workflow for reviewing potential tax-loss harvesting opportunities before discussing decisions with a qualified tax professional.

Digital Product Contents

Start Here
A user guide explaining that the workbook is for educational purposes only and is not tax advice. It introduces tax-loss harvesting, explains how capital losses may offset capital gains, explains the potential $3,000 annual ordinary income offset, and reminds users that unused losses may be carried forward to future years.

Tax-Loss Harvesting Explanation
The guide explains tax-loss harvesting as a strategy where investors sell investments that have declined in value to realize capital losses. It also explains that investors may maintain similar market exposure by purchasing a comparable but not substantially identical security.

Wash Sale Rule Guide
A dedicated guide section explaining the IRS wash sale rule. It notes that a loss may be disallowed if a substantially identical security is purchased within 30 days before or after the sale, creating a 61-day review window.

Wash Sale Considerations
The workbook reminds users that the 30-day window applies before and after the sale date, purchases in any account may trigger the rule, spouse account purchases may also trigger wash sale risk, and disallowed losses may be added to the cost basis of the new position.

How to Use Workflow
A step-by-step guide explaining how to configure the Settings tab, enter holdings in Lots_Holdings, record trades in Trade_Log, review Harvest_Candidates, and check the Summary_Dashboard.

Settings
A configuration sheet for entering the tax year, federal marginal tax rate, optional state tax rate, short-term capital gains rate, long-term capital gains rate, combined long-term rate, and wash sale window in days.

Replacement Security Mapping Notes
A planning area for recording possible replacement security pairs that may help maintain similar market exposure while avoiding substantially identical purchases. Example notes include VTI → SCHB for total market ETFs, VOO → SPLG for S&P 500 ETFs, and QQQ → QQMG for Nasdaq ETFs.

Lots_Holdings
A tax lot tracking sheet where users can list each lot separately. Fields include ticker, asset name, lot purchase date, shares, cost per share, total cost basis, current price, current value, unrealized gain/loss, unrealized gain/loss percentage, holding period in days, term classification, and notes.

Lots_Holdings Formulas
The sheet includes calculated fields for total cost basis, current value, unrealized gain or loss, unrealized gain/loss percentage, holding period, and short-term or long-term classification.

Trade_Log
A transaction log for recording every buy and sell transaction. Fields include date, ticker, action, shares, price, and account. The guide reminds users to include purchases from taxable accounts, IRA accounts, 401(k) accounts, and spouse accounts when reviewing wash sale risk.

Harvest_Candidates
A planning sheet designed to identify positions with unrealized losses. Fields include ticker, asset name, purchase date, unrealized loss, short-term or long-term term classification, applicable tax rate, estimated tax benefit, wash sale risk flag, and action notes.

Estimated Tax Benefit Calculation
The workbook explains that short-term losses may be evaluated using the marginal tax rate and long-term losses may be evaluated using the long-term capital gains rate. Tax benefit is calculated using loss amount multiplied by the applicable tax rate.

Wash Sale Risk Flags
The workbook includes risk flag language such as “Clear” when no purchases are detected in the 30-day window and “High Risk” when a purchase is detected near the harvest window. Users are reminded to review the full trade log before executing any sale.

Summary_Dashboard
A dashboard sheet showing key metrics such as total unrealized losses available, total estimated tax benefit, number of loss positions, and average loss per position.

Top 10 Harvest Candidates
A dashboard section designed to summarize top potential harvest candidates by rank, ticker, asset name, loss amount, tax benefit, and wash sale risk.

Wash Sale Warnings
A dashboard section for highlighting positions with high-risk wash sale concerns so users can review the trade log before selling.

Tax Impact Summary
A dashboard summary showing total short-term losses, total long-term losses, short-term tax benefit, long-term tax benefit, and total estimated tax benefit.

What You Will Receive

Refund Policy

Due to the digital nature of our products, all sales are final once access is delivered, unless otherwise stated. Once a purchase is completed and access is successfully provided, cancellations or exchanges will not be issued. We encourage customers to review all product descriptions carefully before purchasing. If you have any questions about a digital product, please contact us prior to completing your purchase, and we will be happy to assist. For additional details, please review our full Refund Policy here.

Disclaimer

CPI Digital Hub LLC provides educational tools, templates, and resources designed to support individuals in building and managing digital income strategies. All content is provided for informational and educational purposes only. Results are not guaranteed. Your success depends on many factors, including but not limited to your personal effort, skills, experience, market conditions, and commitment. These products are not a “get-rich-quick” scheme, and individual results will vary. CPI Digital Hub LLC makes no representations, warranties, or guarantees regarding income, profits, or financial outcomes. Nothing provided by CPI Digital Hub LLC should be construed as financial, legal, or tax advice.

© CPI Digital Hub LLC.
All rights reserved. All content on this website and within CPI Digital Hub LLC products, including but not limited to text, graphics, digital products, templates, spreadsheets, downloads, and other materials, is the intellectual property of CPI Digital Hub LLC and is protected by applicable copyright and intellectual property laws. No part of this content may be reproduced, distributed, transmitted, displayed, or otherwise exploited in any form or by any means without prior written permission, except where permitted by law or an applicable license.

Guarantee safe checkout