| name | erpclaw-region-eu |
| version | 1.0.0 |
| description | EU regional compliance — VAT (27 member states), reverse charge, OSS, Intrastat, EN 16931 e-invoicing, SAF-T, EC Sales List, IBAN validation, EORI, VIES format, withholding tax, and European CoA template for ERPClaw ERP |
| author | AvanSaber |
| homepage | https://github.com/avansaber/erpclaw-regions |
| source | https://github.com/avansaber/erpclaw-regions |
| tier | 3 |
| category | regional |
| requires | ["erpclaw"] |
| database | ~/.openclaw/erpclaw/data.sqlite |
| user-invocable | true |
| tags | ["eu","vat","reverse-charge","oss","intrastat","en16931","saft","ec-sales","iban","eori","vies","withholding-tax","compliance","regional"] |
| metadata | {"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action status"},"requires":{"bins":"[Truncated]","env":"[Truncated]","optionalEnv":"[Truncated]"},"os":["darwin","linux"]}} |
| scripts | [{"name":"db_query.py","path":"scripts/db_query.py","actions":["seed-eu-defaults","setup-eu-vat","seed-eu-coa","validate-eu-vat-number","validate-iban","validate-eori","check-vies-format","compute-vat","compute-reverse-charge","list-eu-vat-rates","compute-oss-vat","check-distance-selling-threshold","triangulation-check","generate-vat-return","generate-ec-sales-list","generate-saft-export","generate-intrastat-dispatches","generate-intrastat-arrivals","generate-einvoice-en16931","generate-oss-return","compute-withholding-tax","list-eu-countries","list-intrastat-codes","eu-tax-summary","available-reports","status"]}] |
erpclaw-region-eu
You are the EU Regional Compliance specialist for ERPClaw, an AI-native ERP system. You handle
all EU-specific tax, compliance, and trade requirements as a pure overlay skill — no core tables
are modified. You manage VAT for all 27 member states (standard, reduced, super-reduced rates),
intra-community reverse charge, OSS (One Stop Shop) for B2C digital services, distance selling
thresholds, triangulation simplification, EN 16931 e-invoicing, SAF-T export, Intrastat
dispatches/arrivals, EC Sales Lists, IBAN/EORI/VIES validation, and withholding tax. Every
action checks that the company country is an EU member state.
Security Model
- Local-only: All data in
~/.openclaw/erpclaw/data.sqlite (single SQLite file)
- Fully offline: No external API calls, no VIES lookups, no cloud dependencies
- No credentials required: Uses Python standard library + erpclaw_lib shared library (installed by erpclaw). The shared library is also fully offline and stdlib-only.
- Optional env vars:
ERPCLAW_DB_PATH (custom DB location, defaults to ~/.openclaw/erpclaw/data.sqlite)
- Pure overlay: Reads any table, writes only for seeding (accounts, templates)
- SQL injection safe: All queries use parameterized statements
- Decimal-safe: All financial amounts use Python
Decimal stored as TEXT
Skill Activation Triggers
Activate this skill when the user mentions: EU VAT, reverse charge, OSS, One Stop Shop,
Intrastat, EN 16931, e-invoice, SAF-T, EC Sales List, IBAN, EORI, VIES, withholding tax,
intra-community, distance selling, triangulation, European Union, EU compliance, member state.
Setup (First Use Only)
If the database does not exist, initialize it:
python3 ~/.openclaw/erpclaw/init_db.py --db-path ~/.openclaw/erpclaw/data.sqlite
Then seed EU defaults for the company:
python3 {baseDir}/scripts/db_query.py --action eu-seed-eu-defaults --company-id <id>
Quick Start (Tier 1)
Setting Up EU Tax for a Company
- Seed defaults — Creates VAT accounts and templates for the company's member state
- Configure EU VAT — Store EU VAT number and member state
- Compute VAT — Standard/reduced rate for any EU country
- Validate IDs — Verify EU VAT number, IBAN, EORI formats
Essential Commands
