EU VAT Reports Module: OSS, IOSS + VIES Validation

• Quarterly OSS report grouped by country of consumption and VAT rate, including taxable base and VAT amount.
• Report structure aligned with Modelo 369 and the equivalent OSS portal of every EU member state.
• Monthly IOSS report for imported consignments, with an automatic EUR 150 cut-off.
• Your IOSS number (IM...) displayed in the IOSS report.
• EUR 10,000 distance-selling threshold monitor for the current and previous year.
• Automatic annual email alert when the threshold is exceeded.
• VAT rate derived from the actual amounts of each order and matched against the official rates of the destination country.
• Warning including the order reference when a rate does not match any official VAT rate.
• Editable built-in table containing the 2026 EU VAT rates.
• Individual and batch VIES validation of intra-Community VAT numbers.
• Validation evidence stored, including the date, result and request identifier when provided by VIES.
• Optional automatic assignment of validated customers to a B2B group.
• Automatic exclusion of B2B orders and domestic sales.
• Credit slips issued during the period deducted from the reported amounts.
• Cart discounts prorated and shipping costs included in the taxable base.
• Multicurrency support: amounts are converted into your default currency using the exchange rate applied to each order.
• Summary CSV export for your accountant.
• Detailed CSV export by order for reconciliation and auditing.
• Excel-friendly CSV format, with UTF-8 BOM, configurable separator and decimal format.
• Configurable order statuses. Paid statuses are selected by default.
• Text and interface available in English, Spanish, French, German, Italian and Portuguese.
• Multistore compatible, allowing reports for the current shop or all shops.
• No cron jobs, API keys or subscriptions required.
• Compatible with PrestaShop 1.7, 8.x and 9.x.
• Simple installation without modifying system files.

Advantages for your business

• An hour of work in two clicks: The quarterly spreadsheet process of exporting orders, separating them by country and matching VAT rates becomes a report that you can generate on screen and export in seconds.
• Reliable figures, not guesswork: The applied VAT rate is calculated from the actual amounts of each order. This means the report does not depend on your tax tables being configured perfectly.
• Know when you must file: The threshold monitor tracks the EUR 10,000 limit and sends you an email as soon as you become required to file through OSS, helping you avoid unexpected obligations.
• Instant B2B VAT exemption: Validate a company’s VAT number through VIES and, optionally, assign the customer directly to your B2B group so that you can sell to them without charging VAT.
• Auditable and transparent: The detailed CSV provides your accountant with all the information required to reconcile each figure against the corresponding invoices. Any order whose VAT does not match an official rate is clearly flagged with its reference and is never hidden.
• No conflicts or dependencies: The module does not modify the front office or interfere with VAT calculations during checkout, so it does not create conflicts with your theme. It also requires no external paid services, as VIES validation uses the free and official European Commission service.

Installation and configuration

Installation is simple: download the module, install it from the PrestaShop panel and access the configuration section. Upon installation, the module suggests sensible default values, including the establishment country, paid order statuses and the alert email address. A help panel also provides step-by-step instructions for each option.

Module customization

From the “Module Settings” tab, you can:

• Set your establishment country. Sales made within this country will be treated as domestic.
• Choose which order statuses count as paid.
• Exclude B2B orders, deduct credit slips and include shipping costs. The shipping option is enabled by default.
• Enter your IOSS number (IM...).
• Edit the EU VAT rates table if a country changes its applicable rates.
• Choose the CSV separator and decimal format for Excel.
• Enable the EUR 10,000 email alert and define the recipient.
• Select the B2B group for customers validated through VIES and decide whether the assignment should be automatic.

Generating a report

1. Open the OSS or IOSS tab.
2. Select the year and quarter for OSS, or the month for IOSS.
3. Choose the scope: current shop or all shops.
4. Review the figures displayed on screen, grouped by country and VAT rate, including subtotals and the overall total.
5. Export the summary CSV for your accountant or the detailed CSV for auditing purposes.
6. Submit the figures through Modelo 369 or the equivalent OSS portal in your country.

VIES validation

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

From this section, you can:

• Validate an individual address whenever needed.
• Validate pending VAT numbers in batches.
• Store the date and result of each check as evidence.
• Automatically assign validated customers to your selected B2B group.

Automatic threshold monitoring

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

When the threshold is exceeded, the module sends a single email notification during that year. No cron job is required.

Dashboard

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

It also shows warnings when something requires your attention, such as when no establishment country has been selected or when the default currency is not the euro.