# 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