You can export payment data by creating a data source export.
To export payment data:
Navigate to Reporting > Data Sources.
From the Data Source field, select Payment.
The Fields panel displays the fields provided by the Payment data source.
In the Fields panel, select one or more fields to retrieve.
Optional: In the Filters, Time Frame, and Format panels, specify the scope and format of the payment export.
By default, Zuora exports payments in CSV format.
For more information, see Generate a Data Source Export.