Bank statement import shows zero rows

Symptom

You upload a CSV of bank statement lines. The preview screen shows zero rows ready to import, even though the CSV clearly contains data.

Cause

The most common causes:

• Wrong CSV format. PropLink supports the standard formats from the major UK banks; an unusual export format may not be recognised.
• Date format mismatch. PropLink expects dates in either dd/mm/yyyy or yyyy-mm-dd. American mm/dd/yyyy is not auto-detected.
• Currency mismatch. The CSV uses a different currency than the bank account.
• Wrong account. The CSV is for a different account than the one you are importing to.
• All rows are duplicates of lines already in PropLink — the importer dedupes by date, amount and description.

Fix

1. Open the CSV and check the date format on a few rows.
2. Compare the column headers with PropLink's expected format under Settings → Financial settings → Bank statement formats.
3. If the bank's format is not standard, configure a bank statement parser under that settings page.
4. Confirm the CSV is for the right bank account.
5. If all rows are duplicates, that is the expected behaviour — PropLink ignores them silently.

Prevent it next time

• Connect a GoCardless Open Banking feed where possible, so CSV uploads are no longer needed.
• For banks that need CSV, save the parser configuration once and reuse.

Still stuck?

Contact PropLink support with a small sample of the CSV (with sensitive details removed). We can add a parser for your bank's format if it is not yet supported.