Level of detail—Financial Report Writer

You can choose to show summary rows only or show summary rows expanded by location, department, or other dimension (Summary by dimension).

This version of the Rows tab applies only if you created a financial report that features account groups on the rows of the report. Learn more about Select a report structure (new reports only).
Subscription

Company

Regional availability

All regions

User type Business
Permissions Reports: List, View, Edit

Using the Choose level of detail page, you can:

* The last option applies only if you chose the option to Filter by dimension structure on rows on the Report Info tab.

Details vs. Summary

For account groups that contain individual amounts, you can set the detail level to either show or hide accounts within the group. When you summarize an account group, additional options appear that allow you to show the breakdown by dimension, such as showing the "Fixed Assets, Net account" summarized by location.

To expand or collapse an account group that contains subgroups, exit the Choose level of detail page and select or - to the left of the account group.

Summarize and expand by dimension

Instead of displaying a single summary amount for an account group, you can create additional summary rows that break the data down by dimension. For example, expanding a "Fixed Assets, Net" account group by location would display a summary amount for "Fixed Assets, Net" with additional rows (indented underneath) that show the amount for each location.

What do the "Show" options mean when expanding by dimension?

Because many dimensions are hierarchical (for example, a US location might be organized by state, with additional locations in certain cities), the Show dropdown menu allows you to choose:

  • How many levels to show.
  • Whether amounts or reported individually, or with amounts "rolled up" from levels below it.

The following table describes each option, and provides examples.

Show options
Option Description

One level down, with rollup

Displays rows that contain summary amounts for one level only.

For example, suppose that you have locations in California, New York, and Florida. In addition, California has sublocations for Northern California and Southern California. In this case, the report:

  • Includes rows for California, New York, and Florida
  • Doesn't include rows for sublocations, such as particular regions (like Northern California). However, amounts from sublocations are included in the summary amounts for California, New York, and Florida.

All levels, with rollup

Displays rows that contain summary amounts for each level.

For example, suppose that your California location has sublocations by city. In this case, the report:

  • Includes rows for California and each city in California.
  • Includes amounts from each city in the amount for California.

All levels, with individual balance

Displays all levels, but with each level showing only the individual amounts assigned to that level.

For example, suppose that your California location has sublocations by city. In this case, the report:

  • Includes rows for California and each city within California.
  • Doesn't include amounts from each city in the amount for California.

In the case of expenses, for instance, the row for "California" would include only expenses attributed directly to California and would not include amounts from any city in California.

Leaf amounts, all levels

Displays only the lowest levels of the hierarchy.

For example, suppose you have a location in Arizona with no sublocations, but you also have a location in California, with sublocations in Los Angeles and San Jose. Choosing "Leaf amounts, all levels," would include rows for:

  • Arizona
  • Los Angeles
  • San Jose

In account groups, the leaf is the lowest account group level that has accounts assigned to it. For example:

Net Income (group of groups)

  • Expense is a group within Net Income that has accounts directly assigned to it. It's a leaf of Net Income.
  • Education Expense is a group within Net Income that has another group assigned to it but no accounts directly assigned. It is not a leaf of Net Income.

Revenue (group of groups)

  • Gross Sales is a group within Revenue that has accounts directly assigned to it. It's a leaf of Revenue.
  • COGS is a group within Revenue that has accounts directly assigned to it. It's a leaf of Revenue.

Leaf amounts, one level down

Displays only one level, but includes amounts from only the lowest levels.

For example, suppose you have a location in Arizona with no sublocations, but you also have a location in California, with sublocations in Los Angeles and San Jose. Choosing "Leaf amounts, one level down," would :

  • Include rows for Arizona and California.
  • California would include only amounts from Los Angeles and San Jose.