South African bank statements into Excel

South African statements usually arrive as PDFs: emailed eStatements, stamped copies for a bond application, or a six-month statement for a lender. Few personal banking sites offer a CSV, so the PDF is where the numbers start, with fees sitting among the transactions and amounts carrying an R prefix. Pick your bank, or upload a statement.

Currency
South African rand (ZAR)
Date order
Day first, DD/MM/YYYY
On every line
Amount and running balance
Common imports
Sage Accounting, Xero

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

Banks

South African banks and what their statements do

Big banks 5

  • Standard Bank

    The app offers a 6-month statement and stamped copies; Internet Banking reaches back 24 months.

  • FNB

    Each statement comes verified or unverified; the latest 12 are free, older ones cost a fee.

  • Absa

    Emailed eStatements are password protected, and the online archive keeps two years.

  • Nedbank

    Downloaded statements carry an e-confirm stamp; the last three months are free, older ones R11 each.

  • Capitec

    The app emails a statement for any date range you pick, with an electronic bank stamp.

Digital and private banks 3

  • Discovery Bank

    Three months of certified statements can arrive in a single attachment.

  • GoTyme Bank (TymeBank)

    Statements from before February 2026 may say TymeBank; both names are one account history.

  • Investec

    Statements share a screen with tax certificates and visa letters, so check you have the right files.

Statement layout

What South African statements look like

Rand amounts and fee rows

Amounts carry an R prefix and often spaces between thousands, which Excel reads as text. Monthly fees and transaction charges sit between purchases as lines of their own. They keep their own signed rows, so bank charges can be coded apart and the balance still adds up.

Stamped, verified and certified copies

FNB's verified statements, Nedbank's e-confirm stamp and Capitec's electronic stamp make a PDF fit for official use. The stamp identifies the document, not a transaction, so it stays out of the rows, and an unstamped copy converts the same way.

Date ranges you choose

Capitec's emailed statements and Standard Bank's 6-month statement don't follow calendar months, so files often overlap. Upload them together and repeated days are flagged before anything is counted twice.

Output and review

What you get back, and what's checked

Each statement comes back as rows of date, description, signed amount and balance: Excel, CSV, JSON, or a CSV laid out for Xero or QuickBooks. The printed balances are compared with the ones the transactions produce, from opening to closing. Signed in, a run of statements for one account is also checked for missing, overlapping and duplicate periods.

Benchmark vs free tools

Sage and Xero

  • Sage Business Cloud Accounting

    Sage imports a CSV statement with Date, Description and Amount columns, payments negative and receipts positive, which is the shape of the QuickBooks CSV. Reconcile one statement period at a time.

  • Xero

    Xero's manual statement import takes CSV but not PDF. Import the Xero CSV into the matching account; Xero keeps your column mapping for the next file.

    Step-by-step import guide

FAQ

Questions about South African bank statements

Do I need the stamped statement to convert it?
No. The stamp matters to a bank, landlord or embassy, not to a spreadsheet. Convert whichever version you have and keep the stamped PDF for whoever asked for it.
Why not download transactions from online banking instead?
Where it's offered, as at Nedbank and Discovery Bank, a download is fine for a working file. The statement adds the opening and closing balances that accountants and lenders usually ask for.
How should I post bank fees?
Each fee converts as its own negative row. Post it to a bank charges account rather than to the purchase beside it, and the balance check still adds up.

Any bank, any country

Bank statement converter