Cash Application Matcher
Import remittance advices and auto-match bulk receipts to customer invoices
Reconciling bulk customer receipts against open invoices is slow and error-prone when a single payment arrives with a remittance advice listing dozens of invoices, part-payments and short-pay deductions. Odoo's native reconciliation has no remittance import. This module ingests the remittance advice, fuzzy-matches every line to the right invoice, and posts the customer payment with full allocation — turning a painful month-end task into an auditable cash-application run.
Key Features
Remittance Import
Paste or upload a remittance advice as CSV. The module parses every remittance line ready for matching — no re-keying.
Fuzzy Matching Engine
Exact match on invoice number/reference, normalised match (strips prefixes, leading zeros, punctuation and case), and similarity scoring (token + sequence ratio) with a configurable confidence floor.
Amount-Aware Allocation
Tolerates short payments and deductions within a configurable threshold, and supports full or partial allocation across the matched invoices.
Deduction Write-Off
Books configured deduction / write-off amounts to a dedicated account so the receipt fully clears even when the customer short-pays.
Reviewable Batches
Matched lines roll up into a cash-application batch you can review and adjust before posting. The batch creates the customer payment and allocates it across invoices in one step.
Scoring & Exceptions
A per-line scoring breakdown and an exception list make every match transparent and auditable, so unmatched or low-confidence lines are easy to triage.
Screenshots
Cash Application Batches
Configurations
Import Remittance
Why Choose This Module
Native reconciliation cannot ingest a remittance file or match fuzzily across short-pays and deductions. This module adds exactly that layer on top of Odoo Community accounting — no external service, no data leaves Odoo.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: account
- Support: support@pokutsoft.com
Update date: 2026-07-02