Stripe payout reconciliation
Turn Stripe's payout reconciliation or balance report into one balanced journal entry per payout for QuickBooks or Xero — gross sales, fees, refunds and disputes. Runs in your browser.
Why the deposit never matches your sales
Your processor doesn't send each sale to your bank. It nets a batch of sales against refunds, chargebacks and its own fees, then sends one payout. Your bank feed shows one lump sum; your books show dozens of gross sales. Bookkeepers fix this with a payout journal entry: debit the bank for the deposit, debit fees and refunds, credit gross sales. PayoutSplit writes that entry for every payout, from the export you already have.
Which Stripe report to use
In the Stripe Dashboard open Reports › Payout reconciliation, pick the date range and download Itemized (“Payout reconciliation — itemized”). The Balance report's itemized “balance change from activity” download also works. PayoutSplit reads the automatic_payout_id, reporting_category, gross, fee and net columns; extra columns are ignored.
What gets split out
- Charges → gross sales income; Stripe fees → fee expense.
- Refunds and refund failures → refunds.
- Disputes and dispute reversals, including the $15 dispute fee → chargebacks and fees.
- Stripe Billing, Radar and other platform fees → fees.
- Payout rows in the balance report are used to verify each payout: the transactions must add up to the payout to the cent, or you get a warning.
After importing
- Import the journal CSV (QuickBooks Online: New › Journal entry › Import, or the Xero manual journal import; IIF for QuickBooks Desktop).
- In your bank feed, match each processor deposit to the journal line on the bank account instead of adding it again.
- Your income now shows gross sales, fees appear as an expense, and the bank reconciles to the cent.
Already record each sale another way (an invoice app, Shopify connector, POS sync)? Point “Sales income” at your clearing or Undeposited Funds account so nothing is counted twice.
How it works
- Drop your processor export — Stripe payout reconciliation, PayPal activity, Square transactions or Shopify Payments transactions. Add your bank CSV if you want deposits matched.
- Check the payouts. Each one is split into gross sales, fees, refunds and more, and verified against the payout amount.
- Download journal entries for QuickBooks Online, QuickBooks Desktop or Xero and match them to the bank deposits.
FAQ
Is it really private?
Yes. Your files are read and processed by JavaScript running in your browser tab; their contents are never sent over the network. You don't connect PayoutSplit to Stripe, PayPal, Square, Shopify or your accounting software, so there's no access to revoke later.
Which processors are supported?
Stripe (payout reconciliation itemized and balance change from activity reports), PayPal (activity download, English headers), Square (Transactions CSV and Transfers CSV) and Shopify Payments (transactions export). Bank files from any bank can be added for deposit matching.
What does a payout journal entry look like?
Debit your bank for the deposit, debit processing fees, refunds and chargebacks, and credit gross sales (plus sales tax and tips payable when the export has them). The entry always balances, and the bank line equals the deposit to the cent.
I already record sales another way. Will this double count?
Only if you leave Sales income pointed at your real income account. If your POS or store already books each sale, set Sales income to the clearing or Undeposited Funds account under Your account names — the journal then just moves the net to the bank and records the fees.
What if a payout doesn't add up?
When the export includes the payout row (Stripe balance report, Shopify, PayPal withdrawals), PayoutSplit compares it with the sum of the transactions. A difference is flagged and booked to the clearing account so you can investigate instead of importing a wrong number.
What's free?
Every export format for up to 10 payouts per download, one processor file plus one bank file at a time. No account needed. Pro removes the limit and lets you combine several exports and processors in one go.