Convert MCB Statement PDF to CSV, Excel

MCB Accounts & Statement Challenges

Statement formats we've seen and can convert.

See this statement's conversion

Synthetic example of a MCB bank statement

Current Account

Current

Common pain points with this format:

Running Balance Cross-Check

MCB statements include a running balance column that most converters ignore. Without validating it, missing or duplicate transactions go undetected. We extract this balance and cross-check it against opening/closing balances to ensure every transaction is accounted for.

Separate Credit & Debit Columns

Maduro & Curiel's Bank statements use separate Credit and Debit columns in some formats, while others use a single Amount column with signs. Treating one layout like the other leads to wrong amounts or flipped signs. We automatically detect which layout is used and normalize the output.

Currency Symbols Breaking Numeric Parsing

Maduro & Curiel's Bank N.V. statements embed currency symbols (e.g., "$1,234.56") directly in amount cells, which breaks numeric parsing in Excel and most CSV importers. We strip these symbols so amounts import as clean numbers.

Missing Year in Dates

These statements omit the year from transaction dates (e.g., "15/03" instead of "15/03/2025"), which makes it impossible to sort or reconcile without guessing. We infer the correct year from the statement period and surrounding context.

Inconsistent Date Formats

Maduro en Curiel's Bank statements use different date formats within the same document (e.g., "30 Jun 2025" for statement dates and "15/03/2025" for transactions), which can cause date parsing errors or silent misinterpretation. We normalize all dates to a consistent format automatically.

Mixed Number Formats

The bank's statements mix multiple formatting conventions within a single date value — for example, "Mon, 05 Januari 2026" combines an English day abbreviation with an Indonesian month name. We detect and resolve each component separately to parse these hybrid values correctly.

See 5 more challengesSee 3 more challenges

CSV output — compatible with Excel, Google Sheets, and accounting software. Learn more →

Excel output — auto-sized columns with numeric formatting, ready for analysis. Learn more →

QBO-ready output, tested with QuickBooks Online (Desktop: see FAQ). Learn more →

Xero-ready output — CSV formatted for direct Xero bank statement import. Learn more →

Other Curaçaoan Banks

Banco di Caribe

Banco di Caribe N.V.

Curaçao

Orco Bank

Orco Bank N.V.

Curaçao

RBC Royal Bank

RBC Royal Bank N.V.

Curaçao

Vidanova Bank

Vidanova Bank N.V.

Curaçao