Home → Investments →

QFX import problem

• Edit

mike

07 Feb, 2021 08:57 PM

When I try to import a .qfx from my section 457 retirement account, Moneydance only sees the number of shares. It doesn't see the share price in the file, but instead shows 100 or 10000, depending upon the fund. It also doesn't show any dollar amount. (See attached screenshot)

The file does not include the cash amount, but it does include the number of shares. (.qfx snippet below)
          <TRANSFER>
            <INVTRAN>
              <FITID>71879910E792545033</FITID>
              <DTTRADE>20191023000000.000[-6:MDT]</DTTRADE>
            </INVTRAN>
            <SECID>
              <UNIQUEID>09257F842</UNIQUEID>
              <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
            </SECID>
            <SUBACCTSEC>OTHER</SUBACCTSEC>
            <UNITS>-0.071611</UNITS>
            <TFERACTION>OUT</TFERACTION>
            <POSTYPE>LONG</POSTYPE>
            <UNITPRICE>21.086146</UNITPRICE>
          </TRANSFER>
:
How can I troubleshoot this? Is the .qfx file not complying with the standard?
Thanks,
-Mike

• Screenshot_2021-02-07_14-46-01.png 7.35 KB

1. 1 Posted by Stuart Beesley ... on 07 Feb, 2021 09:02 PM

   

   What version of MD?
   Step 1, Menu Help>Show Console.. Leave this console window open and then try the import again. You will get extra messages in the console to debug...

   (not support, just a fellow user)

   • Edit

2. 2 Posted by mike on 07 Feb, 2021 09:33 PM

   

   Moneydance version: 2021 (2006)

   The console shows the share price from the file, though the decimal point is in the wrong place:

   stored fields InvestFields[txntype=SELL_XFER dt=20191023 taxdt=20191023 chknum= payee= memo= status=UNRECONCILED amt=0 shares=71611 price=210861.46 sec=Mike's WDC2:BlackRock Russell 2000 Index Fund M cat=Mike's:Asset Fee xfr=AMEX Escrow Savings feecat=Mike's:Asset Fee fee=0 as txn [ParentTxn(null) 20191023 desc=; val=0; stat= ; #splits=2; chk=; acct=Mike's WDC2; dirty; splits=SplitTxn: val=-71611; amt=0; desc=; stat= ; cat=Mike's WDC2:BlackRock Russell 2000 Index Fund M; tags=[(samt:-71611)(acctid:7639d24d-d0ce-4b60-b8c5-9ceeefaddbf7)(invest.splittype:sec)(id:7d12e43d-e144-4545-b324-2caf88445c0d)(pamt:0)(desc:)];dirty; ], SplitTxn: val=0; amt=0; desc=; stat= ; cat=AMEX Escrow Savings; tags=[(samt:0)(acctid:e7e0c83c-79f9-49c7-8dfc-35b204d7aa14)(invest.splittype:xfr)(id:3e0aff9b-750a-4ff6-a377-39b666bd204a)(pamt:0)(desc:)];dirty; ], ; ]
   logging txn; file: tiksync/out/20210207210912_152.txn-tmp

   • Edit

3. 3 Posted by mike on 12 Feb, 2021 02:15 AM

   

   Is it unusual for an investment QFX file to omit the dollar amount in a transaction? I don't have any other investment accounts that export QFX to compare it to.

   Does the line from the console shed any light on the problem? I don't know if it is normal for the decimal point to be missing (shares=71611) or in the wrong place (price = 210861.46)

   Thanks,
   -Mike

   • Edit

4. System closed this discussion on 14 May, 2021 02:20 AM.