Skip to Content

Smart Reconciliation

by
Odoo

$ 114.45

v 18.0 Third Party
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Lines of code 1810
Technical Name softeam_smart_reconcile
LicenseLGPL-3
Websitehttps://softeamg.com
Versions 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Lines of code 1810
Technical Name softeam_smart_reconcile
LicenseLGPL-3
Websitehttps://softeamg.com
Versions 16.0 17.0 18.0 19.0

Smart Bank Reconciliation

AI-powered automatic bank statement reconciliation

Fuzzy Matching

Intelligent partner detection from bank statement labels using advanced text similarity algorithms.

Reference Extraction

Automatically extracts invoice numbers, order references, and contract IDs from statements.

AI Enhancement

Optional integration with OpenAI or Google Gemini for improved accuracy on complex cases.

Confidence Scoring

Each suggestion includes a confidence score to help you prioritize and review matches.

How It Works

  1. Analysis: The module analyzes each unreconciled bank statement line
  2. Extraction: Partner names and references are extracted using pattern matching
  3. Matching: Open invoices are matched by amount, partner, and reference
  4. Scoring: Each match receives a confidence score (0-100%)
  5. Auto-reconcile: High-confidence matches are automatically reconciled
  6. Review: Lower-confidence suggestions are presented for manual review

Supported Document Types

Document Type Direction Amount Sign
Customer Invoice Incoming payment Positive (+)
Vendor Bill Outgoing payment Negative (-)
Customer Credit Note Outgoing refund Negative (-)
Vendor Credit Note Incoming refund Positive (+)

Scoring Algorithm

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
AI Enhancement (Optional)
When the fuzzy matching score is below 70%, the module can use AI (OpenAI GPT or Google Gemini) to improve partner detection and reference extraction. This is completely optional and only activates when API keys are configured.

Configuration

Navigate to Accounting > Configuration > Settings and find the Smart Reconciliation section:

Setting Default Description
Auto-Reconciliation Threshold 90% Minimum score for automatic reconciliation
Suggestion Threshold 55% Minimum score to create a suggestion
Amount Tolerance 0.02 Absolute tolerance in currency units
Fuzzy Match Threshold 65% Minimum similarity for partner matching
AI Provider - OpenAI or Google Gemini (optional)

Features

Fuzzy Matching Reference Extraction Confidence Scoring Batch Processing Cron Job AI Enhancement Multi-currency Credit Notes

Requirements

  • Odoo 16.0 / 17.0 / 18.0 / 19.0 (Community or Enterprise)
  • Accounting module installed
  • Optional: OpenAI or Google Gemini API key for AI enhancement

Support

For support, feature requests, or bug reports, please contact us at support@softeamg.com

Smart Reconciliation

Automatically reconcile bank statements with invoices using intelligent matching algorithms.

Installation

  1. Download the module from the Odoo Apps Store
  2. Place it in your addons folder
  3. Update the apps list: Apps > Update Apps List
  4. 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:

  1. Enable AI Matching
  2. Select provider: OpenAI or Google Gemini
  3. Enter your API key
  4. 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:

  1. Extracts partner names from statement labels
  2. Detects invoice/order references
  3. Matches against open invoices by amount, partner, and reference
  4. Creates suggestions with confidence scores
  5. Auto-reconciles high-confidence matches

Manual Analysis

  1. Go to Accounting > Bank > Bank Statements
  2. Select unreconciled lines
  3. Click Action > Smart Analyze
  4. 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)

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.