Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search
SStKelley

Squarespace sales tax issues

Recommended Posts

  So we all know that squarespace lacks the ability to correctly charge sales tax. (IE local option sales tax). But, their integration with stripe is also an issue. I wanted to talk to someone on the phone, but we all know that isn't possible either.

   I use Quickbooks to run my business. I get the sales amount from stripe imported using a app in quickbooks that imports the data from stripe, square, and paypal.  Well stripe doesn't break out the sales tax they collect only the amount they collect, their fee, customer name etc etc. My quickbooks is constantly in need of attention because I have to send in my tax liability report to the state of Iowa every quarter. (Saying what jurisdictions get what amount from my sales tax pool) So first of all my tax collected is wrong because squarespace has no realistic way to enter tax obligation other than hand entering 5000+ 9 digit zip codes and maintaining them every month encase of changes. And their chosen partner (Stripe) doesn't pass thru the amount of tax paid. Every month I have to go thru and find / fix hundreds of orders in quickbooks to make sure my taxes are paid correctly. If I'm incorrect in this someone please point out what im doing wrong. To me the only solution is to switch to someone other than Stripe/Squarespace, because honestly it doesn't seem like either really cares that business owners are possibly getting into tax issues with their state.

Edited by SStKelley

Share this post


Link to post

Greetings SStKelly,

I author the CartSpan eCommerce integration for QuickBooks accounting...which supports Squarespace.  I haven't encountered any issues with the Squarespace API exposing tax collected during the import process.  Out of the box, most eCommerce platforms don't calculate tax down to the address level...it's simply outside of their core-competence.  You would need an add-on like TaxJar to achieve this level of granularity in the tax calculation process.  TaxJar is advertised in the Extensions area of this site if you have the complex requirement of collecting/reporting by multiple jurisdictions.  Services like TaxJar will prepare your state returns and remit payment on your behalf...for a small fee of course.  My product then simply imports tax into QuickBooks as a common line-item to give you an idea of your ongoing tax liability. 

Hope this helps,
Scott

Share this post


Link to post
On 1/2/2020 at 6:30 PM, CartSpan said:

Greetings SStKelly,

I author the CartSpan eCommerce integration for QuickBooks accounting...which supports Squarespace.  I haven't encountered any issues with the Squarespace API exposing tax collected during the import process.  Out of the box, most eCommerce platforms don't calculate tax down to the address level...it's simply outside of their core-competence.  You would need an add-on like TaxJar to achieve this level of granularity in the tax calculation process.  TaxJar is advertised in the Extensions area of this site if you have the complex requirement of collecting/reporting by multiple jurisdictions.  Services like TaxJar will prepare your state returns and remit payment on your behalf...for a small fee of course.  My product then simply imports tax into QuickBooks as a common line-item to give you an idea of your ongoing tax liability. 

Hope this helps,
Scott

I have a very similar issue and bookkeeping is a nightmare. I don't need Stripe to calculate sales tax, I only need it to import the information from Squarespace so that I can easily import everything to Quickbooks.
For example, if I make a $6.00 sale, Squarespace collects an extra 0.42 cents for sales tax. Stripe processes the $6.42 transaction and deducts a 0.31 cent fee, giving me a payout of $6.11. When Quickbooks sees that payout hit my bank, I have no way to separate out what was sales, what was tax, and what was a fee.
It's so frustrating because our in-person POS with Square does everything 100% automatically!
Any advice?

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment


×
×
  • Create New...