In this article:
Overview | 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.

Configure your own

You can configure XLReporting through 4 types of configurable 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.

When you sign up, your account already contains demo data, reports, imports, and data sets for common financial reporting. So you don't have to start from scratch, you'll have working examples which you can start to use, and amend or expand over time.

Recommended reading:
Back to top | Navigation | Data sets | Imports | Reports | Models