Schwab - wrong transaction dates

K123

Ditto. No change. Four months. No progress.

Attn Quicken: I implore you to stop the finger pointing at Schwab, etc. and fix the problem. This is your product, and we are paying you, so Quicken is ultimately responsible for the fix.

Request (again) an update on the issue.

Wil

Darn. Was hoping it was the DST thing. Trying not to complain … but this is ridiculous.

Nothing but foot dragging & finger pointing from these two (Schwab & Quicken). Look at this board! Months of serious people taking the time to report and share details about this issue … writing in to elevate it … those with coding skills trying to help illustrate and troubleshoot the problem … all we want is a FIX NOW.

I am doing my bit … transferring an account from Schwab to Fidelity.

Rick8

Same with my Monday 11-4 transactions, divs, etc. all dated Sunday 11-3-24. Quicken needs to fix this now.

veegee

@Bill44 Some questions for you. Can anyone access these Schwab APIs, or only limited users specifically approved by Schwab? How difficult is to get approved, if that is the case? Also, are you accessing from a C# .NET application? Does Schwab docs provide sample usage docs for this?

veegee

Took a real quick look at downloading data manually from Schwab.com and transferring to Quicken.

There appears to be no easy way to do this. None of the export formats of Schwab.com transaction history - .CSV, JSON, XML - can be imported into Quicken. Even if one could write a program to translate the data from the Schwab [CSV,JSON,XML] formats into a .QFX or .QIF file for Quicken ( and this would be no easy task ), when importing the data into Quicken, it will end up in the register, not in the 'downloaded transactions list'. And multiple imports of the same data will result in duplicate register entries.

Schwab should at least support exporting to the industry standard OFX format, it does not appear to do so.

Quicken should support importing from the industry standard OFX format also - not clear if it does.
(Quicken QFX is a minor extension of OFX, so possibly renaming an OFX file to QFX file and importing may work - I don't have a way to test this.)

Note: This was only quick look. Many people may have more extensive knowledge of these transfer methods.

Bill44

Schwab access is at:

Charles Schwab Developer Portal

You can use whatever language you would like. .net as well as many others.

Check out Discord.com schwab-py. This would provide help. It talks about a python interface. The help pretty much applies to all languages.

This would be the easiest if starting from scratch.

veegee

Thank you, @Bill44 . Will try to give it a shot when I have some time.

smutschler

I thought I'd share my download matching technique, for those who may not have discovered this semi-workaround. This works whether you enter transactions manually into the register before downloading (and then using "Match" to the entries) or whether you use the download to create the transactions in your register. I will address each method separately.

1. Manual entry followed by download and Match: In this case your downloaded brokerage transactions will show as "Near Match" due to the date difference. If you Accept a Near Match, the system will change the date on your register transaction to the incorrect date from the download. So, instead, select a downloaded transaction, which will highlight the near matching transaction in the register. Change the reconciliation field (drop down) on the register transaction to "Cleared". Now, click on the Edit button beneath the downloaded transaction (in the download panel) and select "Delete" on the pop-up menu. This deletes the downloaded transaction while simultaneously recording your reconciled (now "matched") register transaction (as if you had pressed the Return key).
   
2. If using the download to create your register transactions: Select a downloaded transaction. This will create the transaction in the bottom register line. The transaction will have the reconciliation field set to "Cleared", as it should. Manually alter the date on the transaction (to one day later of course). Now, click on the Edit button beneath the downloaded transaction (in the download panel) and select "Delete" on the pop-up menu. This deletes the downloaded transaction while simultaneously recording your newly created register transaction (as if you had pressed the Return key).

Yes, it is a pain in the butt workaround with a few extra mouse clicks, but it results in a correctly dated transaction in the register that does not need to be edited again.

K123

Reply to smutschler: Your matching technique #2 is what I've been doing. It's annoying having to do the manual deletions of the downloaded entries, but at least I don't have to go back in and edit the register transaction again.

Rick8

HEY - QUICKEN!! HOW ABOUT AN UPDATE ON YOUR PROGRESS WITH THIS?

THANKS!

ronwalter

HEY - QUICKEN!! HOW ABOUT AN UPDATE ON YOUR PROGRESS WITH THIS?

THANKS!

Stu

HEY - QUICKEN!! HOW ABOUT AN UPDATE ON YOUR PROGRESS WITH THIS?

THANKS!

Would it help for us to apply pressure to Schwab? Give us some guidance.

vaporchemist

I think we should ask for an extension on our subscriptions given this huge inconvenience. Perhaps seeing some lost dollars will stimulate some activity.

malloc

https://community.quicken.com/discussion/comment/20460475#Comment_20460475

My subscription is up at the end of the month, I plan on bringing this bug up when im forced to call support to cancel the auto renewal.

smutschler

HEY - QUICKEN!! HOW ABOUT AN UPDATE ON YOUR PROGRESS WITH THIS?

THANKS!

veegee

@smutschler , I have been using 2 - with the exception that I
a) change the date,
b) specify the lots if needed,
c) accept the transaction into the register, then
d) delete the transaction in the download list (which should have a 'near match' at this point).

In my Quicken Classic Deluxe Windows, Quicken will not let me do step d before step c like you seem to be able to do. Perhaps you have a different version of Quicken?

One side benefit of being forced to do this whole workaround is that the accepted transaction gets deleted in the download list, thus reducing clutter in that list. Which I like because I don't have to keep scrolling as much and which is a feature I have always wanted (i.e. a button to clear accepted transactions in the download). The only way before was to do another download, which then would clear the accepted transactions from the download list.

smutschler

@veegee, I am using Quicken Classic Business and Personal, Windows.

I have "Automatic Add Downloaded Transactions" set to OFF (for both banking and investments).

I have automatic Lot choice set to "First Shares In for Equites" on all investment accounts, so I am never prompted for Lots on sales (when entering directly on a register line… may be prompted if entering in the larger, detailed transaction entry window).

veegee

@smutschler, ha the "automatic lot choice" may explain the different behavior (I always match the lots manually). Unless it the Quicken Deluxe' vs Quicken Business & Personal' version difference.

Rick8

HOW ABOUT IT QUICKEN - ANY UPDATE WOULD BE APPRECIATED. WE ARE PAYING FOR THIS TO WORK PROPERLY! Your record of transactions downloads working with Schwab over the past year is abysmal. Not even counting the debacle with them all last summer, but it never works perfectly more than 3 days in any given week!!! Lets get this fixed once and for all, PLEASE!

smutschler

@veegee, I meant to get back to you regarding an earlier post where you said you had to "Download again" to clear Accepted download transactions. I don't understand or that sounds like a problem. After I have Accepted all the downloaded transactions, a DONE button at the bottom of the download window is enabled. Clicking that button clears all the transactions from the download list, leaving an empty window.

Do you not see that DONE button? All remaining transactions in the download window have had to have been Accepted in order for it to appear.

veegee

@smutschler, After I have accepted all the transactions, yes, I can do Done. But it is during the process of accepting the transactions that this is an issue for me. It may not be an issue for most people since they may not have a large number of transactions.

In my case, I have a large number of transactions that get downloaded (I am an active trader, and it is not unusual to have 40+ transactions downloaded per day). I accept transactions in time order, while matching them with entries on the Schwab website as well as my own tracking I do. This means I am scrolling up and down the downloaded list (because they are not in time order). It is very helpful if I can 'clear' the accepted transaction from the download list which will reduces the size of the download list. Having an accepted transaction in the download list has no value for me.

Often times, I will do 're-download' in the middle of accepting the downloaded transactions - this tend to clear out the accepted ones and leave the ones still remaining to be accepted. But having a simple 'Clear Accepted' button will be so much a better option.

Hopefully I have explained the situation well enough (?)

veegee

@smutschler , also, please note that my reply to your comment (and my other comments as well) often take a day or longer to appear publicly since * for some unknown reason * they have to be approved by the moderator first. No idea why I get such great special treatment :-), but whatever.