Start with Nedbank's own export. In Online Banking, the account's Statements and documents menu downloads transaction history in CSV, OFX, OFC, QIF or Excel for up to five years back, so if the period you need falls inside that window, download CSV or Excel and skip conversion. You need a conversion step only for what that export can't give you: a PDF statement, a scanned copy, an encrypted .emc file, or transactions older than five years.
Nedbank reached 8 million clients for the first time in 2025, while active Money App users rose 14% to 3 million; TechAfrica News also reported a 16% increase in Personal and Private Banking digital transaction values from Nedbank's annual results. A significant share of those clients are accountants, bookkeepers, and SME owners who need Nedbank bank statement data in spreadsheet format for reconciliation, VAT returns, or import into packages like Sage Pastel.
This guide covers every available path: Nedbank's native CSV, Excel, OFX and OFC exports, what the OFC format actually is, handling Nedbank's encrypted .emc files, converting PDF statements to Excel or CSV, and importing the result into South African accounting software. If you also work with FNB accounts, we have a separate walkthrough for converting FNB statements to Excel. For TymeBank, now GoTyme Bank, where statements are emailed from the app because internet banking is gone, see how to turn emailed GoTyme Bank statement PDFs into Excel or CSV.
Nedbank Statement Export Options: Online Banking vs Money App
The export options differ by channel, so check the available format before you start converting files.
Nedbank Online Banking (Personal)
Nedbank's Online Banking how-to guide gives this route for downloading your transactions as data:
- Log in to Online Banking and select the account.
- Under Features, select Statements and documents.
- Click Other.
- Select a period, then choose CSV, OFX, OFC, QIF or Excel.
The same menu holds the two PDF options: the monthly e-stamped statement, and a Provisional statement for a from and to date you choose. Nedbank told MyBroadband in 2021 that Online Banking downloads cover up to five years of transaction history, while Account Overview shows only the last 90 days, and that transactions older than five years come through your branch or banker.
- CSV or Excel: use this when your goal is spreadsheet work.
- OFX or OFC: use this when you are importing into accounting software that reads bank-statement files.
Sage Pastel's Nedbank import takes either OFX or OFC, according to Sage's own guide, and Xero and several other SA-focused accounting packages take OFX for bank reconciliation.
What Is the OFC Format?
OFC (Open Financial Connectivity) is the original Microsoft Money bank-statement format. It is a tag-based text file: tags such as <ACCTID> and <LEDGER> carry the account number and closing balance, and each transaction carries its posting date and amount. Microsoft, Intuit and CheckFree merged it into OFX, the Open Financial Exchange standard, in January 1997, and FNB's OFC file specification notes that Microsoft has discontinued the format and only older versions of Microsoft Money still use it.
South African banks still offer OFC because some accounting packages import it, Sage Pastel among them. Choose OFC only when your software asks for it; otherwise OFX is the import format more packages read. For a spreadsheet, take CSV or Excel, since neither OFX nor OFC opens in Excel as a usable table.
Nedbank Money App
In the Money App, tap More, choose Statements and documents, tap the arrow next to Statements, confirm the account, pick the month and tap the download arrow (Nedbank's help page). That gives you the monthly statement as a PDF. Nedbank has also said the app's Statements and documents section downloads transaction history in CSV, OFC, OFX and Excel for up to five years (in the same MyBroadband piece), so look for that option there first. If your version of the app doesn't show it, use Other in Online Banking instead.
NetBank Business
For Nedbank's business internet banking, Sage's guide to downloading Nedbank internet and business banking statements gives this route: Enquiries > Statements, choose the date range, open the Select to export drop-down at the bottom left, and choose Download to OFC or Download to OFX. Those files go straight into Sage Pastel's bank import. If you bank on Business Hub, check its statement export options first. Use PDF extraction only where the file you have is a PDF, .emc or scan, or where the target package can't read the export.
Historical Statement Fees
Nedbank's 2026 Everyday banking pricing guide gives the latest three months of digital statements free and charges R12 per digital statement older than three months on accounts such as MiGoals; fees vary by account. For bookkeepers and accountants pulling several months of historical statements for reconciliation or audit preparation, these fees accumulate quickly across multiple client accounts. The practical advice: download recent statements promptly each month before they cross the three-month threshold. When you need the transaction data rather than the stamped statement, use the five-year CSV, Excel, OFX or OFC download under Other; the pricing guide lists its R12 against statements and names no charge for that download.
The e-Confirm Stamp
Every Nedbank PDF statement carries an official e-confirm verification stamp, giving the document evidentiary value for legal, audit, and formal compliance purposes. When you convert a Nedbank statement to Excel or CSV, the converted file does not carry this authentication. Always retain the original PDF as your verified source record alongside any spreadsheet versions you create.
When Your Nedbank Statement Is a PDF, .emc File, or Scan
Nedbank PDF statements use a five-column layout: Date, Description, Debit, Credit, and Balance. The difficult column is Description, because Nedbank often packs beneficiary names, branch codes, card references, and payment identifiers into wrapped multi-line text.
Generic PDF-to-Excel tools usually fail for four reasons: they split wrapped descriptions into separate rows, lose embedded reference numbers, mishandle page-break continuations, and knock the running balance out of alignment once any row splitting occurs.
The .emc Encrypted File Problem
Some Nedbank statements never arrive as PDFs at all. Statements delivered via email or downloaded from certain Nedbank channels come as .emc encrypted files. If you have tried to open one of these and got nothing useful, that is expected. The .emc format is a proprietary encrypted container that requires Striata Reader software to decrypt and view.
The workflow to get from .emc to usable data is:
- Download and install Striata Reader (free from Striata, with versions for Windows, Apple devices and Android).
- Open the .emc file in Striata Reader using the password provided by Nedbank (typically your ID number or a pre-agreed passphrase).
- Save or print to PDF from within Striata Reader.
- Convert the resulting PDF to Excel or CSV using a capable converter.
You cannot skip this step. No PDF converter, no matter how capable, can read an .emc file directly.
Scanned Statements Add Another Layer
Scanned Nedbank statements add OCR risk before the layout problem even begins. The converter must first recognise the characters, then parse the Nedbank-specific columns and multi-line descriptions.
Manual Copy-Paste: Quick but Unreliable
Copy-paste rarely produces usable output. Nedbank's multi-line descriptions collapse into a single cell or scatter across adjacent columns, debit and credit amounts misalign, and the running balance can merge with the credit field. It may work for a single page after cleanup, but it does not scale for monthly client work.
OFX Import Route
If you downloaded OFX or OFC files and now want them in a spreadsheet for VAT working papers, custom analysis, or a client transaction summary, the simplest fix for any period inside Nedbank's five-year window is to download the same period again as CSV or Excel. Excel has no built-in OFX import: Power Query's list of connectors includes XML and Text/CSV but nothing for OFX, and OFC and most bank OFX files are tagged text rather than a table. For older OFX files you already hold, third-party OFX converter utilities will output CSV or XLSX, and the result is clean because OFX is already machine-readable.
None of this helps with historical PDFs you already have on file. If your source document is a PDF, you need a different approach.
AI-Powered Extraction for Nedbank PDFs
AI extraction is the practical route when the source file is a Nedbank PDF rather than a native CSV or Excel export. Instead of parsing the visual layout through copy-paste, AI reads the document structure, identifies column boundaries, and maps each transaction to the correct fields regardless of multi-line descriptions or page breaks.
With Invoice Data Extraction, the workflow is:
- Upload your Nedbank PDF statement (or batch-upload multiple months at once, up to 6,000 files in a single job).
- Prompt the AI with what you need extracted and how you want it structured.
- Download a formatted Excel (.xlsx) or CSV (.csv) file.
The AI interprets Nedbank's column layout, keeps multi-line transaction descriptions intact, correctly separates debit and credit amounts, and handles page-break continuations where a transaction starts at the bottom of one page and finishes at the top of the next. Scanned statements and mobile phone photos of printed statements are also supported.
Prompting for Nedbank Statements
The prompt-based approach lets you control exactly what gets extracted and how it appears in your output. For a standard Nedbank cheque account statement, a practical prompt looks like this:
"Extract date, description, debit, credit, and balance from my Nedbank statement. Standardise dates to YYYY-MM-DD format. Keep the full transaction description, including reference numbers, on a single row."
You can adapt this to your specific needs. If you only need debits for expense analysis, say so. If you want a column for transaction type (EFT, debit order, card purchase), the AI will classify based on Nedbank's description text. If you process the same statement format monthly, save your prompt to the Prompt Library and reuse it, ensuring consistent output structure across every period.
For bookkeepers and accountants handling multiple Nedbank clients, batch extraction reduces the month-end handling time: upload the statements, run one saved prompt, and download a consolidated spreadsheet.
Importing Nedbank Statement Data into SA Accounting Software
If the spreadsheet is headed into accounting software, format the columns for the import target before you download the file.
Sage Pastel
Sage Pastel bank reconciliation imports typically need date, reference, description, and amount, although some versions expect separate debit and credit columns. For the destination-specific steps, follow the Pastel Bank Manager file-preparation and import workflow. If you use an AI extraction tool, prompt it for the same layout you use to import bank statements into Sage: date in your Pastel date format, Nedbank transaction reference, full description, and either a signed amount or separate debit/credit columns.
Xero South Africa
If you already downloaded an OFX file from Nedbank Online Banking, upload it directly to the bank feed. For PDF-sourced Nedbank data, export CSV with at least date, amount, and description, plus optional payee and reference fields.
QuickBooks South Africa
QuickBooks Online accepts CSV or QBO bank transaction imports. Keep the CSV clean: consistent dates, numeric amounts without currency symbols, and descriptions without line breaks that could split one transaction across multiple rows.
Scaling Across Multiple Clients
For accountants and creditors clerks processing Nedbank statements for multiple clients, standardise one extraction prompt per accounting platform. Extract once in the right format, import without rearranging. The same principle of streamlining document processing for SA creditors clerks applies whether you are handling bank statements, supplier invoices, or other source documents: consistent extraction templates matched to your downstream system.