Skip to Content
Menú
This question has been flagged
3 Respostes
2878 Vistes

I am on ODOO 14.


I am importing both my paypal, stripe,.. statement in a Suspense account (1009 Suspense account for PayPal, 1091 Suspense Account for Stripe,...) and my bank account statements. 

My bank statements lines start with indications like 'Stripe xxx'. 'Stripe xxx'. 


Today, what i do is manually reconcile each bank statement line manually against the corresponding  the suspense account . And that i add manually the fees to get my suspense account to zero. 

I would like to automate the manual process to reconcile each bank statement line. Is there any solution how to do it ? 


Anyone has an idea how to aumated this process ?


Thanks

Avatar
Descartar
Best Answer

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

Avatar
Descartar
Best Answer

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

Avatar
Descartar
Best Answer

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!

Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
de juny 24
4547
0
de gen. 24
1580
0
d’oct. 22
68
0
d’oct. 22
7
1
de gen. 24
4370