Banco de Occidente Statement to Excel Converter

ClearlyLedger converts Banco de Occidente (Colombia) PDF statements into clean Excel and CSV files. This guide covers the common Banco de Occidente spanish pdf layout, DD/MM/YYYY dates and COP amounts. Exports are released only when verification checks pass. Most Banco de Occidente statements (5-18 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-09-03

What does a Banco de Occidente statement PDF look like?

Printed structure: Spanish PDF with Fecha, Descripción, Débito, Crédito and Saldo

Date notation: DD/MM/YYYY. Money notation: $ COP. Observed statement size: 5-18 pages.

Amounts are in Colombian Pesos and often omit decimals; thousands grouping is normalised before export.

In Spanish, this document is a extracto bancario. Banco de Occidente forma parte del Grupo Aval, por lo que su extracto bancario comparte una estructura similar a la de Banco de Bogotá y Banco Popular, aunque con el formato y la marca propios del banco.

What fields does Banco de Occidente print on each transaction row?

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • Banco de Occidente checkpoint 1: Part of Grupo Aval, Colombia's largest financial conglomerate (which also owns Banco de Bogotá, Banco Popular, and AV Villas), so statement templates share structural similarities with those sibling banks while using Banco de Occidente's own branding
  • Banco de Occidente checkpoint 2: Reference metadata can split across multiple description cells rather than staying in one field
  • Banco de Occidente checkpoint 3: Fee reversals and refunds can invert the expected debit/credit sign, so the direction shouldn't be assumed from the transaction type alone
  • Banco de Occidente checkpoint 4: The layout changes slightly for savings (ahorros) versus checking (corriente) account statements

How do I check a Banco de Occidente conversion before using it?

A typical Banco de Occidente file runs 5-18 pages. Confirm its DD/MM/YYYY dates, COP signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Part of Grupo Aval, Colombia's largest financial conglomerate (which also owns Banco de Bogotá, Banco Popular, and AV Villas), so statement templates share structural similarities with those sibling banks while using Banco de Occidente's own branding. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Banco de Occidente PDF.
  2. Inspect the documented Banco de Occidente row patterns.
  3. Reconcile the COP transaction math.
  4. Download verified Banco de Occidente Excel or CSV data.

Which accounting tools accept Banco de Occidente Excel or CSV files?

Excel suits source-document review and coding. CSV suits mapped imports into Siigo, Alegra, World Office or QuickBooks. Those routes preserve the DD/MM/YYYY interpretation and COP values established from the Banco de Occidente source.

Is my Banco de Occidente statement data kept private?

The Banco de Occidente PDF is processed in memory and deleted after conversion. The Banco de Occidente transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around Colombia's Law 1581 of 2012 for Colombia account holders.

Banco de Occidente conversion FAQ

Which Banco de Occidente statement layouts can ClearlyLedger convert?

Banco de Occidente statements typically arrive as Spanish PDF with Fecha, Descripción, Débito, Crédito and Saldo. ClearlyLedger's Banco de Occidente profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle Banco de Occidente-specific quirks?

This guide highlights common Banco de Occidente statement characteristics — for example: Part of Grupo Aval, Colombia's largest financial conglomerate (which also owns Banco de Bogotá, Banco Popular, and AV Villas), so statement templates share structural similarities with those sibling banks while using Banco de Occidente's own branding. The conversion is released only after its verification checks pass.

Can I import a converted Banco de Occidente statement into Siigo?

Yes. Export to CSV and import into Siigo, Alegra, World Office or any tool that accepts a transaction file. The DD/MM/YYYY dates and COP amounts are normalised so the import maps cleanly.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free