understanding QFX file structure

Options

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?

Comments

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Options

    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
    Chris_QPW Member ✭✭✭✭
    Options

    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

    Signature:
    This is my website: http://www.quicknperlwiz.com/
This discussion has been closed.