home

Indirect Tax

Sovos Docs

Upload Shopify sales data

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

CAUTION:

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.

Formatting requirements:

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

  • Format all dates as MM/DD/YY (for example, 10/1/2020 10:34:33 AM).

  • Add a column to the file with the header "Marketplace code".

  • Add a column with the header "Exempt".

  • Sovos processes the following Shopify order export fields automatically. These are mandatory fields, so make sure that all of them are in the file you are uploading.

    Shopify FieldSovos Field
    TaxesTax Amount
    Shipping StreetShip To Street Name With Number
    Shipping ProvinceShip To State/Province
    Shipping ZipShip To Postal Code
    Shipping CountryShip To Country
    Shipping CityShip To City
    Line item quantityQuantity
    SubtotalGross Amount
    NameDocument Number
    Created atDocument Date
    Financial StatusDebit/Credit Indicator
    CurrencyCurrency
    Paid atAccounting Date
  1. Log in to Batch Determination.
  2. Click Upload.
  3. Select the Shopify template.
  4. Click Browse to select your .csv file from your computer or drag the file into the box.
  5. When your file is uploaded, click Next.
    A success screen will display.
  6. If the data in the uploaded file is final and will not change, click Save, then click Save for Filing on the popup to submit it for filing.

Your transaction data will be available in Sales Tax Filing within 24 hours. You can track the status of your returns by logging in.