Multi-Book Income Statement Report
Please contact your sales or account representative to find out how to get Multi-Book Accounting. The assistance of NetSuite Professional Services is required to implement this feature.
Multi-Book Accounting is available only in NetSuite OneWorld accounts.
The Multi-Book Income Statement report enables you to compare the income and expenses for a specific period of time for two different accounting books. This comparison is useful for reconciling one accounting book against another.
In the report footer, from the Accounting Book 1 and Accounting Book 2 lists, select the accounting books for which the report is to display data, or accept the default accounting books. The data that displays includes automatically calculated accounts such as Net Income. Data appears in the Amount (Book 1) and Amount (Book 2) columns. Any difference appears in the Difference column.
If the currencies between the accounting books are different, the Difference column is blank.
The standard Multi-Book Income Statement report includes the following rows:
-
Ordinary Income/Expense (header row)
-
Income (financial section)
-
Cost of Sales (financial section)
-
Gross Profit (formula row)
-
Expense (financial section)
-
-
Net Ordinary Income (summary row)
-
Other Income and Expenses (header row)
-
Other Income (financial section)
-
Other Expenses (financial section)
-
-
Net Other Income (summary row)
-
Net Income (formula row)
Header and summary rows are linked. Each summary row is calculated either through a sum of child row amounts or through a specified formula. The Net Income row is a formula row that sums Net Ordinary Income with Net Other Income. Standard Income Statement section data is selected based on account type and is grouped by account.
You can customize the Multi-Book Income Statement report in the Financial Report Builder. You can add, reorder, and change the hierarchy of rows. You can also add these columns: Amount (Book 1 - Generic), Amount (Book 1 - Specific), Amount (Book 2 - Generic), Amount (Book 2 - Specific). The sum total of the book generic and book specific transactions in an accounting book is equal to the value in the Amount column for that accounting book. Columns displaying only book specific transactions, book generic transactions, or the difference are not linked. For information see Financial Statement Rows and Editing a Financial Statement Section.
You can use dynamic criteria other than account type for section data, including account name, account number, class, department, location, and subsidiary. In addition to account type, you can group section data by class, department, location, and subsidiary. You can set formatting options for each row. For more information, see Financial Report Builder. Be aware that the Allow Web Query option is not available for this report.
Also, you can add a Percent of Expense or Percent of Income column to your Income Statement. See Adding a Percent of Income Column to an Income Statement.
To see the Multi-Book Income Statement report:
Go to Reports > Financial > Multi-Book Income Statement.
A message appears indicating that your report is loading. The status bar in the footer of the report indicates the progress as your report loads. Click Cancel Report next to the status bar to stop the report from loading.
In the footer of the report, select from filter lists to refilter report data. You also can select from the Column list to display report amounts by an additional dimension, including time period, class, department, location, or subsidiary.
For information about the permissions required to view and customize financial statements, see Permissions and Roles.
The Report by Period user preference determines whether report data is calculated by date range or by period. This preference is available at Home > Set Preferences on the Analytics subtab. To display this report's data by date range, set this preference to Never. To display this report's date range by period, set this preference to All Reports or to Financials Only. For more information, see Choosing a Date or Period Range for a Report.
The Multi-Book Income Statement report may be run on a cash basis. The Cash Basis Reporting preference applies to all standard reports that support cash basis reporting. This preferences is on the General tab under General Ledger at Setup > Accounting > Preferences > Accounting Preferences. If this preference is not enabled, you can create a custom cash basis Multi-Book Income Statement report by enabling the Cash Basis option on the More Options page of the Financial Report Builder. See Setting Up Cash Basis Reporting.
Click an Account Name in the Accounting Book 1 column to access General Ledger report data for the account. The data in the Balance column may vary from data in the Multi-Book Income Statement Amount column. This difference occurs because the Amount column is the account balance from the specified report period only, while the Balance column is a running account balance that includes the amount from the prior period as a beginning balance.
Three key performance indicators (KPIs), Income, Expenses, and Profit, can be added to your dashboard to provide at-a-glance views of totals from the Multi-Book Income Statement report. For more information about KPIs, see Setting Up the Key Performance Indicators Portlet.