I would want to generate a excel report like below from the Payment File Trace Information LU

This is the template that the bank gave us.

Row 1&2 are headers, row 3&4, 5&6, 7&8 are the data from PAY_TRACE_ITEM_CASH_ACCOUNT

I will have to generate such a excel and store it in a network location and the bank application will pick it up from the location and process the file for payment.

What is the best way to get this done ?