GLAccountNetIncome Function
GLAccountNetIncome Function
Definition
The GLAccountNetIncome function returns the total account balance for all transactions under the umbrella of Income, Cost of Goods Sold, Expense, Other Income and Other Expense. Because debits and credits help determine the direction of the signs for account balances, the accounts listed above are simply added together to get the Net Income balance value.
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 |
| 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 |
| Transaction Type | Transaction Type | No |
| Currency | If left blank, will default to the currency defined by the Subsidiary. Currency Names are listed in the Data Retrieval section of the ribbon. | No |
| Custom Segment Parameters | Custom segment filter values. Multiple custom segments can be specified. | No |
Remarks
While very similar in inputs to the other balance functions, the Net Income function does not require an account number input as it is consolidating transactions from many accounts.
Example
Let's say you are creating an income statement and would like to see the GL Account Net Income for your subsidiary for the entirity 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 GLAccountNetIncome function does allow for drill down to view by segments, subsidiaries, and transaction lines. Refer to the Drill Down feature for more information.