Reconciliation model setup

1. Create the reconciliation model under Accounting > Configuration > Reconciliation Model

2. Create a reconciliation model named Factoring Fee.

rule to match invoice or bill

-2% payment tolerance

-Set counterpart entry with defined account

-Auto-validate: checked box

Workflow

1. Create an invoice for $12100.

2. Register payment of $12100 (attached to the invoice)

3. Create a bank statement line of $11858.

Calculation:

12100 *2% = 242

12100-242 = 11858 (Bank statement deduct 2% factoring fee)

Reconciliation model – Factoring fee 2% tolerance (able to match 12100 with 11858 (2%)

4. When clicking on the bank statement line, Odoo automatically suggests the $12100 and billed 2% to the factoring fee.

5. Since we have an auto-validate checked box, Odoo will automatically match/reconcile the bank statement line $11858.

If we remove the 'not matched' filter, we can see the bank statement line $11858.

Video:

https://drive.google.com/file/d/15RwhXvpd24y3QPTya9Ey-tKgMtvP5oxj/view