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. The data resides in a secure source and feeds into pre-formatted Excel Income Statement and Balance Sheet reports upon request, leaving the user with little or no work to do to get the required results. High level summaries, account groupings and even detailed transactions can be accessed immediately, for both the current and prior year, in different views as determined by the user, in the Excel report. ALCHEMEX Smart Reporting also provides the ability to consolidate data from multiple disparate sources, eg. across multiple companies or divisions, in a dashboard style view. This graphical representation of data in Excel is particularly useful for providing management and executives with an overview of the business to identify trends. Drill down capabilities allow for transaction details to be viewed at the click of a mouse.

ALCHEMEX Smart Reporting Standard (1 User) includes:

• a single Administrator License for database queries, consolidations and connectivity to multiple disparate data sources and report authoring and viewing (creating, editing and running reports)
• Management Pack template with drill down for setup of automated income statement and balance sheet schedules in the of your choice
• Management Dashboard template with drill down, giving a holistic and summarised view of key performance indicators in your business
• GL Trend Analysis template with drill down, trending your GL accounts for the current and prior years??
• Sales, Purchases and Inventory master reports to support flexible analysis of business data, in the format of your choice
• Security Module to allow flexible control of access to databases, report folders, reports and reporting functions

ALCHEMEX Smart Reporting Advanced (5 User) includes:

• All the above plus
• 4 Report Manager (User) Licenses for report authoring (creating, editing and running reports) and viewing (including drill-down)

Download our FREE fully-functional 30-day trial software NOW

Alchemex ships with standard reports for select install bases to fast track solution development and deliver immediate value. Try the BI calculator and see how you can save!

Standard reports can be edited and/or cloned and include:

• Management Pack - delivers automated management accounts and supports drill down and consolidations. Displays balances per General Ledger Account number per financial period for the current financial year, previous financial year and current budget year. Layouts are automatically grouped and subtotalled by Financial Group. Fully customisable using native Excel to suit any mapping and layout requirements.
  
  View Management Pack video
  View screenshot of Management Pack
  
  
• GL Trend Analysis - graphically compares selected GL accounts for the current and prior year by value, with the ability to drill down to detailed ledger transactions for analysis. A great extension to the Management Pack.
  
  View screenshot of GL Trend Analysis
  
  
• Management Dashboard - a one page summary of KPIs including financials and sales, showing the top expenses, customers, and products. Supports drill down to product and customer details. Fully customisable.
  
  View Management Dashboard video
  View screenshot of Management Dashboard
  
  
• Sales Master - displays Qty, Cost, SellPrice, GP and GP% grouped by Sales Code, Customer and product with an option to select the date Range at run time. Fully customisable.
  
  View screenshot of Sales Master
  
  
• Purchase Master - displays purchase quantities and amounts by supplier by product over a selected date range. Fully customisable.
  
  View screenshot of Purchase Master
  
  
• Inventory Master - displays stock on hand qty and value, over/under stocked qty and value, reorder levels by inventory group by inventory code. Fully customisable.
  
  View screenshot of Inventory Master

For customers needing to extend their solution, 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. The software supports on the fly creation of dimensions and measures, allowing you to create your own drill down experience, and identify trends and patterns in your data.

View OLAP video

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

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 Analytics for Sage X3 includes the OLAP Module for multi-dimensional analysis and a pre-built Financial Cube.

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 Web Reporting video