Colombian bank statements to Excel
Statements from Colombian banks turned into a spreadsheet, every balance checked.
- Checked every row against your balance
- Private read on your device first
- Excel & CSV plus QuickBooks, Xero and Quicken files
- Free no sign-up, no page limits
Colombian banks tested on their statement layouts
Colombian amounts are written either 1,234,567.00 or $1.234.567,00; Bancolombia prints dates without the year and Nequi uses signed amounts.
StatementEasy recognises each format and checks every balance.
Banks
Eight Colombian banks are tested on their statement layouts: Bancolombia, Davivienda, BBVA Colombia, Banco de Bogotá, Nequi, as well as Banco de Occidente, Banco Popular and Scotiabank Colpatria. If yours is not read, tell us the bank.
Bank by bank
- Bancolombia — dates without the year, signed amounts.
- Davivienda — $1.234.567,00 amounts.
- Nequi — signed amounts with $.
Colombian formats, read correctly
| On the statement | In your sheet |
|---|---|
| 1,234,567.00 | 1234567.00 |
| $1.234.567,00 | 1234567.00 |
Colombian statement words, in English
- extracto — statement
- consignación — deposit
- retiro — withdrawal
- abono / cargo — credit / debit
- GMF (4x1000) — the financial transactions tax: 4 pesos per 1,000 moved
- PSE — the online bank-payment system used for bills and purchases
- cuenta de ahorros — savings account, the most common everyday account
- saldo anterior — opening balance
How money moves in Colombia
Most people hold a savings account (cuenta de ahorros) as their everyday account, pay bills through PSE and move money with Nequi or DaviPlata. Every withdrawal or transfer may carry the 4x1000 tax as a separate line.
Once converted, filtering by “4X1000” shows the tax paid in a year, and filtering by “PSE” shows what went on bills.
Who converts Colombian statements
Accountants preparing DIAN income-tax returns, entrepreneurs paid by Nequi who need a sales record, and people proving income for a loan or a lease.
Questions
Can the two number formats be confused?
No; each statement’s format is recognised and checked.
Is the 4x1000 tax shown?
Yes, as its own rows, which you can filter and total.
Is my statement uploaded?
Your browser reads the PDF first, on your device. Only if it cannot read it is the file read on our server, and deleted right after.
Other countries
Your next statement, in a spreadsheet
Free, no limits. No sign-up.