Loading page...Загружаем страницу...正在加载页面...
AtlasRepo

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