Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
W
wildfire39
May 22, 2026
Question

Shopify connector classifying transactions incorrectly

  • May 22, 2026
  • 1 reply
  • 4 views

I’ve been having a couple of issues with the Shopify connector and would appreciate if someone can help. I also only have the basic account and not sure if certain features are disabled bec of this. 

All Shopify sales are mapped out to automatically be classed under Shopify Channel sales. However, when I looked at my P&L report, I just noticed that at some point QBO started classifying these transactions under Wholesale Sales. I’ve no idea how to fix this. 

The other questions I have is - there seems to be duplicate clearing accounts for Shopify transactions. I push everything into a Shopify clearing account first, then final ACH transfers are received by my bank account. but I just found that QBO has also been pushing transactions into a Payments for Deposit account for undeposited funds. This seems to be a duplicate effort? My clearing account balance is reconciled and correct but the Payments for deposits account has a large balance and every single transaction in there stems from Shopify. Seems like a waste of time to try to reconcile this as well. What would you recommend?

1 reply

R
RusimyhrQuickBooks Team
QuickBooks Team
May 22, 2026
To fix your Shopify connector issues, adjust the default income mapping within your app settings and process payouts directly from the Integration transactions tab.
 
To correct the sales mapping:
 
  1. Go to the Integrations menu in your app settings.
  2. Select Manage integrations and open your Shopify tile settings.
  3. Review the Advanced Settings section.
  4. Change the default Sales Item mapping away from your wholesale income account and back to Shopify Channel Sales.
 
It’s also worth noting that this only fixes future imports; past entries on your P&L must be updated manually.
 
To stop the payments to the deposit balance from accumulating, use the app's three-step reconciliation workflow instead of manual bank feeds. Here’s how:
 
  1. Go to Integration transactions and click Confirm on individual sales receipts.
  2. Find the corresponding payout and click Add/Confirm.
  3. Go to your Bank transactions feed and click Match.
 
To clean up existing duplicates without throwing off your reconciled books, clear the screen with a zero-dollar deposit:
 
  1. Go to + Create and select Bank Deposit.
  2. Check the boxes next to the duplicate Shopify transactions.
  3. Add a negative line item that exactly matches the total amount of the duplicates.
Ensure the total of the deposit equals $0.00, then click Save.
 
If you have follow-up questions, please don't hesitate to click the Reply button.
 
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement