# Reports

The Till Check reports include all the sales and variance information for products and recipes that you should need to complete a stocktake. There are options available to tailor your reports to match what your client requires. The Display of Quantities options cover how product quantities are shown on the reports : Selling Units - Tots or Pints - e.g. 28, for a full 70cl bottle of spirits Count Units - Bottles or Gallons - e.g. 1, for a full bottle Combination - Bottles and Tots - e.g. 2.14, for 1.5 70cl bottles of spirits Millilitres - Some bars doing cocktails have recipes measured out in millilitres The Display Options box gives you : Blank Zeros - Any quantity with a value of zero will not be shown Use Colour - Some figures, e.g. variance, can be negative. These can be shown in red. Sub-Products - Multiple products on the same PLU number can be shown, or not. Use Av Price - The variance @ retail figure can be calculated using the average price or the selling price.

### Till Variance by PLU

This simplified report lists all of the PLU Numbers that you have set up and shows the Sales, Allowances, Consumed and Variance figures in both quantity and retail values.

The quantity and retail variance figures are calculated independently of each other. On the main Till Check screen, you do not have to have both quantity and value figures entered, and the variance report allows for this.

If you are using multiple price bands or recipes, instead of the Variance by PLU report, you should use the Variance by Product report as that will take into account the varying prices of products.

### Till Variance by Product

The detailed variance report brings in to play all sales of individual products and recipes, in all price bands.

The average sales price for each product has been calculated and is then multiplied by the Variance Quantity figure to give the Variance at Retail.

### Till Sales by Band

This report simply shows the sales quantities of each product in each band, allowing you to compare sales in different bands.

### Till Sales by Bar

For a multi-bar outlet, this report shows the sales quantities in each bar, allowing a comparison.

### Compare Sales with last audit

This report will show the sales in the current audit and the sales in the last audit, for each band.

### Price Band Variance

Where multiple price bands have been setup, it is essential that the difference in retail income is known. The columns for bands 2-6 show the amount of money that has been taken, more or less, than would have been taken had those sales been in band 1.

As the main Summary report is all calculated at the standard selling price (band 1), these variances must be put in as an allowance.

Example : A pint of beer is priced at £3.00 in the bar, but at £3.50 in the function room. If there are sales of 20 pints in the function room, then £10.00 (20 x £0.50) extra money would have been taken. This would need to go in as an allowance of £-10.00.

The report calculates the figures for each product and adds them up for each section and overall. If you select an allowance in the drop-down box, the total figure will be automatically inserted into that figure on the allowances screen.

### Recipe Variance

Where recipes have been setup, it is essential that the variance in retail income is known. The columns for bands 2-6 show the amount of money that has been taken, more or less, than would have been taken had the ingredients of the recipes been sold as individual products, at the standard selling price.

As the main Summary report is all calculated at the standard selling price (band 1), these variances must be put in as an allowance.

Example : A pint of beer is priced at £3.00, a half pint of lemonade is £1.40 and a pint of shandy is £3.00. If there are sales of 20 pints, then £2.00 (20 x £0.10) extra money would have been taken.

Standard price of half pint of beer £1.50

Standard price of half pint of lemonade £1.40

Total £2.90

Variance to Pint of shandy (£3.00) £0.10

This would need to go in as an allowance of £-2.00.

The report calculates the figures for each recipe and adds them up for each section and overall. If you select an allowance in the drop-down box, the total figure will be automatically inserted into that figure on the allowances screen.

Sometimes, your client might want separate allowances to be used for different recipe types, e.g. cocktails, wine by the glass, etc. If this is the case, you will need to add up the different variances and apply them manually to each allowance.

### Average Price Variance

Instead of using recipes and/or price bands, some tills will give you a total value for each product, irrespective of how that product has been sold, e.g. pints, halves, shandies. The till information should include both a quantity of sales and a value and this results in an average price per pint.

In a similar manner to price bands and recipes above, a variance must be applied as an allowance so that extra (or less) takings are included in the summary report.

Example : A pint of beer is priced at £3.00 in the bar, but at £3.20 in the function room, and is also used in shandies. The till roll shows that the total quantity sold is 50 pints for a total value of £168.30.

Had those 50 pints all been sold in the bar, the income would have been £150.00. So, there is a variance of £18.30 and this would go in as an allowance of £-18.30.

The report calculates the figures for each product and adds them up for each section and overall. If you select an allowance in the drop-down box, the total figure will be automatically inserted into that figure on the allowances screen.

Back to Contents