Convert a South African Bank Statement to Excel

Standard Bank, FNB, ABSA and Nedbank statement conversion, the ZAR conventions, and verification.

South African bank statements use English-language layouts with rand amounts, and the main conversion issues are structural rather than linguistic.

Fee lines are numerous

South African banking carries more per-transaction fees than most markets. A single month can include dozens of separate fee rows — card purchase fees, cash withdrawal fees, monthly account fees, notification fees.

These are real transactions and belong in the export. A converter that filters small amounts, or that treats fee rows as noise, will leave your debit total short of the printed figure.

Fee rows are often paired with their transaction

A card purchase may generate two rows: the purchase itself and a separate fee. They share a date and a similar description, which makes them look like duplicates to a deduplicating converter.

Both are real. Removing one because it resembles the other leaves your totals wrong and your balance chain broken.

Verifying

Convert the statement Each bank's layout is read from the file itself, not looked up from a list.
Count the rows Fee-heavy statements have high row counts; a low count suggests filtering.
Compare debit and credit totals Missing fee rows show up here as a shortfall in the debit total.
Walk the chain Which confirms every amount was read correctly.

What the export contains

In the file	What you get
The bank's own columns	Every heading as printed, in the same order
Dates	Exactly as printed, with nothing reformatted
Descriptions	In full, each fee on its own row with its own descriptor, never merged into the purchase it follows
Amounts	Every row, however small, each figure in the column the bank printed it in
A Completeness sheet	Every row checked against the printed running balance, and the statement's own totals where it prints them

Analysing bank charges

Because South African statements carry so many fee rows, one genuinely useful thing to do with a converted statement is total the charges for the period.

Filter debits whose description matches the fee descriptors, sum them, and compare against what you expected to pay. People are routinely surprised — and it is the kind of question that is impractical to answer by reading a PDF and trivial in a spreadsheet.

Frequently asked questions

Are Capitec statements supported?

The reader works from the table on the page rather than a list of banks, so a statement from any South African bank is read the same way. The Completeness sheet tells you whether yours came out right.

How do I total my bank charges for the year?

Convert each month, combine the exports, filter debits to fee descriptors and sum. It is a few minutes of work and frequently informative.

Will small fee transactions be included?

Yes. No amount threshold is applied — every row on the statement appears in the export.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.