Convert Capitec bank statements to Excel or CSV

Capitec's app can email you a statement for a date range you choose, with an electronic bank stamp, and online banking lets you view and download statements as well. Either way you end up with a PDF. If you need Capitec transactions in a spreadsheet, for SARS, a bond application or a small business's books, upload it here for Excel or CSV.

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.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Capitec statement into Excel

  1. Download the PDF statement from Capitec online banking

    • Sign in to Capitec online banking or the Capitec app.
    • Open the account and go to its statements or transaction history.
    • Choose the statement period and download the statement as a PDF.
    • Save the statement for the period you need as a PDF.
    Go to Capitec Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Capitec statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · ZAR
Sample bank statement rows with made-up data, amounts in ZAR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Capitec statements

Emailed with an electronic stamp

Statements emailed from the app carry an electronic bank stamp, which is what makes them useful as proof for a landlord or lender. For bookkeeping, the stamp is simply part of the page: it identifies the document rather than any transaction, so the same PDF serves both purposes.

You choose the date range

Because the app asks you for a date range, statements don't have to follow calendar months. Email yourself several and the ranges can easily overlap. Upload them together and duplicate or overlapping periods are flagged before export, so no purchase is counted twice.

Fees between transactions

Monthly fees and transaction charges appear as separate lines among purchases and transfers. They stay as their own rows with negative amounts, so bank charges can be posted to their own account and the balance still reconciles from opening to closing.

Rand amounts as numbers

An R prefix, a space between thousands or a comma separator turns a pasted amount into text that Excel won't add. The output writes every amount as a plain signed number and every date as YYYY-MM-DD, so totals and sorting work straight away.

Output and review

From Capitec PDF to your books

Accounting tip

Xero is sold in South Africa, and its statement import accepts CSV but not PDF, which is why the conversion step matters. Import the Xero-ready CSV: one signed Amount column, money in positive and money out negative, the same layout as Xero's own template.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Capitec statement questions

How do I get a Capitec statement I can convert?
In the app, choose to email a statement and pick the date range; it arrives with an electronic bank stamp. Online banking also lets you view and download statements. Save the PDF from your email or browser and upload it here.
My Capitec PDF asks for a password. Can I still convert it?
Yes. Upload it unchanged and type the statement's password at the prompt. It's used only to open that one file and isn't stored. The converter never needs your banking login or PIN, just the PDF and its password.
Can I import converted Capitec rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Capitec statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Capitec.