Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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. ;-)
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/20/14, 12:50 PM|
|Seen: 1815 times|
|Last updated: 3/16/15, 8:10 AM|