skills.rest
mvanhorn
mvanhornCOMMUNITY
Explore all skills by this author →
𝕏@mvanhornGitHub

pp-stripe

Analyze and reconcile local Stripe account data with SQL queries.

1.9k|565|Updated Mar 28, 2026
Search Tags:#analytics#reconciliation#stripe#customer-health#invoice#payout
One-click install
npx skills add https://github.com/mvanhorn/printing-press-library --skill pp-stripe
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pp-stripe
Source: https://github.com/mvanhorn/printing-press-library/tree/main/cli-skills/pp-stripe
Command: npx skills add https://github.com/mvanhorn/printing-press-library --skill pp-stripe

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires stripe-pp-cli, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides comprehensive tools for analyzing Stripe data, performing local reconciliation, and generating insights for payment operations.

Core Features & Use Cases

  • Local Customer Health Scoring: Calculate a customer health score based on payment failure, dispute, and subscription data to assist in proactive outreach.
  • Invoice Dunning Management: Generate a list of overdue invoices for targeted collections efforts.
  • SQL Data Queries: Run custom read-only SQL queries against the local Stripe mirror to support complex data analysis.
  • Payout Reconciliation: Cross-validate payouts with transactions and generate CSV reports for accounting.
  • Subscriptions at Risk: Identify subscriptions with expiring payment methods to prevent churn.
  • Metadata Search: Find resources associated with CRM or tagging metadata.
  • Customer 360 View: Aggregate customer data to support support and churn analysis.
  • Event Replay: Fetch and process new Stripe events incrementally to support automation.

Quick Start

Use the dunning-queue command to list overdue invoices with customer contact info.

Frequently Asked Questions about pp-stripe

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile Stripe payouts with transactions for accounting?▼

Stripe payout reconciliation cross-validates payouts with transactions and generates CSV reports for accounting. You can run custom read-only SQL queries against the local Stripe mirror to support detailed transaction matching.

How do I identify overdue Stripe invoices for collections?▼

Overdue Stripe invoice identification is handled by the dunning-queue command, which lists overdue invoices with customer contact info. This supports targeted collections efforts for payments operations.

Can I run custom SQL queries against my Stripe data locally?▼

Custom SQL queries can be run read-only against the local Stripe mirror database. This requires the stripe-pp-cli to be installed and synced locally, enabling complex data analysis and reporting.

How do I calculate customer health scores from Stripe payment data?▼

Customer health scoring calculates a score based on Stripe payment failure, dispute, and subscription data. This local analysis assists in proactive customer outreach and churn prevention.

Do I need stripe-pp-cli installed to analyze Stripe data locally?▼

Yes, stripe-pp-cli is a required dependency that must be installed and synced to a local database. The Skill relies on this local mirror to perform reconciliation, customer health monitoring, and custom SQL queries.

How do I find Stripe subscriptions with expiring payment methods?▼

Finding at-risk Stripe subscriptions identifies those with expiring payment methods to prevent churn. The Skill analyzes the local database mirror to flag these accounts for proactive payment method updates.

Related Skills

Explore More Finance & Accounting Skills→
offers-pngoffers-png

stripe

Implement Stripe payments and sync Stripe data to a local database.

Community
Advanced
steveclarkesteveclarke
35

invoice-organizer

Extract invoice data from PDFs and images into a CSV summary.

Community
Advanced
borgheiborghei
467

data-analyst

Query SQL databases, create visualizations, and generate insights reports.

Community
Intermediate
Gundlapuriswathiii006Gundlapuriswathiii006

stripe

Integrate Stripe payments with setup, data sync, and webhook handling.

Community
Advanced