EU VAT OSS & Intrastat Reporting

The problem

Selling across EU borders from Dynamics 365 Finance & Operations creates three separate filing obligations that all read the same transaction data and all want it in a different shape.

The One Stop Shop return needs distance sales to consumers split by member state of consumption and by VAT rate, in a single quarterly submission. The EC Sales List needs intra-community supplies of goods and services to VAT-registered businesses, grouped by counterparty VAT number and transaction type, filed monthly or quarterly depending on the country and the threshold. Intrastat needs the physical movement of goods, by commodity code, partner country, transaction nature, transport mode, net mass and supplementary units, filed to each member state in that state's own file layout, under that state's own thresholds, with arrivals and dispatches treated separately.

F&O has Intrastat and EU sales list functionality, but in practice teams still export to spreadsheets. Commodity codes are missing on some released products, statistical values do not reconcile to the ledger, credit notes and returns land in the wrong period, triangulation and call-off stock get handled by hand, and every member state wants a different file. The reconciliation happens in Excel under deadline pressure, and nobody can prove afterwards which transactions produced which line of a submitted return.

This is a build-to-order engagement. ECOSIRE scopes your registrations, your countries and your file formats, then builds and installs the extension in your environments.

What ECOSIRE builds

X++ extension model, no overlayering

Delivered as extension models over the standard Tax and Trade modules using chain-of-command, event handlers and table and form extensions. Nothing standard is overlayered, so One Version updates apply cleanly.

Registration and obligation setup

We add a registration register: per legal entity, the member states you are registered in, the scheme you file under, the reporting frequency, the thresholds that apply, and the responsible filer. This drives which reports are due and when, and it drives a due-date calendar so a missed filing surfaces before the deadline rather than after.

OSS return generation

A reporting engine reads posted customer invoices, credit notes and free text invoices, determines the member state of consumption from the delivery address and your place-of-supply rules, groups by state and rate, and produces the OSS return with the taxable amount and VAT amount per line. Corrections to prior periods are carried as adjustment lines rather than being folded silently into the current period, so the return reconciles to the ledger and to the prior submission.

EC Sales List

Intra-community supplies are collected by counterparty VAT registration number and split by transaction type — goods, services, triangulation — into the layout your filing member state requires. Counterparty VAT numbers are validated in format before a return is generated, and missing or invalid registrations are listed as exceptions with a link to the customer record.

Intrastat per member state

We build the arrival and dispatch collection from posted packing slips, product receipts, invoices and inventory transactions, carrying commodity code, partner country and partner VAT, country of origin, transaction nature, transport mode, delivery terms, net mass, supplementary units, invoice value and statistical value. Output formats are built per member state to the layout that state's authority accepts. Threshold logic is configured per state, per direction, so a country you are below the simplified threshold in is reported at the reduced detail level.

Ledger dimensions and traceability

Every reported line traces back to its source voucher. From a return line you open the underlying transactions, and the reconciliation report compares reported amounts to the sales tax transactions and to the ledger by financial dimension, so a variance is found before submission rather than during an audit.

Data quality gates

Before a period can be generated, a validation pass reports released products without a commodity code or net weight, customers without a valid VAT registration for an intra-community supply, addresses without a resolvable country, and transactions with no transaction nature. The gate names the record and links to it. This is the step that removes the spreadsheet.

Batch, entities and export

Generation runs on the batch framework per period and per legal entity. Data entities expose commodity codes, transaction natures, registration setup and generated return lines for import and read through the Data management framework and OData, so master data can be loaded in bulk and returns can be handed to a filing agent or a tax engine downstream.

Who it is for

Companies running Dynamics 365 Finance & Operations that ship goods or supply services across EU borders — distance sellers registered under One Stop Shop, manufacturers and distributors with intra-community movements, and groups filing Intrastat in more than one member state from one F&O instance.

How delivery works

1. Scoping call. We map your legal entities, your VAT registrations and schemes, the member states you file Intrastat in and in which direction, your product master data quality, and whether you file directly or through an agent. 2. Fixed quote. A written scope naming every country format included, at a fixed price. 3. Build. Developed against your F&O version with unit tests, and a reconciliation run against a copy of your posted data so the numbers are checked before you see them. 4. Install in test. Deployed to your sandbox through your LCS pipeline, configured, then a joint session generating a real historic period and reconciling it line by line to what you filed. 5. Production. The package moves to production through your release process after sign-off. We attend the first live filing period. 6. Support. A defined support window covering defects and covering format or threshold changes published within that window.

What we do not claim

We build the software that produces the returns and proves them against your ledger. We do not file on your behalf, we do not give tax advice, and the determination of your place-of-supply treatment stays with your tax advisor. Where you file through an agent or a national portal, we build to that channel's accepted file format.