The following functions compliments Consolidated XL functions used to get GL Account values. GLName() hot link the name of a GL Account or its Heading.

   The Wizard "Get GL Values Example Wizard" shows how to use the functions below. It's best to create a sheet using the wizard, to understand the use and possibilities.

Get GL Account Name

Get GL Account name

   For a tutorial on this function, click here

Returns the name of the General Ledger Account name, or Heading see below.

Examples: Get Name of account by Code

Example Query	Function and Parameters	Value Returned
Get name for account 230	=CXL.GLName( “EXAMP01”,230 )	Sales of Books
Get name for account 835	=CXL.GLName( “EXAMP01”,835 )	Directors Loan Account
Get name for account 091	=CXL.GLName( “EXAMP01”,091 )	Business Savings Account

Examples: Get Name of Major Headings

Example Query	Function and Parameters	Value Returned
Get name for heading #SALES	=CXL.GLName( “EXAMP01”,"#SALES" )	Sales
Get name for heading #FIXEDASSETS	=CXL.GLName( “EXAMP01”,"#FIXEDASSETS" )	Fixed Asset account
Get name for heading #CURRLIAB	=CXL.GLName( “EXAMP01”,"#CURRLIAB" )	Current Liability account

See Xero Major Headings, QuickBooks Major Headings or Sage Major Headings for the defined GL Major Headings.

GL Account Major Headings

When using the Get GL Name/Turnover and Balance functions the total of a Chart of Accounts section can be returned using special codes, such as #SALES, #COS, #BANK, #CURRLIAB, #CURRENTASSETS and #EQUITY.

Accounting packages differ in their Major Heading analysis. Click for Xero, QuickBooks or Sage list for a more detailed list