Income Statement Detail Report
The Income Statement Detail report shows individual transactions for a specified time period for each income and expense account and the totals for each account and category.
The standard Income Statement Detail 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 section data are selected based on account type and are grouped by account.
The Income Statement Detail report may display a Split column. The Split column displays the other account involved in the double-entry bookkeeping notation. If more than one account was used to offset this distribution, you see the notation -Split- in the Split column.
The account you see in the Split column depends on how you view the reports:
-
If the main line account is in the Financial Row column, you will see the other account used in the transaction.
-
If the main line account is not in the Financial Row column, you will see the main line account used in the transaction.
The main line refers to the Primary Information field group in a transaction.
NetSuite does not write foreign currency amounts for cost of goods lines. Item Fulfillment and Item Receipt are noted in base currency only.
You can customize the Income Statement Detail report in the Financial Report Builder. You can add, reorder, and change the hierarchy of rows. You can use dynamic criteria other than account type for section data, including account name, account number, class, department, location, and if you are using NetSuite OneWorld, subsidiary. In addition to account type, you can group section data by class, department, location, and if you are using NetSuite OneWorld, 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 Expense Column to an Income Statement or Adding a Percent of Income Column to an Income Statement.
To see the Income Statement Detail report:
Go to Reports > Financial > Income Statement > Detail.
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.
If employee information is masked and you require this information, contact your account administrator.
In the footer of the report, you can select from filter lists to refilter report data. Click the More arrow button to display all footer lists. For more information, see Setting Report Footer Options.
Inactive classes, departments, locations, and subsidiaries are available as filters to provide historical reporting and to avoid unbalanced totals.
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 Income Statement Detail 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 the preference is enabled, the Income Statement Detail is on a cash basis rather than an accrual basis. If this preference is not enabled, you can create a custom cash basis Income Statement Detail 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 to view General Ledger report data for the account. The data in the General Ledger Balance column may vary from data in the Income Statement Detail Amount column. This difference occurs because the Amount column is the account balance from the specified report period only, but the Balance column is a running account balance that includes the amount from the prior period as a beginning balance.