Budget Income Statement Detail Report
The Budget Income Statement Detail report enables you to view budgeted amounts for income, cost of goods sold, and expenses, including projected net income, for a specific time period. This report includes individual transactions, and totals for each account and category.
Because budgets are set up by period, this report does not display budget data accurately if the Report by Period preference is set to Never. If your report's budget columns are displaying zeros, go to Home > Set Preferences, and on the Analytics subtab, set the Report by Period preference to All Reports, or to Financials Only.
The standard Budget Income Statement Detail report includes the following rows by default:
-
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 header row provides a text description for its set of child rows. 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.
You can customize the Budget 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. For more information, see Financial Report Builder . The Allow Web Query option is not available for this report.
Custom segments are not included in the Budget and Financial fields of the Financial Report Builder for budget-related reports.
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 Budget Income Statement Detail report:
Go to Reports > Banking/Budgeting > Budget 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. You can click Cancel Report next to the status bar to stop the report from loading.
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.
For information about the permissions required to view and customize financial statements, see Permissions and Roles.
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 Budget 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 Budget 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.