Prepare your products and grouping so that you can obtain on-premises sales and retail sales data for alcoholic beverages separately from Vektori. You can also search for the guide by the name Valvira reporting. The preparations make future reporting easier; they do not submit a report to the authorities.
If you need a report for sales that have already been made, start with the guide Alcohol sales reporting – on-premises sales and retail sales. You can also limit the report without pre-created reporting groups, provided that the required sales can be identified.
First, find out about the report and the preparations already made
Select the work steps based on this initial information:
- Do you need on-premises sales data, retail sales data for alcoholic beverages, or both? On-premises sales means alcohol sold for consumption on the premises, while retail sales means alcohol sold to take away. The data for both must be kept separate.
- Have preparations already been made for reporting? Have on-premises sales and takeaway sales been separated using products or product groups? Are the serving and package sizes known? If necessary, check the existing products and groups.
After this, find out whether stock management is used for alcoholic products and whether the intention is to prepare for future sales or report on a period that has already ended. Using stock management alone does not mean that the reporting preparations are complete.
1. Decide what needs to be kept separate
Check the reporting period and the information required for your own notification in the authority's up-to-date guidance. An on-premises sales notification, retail sales at an on-premises sales location and a notification for a separate retail sales location are not the same thing. They may have different periods and information requirements.
Plan to separate at least the following:
- alcoholic products sold for consumption on the premises;
- alcoholic products sold to take away;
- non-alcoholic products and food;
- the more detailed beverage groups and business locations required for the notification.
The same drink may need separate sales products for on-premises sales and takeaway sales, for example Beer 0.33 l – on-premises sales and Beer 0.33 l – takeaway. Use this if the sales methods cannot otherwise be reliably distinguished. A price difference or the product's current group does not alone indicate how an old sale was made.
2. Prepare the product groups
Open Vektori Pilvi → Product management → Product groups. Use suitable existing groups and add only missing ones according to the Product groups guide.
You can name the groups, for example, On-premises sales – beers, On-premises sales – other alcoholic beverages and Retail sales – alcoholic beverages. These are structural examples: adapt the more detailed division to the information in your own notification. Keep food and non-alcoholic drinks separate.
Product groups also affect the till folder structure. Check that the employee can find the correct product and distinguish on-premises sales from takeaway sales. Creating a group alone does not associate products with it.
If you are grouping products that are already in use: first save any earlier reports that you need. Changing a product's group may also change the group filter in the product sales report for an earlier period. The change does not add information missing from the sales data, such as whether the drink was consumed on the premises or sold to take away.
3. Check the products and serving sizes
New product: open Vektori Pilvi → Product management → Products → + New product. Enter a clear name and product code, select the product group and sales unit, and check the tax, price, Sales product and Active settings. Save. Detailed steps: Adding a product to the product register.
Existing product: search for the correct product and open Edit → General. Check the name, product group and units, and select Update. Change the price and tax separately on the Prices tab if necessary. See Editing product details and price. Update the information in the existing product.
For each serving and package size, make sure you know what one sold unit represents. For example, one 16 cl serving is 0.16 litres and one 0.33-litre bottle is 0.33 litres. Convert every serving and package size into litres before adding them together. If the size changed during the reporting period, you also need the date of the change and the previous size.
4. Select the method according to whether stock management is used
You do not use stock management
Retrieving sales data does not require the Stock tracking setting to be selected for the product. It is sufficient that the sales have been recorded against identifiable products. Prepare the grouping and the information on serving and package sizes. Calculate the required litre quantities from the product-specific sales quantities in the report.
You use stock management
Check the stock management setup, stock locations, stock selections for tills, opening balances and products being tracked. Also check the units and their conversions.
When a serving is sold using a recipe, the sales product and the raw material consumed from stock are different things. Leave Stock tracking disabled for the serving product itself and enable tracking for the recipe's raw materials. Define consumption according to the guide Recipe products and automatic stock deduction.
Stock consumption is not the same as sales: the balance is also affected by, for example, wastage and stock transfers. Use the sales report data for the sales quantity in the notification. Starting to use stock management now does not replace missing sales or serving data from an earlier period.
Recommended model: stock unit and recipe unit of 1 cl
Use 1 cl as the stock unit for liquid alcoholic raw materials. Also use 1 cl as the unit on the recipe line and enter the serving size in the Quantity field. Using the same unit makes balances and recipes easy to check.
- Raw material in stock: a 0.75-litre bottle is 75 cl. The opening balance for one bottle is 75 and for six bottles it is 450.
- Purchasing: the purchase unit can be, for example, 0.75 l. Check the conversion from 0.75 l to 1 cl; its factor is 75. A supplier's pack of six bottles is then 6 purchase units.
- Recipe: for a 16 cl serving, Quantity is 16 and Recipe unit is 1 cl. For a 12 cl serving, Quantity is 12. Consumption is allocated to the same raw material tracked in stock.
- Sales product: the serving is sold as one item. Stock tracking is disabled for the serving product itself. A quantity of 1 in the sales report means one serving, whose contents in this example are 0.16 litres.
A whole bottle can also be implemented as a separate sales product: the recipe for a 0.75-litre bottle consumes 75 × 1 cl of the same raw material. This means that different serving sizes and bottle sales reduce the same stock. Sales products for on-premises sales and takeaway sales are separated for reporting purposes.
When the opening balance or stock entry is made in 1 cl units, also check the transaction unit price per centilitre. For example, the value of a 0.75-litre bottle costing £15 is 75 × £0.20. The exact unit and recipe steps are provided in the main guides linked above.
Recipe consumption is Quantity × Recipe unit. When the recipe unit is 1 cl, the quantity for a 16 cl serving is 16. For example, 16 × 16 cl would be 256 cl. In a mixed drink containing several alcoholic raw materials, define the quantity of each raw material separately; the quantity of a non-alcoholic mixer is not the quantity of the alcoholic beverage.
If products are already tracked using another unit
This recommendation is a model for a new setup. Keep the current stock unit until any transition has been assessed. Review the current units, balances, values, conversions and recipes, and plan the transition with Vektori support. A report for an earlier period is based on the information from the time of sale. Without stock management, you can proceed directly to generating the sales report.
5. Check readiness for use
- On-premises sales and takeaway sales can be found separately in the products or other reliable sales data.
- Each product belongs to the correct group, and the grouping works at the till.
- The contents of one sales unit and the required serving and package sizes are known.
- If stock is tracked, the units, recipes and stock selections for tills have been checked.
- The person responsible for reporting knows which period and business location to retrieve and where to obtain the other information for the notification.
After the first sales, check the product sales report for the product name, quantity, pounds and filters. Once the preparations are in order, generating the report is part of using the system and does not require the setup to be repeated.
Comments
0 comments
Please sign in to leave a comment.