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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your FNB statement into Excel
-
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.
-
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 FNB 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 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.
-
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?
Can I convert FNB statements from several years ago?
Can I import converted FNB rows into QuickBooks or Xero?
Convert your FNB 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 FNB.