contabilidad-ia

Automatic bank reconciliation with Cerewro: match statements with invoices in seconds

Import the bank statement CSV/Excel, upload the invoices and Cerewro automatically matches each transaction with its corresponding invoice, detects payments without invoice, uncollected invoices and generates the reconciliation report.

06 de August de 2026

Equipo Cerewro

banco extracto conciliacion csv reconciliar contabilidad

Automatic bank reconciliation with Cerewro

Bank reconciliation means cross-matching bank statement transactions with issued and received invoices to verify everything has been paid/collected. Cerewro automates this process that normally takes hours.

Cerewro Chat — Full reconciliation

Perform September 2026 bank reconciliation:
- Bank statement: C:\bank\barclays-september-2026.csv
- Issued invoices: C:\invoices\issued\ (PDFs and HTML from Aug-Sep)
- Received invoices: C:\invoices\received\ (same period)

Expected output:
1. Issued invoices matched with their bank receipt
2. Received invoices matched with their bank payment
3. Bank transactions WITHOUT matched invoice (unrecorded expenses)
4. Invoices WITHOUT bank transaction (pending collection/payment)
5. Amount differences (discounts, bank charges)
6. Reconciliation summary in Excel

Date tolerance: Payments rarely land on the exact invoice date. Cerewro uses ±5 days by default to match invoices with bank transactions. Adjust it: "Use ±3 days for the reconciliation".