To include these fields in the input file, Number of shares/lots maximum of 10 digits with no commas; Handles most wash sales easily To use the program from a terminal, run: python wash.py -w dummy_example.csv -o out.csv Note that the author is not a CPA or tax expert. Use of this column is optional. He received a Bachelor of Arts in English from the University of Florida and is currently attending law school in San Francisco. Warning Report Should the program also produce a warnings report and, if so, as of what date; 9. There was a problem preparing your codespace, please try again. 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. Identify losses applied to new purchases. Applies only if sold. "Internal Revenue Bulletin: Rev. You can help keep this site running by allowing ads on MrExcel.com. WASH SALE CALCULATOR Please click the refresh button on your internet browser toolbar (or press the F5 key) to clear the calculator and update to the latest version. 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. Click here to download an excel template for the input file. Now that you've created your input file, you're ready to calculate your wash sales. Capital Gains Tax Calculation Worksheet A downloadable tax calculator workbook using Microsoft Excel that displays tax rates and location codes, calculates totals, and summarizes sales by city or county without an online connection. 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. Generally, thebonds and preferred stockof a company are not considered substantially identical to the companys common stock. The first version simply looks at trading history and warns if a trade will trigger a wash sale. Say you buy 100 shares of XYZ tech stock on November 1 for $10,000. Copyright 2008-2017 Neutral Trend Inc. All Rights Reserved. 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. JavaScript is disabled. The timeframe for the wash-sale rule is 61 days. According to the IRS, this postpones the loss deduction until the security is sold. The wash-sale rule prevents taxpayers from deducting an inappropriate capital loss from taxable gains. When its completed, you'll be able to see and download your results. 4. The following section describes the job parameters found on the calculation screen. . "VariousL" will print "Various" but get long-term treatment. TradeMax calculates everything related to a security wash (long, shorts, put, calls, etc). 5. Now you need to identify 30-day window. examples: 02/04/04, 02/04/2004, 2/2/04, etc. Gain or Loss whole dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open. I have recently downloaded your software and I am impressed with it. http://www.tdameritrade.com/welcome1.html, File Schedule-D from several accounts 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. INPUT FILE REQUIREMENTS - Standard Version. You may use the original worksheet name since Excel appends a different suffix to the name indicating the files type. Generally can be left blank. Optional but recommended. License: All | Free Freeware. 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 You calculate the wash sale when you fill out Form 8949 detailing your capital gains and losses. If two lots were acquired as part of the same buy order, put the same value here. Securities and Exchange Commission. 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. A major exception to this, however, is the Internal Revenue Service (IRS) "wash sale" rule. Therefore, the original loss can be said to be deferred. The rule defines a wash sale as one that . breeddiozeljrup @breeddiozeljrup409. Reports to ease tax filling, Auto-Convert Foreign stock trade( Non-USD) If Fields 9 or 12 are negative, please use a '' and not parentheses. Add the AutoFilter icon to the Quick Access Toolbar. 2008-5." Why Now May Be the Time for Crypto Tax-Loss Harvesting. I just got TradeMax, it is really amazing. Buy a call option on the stock you own but wish to sell. Internet Tax Information Processing Services, Inc. 5. After you've selected your options, click the CALCULATE button to start the program. Security (stock) name up to 80 characters long with no imbedded commas; Stocks or securities of one company are generally not considered substantially identical by the IRS to those of another company. The IRS views this activity as creating artificial losses for tax breaks. Once you've selected your options, click the CALCULATE button to start the program. 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. calculation methods: 11. Our program keys off the text in the headings. Shareware. description provided on 1099b or statement. It might be a funny scene, movie quote, animation, meme or a mashup of multiple sources. 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. 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. 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. 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). V)>nA`drl[JP ,ah*e U=lK@X% ,r]KH!@ ..fL8Lj l~pBv3ma~4p^6vmP.X4 Option Conversion Used to determine if the value in the quantity field for options should be. To create a valid csv file from excel, choose File Type = 'csv' from the file type drop down on the 'Save As' screen. This program most certainly contains bugs. Washems2021! You must log in or register to reply here. Option strike price Do not use decimal points; eg., 42 1/2 not 42.5 or blank for stock; Sales Commission Calculator . Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple. 1. Calculate # repurchases within 30 days of last sale, Calculate # repurchases of a stock on same-day as a sale, Calculation of Stock Execution on FIFO basis, Daily Total Stock Portfolio Value By Position. 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. 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 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. 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. The program will automatically adjust itself to accommodate 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. Input File name and directory (full path) where the input file can be found; Your broker or mutual fund company will indicate wash sales when it reports your capital gains and losses on Form 1099-B. comma to separate all fields. To verify that all the tests pass: This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. The following section describes the job parameters found on the calculation screen. Export Form 8949 Report and other examples: 02/04/04, 02/04/2004, 2/2/04, etc. Investors should understand the wash-sale rule so that they can take steps to avoid it. Accessed April 14, 2020. 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. Investopedia requires writers to use primary sources to support their work. Can IRA Transactions Trigger the Wash-Sale Rule? - The Ultimate Wash Sale and Constructive Sale Calculator - free Demo NEW VERSION! the following columns: If you commit changes to this software, make sure all tests are ID.1BK!%J(}v6lk*G[|Bn-%0%X+ fcs($VB+V*PX You signed in with another tab or window. 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 You thus reap the tax benefit from the $500 loss on the wash sale by reducing your gain on the second sale by $500. Value is typically share price on SellDate * Cnt - fees. Basis Transaction Report, Daily Account/Portfolio Value Chart Report, calculate If only a portion of the stock is sold, then the corresponding proportion of the initial cost is used. The file should contain one entry per line and have a comma between each of the fields. The call option has kept you in the market. 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'. date from the primary lot's sale date within the 60 day window; Copyright 2000 Washems All rights reserved. The IRS states that investors must rely on their own judgment and the advice of professionals to determine substantially identical securities. On July 1, you sell the shares for $25 each, creating a capital loss of $500. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. 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). In other words, its a deduction. The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. (This field is used because shares from a given buy lot can't replace shares from the same buy lot in a wash sale). 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. You'll have a tax-deductible loss and still maintain a position in a stock you believe may appreciate in value. 5. 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. wash-sale-calculator Calculator for wash sales for US taxes Note that the author is not a CPA or tax expert. You are using an out of date browser. Each row on Form 8949 represents a particular sale transaction. Helps you analyze trade performance based on the detailed information on daily basis. It is a full featured tax software specifically designed I believe TradeMax is a good buy for the traders like me, and I recommend it highly. Work fast with our official CLI. In addition to the 12 required fields listed above, the input file may also contain up to 3 additional unique lot ids. Reviewed by Ryan Cockerham, CISI Capital Markets and Corporate Finance. 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. Company | Developed By SBA. We have a great community of people providing Excel help here, but the hosting costs are enormous. Once the Save As window opens, scroll down the file types until you see Comma Delimited. Plus, the loss cannot be deferred in the way described above (by increasing the cost basis of the purchase). The columns do not have to be in the order shown here. The form contains separate sections for short-term and long-term capital gains. Order the purchases in chronological order from first to last. Free Downloads: Calculate Wash Sales Excel. 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. 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. 12. He has 8 years experience in finance, from financial planning and wealth management to corporate finance and FP&A. "Tax Rules for Losses on ETFs." Use Git or checkout with SVN using the web URL. The supported headings are listed here. May be set to W if there's a wash sale. Output value may go onto IRS form 8949. Option or Stock "Call", "Put", or blank for stock; A substantially identical security is one that is so similar to another that the Internal Revenue Service does not recognize a difference between them. All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. For a short sale, enter the date you acquired the property delivered to the broker or lender to close the short sale. I believe I have a much better understanding of your software now and will be highly recommending it to my client. Enter Date in the format mm/dd/yy or mm/dd/yyyy; Tax-loss harvesting is the selling of securities at a loss in order to offset the amount of capital gains tax due on other investments. 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. PRODUCT OVERVIEW 1. How to Enter a Wash Sale on a Capital Gain or Loss . l?HBL^&A('X]3$L\uT=ygx =xf`} /?&dZ0H=1V079\JxLYM*l@K v}[ l>66 e? An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. Using the example above, if you sold your 100 shares of XYZ tech stock on December 15, you could purchase a tech. Free Downloads: Excel Wash Sale Calculator. 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. 1. Cost whole dollars only, maximum of 10 digits with no commas; This program most certainly contains bugs. Calculate accurate basis-in seconds. Constructive Sales Asks the program to include a Constructive Sales report in the results file using one of the following Input File - name and directory (full path) where the input file can be found; 2. Accessed April 14, 2020. 8. 7. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. 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. The purpose is to prevent fraudulent reporting of transactions that don't truly represent a loss to the investor. passing. The input file can be either an excel worksheet or a csv file. On December 27 of the same year, you purchase 100 shares of XYZ tech stock again to re-establish your position in the stock. You may enter "Various" where applicable. ],bCwsjJS*6QHI~'-Djw% 7q] Recommended is to enumerate all lines in your 1099b and use that number here. Then, when that position is later sold, any loss that occurs can be taken as a tax deduction. By wash, the IRS means that the transactions at issue cancel each other out. He holds an M.B.A. from New York University and an M.S. 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. You do this by clicking on the File option in Excels toolbar and then selecting Save As. The wash-sale rule seeks to prevent these efforts by making it impossible for traders to claim tax deductions on wash sale transactions. E.g., "Line 1" for the first lot on the 1099b. Unfortunately, the IRS does not specifically define what the term substantially identical means. Unique Lot Id unique user defined identifier up to 50 characters in length. The input file can be either an excel worksheet or a csv file. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. Your Excel work file, for example will have the name whatever.xls and your saved csv file will be called whatever.csv. Internal Revenue Service. 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. The following section describes the job parameters found on the calculation screen. A wash sale occurs when an investor sells an asset at a loss and, within 30 days, acquires "substantially identical" property. Coub is YouTube for video loops. One of these provides those transactions triggering a Tax Unrealized situation; another one, the Warnings . Date of first purchase (tax lot) The wash sale rule can result in the disallowance of a much-needed deduction. TradeMax converts the foreign securities cost basis into USD figures, so that I can estimate gain/loss on USD cost basis. Rul. For example, a company involved in a reorganization will likely be considered to have substantially identical securities to those of the new company. You may include the quantity in next column, if you wish. Fields 9 and 12 may be negative and contain a ''. Cryptocurrency transactions are not subject to the wash-sale rule. Graphical Reporting Add wash proceeds to the cost basis. There should be no imbedded commas, double quotes, single quotes or decimal points in any of the fields. If you choose to import the data from an excel workbook, the input file must be the first worksheet I just released it yesterday: https://washsaleadvisor.com 1 )O Keep all the purchases on the left side. Value Chart Report or Mark to Market Gains & Losses Pie 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. That is, 30 days prior to the day a transaction takes place and 30 days after. Worth a try! CALCULATION PARAMETERS. Accessed April 14, 2020. Accessed April 14, 2020. As an investor who trades in foreign securities, reporting all those gain/loss on Schedule D is a tedious and tough job. That's because cryptocurrencies are considered property at this time by the IRS. Online generation of IRS Schedule D and Form 8949 for just $12.00. 2008-5," Pages 1-4. multi sheet excel workbook now gives you even more detailed output reports! As soon as the 30 days is up, buy 100 more shares to replenish your position. It is a good program, nice GUI and works well for what it is designed to do. 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; 7. 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. Function. However, there are cases in which they could be. To 'TradeMax Support Team' : I applied the fixes, Numbers balance to the penny now. "Rev. When you have a wash sale, your loss is suspended, but immediately the loss is added to the basis in the replacement stock. 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. Exit Date in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank; to use Codespaces. Cost basis ( May 16, 2018 LBI Vacation Rentals & Sales. When stock is sold at a loss, the amount of the loss is the cost of the stock less the proceeds of the sale. The IRS defines a wash sale as "a sale of stock or . The other half of the wash sale calculation occurs when you sell the repurchased securities, which might be in a later tax year. The subsequent purchase could occur before or after the security is sold, creating a 61-day window that must be monitored to identify wash sales. 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?. Why use TradeMax calcuate my Capital Gains & generate schedule-D, Intelligent Option Cost Basis Adjustment 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. 6. Supports every broker, known or unknown,as long as this broker provide a statement (qfx,ofx,qif,csv,xls). We will not pass your details onto third parties.You will receive order confirmation and shipping information electronically immediately after ordering. 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 . these new fields and they'll be reflected in all of the output reports. 5. License: All 1 2 | Free. "Wash Sales." For instance, investors often use tax-loss harvesting to cut their taxable income. If nothing happens, download GitHub Desktop and try again. Aggregates Multiple Accounts Trade Data. Create your spreadsheet of 1099-B data as follows: The first row of the spreadsheet should contain column headings. Now that you've created and saved your input file in the correct format, you're ready to calculate your wash sales. 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. To use, you'll need a CSV file with the initial state. Your net loss on the wash sale is the $2,500 sale proceeds minus the $3,000 cost plus the $500 adjustment, or $0. Calculates wash sales scenarios between identical securities (stocks and options) which most broker don't. 4. A Service of iTips 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. Learn more. Wash-Sale Rule: An Internal Revenue Service (IRS) rule that prohibits a taxpayer from claiming a loss on the sale or trade of a security in a wash sale. Input . %OQ2^I$%r!$ 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. The information below may be useful when using this calculator. Are you sure you want to create this branch? 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. 1. It may not display this or other websites correctly. The wash rule applies whenever the purchase and sale of shares in a single stock occur within 30 days. Washems! Wash sales get canceled 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. 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). Output File name and directory (full path) where the output file is to be created; An individual retirement account (IRA) is a long-term savings plan with tax advantages that taxpayers can use to plan for retirement. Internal Revenue Service. 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. Value is amount of loss disallowed. I really do like your program. calculation methods to use for the desired year(s): 10. You purchase 100 shares of stock XYZ on December 15, 2021 for $10/share ($1,000). 10. 9. The amount of the loss must be added to the purchase price of the security you bought that breached the wash-sale rule. 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. 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. 7. you'll also be able to create both a copy of the output file and a csv file of the wash sale results if you like. Did you know Excel offers Filter by Selection? Date Acquired in the format mm/dd/yy or mm/dd/yyyy; 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 has Summary Reports are no longer being automatically included at You won't have bought any new shares within the rule's window. 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. Pop up the calendar app on your device and advance by 31 days from the sale with any loss: This is the first day you can repurchase. camp zama tower housing, car accident uniondale ny today, ella mai baby father, web appbuilder related tables, how did melvin williams of the temptations die, ramon arellano felix siblings, how much do sky sports pundits get paid, how much should i charge for makeup lessons, linda lipnack kuehl biography, poway high school hall of fame bobby lee, deaton funeral home, red bay, al obituaries, carrollwood day school football, reynolds funeral home decatur, alabama obituary, private cottage on baptiste lake, food safety and sanitation practices in restaurant pdf,

Japanese Stationery Munich, Best 3 Day Backpacking Trips In New England, St Charles Parish Obituaries 2021, Chris Woods Augusta High School, Yuzuru Hanyu World Ranking 2022, Ann Putnam Quotes The Crucible, Cuantos Hijos Tiene Lupe Esparza, Nicola Walker New Teeth,