How to Generate Stripe Reports for Product Revenue (Step-by-Step)

One of the most common questions from Stripe users is: “How can I see what sales were in a specific period for a specific product?”It sounds simple, but Stripe’s built-in reporting makes this surprisingly difficult.

This guide walks through every method available — from Stripe’s native dashboard to API-based approaches to third-party tools — so you can generate Stripe reports for product revenue regardless of your technical skill level.

Why Product-Level Revenue Matters

If you sell multiple products or plans through Stripe, aggregate revenue numbers only tell part of the story. You need to know:

• Which product is driving the most revenue?
• Are sales of a specific product growing or declining?
• How much revenue did Product X generate last quarter?
• Which product has the highest refund rate?

Without product-level breakdowns, you’re making pricing, marketing, and product decisions in the dark.

Method 1: Stripe Dashboard Reports

Stripe’s native dashboard offers some basic reporting. Here’s how to get product revenue data:

1. Log into your Stripe Dashboard
2. Navigate to Reports → Revenue
3. Set your date range using the date picker
4. Download the report as a CSV

The limitation? Stripe’s downloadable reports show charges, not product breakdowns. You’ll get a list of every transaction with amounts, but you’ll need to manually cross-reference invoice line items with products in a spreadsheet. For businesses with hundreds or thousands of transactions, this quickly becomes unmanageable.

Method 2: Stripe’s Sigma (SQL Reporting)

Stripe Sigma lets you write SQL queries against your Stripe data. You could run something like:

SELECT product_name, SUM(amount) FROM invoices GROUP BY product_name

Sigma is powerful but has drawbacks:

• Cost — starts at $12/month on top of your Stripe fees
• Requires SQL knowledge — not accessible to non-technical users
• No visualization — returns raw tables, no charts or dashboards
• No projections — only shows historical data

Method 3: The Stripe API

For developers, the Stripe API provides full access to your data. To generate a product revenue report, you would:

1. Use stripe.invoices.list() with date filters to fetch paid invoices
2. Iterate through each invoice’s line items
3. Resolve the product name from each line item’s price.product field
4. Aggregate amounts by product

This works but requires building and maintaining custom code. You’ll also need to handle pagination (Stripe returns max 100 objects per request), rate limiting, and currency conversion.

Method 4: Use a Stripe Revenue Reporting Tool

The fastest way to get product-level Stripe revenue reports is to use a purpose-built tool. StripeReport includes a Sales by Product dashboard that lets you:

• Pick any date range — preset periods (last 7 days, 30 days, this month, last quarter, this year) or custom dates
• Filter by product — select a specific product from a dropdown to see only its sales
• See summary metrics — total sales count, gross revenue, refunds, and net revenue at a glance
• View a product breakdown chart — visual bar chart comparing net revenue across all products
• Drill into individual transactions — see every charge with customer name, email, date, amount, and refund status

Setup takes under 2 minutes: create an account, connect a read-only Stripe API key, and your reports populate instantly. No SQL, no code, no spreadsheets.

Comparing Your Options

Here’s how each method stacks up for generating Stripe reports for product revenue:

• Stripe Dashboard — Free, but no product-level breakdowns. Requires manual CSV work.
• Stripe Sigma — $12+/mo, requires SQL, no visualizations or projections.
• Stripe API — Free (no extra cost), but requires engineering time to build and maintain.
• StripeReport — $19.99/mo (3-day free trial), instant product revenue reports with charts, filters, and daily email summaries. No code required.

Tips for Better Product Revenue Tracking

1. Name your Stripe products clearly — product names in Stripe flow directly into reports. “Pro Plan Monthly” is more useful than “prod_abc123”.
2. Use separate products for different tiers — don’t use a single product with different prices if you want clean per-product reporting.
3. Review product revenue monthly — trends matter more than snapshots. A product growing 10% month-over-month is a very different story than one that’s flat.
4. Watch refund rates by product — a high refund rate on one product may indicate a quality or expectation-setting problem.
5. Compare periods — use your reporting tool to compare this month vs. last month, or this quarter vs. the same quarter last year.

Frequently Asked Questions

Can I see revenue by product in Stripe?

Not directly in Stripe’s standard dashboard. You can download transaction CSVs and manually cross-reference products, use Stripe Sigma for SQL queries, or connect a tool like StripeReport that provides instant product-level revenue breakdowns.

How do I see sales for a specific time period in Stripe?

In Stripe’s dashboard, go to Payments and set a date filter. For more detailed reporting with product breakdowns, use Stripe’s Report Downloads or a third-party analytics tool that connects to your Stripe account.

Does Stripe track revenue by product automatically?

Stripe records which product and price each charge is associated with (via invoices and line items), but it doesn’t aggregate this into a product revenue report. You need either Sigma, the API, or a third-party tool to see product-level totals.