Use these instructions to retrieve till sales data from Vektori for the official notification of alcohol sales. You can also search for the instructions using the name Valvira reporting. The data is retrieved from the Vektori Pilvi → Reports → Till → Product sales report view. Creating the report does not send a notification to the authorities.
Start with two questions
Select the correct steps only once you know the following:
- Do you want an on-premises sales report, an alcohol retail sales report or both? On-premises sales are alcohol sales for consumption on the premises. Retail sales are alcohol sold to take away.
- Has the reporting been prepared in advance? Have on-premises sales and takeaway sales been separated using products or product groups, and are the serving and pack sizes known? Or is a report required without this preparation?
If you are unsure about the preparation, check which products and groups have been used. Verify the preparation using the current product details. Next, establish whether stock management is used for alcohol products, the reporting period and the premises. If you want both reports, process them as separate filters.
Getting started: choose your situation
- Groups and products have been prepared: filter the report to the agreed product groups and check the products included.
- Nothing has been prepared: select the required products in the Products field of the report. You do not need to enable product groups or stock management just to retrieve this report. However, you need to know what was sold using the products.
- Preparation has been partly completed: use only verified filters. Check the sales method and size of missing products separately.
- You want to make future reports easier: read the separate Setting up alcohol sales reporting instructions.
1. Select the notification and period
The notification for on-premises sales and the notification for retail sales differ from each other. The retail sales notification for premises serving alcohol and the annual notification for separate retail premises may also concern different periods and data. Check the requirements for your notification before retrieving the report.
The current licensing authority is the Licensing and Control Agency. For on-premises sales, the sales value and number of staff are reported every six months. For retail sales at premises serving alcohol, the quantity and value are also reported every six months. The annual notification for the holder of a retail sales licence includes the value of sales of alcoholic beverages and foodstuffs. Depending on the activity, other information may also be required, for example information about deliveries or certain purchases. Vektori’s product sales report does not on its own contain all the information required for the notification. Provision on the information to be reported: Finlex, section 9.
Always use the current form and instructions for your notification. Also check which fields request euros and which request litres, and whether the value should include tax.
2. Create the report
- Open Vektori Pilvi → Reports → Till → Product sales report.
- Select Name, and, where necessary, Product code, Sales Qty, Sales, Returns Qty, Returns, Net sales (qty) and Net sales as the fields. You can remove unnecessary percentage columns.
- Enter the start and end dates and times for the entire reporting period in the Sales period fields. Check both fields. The daily Time filter is different: it limits the times on each day. For full days, keep it between 00:00 and 23:59 and select all the weekdays required.
- If necessary, filter Locations and Tills to the sales location corresponding to the notification. Remove any unintended filters for Salespersons, Price lists and other fields.
- Select the products according to the on-premises or retail sales section below. Use the Product groups field if the groups have been checked, or the Products field if you are compiling the selection now. Remove conflicting and unnecessary filters.
- Select Preview and Create report. Check the date range, filters and products in the output before using the totals.
- If necessary, download the same data in Excel or CSV format for further calculations. Keep the report and the filters and calculations used so that the notification can be checked.
Sales and Sales (excluding tax) are different fields. Net sales means sales after returns, not automatically the value excluding tax. There is a separate field, Net sales (excluding tax), for the net amount excluding tax. Use the value requested in the notification and check how returns are handled; the net amount already includes those returns.
3. On-premises sales report
When preparation has been completed: select the product groups intended for on-premises sales. Check each product to ensure that all alcoholic products consumed on the premises are included and that takeaway sales, food and non-alcoholic drinks are excluded.
Without advance preparation: in the Products field, select the products used to record on-premises sales. Find and add the required products, and check the report rows. If the notification requests, for example, beer separately from other alcoholic beverages, make a separate product selection and summary for each.
A serving of wine sold using a recipe appears in the sales report as a serving product sold. The bottle of ingredient used for it is not a second sale. Count the serving product as a sale once.
4. Retail sales report
When preparation has been completed: select the product groups intended for takeaway sales. Check that on-premises sales are not included.
Without advance preparation: in the Products field, select the products used to record takeaway sales. If a product has also been used for on-premises sales, use only an additional filter that you know separates the sales methods, such as a till used exclusively for takeaway sales. The fact that the till belongs to the same premises is not sufficient grounds.
Check whether you are making a notification for retail sales at premises serving alcohol or an annual notification for retail premises. If the notification requires food sales, retrieve them using a separate filter. Calculate quantities in litres only for the information where they are requested.
5. Calculate the required quantity in litres
Sales Qty does not automatically mean litres. It may mean, for example, bottles or servings sold. The quantity of a recipe product is also the number of servings sold.
Calculate each size separately:
quantity sold × contents of one sales unit in litres = quantity sold in litres
- 24 bottles × 0.33 l = 7.92 l.
- 10 servings × 0.16 l = 1.60 l.
- If a product is sold one centilitre at a time, multiply the quantity by 0.01 litres.
Handle returns consistently. When you use the Net sales (qty) amount, the same returns have already been deducted. Convert products of different sizes into litres first and only then add them together. Use the serving or pack size that was valid at the time of sale.
6. Effect of stock management
Without stock management: retrieve sales using the same product sales report. To calculate litres, you need the actual sizes of the products. Stock tracking is not required for this sales report.
With stock management: continue to retrieve sales from sales products. You can check the serving size in the recipe and units when they correspond to the time of the sales being reported. Stock transactions help verify consumption, but also include items other than sales. Use the product sales report for the sales information in the notification.
Recipe and sales quantity
For example, a recipe for a 16 cl serving may use 16 × 1 cl of an ingredient. In the sales report, this is one serving sold, or 0.16 litres. Count the sale once using the serving product. For a recipe containing several alcoholic ingredients, check the quantity of each separately; the total volume of the drink may also include a non-alcoholic mixer.
Use the serving size, unit and recipe applicable during the reporting period. Keep the current unit settings when retrieving the report. Instructions for preparing the new 1 cl model are provided in the linked setup instructions above.
If old sales cannot be separated
If both on-premises sales and takeaway sales have been made using the same product, and the sales method cannot be distinguished from the stored data, the report cannot determine the correct split. Establish the sales from receipts or other reliable data. The same applies to missing serving sizes or serving sizes changed during the period. Base the split and serving sizes on the information from the time of sale.
Changing a product group now may affect the filters in the product sales report for an old period. Save the original report before making changes. For future sales, prepare the separation according to the setup instructions.
Once the figures have been checked, transfer them to the correct fields in the notification and add any information required from other sources.
Comments
0 comments
Please sign in to leave a comment.