QP2005, Strange Recording of Investment Dividends and Fees

The code that creates the csv file is not necessarily (and unlikely to be) the same code that creates the QFX file; I think you would need to look at the OFX data from your Quicken download to be certain that you know what Vanguard is sending you. As MikeB said, you can see that, even for a direct download, by checking the ofxlog file from Quicken Help. It is a bit more cumbersome than viewing a qif file, but doable.

Reply to
John Pollard
Loading thread data ...

OK, how do I look at what's in the OFXLOG ... from Quicken Help? I searched the index for OFX and OFXLOG, and it came back with nada.

Regards,

Margaret

Reply to
Margaret Wilson

Help > Product and Customer Support > Troubleshooting/OFX log

Reply to
John Pollard

Appropos to my previous contribution to this thread, I completely forgot that I have started investing in a new Vanguard fund this past quarter. In today's download I got hit with the $2.50 acct. maint. fee, which I have also forgotten about, otherwise I'd have put more money into the fund.

However, I noticed that it was treating it differently than any of my older downloads, and also differently than what you describe, so perhaps they have already fixed it. The reinvestment is now 3 transactions, one reinvestment, one investment income and one fee withdrawal.

Reply to
Mike B

No, that's how it was in the first place. Somewhere during my investigation, I forced it to redownload those transactions, and that's when I remembered I had played with the transacations trying to make it all balance. So in my first message, I incorrectly described the transactions. In almost all of my subsequent messages, I correctly laid out the three transactions. Once again, they are:

ReinvDiv - this is the offending transaction, because it uses the gross transaction amount (that is, including the $2.50 fee) with net shares (after the fee is removed), and the resulting share price that Quicken calculates is artificially high as a result. This is WRONG, because Vanguard takes the fee *before* reinvesting the dividend. That's why the next Div $2.50 transaction is necessary. That leaves a cash balance of $2.50, so the Withdraw transaction of $2.50 is necessary.

Div $2.50 (account maint fee) Withdraw $2.50 (account maint fee)

Please look at that first transaction carefully. If the transaction is using net shares, then they've fixed it. You can also look at your price history to see if the fund has an unusually high share price on the date the ReinDiv transaction took place.

Regards,

Margaret

Reply to
Margaret Wilson

OOPS, my last paragraph should read as follows:

Reply to
Margaret Wilson

Thanks, I'll check as soon as I can, but unfortunately I've uninstalled Quicken and am battling to clean up my machine a bit. I'm actually suffereing from Quicken withdrawal symptoms!

Reply to
Mike B

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.