Stripe QuickBooks Payout Reconciliation - Prepare Clean Entries
Reconcile Stripe payouts, balance transactions, payout status, and bank deposits before clearing or reviewing them in QuickBooks.
Try with sample files | View sample report
Problem statement
QuickBooks sees the net bank deposit, while Stripe spreads the explanation across payouts, balance transactions, refunds, disputes, adjustments, and timing. Without payout-level support, a deposit can be cleared with the wrong fee, refund, or open-item story.
Numeric example
| Line item | Amount |
|---|
| Gross Stripe charges | $3,260.00 |
| Refunds | -$180.00 |
| Stripe fees | -$102.80 |
| Disputes or adjustments | -$43.20 |
| QuickBooks bank deposit | $2,934.00 |
Why the numbers do not match
- QuickBooks bank feeds usually show only the net deposit that reached the bank.
- Stripe balance transactions hold the payout composition: charges, fees, refunds, disputes, and other adjustments.
- Payout status and arrival timing can make a valid Stripe payout look missing inside the QuickBooks review window.
- One payout can group many charges and non-charge deductions into one bank movement.
- A bank-feed match can clear cash before the payout evidence is fully reviewed.
What files to export
- Stripe balance transactions export with payout ID, type, amount, fee, net amount, and timing fields.
- Stripe payouts export with payout ID, status, arrival date, Trace ID or bank-reference details when available, and net payout amount.
- QuickBooks bank export with the bank deposit rows being reviewed or matched inside the bank feed.
- Optional orders or invoices export when customer-facing references are needed behind the Stripe charges.
Reconciliation workflow
- Identify the Stripe payout ID, payout status, arrival date, and expected bank movement that should explain the QuickBooks deposit.
- Group Stripe balance transactions by payout ID and separate charges, fees, refunds, disputes, and adjustments.
- If the payout status is pending, in transit, failed, or otherwise unresolved, keep the QuickBooks bank side open until the Stripe payout support is clearer.
- Compare the grouped net amount to the Stripe payouts export before you compare it to the QuickBooks bank row.
- Match the supported payout to the QuickBooks bank deposit by amount, date, and Trace ID or bank reference where available.
- Keep unsupported shortfalls as amount differences until the exported files prove the exact cause.
- Retain the reviewed payout report before any QuickBooks entry is cleared, edited, or approved.
Review checks
- The QuickBooks deposit was accepted from the bank feed without Stripe payout support.
- Gross Stripe charges were compared directly to a net QuickBooks deposit.
- Refund, dispute, or adjustment rows belong to a different payout period than the bank row under review.
- Payout status or arrival date was ignored before the bank match was called final.
- QuickBooks contains duplicate deposits or prior manual entries for the same Stripe payout.
How Reconcile Locally helps
- Keeps Stripe payout rows, balance-transaction support, and QuickBooks bank rows in one local review workflow.
- Separates matched deposits from amount differences, unknown bank payments, and grouped-row cases.
- Preserves payout-first evidence before clearing-account review or downstream bookkeeping decisions.
- Exports a report the accountant can review before any QuickBooks posting or clearing step.
What still needs manual review
- Reconcile Locally does not post to QuickBooks or decide ledger mapping, clearing-account treatment, or final journal structure.
- Some reserve, dispute, grouped-settlement, and weak-reference cases still need manual confirmation.
- A payout that arrives late or later changes status can require one more Stripe review before the bank side is considered complete.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Why does QuickBooks not match my Stripe payout automatically?
Because the bank feed sees the net deposit, while Stripe contains the payout-level charges, fees, refunds, disputes, and adjustments that explain it.
What should I export first?
Start with Stripe balance transactions and payouts for the period, then compare the supported payout net amount to the QuickBooks bank deposit.
Do I need Trace ID or arrival date if the amount already looks right?
Often yes. Trace ID, payout status, and arrival date help separate a true mismatch from a payout that is still in transit, delayed, or simply hard to identify in the bank feed.
Can Reconcile Locally post or clear the QuickBooks transaction?
No. It prepares a review-ready report from exported files. Posting, clearing, and approving accounting entries remain separate human workflows.