What is the scope ?

Sometimes, our customers are debited thanks to the SEPA Direct Debit (SDD).

Once we send the SEPA xml file to the bank, the bank will retrieve the money from the customer. Later, in our bank statement, we will notice the incoming amount from the customer and we will be able to reconcile the SEPA incoming payment with the related bank statement.

It can happen that our customer doesn’t have enough money in his own bank account once the money is retrieved. Therefore, as the bank already forwarded the money on our bank account, it will reject the SEPA payment and will take back the money on our bank account. We will see on our bank statement a negative amount which has been taken away from us. :’(

How to handle this use case inside Odoo ?

After the creation of the customer invoice, thanks to the mandate, we create a SEPA payment file to retrieve the money from our customer. The customer invoice is then reconciled with the SEPA incoming payment and the payment status of the invoice is “In payment”.

The first bank statement arrives and we are able to reconcile the payment with the transaction, meaning that the payment status of the invoice is now on “Paid” and the SEPA incoming payment is now linked to a statement.

In a short period of time, the second bank statement arrives with the SEPA rejection. First thing to do, as the invoice has not been paid in the end, we need to reopen it by clicking on the button “Unreconcile” of the payment widget in the invoice (see screenshot above). The payment status of the invoice will come back in “Not paid”. Regarding this second statement, we will reconcile the transaction with the related partner on the receivable account in the manual operations (by default, as it’s an ongoing payment, Odoo will propose the payable account). 

Last thing to do, we need to reconcile the credited receivable account of the first SEPA payment journal entry with the debited one of the last bank reconciliation entry. We can reconcile inside the partner ledger under the Accounting menu.

To summarize, our initial invoice remains open, all our bank transactions are reconciled and the journal items with the receivable account in the incoming SEPA payment and SEPA rejection are reconciled as well. 

Please find the demo in this video : https://watch.screencastify.com/v/HXnb7R6GLmYkRtYlWfmQ