Quicken Windows Help

How do I use the Display tab to customize a report?

The options on this tab let you change the report or graph layout and hide or display certain types of information. Not all options are available for all reports and graphs.

Title

Enter a different title. Quicken displays and prints the report or graph with this new title. Row headings (summary and comparison reports only) Select category, tag, payee, or account names as row headings for the report.

Headings

  • Row headings (summary and comparison reports only)

    Select category, tag, payee, or account names as row headings for the report.

  • Column headings (summary and comparison reports, and Budget report and graph only)

    Select to create a report or graph with separate columns for each time period (such as each week or each month), or for each category, tag, payee, or account. If you select Don't Subtotal, Quicken creates the report with a single column.

  • Subtotal by (transaction and investment reports)

    Select to group and total transactions by time period (such as each week or each month), or by category, tag, payee, account, or tax schedule, or to group and total securities by time period, account, security, security type, investing goal, or asset class.

  • Interval (account balance, net worth, portfolio value and cost basis, and balance sheet reports)

    Select to create a column and total account balances for a time period (such as each week or each month). If you select None, the report includes one total for account balances based on the ending date you enter at the top of the window.

  • Sort by (transaction reports only)

    Change the order of transactions in the report. Your options are:

    Option

    Result

    Account/Date

    Sorts first by account type, then by account name, and then by date.

    Date/Account

    Sorts first by date, then by account type, and then by account name.

    Account/Check#

    Sorts first by account type, then by account name, and then by check number. (Cheque in Canada)

    Amount

    Sorts from smallest amount to largest.

    Payee

    Sorts alphabetically by payee name.

    Category

    Sorts alphabetically by category.

  • Organization

    Select the groups and totals that make up the report or graph. Your options are:

    Option

    Result

    Income & Expense

    Totals income, expense, and transfer transactions in separate sections of your report.

    Cash Flow Basis

    Groups and totals inflows and outflows (including expenses and transfers out of the account). For example, if you've an asset account called House, and you treat home improvement transactions as transfers to that account, selecting Cash Flow Basis lets you treat those transfers as spending, giving you a more accurate picture of your total expenditures.

    Category Group (budget, comparison, and summary reports)

    Groups and totals amounts by category group instead of inflows and outflows.

  • Currency
    If you've enabled multicurrency support, you can select the currency you want to use for your report or graph. All monetary amounts will be converted to the selected currency, based on the exchange rate defined in the Currency list.


Notes

To enable multicurrency support, choose Edit menu > Preferences. Under Setup, select Calendar and currency, and then select the Multicurrency support check box.

Show

Depending on the report you are customizing, the relevant options will display for you to select from.

  • Cents (no rounding)

    Select this check box to display amounts in dollars and cents, or click to clear the check box to display amounts in dollars. If you display amounts in dollars, Quicken rounds to the nearest dollar.

  • Totals only

    Select this check box to display only the total dollar amount of all related transactions, or click to clear the check box to list all related transactions as individual transactions. For example, if you've a category such as Auto that has three subcategories such as Gas, Insurance, and Repairs, selecting this check box displays one total amount for the category and the three subcategories. On the other hand, if you click to clear this check box, Quicken displays four amounts, one for the category and one for each of the three related subcategories.

  • Amount as % (summary reports)

    Select this check box to see each summary amount as a percentage of the total amount, or click to clear the check box to see total amounts only (in dollars and cents).

  • Difference as % (comparison reports)

    Select this check box to see the difference between the two column amounts as a percentage of the first column amount. (Negative amounts are shown in red.) Click to clear the check box to hide the percentage differences.

  • Difference in $ (comparison reports)

    Select this check box to see the dollar difference between the two column amounts. (Negative amounts are shown in red.) Click to clear the check box to hide the dollar differences.

  • Account detail (balance sheet, net worth, and account balance reports)

    Select this check box to have Quicken display subtotals by tag for all selected accounts (or by security if it's an investment account). Click to clear the check box to omit subtotals by tag (or security) for all selected accounts.

    If you select many accounts with a number of tags or securities, Quicken may take longer to generate a report with account detail.

    If you select many accounts with a number of tags or securities, Quicken may take longer to generate a report with account detail.

  • Zero-balance accounts
    Select this check box to show accounts in your report that have no balance. You can also set this preference globally at Reports only preferences.

  • Breakdown of split trans. (transaction reports only)

    Select this check box to include details from the Split Transaction dialog, or click to clear the check box to omit split details.

  • Show Columns (transaction reports only)

    Select the columns that appear in the report. This box lists the standard column headings available for the type of report you've selected. Initially, all the columns are selected for inclusion.

    You can remove columns from reports with adjustable column widths by clearing the check mark next to the column name. If you want to include all the columns again, click Reset Cols.

  • Reset Columns

    Click this button to make all the default columns appear in the report at their default widths. When you click this button, Quicken returns the check marks next to all the column names.


Note for our Canadian Customers

The following terms will be different in the Canadian releases of Quicken.

Canada: "Cheque" / United States: "Check"
Canada: "Colour" / United States: "Color"
Canada: "Centre" / United States: "Center"
Canada: "Realise" / United States: "Realize"
Canada: "Behaviour" / United States: "Behavior"
Canada: "Analyse" / United States: "Analyze"