The Chief Designer - Sam Smith

Consolidated XL's chief designer Sam Smith used to train customers using a leading UK SME accounting package, back in 1998, with many of the functions you see here. Many potential customers fell in love with this functionality when it was demonstrated to them. They chose the package over rival systems due to this Excel reporting functionality, enabling them to create innovative and time-saving management reports in Excel. Analyzing data from many different companies, budget tracking or by analyzing data by cost centres and departments. Know as Tracking codes in Xero, Classes and Locations in QuickBooks.

Later, he developed a set of functions that queried the accounts database for data between dates for a rival accounting package. However, its performance was poor, and it made the functions complicated. Implementing an engine to process the accounts data and summarizing it by a known period is the key.

For optimal performance, the Consolidated XL Function Library summarizes data by Account, Calendar Month/Quarter Period, and 52 Weeks of the year.

With the help of our team of programmers and under the supervision of our Chief designer, Consolidated XL is brought to you using the latest Azure and Microsoft technologies.