Get GL Name

On this Page:
 Get GL Account Name
 Major Headings
 Calculated Headings

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 a Income Sattement or Balance sheet using excel form Xero or Quickbooks
Get GL Account name

Syntax: =CXL.GLName ( CompCode, GlCode )
Performance Rated:A

   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 Major Headings for these '#' codes. #OTHERINCOME,#COS,#OVERHEADS,#BANK, #ASSET, #LIABILITY, etc.

   Wizard: Try out the Income Statement/P&L Wizard , which generates multiple sheets. The "Income 12 period" sheet demonstrates this feature in action and serves as an excellent starting point for your report creation.

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