OfflineStatementCapitec statement PDF to Excel
Drop a Capitec statement PDF and get a spreadsheet of dates, descriptions, money in, money out and balances. The PDF is read on your device; there is no upload.
Drop statement PDFs hereor click to choose filesTap to choose a statement PDF
Free: 3 statements a day, no sign-up.
Bank not supported yet? Email the bank name and country to [email protected] and we'll add it. No need to send your statement.
How your statement stays private
- Your PDFPick a statement from your computer or phone.
- Read in this tabThis page reads it on your device and never sends the file anywhere. Turn off your wifi after the page loads and it still works.
- Your spreadsheetThe rows go straight into a file in your downloads.
Works with most banks
Reads text-based PDF statements with debit/credit or single-amount columns, in US, UK, European, Indian and Indonesian number formats. Password-protected e-statements work too, and the password stays on your device.
Checked, not guessed
Every statement gets a running-balance check: if a row doesn't add up to the printed balance, we highlight it, so nothing goes into your books wrong.
Hours of typing, done in a minute
Free: preview every transaction and download the first 25 as a CSV.
Pro: every transaction, a year of statements in one file, Excel, QuickBooks, Xero and OFX. See pricing
How to download your Capitec statement as a PDF
- Open the Capitec app and find the account.
- Tap the three dots next to it, then Email Statement, and pick the months you need. Menu names change from time to time.
- The statement arrives as a PDF attached to an email: save the attachment.
Then drop the PDF in the box above, or click it to choose the file.
What you get
Capitec statements usually print Posting Date, Transaction Date, Description, Money In (R), Money Out (R) and Balance (R), with dates such as 03/09/2026 and amounts such as -1 245.30. The converter takes the posting date (the one the balance follows), maps Money In to Credit and Money Out to Debit, and reads amounts with a space between thousands. Capitec posts each fee as a row of its own (Payment Fee, Immediate Payment Fee, SMS Payment Notification Fee), so those rows stay in the file and the running balance checks on every one. The (R) in the headings sets rand as the currency for the Pro OFX export.
Capitec's PDF carries a bank stamp drawn over the page. Where the stamp lands on a row, its words can end up in that row's description, or its amount can be misread; a misread amount is highlighted by the balance check. Compare the rows near the stamp with the PDF. Newer statements can also print a separate Fee column; check fee rows the first time you convert one.
How it works, and what it can't do
OfflineStatement is a general reader for text-based PDF statements: it finds the transaction table by its column headings and turns each dated row into a spreadsheet row. It was not built with or tested by Capitec, and statement layouts change, so check the result against the PDF. Where the statement prints a running balance, every row is checked against it and rows that don't add up are highlighted. Scanned or photographed statements (images, not text) are not supported. Password-protected PDFs work: you type the password and it stays on your device.
Open the CSV in Excel, Google Sheets or QuickBooks
Excel: double-click the CSV, or use Data > From Text/CSV. Google Sheets: File > Import > Upload, then choose the CSV. QuickBooks Online: the bank-upload CSV needs Date, Description and Amount; Pro exports exactly that format (see PDF to QuickBooks), or you can trim the free CSV to those columns.
Other bank guides: Chase · Bank of America · Wells Fargo · Capital One · American Express · Citi · U.S. Bank · PNC · TD Bank · Discover · Apple Card · Truist · Navy Federal · HSBC UK · Barclays · Lloyds · NatWest · Santander UK · Monzo · Halifax · Nationwide · Starling · TSB · first direct · RBC Royal Bank · TD Canada Trust · Scotiabank · CommBank · Westpac · ANZ · NAB · BMO · CIBC · SBI · HDFC Bank · ICICI Bank · Axis Bank · Kotak · PNB · Bank of Baroda · Canara Bank · Union Bank of India · IDFC FIRST Bank · Yes Bank · Indian Bank · IDBI Bank · UCO Bank · Bank of Maharashtra · South Indian Bank · Bandhan Bank · IndusInd Bank · Federal Bank · Bank of India · Central Bank of India · FNB · Absa · Standard Bank · Bank of Ireland · AIB · Maybank · DBS / POSB · OCBC · UOB · Any bank
Capitec and the other bank names on this site are trademarks of their respective owners. OfflineStatement is an independent tool by Tofu Labs and is not affiliated with, endorsed by or sponsored by any bank.
FAQ
Is this a Capitec tool?
No. OfflineStatement is independent and not affiliated with or endorsed by Capitec Bank Limited.
Can I put a whole tax year in one spreadsheet?
Yes, with Pro. The South African tax year runs from 1 March to the end of February: drop those statements together and they are merged into one file, oldest first, with duplicate transactions removed. Handy for a budget or the books of a side business. The free version converts one statement at a time.
Is my statement uploaded?
No. The PDF is read by code running in your browser. There is no server that receives your file, and you can disconnect from the internet after the page loads. Pro checks your license about once a day when you're online and keeps working offline in between.
Is it free?
Previewing a statement and downloading a CSV of its first 25 transactions is free. Pro gives you every transaction, batches of statements, Excel .xlsx and QuickBooks, Xero and OFX files.