Convert your Banco de Bogotá Miami Agency statement to Excel

Many Colombian companies that operate in dollars keep a corporate account at Banco de Bogotá’s agency in Miami. That account issues its statement in English and in US dollars — an "Account Statement" that looks nothing like the peso statement the same group gets back home. If you handle the books or the treasury for one of these companies, that PDF lands on your desk every period, and it is built to be read, not summed. This guide covers what the Miami Agency statement looks like and how to turn it into an Excel that reconciles to the cent.

Who gets a Banco de Bogotá Miami Agency statement

The typical holder is a Colombian company with USD operations — importers, exporters, or any business that invoices and pays in dollars — that opened a corporate account at the Banco de Bogotá agency located at 701 Brickell Avenue, Miami, FL. That Miami address, printed at the foot of every page and in the account header, is the clearest way to tell this statement apart from a domestic Colombian one: the bank’s name shows up mostly in the logo and as a counterparty inside the transactions, while the Miami agency identity is what makes the document what it is.

What the Account Statement looks like

The statement lays each transaction out in columns: Posting Date, Value Date, Description, Debit, Credit, Fee and Balance. Dates use the DD-Mon-YY format with an English month abbreviation (for example, 04-May-26), amounts are in US number format 1,234.56 in dollars, and every line carries the running balance after the operation.

A detail worth knowing: each line can carry a Debit, a Credit and a Fee, and the real effect on the balance is Credit minus Debit minus Fee. Wire and service fees are not buried — they also show up as their own lines, with descriptions like "INTERNET TFR FEE" or "SYSTEM GENERATED SERVICE CHARGE". Keeping every fee visible is good for the books, but it also makes the transaction list longer.

At the top, the statement includes an "Account Summary" that closes the period: Previous Balance plus credits minus debits equals Current Balance. Those printed figures are the reference to reconcile the conversion against.

Why the PDF will not import into your accounting software

The columns you see on screen are not a real table — they are text placed at a position inside the PDF. Copy and paste it into a spreadsheet and the rows collapse into each other, the Debit, Credit and Fee amounts run together, and the balance stops adding up. On a busy treasury account with wires and fees on almost every line, doing it by hand is slow, and it is easy to line up an amount under the wrong column, which you then have to chase during reconciliation.

How to convert it to Excel with ExtractPro

1. 1Go to extractpro.app and upload the Banco de Bogotá Miami Agency "Account Statement" PDF as you downloaded it.
2. 2ExtractPro reads each transaction and builds one row per operation with date, description, debit, credit, fee and balance, reading the US number format 1,234.56 in dollars.
3. 3Download the Excel, with amounts as real numbers ready to sum and filter, and the balance kept as a control column.

The detail that matters: for every line, ExtractPro computes the net effect on the balance as Credit minus Debit minus Fee, and before handing you the sheet it checks the running balance and the Account Summary — Previous Balance plus credits minus debits should equal the printed Current Balance. If the reconstructed balance does not match what the statement prints, it flags it, instead of handing you a sheet that is quietly missing a line.

Importing the Excel into QuickBooks or Xero

Because the account is in US dollars and the statement is already in English, the Excel drops straight into the tools these companies usually run for their USD books — QuickBooks or Xero. Map the columns to the import template, and since the amounts come through as real numbers with the fees on their own lines, you can post the wires and the bank charges separately and reconcile each one against your records. The balance column stays as a control to confirm the period ties out before you close.