How to Prepare Bank Statement CSVs for Accounting Import
Updated 5 May 2026 · 3 min read · 3 steps
Clean and review extracted bank statement CSV files before importing into accounting software.
Step-by-Step Guide
- 1
Check required columns
Most imports need date, description, money in, money out, and sometimes balance columns. - 2
Normalize dates and currency
Confirm date format and currency before importing into your bookkeeping software or a spreadsheet. - 3
Remove import blockers
Look for duplicated headers, blank rows, merged descriptions, and reversed debit or credit signs.
Frequently Asked Questions
Can Accounter import directly into accounting software?
This workflow prepares CSV for import review rather than claiming direct integration.
More How-To Guides
- How to Register for VAT in South AfricaHow to register for VAT in South Africa: mandatory at R2.3 million taxable supplies, voluntary from R120,000. File VAT101 on SARS eFiling with CIPC certificate and bank letter. Approval in 1–21 days.
- How to Calculate PAYE in South AfricaHow to calculate PAYE on salary in South Africa: annualise gross pay, apply SARS 2026/2027 brackets, subtract rebates and medical credits, divide by 12. Free PAYE calculator included.
- How to File Provisional Tax in South AfricaComplete guide to provisional tax in South Africa. Learn who must pay, how to calculate payments, and deadlines for IRP6 submissions.
- CIPC company registration: how to register a company in South AfricaRegister a Pty Ltd with CIPC online: reserve a name, file the CoR14.1 with a standard MOI, then register for tax with SARS. Steps, fees and documents.