reconcile_movements
Matches bank movements from Norma 43 files or lists to expected invoices or ledger entries, scoring confidence and evidence for 1:1, grouped, and partial payments.
Instructions
Bank reconciliation (conciliación bancaria): match bank movements to expected items, deterministically.
Bank side: a Norma 43 file (content / content_base64) or a movements list of
{id, date, amount, text}. Expected side: expected list of {id, date, amount, reference?, counterparty?}
such as issued invoices (+, cobros), supplier invoices or payroll (-, pagos), or ledger entries.
Signs: + is money in, - is money out, as on the statement.
Finds 1:1 matches, one transfer paying several invoices (1:N) and partial payments (N:1). Each match
has a 0-100 score, a confidence (alta/media/baja) and the evidence used (amount, invoice reference found
in the bank concept, counterparty name, date distance, uniqueness). Ties are never guessed: they are
returned under ambiguous. Weak candidates go to suggestions. Group matches require a unique exact
sum plus reference or name evidence.
Args:
expected: Items to find in the bank (max 5000).
content: Norma 43 file as text (alternative to movements).
content_base64: Norma 43 raw bytes as base64.
movements: Bank movements if you do not have a Norma 43 file (max 5000).
date_window_days: Max days between bank date and item date (default 10, max 180).
amount_tolerance: Max amount difference accepted, e.g. "0.50" for bank fees (default "0", max "10").
max_group_size: Max items combined in 1:N / N:1 matches (1 disables grouping, max 5).
min_score: Minimum score to confirm a match (default 50).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| content | No | ||
| expected | Yes | ||
| min_score | No | ||
| movements | No | ||
| content_base64 | No | ||
| max_group_size | No | ||
| amount_tolerance | No | 0 | |
| date_window_days | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||