merging transactions in 8949
From the instructions: If you do not need to make any adjustments to the basis or type of   gain or loss (short-term or long-term) reported to you on Form 1099-B   (or substitute statement) or to your gain or loss for any transactions   for which basis has been reported to the IRS (normally reported on   Form 8949 with box A checked), you do not have to include those   transactions on Form 8949. Instead, you can report summary information   for those transactions directly on Schedule D. For more information,   see Exception 1, later. However, in case of ESPP and RSU, it is likely that you actually do need to make adjustments. Since 2014, brokers are no longer required to track basis for these, so you better check that the calculations are correct. If the numbers are right and you just summarized instead of reporting each on a separate line, its probably not an issue. As long as the gains reported are correct, no-one will waste their time on you. If you missed several thousand dollars because of incorrect calculations, some might think you were intentionally trying to hide something by aggregating and may come after you.
"I believe that your option contracts will become ""non-standard"" and will be for a combination of ACE stock and cash.  The allocation between stock and cash should follow that of the acquisition parameters of the underlying - probably with fractional shares converted to cash. Hence 1 call contract for 100 shares of CB will become 1 call contract for 60 shares of ACE + $6293 cash + a cash correction for the 0.19 fractional share of ACE that you would have had claim to get.  The corrections should be 0.19 sh x $62.93/sh." "Thanks for the response.   I am using WRDS database and we are currently filtering through various variables like operating income, free cash flow etc.  Main issue right now is that the database seems to only go up to 2015...is there a similar database that has 2016 info?  filtering out the ""recent equity issuance or M&amp;A activity exceeding 10% of total assets"" is another story, namely, how can I identify M&amp;A activity? I suppose we can filter it with algorithm stating if company's equity suddenly jumps 10% or more, it get's flagged" You add the wash sale loss to your cost basis for the other transaction so you would have two entries in your schedule d reporting 1.) Listing the $2000 loss as a wash 2.) The cost basis for your second transaction is thus $1000+$2000 = $3000 so when it was sold for $2000 you now have a reportable loss of $1000. For more information see here.... http://www.ehow.com/how_5313540_calculate-wash-sale.html I wound up asking Mint over email so I'll share the answer I received: Thank you for contacting Mint.com.  From my understand you want to know if Mint can transfer data to other   Intuit products and vice versa. Let me address your concern based from   what I can see on my tools. Upon confirming, while Mint and other Intuit products are under the   same company, Mint.com is not yet integrated to other Intuit products.   We’d like to thank you though for giving the idea to us. With this, we   would know which future enhancements will our customers appreciate. We have forwarded your request/suggestion to our Product and   Development team for their review. At this time though, we can't make   any guarantee that your request/suggestion will get implemented as we   must balance customer demand with resources and business objectives. Oops... It's a covered call.  When I want to create a covered call position, I don't need to wait before the stock transaction settles. I enter it as one trade, and they settle at different times. I wouldn't get too caught up with this. Doesn't sound like this is even stock reconciliation, more ensuring the cash you've received for dividends &amp; other corporate actions agrees to your expected entitlements and if not raising claims etc. They're all in one place. The OCC provides: http://www.optionsclearing.com/webapps/flex-reports "In the first situation you describe, any intelligent routing algo will send a 1000 lot order to the lit exchange in step 1. Then you get filled 1000@$10. After the fill occurs, the matching engine tells everyone what happened.   If the order book consists of 100 orders of 1 lot @ $10, and you place a ""buy 100 lots"" order, here is what happens:  1. The matching engine receives your order. 2. The matching engine matches your order against the 100 individual orders on the book. 3. The matching engine broadcasts 100 trade notifications.   No one has any opportunity to cancel their orders since they only hear of the fill after it happened.   The only way someone would have the opportunity to cancel is if there was 500 lots on one exchange and 500 on another. Then someone might observe a trade on exchange #1 and cancel their sell order on exchange #2 in response." I'd say its time to merge finances! Absolutely agree and I strongly support the proposals being thrown around to separate back out banks from their investment / brokerage departments.  I also think we should have a minimum transaction time for trades and minimum holding times. The data for ES_F normally is joined on the contract expiry date, i.e. june is joined to the next month on the expiry date.  The discrepancy to the real thing in practice might be significant, as seasonal strategies (as we call these) are mined fairly often. "Its a broker fee, not something charged by the reorganizing company. E*Trade charge $20, TD Ameritrade charge $38. As with any other bank fee - shop around. If you know the company is going to do a split, and this fee is of a significant amount for you - move your account to a different broker. It may be that some portion of the fee is shared by the broker with the shares managing services provider of the reorgonizing company, don't know for sure. But you're charged by your broker. Note that the fees differ for voluntary and involuntary reorganizations, and also by your stand with the broker - some don't charge their ""premier"" customers." It is perfectly legitimate to adjust your 1099-B income by broker's fees.  Publication 17 (p 116) specifically instructs taxpayers to adjust their Schedule D reporting by broker's fees: Form 1099-B transactions.   If you sold property, such as stocks, bonds, or certain commodities, through a broker, you should receive Form 1099-B or substitute statement from the broker. Use the Form 1099-B or the substitute statement to complete Form 8949. If you sold a covered security in 2013, your broker should send you a Form 1099-B (or substitute statement) that shows your basis. This will help you complete Form 8949. Generally, a covered security is a security you acquired after 2010. Report the gross proceeds shown in box 2a of Form 1099-B as the sales price in column (d) of either Part I or Part II of Form 8949, whichever applies. However, if the broker advises you, in box 2a of Form 1099-B, that gross proceeds (sales price) less commissions and option premiums were reported to the IRS, enter that net sales price in column (d) of either Part I or Part II of Form 8949, whichever applies. Include in column (g) any expense of sale, such as broker's fees, commissions, state and local transfer taxes, and option premiums, unless you reported the net sales price in column (d). If you include an expense of sale in column (g), enter “E” in column (f). You can rely on your own records and judgment, if you feel comfortable doing so.  Brokers often make incomplete tax reporting.  This may have been simpler from their perspective if the broker fees were variable, or integrated, or unknown for a number of clients party to a transaction.  If a taxpayer has documentation of the expenses that justify an adjustment, then it's perfectly appropriate to include that in the calculations. It is not necessary to report the discrepancy, and it may increase scrutiny to include a written addendum.  The Schedule D, Form 8949, and Form 1099-B will probably together adequately explain the source of the deduction. "For any accounts where you have a wish to keep track of dividends, gains and losses, etc., you will have to set up a an account to hold the separately listed securities.  It looks like you already know how to do this.  Here the trading accounts will help you, especially if you have Finance:Quote set up (to pull security prices from the internet). For the actively-managed accounts, you can just create each managed account and NOT fill it with the separate securities.  You can record the changes in that account in summary each month/year as you prefer. So, you might set up your chart of accounts to include these assets: And this income: The actively-managed accounts will each get set up as Type ""Stock.""  You will create one fake security for each account, which will get your unrealized gains/losses on active accounts showing up in your trading accounts.  The fake securities will NOT be pulling prices from the internet.  Go to     Tools -> Securities Editor -> Add and type in a name such as ""Merrill Lynch Brokerage,"" a symbol such as ""ML1,"" and in the ""Type"" field input something like ""Actively Managed."" In your self-managed accounts, you will record dividends and sales as they occur, and your securities will be set to get quotes online.  You can follow the general GnuCash guides for this.   In your too-many-transactions actively traded accounts, maybe once a month you will gather up your statements and enter the activity in summary to tie the changes in cost basis.  I would suggest making each fake ""share"" equal $1, so if you have a $505 dividend, you buy 505 ""shares"" with it.  So, you might have these transactions for your brokerage account with Merrill Lynch (for example): When you have finished making your period-end summary entries for all the actively-managed accounts, double-check that the share balances of your actively-managed accounts match the cost basis amounts on your statements.  Remember that each fake ""share"" is worth $1 when you enter it.  Once the cost basis is tied, you can go into the price editor (Tools -> Price Editor) and enter a new ""price"" as of the period-end date for each actively-managed account.  The price will be ""Value of Active Acct at Period-End/Cost of Active Acct at Period-End.""  So, if your account was worth $1908 but had a cost basis of $505 on Jan. 31, you would type ""1908/505"" in the price field and Jan. 31, 2017 in the date field. When you run your reports, you will want to choose the price source as ""Nearest in Time"" so that GnuCash grabs the correct quotes. This should make your actively-managed accounts have the correct activity in summary in your GnuCash income accounts and let them work well with the Trading Accounts feature." Perhaps you should use your own tracking software, such as GnuCash, Quicken, Mint, or even Excel.  The latter would work given you say you're manually putting in your transactions.   There's lots of pre-done spreadsheets for tracking investments if you look around.    I'm hoping that a web search gets you help on migrating transaction data, but I've yet to run into any tools to do the export and import beyond a manual effort.  Then again, I haven't checked for this lately. Not sure about your other questions, but I'd recommend you edit the question to only contain what you're asking about in the subject.