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 Note: Balance sheet item values are reported at the end of a financial year or reflect the current balance for this financial year.
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 Note: Balance sheet item values are reported at the end of a financial year or reflect the current balance for this financial year.
#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 and headings under a category

When utilizing CXL.GLValSpill(), you can use "#Cat..." codes to retrieve all items and headings associated with a category in the Chart of Accounts. This feature enables you to create dynamic reports that automatically update as new General Ledger accounts are added to the system.

Code	Description
Profit and Loss
#CatSales	Total Sales
#CatCOS	Total Cost of Sales
#CatOverhead	Total Overhead
Balance Sheet Note: Balance sheet item values are reported at the end of a financial year or reflect the current balance for this financial year.
#CatCurAsset	Total Current Assets
#CatFixAsset	Total Fixed Assets
#CalcTotalAsset	Total Assets
#CatCurLiab	Total Current Liabilities
#CatLongLiab	Total Long-Term Liabilities
#CatEquity	Total Liabilities + Equity