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.
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 |