How to Fix Bank Statement CSV Import Errors
Troubleshoot date, amount, header, currency, and duplicate-row issues when importing statement CSV files.
Step-by-Step Guide
Check the header row
Make sure your CSV has clear date, description, debit, credit, and balance headings.
Fix date and amount formats
Import tools can reject mixed date formats, commas in numbers, or currency symbols in amount columns.
Compare against the PDF
Use the original statement to resolve missing rows, duplicate rows, or sign errors.
Frequently Asked Questions
What causes most CSV import errors?
More How-To Guides
How to Register for VAT in South Africa
Step-by-step guide to VAT registration with SARS. Learn when you must register, what documents you need, and how to complete the process online.
Read guideHow to Calculate PAYE in South Africa
Learn how to calculate PAYE tax for employees using SARS tax tables. Step-by-step guide with examples and current tax brackets.
Read guideHow to File Provisional Tax in South Africa
Complete guide to provisional tax in South Africa. Learn who must pay, how to calculate payments, and deadlines for IRP6 submissions.
Read guideHow to Register a Company with CIPC in South Africa
Complete guide to registering a Pty Ltd company with CIPC in South Africa. Name reservation, documents needed, online process, and costs.
Read guideSimplify your accounting with Accounter
South African accounting software built for accountants, bookkeepers, and small businesses. VAT, PAYE, and compliance — all in one place.
View pricing