Simplified European VAT declaration - VAT by country and rate, rates checked

Simplified European VAT declaration - VAT by country and rate, rates checked

Your EU VAT return in one click, with rates that stay up to date Net sales and VAT for the period, by country and rate, credit slips deducted, ready for the OSS. Your VAT rates compared every day with the official rates, and fixed in one click when a country changes.

Versión v1.8.0 Compatibilidad PS 1.6 → 9.x Categoría International & Localization 0 instalaciones 10.0★ valoración media

Descripción

The problem

Since the OSS, every distance sale within the EU is declared at the customer's country rate. Preparing the return means grouping sales by country and rate, allocating discounts and shipping, removing credit slips and converting currencies.

And rates change: a country raises its standard rate, the shop keeps charging the old one, and the gap only shows up when filing.

The solution

The module calculates the period's return in one click: one total per country and rate, credit slips deducted, detailed order by order and exportable to Excel.

It checks your VAT rates every day against the official rates of the 27 EU countries, alerts you when a rate changes and fixes an outdated rate in one click.

What sets it apart

Six design choices that make the difference when filing.

The calculation of your invoices

Discounts allocated to products, shipping at the carrier's rate, line rounding: the amounts are those of your invoices.

Credit slips in the right period

Deducted at the country and rate of the original order, in the period when they are issued, refunded shipping included.

Official rates

Your tax rules compared with the rates published by the member states in the European Commission's TEDB database, updated every week.

One-click fix

An outdated rate is fixed from the module: only that country's rules change, your past orders keep their rate.

Excel with real numbers

Numeric amounts ready to add up, CSV readable as is, copy for any spreadsheet. Generated in your browser.

Multi-currency and multistore

One return per currency or conversion at each order's rate, one shop or all.

Three ways to prepare a VAT return

They do not take the same work. Here is where the module stands.

Order export and spreadsheetGeneric accounting exportSimplified European VAT declaration
Totals by country and rate To build Depends on the module Yes, ready for the OSS
Discounts and shipping allocated By hand Rarely Yes, as on the invoice
Credit slips in their issue period By hand Depends on the module Yes, at the original rate
Order-by-order detail Yes Yes Yes, with a link to the order
VAT rates check No No Every day, 27 countries
Outdated rate fix No No In one click
Orders at the old rate flagged No No Yes, with their numbers
PrestaShop 1.6 Yes Rarely Yes

The module prepares the amounts of your return, it does not file it with the tax authorities. The rates reference comes from TEDB, the database where member states publish their rates; it may omit some reduced or temporary rates.

How it works

1

The period

The previous quarter is suggested by default. Tick the order statuses to include and the display options.

2

The return

One total per country and rate, with the per-order detail and credit slips deducted, ready to export for your accountant.

3

The rates check

Every day, your rates are compared with the official rates. A banner warns you of a change, and one click fixes it.

Detailed features

Period calculation

  • Previous quarter suggested by default
  • Order statuses of your choice, with colour hints
  • Invoice date and billing address country
  • Choices remembered for the next calculation

VAT return

  • Net sales and VAT by country and rate
  • Discounts allocated as on the invoice
  • Shipping at the carrier's rate
  • One return per currency, or conversion at each order's rate

Credit slips

  • Deducted at the country and rate of the original order
  • In the period when the credit slip is issued
  • Refunded shipping included
  • Detail with credit slip and order dates

Verification

  • Per-order detail with a link to the order
  • Alert on orders without tax details
  • Orders invoiced at an outdated rate flagged
  • 0% lines left out

VAT rates check

  • 27 EU countries, standard and reduced rates
  • TEDB reference updated every week
  • Refreshed once a day, embedded reference offline
  • Shop country rates recognised (10,000 EUR threshold)

Alerts and fixes

  • Back-office banner when a rate changes
  • Changes of the last two months and the next six
  • One-click fix, after confirmation
  • Change written to the PrestaShop logs

Tables and exports

  • Sorting, search and pagination
  • Copy, UTF-8 CSV and Excel .xlsx
  • Amounts as numbers in Excel
  • No library loaded from a CDN

Options

  • Default country included or excluded
  • Unformatted prices for a spreadsheet
  • States merged into their country
  • Multistore: one shop or all

Documentation and support

  • PDF documentation in 6 languages
  • Built-in FAQ of 29 questions
  • Support form inside the module
  • Interface in 6 languages

License and support

The module is fully functional as soon as it is installed. The Mediacom87 license supplied with the module unlocks update notifications and support, which you contact directly from the module. Published by Mediacom87, PrestaShop specialist since 2008.

Installation in 4 steps

Install the module from your back office (Modules > Module Manager): invoiced statuses are ticked by default.

In the VAT tab, keep the suggested quarter or choose your dates.

Click Show my VAT, check the detail, then export to Excel or CSV.

In the VAT rates tab, fix an outdated rate in one click.

Características

Historial de versiones

v1.8.0
  • New VAT rates tab: your tax rules are compared with the rates in force in each EU country, and a back-office banner warns you when a rate changes
  • The declaration flags the orders invoiced at a rate that was not in force on their invoice date
  • An outdated rate is corrected in one click, without searching through the tax rules
  • New License tab: register the module to unlock update notifications and priority support
  • Contact support directly from the module through a form, no email client needed
  • Fixed the new version alert, which did not display the available version
  • Tables no longer load any library from an external server: sorting, search and Copy / CSV / Excel export work offline
  • Amounts are exported to Excel as numbers, ready to be summed
  • Credit slips now show the name of each tax instead of its raw rate
  • New FAQ tab answering the most frequent questions about the declaration
  • The More Modules tab is replaced by a button to our catalogue in the Informations tab
v1.7.0
  • Major overhaul of VAT calculation engine using bulk SQL queries for significantly improved performance
  • Fixed tax calculation accuracy: proper discount distribution with cart rules and free shipping
  • Fixed orders with free shipping cart rules incorrectly reporting shipping VAT
  • Fixed tax name display: shipping-only tax rates now show proper names instead of numeric values
  • Fixed rounding discrepancy on orders without discounts by using stored tax amounts
  • Orders with all amounts at zero are no longer displayed in the detail listing
  • Added option to merge state-level entries into their parent country
  • Added option to convert all amounts to the default currency using historical exchange rates
  • Added order reference column in the detail listing
  • Filtered out 0% tax rate entries from declarations
  • Rewritten features description in the information tab
  • Cleaned up and optimized CSS files
  • Fixed flexbox layout for the modules tab
  • Improved multi-shop compatibility
  • DataTables library updated to version 2.3.7, Buttons to 3.2.6
v1.6.0
  • Added compatibility with PrestaShop 9
  • Improved credit slip processing
  • Improved display of declarations by currency if deactivated
  • Correction of declaration totals in different currencies
  • Datatables library updated to version 2.2.2
v1.5.0
  • Integration of credit notes
  • DataTables library updated
v1.3.0
  • Added an option to export result tables as CSV or Excel files
  • Added an option to display the amounts without any formatting and facilitate processing when exporting to a spreadsheet
  • Changes in the processing of translations of certain elements
  • Improved presentation of order status to facilitate the selection of those to be exported
  • Added Logs and an error message if some orders do not have tax information when they should
v1.2.1
  • Correction of VAT treatment on shipping costs
v1.4.0
  • Automatic definition of the quarter preceding today's date to facilitate declarations
  • Improved compatibility with PHP 8
  • Updated all libraries versions
v1.2.0
  • Improvement of some texts to facilitate the use of the module
  • Added a control on the dates to avoid reversing the start and end date of the period
v1.1.0
  • Merging of tax lines for countries that do not have the State of Activation option
  • Correction of a calculation bug on the total taxes to declare
  • Addition of the country of each order in the listing of the orders connected by the period
v1.0.0
  • Initial commit

Opiniones de clientes · 2 opiniones verificadas

Bertrand D. ★★★★★ 2022-08-29
Makes reporting so much easier and quicker
Great tool, simple to use, excellent support. Thanks!

¿Un proyecto, una pregunta, una auditoría?

Respuesta personal en 24h laborables. Conversemos sin compromiso.

Hablemos de tu proyecto →