Financial Documents

How to Convert a Capitec Bank Statement to Excel or CSV

Convert Capitec bank statement PDFs to Excel or CSV: app download steps, converter options, cleanup checks, and bookkeeping-ready import tips.

Published
Updated
Reading time
11 min
Topics:Financial DocumentsBank StatementsExcelSouth AfricaPDF conversionCapitecCSV export

To convert a Capitec bank statement to Excel or CSV, first share or download the PDF statement from the Capitec app, then convert the PDF with a table converter or structured extraction tool, and finally check dates, descriptions, debit/credit signs, and balances before import. That is the route for personal accounts, where Capitec gives you a PDF statement. Capitec Business accounts can download their transaction history as CSV or OFX from the app or online banking, or connect a free bank feed to accounting software, so a Business customer often needs no conversion at all (see the Capitec Business section below).

Treat the personal-account route as three jobs:

  • Getting the statement: tapping Share PDF Statement in the Capitec app, or downloading the statement from online banking
  • Converting the statement: turning that PDF into Excel or CSV
  • Cleaning the output: fixing dates, debit and credit columns, running balances, split descriptions, and other extraction issues

A shared PDF may be fine for sending records to an accountant, but it is usually not enough on its own if you need to sort transactions, map categories, reconcile cash movements, or import data into another system. For a usable spreadsheet, start with the statement PDF, convert it, then check the rows before bookkeeping or import.

Capitec banking is heavily mobile-led. ITWeb reported that more than 14.5 million Capitec clients had logged into the app in the previous month in November 2025, so the app is the realistic starting point for most account holders and the bookkeepers working from their statements. The pattern is stricter still at TymeBank, now GoTyme Bank, which has retired internet banking, so GoTyme statements have to be emailed from the app before you can convert them to Excel.

Download or Share the Statement From the Capitec App First

If you are searching for how to download a Capitec bank statement, start with the Capitec app, not with a converter. Capitec's help page explains how to email statements from your phone, so the practical first step is to get the statement PDF out of the app. On a personal account, a typical Capitec app statement download gives you the statement document you can archive or convert later, not transaction rows in CSV or XLSX format.

Capitec's own path is short:

  1. Sign in on the Capitec app and choose the account whose statement you need.
  2. Tap the three dots at the top right, then tap Statement.
  3. Choose the date range, then tap Share PDF Statement and save the PDF or email it to yourself.
  4. Open the PDF and make sure the transaction pages, amounts, references, and balances are all visible before you try to convert anything.

Before you move on, make sure you have the right PDF in hand. Check:

  • The date range matches the month or period you need for bookkeeping, tax work, or reconciliation.
  • The statement includes all pages, not just the first summary page.
  • The transaction table is readable, with amounts, dates, references, and balances visible.
  • You know whether this is the version you want to convert, the version you want to store for records, or both.

A statement generated in the app already carries Capitec's electronic bank stamp, so the same PDF serves a lender, a landlord or SARS without a trip to a branch. If you work at a desk, Capitec's personal online banking also lets you view and download statements, which is often the easier start for a bookkeeper handling several months.

One option in the app is not a download route. With Secure Statement Sharing, a business that Capitec has approved, such as a lender or landlord, sends a request to your cellphone number; you review it in the app, choose the accounts and tap Approve, and the statement goes directly to that business. It leaves you with no file to convert.

The same source-first pattern applies across South African banks; for comparison, see the ABSA and Standard Bank statement-to-Excel guides.

Capitec Business: Export CSV or OFX, or Connect a Bank Feed

Capitec Business accounts have two routes to transaction data that personal accounts do not, both described on Capitec's accounting software integration page:

  • A free bank feed. Capitec Business connects to Xero, Sage, FreshBooks, Zoho, Bookipi, Odoo, Invoice Ninja and ZipBooks. You set it up from inside the accounting software: search for Capitec Business, sign in with your Capitec Business credentials, approve the link, then choose the accounts and the date the feed should start from. Transactions then arrive without any file at all.
  • A CSV or OFX download. For software without a feed, or when you want a spreadsheet, sign in on the Business app or Business online banking, download the transaction history and choose CSV or OFX. The CSV opens in Excel; either file can be uploaded to accounting software.

So if you are asking how to export a CSV from a Capitec Business account, the transaction history download is the answer, not a converter. PDF conversion still earns its place when the statements reach you as PDFs: an accounting practice receiving client statements by email, periods from before the feed was connected, or stamped statements already filed for a lender or an audit.

Choose the Fastest Way to Turn the PDF Into Excel or CSV

Once the PDF is in hand, the fastest method depends less on the word "converter" and more on how much cleanup you can tolerate. If you want a Capitec statement to CSV or a Capitec PDF to Excel file you can actually sort, filter, and reconcile, you still need a conversion or extraction step after downloading the PDF, whether it is a personal statement or a Business statement you hold only as a PDF.

1. Manual copy-paste or one-off cleanup works best for a very short statement, usually when you only need a handful of rows for a once-off task. If the PDF is clean and text-based, you may be able to copy the transactions into Excel, split columns, and save as CSV or XLSX. The downside is obvious: descriptions can break across lines, debit and credit values can shift into the wrong columns, and running balances often need hand-checking. This is fine for a tiny job, but it becomes slow the moment you need reliable line-by-line data.

2. A generic PDF table converter is usually adequate when it can detect tables cleanly from the native Capitec PDF. This is the middle-ground option for short to medium statements where you want something faster than manual repair but do not need a highly controlled output. It can work well if the statement layout is consistent, the text layer is intact, and you only need a CSV for light review. Where these tools often struggle is with description integrity, rows that wrap, balance columns that drift, and repeated formatting fixes after export. A file can look "converted" and still take 20 minutes to repair before it is safe to import.

3. AI extraction is the better choice for longer statements, mixed-quality files, repeated monthly work, or any case where you need consistent columns every time. Instead of hoping the PDF's table structure survives export, extraction software reads the transaction data and outputs a structured spreadsheet. That matters when you need clean dates, payee descriptions that stay together, dependable amount columns, and a usable running balance field. If your real goal is to extract bank statement PDFs into Excel automatically, structured extraction is usually the more reliable route than repeatedly fixing broken tables.

A quick decision rule: use manual cleanup for a few rows, use a generic converter for a clean native PDF you can verify in minutes, and skip straight to extraction software if accuracy matters more than speed on the first export. In practice, a basic converter is good enough for ad hoc review, but not always for bookkeeping, reconciliation, or repeat imports where column consistency matters.

For repeat monthly statements, structured extraction is faster than repairing the same columns by hand. Invoice Data Extraction returns one row per transaction with the columns you ask for, such as date, description, debit, credit, and balance, in the same layout every month, and you download the result as Excel, CSV or JSON. If you want a broader comparison first, see other methods for converting bank statement PDFs into Excel.

Clean, Categorize, and Reconcile the Export

A converted file is only useful if you can trust it. Before you import a converted Capitec statement into your bookkeeping model, tax workbook, or accounting system, run a short cleanup pass so the data is usable in both CSV and XLSX form.

Start with the fields that break downstream reporting fastest:

  • Normalize the date column. Pick one format for the whole sheet, ideally YYYY-MM-DD if you want fewer import issues across systems. If some rows came through as text and others as real dates, fix that before you sort, filter, or save.
  • Check debit and credit signs. Make sure money out is consistently negative and money in is consistently positive, or that you have separate debit and credit columns with no mixed logic. Reversals are where mistakes often show up.
  • Rename vague description fields. If the converter created columns like Description 1, Description 2, or Notes, combine or relabel them into something you will still understand later, such as Transaction Description, Reference, or Channel.
  • Remove statement noise. Delete repeated page headers, footer text, page numbers, watermark fragments, and any duplicated opening labels that are not actual transactions.
  • Reconcile the extracted output back to the statement. Count the transaction rows, compare opening and closing balances if shown, and spot-check that the running balance still makes sense after cleanup.

Pay extra attention to layout artifacts. A Capitec PDF with an electronic bank stamp, the SkyQR verification code at the top right, a watermark, or other overlay text can push values into the wrong columns or split one transaction across two rows. If a date looks shifted, an amount appears in the description field, or a balance disappears on one line only, go back to the source PDF and verify that row before you trust the extract.

Check bank fees, reversals, cash deposits, and transfers line by line, because small sign or description errors can change the bookkeeping treatment. If the PDF is password-protected, low quality, or only available as a screenshot, go back to the cleanest original statement file before repairing a bad export.

For South African bookkeeping workflows, keep the date format, decimal style, and column separators stable before you save the final file. If you export to CSV, reopen it once before importing anywhere else to confirm the delimiter has not split amounts or references into the wrong columns.

For South African small businesses, review the sheet in batches: receipts, supplier payments, debit orders, Capitec fees, transfers, salaries, VAT-related payments, and owner drawings. Add a Category column for the bookkeeping bucket and a Matched To or Reference Check column for reconciliation. If you want a more detailed system for categorizing exported bank transactions for bookkeeping, build it around how you report income, expenses, and balance sheet movements.

For reconciliation, match each statement row to an invoice, cashbook entry, supplier bill, payroll run, card expense, or accounting entry. If the row does not tie out, investigate it before import. For the full control process, use this guide to turning converted transactions into a bank reconciliation workflow.

Before you import anything or hand the file to your accountant, finish the cleanup, categorize every line, reconcile it against the source records, investigate exceptions, and save the final version as CSV or XLSX.

If the final file is for accounting software, shape the CSV to that import format before upload; South African teams commonly need Xero, Sage, or accountant-ready CSV columns. A Capitec Business account can skip this step by connecting the bank feed or uploading its own CSV or OFX download; the shaping is for statements converted from PDF. The Xero bank statement import guide and Sage bank statement import guide cover those downstream formats. If cleanup repeats every month or across several Capitec statements, it is usually time to switch to a structured extraction workflow.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours