Convert Krungthai Statement PDF to CSV, Excel

Krungthai Accounts & Statement Challenges

Statement formats we've seen and verified for accuracy.

Synthetic example of a Krungthai bank statement

ออมทรัพย์

Personal

bank-statement (THB)

Common pain points with this format:

Running Balance Cross-Check

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

Buddhist Era Calendar (Year +543)

Krungthai Bank statements use the Thai Buddhist Era calendar (พ.ศ.), where years are 543 ahead of the Gregorian calendar. We automatically convert all dates to the standard Gregorian calendar.

Separate Credit & Debit Columns

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

Zero-Value Fee & Interest Lines

Krung Thai 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.

Inconsistent Date Formats

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

Currency Symbols Breaking Numeric Parsing

Krung Thai Bank Public Company Limited 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.

See 6 more challenges

CSV output for Krungthai — compatible with Excel, Google Sheets, and accounting software. Learn more →

Excel output for Krungthai — auto-sized columns with numeric formatting, ready for analysis. Learn more →

QBO-ready output for Krungthai — compatible with QuickBooks Online and Desktop. Learn more →

Xero-ready output for Krungthai — CSV formatted for direct Xero import. Learn more →

Other Thai Banks We Verified for Accuracy