Kryptronic Software Support Forum

polarize · 02-14-2020 10:48:35

Hello,

Our state just recently started requiring marketplaces such as Amazon and eBay to start collecting and remitting sales tax from sales to our state and this amount is shown on the invoice but is not being included in our disbursements from Amazon or Paypal. What we are trying to figure out is how to separate the marketplace orders with sales tax collected but not sent to us from our regular in state orders where we are receiving sales tax revenue. The amount shown for us to remit to the state is fully inclusive of all sales including marketplaces so we would essentially be paying the sales tax twice unless we can find a way to separate these sales.

Is there a remedy for this or a workaround we can try to separate these transactions?

webmaster · 02-17-2020 09:18:17

Are you looking for an SQL statement to issue against the database to get taxes payable for a particular timeframe excluding channels? How are you looking to separate the sales?

polarize · 02-17-2020 10:24:34

We are hoping to have it separate sales tax that Amazon is collecting but not remitting to us so we don't wind up paying the sales tax twice. We have other sales tax outside of marketplaces that we do need to pay. If we can use an SQL statement to separate that out should be a good workaround. Thanks

webmaster · 02-18-2020 08:37:52

This would get you taxes paid for Amazon channel orders in Jan 2020. Change the year and month to adjust the timeframe:

Code:

SELECT CONCAT(dateyear,'-',datemonth) AS month, SUM(taxsptotal) AS itemtaxtotal, SUM(taxspshiptotal) AS shiptaxtotal FROM ecom_orders WHERE datemonth='01' AND dateyear='2020' AND statusenabled=1 AND channelid='AMAZON'

polarize · 02-22-2020 01:02:36

Thank you for this Nick!

I modified it some to include our state so we can separate out what Amazon has already collected for our state with the following and it seems to work great......

Code:

SELECT CONCAT(dateyear,'-',datemonth) AS month, SUM(taxsptotal) AS itemtaxtotal, SUM(taxspshiptotal) AS shiptaxtotal FROM ecom_orders WHERE datemonth='01' AND dateyear='2020' AND statusenabled=1 AND stateprov='State' AND channelid='AMAZON'

I'm not sure if its going to work with eBay yet since it appears that only month 12 and year 2019 actually produces amounts but not any other month before or since however

webmaster · 02-24-2020 09:07:13

For eBay you need to set channelid='EBAY' and it will pull those orders. Adjust datemonth and dateyear to adjust the timeframe.

Kryptronic Software Support Forum

#1 02-14-2020 10:48:35

Marketplace Facilitator Tax Accounting in QuickBooks from K9

#2 02-17-2020 09:18:17

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

#3 02-17-2020 10:24:34

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

#4 02-18-2020 08:37:52

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

Code:

#5 02-22-2020 01:02:36

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

Code:

#6 02-24-2020 09:07:13

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

Board footer