Convert a Bancolombia statement to Excel

How to download Bancolombia extractos

On the web, log in to the Sucursal Virtual Personas, open the Menú (≡) at the top left, then Documentos (documents) → Extractos (statements). Enter your clave dinámica (the one-time code). Find the account or card by date, name or number, click the three dots next to it and pick Descargar en PDF or Descargar en XLS (download as Excel). To get several at once, tick the products and use Descargar extractos. The steps are in Bancolombia's help article how to download extractos in the Sucursal Virtual.

Bancolombia's help page says this download isn't available in the Mi Bancolombia app yet, so use a browser. Without online banking you can also go to bancolombia.com → Trámites digitales (online requests) → Solicitud de documentos → Extracto bancario, pick a year and month and choose Descargar PDF. Credit card extractos can also be requested as a PDF over WhatsApp from Tabot, Bancolombia's chatbot.

Businesses use the Sucursal Virtual Negocios: Reportes y archivos (reports and files) → Consulta y solicitud → Extractos, then the three dots → Ver extracto or Descargar, in PDF or XLS.

Which formats Bancolombia offers (and how far back)

Business deposit accounts (savings and checking) keep up to two years of extractos in the Sucursal Virtual Negocios, available from the fifth business day of each month. Anything older must be requested from the Sucursal Telefónica (phone banking) or a branch, and arrives as a PDF or on paper.

When you still need to convert the PDF

If the XLS file covers what you need, you may only want it categorized. A PDF converter is the practical route when:

• You need statements older than two years — they come from phone banking or a branch as PDF or paper, never as XLS.
• A client, tenant or applicant sends you PDF extractos and you don't have their login.
• You're working from credit card extractos received by e-mail or WhatsApp. See credit card statements to Excel.
• You only have a scan or phone photo of a printed extracto.

Bancolombia statement quirks

• Password-protected PDFs. If an extracto asks for a password, Bancolombia's help page says it is your número de documento de identidad (your cédula or other ID number). Type it when you upload; we use it once and don't store it. More on opening password-protected bank statement PDFs.
• Peso amounts. Balances in COP run into millions, and Colombian documents print them either as 1.234.567,89 or 1,234,567.89. Both are read correctly, and Excel gets real numbers, not text.
• The 4x1000 tax. The GMF (gravamen a los movimientos financieros, 0.4% on withdrawals and transfers) usually shows up as many small debit lines. Give it its own category so it doesn't disappear into "bank fees".
• Credit card extractos list purchases, installments and interest, not your account movements. Upload them separately; each card becomes its own statement.
• E-mailed extractos come from extractosbancolombia@extractos.documentosbancolombia.com with the subject "extractos Bancolombia" — check your spam folder if one is missing.

Convert Bancolombia extractos to Excel, CSV or accounting software

Upload the PDFs or XLS files and every movement is extracted with its date, the full description, a clean payee name and a category. Then the balance check runs: the opening balance plus credits minus debits must equal the closing balance printed on the extracto, and the running balance is checked row by row. If a line was missed at a page break or a sign was misread, the rows to look at are flagged with their page number — and a statement that doesn't balance uses no pages.

Export to Excel for a workbook with a Transactions and a Summary sheet, or to CSV with comma or semicolon separators and DD/MM/YYYY dates. If your accounting software — Siigo, World Office, Alegra or another — imports bank movements from a spreadsheet, export the CSV or Excel file in the layout it asks for. QuickBooks Online CSV, Xero CSV, OFX and QIF are there too.

For accountants handling Colombian clients

Clients rarely share their Sucursal Virtual login, so most of the work arrives as PDF extractos, often locked with the client's ID number. Upload a whole folder at once, combine several accounts and months into one export, and limit it to the tax year. See how it fits a bookkeeping workflow, or browse converters for other banks.

Questions