DBS statements repeat "Balance brought forward" and "Balance carried forward" rows on every page. Without filtering, these appear as phantom transactions in your export, inflating your transaction count. We remove them automatically.
Separate Credit & Debit Columns
DBS 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.
Inconsistent Date Formats
DBS 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.
Running Balance Cross-Check
These 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.
Times Mixed Into Date Column
Development Bank of Singapore statements sometimes include a time alongside the date in the date column. We normalize the value and keep the correct transaction date.
Separate Counterparty Column
The bank's statements sometimes list the counterparty in its own column separate from the description. We don`t merge the fields so the transaction details stay complete.
Multiple Currencies in One Table
DBS 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.
Multiple Dates per Transaction
These 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.
Currency Symbols Breaking Numeric Parsing
DBS Bank 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.
Payment Method/Rails Information
The bank's 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.
Transactions Listed Newest-First
DBS Singapore statements list transactions in reverse chronological order (newest first). We detect this ordering and handle balance derivation correctly, working backwards from the closing balance when needed.
DBSの銀行明細書の合成サンプル例
Dbs Business Multi Currency Account
事業用口座
DBS Business Multi-Currency (SGD)DBS Business Multi-Currency (USD)
このフォーマットでよくある注意点：
Running Balance Cross-Check
DBS 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
DBS 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
DBS Singapore 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.
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.
Multiple Dates per Transaction
Development Bank of Singapore 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.
Times Mixed Into Date Column
The bank's statements sometimes include a time alongside the date in the date column. We normalize the value and keep the correct transaction date.
Separate Counterparty Column
DBS statements sometimes list the counterparty in its own column separate from the description. We don`t merge the fields so the transaction details stay complete.
