Problem importing data from Vanguard

Help
1

Vanguard does provide both OFX and CSV download files, and I recently tried importing on OFX file, but got “Caught exception from processTransactionEntry() not caused by USERABORT: Cannot add split where sign of shares differs from sign of value to transaction /var/tmp/portage/app-office/kmymoney-9999/work/kmymoney-9999/kmymoney/mymoney/mymoneytransaction.cpp:209”. I then tried importing the CSV file with the same data, and after getting a similar error, noticed that each dividend reinvestment transaction (at least in the csv file, I did not pull apart the OFX) is represented as two transactions: one “Dividend Reinvestment” with positive shares and price but negative amount, and the other “Devidend Received” with 0 shares, 1 price, and positive amount (same value as the first transaction amount.)

This is somehow sounding familiar to me, but I think it is not the case where a transaction did get imported, but showed an error until you edit and save the transaction (without changing anything) which I have not had recently.

Is this familiar to anyone? Has anyone succesfully imported transactions from Vanguard within the past months? Is my best approach (at least short term) to just edit the CSV, removing the extra rows and reversing the sign of the remaining ones?

2

There is an option to revert the sign of a transaction. Does that help?

3

Well color me even more confused. I had forgotten about that setting, and before trying it, I just tried to import the qfx file again - and it worked. However, I’m on my laptop, not at home, so I’ll have to see if it works at home. (I also need to confirm both are built from same commit.) I’ll update later today.

As a side note, the csv file is even worse than I thought - for a number of dividend reinvest transactions it appears both records have 0 shares, but I’ll deal with those separately, hoping that I can, in fact, use the OFX import.

4

To confirm, ticking the box to reverse the sign allowed full import. I can’t fully confirm everything is correct until I go through reconciliation to cover all these months of neglect. I also need to confirm why the laptop imported ok without checking that box, unless it got checked without my noticing. (I consider that quite possible these days.)

I forget if that setting is available in the OFX import details when editing the Account. If so, I need to be sure that is mentioned on the wishlist about being able to set OFX import details even if there is no online mapping for the account.