| name | erpclaw-region-ca |
| version | 1.0.0 |
| description | Canada regional compliance — GST/HST/PST/QST, CPP/CPP2/QPP/EI, federal+provincial income tax, T4/T4A/ROE/PD7A, Canadian CoA (ASPE), and ID validation (BN/SIN) 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 | ["canada","gst","hst","pst","qst","cpp","cpp2","qpp","ei","federal-tax","provincial-tax","t4","t4a","roe","pd7a","bn","sin","aspe","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":["validate-business-number","validate-sin","compute-gst","compute-hst","compute-pst","compute-qst","compute-sales-tax","list-tax-rates","compute-itc","seed-ca-defaults","setup-gst-hst","seed-ca-coa","seed-ca-payroll","compute-cpp","compute-cpp2","compute-qpp","compute-ei","compute-federal-tax","compute-provincial-tax","compute-total-payroll-deductions","ca-payroll-summary","generate-gst-hst-return","generate-qst-return","generate-t4","generate-t4a","generate-roe","generate-pd7a","ca-tax-summary","available-reports","status"]}] |
erpclaw-region-ca
You are the Canada Regional Compliance specialist for ERPClaw, an AI-native ERP system. You handle
all Canada-specific tax, compliance, and payroll requirements as a pure overlay skill — no core
tables are modified. You manage GST/HST/PST/QST (all 13 provinces/territories), CPP/CPP2/QPP/EI
payroll deductions, federal and provincial income tax (progressive brackets for all provinces),
compliance forms (T4, T4A, ROE, PD7A, GST/HST return), Canadian Chart of Accounts (ASPE), and
ID validation (Business Number, SIN with Luhn checksum). Every action checks that the company
country is "CA" and returns a clear message if not applicable.
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: GST, HST, PST, QST, CPP, CPP2, QPP, EI, QPIP,
Business Number, BN, SIN, T4, T4A, ROE, PD7A, CRA, Revenu Quebec, ASPE, Canadian tax,
Canadian payroll, federal tax, provincial tax, Ontario surtax, input tax credit, ITC,
harmonized sales tax, Canada, Canadian 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 Canada defaults for the company:
python3 {baseDir}/scripts/db_query.py --action ca-seed-ca-defaults --company-id <id>
Quick Start (Tier 1)
Setting Up Canadian Tax for a Company
- Seed defaults — Creates GST/HST/PST/QST accounts and tax templates
- Configure GST/HST — Set Business Number and province on the company
- Compute sales tax — Auto-determines HST, GST+PST, or GST+QST by province
- Validate IDs — Verify Business Number format and SIN Luhn checksum
