Why does Quicken show a mismatch of -.001 for bonds downloaded from Vanguard?

mtbdog

This has been happening for well over a year, maybe longer. Quicken shows a Securities Comparison Mismatch. I've been ignoring/accepting it until this moment.

For instance, Shares Reported: 189.999, Shares in Quicken: 190, Difference: -0.001.

My accounts are with Vanguard. Quicken version is 27.1.58.9, but this has been happening for many versions. It's not happening with stock, mutual fund or ETF holdings.

There are lots of Vanguard users on this board, but I haven't been able to find anyone experiencing the same problem.

Appreciate any thoughts or suggestions about this.

NotACPA

How did you record that bond acquisition? What are the specific details of that transaction?

markus1957

I see it also on occasion, but today they all match. I seem to recall looking at the OFX log once before and it was Vanguard misreporting the Long>Units in the OFX file.

You can verify it by looking in your OFX log which can be accessed under the Help menu, Contact Support, Log Files. It's an ugly log file to wade thru. I suspect you will see the problem holdings being reported with xxxx.999 units. I'll check again next time I notice. You can turn off the Compare option for Vanguard if it annoys you. But again, you would need to contact Vanguard as they are providing an incorrect OFX download file some of the time.

Rocket J Squirrel

It's an ugly log file to wade thru.

There's an OFX formatter (written long ago at Intuit) which makes it a little less ugly. You drag'n'drop the OFXLOG.txt file's icon onto the formatter's icon and out pops an OFXLOG.tab file with proper indentation. I keep it on my Dropbox.

https://www.dropbox.com/scl/fi/vc9yvi5mmjeafvpcdobur/OFXFormatter.zip

mtbdog

NotACPA: T-bills and agency bonds, with transactions and securities downloaded from Vanguard the next day. Actually, I believe the security gets downloaded the day after purchase, but the transaction isn't reported until settlement date. (Hope that makes sense.). That's about as much as I can tell you cuz there's not much to it.

mtbdog

https://community.quicken.com/discussion/comment/20450360#Comment_20450360

Thanks for this info. I'll contact Vanguard and see if they're aware of it also. It's not a huge problem by any means - minor annoyance. Just wondering if anyone has seen it and might have a solution.