Import a bank statement
books_import_bankRead a bank statement from the file store onto a bank account (default the bank account): CSV as the bank exports it, CAMT.053 (.052, .054) or OFX/QFX. CSV columns are found by their headers in several languages; when they aren't, name them with columns. Lines imported before are skipped, so overlapping statements are fine. Each line then waits in books_bank_lines to be matched. Charged per line added. Free.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_id": "<file_id>"
},
"name": "books_import_bank"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | No | An account code from the chart, e.g. "6600". | |
| columns | No | CSV header names, e.g. {"date": "Buchungstag", "amount": "Betrag", "description": "Verwendungszweck"}. money_in and money_out are for files with two amount columns; direction for a debit/credit marker column. | |
| decimal | No | The CSV's decimal mark. | |
| file_id | Yes | A file_id from the file store. | |
| currency | No | The statement's currency when the file doesn't say. Default the base currency. | |
| max_lines | No | The most lines this call may add (and hold the price for). | |
| date_format | No |