Why members are not showing on Direct Debit Export Preview
This usually happens when the club recently done Bulk Renewals.
This happens to clubs who got their invoicing settings set to DRAFT in XERO

Solution:
Approve the invoices in Xero first then try the direct debit export again.