Supplier Payment proposal - output file

Hi, 

I see your attempting to use an ACH payment method.  Payment methods are user defined meaning you can call it anything you want, and that the payment format is the important concept. The payment format drives the file structure or even if a file is created.    I assume the ACH payment method is connected to the ACH payment format.  ACH is a very sophisticated payment structure, with multiple record types from header to batch, to addenda to the trailing record types.   ACH / NACH is a very specific layout. 

If you need an excel type format you need to try a different payment format one closer to you needs. Even then, I don’t know of any format that generates an excel file.   Some payment formats (such as bacs) will create a relatively basic /simple data file. BACS can easily be converted to CSV type file very easily used by excel. 

You need to use a different payment format - if you really need a csv or similar file.  ACH is not one of the payments formats that would be friendly for excel. 

Best regards, 

Thomas