01-01-2021 03:04 PM
I need to download a comprehensive ledger of all 2020 sales and MP transactions for tax purposes. What is the easiest way to do this?
Solved! Go to Best Answer
01-01-2021 10:36 PM - edited 01-01-2021 10:37 PM
In eBay Seller Hub, click on the "Payments" in the line below "SELLER HUB". Then click on "Reports" in the left panel. Set the dates for the default "Transaction report" to start Jan 1, 2020 and end Dec 31, 2020. Start the download and wait for a few minutes until the report is ready to download. The report .csv file can be opened by Excel and saved as an .xlsx (Excel) file. Then it is possible to remove the extraneous lines above the headers and reformat numeric and dollar amounts before saving the report. Some Excel skills are required.
Alternatively, in the Payments page, choose "All transactions" at the top of the left panel. In the boxes to the right set the date range to "Custom" and set begin and end dates. The report will show transactions from as early as January 1, 2020 or the first day of Managed Payments for the account. The reports are readable, but no easy to save as a multi-page report appears to be available. Also, the report lacks details related to payment holds that can be found in detail records. Links to Payout Detail windows should be opened in a new tab to avoid using the back button on the browser. If the back button is used, the Transactions page reverts to the last 90 days instead of the full year - a bug or failure to restore the page when going back. Tax and locale information will not be available until sometime in January. Unless information is backfilled (as PayPal has done in the past), consistent sales tax information for the entire year will not be available until 2022. Ideally, it would be backfilled for 2020 and early 2021 before the end of January.
01-01-2021 10:36 PM - edited 01-01-2021 10:37 PM
In eBay Seller Hub, click on the "Payments" in the line below "SELLER HUB". Then click on "Reports" in the left panel. Set the dates for the default "Transaction report" to start Jan 1, 2020 and end Dec 31, 2020. Start the download and wait for a few minutes until the report is ready to download. The report .csv file can be opened by Excel and saved as an .xlsx (Excel) file. Then it is possible to remove the extraneous lines above the headers and reformat numeric and dollar amounts before saving the report. Some Excel skills are required.
Alternatively, in the Payments page, choose "All transactions" at the top of the left panel. In the boxes to the right set the date range to "Custom" and set begin and end dates. The report will show transactions from as early as January 1, 2020 or the first day of Managed Payments for the account. The reports are readable, but no easy to save as a multi-page report appears to be available. Also, the report lacks details related to payment holds that can be found in detail records. Links to Payout Detail windows should be opened in a new tab to avoid using the back button on the browser. If the back button is used, the Transactions page reverts to the last 90 days instead of the full year - a bug or failure to restore the page when going back. Tax and locale information will not be available until sometime in January. Unless information is backfilled (as PayPal has done in the past), consistent sales tax information for the entire year will not be available until 2022. Ideally, it would be backfilled for 2020 and early 2021 before the end of January.