I was reading another thread earlier where a seller was having difficulty giving his/her accountant Sales data.
Many suggested using Data transfer programs offered at £30-£40 a month.
Here is a neat solution any seller who is excel savvy to use that does all that is required and avoid any monthly fees.

• Create new Workbook in Excel
• Name and save Workbook e.g., “Amazon Sales October 2022”
• Then go to your Amazon dashboard
• Select Reports> Payments > All Statements and download the required “Flat File V2”
• Select and download each Settlement report in turn for all the disbursements taken in month
• Open each download report in turn and copy and; paste all the “titles and data fields” to a new worksheet on your Workbook, One new sheet for each disbursement
• Converted data to a “Table” by selecting any single data field and press Ctrl “T”. Data will change colour to confirm success.
• Rename each Sheet Tab with Start-End Date for current report.
• When all reports for month are added. One sheet for each disbursement made in the month
• Save “Workbook. This protects the data for reuse. Should you mess up below.
• You can now create a PivotTable to compile the data
• Open “First” Worksheet in the Workbook
• Click on the top row the Data tab then select in turn on menu bar GetData > From Other Sources > Blank Query.
• The Power Query Editor Opens
• Type into Query Bar = Excel.CurrentWorkbook () then press Enter
• A data table appears
• Then under Properties rename “Query 1” with a Month-Year-Value say “Oct 22”
• On Content column heading click on the small selection box, then Untick “Use original column name as prefix” then Press “OK”
• Refreshes and then Consolidated Table Data appears.
• Select from menu bar Close & Load > Close & Load To
• A Pop-up box appears
• Tick the Radio Buttons > PivotTable Report, New Worksheet. Press OK
• Data Compiles
• A Query Table appears
• Important tick items in following order
• Deposit-Date
• Total-Amount
• Amount
• Amount Description

Then hey presto! You have all the sales and expense data for entire period in one Workbook fully MTD compliant. Save and send the Excel file to your accountant.