Every time I receive a bank statement, the bank will take a 2% fee. I would like to automate the process where Odoo pulls the original payment and bills the 2% to the defined fee account.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilitat
- Inventari
- PoS
- Projectes
- MRP
This question has been flagged
1
Respondre
4487
Vistes
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
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se| Related Posts | Respostes | Vistes | Activitat | |
|---|---|---|---|---|
|
2
d’oct. 25
|
10040 | ||
|
|
1
de des. 24
|
6048 | ||
|
|
1
de set. 23
|
2654 | ||
|
|
1
de febr. 25
|
4097 | ||
|
|
1
de nov. 25
|
7434 |
