The data is stored in a way that it provides a strong reporting platform.
After a sale all working totals have been updated.
There are a large number of reports developed in crystal reports writer
Data is stored and available in real time from the tills.
Totals available by day, week, period, year.
Over 150 standard reports available as standard.
Export data to excel for further analysis or distribution.
The reports have lots of variables in the way that the data can be selected or presented. These are called criteria and are entered by the operator prior to running a report. They make the eventual results produced a lot more flexible.
Operator selectable options for more flexibility.
View on screen with an option to further print out.
Can preload criteria to run regularly or at a future date.
Add regularly run reports into your favourites list.
The reports have many different purposes being price lists, reordering, merchandising of best sellers and delisting slow sellers. The management get information at department group level to identify problems and drill down to investigate.
Reports designed for different levels of user
Drill down from management level into line detail
Margin issues use colour traffic light highlighting
Show not only where profit is made but also where profit is lost too.
Not all users are happy with rows of figures and find visual presentation more acceptable in barchart format.
Easier visibility of complicated information
Compare sales periods on variable timeframe
Helps show flow of customers and sales through tills.
If the report is in the wrong format or you want to pick out a different total or even take it away to work on
Some reports are important to have a copy taken at the correct time like a month end , others
are useful to be printed before your arrival at work that day or to be shared with colleagues
The figures and the stored reports they produce are only possible because they are collected by the whole of the epos system.
The fact that they are available in real time makes the decision making more timely.
The data of prevous years allows for comparison figures to be produced.
The reports can be distrubuted as excel spreadsheet or pdf document.
HOW DOES IT INCREASE MY SALES ?
You need to read the benefits section, but mostly by checking the margin being made between cost and actual sell price. You can also find the best and worst sellers and clear bad stock and buy better stock.
CAN IT SHOW WHICH DEPARTMENTS ARE OVERSTOCKED OR UNDER STOCKED ?
The stock can be valued at both cost and retail selling price allowing margin to be calculated if sold.
The average week sale can be divided into this stock figure to see how many weeks of stock holding you have and need.
FIND WHICH LINES NEED TO BE REDUCED ?
Valuations by age of stock based on goods inwards date or date of last sale can be used to find which products to delist or promote to clear.
WHICH DEPARTMENTS/GROUPS ARE SELLING AND MAKING THE REQUIRED MARGIN ?
After each sale the value of quantity sold, sales , vat,cost , discount , promotional and loyalty values get stored at department/group and sub group level.
The stored totals show the actual margin made versus the target margin and can be drilled down by department into group or sub group and then down to line level.
ARE THE BIGGEST SELLERS BY QUANTITY MAKING THE BIGGEST PROFIT ?
If sales are ranked on quantity alone then this may not show where the profit is being made.
The information can identify the top or bottom sellers and also the slow movers need clearing to raise money to buy better performing stock to sell.
This is called the 80/20 rule in that 80% of profit comes from 20% of the lines typically
HOW DO SALES THIS COMPARE TO LAST YEAR ?
The sales history of each year are saved in separate yearly databases allowing year on year comparisons to be performed in enquiries and reports.