1. Run a list report (FBL1N/FBL5N/ME2M).
2. Change layout: add 3 columns, remove 3, reorder.
3. Sort by amount descending; filter one company code; subtotal by vendor/customer.
4. Save layout as /MY_LAYOUT (the / makes it available to others if allowed).
5. Export: List > Export > Spreadsheet (or the Excel icon) > choose 'Excel (Office 2007 XLSX)'. Check amounts are numbers in Excel.