CIC Hospitality manages 20 hotels in the Nordics region, some of which operate independently and use different types of software.

The group CFO requires consolidated data for monthly board reports. This data must be sourced from a wide range of different systems, each specific to the respective hotels. Additionally, the data requires transformation; for instance, accounting data must be mapped to a unified Chart of Accounts, and currencies must be converted based on daily rates.

Prior to using Peliqan, this data was gathered manually, resulting in a significant amount of time spent on repetitive work.

Consolidated board reports rely on data from various sources that need to be combined and transformed.

For instance, accounting transactions must be mapped to a unified Chart of Accounts, and transaction amounts must be converted into a single currency using the correct transaction date rate.

Moreover, board reports require a specific layout that is easy to maintain and update, and a Google Sheet template is typically utilized for this purpose.

Peliqan.io is leveraged to establish connections with various data sources, predominantly SaaS platforms, used by the hotels.

The master Google Sheet file maintains the Charts of Accounts, which is also connected to Peliqan. The transformation process involves SQL statements, as well as formulas found in Peliqan's built-in spreadsheet.

Additionally, a public API connection is utilized to acquire currency conversion rates for all dates. After transformation, the data is consolidated and the aggregations are written into a Google Sheet file, in accordance with the Google Sheet template file.

As a result, a fully automated board report is generated monthly, containing key figures and metrics unique to the hospitality industry.

Peliqan

Write a review for Peliqan

Please fill the form below

Budget

Quality

Schedule

Communication