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

Help Center  »  Technical information  »  Quicken FAQs (Mac)

 

Technical FAQs—Downloading transactions to Quicken for Macintosh

You can download and export up to 18 months 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 2007 and Quicken Essentials. As of April 30, 2009, Intuit no longer supports previous versions.

Vanguard cannot provide technical support for Quicken. For technical assistance, we recommend visiting Intuit's website.

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 Back Up, then click To Disk.
  2. Choose a location to back up your file, then click Back Up. Quicken will display a message that the file was backed up successfully.

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?

I don't see Vanguard listed within Direct Connect. What should I do?

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.

You cannot download transactions for these account types:

  • Vanguard 529 accounts.
  • Vanguard annuity 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 Customize this 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."

New accounts for Quicken Essentials

  1. Select the File menu in Quicken, then New.
  2. Choose a name for the file and enter it in the Save As field, then click Save.
  3. Select the Create a new account icon at the lower left.
  4. Scroll down until you find Investments, then select Brokerage.
  5. Type Vanguard into the Search field, select Vanguard Group then click Continue.

Current accounts for Quicken Essentials

  1. Select the Accounts menu in Quicken, then New.
  2. Select Investments, then click Brokerage.
  3. Type Vanguard into the Search field, select Vanguard Group then click Continue.
  4. Type in your Vanguard User name and Password, then press Continue.
  5. Under Accounts Found, any new account has an Add action selected. Verify which accounts you would like to add, then select Continue.
  6. Select Finish.

New Accounts for Quicken 2007

  1. Select the File menu, then click the New option, followed by Account.
  2. Select Vanguard Group from the Institution list, then click Continue.
  3. Type in your Vanguard User name and Password, then press Continue.
  4. Choose the account(s) you want to enable from the dropdown menu and click OK.
  5. Click OK again when the process is complete.

Existing accounts in Quicken 2007

  1. To set up new accounts in your file:
  2. Select the File menu, then click the New option, followed by Account.
  3. Select Vanguard Group from the Institution list, then click Continue.
  4. Type in your Vanguard User name and Password, then press Continue.
  5. Choose the account(s) you want to enable from the dropdown menu and click OK.
  6. Click OK again when the process is complete.

After setting up your accounts, you'll need to download transactions using the One Step Update process:

  1. Click the One Step button in the Quicken toolbar.
  2. Enter your PIN (Vanguard.com password) for each Vanguard user name you're downloading and click Update Now.
  3. Click OK when the download completes.
  4. To view and accept the transactions, click the Online menu and choose Download Transactions. Accounts with transactions that need to be accepted will have a dot next to their name.

Note: Your account balance may show with a higher or lower value than on Vanguard's website. See Why doesn't my balance match what's shown on Vanguard.com? for more information.

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:

  1. Choose the Lists menu in Quicken, then choose Accounts.
  2. Click the account you wish to change to Web Connect.
  3. Click Edit.
  4. Change the Download Transactions menu from via website to not enabled.
  5. Click OK when prompted that you're about to disable online services. (You do not need to contact Vanguard.)
  6. Click OK.
  7. Click the same account you just disabled in the Accounts window, then click Edit.
  8. Change the Download Transactions menu from not enabled to using Direct Connect. (If you're unable to select Direct Connect, click Cancel and update your financial institution list.)
  9. Delete the existing Customer ID (all zeroes) and enter your Vanguard user name as the Customer ID.
  10. Click OK.

After setting up your accounts, you'll need to download transactions using the One Step Update process:

  1. Click the One Step button in the Quicken toolbar.
  2. Enter your PIN (Vanguard.com password) for each Vanguard user name you're downloading and click Update Now.
  3. Click OK when the download completes.
  4. To view and accept the transactions, click the Online menu and choose Download Transactions. Accounts with transactions that need to be accepted will have a dot next to their name.

Note: Your account balance may show with a higher or lower value than on Vanguard's website. See Why doesn't my balance match what's shown on Vanguard.com? for more information.

Return to top

I don't see Vanguard listed within Direct Connect. What should I do?

Update your financial institution list:

  1. Launch Quicken.
  2. Click the Online menu and choose Financial Institutions.
  3. Click Update List in the financial institutions window. Quicken will connect to Intuit's servers and download an up-to-date list.
  4. Check to make sure that Vanguard Group displays in the list. If it does, you're able to set up Direct Connect downloads.

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.

You can download your transactions into Quicken 2007 and higher from our website using the Web Connect feature available on Vanguard.com. To download the transactions:

  1. Log on to Vanguard.com, click Balances & holdings, then click the download icon near the top of the page.
  2. Select either Download all funds into a single Quicken or Money account or Download each fund into separate Quicken or Money accounts.
  3. Choose a date range. The system defaults to 18 months.
  4. Uncheck any accounts you do not wish to download.
  5. Click Download to Quicken. An OFX file containing your transaction data will download to your desktop.
  6. Double-click the file on your desktop to open it in Quicken.
  7. Choose the Quicken account into which you'll import the data.
    • If you have not created an account previously, choose Create a New Account. If you choose this option, you'll need to know the account balance 18 months prior in order for the account to be accurate.
    • If you've created a Vanguard money market account as a banking account, you'll need to create a new register to download these transactions. Because Vanguard's money market funds are mutual funds, they cannot be downloaded into banking accounts.
  8. If prompted, choose the appropriate security from your Security List, or add each new security.
  9. To view and accept the transactions, click the Online menu and choose Download Transactions. Accounts with transactions that need to be accepted will have a bullet next to their name.

Note: Your account balance may show with a higher or lower value than on Vanguard's website. See Why doesn't my balance match what's shown on Vanguard.com? for more information.

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.

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

  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 the download icon near the top of the page.
  5. Select either Download all funds into a single Quicken or Money account or Download each fund into separate Quicken or Money accounts.
  6. Choose a date range. The system defaults to 18 months.
  7. Uncheck any accounts you do not wish to download.
  8. Click Download to Quicken. An OFX file containing your transaction data will download to your desktop.
  9. Double-click the file on your desktop to open it in Quicken.
  10. Choose the Quicken account into which you'll import the data.
    • If you have not created an account previously, choose Create a New Account. If you choose this option, you'll need to know the account balance 18 months prior in order for the account to be accurate.
    • If you've created a Vanguard money market account as a banking account, you'll need to create a new register to download these transactions. Because Vanguard's money market funds are mutual funds, they cannot be downloaded into banking accounts.
  11. If prompted, choose the appropriate security from your Security List, or add each new security.
  12. To view and accept the transactions, click the Online menu and choose Download Transactions. Accounts with transactions that need to be accepted will have a bullet next to their name.

Note: Your account balance may show with a higher or lower value than on Vanguard's website. See Why doesn't my balance match what's shown on Vanguard.com? for more information.

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"?

The following information applies only 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.

  • 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 in 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.

Return to top

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

(Note: Correcting your balance in Quicken for Macintosh is a manual process. Unlike Quicken for Windows, which provides prompts that automatically adjust your cash balance and share balance, you'll need to calculate the amount of most adjustments manually and enter them in your account register. Quicken 2007 for Macintosh does provide some automatic adjustment. If you are prompted to add an adjustment transaction, do so.)

Three scenarios can cause the balance to differ:

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 should remain at zero between transactions. To adjust your cash balance:

  • Click the Activities menu, then Adjust Balance.
  • Accept the default of $0 for today's date and click OK. A transaction labeled "Balance Adjustment" will be entered with the proper amount to make your cash balance equal $0.

2. Incorrect share balance. If the number of shares and price per share are correct and there's no cash balance, 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. To correct a discrepancy, enter a "Move Shares" transaction in the affected account register. For example:

  • If Vanguard.com states you have 1,000 shares but Quicken only shows 600, enter a Move Shares transaction for 400 "shares in."
  • If Vanguard.com states you have 1,000 shares but Quicken shows 1,600, enter a Move Shares transaction for 600 "shares out."

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.

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

If the incorrect prices are still displaying, you can enter new prices manually on the Portfolio page.

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 account and then re-enabling it to resolve these issues. First, back up your existing data file, then disable access to your account:

  1. Click the Lists menu and choose Accounts.
  2. Click the account you wish to deactivate to highlight it.
  3. Click Edit.
  4. Change the Download Transactions dropdown to the "not enabled" option.
  5. Click OK to indicate you read the warning stating you must contact your financial institution when deleting setup information for an online account. (You do not need to contact Vanguard.)
  6. Click OK to close the Account Details window.

We recommend that you deactivate all accounts from Vanguard before reactivating. To reactivate, 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 banking accounts, you'll 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.

Return to top

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

Because Vanguard treats the conversion as a nontaxable event, 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.

The corporate acquisition (stock-for-stock) transaction will handle a class conversion and maintain an accurate cost basis for the new share class. To enter the conversion manually:

  1. Open the investment account in question from the account list.
  2. Click Gear at the bottom right-hand corner, then Open Investment Actions List.
  3. In the Open Investment Actions List, choose Corporate Acquisition under the Advanced header. 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 of the combined company—Enter the closing price of the new share class on the date of conversion.
  4. Click OK.

Return to top

How do I get help using Quicken?

For technical assistance using Quicken, visit Intuit's website. 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