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.
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?
Why not download transactions from online banking instead?
How should I post bank fees?
Any bank, any country