erpclaw-integrations-stripe

name	erpclaw-integrations-stripe
version	2.0.0
description	Deep Stripe integration -- 67 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.
author	avansaber
homepage	https://github.com/avansaber/erpclaw-addons
source	https://github.com/avansaber/erpclaw-addons
tier	4
category	integrations
requires	["erpclaw"]
database	~/.openclaw/erpclaw/data.sqlite
user-invocable	true
tags	["erpclaw","stripe","payments","gateway","charges","refunds","disputes","payouts","subscriptions","webhooks","connect","reconciliation","gl-posting","mrr","asc606","revenue-recognition"]
scripts	["scripts/db_query.py"]
metadata	{"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action stripe-status"},"requires":{"bins":["python3"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH","STRIPE_API_KEY"]},"os":["darwin","linux"]}}

ERPClaw Integrations -- Stripe

Deep Stripe integration that syncs every transaction into your ERP general ledger. Manages Stripe accounts, syncs charges/refunds/disputes/payouts/subscriptions, maps Stripe customers to ERP customers, posts GL entries with configurable rules, reconciles payouts, tracks Connect platform fees, processes webhooks, and generates financial reports (revenue, MRR, fees, disputes).

Companion code: the Stripe App Marketplace listing + Cloudflare Worker that bridges Stripe to this skill lives at apps/stripe/. This SKILL is the runtime that processes Stripe data on the user's machine; apps/stripe/ is the discovery/OAuth surface on Cloudflare.

Skill Activation Triggers

Activate when user mentions: Stripe, payment gateway, payment processor, charges, refunds, disputes, chargebacks, payouts, subscriptions, MRR, webhooks, Connect, platform fees, payment reconciliation, Stripe sync.

Setup

The ERPClaw Accounting app is published on the Stripe App Marketplace. Users must install it before connecting.

Step 1 — Install the app: When a user says "connect Stripe" or "set up Stripe", first ask: "Have you installed the ERPClaw Accounting app from the Stripe Marketplace?" If not, direct them to install it: https://marketplace.stripe.com/apps/erpclaw-accounting

Step 2 — Get the restricted key: After installing, the user retrieves their key from the Stripe Dashboard: Installed Apps > ERPClaw Accounting > View API Keys. The ERPClaw Accounting app uses restricted API keys (starting with rk_test_ or rk_live_), NOT standard secret keys. Do NOT ask for publishable keys (pk_) or standard secret keys (sk_). Only restricted keys (rk_) are accepted.

python3 {baseDir}/init_db.py
python3 {baseDir}/scripts/db_query.py --action stripe-add-account --company-id {id} --account-name "Main" --api-key "rk_test_..."
python3 {baseDir}/scripts/db_query.py --action stripe-test-connection --stripe-account-id {id}

Quick Start

--action stripe-add-account --company-id {id} --account-name "Main Stripe" --api-key "rk_test_..." --mode test
--action stripe-configure-gl-mapping --stripe-account-id {id} --clearing-account-id {id}
--action stripe-start-sync --stripe-account-id {id}
--action stripe-run-reconciliation --stripe-account-id {id}
--action stripe-revenue-report --stripe-account-id {id}

All 67 Actions

Account Management (6 actions)

Action	Description
stripe-add-account	Create Stripe account config (auto-creates GL accounts)
stripe-update-account	Update account name/key/mode
stripe-get-account	View account with masked key
stripe-list-accounts	List Stripe accounts
stripe-configure-gl-mapping	Update GL account mapping
stripe-test-connection	Verify API key works

Sync & Jobs (6 actions)

Action	Description
stripe-start-sync	Start incremental sync
stripe-start-full-sync	Start full historical sync
stripe-get-sync-status	Get sync job status
stripe-list-sync-jobs	List sync jobs
stripe-cancel-sync	Cancel running sync
stripe-status	Overall Stripe status

Transaction Browse (10 actions)

Action	Description
stripe-list-charges	List synced charges
stripe-get-charge	Get charge details
stripe-list-refunds	List refunds
stripe-list-disputes	List disputes
stripe-list-payouts	List payouts
stripe-get-payout	Get payout with transactions
stripe-list-invoices	List Stripe invoices
stripe-list-subscriptions	List subscriptions
stripe-list-webhook-events	List webhook events
stripe-health-check	Stripe health check

Customer Mapping (4 actions)

Action	Description
stripe-map-customer	Map Stripe customer to ERP
stripe-unmap-customer	Remove customer mapping
stripe-list-customer-maps	List customer mappings
stripe-auto-map-customers	Auto-map by email match

GL Posting (8 actions)

Action	Description
stripe-post-charge-gl	Post charge to GL
stripe-post-refund-gl	Post refund to GL
stripe-post-dispute-gl	Post dispute to GL
stripe-post-payout-gl	Post payout to GL
stripe-post-connect-fee-gl	Post Connect fee to GL
stripe-preview-gl-posting	Preview GL posting
stripe-bulk-post-gl	Bulk post unposted items
stripe-verify-gl-balance	Verify GL balance

GL Rules (4 actions)

Action	Description
stripe-add-gl-rule	Create custom GL posting rule
stripe-update-gl-rule	Update GL rule
stripe-delete-gl-rule	Delete GL rule
stripe-list-gl-rules	List GL rules

Reconciliation (7 actions)

Action	Description
stripe-run-reconciliation	Run payout reconciliation
stripe-get-reconciliation-run	Get reconciliation run
stripe-list-reconciliation-runs	List reconciliation runs
stripe-reconcile-payout	Reconcile specific payout
stripe-match-charge	Match charge to ERP invoice
stripe-unmatch-charge	Remove charge match
stripe-list-unreconciled	List unreconciled items

Webhooks (3 actions)

Action	Description
stripe-process-webhook	Process incoming webhook
stripe-replay-webhook	Replay webhook event
stripe-get-customer-detail	Get mapped customer detail

Connect Platform (4 actions)

Action	Description
stripe-list-connected-accounts	List connected accounts
stripe-list-application-fees	List application fees
stripe-list-transfers	List transfers
stripe-connect-fee-summary	Connect fee summary

Revenue Recognition / ASC 606 (5 actions)

Action	Description
stripe-create-rev-rec-schedule	Create ASC 606 revenue contract from Stripe subscription
stripe-recognize-subscription-revenue	Batch recognize deferred revenue for period
stripe-rev-rec-status	Revenue recognition status across subscriptions
stripe-handle-subscription-change	Handle subscription upgrade/downgrade/cancel
stripe-rev-rec-summary	Revenue recognition summary report

Reports (10 actions)

Action	Description
stripe-revenue-report	Revenue summary report
stripe-fee-report	Fee breakdown report
stripe-dispute-report	Dispute report
stripe-payout-detail-report	Payout detail report
stripe-reconciliation-report	Reconciliation report
stripe-reconciliation-summary	Reconciliation summary
stripe-customer-revenue-report	Revenue by customer
stripe-mrr-report	Monthly recurring revenue
stripe-connect-payout-report	Connect payout report
stripe-connect-revenue-report	Connect revenue report

Tables (17)

stripe_account, stripe_sync_job, stripe_balance_transaction, stripe_charge, stripe_refund, stripe_dispute, stripe_payout, stripe_invoice, stripe_subscription, stripe_customer_map, stripe_deep_webhook_event, stripe_credit_note, stripe_application_fee, stripe_transfer, stripe_gl_rule, stripe_fee_detail, stripe_reconciliation_run.