Loading page...

USER DEFINABLE REPORTING SYSTEMS

Aralco Report Engine is feature-rich and easy-to-use with extensive capabilities for producing accurate and superior reports with in-depth analysis so that you can make timely and correct decisions. There are over 100 standard reports that can be further modified to user specifications.

With its user-definable tool to create your own custom or modify reports, extracting any data for reporting is no longer an onerus task for your back-office employees. Moreover, you need not purge your valuable historical data in the central SQL database hence you can report on year-on-year performances of your business. 

Therefore, Aralco Reporting Engine is the perfect data analytics tool for retailers and it will save you countless man-hours preparing reports for analytics every day and periodically.

 

Aralco Report Engine

 

BUILD YOUR OWN REPORT 

 

You can design a new report on your own easily without the need for costly customization by programmers. Simply use the following tab options to create one quickly or whenever you need to make changes to any existing reports: 

 

  • FILTERING TAB option is where you define the date range, include and exclude location, brand, department, season, customer type, supplier, etc.
     
  • GROUPING TAB option is where you specify the grouping for summarizing data by groups such as location, customer, department, supplier, brands season or any categories
     
  • COLUMN TAB option is where you can define to insert any fields/values in the columns of the report such as Product Code/Name, Cost of Sales, GP%, Margins, Stock Quantity At Hand, etc and frequently used formulas like "Sell Through Rate", "Stock Valuation", "Commission Calculations", "Average Spending".

 

 

Real-time reporting is another key feature in Aralco Retail Systems, and it comes with the following comprehensive report formats for you to choose from to meet your precise reporting requirements:


 

TABULAR VS MATRIX REPORT FORMAT

 

Tabular Report is the most basic type of report you can build and the report output is organized with a single column header with multirow of data. 

 

 

Matrix Report is very similar to a table, but it is configured to show data grouped by columns and rows, with aggregate data at the intersections. Some of the data you might expect to see in a row can actually become a column header. This format is similar to a crosstab or pivot table in a spreadsheet.

 

 

SUMMARY REPORT FORMAT 

Summary Report is similar to Tabular Reports and you can configure these reports to group by rows of data but with the same column header - below is an example with images included in the report.

 

 

 

 

CHART REPORT FORMAT

Chart Report shows data in the form of areas, bars, columns, lines, and other shapes.

 

 

 

REPORTING INTERFACE TO MICROSOFT OUTLOOK, EXCEL, WORD, PDF :

 

All Aralco reports are prepared as HTML (or ASCII) files and readily convertible with a click of a button to Microsoft (MS) Excel, MS Word or PDF format, wherein any MS documents, you can make a modification such as your own presentation or applications of formulas and other calculations.

For mass price updates or markdowns, Aralco exports the selected product range (by Supplier, Department, Group etc.) into Excel where you can easily manipulate the data at your convenience, then simply re-import your changes back into Aralco with a simple click. The product price information residing on the Aralco system will then be replaced by your Excel's entries.

 

WATCH VIDEO ON ARALCO REPORTING ENGINE

 

 

 

 


Read about more Reporting Feature - Cube Analytics