|
#1
| |||
| |||
| In microsoft.public.money, Tom Hornbach wrote: - quote - > I had a similar problem with Vanguard and MS Money. The
I agree on the strange definition of what an "account" is.> basic problem is that Vanguard and Microsoft have two > different incompatible definitions of what an "account" is. - quote - > [I think MS's is more appropriate, but still not
duplicated. I had noticed another flaw: The Vanguard OFX file lacks> correct.] Basically Vanguard has the MS concept of > an "account" overloaded. You may think that the Vanguard > account # is unique to each Vanguard fund you have, but it > is not. In one case Vanguard calls your IRA and > Individual Funds accounts two accounts. However, each of > these Vanguard "accounts" could have multiple funds in > them. Any or all of the funds, even across IRA and > Individual accounts, could potentially have the > same "account" number. When this happens MS Money assumes > that all "funds" with the same "account number" belong to > the same MS Money "account" and will combine them, > especially when using the "direct" statement method of > connection. <snip I had not previously noticed that the account numbers had been <ACCTINFO> <INVACCTINFO> ... </INVACCTINFO> </ACCTINFO> tags -- and maybe more. See http://groups.google.com/groups?hl=e...2809f0699dab4c - quote - > My solution was to have Vanguard transfer all of my funds
I can't verify that portion of your observations. In the> such that each ended up with a unique Vanguard "account" > number; note EACH fund! The fund number is NOT part of > the "account" number transmitted to MS Money on download; > so if you have, for example, a PMMF and a TEMMF with the > same "account" number but different fund numbers, you have > to have Vanguard change one of them. "Vanguard nnnnnnnn RQ.txt" request file I see <ACCTID> nnnn-nnnnnnnnnnn where "n" represents a digit. The first 4 digits are the fund number. However where the same fund is in two Money-style accounts, I see the same <ACCTID> nnnn-nnnnnnnnnnn for each. To get the "Vanguard nnnnnnnn RQ.txt" and "Vanguard nnnnnnnn RS.txt" files, proceed to get online statements. But when you see the Connect button, hold down the Ctrl+Shift keys as you click Connect. Find the files in the same folder as your Money file. - quote - > Of course the simple solution for Vanguard would be to
That would be part of it-- add in the "Account Type" to what they> concatenate the Vanguard "Fund number", "account number", > and "Account Type (e.g., IRA, Individual) to make them > unique and then download this "real unique account number" > as the account number to MS Money are doing. Then a Roth and a Regular would have unique account numbers. I would rather see them use the paradigm where an account can contain more than one fund, but their separate "account" per fund concept is tolerable. - quote - > ... but do you think
I seriously doubt that will happen.> Vanguard could do this? NO WAY ... they can't even print > the statement date on the first page of my monthly report > and I'm one if their "high rollers." Vanguard needs a > customer oriented web-team ... their customer service > telephone agents don't even know how to contact the web- > support team (they're probably doing training in India now > anyway.) They are spending big bucks to changes hundreds > (thousands) of customer accounts instead of spending 1- > programmer day to fix the problem correctly in the 1st > place. I wonder if Vanguard is "really" the low cost > provider? > Hope this helps ... hope the flame gets Vanguard off their > duffs. |
| | |||
| |||
| I had a similar problem with Vanguard and MS Money. The basic problem is that Vanguard and Microsoft have two different incompatible definitions of what an "account" is. [I think MS's is more appropriate, but still not correct.] Basically Vanguard has the MS concept of an "account" overloaded. You may think that the Vanguard account # is unique to each Vanguard fund you have, but it is not. In one case Vanguard calls your IRA and Individual Funds accounts two accounts. However, each of these Vanguard "accounts" could have multiple funds in them. Any or all of the funds, even across IRA and Individual accounts, could potentially have the same "account" number. When this happens MS Money assumes that all "funds" with the same "account number" belong to the same MS Money "account" and will combine them, especially when using the "direct" statement method of connection. This is really nasty because then MS may be combining taxable, tax-deferred retirement accounts, and taxable accounts together which may cause you problems if you trust this software to help you do your taxes; on the other hand maybe Vanguard and Microsoft will pay your IRS tax penalties and bail you out of jail ![]() My solution was to have Vanguard transfer all of my funds such that each ended up with a unique Vanguard "account" number; note EACH fund! The fund number is NOT part of the "account" number transmitted to MS Money on download; so if you have, for example, a PMMF and a TEMMF with the same "account" number but different fund numbers, you have to have Vanguard change one of them. Of course the simple solution for Vanguard would be to concatenate the Vanguard "Fund number", "account number", and "Account Type (e.g., IRA, Individual) to make them unique and then download this "real unique account number" as the account number to MS Money ... but do you think Vanguard could do this? NO WAY ... they can't even print the statement date on the first page of my monthly report and I'm one if their "high rollers." Vanguard needs a customer oriented web-team ... their customer service telephone agents don't even know how to contact the web- support team (they're probably doing training in India now anyway.) They are spending big bucks to changes hundreds (thousands) of customer accounts instead of spending 1- programmer day to fix the problem correctly in the 1st place. I wonder if Vanguard is "really" the low cost provider? Hope this helps ... hope the flame gets Vanguard off their duffs. TSH - quote - > -----Original Message----- > I'm pretty confused with Money 2004 accessing my Vanguard > account online. My account is a mixture of IRA, > investment and money market accounts, and Money creates 3 > separate accounts in the Account List, but they don't > make sense: > - The Vanguard Group Investment - contains one investment > account and the money market account > - The Vanguard Group Investment #2 - empty > - The Vanguard Group Retirement - contains second > investment account and IRA account > So my questions are: > 1. Any clues as to what might be wrong with my accounts, > or how best to set the up? I.e. is the problem with > Money, my Vanguard account, my understanding, etc? > 2. Is there a good reference for working with Money 2004 > with Vanguard or other investment/retirement accounts? > Thanks! > WH > . |
|
#-1
| |||
| |||
| I'm pretty confused with Money 2004 accessing my Vanguard account online. My account is a mixture of IRA, investment and money market accounts, and Money creates 3 separate accounts in the Account List, but they don't make sense: - The Vanguard Group Investment - contains one investment account and the money market account - The Vanguard Group Investment #2 - empty - The Vanguard Group Retirement - contains second investment account and IRA account So my questions are: 1. Any clues as to what might be wrong with my accounts, or how best to set the up? I.e. is the problem with Money, my Vanguard account, my understanding, etc? 2. Is there a good reference for working with Money 2004 with Vanguard or other investment/retirement accounts? Thanks! WH |
| Tags |
| group, vanguard, working |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| On-line updates from Vanguard funds Bob Alston: Apparently Vanguard funds do not permit Microsoft Money 2002 to access data in your personal account, as does Fidelity and others. Correct? Any... | Microsoft Money | 1 | 05-06-2004 02:05 AM | |
| Downloading transactions from Vanguard Steve: I have two investments in my Vanguard Group account. When I download the transactions into Money 2004, Money creates, in addition to my two... | Microsoft Money | 1 | 03-04-2004 01:28 AM | |
| Money 2004 / Vanguard online access Tex: Hi all, just purchased Money 2004 and have a few issues I'm hoping you can help with. I have a few different accounts (Roth IRA, Rollover IRA,... | Microsoft Money | 3 | 02-05-2004 12:48 AM | |
| getting stmts for all my accounts from vanguard sean: i was having this problem with mny 2002. i just upgraded to 2004 and am still having the same problem. we have 3 accounts w/ vanguard. i have... | Microsoft Money | 4 | 09-23-2003 05:44 AM | |
| Thread Tools | |
| Display Modes | |
| |