How to Prepare Bank Statement CSVs for Accounting Import
Clean and review extracted bank statement CSV files before importing into accounting software.
Step-by-Step Guide
Check required columns
Most imports need date, description, money in, money out, and sometimes balance columns.
Normalize dates and currency
Confirm date format and currency before importing into Xero, QuickBooks, Sage, or spreadsheets.
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?
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