Two tables → what does not match (the VLOOKUP job), with the arithmetic proof
reconcile_ledgerReconciles two sets of records — your books against a bank, platform, or supplier statement. Matches rows on a key column, compares an amount column, and returns three lists: only in A, only in B, and same key but different amount. Amounts are compared in integer cents, so 0.1 + 0.2 never invents a phantom difference for someone to chase. The response also proves the result: the listed differences are re-added and must equal the gap between the two totals, checked in code. Use for month-end close, platform payouts vs orders, or any "these two numbers should agree and do not" problem. This is the job people do by hand with VLOOKUP or a groupby and then cannot prove they got right.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | Yes | Column name to match rows on, e.g. order_id. | |
| url_a | No | Link to side A (e.g. your books). | |
| url_b | No | Link to side B (e.g. the statement). | |
| amount | Yes | Numeric column to compare, e.g. amount. | |
| text_a | No | Or the CSV content of side A directly. | |
| text_b | No | Or the CSV content of side B directly. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||