How to Convert Nedbank Statements to CSV

Nedbank rounds out South Africa's big four, and its statements come across the bookkeeping desk just as often as the rest. The story is familiar: a Nedbank PDF is fine to read but won't import cleanly into Sage, Xero, QuickBooks, or Pastel without reformatting. Nedbank also has a specific habit — value dates alongside transaction dates — that needs handling, and its statement layout has changed over time, so older and newer statements can look different.

Here's how to convert a Nedbank PDF statement into a clean CSV, and what to watch for.

Why Nedbank statements need conversion

Alongside the usual SA conversion issues, Nedbank brings a couple of its own:

Value dates vs transaction dates. Nedbank statements often include a value date in addition to the transaction date. Accounting software wants a single date, so the extra one needs to be dropped (and you need to choose consistently which date to keep).

Layout changes. Nedbank has updated its statement layout over the years, so a converter or manual process tuned to one version can stumble on another.

No single signed amount column. Debits and credits need restructuring into one signed column.

Running balance. The balance column usually has to be removed for import.

Date format mismatch. As with every SA bank, the date format in the PDF often won't match what your accounting software expects.

Doing this manually means copying transactions into Excel, removing the value-date column, rebuilding the amount column, stripping the balance, and fixing the date format — comfortably a couple of hours for a busy statement, with errors creeping in along the way.

Step 1: Download your Nedbank statement as a PDF

Select the relevant account.

Open Statements.

Choose the date range for the bookkeeping period.

Download the statement as a PDF.

Download the complete statement for the period so every transaction — including fees and interest — is captured and you can reconcile to the closing balance.

Step 2: Convert the PDF to CSV

Upload the PDF to PDF Statement Converter rather than reformatting it by hand. It detects the Nedbank layout (including the different versions) and handles the value-date quirk automatically:

Upload your Nedbank PDF.

The converter extracts each transaction, keeping a single consistent date.

It outputs a CSV with one signed amount column and no balance column.

Download the CSV, ready to import.

Convert your first statement free so you can confirm the right date came through before you rely on it.

Step 3: Import into your accounting software

Sage / Sage Pastel: Use the import or bank-feed function, map the columns, and confirm the date format matches your company settings.

Xero: Use "Import a Statement" and map date, description, and amount.

QuickBooks: Use the upload/import bank transactions flow.

Then verify:

Opening and closing balances match the statement.

The transaction count is correct.

The dates are the ones you intended (transaction date, not value date, unless you chose otherwise).

Nedbank-specific things to watch

Drop the value date. Make sure only one date comes through, consistently, or your reconciliation will drift between months.

Check older vs newer statements. If a client sends a mix of statement layouts, confirm both converted correctly the first time.

Categorise fees. Nedbank service fees and charges need categorising, not removing, for a clean reconciliation.

The bottom line

Nedbank's value dates and changing layouts add to the usual SA conversion headaches. Handling them manually is slow and mistake-prone. An automated converter resolves the date quirk, copes with different statement versions, and gives you a CSV that imports straight into Sage, Xero, QuickBooks, or Pastel.

Ready to convert your Nedbank statements? Try PDF Statement Converter and convert your first statement free.

---

How to Import FNB Statements into Sage One

Sage Import Troubleshooting Guide

Why Converting SA Bank Statements to Excel Doesn't Work for Sage