Odoo Help


How to automatically account for credit card fees per transaction?

michel Guénard
on 5/20/14, 12:50 PM 2,402 views

Context: Cutomers pay with their credit card; Credit Card is defined as a payment method inside the Odoo settings (at POS level for instance). The commercial transactions with the customers are accounted for with the full amount of the sale. The Credit Card company charges us with a fee per transaction; such fee is automatically debited by the bank on our account.

The fee is calculate as a % of the transaction amount plus a fixed amount per transaction

The fee charge is debited each time the credit card terminal sends a global daily transaction, which in our case is done every night. Thus aggegating several of our sales into one single global amount.

Our bank provides the gross amount only in a text filed mixed with the commission amount on a transaction basis

Consequences: We loose the tracability between our sales transactions and the bank statement; and this prevents us to import the bank statement into OpenErp - because:

A) it duplicates the payment entries into the accounting system

B) the amounts on the bank statement (credited to our account) are different from the ones resulting from our sales.


Is there a method within OpenErp to automatically calculate the credit card fee per transaction and to account for it? I guess that all e-commerce vendors are facing this kind of issue!

Thanks in advance for your comments or answers




Erwin De Raad
On 5/20/14, 6:16 PM

This is not the automation you are looking for, but it will create correct entries:

Per day or per payment batch the bank probably will (should) show the gross amount and the fee amount.
So we enter this in the bank statement:

03/31/2014/Algemeen228200 Betaalwijze Creditcard 291.78Aanmaken

03/31/2014/Algemeen455500 Provisie betaalmethoden-8.61Aanmaken

03/31/2014/Algemeen228200 Betaalwijze Creditcard 402.15Aanmaken

03/31/2014/Algemeen455500 Provisie betaalmethoden-11.86  

This way your bank statement will match and the correct accounts will de debited/credited.

I hope this helps until the automation pops up. ;-)

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/20/14, 12:50 PM
Seen: 2402 times
Last updated: 3/16/15, 8:10 AM