Use the Display Tab to Modify a QuickBooks 2018 Report

By Stephen L. Nelson

The Display tab of the Modify Report dialog box in QuickBooks 2018 lets you control the report interval date, the report basis, the columns, and some other formatting.

The Report Date Range boxes — Dates, From, and To — do the same thing as the Dates, From, and To boxes in the Report window. These boxes let you control the reporting interval or accounting period. You can choose one of the date descriptions from the Dates drop-down list, or you can use the From and To boxes to specify a particular range of dates. The From and To boxes, shown here, accept dates in mm/dd/yyyy format.

The Display tab of the Modify Report dialog box for a profit and loss statement.

The Columns area enables you to control or specify how many columns a report should display. The Display Columns By drop-down list is analogous to the Columns drop-down list in the Report window. The Columns area also lets you choose a Sort By option. Again, this is analogous to the Sort By drop-down list in the Report window.

In addition, the Columns area allows you to add subcolumns (you do this with the Previous Period, Previous Year, and Year-to-Date check boxes) and add percentages. The neat thing about these percentages is that you’re actually adding financial ratios to your financial statement when you do this.

To show each line item of an income statement as a percentage of total income, select the % of Income check box.

For more report formatting options, click the Advanced button. QuickBooks displays the Advanced Options dialog box, as shown here. Use the Display Rows radio buttons to tell QuickBooks when it should or shouldn’t display rows of information in a report. Similarly, use the Display Columns radio buttons to tell QuickBooks when it should or shouldn’t display columns in a report. You can use the Reporting Calendar radio buttons to select the default annual reporting period. The default year can be a fiscal year (you set this option when setting up QuickBooks), a calendar year, or an income tax year. Click OK to activate these selections.

The Advanced Options dialog box.

To revert to the default display settings, click the Revert button on the Display tab.