erpclaw-integrations-stripe

name	erpclaw-integrations-stripe
version	2.2.0
description	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.
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":"[Truncated]","env":"[Truncated]","optionalEnv":"[Truncated]"},"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 68 Actions

Account Management (6 actions)