Home Bank and statement format compatibility Banco a Excel · Accounting work, private data Bank and statement format compatibility Check validated banking products, verification dates, available reconciliation checks and the actual limitations of Banco a Excel.
Published by VICA Technology · Updated 2026-09-25
Compatibility depends on the product and PDF layout, not just the bank name. Nine institutions have at least one format checked against real statements; Mercado Pago remains experimental. OCR and validated credit-card profiles are unavailable.
How validation works Columns, dates, wrapped descriptions and page breaks were measured in statements published through Mexican public-transparency portals. Movements were checked, along with balances and declared totals when the layout allows. Dates below refer to that validation: a later editorial update is not a new test of every format.
Automated tests use entirely synthetic PDFs and CSV outputs, including two-page files and continuations. Those examples can be downloaded; we do not publish real statements or their movements. Passing a synthetic test does not establish support for a new product.
Business debit Format validation: 2026-07-22
8-page business statement: no balance mismatches; declared totals matched to the cent.
Declared debits and credits; balance chain. Balances not printed between same-day movements are calculated.
Business debit validated. Personal debit and credit cards are not yet validated.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Enlace Global PM Format validation: 2026-07-22
5-page business statement: balances and declared totals matched to the cent.
Declared deposits and withdrawals; fees and VAT are included in their separate categories.
Enlace Global PM validated, including fees and VAT. Personal formats are unvalidated.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Business Format validation: 2026-07-22
20-page business statement: no balance mismatches; declared totals matched to the cent.
Declared debits and credits, and the balance chain.
Business accounts validated. Other formats and credit cards are unvalidated.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Experimental · synthetic template Format validation: Not validated
Synthetic tests only. This is not presented as a validated converter.
No validation against real PDFs. Mercado Pago CSV reports cannot be imported.
Experimental: synthetic template, not validated against a real PDF. Mercado Pago CSV reports are unsupported.
Methodology and full matrix
Cuenta Productiva PM · 531 × 792 layout Format validation: 2026-07-23
Three independent business samples, reconciled to the cent.
Declared totals in the validated format. First account only; the 2022 layout is unsupported.
Legacy 531×792 Cuenta Productiva PM validated. The 2022 layout is unsupported; first account only.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Cuenta Integral PyME · first account Format validation: 2026-07-23
117 of 117 movements verified in the business sample.
Movements and balances of the first section. Declared totals unavailable: summaries cover multiple accounts.
Cuenta Integral PyME validated. First account only; declared summary totals unavailable.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Business checking Format validation: 2026-07-23
Samples from two business customers, with every movement checked.
Movements and balance chain. Declared totals unavailable due to the summary layout.
Business checking validated. Declared summary totals unavailable.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Personal debit Format validation: 2026-07-23
678 movements checked. This is the validated personal variant; it does not cover other products.
Column sums checked against statement totals; dates split over two lines are read together.
Personal debit validated. Other products are unvalidated.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Business · low-volume sample Format validation: 2026-07-23
Two accounts with seven movements in total; both reconciled.
Declared debits and credits. Description continuation is inferred from column geometry; samples contain no wrapped descriptions.
Business accounts validated on low-volume samples. Other layouts are unvalidated.
Fully synthetic example: PDF · CSV
Methodology and full matrix
PyME business Format validation: 2026-07-23
Movements checked and declared credit total matched exactly.
Declared credit total only. The declared debit total is not extracted reliably.
PyME validated. Only the declared credit total can be checked.
Fully synthetic example: PDF · CSV
Methodology and full matrix
Before relying on an export Compare the original PDF with the preview. Review warnings, unrecognized rows and out-of-column amounts. No arithmetic discrepancy does not guarantee that every date or description is correct. Personal debit remains unvalidated except for the Inbursa variant listed above.