PART 4.2 – Financial Statement Creation

You need both the Financial Statements permission and the Report Customization permission to access the Financial Report Builder. 

You can access the Financial Report Builder in any of the following ways: 

• Run a financial statement, and on its results page, click Customize. 
• Go to Reports > New Financial Report, and select a financial statement type from the New Financial Report – Select Financial Statement page. 
• Go to Reports > Reports Overview. In the Saved Reports, Financial, or Banking/Budgeting lists, click Customize for a report that uses the Financial Report Builder. 
• Go to Reports > Financial > Row Layout Assignment. Click Customize next to a standard financial statement, or click Edit next to a custom financial statement. 

Financial Report Builder Edit Layout Page

This page includes a Layout outline that displays the order and hierarchy of all financial statement rows. In this outline, you also can add, move, and delete financial sections and rows as necessary.

• When you edit an existing custom financial statement, the initial layout is the custom layout for the custom financial statement when it was created or last edited. 
• If you are using NetSuite OneWorld, the layout displayed in the Financial Report Builder is based on the subsidiary context you last selected. To customize a layout for a different subsidiary context: 
  1. Rerun the financial statement. 
  2. Select the desired subsidiary context from the footer dropdown list. 
  3. Click Refresh. 
  4. Click Customize to restart the Financial Report Builder.

• You cannot rename a layout on the Edit Layout page. To rename a layout, go to Reports > Financial > Financial Row Layouts.
• To add a financial section or row, select a row type from the Add Row/Section… dropdown list in the Layout outline. The row is added above the currently selected row. 
• To move a financial section or row, select it in the Layout outline. Then click the up arrow or down arrow buttons or drag and drop it to desired place. 
• To delete a financial section or row, select it in the Layout outline, and click the delete button. 

To edit selection criteria for an existing section: 

1. Select a financial section in the Layout outline. 
2. In the right pane of the Financial Report Builder on the Section subtab, click Edit Criteria.
3. In the Edit Section Criteria popup, click OK to indicate that you are creating a new custom section. 
4. You can insert and remove filters. 
   • To add a filter, select a field from the list in the Filter column. 
   • In the Filter popup that opens immediately after you select a filter, select one or more values to indicate the criteria to be applied to this section. You also can click Set Options to open this popup. 
   • If you want to use parenthetical expressions to define section data filters, check the Use Expressions box. This option functions here in the same manner as it does for search criteria. 
5. If you want this custom section to be available for use in other custom financial layouts, click Share Section. 
   • In the Share Section popup, click OK. 
   • Change the section name/ID as desired. 
6. Make other changes to the section as desired.

To add a new custom section to a custom financial statement: 

1. In the Layout outline, select the row where you want to insert the new section. The section is added above the selected row. 
2. From the Add Row/Section… list, select Add Financial Section. 
3. In the New Section Row popup, choose the Create New Section option, and click OK. 
4. You can insert and remove filters. 
   • To add a filter, select a field from the list in the Filter column. 
   • In the Filter popup that opens immediately after you select a filter, select one or more values to indicate the data that will be included in this section. You also can click Set Options to open this popup. 
   • If you want to use parenthetical expressions to define section data filters, check the Use Expressions box. This option functions here in the same manner as it does for search criteria. 
5. If you want this custom section to be available for use in other custom financial statements, click Share Section. 
   • In the Share Section popup, click OK. 
   • Change the section name/ID as desired. 
6. Make other changes to the section as desired. 

To edit header and summary rows:

1. 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. 
2. 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.)
3. Edit the Header Label. This is the header row’s text. 
4. Choose whether to display the header row. To hide this row, clear the Display Row box. 
5. 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. 
6. Choose whether to display the Summary row. To hide this row, clear the Display Row box. 

Modifying Financial Section Hierarchy 

You can change a financial section’s placement in the report hierarchy by selecting a different row in the Child Of list. The section is moved under the row you select here, as reflected in the Layout outline. 

Alternatively, you can drag and drop a financial section in the Layout outline to change its hierarchy. 

Modifying Financial Section Row Expansion 

You can indicate the expansion of financial section data, by selecting from the Display list: 

• Expanded – the section is displayed in expanded format, showing all rows. Viewers can collapse it. This is the default. 
• Collapsed – the section is displayed in collapsed format, showing a header row with a summary amount. Viewers can expand it. 
• Cannot Expand – the section is displayed in collapsed format. Viewers cannot expand it. 

Modifying Financial Section Grouping 

By default, financial section data are grouped by accounts. 

• You can select from the Group By dropdown list to change this primary grouping to be by class, department, location, customer/project, item, or if you are using NetSuite OneWorld, subsidiary. 
• You also can set an optional, secondary grouping in the Then By dropdown list to be by accounts, class, department, location, customer/project, item, or subsidiary. 

The Show Hierarchy check boxes next to the Group By and Then By dropdown lists indicate whether full hierarchical names are used for group labels and sort order. Full hierarchical names are in the format of grandparent : parent : child. Non-hierarchical, or flat, names include only the child. By default, these boxes are checked and full hierarchical names are used. 

Modifying Financial Section Sort Order 

Within each grouping of financial section data, you can define the sort order of account rows on the Order subtab. Note that if you have defined a secondary grouping, two Order subtabs are provided. 

Modifying Financial Section Format Options 

You can modify the formatting of text, lines, and background color for section rows, including the header row that displays a description of the section, account rows that display data amounts, and the total row that displays the total amount for the section. Note that the same format options are applied to all account rows in a section. You also can indicate whether to show currency symbols, reverse signs, or include text, such as USD, before or after amounts for the account rows and total row. 

You cannot change whether account numbers are displayed. Account names include account numbers when the accounting preference Use Account Numbers is checked. 

You can make these edits on the Format subtab. 

To define a formula to calculate a summary row:

1. When a header and summary rows combination is selected in the Layout outline, choose the Apply a Formula option. 
2. 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.

To edit Financial Statement Reference Row:

1. In the Layout outline, do one of the following:
   1. Select the row below the place where you want to add a new reference row, and from the Add Row/Section list, select Add Reference Row. 
   2. Select an existing reference row. 
2. You can select the financial statement (Report), the financial section or row (Row), and the date range (Relative Range) to be referenced for a reference row value.
   

1. Select the row below the place where you want to add a new text row, and from the Add Row/Section list, select Add Text Row. 
2. Select an existing text row. 
3. You can edit the Text to display in a text row. Clear the Display Row box to display a blank row. 
4. You can change a text row’s placement in the report hierarchy, by selecting a different row in the Child Of dropdown. The text row is moved under the row you select here and is reflected in the Layout outline at left. 
   Alternatively, you can drag and drop a text row in the Layout outline to change its hierarchy.