Why QuickBooks Online Duplicates Shopify Transactions

There are three main causes for duplicate transactions in QBO, depending on your setup.

1. Double Data Sources (Most Common Cause)

You may be getting data into QBO from both Shopify and your bank feed separately. For example:

• Shopify or a connector app (Shopify Connector, A2X, Synder, etc.) creates sales receipts or journal entries for each payout.
• The bank feed downloads the actual deposit from Shopify Payments.

QBO sees both entries but they do not automatically match because:

• The Shopify payout record already created a deposit.
• The bank feed shows a deposit with the same amount.

Result: You see two deposits, one created by the integration and one downloaded from the bank.

Example:

• Shopify records a $970 deposit (net of $30 fees) in QBO.
• Bank feed imports a $970 deposit from your bank.
• This creates a duplicate entry.

2. Overlapping Apps or Sync Settings

If you have connected multiple Shopify apps (for example, the native Shopify Connector and A2X, Webgility, or Synder), each app may post transactions independently.

Result: Every sale or payout can appear twice or more, one per integration.

Fix:

• Use only one integration to post Shopify sales into QBO.
• Turn off automatic sales posting in extra apps.
• Keep one app for sales data and another (if needed) for inventory sync, but do not let both create invoices.

3. Incorrect Deposit Mapping

Sometimes the connector is set to record deposits directly to Checking instead of a clearing account. When the actual deposit comes from your bank feed, QuickBooks does not recognize it as the same money, creating a duplicate.

Fix:

• In your connector settings, set the deposit account to a Shopify Clearing Account or Shopify Payments Clearing.
• When the bank feed transaction downloads, match it to the clearing account instead of creating a new deposit.

Bonus Causes

• Test orders or manual entries recorded both directly in QBO and via sync.
• Partial sync retries if the app disconnected mid-sync and resent the same data.
• Shopify payouts with multiple orders may post each order separately plus a summary entry.

How to Fix Existing Duplicates

Step 1: Identify the Duplicates

Go to Sales → All Sales or Banking → Reviewed Transactions. Look for:

• Duplicate deposits for the same date and amount
• Duplicate sales receipts or invoices for the same order number

Step 2: Determine the Source

Open each duplicate and check the “Created by” or Memo field:

• If it says Shopify Connector, A2X, or Synder → it’s from an app.
• If it says Added via Bank Feed → it’s from your connected bank account.

Step 3: Decide Which to Keep

Keep the entry that includes detailed sales information (items, tax, fees). Delete or exclude the one showing only a lump-sum deposit.

Usually, keep the Shopify/A2X/Synder entry and exclude the matching deposit from the bank feed. In the Banking tab, select the duplicate bank transaction and click “Exclude” instead of “Add.”

Step 4: Reconcile Using a Clearing Account

If you use Shopify Payments:

1. Create a Shopify Clearing Account (type: Bank) in QBO.
2. Let the connector post all Shopify payouts there.
3. When the actual deposit hits your bank, match it to the clearing account instead of creating a new deposit. This prevents future duplicates automatically.

Best Practices to Prevent Duplication

Quick Recap