For bookkeepers in South Africa

PDF bank statement converter for South African bookkeepers

Convert clients’ PDF statements into files for Xero, Sage, QuickBooks Online or Excel, with the opening and closing balances checked before you import anything.

  • Choose the date format on export
  • Xero, Sage and QuickBooks
  • Try 3 pages free

Converting a South African statement

ItemWhat you get
DatesRead as printed; exported as DD/MM/YYYY, MM/DD/YYYY or YYYY-MM-DD
AmountsRand, two decimal places, no R sign or thousands separators
Bank details for OFXBranch code and account number
XeroXero statement CSV or OFX
Sage AccountingOFX, or CSV
QuickBooks Online3- or 4-column CSV

Statements from South African banks

Clients bank with FNB, Standard Bank, Absa, Nedbank and Capitec, and with Investec, Discovery Bank, TymeBank and others. Statements print dates in several styles, day first, year first or with the month name, and the converter reads each date as printed. You choose the format of the dates in the exported file.

There’s no list of supported banks to wait for: the converter reads each statement’s layout instead of relying on a template per bank. It’s designed for English-language PDF statements. Results vary by layout, so try one of your client’s statements with the free pages before you rely on it.

Xero in South Africa

Xero only reads PDF bank statements for organisations in the US and Canada. Everywhere else, a PDF has to become a CSV or OFX file before Xero will import it. Export the Xero statement CSV, or OFX with the branch code and account number, and import it with Manage account › Import a statement.

Sage Accounting and QuickBooks Online

Sage Accounting lists OFX among the bank statement files it imports, so OFX is usually the easiest route; the general CSV works if you’d rather map columns. For QuickBooks Online, export the 3-column CSV with one signed amount, or the 4-column layout, and check the column matching before you accept the upload.

Client data

Files and results are deleted 24 hours after upload, or straight away if you delete them. Before uploading client statements, read the privacy notice: it names every company that processes statement data and where.

Questions

Does it work with my client’s bank?

It reads the layout of English-language PDF statements rather than using a template per bank. Convert one statement with the free pages and see whether it balances.

What does it cost?

Prices are in US dollars: try 3 pages free as a guest or get 15 free pages with a free account, then credit packs from $9 for 60 pages or Pro at $29 a month for 400 pages.

Which branch code do I use for OFX?

Use the branch code your client’s bank gives for the account, which for most South African banks is a single universal branch code.

Try it on one of your statements

No account needed. The file is deleted within 24 hours.

Convert a statement