Reports Setup

There are a number of items which you can specify which will change the way some reports are calculated and formatted.

Stock Report
Average Daily Sales
The average daily sales column on the bar stock report can display either the sales quantity or the sales value.

Order Products
On the stock report, products will be ordered by section. Then, within the section, they can be ordered by Code, SubSection, Description or Bin Number.

Count Sheets
Include Products
The count sheets can be displayed/printed with all products or just the live products (those which are ticked on the Products screen).

Order Products
On the stock report, products will be ordered by section. Then, within the section, they can be ordered by Code, SubSection, Description or Bin Number.

Barcoded Products
If you are using StockMate to scan products, it is useful to take along a count sheet as well. Many products do not have barcodes and, with this option ticked, a count sheet can be produced which only includes the products which have no barcode.

Cellar Summary
Cellar Balance
When a cellar does not balance, the retail value of the imbalance must be included in the overall result. However, as the cellar does not have a selling price for a product, the selling price must come from one of the bars.

Bar 1 is self-explanatory.
Bar Receipts means that the value will be calculated based on the price of the product in the bar which has the highest takings.
Product Sales means that the value will be calculated based on the price of the product in the bar which has sold the most of that product.

The option to display products that do not balance is useful. This reduces the amount of clutter in the report and immediately draws your attention to those products which might have a problem.

Bar Summary
Return Deposits
The summary report will add on the deposit value of the full bottles to the empty bottles and give you the total stock at cost. However, by ticking this option, the consumption at cost is also calculated and included in the overall figure, thereby changing the GP and Surplus/Deficit.
Group Products
On the stock report, it is possible to group products with the same SubSection value together and display a sub-total for those items. Tick this if you want the subsections to be totalled.

Use Average Costs
When you enter purchases, it is possible to specify a cost price that is different to the normal cost price. If so, this will affect the Gross Profit percentage, closing stock at cost, etc.

To avoid inaccurate data on reports, you can choose to use the average cost prices for each product.

Use Central Reports
Each client database contains a set of reports which can be customised for that client. If you have no need for customisation, or if all of your clients will always have the same set of reports, you can optimise the operation of StockManager by selecting this option.

Disclaimer
Many of the reports can include a disclaimer at the foot of the page. You have the option here of changing the wording of the disclaimer.


Back to Contents