Shopify Holding Account in Quickbooks is Negative Balane

Accounting & Taxes

Topic summary

Issue: The Shopify in-transit holding account in QuickBooks Online (QBO) shows a negative balance starting in December, despite syncing transaction-level details. The account is where sales and payments run through, and it should match Shopify’s ending holding amount. The poster wonders if missing sales, excess payments, or refunds could be causing the variance, but the QBO–Shopify sync shows no discrepancies.

Suggested checks:

  • Reconcile daily: compare each day’s posted income in QBO to Shopify’s daily summary report. One respondent reports occasional mismatches that Shopify acknowledged as issues; after reposting, totals aligned.
  • Verify all sales/payment platforms (Shopify, Affirm, PayPal, Facebook, Walmart, etc.) are posting correctly and included in the sync.

Status: No confirmed root cause or resolution yet. Action items are daily reconciliation, contacting Shopify if daily totals don’t match, and ensuring all external payment channels are correctly integrated and posting into QBO.

Summarized with AI on January 8. AI used: gpt-5.
1

Hello - I am looking to get some insight on an issue I am seeing with my Shopify in transit holding account. I currently have all transaction level details being synced to QuickBooks online such that any sale and any payment run through the holding account which should give agree to the ending holding amount in shopify.

At some point in December, the shopify holding account went into a negative position, which really doesn’t make much sense to me. This either means that all the sales are not being synced or we are receiving too many payments? Both of which I am not sure how would happen as qbo<>shopify is not showing any discrepancies in synced data. I suppose it could also be related to refunds, but am not really sure how.

Anyone else have this issue or insights they can provide?

Thanks!

2

Have you reviewed each day to see if the recorded sales match Shopify? I look at the posted income for each day and compare that to the summary report in Shopify. There have been a few days where the totals didn’t match and when we contacted Shopify they responded that they had an issue and once we reposted, everything matched. Another possibility is the sales/payment platforms (shopify, Affirm, Paypal, Facebook, Walmart, etc.) Are the sales all posting correctly?