Jump to content

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
Link to comment
  • 2 months later...
Guest CartSpan

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

Link to comment
  • 6 months later...
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?

Link to comment
  • 7 months later...
  • 7 months later...

Same problem, and I don't believe there is a fix in sight. Last year I attempted to get to the bottom of this, I spent 6 hours on the phone bouncing from company to company until I was actually talking to DBA's on either side of the equation on SS and Stripe, and they said that the other weren't formatting their metadata and their columns properly to coincide with they way the other was passing data, and no side was going to repair it.  If this is actually the problem, which I can in no way verify, I'm finding this really hard to believe that these companies can't find a solution to get this right and make this effortless. The answer to me was, "buy some middleware and pay them monthly or enter it all in manually". Neither of these is the solution I'm paying for--on ALL platforms.

If that's the answer, Squarespace / Stripe / QuickBooks Online should be listed as incompatible, instead of them bragging that they work so well together. I'm currently looking into different platforms that don't require Stripe.

Link to comment
  • 6 months later...

I have the same problem with PayPal.

For example, SquareSpace adds $11.48 in tax to a $164 sale with $7.50 in shipping. But when the transaction is submitted to PayPal, I see only a single number $182.98 with no way of differentiating between product, shipping, and tax. I then have to manually break out tax on every transaction after it is imported into QuickBooks. 😭

Would love to hear if anyone has found a solution that doesn't involve adding third party services.

image.png

Link to comment
15 hours ago, Libertie said:

I have the same problem with PayPal.

I have replied to your post here:

 

Improve your online store with our extensions.
About: Squarespace Circle Leader since 2017. I value honesty, transparency, appreciation and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™.
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Buy me a coffee

Link to comment
  • 9 months later...

I have the same problem.  SquareSpace sends the transactions to Stripe, and in SquareSpace I can see the amount for the merchandise, shipping fees, and sales tax. But in Stripe, only the gross amount collected from the customer, and the fee the Stripe charged on that transaction. I use Synder to bring the transactions in from Stripe to QuickBooks Online, but Synder cannot bring in the detail (shipping fees and sales tax) because Stripe does not show Synder that information. Is SquareSpace giving that detail to Stripe? If not, can I bring information directly into QBO from SquareSpace? And if so, then how do folks quickly reconcile the deposits being made into one's bank account by Stripe, with Sales Made? Is it necessary to abandon SquareSpace and Stripe and find a different website site platform and credit card processor? Any suggestions / solutions would be greatly appreciated. 

Link to comment
40 minutes ago, acgoggin said:

Is SquareSpace giving that detail to Stripe? If not, can I bring information directly into QBO from SquareSpace?

No, Squarespace sends the transaction amount only.

There is a Quickbooks extension for Squarespace, but I don't know if this will help. If you try it, let us know how you get on.

Did this help? Please give feedback by clicking an icon below  ⬇️

Improve your online store with our extensions.
About: Squarespace Circle Leader since 2017. I value honesty, transparency, appreciation and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™.
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Buy me a coffee

Link to comment

Create an account or sign in to comment

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

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.