Account History

To find a detailed history of all the transactions in your account (buys, sells, dividends, etc), please follow the instructions below: navigate to Accounts > Transaction History (sign in required). In addition, you can download this information into Microsoft Money, Quicken, or Excel (CSV).

The default setting lets you see all the activity for the past 7 days, but you can change the settings to fit your specific needs:

Time Period

You can choose either the pre-defined Time Period or choose a Custom Date range.

Tip: When selecting Custom Dates, you can only view one year at a time, but the 'From' date can be set to a date as early as December 1, 1999.

Date Range

When you select a pre-defined date, the 'from' and 'to' dates automatically pop up. You can either use the pre-defined date, or edit it to create your own custom date range.

Transactions

The Transaction list lets you filter the types of transactions you'd like to look at within your account. For example, You can filter the list to show only your Automatic Investing Plan trades.

• All Transactions – All account transactions for a specific time period will show up.
• All Trades – All buys and sells in your account, regardless of the type of security, gets displayed.
  • Automatic Investments – Only shows buy orders you've made through the Automatic Investing Plan.
  • Buys (Trade Now) – Let's you see buys transactions of stocks and ETF's.
  • Sells (Trade Now) – Let's you see sell transactions of stocks and ETF's.
  • Mutual Fund Trades – Shows activity for mutual fund buys and sells.
  • Options Trades – Includes all buys and sells of options contracts
• Funds Transfer – All cash transfers in-and-out of your ShareBuilder account.
  • Deposits – Any cash you put into your ShareBuilder account (deposits from checking account, wire transfers, etc) show up in this filter.
  • Withdrawals – Cash you take out of your ShareBuilder account (withdrawals to checking or savings account, etc) shows up here.
• Dividends – If you've received any type of dividend in your ShareBuilder account, it shows up here.

Tip: All transactions are ordered by Date.

If you want to look at activity in another one of your ShareBuilder accounts, use the 'Switch Accounts' box (linked accounts only).

We offer two ways for you to download your account's transactions into Microsoft® Money. You can either manually download a file from the ShareBuilder site to be imported into Money (web-connect) or you can automatically load your transactions from within Money (direct-connect).

The following instructions are specific to the "web-connect" method. You can find "direct-connect" instructions on the 'Transaction History' page below the Financial Application list.

You can download your ShareBuilder account's transaction history so that is can be imported into Money by following the instructions below:

1. Navigate to Accounts > Transaction History (sign in required).
2. Select the Time Period you wish to download and click the Download Account Activity link. Only the Time Period being displayed on the page will be included.
   
   Note: All transactions will be included in the download file for the selected Time Period regardless if they are not displayed on the page because Transactions are being filtered.
3. From the Financial Application list, select Microsoft Money (OFX).
4. Click Download. You will be prompted to save the export file to your computer.

Support Levels

The "web-connect" feature is compatible with Microsoft Money versions 2005 and newer. Older versions may work, but are not supported by ShareBuilder. If you download historical data, Capital One ShareBuilder, Inc. does not warrant resultant data.

ShareBuilder Customer Service does not provide support for Microsoft Money. We recommend you visit the Microsoft Money website, which provides detailed instructions on importing your download file into Money.

Here are several suggestions that can help when importing your ShareBuilder transactions to Microsoft Money:

• Back up your Money data file before importing your ShareBuilder transactions
• Create a ShareBuilder account in Money before you import the transactions
• If you have already been entering your ShareBuilder transactions in Money, you may end up with duplicate transactions. Verify your transactions with your monthly statements and confirmations

Special Notes:

1. Due to the partial share transactions that are possible through ShareBuilder and the way these transactions are rounded to 4 decimal places, Microsoft Money may display a message stating that the "price, quantity, commission, and total" do not match for some transactions. Your transactions are being imported correctly, and this can be verified by comparing your transactions to your trade confirmations.
2. Once you have imported your ShareBuilder transactions, you can verify that your import was successful by comparing the cash balance and the number of shares for each position in your ShareBuilder account to the cash balance and number of shares for each position in Microsoft Money. The securities market value may differ from what is currently being displayed in your ShareBuilder account.
3. Cash dividends paid on a stock on or before 12/19/2003 will be reported as a cash deposit instead of dividend income.
4. Transaction descriptions may be shortened in Money versus what you see on the ShareBuilder site due to a 32-character limitation.

When downloading your ShareBuilder account activity into Quicken, you can either manually import a file into Quicken by downloading a file from the ShareBuilder web site, (web- connect) or you can automatically load your transactions from within Quicken (direct-connect).

The following instructions are specific to the "web-connect" method. You can find "direct-connect" instructions on the 'Transaction History' page below the Financial Application list.

You can download your ShareBuilder account's transaction history so that it can be imported into Quicken by following the instructions below:

1. Navigate to Accounts > Transaction History (sign in required).
2. Select the Time Period you wish to download and click the Download Account Activity link. Only the Time Period being displayed on the page will be included. Tip: All transactions will be included in the download file for the selected Time Period regardless if they're not displayed on the page because Transactions are being filtered.
3. From the Financial Application list, select Quicken 2005 and newer (QFX).
   
   Tip: Quicken for Mac is not supported.
4. Click Download; you will be prompted to save the export file to your computer.

Support Levels

The "web-connect" feature is compatible with Intuit's Quicken versions 2005 and newer. You can download a "QIF" file which is compatible with Quicken 98 through Quicken 2004, however we don't officaly support the QIF file format. If you download historical data, we don't warrant resultant data.

ShareBuilder Customer Service doesn't provide support for Quicken. We recommend you visit the Quicken website, which provides detailed instructions on importing your downloaded file into Quicken.

Here are several suggestions to help you import your ShareBuilder transactions into Quicken:

• Back up your Quicken data file before importing your ShareBuilder transactions.
• Create a ShareBuilder account in Quicken before you import the transactions.
• If you have already been entering your ShareBuilder transactions in Quicken, you may end up with duplicate transactions. Verify your transactions with your monthly statements and confirmations.

Once you have imported your ShareBuilder transactions, you can verify that your import was successful by comparing the cash balance and the number of shares for each position in your ShareBuilder account to the cash balance and number of shares for each position in Quicken. The securities market value may differ from what is currently being displayed in your ShareBuilder account.

Note: Quicken, which has a 32-character limitation, may show shortened transaction descriptions than what you see on the ShareBuilder website.

By following the instructions below, you can download your ShareBuilder account history as a CSV file (comma-separated values or comma delimited) for use in Microsoft® Excel. Here's how:

1. Go to Accounts > Transaction History (sign in required).
2. Select the Time Period you wish to download and click the Download Account Activity link. Only the Time Period you see in the web page will download.
   Tip: Every transaction in the time period you select is included in the file you download.
3. From the Financial Application list, select Microsoft Excel (CSV).
4. Click Download. The message asks you to save the export file to your computer.

Support Levels

ShareBuilder Customer Service doesn't provide support for Excel. We recommend you visit the Microsoft Office Excel website, which provides detailed instructions on importing your CSV file into Excel.