將 SCB PDF 對帳單轉換為 CSV 及 Excel

SCB帳戶類型與對帳單挑戰

我們已見過並通過準確度驗證的對帳單格式。

查看此對帳單的轉換結果

SCB 銀行對帳單的合成範例

Savings Account

儲蓄賬戶

此格式常見的注意事項：

Running Balance Cross-Check

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

Payment Method/Rails Information

Siam Commercial Bank 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.

Abbreviated Year in Dates

The Siam Commercial Bank 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.

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.

Visual Debit/Credit Split in Single Column

ธนาคารไทยพาณิชย์ statements have a single "Debit/Credit" column header, but debits and credits are visually separated within it — debits sit on the left and credits on the right. Standard extractors see one column and cannot determine the transaction direction. We split the column based on position and correctly assign each amount as a debit or credit.

Phantom Balance Rows on Every Page

The bank's 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

SCB 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

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

Zero-Value Fee & Interest Lines

Siam Commercial Bank statements include $0.00 rows for interest charges, fees, and adjustments that had no activity that period. These look like real transactions but carry no value, cluttering your export and inflating row counts. We detect and remove them automatically.

查看更多 8 項挑戰查看更多 6 項挑戰

查看此對帳單的轉換結果

SCB 銀行對帳單的合成範例

ออมทรัพย์

個人賬戶

此格式常見的注意事項：

Running Balance Cross-Check

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

Bilingual Column Headers

Siam Commercial Bank statements show column headers and metadata labels in two languages (e.g., "Date / Tarikh"). We detect the relevant fields across both languages so transactions are captured consistently.

Separate Credit & Debit Columns

The Siam Commercial 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.

Times Mixed Into Date Column

These statements sometimes include a time alongside the date in the date column. We normalize the value and keep the correct transaction date.

Payment Method/Rails Information

ธนาคารไทยพาณิชย์ 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.

Bilingual Transaction Descriptions

The bank's statements show transaction descriptions in two languages, with the primary description on one line and the secondary language on the next.

查看更多 5 項挑戰查看更多 3 項挑戰

CSV 輸出 — 相容 Excel、Google 試算表及會計軟體。 了解更多 →

Excel 輸出 — 欄寬自動調整並套用數字格式，可直接用於分析。 了解更多 →

QBO 就緒輸出 — 相容 QuickBooks Online 及 Desktop。 了解更多 →

Xero 就緒輸出 — CSV 格式化，可直接匯入 Xero 銀行對帳單。 了解更多 →

其他經準確度驗證的Thai銀行

American Expresscredit card

American Express (Thai) Co., Ltd.

泰國

Bangkok Bank

Bangkok Bank Public Company Limited

泰國英文泰文

Bank of China

Bank of China (Thai) Public Company Limited

泰國

CIMB Bank

CIMB Thai Bank Public Company Limited

泰國