CSV import errors usually come from date formats, debit-credit signs, duplicate rows, missing headers, or balances that do not agree to the original statement.
Note
Current as of 9 May 2026. Verify unusual facts against the official source before filing or advising a client.
Answer First
To fix a bank statement CSV import error, first confirm that the CSV has the required columns, consistent date format, clean debit and credit values, no duplicate header rows, no blank total rows, and the same opening and closing balances as the original statement.
Worked Example
A CSV exported from a PDF statement has dates as 2026/04/01, 01-04-2026, and 1 Apr 26 in the same file. Before importing to accounting software, standardise every date into one accepted format and confirm the transaction count still matches the statement.
Quick Reference Table
Error | Symptom | Correction |
|---|---|---|
Date format | Import rejects rows | Use one date format throughout |
Signs reversed | Income appears as expense | Map debit and credit columns correctly |
Duplicate headers | Extra transactions imported | Remove repeated page headers |
Currency symbols | Amounts fail validation | Remove R signs and separators if required |
Before You Re-Import
Save the original export, fix a copy, and import into a test or review screen first where the accounting platform allows it. Never repeatedly import the same bank period into a live ledger without checking duplicates.
What to Review After Import
Once the CSV imports, check the opening balance, closing balance, first and last transaction, total money in, total money out, and suspense-account movements.
Related Accounter Resources
- Bank Statement Converter
- Bank Statement PDF to CSV
- Bank Statement to Xero Import Prep
- Bank Statement to Sage Import Prep
- Bank Statement to QuickBooks Import Prep
- Bank Statement Scanner
FAQs
Should debit and credit be one column or two?
It depends on the import tool. If your platform expects separate money-in and money-out columns, do not use a single signed amount column.
Can CSV files include currency symbols?
Some importers reject currency symbols. Use plain numeric values unless the platform specifically accepts symbols.
What is the safest import check?
Confirm the imported closing balance and transaction count against the original bank statement before reconciling.