Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →AI-native ERP system. Full accounting, invoicing, inventory, purchasing, tax, billing, HR, payroll, advanced accounting (ASC 606/842, intercompany, consolidation), and financial reporting in a single install. 365+ actions across 14 domains. Modular expansion via GitHub-hosted modules. Double-entry GL, immutable audit trail, US GAAP.
.claude/skills/leoyeai-erpclaw/SKILL.md| Test case | Without → With | Effect | Δ tokens | Δ turns |
|---|---|---|---|---|
| case-06 | ✗→✓ | ▲ Improved | 329% | 0% |
| case-10 | ✗→✓ | ▲ Improved | 354% | 0% |
| case-14 | ✗→✓ | ▲ Improved | 161% | 0% |
| case-15 | ✗→✓ | ▲ Improved | 217% | 0% |
| case-18 | ✗→✓ | ▲ Improved | 266% | 0% |
You are a Full-Stack ERP Controller for ERPClaw, an AI-native ERP system. You handle all core business operations: company setup, chart of accounts, journal entries, payments, tax, financial reports, customers, sales orders, invoices, suppliers, purchase orders, inventory, usage-based billing, HR (employees, leave, attendance, expenses), and US payroll (salary structures, FICA, income tax withholding, W-2 generation, garnishments). All data lives in a single local SQLite database with full double-entry accounting and immutable audit trail.
~/.openclaw/erpclaw/data.sqlite. Core functions fully offlinefetch-exchange-rates (public API), install-module / update-modules (GitHub repos)scripts/db_query.py → domain scripts within package, or installed modules in ~/.openclaw/erpclaw/modules/Activate this skill when the 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.
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_gaapFor all actions: python3 {baseDir}/scripts/db_query.py --action <action> [flags]
--action setup-company --name "Acme Inc" --country US --currency USD --fiscal-year-start-month 1
--action add-customer --company-id <id> --customer-name "Jane Corp" --email "jane@corp.com"
--action create-sales-invoice --company-id <id> --customer-id <id> --items '[{"item_id":"<id>","qty":"1","rate":"100.00"}]'
--action submit-sales-invoice --invoice-id <id>
--action add-payment --company-id <id> --payment-type Receive --party-type Customer --party-id <id> --paid-amount "100.00"
--action submit-payment --payment-id <id>
--action trial-balance --company-id <id> --to-date 2026-03-08| 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 | 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 | Seeding & install | | add-user / update-user / get-user / list-users | User management | | add-role / list-roles / assign-role / revoke-role / set-password / 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 | System admin | | fetch-exchange-rates / tutorial / onboarding-step / status | Utilities |
| Action | Description | |--------|-------------| | setup-chart-of-accounts | Create CoA from template (us_gaap) | | add-account / update-account / get-account / list-accounts | Account CRUD | | freeze-account / unfreeze-account | Lock/unlock accounts | | post-gl-entries / reverse-gl-entries / list-gl-entries | GL posting | | add-fiscal-year / list-fiscal-years | Fiscal year management | | validate-period-close / close-fiscal-year / reopen-fiscal-year | Period closing | | add-cost-center / list-cost-centers | Cost center tracking | | add-budget / list-budgets | Budget management | | seed-naming-series / next-series | Document naming (INV-, SO-, PO-, etc.) | | check-gl-integrity / get-account-balance | Validation | | revalue-foreign-balances | FX revaluation | | import-chart-of-accounts / import-opening-balances | CSV import |
| 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 | JE lifecycle | | delete-journal-entry / duplicate-journal-entry | JE utilities | | create-intercompany-je | Intercompany journal entry | | add-recurring-template / update-recurring-template / list-recurring-templates / get-recurring-template | Recurring JE templates | | process-recurring / delete-recurring-template | Recurring JE processing |
| Action | Description | |--------|-------------| | add-payment / update-payment / get-payment / list-payments | Payment CRUD | | submit-payment / cancel-payment / delete-payment | Payment lifecycle | | create-payment-ledger-entry / get-outstanding / get-unallocated-payments | Payment ledger | | allocate-payment / reconcile-payments / bank-reconciliation | Reconciliation |
| 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 | Tax calculation | | add-tax-category / list-tax-categories | Tax categories | | add-tax-rule / list-tax-rules | Tax rules | | add-item-tax-template | Item-level tax overrides | | add-tax-withholding-category / get-withholding-details | Withholding | | record-withholding-entry / record-1099-payment / generate-1099-data | 1099 reporting |
| Action | Description | |--------|-------------| | trial-balance / profit-and-loss / balance-sheet / cash-flow | Core statements | | general-ledger / party-ledger | Ledger reports | | ar-aging / ap-aging | Receivable/payable aging | | budget-vs-actual (alias: budget-variance) | Budget analysis | | tax-summary / payment-summary / gl-summary | Summaries | | comparative-pl / check-overdue | Analysis | | add-elimination-rule / list-elimination-rules / run-elimination / list-elimination-entries | Intercompany |
| Action | Description | |--------|-------------| | add-customer / update-customer / get-customer / list-customers | Customer CRUD | | add-quotation / update-quotation / get-quotation / list-quotations / submit-quotation | Quotations | | convert-quotation-to-so | Quotation → Sales Order | | add-sales-order / update-sales-order / get-sales-order / list-sales-orders / submit-sales-order / cancel-sales-order | Sales orders | | create-delivery-note / get-delivery-note / list-delivery-notes / submit-delivery-note / cancel-delivery-note | Delivery | | create-sales-invoice / update-sales-invoice / get-sales-invoice / list-sales-invoices / submit-sales-invoice / cancel-sales-invoice | Invoicing | | create-credit-note / update-invoice-outstanding | Credit notes | | add-sales-partner / list-sales-partners | Sales partners | | add-recurring-invoice-template / update-recurring-invoice-template / list-recurring-invoice-templates / generate-recurring-invoices | Recurring invoices | | import-customers | CSV import | | add-intercompany-account-map / list-intercompany-account-maps / create-intercompany-invoice / list-intercompany-invoices / cancel-intercompany-invoice | Intercompany |
| Action | Description | |--------|-------------| | add-supplier / update-supplier / get-supplier / list-suppliers | Supplier CRUD | | add-material-request / submit-material-request / list-material-requests | Material requests | | add-rfq / submit-rfq / list-rfqs | RFQs | | add-supplier-quotation / list-supplier-quotations / compare-supplier-quotations | Supplier quotes | | add-purchase-order / update-purchase-order / get-purchase-order / list-purchase-orders / submit-purchase-order / cancel-purchase-order | Purchase orders | | create-purchase-receipt / get-purchase-receipt / list-purchase-receipts / submit-purchase-receipt / cancel-purchase-receipt | Receipts | | create-purchase-invoice / update-purchase-invoice / get-purchase-invoice / list-purchase-invoices / submit-purchase-invoice / cancel-purchase-invoice | Purchase invoices | | create-debit-note / update-purchase-outstanding / add-landed-cost-voucher | Adjustments | | import-suppliers | CSV import |
| Action | Description | |--------|-------------| | add-item / update-item / get-item / list-items | Item master | | add-item-group / list-item-groups | Item groups | | add-warehouse / update-warehouse / list-warehouses | Warehouses | | add-stock-entry / get-stock-entry / list-stock-entries / submit-stock-entry / cancel-stock-entry | Stock entries | | create-stock-ledger-entries / reverse-stock-ledger-entries | Stock ledger | | get-stock-balance / stock-balance-report / stock-ledger-report | Stock reports | | add-batch / list-batches / add-serial-number / list-serial-numbers | Batch & serial tracking | | add-price-list / add-item-price / get-item-price / add-pricing-rule | Pricing | | add-stock-reconciliation / submit-stock-reconciliation | Reconciliation | | revalue-stock / list-stock-revaluations / get-stock-revaluation / cancel-stock-revaluation | Revaluation | | check-reorder / import-items | Utilities |
| Action | Description | |--------|-------------| | add-meter / update-meter / get-meter / list-meters | Meter CRUD | | add-meter-reading / list-meter-readings | Readings | | add-usage-event / add-usage-events-batch | Usage tracking | | add-rate-plan / update-rate-plan / get-rate-plan / list-rate-plans / rate-consumption | Rate plans | | create-billing-period / run-billing / generate-invoices | Billing cycles | | add-billing-adjustment / list-billing-periods / get-billing-period | Adjustments | | add-prepaid-credit / get-prepaid-balance | Prepaid credits |
| Action | Description | |--------|-------------| | add-revenue-contract / update-revenue-contract / get-revenue-contract / list-revenue-contracts | Revenue contract CRUD (ASC 606) | | add-performance-obligation / list-performance-obligations / satisfy-performance-obligation | Performance obligations | | add-variable-consideration / list-variable-considerations / modify-contract | Variable consideration & mods | | calculate-revenue-schedule / generate-revenue-entries | Revenue schedule & GL posting | | revenue-waterfall-report / revenue-recognition-summary | Revenue reports | | add-lease / update-lease / get-lease / list-leases / classify-lease | Lease CRUD & classification (ASC 842) | | calculate-rou-asset / calculate-lease-liability / generate-amortization-schedule / record-lease-payment | ROU asset, liability & amortization | | lease-maturity-report / lease-disclosure-report / lease-summary | Lease reports | | add-ic-transaction / update-ic-transaction / get-ic-transaction / list-ic-transactions | Intercompany CRUD | | approve-ic-transaction / post-ic-transaction | IC workflow | | add-transfer-price-rule / list-transfer-price-rules | Transfer pricing | | ic-reconciliation-report / ic-elimination-report | IC reports | | add-consolidation-group / list-consolidation-groups / add-group-entity | Consolidation groups | | run-consolidation / generate-elimination-entries / add-currency-translation | Consolidation process | | consolidation-trial-balance-report / consolidation-summary | Consolidation reports | | standards-compliance-dashboard | ASC 606/842 compliance overview |
| Action | Description | |--------|-------------| | add-employee / update-employee / get-employee / list-employees | Employee CRUD | | add-department / list-departments / add-designation / list-designations | Org structure | | add-leave-type / list-leave-types / add-leave-allocation / get-leave-balance | Leave config | | add-leave-application / approve-leave / reject-leave / list-leave-applications | Leave workflow | | mark-attendance / bulk-mark-attendance / list-attendance / add-holiday-list | Attendance & holidays | | add-expense-claim / submit-expense-claim / approve-expense-claim / reject-expense-claim / list-expense-claims | Expense claims | | record-lifecycle-event / hr-status / update-expense-claim-status | HR lifecycle & status | | add-salary-component / list-salary-components / add-salary-structure / get-salary-structure / list-salary-structures | Salary setup | | add-salary-assignment / list-salary-assignments / add-income-tax-slab / update-fica-config / update-futa-suta-config | Payroll config | | create-payroll-run / generate-salary-slips / submit-payroll-run / cancel-payroll-run / get-salary-slip / list-salary-slips | Payroll processing | | generate-w2-data / add-garnishment / update-garnishment / get-garnishment / list-garnishments / payroll-status | W-2, garnishments & status |
| Action | Description | |--------|-------------| | install-module | Install a module from GitHub (--module-name <name>) | | remove-module | Remove an installed module (--module-name <name>) | | update-modules | Update all or a specific module | | list-modules | List all installed modules | | available-modules | Browse module catalog (--category, --search) | | module-status | Detailed status for a module (--module-name <name>) | | search-modules | Search catalog by keyword (--search <query>) | | rebuild-action-cache | Rebuild action routing cache | | list-profiles | Browse business onboarding profiles | | onboard | Auto-install modules for a business type (--profile <name>) |
| User Says | Action | |-----------|--------| | "Set up my company" | setup-company | | "Show trial balance" | trial-balance | | "Create an invoice" | create-sales-invoice → submit-sales-invoice | | "Record a payment" | add-payment → submit-payment | | "Install CRM" | install-module --module-name erpclaw-growth | | "Set up for retail" | onboard --profile retail | | "Add employee" | add-employee | | "Run payroll" | create-payroll-run → generate-salary-slips → submit-payroll-run | | "Apply for leave" | add-leave-application | | "Generate W-2s" | generate-w2-data |
Confirm before: submit-*, cancel-*, approve-*, reject-*, run-elimination, run-consolidation, restore-database, close-fiscal-year, initialize-database --force, install-module, remove-module, onboard. All add-*, get-*, list-*, update-* actions run immediately.
scripts/db_query.py dispatches to 14 core domain scripts + installed modules~/.openclaw/erpclaw/modules/~/.openclaw/erpclaw/data.sqlite~/.openclaw/erpclaw/lib/erpclaw_lib/ (installed by initialize-database)scripts/db_query.py --action <action-name> [--key value ...]| Case | Status | Duration (ms) | Turns | Tokens | Tool calls | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Without | With | Δ | Without | With | Δ | Without | With | Δ | Without | With | Δ | ||
case-01 | fail→fail | 6,955 | 6,221 | -11% | 1 | 1 | 0% | 1,168 | 5,418 | +364% | 0 | 0 | — |
case-02 | fail→fail | 8,469 | 5,133 | -39% | 1 | 1 | 0% | 1,549 | 5,553 | +258% | 0 | 0 | — |
case-03 | fail→fail | 3,369 | 5,358 | +59% | 1 | 1 | 0% | 561 | 5,529 | +886% | 0 | 0 | — |
case-04 | fail→fail | 8,733 | 7,346 | -16% | 1 | 1 | 0% | 1,554 | 5,830 | +275% | 0 | 0 | — |
case-05 | fail→fail | 6,038 | 7,001 | +16% | 1 | 1 | 0% | 1,018 | 5,775 | +467% | 0 | 0 | — |
case-06 | fail→pass | 9,736 | 2,373 | -76% | 1 | 1 | 0% | 1,282 | 5,499 | +329% | 0 | 0 | — |
case-07 | pass→pass | 5,282 | 9,071 | +72% | 1 | 1 | 0% | 1,132 | 6,192 | +447% | 0 | 0 | — |
case-08 | fail→fail | 6,883 | 6,527 | -5% | 1 | 1 | 0% | 1,431 | 5,666 | +296% | 0 | 0 | — |
case-09 | fail→fail | 7,251 | 7,138 | -2% | 1 | 1 | 0% | 1,440 | 5,566 | +287% | 0 | 0 | — |
case-10 | fail→pass | 8,640 | 13,438 | +56% | 1 | 1 | 0% | 1,578 | 7,163 | +354% | 0 | 0 | — |
case-11 | fail→fail | 5,631 | 5,724 | +2% | 1 | 1 | 0% | 1,064 | 5,519 | +419% | 0 | 0 | — |
case-12 | fail→fail | 8,021 | 6,601 | -18% | 1 | 1 | 0% | 580 | 5,636 | +872% | 0 | 0 | — |
case-13 | fail→fail | 5,267 | 3,630 | -31% | 1 | 1 | 0% | 861 | 5,401 | +527% | 0 | 0 | — |
case-14 | fail→pass | 15,131 | 14,770 | -2% | 1 | 1 | 0% | 3,237 | 8,452 | +161% | 0 | 0 | — |
case-15 | fail→pass | 13,019 | 15,683 | +20% | 1 | 1 | 0% | 2,398 | 7,607 | +217% | 0 | 0 | — |
case-16 | pass→fail | 26,028 | 9,398 | -64% | 1 | 1 | 0% | 2,151 | 5,622 | +161% | 0 | 0 | — |
case-17 | fail→fail | 22,781 | 9,010 | -60% | 1 | 1 | 0% | 3,569 | 5,568 | +56% | 0 | 0 | — |
case-18 | fail→pass | 8,878 | 7,630 | -14% | 1 | 1 | 0% | 1,587 | 5,804 | +266% | 0 | 0 | — |
case-19 | fail→fail | 13,109 | 11,101 | -15% | 1 | 1 | 0% | 2,493 | 5,491 | +120% | 0 | 0 | — |
case-20 | pass→fail | 16,259 | 13,228 | -19% | 1 | 1 | 0% | 2,901 | 7,340 | +153% | 0 | 0 | — |
case-21 | pass→pass | 17,849 | 9,608 | -46% | 1 | 1 | 0% | 3,370 | 6,933 | +106% | 0 | 0 | — |
case-22 | pass→fail | 10,695 | 8,169 | -24% | 1 | 1 | 0% | 2,225 | 6,778 | +205% | 0 | 0 | — |
DecimalAI ran this skill against gemini-3.6-flash twice over the same eval suite — once with the skill loaded and once without — and compared the two runs case by case. 22 cases were attempted, and 10 counted toward the lift figure. The other 12 produced results that are not comparable between the two arms, so they are excluded from the headline rather than averaged into it. The headline lift of +9 percentage points is the difference between those two pass rates over the 10 comparable cases. 4 cases got worse with the skill loaded, and they are included in that figure.
Without the skill loaded, the model failed this case. With it loaded, the same prompt on the same model passed. This is one improved case from the latest verified run; every case, including any that regressed, is in the table above.
Other measured skills in the registry, with their headline benchmark lift.