Skip to main content

Export or download subscriptions as a CSV

Learn how to export your subscriptions to a CSV file, and what each column in the export means.

M
Written by Matt Phillips

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

  1. Go to Payments → Subscriptions.

  2. (Optional) Apply a search or filters:

    • Status (Active, Canceled, Past Due, etc.)

    • Product type

    • Customer details

    • Provider, currency or date range

  3. Click Download.

  4. 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.


Did this answer your question?