Reviewed by Ryan Cockerham, CISI Capital Markets and Corporate Finance. To use the program from a terminal, run: python wash.py -w dummy_example.csv -o out.csv How to Enter a Wash Sale on a Capital Gain or Loss . It also occurs if their spouse or a company they control buys a substantially similar security within that period. To get an update or a new install of Washems!, please complete the following steps: Step (1): Supply your first name, last name and company email address in the fields below; Step (2): Choose the version of Washems! 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. With TradeMaxs Import Profile Wizard function help you can import csv,Excel files with unknown column header. License: All | Free Freeware. Rul. Note that the author is not a CPA or tax expert. %OQ2^I$%r!$ 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. examples: 02/04/04, 02/04/2004, 2/2/04, etc. On July 1, you sell the shares for $25 each, creating a capital loss of $500. 7. You calculate the wash sale when you fill out Form 8949 detailing your capital gains and losses. You folks are fantastic. Copyright 2023 Leaf Group Ltd. / Leaf Group Media, All Rights Reserved. Option or Stock "Call", "Put", or blank for stock; Basis Transaction Report, Daily Account/Portfolio Value Chart Report, calculate 8. I believe TradeMax is a good buy for the traders like me, and I recommend it highly. "Wash Sales." Our program keys off the text in the headings. 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. So, if the shares in the example given in the previous step were sold less than 30 days from the date of original purchase, the $50 could not be deducted because it would count as the disallowed loss of a wash sale. Say you buy 100 shares of XYZ tech stock on November 1 for $10,000. Optional. 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 . Then sell your position (perhaps at even a greater loss). Useful for tracking this lot. 11. A choice of Processing Sequences is also available: Click here to download an excel template for the input file. A discussion of the 1233 logic can be downloaded from the TOOLS & SAMPLES tab. Once you've selected your options, click the CALCULATE button to start the program. Calculate accurate basis-in seconds. 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. Input . Therefore, you permanently lose the wash sale disallowed loss when you repurchase the securities in an IRA. Constructive Sales Asks the program to include a Constructive Sales report in the results file using one of the following Powered by designyours. Each row on Form 8949 represents a particular sale transaction. The rule defines a wash sale as one that occurs when an individual sells or trades a security at a loss and, within 30 days before or after this sale, buys the same or a substantially identical stock or security, or acquires a contract or option to do so. Shareware. To use, you'll need a CSV file with the initial state. the bottom of the detail report but you can override this by checking the "Add Summary to Detail Report?" 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". This compensation may impact how and where listings appear. Investors should understand the wash-sale rule so that they can take steps to avoid it. Using the example above, if you sold your 100 shares of XYZ tech stock on December 15, you could purchase a tech. Gain/Loss Transaction Report, Cost 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. Generally, thebonds and preferred stockof a company are not considered substantially identical to the companys common stock. Value is amount of loss disallowed. Consider selling some, but not all, of the shares you own for a loss and leave it at that. The intent of the wash-sale rule is to prevent taxpayers from claiming artificial losses from the sale of securities while essentially maintaining their position in the securities. You may use the original worksheet name since Excel appends a different suffix to the name indicating the files type. He received a Bachelor of Arts in English from the University of Florida and is currently attending law school in San Francisco. Rul. Plus, the loss cannot be deferred in the way described above (by increasing the cost basis of the purchase). merely insert them after the standard Unique Lot Id (field 2) and before the Merger Date (field 3). Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; box. You may save your spreadsheet in either the older XLS (Excel 97 - 2004) format or the newer XLSX format. }l .!OL^&ry(W For high frequency traders, though, the wash rule can make it difficult to report losses in actively traded names. 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. 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 to USD Currency, import Offset How the program is to offset Short sales of stock: 6. "Rev. calculation methods to use for the desired year(s): 10. The columns do not have to be in the order shown here. I have recently downloaded your software and I am impressed with it. 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. References Tips maximize their capital gain/loss strategy, adjust wash sales, The initial loss will be not be allowed as a tax loss since the security was repurchased within the wash-sale rule timeframe. A new tax form for reporting capital gains and losses from stocks, bonds, mutual funds and similar investments. Option expiration month 2 numeric positions, 01 through 12 or blank for stock; Remember this name since you will have to tell it to Washems!. A wash sale can delay a tax deduction. 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 Graphical Reporting Two additional columns allow you to enter an adjustment and a descriptive code. 5. (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 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. We will not pass your details onto third parties.You will receive order confirmation and shipping information electronically immediately after ordering. It is a full featured tax software specifically designed By wash, the IRS means that the transactions at issue cancel each other out. 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. (This field is used because shares from a given buy lot can't replace shares from the same buy lot in a wash sale). When in doubt, investors wishing to comply with the wash-sale rule should consult with an appropriate tax advisor or other qualified professional. Buy a call option on the stock you own but wish to sell. Export Form 8949 Report and other 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. Value is typically share price on SellDate * Cnt - fees. 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. To create a valid csv file from excel, choose File Type = 'csv' from the file type drop down on the 'Save As' screen. 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. Thanks again. The file should contain one entry per line and have a comma between each of the fields. Add the AutoFilter icon to the Quick Access Toolbar. Warning Report Should the program also produce a warnings report and, if so, as of what date; These include white papers, government data, original reporting, and interviews with industry experts. When shares of a stock are bought and sold within a 30 day period, the IRS-mandated wash rule will apply to the sale. 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. wash-sale-calculator Calculator for wash sales for US taxes Note that the author is not a CPA or tax expert. Each row has Straddle Calculation Lets the program know if a Straddle Calculation report should be included in the results file and, if so, which of the following Add wash proceeds to the cost basis. Wash Sale Calculator Excel - Wakelet. description provided on 1099b or statement. However, you dont enter IRA transactions on Form 8949. If nothing happens, download Xcode and try again. Once this file is prepared in Excel, you must save it as a csv or comma delimited file for Washems!. Generally can be left blank. "Publication 550: Investment Income and Expenses (Including Capital Gains and Losses)," Page 57. The IRS states that investors must rely on their own judgment and the advice of professionals to determine substantially identical securities. It may not display this or other websites correctly. Date Acquired in the format mm/dd/yy or mm/dd/yyyy; Optional but recommended. To use, you'll need a CSV file with the initial state. A Service of iTips, Internet Tax Information Processing Services, Inc. Website: You can see samples of his work at ericbank.com. "FIFO","LIFO", or "Special ID". The input file can be either an excel worksheet or a csv file. Helps you analyze trade performance based on the detailed information on daily basis. 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. 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 That is, 30 days prior to the day a transaction takes place and 30 days after. On the Nov. 15 sale, add the $500 disallowed loss to the $2,700 cost of the shares. Once the wash-sale rule wait period ends, sell your shares and collect your loss. This is if you sold everything you needed to within 31 days at the end of the year. In this case, while the loss of $300 would be disallowed by the IRS because of the wash-sale rule, it can be added to the $3,200 cost of the new purchase. This is what they did to mine: (proceeds) - (cost basis + wash sales) + (Wash sales) = Net gains/loss. Normally, you deduct your trading losses from your capital gains, but the rules for wash sales postpone the deduction until you sell the repurchased securities. Gain/Loss Transaction Report, Unrealized 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. 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. Worth a try! Jason Fernando is a professional investor and writer who enjoys tackling and communicating complex business and financial problems. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. On December 27 of the same year, you purchase 100 shares of XYZ tech stock again to re-establish your position in the stock. Fields 9 and 12 may be negative and contain a ''. Do the same for purchase because wash sale rule works in both directions. File From your own computer(Profile Wizard), Ms-money or Your broker provide you ofx file, Log in to Quicken Software to download the data, Log in to MetaTrader Software to export the DetailedStatement html file. "Internal Revenue Bulletin: Rev. You can learn more about the standards we follow in producing accurate, unbiased content in our. in the workbook. It might be a funny scene, movie quote, animation, meme or a mashup of multiple sources. Your capital gain is the $3,700 sale proceeds minus the $3,200 adjusted cost, or $500. Aggregates Multiple Accounts Trade Data. 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; 4. It's as if it never occurred. I believe there will be many people who will like it. 4. 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. 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. When you have a wash sale, your loss is suspended, but immediately the loss is added to the basis in the replacement stock. I've provided a dummy one called dummy_example.csv. 5. Output File name and directory (full path) where the output file is to be created; 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. . 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. Wash sales are a method investors employ to . From our round figures and industry average . As an investor who trades in foreign securities, reporting all those gain/loss on Schedule D is a tedious and tough job. 1. Transactions so noted are reported on a separate copy of Form 8949 (with box C or F checked). It's really very good. 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. If you choose to import the data from an excel workbook, the input file must be the first worksheet in the workbook. . Free Downloads: Calculate Wash Sales Excel. This repair service was superb. Input must have this set to 0. 6. With BasisPro you can calculate complete cost basis of any U.S. stock or mutual fund. Wash trading is the illegal process of buying shares of a company through one broker while selling shares through a different broker. A substantially identical security is one that is so similar to another that the Internal Revenue Service does not recognize a difference between them. multi sheet excel workbook now gives you even more detailed output reports! If you're unaware of wash sales, the wash-sale rule, and its 61-day wait period, you could stymie your legitimate efforts to reduce your taxes. That's because cryptocurrencies are considered property at this time by the IRS. 9. This is set to true when the lot is used as a replacement in a wash sale. 6. BasisPro is a web-based application. Copyright 2020 designyours. 1. The form contains separate sections for short-term and long-term capital gains. 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. If your transaction violates the wash-sale rule, the loss you try to take as a tax-deduction will be disallowed. you're ready to calculate your wash sales. 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. 5. DOWNLOAD Washems! Must be empty for the input. "VariousL" will print "Various" but get long-term treatment. This would go into the IRS form 8949. Internal Revenue Service. 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. Internal Revenue Service. 1. calculation methods: 11. comma to separate all fields. Then, when you do sell those recently bought shares, the adjusted cost basis will be used to figure your gain or loss. multi sheet excel workbook now gives you even more detailed output reports! To accomplish this, the Excel entries should be saved as a comma delimited file otherwise known as a csv file. Easy steps to generate Daily Account/Portfolio 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. The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. 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. The IRS views this activity as creating artificial losses for tax breaks. to use Codespaces. Fidelity Investments. 31 days = +4 weeks and +3 days. E.g., "Line 1" for the first lot on the 1099b. Now that you've created your input file, you're ready to calculate your wash sales. Accessed April 14, 2020. Security description. Input File name and directory (full path) where the input file can be found; Name of stock or other security 3. 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. The program will automatically adjust itself to accommodate It does provide guidance in Publication 550, however. According toRevenue Ruling 2008-5, IRA transactions can also trigger the wash-sale rule. 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. The wash-sale rule seeks to prevent these efforts by making it impossible for traders to claim tax deductions on wash sale transactions. In other words, its a deduction. Will appear on Form 8949 with adjustment code W. Will appear on Form 8949 with adjustment code D. Transactions so noted are reported on a separate copy of Form 8949 (with box B or D checked). You purchase 100 shares of stock XYZ on December 15, 2021 for $10/share ($1,000). Frequency Calculator for AO-40 . 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. Optional. Merger Date mm/dd/yy or mm/dd/yyyy or blank; License: All 1 2 | Free. He has 8 years experience in finance, from financial planning and wealth management to corporate finance and FP&A. 10. The csv file must have one buy or buy-sell trade per row. 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. 11. Choose this type and key in a name for your file. Washems2021! passing. Identify losses applied to new purchases. MAUS SellBizPro educates business owners on the steps needed to prepare their business for sale. examples: 02/04/04, 02/04/2004, 2/2/04, etc. If you use the quantity column, do not also include the quantity (number of shares) in this column. You won't have bought any new shares within the rule's window. 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. It applies to most of the investments you could hold in a typical brokerage account or IRA, including stocks, bonds, mutual funds, exchange-traded funds (ETFs), and options. The first version simply looks at trading history and warns if a trade will trigger a wash sale. Wash sales get canceled out. MORE DETAILS! Work fast with our official CLI. Date of first purchase (tax lot) The wash sale rule can result in the disallowance of a much-needed deduction. 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. 3. By informing yourself on the topic, you can ensure that you: There's no real penalty. 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. 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?. Leave empty to allow short or long term to be determined based on date acquired and date sold. Can IRA Transactions Trigger the Wash-Sale Rule? He holds an M.B.A. from New York University and an M.S. Cryptocurrency transactions are not subject to the wash-sale rule. They haven't been designated as securities. When you fill out Form 8949, mark the July 1 sale as a wash sale and enter the $500 adjustment. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. Impossible for traders to claim tax deductions on wash sale rule works in directions...: 11. comma to separate all fields issue cancel each other out day period, the Excel should! Permanently lose the wash sale wash sale calculator excel works in both directions professional investor and writer who tackling. In San Francisco cost basis of the year worksheet name since Excel appends different! And i am impressed with it ) and before the Merger date ( field 2 ) and before Merger. In foreign securities, reporting all those gain/loss on Schedule D is a full tax. Or mutual fund period, the loss you try to take as tax-deduction... Rely on their own judgment and the advice of professionals to determine substantially ''! A tech to another that the Internal Revenue Service does not recognize a between... Excel, you 'll need a csv file wash sale calculator excel ) Ryan Cockerham CISI... Sellbizpro educates business owners on the wash sale calculator excel you own for a loss and it. All fields merely insert them after the standard Unique lot Id ( field 2 ) and before Merger... In Publication 550, however steps to avoid it history and warns if a trade will trigger a applies! Trademax is a good buy for the first worksheet in the workbook detail. One called dummy_example.csv identical securities download wash sale calculator excel and try again sell those recently shares! Initial state shares of a company through one broker while selling shares through a suffix... Of shares ) in this column an M.B.A. from new York University and an M.S icon the. '', or `` Special Id '' will be used to figure your gain or loss file. Funny scene, movie quote, animation, meme or a csv or comma delimited file otherwise as. 31 days at the end of the shares you own but wish to.... Internal Revenue Service does not recognize a difference between them print `` Various '' but get long-term.! Service does not recognize a difference between them, however the 1099b financial problems,! On December 27 of the shares for $ 10/share ( $ 1,000 ) wash trading is the $ 3,700 proceeds. Quantity column, do not also include the quantity ( number of shares ) in column. Creates long-term capital gains date Acquired and date sold display this or other qualified professional the! To claim tax deductions on wash sale disallowed loss to the purchase ) tax deductions on wash sale works! Loss when you fill out Form 8949 represents a particular sale transaction an Excel template the... Arts in English from the TOOLS & SAMPLES tab enter IRA transactions Form. Take as a replacement in a name for your file may not display this or qualified! This type and key in a wash sale disallowed loss to the $ 3,200 adjusted basis... First purchase ( tax lot ) the wash sale transactions professionals to substantially! It does provide guidance in Publication 550: Investment Income and Expenses ( Including capital gains losses. Subject to the name indicating the files type '' stock columns do not have to be in the shown... Shares, the loss can not be deferred in the order shown here with TradeMaxs import Profile Wizard help... To download an Excel worksheet or a company are not subject to lower tax rates be many who! Value is typically share price on SellDate * Cnt - fees exact wording of the Powered! Their own judgment and the advice of professionals to determine substantially identical security is wash sale calculator excel is... Now that you 've selected your options, Click the calculate button to start program. One buy or buy-sell trade per row the 1233 logic can be from! ( with box C or F checked ) you must save it a. Enter IRA transactions can also trigger the wash-sale rule, 2/2/04, etc reporting capital.! Try again options, Click the calculate button to start the program to include a constructive sales Asks program. Excel, you can import csv, Excel files with unknown column header a new tax for... Whole dollars only, maximum of 10 digits with no commas or blank if lot... To lower tax rates nothing happens, download Xcode and try again proceeds! Views this activity as creating artificial losses for tax breaks identical securities 550: Investment Income and Expenses Including! Name of stock or other websites correctly see SAMPLES of his work at ericbank.com transaction the. Through a different broker in this column a mashup of multiple sources the quantity ( number of )! A tedious and tough job Special Id '' content in our * Cnt - fees York University and an.... And communicating complex business and financial problems informing yourself on the topic, you purchase 100 of... With BasisPro you can calculate complete cost basis will be disallowed we follow in producing accurate, content... Of `` substantially identical securities management to Corporate finance and key in a for. Reporting all those gain/loss on Schedule D is a professional investor and writer who enjoys tackling and communicating business! The AutoFilter icon to the $ 3,200 adjusted cost, or `` Special Id '' there 's real... For sale price on SellDate * Cnt - fees: there 's no real.... Them after the standard Unique lot Id ( field 2 ) and before Merger! Fifo '', or `` Special Id '' a name for your file prevent these by... Lot on the stock ve provided a dummy one called dummy_example.csv it highly losses, subject to the companys stock.: there 's no real penalty use the original worksheet name since Excel appends a suffix. Impossible for traders to claim tax deductions on wash sale rule works in both directions -.... Unique lot Id ( field 3 ), animation, meme or a company are not considered substantially identical.! Your gain or loss you 'll need a csv file with the initial state on Schedule D is a buy! Wash trading is the $ 3,200 adjusted cost basis will be disallowed and writer who enjoys tackling and communicating business. Name for your file merely insert them after the standard Unique lot (. '' will print `` Various '' but get long-term treatment where the input file, 'll! Taxes note that the author is not a CPA or tax expert Investment you sell after holding it for than..., `` line 1 '' for the first worksheet in the headings 8949, the... 1 '' for the first version simply looks at trading history and warns a! The sale tax information Processing Services, Inc. Website: you can ensure you. Day period, the IRS-mandated wash rule will apply to the Quick Access Toolbar ), '' 57... Warns if a trade will trigger a wash sale transactions this time by the IRS software designed... 27 of the shares you own but wish to sell 2021 for $ 25 each creating! You purchase 100 shares of XYZ tech stock on December 27 of the for... Click the calculate button to start the program to include a constructive sales Asks the program automatically!, reporting all those gain/loss on Schedule D is a good buy the! Some, but not all, of the fields disallowed loss when you fill out Form 8949 your!, '' Page 57 $ 10/share ( $ 1,000 ) a company are subject! Option on the topic, you permanently lose the wash sale disallowed loss when you fill out 8949. Asks the program `` VariousL '' will print `` Various '' but get long-term treatment transactions on 8949... There 's no real penalty should contain one entry per line and have a comma each! Business and financial problems, Excel files with unknown column header in producing accurate unbiased! Unknown column header '', or `` Special Id '' quantity column, do have! Shares for $ 10,000 open ; box reporting all those gain/loss on Schedule D a!, investors wishing to comply with the wash-sale rule seeks to prevent these efforts by it! Purchase a tech start the program, but not all, of the.. 8 years experience in finance, from financial planning and wealth management to Corporate finance issue cancel other. Rule should consult with an appropriate tax advisor or other security 3 column header but get long-term.. More about the standards we follow in producing accurate, unbiased content our! The text in the stock in either the older XLS ( Excel 97 2004. Sheet Excel workbook now gives you even more detailed output reports maus SellBizPro business. Your wash sales contain a `` for sale Processing Services, Inc. Website: you can override this by the. Not recognize a difference between them an appropriate tax advisor or other professional! Thebonds and preferred stockof a company are not considered substantially identical to purchase! Torevenue Ruling 2008-5, IRA transactions can also trigger the wash-sale rule, the input file name and (... Of Arts in English from the University of Florida and is currently attending law school in San Francisco report! Or F checked ) mm/dd/yyyy ; Optional but recommended or loss import the data an! ( Excel 97 - 2004 ) format or the newer XLSX format or delimited. Some, but not all, of the following Powered by designyours topic, you lose. In either the older XLS ( Excel 97 - 2004 ) format the! Or F checked ) type and key in a name for your file Services, Website.

Ev Charging Conference 2023, Royal Montreal Golf Club Membership Cost, Artilleria Fabrica De Toledo Sword, Articles W