← All ResourcesResource

Bank Statement Columns Explained

Bank statements organize transactions into predictable columns — dates, descriptions, debits, credits, and balances. Understanding these fields is essential for accurate imports and reconciliation.

Last updated: 3 min read

Standard Bank Statement Columns

Whether in PDF, CSV, or Excel format, bank statements organize financial activity into predictable columns. Understanding these fields is essential for accurate reconciliation and accounting imports.

Core Transaction Columns

  • Date — when the transaction posted
  • Value Date — when funds cleared (common in international statements)
  • Description — payee, reference, or narrative
  • Debit — withdrawals and payments
  • Credit — deposits and incoming transfers
  • Balance — running total after each transaction
  • Reference — check number, transaction ID, or bank reference

Layout Variations by Bank

Different banks use different column orders, date formats, and amount presentations. Indian banks may show Dr/Cr columns. US banks often combine debits and credits into a single Amount column with signs.

Tip

When converting PDF statements, choose a converter that normalizes varying layouts into consistent Excel or CSV columns.

Frequently Asked Questions

Why do my CSV columns not match my PDF?
PDF layouts vary by bank. A good converter maps varying PDF structures into standardized columns during extraction.

Related Resources

Related Formats

Convert Bank Statements Automatically

Upload your PDF bank statement and convert it into Excel, CSV, QBO, or accounting-ready formats within seconds.

Convert Statement Now