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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Absa statement into Excel
-
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.
-
Upload it here
Scans and phone photos work too.
-
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.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | 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.
-
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?
Can I convert Absa's transaction history PDF?
Can I import converted Absa rows into QuickBooks or Xero?
Convert your Absa statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Absa.