Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

My Stripe payout does not match the deposit in QuickBooks

Short answer

A Stripe payout is not one sale. It sends your available balance to the bank and can bundle many payments, refunds and fees, so a sale-by-sale sync will not equal the deposit. Reconcile the payout, not the sales: Stripe lists exactly which transactions each automatic payout holds.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • The bank deposit is lower than the sales QuickBooks shows for the same days.
  • I cannot tell which sales a deposit covers.
  • Refunds, fees or disputes seem to vanish between Stripe and QuickBooks.
  • The deposit arrives days after the sales, and the dates never line up.
  • My bookkeeper reconciles by guessing which payments make up each deposit.

Why does this happen?

  1. A payout carries a bundle, not one payment

    Stripe states that automatic payouts follow your payout schedule and can include funds from multiple transactions. Each payout reflects the available balance at the time it was created, so one deposit can hold many sales.

  2. Fees and refunds sit inside the same balance

    Stripe's balance transactions include charges, refunds and Stripe fees, and the payout itself is also a balance transaction. A sync that books gross sales but not fees and refunds will always be higher than the bank.

  3. Sales and payouts happen on different days

    Stripe describes settlement timing as the time it takes for funds to become available, so a sale and the deposit that contains it are different events. Payouts scheduled on weekends or holidays arrive on the next business day.

  4. Manual payouts cannot be matched automatically

    Stripe notes that with manual payouts it cannot identify which transactions are in each payout. You are responsible for reconciling them against your transaction history.

  5. The sync books sales but not the money movement

    Many integrations record each sale as income and stop there. Nothing records the fees, the payout, or the clearing step in between, so the bank line has nothing to match.

What can I do about it today?

  1. Take one deposit and open it in StripeIn the Stripe Dashboard, open that payout. Stripe shows the transactions it contains and offers a payout reconciliation report.
  2. Add up the piecesSales minus refunds minus fees should equal the deposit. If it does, the problem is how QuickBooks records the pieces, not missing money.
  3. Check the payout scheduleSee whether payouts are automatic, daily, weekly or manual. Manual payouts are the hardest to reconcile.
  4. Do not force the books to matchDo not add an adjustment entry to make the deposit equal. It hides the cause and repeats every payout.
  5. Ask your bookkeeper how they want it recordedMost want fees and refunds shown separately, and sales cleared by one payout entry.

When should I bring someone in?

  • Deposits and recorded sales have differed for several months.
  • Disputes, refunds or multiple currencies are involved.
  • Your bookkeeper wants each payout matched to its sales automatically.

How do I handle it?

  1. Reconcile one payout by hand firstI read the vendor's current documentation first, and every change is tried on test data before it touches your real books. I use Stripe's own payout detail to prove that the total of its transactions equals the deposit, so the target is known.
  2. Record the payout as an eventThe integration is changed to book gross sales, refunds and fees as they happen and clear them with one payout entry that matches the bank line.
  3. Link every entry to its payoutEach recorded transaction carries its payout reference, so an unmatched amount can be traced rather than guessed.
  4. Check on a scheduleA regular comparison of payouts against bank deposits raises a message when they stop agreeing.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Where do I see what a payout contains?

Stripe says you can open the payout in the Dashboard, download the payout reconciliation report, or read it through the API.

Why does the deposit arrive later than the sale?

Stripe separates the time funds take to become available from the payout schedule. Weekends and holidays move a payout to the next business day.

Is money missing?

Usually not. The gap is normally fees, refunds, disputes and timing. Your payout detail shows whether the pieces add up.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

For your developer: the technical fixes

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.