How to export list of customers who has payment method with auto-collection 'OFF'?

Modified on: Thu, 11 May, 2023 at 12:06 PM


How to identify if a customer has a payment method present, however, the auto collection is off

I want a report of customers who has the payment method but the auto-collection is not enabled.

Can I filter invoices that are set to not auto close?


You can download this report using multiple filters by navigating to the Subscription Index page by using the filter Primary Payment method is present and filter Auto collection status is Off/OnYou can also download reports from Settings > Import & Export Data > Export Data > Subscriptions.


1. Subscription Index page

Navigate from the Subscription Index page and use the below filters.

1. Filter list > Customer > Primary Payment method > is > present

2. Add filter > Subscription > Auto Collection > is > Off

Then you can ‘Save filter’ for future reference. Refer to this link to know more about Advanced Filter Option.

Once done, you can click on ‘Export’ and click on ‘Export as CSV’ to download the report.

Note: On the recent UI enhancement you can now scroll the index pages - Customers, Subscriptions, Invoices, and Credit Notes vertically. Earlier, the pages will be paginated which may prolong your search however with the new enhancement as you scroll down the list it will load all other data in a single page. Refer to this link for more information. 

2. Downloading reports from Export Data:

Export transactions with error codes or error text

Navigate to  Settings > Import & Export Data > Export Data > Subscription > Select Criteria to export

1. Add condition > Customer > Primary Payment method > is > present

2. Add condition > Subscription > Auto Collection > is > Off/On

Once done, you can click Preview for the updated list and click Export to download the report in CSV format.

Related Articles

How to export customers data of all active subscribers? 

How to export the billing periods associated to the subscriptions? 

Is it possible to build a report to show all the customers and the total amount of usage (units)? 

How to export subscriptions specific to a recurring addon? 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.