QB, Square and BigCommerce

DeeLT · ‎January 22, 2019

We use Square for processing both on our BigCommerce store and in our brick and mortar store. Bigcommerce and square integrate and Square passes all transactions to QB. The problem is with online transactions. They come over as one lump sum that doesn't break up tax and shipping. Big commerce integrates directly with QB but if I add this I now get duplicates of the online transactions as they come in from both S and BC. Is it possible to add two square accounts to QB? That way I could have BC talk to QB directly and Square talk directly to QB.

Anonymous · ‎January 22, 2019

Hello, @DeeLT.

I appreciate you sharing all the details about the integration. Let me help share some information about the online transactions from both Square and BigCommerce.

In QuickBooks Online, you can only integrate with one third-party app to avoid getting duplicates. If you have two integrated apps, it would be inconvenient to delete the other transactions.

You'll need to decide which app you should integrate to get you on the right track. I'll be here to help if you have additional questions. Have a good one.

DeeLT · ‎January 22, 2019

Thanks for that, but i don't think you are fully understanding me. Right now it's pretty useless as the square app doesn't hey the transaction details from big commerce for online sales. No sales tax or shopping so we have to manually sieve through 200-300 orders to get that info. If I add the big commerce integration I don't get any of the transactions from our store. O

If I could add two square accounts I would get exactly what I need. I would have one square amount for e commerce and the other for or brick and mortar store. No manual importing, no sifting through hundreds of orders looking for sales tax and shipping. There wouldn't be any duplicates.

JenoP · ‎January 22, 2019

Let me join this thread and answer your question, DeeLT.

For now, only one Square account can be connected to QuickBooks. You might need to manually add the sales tax info and other transaction details to the transactions that are imported to QuickBooks.

I would suggest sending your feedback directly to our product engineers. They collect feedback and request from our customers for future product enhancements. Just go to the Gear icon and click Feedback.

We hope to have this option enabled soon. You can also drop a comment or reply to this thread if you need anything else.

DeeLT · ‎January 22, 2019

I guess for now we'll have to look for another book keeping solution. We have 200+ orders weekly and it's not an effective use of anyone's time to go through and manually add the sales tax for those each week.

DeeLT · ‎January 23, 2019

I haven't used QB before so excuse my lack of knowledge. Is there a way that I could setup two companies, or a sub company and each one use different square processing accounts?

Anonymous · ‎January 23, 2019

Hello, DeeLT.

One QuickBooks Online account is only good for one company file and won’t allow you to add a sub company. You’ll need to subscribe for another QBO account to cater your second company.

Thanks for dropping by. Keep in touch if there's anything else we can help you with.

Topics

Training

Community

Resources

QB, Square and BigCommerce