GLAccountCategoryBalance Function

Definition

The GLAccountCategoryBalance provides the highest level of grouping for accounts and utilizes the AccountCategory field in the GL Accounts list to return a summarized balance.

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	Yes
Account Category	Valid Account Category based on options available for review in the GL Accounts list.	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
Posted	Specified whether to include only Posted (P) or Non-Posted (NP) Transactions. Valid values are P (default) or NP.	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

Remarks

Easily add the Accounts Category list next to an account numbers list by using the GetListInfo Function as seen below.

Example

Let's say you want to see the Account Category Balances for Asset and Liability accounts. You can use the GLAccountCategoryBalance function to return this easily.

Start by having a place whereall required function arguments can be entered
Select Finsyte Functions > GL Level Totals > GLAccountCategoryBalance
Link all function arguments including the Account Category which can either by typed in (ex: "Asset") or selected from a cell reference
Select OK to see the balance total for all accounts under the umbrella of the AccountCategory of "Asset"
Repeat for "Liability" to see the separate balance returned

Note: Right click on the amount to select Drill Down to Base Accounts which will create a new tab where all accounts under the selected category are shown with the GLAccountBalance function.