Reconcile Bank Transactions
reconcile_bank_transactionsMatch bank transactions to open invoices, dry-run and execute auto-confirmations, and detect and reconcile inter-account transfers.
Instructions
Merged bank reconciliation entry point. Use mode='suggest' for invoice-match suggestions, mode='dry_run_auto_confirm' or mode='execute_auto_confirm' for exact invoice matches (confidence >= 90, or the ref_number_exact rule: the reference of exactly one open unpaid EUR invoice + the exact EUR amount + a proven direction matching the invoice kind; such rows keep their lower confidence and carry auto_confirm_rule), mode='inter_account_dry_run' for own-account transfer detection, and mode='execute_inter_account' (REQUIRES the plan_handle from the dry run) to reconcile the reviewed inter-account transfers.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | Workflow phase to run. Defaults to suggest. | |
| plan_handle | No | Execution-plan handle from the reviewed dry run. Required for mode='execute_auto_confirm' and mode='execute_inter_account', and forwarded to the executor. | |
| max_date_gap | No | Maximum days between inter-account transfer legs (default 1, max 31). | |
| min_confidence | No | Minimum confidence threshold for invoice matching modes (auto-confirm default 90). Above 90 also disables the ref_number_exact rule. | |
| block_on_duplicate | No | For the invoice-matching modes (suggest / dry_run_auto_confirm / execute_auto_confirm): refuse (or, in suggest, flag) an exact match whose cash movement appears already booked by another journal. Default false = advisory only. | |
| delete_proposed_mirrors | No | Inter-account only, opt-in: bind each proposed mirror deletion (a PROJECT row already journalized from the other account side) into the dry-run plan; execute deletes only rows still matching the reviewed identity. Resend the same value at execute. | |
| target_accounts_dimensions_id | No | For inter_account_dry_run one-sided transfers, specify the target bank account dimension ID when it cannot be inferred. |