Accounts payable control
Vendor Bill Match Check
A three-way match between purchase order, receipt and vendor bill, with a quantity and a price tolerance per company and one exception list to work through before you pay.
Odoo 16.0Odoo 17.0Odoo 18.0Odoo 19.0Odoo 20.0CommunityEnglish / Arabic
Every mismatch on one screen, before payment.
01 The problem
What this fixes
Bills post whether they match or not
A vendor bill that charges for more than was ordered or received, or at a higher price, posts like any other.
Checking means opening every bill
Without a report, finding the overbilled lines means comparing each bill with its order and its receipt by hand.
Nothing shows who checked
When a difference is accepted, there is no record of who looked at it or when.
02 How it works
From setup to daily use
Set the tolerances, post, then work the exception list.
Screenshots taken on a running Odoo 18.0 database with the module's demo data.
1Set two tolerances once
Quantity and price tolerances, set once per company in the Invoicing settings.
2Post the bill as usual
A posted vendor bill with a mismatch, and the exception count on the bill itself.
3Every exception in one list
Exceptions of every type in one list, with ordered, received and billed quantities and the variance.
4Open one to see both sides
Ordered, received and billed quantities, and the unit price on each side.
5Group it before you pay
The same list grouped by exception type: the report to read before a payment run.
6A clean bill stays quiet
A bill that matched. The smart button is absent because there is nothing to report.
7Arabic, right to left
The exception list for a user working in Arabic.
03 Features
What is in the module
What ships in the module.
Checked on post
Every vendor bill and vendor refund is checked when it is posted, and again whenever someone presses Check bill match.
Five exception types
Billed over received, billed over ordered, price over ordered, no purchase order, not received.
Both sides on every row
Ordered, received and billed quantity, ordered and billed unit price, and both variances.
Company tolerances
A quantity tolerance in units and a price tolerance in percent. A difference inside them is not reported.
Count on the bill
A smart button on the vendor bill shows how many exceptions it has.
List and pivot
Grouped by exception type or vendor, filtered to unresolved by default.
Resolved, with a name on it
Resolve records who acknowledged the row and when. A later re-check keeps that resolution.
No duplicates
Re-checking updates the existing rows in place.
The bill is never edited
No field on the bill, its lines or its journal entry is written by the module.
Currency mismatch flag
When bill and order are in different currencies, the price comparison is skipped and the quantity check still runs.
Multi-company
Record rules keep each company to its own exception rows.
Arabic interface and guides
Arabic, right to left, plus business and technical guides in English and Standard Arabic.
04 Configuration
Set it up in five steps
05 Compatibility
Versions, editions and languages
| Odoo | Community | Enterprise |
|---|---|---|
| 20.0 | Tested | Not tested |
| 19.0 | Tested | Not tested |
| 18.0 (this page) | Tested | Not tested |
| 17.0 | Tested | Not tested |
| 16.0 | Tested | Not tested |
| Odoo Online | Not supported | |
Tested: Each series is installed and runs the module's own test suite on a real Community database of that version, with no failures and no errors. The module has no Enterprise dependency, but no Enterprise database was part of those runs.
Depends on: account, purchase, stock. Standard Odoo modules only, no OCA modules, no external library.
Languages: English, and a complete Arabic translation of the interface (i18n/ar.po).
Guides: A business guide and a technical guide, each in English and Standard Arabic, in the module's doc/ folder.
License: Odoo Proprietary License v1.0 (OPL-1).
Before you buy
Odoo Online is not supported. The module carries custom Python code, which Odoo Online does not accept. It runs on Odoo.sh and on self-hosted Odoo.
Posting is never blocked. Posting a bill is never blocked or delayed, and there is no approval step. If you need bills held for sign-off, this module is not that.
Single-currency comparison. Prices are not converted between currencies. A line in a different currency from its order is flagged and its price is not compared.
Resolving needs Accounting Manager rights. Invoicing users see the count and the list and can re-run the check. Marking a row resolved is kept to the manager group.
06 FAQ
Common questions
Does it stop a mismatched bill from being posted?
No. The bill posts as usual and the mismatch appears in the exception list, so nothing in your payables flow waits on this module.
What exactly do the tolerances do?
A billed quantity is reported once it exceeds the ordered or received quantity by more than the quantity tolerance. A billed unit price is reported once it is higher than the ordered price by more than the price tolerance percentage.
Does re-checking a bill undo a resolution?
No. Rows are matched back to their bill line, so a resolved row stays resolved when the same mismatch is found again.
What happens with a bill line that has no purchase order?
It becomes its own exception, No Purchase Order, so an unlinked line never drops out of the report.
Does it work on Odoo Online?
No. Use Odoo.sh or a self-hosted install.
07 Support
Built and supported by Mohamad Fayad
Odoo backend developer, Abu Dhabi. Four years building custom Odoo for government, non-profit and private-sector clients in the UAE (Python, XML, JavaScript and PostgreSQL), currently leading the technical side of an Odoo 16 to 19 migration. FYD is his practice: every module under it is written and maintained by one developer.
Support is answered in English and Arabic during Gulf hours. If something on this page is missing or does not work as described, that is covered by the store's refund window.
Questions before or after you buy: support@mohamadfayad.com
08 Changelog
Changes on 18.0
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Discuss (mail) |
| Lines of code | 968 |
| Technical Name |
fyd_bill_match |
| License | OPL-1 |
| Website | https://mohamadfayad.com |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module