GL Account Major Headings

When using the Get GL Name/Turnover and Balance figures the following codes can be used to get the totals for Major Headings, and by Cost Centre and Departments. This allows the sheet to ensure the total is the total of the system and not an addition within the sheet which may have missed a GL code from the list of GL codes.

Code Description
Profit and Loss - Sales  
#REVENUE Revenue account
#SALES Sale account
#OTHERINCOME Other Income account
Profit and Loss - Cost of Sales  
#COS Cost of Sales
Profit and Loss - Overheads  
#OVERHEADS Overhead account
#EXPENSE Expense account
Balance Sheet - Assets  
#BANK Bank account
#ACCRECV Accounts Receivable
#CURRENTASSETS Current Asset account
#FIXEDASSETS Fixed Asset account
#LONGASSET Long Term Assets
Balance Sheet - Liabilies  
#CURRLIAB Current Liability account
#LONGLIAB Long Term Liability account
ACCPAY Accounts Payable
#CREDITCARD Credit Card
Balance Sheet - Equity  
#EQUITY Equity account

Calculated Headings

In order to produce Profit and Losss/Income statement, Trail Balance or Balance sheet we prvide a number of calculated totals for reporting. These will return a total as checked by Consolidated XL against the accounts and thus if an account is missing from the report, unfortunetly you have to maintain these after report creation if a new GL account is added to the system, these totals will be correct.

You could add you own cacluations to check your totals, against these value to verify all GL accounts are listed.

Code Description
Profit and Loss  
#CalcTotalSales Total Sales
#CalcTotalCOS Total Cost of Sales
#CalcGrossProfit Gross Profit
#CalcTotalOverhead Total Overhead
#CalcNetProfit Net Profit
Balance sheet  
#CalcTotalCurrentAsset Total Current Assets
#CalcTotalFixedAsset Total Fixed Assets
#CalcTotalAsset Total Assets
#CalcTotalCurrentLiab Total Current Liabilities
#CalcTotalLongLiab Total Long-Term Liabilities
#CalcTotalLiab Total Liabilities
#CalcTotalLiabEquity Total Liabilities + Equity
Trail Balance  
#CalcTotalTrialBal TB Total

Items under Headings

When using CXL.GLValSpill() you can use "#Cat..." codes to get all items in a part of the Chart of Accounts. This allows you to create dynamic reports that will update as new GL accounts are added to the system.

Code Description
Profit and Loss  
#CatSales Total Sales
#CatCOS Total Cost of Sales
#CatOverhead Total Overhead
Balance sheet  
#CatCurAsset Total Current Assets
#CatFixAsset Total Fixed Assets
#CalcTotalAsset Total Assets
#CatCurLiab Total Current Liabilities
#CatLongLiab Total Long-Term Liabilities
#CatEquity Total Liabilities + Equity