Convertir un relevé PDF Mercury en CSV, Excel

Comptes et difficultés de relevé Mercury

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 Mercury

Checking

checking account

Difficultés courantes de ce format :

Currency Symbols Breaking Numeric Parsing

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

Transactions Split Across Multiple Tables

Mercury Technologies Inc. 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.

Missing Year in Dates

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

Payment Method/Rails Information

These statements include a separate column showing the payment method or rails used for each transaction (e.g., ACH, wire, card, check). We preserve this information in the extracted data to maintain the full transaction context.

Sparse Balance Column (End-of-Day Only)

Mercury Technologies Inc. statements show end-of-day balances, which can create empty cells for certain transactions that occur mid-day. We handle these gaps correctly and ensure all transactions are captured with their proper balance information.

Inconsistent Date Formats

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

Blank Dates for Same-Day Transactions

Mercury statements only print the date on the first transaction of each day — the rest have blank date cells. If you paste this into a spreadsheet, most rows will have no date at all. We automatically fill in the missing dates from context.

Voir 6 difficultés de plusVoir 4 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 US

Addition Financialcredit unionPrécision vérifiée

Addition Financial Credit Union

États-Unis

Ally Bank

Ally Financial Inc.

États-Unis

American Expresscredit cardPrécision vérifiée

American Express Company

États-Unis

Austin Bankcommunity bank

Austin Bank, Texas National Association

États-Unis