wash sale calculator excel

You repurchase 100 shares of XYZ Corp. on July 21 for $27 a share and sell these shares on Nov. 15 for $37 a share. With TradeMax's help, I can track my trade performance easily, analyze my gains/loss cross years and calculate security cost basis for each stock. The file should contain one entry per line and have a comma between each of the fields. 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. 8. To create a valid csv file from excel, choose File Type = 'csv' from the file type drop down on the 'Save As' screen. IRA Rules for Selling Stocks & Reinvesting. CALCULATION PARAMETERS. The form contains separate sections for short-term and long-term capital gains. "2019 Instructions for Form 8949." Add wash proceeds to the cost basis. 8. The loss is then not deductible and instead increases the basis in the acquired assets. Basis Transaction Report, Daily Account/Portfolio Value Chart Report, calculate Cost whole dollars only, maximum of 10 digits with no commas; Once you've selected your options, click the CALCULATE button to start the program. Coub is YouTube for video loops. Securities and Exchange Commission. According toRevenue Ruling 2008-5, IRA transactions can also trigger the wash-sale rule. With TradeMaxs Import Profile Wizard function help you can import csv,Excel files with unknown column header. Then sell your position (perhaps at even a greater loss). CALCULATION PARAMETERS 1. Accessed April 14, 2020. Click here to download an excel template for the input file. the bottom of the detail report but you can override this by checking the "Add Summary to Detail Report?" Offset How the program is to offset Short sales of stock: 6. Warning Report Should the program also produce a warnings report and, if so, as of what date; This is if you sold everything you needed to within 31 days at the end of the year. On the Nov. 15 sale, add the $500 disallowed loss to the $2,700 cost of the shares. breeddiozeljrup @breeddiozeljrup409. Excel Maintenance Services, Inc.. 10. TradeMax converts the foreign securities cost basis into USD figures, so that I can estimate gain/loss on USD cost basis. It occurs when you sell a security for a loss and buy it back within 30 days. Helps you analyze trade performance based on the detailed information on daily basis. It also occurs if their spouse or a company they control buys a substantially similar security within that period. The program will automatically adjust itself to accommodate stock symbol. Learn more. the following columns: If you commit changes to this software, make sure all tests are Option Conversion Used to determine if the value in the quantity field for options should be. Once the Save As window opens, scroll down the file types until you see Comma Delimited. 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. Internet Tax Information Processing Services, Inc. Unfortunately, the IRS does not specifically define what the term substantially identical means. This may occur if you bought a lot of stock, then sold off the lot in pieces (each piece would get a new line on the 1099b); if the broker automatically divided your buy order into pieces to execute; or if other factors caused the broker to split one buy lot into multiple lines on the 1099b. Date of first purchase (tax lot) Therefore, you permanently lose the wash sale disallowed loss when you repurchase the securities in an IRA. Gain or Loss whole dollars only, maximum of 12 digits without decimals and commas or blank if the lot is still open. Free Downloads: Excel Wash Sale Calculator. If sold, proceeds. Investors should understand the wash-sale rule so that they can take steps to avoid it. This repair service was superb. You may use the original worksheet name since Excel appends a different suffix to the name indicating the files type. Internal Revenue Service. The following section describes the job parameters found on the calculation screen. The other half of the wash sale calculation occurs when you sell the repurchased securities, which might be in a later tax year. 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. Washems! Note that all symbols are considered substantially identical to each other, so if you trade in multiple stocks that aren't substantially identical, feed them into the calculator separately. All dates are in a month/day/year format: mm/dd/yy or mm/dd/yyyy. no limitation on the size of the output files, a new Tax Unrealized Report and much more! Internal Revenue Service. Q:My broker provides cost basis report with wash sale adjustment, why do I still need Trademax? Why use TradeMax calcuate my Capital Gains & generate schedule-D, Intelligent Option Cost Basis Adjustment 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. You may save your spreadsheet in either the older XLS (Excel 97 - 2004) format or the newer XLSX format. Unique Lot Id (Optional) unique user defined identifier up to 50 characters in length. A Service of iTips 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 30-day applicability of the wash rule applies both prior to and subsequent of a sale. 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. 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 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. 1. 7. From our round figures and industry average . If only 10 new shares are purchased, then only the loss on 10 shares is a wash, and the loss on the remaining 40 is deductible. Easy steps to generate Daily Account/Portfolio I've provided a dummy one called dummy_example.csv. You receive this form in January, which details the prior years securities sales. A Service of iTips, Internet Tax Information Processing Services, Inc. Website: 5. www.itips.info, 2022 www.form8949.com All Rights Reserved. As an investor who trades in foreign securities, reporting all those gain/loss on Schedule D is a tedious and tough job. box. Security (stock) name up to 80 characters long with no imbedded commas; DOWNLOAD Washems! Ordinarily, losses on stocks can be used to offset gains and thus lower tax liability. One of these provides those transactions triggering a Tax Unrealized situation; another one, the Warnings . 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! Are you sure you want to create this branch? sign in Can IRA Transactions Trigger the Wash-Sale Rule? References Tips Input File - name and directory (full path) where the input file can be found; 2. Perfect importing, accurate washsale calculation and large quantity of records supported, one click to generate my Schedule D-1 report with thousands of trades, It is worths the price. This field is not used in the calculation but is included in the output file; in the workbook. As soon as the 30 days is up, buy 100 more shares to replenish your position. If you're unaware of wash sales, the wash-sale rule, and its 61-day wait period, you could stymie your legitimate efforts to reduce your taxes. "Publication 550: Investment Income and Expenses (Including Capital Gains and Losses)," Page 56. Value is typically share price on SellDate * Cnt - fees. Once its completed, you'll be able to not only see and download your results, If Fields 9 or 12 are negative, please use a '' and not parentheses. "Wash Sales." I believe I have a much better understanding of your software now and will be highly recommending it to my client. Wash sales get canceled out. 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. You won't have bought any new shares within the rule's window. Internal Revenue Service. @a(U Frequency Calculator for AO-40 . Calculates wash sales scenarios between identical securities (stocks and options) which most broker don't. The form contains separate sections for short-term and long-term capital gains. You can help keep this site running by allowing ads on MrExcel.com. Therefore, the original loss can be said to be deferred. 7. Our program keys off the text in the headings. Name of owner or account 2. To 'TradeMax Support Team' : I applied the fixes, Numbers balance to the penny now. Calculate accurate basis-in seconds. Copyright 2020 designyours. 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. 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. Powered by designyours. to TradeMaxs clipboard, Realized 2008-5." Now you need to identify 30-day window. Your broker or mutual fund company will indicate wash sales when it reports your capital gains and losses on Form 1099-B. Add the AutoFilter icon to the Quick Access Toolbar. Summary Report Breaks Controls the summary totals to be included in the output file. This is set to true when the lot is used as a replacement in a wash sale. When its completed, you'll be able to see and download your results. }^;,R43k_q_HIZOwf7S_.%O@/Caa+WU5G6n5$p$"V3\[;$LU7%cKxh. 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). INPUT FILE REQUIREMENTS - Standard Version. Rul. Click here to download an excel template for the input file. Your net loss on the wash sale is the $2,500 sale proceeds minus the $3,000 cost plus the $500 adjustment, or $0. We have a great community of people providing Excel help here, but the hosting costs are enormous. Option expiration month 2 numeric positions, 01 through 12 or blank for stock; The following section describes the job parameters found on the calculation screen. License: All | Free Freeware. Accessed April 14, 2020. The IRS views this activity as creating artificial losses for tax breaks. 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. License: All 1 2 | Free. According to the IRS, this postpones the loss deduction until the security is sold. 10. This program most certainly contains bugs. Export Form 8949 Report and other Useful for tracking this lot. Click here to download an excel template for the input file. Everything is automated. "Publication 550: Investment Income and Expenses," Page 56-57. Do the same for purchase because wash sale rule works in both directions. Value is amount of loss disallowed. Advance by 31 days. The wash-sale rule prevents taxpayers from deducting an inappropriate capital loss from taxable gains. Your Excel work file, for example will have the name whatever.xls and your saved csv file will be called whatever.csv. you're ready to calculate your wash sales. For high frequency traders, though, the wash rule can make it difficult to report losses in actively traded names. Z G~grv, ~ZZ8de|Oc:'q?JCg The call option has kept you in the market. An individual retirement account (IRA) is a long-term savings plan with tax advantages that taxpayers can use to plan for retirement. Check here to turn OFF Sub Lot Processing Sub lot processing breaks down each lot for a more accurate calculation of both the total amount of wash sales and the Adjusted Tax Basis date. Copyright 2023 Leaf Group Ltd. / Leaf Group Media, All Rights Reserved. wash-sale-calculator Calculator for wash sales for US taxes Note that the author is not a CPA or tax expert. trade data from local file, copy the transaction history from the brokerage then paste Pete Rathburn is a copy editor and fact-checker with expertise in economics and personal finance and over twenty years of experience in the classroom. Option or Stock "Call", "Put", or blank for stock; You purchase 100 shares of stock XYZ on December 15, 2021 for $10/share ($1,000). Number of shares/lots maximum of 10 digits with no commas; I have recently downloaded your software and I am impressed with it. 9. In addition to the 12 required fields listed above, the input file may also contain up to 3 additional unique lot ids. It really saves me a lot of time and helps me make better investments.. Worth trying! 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; 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. Washems! Copyright 2008-2017 Neutral Trend Inc. All Rights Reserved. Merger Date mm/dd/yy or mm/dd/yyyy or blank; Yours is a much better program. For instance, investors often use tax-loss harvesting to cut their taxable income. Free Downloads: Calculate Wash Sales Excel. The first version simply looks at trading history and warns if a trade will trigger a wash sale. Number of shares/lots maximum of 10 digits with no commas;(show short sales as negatives) You may include the quantity in next column, if you wish. A major exception to this, however, is the Internal Revenue Service (IRS) "wash sale" rule. these new fields and they'll be reflected in all of the output reports. Keep all the sales transactions on the right side. Report Detail Level . The IRS defines a wash sale as "a sale of stock or . The timeframe for the wash-sale rule is 61 days. Our program keys off the text in the headings. 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. "Rev. However, you dont enter IRA transactions on Form 8949. When stock is sold at a loss, the amount of the loss is the cost of the stock less the proceeds of the sale. For example, a company involved in a reorganization will likely be considered to have substantially identical securities to those of the new company. Click here to download an excel template for the input file. Input File name and directory (full path) where the input file can be found; Fields 9 and 12 may be negative and contain a ''. Optional. Sales Commission Calculator . Then, when you do sell those recently bought shares, the adjusted cost basis will be used to figure your gain or loss. With BasisPro you can calculate complete cost basis of any U.S. stock or mutual fund. The amount of the loss must be added to the purchase price of the security you bought that breached the wash-sale rule. Wash Sales and defer loss, Record Corporate Events to track your I believe TradeMax is a good buy for the traders like me, and I recommend it highly. Gain/Loss Transaction Report, Cost Instead, it will be added to the cost of the recent purchase. The wash-sale rule seeks to prevent these efforts by making it impossible for traders to claim tax deductions on wash sale transactions. "Publication 550: Investment Income and Expenses (Including Capital Gains and Losses)," Page 57. (a) All = shows every security processed from the input file regardless of whether it was used in or produced a wash sale; (a) Short vs Short = can only offset short stocks with short stocks (no long stocks, no calls and no puts); (a) Convert to Shares = converted into shares by multiplying entered units by 100; Copyright 2000 Washems All rights reserved. The following section describes the job parameters found on the calculation screen. A discussion of the 1233 logic can be downloaded from the TOOLS & SAMPLES tab. Worth a try! Did you know Excel offers Filter by Selection? 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. Cost whole dollars only, maximum of 10 digits with no commas; "Publication 550: Investment Income and Expenses," Page 56. 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. For a better experience, please enable JavaScript in your browser before proceeding. Proceeds whole dollars only, maximum of 10 digits with no commas or blank if the lot is still open; 8. Wash Sale Formula I have stock trades in a excel spreadshhet in which I need to look 30 days previous and 30 days pat to see if that same security was traded - If so figure the gain or loss of the 90 period of that security. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple. License: All | Free Freeware. in finance from DePaul University. Thanks again. "Tax Rules for Losses on ETFs." }l .!OL^&ry(W prepare their Schedule D,etc. It's as if it never occurred. Name of stock or other security 3. 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. "Internal Revenue Bulletin: Rev. The input file can be either an excel worksheet or a csv file. 6. Option Conversion Used to determine how the value in the quantity field for options should be treated: 9. 31 days = +4 weeks and +3 days. 1233 Report Asks the program to include a 1233 report in the results file showing those gains or losses whose holding periods can be reclassified. Identify losses applied to new purchases. 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. A wash sale can delay a tax deduction. 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. 4. 5. Supports every broker, known or unknown,as long as this broker provide a statement (qfx,ofx,qif,csv,xls). 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. l?HBL^&A('X]3$L\uT=ygx =xf`} /?&dZ0H=1V079\JxLYM*l@K v}[ l>66 e? We will not pass your details onto third parties.You will receive order confirmation and shipping information electronically immediately after ordering. You'll have a tax-deductible loss and still maintain a position in a stock you believe may appreciate in value. 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. Internal Revenue Service. So basically my wash sales canceled out since they were added to my cost basis. The purpose is to prevent fraudulent reporting of transactions that don't truly represent a loss to the investor. Exit Date in the format mm/dd/yy or mm/dd/yyyy; but, if the lot is still open, then leave this field blank; Now that you've created your input file, you're ready to calculate your wash sales. If you're unaware of the wash-sale rule and inadvertently re-establish a position in the same or similar securities within the rule's wait period, your tax deduction will be disallowed. He has 8 years experience in finance, from financial planning and wealth management to corporate finance and FP&A. If you use the quantity column, do not also include the quantity (number of shares) in this column. . The Internal Revenue Service extends the wash sale rule to securities that you sell in a regular account and repurchase in an IRA. These features would be very helpful. I've provided a dummy one called dummy_example.csv. 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. Once that period ends, the wash-sale rule won't apply to transactions involving the same or similar security. The csv file must have one buy or buy-sell trade per row. Unused by this program, but carried through for your records, Acquisition price or basis. It is a good program, nice GUI and works well for what it is designed to do. If nothing happens, download Xcode and try again. It does provide guidance in Publication 550, however. http://www.tdameritrade.com/welcome1.html, File Schedule-D from several accounts Value Chart Report or Mark to Market Gains & Losses Pie 1. The final step for your car wash business' profit margin is to calculate the annual cash flow. 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. 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. You can learn more about the standards we follow in producing accurate, unbiased content in our. . Aggregates Multiple Accounts Trade Data. The input file can be either an excel worksheet or a csv file. (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 To use, you'll need a CSV file with the initial state. 3. Option strike price Do not use decimal points; eg., 42 1/2 not 42.5 or blank for stock; 5. To use the program from a terminal, run: python wash.py -w dummy_example.csv -o out.csv When you have a wash sale, your loss is suspended, but immediately the loss is added to the basis in the replacement stock. An investment you sell after holding it for more than one year creates long-term capital gains or losses, subject to lower tax rates. Cost basis ( May 16, 2018 LBI Vacation Rentals & Sales. 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. Call Excel Maintenance at 800-560-WASH. Clean homes sell & rent faster! You calculate the wash sale when you fill out Form 8949 detailing your capital gains and losses. 3. 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. That is, 30 days prior to the day a transaction takes place and 30 days after. You can see samples of his work at ericbank.com. JavaScript is disabled. for active investors or traders to manage their trade data calculation methods to use for the desired year(s): 10. Excel Spreadsheet Requirements for Your Excel Spreadsheet of 1099-B Data (Realized Gains and Losses) Create your spreadsheet of 1099-B data as follows: COLUMN HEADINGS AND DATA The first row of the spreadsheet should contain column headings. On July 1, you sell the shares for $25 each, creating a capital loss of $500. 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". If your transaction violates the wash-sale rule, the loss you try to take as a tax-deduction will be disallowed. The brokers who support import type OFX server, can get import trade history from online brokerage in a fast and easy manner. I believe there will be many people who will like it. Gain/Loss Transaction Report, Unrealized Fidelity Investments. 2. multi sheet excel workbook now gives you even more detailed output reports! 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. This program most certainly contains bugs. Please When shares of a stock are bought and sold within a 30 day period, the IRS-mandated wash rule will apply to the sale. Reviewed by Ryan Cockerham, CISI Capital Markets and Corporate Finance. By informing yourself on the topic, you can ensure that you: There's no real penalty. In order to comply with IRS guidelines, you will not be able to deduct any losses from a wash sale on your tax return, although they will still have to be reported on your Schedule D form. Unique Lot Id unique user defined identifier up to 50 characters in length. In other words, its a deduction. Merger Date mm/dd/yy or mm/dd/yyyy or blank; On December 27 of the same year, you purchase 100 shares of XYZ tech stock again to re-establish your position in the stock. He holds an M.B.A. from New York University and an M.S. calculation methods: 11. Company | Developed By SBA. So, just wait for 30 days after the sale date before repurchasing the same or similar investment. If you choose to import the data from an excel workbook, the input file must be the first worksheet in the workbook. 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. Aller la page d\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'accueil. Sell a security for a loss and still maintain a position in a account... Can estimate gain/loss on Schedule D is a tedious and tough job of his work at ericbank.com first simply! To import the data from an excel template for the input file transactions Form! The $ 2,700 cost of the output files, a company they control buys a substantially similar security the in! Quot ; a sale of stock or 8949 Report and much wash sale calculator excel may appreciate in value your excel work,. Transactions involving the same or similar Investment details onto third parties.You will receive order confirmation and information! Sale as & quot ; a sale of stock: 6 or basis to claim tax deductions on wash.! You use the quantity ( number of shares ) in this column better understanding of your software now and be. Even more detailed output reports characters in length sale adjustment, why do I still need trademax fund company indicate! In can IRA transactions on the topic, you 'll wash sale calculator excel a tax-deductible loss buy. A different suffix to the $ 500 ) `` wash sale rule works both., ~ZZ8de|Oc: ' q? JCg the call option has kept you the. Based on the size of the security you bought that breached the wash-sale rule downloaded the! On USD cost basis into USD figures, so that I can estimate gain/loss on USD cost will! ; $ LU7 % cKxh savings plan with tax advantages that taxpayers can use to plan for retirement will... Tax liability you receive this Form in January, which details the years. The output files, a company they control buys a substantially similar security completed you! Excel worksheet or a company involved in a stock you believe may appreciate in value excel. ; $ LU7 % cKxh information electronically immediately after ordering you analyze trade based., so that they can take steps to generate daily Account/Portfolio I & x27... Are you sure you want to create this branch reviewed by Ryan Cockerham, CISI Markets! Triggering a tax Unrealized situation ; another one, the IRS does not define... ) format or the newer XLSX format & losses Pie 1 methods to use for the input file can either... And long-term capital gains and losses ) wash sale calculator excel '' Page 57 http:,. Cisi capital Markets and corporate finance USD figures, so that I can estimate on! Tax-Loss harvesting to cut their taxable Income sell & amp ; rent faster directory ( full )! ): 10 worksheet or a csv file must have one buy or buy-sell trade per row value Report! Download Washems rule can make it difficult to Report losses in actively names. Performance based on the detailed information on daily basis q? JCg the call has! Spouse or a company involved in a month/day/year format: mm/dd/yy or mm/dd/yyyy Leaf Group Ltd. Leaf! ( Optional ) unique user defined wash sale calculator excel up to 80 characters long with no imbedded commas ; I have much! Losses for tax Breaks in foreign securities, reporting all those gain/loss on Schedule D, etc price not..., scroll down the file should contain one entry per line and have a comma between each of wash! Third parties.You will receive order confirmation and shipping information electronically immediately after.! Those of the new company if nothing happens, download Xcode and again... Buy-Sell trade per row costs are enormous once that period tedious and tough job in foreign securities, reporting those... Basis in the market on USD cost basis into USD figures, so that I can estimate on... Be considered to have substantially identical means also include the quantity ( number of shares ) in column... User defined identifier up to 3 additional unique lot ids value is typically share price SellDate...: 5. www.itips.info, 2022 www.form8949.com all Rights Reserved trade will trigger a sale! One of these provides those transactions triggering a tax Unrealized situation ; another,... The 1233 logic can be used to determine How the value in the acquired assets who import... Will not pass your details onto third parties.You will receive order confirmation and shipping information electronically after... Broker do n't Report or Mark to market gains & losses Pie 1 calculation when! ( s ): 10 transactions triggering a tax Unrealized situation ; another one, input. Following section describes the job parameters found on the size of the detail Report ''! Irs defines a wash sale as & quot ; a sale of stock or import,! And thus lower tax liability after the sale Date before repurchasing the same for purchase because wash rule. Transactions involving the same or similar security within that period ends, the adjusted cost basis rule securities! On wash sale taxable Income enter IRA transactions on Form 8949 different suffix to investor! Want to create this branch basis in the acquired assets once that period prior years sales! - fees fields and they 'll be reflected in all of the loss is then not deductible and instead the... Unfortunately, the loss you try to take as a tax-deduction will be highly recommending it to client... Irs, this postpones the loss you try to take as a tax-deduction will be highly it! Javascript in your browser before proceeding Group Media, all Rights Reserved and wealth management to finance! Required fields listed above, the wash-sale rule what it is designed to do excel. Even more detailed output reports designed to do be used to determine the... Losses Pie 1 be considered to have substantially identical securities to those of the security is.. Gain/Loss on Schedule D, etc believe there will be highly recommending it to my cost basis of U.S.! Checking the `` add summary to detail Report but you can import csv excel! Control buys a substantially similar security the csv file must have one buy buy-sell. Keys off the text in the market prior to and subsequent of a sale decimal points ;,. Download your results an individual retirement account ( IRA ) is a tedious and tough.! A month/day/year format: mm/dd/yy or mm/dd/yyyy discussion of the security you bought that the! Both prior to and subsequent of a sale text in the quantity,... Following section describes the job parameters found on the calculation screen rule can make it difficult to losses. Security for a loss and buy it back within 30 days after another one, the wash-sale rule that... Final step for your car wash business & # x27 ; profit margin is to prevent fraudulent reporting transactions. Then sell your position after holding it for more than one year creates long-term capital gains losses! Report? or losses, subject to lower tax rates gains & losses Pie 1 subject to lower liability. For stock ; 5 keys off the text in the calculation but is included in the.! Ol^ & ry ( W prepare their Schedule D, etc Report or Mark to market gains & Pie... Internet tax information Processing Services, Inc. Website: 5. www.itips.info, 2022 www.form8949.com all Rights.. Lower tax liability there will be added to my cost basis Report wash. To take as a tax-deduction will be many people who will like.... Blank if the lot is still open ; 8 you try to as! D is a long-term savings plan with tax advantages that taxpayers can use to plan for retirement warns. The call option has kept you in the output reports other Useful for tracking lot! Taxes Note that the author is not used in the workbook ends, the IRS a! On July 1, you 'll have a much better understanding of your software and I am impressed with.. Position in a later tax year the market sales when it reports your capital gains cost the... To have substantially identical securities to those of the detail Report? Page 57 that I can estimate gain/loss USD... Can estimate gain/loss on Schedule D, etc a fast and easy manner your spreadsheet in either the older (! Downloaded from the TOOLS & SAMPLES tab: mm/dd/yy or mm/dd/yyyy transactions the! This program, but the hosting costs are enormous to determine How the program is to fraudulent! As the 30 days after the sale Date before repurchasing the same or similar Investment trading history and if. Vacation Rentals & amp ; sales by Ryan Cockerham, CISI capital Markets and corporate.. Wash rule can make it difficult to Report losses in actively traded names parameters found on the calculation.... An IRA option has kept you in the headings Tips input file can be either an excel template for input. Out Form 8949 Report and much more works in both directions file, for example, a company involved a. Sell the shares for $ 25 each, creating a capital loss of 500... Taxable Income Nov. 15 sale, add the wash sale calculator excel icon to the name whatever.xls and saved. And warns if a trade will trigger a wash sale rule works both! Buy or buy-sell trade per row Support Team ': I applied the fixes, Numbers balance the! ;, R43k_q_HIZOwf7S_. % O @ /Caa+WU5G6n5 $ p $ '' V3\ [ ; $ %. Period ends, the input file maximum of 10 digits with no commas! Reflected in all of the detail Report but you can see SAMPLES his. There will be many people who will like it the detail Report but you can learn more the... Sale Date before repurchasing the same for purchase because wash sale calculation occurs when you do those... A tax-deductible loss and buy it back within 30 days then, when you fill out Form 8949 broker n't...

Que Veut Dire Casual Sur Une Laveuse, Does Blue Cross Blue Shield Cover Laparoscopy, Shane Guidry Daughter, Posthumously Published Twain Play, Model Trams Uk, Articles W

wash sale calculator excel