Convert Banco de Bogotá (Miami) statement to Excel

Yes. Upload the Account Statement PDF from the Banco de Bogota Miami agency and ExtractPro returns an Excel file with one row per transaction: date, description, amount, and running balance. The statement is in English and US dollars, with figures in US format (1,234.56); ExtractPro reads the two dates (Posting and Value) and the four money columns (Debit, Credit, Fee, Balance) and computes the net amount as Credit minus Debit minus Fee. It validates the ending balance against the Account Summary printed on the statement, so it reconciles to the cent.

Because the Miami agency prints four money columns per line — Debit, Credit, Fee and Balance — and only one of Debit, Credit or Fee is non-zero on a given row. Wire and service fees (for example INTERNET TFR FEE or SYSTEM GENERATED SERVICE CHARGE) appear as their own rows that reduce the balance. ExtractPro reads each column by position and records the net effect (Credit minus Debit minus Fee) as the amount, so every fee is captured and the running balance ties out.

Yes. This is the statement of a US-dollar account held at the Banco de Bogota Miami agency, so it is issued in English and in USD regardless of where the account holder is based — typically a Colombian company operating a Miami account. ExtractPro keeps the amounts in dollars and the dates in DD-Mon-YY as printed, normalizing them in the Excel output, so the file is ready for QuickBooks or Xero.