| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 5171 |
| Technical Name |
softeam_smart_reconcile |
| License | OPL-1 |
| Website | https://softeamg.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 5171 |
| Technical Name |
softeam_smart_reconcile |
| License | OPL-1 |
| Website | https://softeamg.com |
| Versions | 16.0 17.0 18.0 19.0 |
Reconcile bank statements automatically — with confidence
Smart Reconciliation matches bank lines to the right invoices using fuzzy partner matching, amount & reference detection — each suggestion carries a confidence score, and high-confidence matches reconcile automatically via a scheduled job. Optional AI sharpens the tricky ones.
1 Import statementsAs usual, any bank. |
2 Smart matchPartner, amount, reference, fees. |
3 Auto-reconcileAbove your threshold, hands-free. |
4 LearnFeedback improves scoring. |
It catches what manual rules miss
🔤 Fuzzy partner matchingJaro-Winkler, n-gram & trigram index. |
💶 Amount matchingConfigurable absolute & % tolerance. |
🔎 Reference detectionSEPA, SWIFT & generic references. |
🤖 AI enhancementOptional OpenAI / Gemini boost. |
🎯 Confidence scoringEvery suggestion scored 0–100%. |
⏱️ Batch cronAuto-reconcile above threshold. |
💳 Fee profilesPayPal, Stripe & other fees handled. |
➗ Partial & groupedInstallments & many-invoice payments. |
🧠 Machine learningImproves confidence from feedback. |
Good to know
No. The fuzzy/amount/reference engine works on its own; AI (OpenAI or Gemini) is optional and only sharpens the hardest matches.
Only matches above your auto-threshold (default 90%) reconcile automatically; the rest are proposed for review (default 55%+).
Fee profiles (PayPal, Stripe…), partial/grouped payment detection and duplicate-import flagging are built in.
Odoo 16 · 17 · 18 · 19 — Community & Enterprise.
Buy & install directly from this Odoo Apps page.
Smart Reconciliation
Automatically reconcile bank statements with invoices using intelligent matching algorithms.
Installation
- Download the module from the Odoo Apps Store
- Place it in your addons folder
- Update the apps list: Apps > Update Apps List
- Install the module: Search for "Smart Reconciliation" and click Install
Configuration
Navigate to Accounting > Configuration > Settings and scroll to the Smart Reconciliation section.
Thresholds
- Auto-Reconciliation Threshold (default: 90%): Minimum confidence score for automatic reconciliation without user confirmation
- Suggestion Threshold (default: 55%): Minimum confidence score to display a suggestion
Matching Parameters
- Amount Tolerance: Absolute tolerance in currency units (e.g., 0.02 = 2 cents)
- Fuzzy Match Threshold (default: 65%): Minimum similarity for partner name matching
AI Configuration (Optional)
Enable AI-powered matching when fuzzy algorithms need assistance:
- Enable AI Matching
- Select provider: OpenAI or Google Gemini
- Enter your API key
- Set AI Activation Threshold (default: 70%): AI is used when fuzzy score is below this value
Usage
Automatic Analysis
A scheduled job runs every hour to analyze unreconciled bank statement lines:
- Extracts partner names from statement labels
- Detects invoice/order references
- Matches against open invoices by amount, partner, and reference
- Creates suggestions with confidence scores
- Auto-reconciles high-confidence matches
Manual Analysis
- Go to Accounting > Bank > Bank Statements
- Select unreconciled lines
- Click Action > Smart Analyze
- Review suggestions in Accounting > Reconciliation > Smart Suggestions
Reviewing Suggestions
Each suggestion shows:
- Statement Line: The bank statement entry
- Suggested Partner: Detected partner
- Suggested Invoice: Matched invoice (if found)
- Confidence Score: Match quality (0-100%)
- Match Reasons: Breakdown of scoring factors
Actions:
- Apply: Accept the suggestion and reconcile
- Reject: Dismiss the suggestion
- Apply All Best Matches: Bulk apply all #1 ranked suggestions
Scoring Algorithm
The confidence score is calculated from four factors:
| Factor | Weight | Description |
|---|---|---|
| Amount Match | 35% | Exact match within tolerance |
| Partner Match | 35% | Fuzzy matching on partner name |
| Reference Match | 20% | Invoice/order reference found |
| Date Proximity | 10% | Days between statement and invoice |
Supported Documents
- Customer Invoices (incoming payments, positive amounts)
- Vendor Bills (outgoing payments, negative amounts)
- Customer Credit Notes (outgoing refunds, negative amounts)
- Vendor Credit Notes (incoming refunds, positive amounts)
Troubleshooting
No suggestions generated
- Check that the statement line is not already reconciled
- Verify there are open invoices in the system
- Lower the suggestion threshold in settings
Low confidence scores
- Ensure partner names in Odoo match bank statement labels
- Add partner bank accounts for better matching
- Enable AI enhancement for complex cases
AI not working
- Verify API key is correct
- Check API quota/limits
- Review Odoo logs for error messages
Support
For support, please contact: support@softeamg.com
Changelog
Version 1.0.0
- Initial release
- Fuzzy partner matching
- Amount and reference matching
- AI enhancement (OpenAI/Gemini)
- Batch processing with cron job
- Multi-document support (invoices, bills, credit notes)
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
There are no ratings yet!