Convert a Bank Statement to CSV (PDF, OFX, QFX, QIF)

Pick Your Source Format

Banks deliver history in different shapes. Structured downloads (OFX/QFX/QIF/CSV) beat PDF every time. Use PDF conversion only when the bank gives you no better option.

Step-by-Step: Structured Bank Export → CSV

Preferred path for accuracy.

• Download OFX, QFX, QIF, or CSV from online banking.
• Convert specialty formats via the Finance File Converter (e.g., QFX to CSV, QIF to CSV).
• Open the CSV in the Online CSV Editor.
• Standardize date and amount columns.
• Export to Excel if stakeholders need XLSX.
• Import into accounting software or reconcile in a spreadsheet.

Step-by-Step: PDF Statement → CSV

Harder—but often necessary.

• Prefer a text-based PDF (selectable text), not a scanned image.
• Use PDF Bank Statement to CSV on Convert CSV Online.
• If pasting is required, copy only the transaction table—skip ads, headers, footers.
• Check that each row has date, description, and amount.
• Reconcile the CSV sum to the statement’s ending balance.

Normalize Columns for Bookkeeping

Create a consistent table even when banks differ.

• ISO dates when possible.
• Signed amounts (outflows negative) or separate debit/credit—pick one.
• Keep bank transaction IDs when present to prevent duplicates.
• Do not delete fees or pending items without a rule.

date,description,amount,balance,fit_id
2026-05-03,CLOUD HOSTING,-39.99,1210.01,txn-2
2026-05-06,CLIENT PAYMENT,2400.00,3610.01,txn-3

Reconcile Before You Trust the File

A CSV that does not tie to the statement is not done.

• Compare row count to visible transactions.
• Sum amounts and match the period’s net change.
• Spot-check first/last transactions of the period.
• Investigate missing days or duplicated downloads.

Real-World Examples

How teams use statement CSV.

Common Mistakes

Reconciliation killers.

• Mixing personal and business transactions in one import.
• Trusting PDF OCR without balancing to the statement.
• Excel date swaps (05/04 vs 04/05).
• Importing overlapping date ranges twice.
• Dropping the FITID/reference column that prevents duplicates.

Best Practices

Bank data deserves controls.

• Prefer OFX/QFX/QIF/CSV over PDF.
• Keep original downloads immutable.
• Reconcile totals every conversion.
• Redact full account numbers before sharing CSV.
• Use Finance File Converter + Online CSV Editor as the cleanup path.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Convert PDF statements and QFX/QIF downloads to CSV, preview in the Online CSV Editor, and hand clean tables to Excel or accounting tools. Client-side workflows work on Windows, macOS, and Linux browsers.

Conclusion

Bank statement to CSV is easy with structured OFX/QFX/QIF downloads and careful with PDFs. Normalize columns, reconcile totals, and keep originals—then bookkeeping becomes spreadsheet math instead of detective work.