Hi,

You’ve raised a very valid point — we’ve encountered this same challenge when working with Stripe payouts, especially in scenarios involving Stripe Terminal or grouped transactions. The lack of clear mapping between individual charges and the final bank payout often creates reconciliation gaps in Odoo.

We’re actively working on a solution that simplifies this by utilizing Stripe’s transaction metadata and payout structure to deliver cleaner, automated reconciliation logic within Odoo — including fee handling and proper mapping of grouped charges.

While I can’t share all the specifics yet, our approach is designed to give better visibility and save hours of manual work.

If this sounds relevant, feel free to DM me. Happy to keep you updated once we’re ready to roll it out.

Best regards,

Bhushan Lilapra

Director – iQud Tek LLP

In the case of Stripe, the problem is that Stripe is sending the money of for example couple of days of terminal payments in one transaction. Sometimes you do not see any description about the original transaction of the stripe payment. Besides, stripe is reducing the amount by a percentage as a provision (this can be done during reconciliation and/or via automation).

So to explain better the issue, here is an example:

terminal payment, 01.02.2025, stripe transaction_id = pin_00001, amount = 10 €
terminal payment, 01.02.2025, stripe transaction_id = pin_00002, amount = 20€
terminal payment, 02.02.2025, stripe transaction_id = pin_00003, amount = 20 €

Stripe transfers money:
bank transaction, 03.02.2025, NO stripe transaction_id (only bank transaction_id which is not useful), Transaction Description = Stripe, amount = 45€ = 50€ - (50€ * 10% as an example of the stripe provision)

On Stripe Panel: (This is missing in Odoo)
stripe out transaction, 03.02.2025, stripe transaction_id = pout_00010, amount = 45€, includes transactions =[pin_00001, pin_00002, pin_00003] 

even if we have the infos from the stripe panel, we cannot 100% match with the bank transactions, because of lack of information from stripe.

I hope someone can have a solution for it. Otherwise, we will also need to do some customizations.

Regards,

bitigloo GmbH

Hi Dan,

It sounds like what you are looking for are Reconciliation Models. Using the counterpart values you should be able to set up fixed or percentage-based fees to be deducted from payments coming in and reconcile the rest with pending transactions.

If you can, I would suggest setting up a second testing database with a copy of your live data. You'll have more freedom to test things without making a mountain of work for yourself should you need to undo some particularly annoying mistake.

Good luck!