Problems with the QuickBooks Desktop Connector App

Hi Everyone,

My business is a small- to mid-sized non-profit. As with so many others, we made the switch from QuickBooks POS to Shopify/Shopify POS and, with this move, have set up the QuickBooks Desktop Connector app that was recommended for the migration since we also use QuickBooks Desktop. Setting up the connection in the app was frustrating, but we figured it out and are able to record data from Shopify POS purchases in QuickBooks Desktop.

The Problems:

  • Despite activating the “automatic sync” option, our orders still do not automatically sync. Our office manager has to log in every day [when he is onsite] and manually sync orders by working directly in the server. No one else seems to have the ability to do this, even when they have administrator powers in both QB Desktop and Shopify, and we do not want to grant multiple employees access to the server nor the office manager’s office (he is also our bookkeeper). As you can imagine, this is not only wildly inefficient, but also an issue for our workflow and security: whenever our office manager is offsite we cannot pull any orders into QB Desktop! Attempts from non-office manager employees (with Admin access) to sync via both QB Desktop and the Connector app UI do absolutely nothing–literally nothing happens.
  • We were promised “more detail” when viewing Shopify orders in QB Desktop as compared to QB POS, and yet we have found that our orders have even less detail. Payment methods used to list details like “Visa” or “Cash”–they now all say “Shopify Payments” (with the exception of cash which reads “cash” followed by our store’s “address”). Taxes are also unlabeled, except for the date, and are automatically sorted to the top making it incredibly tedious and difficult for our admin assistant to parse through which taxes go to which order (not to mention the taxes are incorrect, but that’s a different discussion…).
  • Customer details, like the payment details, are recorded on the Shopify side, but are not being transmitted to QB Desktop. Instead, these details have extremely general names and every order has the same information (i.e. “Shopify Payments”, “Shopify Default Customer”).

If anyone has any ideas regarding what we are doing incorrectly (assuming we are doing something incorrectly) or what the issue is, please help! Honestly, even if you don’t have a solution but have ran into the same kind of issues, I would love to hear about your experience(s) with this app as more data could help us identify the issue. Until then, we are looking at tumbling through the gauntlet of Shopify support, QB Desktop Connector app support, and Intuit support (or building our own API!).

Thank you.

1 Like

I am having a lot of the same issues. The other issue I am having is that now my QB connector app won’t let me select with accounts to sync with. Can’t get any answers. Hard to pay bills from QB if they aren’t there. They are in Shopify but not QB. My accountant is not going to be happy with the creative accounting I have been doing.

Oh no!

I am not sure if we are running into that issue as well, but a new one cropped up this past weekend: about 3/4 of our in-store Shopify POS transactions did not sync with QuickBooks Desktop.

This one is a bit of a head scratcher right now because on the Shopify end there is record of payment being captured successfully for all of them (POS app and backend Admin); however, weirdly enough, the receipts for those orders say there is a “balance due” after listing out the payment information…the following day everything was back to syncing like normal (as paltry as that may be). I have absolutely NO idea how to sync successful transactions with QB Desktop selectively, especially when I am not even really sure what the problem was to begin with…

We are having the same issues. Transactions and sales that are going through in shopify pos are not being recorded correctly or at all in quickbooks. Just curious to see if anyone has any fixes for this yet?

I am having issues syncing online orders. All in store sales sync but just dont know how to get the other orders to sync.

This company is a joke. They never fix anything it seems other than to mess with how the pos screen functions. The split payment does not transfer into quickbooks desktop properly and they have no answers. This software is creating an accounting nightmare and untold cost in accounting fees.

Same! Shopify in general works relatively well for our inventory management and actual retail sales, but the plethora of accounting issues is making it borderline unusable.

My organization ended up switching to QuickBooks Online and then, when we continued to experience order syncing issues (new ones, this time, but issues nonetheless), we decided to completely shut down automatic syncing instead resorting to manually entering sales receipts each day. I legitimately do not understand how Shopify and QuickBooks–two of the largest business solutions/platforms out right now–do not have a team working on this and/or a robust connection application!

I agree, the worst part is that you can’t talk to anyone that can resolve
the issue, and they tell you they will call you back and never do. It is
the most frustrating issue I have had to deal with since starting my
business in 1999.