This article explains how to export your Subscriptions into a detailed CSV file. You can use it for compliance, revenue analytics, retention monitoring and billing management.
Overview
The Subscriptions CSV Export feature lets you download subscription records from the Payments → Subscriptions dashboard.
You can export:
Every subscription in your account, or
Only the subscriptions that match your filters/search query
The export is sent to you by email as a secure download link. The link expires after 7 days. If the link expires, just start another export.
How to export subscriptions
Go to Payments → Subscriptions.
(Optional) Apply a search or filters:
Status (Active, Canceled, Past Due, etc.)
Product type
Customer details
Provider, currency or date range
Click Download.
Open the link sent to your email. The CSV downloads straight away.
Understanding the data format
Subscriptions often include more than one:
Product (line item)
Tax
Because of this, one subscription may create multiple rows in the file: one row per line item and tax entry (where applicable).
This is needed for accurate product-level and tax-level reporting.
Tip: When summarising totals in Sheets or Excel, group values by Subscription id to avoid double counting.
Data consistency
Subscription exports are formatted for stable billing analytics and audit-ready reporting.
0 vs blank values
0 appears only when the field applies and the value really is zero.
Blank appears only when the field does not apply (for example, trial fields when there is no trial).
Stable structure for reporting
Column order is consistent, so it works well with pivots, imports and BI pipelines.
Multiple rows per subscription is intentional, for product-level and tax-level accuracy. Group by Subscription id to avoid double counting.
Column reference guide (with examples)
Column name | Description | Example |
Subscription id | Internal system ID of the subscription | jfhbiabfoanfle13kj |
Location id | Your account's identifier | NyGCsdhgRZ8Ffa8Ssagfhd |
Customer id | System identifier for the customer | jbtyjkzMjvd8cLi9HUC |
Customer name | Customer display name | Maria Russell |
Customer email | Email stored for the subscriber | |
Customer phone | Phone stored for the subscriber | +1 480-555-7002 |
Subscription start | Date the subscription was created | Jan 05, 2026 |
Subscription end | End date if cancelled or expired. Blank if the subscription has not ended | May 30, 2026 |
Number of trial days | Length of the trial applied. Blank if no trial | 14 |
Trial start | First day of the trial. Blank if no trial | Jan 05, 2026 |
Trial end | Date the trial finishes. Blank if no trial | Jan 19, 2026 |
Cancelled at | When the subscription was cancelled. Blank if not cancelled | Mar 15, 2026 |
Payment method | Method used for the latest successful charge | Visa •1234 |
Currency | Subscription currency | USD |
Sub total | Total before discount and exclusive tax (does not include setup fees) | 200.00 |
Discount | Discount applied (coupon etc.) | -20.00 |
Total tax amount (excluded in prices) | Taxes added on top (does not include anything on setup fees) | 14.40 |
Total tax amount (included in prices) | Taxes built into the price (does not include anything on setup fees) | 0.00 |
Total amount | Final charge (after discount and taxes; does not include processing charges) | 194.40 |
Coupon code | Coupon applied (if any) | WELCOME10 |
Status | Subscription lifecycle state | Active, Past Due, Cancelled |
Live mode | Whether the subscription is test or live | Yes, No |
Source type | Where the checkout came from, such as Funnel, Payment Link or Store | Funnel |
Source sub type | More specific source classification | One-Step Checkout |
Source id | Internal identifier of the checkout | fnl_0188 |
Source name | Display title of the source | Health Coaching Funnel |
Payment provider | Stripe, NMI, Authorize.net, PayPal, Square | Stripe |
Connected account | Provider account used for billing | acct_5520XX |
Transaction date | Date of the last successful renewal transaction | Mar 05, 2026 |
Transaction time | Time of the last charge | 2:10 PM |
Timezone | System timezone | America/New_York |
Total products | Number of products tied to the subscription | 1 |
Line item name | Product title | Monthly Yoga Plan |
Line item quantity | Product quantity | 1 |
Line item price | Price per product unit | 200.00 |
Line item discount | Discount applied to the product | 20.00 |
Line item subtotal | Product subtotal (before tax and fees) | 180.00 |
Line item product id | Product reference ID | prod_X7E12 |
Tax name | Tax label for the line | NY Sales Tax |
Tax amount | Tax portion allocated to this line | 14.40 |
Last paused on date | When the subscription was most recently paused | April 01, 2026 |
Resumed on date | The actual date the subscription resumed from a paused state | April 10, 2026 |
Pause end date | The date a paused subscription is expected to end its pause (most recent pause) | April 10, 2026 |
Processing charge name | Name of additional fees/charges | Platform Fee |
Processing charge amount | Value of the charge | 2.50 |
Example of multi-row subscription data
Example 1
A single subscription with:
3 products
2 taxes, both exclusive
The CSV could create a total of 6 rows:
2 rows for each product
6 rows for taxes, where the tax amount for each tax name on each product is a new row
All rows share the same Subscription id.
Example 2
A single subscription with:
3 products
2 taxes: both exclusive on product 1, both inclusive on product 2, and no tax on product 3
The CSV could create a total of 5 rows:
2 rows for each of the first 2 products, and 1 row for the 3rd product
4 rows for taxes. The first 2 taxes appear as <Tax Name 1> and <Tax Name 2>, and the next 2 appear as <Tax Name 1 (Included in prices)> and <Tax Name 2 (Included in prices)>. The 5th row has no values in the tax columns.
All rows share the same Subscription id.
Frequently Asked Questions
1. Why do I see multiple rows per subscription?
Each product and/or tax is broken out on its own row for accurate reporting.
2. Will cancelled subscriptions be included in exports?
Yes, unless you filter by Status before exporting.
3. Does my export show the latest values after a subscription is updated?
Yes. The export always shows the latest data on the subscription, not the data it started with. For example, if products or quantities change, the export shows the latest values.
4. Can I export subscription billing history?
For complete billing history, use the Transactions Export.
5. Who can download subscription exports?
Only users with permission to:
View Subscriptions
Export Subscriptions
6. Is the customer's address included?
Only if it was collected at checkout. Otherwise those columns stay blank.
7. Why is Subscription end blank?
It means the subscription has not ended yet. For example, it is still active, unpaid, trialing or scheduled.
