Bank statement to CSV format for bookkeeping
Which CSV columns to use when converting bank statements for review, cleanup, and accounting software imports.
Who this is for
People preparing transaction files for bookkeeping or accounting software.
Use different CSV formats for review and import
A review CSV can keep separate debit, credit, and balance columns because that makes mistakes easier to spot. An import CSV often needs fewer columns because accounting tools prefer a single amount field.
Recommended review columns
For cleanup work, keep enough information to trace each row back to the original PDF statement. The review file should make mistakes visible before anything touches accounting software.
- Date
- Description
- Debit
- Credit
- Balance
- Flag or notes
Recommended import columns
For QuickBooks and many accounting imports, the file is usually reduced to Date, Description, and Amount. Charges and deposits are represented with opposite signs in the amount column.
- Date
- Description
- Amount
Step-by-step workflow
Extract to a review table
Start with Excel or standard CSV so you can inspect the original debit, credit, and balance columns.
Remove non-transaction rows
Delete repeated headers, page footers, balance summaries, and informational rows that are not actual transactions.
Normalize amounts
Convert debit and credit columns into a single signed amount only after you trust the extracted rows.
Save the import CSV
Export the final import file separately from the review workbook so you keep an audit trail.
Review checklist
- Dates use one consistent format
- Descriptions do not contain line-break fragments from another row
- Amounts use plain numbers without currency symbols
- Deposits and withdrawals have correct signs
- The import file has no repeated statement headers
Frequently asked questions
Should bank statement CSV files include a balance column?
Keep balance in the review file when available, but many accounting imports do not need or accept a balance column.
Why does my CSV import fail?
Common causes are wrong date format, currency symbols in amount fields, duplicate headers, or charges and deposits using the wrong sign convention.