VAT report

The VAT report shows your store's sales, refunds and shipping costs for the chosen period grouped by VAT rate, ready to hand off to bookkeeping or use for the VAT return. You'll find the page under Reports → VAT report in the dashboard.

Choosing a date range

The top of the report has two date buttons — start date and end date. Clicking either opens a calendar; the moment you pick a day, the report reloads for the new range. There's no separate Update button.

The default range is the last 12 months (filled in automatically when no dates are present in the URL).
The end date covers the entire selected day — the time is set to 23:59:59 behind the scenes, so orders placed late on that day are still included.
Selections persist in the URL (?startDate=...&endDate=...), so you can share a specific report with a colleague or accountant as a link.

Which orders are included

Only orders in status paid, shipped, completed, refunded or partially refunded are included. Pending, cancelled and failed orders are excluded — they are not taxable events.

Sales

The first table breaks sales down by VAT rate (e.g. 25.5%, 14%, 10%). Each row shows:

Net sales — the pre-VAT amount
Tax amount — VAT collected
Gross sales — the total including VAT

The bottom Total row sums every rate for the selected period.

Refunds

If you've issued refunds during the period, a separate table appears below the sales table. Numbers are shown in red with a minus sign — they reduce the sales totals. If there are no refunds, the table is hidden.

Net totals

When refunds exist, a third table Net totals (sales − refunds) appears. This is the number you need for the VAT return — VAT collected minus VAT returned to customers.

Shipping

At the bottom of the page is a separate Shipping breakdown card that pulls shipping VAT into its own line. In the main report, shipping is already folded into the per-rate rows — the breakdown card lifts it out so you can see it on its own when needed.

Use the main VAT report for filing

The breakdown card at the bottom of the page is intended for internal analysis. For the official VAT return, always use the main VAT report table at the top of the page, which already distributes shipping costs across product VAT rates.

How the numbers are calculated

In Putiikkipalvelu, product prices are stored as VAT-inclusive amounts. Every row in the report is derived using the same formula:

Net   = Gross / (1 + rate / 100)
Tax   = Gross − Net
Gross = Price taken from the order line

Product lines

Each order's lines are grouped by VAT rate, and the formula above is applied to each group. If an order has multiple rates (e.g. a 10% magazine + a 25.5% shirt), they produce two separate rows in the report.

Discounts

Discount codes and campaign discounts are applied proportionally across VAT rates: if 60% of an order's products are at 25.5% VAT, 60% of the discount is deducted from the 25.5% group. This follows the Finnish Tax Administration rule that each VAT bucket must be reduced by its own share.

Shipping VAT — main report

The shipping VAT rate is calculated per order based on the products in that order, then distributed across product VAT rates using the same proportional rule as discounts.

Example — a single order's shipping

The order contains:

€60 of products (10% VAT)
€40 of products (20% VAT)

Weighted VAT: (€60 × 10% + €40 × 20%) / €100 = 14%.

In the main report, 60% of that order's shipping is allocated to the 10% row and 40% to the 20% row — rather than shipping appearing on its own 14% row.

Shipping VAT — breakdown report

The Shipping breakdown card adds up shipping costs from every order in the period and shows them under a single average VAT rate for the whole window:

Average VAT = Σ(shipping VAT × shipping net) / Σ(shipping net)

Example — period-wide average

Across the period there are:

€100 of shipping at 24% VAT
€200 of shipping at 14% VAT

Average VAT: (24% × €100 + 14% × €200) / €300 ≈ 17.33%.

In the breakdown report this appears as its own row.

The average is intended for internal analysis — it tells you the typical VAT charged on your store's shipping. Use the main report's numbers for the actual VAT return.

Refunds

A refund line stores its VAT rate at the moment of refunding, so the report uses the same rate as the original order line. Older refunds made before this was tracked default to 25.5%.

Downloading the report as PDF

The Download PDF button in the top right of the report card generates a printable file. The file name includes the selected date range (e.g. ALV-raportti-2025-01-01-to-2025-12-31.pdf) so archived reports stay easy to sort.

On this page