How to Convert a CaixaBank PDF Bank Statement to Excel (2026)

- Fecha — formatted as Excel dates in DD/MM/YYYY (sortable, filterable)

- Concepto — full transaction description (domiciliaciones, transferencias, Bizum, recibos)

- Importe — negative for debits, positive for credits, in EUR

- Saldo — running balance after each transaction

CaixaBank vs ex-Bankia statements (different templates pre-merger): CaixaBank absorbed Bankia in 2021. If you have older Bankia statements (entity code 2038), they use a different PDF layout than current CaixaBank statements (entity code 2100). pdftoxlsx auto-detects both templates and extracts transactions identically. No manual configuration needed — just upload and the converter handles it.

CaixaBankNow vs legacy "la Caixa" PDF formats: Over the years, CaixaBank has updated its statement format — from the old "la Caixa" branding to the current CaixaBankNow layout. pdftoxlsx recognizes all format generations and extracts Fecha, Concepto, Importe, and Saldo consistently regardless of when the statement was generated.

Bizum transactions (BIZUM + phone/name): Bizum payments and receipts in CaixaBank statements appear with a "BIZUM" prefix followed by the recipient or sender phone number and name. pdftoxlsx preserves the full Bizum identifier, phone number, and name in the Concepto column so you can reconcile peer-to-peer payments easily.

Domiciliaciones SEPA (direct debits): SEPA direct debits in CaixaBank statements include long mandate references, creditor IDs, and IBAN details that may wrap across multiple lines. pdftoxlsx merges these wrapped lines into a single Concepto cell without losing any reference data, making them searchable and filterable in Excel.

Tarjeta de crédito statements (separate monthly statements): CaixaBank credit card PDFs are separate from current account statements and include Compras (purchases), Pagos (payments), and finance charge details. pdftoxlsx consolidates these into a single Importe column so the ledger matches the card balance exactly.

Cuenta Negocios/Empresa (empresas.caixabank.es portal): Business account statements from CaixaBankNow Empresas may include multiple accounts and CIFs in a single PDF. pdftoxlsx splits these into separate sheets (one per account/CIF) so you can import each to the correct ledger in your accounting software.

TPV/POS transactions for business accounts (merchant payments): CaixaBank Empresa statements with TPV (Terminal Punto de Venta) activity show merchant payment aggregations and individual card transaction breakdowns. pdftoxlsx extracts both the summary and detail lines, placing them on appropriately labeled sheets.

Seguros y fondos (insurance/investment linked transactions): CaixaBank statements may include lines related to VidaCaixa insurance premiums or investment fund movements. These appear as separate transaction types. pdftoxlsx preserves the full description including policy or fund reference numbers in the Concepto column.

CaixaBank Sign authentication (2FA may affect download flow): CaixaBank requires CaixaBank Sign (a separate app) for two-factor authentication when downloading statements. This does not affect the PDF content — once you have authenticated and downloaded the PDF, simply upload it to pdftoxlsx as normal. The 2FA step is only relevant for the download process from the bank.

Extracto consolidado multi-cuenta: CaixaBank can generate consolidated statements covering multiple accounts in a single PDF. pdftoxlsx detects each account section and splits them into separate sheets, preserving the IBAN and account alias for each. This is particularly useful for families or businesses managing several CaixaBank accounts under one profile.