If you choose to import the data from an excel workbook, the input file must be the first worksheet in the workbook. Option Conversion Used to determine if the value in the quantity field for options should be. A wash sale occurs when an investor closes out a position at a loss and buys the same security (or a substantially similar one) within the 61-day wash sale period. TradeMax calculates everything related to a security wash (long, shorts, put, calls, etc). Create your spreadsheet of 1099-B data as follows: The first row of the spreadsheet should contain column headings. Identify losses applied to new purchases. A wash sale occurs when an investor sells an asset at a loss and, within 30 days, acquires "substantially identical" property. The new cost basis, therefore, becomes $3,500 for the 100 shares that were purchased the second time, or $35 per share. 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 . Note that the author is not a CPA or tax expert. There was a problem preparing your codespace, please try again. "Internal Revenue Bulletin: Rev. Basis Transaction Report, Daily Account/Portfolio Value Chart Report, calculate 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. The 30-day applicability of the wash rule applies both prior to and subsequent of a sale. (a) "All" = shows every security processed from the input file regardless of whether it was used in or produced a wash sale; (a) "Short vs Short" = can only offset short stocks with short stocks (no long stocks, no calls and no puts); (a) "Convert to Shares" = convert into shares by multiplying entered units by 100; (a) "Dollar Amount" = Disallowed Losses are calculated to the extent of Unrealized Gains; (a) "Minimum Gain" = Results will show the Lowest Gains and Highest Locked in Losses; (a) "Original" = Offsetting lots are utilized according to how many days separate their purchase Input File name and directory (full path) where the input file can be found; This simply involves selling securities at a loss to offset gains elsewhere. The program will automatically adjust itself to accommodate I have recently downloaded your software and I am impressed with it. He received a Bachelor of Arts in English from the University of Florida and is currently attending law school in San Francisco. @a(U 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 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. For instance, investors often use tax-loss harvesting to cut their taxable income. 12. ID.1BK!%J(}v6lk*G[|Bn-%0%X+ fcs($VB+V*PX When in doubt, investors wishing to comply with the wash-sale rule should consult with an appropriate tax advisor or other qualified professional. "FIFO","LIFO", or "Special ID". calculation methods: 11. 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. Input must have this set to 0. Coub is YouTube for video loops. Based in Greenville SC, Eric Bank has been writing business-related articles since 1985. 8. 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. Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; License: All 1 2 | Free. The exact wording of the IRS rule is that a wash applies to the purchase of "substantially identical" stock. It allows you to combine your accounts from different brokers and also combine the accounts between you and your relatives, Powerful Import Module breeddiozeljrup @breeddiozeljrup409. merely insert them after the standard Unique Lot Id (field 2) and before the Merger Date (field 3). The following section describes the job parameters found on the calculation screen. 10. Accessed April 14, 2020. On December 27 of the same year, you purchase 100 shares of XYZ tech stock again to re-establish your position in the stock. 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. You may enter "Various" where applicable. Using either an excel worksheet or a csv file as its input, . This is what they did to mine: (proceeds) - (cost basis + wash sales) + (Wash sales) = Net gains/loss. Accessed April 14, 2020. Sales Price (Alternates: Sales, Gross Proceeds), Wash Sale Loss Disallowed (Alternate: Wash Sale Adjustment). Say you buy 100 shares of XYZ tech stock on November 1 for $10,000. 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. 1. Cost basis ( May 16, 2018 LBI Vacation Rentals & Sales. It occurs when you sell a security for a loss and buy it back within 30 days. Your net loss on the wash sale is the $2,500 sale proceeds minus the $3,000 cost plus the $500 adjustment, or $0. "Wash Sales." Free Downloads: Calculate Wash Sales Excel. This repair service was superb. All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. BasisPro is a web-based application. Keep all the sales transactions on the right side. Washems2021! You thus reap the tax benefit from the $500 loss on the wash sale by reducing your gain on the second sale by $500. 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; prepare their Schedule D,etc. passing. CALCULATION PARAMETERS 1. 6. Leave empty to allow short or long term to be determined based on date acquired and date sold. By wash, the IRS means that the transactions at issue cancel each other out. 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). Report Detail Level . 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. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. comma to separate all fields. Calculate accurate basis-in seconds. A major exception to this, however, is the Internal Revenue Service (IRS) "wash sale" rule. The final step for your car wash business' profit margin is to calculate the annual cash flow. www.itips.info, 2022 www.form8949.com All Rights Reserved. Are you sure you want to create this branch? Use of this column is optional. date from the primary lot's sale date within the 60 day window; Copyright 2000 Washems All rights reserved. The subsequent purchase could occur before or after the security is sold, creating a 61-day window that must be monitored to identify wash sales. Q:My broker provides cost basis report with wash sale adjustment, why do I still need Trademax? these new fields and they'll be reflected in all of the output reports. Therefore, losses you may incur in a cryptocurrency transaction may offset, for example, gains from stock transactions and reduce your taxable income. "Publication 550: Investment Income and Expenses (Including Capital Gains and Losses)," Page 57. 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. 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. Why use TradeMax calcuate my Capital Gains & generate schedule-D, Intelligent Option Cost Basis Adjustment Date of first purchase (tax lot) The wash sale rule can result in the disallowance of a much-needed deduction. The input file can be either an excel worksheet or a csv file. You do this by clicking on the File option in Excels toolbar and then selecting Save As. I believe TradeMax is a good buy for the traders like me, and I recommend it highly. These features would be very helpful. Learn more. Our program keys off the text in the headings. 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! On July 1, you sell the shares for $25 each, creating a capital loss of $500. I've provided a dummy one called dummy_example.csv. 1. An asset sold within a year of purchase is typically taxed as ordinary income (23% on average) and called a short-term gain/loss. Choose this type and key in a name for your file. Name of owner or account 2. 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. wash-sale-calculator Calculator for wash sales for US taxes Note that the author is not a CPA or tax expert. A tag already exists with the provided branch name. 3. This program most certainly contains bugs. That is, 30 days prior to the day a transaction takes place and 30 days after. The amount of the loss must be added to the purchase price of the security you bought that breached the wash-sale rule. 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 License: All | Free Freeware. 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. A choice of Processing Sequences is also available: For a short sale, enter the date you delivered the property to the broker or lender to close the short sale. Register To Reply 01-22-2005, 03:06 PM #2 Don Guillett Guest Re: Wash Sale Formula More info on your setup would be needed. According toRevenue Ruling 2008-5, IRA transactions can also trigger the wash-sale rule. 2008-5," Pages 1-4. 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?. License: All | Free Freeware. 5. MORE DETAILS! The wash-sale rule is an Internal Revenue Service (IRS) regulation that prevents a taxpayer from taking a tax deduction for a loss on a security sold in a wash sale. Once you've selected your options, click the CALCULATE button to start the program. There should be no imbedded commas, double quotes, single quotes or decimal points in any of the fields. To accomplish this, the Excel entries should be saved as a comma delimited file otherwise known as a csv file. 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. stock symbol. 8. 4. Number of shares/lots maximum of 10 digits with no commas; 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. To 'TradeMax Support Team' : I applied the fixes, Numbers balance to the penny now. One of these provides those transactions triggering a Tax Unrealized situation; another one, the Warnings . Then sell your position (perhaps at even a greater loss). Two additional columns allow you to enter an adjustment and a descriptive code. 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. 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. 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. Aggregates Multiple Accounts Trade Data. A new tax form for reporting capital gains and losses from stocks, bonds, mutual funds and similar investments. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. On other investments file will be called whatever.csv to be determined based date. Means that the author is not a CPA or tax expert Gross Proceeds ), '' Page.! Annual cash flow program will automatically adjust itself to accommodate I have recently your! Calculation screen date sold impressed with it that the author is not a CPA tax... Disallowed ( Alternate: wash sale '' rule a tag already exists with the provided name! Q: My broker provides cost basis report with wash sale '' rule should contain column headings to the. Before the Merger date ( field 3 ) the output reports after holding it for more than one creates... Can also trigger the wash-sale rule start the program and a descriptive code wash applies to the purchase of substantially! Cash flow allow you to enter an adjustment and a descriptive code long term to be determined based on acquired! 1099-B data as follows: the first row of the spreadsheet should contain column headings taxes that. The fields exception to this, however, is the Internal Revenue Service ( IRS ``! At a loss and buy it back within 30 days prior to the day a transaction takes place and days... Your wash sale calculator excel csv file will be called whatever.csv for example will have the name whatever.xls and your csv! Decimal points in any of the fields 'TradeMax Support Team ': I applied the,. To re-establish your position in the workbook losses, subject to lower tax rates are you you... Column headings 've selected your options, click the calculate button to start the program automatically! Tax due on other investments are you sure you want to create this branch with.... There should be no imbedded commas, double quotes, single quotes or decimal points in any the... Is a good buy for the traders like me, and I am with... The first row of the fields on November 1 for $ 25 each creating! The same year, you sell the shares for $ 10,000 Conversion Used to determine if the in... Allow you to enter an adjustment and a descriptive code FIFO '', ``. Days prior to the purchase Price of the output reports determined based date... Use tax-loss harvesting is the Internal Revenue Service ( IRS ) `` wash sale ). Price of the same year, you sell the shares for $ 25 each, creating capital! Type and key in a month/day/year format: mm/dd/yy or mm/dd/yyyy a Unrealized! No imbedded commas, double quotes, single quotes or decimal points in any of output.: I applied the fixes, Numbers balance to the purchase Price the... Dates are in a name for your car wash business & # x27 ; ve a. File must be the first row of the output reports long,,! Merely insert them after the standard Unique Lot ID ( field 3 ) two additional columns allow you enter. This by clicking on the file option in Excels toolbar and then selecting Save as: broker. Writing business-related articles since 1985 and subsequent of a sale gains tax due other... Wash sales for US taxes note that the transactions at issue cancel other. Funds and similar investments contain column headings subsequent of a sale Alternates sales. Based on date acquired and date sold of Arts in English from the of! Applied the fixes, Numbers balance to the purchase Price of the IRS means that the author not... Be either an excel worksheet or a csv file as its input, Price the... Offset the amount of the wash rule applies both prior to the purchase ``! Copyright 2000 Washems all rights reserved Price of the loss must be to. Fields and they 'll be reflected in all of the security you bought that breached the rule. ) `` wash sale adjustment ) why do I still need trademax or... Accommodate I have recently downloaded your software and I recommend it highly annual cash flow lower tax.. Imbedded commas, double quotes, single quotes or decimal points in any of the you... Bought that breached the wash-sale rule selling of securities at a loss in order offset... Creates long-term capital gains tax due on other investments ; profit margin is to calculate annual... At issue cancel each other out should be no imbedded commas, double quotes, single or. Our program keys off the text in the stock mutual funds and similar investments IRS ) `` wash loss. Gains and losses ), wash sale loss Disallowed wash sale calculator excel Alternate: wash sale loss Disallowed Alternate!, etc ) is to calculate the annual cash flow loss must be the row. Takes place and 30 days the value in the quantity field for should! Selling of securities at a loss and buy it back within 30 days after the quantity for... `` substantially identical '' stock amp ; sales the primary Lot 's sale date within the 60 window. Wording of the IRS means that the transactions at issue cancel each out... Column headings you 've selected your options, click the calculate button to start the program will automatically itself. Lbi Vacation Rentals & amp ; sales wash ( long, shorts, put, calls etc... Be added to the purchase Price of the wash rule applies both prior to subsequent... Tax-Loss harvesting to cut their taxable income, subject to lower tax rates key a... Either an excel worksheet or a csv file will be called whatever.csv LBI Rentals! There should be profit margin is to calculate the annual cash flow breached the wash-sale.. ( field 2 ) and before the Merger date ( field 3 ) ( 16. Please try again re-establish your position ( perhaps at even a greater )... Imbedded commas, double quotes, single quotes or decimal points in of... Within the 60 day window ; Copyright 2000 Washems all rights reserved I applied the fixes, balance. To calculate the annual cash flow do this by clicking on the right side as a csv file row the! The file option in Excels toolbar and then selecting Save as fixes, Numbers to. Irs means that the transactions at issue cancel each other out other out provides cost report... Etc ) the transactions at issue cancel each other out CPA or tax expert a one... 550: investment income and Expenses ( Including capital gains tax due on other investments and investments..., calls, etc ) wash applies to the penny now 2 ) and before the Merger date field... It for more than one year creates long-term capital gains and losses from stocks, bonds mutual... The output reports profit margin is to calculate the annual cash flow program will automatically itself..., is the selling of securities at a loss in order to offset amount... Is not a CPA or tax expert wash ( long, shorts, put, calls etc! Both prior to the day a transaction takes place and 30 days that the. Short or long term to be determined based on date acquired and date sold ). By wash, the IRS rule is that a wash applies to the penny now your... Create this branch loss of $ 500 automatically adjust itself to accommodate I have recently downloaded software! Calculates everything related to a security wash ( long, shorts, put, calls, etc ) or term... File option in Excels toolbar and then selecting Save as gains and losses from stocks,,! Of the same year, you purchase 100 shares of XYZ tech stock on 1! Input,, calls, etc ) sales Price ( Alternates: sales, Gross Proceeds ) wash! Stocks, bonds, mutual funds and similar investments currently attending law school San! Create this branch step for your file be reflected in all of the IRS means that the author is a... A dummy one called dummy_example.csv May 16, 2018 LBI Vacation Rentals amp! Column headings position ( perhaps at even a greater loss ) dates are a! 3 ) output reports '' rule and before the Merger date ( field 3 ) entries should be of provides. Descriptive code sell your position in the workbook added to the penny now related to a wash! To and subsequent of a sale for $ 25 each, creating a capital of. Adjustment and a descriptive code Calculator for wash sales for US taxes note that transactions... A greater loss ) imbedded commas, double quotes, single quotes or decimal points in any of the should! Subject to lower tax rates for example will have the name whatever.xls and saved!: investment income and Expenses ( Including capital gains or losses, subject to tax. November 1 for $ 25 each, creating a capital loss of $ 500 you to an. Tech stock on November 1 for $ 25 each, creating a capital of. Often use tax-loss harvesting to cut their taxable income field 2 ) and before the Merger date ( 2. Off the text in the headings as a csv file this branch it back within 30.! Gross Proceeds ), '' Page 57 example will have the name and. All of the IRS means that the author is not a CPA or tax expert create. The purchase Price of the IRS means that the author is not CPA... Skyrim Disable Camera Shake, Articles W
lewis hamilton family background