# EU Intrastat Threshold Monitoring Worksheet > Source: https://netray.co/tools/eu-intrastat-threshold-monitoring-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track year-to-date intra-EU arrivals and dispatches against your national Intrastat thresholds and see projected annual use. ## Category regional ## Region European Union ## Audience - Logistics manager - Customs specialist - Finance controller ## Tool **Kind:** worksheet **Mode:** editable **Currency:** EUR **Columns:** #### Legal entity **Key:** entity **Type:** text #### Member state **Key:** country **Type:** select **Options:** - Germany - France - Italy - Spain - Netherlands - Belgium - Poland - Czechia - Austria - Ireland - Sweden - Other EU #### Flow **Key:** flow **Type:** select **Options:** - Dispatches - Arrivals #### Months elapsed **Key:** months **Type:** number **Unit:** months #### YTD statistical value **Key:** ytd **Type:** number **Format:** currency #### National threshold **Key:** threshold **Type:** number **Format:** currency **Help:** Enter the current figure published by your national statistics or customs authority. #### Threshold used **Key:** used **Type:** number **Expr:** ytd / threshold * 100 **Format:** percent #### Headroom **Key:** headroom **Type:** number **Expr:** threshold - ytd **Format:** currency #### Projected annual value **Key:** proj **Type:** number **Expr:** ytd / months * 12 **Format:** currency #### Projected vs threshold **Key:** proj_pct **Type:** number **Expr:** ytd / months * 12 / threshold * 100 **Format:** percent **Rows:** **Entity:** Acme GmbH **Country:** Germany **Flow:** Dispatches **Months:** 9 **Ytd:** 410000 **Threshold:** 500000 **Used:** 0 **Headroom:** 0 **Proj:** 0 **Proj pct:** 0 **Entity:** Acme GmbH **Country:** Germany **Flow:** Arrivals **Months:** 9 **Ytd:** 520000 **Threshold:** 800000 **Used:** 0 **Headroom:** 0 **Proj:** 0 **Proj pct:** 0 **Entity:** Acme Italia Srl **Country:** Italy **Flow:** Dispatches **Months:** 9 **Ytd:** 95000 **Threshold:** 350000 **Used:** 0 **Headroom:** 0 **Proj:** 0 **Proj pct:** 0 **Entity:** Acme BV **Country:** Netherlands **Flow:** Arrivals **Months:** 9 **Ytd:** 880000 **Threshold:** 1000000 **Used:** 0 **Headroom:** 0 **Proj:** 0 **Proj pct:** 0 **Entity:** Acme Sp. z o.o. **Country:** Poland **Flow:** Dispatches **Months:** 9 **Ytd:** 1200000 **Threshold:** 1000000 **Used:** 0 **Headroom:** 0 **Proj:** 0 **Proj pct:** 0 **Totals:** #### Total YTD statistical value **Key:** ytd **Agg:** sum **Format:** currency **Summary:** #### Highest projected use of any threshold **Key:** worst **Expr:** max_proj_pct **Format:** percent **Primary:** true #### Lines tracked **Key:** lines **Expr:** count **Format:** integer **Notes:** Threshold values in the example rows are illustrative placeholders. Thresholds differ by member state, by flow, and are revised, so replace them with the current official figures. Many states also have a separate, higher threshold for the detail level of data required. ## Content **Intro:** Intrastat is the statistical survey of goods moving between EU member states. Whether you must file depends on a national threshold for arrivals and dispatches, and exceeding it mid-year can trigger monthly reporting with little warning. This worksheet keeps each entity and flow in one table and flags how close you are. **Sections:** #### How to use the worksheet **Body:** Add one row for each legal entity, member state and flow, either arrivals or dispatches, since thresholds are normally set separately for each. Enter the months elapsed and the year-to-date statistical value from your ERP or customs reports, then type the current national threshold. The sheet computes the share used, the headroom, a straight-line projection of the full year and how that projection compares with the limit. Export the table to Excel to share with logistics and finance each month. #### What is being measured **Body:** Thresholds are applied to the value of intra-EU trade in goods, normally the statistical value, which is often the invoiced value excluding VAT adjusted to the border (usually a delivered-to-border basis). Each member state sets its own annual thresholds, and there are typically separate figures for arrivals and dispatches. Once exceeded, a business usually becomes obliged to file from the month the limit was crossed, and the obligation tends to continue into the following year. Your national authority publishes the official rules. **Bullets:** - Compare like with like: statistical value, not margin or cost - Track arrivals and dispatches separately - Track by legal entity and VAT registration, not by group - Straight-line projections are a warning, not a forecast #### Reading the results **Body:** If threshold used is above 100 percent, you have probably crossed the limit and need to check the filing deadline for that month. A projected figure above 100 percent while the current use is below it is an early warning, so prepare commodity codes, countries of origin, transaction nature codes and transport data before you need them. In the example, the Polish dispatch line is already over the limit, while the Dutch arrivals line is on track to exceed it by year-end. #### ERP notes and common mistakes **Body:** Most ERPs have an Intrastat module, but it only helps if tax and commodity master data are correct. Common mistakes include mixing entities, forgetting returns and credit notes, missing consignment stock and processing movements, and using the invoice currency instead of the reporting currency. Review the product commodity code (CN8) for items you ship often, because errors multiply across lines. **Cta:** If you want threshold alerts triggered from live shipment and invoice data, Netray can help build a read-only monitor over your ERP, deployed on your own infrastructure. **Faq:** #### Are Intrastat thresholds the same in every EU country? **Answer:** No. Each member state sets its own annual thresholds and they are changed from time to time. Many states have separate limits for arrivals and dispatches, so use the official figure from your national authority. #### Does Intrastat apply to services? **Answer:** No. Intrastat covers trade in goods between EU member states. Services are reported through other mechanisms, such as the VAT EC Sales List where relevant, and are not included in the Intrastat threshold. #### What happens once we cross the threshold? **Answer:** In most states you must start filing declarations for the month in which the limit was crossed, and you may be required to keep filing the following year. Check the exact deadline and format with your national statistics or customs authority. #### Do we count the UK? **Answer:** Since Brexit, the UK is no longer an EU member state for Intrastat purposes, with a special arrangement for Northern Ireland goods trade with the EU. Confirm the current treatment with the authority in your member state. ## Search terms intrastat threshold worksheet, intrastat threshold tracker, intrastat excel template, intrastat arrivals dispatches threshold, intrastat reporting obligation manufacturer, intra-eu trade statistics threshold, intrastat monitoring, intrastat erp report --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json