Use Odoo Export Feature

If you have already created a Bank Account record linked to your Vendor:

And you have a Payment like this:

That you include in a Payment Batch like this:

You would then switch to the List View of Batch Payments, select the payment (or payments) you want to export:

Then add the following fields to the Export Wizard:

Note: you need to expand the fields and "drill down" to get to the information you want, and choose either XLSX or CSV on the Wizard.

This gives you the following file:

If you want additional information, go back to a single Vendor Payment and review any other information you would want and find those fields also:

• Payments/Date
• Payments/Reference (for Memo)