How to import payments and bank statements from your previous software

What is it for?

It brings the bank statements and payments from your previous software and links them to the journal entries already in fiscaldoo. The amounts of the entries do not change: what is missing is added so that the reconciliation is complete.

When to use it?

• You have already imported the journal entries from the previous software and want to see the statements of each bank.
• You want the old receipts and payments to appear as payments.
• Do not use it for new journal entries: a statement or payment is only linked to an entry that is already posted. For current statements, follow the normal bank import.

Where to find it?

Accounting › Configure › Other settings › Archive › Import migrated bank statements and Import migrated payments.

The Administrator sees these two menus without developer mode; the other profiles only with it.

Before you start

• Profile: Administrator. The Certified accountant can import with developer mode enabled. The Accountant does not see these menus, even in developer mode.
• Company: choose the right company in the top corner. The file is read only in that company.
• Journal entries: they must be posted, each with a single line on the journal's bank account.
• Statements file (CSV or XLSX), with titles in the first row: extrato, diario, data, saldo inicial, saldo final, lancamento, valor and, optionally, descricao and por reconciliar.
• Payments file (CSV or JSON), with pagamento, lancamento, diario and, optionally, tipo, valor, moeda, data and referencia.

How to use it

1. Open Import migrated bank statements and choose the file in File.
2. Click Check. Nothing is saved at this step.
3. Read the summary and the warnings. If there are problems, click Back, correct the file and choose it again.
4. Click Import and, at the question “The statements will be created and linked to the entries. Continue?”, click Confirm.
5. Click View statements to check them.
6. Open Import migrated payments, choose the file in Payments file and click Check.
7. Click Import and, at the question “The payments will be created on the entries that already exist. Continue?”, click Confirm.

Expected result

• Statements: the summary says “1 statements, 1 lines linked to entries already posted.” and View statements shows the statement of 31/03/2026, with an opening balance of €0.00, a closing balance of €250.00 and the status Reconciled.
• Payments: the summary says “1 payments and 0 batches linked to entries already posted; 0 already imported before; 0 rows refused”, and the View payments button opens them.

The lines of the journal entries stay the same: in the example, the €250.00 entry still has €250.00 in debit on 121 Depósitos à ordem and €250.00 in credit on 2111 Clientes gerais.

Important notes

• A warning does not block. It warns, for example, that the closing balance of the statement differs from the account ledger. Check with the certified accountant whether the difference is expected. Pending validation by a certified accountant: how to handle a balance that differs from the ledger.
• A payments-only import does not reconcile. An entry with an open customer line stays open, and the warning tells you so.
• The same statement is refused if you import it again.

Common problems

• Symptom: “Row 2: Entry "BNK1/2026/00109" has 120.5 in the bank account, the file says 50.00. The statement line must have the amount of the entry.” Cause: the amount in the file differs from the entry. What to do: correct the file. Nothing was saved.
• Symptom: “Row 2: Statement "EXT-2026-03" already exists in journal BNK1. Importing it again would duplicate it.” and “Entry "BNK1/2026/00108" already belongs to a bank statement line.” Cause: the statement has already been imported. What to do: remove it from the file.
• Symptom: in View statements, the status is With problems. Cause: the opening balance does not match the closing balance of the previous statement of the same journal. What to do: check the balances against the previous software and talk to the certified accountant.
• Symptom: “Payments file, row 2 (PAG-2026-0002): The file says 99.0 but the bank line of entry "BNK1/2026/00109 (REC-MIG-2)" has 120.5 EUR. The payment must have the amount of the entry.” Cause: the amount is different. What to do: click Back and correct the file.