Why don't my Shopify sales match my accounts?
Shopify records what was sold. Your bank records what was paid out, later, minus fees, bundled across several days of orders. Compared directly, gross and net were never going to agree. The fix is not more manual matching, it is a system that understands the difference automatically.
Why sales and accounts never quite match
Shopify shows gross, the bank shows net
Shopify records the full sale value. What actually lands in the bank is that figure minus processor fees and minus a payout delay. Compared naively, the two never match.
One payout covers many orders, on its own schedule
A single Stripe or PayPal payout can bundle several days of orders together, arriving on a schedule that has nothing to do with when each sale happened.
Refunds and chargebacks land in a different period
A refund issued this month against an order from last month throws off whichever period you are trying to reconcile, unless something is tracking the link.
Bookkeeping software was not built for this
General accounting tools expect a bank statement and a handful of invoices, not thousands of small transactions bundled through payment processors and channels.
Sales, fees and payouts reconcile themselves.
Every order, fee and payout is understood by the system as it happens, so a payout arriving days later is automatically matched back to the orders it covers, fees are recorded correctly against the right period, and refunds tie back to the original sale. What is left to check by hand is genuinely the exception, not the everyday.
Odoo understands gross, fees and net, automatically
We build your accounting on Odoo, the open-source commerce ERP, and connect Shopify and your payment processors to it with connectors we build and maintain ourselves. Odoo records the gross sale, the fee and the net payout as related entries, so reconciliation is a match the system already made, not a spreadsheet exercise someone repeats every week.
We built the equivalent discipline at real volume with an EDI pipeline processing thousands of invoices a day, replacing licensed middleware and saving roughly one million euros a year, and with the revenue assignment workflow we built for Gandys, correctly posting sales by channel across three Shopify stores.
See how the pieces fit
How do I reconcile Shopify, Stripe & PayPal payouts?
The specific gross-versus-net, fees and timing problem, solved.
Why does month-end take so long?
How this reconciliation problem compounds into a slow close.
Odoo vs QuickBooks
When bookkeeping software stops being enough for a multi-channel operation.
Is it specifically the payouts that do not match? See how to reconcile Shopify, Stripe and PayPal payouts →
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.