Guide / Copilot for Odoo / Write
Import statements
Attach your bank statement (Norma 43, CSV or Excel) and the Copilot creates it in Odoo, in the bank journal you choose, unreconciled. First it checks the currency, the account, the balances and that the statement isn't already imported.
Requirements
| Plan | Copilot for Odoo: Pro, Team or Business. |
|---|---|
| Permission in Conectores ERP | Importar extractos (Import statements): «Preguntar» (Ask) or «Bloquear» (Block), never «Permitir» (Allow). By default, Preguntar. |
| Your Odoo user | In Odoo 19, the Basic accounting group (account.group_account_basic) or the accountant one, «Show Full Accounting Features» (account.group_account_user). With only Invoicing, Odoo lets you read statements but not create them. |
| In Odoo | A Bank journal in the same currency as the statement. If the statement is Norma 43, the journal should have its bank account (IBAN) so the Copilot can check it's the same one. |
Important: In Odoo Community, the Basic group doesn't show on the user form until you activate developer mode (Settings → Activate the developer mode). Then, in Settings → Users, open the user and add the group. If you don't see it, ask your Odoo partner.
What it does
- You attach the file and say which journal to import it into (otherwise, the Copilot asks you).
- Conectores ERP reads the transactions in the file with code, not with AI: dates, signed amounts, descriptions and, from Norma 43, the account and the opening and closing balances.
- It checks the file against the journal (see the table) and, if everything adds up, shows you the card.
- When you approve, it checks the journal and the duplicates again and creates the statement with its lines, with your Odoo user.
- Reconciliation comes afterwards: in Odoo, or with the Copilot (match the statement and register the payments).
How to use it
- Import this statement into the Banco Santander journal
- Import the October statement (attached as CSV) into the BBVA bank, it's in euros
Checks
| Check | If it fails |
|---|---|
| The journal exists, is a bank journal and your Odoo user can see it. | Not proposed. |
| The file currency is the journal currency (Norma 43 includes it; CSV and Excel are taken as euros unless you say otherwise). | Not proposed. |
| Norma 43 with a single account, and that account within the journal's IBAN. | Several accounts or a different account: not proposed. Journal without an account: warning on the card. |
| Opening balance + transactions = closing balance of the file. | Not proposed: the file doesn't add up. |
| The opening balance of the file is the closing balance of the journal's last statement. | Warning on the card (Odoo will mark the statement as invalid). |
| Transactions already imported (same date, amount and description). | All of them: not proposed. Some: the Copilot asks whether to import only the missing ones (without the file's balances). |
| At most 500 transactions. | Not proposed: split the file. |
The approval card
- The journal (and its company), the period and the number of transactions.
- The total money in and money out, and the opening and closing balances (or «Los calcula Odoo (el archivo no los trae)», meaning Odoo calculates them because the file doesn't include them).
- The transactions: date, description, partner (only if it matches an open invoice) and amount; the first 50 and «y N movimientos más» (and N more transactions).
- The checks and the note «Se crea el extracto en Odoo sin conciliar» (The statement is created in Odoo unreconciled).
- The Aprobar e importar (Approve and import) button.
Troubleshooting
Quoted text is exactly what the app shows, in Spanish, followed by what it means. When the Copilot can't propose something, it explains why in the chat, in its own words.
| What you see | Why | What to do |
|---|---|---|
| «Tu usuario de Odoo no puede crear extractos bancarios: en Odoo 19 hace falta el grupo de contabilidad «Basic» o el de contable. Pide a quien administra tu Odoo que te lo dé.»Means: Your Odoo user can't create bank statements: Odoo 19 requires the Basic accounting group or the accountant one. Ask your Odoo administrator to give it to you. | Your user only has Invoicing. | Ask for the Basic group or the accountant one (see Requirements). The card links here with Ver requisitos (See requirements). |
| «El diario cambió en Odoo después de la propuesta.»Means: The journal changed in Odoo after the proposal. | Someone changed the journal between the proposal and the approval. | Ask for the proposal again. |
| «Alguno de estos movimientos ya está en el diario (se importó mientras tanto).»Means: Some of these transactions are already in the journal (they were imported in the meantime). | The same statement was imported in the meantime. | Review the journal in Odoo. |
| «La propuesta ya no coincide con lo validado en Odoo.»Means: The proposal no longer matches what Odoo validated. | Odoo validated something different from what was proposed. | Ask for the proposal again. |
| The Copilot says the file currency isn't the journal currency | The statement is in one currency and the journal in another. | Choose the journal in that currency, or tell the Copilot the currency of the CSV. |
| The Copilot says the file doesn't add up | The balances in the file don't match its transactions. | Download the statement from your bank again. |
| The Copilot says the statement is already imported | All its transactions are already in the journal. | — |
| «Un administrador ha bloqueado este tipo de cambio.»Means: An admin has blocked this type of change. | An admin blocked the permission after the proposal. | Ask an admin to change it on the Permisos (Permissions) page. |
| «La propuesta ha caducado. Pide al Copiloto que la rehaga.»Means: The proposal has expired. Ask the Copilot to redo it. | 24 hours passed without a decision. | Ask for the change again. |