About investment reports

In Quicken, investment reports help you review what you own and what it's worth, based on the latest prices in your file. This topic covers two reports: Portfolio Value and Portfolio Value & Cost Basis.

What these reports show

Both reports summarize your investment holdings across one or more accounts. Use them to confirm share counts, review current prices, and see market value totals.

Access the reports

You can open both reports from the Reports menu.

1. Choose Reports > Investing.

2. Choose Portfolio Value or Portfolio Value & Cost Basis.

Charts

Both reports include a chart that lets you visualize your portfolio data at a glance.

Portfolio Value chart

The Portfolio Value report displays a donut chart in the upper-left area of the report. The chart shows your holdings broken down by security, with each slice color-coded to match the security listed in the table. The center of the chart shows the total portfolio value.

You can drill down into the chart to explore groupings in more detail. Selecting a slice or a row in the table narrows the view to that group. A breadcrumb at the top of the chart shows your current level (for example, Other Securities (Level 2)), along with the group's total value and its percentage of the full portfolio. Select the back arrow to return to the previous level.

Portfolio Value & Cost Basis chart

The Portfolio Value & Cost Basis report displays a line chart above the data table. The chart plots Total Value and Cost Basis over the selected date range. Hover over any point on the chart to see a tooltip with the Gain, Total Value, Cost Basis, and the date for that point.

Use the Date Range and Interval controls above the chart to adjust the time period and the granularity of the data points. Select Y-axis starts at zero in the upper-right corner of the chart to anchor the Y-axis at zero for a clearer view of absolute values.

Understand the columns

The columns you see depend on which report you open.

Portfolio Value columns

This report shows what you hold and what it's worth right now.

Portfolio Value & Cost Basis columns

This report adds performance and cost details. Some columns may show an "as of" date in the header, and the report can display multiple date columns side by side for comparison.

Edit a report

You can customize either report to control the date range and what accounts or securities are included.

1. Open the report.

2. Click Edit.

3. Update settings on Accounts and Securities, and set a Date range.

4. Click OK.

Set the date range

Use the Data as of or Date range menu to select a preset range such as Today, End of Last Year, or Last 12 Months, or choose Custom Dates… and enter a start and end date.

Include accounts

On Accounts, choose one:

• All investing accounts (except separate accounts)

• Selected accounts

If you choose Selected accounts, use the checkboxes to include or exclude accounts. You can also use Search, Select All, and Clear All.

Include securities

On Securities, choose one:

• Include all securities

• Include only selected securities

If you choose Include only selected securities, use the checkboxes to include or exclude securities. You can also use Search, Select All, and Clear All.

Save, duplicate, print, and export

Both reports support saving, duplicating, printing, and exporting.

Save a customized report

Saving lets you keep your filters and selections so you can run the same report again later.

1. Open the report and apply your changes.

2. Click Save.

3. Enter a name, then click Save.

Duplicate a report

Duplicating is useful when you want to create a second version of a report with different filters.

1. Open the report.

2. Click Duplicate.

3. Edit the duplicate, then click Save if you want to keep it.

Print a report

Printing sends the current report view to your printer.

1. Open the report.

2. Click Print.

3. Choose your print options, then print.

Export a report

Exporting lets you work with the report data outside Quicken, for example in a spreadsheet app.

1. Open the report.

2. Click Export.

3. Choose the export option you want, then save the file.

Drill into report data

Both reports let you explore your data in more detail by clicking into the chart or table.

• Click an amount or a chart slice to open the related details.

• Use the breadcrumb at the top of the chart to navigate back up to a broader view.

• If Quicken shows a list of transactions, review that list to confirm what's included.

Tips

These suggestions can help you get cleaner, more useful results from both reports.

• Start with All investing accounts (except separate accounts) and Include all securities, then narrow down after you confirm totals.

• If a number looks off, change one filter at a time so you can tell what caused the change.

• Use Search on Accounts and Securities to find items quickly in long lists.

Troubleshooting

If the report doesn't look right, these are the most common causes.

Cost basis is $0.00 or missing

This usually means Quicken can't calculate cost basis for the holding based on the transactions in your file. Check the following:

• Confirm you have buy transactions (not just a share balance) for the security.

• If shares came from a transfer or an adjustment, confirm the original purchase history exists in your file.

A security is missing from the report

This is usually caused by report filters. Check the following:

• Click Edit, then on Accounts confirm the account is included.

• On Securities, confirm the security is included, or switch to Include all securities.

Totals don't match what you expected

This is often a date range or selection issue. Check the following:

• Confirm the Date range, especially if you're using a rolling range like Last 12 Months.

• Click Edit and confirm you didn't exclude an account or security unintentionally.