QuickBooks & Shopify

Wetsox
New Member
3 0 0

I am looking for a way to integrate QuickBooks and Shopify but I do NOT want to bring over individual customers/orders; we have way too many orders and would blow QBs up in no time (even Enterprise).  Ideally we would have a summarized daily sales receipt that uses the date as the 'customer' (or even Shopify as the customer) and list out how many of each product was sold; then list the payments - so it would end up being a zero dollar sales receipt.

 

Has anyone created this solution yet?  We just don't need to duplicate the customer details in QuickBooks; I don't know how larger merchants are doing this.

 

Thank you.

Replies 18 (18)
jmartini
Tourist
6 0 1

I too am searching for this answer for three different accounting clients I have and can't seem to find any good solutions. All of the connector apps I have researched so far either have terrible reviews or are pretty expensive for a small business to bear. 


eCommAccountant
Explorer
72 1 11

A2X does this

MashaZ
Tourist
9 1 1

In cases of large transaction volumes, the regular practice is to make either weekly or daily (depends on the company's size, labour availability and other factors) manual journal for sales, COGS (cost of goods sold) and corresponding fees (bank, Shopify, etc.). There is no need to connect Shopify with Quickbooks in this case. In fact, it is better if you won't. And yes, you are right, you may either enter it through the AR subledger (entering one customer as Shopify or "General Customer" or whatever you want to call it) and then add all the sales for the period to this transaction, or via manual journal entry. 

---
Accounting professional with experience in e-commerce and other industries. Specializing in Xero & QBO setups, year-end/period-end catching up, and monthly support
www.canadiancloudaccounting.ca
jmartini
Tourist
6 0 1

Hoping for something more sophisticated than journal entries. Especially as we don't maintain inventory costs in Shopify since they change constantly, so calculating COGS is an all day affair each month.  So we have to maintain a whole separate system for inventory tracking (especially because QBO is not sophisticated enough to do it) and enter every transaction twice. Additionally, there is often a long delay between receiving the customer order/payment and shipping out the goods (actually earning the revenue). All of Shopify's "sales" reports are just orders and do not represent GAAP revenue, which for us is often vastly different than orders. Nor can Shopify report on only unshipped orders which we could back out of gross sales to get earned revenue.  We did just find out about and subscribe to an app called Data Export that allows for much better reporting. It's not that user friendly, but their representatives will actually write the reports for you if you can articulate your needs and it's a bargain with their top tier being only $20/mo.

MashaZ
Tourist
9 1 1

If someone is willing to do this for you for $20/month, I wouldn't even think - I'd hire them today.:) 

As for the gap between the sale and shipment, you may only adjust that at the end of the reporting period - no need to do it with every entry. 

I would still, actually, figure out the best way to make manual journal entries. Maybe, there is something in the process that you currently have could be changed to make it easier for you. You really need to talk to an accountant about it as someone would need to spend some time to understand your current process in order to improve it.

---
Accounting professional with experience in e-commerce and other industries. Specializing in Xero & QBO setups, year-end/period-end catching up, and monthly support
www.canadiancloudaccounting.ca
Wetsox
New Member
3 0 0

Look at using www.thesupermanager.com as a bridge program.  It will bring the orders into QuickBooks using the date as the customer name so you don't blow up the customer list in QBs.  We have a sales receipt come in for each order that decrements inventory in QBs; if there's 100 orders today each one comes in under today's date as the 'name' - although the actual bill to/ship to information does show on the sales receipt.  If you have a ton of SKUs though - this isn't the best solution.  Also - you may run into trouble with the 'ship status' and if they are marked paid or not - but it's something to look into.  There's a few ways you can configure the software - in case you wanted the customer names to come in, you can.  You can also use a generic item if you are just looking for sales numbers.

 

The other option is to get a full blown OM/Inventory management system like Stone Edge or Locate; something that works with Shopify but manages the inventory/customers within their database.  Both of these programs will send over summary information to QBs only - so QBs can be just the accounting software.

eCommAccountant
Explorer
72 1 11
this supermanager is rather expensive. I do this same thing for my
eCommerce bookkeeping clients but balance each order rather than dumping a
bunch of data into QBO WITHOUT balancing each transaction. remember garage
in = garbage out.
Parextech
Shopify Partner
42 1 4
Hi All,
I represent QuickBooks Bridge. One of the well rated QuickBooks and Xero apps.
https://apps.shopify.com/quickbooks-bridge

We have a solution for Daily summary. Buy instead of Salesreceipt, we enter details in the form of a Journal entry.

We offer a free trial so feel free to test if it meets your need.
Daily journal entry is not a common feature but we will have to set it up for you.

Already so many of our customers are using this feature.

Let us know if you have any questions.
Thanks,
Kumar
AlanaBryantCPA
Excursionist
10 0 3

A2X Accounting is a good solution

eCommAccountant
Explorer
72 1 11

only if you don't care about landed cost by sku, by all means force balance with A2X

AlanaBryantCPA
Excursionist
10 0 3

@eCommAccountant   What would be your best recommendation?

eCommAccountant
Explorer
72 1 11

There isn't any app that can handle landed cost by sku, I've created my own system to do this and balance each order I import for my small eCommerce bookkeeping clients into QBO. If you want to get away from QBO with inventory clients, then I'd suggest AccountingSuite with their built in eCommerce features. They do require a bridge and they suggest ShipStation which some of my larger eCommerce clients already use, so it's a win-win for them.

 

Here's AccountingSuite's pricing, and they do have 50% off pricing frequently, and keep in mind these prices are for life not like QBO. And when you partner with them like I have, I get an additional 30% off for life that I pass on to my smaller eCommerce clients. So this $129 a month could drop down to under $20 a month working with a partnered Accountant.

And I must add; I just received an email from my AccountingSuite rep yesterday offering me an additional 31% off for life, any new client I on-boarded.

11.2.19.JPG

pondconsulting
New Member
3 0 0

Hi

 

We are QuickBooks integrators currently working on our own QuickBooks Shopify integration bridge. We also take on adhoc projects and we would very much like the opportunity to work on your requirements as a quick adhoc project. We can agree on a fixed price for this solution or a monthly fee if you want us to host it. Please contact me and let's discuss your requirements further.

 

Best regards

 

Terence Joubert

Pond Consulting

info@pondconsulting.biz

https://www.pondconsulting.biz

aremae33
New Member
3 0 0

I'm using the plugin of Shopify for my QuickBooks and accounting management. I'm running a store of fish pond on my shopify which is running in a very good position.

PhotosByBennett
New Member
1 0 0

I am setting up a first-time Shopify store and was told by my accountant to use QuickBooks Pro DESKTOP. But is the Desktop version supported by Shopify and does anyone work with the Desktop version? The few references to QuickBooks that I see on the Shopify help site refer to the Quickbooks Online version only. Thank you.

pondconsulting
New Member
3 0 0

Hi

Your accountant is right; QuickBooks Desktop is the best because QuickBooks Online does not support all the features that you need. To integrate with QB Desktop, you need a developer who is familiar with both QuickBooks Desktop and Shopify APIs to build a custom solution for you. This is what I do and if you are interested, please let me know a good time that we can meet to discuss your requirements.

Best Regards

Terence Joubert
Principal Consultant
Pond Consulting
info@pondconsulting.biz
https://www.pondconsulting.biz

MashaZ
Tourist
9 1 1

It really depends on your volumes. I wouldn't go the "QBDesktop" route. You work with an online app and you want convenience. There are workarounds with QBD, but you still need to figure it out before you'd implement everything the way you want. 

Many accountants recommend QBD because it is more "stable", has more features, etc. Also, some accountants recommend it because they simply used it for years and truly believe that this is the best, if not the only solution. However, there are tons of Shopify stores nowadays that use QBO or Xero. My personal preference is with Xero, but QBO is also a valid option. 

Having said that, once again, before you implement anything, you need to know what exactly you are looking for. Shopify tracks inventory. Your accountant might not even know about that. If you'd set up Shopify correctly, you won't need to track inventory in QBO (or Xero - whichever one you'd use). I am almost certain that the reason your accountant recommends QBD is that you'd have inventory and QBD handles inventory better than QBO. However, once again, if you use Shopify properly, you won't need to track inventory in the bookkeeping program. 

Anyway... my suggestion - talk to another accountant to get a second opinion.:) The one you currently use is clearly either a big fan of QBD or doesn't know all the features available in QBO, Xero, or Shopify.

---
Accounting professional with experience in e-commerce and other industries. Specializing in Xero & QBO setups, year-end/period-end catching up, and monthly support
www.canadiancloudaccounting.ca
Parextech
Shopify Partner
42 1 4

I represent Parex. We have apps for all 3 platforms. QuickBooks Desktop, QuickBooks Online and Xero. I would agree that QB desktop has more features but probably more complex to use. It depends on what your need is. For USA, go with QuickBooks. For any other country, go with Xero.

@MashaZ is very right. There are many old school accountants not familiar with the latest options and trends. 

We are very neutral because we have apps for all 3 platforms on Shopify app marketplace.

Happy to answer any specific questions.