BudgetAccountNetIncome Function
BudgetAccountNetIncome Function
Definition
The BudgetAccountNetIncome function returns the total budget account balance for all transactions under the umbrella of Income, Cost of Goods Sold, Expense, Other Income and Other Expense. Unlike GLAccountNetIncome, the BudgetAccountNetIncome doesn't utilize debit and credit accounts so the total Net Income here is calculated by summarizing Income and Other Income and then subtracting Cost of Goods Sold, Expense and Other Expense.
Function Arguments
| Argument Name | Input Information | Required |
|---|---|---|
| Subsidiary | Subsidiary Name | No |
| Fiscal Year | Fiscal Year in the format specified in NetSuite | Yes |
| Period | Period Number (ex: 1 for January) | Yes |
| Period Range | Valid values include ITD, YTD, RTD, QTD, PTD, TTD | Yes |
| Budget Category | Budget Category | Yes |
| Book | Book Number. Default is 1 if omitted. | No |
| Item | Item ID | No |
| Class | Classification Name | No |
| Department | Department Name | No |
| Location | Location Name | No |
| Entity | Entity Name | No |
| Reserved | Reserved (ignored) | No |
Remarks
While very similar in inputs to the other balance functions, the Net Income functions do not require an account number input as they are consolidating transactions from many accounts.
Example
Let's say you are creating an income statement and would like to see the Budget Account Net Income for your subsidiary for the last period of Fiscal Year 2024. You can use a GLAccountNetIncome function to create this.
- Have your primary required parameters already in cells at the top of your report.
- Select Finsyte Functions > GLAccountNetIncome
- Fill in the required input parameters
- See the account balance returned.
Note: The BudgetAccountNetIncome function function has the right-click ability to go to the budget inside of NetSuite. Review the Go To Budget feature for more information.