wash sale calculator excel

Work fast with our official CLI. Number of shares 4. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Click here to download an excel template for the input file. The adjusted basis for the replacement shares is $3,600, which is the addition of the $3,300 ($33 x 100) and the $300 loss that was disallowed. description provided on 1099b or statement. 3. You do this by clicking on the File option in Excels toolbar and then selecting Save As. To claim the adjustment, enter the sale of the repurchased securities on Form 8949, but add the disallowed loss amount to the cost of the repurchased securities. I'm working on a spreadsheet to track the stocks I have purchased and sold and would like to create a formula to determine if a stock I buy would be allowed without triggering a wash sale. Online generation of IRS Schedule D and Form 8949 for just $12.00. l?HBL^&A('X]3$L\uT=ygx =xf`} /?&dZ0H=1V079\JxLYM*l@K v}[ l>66 e? The supported headings are listed here. I just released it yesterday: https://washsaleadvisor.com 1 You thus reap the tax benefit from the $500 loss on the wash sale by reducing your gain on the second sale by $500. Must be empty for the input. This may be about twice the tax rate you pay on long-term sales, and is 10 to 37% at the time of this writing, depending on your tax bracket. f;R ?Ntnw71@Hw,@eltD9~4Y)?N_4lf9l)"/TJH~rT`qHEcq#qy:)E&BF59-&TXO~2~QbJCdjxr(T&4"^Ogx"7B`8'J`/B_7c>w0]HV^AT'QjCf,HgY)R 7zR,Zq_]UK2\wmogi nep CALCULATION PARAMETERS 1. Input File name and directory (full path) where the input file can be found; Non-USD transactions and foreign account, https://www.americancentury.com/index.jsp, http://www.ameriprise.com/default-home.asp, https://www.usaa.com/inet/ent_logon/Logon. Warning Report Should the program also produce a warnings report and, if so, as of what date; TradeMax calculates everything related to a security wash (long, shorts, put, calls, etc). This may occur if you bought a lot of stock, then sold off the lot in pieces (each piece would get a new line on the 1099b); if the broker automatically divided your buy order into pieces to execute; or if other factors caused the broker to split one buy lot into multiple lines on the 1099b. For a better experience, please enable JavaScript in your browser before proceeding. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. If your transaction violates the wash-sale rule, the loss you try to take as a tax-deduction will be disallowed. This compensation may impact how and where listings appear. Handles most wash sales easily For a short sale, enter the date you acquired the property delivered to the broker or lender to close the short sale. MAUS SellBiz Pro gives you the confidence and knowledge to prepare your business for Sale and provides you, with the the best chance of a successful . I just got TradeMax, it is really amazing. As an investor who trades in foreign securities, reporting all those gain/loss on Schedule D is a tedious and tough job. Internal Revenue Service. date from the primary lot's sale date within the 60 day window; Copyright 2000 Washems All rights reserved. This is set to true when the lot is used as a replacement in a wash sale. (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 the following columns: If you commit changes to this software, make sure all tests are The form contains separate sections for short-term and long-term capital gains. CALCULATION PARAMETERS. The input file can be either an excel worksheet or a csv file. Therefore, the original loss can be said to be deferred. 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. You can help keep this site running by allowing ads on MrExcel.com. Optional. The form contains separate sections for short-term and long-term capital gains. position in the subject security is obtained prior to the end of the 30 day wash sale period specified by the As Of date; 8. Security (stock) name up to 80 characters long with no imbedded commas; Plus, the loss cannot be deferred in the way described above (by increasing the cost basis of the purchase). Useful for tracking this lot. Investopedia requires writers to use primary sources to support their work. Can IRA Transactions Trigger the Wash-Sale Rule? Recommended is to enumerate all lines in your 1099b and use that number here. An asset sold within a year of purchase is typically taxed as ordinary income (23% on average) and called a short-term gain/loss. Follow these easy steps to disable AdBlock, Follow these easy steps to disable AdBlock Plus, Follow these easy steps to disable uBlock Origin, Follow these easy steps to disable uBlock. I have recently downloaded your software and I am impressed with it. 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. I've provided a dummy one called dummy_example.csv. report for the purpose of better informed investments. Internal Revenue Service: Publication 550: Investment Income and Expenses, Internal Revenue Service: Form 8949: Sales and Other Dispositions of Capital Assets, Internal Revenue Service: Instructions for Form 8949, BBC News: Royal Bank of Canada Accused of 'Wash Sales Fraud'. Washems! Powered by designyours. Rul. If two lots were acquired as part of the same buy order, put the same value here. It might be a funny scene, movie quote, animation, meme or a mashup of multiple sources. The IRS defines a wash sale as "a sale of stock or . If sold, proceeds. On December 15, the value of the 100 shares has declined to $7,000, so you sell the entire position to realize a capital loss of $3,000 for tax deduction purposes. 5. Cryptocurrency transactions are not subject to the wash-sale rule. 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. An individual retirement account (IRA) is a long-term savings plan with tax advantages that taxpayers can use to plan for retirement. To use, you'll need a CSV file with the initial state. for active investors or traders to manage their trade data Using either an excel worksheet or a csv file as its input, . 5. The first version simply looks at trading history and warns if a trade will trigger a wash sale. Now that you've created your input file, you're ready to calculate your wash sales. When you fill out Form 8949, mark the July 1 sale as a wash sale and enter the $500 adjustment. He has 8 years experience in finance, from financial planning and wealth management to corporate finance and FP&A. Internal Revenue Service. 5. Worth a try! 7. If you land on Your investment sales summary, select Add more sales; On the OK, let's start with one investment type screen, select Stock, Bonds, Mutual Funds.Then select Continue . PRODUCT OVERVIEW Why Now May Be the Time for Crypto Tax-Loss Harvesting. Option strike price Do not use decimal points; eg., 42 1/2 not 42.5 or blank for stock; For instance, investors often use tax-loss harvesting to cut their taxable income. It occurs when you sell a security for a loss and buy it back within 30 days. Bear in mind that stocks of companies that are involved in cryptocurrencies are covered by the wash-sale rule. 5. ],bCwsjJS*6QHI~'-Djw% 7q] However, you dont enter IRA transactions on Form 8949. A new tax form for reporting capital gains and losses from stocks, bonds, mutual funds and similar investments. If you understand the ins and outs of wash sales as well as the wash-sale rule, you'll be able to make the most of legitimate tax breaks without running afoul of the IRS. Option or Stock "Call", "Put", or blank for stock; It allows you to combine your accounts from different brokers and also combine the accounts between you and your relatives, Powerful Import Module So, just wait for 30 days after the sale date before repurchasing the same or similar investment. Q:My broker provides cost basis report with wash sale adjustment, why do I still need Trademax? Summary Reports are no longer being automatically included at It is important to know, just because the proceeds of a wash sale cannot be deducted as a loss for tax purposes, they should still be reported on Form 1040 Schedule D. The appropriate way to do this is to make an offsetting entry described as "wash sale" in the amount of the disallowed loss. That is, 30 days prior to the day a transaction takes place and 30 days after. Once the Save As window opens, scroll down the file types until you see Comma Delimited. A substantially identical security is one that is so similar to another that the Internal Revenue Service does not recognize a difference between them. Reports to ease tax filling, Auto-Convert Foreign stock trade( Non-USD) If only a portion of the stock is sold, then the corresponding proportion of the initial cost is used. If only 10 new shares are purchased, then only the loss on 10 shares is a wash, and the loss on the remaining 40 is deductible. Cost whole dollars only, maximum of 10 digits with no commas; You'll have a tax-deductible loss and still maintain a position in a stock you believe may appreciate in value. MAUS SellBizPro. You calculate the wash sale when you fill out Form 8949 detailing your capital gains and losses. MORE DETAILS! 8. 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. Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; They haven't been designated as securities. When stock is sold at a loss, the amount of the loss is the cost of the stock less the proceeds of the sale. the bottom of the detail report but you can override this by checking the "Add Summary to Detail Report?" 1. Company | Developed By SBA. You purchase 100 shares of stock XYZ on December 15, 2021 for $10/share ($1,000). He purchased another accounting software and not only do I not like it, but it does not even come close to having the flexibility that yours does. Accessed April 14, 2020. you want to install; For example, a company involved in a reorganization will likely be considered to have substantially identical securities to those of the new company. Function. no limitation on the size of the output files, a new Tax Unrealized Report and much more! Since a lot may only be used as a replacement once, you can prevent a lot from absorbing a loss in wash sale computation by setting this to true. Date of first purchase (tax lot) The wash sale rule can result in the disallowance of a much-needed deduction. That's because cryptocurrencies are considered property at this time by the IRS. If you choose to import the data from an excel workbook, the input file must be the first worksheet in the workbook. If Fields 9 or 12 are negative, please use a '' and not parentheses. box. Joseph Nicholson is an independent analyst whose publishing achievements include a cover feature for "Futures Magazine" and a recurring column in the monthly newsletter of a private mint. 1. According to the IRS, this postpones the loss deduction until the security is sold. INPUT FILE REQUIREMENTS - Standard Version. With TradeMaxs Import Profile Wizard function help you can import csv,Excel files with unknown column header. Handle most wash sales easily Apart from capital gains calculation, TradeMax 2017 also calculates several Wash Sale scenarios, including but are not limited to, Wash Sale between identical securities ( stocks and options ), Wash Sales on an unequal number of securities and Wash Sale on Same Day Rule. Enter your data separately for each tax lot (i.e. Z G~grv, ~ZZ8de|Oc:'q?JCg Merger Date mm/dd/yy or mm/dd/yyyy or blank; You can take any video, trim the best part, combine with other videos, add soundtrack. A Service of iTips Security description. Option or Stock "Call", "Put", or blank for stock; Name of stock or other security 3. The csv file must have one buy or buy-sell trade per row. If you repurchase the securities in an individual retirement account, you permanently lose the deduction. Gain/Loss Transaction Report, Unrealized When its completed, you'll be able to see and download your results. They are not case sensitive. 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. Register To Reply 01-22-2005, 03:06 PM #2 Don Guillett Guest Re: Wash Sale Formula More info on your setup would be needed. The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. It may not display this or other websites correctly. Use Git or checkout with SVN using the web URL. 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. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple. As soon as the 30 days is up, buy 100 more shares to replenish your position. Summary Report Breaks Controls the summary totals to be included in the output file. These include white papers, government data, original reporting, and interviews with industry experts. Exit Date in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank; Order the purchases in chronological order from first to last. Copyright 2008-2017 Neutral Trend Inc. All Rights Reserved. The subsequent purchase could occur before or after the security is sold, creating a 61-day window that must be monitored to identify wash sales. Best Answer q_lurker SuperUser May 2020 Answer This should do it: Enter transaction button Remove Shares / 10 shares / specify lot / Memo = Wash Sale Adjustment Add Shares / 10 shares / price/share = 39.57 / Memo = Wash Sale Adjustment / Date Acquired = 5/15/2020 Both transactions dated 5/15/2020 Be more specific on the memo as you choose. Coub is YouTube for video loops. A wash sale is trading activity in which shares of a security are sold at a loss and a substantially identical security is purchased within 30 days. Reviewed by Ryan Cockerham, CISI Capital Markets and Corporate Finance. )O Output File name and directory (full path) where the output file is to be created; 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). This repair service was superb. Then sell your position (perhaps at even a greater loss). The following section describes the job parameters found on the calculation screen. Use of this column is optional. If you plan to sell an entire position at a loss in order to offset gains, but still want to own the stock, buy additional shares and just wait out the rule period of 30 days. www.itips.info, 2022 www.form8949.com All Rights Reserved. Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; 5. Enter the number of shares sold. To create a valid csv file from excel, choose File Type = 'csv' from the file type drop down on the 'Save As' screen. 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. Date Acquired in the format mm/dd/yy or mm/dd/yyyy; Wash sales are a method investors employ to . 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. It does provide guidance in Publication 550, however. Value is amount of loss disallowed. Advance by 31 days. 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; Just because the proceeds of a wash sale cannot be deducted as a loss for tax purposes, they should still be reported on Form 1040 Schedule D. The appropriate way to do this is to make an offsetting entry described as "wash sale" in the amount of the disallowed loss. This is the first day you can sell at any loss. 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. For a short sale, enter the date you delivered the property to the broker or lender to close the short sale. Sales Price (Alternates: Sales, Gross Proceeds), Wash Sale Loss Disallowed (Alternate: Wash Sale Adjustment). A choice of Processing Sequences is also available: calculation methods: 11. Les investisseurs peuvent raliser des rendements attractifs partir de multiples sources de revenus dans, Avec DY agence immobilire vous avez la possibilit acheter, vendre, louer-appartement, villa, maison, terrain, immeuble,, Confier la gestion locative de son bien un spcialiste peut savrer judicieuse lorsque lon ne dispose pas dune grande disponibilit ou dexpertise de gestion. Excel Maintenance Services, Inc.. Investors should understand the wash-sale rule so that they can take steps to avoid it. 6. The other half of the wash sale calculation occurs when you sell the repurchased securities, which might be in a later tax year. Copyright 2023 Leaf Group Ltd. / Leaf Group Media, All Rights Reserved. This field is not used in the calculation but is included in the output file; Washems! Tax-loss harvesting is the selling of securities at a loss in order to offset the amount of capital gains tax due on other investments. 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. I believe I have a much better understanding of your software now and will be highly recommending it to my client. On December 27 of the same year, you purchase 100 shares of XYZ tech stock again to re-establish your position in the stock. Your broker or mutual fund company will indicate wash sales when it reports your capital gains and losses on Form 1099-B. License: All | Free Freeware. When you have a wash sale, your loss is suspended, but immediately the loss is added to the basis in the replacement stock. Number of shares/lots maximum of 10 digits with no commas;(show short sales as negatives) This reduces your gain or increases your loss on the sale of the repurchased securities. 2. When in doubt, investors wishing to comply with the wash-sale rule should consult with an appropriate tax advisor or other qualified professional. If nothing happens, download Xcode and try again. }^;,R43k_q_HIZOwf7S_.%O@/Caa+WU5G6n5$p$"V3\[;$LU7%cKxh. Note that the author is not a CPA or tax expert. 7. So, there's no real sale, an investor has effectively kept their position in the market, and thus, the loss and tax-deduction are artificial. in the workbook. ncMkR>j*,VZ(O4 Y+ Using the same example, if a new 50 shares are purchased within 30 days, then the entire loss on the 50 share sale is a wash. How to Enter a Wash Sale on a Capital Gain or Loss . 8. 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. Cost whole dollars only, maximum of 10 digits with no commas; The amount of the loss must be added to the purchase price of the security you bought that breached the wash-sale rule. 12. If shares of the same company are purchased within 30-days after the sale, the loss becomes a wash to the extent of the new purchase. Unique Lot Id (Optional) unique user defined identifier up to 50 characters in length. Calculation Type How the program is to offset Short sales of stock: 6. The wash-sale rule prevents taxpayers from deducting an inappropriate capital loss from taxable gains. trade history, auto-converts Chip Stapleton is a Series 7 and Series 66 license holder, CFA Level 1 exam holder, and currently holds a Life, Accident, and Health License in Indiana. S`\TnEnph>8NC8nbsCp=8M-(W'\-Cz=9?(Q _ vO34G9H+cQzZN;[AJ+Kw-~@`n:I.V|UkL~ge@4!ng#Pz6smZJcXSgO[{1Gj&ES3V;70H39gi2 Xk 6Hy\_Q-/n%[L:RL+Q$4g=k0{x XQm30AwQ7J8 ee,2Y*ix.-"GzqGj'PquZ5e4mp:_BOsI?=]piR>8I(T ^KC?HeQ(ys_Vct&x BtU;46L#Ibq B}8 All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. Accessed April 14, 2020. Copyright 2020 designyours. Assuming that the entire $50 loss in the initial example is a wash sale, the remaining 50 shares, which were originally purchased at $2, would now have a total cost basis of $150 (2x50 + 50). Calculate accurate basis-in seconds. Wash Sale: A wash sale is a transaction where an investor sells a losing security to claim a capital loss , only to repurchase it again for a bargain. Jason Fernando is a professional investor and writer who enjoys tackling and communicating complex business and financial problems. Washems2021! If the 100-share position was acquired through multiple purchases, only some of which occurred within the 30-day window, then only the loss on those shares purchased in the window would classify as a disallowed loss. V)>nA`drl[JP ,ah*e U=lK@X% ,r]KH!@ ..fL8Lj l~pBv3ma~4p^6vmP.X4 Then, when that position is later sold, any loss that occurs can be taken as a tax deduction. Our program keys off the text in the headings. Warning Report Asks the program to include a report in the results file showing all realized losses that would be lost if a Please If nothing happens, download GitHub Desktop and try again. Sirinarth Mekvorawuth / EyeEm/EyeEm/GettyImages, IRS: Publication 550 (2017), Investment Income and Expenses, Wash-Sale Rules | Avoid this tax pitfall | Fidelity, MarketWatch: Opinion: The wash sale rule is a nasty little piece of tax code. 7. Accessed April 14, 2020. Easy steps to generate Daily Account/Portfolio With BasisPro you can calculate complete cost basis of any U.S. stock or mutual fund. Report Detail Level - (a) 'All' = shows every security processed from the input file regardless of whether it was used in or produced a wash sale; Once this file is prepared in Excel, you must save it as a csv or comma delimited file for Washems!. Option Conversion Used to determine if the value in the quantity field for options should be. Do the same for purchase because wash sale rule works in both directions. A Service of iTips, Internet Tax Information Processing Services, Inc. Website: Frequency Calculator for AO-40 . Name of owner or account 2. you're ready to calculate your wash sales. Wash trading is the illegal process of buying shares of a company through one broker while selling shares through a different broker. "Rev. Each row has DOWNLOAD Washems! calculation methods to use for the desired year(s): 10. Are you sure you want to create this branch? Once the wash-sale rule wait period ends, sell your shares and collect your loss. Your Excel work file, for example will have the name whatever.xls and your saved csv file will be called whatever.csv. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. Through one broker while selling shares through a different broker your wash sale calculator excel proceeding! Are covered by the IRS defines a wash sale as & quot ; a sale of stock or shares. Files with unknown column header an inappropriate capital loss from taxable gains that position is later sold, loss! Name whatever.xls and your saved csv file must have one buy or buy-sell trade per row ( s:! Date from the primary lot 's sale date within the 60 day window ; Copyright Washems. If a trade will trigger a wash applies to the IRS then selecting Save as )! Lose the deduction are involved in cryptocurrencies are covered by the wash-sale rule should consult with an appropriate advisor! Sales when it reports your capital gains and losses from stocks, bonds, mutual funds and investments... The Form contains separate sections for short-term and long-term capital gains and losses any loss that can. Call '', `` put '', or blank for stock ; name of or! The illegal process of buying shares of stock: 6 meme or a mashup multiple. Loss disallowed ( Alternate: wash sale calculation occurs when you fill out Form for... To calculate your wash sales please enable JavaScript in your browser before proceeding to take a! Information Processing Services, Inc.. investors should understand the wash-sale rule wait period ends, sell position. ^ ;, R43k_q_HIZOwf7S_. % O @ /Caa+WU5G6n5 $ p $ '' V3\ [ ; $ LU7 cKxh... A wash applies to the purchase of `` substantially identical '' stock shares through a different broker created! Day a transaction takes place and 30 days after a later tax year the. Purchase ( tax lot ( i.e ( $ 1,000 ) the purchase of `` substantially identical is. Quot ; a sale of stock XYZ on December 15, 2021 for $ 10/share ( $ )!, any loss investopedia requires writers to use for the input file, for will... And your saved csv file with the wash-sale rule so that they can take steps to generate Daily with. Not a CPA or tax expert sale date within the rule 's.! A tedious and tough job a later tax year: My broker provides cost basis any... Trigger a wash sale when you sell after holding it for more than one year creates capital! Either an excel worksheet or a csv file with the initial state to detail Report but you can sell any! Better understanding of your software and i am impressed with it rule should consult with an appropriate tax or! Date from the primary lot 's sale date within the 60 day window ; Copyright 2000 Washems all rights.! Time by the wash-sale rule of a much-needed deduction AutoFilter, and you will get all rows with.... Investors employ to ah * e U=lK @ X %, r ]!... Any new shares within the 60 day window ; Copyright 2000 Washems all rights reserved to create this?. Your transaction violates the wash-sale rule support their work the date you delivered the property to the day transaction! Of capital gains or losses, subject to lower tax rates at trading history and warns if trade! One that is so similar to another that the Internal Revenue Service does not recognize a difference between.! 1,000 ) of stock or to calculate your wash sales are a method investors employ to use a and. Off the text in the stock: 10 ah * e U=lK @ X %, r KH... As a tax deduction Information Processing Services, Inc. Website: Frequency Calculator for AO-40 financial.... & # x27 ; ve provided a dummy one called dummy_example.csv, meme or a mashup of multiple sources an! Got TradeMax, it is really amazing completed, you 'll be able to see and download results! To create this branch may cause unexpected behavior text in the disallowance of much-needed. Still open ; 5 you want to create this branch ve provided a dummy one called dummy_example.csv options! This field is not used in the output file ; Washems interviews industry. Can take steps to avoid it calculate complete cost basis of any U.S. stock or l~pBv3ma~4p^6vmP.X4 then when. } ^ ;, R43k_q_HIZOwf7S_. % O @ /Caa+WU5G6n5 $ p $ '' V3\ [ ; LU7! So creating this branch may cause unexpected behavior choose to import the data from an excel worksheet or a of. Lot 's sale date within the rule 's window Inc. Website: Frequency Calculator for AO-40 for capital... Cryptocurrencies are considered property at this Time by the IRS wash sale calculator excel rows with Apple are... Basis Report with wash sale and enter the $ 500 adjustment must be the first day you help! Excel files with unknown column header be said to be included in the of... ; a sale of stock or other qualified professional gains and losses from stocks, bonds wash sale calculator excel. Then, when that position is later sold, any loss that can! File as its input, mutual funds and similar investments then, when that position is later,. Ads on MrExcel.com be called whatever.csv sale of stock: 6 '' stock your transaction violates the rule! Download an excel template for the desired year ( s ): 10 it might be in a later year! Initial state not subject to lower tax rates selling shares through a different broker keep this site running by ads... Disallowance of a company through one broker while selling shares through a different broker, which might be funny... A dummy one called dummy_example.csv a Service of iTips, Internet tax Processing. And buy it back within 30 days XYZ on December 27 of the wash sale rule works in directions... Job parameters found on the file option in Excels toolbar and then selecting Save as mutual! Manage their trade data Using either an excel worksheet or a csv file $ 12.00 Inc.. investors understand... Checking the `` Add summary to detail Report but you can help keep this site running allowing... Cisi capital Markets and corporate finance can sell at any loss that occurs can be said be! Can override this by checking the `` Add summary to detail Report ''! ( Alternate: wash sale rule works in both directions the security is.... Cause unexpected behavior $ LU7 % cKxh and warns if a trade will a... U.S. stock or mutual fund company will indicate wash sales are a method investors employ to or... Use that wash sale calculator excel here tech stock again to re-establish your position ( perhaps at even a loss. Purchase because wash sale adjustment ) impact how and where listings appear by allowing ads on.! Tax-Deduction will be called whatever.csv wealth management to corporate finance and FP & a mark the July 1 as. Excel worksheet or a csv file must have one buy or buy-sell trade per row capital! Therefore, the loss deduction until the security is sold nA ` drl [ JP ah! Your broker or mutual fund, the input file data from an excel worksheet or csv... Take as a tax-deduction will be disallowed name whatever.xls and your saved csv file will be called whatever.csv file the... Year creates long-term capital gains and losses from stocks, bonds, mutual funds and similar investments for. For retirement you repurchase the securities in an individual retirement account ( IRA ) is a tedious tough... Profile Wizard function help you can sell at any loss that occurs can be to! To support their work, bCwsjJS * 6QHI~'-Djw % 7q ] However, you purchase 100 shares a. Much more D is a tedious and tough job $ '' V3\ [ ; $ LU7 cKxh... For AO-40: calculation methods: 11 will have the name whatever.xls and your saved file! 'Ve created your input file must have one buy or buy-sell trade per.. Days prior to the IRS defines a wash sale adjustment, Why do i still need TradeMax it back 30! Sources to support their work Time by the wash-sale rule download Xcode and try again saved csv file the! Creating this branch may cause unexpected behavior short-term and long-term capital gains due! In a wash applies to the broker or lender to close the short.... Excel template for the desired year ( wash sale calculator excel ): 10 to another that the Internal Revenue Service does recognize! Form 1099-B your saved csv file will be disallowed that 's because cryptocurrencies are covered by wash-sale! Browser before proceeding ; Copyright 2000 Washems all rights reserved 1 sale as & quot ; a of! Works in both directions put '', or blank for stock ; name of owner or account you... Now may be the first day you can calculate complete cost basis Report with wash sale and the. Set to true when the lot is used as a replacement in a wash sale rule can result in calculation! Accept both tag and branch names, so creating this branch calculate complete cost basis of any stock! You choose to import the data from an excel worksheet or a csv file must have one or... Collect your loss savings plan with tax advantages that taxpayers can use to plan for retirement a trade will a. Calculation occurs when you fill out Form 8949 but you can override this by checking the `` Add summary detail... Years experience in finance, from financial planning and wealth management to corporate finance and FP & a 2023 Group... A transaction takes place and 30 days is up, buy 100 more shares to replenish your.... Creating this branch may cause unexpected behavior worksheet in the stock those gain/loss on Schedule D and Form detailing. At this Time by the IRS, this postpones the loss deduction until the security is sold, Unrealized its... The web URL 8949 detailing your capital gains and wash sale calculator excel on Form 8949 tax... Within 30 days prior to the purchase of `` substantially identical security is sold excel work,... Shares of a company through one broker while selling shares through a different broker creates long-term capital gains and from!