In this article:
Overview | Your account | Configure

Introduction

Many companies depend on complex Excel spreadsheets to run their reports and budgets: lots of linked workbooks, complex formulas, and multiple copies of data. Preparing reports often requires manual work and is usually time-consuming and repetitive.

We developed XLReporting as a better and more robust way. Set up your company structure once, import your data, and you can create dynamic reports, charts, and dashboards in an automated manner.

XLReporting is flexible, configurable, and protects your data through secure hosting and user access rights. You can import data from a wide variety of sources (e.g. accounting systems, text files, Excel workbooks, 3rd party API's etc), and combine everything into a single data store.

Process overview

Let's take a look at the overall process within XLReporting:

diagram overview introduction

It all starts with your existing data, which you can import and store in XLReporting.

As part of importing your data, you can validate, transform, lookup, recalculate the data any way you want. For example, you can look up currency rates, account codes, or make calculations. XLReporting will store the resulting information into its own database (the "data sets"), where it is instantly available for reporting and budgeting.

Start with your account

When you sign up, your account already contains a number of predefined reports, models, imports, and data sets. It shows example financial data of a fictitious coffee company based in 4 countries around the world (we really like coffee ..).

This should give you an quick impression of the capabilities of XLReporting, but ofcourse you really want to see it with your own data. We understand that. So, with just a few simple steps and using our Excel templates you can import your own data in a few minutes.

Configure your own

Your account already contains predefined objects for common financial reporting. That gives you working examples to start with, which you can amend or expand over time.

You can configure XLReporting through 4 types of objects:

  • Data sets - define how you want to store your data. Think of it as an Excel sheet, or a database table. You can configure as many data sets as you want, define the columns and types of data, and then import data into them.
  • Imports - define how you want to transform and filter your existing data into data sets in XLReporting. You can also apply conversions, lookups, and calculations. We have pre-defined a number of imports for common finance systems, but you can also create your own imports.
  • Reports - define the logic and layout of your reports. You can define calculations, filters, and multiple layouts for each report.
  • Models - define the logic and layout of your models. Models can be used for 2 purposes:
    • Reporting - combine diverse types of information, formulas, calculations, charts, and KPI's into one single report.
    • Planning - combine reports, data lookups, formulas, and editors into planning models which you can save back into data sets.

All objects in XLReporting are implicitly linked. You don't have to do this, XLReporting does it for you automatically. This protects the integrity of your information.