Warning: Vanguard.com will not work properly with JavaScript disabled!
Download Transactions - Help
Personal Investors

Downloading Account Information—Help

Downloading to Intuit's Quicken or Microsoft Money

Downloading to a spreadsheet

Downloading to Intuit's Quicken or Microsoft Money

You can download and export up to 18 months' worth of Vanguard® transaction history into Quicken or Money. After you download your data, your Quicken or Money software should automatically recognize the file and import it directly into your account records. The software will compare the new download with older information to record only new transactions and eliminate any duplicates.

This service will work for Quicken 2004 (or later) and Money 2004 (or later). As of April 25, 2006, Intuit no longer supports versions of Quicken prior to Quicken 2004. Transaction downloads will not work for older versions.

For technical support, see Intuit's website or Microsoft's website. For general questions about downloading transaction information from Vanguard.com®, call Vanguard Web Technical Support Services at 1-800-860-8394.

Frequently asked questions about Quicken and Money

How do I use Quicken's Direct Connect?

You can use Quicken's Direct Connect feature to download Vanguard transactions into Quicken without first logging on to Vanguard.com. Note the following:

  • Always back up your Quicken data file before downloading. For instructions, see your Quicken Help files.
  • Direct Connect downloads all Vanguard mutual funds with the same account number into a single Quicken account. To download funds into separate Quicken accounts, use the Web Connect download through Vanguard.com instead of using Direct Connect. Instructions for using Web Connect are listed under "How do I use Quicken's Web Connect?"
  • On your first download, Quicken will download the last 18 months' worth of transactions. Subsequent downloads will only download new transactions.
  • Only accounts that display on your Preferred Account View will download. To hide an account from downloading, or to display a missing account, please modify your Preferred Account View.

The instructions provided below are for Quicken 2005. If you are using an older version, please see your Quicken software's Help files for specific instructions.

To set up Direct Connect downloads:

  1. In Quicken, select the File menu, then New, then New Quicken Account.
  2. Indicate that the account is held at "Vanguard Group."
  3. Choose Online as the method to set up those accounts.
  4. Enter your Vanguard.com user name and password as your Quicken customer ID and PIN. Quicken will connect to Vanguard.com and obtain your account information.
  5. The first six accounts that you hold at Vanguard will display. For each, either select an existing Quicken Investment account, or choose "Add a new Quicken account" and name the account. If you don't wish to download a specific account, mark it as "Do not use this account in Quicken."
  6. Confirm that the accounts are set up correctly, and click Done. If you have more than six Vanguard accounts to download, follow steps 1–6 again for the next set of six accounts.

Note: Once the accounts are configured, Quicken 2005 will automatically fetch your most recent transactions for each account. For older versions, you must initiate a second download using Quicken's One Step Update process to receive your transactions.

If you've been downloading account information from Vanguard.com using the Web Connect process, and you want to switch to Direct Connect:

  1. In Quicken, choose the Investing menu, then choose Online Center.
  2. Make sure Vanguard is selected as your financial institution.
  3. Click the Transactions tab.
  4. Select an account in the list below the Transactions tab.
  5. Choose the Options submenu at the top right side of the screen and uncheck Download this account using Web Connect. Complete this step for each account listed under the Transactions tab.
  6. Click OK when prompted to set your client ID. If you've been using Web Connect with your Vanguard accounts, your client ID is already set.
  7. Click Update/Send.
  8. When prompted for your PIN, enter your Vanguard.com password.

Return to top

How do I use Quicken's Web Connect through Vanguard.com?

You can download your transactions into Quicken 2004 or higher from our website using the Web Connect feature available on Vanguard.com. To download the transactions, please follow the instructions below.

  • Create a new Investing (Brokerage) type account within Quicken, and name the account. You should not provide an account number during the setup process. The account number will be provided during the download.
  • Visit the Download page available within your accounts.
  • Choose from "Download all mutual funds with the same Vanguard account number into a single Quicken or Money account" or "Download each mutual fund into a separate Quicken or Money account."
  • Choose a date range. Eighteen months of transactions are chosen by default.
  • Uncheck any accounts you do not wish to download.
  • Click the "Download to Quicken" button.
  • If prompted to save the file or open it, choose "Open it."
  • Match the account number displayed at the top of Quicken's Download window to the Quicken account register you have created, or choose to create a new account register if you don't already have one set up for a given account.

Return to top

How do I use Money's Direct Statements?

You can use Money's Direct Statements feature to download Vanguard transactions into Microsoft Money without first logging on to Vanguard.com. Note the following:

  • Always back up your Money data file before downloading. For instructions, see your Money Help files.
  • Direct Statements downloads all Vanguard mutual funds with the same account number into a single Money account. To download funds into separate Money accounts, use the Active Statements download through Vanguard.com instead of using Direct Statements. Instructions for using Active Statements are listed under "How do I use Money's Active Statements?"
  • On your first download, Direct Statements will download up to 18 months' worth of transactions. (The range varies depending on your version of Money.) Subsequent downloads will only download new transactions.
  • Only accounts that display on your Preferred Account View will download. To hide an account from downloading, or to display a missing account, please modify your Preferred Account View.

The instructions below are for Money 2005. If you are using an older version, please see your Money software's Help files for specific instructions.

To set up Direct Statements downloads:

  1. In Microsoft Money, select Account List from the left navigational area on the Home tab, or in the Accounts & Bills menu.
  2. Select Add a New Account from the left navigational area.
  3. Select an Investment as the Account Type.
  4. Select V to retrieve Vanguard on the Financial Institution screen that follows. It will appear as “Vanguard Group, The.”
  5. Choose Yes, I have my online signup information.
  6. Enter your Vanguard.com user name and password as your user ID and password. Money will connect to Vanguard.com and obtain your account information. (If you have more than one Vanguard user name and password for your household, read the "Set up online services for two accounts with different passwords at one bank" topic in the Microsoft Money Help menu before continuing.)
  7. Match the account number to the Money account register you created, or create a new register if you don't already have one for a given account.

Note: During the initial matching process, no transactions will be downloaded. You'll need to initiate a second download using the Get Online Statements process.

If you've been downloading account information from Vanguard.com and want to switch to Money's Direct Statements:

  1. In Microsoft Money, choose Account List from the left navigational area of the Home tab.
  2. In the left menu, click Manage online services.
  3. On the next page, click Set Up Online Services in the left menu.
  4. On the next page, click Set Up Online Services again.
  5. When prompted, select Vanguard as your financial institution.
  6. When prompted for a user ID and password, enter your Vanguard.com user name and password.

Return to top

How do I use Money's Active Statements through Vanguard.com?

You can download your transactions into Money 2004 or higher from our website using the Active Statements feature available on Vanguard.com. To download the transactions, please follow the instructions below.

  • Create a new Investing account within Money, and name the account. You should not provide an account number during the setup process. The account number will be provided during the download.
  • Visit the Download page available within your accounts.
  • Choose from "Download all mutual funds with the same Vanguard account number into a single Quicken or Money account" or "Download each mutual fund into a separate Quicken or Money account."
  • Choose a date range. Eighteen months of transactions are chosen by default.
  • Uncheck any accounts you do not wish to download.
  • Click the "Microsoft Money" button.
  • If prompted to save the file or open it, choose "Open it."
  • Click "Close" to proceed past the File Import Summary.
  • Choose an existing Money account for each downloaded account. If you have not created an account in Money for a downloaded Vanguard account, choose to create a new account.

Return to top

What are my client ID and PIN for Quicken? What are my user ID and password for Money?

To authenticate your identity when accessing Vanguard accounts via Direct Connect or Direct Statements in Quicken or Money, use your Vanguard.com user name when prompted for your client ID or user ID. Use your Vanguard.com web password when prompted for your PIN or Password.

Return to top

What's the difference between "Download all mutual funds with the same Vanguard account number into a single Quicken or Money account" and "Download each mutual fund into a separate Quicken or Money account"?

You can organize Vanguard mutual fund accounts two different ways within Quicken or Money:

  • You may group accounts together by Vanguard account number, so that a single Quicken or Money account holds two or more Vanguard funds in aggregate (similar to the way a brokerage account operates). We refer to this as "Download all mutual funds with the same Vanguard account number into a single Quicken or Money account." This is our most popular option, as it allows you to keep all of the funds in a given grouping together. This option is available whether you download transaction information from within Quicken or Money (Direct Connect/Direct Statements) or through Vanguard.com (Web Connect/Active Statements).
  • You may treat each Vanguard mutual fund as a separate Quicken or Money account. We refer to this option as "Download each mutual fund into a separate Quicken or Money accounts." This option is available only if you download to Quicken or Money using Web Connect or Active statements (by first logging in to Vanguard.com).

Please note that the information above only applies to Vanguard mutual fund accounts. All Vanguard Brokerage Services securities listed under a single account number will download into a single Quicken account regardless of whether you choose Web Connect or Direct Connect. All securities held within a single employer plan account (listed on the Retirement Plans area of the site) will download into a single Quicken account, regardless of whether you choose Web Connect or Direct Connect. If prompted by Quicken, please make sure to indicate that these accounts belong in Quicken's 401(k)/403(b) account registers.

Note: If you dislike your download option, or if an error occurs, backing out changes in either program can be difficult. For that reason, please always back up your data file before downloading transactions.

Return to top

Why doesn't my balance match what's shown on Vanguard.com?

Three scenarios can cause the balance of your account in Quicken to not match the balance as displayed on Vanguard.com:

  1. Incorrect cash balance. Your accounts at Vanguard do not track a cash balance. When you invest with us, we immediately purchase mutual fund shares with your investment. For this reason, the cash balance of your account registers in Quicken or Money should remain at zero between transactions. See your software's Help files for instructions on adjusting the cash balance in an account.
  2. Incorrect share balance. Assuming the cash balance in your accounts is zero as described above, the ending market value of your accounts should display as the current balance for your accounts if the number of shares and price per share are correct. If the number of shares is incorrect, you may need to download the latest transactions from your account. If you've just created a new account and downloaded for the first time, make sure to enter the account balance as of the day before the first transaction downloaded, so that the number of shares in your account is correct from that point forward. If you've entered your starting balance and you've downloaded recently, compare your account history in Quicken to the account history provided on Vanguard.com so that you can identify and correct the discrepancy.
  3. Incorrect share price. When you download your recent transactions from Vanguard.com, we provide the value of the funds you downloaded as of the day of the download. We do not update the share prices for funds that have no current holdings. If you do not download transactions for a specific fund, you may need to download the current share price for the fund through Quicken or Money. See your software's Help files for instructions on downloading quotes for securities.

Note: Price quotes you download into Quicken are provided by S&P Comstock through its relationship with Intuit, and are not provided by Vanguard. Quotes you download into Money are provided by MSN Money through its relationship with Microsoft and are not provided by Vanguard. We cannot guarantee the accuracy of price information downloaded through Quicken or Money servers.

Return to top

Can I download money market information into a money market account in Quicken or Money?

No. The money market funds that Vanguard provides are mutual funds, just as the stock, bond, and balanced funds that Vanguard offers are mutual funds. Quicken and Money treats Vanguard® money market funds as investments rather than as banking accounts. You will need to download Vanguard mutual funds into an "Investment" type Quicken or Money account instead of a "Banking" account.

Quicken and Money do not provide the ability to change a Banking account into an Investment account. We recommend you create a new Investment account for these funds.

Quicken users: You may add a linked checking account to the investment register you use to track money market funds, particularly if you also use Vanguard's checkwriting service. Information on that option is available in the Help files provided within Quicken, or from Intuit's technical support.

Return to top

Downloading to a spreadsheet

You can download and save a Comma-Delimited File, or Comma-Separated Value (.CSV), to your desktop, and import this file into most spreadsheet programs (such as Microsoft Excel) on Windows and Macintosh systems.

You don't need to select a download option when using the .CSV file format. When you download a .CSV file, all funds with the same Vanguard® account number will be grouped together. You must open the .CSV file in your spreadsheet software, then copy and paste its contents into your spreadsheet. You must manually remove any duplicate transaction entries you download. You can manipulate the data into multiple files or formats, or adjust the date range to reflect only transactions you haven't yet downloaded.

You cannot import .CSV spreadsheet files into Quicken or Money. Once you have downloaded the file, you do not need to maintain an Internet connection. Also, note the following:

  • You'll need to manually copy transactions into your spreadsheet program, set up any formulas necessary to calculate balances, and create charts to analyze your data.
  • You're responsible for ensuring that your transactions are downloaded, and that you do not have duplicate transactions recorded. Your spreadsheet software cannot check for duplicate or missing transactions.
  • If you're calculating your balance on the spreadsheet, you must update your spreadsheet with the number of shares you owned before your first transaction. You can adjust the download start date to a convenient date for downloading, such as the beginning of a year or quarter.
  • For technical support, contact the manufacturer of your spreadsheet software.

Return to top

Note: Vanguard warrants that all account information is accurate. However, Vanguard is not responsible for any errors associated with the subsequent use of such information by shareholders, including but not limited to the downloading of such information for use in preparing tax returns or financial-planning packages.

 

© 1995–2014  The Vanguard Group, Inc. All rights reserved. Vanguard Marketing Corporation, distributor. Your use of this site signifies that you accept our terms & conditions of use.
Security  |  Prospectuses  |  Careers  |  Mobile  |  Feedback