Reporting & Business Intelligence

You need an IT Partner who can provide a reliable IT service for your business.

Comprehensive Business Intelligence

> The information you need the way you want it:

Heart Business Systems understand that Financial Reporting is essential to any modern business. We are specialists in the creation of custom Financial Reports & other documents (custom invoices/purchase orders/delivery notes/ picking lists/etc.).

Heart Business Systems can also develop specialised import & export routines allowing you to transfer data however and wherever you require (for example bespoke data exports from your Web Site into your Accounts System or visa-versa).

As a part of the Pegasus Opera solutions, Heart It can also provide live data links between Pegasus Opera and Excel for advanced reporting with endless scope for customisation and drill-down functionality.

Last but not least; Heart Business Systems are also experienced in the configuration and deployment of Dashboard style reporting, usually accessed via secure web-browser log-in.

  • Custom Financial Reporting
  • Bespoke Documents (Invoices, Purchase Orders, Delivery Notes, etc.)
  • Import & Export Routines
  • Excel Reporting
  • Dashboards & Notifications

> Pegasus XRL: Accessing accounts data within Microsoft® Excel:

Pegasus XRL provides powerful and adaptable access to the financial and distribution modules within Opera 3. With its flexibility, ease of use and advanced drilldown capabilities, Pegasus XRL delivers fast and accurate information to provide enhanced analytical power.

> Ease of use:

Pegasus 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 plain 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 Pegasus 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 Pegasus XRL to display financial data in no time at all. What's more, it's accurate too. Pegasus XRL data is extracted straight out of Opera 3, 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 Pegasus XRL’s powerful reporting tools.

With Pegasus 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 financial information. This means 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.

> Pegasus XRL drilldown: 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 Data Send facility in Pegasus XRL is easy to use and allows you to take information which has been prepared in Excel and load it directly into Opera 3. Information such as Nominal Budgets, Price Lists and Stock Adjustments can all be entered into Opera 3 with a minimum of effort. 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:

  • Sliced (eg. breakdown company turnover by customer)
  • Diced (see which products those customers buy)
  • Drilled (see details of every invoice for that customer and product)
  • Charted (instant chart will provide a concise and clear visual representation of selected data – ideal for spotting problems and errors)
  • Distributed (Cube Analysis results can be saved as an Excel Spreadsheet or PDF and quickly dispatched to people)

The Cube Analysis feature within Pegasus XRL provides an efficient and easy way of working with Data Cubes so that data analysis can be undertaken rapidly and with the minimum of fuss. The result is that many finance departments can conduct interesting and thorough investigation into performance data, spotting trends, problems and opportunities and therefore providing a value added service for the organisation.

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 Pegasus XRL.

Got an IT Question?


Heart Business Systems Ltd.
Unit 314/315 The Big Peg
120 Vyse St
Birmingham B18 6NF
© Heart Business Systems Ltd. A company registered in England & Wales Company Registration Number: 06841822