How do you reconcile ESPP and RSU for the same company?

mikek753b

hello,

How to reconcile ESPP and vested RSU for the same company?

The brokerage reports the total shares number, while in the Quicken I have as a split between Company Stock shares and ESPP shares, as result I got Security Comparation Mismatch.

I see this is due to required separate Security name for the ESPP type, even the ticker is the same.

How to address this mismatch?

Can Quicken reconcile shares based on the ticker / Symbol instead of Security logical Name?

NotACPA

Are you holding, in Q, these shares in the same account? Are you downloading into the account? At the broker, do they show in the same account?

mikek753b

Yes, the same account, the same broker schwab.

Yes, at the broker those shows as single symbol, while in many Lots.

Yes, I auto download from schwab, including this account, that is just for a company, while my trading account is another one.

Originally RSU and ESPP were in Equity Award account, but were transferred to brokerage account for trust estate reasons.

I have all required info for each transaction, it's just reconciliation error in Quicken that I hope can be addressed.

Tom Young

Am I understanding this correctly?:

• Within a Quicken brokerage account you have "X" ESPP shares and "Y" RSU shares for a total of "Z" shares.
• The account at Schwab also has Z number of shares
• After downloads Schwab reports Z shares and Quicken reports a comparison mismatch because Y doesn't equal Z

Another question: All the shares in this Account are actual shares you own at this point the RSUs having vested and you having exercised the ESPP share options?

I don't believe Quicken is doing its comparison based on the names assigned in Quicken, I'd expect that comparison is based either on the CUSIP number. Do all the shares in the Quicken Account report the same CUSIP, or not?

mikek753b

no, Quicken doesn't reconcile based on the CUSIP and this is the issue, but by Security Name.

The Quicken requires to name ESPP as different Security, while the symbol is the same as RSU or plain Stock.

The Quicken has another type for the ESPP as ESPP, even the Symbol is the same.

No, I don't want to chance ESPP type to Stock type, as I don't want to loose Tax related info very specific to ESPP type.

Chris_QPW

This sounds like one those "Hey, we never thought about that" moments for when they implemented the new RSU code.

And I would guess that the workaround would be to turn off/ignore the comparison and do the share reconcile "old school" where you just look at them/add them up, if need be, by setting the right date on the portfolio view.

I have never had any RSUs let alone any recently so that the new feature is being used.

In the case of my ESPPs, ESOs, and RSAs from the distant past if I remember correctly none of this could be downloaded so I manually entered them, and I used different accounts for each. As such reconciling was never a problem for me.

It is interesting that from your description the RSUs aren't treated separately. It is pretty clear that when the ESPP, ESO, … wizards and functionality was created they created some kind of "backdoor" accounting of these and needed a way to keep them separate because they aren't the same thing.