# Import a bank statement and reconcile

> Match bank movements to payments, invoices and approved adjustments in the reconciliation interface.

Fonte: https://docs.kmee.com.br/en/odoo/funcional/financeiro/conciliacao-bancaria/

Match bank movements to payments, invoices and approved adjustments in the reconciliation interface.

## Before you start

Download the statement for the period from online banking in OFX, CSV or spreadsheet format. In the bank journal, the account number must be the same one the bank uses in the file. For CSV and spreadsheet files, also choose the column mapping of your bank in the journal.

## Step by step

### 1. Import and compare the statement

In Invoicing > Accounting > Actions > Import Statement, or from the import option on the bank journal card in the Dashboard, select the file and click Import and View. Check the account, date range, number of transactions and opening and closing balances. Transactions already in Odoo are recognized and left out of the new statement.

### 2. Review each proposed match

In the Dashboard, click Reconcile on the bank journal card. Select a transaction and check the proposed partner, invoice or payment. Compare the reference and the amount and identify whether the movement is a partial payment, an advance, a bank fee or a transfer. For a grouped deposit, select the matching installments and check that their sum equals the statement amount.

### 3. Validate and check the balances

Click Validate after checking the match and, when there is one, the adjustment account. The transaction leaves the list of pending items and the invoice shows its new balance. When the origin of a difference is unknown, leave the transaction pending and look into it before posting it.

## Expected result

Bank movements are linked to their invoices and payments, and the remaining differences stay visible for follow-up.

## If something goes wrong

If an invoice is not among the suggestions, check that it is posted, that the active company is correct and that the partner is filled in on the statement line, since the suggestion list opens filtered by that partner. If the file is not recognized, check that the account number in the journal matches the one in the bank file.

## Continue the process

- [Review receivables, payables and installments](https://docs.kmee.com.br/en/odoo/enterprise/funcional/financeiro/parcelas-e-vencimentos/)
- [Issue boletos and follow CNAB collection files](https://docs.kmee.com.br/en/odoo/enterprise/localizacoes/brasil/financeiro/cobranca-boleto-cnab-e-pix/)