How to Convert Capitec Bank Statements to CSV

Capitec is now the largest bank in South Africa by customer numbers, and that popularity shows up in the bookkeeping queue: more and more clients bank with Capitec, which means more Capitec PDF statements landing in your inbox at month-end. The problem is the same one every SA bookkeeper knows — a Capitec PDF is built to be read, not imported. Before you can reconcile anything in Sage, Xero, QuickBooks, or Pastel, that statement has to become a clean, properly formatted CSV.

This guide walks through exactly how to do that, including the Capitec-specific quirks that trip up a manual conversion.

Why Capitec statements don't import cleanly

Capitec keeps its statement layout simple and clean to read, which is great for humans and frustrating for accounting software. A few issues come up again and again:

Transaction types don't map to accounting categories. Capitec uses its own descriptions and transaction-type labels that don't line up with the categories Sage or Pastel expect, so transactions need re-describing or re-categorising after import.

No single signed amount column. Accounting packages usually want one amount column where credits are positive and debits are negative. Capitec presents money in and money out in a way that needs restructuring.

Balance column gets in the way. The running balance is useful on a printed statement but most accounting imports don't want it — and will throw errors if it's left in.

Date format mismatches. The date format in the PDF rarely matches what your accounting software expects (DD/MM/YYYY vs YYYY/MM/DD), and a mismatch is one of the most common reasons an import silently fails.

Do this by hand and you're looking at copy-pasting transactions into Excel, fixing each of the issues above, and testing the import — often two to three hours for a single busy statement.

Step 1: Download your Capitec statement as a PDF

You'll need the original PDF as Capitec issued it:

Open the Capitec banking app or log in to internet banking.

Select the relevant account (cheque/transaction or savings).

Go to Statements.

Choose the date range you need for the bookkeeping period.

Download or email the PDF to yourself.

Tip: download the complete statement for the period rather than a filtered transaction view — accounting work needs every transaction, including fees and interest, to reconcile to the closing balance.

Step 2: Convert the PDF to CSV

Rather than rebuilding the file manually in Excel, upload the PDF to PDF Statement Converter. It automatically detects the Capitec layout, extracts every transaction, and returns a CSV already structured for accounting software:

Upload your Capitec PDF.

The converter detects the format and extracts dates, descriptions, and amounts.

It produces a clean CSV with a single signed amount column and the balance column handled correctly.

Download the CSV, ready for import.

You can convert your first statement free, so you can check the accuracy against your own document before relying on it.

Step 3: Import into your accounting software

With a properly formatted CSV, the import itself is straightforward:

Sage / Sage Pastel: Use the bank feed or import function and map the columns when prompted. Confirm the date format matches your Sage company settings.

Xero: Import via the bank account's "Import a Statement" option, mapping date, description, and amount.

QuickBooks: Use the upload/import bank transactions flow.

After importing, always run a quick check:

Compare the opening and closing balance to the statement.

Confirm the transaction count matches.

Review any transactions that didn't categorise automatically — Capitec's transaction types often need a one-time set of categorisation rules.

Capitec-specific things to watch

Set up categorisation rules once. Because Capitec's transaction descriptions are distinctive, creating a few rules in your accounting software the first time saves repeating the work every month.

Watch for fees and interest. These appear within the transaction list and must be categorised correctly, not dropped, or your reconciliation won't balance.

Match the date format up front. Confirm whether your accounting package expects DD/MM/YYYY before importing — fixing it afterwards is far more painful.

The bottom line

Capitec statements are clean to read but need real reformatting before Sage, Xero, QuickBooks, or Pastel will accept them. Doing it manually is slow and error-prone; an automated converter turns a two-to-three-hour job into a few seconds and removes the formatting mistakes that cause failed imports.

Ready to convert your Capitec statements? Try PDF Statement Converter and convert your first statement free.

---

How to Import FNB Statements into Sage One

Why Converting SA Bank Statements to Excel Doesn't Work for Sage

Sage Import Troubleshooting Guide