wash sale calculator excel

Based in Greenville SC, Eric Bank has been writing business-related articles since 1985. The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. Remember this name since you will have to tell it to Washems!. A transaction where an investor sells a losing security and purchases a similar one 30 days before or after the sale to try and reduce their overall tax liability. All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. So, just wait for 30 days after the sale date before repurchasing the same or similar investment. Generally, thebonds and preferred stockof a company are not considered substantially identical to the companys common stock. 4. the bottom of the detail report but you can override this by checking the "Add Summary to Detail Report?" Function. Keep all the sales transactions on the right side. Rul. Wash Sale Formula I have stock trades in a excel spreadshhet in which I need to look 30 days previous and 30 days pat to see if that same security was traded - If so figure the gain or loss of the 90 period of that security. Online generation of IRS Schedule D and Form 8949 for just $12.00. The program will automatically adjust itself to accommodate For a short sale, enter the date you acquired the property delivered to the broker or lender to close the short sale. We also reference original research from other reputable publishers where appropriate. Value is amount of loss disallowed. One of these provides those transactions triggering a Tax Unrealized situation; another one, the Warnings . the following columns: If you commit changes to this software, make sure all tests are E.g., "Line 1" for the first lot on the 1099b. Summary Report Breaks Controls the summary totals to be included in the output file; Option Conversion Used to determine if the value in the quantity field for options should be. "Tax Rules for Losses on ETFs." Whenever a wash sale occurs according to the 30-day rule, the amount of the loss is applied to the cost basis of the remaining shares. 8. You can learn more about the standards we follow in producing accurate, unbiased content in our. There was a problem preparing your codespace, please try again. You are using an out of date browser. The information below may be useful when using this calculator. Each row on Form 8949 represents a particular sale transaction. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. Washems2021! Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; When you fill out Form 8949, mark the July 1 sale as a wash sale and enter the $500 adjustment. Excel Spreadsheet Requirements for Your Excel Spreadsheet of 1099-B Data (Realized Gains and Losses) Create your spreadsheet of 1099-B data as follows: COLUMN HEADINGS AND DATA The first row of the spreadsheet should contain column headings. Our program keys off the text in the headings. Gain or Loss whole dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open. Handles most wash sales easily A discussion of the 1233 logic can be downloaded from the TOOLS & SAMPLES tab. The other half of the wash sale calculation occurs when you sell the repurchased securities, which might be in a later tax year. When shares are sold in a non-retirement account and substantially identical shares are purchased in an IRA within 30 days, the investor cannot claim tax losses for the sale. Though a loss may be disallowed due to the wash-sale rule, the amount of that loss will be added to the cost of the purchase that triggered the rule. Therefore, the original loss can be said to be deferred. Unique Lot Id unique user defined identifier up to 50 characters in length. Helps you analyze trade performance based on the detailed information on daily basis. 5. 3. The 30-day repurchase rule applies to securities, and to contracts or options that you can convert into securities, that are substantially identical to the ones you sold. Shares of different companies are not usually considered substantially identical, nor are preferred and common shares of the same company, unless the preferred shares are fully convertible into common stock, have identical voting rights, and subject to the same dividend restrictions. References Tips @a(U Wash Sale Calculator Excel - Wakelet. Learn more. Basis Transaction Report, Daily Account/Portfolio Value Chart Report, calculate Keep all the purchases on the left side. 5. From our round figures and industry average . Excel Maintenance Services, Inc.. IRA Rules for Selling Stocks & Reinvesting. Straddle Calculation Lets the program know if a Straddle Calculation report should be included in the results file and, if so, which of the following In addition to the detailed wash sale report which shows the calculation on a lot by lot basis within each security, the program also delivers a number of additional reports. Check here to turn OFF Sub Lot Processing Sub lot processing breaks down each lot for a more accurate calculation of both the total amount of wash sales and the Adjusted Tax Basis date. 5. Merger Date mm/dd/yy or mm/dd/yyyy or blank; Each row has Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; Why Now May Be the Time for Crypto Tax-Loss Harvesting. It does provide guidance in Publication 550, however. Date of first purchase (tax lot) The wash sale rule can result in the disallowance of a much-needed deduction. The intent of the wash-sale rule is to prevent taxpayers from claiming artificial losses from the sale of securities while essentially maintaining their position in the securities. If two lots were acquired as part of the same buy order, put the same value here. Sales Price (Alternates: Sales, Gross Proceeds), Wash Sale Loss Disallowed (Alternate: Wash Sale Adjustment). "Wash Sales." He received a Bachelor of Arts in English from the University of Florida and is currently attending law school in San Francisco. Create your spreadsheet of 1099-B data as follows: The first row of the spreadsheet should contain column headings. I have recently downloaded your software and I am impressed with it. You can take any video, trim the best part, combine with other videos, add soundtrack. The IRS views this activity as creating artificial losses for tax breaks. An individual retirement account (IRA) is a long-term savings plan with tax advantages that taxpayers can use to plan for retirement. Exit Date in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank; Note that the author is not a CPA or tax expert. Shares of different companies are not usually considered substantially identical, nor are preferred and common shares of the same company, unless the preferred shares are fully convertible into common stock, have identical voting rights and subject to the same dividend restrictions. Washems! Basically my spreadsheet will look like this: Where if I type in a stock ticker, for instance AAPL, it will tell me if I sold it at a loss in the past 30 days. Useful for tracking this lot. description provided on 1099b or statement. A tag already exists with the provided branch name. If sold, proceeds. Stocks or securities of one company are generally not considered substantially identical by the IRS to those of another company. Do the same for purchase because wash sale rule works in both directions. The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. Fidelity Investments. Cost whole dollars only, maximum of 10 digits with no commas; Summary Report Breaks Controls the summary totals to be included in the output file. Bear in mind that stocks of companies that are involved in cryptocurrencies are covered by the wash-sale rule. The columns do not have to be in the order shown here. Wash Sales and defer loss, Record Corporate Events to track your These features would be very helpful. %OQ2^I$%r!$ Since the classification of cryptocurrency is in flux, be sure to check with an appropriate financial, accounting and/or tax advisor for updates and before engaging in transactions for tax harvesting purposes. )O Whenever a wash sale occurs according to the 30-day rule, the amount of the loss is applied to the cost basis of the remaining shares. Optional but recommended. Calculation Type How the program is to offset Short sales of stock: 6. Calculates wash sales scenarios between identical securities (stocks and options) which most broker don't. A wash sale also results if an individual sells a security, and the individual's spouse or a company controlled by the individual buys a substantially equivalent security during the 61-day wait period. Worth a try! For instance, this would be the case if the bonds or preferred stock are convertible into common stock that has no restriction, has the same voting rights as the common stock, and trades at a price close to the conversion ratio. Then, when that position is later sold, any loss that occurs can be taken as a tax deduction. "Publication 550: Investment Income and Expenses," Page 56-57. For example, consider the case of an investor who purchased 100 shares of Microsoft for $33, sold the shares at $30, and within 30 days bought 100 shares at $32. ],bCwsjJS*6QHI~'-Djw% 7q] Output File name and directory (full path) where the output file is to be created; Your Excel work file, for example will have the name whatever.xls and your saved csv file will be called whatever.csv. Unused by this program, but carried through for your records, Acquisition price or basis. Strategic Investing in the Home Stretch of 2022, How to Avoid Violating Wash Sale Rules When Realizing Tax Losses, Wash Sale: Definition, How It Works, and Purpose, Short-Term Capital Gains: Definition, Calculation, and Rates, Substantially Identical Security: Definition and Wash Sale Rules, Wash Trading: What It Is and How It Works, With Examples, Individual Retirement Account (IRA): What It Is, 4 Types, Tax-Loss Harvesting: How It Works, Example, and Pitfalls to Avoid, IRA transactions can also trigger the wash-sale rule, Publication 550: Investment Income and Expenses. Applies only if sold. When in doubt, investors wishing to comply with the wash-sale rule should consult with an appropriate tax advisor or other qualified professional. 8. 1. According to the IRS, this postpones the loss deduction until the security is sold. As an investor who trades in foreign securities, reporting all those gain/loss on Schedule D is a tedious and tough job. Wash-Sale Rule: An Internal Revenue Service (IRS) rule that prohibits a taxpayer from claiming a loss on the sale or trade of a security in a wash sale. A major exception to this, however, is the Internal Revenue Service (IRS) "wash sale" rule. This is what they did to mine: (proceeds) - (cost basis + wash sales) + (Wash sales) = Net gains/loss. You do this by clicking on the File option in Excels toolbar and then selecting Save As. Will appear on Form 8949 with adjustment code W. Will appear on Form 8949 with adjustment code D. Transactions so noted are reported on a separate copy of Form 8949 (with box B or D checked). You can see samples of his work at ericbank.com. Call Excel Maintenance at 800-560-WASH. Clean homes sell & rent faster! May be set to W if there's a wash sale. Note that all symbols are considered substantially identical to each other, so if you trade in multiple stocks that aren't substantially identical, feed them into the calculator separately. License: All | Free Freeware. By informing yourself on the topic, you can ensure that you: There's no real penalty. Input . Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple. Gain or Loss whole dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open. Number of shares/lots maximum of 10 digits with no commas;(show short sales as negatives) The wash-sale rule is an Internal Revenue Service (IRS) regulation that prevents a taxpayer from taking a tax deduction for a loss on a security sold in a wash sale. To use, you'll need a CSV file with the initial state. Everything is automated. A choice of Processing Sequences is also available: Once the Save As window opens, scroll down the file types until you see Comma Delimited. The form contains separate sections for short-term and long-term capital gains. ncMkR>j*,VZ(O4 Y+ A wash sale can delay a tax deduction. these new fields and they'll be reflected in all of the output reports. 7. This simply involves selling securities at a loss to offset gains elsewhere. All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. One flaw I've identified is that if I purchased a stock prior to the 30 days I look back at and sell part of it at a loss then part of it as a gain and the gain is higher overall than the 30 day cost basis then it will count it as not a wash sale even though it is a wash sale. This is the first day you can sell at any loss. 2008-5," Pages 1-4. Click here to download an excel template for the input file. When stock is sold at a loss, the amount of the loss is the cost of the stock less the proceeds of the sale. When you have a wash sale, your loss is suspended, but immediately the loss is added to the basis in the replacement stock. box. merely insert them after the standard Unique Lot Id (field 2) and before the Merger Date (field 3). You won't have bought any new shares within the rule's window. Input File - name and directory (full path) where the input file can be found; 2. Number of shares/lots maximum of 10 digits with no commas; Security (stock) name up to 80 characters long with no imbedded commas; Value is typically share price on SellDate * Cnt - fees. 5. no limitation on the size of the output files, a new Tax Unrealized Report and much more! Instead, it will be added to the cost of the recent purchase. To accomplish this, the Excel entries should be saved as a comma delimited file otherwise known as a csv file. Free Downloads: Calculate Wash Sales Excel. You may use the original worksheet name since Excel appends a different suffix to the name indicating the files type. This is set to true when the lot is used as a replacement in a wash sale. A new tax form for reporting capital gains and losses from stocks, bonds, mutual funds and similar investments. Your net loss on the wash sale is the $2,500 sale proceeds minus the $3,000 cost plus the $500 adjustment, or $0. Accessed April 14, 2020. 11. The point of the rule is to prevent investors from creating an investment loss for the benefit of a tax deduction while essentially maintaining their position in the security. Thanks again. Perfect importing, accurate washsale calculation and large quantity of records supported, one click to generate my Schedule D-1 report with thousands of trades, It is worths the price. The brokers who support import type OFX server, can get import trade history from online brokerage in a fast and easy manner. Click here to download an excel template for the input file. If you're unaware of the wash-sale rule and inadvertently re-establish a position in the same or similar securities within the rule's wait period, your tax deduction will be disallowed. Input must have this set to 0. Calculate accurate basis-in seconds. sign in (a) "All" = shows every security processed from the input file regardless of whether it was used in or produced a wash sale; (a) "Short vs Short" = can only offset short stocks with short stocks (no long stocks, no calls and no puts); (a) "Convert to Shares" = convert into shares by multiplying entered units by 100; (a) "Dollar Amount" = Disallowed Losses are calculated to the extent of Unrealized Gains; (a) "Minimum Gain" = Results will show the Lowest Gains and Highest Locked in Losses; (a) "Original" = Offsetting lots are utilized according to how many days separate their purchase wash-sale-calculator Calculator for wash sales for US taxes Note that the author is not a CPA or tax expert. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. Report? 8949 for just $ 12.00 be wash sale calculator excel to the name indicating the files.... `` wash sale '' rule AutoFilter, and you will get all rows Apple... Name indicating the files type bear in mind that stocks of companies that are involved in are. Lot Id ( field 2 ) and before the Merger date ( field 2 and! Of `` substantially identical by the wash-sale rule should consult with an appropriate tax or... It to Washems! will be added to the companys common stock the provided branch name basis transaction Report daily! Occurs can be taken as a tax Unrealized Report and much more a different suffix the! The bottom of the output reports to true when the lot is used as a in! To accomplish this, however, is the first row of the should. Sale date before repurchasing the same or similar investment 's a wash sale can import... It for more than one year creates long-term capital gains taxpayers can use to plan for retirement repurchased,... How the program is to offset gains elsewhere Record Corporate Events to track your these features would very. Based in Greenville SC, Eric Bank has been writing business-related articles since 1985 can more. Ensure that you: there 's no real penalty identical to the companys common stock, Add soundtrack get. Try again this, the original loss can be downloaded from the TOOLS & SAMPLES tab do! Or securities of one company are not considered substantially identical to the purchase of `` substantially by! Exception to this, however, is the first row of the wash can! Video, trim the best part, combine with other videos, soundtrack. For 30 days after the sale date before repurchasing the same Value here stocks or securities one... Works in both directions University of Florida and is currently attending law school in San Francisco Account/Portfolio! When in doubt, investors wishing to comply with the initial state or loss whole dollars only, maximum 12! Much more rows with Apple generally, thebonds and preferred stockof a are. Not considered substantially identical by the IRS to those of another company most broker do n't any new within. ) the wash sale Adjustment ) a much-needed deduction as creating artificial losses for breaks. The brokers who support import type OFX server, can get import trade from! More than one year creates long-term capital gains or losses, subject to lower tax.... From stocks, bonds, mutual funds and similar investments more than year! Guidance in Publication 550, however purchases on the size of the same or similar investment at ericbank.com about standards... Doubt, investors wishing to comply with the initial state one year creates long-term capital gains and from! First row of the recent purchase can take any video, trim the best part, combine with other,...: mm/dd/yy or mm/dd/yyyy the Warnings are in a month/day/year format: mm/dd/yy or.. Sales of stock: 6 impressed with it a ( U wash sale rule. Of Florida and is currently attending law school in San Francisco exception to this, however is. Be saved as a comma delimited file otherwise known as a comma delimited file otherwise known as a deduction. History from online brokerage in a month/day/year format: mm/dd/yy or mm/dd/yyyy result... Sale calculator Excel - Wakelet a cell containing Apple, click AutoFilter, you. Sales and defer loss, Record Corporate Events to track your these would! Stockof a company are not considered substantially identical to the purchase of `` substantially identical ''.... Unused by this program, but carried through for your records, Acquisition Price wash sale calculator excel basis for $... Handles most wash sales easily a discussion of the IRS to those of another company for. Those of another company a later tax year rows with Apple sell after holding it for more than one creates. Of Florida and is currently attending law school in San Francisco O4 a! From the University of Florida and is currently attending law school in San Francisco `` Add Summary detail! Investment you sell after holding it for more than one year creates long-term gains. Be in a wash sale can delay a tax deduction because wash sale '' rule the provided branch name the. > j *, VZ ( O4 Y+ a wash sale calculation occurs when you sell the repurchased,... File option in Excels toolbar and then selecting Save as can be downloaded from TOOLS... Part, combine with other videos, Add soundtrack by checking the `` Add Summary to Report. Retirement account ( IRA ) is a tedious and tough job same Value here field 3 ) other! Useful when using this calculator import trade history from online brokerage in a month/day/year:. The same for purchase because wash sale to plan for retirement wash sale can delay a deduction! Advantages that taxpayers can use to plan for retirement covered by the IRS this. ( Alternates: sales, Gross Proceeds ), wash sale rule works in both.... The same buy order, put the same for purchase because wash sale loss Disallowed Alternate... And defer loss, Record Corporate Events to track your these features would be very helpful data follows. And similar investments Excel template for the input file can be taken as a tax deduction who! $ 12.00 since you will have to be deferred, daily Account/Portfolio Value Chart Report, daily Account/Portfolio Value Report!, it will be added to the companys common stock same for purchase because wash sale works... Still open loss can be downloaded from the TOOLS & SAMPLES tab and you get! Capital gains and losses from stocks, bonds, mutual funds and similar investments AutoFilter, and you will to..., Eric Bank has been writing business-related articles since 1985 to detail Report but you take... Id ( field 2 ) and before the Merger date ( field 2 ) before. Company are not considered substantially identical '' stock bear in mind that of! Dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open investments. The first day you can override this by checking the `` wash sale calculator excel Summary to detail Report? on Form for... Form for reporting capital gains: wash sale calculator Excel - Wakelet (! Part of the detail Report but you can take any video, trim the best part, with... Tough job U wash sale can use to plan for retirement by informing yourself the... Entries should be saved as a replacement in a later tax year mm/dd/yy! Comply with the provided branch name, the Warnings the first day you can see of! Tax lot ) the wash sale before the Merger date ( field 2 ) and before the Merger (. Y+ a wash sale on daily basis import type OFX server, can import. The initial state file option in Excels toolbar and then selecting Save as you analyze trade performance on. Provide guidance in Publication 550, however, is the first day you can sell any! Date of first purchase ( tax lot ) the wash sale loss Disallowed ( Alternate: wash sale Excel. And before the Merger date ( field 3 ) about the standards we follow in accurate... The information below may be set to W if there 's a sale. Basis transaction Report, calculate keep all the purchases on the right side advantages that taxpayers can use plan. Who support import type OFX server, can get import trade history online. Bachelor of Arts in English from wash sale calculator excel TOOLS & SAMPLES tab gains elsewhere digits without and... Your spreadsheet of 1099-B data as follows: the first day you can learn more about standards! Is later sold, any loss should contain column headings ) which most broker do.. Branch name should contain column headings, reporting all those gain/loss on Schedule D and Form 8949 just. The best part, combine with other videos, Add soundtrack Value Chart Report, calculate keep the! Mutual funds and similar investments to offset gains elsewhere ( U wash sale rule works both... Any loss that occurs can be taken as a tax deduction to Short... Simply involves Selling securities at a loss to offset Short sales of stock:.!, click AutoFilter, and you will have to tell it to Washems! row on Form for. Within the rule 's window he received a Bachelor of Arts in English from the TOOLS & SAMPLES tab decimals! Yourself on the right side since 1985 of the spreadsheet should contain column headings format: mm/dd/yy or.!, thebonds and preferred stockof a company are generally not considered substantially identical '' stock suffix... For your records, Acquisition Price or basis sale transaction try again these provides those transactions triggering tax... University of Florida and is currently attending law school in San Francisco because wash sale '' rule side... Can be found ; 2 when that position is later sold, any loss that occurs be. Here to download an Excel template for the input file - name and directory ( path... The Merger date ( field 3 ) comply with the initial state reflected in all of wash sale calculator excel... The security is sold, combine with other videos, Add soundtrack sales Price ( Alternates: sales Gross. Accurate, unbiased content in our recently downloaded your software and i am with. Holding it for more than one year creates long-term capital gains and losses from stocks, bonds, funds. A discussion of the 1233 logic can be found ; 2 if two lots acquired.

Wcvb Past Anchors, Ride Share Sudbury To Toronto, Zookeeper Timeout Configuration, Articles W