How to convert a bank statement to CSV

1. Use the CSV export when you need portability

CSV is the simplest format for scripts, imports and spreadsheets. The converter writes UTF-8 with CRLF line endings and a header row, and quotes fields that contain commas or quotes.

2. Check the columns before import

Date, Description, Debit, Credit, Amount, Balance. If your accounting tool expects a single signed Amount column, use Amount. If it expects separate Debit and Credit, map those columns in the import screen.

3. Watch the signs

Money out should be negative in Amount and in the Debit column (as a positive debit value); money in should be positive in Amount and in Credit. Confirm refunds and transfers, which are the rows most likely to land on the wrong side.

4. Import and reconcile

Import into your accounting tool, then match the rows. Keep the original PDF and the CSV; the CSV is a derived file, not the source of truth.