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

Scope

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?

Summary

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/On. You can also download reports from Settings > Import & Export Data > Export Data > Subscriptions.

Solution

Subscription Index page

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

Filter list > Customer > Primary Payment method > is > present
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.