Warning: Vanguard.com will not work properly with JavaScript disabled!
Vanguard - FAQs - Quicken for Windows

Help Center  »  Technical information  »  Quicken FAQs (Windows)

 

Technical FAQs—Downloading transactions to Quicken for Windows

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

This service will work for Quicken 2011 or later. As of April 30, 2013, Intuit no longer supports previous versions of Quicken.

Vanguard cannot provide technical support for Quicken. For technical assistance, we recommend visiting Intuit's website or calling 800-811-8766 (charges may apply).

For general questions about downloading transaction information from vanguard.com, call Vanguard at 888-353-0547.

Back up your transaction data

We strongly recommend backing up your transaction data before making any changes:

  1. Click the File menu, then choose Backup and Restore.
  2. Choose Back up Quicken File
  3. Choose a location to back up your file, then click Back up Now. Quicken will display a message that the file was backed up successfully.
  4. Click OK to close the message.

Frequently asked questions about Quicken

What types of accounts can I download my transactions for?

How do I use Quicken's Direct Connect?

How do I switch to Quicken's Direct Connect?

How do I use Quicken's Web Connect through vanguard.com (personal investors)?

How do I use Quicken's Web Connect through vanguard.com (institutional investors)?

What are my User name and Password for Quicken?

What's the difference between "Download all funds into a single Quicken account" and "Download each fund into separate Quicken accounts"?

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

I'm receiving an OL-295-A or OL-297-A error when downloading to Quicken. What should I do?

Can I download Vanguard money market information into a Quicken money market account?

What happens to my transaction data if I convert to Admiral™ Shares?

How do I get help using Quicken?

What types of accounts can I download my transactions for?

You can download transactions for these Vanguard account types:

  • Personal nonretirement accounts such as individual, joint, and trust accounts.
  • Personal retirement accounts such as traditional IRAs, Roth IRAs, and rollover IRAs.
  • Employer-sponsored retirement plans such as 401(k), 403(b), and some types of pension plan accounts. (Please note that these accounts cannot be downloaded into Quicken Basic because of restrictions within the software.)
  • Vanguard Brokerage Services® accounts.
  • Vanguard annuity accounts.

You cannot download transactions for these account types:

  • Vanguard 529 accounts.

Return to top

How do I use Quicken's Direct Connect?

Direct Connect lets you download Vanguard transactions directly into Quicken without logging on to vanguard.com Remember:

  • Always back up your Quicken data file before downloading your transaction data. Get instructions or see your Quicken Help files.
  • Direct Connect downloads all Vanguard mutual funds with the same account number into a single Quicken account. To download transactions into separate Quicken accounts, use the Web Connect download through vanguard.com See How do I use Quicken's Web Connect? for more information.
  • On your first download, Quicken will download the last 18 months' worth of transactions. Subsequent downloads will only include new transactions.
  • Only accounts that display in your customized page view will download. To hide an account or display a missing account, use the link on the Balances & holdings page that says "Customize this page."

The instructions below are for Quicken 2010 and newer. If you're using another version, see your Quicken software's Help files for specific instructions. To set up Direct Connect downloads:

  1. Select the File menu in Quicken, click New Quicken File and a new window will open.
  2. Select New Quicken File and click OK.
  3. In the "File name" field, enter a name for this new Quicken file then click OK.
  4. Quicken will then take you to the “Home” screen, choose Add an Account on the bottom left of the Accounts list.
  5. Choose Brokerage in the Investing column, then click Next.
  6. Click on Vanguard Group.
  7. Enter your vanguard.com user name and password into the requested fields. Please note, Quicken will only recognize the first 10 characters in the password field. If your password is longer, please only enter the first 10 characters. Quicken will connect to vanguard.com and get your account information.
  8. If you have an employer plan, Quicken will ask you for the name of the employer. Enter the name into the provided field and choose Next. Quicken may ask "Is this a single mutual fund account?" Make a selection and choose Next.
  9. Quicken will display the accounts that it has found and the transactions it has downloaded. Confirm this and click Finish

Note: Once the accounts are configured, your Quicken 2010 or higher software will automatically retrieve your most recent transactions for each account.

Return to top

How do I switch to Quicken's Direct Connect?

Note: Backing out of changes in Quicken can be difficult. We recommend, therefore, that you back up your data file before downloading transactions.

If you've been downloading account information from vanguard.com using the Quicken Web Connect process and you want to switch to Direct Connect in Quicken 2010 or 2011:

  1. Choose the Tools menu then click Accounts List.
  2. Click Edit on one of your Vanguard accounts.
  3. Select the Online Services tab.
  4. Click Activate One Step Update.
  5. Enter your vanguard.com user name into the user name field and then enter your password into the password field.
  6. Click Connect.
  7. Follow the steps to set up the account on the next screen, then click Next.
  8. Review the information on the screen and choose Finish.
  9. Repeat these steps as needed for each Vanguard account.

For Quicken 2012:

  1. Choose the Tools menu then click Accounts List.
  2. Click Edit on one of your Vanguard accounts.
  3. Select the Online Services tab.
  4. Click the link for Click here to find out more and get set up.

Return to top

How do I use Quicken's Web Connect through vanguard.com (personal investors)?

Note: Backing out of changes in Quicken can be difficult. We recommend, therefore, that you back up your data file before downloading transactions.

Your downloaded account history includes purchases, redemptions, dividends, and capital gains. It also includes all share prices and share amounts pertaining to each transaction. Before importing any transactions, be sure to launch Quicken and open it to the account for which you will be downloading data.

You can download your transactions into Quicken 2010 or higher from our website using the Web Connect feature available on vanguard.com To download the transactions:

  1. Create a new investing or brokerage account within Quicken and name the account. You should not provide an account number during the setup process as it will be provided during the download.
  2. Log on to vanguard.com, click Balances &holdings, and then Download using the icon with the downward arrow near the top of the page.
  3. Select either Download all funds into a single Quicken or Money account or Download each fund into separate Quicken or Money accounts.
  4. Choose a date range. The system defaults to 18 months.
  5. Uncheck any accounts you do not wish to download.
  6. Click Download to Quicken.
  7. If prompted to save the file or open it, choose Open.
  8. Match the account number displayed at the top of Quicken's Download window to the Quicken account register you've created or create a new one.
  9. Quicken will prompt you with an Import Downloaded Transactions window and ask whether the downloaded accounts should be created in a new or existing account. Make a selection. (Depending on the number of accounts you have with Vanguard, you'll be prompted multiple times for every account.)
  10. The One Step Update Summary screen will load a list of all accounts downloaded
  11. The newly downloaded accounts will have red flags in the accounts column. Click on each red flagged account.
  12. Quicken will download the transaction information and may prompt you to accept the entries.
  13. Click Accept All to take all transactions in the account. Then click Done when the process is completed. You may need to accept each "Sell" or "ShrsOut" transaction separately to choose your tracking method for tax purposes. Visit Intuit's website for more information about this process.
  14. Adjust your portfolio, if prompted, to match the number of shares listed in the Quicken register to the number listed on our website. Click Yes, then Add Adjustment to modify the number of shares in each register.
  15. If your account's cash balance is not zero, click the Investing menu, choose Investing Activities, then click Update My Cash Balance. Set your cash balance to $0 as of today's date.

Return to top

How do I use Quicken's Web Connect through vanguard.com (institutional investors)?

Note: Backing out of changes in Quicken can be difficult. We recommend, therefore, that you back up your data file before downloading transactions.

If you haven't downloaded your transactions before, we recommend creating a new 401(k) account register rather than using an existing account. If you've already created a Quicken register, the software may "swap" your existing transactions for identical transactions that use a tax-free security.

Your downloaded account history includes purchases, redemptions, dividends, and capital gains. It also includes all share prices and share amounts pertaining to each transaction. Before importing any transactions, be sure to launch Quicken and open it to the account for which you will be downloading data.

You can download your transactions into Quicken 2010 or higher from our website using the Web Connect feature available on vanguard.com:

  1. Log on to your Vanguard accounts using your vanguard.com user name and password.
  2. Click Plan Summary.
  3. Click Transaction History.
  4. Click Download at the top of the page.
  5. Choose the Quicken download option and click Download.
  6. If prompted to save the file or open it, choose Open.
  7. Match the account number displayed at the top of Quicken's Download window to the Quicken account register you've created or create a new one.
  8. Choose the appropriate security from your Security List, if prompted, or add each new security.
  9. Click OK to the message that your data has been downloaded.
  10. Click Accept All to take all your transactions, then click Done when the process is completed. You may need to accept each "Sell" or "ShrsOut" transaction separately to choose your tracking method for tax purposes. Visit Intuit's website for more information about this process.
  11. Adjust your portfolio, if prompted, to match the number of shares listed in the Quicken register to the number listed on our website. Click Yes, then Add Adjustment to modify the number of shares in each register.
  12. If your account's cash balance is not zero, click the Investing menu, choose Investing Activities, then click Update My Cash Balance. Set your cash balance to $0 as of today's date.

Return to top

What are my user name and password for Quicken?

Your vanguard.com user name is your user name. Your vanguard.com web password is your password.

Return to top

What's the difference between "Download all funds into a single Quicken account" and "Download each fund into separate Quicken accounts"?

  • Download all funds into a single Quicken account. This option groups accounts by Vanguard account number, so that a single Quicken account holds two or more Vanguard funds in aggregate (similar to the way a brokerage account operates). This is the most popular option with our users, as it allows them to group all their funds. This choice is available whether you download transaction information from within Quicken (Direct Connect) or through vanguard.com (Web Connect).
  • Download each fund into separate Quicken accounts. This option treats each Vanguard mutual fund as a separate Quicken account. This choice is available only if you use Web Connect (by first logging in to vanguard.com) to download to Quicken.

The information above only applies to Vanguard mutual fund accounts. All securities held in Vanguard Brokerage Services or employer plan accounts will download into a single Quicken account whether you choose Web Connect or Direct Connect. If prompted by Quicken, make sure to indicate that any employer plan accounts belong in Quicken's 401(k)/403(b) account registers.

Note: Backing out of changes in Quicken can be difficult. We recommend, therefore, that you 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 to differ:

  1. Incorrect cash balance. All Vanguard accounts will not carry a cash balance at all times. As soon as your investments funds are received, we immediately purchase mutual fund shares with your investment. Therefore, the cash balance of your account registers in Quicken should remain at zero between transactions. See your software's Help files for instructions.
  2. Incorrect share balance. If the number of shares and price per share are correct, the ending market value of your accounts should match your Vanguard balance. If the number of shares is incorrect, download the latest transactions from your account. If you've just created a new account and downloaded for the first time, enter the account balance as of the day before the first transaction downloaded. If you've recently downloaded transactions and entered your starting balance, compare your account history in Quicken with the account history provided on vanguard.com to identify and correct any discrepancies. You can see your share balance in Quicken by clicking the Activities menu and then choosing Portfolio.
  3. Incorrect share price. When you download your recent transactions from vanguard.com, we provide the value of the funds 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. See your software's Help files for instructions on downloading quotes for securities.

Note: Vanguard provides price information during a transaction download; however, Quicken may override our information with quotes it receives internally. Quicken downloads market data via S&P Comstock, through its relationship with Intuit. Vanguard cannot guarantee the accuracy of price information downloaded through Quicken.

Return to top

I'm receiving an OL-295-A or OL-297-A error when downloading to Quicken. What should I do?

We recommend disabling online access to your accounts, then re-enabling access, to resolve these issues. First, back up your existing data file, then disable access to your account:

  1. Navigate to the account you wish to disable.
  2. Click the Tools tab and click on Account List.
  3. Click Edit next to the account you want to deactivate.
  4. Click Online Services.
  5. Click Remove from One Step Update.
  6. Choose Yes to deactivate this service.
  7. Click OK to indicate you read the warning stating you must contact your financial institution when deleting setup information for an online account. (This is a generic message. You do not need to contact Vanguard.)
  8. Click OK to close the Account Details window.

We recommend that you deactivate all accounts from Vanguard before reactivating any of the accounts. To reactivate an account, see the Direct Connect section.

Return to top

Can I download Vanguard money market information into a Quicken money market account?

No. Vanguard money market funds are mutual funds, just like our stock, bond, and balanced funds. Because Quicken treats money market accounts as investments rather than as banking accounts, you will need to download Vanguard money market mutual funds into an investment account.

Quicken does not provide the ability to change a banking account into an investment account. We recommend creating a new investment account for any Vanguard funds listed in a banking account.

Note: 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. For more information, see the Help files provided within Quicken.

Return to top

What happens to my transaction data if I convert to Admiral Shares?

If you convert your Vanguard Investor funds to Admiral Shares™, Vanguard treats the conversion as a nontaxable event. Subsequently, there will be no associated capital gains or losses.

If you choose to download the transactions, they'll automatically appear in the associated accounts, depending on how you track your Vanguard accounts in Quicken. If you track them by account number only, they'll appear as new funds in the accounts and Quicken will prompt you to add them to the security list. If you track them by fund and account number, you'll have to create a new account in Quicken to track the Admiral Shares account. Your Investor Share account balance will be reduced to zero.

If you choose to enter the conversion manually, please enter it as shown below. Quicken doesn't currently contain a specific investment transaction for share class conversions, but the corporate acquisition (stock-for-stock) transaction will handle a class conversion and maintain an accurate cost basis for the new share class.

  1. Open the account in question and click Enter Transactions.
  2. In the Enter Transactions drop down menu, choose Corporate Acquisition (stock for stock).
  3. Complete the form using the following information:
    1. Company acquired—Enter your original share class.
    2. Acquiring company—Enter your new share class.
    3. New shares issued per old share—Enter the number of new share class shares received for each original share class share. If you are unsure of the number to enter, please check your Transaction History online or reply to this message. Please specify the date, fund, and account number for your Admiral conversion.
    4. Price per share for acquiring company—Enter the closing price of the new share class on the date of conversion.
  4. Click Enter/Done.

Return to top

How do I get help using Quicken?

For technical assistance using Quicken, visit Intuit's website or call 800-811-8766 (charges may apply). Vanguard cannot provide technical support for this program.

Return to top

Note: Vanguard warrants that all account information on vanguard.com is accurate. Vanguard is not responsible, however, 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.

Need technical assistance?

Contact Web Technical Support Services at 888-353-0547, Monday through Friday, 8 a.m. to 7 p.m., Eastern time.

E-mail this page

Send a link Send a link

© 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