Editing Financial Statement Header and Summary Rows
In NetSuite financial statements, header rows and their linked summary rows are used to aggregate related rows of data. The header row appears above its set of child rows and usually contains descriptive text. The summary row appears below the set of rows and summarizes the row amounts. This summary can be a dynamic total that adds all row amounts or a calculation based on a more complex formula.
The following screenshot points out header rows and their linked summary rows. These header rows differ from section header rows in that they do not include their own account rows, but instead group data from other rows.
|
1 |
Header row: Assets |
|
2 |
Summary row: Assets |
|
3 |
Header row: Current Assets |
|
4 |
Summary row: Current Assets |
|
5 |
Header row: Liabilities & Equity |
|
6 |
Summary row: Liabilities & Equity |
To edit header and summary rows:
-
Start the Financial Report Builder, and ensure an editable custom layout is selected in the Edit Layout page. For information, see Accessing the Financial Report Builder.
-
In the Layout outline, do one of the following:
-
Select the row below the place where you want to add a new header row, and from the Add Row/Section list, select Add Header and Summary Rows.
-
Select an existing header row or linked summary row that you want to edit. (Notice that whenever you select a header or summary row, its linked row is also selected, and you can edit properties for both rows.)
-
-
Complete any of the following tasks:
Editing Header and Summary Labels
You can:
-
Edit the Header Label. This is the header row's text.
-
Choose whether to display the header row. To hide this row, clear the Display Row box.
-
Edit the Summary Label. This is the summary row's text. If this field is left blank, the default label Summary - <Header Label> is displayed.
-
Choose whether to display the Summary row. To hide this row, clear the Display Row box.
Modifying Header Row Hierarchy
You can change a header row's placement in the report hierarchy by selecting a different row in the Child Of dropdown. The header row is moved under the row you select here. This move is reflected in the Layout outline.
Alternatively, you can drag and drop a header row in the Layout outline to change its hierarchy.
Modifying Header Row Expansion
You can indicate the expansion of data rows under a header row by selecting from the Display dropdown:
-
Expanded – data rows are displayed in expanded format. Viewers can collapse the header row to hide other rows. This is the default.
-
Collapsed – the header row is displayed in collapsed format. Viewers can expand it.
-
Cannot Expand – the header row is displayed in collapsed format. Viewers cannot expand it. In this case, the summary amount is displayed and the details that make up the summary cannot be seen.
Setting Summary Calculation Method
By default, a summary row displays a sum of amounts for the group of rows under its linked header. This sum is dynamic. This means it changes when any of the row amounts change. The Financial Report Builder also enables you to define a formula to calculate the summary.
Enabling the Reverse Sign option for a row affects all dynamic total calculations that include that row's value.
To define a formula to calculate a summary row:
-
When a header and summary rows combination is selected in the Layout outline, choose the Apply a Formula option.
-
Use the formula builder to enter an expression. Add each value on a separate line.
-
Select an operator if needed. Addition (+), subtraction (-), multiplication (*), division (/), and percentage (%) operators are available.
-
Select opening parentheses if needed.
-
Indicate whether the type of value is a constant number (Constant) or a value from another row in the report (Row).
-
Enter the value, which is a field or a dropdown depending on the value type you select.
-
Select closing parentheses if needed.
-
Repeat until the formula expression is complete.
-
Review the expression displayed at the top of the formula builder for correctness, then make adjustments as necessary.
-
Modifying Header and Summary Row Format Options
You can modify the formatting of text, lines, and background color for header and summary rows. You also can indicate whether to show currency symbols, reverse signs, or include text, such as USD, before or after the summary row amount.
Enabling the Reverse Sign option for a row affects all dynamic total calculations that include that row's value.
For more information, see Setting Financial Statement Formatting Options.
You need both the Financial Statements permission and the Report Customization permission to customize reports in the Financial Report Builder. If you do not have necessary permissions, contact your account administrator. See Giving Access to Financial Statements for more information.