Go to the Payments section of the Club Control Panel.
Click on Reporting.
Click on the Filters option.
Change records per page to All and click Filter.
Click the Export Payments as CSV button.
Top Tip: Use the filters option to filter by "Method", to see all payments by cash, cheque, GoCardless etc.