--- name: erpclaw version: 3.4.1 description: > AI-native ERP system. Full accounting, invoicing, inventory, purchasing, tax, billing, HR, payroll, advanced accounting (ASC 606/842, intercompany, consolidation), and financial reporting. 467 actions across 14 domains, 43 optional expansion modules (user-approved install from GitHub). Double-entry GL, immutable audit trail, US GAAP compliant. author: AvanSaber homepage: https://github.com/avansaber/erpclaw source: https://github.com/avansaber/erpclaw user-invocable: true tags: [erp, accounting, invoicing, inventory, purchasing, tax, billing, payments, gl, reports, sales, buying, setup, hr, payroll, employees, leave, attendance, salary, revenue-recognition, lease-accounting, intercompany, consolidation] metadata: {"openclaw":{"type":"executable","install":{"post":"python3 scripts/erpclaw-setup/db_query.py --action initialize-database"},"requires":{"bins":["python3","git"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH"]},"os":["darwin","linux"]}} cron: - expression: "0 1 *" timezone: "America/Chicago" message: "Using erpclaw, run the process-recurring action." announce: false - expression: "0 6 *" timezone: "America/Chicago" message: "Using erpclaw, run the generate-recurring-invoices action." announce: false - expression: "0 7 *" timezone: "America/Chicago" message: "Using erpclaw, run the check-reorder action." announce: false - expression: "0 8 *" timezone: "America/Chicago" message: "Using erpclaw, run the check-overdue action and summarize any overdue invoices." announce: false ---

erpclaw

Full-Stack ERP Controller for ERPClaw. Handles company setup, chart of accounts, journal entries, payments, tax, financial reports, customers, sales, suppliers, purchasing, inventory, billing, HR (employees, leave, attendance, expenses), US payroll (FICA, W-2, garnishments), advanced accounting (ASC 606/842, intercompany, consolidation), and 43 industry modules. Single local SQLite DB, double-entry GL, immutable audit trail.

Security: Local-first (~/.openclaw/erpclaw/data.sqlite). Parameterized queries. RBAC (PBKDF2). Immutable GL. Network only for fetch-exchange-rates (public API) and install-module (GitHub avansaber/*, requires user approval). Integration API keys (Stripe, Shopify, etc.) are passed via --api-key flags and stored in the local DB only — no credentials in code or environment variables.

Skill Activation Triggers

Activate when user mentions: ERP, accounting, invoice, sales order, purchase order, customer, supplier, inventory, payment, GL, trial balance, P&L, balance sheet, tax, billing, modules, install module, onboard, CRM, manufacturing, healthcare, education, retail, employee, HR, payroll, salary, leave, attendance, expense claim, W-2, garnishment, integration.

Auto-Detection

When a user describes their business: detect type (e.g., "dental practice" -> dental), ask user to confirm before proceeding, then call setup-company --industry . Industry values: retail, restaurant, healthcare, dental, veterinary, construction, manufacturing, legal, agriculture, hospitality, property, school, university, nonprofit, automotive, therapy, home-health, consulting, distribution, saas. When a user asks about a service or integration not currently installed, search the module registry and suggest installation (never auto-install without user approval).

Setup

python3 {baseDir}/scripts/erpclaw-setup/db_query.py --action initialize-database
python3 {baseDir}/scripts/db_query.py --action seed-defaults --company-id <id>
python3 {baseDir}/scripts/db_query.py --action setup-chart-of-accounts --company-id <id> --template us_gaap

All 467 Actions

Setup & Admin (44)

| Action | Description | |--------|-------------| | initialize-database / setup-company / update-company / get-company / list-companies | DB init & company CRUD | | add-currency / list-currencies / add-exchange-rate / get-exchange-rate / list-exchange-rates / fetch-exchange-rates | Currency & FX | | add-payment-terms / list-payment-terms / add-uom / list-uoms / add-uom-conversion | Terms & UoMs | | seed-defaults / seed-demo-data / check-installation / install-guide / setup-web-dashboard / tutorial / onboarding-step / status | Seeding & utilities | | add-user / update-user / get-user / list-users / set-password | User management | | add-role / list-roles / assign-role / revoke-role / seed-permissions | RBAC & security | | link-telegram-user / unlink-telegram-user / check-telegram-permission | Telegram integration | | backup-database / list-backups / verify-backup / restore-database / cleanup-backups | DB backup/restore | | get-audit-log / get-schema-version / update-regional-settings / onboard | System admin |

General Ledger (26)

| Action | Description | |--------|-------------| | setup-chart-of-accounts / add-account / update-account / get-account / list-accounts | Account CRUD | | freeze-account / unfreeze-account / get-account-balance / check-gl-integrity | Account management | | post-gl-entries / reverse-gl-entries / list-gl-entries | GL posting | | add-fiscal-year / list-fiscal-years / validate-period-close / close-fiscal-year / reopen-fiscal-year | Fiscal year | | add-cost-center / list-cost-centers / add-budget / list-budgets | Cost centers & budgets | | seed-naming-series / next-series / revalue-foreign-balances | Naming & FX revaluation | | import-chart-of-accounts / import-opening-balances | CSV import |

Journal Entries (16)

| Action | Description | |--------|-------------| | add-journal-entry / update-journal-entry / get-journal-entry / list-journal-entries | JE CRUD | | submit-journal-entry / cancel-journal-entry / amend-journal-entry / delete-journal-entry / duplicate-journal-entry | JE lifecycle | | create-intercompany-je | Intercompany JE | | add-recurring-template / update-recurring-template / list-recurring-templates / get-recurring-template / process-recurring / delete-recurring-template | Recurring JEs |

Payments (13)

| Action | Description | |--------|-------------| | add-payment / update-payment / get-payment / list-payments / submit-payment / cancel-payment / delete-payment | Payment CRUD & lifecycle | | create-payment-ledger-entry / get-outstanding / get-unallocated-payments / allocate-payment / reconcile-payments / bank-reconciliation | Reconciliation |

Tax (17)

| Action | Description | |--------|-------------| | add-tax-template / update-tax-template / get-tax-template / list-tax-templates / delete-tax-template | Tax template CRUD | | resolve-tax-template / calculate-tax / add-tax-category / list-tax-categories / add-tax-rule / list-tax-rules | Tax rules | | add-item-tax-template / add-tax-withholding-category / get-withholding-details | Withholding | | record-withholding-entry / record-1099-payment / generate-1099-data | 1099 reporting |

Financial Reports (20)

| Action | Description | |--------|-------------| | trial-balance / profit-and-loss / balance-sheet / cash-flow / general-ledger / party-ledger | Core statements | | ar-aging / ap-aging / budget-vs-actual (alias: budget-variance) | Aging & budget | | tax-summary / payment-summary / gl-summary / comparative-pl / check-overdue | Summaries | | add-elimination-rule / list-elimination-rules / run-elimination / list-elimination-entries | Intercompany |

...