Exporting sales data from eBay
- Log into your eBay account.
- Go to eBay Managed payments on the eBay Seller Hub.
- Go to the Payments tab and select Reports.
- You can download reports for transactions over a specific period and/or filtered by status.
- Select the report parameters and click Create Report.
Preparing your file
- Add a column to the report file with the header tax. Sovos will use this column to combine any values in Sales Tax and eBay Collected Tax into a single record called tax, which will map with the Tax Amount field in Sovos.
- Add a column to the file with the header marketplace code.
- Add a column to the file with header exempt.
- Make sure that the date format for Order Date is MM/DD/YYYY.
- Make sure that your file is in CSV UTF-8 format.
- Sovos processes the following eBay report fields automatically. These are mandatory fields, so make sure that all of them are in the file you’re uploading.
eBay Field |
Sovos Field |
Sales Record Number |
Document Number |
User Id |
Customer/Vendor Code |
Quantity |
Quantity |
Sale Price |
Gross Amount |
Sales Tax |
Third-Party Name |
eBay Collected Tax |
Good/Service Code Description |
Sale Date |
Document Date |
Ship to Address 1 |
Ship to Street Name With Number |
Ship to City |
Ship to City |
Ship to State |
Ship to State/Province |
Ship to Zip |
Ship to Postal Code |
Ship to Country |
Ship to Country |
Uploading your sales data to Batch Determination
- Log in to Batch Determination.
- Click Add Transactions.
- Select eBay Template.
- Click Browse to select your CSV file or drag and drop it.
- Click Continue.
- You’ll see a success screen with details once your data has been uploaded.
Transaction data must be uploaded by the fourth business day of each month. If the data is not uploaded by then, Sovos can’t guarantee that the return will be filed on time in that filing period.
Always use Batch Determination to upload your tax data. Don’t try to add data from the Imports menu in Filing.
Submitting your data for filing
If the data in the uploaded file is final and won’t change, click Save to Database. Click Save for Filing on the popup message to submit it for filing.
The data will show up in Sovos Filing within 24 hours as return(s) waiting to be prepared. You can track the status of these returns in Sovos Filing. To learn more about how Sovos Filing works, read this article.