DeepLedger
Menu

Bookkeeping

How to Reconcile Stripe Payouts in QuickBooks or Xero with AI

A Stripe deposit is net of fees, refunds and disputes. Break each payout into its parts, find the deposit in QuickBooks Online or Xero, and record it with a person's review.

Published by DeepLedger7 min read

To reconcile a Stripe payout, break the bank deposit into what Stripe netted together (the gross charges, Stripe's fees, refunds and disputes), record those parts in the ledger so they add up to the deposit, then match the deposit to the bank line. An AI agent connected through DeepLedger can do the reading and the arithmetic, and prepare the entry in QuickBooks Online or Xero for a person to confirm.

This guide is for bookkeepers and accountants who close the books for clients that sell through Stripe. It explains why the deposit never matches a sale, the two recording methods firms use, and a step-by-step workflow with an AI agent.

Why doesn't the Stripe deposit match the sales?

Stripe does not send each sale to the bank. It collects charges in the Stripe balance, takes its fees, deducts refunds and disputes, and pays out the net on a schedule. So one deposit is the sum of many items:

In the payoutEffect on the deposit
Charges (gross sales)Increase
Stripe processing feesDecrease
RefundsDecrease
Disputes and dispute feesDecrease (a won dispute can come back later)
AdjustmentsEither way

Stripe calls each of these a balance transaction, and each one carries a gross amount, a fee and a net amount. The nets of the balance transactions in a payout add up to the payout amount, which is why the payout, not the sale, is the unit you reconcile.

Two ways to record Stripe payouts

Pick one per client and keep it.

1. One deposit per payout. Record the bank deposit with a line for gross sales and a negative line for fees (and lines for refunds or disputes if any), so the deposit equals the payout. This is simple and suits clients whose sales are not invoiced one by one in the ledger.

2. A Stripe clearing account. Record sales into a clearing account (a bank-type account named Stripe), record fees and refunds against it, and record each payout as a transfer from the clearing account to the real bank account. The clearing account's balance should equal Stripe's own balance. This suits clients with invoices paid through Stripe, because each invoice payment can be applied to the clearing account.

Either way, the bank line in the ledger should match one figure: the payout.

The workflow with an AI agent

You need the company in DeepLedger with its ledger connected (QuickBooks Online or Xero) and Stripe connected for reporting on the company's Connections tab. If you have not set this up, follow Connect Claude to Stripe first. Connecting Stripe to the company is the same step whichever AI app you use.

Step 1: list the payouts for the period.

List every Stripe payout that arrived in October 2026 with its arrival date and amount. Convert cents to dollars and total them.

Stripe returns amounts in the smallest currency unit, so ask for the conversion every time.

Step 2: break one payout into its parts.

For the payout that arrived on October 14, list its balance transactions with type, gross, fee and net. Total each column and show that the net total equals the payout. If it does not, say by how much.

DeepLedger reads the balance transactions filtered to that payout through Stripe's own API. If the totals do not agree, stop there and look at the difference in the Stripe Dashboard before recording anything.

Step 3: find the deposit in the books.

Switch to Harbour Goods LLC. Look for a deposit of $4,812.36 within three days of October 14 in the operating bank account. Tell me if it is already recorded, and how.

In QuickBooks, if the company's bank is connected in DeepLedger, the AI can also check DeepLedger's bank feed for the payout. In Xero the AI reads the ledger side only, because Xero's API does not expose bank statement lines, so a person matches the statement line in Xero.

Step 4: prepare the entry, using the client's rule.

Read the AI Brain for this company. Prepare the entry for this payout using the client's Stripe method: gross sales, fees and refunds, so it equals the deposit. Show me the lines before you record anything.

Write the client's method in the company's AI Brain once (for example: "Stripe payouts arrive net of fees; record gross sales to Sales, fees to Merchant Fees, one deposit per payout"), so the AI follows it every month.

Step 5: confirm, then record. Read the proposed lines, check the account for each, and tell the AI to record it. In QuickBooks Online the payout becomes a deposit with a negative fees line. In Xero, money in and money out that have no invoice or bill behind them are recorded as Receive Money and Spend Money, which post at once, so check each one before you confirm.

Step 6: reconcile the bank account. The payout now matches one bank line. Reconcile the bank account as usual and sign it off. See QuickBooks AI reconciliation for what the AI prepares and what stays with you.

What the AI should never do here

  • Record a payout twice. Ask it to search for an existing deposit first (step 3). In QuickBooks, a deposit cannot be voided: a wrong one is deleted with your confirmation (refused if it is reconciled or dated on or before the closing date) or reversed with a journal entry.
  • Guess the method. If the AI Brain has no Stripe rule, the AI should ask, or open a Task for the reviewer, rather than pick accounts on its own.
  • Change Stripe. It cannot: DeepLedger blocks every Stripe write, refund and money movement.

Month-end checklist for Stripe

  1. Every payout that arrived in the month is recorded once.
  2. Each payout's balance transactions add up to the payout.
  3. Fees for the month in the ledger equal Stripe's fees for the payouts recorded.
  4. Refunds and disputes are recorded, and open disputes are listed for the reviewer.
  5. If you use a clearing account, its balance equals Stripe's balance at month end, allowing for payouts in transit.
  6. The bank reconciliation is signed off by a person.

Add these to the client's month-end close checklist.

Frequently asked questions

Why doesn't my Stripe deposit match my sales?

Stripe pays out the net of everything in the payout: charges minus Stripe's fees, minus refunds, minus disputes and their fees, plus any adjustments. One bank deposit can cover dozens of sales from several days, so it rarely matches a single invoice or sales total.

How do I record Stripe fees in QuickBooks Online?

A common method records each payout as one deposit: a line for the gross sales to your income or clearing account and a negative line for Stripe's fees to a fees expense account, so the deposit equals the payout. Use the method your firm already uses for that client, and keep it the same every month.

Can an AI agent reconcile Stripe payouts for me?

It can do the preparation. Through DeepLedger, an AI agent reads a payout's balance transactions in Stripe, adds up the gross, fees and net, looks for the matching deposit in QuickBooks Online or Xero, and prepares the entry. You check the figures and tell the AI to record it, and the bank reconciliation itself is still signed off by a person.

Does DeepLedger change anything in Stripe?

No. DeepLedger connects Stripe for reporting only. It reads payouts, balance transactions, charges, refunds and disputes, and every Stripe write and money movement is blocked.

Ready to get started?

Connect QuickBooks and try your first task with an AI agent.

Create an Account

With your permission, Google Analytics measures visits to our public website and blog. Essential cookies work either way. Change your choice in Cookie settings. Privacy policy