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 GL Account name
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 |
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