Convertir un relevé PDF OCBC en CSV, Excel

Comptes et difficultés de relevé OCBC

Formats de relevé que nous avons vus et que nous savons convertir.

Voir la conversion de ce relevé

Exemple synthétique d'un relevé bancaire de OCBC

Giro Mcy Smart

current account

Difficultés courantes de ce format :

Running Balance Cross-Check

OCBC 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

OCBC 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.

Multiple Currencies in One Table

OCBC Bank Indonesia statements mix multiple currencies (SGD, USD, EUR, etc.) in a single table, making it easy to misattribute amounts to the wrong currency. We automatically split and label each currency correctly, ensuring your CSV has separate rows with proper currency identification.

Transactions Split Across Multiple Tables

These statements split transactions into separate tables by type (deposits, withdrawals, checks, online transfers, etc.), each with different column layouts. Manually merging these into a single timeline is tedious and error-prone. We combine all tables into one chronological list while preserving transaction type information.

Inconsistent Date Formats

OCBC 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.

Multiple Dates per Transaction

The bank's statements show multiple dates per transaction (transaction date, posting date, value date), and it is not always obvious which one to use for bookkeeping. We consistently extract the posting date so your records match your bank balance.

Bilingual Transaction Descriptions

OCBC Bank statements show transaction descriptions in two languages, with the primary description on one line and the secondary language on the next.

Mixed Number Formats

These 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.

Voir 7 difficultés de plusVoir 5 difficultés de plus

Export CSV — compatible avec Excel, Google Sheets et les logiciels comptables. En savoir plus →

Export Excel — colonnes ajustées automatiquement avec mise en forme numérique, prêt pour l'analyse. En savoir plus →

Export prêt pour QBO — compatible avec QuickBooks Online et Desktop. En savoir plus →

Export prêt pour Xero — CSV formaté pour une importation directe des relevés bancaires dans Xero. En savoir plus →

Autres banques Indonesian

Allo Bankneobank

PT Allo Bank Indonesia Tbk

Indonésie

BCAPrécision vérifiée

PT Bank Central Asia Tbk

IndonésieIndonésien

Bludigital bank

PT Bank Digital BCA

IndonésieAnglaisIndonésien

BNI

PT Bank Negara Indonesia Tbk

IndonésieAnglaisIndonésien