Introduction
Odoo Automatic Invoice Reconciliation helps businesses match customer payments with invoices automatically.
It removes the need for manual payment matching and keeps accounting records clean and accurate.
Moreover, when an invoice is confirmed, the module applies available customer credits on its own. This saves time, reduces mistakes, and makes daily accounting work easier.
As a result, users can focus on more important tasks while the system handles reconciliation in the background. It also allows flexible matching methods to suit different business needs.
Features
- Odoo Automatic Invoice Reconciliation matches customer payments with invoices automatically
- Applies customer credits automatically when invoices are confirmed
- Reduces the need to match payments with invoices by hand
- Saves time for accountants and other users
- Supports using the oldest available payment first
- Supports matching payments only when the amount is exactly the same
- Allows partial payment matching when full payment is not available
- Works automatically in the background without user effort
- Keeps customer accounts clean, clear, and accurate
Installation
- Once you purchase the App from Webkul store, you will receive a link to download module’s zip file.
- Extract the file on your system after download finishes. As a result, you will be able to see a folder named- ‘wk_account_automatic_reconcile’
- Copy and paste this folder inside your Odoo Add-Ons path.
- Now, open Odoo App and click on the Settings menu. Here, click on Activate Developer Mode.
- Then, open Apps menu and click on ‘Update Modules List.’
- In the search bar, remove all the filters and search ‘wk_account_automatic_reconcile’
- You will be able to see module in the search results. Click on ‘Activate’ to install it.
Workflow
1. After installing Odoo Automatic Invoice Reconciliation, navigate to Settings and enable the preferred auto-reconciliation method.
You can select Exact Amount Match or Oldest Payment First as needed.


2. Next, go to Invoicing → Customers → Credit Notes. Here, you can view the list of pending customer credit notes available for reconciliation.

Exact Amount Match only
3. When Exact Amount Match is enabled, the system looks only for a customer credit with the same amount as the invoice. You can see the pending credit note with the exact amount in the list.
4. You can see the pending credit note here.

5. Now, go to the customer invoice and confirm it. As a result, the matching credit amount is applied automatically, and the invoice amount is adjusted.


6. After confirmation, check the customer credit notes again. You will see that the exact amount credit has been used and updated correctly.


Oldest Payment first:
7. In this method the oldest customer credit will be fetched and amount will be received, moreover the pending amount will also be adjusted in other payments.
8. For this you can see the list of pending customer credits in the list

9. Now, again we go to the customer invoices and confirm the payment.


10. Now, with the help of the Automatic Invoice Reconciliation module, enable the Oldest Payment First option. As a result, the system automatically adjusts the available customer credits.

11. Next, you can clearly see that the system settles the oldest payment first. After that, it partially adjusts the remaining amount using the available customer credits.

12. Finally, the system shows the partially adjusted amount and automatically updates the remaining due balance, which is reflected correctly in the customer credit notes.

Need help?
Hope you find guide helpful! Please feel free to share your feedback in the comments below.
If you still have any issues/queries, please create a ticket at the UV Desk.
I hope this helps. In case of any further queries, contact us at our support mail.
Thanks for paying attention!!
Current Product Version - 1.0.0
Supported Framework Version - Odoo V19, V18, V17

Be the first to comment.