How do I enter/record payments from Customers when I don't know exactly how much I will get until I see the Bank Deposit?
We are currently trying to reconcile some payments we receive from customers via credit card.
In this scenario, we have been invoicing the customer an additional 3% fee if they choose to pay by credit card.
When the customer pays, the credit card processor subtracts their fee and deposits the remainder into our bank account.
The problem is, the deposit amount in the bank statement doesn’t match the invoice amount.
What is the proper way to conduct this transaction in Odoo?
For example, we invoiced a Customer for $100 of products and the additional CC processing fee was calculated to be 3% or 3$ - so we invoiced them a total of $103.
The customer paid the full amount due, $103, via credit card.
The credit card processor then sent us a receipt saying we “received” $103, but they only deposited $100 into our bank account.
So the CC processor charged a fee of $3 for this transaction.
However, the line item in our bank statement will show a deposit for $100, and the invoice we sent the customer will show $103(paid in full), but the bank reconciliation system won’t match the two up because they’re different amounts.
Also, there is no entry in Odoo for the $3 we paid the CC processor.
This is just a simple example, sometimes the charge is 2.5%, 2.8%, 3.1% - so sometimes we make a little on these transactions and other times we lose a little - so we can't predict the amount - rewards cards get charged higher than others - if we swipe the card it is cheaper than entering the number by hand - if we use CVV instead of address, it is cheaper to process, etc.