match_bank_csv_to_vouchers
Matches bank statement CSV transactions to Lexware vouchers using exact amount and date tolerance, streamlining reconciliation.
Instructions
Parses a bank statement CSV (date + EUR amount columns) and matches each transaction against Lexware vouchers by exact amount and a date-tolerance window. Fetches the voucher list itself (paginated, date-range padded by the tolerance). Narrow voucherType/voucherStatus (comma-separated, e.g. "purchaseinvoice" + "open,paid") when reconciling a specific category — the underlying /voucherlist endpoint refuses to traverse beyond 10,000 matching entries, so split by date range or narrow the filters if that happens.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csvContent | Yes | Raw bank statement CSV content | |
| voucherType | No | Comma-separated types (e.g. salesinvoice, purchaseinvoice, invoice, creditnote) or the wildcard "any". Defaults to "any". | |
| voucherStatus | No | Comma-separated statuses (e.g. open, paid, voided, transferred, draft) or the wildcard "any". Defaults to "any". | |
| dateToleranceDays | No |