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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Capitec statement into Excel
-
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.
-
Upload it here
Scans and phone photos work too.
-
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.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | 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.
-
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?
My Capitec PDF asks for a password. Can I still convert it?
Can I import converted Capitec rows into QuickBooks or Xero?
Convert your Capitec statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Capitec.