The problem
Bank reconciliation is matching free text to records. The payer writes the reference wrong, abbreviates the company name, pays two invoices at once, or pays a slightly different amount. Exact-match rules clear the easy lines and leave the rest to a person.
How it works
The bank transaction's description and amount go into the where clause, and _predict of invoice_id follows the schema link to the invoices table, limited to the open ledger. The candidates come back ranked, and $why highlights the tokens that carried the match: a reference number, a company name, the amount.
The demo blends Aito's probability with a plain amount check before deciding what to auto-match, suggest, or leave unmatched. Only the confident matches post without review.
For the full architecture, see the technology overview. For the broader narrative across multiple use cases, read The Predictive Application.
See it live
This use case runs in the 🧾 Accounting demo today. Click through to the live application and inspect the queries that produce the result.
