Why does Quicken show a mismatch of -.001 for bonds downloaded from Vanguard?
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.
Answers
-
How did you record that bond acquisition? What are the specific details of that transaction?
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
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.
1 -
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
Quicken user since version 2 for DOS, now using QWin Biz & Personal Subscription (US) on Win10 Pro.
2 -
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.
0 -
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.
0
