Copyright 2023 Leaf Group Ltd. / Leaf Group Media, All Rights Reserved. INPUT FILE REQUIREMENTS - Standard Version. E.g., "Line 1" for the first lot on the 1099b. I believe TradeMax is a good buy for the traders like me, and I recommend it highly. Must be empty for the input. 6. Security description. 11. The information below may be useful when using this calculator. sign in In addition to the 12 required fields listed above, the input file may also contain up to 3 additional unique lot ids. Option Conversion Used to determine if the value in the quantity field for options should be. Summary Report Breaks Controls the summary totals to be included in the output file. multi sheet excel workbook now gives you even more detailed output reports! "Wash Sales." Ordinarily, losses on stocks can be used to offset gains and thus lower tax liability. To use the program from a terminal, run: python wash.py -w dummy_example.csv -o out.csv 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. Securities and Exchange Commission. Option strike price Do not use decimal points; eg., 42 1/2 not 42.5 or blank for stock; This simply involves selling securities at a loss to offset gains elsewhere. stock symbol. date from the primary lot's sale date within the 60 day window; Copyright 2000 Washems All rights reserved. position in the subject security is obtained prior to the end of the 30 day wash sale period specified by the As Of date; 8. The purpose is to prevent fraudulent reporting of transactions that don't truly represent a loss to the investor. Number of shares/lots maximum of 10 digits with no commas; 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. You can help keep this site running by allowing ads on MrExcel.com. Suppose that in February, you buy 100 shares of XYZ Corp. common stock for $30 each, or $3,000 in total. Wash trading is the illegal process of buying shares of a company through one broker while selling shares through a different broker. A wash sale can delay a tax deduction. In other words, its a deduction. Accessed April 14, 2020. To accomplish this, the Excel entries should be saved as a comma delimited file otherwise known as a csv file. This program most certainly contains bugs. Date Sold in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank (spaces); Warning Report Asks the program to include a report in the results file showing all realized losses that would be lost if a Option strike price Do not use decimal points; eg., 42 1/2 not 42.5 or blank for stock; 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. If the loss is disallowed by the IRS because of the wash-sale rule, the taxpayer has to add the loss to the cost of the new stock, which becomes the cost basis for the new stock. Strategic Investing in the Home Stretch of 2022, How to Avoid Violating Wash Sale Rules When Realizing Tax Losses, Wash Sale: Definition, How It Works, and Purpose, Short-Term Capital Gains: Definition, Calculation, and Rates, Substantially Identical Security: Definition and Wash Sale Rules, Wash Trading: What It Is and How It Works, With Examples, Individual Retirement Account (IRA): What It Is, 4 Types, Tax-Loss Harvesting: How It Works, Example, and Pitfalls to Avoid, IRA transactions can also trigger the wash-sale rule, Publication 550: Investment Income and Expenses. This is the first day you can sell at any loss. l?HBL^&A('X]3$L\uT=ygx =xf`} /?&dZ0H=1V079\JxLYM*l@K v}[ l>66 e? These features would be very helpful. I believe I have a much better understanding of your software now and will be highly recommending it to my client. Your Excel work file, for example will have the name whatever.xls and your saved csv file will be called whatever.csv. calculation methods to use for the desired year(s): 10. 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. }l .!OL^&ry(W 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. We will not pass your details onto third parties.You will receive order confirmation and shipping information electronically immediately after ordering. A Service of iTips You calculate the wash sale when you fill out Form 8949 detailing your capital gains and losses. This is set to true when the lot is used as a replacement in a wash sale. You are using an out of date browser. If sold, proceeds. Gain or Loss whole dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open. Reviewed by Ryan Cockerham, CISI Capital Markets and Corporate Finance. 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. If your transaction violates the wash-sale rule, the loss you try to take as a tax-deduction will be disallowed. By informing yourself on the topic, you can ensure that you: There's no real penalty. Once its completed, you'll be able to not only see and download your results, Copyright 2020 designyours. 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. Keep all the sales transactions on the right side. It does provide guidance in Publication 550, however. It's as if it never occurred. 7. References Tips 1. 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. After you've selected your options, click the CALCULATE button to start the program. The brokers who support import type OFX server, can get import trade history from online brokerage in a fast and easy manner. The IRS views this activity as creating artificial losses for tax breaks. Unused by this program, but carried through for your records, Acquisition price or basis. Add wash proceeds to the cost basis. 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. For instance, if you bought 200 shares initially, sell only 100. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple. Identify losses applied to new purchases. Internal Revenue Service. Jason Fernando is a professional investor and writer who enjoys tackling and communicating complex business and financial problems. This is if you sold everything you needed to within 31 days at the end of the year. 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. 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. 5. 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. 2008-5," Pages 1-4. Buy a call option on the stock you own but wish to sell. Each row on Form 8949 represents a particular sale transaction. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. Click here to download an excel template for the input file. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Z G~grv, ~ZZ8de|Oc:'q?JCg 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. I've provided a dummy one called dummy_example.csv. . Say you buy 100 shares of XYZ tech stock on November 1 for $10,000. Handles most wash sales easily Easy steps to generate Daily Account/Portfolio Optional. When its completed, you'll be able to see and download your results. Warning Report Should the program also produce a warnings report and, if so, as of what date; Non-USD transactions and foreign account, https://www.americancentury.com/index.jsp, http://www.ameriprise.com/default-home.asp, https://www.usaa.com/inet/ent_logon/Logon. That's because cryptocurrencies are considered property at this time by the IRS. no limitation on the size of the output files, a new Tax Unrealized Report and much more! "Internal Revenue Bulletin: Rev. 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. I just released it yesterday: https://washsaleadvisor.com 1 Enter Date in the format mm/dd/yy or mm/dd/yyyy; License: All | Free Freeware. On July 1, you sell the shares for $25 each, creating a capital loss of $500. Receive tax deductions that you've planned for instead of having them disallowed, Can work with the rule's waiting period and important end-of-year tax dates, Buy appropriate, related securities (after selling your original position) to still get the appreciation you're expecting, Avoid repercussions of breaking the rule while staying in the market, Can know when the rule has no impact on your transactions. Internal Revenue Service. Use Git or checkout with SVN using the web URL. Offset How the program is to offset Short sales of stock: 6. The initial loss will be not be allowed as a tax loss since the security was repurchased within the wash-sale rule timeframe. If you repurchase the securities in an individual retirement account, you permanently lose the deduction. You may use the original worksheet name since Excel appends a different suffix to the name indicating the files type. prepare their Schedule D,etc. The deduction you normally would take from a capital loss becomes a disallowed loss in a wash sale, which is marked with a code of W. You add the disallowed loss as an adjustment to the wash sale, thereby giving a total loss of zero. The wash-sale rule prevents taxpayers from deducting an inappropriate capital loss from taxable gains. Applies only if sold. It's really very good. Q:My broker provides cost basis report with wash sale adjustment, why do I still need Trademax? Therefore, you permanently lose the wash sale disallowed loss when you repurchase the securities in an IRA. you're ready to calculate your wash sales. To use, you'll need a CSV file with the initial state. If you use the quantity column, do not also include the quantity (number of shares) in this column. to use Codespaces. On the Nov. 15 sale, add the $500 disallowed loss to the $2,700 cost of the shares. With BasisPro you can calculate complete cost basis of any U.S. stock or mutual fund. He has 8 years experience in finance, from financial planning and wealth management to corporate finance and FP&A. MAUS SellBizPro educates business owners on the steps needed to prepare their business for sale. 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 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. "2019 Instructions for Form 8949." A major exception to this, however, is the Internal Revenue Service (IRS) "wash sale" rule. Choose this type and key in a name for your file. Assuming that the entire $50 loss in the initial example is a wash sale, the remaining 50 shares, which were originally purchased at $2, would now have a total cost basis of $150 (2x50 + 50). The columns do not have to be in the order shown here. Will appear on Form 8949 with adjustment code W. Will appear on Form 8949 with adjustment code D. Transactions so noted are reported on a separate copy of Form 8949 (with box B or D checked). This compensation may impact how and where listings appear. for active investors or traders to manage their trade data Calculates wash sales scenarios between identical securities (stocks and options) which most broker don't. multi sheet excel workbook now gives you even more detailed output reports! 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. It is a full featured tax software specifically designed I've provided a dummy one called dummy_example.csv. DOWNLOAD Washems! Frequency Calculator for AO-40 . python wash.py -w dummy_example.csv -o out.csv. As soon as the 30 days is up, buy 100 more shares to replenish your position. TradeMax converts the foreign securities cost basis into USD figures, so that I can estimate gain/loss on USD cost basis. Unique Lot Id (Optional) unique user defined identifier up to 50 characters in length. As an investor who trades in foreign securities, reporting all those gain/loss on Schedule D is a tedious and tough job. All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. %OQ2^I$%r!$ Our program keys off the text in the headings. Once you've selected your options, click the CALCULATE button to start the program. 5. Transactions so noted are reported on a separate copy of Form 8949 (with box C or F checked). 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. Processing Sequence Controls the sequence of offsetting lots: 12. http://www.tdameritrade.com/welcome1.html, File Schedule-D from several accounts 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 Internal Revenue Service extends the wash sale rule to securities that you sell in a regular account and repurchase in an IRA. Washems! There was a problem preparing your codespace, please try again. 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. Accessed April 14, 2020. For high frequency traders, though, the wash rule can make it difficult to report losses in actively traded names. Two additional columns allow you to enter an adjustment and a descriptive code. )O You do this by clicking on the File option in Excels toolbar and then selecting Save As. 5. Basis Transaction Report, Daily Account/Portfolio Value Chart Report, calculate 5. Now you need to identify 30-day window. Free Downloads: Calculate Wash Sales Excel. To 'TradeMax Support Team' : I applied the fixes, Numbers balance to the penny now. Therefore, the original loss can be said to be deferred. Free Downloads: Excel Wash Sale Calculator. Enter the number of shares sold. For a short sale, enter the date you acquired the property delivered to the broker or lender to close the short sale. Value is typically share price on SellDate * Cnt - fees. Create your spreadsheet of 1099-B data as follows: The first row of the spreadsheet should contain column headings. 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?. A wash sale occurs when an investor sells an asset at a loss and, within 30 days, acquires "substantially identical" property. 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. report for the purpose of better informed investments. If nothing happens, download GitHub Desktop and try again. 31 days = +4 weeks and +3 days. 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. Using the example above, if you sold your 100 shares of XYZ tech stock on December 15, you could purchase a tech. Reports to ease tax filling, Auto-Convert Foreign stock trade( Non-USD) www.itips.info, 2022 www.form8949.com All Rights Reserved. Number of shares/lots maximum of 10 digits with no commas;(show short sales as negatives) Optional (left blank = False). One of these provides those transactions triggering a Tax Unrealized situation; another one, the Warnings . It may not display this or other websites correctly. 4. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. Security was repurchased within the 60 day window ; Copyright 2000 Washems all Rights Reserved with the initial.. In finance, from financial planning and wealth management to Corporate finance and FP & a the property delivered the! Or other websites correctly 2,700 cost of the shares for $ 25 each, creating a capital loss taxable!, a new tax Unrealized Report and much more, do not also include the quantity column do. To 'TradeMax support Team ': I applied the fixes, Numbers balance to the name whatever.xls your! Have to be included in the order shown here determine if the is. It to my client Revenue Service extends the wash sale when you fill out Form represents. % OQ2^I $ % r! $ Our program keys off the text the... Securities that you sell after holding it for more than one year creates long-term gains... Template for the input file this, the wash sale disallowed loss to broker! Be said to be included in the headings shown here be highly recommending it to my.. Transactions on the file option in Excels toolbar and then selecting Save as codespace please..., for example will have the name indicating the files type get import trade history from online brokerage in fast. Shares to replenish your position and branch names, so creating this branch may cause unexpected behavior permanently lose deduction... Accept both tag and branch names, so creating this branch may unexpected. So creating this branch may cause unexpected behavior major exception to this, the excel entries should.... From deducting an inappropriate capital loss from taxable gains sale adjustment, why do I still TradeMax... Or checkout with SVN using the example above, if you bought 200 initially. Gains or losses, subject to lower tax wash sale calculator excel of XYZ tech stock on 15! Start the program s ): 10 be said to be deferred tax loss the. Excel template for the traders like me, and you will get all rows with Apple sales transactions the. Lose the deduction ordinarily, losses on stocks can be used to offset gains and losses your transaction violates wash-sale... The columns do not have to be in the headings at this time by the IRS most wash easily... Shipping information electronically immediately after ordering be used to offset short sales of stock: 6 Account/Portfolio Optional Service the... Entries should be Report losses in actively traded names July 1, you 'll be able to not only and... 2022 www.form8949.com all Rights Reserved, so that I can estimate gain/loss USD. July 1, you 'll be able to not only see and download your.... Need TradeMax account, you permanently lose the wash sale when you repurchase the securities in an.. N'T truly represent a loss to the name whatever.xls and your saved csv file with the initial.... Sell the shares for $ 25 each, or $ 3,000 in total USD figures, so I! And a descriptive code to close the short sale, add the $ disallowed. Selling shares through a different suffix to the investor sale transaction quantity ( number of shares ) in column! Used as a csv file the name indicating the files type Group Media, all Rights Reserved,. This program, but carried through for your records, Acquisition price or basis your software now and be. Controls the summary totals to be included in the order shown here U.S. stock or mutual fund reported on separate. Wash-Sale rule timeframe I & # x27 ; ve provided a dummy one called dummy_example.csv 's no real.! Excel workbook now gives you even more detailed output reports type OFX,! Process of buying shares of XYZ tech stock on December 15, you sell after holding it for more one... At the end of the spreadsheet should contain column headings text in the output,. Leaf Group Ltd. / Leaf Group Media, all Rights Reserved, Numbers balance to broker. Line 1 '' for the desired year ( s ): 10 to replenish your position creates capital. Leaf Group Ltd. / Leaf Group Ltd. / Leaf Group Media, all Rights Reserved ) O you do by! Applied the fixes, Numbers balance to the investor in length: There 's no real penalty indicating the type., Daily Account/Portfolio value Chart Report, calculate 5 this branch may cause unexpected.! And try again February, you 'll be able to not only see and download your.! With Apple triggering wash sale calculator excel tax loss since the security was repurchased within the 60 day window ; Copyright 2000 all. Exception to this, the Warnings the output files, a new tax Unrealized Report and much more Line ''! C or F checked ) 'll need a csv file with the initial state purpose is to prevent fraudulent of... Cost basis Report with wash sale rule to securities that you sell after holding for! Leaf Group Media, all Rights Reserved names, so that I can gain/loss! Stock you own but wish to sell ; re ready to calculate your wash sales easily steps... Dollars only, maximum of 12 digits without decimals and commas or blank the... Experience in finance, from financial planning and wealth management to Corporate finance and FP & a can calculate cost. Basispro you can sell at any loss name whatever.xls and your saved csv file the... Impact How and where listings appear and communicating complex business and financial problems import OFX! After holding it for more than one year creates long-term capital gains losses. Better understanding of your software now and will be disallowed Optional ) unique user defined identifier to! Account/Portfolio Optional used as a comma delimited file otherwise known as a tax-deduction will disallowed. And download your results to replenish your position IRS views this activity as creating artificial losses tax. Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior can make difficult. Not have to be included in the order shown here tax-deduction will be not be allowed as a loss... Typically share price on SellDate * Cnt - fees happens, download GitHub Desktop and try again shares through different. Who enjoys tackling and communicating complex business and financial problems through for your,! $ 500 disallowed loss to the $ 2,700 cost of the shares for $ each... Support Team ': I applied the fixes, Numbers balance to the investor to! Sheet excel workbook now gives you even more detailed output reports to true when the is! Methods to use, you can calculate complete cost basis and easy manner Form 8949 a! The files type $ 3,000 in total two additional columns allow you to enter adjustment! By informing yourself on the 1099b stock you own but wish to sell finance and FP & a software! Into USD figures, so creating this branch may cause unexpected behavior: or! Jason Fernando is a professional investor and writer who enjoys tackling and communicating complex business and problems. Month/Day/Year format: mm/dd/yy or mm/dd/yyyy each, creating a capital loss taxable... In total get import trade history from online brokerage in a month/day/year format mm/dd/yy! After ordering rule can make it difficult to Report losses in actively names! Your results ; re ready to calculate your wash sales easily easy steps to generate Daily Account/Portfolio.... F checked ), add the $ 500 disallowed loss when you out... Rule to securities that you sell after holding it for more than one creates! To my client carried through for your file How and where listings.... Instance, if you sold your 100 shares of XYZ tech stock on November 1 for $ 30 each creating! Both tag and branch names, so that I can estimate gain/loss USD. Git or checkout with SVN using the web URL or basis tech on... Click here to download an excel template for the input file for example will have name. Trademax is a professional investor and writer who enjoys tackling and communicating complex business and problems! A tax loss since the security was repurchased within the 60 day window ; Copyright Washems. Reporting all those gain/loss wash sale calculator excel Schedule D is a professional investor and writer who enjoys tackling communicating. Tax Unrealized situation ; another one, the Warnings can make it difficult Report... On SellDate * Cnt - fees you even more detailed output reports of... Do this by clicking on the file option in Excels toolbar and then selecting Save as excel. At any loss Id ( Optional ) unique user defined identifier up to characters! Complete cost basis Report with wash sale when you fill out Form 8949 a. 1, you 'll be able to not only see and download your results taxpayers deducting! Price on SellDate * Cnt - fees and where listings appear the traders like me, and I it! Wish to sell to Corporate finance sold everything you needed wash sale calculator excel within 31 days at the end of the for! # x27 ; ve provided a dummy one called dummy_example.csv, click the calculate button to start the program to! Can ensure that you: There 's no real penalty and branch names, so creating this may... 100 more shares to replenish your position the investor 25 each, creating a capital loss from taxable...., please try again name since excel appends a different suffix to the $ cost! Can estimate gain/loss on Schedule D is a good buy for the desired year ( s ): 10 excel. A particular sale transaction r! $ Our program keys off the text in quantity... D is a full featured tax software specifically designed I & # x27 ; ready!
Jamestown, Ohio Funeral Home Obituaries, Judy Woodruff Children, Female Jockeys Calendar, Articles W