Skip to main content

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 NameInput InformationRequired
SubsidiarySubsidiary NameNo
Fiscal YearFiscal Year in the format specified in NetSuiteYes
PeriodPeriod Number (ex: 1 for January)Yes
Period RangeValid values include ITD, YTD, RTD, QTD, PTD, TTDYes
BookBook Number. Default is 1 if omitted.No
ItemItem IDNo
ClassClassification NameNo
DepartmentDepartment NameNo
LocationLocation NameNo
EntityEntity NameNo
Transaction TypeTransaction TypeNo
CurrencyIf 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 ParametersCustom 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.

  1. Have your primary required parameters already in cells at the top of your report.
  2. Select Finsyte Functions > GLAccountNetIncome
  3. Fill in the required input parameters
    1. GLAccountNetIncome Function Inputs
  4. See the account balance returned.
    1. GLAccountNetIncome Result

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.