How to Convert ABSA Bank Statements to CSV

ABSA is one of South Africa's big four banks, and its statements are a regular fixture in any bookkeeping practice. Like every SA bank, ABSA gives you a PDF that reads perfectly well but won't drop straight into Sage, Xero, QuickBooks, or Pastel. ABSA also has a couple of structural habits — particularly around extra account codes — that catch out a manual conversion.

This guide covers how to turn an ABSA PDF statement into a clean, import-ready CSV, and the ABSA-specific details to watch.

Why ABSA statements need reformatting

The common SA conversion problems all apply to ABSA, plus a few of its own:

Extra account codes. ABSA statements often include additional account codes and reference fields that don't mean anything to your accounting software and can confuse the import if they're not stripped out or mapped.

No single signed amount column. As with other banks, debits and credits need restructuring into the one signed column most accounting packages expect.

Running balance. The balance column needs removing for most imports.

Date format. ABSA's date format frequently won't match your accounting software's expected format, and a mismatch causes failed or misread imports.

Description formatting. Descriptions can carry extra codes or wrap awkwardly, so a careless extraction produces messy or split rows.

By hand, that's a lot of cleanup per statement: pulling out the codes that don't belong, rebuilding the amount column, removing the balance, and fixing dates — often two hours or more for a busy account.

Step 1: Download your ABSA statement as a PDF

Select the relevant account.

Go to Statements.

Choose the date range for the bookkeeping period.

Download the statement as a PDF.

Always download the complete statement for the period — accounting work needs every line, including fees, to reconcile to the closing balance.

Step 2: Convert the PDF to CSV

Upload the PDF to PDF Statement Converter rather than reformatting in Excel. It recognises the ABSA layout and handles the extra codes for you:

Upload your ABSA PDF.

The converter extracts each transaction, leaving out the account codes that don't belong in the import.

It outputs a CSV with a single signed amount column, clean descriptions, and no balance column.

Download the CSV, ready to import.

You can convert your first statement free to check that the extraction matched your statement before relying 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 check:

Opening and closing balances match the statement.

The transaction count is correct.

No stray ABSA codes ended up in your descriptions or references.

ABSA-specific things to watch

Strip the account codes. Make sure any extra ABSA reference codes are removed or deliberately mapped — left in raw, they clutter your ledger and complicate matching.

Confirm the date format first. Set this before importing rather than fixing it afterwards.

Review fee lines. ABSA charges and service fees must be categorised, not dropped, for a clean reconciliation.

The bottom line

ABSA statements add their own wrinkle — extra account codes — on top of the usual SA conversion problems. Cleaning that up by hand is slow and easy to get wrong. An automated converter removes the codes that don't belong, rebuilds the file correctly, and gives you a CSV that imports straight into Sage, Xero, QuickBooks, or Pastel.

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

---

How to Import FNB Statements into Sage One

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

Sage Import Troubleshooting Guide