South African bank statements to Excel

Here is what FNB, Standard Bank and Absa each say about statements, in their own words, followed by links to the 3 South African banks that have a page on ExtractPro. Whatever the bank, the route is the same: save the statement, upload it, and receive an .xlsx workbook with a row for every transaction, the date, description and amount kept apart, a balance column too when the statement shows it, and amounts stored as numbers that Excel can total.

What each bank says about its statements

• FNB: “Click download icon to save verified statement onto your smartphone” and “You will be able to access your verified statement from your cellphone files or use a PDF viewer”.
• Standard Bank: “Get your stamped bank statements, confirmation letters and more on your Banking App.” and “You can choose to either Download it to your device or Send it as an email to your preferred email address.”
• Absa: “Click or tap Download and Print. A new window will open with a PDF that you can save or print.” and “Your eStatement will be delivered to your email inbox as a PDF attached to the email.”

Source: FNB, How to download a verified statement, www.fnb.co.za/downloads/fnb-app/how-to-guides/2020/Download-Verified-Statement.pdf; Standard Bank, How to get bank account documents, www.standardbank.co.za/southafrica/personal/products-and-services/ways-to-bank/help-centre/bank-account-documents; Absa, How do I get my statement in PDF format?, onlinebanking.help.absa.co.za/en/help/transaction-history/statements/how-do-i-get-my-transaction-history-in-pdf-format/, and Absa, stamped statements and statements by email, www.absa.co.za/self-service/digital-banking-services/anytime-anywhere-banking-transactions/estatements/. All accessed 11 October 2026.

PDF turns up in the FNB and Absa passages. Standard Bank’s passage talks of statements without using the word, and for that bank the file you upload is the statement you saved, as long as it is a PDF. A separate guide follows the download step by step for each of FNB, Standard Bank and Absa.

Where a bank’s export ends and a statement carries on

The Online Banking Enterprise help at FNB says “Scheduled Exports can be set up per transactional account for Transaction History, Interim Statements and/or your final Statements.” and its statement types include “Statement Type - CSV”, “Statement Type - OFX” and “Statement Type - PDF”. Standard Bank’s guide for Online Banking for Business says “The client can choose from several export options, including CSV, OFX, QFX, QBO, PDF, and XLSX.” and names “Transactions_with_balances.csv – includes running balances for easier spreadsheet tracking.” Separately, Absa’s help on viewing older transactions says “Choose a date range from the dropdown menu or pick a custom start and end date.” When the period you need lies beyond what these exports and views cover, or what a client sent you is the stamped or verified statement itself, the statement is the document to convert. Source: FNB, Online Banking Enterprise help: Statements, www.online.fnb.co.za/rhelp_0_15/OBE_SA_Downloads/Statements.htm; Standard Bank, Downloading transaction history and available file export formats on OB4B, www.standardbank.co.za/static_file/South%20Africa/PDF/How%20To%20Guides/OB4B%20How-to%20guide%20-%20Downloading%20transaction%20history.pdf; Absa, Online Banking help: How do I see my older transactions?, onlinebanking.help.absa.co.za/en/help/transaction-history/statements/how-do-i-see-my-older-transactions/. All accessed 11 October 2026.

Why five years matters

SARS’s record keeping page says “A person must keep records, books of account or documents.” For “A person who has submitted a return” it gives “Five years: counting from the date of submission of a return until the last day of the period.” and it adds “The records can be kept in an electronic form as prescribed by the Commissioner by public notice.” Set against that are the banks’ own figures. FNB’s business pricing guide shows “No charge” beside “Your recent 12 stamped statements available online or on the FNB App” and “R12.60 per statement” beside “Historical statements: After your 12 recent statements available online or on the FNB App”; Standard Bank’s business pricing guide shows “Free” under “Online Banking/Mobile App” for “3 Month Stamped Statements”; Absa’s personal pricing brochure has the row “Copies of statements (per statement)” with “Less than 4 months” at “R50.00” and “4 months or older” at “R100.00”, and its business banking brochure says “All statements or proof of payment (POP) older than three months retrieved on your behalf will cost R95.00 per statement/POP.” Source: SARS, Record keeping, www.sars.gov.za/client-segments/record-keeping/; FNB, Business Annual Pricing Guide, www.fnb.co.za/downloads/pricing-guides/FNB-Business-Accounts.pdf; Standard Bank, business pricing guide 2026, www.standardbank.co.za/static_file/South%20Africa/PDF/Business%20Pricing/2026/Business%20Current%20Account%20Pricing%20Guide%202026.pdf; Absa, personal banking products pricing brochure, www.absa.co.za/content/dam/south-africa/absa/pdf/pricing-brochure/2026/2026-benefits-and-pricing-personal-banking-products-on-sale.pdf, and business banking 2026 pricing brochure, www.absa.co.za/content/dam/south-africa/absa/pdf/pricing-brochure/2026/absa-bb-pricing-2026-bb-brochure.pdf, accessed 11 October 2026.

The 3 South African banks on ExtractPro

Every name in the list leads to the ExtractPro page for that bank, with answers to the questions people ask about its statements.

• FNB
• Standard Bank
• Absa

From the statement to a spreadsheet

It makes no difference whether the statement was saved from an app or Online Banking, arrived by email, or was passed on by a client. The route is three steps:

1. 1Pick the PDF exactly as it was given to you and upload it. If it has a password, type the password at the upload step; the file is unlocked in your browser.
2. 2ExtractPro reads the transactions in the statement and puts each one on its own row.
3. 3Download the .xlsx, with the date, description and amount in separate columns, every amount stored as a number, and the balance as well when the statement shows it. The custom format writes a CSV instead.

For a CSV that is going to Xero, the Xero guide lists the custom format options to choose, and the QuickBooks Online guide does the same for its 3-column CSV. Check the workbook against the statement before relying on it: its row count should equal the number of transactions listed and, when the statement shows a closing balance, its last balance should equal that.

Frequently asked questions

The questions that come up most: