banking-addons-drivers team mailing list archive

[Bidoul, Stéphane <stephane.bidoul@xxxxxxxxx>]

Hi Joël,

In our experience, the characteristic of eCommerce (or electronic) payments
is that we typically have one line on the bank statement for many customer
payments.

In this case, the number of lines on the bank statement itself remains
reasonable, but there is high volume many2one reconciliation to be done
with the help of an additional file relating bank statement lines and card
payments.

We have done it this way (I think it's similar to what you suggest):

   1. when requesting the payment of the invoice to the electronic payment
   company, create a move to a transfer account and reconcile the invoice (N)
   2. when receiving the bank statement for eg a batch of VISA payments,
   create a move from the bank account to the transfer account (1); we
   typically have one per day per card type
   3. when receiving the payment details from the electronic payment
   company, load these references in a separate table; this table typically
   contains references between the communication in (1) and the order
   references in (N), plus the fees
   4. run a reconciliation job that matches moves lines on the transfer
   account with the help of the table from 3.; this job also creates the moves
   for the fees

1. is reminiscent of account_banking_payment_transfer (not sure how it is
done with the electronic payment interface of 8.0, I'll need to look it up).

2. is a bank statement operation button in 8.0 and/or a statement
completion rule.

3. and 4. could be a useful generic module in bank-statement-reconcile.

-sbi