How do I reconcile Shopify, Stripe and PayPal payouts?
Each processor pays out gross sales minus its own fees, on its own schedule, bundling several days of orders into one payout with no obvious breakdown. Matching that back to individual orders by hand does not scale past a handful of transactions a day. It needs to happen automatically, at the point of sale.
Why a payout never matches an order list on sight
Gross in, net out
Every processor pays you less than the order total. Stripe, PayPal and Klarna each take their own cut on their own schedule, and none of them explains it in a way that matches your order list.
One payout, many orders, no obvious link
A payout reference is just a number and an amount. Working out which orders it actually covers means opening the processor dashboard and counting by hand.
Three processors, three formats
Stripe, PayPal and Klarna each report fees and timing differently, so a spreadsheet built to handle one rarely copes cleanly with the others.
Disputes and chargebacks reopen a period you already closed
A chargeback landing weeks after the sale forces you to revisit a period you thought was done, unless something is already tracking the order it relates to.
Every payout arrives pre-matched to its orders.
Fees, gross and net are calculated and recorded per order the moment it is placed, so when a payout lands from Stripe, PayPal or Klarna, it is matched against the exact orders it covers automatically. Disputes and chargebacks link straight back to the original sale instead of reopening a closed period.
Odoo matches payouts to orders, not the other way round
We build your accounting on Odoo, the open-source commerce ERP, and connect Shopify, Stripe, PayPal and Klarna to it with connectors we build and maintain ourselves. Fee and net calculations happen at the order level, so a payout arriving days later is a reconciliation the system has already done, not one your finance team has to start from scratch.
This is the same underlying discipline behind the EDI pipeline we built and run, processing thousands of invoices a day, and the revenue assignment work we did for Gandys across three sales channels. Getting financial documents matched correctly the first time is the whole point of both.
See how the pieces fit
Why don't my Shopify sales match my accounts?
The wider reconciliation problem payouts sit inside.
How do I reconcile marketplace settlements?
The same problem, for Amazon and bol.com fees and adjustments.
Packaged commerce build
One system for your operation, from £20,000, live in 8 to 10 weeks.
Selling on marketplaces too? See how to reconcile Amazon and marketplace settlements →
Ready to fix your ops?
Book a free discovery call. We'll look at your current setup and tell you honestly whether Odoo is the right move and what it would involve.