How to Convert a Nedbank Statement to Excel or CSV

Start by checking the format options in Nedbank Online Banking. If CSV or Excel is available for your account and date range, download that and skip conversion. If your source is an OFX/OFC file, a Money App PDF, a historical PDF, a scanned statement, or an encrypted .emc file, you need a conversion step before the data is usable in a spreadsheet.

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: native OFX/OFC exports from online banking, 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.

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)

The desktop online banking platform usually offers the most export flexibility. Navigate to Enquiries → Statements, select your account and date range, and open the Export dropdown. Check the format list first: depending on the account, period, and Nedbank interface, structured options may include CSV, OFX, OFC, and sometimes Excel/QIF.

CSV or Excel — use this when your goal is spreadsheet work.
OFX or OFC — use this when you are importing into accounting software that accepts bank-feed formats.

If CSV or Excel is not available, OFX/OFC still gives you machine-readable transaction data. You can import OFX files into Sage Pastel, Xero, and several other SA-focused accounting packages for bank reconciliation, or convert the OFX file to CSV when you need a spreadsheet for VAT working papers, custom analysis, or a client transaction summary.

Nedbank Money App

The Money App supports PDF statement downloads only. There is no OFX, OFC, or any other structured export option. If you do most of your banking through the app, your only native output is a PDF file, which means you have no direct path to spreadsheet data without a conversion step.

A Nedbank Money App statement download gives you a formatted document, not usable data.

NetBank Business

Business users should first check NetBank Business or Business Hub statement export and reporting options, especially where statement data can be exported into line-of-business software. Use PDF extraction only where the available file is PDF, .emc, scanned, or unsuitable for the target accounting package.

Historical Statement Fees

Nedbank charges R11 per statement for any statement older than three months. For bookkeepers and accountants pulling several months of historical data 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.

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, available for Windows and Mac).
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 files from Nedbank Online Banking, you can convert these to spreadsheet format. Excel's Power Query can import OFX data directly: go to Data > Get Data > From File, select the OFX file, and transform the resulting table. Alternatively, third-party OFX converter utilities will output CSV or XLSX. This method produces clean, structured data because OFX is already machine-readable.

OFX exports are only available through Nedbank Online Banking, cover the available statement periods in that channel, and do not help 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, typically within minutes.

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. 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.