roboaccount or direct index account support

With the advent of index accounts traded by algorithms, account complexity and transaction volume go up dramatically. IMHO, documenting such accounts is foolhardy WITHOUT the use of Quicken or a database. My Schwab EAFE direct index has had 5500 transactions since 10/15/24. My Schwab 1000 direct index likewise has done 5630 since 08/08/23. Statement pdfs and trade confirmation pdfs are grossly inadequate to the task. I see this as a sales brochure for the use of Quicken. It is a must have, not a might be nice if.

Although only a few million folks use these accounts, I suspect sell through would be high.

But it has to work flawlessly, which it currently does not. Very close though.

The remainder of this post covers the 3 things I have seen between current and desired: positive tax adjustments for fairly common errors with ex-US taxes, uncategorized transactions for Foreign Taxes and ADR fees, and cash handling idiosyncrasies related to Schwabs use of SWGXX/SWVXX as cash (dividends import as zero)

Tax adjustment:

Rather than have revised transactions imported as miscellaneous income, it would be more accurate to record them as positive taxes/negative taxes. This way it will tally with 1099's better.

It is shown above with DIFTY/WIZEY/GMAB getting ADR payment adjusted. Each of them had a prior transaction of the same value that was a debit, and then following with a final debit of the corrected amount. This happens with foreign taxes too.

Uncategorized transactions:

Since international stocks pay a much higher amount of dividends, and have more frequent dividend payments (with corresponding tax and adr fee transactions) this is much more critical for my exUS account. Some way to evaluate the guesswork and limit my manual categorization is critical.

SWGXX/SWVXX (schwab specific issue)

I am aware of this idiosyncratic behavior and put this last for a reason, it only needs manually corrected once a month. Quicken identifies SWGXX as dividend income correctly, but imports the amount as zero. I suspect this is because there is no purchase transaction. As an experiment, I entered a placeholder of 0.00001 shares of SWGXX purchased which rounds to zero. I will see in a few weeks if this convinces quicken to import the actual dividend.

There are some international oddities that are probably too challenging and will remain manual corrections. I had a 19/20 stock split, change of symbol, cash in lieu for fractional shares, and spinoffs as stuff I think is just too hard.