EU VAT Reports Module: OSS, IOSS + VIES Validation

• Quarterly OSS report grouped by country of consumption and VAT rate, with taxable amount and VAT due.
• Report structure matching Spain's Form 369 and the equivalent OSS portal of any EU country.
• Monthly IOSS report for imported consignments, with an automatic €150 cut-off.
• Your IOSS number (IM...) is shown on the IOSS report.
• Monitoring of the €10,000 distance-selling threshold for the current and previous year.
• Automatic yearly email alert when the threshold is exceeded.
• VAT rate worked out from the actual amounts of each order and checked against the official rates of the destination country.
• Warning with the order reference when the rate applied does not match any official rate.
• 2026 EU VAT rates table included and editable.
• Single and batch VIES validation of intra-community VAT numbers.
• Real-time VAT number check in VIES when the address is created or edited, with automatic assignment to the exempt group.
• Validation evidence stored, including date, result and consultation number when VIES provides it.
• Optional automatic assignment of validated customers to a B2B group.
• Automatic exclusion of B2B orders and domestic sales.
• Credit slips for the period deducted from the declared amounts.
• Cart discounts prorated and shipping costs included in the taxable amount.
• Multi-currency support: amounts are converted to the default currency using the exchange rate applied to each order.
• Summary CSV export for your accountant.
• Detailed per-order CSV for reconciliation and audits.
• Excel-friendly CSV, with UTF-8 BOM and configurable separator and decimal format.
• Configurable order statuses. Paid statuses are included by default.
• Texts and interface available in Spanish, English, French, German, Italian and Portuguese.
• Multistore compatible: work with the current store or with all stores.
• No cron, no API keys and no subscription.
• Compatible with PrestaShop 1.7, 8.x and 9 (up to 9.2, the latest version).
• Easy installation with no changes to system files.

Benefits for your business

• An hour's work in two clicks: The quarterly routine of wrestling with spreadsheets, exporting orders, splitting them by country and reconciling VAT rates becomes a report you can generate on screen and export in seconds.

• Reliable figures, not estimates: The VAT rate is worked out from the actual amounts of each order, so the report does not depend on your store's tax rules being perfectly configured.

• Know when you have to declare: The threshold monitor tracks the €10,000 limit and emails you the moment you become required to declare through OSS, so there are no surprises.

• Instant B2B VAT exemption: Validate a business's VAT number in VIES and, optionally, have the customer assigned automatically to your B2B group so you can sell to them without VAT.

• Auditable and transparent: The detailed per-order CSV gives your accountant everything they need to reconcile any figure with the actual invoices. And any order whose VAT does not match an official rate is flagged by its reference, never hidden.

• No conflicts, no dependencies: The module does not touch the front office or interfere with tax calculation at checkout, so it does not clash with your store's theme. Nor does it need paid external services, as VIES validation uses the free, official European Commission service.

Installation and setup

Installation is simple: download the module, install it from the PrestaShop dashboard and open the configuration. On installation it suggests sensible default values, such as the country of establishment, the paid order statuses and the alert email. A help panel also gives step-by-step instructions for each option.

Customising the module

From the “Module configuration” tab you can:

• Set your country of establishment. Sales made in it are treated as domestic.
• Choose which order statuses count as paid.
• Exclude B2B orders, deduct credit slips and include shipping costs. This last option is enabled by default.
• Enter your IOSS number (IM...).
• Edit the EU VAT rates table if a country changes its tax rates.
• Choose the CSV file separator and the decimal format for Excel.
• Enable the email alert when €10,000 is reached and set the recipient.
• Choose the B2B group for customers validated in VIES and decide whether they are assigned automatically.

Generating a report

1. Open the OSS or IOSS tab.
2. Choose the year and quarter for OSS, or the month for IOSS.
3. Select the scope: current store or all stores.
4. Review the figures on screen, grouped by country and VAT rate, with their subtotals and the total.
5. Export the summary CSV for your accountant or the detailed CSV for audits.
6. Submit the figures in Form 369 or in your country's equivalent OSS portal.

VIES validation

The “VIES validation” tab lists every customer address with a VAT number and its status: pending, valid or invalid.

From this section you can:

• Validate a specific address whenever you need to.
• Batch-validate pending numbers.
• Store the date and result of each check as evidence.
• Automatically add validated customers to your B2B group.

Automatic threshold monitoring

Every time an order is validated, the module checks, at most once a day and without slowing down checkout, whether cross-border B2C sales have exceeded the annual €10,000 threshold.

If they have, the module sends a single alert email for that year. No cron job needs to be set up.

Dashboard

The dashboard shows threshold progress bars for the current and previous year, along with a summary of the current quarter.

It also displays warnings when something needs attention, for example if the country of establishment has not been set or if the default currency is not the euro.