ALCHEMEX Keypoints

Key Features of Alchemex Business Intelligence Software include:

  • Alchemex Management Packs
    With the Alchemex management pack you can run your end of month reports directly to Excel with the click of a button.
  • Alchemex Dashboards
    With Alchemex Dashboards you can see a graphical representation of how your sales are travelling, inventory movements, creditor purchases and much much more. View a demo here.
  • Customise Report Templates
    Want a P & L or balance sheet in a certain format? Not a problem, with Alchemex you can edit the formats in excel and save them to be used over and over again.
  • Alchemex ODBC Connectivity
    Although Alchemex is integrated into a number of Market Leading Accounting Packages including Sybiz Software and Sage Pastel, it can be used with any system with a ODBC databse connection.
  • Alchemex Analytics includes an OLAP Module for high speed multi-dimensional analysis of large volumes of data via offline OLAP cubes, providing users with the ability to use OLAP technology cost-effectively and easily through the Excel interface. View demo here.

ALCHEMEX Overview

Business Intelligence Software

Alchemex specialises in Excel-based reporting for easy and affordable business intelligence for small to medium enterprises.

Alchemex's reporting software delivers automated and pre-formatted management packs and other decision-support reports on demand in Microsoft Excel directly from the database of a company’s accounting and/or payroll application, integrating with Sage Pastel Evolution and Sybiz Vision.
Alchemex is a software solution offering Excel based Business Intelligence for the SME market. Various modules that make up Alchemex present the following benefits to organisations;

ALCHEMEX Smart Reporting automates monthly management packs and other financial, payroll, sales, inventory and trend analysis reports. Use of the software will minimise manual, repetitive work in Excel, and prevent the accumulation of critical data in personal spreadsheets.

ALCHEMEX Analytics ships with pre-built Sales, Purchases and Inventory Cubes for select install bases, to fast track solution development and deliver immediate value. View demo here.

Standard OLAP cubes can be edited and/or cloned and include:

  • Financial Analysis - Analyse financials by account segments and financial groups across multiple years with drill down to required levels of detail. Fully customisable.
  • Sales Analysis - Analyse sales by product, customer, rep, across multiple years with drill down to required levels of detail. Fully customisable.
  • Inventory Analysis - Analyse inventory by product, warehouse with drill down to required levels of detail. Fully customisable.

ALCHEMEX Web Reporting gives authenticated users access to company reports off a centralised database via a browser interface, no matter where they are in the world. Alchemex Web Reporting includes the Web Solution and 10 Web User Licenses for secure real-time running of Alchemex Reports via a web browser into Excel, HTML or PDF. View demo here.


Click to download an Alchemex Software Brochure.

If you would like to discuss your business intelligence and reporting requirements with us, call us on 1300 720 767 or email sales@pbt.net.au. Alternatively you can complete our online form and one of our team will be in contact with you within 24 hours.