Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

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

polarize
Member
Registered: 11-15-2004
Posts: 276

Marketplace Facilitator Tax Accounting in QuickBooks from K9

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?


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19525
Website

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

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?


Nick Hendler

Offline

 

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

polarize
Member
Registered: 11-15-2004
Posts: 276

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

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


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19525
Website

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

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'

Nick Hendler

Offline

 

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

polarize
Member
Registered: 11-15-2004
Posts: 276

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

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


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19525
Website

Re: Marketplace Facilitator Tax Accounting in QuickBooks from K9

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


Nick Hendler

Offline

 

Board footer