How to denote sales tax collected by a Marketplace Facilitator in a CSV import

If you are selling via a Marketplace Provider TaxJar supports and automatically recognize as marketplace exempt, we tell you how to upload these transactions as long as the name of the cart in the "provider" column of your CSV file matches: 'amazon', 'etsy', 'walmart' or 'ebay'. 

  • If you are working with a Marketplace Provider we don’t yet automatically recognize as marketplace exempt, you can still enter the provider and exemption_type of ‘marketplace’ to properly classify the transaction as exempt in your Reports.

    Please see below as an example (  Columns D-M are hidden to capture this screenshot and are required; please follow our formatting guidelines here.)
  • We show you how to upload other exemption reasons via CSV here.

If your CSV data includes Marketplace* sales to customers in states with Marketplace Facilitator laws, TaxJar's Reports (and TaxJar's AutoFile, if you're enrolled in this service) will assume that your Marketplace (Amazon, eBay, Etsy and Walmart) has remitted all collected taxes associated with such sales on your behalf. 

  • To our understanding, the states with Marketplace Facilitator laws still require sellers to file a return and deduct the sales totals that were Marketplace collected.
  • Each time we update state Reports to reflect Marketplace sales, those same changes also apply to Marketplace sales orders uploaded via CSV. 
  • As long as the name of the cart in the "provider" column of your CSV file matches: 'amazon', 'etsy', 'walmart' or 'ebay' in a state where one of these Marketplaces collects tax automatically on your behalf, those sales will be listed in the Marketplace Sales row of the Sales Tax Reports for the Marketplace Facilitator states here
  • Remember that the provider name must be lowercase in your file in order for our system to accept the import.
  • In addition, beginning August 15, 2018, if the name of the cart in the "provider" column of your CSV file matches: 'amazon', 'etsy', or 'walmart' in a state where one of these marketplaces collects tax automatically on your behalf, those sales uploaded via CSV will also be denoted with an "M" for Marketplace Sales in your Transactions page. (See image below.)
  • Beginning February 7, 2019, if the name of the cart in the "provider" column of your CSV file matches: 'ebay' in a state where this marketplace collects tax automatically on your behalf, those sales uploaded via CSV will also be denoted with an "M" for Marketplace Sales in your Transactions page

*Though your Marketplace is remitting the tax to the states, they will not file a return on your behalf as the states may require.