Free reporting template
Stripe Subscription and MRR Dashboard Google Sheets Template
See active, past due, and canceled Stripe subscriptions in one list, with MRR at the top and a link to each subscription in Stripe. Add one reporting tab to your SyncStaq Sheet to use your data.
Active
8
Past due
3
Canceled
3
MRR
1,017.00
| Status | Customer | Product | Amount | Interval | Started | Stripe |
|---|---|---|---|---|---|---|
| past_due | Cloud Ledger | Pro Plan | 59.00 | month | 2026-05-08 | Open in Stripe |
| past_due | Nimbus Tools | Team Plan | 149.00 | month | 2026-09-20 | Open in Stripe |
| active | Vector Finance | Enterprise Plan | 299.00 | month | 2026-06-12 | Open in Stripe |
| active | Atlas Ops | Team Plan | 149.00 | month | 2026-03-18 | Open in Stripe |
| active | Metric Labs | Pro Plan | 79.00 | month | 2026-02-10 | Open in Stripe |
| canceled | Beacon Works | Pro Plan | 59.00 | month | 2026-04-08 | Open in Stripe |
Reporting basis: MRR is list price times quantity for active and past due subscriptions, converted to a monthly amount. Coupons and discounts are not subtracted.
Use it with your SyncStaq Sheet
Copy the template
Open the workbook and choose Make a copy.
Add the reporting tab
Right-click Subscription Dashboard, then choose Copy to > Existing spreadsheet. Select your dedicated SyncStaq Sheet. The tab reads its Subscriptions_raw tab.
Filter by status
Choose a status in the yellow cell to list only those subscriptions. Past due subscriptions sort to the top, and Open in Stripe takes you to each one.
Stripe subscription statuses in the dashboard
The Status column uses Stripe's own subscription status values. This is what each one means and what to do about it.
| Status | What it means | What to do |
|---|---|---|
| trialing | The customer is in a free trial. The subscription becomes active when the first payment succeeds. | Nothing yet. Watch the trial end date. |
| active | The subscription is in good standing and the latest invoice is paid. | None. This is the list of your paying subscribers. |
| past_due | The latest renewal payment failed. Stripe keeps retrying on your retry schedule. | Contact the customer or ask them to update their card. |
| unpaid | Retries ran out and your settings keep the subscription open instead of canceling it. New invoices are created but not charged. | Collect payment or cancel the subscription. |
| incomplete | The first payment failed or needs customer action. The customer has about 23 hours to complete it. | Follow up quickly, before it expires. |
| incomplete_expired | The first payment was never completed in time. The subscription never started. | None. The customer has to subscribe again. |
| paused | A trial ended without a payment method on file and your settings pause instead of cancel. | Ask the customer to add a payment method. |
| canceled | The subscription has ended and cannot be reactivated. | Review the cancellation reason for churn patterns. |
Template questions
Does copying the template connect it to my Stripe data?
No. The template includes example data. Copy its Subscription Dashboard tab into your existing SyncStaq-created spreadsheet to use your synced subscription data.
How is MRR calculated in the dashboard?
MRR is the plan price multiplied by quantity for every active and past due subscription, with yearly, weekly, and daily plans converted to a monthly amount. It uses list prices, so coupons and discounts are not subtracted, and it assumes a single currency.
What is the difference between past_due and unpaid in Stripe?
A subscription is past_due when its latest renewal payment failed and Stripe is still retrying. It becomes unpaid when the retries are exhausted and your billing settings leave the subscription open instead of canceling it. Past due subscriptions are usually still recoverable, which is why the dashboard sorts them to the top.
How do I see all active subscriptions in Stripe?
In the Stripe Dashboard, open Billing, then Subscriptions, and filter by the Active status. That shows one status at a time. This dashboard counts each status and lists active, past due, and canceled subscriptions together in one view.
Can I use the template without SyncStaq?
Yes, if you maintain the data yourself. The dashboard reads from a tab named Subscriptions_raw and finds its columns by header name, so a manual Stripe CSV export works once its column headers are renamed to match the ones in the template. You will need to paste in a fresh export each time you want current numbers.
How many subscriptions can the template handle?
The template reads the first 1,000 rows of the Subscriptions_raw tab. A subscription with several items takes one row per item.
Related templates
Keep your Stripe data in Sheets
SyncStaq creates a dedicated Google Sheet and keeps your Stripe billing data updated for reporting and reconciliation.
Start 14-day free trial