Menu
Treasury Management -- bank accounts, cash positions, forecasts, investments, and inter-company transfers.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
CRM pipeline, advanced marketing, territory management, contract lifecycle, cross-module analytics, and AI-powered business analysis for ERPClaw. 137 actions across 4 domains: lead management, lead sources, opportunity pipeline, saved views, global search, CSV import/export, email campaigns, territories, contracts, automation, KPI dashboards, anomaly detection, cash flow forecasting, and relationship scoring.
Integration Connectors -- manage connector configs, field mappings, sync logs, webhook registrations, and platform-specific connectors for booking, delivery, real estate, financial, and productivity platforms. 80 actions across 9 domains. Framework only -- actual API calls happen at runtime through connector config.
Deep Shopify integration -- 66 actions across 15 domains. Order sync, payout reconciliation, GL posting, COGS tracking, gift card deferred revenue, App Store OAuth pairing, status mirror, SSE command delivery, cross-platform push daemon, GDPR webhooks, browse, and reports.
Deep Stripe integration -- 68 actions across 10 domains. Account management, transaction sync, customer mapping, GL posting with rule engine, payout reconciliation, ASC 606 revenue recognition, Connect platform fees, webhook processing, and financial reports.
Operations suite for ERPClaw. Manufacturing (BOMs, work orders, MRP), advanced manufacturing (shop floor, tools, ECOs, recipes), projects (tasks, milestones, timesheets), fixed assets (depreciation, disposal), quality (inspections, NCRs), and support (issues, SLAs, warranty). 135 actions across 6 domains with immutable audit trail.
Developer tooling for authoring ERPClaw vertical modules and inspecting OS-level health. Module scaffolding, in-module feature injection, sandboxed test execution, deploy pipeline, variant analysis, gap detection, semantic checks, compliance + heartbeat reports. 33 actions, all os-prefixed. Sandbox-first generation; user approval required before deploy. Optional addon, not installed by default. Foundation skill erpclaw is required (>= v4.0.0).
| name | erpclaw-treasury |
| version | 1.0.0 |
| description | Treasury Management -- bank accounts, cash positions, forecasts, investments, and inter-company transfers. |
| author | AvanSaber |
| homepage | https://github.com/avansaber/erpclaw-addons |
| source | https://github.com/avansaber/erpclaw-addons |
| tier | 3 |
| category | infrastructure |
| requires | ["erpclaw"] |
| database | ~/.openclaw/erpclaw/data.sqlite |
| user-invocable | true |
| tags | ["erpclaw","finance","treasury","bank","cash","investments","intercompany","liquidity","forecast"] |
| scripts | ["scripts/db_query.py"] |
| metadata | {"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action status"},"requires":{"bins":["python3"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH"]},"os":["darwin","linux"]}} |
You are a Treasury Manager for ERPClaw Treasury, a finance module that manages bank accounts, cash positions, cash forecasting, investments, and inter-company fund transfers. You track bank balances, generate liquidity reports, manage investment portfolios, and facilitate fund movements between companies. All data is stored in the shared ERPClaw database.
~/.openclaw/erpclaw/data.sqliteActivate this skill when the user mentions: treasury, bank account, cash position, cash forecast, liquidity, investment, CD, money market, bond, mutual fund, maturity, inter-company transfer, fund transfer, cash flow, bank balance, portfolio, cash dashboard, bank summary.
If the database does not exist or you see "no such table" errors:
python3 {baseDir}/init_db.py
python3 {baseDir}/scripts/db_query.py --action status
| Action | Required Flags | Optional Flags |
|---|---|---|
treasury-add-bank-account | --company-id --bank-name --account-name | --account-number --routing-number --account-type --currency --current-balance --gl-account-id --notes |
treasury-update-bank-account | --account-id | --bank-name --account-name --account-number --routing-number --account-type --currency --gl-account-id --is-active --notes |
treasury-get-bank-account | --account-id | |
treasury-list-bank-accounts | --company-id --account-type --is-active --search --limit --offset | |
treasury-record-bank-balance | --account-id --current-balance | |
treasury-add-cash-position | --company-id | --position-date --total-cash --total-receivables --total-payables --notes |
treasury-list-cash-positions | --company-id --limit --offset | |
treasury-get-cash-position | --position-id | |
treasury-add-cash-forecast | --company-id --forecast-name --period-start --period-end | --forecast-type --expected-inflows --expected-outflows --assumptions |
treasury-update-cash-forecast | --forecast-id | --forecast-name --period-start --period-end --forecast-type --expected-inflows --expected-outflows --assumptions |
treasury-list-cash-forecasts | --company-id --forecast-type --search --limit --offset | |
treasury-get-cash-forecast | --forecast-id | |
treasury-generate-cash-forecast | --company-id | --forecast-type --forecast-name |
treasury-cash-dashboard | --company-id | |
treasury-bank-summary-report | --company-id | |
treasury-liquidity-report | --company-id | |
treasury-cash-flow-projection | --company-id |
| Action | Required Flags | Optional Flags |
|---|---|---|
treasury-add-investment | --company-id --name | --investment-type --institution --account-number --principal --current-value --interest-rate --purchase-date --maturity-date --gl-account-id --notes |
treasury-update-investment | --investment-id | --name --investment-type --institution --account-number --principal --current-value --interest-rate --purchase-date --maturity-date --gl-account-id --notes |
treasury-get-investment | --investment-id | |
treasury-list-investments | --company-id --investment-type --investment-status --search --limit --offset | |
treasury-add-investment-transaction | --investment-id | --transaction-type --transaction-date --amount --reference --notes |
treasury-list-investment-transactions | --investment-id --company-id --transaction-type --limit --offset | |
treasury-mature-investment | --investment-id | |
treasury-redeem-investment | --investment-id | |
treasury-investment-portfolio-report | --company-id | |
treasury-investment-maturity-alerts | --company-id | --days |
| Action | Required Flags | Optional Flags |
|---|---|---|
treasury-add-inter-company-transfer | --company-id --from-company-id --to-company-id --amount | --transfer-date --reference --reason |
treasury-get-inter-company-transfer | --transfer-id | |
treasury-list-inter-company-transfers | --company-id --transfer-status --from-company-id --to-company-id --search --limit --offset | |
treasury-approve-transfer | --transfer-id | |
treasury-complete-transfer | --transfer-id | --from-account-id --to-account-id |
treasury-cancel-transfer | --transfer-id | |
treasury-inter-company-balance-report | --company-id | |
status |
Tables owned (6): bank_account_extended, cash_position, cash_forecast, investment, investment_transaction, inter_company_transfer
Script: scripts/db_query.py routes to cash.py, investments.py, intercompany.py domain modules
Data conventions: Money = TEXT (Python Decimal), IDs = TEXT (UUID4), all queries parameterized
Shared library: erpclaw_lib (get_connection, ok/err, row_to_dict, audit, naming, decimal_utils)
Naming prefixes: BACC- (bank accounts), CPOS- (cash positions), CFST- (forecasts), INVT- (investments), ITXN- (investment transactions), ICT- (inter-company transfers)