Bank statement converter

Convert an Absa bank statement to Excel or CSV

Download the statement from Absa Online or the app, save an unlocked copy if it is a password-protected eStatement, and upload it to the converter. Absa's separate debit and credit columns become one signed amount you can total and import.

We are an independent South African site and are not affiliated with, or endorsed by, Absa. The name is used only to say whose statements this page covers.

Absa statements cause one problem more than any other: the emailed eStatement is password-protected, and no converter can read a locked file. Absa does this on purpose, and the fix takes a minute once you know where the password comes from.

After that, conversion is straightforward. Below is where to get an Absa statement that converts cleanly, how to unlock an eStatement, what the converter does with Absa's columns, and how to check the spreadsheet against the PDF before you use it.

How to convert an Absa statement

  1. Download the statement from Absa Online or the Absa Banking App. Absa Online is the better choice for several months, because it keeps archived statements for the past two years.
  2. If it is an emailed eStatement, open it with the password explained in the email's cover letter and save an unlocked copy.
  3. Sign in to Payslip Generator with a free account and open the bank statement converter.
  4. Upload the unlocked PDF. Each page counts once against your free pages for the month.
  5. Check the preview: the number of transactions, the money in and money out totals, and the balance on the last row.
  6. Choose the export you need, such as Excel, CSV, or a file for Xero, QuickBooks or Sage, and download it.

Unlocking an Absa eStatement

Absa eStatements are password-protected, and Absa does not publish the password on its website. The cover letter in the email tells you which password to use. To open the file you need Adobe Reader or Striata Reader, which Absa names as the readers that work.

Opening the file is not enough for an upload, because the PDF itself is still locked. You need a copy saved without the password. The simplest way on most computers:

  1. Open the eStatement with the password from the cover letter.
  2. Choose Print, and as the printer pick Save as PDF on a Mac or in a browser, or Microsoft Print to PDF on Windows.
  3. Save the new file and upload that one. It contains the same statement without the lock.

Our guide to password-protected bank statements covers other ways to save an unlocked copy, and what to do if printing is blocked.

What happens to Absa's debit and credit columns

An Absa statement keeps debit amounts and credit amounts in separate columns. The converter merges them into one: a credit stays positive and a debit becomes negative. The balance column is kept, so you can still follow the running balance row by row.

Descriptions that run onto a second line are joined into one, and rows that are not transactions, such as page footers and the balance brought forward, are left out of the export.

How Absa columns map to the exported file
On the Absa statementIn the exported file
Amount in the credit columnPositive amount
Amount in the debit columnNegative amount
BalanceBalance, unchanged
Balance brought forward, page footersLeft out

Add the net figure shown above the preview to the opening balance on the statement. If you arrive at the closing balance, nothing was dropped or double-counted.

Converting older Absa statements

Absa Online lets you request, view, send or print archived statements for the past two years. On a Transact account, Absa's 2026 pricing guide charges R10.00 for each archived statement digitally, plus R2.00 if it is emailed, so download only the months you need. For a tax year, convert the twelve monthly statements one at a time, then paste the exported files one under another.

Older than two years, Absa Online will not reach the statement. A copy from a branch costs R50.00 if it is under four months old and R100.00 if it is older, on a Transact account. Paper cannot be converted, so if the branch offers a printed copy, ask whether it can be emailed as a PDF instead.

Uploading a CSV instead

If you have your Absa transactions as a CSV laid out as date, reference, description, amount and balance, upload it directly. The converter recognises that order and keeps the reference as its own column in the export, which helps when you match payments to invoices.

A CSV is read in your browser, does not need an account and counts as one page however long it is. Where the figures must match an official statement, convert the PDF.

Before you upload

  • A free account converts 5 pages a month. Each PDF page counts as one, and a CSV counts as one however long it is. After that you can buy credits, and Premium subscribers convert without a monthly page limit.
  • One PDF upload can be up to 20 pages and 8 MB. Split anything longer by month.
  • The PDF must have selectable text. A scanned or photographed statement has none, so download the digital version from online banking instead.
  • Password-protected PDFs have to be unlocked first. Our guide to password-protected bank statements shows how.
  • Where a statement prints dates without the year, the converter takes the year from the statement period. If a statement runs from December into January, check those dates in the preview.
  • A PDF is read in memory over an encrypted connection and is not saved. A CSV never leaves your browser.

Frequently asked questions

What is the password for my Absa eStatement?

Absa does not publish it. The cover letter in the email tells you which password to use. Open the file with it and save an unlocked copy before you upload.

Why will the converter not read my Absa eStatement?

Almost always because it is still password-protected. Open it with the password, print it to a new PDF, and upload the new file.

Can I convert an Absa statement to Excel for free?

Yes. A free account converts 5 pages a month. After that you can buy credits, and Premium subscribers convert without a monthly page limit.

How far back can I convert Absa statements?

As far back as you can get the PDF. Absa Online keeps archived statements for the past two years. Older ones come from a branch, where a copy has a fee.

Is my Absa statement stored when I convert it?

No. A PDF is sent over an encrypted connection, read in memory, and the transactions are sent back to your browser. The file itself is not saved.

General information, last checked on 2026-10-18. Banks set their own menus, fees and passwords and can change them without notice, so confirm anything that matters with your bank directly.