Loading page...

USER DEFINABLE REPORTING SYSTEMS

Aralco's reporting capabilities are extensive and designed not to produce volumes of paper, but to prevent just that. Reports are selected for the purpose for which they are required and contain only the information requested.

It comes with over 100 standard reports that can be further modified to user specifications and takes only a few minutes to learn how to create a basic new report. There is also no limit to the SQL database size, so you can keep as many years of history you want without purging, therefore you can report on year-on-year performances of your business. 

Aralco Reporting Engine is the perfect data analytics tool for retailers and it will save you countless man-hours when preparing reports every day, periodically, for boardroom presentation and even at the last minute.

 

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 one of the key features of Aralco offering comprehensive report formats for you to choose from for your precise reporting requirements:

 

REPORT FORMATS REPORT USAGE FORMULAS

IMAGES
CUSTOMERS & PRODUCTS

STYLING
FONT, COLOR, ROW & COLUMN SIZES

AUTO-EMAIL
SCHEDULER

TABULAR REPORTS Basic report listing rows of data in relation to a column Yes Yes Yes Yes
SUMMARY REPORTS Group and summarize rows of data in relation to each column Yes Yes Yes Yes

MATRIX REPORTS

Group and summarize data by columns and rows Yes Yes Yes Yes
CUBE REPORTS Drag & drop data to a column, row for a multidimensional view Yes Not applicable Not applicable Not applicable
CHART REPORTS Chart type in Area, Bar, Bubble, Column, Doughnut, Line & Pie Yes Not applicable Yes Yes

 

 

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.

 

 


ARALCO VIDEOS | POWERFUL REPORTING SYSTEMS

 


Read about more Reporting Feature - Cube Analytics