Using EE v15
I have a custom payment acquirer for our eCommerce website. The payment gateway provider charges a fee per transaction which is applied per line item (transaction).
I have created a journal for this acquirer as well as a bank/cash account. All website payment transactions are posted to this payment acquirer bank/cash account.
There are various withholding rules that the payment gateway provider applies and then releases available funds to our (real) bank account on a daily basis. The amount deposited is an amount net of all fees and there is no matching batch available from the payment gateway provider.
What is available is a mini statement with starting balance, daily ins (website order payments) & 1 x out (deposits into our bank account mentioned above) with a closing balance which represents the total of funds still due to us.
The mini statement has a date, gross value, fee value and net amount per payment together with label info that can be used for transaction matching.
I want to upload the payment gateway mini statements to the payment acquirer bank/cash account I have created and match it to the payments registered in Odoo by the payment acquirer on the website. The payment from the website are gross (invoice) payments made by customers.
How do I do this? e.g.
Website sale of $100 including taxes, payment of $100 registered by payment journal
Uploaded mini statement will have
Funds received form Party xyz, gross $100, Fees $5, Net $95
I want the net amount to remain in the account and the fees to be posted to a fees account.
Once these payments are all matched & posted I need to reconcile the real bank receipts (deposits from the payment gateway provider @ net value) to the payment acquirer bank/cash account and the remaining balance should then match the closing balance on the mini statement e.g.
Am assuming I would do the last step as a manual real bank statement reconciliation to the payment acquirer bank/cash account.
I hope this makes sense and someone can show me the way!
