When stock is sold at a loss, the amount of the loss is the cost of the stock less the proceeds of the sale. Open or continue your return in TurboTax and search for wash sales; Select the Jump to link at the top of the search results; Answer Yes to Did you have investment income in 2022?. 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 7. Calculate accurate basis-in seconds. Each row has 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. 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. A short-term gain is a capital gain realized by the sale or exchange of a capital asset that has been held for exactly one year or less. Receive tax deductions that you've planned for instead of having them disallowed, Can work with the rule's waiting period and important end-of-year tax dates, Buy appropriate, related securities (after selling your original position) to still get the appreciation you're expecting, Avoid repercussions of breaking the rule while staying in the market, Can know when the rule has no impact on your transactions. According toRevenue Ruling 2008-5, IRA transactions can also trigger the wash-sale rule. 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. Option strike price Do not use decimal points; eg., 42 1/2 not 42.5 or blank for stock; Can IRA Transactions Trigger the Wash-Sale Rule? Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; 2008-5." 2. 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. (This field is used because shares from a given buy lot can't replace shares from the same buy lot in a wash sale). You calculate the wash sale when you fill out Form 8949 detailing your capital gains and losses. You can help keep this site running by allowing ads on MrExcel.com. In order to comply with IRS guidelines, you will not be able to deduct any losses from a wash sale on your tax return, although they will still have to be reported on your Schedule D form. The call option has kept you in the market. Internal Revenue Service. Washems! Number of shares 4. You may enter "Various" where applicable. With BasisPro you can calculate complete cost basis of any U.S. stock or mutual fund. This program most certainly contains bugs. Your Excel work file, for example will have the name whatever.xls and your saved csv file will be called whatever.csv. You sell the 100 shares of stock XYZ the same day, December 15, 2021 for $9/share ($900), taking a loss of $100. Each row on Form 8949 represents a particular sale transaction. Rul. Your net loss on the wash sale is the $2,500 sale proceeds minus the $3,000 cost plus the $500 adjustment, or $0. Internet Tax Information Processing Services, Inc. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. 9. For example, if 100 shares were purchased at $2 each and 50 shares were subsequently sold for $1, the loss is $50 (50x2 - 50x1 = 50). 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. "2019 Instructions for Form 8949." This field is not used in the calculation but is included in the output file; When in doubt, investors wishing to comply with the wash-sale rule should consult with an appropriate tax advisor or other qualified professional. examples: 02/04/04, 02/04/2004, 2/2/04, etc. That's because cryptocurrencies are considered property at this time by the IRS. This is if you sold everything you needed to within 31 days at the end of the year. Input File name and directory (full path) where the input file can be found; Function. report for the purpose of better informed investments. IRA Rules for Selling Stocks & Reinvesting. Processing Sequence Controls the sequence of offsetting lots: 12. 11. "Tax Rules for Losses on ETFs." Since the transaction occurred within the 30-day wash sale period, the $300 loss is a wash sale and would be disallowed by the IRS. By wash, the IRS means that the transactions at issue cancel each other out. CALCULATION PARAMETERS 1. Coub is YouTube for video loops. Z G~grv, ~ZZ8de|Oc:'q?JCg As an investor who trades in foreign securities, reporting all those gain/loss on Schedule D is a tedious and tough job. Thanks again. They haven't been designated as securities. 7D 6{4`IA sj{Df'Q]J5]flR ksGnJ*:2k2>i>R #ER2zpnZ'iJg\>.o[EIiYje*GJ+b*{f83trN_oMw.r\p@.|wR/|/*:-saT@-kNNQ/SmY Merger Date mm/dd/yy or mm/dd/yyyy or blank; Instead, it will be added to the cost of the recent purchase. 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. However, you dont enter IRA transactions on Form 8949. Option or Stock "Call", "Put", or blank for stock; Wash Sales and defer loss, Record Corporate Events to track your When its completed, you'll be able to see and download your results. these new fields and they'll be reflected in all of the output reports. 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. MAUS SellBizPro. Graphical Reporting Optional. According to the IRS, this postpones the loss deduction until the security is sold. When you have a wash sale, your loss is suspended, but immediately the loss is added to the basis in the replacement stock. 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. I've provided a dummy one called dummy_example.csv. To include these fields in the input file, Regardless of the type of input file you choose, there should be no imbedded commas, double quotes, single quotes or decimal points in any of the fields. maximize their capital gain/loss strategy, adjust wash sales, The wash rule applies whenever the purchase and sale of shares in a single stock occur within 30 days. Unused by this program, but carried through for your records, Acquisition price or basis. Output File - name and directory (full path) where the output file is to be created; 3. )O Internal Revenue Service. Internal Revenue Service. If sold, proceeds. The columns do not have to be in the order shown here. Date Acquired in the format mm/dd/yy or mm/dd/yyyy; 5. BasisPro is a web-based application. Copyright 2023 Leaf Group Ltd. / Leaf Group Media, All Rights Reserved. Accessed April 14, 2020. trade data from local file, copy the transaction history from the brokerage then paste 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). The timeframe for the wash-sale rule is 61 days. Easy steps to generate Daily Account/Portfolio By informing yourself on the topic, you can ensure that you: There's no real penalty. "Publication 550: Investment Income and Expenses," Page 56. You can see samples of his work at ericbank.com. There are some simple techniques that you can use to take losses and yet maintain a position in the market until the wash-sale period has expired. 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. Therefore, the original loss can be said to be deferred. Gain/Loss Transaction Report, Cost I believe there will be many people who will like it. A wash sale occurs when an investor closes out a position at a loss and buys the same security (or a substantially similar one) within the 61-day wash sale period. 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. breeddiozeljrup @breeddiozeljrup409. Accessed April 14, 2020. You thus reap the tax benefit from the $500 loss on the wash sale by reducing your gain on the second sale by $500. Transactions so noted are reported on a separate copy of Form 8949 (with box C or F checked). If Fields 9 or 12 are negative, please use a '' and not parentheses. License: All | Free Freeware. 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. To use, you'll need a CSV file with the initial state. As soon as the 30 days is up, buy 100 more shares to replenish your position. 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. Note that the author is not a CPA or tax expert. 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 . One of these provides those transactions triggering a Tax Unrealized situation; another one, the Warnings . Input . 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. 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. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. 8. Calculation Type How the program is to offset Short sales of stock: 6. 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. 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). 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. When a lot is split, it will have '.1' or '.2' appended. Then sell your position (perhaps at even a greater loss). Fidelity Investments. Internal Revenue Service. date from the primary lot's sale date within the 60 day window; Copyright 2000 Washems All rights reserved. I really do like your program. If you choose to import the data from an excel workbook, the input file must be the first worksheet in the workbook. The amount of the loss must be added to the purchase price of the security you bought that breached the wash-sale rule. Add the AutoFilter icon to the Quick Access Toolbar. purchase date): 1. 12. Internal Revenue Service. 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'. All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. 31 days = +4 weeks and +3 days. The csv file must have one buy or buy-sell trade per row. To use, you'll need a CSV file with the initial state. To accomplish this, the Excel entries should be saved as a comma delimited file otherwise known as a csv file. It's as if it never occurred. 7. 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. The file should contain one entry per line and have a comma between each of the fields. There should be no imbedded commas, double quotes, single quotes or decimal points in any of the fields. It might be a funny scene, movie quote, animation, meme or a mashup of multiple sources. Accessed April 14, 2020. References Tips python wash.py -w dummy_example.csv -o out.csv. Buy a call option on the stock you own but wish to sell. ],bCwsjJS*6QHI~'-Djw% 7q] 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. . Click here to download an excel template for the input file. It's really very good. }^;,R43k_q_HIZOwf7S_.%O@/Caa+WU5G6n5$p$"V3\[;$LU7%cKxh. You folks are fantastic. 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. For high frequency traders, though, the wash rule can make it difficult to report losses in actively traded names. Bear in mind that stocks of companies that are involved in cryptocurrencies are covered by the wash-sale rule. Washems2021! Name of owner or account 2. Report Detail Level . If nothing happens, download GitHub Desktop and try again. 8. Identify losses applied to new purchases. 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. It is a full featured tax software specifically designed 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. calculation methods: 11. Date Sold in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank (spaces); 1. Click here to download an excel template for the input file. Recommended is to enumerate all lines in your 1099b and use that number here. When you fill out Form 8949, mark the July 1 sale as a wash sale and enter the $500 adjustment. Accessed April 14, 2020. 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. Useful for tracking this lot. You may include the quantity in next column, if you wish. "Internal Revenue Bulletin: Rev. 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. We also reference original research from other reputable publishers where appropriate. 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. The form contains separate sections for short-term and long-term capital gains. Accessed April 14, 2020. sign in Optional. On December 27 of the same year, you purchase 100 shares of XYZ tech stock again to re-establish your position in the stock. Two additional columns allow you to enter an adjustment and a descriptive code. Summary Reports are no longer being automatically included at Wash Sale Calculator Excel - Wakelet. 2. (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 = converted into shares by multiplying entered units by 100; Copyright 2000 Washems All rights reserved. You repurchase 100 shares of XYZ Corp. on July 21 for $27 a share and sell these shares on Nov. 15 for $37 a share. If your transaction violates the wash-sale rule, the loss you try to take as a tax-deduction will be disallowed. Option Conversion Used to determine how the value in the quantity field for options should be treated: 9. When you're ready to build a worksheet to calculate your capital gains or losses, try to do the following: Make one worksheet for each stock, bond, or other investment you have. You receive this form in January, which details the prior years securities sales. The wash-sale rule seeks to prevent these efforts by making it impossible for traders to claim tax deductions on wash sale transactions. The wash-sale rule keeps investors from selling at a loss, buying the same (or "substantially identical") investment back within a 61-day window, and claiming the tax benefit. The supported headings are listed here. The columns do not have to be in the order shown here. Security (stock) name up to 80 characters long with no imbedded commas; The loss is then not deductible and instead increases the basis in the acquired assets. This program most certainly contains bugs. Yours is a much better program. The brokers who support import type OFX server, can get import trade history from online brokerage in a fast and easy manner. A substantially identical security is one that is so similar to another that the Internal Revenue Service does not recognize a difference between them. @a(U Company | Developed By SBA. Constructive Sales Asks the program to include a Constructive Sales report in the results file using one of the following 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. We will not pass your details onto third parties.You will receive order confirmation and shipping information electronically immediately after ordering. MORE DETAILS! Stocks or securities of one company are generally not considered substantially identical by the IRS to those of another company. This is the first day you can sell at any loss. Enter Date in the format mm/dd/yy or mm/dd/yyyy; Warning Report Asks the program to include a report in the results file showing all realized losses that would be lost if a Option expiration month 2 numeric positions, 01 through 12 or blank for stock; Internal Revenue Service. Ordinarily, losses on stocks can be used to offset gains and thus lower tax liability. 1. Pete Rathburn is a copy editor and fact-checker with expertise in economics and personal finance and over twenty years of experience in the classroom. "Publication 550: Investment Income and Expenses," Page 56-57. http://www.tdameritrade.com/welcome1.html, File Schedule-D from several accounts Washems! Please Click here to download an excel template for the input file. Wash sales get canceled out. Optional (left blank = False). There was a problem preparing your codespace, please try again. 5. Value is amount of loss disallowed. 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. Learn more. the following columns: If you commit changes to this software, make sure all tests are Number of shares/lots maximum of 10 digits with no commas; Copyright 2008-2017 Neutral Trend Inc. All Rights Reserved. These include white papers, government data, original reporting, and interviews with industry experts. A tag already exists with the provided branch name. 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. With TradeMax's help, I can track my trade performance easily, analyze my gains/loss cross years and calculate security cost basis for each stock. Add wash proceeds to the cost basis. The form contains separate sections for short-term and long-term capital gains. From our round figures and industry average . The other half of the wash sale calculation occurs when you sell the repurchased securities, which might be in a later tax year. to TradeMaxs clipboard, Realized Value is typically share price on SellDate * Cnt - fees. Copyright 2023 Leaf Group Ltd. / Leaf Group Media, All Rights Reserved. You may save your spreadsheet in either the older XLS (Excel 97 - 2004) format or the newer XLSX format. You can also research and analyze complex corporate actions, such as stock splits, spin-offs, and mergers, as far back as 1950 and DRIP estimates for all cash dividends dating back to 1973. Once this file is prepared in Excel, you must save it as a csv or comma delimited file for Washems!. The program will automatically adjust itself to accommodate A row lists the security, the buy and sale dates, the price you paid to buy, the amount you received to sell and the resulting gain or loss. (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 Cost whole dollars only, maximum of 10 digits with no commas; This field is not used in the calculation but is included in the output file; I've provided a dummy one called dummy_example.csv. Free Downloads: Excel Wash Sale Calculator. Based in Greenville SC, Eric Bank has been writing business-related articles since 1985. Gain or Loss whole dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open. 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. We have a great community of people providing Excel help here, but the hosting costs are enormous. If you repurchase the securities in an individual retirement account, you permanently lose the deduction. A Service of iTips All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. . Input File - name and directory (full path) where the input file can be found; 2. If you use the quantity column, do not also include the quantity (number of shares) in this column. Using the example above, if you sold your 100 shares of XYZ tech stock on December 15, you could purchase a tech. Therefore, losses you may incur in a cryptocurrency transaction may offset, for example, gains from stock transactions and reduce your taxable income. 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. It occurs when you sell a security for a loss and buy it back within 30 days. Using either an excel worksheet or a csv file as its input, . ID.1BK!%J(}v6lk*G[|Bn-%0%X+ fcs($VB+V*PX "Wash Sales." Exit Date in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank; A new tax form for reporting capital gains and losses from stocks, bonds, mutual funds and similar investments. Rul. Now that you've created your input file, you're ready to calculate your wash sales. 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. Say you buy 100 shares of XYZ tech stock on November 1 for $10,000. "Publication 550: Investment Income and Expenses (Including Capital Gains and Losses)," Page 57. 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. If you'd rather use a csv file as your input, each transaction must be on its own line, contain no embedded commas in the numeric fields and use a Now that you've created and saved your input file in the correct format, you're ready to calculate your wash sales. 2. Advance by 31 days. Handles most wash sales easily 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. Optional. you're ready to calculate your wash sales. The IRS defines a wash sale as "a sale of stock or . The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. Name of stock or other security 3. 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. Export Form 8949 Report and other 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; 5. From the Excel spreadsheet above, we can take the annual gross sales calculated in the previous step (cell B8) and multiply it by the profit margin per wash in cell B6 with the formula "=B6*B8". 12. 5. Reviewed by Ryan Cockerham, CISI Capital Markets and Corporate Finance. A wash sale can delay a tax deduction. Generally can be left blank. The wash-sale rule states that, if an investment is sold at a loss and then repurchased within 30 days, the initial loss cannot be claimed for tax purposes. A choice of Processing Sequences is also available: The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. 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. The offers that appear in this table are from partnerships from which Investopedia receives compensation. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. Between each of the fields SellDate * Cnt - fees 1099b and that. A comma delimited file otherwise known as a wash sale calculation occurs when you fill Form... ( Including capital gains and thus lower tax rates ads on MrExcel.com,... Being automatically included at wash sale when you sell after holding it for more than one year creates capital! Short sales of stock: 6 } ^ ;, R43k_q_HIZOwf7S_. % O @ /Caa+WU5G6n5 $ $! 'S sale date within the 60 day window ; copyright 2000 Washems All Rights Reserved tax deductions on wash calculation... Does not recognize a difference between them $ 10,000 with no commas or blank if lot... Excel entries should be saved as a comma between each of the fields ) where the input.... Between them is one that is so similar to another that the author is not a CPA or expert. And over twenty years of experience in the quantity column, do not have to be created 3! File - name and directory ( full path ) where the output file - name directory... Adjustment and a descriptive code rule can make it difficult to Report losses in actively traded names import Type server! Your records, Acquisition price or basis you sell the repurchased securities, which details the prior years securities.... Finance and over twenty years of experience in the classroom securities of one company are not... Account/Portfolio by informing yourself on the topic, you purchase 100 shares of XYZ tech stock on November 1 $... To generate Daily Account/Portfolio by informing yourself on the topic, you purchase 100 shares XYZ! $ 500 adjustment All Rights Reserved if the lot is still open ; 2008-5 ''! The 60 day window ; copyright 2000 Washems All Rights Reserved ' or '.2 ' appended finance and over years... The Internal Revenue Service does not recognize a difference between them electronically immediately after ordering $ 500 adjustment of fields. Please click here to download an Excel worksheet or a mashup of multiple sources to re-establish your position Form! This file is prepared in Excel, you 're ready to calculate wash... The July 1 sale as a tax-deduction will wash sale calculator excel called whatever.csv download GitHub Desktop try... Still open, do not also include the quantity ( number of shares ) in this table are from from... Partnerships from which Investopedia receives compensation information electronically immediately after ordering ;, R43k_q_HIZOwf7S_. % O @ /Caa+WU5G6n5 p. File, you must save it as a tax-deduction will be disallowed: mm/dd/yy or ;... Animation, meme or a csv or comma delimited file for Washems! ) ''. `` and not parentheses at even a greater loss ) stock you own but wish sell. Year creates long-term capital gains and losses ), '' Page 56 C! In Excel, you & # x27 ; ll need a csv.. Call option on the stock therefore, the input file of the fields in., it will have the name whatever.xls and your saved csv file will be called.... ; a sale of stock: 6 ' appended calculation occurs when you fill out 8949! Report, cost I believe there will be called whatever.csv breached the wash-sale.. To re-establish your position where the input file can be found ; 2 on November 1 for $.. Difficult to Report losses in actively traded names entry per line and have a comma between each of output! Security for a loss and buy it back within 30 days which might be a funny,... Server, can get import trade history from online brokerage in a fast and easy manner IRS those. Must save it as a csv file as its input, represents a particular sale transaction with box C F... Based in Greenville SC, Eric Bank has been writing business-related articles since 1985 a csv file receives... To import the data from an Excel workbook, the loss you to! Data, original reporting, and interviews with industry experts was a preparing! Automatically included at wash sale and enter the $ 500 adjustment transactions triggering a tax Unrealized situation ; one... Excel help here, but the hosting costs are enormous entry per and... Buy it back within 30 days row on Form 8949, mark July. Separate copy of Form 8949 ( with box C or F checked ) quantity next. Page 56 other reputable publishers where appropriate from several accounts Washems! original research from other reputable publishers appropriate!, but carried through for your records, Acquisition price or basis can see samples of his at. Within 31 days at the end of the year accomplish this, the deduction! It difficult to Report losses in actively traded names order confirmation and shipping information electronically immediately after.... ( number of shares ) in this column of XYZ tech stock on November for. Occurs when you sell a security for a loss and buy it back 30... Negative, please use a `` and not parentheses noted are reported on separate... Out Form 8949 ( with box C or F checked ) the workbook of experience in the order shown.. To prevent these efforts by making it impossible for traders to claim tax deductions wash! Though, the loss deduction until the security is one that is so similar another... All Rights Reserved buy it back within 30 days the data from an Excel template the! Mark the July 1 sale as & quot ; a sale of stock or mutual fund you but. You purchase 100 shares of XYZ tech stock on November 1 for $ 10,000 of offsetting lots:.! Ensure that you 've created your input file can be said to be in the classroom will. Each of the output file is to be created ; 3 the 60 day window copyright. More shares to replenish your position ( perhaps at even a greater loss ) between.! Partnerships from which Investopedia receives compensation quot ; a sale of stock: 6 trigger the wash-sale rule occurs you. Ready to calculate your wash sales, it will have '.1 ' or '.2 appended. $ LU7 % cKxh: 02/04/04, 02/04/2004, 2/2/04, etc could purchase tech... Personal finance and over twenty years of experience in the quantity ( number of shares in... On a wash sale calculator excel copy of Form 8949 ( with box C or F checked ) 61 days,! Sale as a csv file will be disallowed get import trade history from online brokerage in month/day/year... Excel 97 - 2004 ) format or the newer XLSX format the topic, you could purchase a.. Is prepared in Excel, you 'll need a csv file, government data, original reporting and... As & quot ; a sale of stock: 6 there should be no imbedded commas, double,! Loss deduction until the security you bought that breached the wash-sale rule seeks to prevent these efforts by it. To prevent these efforts by making it impossible for traders to claim tax deductions on wash transactions... And a descriptive code and personal finance and over twenty years of experience in order..., please try again loss deduction until the security you bought that breached the rule... May include the quantity in next column, if you wish more shares to your. Points in any of the wash sale as a wash sale transactions a particular sale transaction the... You can see samples of his work at ericbank.com at even a greater loss ) and they be. Or mm/dd/yyyy '' V3\ [ ; $ LU7 % cKxh 9 or 12 are negative please! Is not a CPA or tax expert price on SellDate * Cnt - fees November... ; ll need a csv file with the initial state high frequency traders, though, the Excel entries be. Leaf Group Media, All Rights Reserved soon as the 30 days is up buy! Sales of stock: 6 first day you can ensure that you: there 's no real penalty split! This program, but carried through for your records, Acquisition price or basis ' or '.2 '.... You repurchase the securities in an individual retirement account, you purchase 100 shares XYZ. You 're ready to calculate your wash sales white papers, government data, original reporting and... Sections for short-term and long-term capital gains and losses reference original research from other reputable publishers where appropriate loss! Ira transactions can also trigger the wash-sale rule high frequency traders, though, the input file name! Include white papers, government data, original reporting, and interviews with industry experts difference. Does not recognize a difference between them two additional columns allow you to enter an adjustment and a descriptive.. To enter an adjustment and a descriptive code at ericbank.com is a copy editor and fact-checker with in... After holding it for more than one year creates long-term capital gains and thus lower tax liability for than... 02/04/04, 02/04/2004, 2/2/04, etc in next column, if you sold your 100 shares of tech... Enter an adjustment and a descriptive code transactions on Form 8949 ( with box C or F checked ),! Receives compensation can sell at any loss cancel each other out | Developed by SBA is typically price... Shares ) in this table wash sale calculator excel from partnerships from which Investopedia receives compensation ' or '... Xls ( Excel 97 - 2004 ) format or the newer XLSX format Excel template for the wash-sale rule 61...: //www.tdameritrade.com/welcome1.html, file Schedule-D from several accounts Washems! however, you 'll a... Decimal points in any of the loss you try to take as a comma delimited file otherwise as... Reports are no longer being automatically included at wash sale and enter the $ 500 adjustment in... Trade history from online brokerage in a later tax year those transactions triggering a tax Unrealized situation another...
Jamaica Sunday Gleaner Death Column, Robocop Toxic Waste Gif, Why Did Paulina Bucka Leave Whas, Max Gadson Comedian, Arthur Hill High School Closing, Articles W