Inconsistent Downloads of SPAXX Div from Fidelity

Geobrick

I started using Fidelity (brokerage not net benefits) in SEP 2024 and I found that the income dividends from SPAXX aren't downloading consistently. I have a few Fidelity accounts and they're all missing several SPAXX dividend transactions. Some months it's there and some it's not. It's not always the same months missing within each account. It seems arbitrary.

I'm using SPAXX (Fidelity Government Money Market) for the sweep and it's treated as cash in quicken (my preferred way of handling it).

It's frustrating to have to manually add these missed transactions. The OSU is supposed to do all that for us.

Here are some screenshots showing that some of the transactions are missing.
Online there's a SPAXX dividend at the end of each month between Sep 2024 and May 2025.
Missing below are January and March thru May 2025

In another account, the missing transactions are Oct, Dec, Jan, Mar and May.

These are all sorted by security name to group them all for the screenshot. All other transactions download into quicken without issue.

I've seen similar posts over the years but I have's seen a specific fix for this.

Quicken Jasmine

Hello @Geobrick,

Thanks for reaching out! In order to better assist you, I have a few questions.

1. Do you see any pattern related to the amount of the SPAXX dividend (i.e., are smaller ones more likely to be missed)?
2. If you go to Tools > Online Center, does the missing dividend show up in the download log for those months, or is it absent entirely?
3. Are the missing dividends present in Fidelity’s online activity export (CSV or PDF) for the affected date ranges?
4. Have you seen any difference in behavior if you deactivate and then reactivate one of the affected accounts?
5. Is your SPAXX security set up in Quicken with the correct symbol (SPAXX) and type as a mutual fund or cash equivalent?

These details can help determine whether this is a data feed inconsistency from Fidelity’s end or something in how Quicken is handling the import.

Let me know!

Geobrick

1. I don't see any pattern. The missed transactions seem arbitrary. For example, the missing Jan div in the first set is $81.86.
2. The online Center shows no downloaded transactions since 6/6/25. The missing transactions would normally be at the end of the month so it's not surprising they're not there. I've tried deactivating and reactivating the accounts. When I reactivated the accounts, it said it was downloading data from the last 602 days (and 900 days) but it didn't download any of the missing transactions. I checked the OFX logs and only saw one reference to SPAXX in the Old Log, "<UNIQUEIDTYPE>CUSIP</SECID><SECNAME>FIDELITY GOVERNMENT MONEY MARKET<TICKER>SPAXX<DTASOF>20250305033013.000[-5:EST]<CURRENCY>". I'm not sure what that is but it doesn't seem like a Dividend. There was nothing related to SPAXX in the current OFX log.
3. Yes. The missing transactions are shown in the online activity view and in the downloaded CSV file.
4. No. As I say in #2 above. The missing transactions didn't download after reactivating the accounts
5. Yes. It is set up in Quicken as SPAXX with the CUSIP 31617H102 as Mutual Fund. I don't know where/when/how it was set to be treated as a cash equivalent, but it does behave that way and that is my preference. Only the Dividend Transactions are downloaded (but not consistently).

My guess is that these transactions are missing during the direct connect because I don't see them in the OFX log.

Quicken Jasmine

https://community.quicken.com/discussion/comment/20493990#Comment_20493990

Thanks for providing more information.

First, to locate whether this problem is with Quicken or Fidelity, will you create a test file and attempt to add brokerage account(s) and facilitate a download to see if the same transactions are missing? You can create a test file by navigating to File > New Quicken File > Follow the prompts.

Let me know how it goes!

Geobrick

I set up the new file and added all the fidelity accounts to the new file.
It only downloaded transactions starting in March 2025 and there are a lot of placeholder transactions but every FIDELITY GOVERNMENT MONEY MARKET (SPAXX) dividend transaction from March, April and May was downloaded in all five Fidelity accounts in the new file. Everything looks good in the new file.

Geobrick

https://community.quicken.com/discussion/comment/20493993#Comment_20493993

I did the experiment you suggested and as I said above, every the SPAXX transaction between March 2025 and now downloaded properly into all 5 of my Fidelity accounts.

What does this experiment tell me? Does it mean there's a problem with Quicken or my Quicken files?

Geobrick

While waiting for an answer on what the test above tells me, I dug into the OFX logfile.

I can see that the SPAXX transactions are associated with the CUSIP 31617H102.

In the OFX log for the Test file, I see every transaction related to CUSIP 31617H102.
In the OFX log for my real file, I only see the 31617H102 transactions that quicken recorded (and they were only in the Old OFX log - there were none in the current OFX log).

I have to conclude that Quicken is importing all the transactions being sent by Fidelity. Now I need to find out why the OFX logs are randomly missing the SPAXX (31617H102) transactions. It seems this is a Fidelity problem. But how is it Fidelity provided the data to the new quicken test file but not to my real quicken file. That's the mystery.

CaliQkn

@Geobrick could it be a difference in file settings? If you click on Tools→Preferences→Downloaded Transactions, do each of the files have "Never interpret money market funds as cash" checked, or unchecked?

Geobrick

https://community.quicken.com/discussion/comment/20494272#Comment_20494272

There could be a difference in file settings since I created the test file using whatever quicken uses as the default (I didn't actively change any settings).

I looked at the setting for "Never interpret money market funds as cash" and both files have that unchecked.

It really seems that Fidelity isn't sending all the SPAXX transactions to my main file yet it sent them all to my test file. The only difference in my main file is that I exclude 3 of the 5 accounts when setting up the link to my main file (the other 3 accounts are linked in another file (where I exclude 2 of the 5 accounts). Both my main file and that 2nd QFX file have the problem with sporadically missing some (most) of the SPAXX dividend transactions while the test QFX file downloaded 100% of the 3 months of transactions in all five accounts.

Based on the OFX logs, it seems clear that Fidelity isn't including all the SPAX transactions in the downloads. Maybe it's something they fixed and that's why it all works now in the test file but then why didn't they download when I deactivated and reactivated the online access? Maybe I need to try that again.

If I can't find a way to get Fidelity to put the past transactions in their downloads, I won't be able to test this again until the next SPAXX dividends hit at the end of June.

CaliQkn

@Geobrick that is perplexing. I have never heard of an FI selectively filter transactions. Usually, the FI sends all transactions but they are not being posted on Quicken because of duplicate transaction IDs.

Geobrick

https://community.quicken.com/discussion/comment/20494343#Comment_20494343

Your mention of duplicate transaction IDs is interesting. Is the OFX log an exact representation of what the FI sent during the direct connect session or does the log only reflect the transactions that Quicken accepted (based on things like the unique transaction ID)?

CaliQkn

@Geobrick good question, and my answer unfortunately is "I don't know". You might want to contact Quicken Support to confirm. They have access to all the various logs and know how to interpret them. They might then be able to determine why duplicate transactions issues are happening.

Geobrick

Update:

Turns out the problem is not just SPAXX. Any transaction that happens at the end of a month is at risk of not downloading. I should probably change the title of this thread (or start a new one).

When I recently tried reconciling the account, I noticed more than just SPAXX dividends missing from the downloaded transactions. The one thing they have in common is they are always last day of the month transactions though it doesn't happen every month, it happens more often than not.

On January 31 2025, SPAXX, JPM and TD dividend were not downloaded (and not in the OFX log). On March 31, SPAXX. ITT, Marriott and Vitesse dividends were missing. On April 30, SPAXX and JPM Chase dividends were missing. On May 31, the SPAXX div and the sale of a stock didn't download.

Since these transactions are missing in the OFX log file, should I conclude this is a Fidelity issue?

NotACPA

I have multiple accounts at Fidelity Investments plus I manage the investments for a club.

Some of my accounts hold SPAXX, others FDRXX and several hold a bond fund. The club holds SPAXX and a couple of bond funds.

No problem with downloading month-end transactions in any of those funds using Direct Connect.

And, I reconcile Q to the printed statements every month … so I'm SURE that nothing's missing.

SO, when you do TOOLS, Account List, which Fidelity name is shown in the "Financial Institution" column … Fido has several names in Q. If that column isn't shown, it can be added via the OPTIONS button at the bottom.

On that same dialog, what shows as your Last Download date and "Transaction Download" method.

Because, barring further info, I'm suspecting a problem with your data file.

Geobrick

https://community.quicken.com/discussion/comment/20495509#Comment_20495509

NotACPA, Thanks for taking a look at this.

I also manage several accounts in separate QDF files (for family members). In my personal QDF, I have Fidelity accounts at both "Fidelity Investments - DC" and "Fidelity NetBenefits". The account list shows each Fidelity account linked to the correct Financial Institution (see modified screenshot below).

Suspecting a problem with the data file is reasonable and I want to explore that, but I have questions about Direct Connect and what the OFX log contains. My understanding is the OFX log shows all communications between Quicken and the Financial Institution so how would a QDF file problem prevent those end of month transactions to be missing? I don't know the mechanics of the protocol so maybe it's not just a data dump from the financial institution. The fact that the transactions are missing from the OFX log makes it hard for me to suspect the QDF file (but I can't dismiss the possibility). Two years ago, I had some issues so I ran Super Validate on the file and it had a damaged data block. I was able to fix that by using Quicken's "create copy a copy or template" to make a copy of the file then used that copy (after relinking the Financial Institutions). I then ran a super validate on the new version and it passed. So even though the file still passes the Super Validate test doesn't completely mean my issue isn't caused by some sort of data corruption.

Let me know what you think of this theory. I'm on the west coast and use OSU almost daily after 10 PM pacific time (sometimes even later into the early morning after midnight). Is it possible some of these end of month transactions haven't hit the account yet at Fidelity (so they don't download during that OSU). Quicken then sets the last download date and time for that session - let's say it's May 31. At some point, those end of month transaction hit the account but are still dated May 31. The next time I use OSU, Quicken starts with June 1st and never get the transactions from the financial institution that fell into the gap. Though, one thing that puts holes in that theory is that it only seems to happen at the end of the month. If there was any basis for the theory, I'd see missing transactions on other dates (unless Fidelity does a specific sort of account maintenance at the end of every month).

Here's a screen shot of my Account List:

NotACPA

"Haven't hit the file yet" is likely. I run Direct Connect from Fidelity Investments - DC at 7 am Central 6 days a week via "Scheduled Updates". They happen automatically as long as my computer is turned on.

Since you're running DC, the transactions should be in the OFX Log. Other download methods store the data elsewhere.

But, your statement about "Quicken starts at June 1" is, according to my understanding, incorrect. Q sends a request that basically says to the FI "send me what you've got" and it's via the FITID, which is maintained by the FI, that Q determines what's new (i.e., FITID doesn't match a prior) and shows the transaction. So, it is pretty much a data dump. Sometimes, a transaction can get downloaded with a new FITID, but not if you stay on the same connection method (i.e., you don't change from DC to, say, Web Connect).

And, I've never heard of Fidelity changing an FITID.

SO, I'd suggest that you start downloading in the morning rather than at night and see what happens with the upcoming month-end.

CaliQkn

@Geobrick I agree with @NotACPA regarding downloading in the morning rather than late at night. At 10:00 pm PT, you are downloading in the midst of most financial institutions overnight processing time. For most major banks and financial institutions, the processing centers are located on the east coast. Even Wells Fargo Bank which is headquartered in CA, has their major processing center located in Charlotte NC. So that means that these centers cannot start processing the current day's work until after 12:00 am ET (9:00 pm PT). When you download transactions at 10:00 pm PT, you may only get a partial download of transactions. I have had this happen to me, but I was always able to download the remaining transactions in the morning. But there is no guarantee that that will always be the case.