Why Stripe, Shopify & Square Deposits Don’t Match QuickBooks (And It’s Usually Not a QBO Problem)

I see this constantly:

A client says, “QuickBooks is wrong. My deposits don’t match my sales.”

But most of the time, QuickBooks isn’t the issue — the workflow is.

Here’s what’s usually happening:

1. Gross vs Net Reporting
   Payment processors collect gross sales, processing fees, refunds and chargebacks, then deposit the net amount to the bank.

If income is recorded as the net deposit instead of gross sales, revenue is understated and merchant fees get buried inside deposits. That creates distorted reporting.

1. Missing Clearing Accounts
   Many files do not use a clearing account for Stripe, Shopify or Square.

Without a clearing account, deposits appear random and reconciliation becomes guesswork.

The cleaner structure is:
Sales recorded to a processor clearing account
Fees recorded separately as expense
Net deposit matches the bank feed

When structured correctly, reconciliation becomes mechanical instead of investigative.

1. Timing Differences
   Processors batch deposits. Weekend sales may hit Tuesday. Refunds may offset later payouts.

If sales are recorded daily but deposits hit weekly, timing differences must be reconciled intentionally.

1. Double Counting Income
   This is one of the biggest problems.

If Shopify pushes sales to QuickBooks and then the bank deposit is also recorded as income, revenue gets overstated. I’ve seen this inflate revenue significantly.

Automation reduces data entry, but it does not replace financial structure.

Reconciliation is a control process, not just matching transactions.

If anyone is struggling with processor integrations or deposits not tying out, I’m happy to discuss workflow structures that make this predictable instead of confusing.

I also wrote a deeper breakdown on processor clearing accounts here if helpful: