Banks and reconciliation

What it is

Banks and reconciliation puts the bank statement next to your books. Each bank line is reconciled against something already recorded, turned into a póliza (journal entry) if it matches nothing, or ignored. At the top is the account's tie-out: Según el banco (per bank), Según los libros (per books) and Diferencia (difference).

When to use it

Every time you pull movements from the bank, and always before you close the month.

Step by step

Set up the account

Click Agregar cuenta (add account) and enter Nombre (name), Banco (bank), Últimos 4 dígitos (last 4 digits; the full number is not stored), Moneda (currency), the Cuenta contable (ledger account) that represents it in your chart of accounts, the Saldo inicial (opening balance) and its date.

Import the statement

Import works by pasting, not by file upload: click Importar estado de cuenta (import statement) and paste the lines, one per row, with date, description and amount, separated by commas, semicolons or tabs. For example: 2026-09-21, OTA deposit, 18320.55. A negative amount is money out, and anything already imported is not duplicated.

• Write the date as year-month-day, like the example on the screen.
• Write the amount without a thousands separator (4500.00, not 4,500.00): with the thousands comma, the line is misread.
• If your bank splits debits and credits into two columns, combine them into one signed column before pasting.
• Paste movements only. A line without a valid date or amount, such as a header, is skipped; a balance line with a date and an amount would be imported as a movement. Compare how many were imported against your statement.

Reconcile

1. Choose the Cuenta bancaria (bank account): its pending movements appear below.
2. For money out, Containn suggests supplier payments recorded in Accounts payable; for money in, deposits from OTAs (online travel agencies) recorded in OTA reconciliation, under Finances → Reports. It only suggests matches with the exact same amount and no more than five days apart. Click the right suggestion.
3. If the movement matches nothing recorded (a fee, interest, a bank charge), use Registrar como gasto (record as expense), choose the account and save: a póliza is created against the bank account, dated the movement's date. It works for money in as well, such as interest earned.
4. Ignorar (ignore) removes from the list a line that should not enter the books.
5. Under Ya conciliados (already reconciled), Deshacer (undo) sends a movement back to pending. Every reconciliation keeps who did it and when.

The tie-out

Según el banco is the opening balance plus the imported movements, excluding ignored ones. Según los libros is the same opening balance plus what pólizas moved in the linked ledger account. If the difference is zero, the account shows Cuadrada (tied out); if not, the screen says how many movements are left to reconcile and for how much.

What can go wrong

• “Sin coincidencias” (no matches). Today only supplier payments and OTA deposits are suggested; guest card or transfer payments and cash deposits are not yet (reconciliation suggests nothing).
• A movement already in the books through another path, such as the payroll payment: do not record it as an expense, or it would be counted twice. Leave it pending: the tie-out counts it anyway.
• Two identical movements on the same day, with the same description and amount: the second is taken as a duplicate. Make their descriptions different before pasting.
• You can't undo. A movement recorded with a póliza (it says con póliza) or an ignored one cannot be sent back from the screen: choose the account carefully and use Ignorar only when you are sure.
• The difference is not zero and nothing is pending. There are movements in the ledger account that do not come from the imported statement, such as a period you did not paste or the opening póliza.

Related articles