If you take card payments through Stripe and keep your books in Odoo, you've probably seen this. Customers pay five invoices this week. A few days later one deposit shows up in the bank, and it doesn't match any of them. It's the total of those payments minus Stripe's fees.
So someone opens the Stripe dashboard, exports the payout, and works out which payments went into that deposit. Then they book the fees by hand and finally reconcile the bank line. It's not hard, it's just tedious, and it's easy to get a few cents off and spend an hour finding them.
We got tired of doing it by hand for our own books, so we built an Odoo module that does it for us. We first built it for Odoo 19, then decided it was worth making work for everyone, so it now supports Odoo 15 through 20. Here's how it works, what it does when something doesn't line up, and what we learned building it.
Why Stripe deposits don't match your invoices
The mismatch comes from how the money moves. Each card payment in Odoo creates a payment against the invoice. That payment sits in an outstanding (clearing) account until it's matched to the bank. Stripe, meanwhile, holds the money, takes its processing fee out of each charge, and sends you one payout for the batch.
Here's a hypothetical example. Three invoices are paid by card for $500, $300, and $200. Say Stripe's fees on those come to $30. The bank gets one $970 deposit. Odoo has $1,000 in payments waiting to clear. The $30 difference has to be booked as an expense before anything reconciles.
Multiply that by every payout and you can see why it ends up in a spreadsheet.
What the module does
The module runs as a scheduled action inside Odoo, hourly by default once you switch it on. For each paid Stripe payout it hasn't seen before, it does five things:
- Pulls the payout and every charge inside it from Stripe's API, using the secret key already stored on Odoo's Stripe payment provider. There's no second login to manage.
- Matches each charge to its Odoo payment by the Stripe payment ID Odoo already saved when the customer paid.
- Finds the bank deposit in your bank journal: same amount, a date within a few days of when Stripe says it arrived (five by default), and "STRIPE" somewhere in the bank line's label. You can change both settings.
- Books the fees as one journal entry to your processing-fee expense account.
- Reconciles everything. It clears the payments, the fee entry, and the bank line against each other, so the deposit shows as matched.
Every payout gets a log record showing its charges and how each one was matched. If you need to know why a deposit looks the way it does, you can open the payout and see it in Odoo.
What happens when it doesn't match
We'll be honest: this was most of the work. Matching the easy payouts is simple. The hard part is deciding what to do when the data is messy.
The rule we settled on is that the module only posts entries when it's confident. If any of these happen, it logs the payout as an error, says why, and posts nothing:
- A charge in the payout can't be traced to an Odoo payment.
- The Odoo payment exists but isn't posted yet.
- It finds zero bank lines that match, or more than one.
- The payments in the payout use different journals or clearing accounts.
Refunds are logged for review rather than auto-matched. We'd rather have a person look at a refund than guess.
There's also a dry run mode, and new setups start in it. In dry run, the module does all the matching and shows you what it would do, but posts nothing. We run it that way first, read through the log, and fix any setup gaps before switching it to post. There's a small test screen too, so you can see what Stripe is actually sending before you trust the matching.
The checkout fee wrinkle
Some businesses pass the card fee on to the customer at checkout. We built a separate Odoo module for that as well: a fixed or percentage fee per payment provider, shown to the customer before they pay.
That breaks the simple math, because now Stripe charged the customer more than the invoice amount. The reconcile module handles it by comparing what Stripe charged with what Odoo expected. It books the difference as income in a checkout fee account you choose. Stripe's own fee still goes to expense, and the payout still balances.
Before you charge customers a card fee, check with your accountant or attorney on whether it's allowed for your business and how it needs to be disclosed. That's not something software settles.
What we learned
Start with a dry run, always. Even with good code, the first run usually turns up setup gaps, like a bank journal that wasn't chosen or a payment that never got posted. Finding those in a log is a lot better than finding them in posted entries.
Refuse to guess. We could have matched "close enough" deposits, but one wrong match in the bank is worse than ten payouts left for a person to review. If the module isn't sure, it stops and tells you why.
Odoo versions move the furniture. Where the clearing account lives, how payment status works, and when bank lines create their entries all changed between Odoo versions. We wrote the module to handle those differences from Odoo 15 through 20, and that's a big reason we build custom work as versioned modules that are tested and carried through upgrades.
Keep it in one database. This could have been an outside sync tool. Building it as an Odoo module means it uses the same accounts, journals, and access rights as the rest of the books, and nobody has to check a second system.
Is this worth it for you?
If you only get a couple of Stripe payouts a month, honestly, doing it by hand is probably fine. If you're reconciling many payouts a week, or your bookkeeper keeps chasing small differences, it's worth looking at.
Here's what I'd check first:
- Are Stripe payments coming in through Odoo's Stripe payment provider, so each payment has its Stripe ID?
- Is your bank feed coming into one bank journal in Odoo?
- Do you have a separate expense account for processing fees?
If those are in place, most of the setup is choosing a few accounts and journals and running a dry run.
Not on Odoo yet? You can try Odoo here and see how payments and bank reconciliation work out of the box.
If Stripe reconciliation is eating your week, send us a note. We can walk through your setup and tell you whether this would fit.