StatementNestTry the sample

Bank statement PDF to CSV: keep dates and amounts correct

A CSV stores rows as plain text. It is useful for moving transaction data between tools, but importing it with the wrong settings can change dates, amounts or descriptions.

Use clear columns

A useful starting structure is Date, Description, Amount, Balance and Source page. Balance is optional. Keep different currencies separate or add a currency column; never total unrelated currencies together.

Date,Description,Amount,Balance,Source page
01/10/2026,Opening transaction,500.00,1500.00,1
02/10/2026,Office supplies,-40.00,1460.00,1

This is a fictional example. The date format is day/month/year. A destination may require separate debit and credit columns or another date format: check its import specification first.

Import deliberately

  1. Use your spreadsheet's text/CSV import command so you can inspect the preview.
  2. Select the correct delimiter and character encoding. Descriptions containing commas need proper quoting.
  3. Set the date column to text if you need to preserve the original dates. An ambiguous date such as 01/10/2026 can be interpreted differently by different locales.
  4. Confirm that decimal points, decimal commas and negative amounts import correctly.
  5. Compare row counts and totals with the PDF before using the file.

Check descriptions as well as numbers

Descriptions should be data, not spreadsheet formulas. Be careful with untrusted text beginning with characters such as = or +. Review how your destination handles those cells. CSV exports also need proper escaping for quotation marks and line breaks.

CSV does not guarantee accounting compatibility

Each accounting tool has its own required headings and formats. Do not assume a generic CSV is ready to import into your ledger. Test a small fictional file before importing real financial records.

Try source review first

The StatementNest public demo shows a fictional sample and lets you compare parsed rows with their source pages. It does not currently convert personal PDFs, download CSV files or accept subscriptions. For the broader workflow, read the Excel review guide.