Erpclaw Region Ca

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

1. Seed defaults — Creates GST/HST/PST/QST accounts and tax templates
2. Configure GST/HST — Set Business Number and province on the company
3. Compute sales tax — Auto-determines HST, GST+PST, or GST+QST by province
4. Validate IDs — Verify Business Number format and SIN Luhn checksum

Essential Commands

Seed Canada defaults (tax accounts + templates):

python3 {baseDir}/scripts/db_query.py --action ca-seed-ca-defaults --company-id <id>

Configure company for GST/HST:

python3 {baseDir}/scripts/db_query.py --action ca-setup-gst-hst --company-id <id> --business-number 123456789RT0001 --province ON

Compute sales tax (auto-detects tax type by province):

python3 {baseDir}/scripts/db_query.py --action ca-compute-sales-tax --amount 1000 --province ON

Validate a Business Number:

python3 {baseDir}/scripts/db_query.py --action ca-validate-business-number --bn 123456789RT0001

Check module status:

python3 {baseDir}/scripts/db_query.py --action status --company-id <id>

Canadian Sales Tax Structure

All Actions (Tier 2)

For all actions, use: python3 {baseDir}/scripts/db_query.py --action <action> [flags]

All output is JSON to stdout. Parse and format for the user.

Tax Setup & Validation (6 actions)

Tax Computation (7 actions)

Payroll Deductions (8 actions)

Compliance Forms (6 actions)

Reports (3 actions)

Quick Command Reference

Confirmation Requirements

Always confirm before: seeding defaults, setting up GST/HST, seeding CoA, seeding payroll components. Never confirm for: validations, computations, listing, generating reports/forms, status checks.

IMPORTANT: NEVER query the database with raw SQL. ALWAYS use the --action flag on db_query.py. The actions handle all necessary JOINs, validation, and formatting.

Response Formatting

• Format CAD amounts with dollar sign (e.g., $5,000.00)
• Tax breakdowns: table with GST, HST/PST/QST columns
• Payroll: table with CPP/QPP, EI, Federal Tax, Provincial Tax, Net Pay columns
• Keep responses concise — summarize, do not dump raw JSON

Technical Details (Tier 3)

Tables owned: None (pure overlay — all writes are seeding operations).

Asset files (8): ca_provinces.json, ca_gst_hst_rates.json, ca_pst_rates.json, ca_cpp_rates.json, ca_ei_rates.json, ca_federal_tax_brackets.json, ca_provincial_tax_brackets.json, ca_coa_aspe.json

Script: {baseDir}/scripts/db_query.py — all 30 actions routed through this single entry point.

Data conventions:

• All financial amounts and rates stored as TEXT (Python Decimal for precision)
• All IDs are TEXT (UUID4)
• Tax rates are percentages stored as TEXT (e.g., "13" means 13%)
• BN validation: 9 digits (base) or 15 chars (9 digits + program code + 4-digit reference)
• SIN validation: 9 digits with Luhn checksum; starts with 1-7 (regular) or 8 (temporary resident)
• CPP/QPP use same YMPE ($74,600 for 2026); QPP rate higher (6.30% vs 5.95%)
• CPP2 applies to earnings between first ceiling ($74,600) and second ceiling ($85,000)
• Quebec uses QPP instead of CPP, and has reduced EI rate + QPIP

Error recovery: