Menu

Tools

Explore

CO · COP · .CSV

Colombia bank statementsGoogle Sheets

Convert Colombia bank statement PDFs from Bancolombia and more.

Loading converter...

Secure Financial Data Processing

Colombia Bank Statements and GOOGLE_SHEETS

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. MintConvert normalises all COP amounts to numeric values and dates to YYYY-MM-DD ready for import into World Office and Siigo. Fiscal year: January 1 – December 31.

Supported Colombia Banks

Example Output

DateDescriptionDebit (COP)Credit (COP)Balance
2024-03-15Bancolombia ATM Withdrawal2,000.0048,500.00
2024-03-18Salary Credit75,000.001,23,500.00

How It Works

  1. Download your PDF

    Log into your Colombia bank's online portal and download your statement as a PDF.

  2. Upload to MintConvert

    Drag and drop the PDF. MintConvert auto-detects which Colombia bank issued it.

  3. Download .CSV

    Clean GOOGLE_SHEETS in under 30 seconds COP amounts preserved, dates normalised.

Why MintConvert

  • 1 Colombia banks Bancolombia bank-specific parsers for each.
  • COP amounts Numeric COP import-ready for World Office.
  • Date normalisation DD/MM/YYYY → YYYY-MM-DD across all Colombia banks.
  • 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.
  • Privacy first Documents processed in-memory only never stored.
  • Free to start 3 free conversions/month. No credit card required.

Frequently Asked Questions

Which Colombia banks are supported for GOOGLE_SHEETS conversion?

MintConvert supports Bancolombia all with bank-specific parsers.

Is COP formatting preserved in the GOOGLE_SHEETS output?

Yes all COP amounts output as numeric values compatible with World Office and Siigo.

Can I use this 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 date format does the output use for Colombia statements?

MintConvert normalises all dates from DD/MM/YYYY to YYYY-MM-DD consistent across all 1 supported Colombia banks.

What accounting software in Colombia is compatible?

The output is compatible with World Office, Siigo, Aspel COI Colombia, SAP. QBO output works with QuickBooks Online and Desktop.

What is the fiscal year for Colombia?

Colombia fiscal year: January 1 – December 31. MintConvert processes statements for any date range.