QuickBooks and Xero
South African bank statements to QuickBooks or Xero
Convert FNB, Absa, Standard Bank, Nedbank and Capitec statements (PDF or CSV) into files QuickBooks Online and Xero import, with South African date and number formats handled.
The short answer
South African statements often use DD/MM/YYYY dates, spaces as thousand separators (R 1 234,50 or R 1 234.50), "Cr"/"Dr" markers and separate debit and credit columns, which QuickBooks and Xero reject as-is. Convert them to one date format and plain signed amounts, remove balance and total rows, then import.
How to do it with Rowvio
- 01Download the statement from internet banking as PDF or CSV (PDFs are often password protected with your ID or account number; Rowvio asks for it and keeps it in your browser only).
- 02Drop it into Rowvio and set your region to South Africa.
- 03Choose QuickBooks Online or Xero.
- 04Check the preview: Cr/Dr, spaces and commas in amounts are converted to plain numbers.
- 05Download and import.
What changes for South African files
| R 1 234,50 / R 1 234.50 | → 1234.50 |
| 123.45 Dr / (123.45) | → -123.45 |
| 03/09/2026 | read as 3 September (day first) |
| Separate Debit and Credit | → one signed Amount (or kept as 4 columns for QuickBooks) |
| Afrikaans month names (Okt, Mei, Des) | read correctly |
Common errors and what causes them
Dates swapped in QuickBooks US settings
The company file uses MM/DD. Pick the date format on the mapping screen to match the file.
Statement PDF will not open
It is password protected; most banks use your ID number or account number.
Amounts like "1 234,50" import as text
Spaces and commas must be removed before import.
Questions
Which banks does it work with?
Any bank whose statement has a text layer or a clear scan. Rowvio reads the table layout rather than a fixed bank template, and you can save a template for your bank.
Is it built for South Africa?
Yes. Rowvio is made by TaskMind in South Africa and handles ZAR formats, Afrikaans month names and SA phone numbers (+27).
Is my statement uploaded?
Files are processed in your browser and never uploaded to Rowvio's servers.
Do it in two minutes
- ✓ Free preview of every change
- ✓ Processed in your browser, never uploaded
- ✓ Free for beta testers, 10 files a day
Related
QuickBooks, Xero, Salesforce, HubSpot, Shopify and Mailchimp are trademarks of their respective owners. Logos are shown only to identify the import formats Rowvio prepares files for. Rowvio is an independent product by TaskMind-AI and is not affiliated with, partnered with, or endorsed by any of these companies.