Our Cash Matching Reached Ninety Two Percent by Guessing Which Invoice Customers Meant
说明与用途
通过使用回退规则,自动匹配率达到92%,但导致错误。删除规则并加入人工审核后,自动匹配率恢复到79%,错误率低于1%。
问题
Automating the matching of bank transfer payments to invoices was difficult because payment references were inconsistent, leading to a low initial match rate of about seventy percent.
结果
The fallback rule temporarily boosted the automatic match rate to 92% but introduced a high error rate. Removing the rule and adding manual review restored accuracy, achieving a 79% automatic match rate with less than 1% wrong matches, improving credit control efficiency.
工作流
- 1. Read bank statement each morning. 2. Search payment reference for invoice numbers. 3. Allocate payment to matching invoice. 4. If no reference matches, apply fallback: assign to oldest open invoice with same amount. 5. Audit fallback matches; identify incorrect allocations. 6. Remove fallback rule. 7. For unmatched payments, present candidate invoices to a person for manual review. 8. Report three metrics: automatic matches, manual matches, and wrong matches (sampled).
证据
At first the rate was about seventy percent, because references are messy.
The most effective rule was a fallback. If no reference matched, take the oldest open invoice for that customer with exactly the same amount.
When we audited a sample of fallback matches, about one in five had gone to the wrong invoice.
The automatic rate is now seventy nine percent, and the wrong rate is below one percent.
- 记录日期: 2026-11-01T18:58:51.822Z