tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/5703-qfx-import-problemInfinite Kind: Discussion 2021-05-14T02:20:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/490202552021-02-07T20:57:29Z2021-02-07T20:57:30ZQFX import problem<div><p>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)</p>
<p>The file does not include the cash amount, but it does include the number of shares. (.qfx snippet below)<br>
71879910E792545033 20191023000000.000[-6:MDT] 09257F842 CUSIP OTHER -0.071611 OUT LONG 21.086146 : How can I troubleshoot this? Is the .qfx file not complying with the standard?<br>
Thanks,<br>
-Mike</p></div>miketag:infinitekind.tenderapp.com,2009-01-14:Comment/490202552021-02-07T21:02:20Z2021-02-07T21:02:20ZQFX import problem<div><p>What version of MD?<br>
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...</p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490202552021-02-07T21:33:09Z2021-02-07T21:35:56ZQFX import problem<div><p>Moneydance version: 2021 (2006)</p>
<p>The console shows the share price from the file, though the decimal point is in the wrong place:</p>
<p>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; ], ; ]<br>
logging txn; file: tiksync/out/20210207210912_152.txn-tmp</p></div>miketag:infinitekind.tenderapp.com,2009-01-14:Comment/490202552021-02-12T02:15:00Z2021-02-12T02:15:01ZQFX import problem<div><p>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.</p>
<p>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)</p>
<p>Thanks,<br>
-Mike</p></div>mike