Bundling NetSuite Financial Statements

Financial statements, which include income statements, balance sheets, and cash flow statements, are specialized reports that use layouts to determine their look and feel. A financial statement layout is a set of definitions for report rows, including the rows and financial sections to be displayed, row order and hierarchy, section filter criteria, methods for calculating summary amounts, row labels, and text, line, and background formatting options.

When you include a custom financial statement in a bundle, the custom layout assigned to the report is automatically bundled as well. The layout, as well as the report, is added to each target account when the bundle is installed.

You can assign layouts to financial statements, and view layout assignments, at Reports > Financial > Row Layout Assignment. Be sure to review these before bundling financial statements. Whenever possible, the assignment of a layout to a bundled financial statement from the source account is preserved in target accounts. If there is ambiguity about this assignment, it is not preserved in target accounts, and users in these accounts can set up the assignments themselves.

For example, in OneWorld accounts, NetSuite provides specialized country-specific layouts for each subsidiary's financial statements, so that each custom layout is associated with a subsidiary as well as with a financial statement. If the source account for a bundled financial statement uses OneWorld, the layout assignment in the source may not be preserved in the target, because the associated subsidiary in the source may not exist in the target.

In cases where the assignment is not preserved, the layout is still added to the target account. After bundle installation, a target account user should review the layout assigned to the bundled financial statement and change this assignment as necessary, at Reports > Financial > Row Layout Assignment. For details, see Financial Reports: Row Layout Assignment Page.

Important:

An update to a bundle that includes a custom financial statement updates the report and the layout objects, but does not update the layout assignment in target accounts. If the assignment has been changed in a target account since the bundle was originally installed, the update does not revert the change.

Note:

SuiteBundler cannot properly match up data for financial statements installed from two different bundles sourced from a sandbox account. To avoid duplicate sections and rows in financial statements, use only one bundle to install them from a sandbox account to a production account.

Related Topics