Convert South Africa Bank Statements to Excel or CSV

Choose a native bank export when available. When you only have a PDF, extract the transactions and review dates, amounts and balances before using the spreadsheet.

Last updated: September 17, 2026

South Africa: obtain the bank-issued PDF

Capitec's app lets you select an account, open the three-dot menu, choose Statement and a date range, then share the PDF. See Capitec's official statement guide. Absa's app offers a stamped PDF under the account's Statements tab; its download instructions explain the date selection.

Keep that original file for reference. A spreadsheet is a working copy of transaction data, not a replacement for a bank-issued stamped statement. If a structured bank export is available for your period and software, use it first.

Check rand amounts, fees and debit orders

Match the statement currency to the destination account. The converter does not perform foreign-exchange conversion.
Check debit orders, service charges and reversed transactions against their individual statement rows.
Confirm date order with an unambiguous date and compare the full period, including month boundaries.
Reconcile opening balance plus money in minus money out with closing balance. Exclude page carry-forward totals from the transaction count.
Before importing another month, check the first and last dates against previous files and bank feeds.

For bank-specific preparation, use the Absa Excel guide. If you need Capitec PDF to OFX, read the export limitations first: its currency defaults to USD and account metadata uses placeholders. A reviewed CSV may be more suitable for a ZAR account.

Convert and review your statement

Upload the original unlocked PDF, review the preview against the source, and download the format you need. Resolve missing rows and ambiguous dates before import.

Open the PDF to Excel converter and sample output

South Africa bank conversion guides

These guides describe preparation and review; listing a bank does not certify every account or document layout.

Frequently asked questions

Does a listed bank mean every statement layout is verified?

No. These guides describe a PDF conversion workflow, not a certification of every bank layout. Results depend on the document. Compare the extracted rows and totals with the original statement.

What should I do with a password-protected statement?

Open the statement using the instructions supplied by your bank, then save an unlocked PDF using your PDF software before uploading. Keep the original statement for reference.

Which file should I use for accounting import?

Prefer a native bank export accepted by your software. If you only have a PDF, review the extracted dates, signs, descriptions and totals first. Select the matching account and currency, and exclude transactions already covered by bank feeds or earlier imports.

Next: map a reviewed CSV into Xero or follow the full PDF-to-Excel walkthrough.