ING BankのPDF明細書をCSV・Excelに変換

ING Bankの口座と明細書の課題

これまでに確認・精度検証済みの明細書フォーマットです。

この明細書の変換結果を見る

ING Bankの銀行明細書の合成サンプル例

Splurge

普通預金

このフォーマットでよくある注意点：

Running Balance Cross-Check

ING Bank 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

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

Currency Symbols Breaking Numeric Parsing

ING Bank (Australia) 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.

Transactions Listed Newest-First

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

Inconsistent Date Formats

ING Bank Australia 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.

他4件の課題を見る他2件の課題を見る

この明細書の変換結果を見る

ING Bankの銀行明細書の合成サンプル例

Savings Maximiser

普通預金

このフォーマットでよくある注意点：

Running Balance Cross-Check

ING Bank 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

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

他1件の課題を見る

この明細書の変換結果を見る

ING Bankの銀行明細書の合成サンプル例

Orange Everyday

個人口座

このフォーマットでよくある注意点：

Running Balance Cross-Check

ING Bank 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

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

Currency Only Shown in Column Header

ING Bank (Australia) Limited 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.

他2件の課題を見る

CSV出力 — Excel、Googleスプレッドシート、会計ソフトと互換性あり。 詳しく見る →

Excel出力 — 数値書式を適用した自動列幅調整で、すぐに分析可能。 詳しく見る →

QBO対応出力 — QuickBooks OnlineおよびDesktopと互換性あり。 詳しく見る →

Xero対応出力 — Xeroへの銀行明細書の直接インポート用にフォーマットされたCSV。 詳しく見る →

Australianの精度検証済み銀行

ANZ

Australia and New Zealand Banking Group Limited

オーストラリア

Bankwest精度検証済み

オーストラリア

Bendigo Bank

Bendigo and Adelaide Bank Limited

オーストラリア

BOQ

Bank of Queensland Limited

オーストラリア