Welcome to the power of XRL

For years, accounting system users have had to struggle with complicated and inflexible reporting tools that are supposed to make things easier. In fact, they make extracting data into Excel a real trial.

XRL brings such struggles to an end. XRL is our eXcel Reporting Layer and Business Intelligent system which seamlessly integrates your financial information into Microsoft Excel in a couple of simple steps.

From now on there’ll be no more re-keying, no more copy and pasting and no more data dropping down the gap. It’ll just be fast, accurate and secure reporting and analysis.

XRL Demonstration Video

The XRL demonstration lasts approximately three minutes Demonstration Video and you can exit at any time.

Seamless integration means less frustration

With XRL, extracting data from your accounts system is astonishingly easy. You simply select what you need from the drop down menus and click.

Everything you’ve selected is immediately imported into an Excel spreadsheet for you. And if you change your mind about the data you’ve selected or want to look at things differently, a few more clicks is all it takes.

Time is money, so spend it wisely

No one can afford to spend days producing simple management reports anymore. XRL dynamically links effective and accurate reports to an Excel spreadsheet so they only take a matter of minutes to produce – so you can concentrate on getting a solid grip of your company’s financial performance.

The XRL link is live, so you’ll always be working with up-to-date information. No matter how long you spend on your analysis, your results will always be valid.

Accessing accounts data within Microsoft® Excel

XRL is an intuitive addition to the capabilities of Microsoft Excel. It provides powerful and adaptable access to the financial and distribution modules within your accounts package. With its flexibility, ease of use and advanced drilldown capabilities, XRL delivers fast and accurate information to provide enhanced analytical power.

Ease of Use

XRL really is easy to use. The XRL Wizard will help you import data into Excel. Simply select the Company for which you want to get data, identify the area of the system you are interested in and then choose the fields you want to import. Plus, it's all written in English so you don't have to work with technical jargon. Getting your company's data into Excel will now take seconds!

Accuracy and Security

The first step to using XRL is to log on to the software. This is important as it allows the system to check your user rights and thus ensure sensitive data is only accessible to the relevant personnel. Once this has been done, you can use XRL to display financial data in no time at all. What's more, it's accurate too. XRL data is extracted straight out of the finance system, therefore eliminating the input errors common in manual spreadsheet use.

Reporting Power

Now that you don't have to fiddle about entering information into a spreadsheet, you can spend more time producing valuable and detailed analysis using XRL’s powerful reporting tools.

With XRL, you can create a link between the data and a specific field in a spreadsheet so that you can design Management Reports (P & L, Balance Sheet etc.) in Excel and link the data fields 'live' into the latest accounting information. Existing XRL users report that producing Management Reports now takes hours rather than days. Further reporting power is provided by multi-dimensional analysis tools such as Cube Analysis and Pivot Tables.

Drill down to individual transactions

Not only can you export data into Excel, you can also interrogate those fields and drill down to the transactions behind them.

For example, a Turnover Value for a customer can be expanded by invoice number and then expanded again so that you can see the stock items which make up that invoice. The real power of this becomes obvious the moment you’re asked to explain a value on a spreadsheet; using drilldown to investigate the transactions behind the field, you’ll have an immediate answer without having to refer back to the accounts system.

Writeback

The easy to use Data Send facility in XRL allows you to take information which has been prepared in Excel and load it directly into the accounts system. Information such as Nominal Budgets, Price Lists and Stock Adjustments can all be entered into the Accounts System with a minimum of effort. This functionality is only available for Pegasus Opera II users. Not only does this feature save a great deal of time, it also eliminates the need to undertake mundane repetition of manual input and therefore proves most popular!

Data Cubes

Data Cubes provide multi-dimensional views of data for use in business analysis. An example of this would be where insight is needed into sales of stock items by region, sales representative, type and so on, and in any combination – this would be the sort of information that exists within the finance system, but would not be so readily available and with this degree of manipulation.

The key to Data Cubes is that information can be manipulated in many ways for a quick and effective view of trading conditions. Furthermore, the data in one of these virtual cubes can be:

Excel users who already have experience with Pivot Tables will particularly enjoy working with Cube Analysis. Indeed they may well find it even easier to select and import data into a Pivot Table when using XRL.

XRL has proven to be a popular and cost effective tool for customers operating Pegasus accounting software.