See it. Understand it. Build it.

Your accounts.
Your Excel.
Your way.

Consolidated XL provides a powerful set of simple Excel functions, used on Mac, PC and Web Excel to facilitate Consolidated Financial Reporting, and Analysis, by hot linking one or more cells, in your sheet, to your chart of accounts in QuickBooks or Xero using simple to master functions.

Watch the GL Spill demo Start your free trial

60+ Excel functions
10+ report wizards
PC · Mac · Web Excel 365

Original Consolidated XL product flow from accounting platforms into an Excel report

Video walkthrough below

A video tells a thousand words

Watch one formula become a live Excel report.

The GL Spill training demonstrates lists of accounts, multiple reporting periods, whole P&Ls and balance sheets, cost-centre filters and wizard-created reports.

TRAINING 2GL Spill Functions

Explore spill functions

You have the power

Drill Down, Wizards,
Locations and Classes.

Create an interactive report any way you want.

Consolidated XL wizard producing a consolidated balance sheet — **Kick Start with Wizards**
Choose the companies and reporting options, then generate a consolidated balance sheet or P&L in minutes. The finished workbook stays fully editable in Excel.
Explore wizards

Profit and loss analysis by sales representative — **Cost-centre analysis**
Break reports down by Xero tracking categories, QuickBooks classes or locations, and Sage cost centres or departments to compare teams, regions or representatives.

Quick Charts showing sales by representative, period and quarter — **Quick Charts and drill-down**
Select any CXL figure to open trend charts, cost-centre breakdowns and the transactions behind the number—without leaving Excel.
Explore drill down

Granular functions

One cell.
One precise answer.
Complete flexibility.

Spill functions can generate a complete report at speed. Granular functions give you the individual building blocks, so every value, comparison, formula and chart can be arranged exactly as your business needs.

HOT LINK GRANULAR VALUESfx

=CXL.GLVal("COMP_A", "200",
2023, 1, "MARK")=CXL.GLVal("COMP_A", "#SALES",
2023, 1, "MARK")

Get Period 1 in 2023 for Class “MARK” and Account 200—or all Sales in the second example—from Company A.

More about these # codes

Figures by:Accounting periodsCalendar monthsAccounting quartersCalendar quartersWeeksBetween dates

Choose the exact value

Target an individual GL code or a major heading such as Sales, Cost of Sales, Profit or Overheads.

Report your way

Work by accounting period, calendar month, quarter, week or a specific date range.

Analyse every dimension

Filter by Xero tracking categories, QuickBooks classes or locations, and Sage cost centres or departments.

Keep Excel in control

Place linked values anywhere, combine companies, add your own calculations and build completely bespoke reports.

Explore granular functions

Because seeing is understanding

Now build the report yourself.