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.
Let's take a look at the overall process within XLReporting:
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.
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.
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:
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.