Login to the ClubZap Admin Portal
Go to Membership -> Membership Sales
Click on Export
Select the payment details you would like to export
Refine your export based on payment date or payment status where you can select only failed payments for example.