Xero Stripe reconciliation without ticking every payout by hand
Xero Stripe reconciliation means getting each Stripe payout to agree with the bank line in Xero, the invoices it paid and the fees Stripe kept. The deposit never equals one invoice, because Stripe pays out charges minus fees, refunds and disputes. You can book it by hand with a clearing account, post summaries with a sync app, or match the payout report with a tool such as Reconciles, from $888 a year. Which one fits depends on how many payouts you close a month.
Why a Stripe payout never matches one Xero bank line
Xero imports the bank feed line for the payout, for example $7,420.46 on the 14th. Your invoices show $7,912.00 of paid sales for the same days. The $491.54 gap is made of four things Xero cannot see from the bank line alone.
- Stripe fees on every charge, kept before the payout.
- Refunds you issued that week, taken out of the same payout.
- Disputes, including the lost amount and the dispute fee.
- Timing, because a payout covers charges from earlier days and one that lands on the 1st belongs to last month's sales.
So the suggested match on the Xero reconcile screen is empty, and the bookkeeper opens Find and Match. At ten payouts a month that is fine. At a daily payout schedule it is the whole afternoon.
Three ways to reconcile Stripe in Xero compared
| Method | How it works | Best for | Where it stops |
|---|---|---|---|
| Manual with a clearing account | Book each sale to a Stripe clearing account, then match the payout and code fees by hand | Under about 15 payouts a month | Slow, and a typing error hides in the clearing balance |
| Sync app that posts summaries | A posting app creates the sales, fee and refund entries per payout in Xero | Sellers who want entries created for them | Creates entries, does not prove each payout landed in the bank |
| Matching tool such as Reconciles | Reads the Stripe payout reconciliation report, the bank statement and the Xero export, matches them and lists exceptions | Teams with many payouts, several accounts or several clients | Does not post live, you import journals after review |
The two last rows solve different problems. Posting creates the books. Matching proves the cash. Teams that have a sync app and still find gaps at month end usually need the proof step, see Xero auto reconcile and what to use when payouts will not match.
One Stripe payout in Xero, line by line
Take the $7,420.46 deposit. The Stripe payout reconciliation report, which Stripe documents in its payout reconciliation guide, lists everything inside it.
| Line | Amount |
|---|---|
| 38 charges | $7,912.00 |
| Stripe fees | -$251.54 |
| 2 refunds | -$140.00 |
| Lost dispute | -$85.00 |
| Dispute fee | -$15.00 |
| Payout to the bank | $7,420.46 |
In Xero the entries come out like this. Debit the bank account $7,420.46. Debit Stripe fees $266.54 (the processing fees plus the dispute fee). Debit refunds $140.00 and chargeback losses $85.00. Credit the 38 invoices $7,912.00 in total. Debits equal credits at $7,912.00, so the payout is closed.
Now the failure case. If one invoice was paid twice and refunded later outside Stripe, the invoices would add up to $8,160.00 and the gap would no longer fit the report. A tool that starts from the report sees at once that $248.00 of invoices has no charge behind it. By hand you find it by ticking 38 invoices against 38 charges.
How Reconciles handles Xero and Stripe together
Export the payout reconciliation report from Stripe, the Account Transactions report from Xero and the bank statement, all as CSV or XLSX. Upload the three. Reconciles rebuilds each payout from its charges, refunds, fees and disputes, ties the net amount to the bank line and the charges to your invoices, and puts what it cannot tie into an exceptions queue with the amount. On Growth and Scale you export the approved adjustments as journal entries for Xero. The page on Stripe reconciliation shows the file layout, and the Xero reconciliation page covers the Xero side.
Firms that close this for many clients can run each client as its own entity, see reconciliation software for accounting firms. Firms that want clients to find them for this work can see which questions their clients search for before writing their own guides.
How to decide which method fits
1. Count payouts. Under 15 a month, a clearing account is enough.
2. Look at your gaps. If month end differences come from fees and refunds, posting solves it. If they come from missing or duplicate payments, you need matching.
3. Count accounts and clients. Past two processors or a few client files, one queue beats several apps.
4. Time one month. Upload last month's files and see how many payouts tie out on their own before you pay.
Xero Stripe reconciliation questions
How do I reconcile Stripe payouts in Xero?
Create a Stripe clearing account, book each sale to it, then match the payout bank line to the invoices and code fees and refunds as the difference. Use the Stripe payout reconciliation report as the source of the fee and refund amounts so the entry equals the deposit.
Why does my Stripe payout not match in Xero?
The payout is the total of many charges minus fees, refunds and disputes, so it equals no single invoice and Xero has no suggestion. Combine the invoices in Find and Match and code the difference, or match the payout report first.
Does Xero reconcile Stripe automatically?
Not the payout. Xero matches one to one lines from the bank feed. A Stripe payout is one bank line for many sales, so it needs a manual combine, a posting app or a matching tool.
What is the best tool for Xero and Stripe reconciliation?
It depends on the gap. A posting app suits teams that want entries created for them. A matching tool such as Reconciles suits teams that need each payout proven against the bank and invoices, from $888 a year.
How much does Xero Stripe reconciliation software cost?
Reconciles publishes its plans. Starter is $888 a year billed yearly for 3,000 matched transactions a month, Growth is $2,388 a year for 20,000 a month, and Scale is $5,988 a year for 100,000 a month. Monthly billing is $149, $399 and $999.