Convert Capitec Bank Statement to Excel
Capitec statements speak their own dialect: instead of Debit and Credit you get Money In (R) and Money Out (R), and every transaction carries two dates — a Posting Date and a Transaction Date — reflecting when you spent versus when it cleared. Fees aren’t tucked into a separate column either; on a Global One account (a savings-based account rather than a cheque account) each fee appears as its own transaction row. Typing that out by hand means constantly deciding which date to record and which rows are charges. SheetMyBank exports both dates as separate columns, keeps Money In and Money Out distinct, and leaves fee rows identifiable so you can filter them out — or total them — in one click.
Getting the PDF takes under a minute: in the Capitec app, open Save, select the account, choose Email Statement (newer versions offer Download Statement directly), pick last month, three months or a custom range, and confirm with your Remote PIN. The statement comes with an electronic stamp included, so there’s no branch queue for verification copies, and it’s free in-app — major networks even zero-rate the data. Decoding happens on-device in the browser, nothing is transmitted anywhere, and each row’s Money In or Money Out must reconcile with the Balance column or SheetMyBank flags it.
Drop your Capitec statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
Capitec statement FAQ
Posting Date or Transaction Date — which one should my books use?
Both come through as separate Excel columns. A common approach is to reconcile on the Transaction Date, which reflects when you actually made the purchase, and keep the Posting Date for reference when queries arise.
Do I still need a branch stamp on my Capitec statement for a landlord or visa application?
Statements generated in the app already include an electronic stamp, which Capitec provides precisely so customers don’t have to visit a branch for verified copies. Check any specific institution’s requirements, but the app version is built for this purpose.
Why doesn’t my Capitec statement have a separate fees column?
Capitec records fees as ordinary transaction rows under Money Out rather than in a dedicated column. In the converted file they remain individual rows, so filtering the description column surfaces every charge instantly.