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
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.78
03/31/2014/Algemeen455500 Provisie betaalmethoden-8.61
03/31/2014/Algemeen228200 Betaalwijze Creditcard 402.15
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. ;-)
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/20/14, 12:50 PM|
|Seen: 1516 times|
|Last updated: 3/16/15, 8:10 AM|