Stripe Reporting
Available Stripe Reports for Piano Clients
To learn about the Stripe reports, please refer to https://docs.stripe.com/stripe-reports.
Dashboard Financial Reports
Balance Summary Report
Piano Data Present: All Piano transactions converted to Stripe PaymentIntents and invoices
Metadata Included: Piano transaction IDs, application context, user identifiers
Use Case: Reconcile Stripe balance with Piano transaction history
Revenue by Customer Report
Piano Data Present: Piano users mapped to Stripe customers with Piano metadata
Customer Mapping: Piano User ID, application context
Use Case: Track revenue across Piano user base with Piano context preserved
Revenue by Product Report
Piano Data Present: Piano Resources mapped to Stripe Products
Product Metadata: Piano Resource IDs, titles
Use Case: Analyze revenue across Piano Resources/products with native Piano categorization
Billing-Specific Reports
Subscription Analytics Report
Piano Data Present: Piano subscriptions mapped to Stripe subscription schedules
Subscription Context: Piano Term information, subscription metadata, lifecycle data
Metrics Available: Customer lifetime value calculated on Piano subscription data
Note: Stripe's standard subscription trial support covers free trials. Paid trials are available only through Stripe's newer Trial Offers API, which Piano does not use and which is not supported in Checkout or Elements. Piano therefore maps both free and paid trials as phases of a subscription schedule, so trial counts are not populated in Stripe's Subscription Analytics report. This may change as Stripe's native paid trial support matures.
Subscription Churn Report
Piano Integration: Maps Stripe churn events back to Piano Subscription Insights
Data Flow: Stripe Revenue Recovery events → Piano churn reporting
Monthly Recurring Revenue (MRR) Report
Piano Data: Piano Terms converted to Stripe price_data with full pricing context
Revenue Attribution: MRR calculated from Piano pricing engine outputs
Segmentation: By Piano application, resource type, and term configurations
Invoice Status Report
Piano Context: Piano payment status mapping to Stripe invoice lifecycle
Status Synchronization: Sync between Piano payment states and Stripe invoice status
Revenue Recognition Reports
Income Statement
Availability: Requires Stripe Revenue Recognition, which is a separately priced Stripe product.
Piano Revenue: Piano subscription revenue recognized through Stripe billing cycles
Revenue Attribution: Maintains Piano application and resource-level revenue categorization
Period Recognition: Aligns with Piano subscription term periods and renewals via Subscription schedules and phases
Revenue Recovery Reporting
Clients using Stripe for Payments and Billing will also benefit from Revenue Recovery features and its associated reporting.
Churn Reporting in Piano Subscription Insights
Will continue to be available based off the webhook event handling and subsequent conversion event generation in Piano.
Stripe Billing Revenue Recovery events are mapped to Piano and will be available in the Subscription Insights and Piano Churn reporting.