bokio_reconcile_bank
Read-only
Matches bank statement rows to ledger lines by exact amount within a date tolerance and returns matched pairs, unmatched items, duplicate suspects, and totals.
Instructions
Match bank statement rows against one ledger account by exact amount within toleranceDays, reading the SIE export itself; rows in date order each take the earliest unmatched ledger line within toleranceDays, each ledger line once. Returns matched pairs, unmatched rows on both sides, suspected duplicate ledger lines and totals, where difference = ledger minus bank. Amounts in ledger sign: debit positive, credit negative.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | Bank statement rows; amounts in kronor with at most two decimals, outflow negative. | |
| account | No | Ledger account to match; default 1930 (bank). | |
| companyId | No | Bokio company id. Defaults to BOKIO_COMPANY_ID if omitted. | |
| toleranceDays | No | Max days between a bank row and its ledger line; default 3. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | ||
| from | Yes | ||
| account | Yes | ||
| matched | Yes | ||
| bankTotal | Yes | ||
| difference | Yes | ||
| ledgerTotal | Yes | ||
| unmatchedBank | Yes | ||
| unmatchedLedger | Yes | ||
| suspectedDuplicates | Yes |