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.
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 spreadsheet | Generic accounting export | Simplified 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
The period
The previous quarter is suggested by default. Tick the order statuses to include and the display options.
The return
One total per country and rate, with the per-order detail and credit slips deducted, ready to export for your accountant.
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
- 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
- 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
- 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
- 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
- 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)
- 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
- Sorting, search and pagination
- Copy, UTF-8 CSV and Excel .xlsx
- Amounts as numbers in Excel
- No library loaded from a CDN
- Default country included or excluded
- Unformatted prices for a spreadsheet
- States merged into their country
- Multistore: one shop or all
- PDF documentation in 6 languages
- Built-in FAQ of 29 questions
- Support form inside the module
- Interface in 6 languages
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
¿Un proyecto, una pregunta, una auditoría?
Respuesta personal en 24h laborables. Conversemos sin compromiso.
Hablemos de tu proyecto →