nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

understanding QFX file structure

Wiley Won

My wife's 401K at work is hosted by a lame outfit called Northwest Plan Services. They produce only 4 statements per year. The only downloads are manual using CSV or QFX.

Today I noticed that our last downloaded transaction was 2/1/2024, so I requested a file covering 2/2/2024 to 4/21/2024 and received a QFX file consisting of 454 lines. Online I see 10 transactions in that range but, when I import it into Quicken, I get "There are no new transactions. However, investment balances and holdings have been updated. (OL-96-A)".

I've tried deactivating online services for that account in Quicken. When I import the same QFX file, Quicken asks me to create a new account. Yet, I still get the OL96A error.

When I download the data in CSV format, there are 65 lines including buys, sells, and reinvests. Oddly, the fees aren't mentioned.

When I examine the QFX file, I see 12 blocks of code that look like this:

<POSMF>
<INVPOS>
<SECID>
<UNIQUEID>92204A827</UNIQUEID>
<UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
</SECID>
<HELDINACCT>OTHER</HELDINACCT>
<POSTYPE>LONG</POSTYPE>
<UNITS>236.0280</UNITS>
<UNITPRICE>126.77</UNITPRICE>
<MKTVAL>29921.27</MKTVAL>
<DTPRICEASOF>20240419000000</DTPRICEASOF>
<INV401KSOURCE>PRETAX</INV401KSOURCE>
</INVPOS>
</POSMF>

and 16 that look like this:

<MFINFO>
<SECINFO>
<SECID>
<UNIQUEID>233203843</UNIQUEID>
<UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
</SECID>
<SECNAME>DFA US Small Cap I</SECNAME>
<TICKER>DFSTX</TICKER>
<FIID>DFSTX</FIID>
<UNITPRICE>43.37</UNITPRICE>
<DTASOF>20240421111353</DTASOF>
<MEMO>DFA US Small Cap I</MEMO>
</SECINFO>
</MFINFO>

but none that include an FITID. I feel like this is just a bunch of quotes, but no transactions.

What am I looking at?
Should I conclude that NWPS has sent me an incomplete QFX file?

Find more posts tagged with

Comments

q_lurker

I can’t say it is incomplete because I don’t know what they intended to send. What you are seeing are your holdings in that account as of 4/21/2024.

236.028 shares of a security with the CUSIP of 233203843 and a current market value of $29,921.27, and 11 other holdings

The Second blocks relate the CUSIP ids to the names of specific securities and should be repeating the price per share.

Make sure your dates specification was correct. They may have understood you to just want today’s holdings snd transactions.

Chris_QPW

What is see here is what I call the "investment summary" section of the QFX, as in no transactions, just a summary of the security positions you have at a given time. This would relate to what Quicken now calls the "simple investment mode".

For reference here is what a mutual fund buy would look like:

                <BUYMF>

                    <INVBUY>

                        <INVTRAN>

                            <FITID>230590534

                            <DTTRADE>20100923160000.000[-5:EST]

                            <DTSETTLE>20100924160000.000[-5:EST]

                            <MEMO>BUY

                        </INVTRAN>

                        <SECID>

                            <UNIQUEID>461418691

                            <UNIQUEIDTYPE>CUSIP

                        </SECID>

                        <UNITS>97.276

                        <UNITPRICE>10.2800279

                        <TOTAL>-1000.0

                        <SUBACCTSEC>CASH

                        <SUBACCTFUND>CASH

                    </INVBUY>

                    <BUYTYPE>BUY

                </BUYMF

And it would be in this section:

            <INVTRANLIST
            …
             </INVTRANLIST>

A QFX file is essentially a OFX file with a few more fields so you if you really interested in it you can find the specifications for it here:

https://financialdataexchange.org/FDX/About/OFX-Work-Group.aspx?WebsiteKey=deae9d6d-1a7a-457b-a678-8a5517f8a474&hkey=f6ef5a03-c596-49a4-a89a-3f368e1ee43f&a315d1c24e44=2#a315d1c24e44