Convert Absa bank statements to Excel or CSV

Absa's personal Online Banking gives you statements and transaction history as PDFs, and its help pages don't describe a CSV export. If you need Absa figures in a spreadsheet, for SARS, a bond application or a client's monthly books, this page covers what to expect: password-protected eStatements, stamped statements, and how fees and rand amounts come through.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Absa statement into Excel

  1. Download the PDF statement from Absa online banking

    • Log in to the Absa Banking App or Absa Online Banking.
    • In the app, choose the account from the Home screen and tap the ellipsis icon; in Online Banking, click Statements on the account bar, then the Statements tab.
    • Choose the Stamped statements option in the app, or choose a date range from the dropdown in Online Banking and click Download. For transaction history as a PDF, click Download and Print.
    • Save the statement for the period you need as a PDF.
    Go to Absa Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Absa statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · ZAR
Sample bank statement rows with made-up data, amounts in ZAR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Absa statements

Emailed eStatements have a password

Absa's emailed eStatements are password protected, and the cover letter in the email explains which password to use. Upload the eStatement unchanged and enter that password at the prompt. It's needed only to open the PDF for conversion and is never stored.

Stamped statements

A stamped statement adds a bank stamp or verification block near the transaction table, and Absa notes that downloading one has additional costs. You don't need the stamped version for a spreadsheet. If that's what you have, the stamp block is kept out of the transaction rows.

Two years in the archive

Online Banking keeps archived statements for the past two years. If you expect to need longer history later, for a tax query or a loan, save each statement while it's still there. A folder of saved PDFs uploaded together is checked for missing and overlapping months.

Fees and rand amounts

Monthly account fees and transaction charges sit between ordinary transactions as their own rows. They stay separate in the output, so the running balance check adds up and bank charges are easy to code. Amounts printed with an R prefix or spaced thousands become plain numbers Excel can total.

Output and review

From Absa PDF to your books

Accounting tip

Sage Business Cloud Accounting imports a CSV headed Date, Description and Amount, with payments negative and receipts positive. That is the QuickBooks-ready layout, so use that file for Sage. Its dates need to match the format you choose at import; for a South African statement the file uses dd/mm/yyyy, so choose that.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Absa statement questions

Do I need to remove the password from an Absa eStatement?
No. Upload the emailed eStatement as it is and type the password described in the email's cover letter when you're asked. That password only opens the file and isn't stored, and the conversion itself never needs your banking login.
Can I convert Absa's transaction history PDF?
Yes. Online Banking can produce transaction history as a PDF, and it converts the same way as a statement. For the balance check, a statement with opening and closing balances is the stronger source, so use it when the dates match.
Can I import converted Absa rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Absa statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Absa.