security prices for transfers are set to 100

Jeff W's Avatar

Jeff W

25 Mar, 2019 03:08 AM

I am importing from Vanguard retirement plans, and all the transfer transactions created in Moneydance have a price of 100 instead of the correct price. I was using Online Banking but the same problem occurs when I import an OFX downloaded from Vanguard's web site.

Here is the relevant transfer entry from the OFX file (reformatted as nice XML):

          <TRANSFER>
            <INVTRAN>
              <FITID>24526201903070023331001457AAA</FITID>
              <DTTRADE>20190306160000.000[-5:EST]</DTTRADE>
              <DTSETTLE>20190307160000.000[-5:EST]</DTSETTLE>
              <MEMO>Investment Expense</MEMO>
            </INVTRAN>
            <SECID>
              <UNIQUEID>92206J206</UNIQUEID>
              <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
            </SECID>
            <SUBACCTSEC>CASH</SUBACCTSEC>
            <UNITS>-0.009</UNITS>
            <TFERACTION>OUT</TFERACTION>
            <POSTYPE>LONG</POSTYPE>
            <UNITPRICE>20.51</UNITPRICE>
            <INV401KSOURCE>PRETAX</INV401KSOURCE>
          </TRANSFER>

In Moneydance, a SellXfr transaction is created with the correct shares value, but a price of 100.

I can reproduce with both version 2019.1 (1855) and the latest preview, 1860.

  1. 1 Posted by Jeff W on 15 Jun, 2019 09:11 PM

    Jeff W's Avatar

    In case anyone else has this issue, the answer I got from Moneydance support is that the OFX doesn't contain a total amount for the transaction (i.e. UNITS times UNITPRICE) so it assumes an amount of 0, then ignores the price from the OFX.

    However, the TRANSFER type in OFX doesn't have an amount field, so it's not possible to "fix" the OFX to work around the issue. After several months of repeated long silences from Moneydance support I gave up asking whether they can fix the issue.

  2. System closed this discussion on 14 Sep, 2019 09:20 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac