Menu

Tools

Explore

CO · COP · 1 Banks

Colombia Bank Statement Converter

Convert Colombia bank statement PDFs to CSV, Excel (.xlsx), JSON, or QuickBooks (.qbo) files. Works with major Colombia banks and helps with DIAN Renta/IVA filing, Electronic Invoicing reconciliation, and World Office or Siigo import.

Bank Statements in Colombia

Banks in Colombia usually provide statements as downloadable PDF files through online banking portals. These PDFs contain transaction tables with dates, descriptions, debit and credit amounts, and balances.

MintConvert extracts these transaction tables and converts them into structured formats like CSV, Excel (.xlsx), JSON, or QuickBooks (.qbo). This allows the data to be analysed in spreadsheets or imported into accounting software used in Colombia.

Major Colombia Banks Supported

MintConvert supports bank statement PDFs from major banks in Colombia, including:

  • Bancolombia bank statements can be converted to CSV, Excel, JSON, or QuickBooks.

Why MintConvert

  • 1 supported banksBancolombia
  • COP preservedAmounts exported as numeric values
  • Date normalisationDD/MM/YYYY → YYYY-MM-DD
  • DIAN Renta/IVA filing, Electronic Invoicing reconciliation, and World Office or Siigo importIn Colombia, bank statements are required for DIAN income tax (Renta) and VAT (IVA) declarations, and as supporting documents for DIAN audits and Electronic Invoicing (CUFE) reconciliation.
  • 4 output formatsCSV, Excel, JSON, QuickBooks
  • Free to start5 conversions/month with no credit card

Frequently Asked Questions

Which Colombia banks are supported?

MintConvert supports Bancolombia with bank-specific parsers for each bank's PDF format.

Can I use converted Colombia statements for DIAN Renta/IVA filing, Electronic Invoicing reconciliation, and World Office or Siigo import?

In Colombia, bank statements are required for DIAN income tax (Renta) and VAT (IVA) declarations, and as supporting documents for DIAN audits and Electronic Invoicing (CUFE) reconciliation.

What currency format is used in the output?

All COP amounts are exported as numeric values with no symbols.

What date format is used?

MintConvert normalises dates from DD/MM/YYYY to YYYY-MM-DD.

Which accounting software works with the output?

CSV and Excel outputs work with World Office, Siigo, Aspel COI Colombia, SAP. QuickBooks uses the QBO format.