Built for responsive reporting
Understand function performance at a glance
Consolidated XL is designed to return financial reporting data quickly. Use these ratings to choose the most efficient function for each workbook.
The performance engine
F.A.S.T. financial summaries
Financial Accounting Summarization Tables keep the information used most often by reports ready for efficient retrieval.F.A.S.T. summarises financial information by financial period and week. Consolidated XL can therefore retrieve turnover or balances for a year, quarter, period, month or week very quickly. This summarised data powers the A- and B-rated functions below.
Speed guide
Function ratings
Higher-rated functions return broader sets of reporting data with fewer database reads.Instant calculations
No database read required
These functions are simple calculations and do not need to read from the database.
Functions Get Period Name/Date, Get Company Info and Get Last Sync Info.
Spill functions
Many values from one call
Spill functions return multiple values to the worksheet in one call. =CXL.GLVALSPILL("COMP01","#ReportPL") or =CXL.GLVALSPILL("COMP01","#ReportBal") can return a whole profit and loss report or balance sheet. Run the “Get GL Values Demo” wizard and review its fourth example sheet.
Core financial reporting
Optimised and memory-cached
Balance and turnover functions for the chart of accounts, including Cost Centre and Department analysis, are highly optimised. When a year is requested, its F.A.S.T. data is loaded once and subsequent figures are returned from memory.
Functions GL turnover and balance history by week, month or period; GL Name; receivable and payable debts; and predicted future receivables and payables.
Detailed analysis
Efficient period-based records
Customer, vendor and stock turnover for each period is stored efficiently. These functions perform well, although they do not read an entire year from one F.A.S.T. record in the way A-rated functions can.
Functions Budgets; contact and stock turnover by week, month or period; Cost Centre and Department analysis; stock profit and margin; currency rates; and unrealised currency.
Individual record reads
Best for focused queries
These functions read one customer, vendor or stock item from the database at a time. They are suitable for focused queries of 10–20 records, but large requests containing thousands of items will take longer.
Functions Get Contact Info and Get Stock Info.
Value-by-value queries
Use for small result sets
These functions must query the source table for every value. Performance is suitable for small requests, but thousands of individual values will take considerably longer.
Function Get Last Cost.