Home › Countries › South Africa › Capitec Bank › Statement to CSV

Convert your Capitec Bank statement to CSV

Based in Stellenbosch, South Africa, Capitec Bank provides statements to its customers as PDF documents in online banking. Upload the statement PDF below and download a CSV file — extracted, normalized and reconciled first.

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

Capitec Bank statements to CSV: what you get

CSV strips the Capitec Bank statement down to portable data: no formatting, no merged cells, just the transactions in a standard column order that imports cleanly into tools that have never heard of this converter.

The main use is long-term archiving in a format that will still open in twenty years. Every conversion is checked against the statement itself: where the statement prints opening and closing (or running) balances, the extracted transactions must add up to them, or the conversion is flagged and the mismatched rows are marked. A statement whose layout the reader cannot parse is reported honestly — never passed off as converted.

Trust in the output comes from the statement's own arithmetic. Capitec Bank prints balances that its transaction list must sum to; the converter repeats that sum independently on the extracted data. Agreement to the cent means the extraction matches the document. Disagreement means the conversion is flagged — the result says so plainly, with the differing rows marked.

Read a Capitec Bank statement as three zones. The header zone names the account and the period — check those first, because a wrong-period PDF converts beautifully and reconciles against the wrong month. The middle zone is the transaction list itself. The closing zone carries the balances and any fees or interest summaries; it is the closing zone the reconciliation check answers to, and the first place to look when a conversion is flagged.

In South Africa, bookkeepers commonly work in Sage, Xero and QuickBooks; the Excel and CSV exports from this converter are the files those tools import, and the Xero export is laid out for direct import where the tool accepts it.

Working from Capitec Bank statements as a bookkeeper

Ask clients for the issued PDFs rather than portal screenshots or spreadsheet exports. The PDF is the only version that carries the balances the check needs, and a folder of monthly PDFs plus their conversion results is an audit trail that assembles itself.

Before you use the file

A CSV carries no formatting to hide behind, which is its virtue: what you see in a text editor is exactly what an importer will read. If a figure looks wrong in the file, it was flagged in the check — compare that row with the PDF before importing.

How to download a statement PDF from Capitec Bank

  1. Get the statement from Capitec Bank itself. Capitec Bank customers with several accounts should download from each account separately — statements are issued per account.
  2. Pick the account and the month. Statements usually live under the account menu, labelled Statements, Documents, or eStatements, depending on the bank.
  3. Set the period you are converting. One PDF per statement period converts cleanest. For a full year, download all twelve periods before you start.
  4. Save the PDF, do not screenshot it. A downloaded PDF carries the text layer the converter reads. If the portal only offers a print view, print to PDF instead of taking a picture.
  5. Convert it on this page. Upload the PDF above and check the reconciliation result before you download the converted file.

These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.

Tip: where the portal shows a 'final' or 'corrected' version of a statement, convert that one — reissued statements supersede the original figures.

Questions and answers

How do I convert a Capitec Bank statement to CSV?

Save the statement as a PDF from Capitec Bank online banking, add it to the converter above, and take the a CSV file it produces. Extraction, column normalization and the reconciliation check all happen before the download is offered.

What date and number formats do Capitec Bank statements use?

Capitec Bank statements generally print dates as the order printed on the statement itself and amounts with the grouping printed on the statement itself. The converter reads the figures as printed and normalizes the output columns the same way for every bank.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

What columns does the converted file have?

Date, Description, Amount, Debit, Credit and Balance — the same normalized columns for every bank, so a Capitec Bank file and a file from any other bank in South Africa can be imported and reviewed the same way.

What happens if my Capitec Bank statement does not reconcile?

The conversion is flagged, and the rows whose running balance disagrees with the statement are marked with the expected and printed figures. Nothing is silently adjusted — you see exactly where the statement and the extraction part company.

Can I convert a scanned Capitec Bank statement?

Yes. Scans and photo-based PDFs are read with OCR and marked as OCR-extracted. The reconciliation check applies identically; on a poor scan it is the check that tells you whether the read can be trusted.

Do I need an account to convert a Capitec Bank statement?

No. There is no sign-up: upload the PDF, check the reconciliation result, download the file. Uploaded files and exports are deleted automatically within 15 minutes.

Which file should I upload — the PDF or a portal CSV export?

The statement PDF. It is the issued document and it carries the opening and closing balances the reconciliation check verifies against; a portal CSV has the transactions but nothing to prove them against.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Other formats for Capitec Bank statements

Capitec Bank statement to Excel

Convert the same Capitec Bank statement PDF to Excel instead.

Capitec Bank statement to OFX

Convert the same Capitec Bank statement PDF to OFX instead.

Capitec Bank statement to Xero

Convert the same Capitec Bank statement PDF to Xero instead.

Back to the Capitec Bank statement converter hub or the South Africa bank directory. Other South Africa banks: Standard Bank statement to CSV · First National Bank statement to CSV · Absa Bank statement to CSV · Nedbank statement to CSV

Bank statements in. Clean books out.

Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.

Convert a statement — free