Home › Countries › Colombia

Bank statement converters in Colombia

Convert statement PDFs from 7 Colombia banks to Excel, CSV, QuickBooks or Xero — every conversion reconciled against the statement's own balances.

Drag & drop statement PDFs hereor tap to choose a file — your first statement is free; batch upload is a plan feature

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

Banks in Colombia

Bancolombia statement converter

Bank headquartered in Medellín. Convert its statement PDFs to Excel, CSV and accounting formats.

Banco de Bogotá statement converter

Bank headquartered in Bogotá. Statement PDFs convert to spreadsheet and accounting formats, reconciled first.

Davivienda statement converter

Bank headquartered in Bogotá. Its statement PDFs convert to Excel, CSV, QuickBooks and Xero formats.

BBVA Colombia statement converter

Bank headquartered in Bogotá. Its statement PDFs convert to Excel, CSV, QuickBooks and Xero formats.

Banco de Occidente statement converter

Bank headquartered in Cali. Convert its statement PDFs to Excel, CSV and accounting formats.

Banco Popular statement converter

Bank headquartered in Bogotá. Convert its statements to Excel, CSV or an accounting format — checked first.

Nu Colombia statement converter

Bank headquartered in Bogotá. Statement PDFs convert to spreadsheet and accounting formats, reconciled first.

Banking in Colombia — the directory in detail

The Colombia directory covers 7 banks, their headquarters spread across Bogotá (5), Cali (1) and Medellín (1). BBVA Colombia also appears in the Mexico and Spain directories. In all, 1 of the 7 banks here belongs to groups listed in other countries' directories as well. A shared name never merges two countries' figures: each bank's statements convert and reconcile on their own balances, in their own currency.

Statement conventions in Colombia

Every conversion is checked against the statement itself: where the statement prints opening and closing (or running) balances, the extracted transactions must add up to them, or the conversion is flagged and the mismatched rows are marked. A statement whose layout the reader cannot parse is reported honestly — never passed off as converted.

Bookkeepers handling several Colombia clients meet the same statement in many layouts. The normalized output is the point: whichever bank issued the PDF, the columns come out identical, so one import routine and one review habit serve every client. The reconciliation check then does per-statement what no template can — it proves the figures against the issuing bank's own balances.

In Colombia, bookkeepers commonly work in Siigo and Alegra; the Excel and CSV exports from this converter are the files those tools import, and the CSV export is laid out for direct import where the tool accepts it.

Amounts on Colombia statements are printed in $. The converter keeps the figures exactly as printed — it converts layout, not currency.

Statements across Colombia are issued in $, and conversion keeps them that way: a Bancolombia export and a Banco de Bogotá export carry their figures exactly as printed, so totals from different Colombia banks can be compared side by side without a currency step in between. Bookkeepers in Colombia commonly pair statement exports with Siigo and Alegra; the CSV export is laid out for direct import where the tool accepts it, and the Excel and CSV exports cover everything else. Layouts vary more between Colombia banks — Bancolombia and Banco de Bogotá do not lay a statement out the same way — which is why the guarantee here is not a memorized template but the balance check itself, applied to every conversion.

A year of Colombia statements, caught up

Start by downloading every period from every account before converting anything; portals in Colombia sometimes archive older statements behind request forms, and discovering a gap early beats discovering it mid-import. Convert the full set as a batch, then clear the reconciliation results in period order — each month's closing balance anchors the next, so the year either chains cleanly or names the month that does not.

Bookkeepers handling several Colombia clients meet the same statement in many layouts. The normalized output is the point: whichever bank issued the PDF, the columns come out identical, so one import routine and one review habit serve every client. The reconciliation check then does per-statement what no template can — it proves the figures against the issuing bank's own balances.

Formats, in plain terms

Excel (.xlsx) keeps the statement readable and workable in a spreadsheet. CSV is the same data as bare text — maximally portable, minimally pretty. QuickBooks and Xero CSVs reorder the columns to each platform's import template. OFX is a tagged banking format for desktop tools. All five are generated from the same reconciled extraction, so choosing is about the destination, never about accuracy.

Questions and answers

Which banks in Colombia are covered?

This directory lists 7 banks in Colombia, each with its own converter pages. The converter itself is not limited to this list — it reads statement PDFs from any bank and normalizes them into the same columns.

How are dates and amounts printed on Colombia statements?

Expect dates as the order printed on the statement itself and amounts with the grouping printed on the statement itself on Colombia statements. The locale-aware reader handles those conventions, and the reconciliation check verifies the outcome against the statement itself.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Where are the banks in the Colombia directory based?

The 7 banks are headquartered across 3 cities: Bogotá (5), Cali (1) and Medellín (1).

What currency are Colombia statements in?

$ — and they stay in $ through every export. The converter changes the layout of a statement, never its currency, so a converted Bancolombia statement totals in $ exactly as the bank issued it, and the reconciliation check runs on those unconverted figures.

Bank statements in. Clean books out.

Your first statement is free — every format, no card — and every result is checked against the statement itself before you download it.

Convert a statement — free