Why Your Stripe Deposit Doesn't Match Your Sales

You sold $5,000 last week. Stripe deposited $4,206.05. Your accounting software shows one deposit, and you're trying to work out where the other $800 went. This is one of the most common questions on bookkeeping forums. The answer is almost always some mix of the six reasons below.

Reason 1: Payouts are net, not gross

Stripe takes its processing fee out of each charge before the money reaches your balance. Your bank sees net, but your revenue is gross. The fee is a business expense, so record it as one rather than letting it vanish.

Reason 2: Refunds come out of the same balance

When you refund a customer, Stripe deducts the refund from your balance, which usually means from your next payout. By default Stripe keeps the original processing fee on a refunded charge. So a fully refunded $100 sale can still cost you the fee.

Reason 3: Disputes (chargebacks) and dispute fees

When a customer disputes a charge, Stripe withdraws the disputed amount plus a dispute fee. If you win, the funds come back later as a separate balance transaction, possibly in a different payout. In the payout reconciliation report these show up under the dispute reporting category.

Reason 4: Timing — a payout isn't "last week's sales"

Stripe pays out on a rolling schedule. A payout contains the transactions that became available in that window (look at the available_on column), and that depends on your payout schedule and account. So Monday's deposit might include Wednesday-to-Friday charges from the week before. Comparing a calendar week of sales to a calendar week of deposits will almost never match.

Time zones matter too. Stripe reports default to UTC unless you choose your time zone when you run them.

Reason 5: Adjustments and other balance activity

Some balance activity isn't sales at all: Stripe billing for other Stripe products, reserve holds and releases, currency conversions, and miscellaneous adjustments. These show up under categories like fee, other_adjustment, or reserve-related categories in Stripe's reporting categories documentation.

Reason 6: Sales tax or VAT included in gross

If your checkout collects tax, part of the gross isn't your revenue. It's a liability you owe. This doesn't change the deposit, but it changes how you split the deposit in your books.

How to trace a payout back to its parts

Step 1: Get the itemized report

In the Stripe Dashboard, go to Reports → Payout reconciliation, choose a date range around the payout, and download the Itemized CSV. Each row is one balance transaction, tagged with the payout it went into (automatic_payout_id) and a reporting_category.

Step 2: Filter to the payout

Filter automatic_payout_id to the deposit you're investigating. Now you're only looking at what Stripe actually bundled into that payment.

Step 3: Total by category

Worked example (illustrative numbers only)

That's the deposit. The "missing" $643.95 between $4,850 of sales and the $4,206.05 deposit is $173.95 in fees, $320 in refunds and $150 in disputed funds.

If the totals still don't match the deposit:

• Make sure you selected all reporting categories when you downloaded.
• Check that the payout ID is correct. Two payouts on nearby days are easy to mix up.
• Look for other_adjustment or fee rows that aren't attached to a charge.

Step 4: Record it properly

Once you have the breakdown, record the payout as one balanced journal entry:

Now your books show the real revenue, the real costs, and a deposit that matches the bank to the cent. For step-by-step entry and import instructions, see:

• How to reconcile Stripe payouts in QuickBooks Online
• How to import Stripe payouts into Xero as a manual journal

A quick mental model

Think of Stripe as a mini bank account that sits between your customers and your real bank:

• Charges go in (gross).
• Fees, refunds, disputes and adjustments come out.
• Payouts move what's left to your bank.

Your books should show each of those flows. The bank deposit is only the last one.

Where PayoutPair helps

The tracing above takes about 15 minutes per payout in a spreadsheet the first time. It gets faster with practice, but it's still repetitive. PayoutPair does steps 2–4 for you. Upload the Stripe payout reconciliation CSV and you get the breakdown (gross sales, fees, refunds, disputes, adjustments, net to bank) as one balanced journal entry. You can map it to your QuickBooks Online accounts by name or your Xero account codes and tax rates, then export it for import.

It doesn't connect to Stripe. It only reads the CSV you upload. The free calculator is a quick way to see why a specific deposit came out the way it did, and you can try a full CSV without an account.