Convert FNB Bank Statement to Excel
FNB’s statement specification is unusually detailed: Effective Date, a Description field capped at 42 characters, a Reference column, a dedicated Service Fee column showing the charge each transaction incurred, an Amount column where withdrawals carry a leading minus, and a running Balance. That per-transaction fee column — something the other big South African banks don’t print — is exactly what trips up manual capture, because a single row can hold two money values that must land in different spreadsheet columns. SheetMyBank maps every FNB column faithfully, keeps Service Fee separate from Amount, and preserves the sign convention so debits stay negative in Excel. For anyone reconciling a Cheque Account month after month, that means no more re-keying six columns per line.
In the FNB app, open Statements, pick the account and month, then tap the download icon — free on digital channels, versus around R60 for a branch printout. What you get is a verified statement: instead of a physical bank stamp it carries a unique electronic stamp number that landlords, SARS or embassies can check on FNB’s online Verify Statement portal for three months. SheetMyBank never uploads that document; parsing is done client-side in your browser, and the Balance column is replayed transaction by transaction to catch extraction errors before you ever open the spreadsheet.
Drop your FNB statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
FNB statement FAQ
Does converting my FNB statement to Excel invalidate the verified-statement stamp?
No — the original PDF is only read, never modified. Keep the stamped PDF for anyone who needs to verify it on FNB’s portal, and use the Excel file for your own analysis.
What happens to the Service Fee column in the export?
It becomes its own spreadsheet column, distinct from the transaction Amount. Totalling a month of bank charges is then a single SUM over that column — no hunting through descriptions.
Why are some amounts negative in my converted FNB file?
FNB marks withdrawals with a minus sign in the Amount column. The converter preserves that convention, so debits subtract and credits add naturally in any formula you build on top.