CSV Exports

In order to include Components or Estimated Next Billing Amount in your exports, you must enable the options below:

Decide what extra data you'd like to include on your CSV exports of subscription data

Estimated Next Billing Amount

This is the anticipated next billing amount, based on the current plan and configuration (taxes, components, discounts,etc.) If there is an amount currently overdue, it is not included in this amount. Note: Including this field will cause your exports to take longer to generate. We strongly advise those that use this option to export a small subset of subscriptions. You can achieve this by applying filters on the subscription list prior to your export.

Last Amount Invoiced

This is the total amount billed on the most recent invoice that was not generated mid-period; as such, it will include renewals, product migrations, signups, and reactivations. It will also discount invoices that have been voided, and any invoices that are in a pending state. It’s available on both our statement architecture for both automatic and invoice billing subscriptions and newer Relationship Invoicing.

The amount is included in two columns. The first, “Last Amount Invoiced In Cents”, reflects the value in cents; the second, “Last Amount Invoiced,” represents the value as a decimal. Neither will have a currency marker, but a separate column in the export will indicate the currency of the subscriber.

Note: including this field can cause your exports to take longer to generate, especially on statement-based architecture, due to the calculation required per subscription.

Components

By including components on your subscription CSV export, we will add 2 fields per component at the end of your subscription export: one for the current component count, and one for the calculated component cost.

For example, if you have 4 components, there will be 8 columns added. Components that have been archived but are attached to active subscriptions will also be included.

Configure Subscription CSV Export for Unconfigured Component Values

Admins can control how unconfigured Components are represented in the Subscription CSV export. This setting helps distinguish between components explicitly set to 0 and those not configured at all, improving downstream reporting accuracy.

When Components is checked, two radio options appear:

• Values for unconfigured components are populated as zero (default)
• Values for unconfigured components are left blank

The selected radio option determines how unconfigured component columns are populated in the export:

Run the Subscription CSV export. The export will reflect your selected option for unconfigured components.

Best Practices

• Choose blank for unconfigured components if you need to distinguish between missing data and explicit zero values in downstream analytics.
• Verify your export after changing settings to ensure the output matches your reporting requirements.
• If using Product-based subscriptions, confirm that the setting applies as expected (Products instead of Components).