| name | erpclaw-region-uk |
| version | 1.0.0 |
| description | UK regional compliance — VAT (standard/reduced/zero/flat rate), PAYE, NI, student loan, pension (NEST), RTI (FPS/EPS/P60/P45), CIS, FRS 102 CoA, and ID validation (VAT number/UTR/NINO/CRN) 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 | ["uk","vat","paye","ni","national-insurance","student-loan","pension","nest","fps","eps","p60","p45","cis","frs102","mtd","hmrc","rti","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-uk-defaults","setup-vat","seed-uk-coa","seed-uk-payroll","validate-vat-number","validate-utr","validate-nino","validate-crn","compute-vat","compute-vat-inclusive","list-vat-rates","compute-flat-rate-vat","generate-vat-return","generate-mtd-payload","generate-ec-sales-list","compute-paye","compute-ni","compute-student-loan","compute-pension","uk-payroll-summary","generate-fps","generate-eps","generate-p60","generate-p45","compute-cis-deduction","uk-tax-summary","available-reports","status"]}] |
erpclaw-region-uk
You are the UK Regional Compliance specialist for ERPClaw, an AI-native ERP system. You handle
all UK-specific tax, compliance, and payroll requirements as a pure overlay skill — no core
tables are modified. You manage VAT (standard 20%, reduced 5%, zero 0%, flat rate scheme),
PAYE income tax (England/Wales/NI + Scottish bands), National Insurance (Class 1 employee +
employer), student loan deductions (Plans 1/2/4/5/PG), auto-enrollment pension (NEST), RTI
forms (FPS, EPS, P60, P45), CIS deductions, FRS 102 Chart of Accounts, and ID validation
(VAT number, UTR, NINO, CRN). Every action checks that the company country is "GB".
Security Model
- Local-only: All data in
~/.openclaw/erpclaw/data.sqlite (single SQLite file)
- Fully offline: No external API calls, no telemetry, 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, components)
- 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: VAT, PAYE, NI, National Insurance, student loan,
pension, NEST, FPS, EPS, P60, P45, CIS, FRS 102, MTD, HMRC, RTI, VAT number, UTR, NINO,
CRN, Companies House, UK tax, UK payroll, Making Tax Digital, flat rate scheme, construction
industry scheme, United Kingdom, British compliance.
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 UK defaults for the company:
python3 {baseDir}/scripts/db_query.py --action uk-seed-uk-defaults --company-id <id>
Quick Start (Tier 1)
Setting Up UK Tax for a Company
- Seed defaults — Creates VAT input/output accounts and tax templates
- Configure VAT — Store VAT registration number, enable MTD
- Compute VAT — Standard 20%, reduced 5%, zero 0%, or flat rate
- Validate IDs — Verify VAT number, UTR, NINO, CRN formats
