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.

Question

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