Convertir un relevé de carte de crédit Trust Bank Singapore en CSV, Excel

Cartes de crédit et difficultés de relevé Trust Bank

Formats de carte de crédit que nous avons vus et que nous savons convertir.

Voir la conversion de ce relevé

Exemple synthétique d'un relevé de carte de crédit de Trust Bank

Standard

Carte de crédit

Primary Cardholder (SGD)Supplementary Cardholder (SGD)

Difficultés courantes de ce format :

Currency Only Shown in Column Header

Trust Bank Singapore statements display the currency symbol only in the column header, not with each amount. We track the currency context throughout the statement to ensure all amounts are properly labeled with the correct currency.

Two Currencies Shown Side-by-Side

Trust Bank statements show amounts in both the account currency and a foreign currency side-by-side. We extract both values and preserve the foreign currency information in separate columns for complete transaction records.

Transactions Split Across Multiple Tables

Trust Bank SG 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

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.

Multiple Dates per Transaction

Trust Bank Singapore Limited 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.

Plus Sign Indicates Credit (Payment)

The bank's credit card statements use + to mark credits/payments and no sign for charges. This follows bank-statement sign conventions rather than the standard credit card convention where + typically indicates a charge added to the balance.

Inconsistent Date Formats

Trust Bank Singapore 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.

Abbreviated Year in Dates

These statements use two-digit years in transaction dates (e.g., "15/03/25" instead of "15/03/2025"), which can be ambiguous across century boundaries. We automatically expand these to full four-digit years.

Blank Dates for Same-Day Transactions

Trust Bank 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 8 difficultés de plusVoir 6 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 Singaporean

American Expresscredit cardPrécision vérifiée

American Express International, Inc. Singapore

Singapour

AspireneobankPrécision vérifiée

Aspire FT Pte. Ltd.

Singapour

Bank of China

Bank of China Limited, Singapore Branch

Singapour

Chocolate Financedigital wallet

Chocfin Pte Ltd

Singapour