Convert Banco de Bogotá (Miami) statement to Excel

Upload the Banco de Bogotá Miami Account Statement PDF and ExtractPro returns an Excel file with a row for each transaction, carrying its date, description, amount and balance. It recognizes the document by the agency address printed on each page together with the Account Summary block, because the name of the bank sits in a logo and shows up inside the transactions only as a counterparty. The Posting and Value dates are read as dates, and Debit, Credit and Fee are combined into one signed amount per row, so a fee row lowers the balance exactly as it does on the PDF.

Because the Miami agency prints four money columns on each line, Debit, Credit, Fee and Balance, and only one of Debit, Credit or Fee is non-zero on a given row. Fees such as INTERNET TFR FEE or SYSTEM GENERATED SERVICE CHARGE appear as rows of their own. ExtractPro reads each column by its position and writes the net effect, Credit minus Debit minus Fee, as the amount, so every fee keeps its row and the Balance column holds the figure the bank printed.

Yes. The Account Statement of the Miami agency is issued in English and in US dollars, and its figures use the US format, 1,234.56. ExtractPro keeps every amount in dollars and reads dates such as 04-May-26, day then month abbreviation then two-digit year, as real dates in the Excel.