Reconcile Stripe payouts: match each bank deposit to the payments, fees and refunds inside it

To reconcile Stripe payouts, match each bank deposit to a payout ID, not to individual sales. Download Stripe's itemised payout reconciliation report, confirm its net amounts add up to the deposit, then book fees and refunds on their own lines. This guide covers the QuickBooks route and the mismatches that remain.

We read the Stripe documentation and the Intuit help article linked below on October 25, 2026. Dashboard screens and report columns change, so check the current pages before you rely on a step. This is bookkeeping guidance, not accounting or tax advice; ask your accountant how your chart of accounts should treat each line.

Why a Stripe deposit never equals one sale

A Stripe payout is a batch. Stripe's documentation says that automatic payouts occur routinely according to your payout schedule and can include funds from multiple transactions. Intuit's article on the Stripe connector puts the arithmetic plainly: Stripe transfers the total amount (minus fees, adjustments, or holds) to your bank account. Your bank therefore sees one net number, and the sales, refunds and fees behind it are only visible inside Stripe.

The schedule adds a time gap. Daily payouts transfer your available funds every business day, weekly or monthly schedules use the days you pick, and payouts scheduled on weekends or holidays arrive on the next business day. Stripe's own example: with daily payouts and a 3-working-day settlement timing, it pays out funds daily from transactions captured 3 working days earlier. A Thursday deposit can hold Monday's sales, so matching sales to deposits by date will not work.

Every movement of money creates a record you can query. In Stripe's words, every funds movement in or out of your Stripe account creates a BalanceTransaction, and the type tells you whether it was a charge, a refund, a Stripe fee or the payout itself. Reconciling means finding the set of balance transactions that add up to the deposit.

Check your payout type before you start

The method depends on how your account pays out. Stripe says the payout reconciliation report is only available for users with automatic payouts enabled, or for a platform on manual payouts whose connected accounts have automatic payouts.

The manual-payout sentence is on Stripe's API reconciliation page, and the instant-payout sentence and the pointer to the Balance report are on the report page. If you use instant payouts for part of your balance, expect to reconcile those deposits against dates and amounts yourself.

How to reconcile Stripe payouts in six steps

1. Pick the bank line and note its posted date and amount. Do not start from a sale.
2. Open the Payout reconciliation report in the Stripe Dashboard and choose a date range that includes the payout's estimated arrival date. Stripe groups payouts by the estimated arrival date shown on the Payouts page, not the date your bank posts the deposit; if you are unsure, widen the range.
3. Find the payout in the Payout reconciliation section and download the Itemised CSV. Stripe says it contains every payment, refund, dispute, fee and other balance transaction included in the payout.
4. Add up the net column for the rows that share the payout's ID. The itemised report has gross, fee and net columns for each row, plus an automatic_payout_id column. In our reading, the net values of one payout's rows are what leave your Stripe balance in that payout, so the total should equal the deposit.
5. Read the totals by reporting category (below) so refunds, disputes and fees are visible rather than buried in a net figure.
6. Record the payout ID in the memo of the bank match, so next month's question "what was this deposit?" has a one-click answer.

What each reporting category does to the deposit

Stripe groups every balance transaction into a reporting category. These are the ones that decide most deposits.

The third column is our summary of those descriptions, not a Stripe table.

A worked example with invented numbers

The amounts below are made up to show the arithmetic. They are not from a real account or from Stripe's fee schedule, and they do not say whether a refund returns the original fee.

Your bank shows a single $337.79 deposit. In our view the clean way to book it is to record the three sales at gross ($390.00), the refund as a refund (-$40.00), the $12.21 of fees in a fees expense account, and the $337.79 deposit as the thing that ties them together. Revenue is then the sales, not the deposit. In our view, booking the deposit as income double counts every sale the integration or you have already recorded.

Reconcile Stripe payouts in QuickBooks Online

QuickBooks has an Intuit-built route. The article Connect and manage Stripe transactions in QuickBooks Online was shown as updated 9/21/2026 when we read it. We are summarizing it; we have not run the connector.

1. Go to Integrations, then Find integrations, and search for "Stripe Connector by QuickBooks".
2. Select Get integration, sign in to Stripe, and select Agree and Connect.
3. Complete the app settings. Intuit says to select the bank account where Stripe deposits your payouts as the Stripe Deposit Account.
4. Choose a start date (the article says you can import up to 2 years of history) and select Sync Now, then Go to App Transactions.

The article describes what a payout looks like once you add it: the app records a bank deposit that automatically links with the individual sales transactions and fees. It adds that fees are included in the compound deposit and categorized into a Stripe Fees expense account, and that a payout's entries can also include holds, disputes and adjustments.

The order matters. Intuit recommends adding transactions from the Stripe app first, then matching them in your online banking center. Intuit adds that you can also match a payout with the deposit from the bank account, which gives you the same one-bank-line-to-many-sales link that the CSV method builds by hand.

Xero: what we could and could not read

Xero's partnership page for Stripe says you can see transaction data flow into Xero using the Stripe feed, automatically match payments and fees to the correct invoices, and reconcile banking with payments in one click. Those are marketing lines from Xero's Stripe page.

Xero Central's help articles on Stripe direct feeds and on reconciling Stripe payments are rendered by script, and on October 25, 2026 we could not read their steps. We therefore give no Xero click path here. If you are weighing the two products on cost, our Xero price increase comparison covers what US small businesses pay.

When the payout still does not match

The date is off by a day or a month

Stripe's report data runs on its own clock. A day's report is normally available by 12:00 on the following day, so a payout can reach your bank before its reconciliation data is ready. You can view reports in your account's time zone or in UTC, and that choice changes which transactions a date range includes. Pick one and keep it for every month-end.

The deposit is smaller than the sales suggest

Open the other sections of the report. A Failed payouts section appears only when there are failed automatic payouts in the range, and the Ending balance reconciliation section lists transactions that hadn't been settled as of the report's end date. Disputes show up as their own reporting category inside the payout, and Intuit lists holds among a payout's entries.

The deposit never arrived

Use the payout trace ID. Stripe says that if you don't see an expected payout in your bank account after 10 working days, contact your bank for an update and provide the Trace ID. The ID is in the Details section of the payout in the Dashboard and in the Payout Reconciliation Report. Its status can be pending, supported or unsupported, and Stripe lists countries where payouts do not return one, including Japan and the Philippines.

The account settles in more than one currency

Reports follow your settlement currency, and if your account has multiple settlement currencies, you can view reports for each currency separately. Reconcile each currency against its own bank account.

Make it repeatable

Three Stripe features cut the monthly effort. You can schedule a report to download daily, weekly or monthly and get an email when it is ready. You can listen for the payout.reconciliation_completed webhook event to get the payout ID, then call the balance transactions endpoint with that ID to list what the payout contains. And for CSV exports, Stripe says you can include custom metadata to match Stripe transactions with records in your accounting system, so putting your order or invoice number in metadata at checkout saves a lookup later.

Skip the manual steps if your accounting connector already links each payout to its sales, as Intuit describes for its connector; spot-check one payout a month instead. If you take payments through Square or PayPal, the principle of matching the deposit to a settlement batch carries over, but we did not read their reports pages for this guide.

As of October 2026, Upfynd lists 155 accounting and invoicing products and 124 payments and banking products, including Stripe. Your next step is small: open your latest payout, download the itemised CSV and check whether the net column adds up to the deposit. If you build a tool in either category, you can submit it for a free listing.