Filing

Upload eBay sales data

If you are not using Tax Determination or an API to share transaction data with Sales Tax Filing, you need to upload your transactions in a file.

Important:

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.

  • Make sure that the file is in CSV UTF-8 format.

  • Add a column to the file with the header tax. The amounts in Sales Tax and eBay Collected Tax are combined into this column, which is mapped to the Tax Amount Sovos field.

  • Add a column with the header Marketplace code.

  • Add a column with the header Exempt.

  • Make sure that the dates in the Order Date column are in MM/DD/YYYY format.

  • Make sure that the file contains the following required eBay fields, which are automatically mapped to Sovos fields:

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
  1. Log in to Batch Determination and select your organization from the dropdown.
  2. Click Upload.
  3. In Step 2, select eBay Template.
  4. In Step 3, click Browse to select the file from your computer or drag and drop the file into the upload area, then click Next.
    Your transaction data is uploaded to Batch Determination. When Batch Determination finishes processing your data, it displays a results screen with a summary of the uploaded transactions.
  5. Review the upload:
    • The transaction summary shows the total tax amount and exempt amount for each country and state/province. To view individual transaction amounts, click Download report.
    • If Batch Determination ran into errors while processing your file, download the error reports.
    Note:

    Though you can save an upload with errors for filing, we recommend that you correct the issues identified in the error report and then upload the corrected file.

  6. If the data in the upload is final and will not change, click Save, then click Save for Filing on the confirmation popup.

Your transaction data will be available in Sales Tax Filing within 24 hours.