Banco de Bogotá statement to Excel

A Banco de Bogotá statement lists Fecha, Transacción, Débito, Crédito and Saldo from the Saldo Inicial, with amounts like 1,234,567.00.

StatementEasy reads each amount as a number and checks every balance.

Download your Banco de Bogotá statement

1. Open the Banco de Bogotá app or online banking.
2. Open Extractos.
3. Download the PDF.
4. Drop the PDF into the converter above.

Banco de Bogotá columns in your sheet

On the statement	In your sheet
Débito / Crédito	Money out / money in
Saldo	Checked on every row

For businesses

Export OFX or CSV for accounting software and use the Categories sheet for suppliers, payroll, taxes and fees.

A line, explained

05/03/2025 RETIRO CAJERO 400,000.00 1,912,300.00 becomes money out 400000.00 and balance 1912300.00, checked against the line before.

Payroll accounts

Insights identifies the salary as regular income and shows each month’s lowest balance.

From PDF to sheet

Débito, Crédito and Saldo are found and every balance is checked before the sheet is shown.

What your Banco de Bogotá spreadsheet contains

Each row of the file is one transaction: the date as a real date, the full description, money in and money out as numbers in separate columns, and the running balance where Banco de Bogotá prints one. Amounts written 1,234,567.00 become plain numbers. A first tab summarises the statement — period, opening and closing balance, totals in and out, and whether the check passed — and the Monthly, Categories and Recurring sheets come in the same download.

Using it for a business or a loan

Businesses can filter client payments, separate fees and the 4x1000 tax, and export OFX or CSV for accounting software. For a loan, convert three to six months: the Monthly sheet and Insights show income and the lowest balance.

Grupo Aval banks — Banco de Occidente, Banco Popular — have their own layouts and are recognised too.

If something looks wrong

• A row does not match — it is highlighted and can be corrected.
• A current-account statement — read the same way if it has Débito, Crédito and Saldo.
• A scanned statement — OCR works; the online banking PDF is exact.

Last tested October 2026. StatementEasy is not affiliated with Banco de Bogotá S.A..