Convert FNB bank statements to Excel or CSV

FNB lets you download each statement in two versions: unverified, or verified with a bank stamp and a reference number that third parties can check. Both are PDFs, and the personal Online Banking guide doesn't describe a CSV option. If you need the transactions as a spreadsheet, for SARS, a landlord or your own books, either version can be uploaded here.

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 FNB statement into Excel

  1. Download the PDF statement from FNB online banking

    • Log in to the FNB App or FNB Online Banking.
    • In the app, select Statements and choose the account; in Online Banking, open the My Bank Accounts tab, click the account name, and select the Statements History view.
    • Choose the month and click the Download icon, picking the Unverified or Verified version; FNB describes a verified statement as bank-stamped and ideal for official use.
    • Save the statement for the period you need as a PDF.
    Go to FNB 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 FNB 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 FNB statements

Verified or unverified

FNB describes the verified statement as bank-stamped and ideal for official use. For a spreadsheet, the unverified version is enough. If a client sends the verified one, that's fine too: the stamp and reference block are kept out of the transaction rows, so they don't turn up as stray lines in Excel.

Twelve free, older ones at a fee

FNB notes that the latest 12 statements download free and that older ones, available back to 1996, carry a fee. Work out exactly which months you're missing before paying for anything. Upload what you already have and missing periods are flagged, which gives you the list.

Business banking exports differ

The bank documents CSV, OFX, QIF and MT940 exports for Online Banking Enterprise, its business platform. If a client is on Enterprise, ask for one of those files first. Personal accounts work from statement PDFs, which is where conversion comes in: each PDF becomes rows with YYYY-MM-DD dates and signed amounts.

Charges and rand formatting

Account fees and transaction charges sit between other transactions as separate rows, and they stay separate in the output so the running balance check adds up. Amounts with an R prefix, spaces or commas as thousands separators become plain numbers.

Output and review

From FNB PDF to your books

Accounting tip

Xero is sold in South Africa and its manual statement import accepts CSV. Import the Xero-ready file into the FNB account in Xero; on the first import you map the columns, and Xero remembers that mapping for every later file, which helps when you're working through a year of statements.

  • 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

FNB statement questions

Do I need a verified FNB statement to convert it?
No. The unverified statement has the same transactions and converts the same way. The verified version matters when a bank, landlord or embassy wants proof, not for getting the data into Excel. If you only have the verified one, upload it; the stamp won't end up in your rows.
Can I convert FNB statements from several years ago?
Yes, once you have the PDFs. The bank says statements are available from 1996, with the latest 12 free and older ones charged. Upload them together and they're checked as a run, with missing or overlapping months flagged.
Can I import converted FNB rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your FNB 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 FNB.