OfflineStatementFNB statement PDF to Excel
Drop an FNB statement PDF and get a spreadsheet of dates, descriptions, amounts and balances, with money in and money out told apart. The PDF is read by code in your browser and never leaves your device.
Drop statement PDFs hereor click to choose filesTap to choose a statement PDF
Free: 3 statements a day, no sign-up.
Bank not supported yet? Email the bank name and country to [email protected] and we'll add it. No need to send your statement.
How your statement stays private
- Your PDFPick a statement from your computer or phone.
- Read in this tabThis page reads it on your device and never sends the file anywhere. Turn off your wifi after the page loads and it still works.
- Your spreadsheetThe rows go straight into a file in your downloads.
Works with most banks
Reads text-based PDF statements with debit/credit or single-amount columns, in US, UK, European, Indian and Indonesian number formats. Password-protected e-statements work too, and the password stays on your device.
Checked, not guessed
Every statement gets a running-balance check: if a row doesn't add up to the printed balance, we highlight it, so nothing goes into your books wrong.
Hours of typing, done in a minute
Free: preview every transaction and download the first 25 as a CSV.
Pro: every transaction, a year of statements in one file, Excel, QuickBooks, Xero and OFX. See pricing
How to download your FNB statement as a PDF
- Log in to FNB Online Banking or the FNB App and open My Bank Accounts.
- Select Statements next to the account, then the month you need. Menu names change from time to time.
- Choose Download for the PDF, or have it emailed to you and save the attachment.
Then drop the PDF in the box above, or click it to choose the file.
What you get
FNB statements usually show Date, Description, Amount, Balance and Accrued Bank Charges, with dates such as 05 Sep and no year. There is one Amount column: money in ends in Cr (1 250.00Cr) and money out has no mark at all. The converter treats amounts without Cr as money out, and the running balance confirms it, so the Amount column comes out signed: plus for money in, minus for money out. Balances ending in Cr stay positive and ones ending in Dr become negative. The Accrued Bank Charges column is left out, because FNB collects those charges later as a row of their own. Amounts with a space or a comma between thousands both work. Dates are kept as printed in the free CSV; the Pro QuickBooks, Xero and OFX exports add the year from the statement.
FNB Online Banking can also export recent transactions as CSV, OFX or QIF. If that covers what you need, use it. The converter is for the statement PDFs: older months, emailed statements, or a statement you saved for a home loan or rental application.
How it works, and what it can't do
OfflineStatement is a general reader for text-based PDF statements: it finds the transaction table by its column headings and turns each dated row into a spreadsheet row. It was not built with or tested by FNB, and statement layouts change, so check the result against the PDF. Where the statement prints a running balance, every row is checked against it and rows that don't add up are highlighted. Scanned or photographed statements (images, not text) are not supported. Password-protected PDFs work: you type the password and it stays on your device.
Open the CSV in Excel, Google Sheets or QuickBooks
Excel: double-click the CSV, or use Data > From Text/CSV. Google Sheets: File > Import > Upload, then choose the CSV. QuickBooks Online: the bank-upload CSV needs Date, Description and Amount; Pro exports exactly that format (see PDF to QuickBooks), or you can trim the free CSV to those columns.
Other bank guides: Chase · Bank of America · Wells Fargo · Capital One · American Express · Citi · U.S. Bank · PNC · TD Bank · Discover · Apple Card · Truist · Navy Federal · HSBC UK · Barclays · Lloyds · NatWest · Santander UK · Monzo · Halifax · Nationwide · Starling · TSB · first direct · RBC Royal Bank · TD Canada Trust · Scotiabank · CommBank · Westpac · ANZ · NAB · BMO · CIBC · SBI · HDFC Bank · ICICI Bank · Axis Bank · Kotak · PNB · Bank of Baroda · Canara Bank · Union Bank of India · IDFC FIRST Bank · Yes Bank · Indian Bank · IDBI Bank · UCO Bank · Bank of Maharashtra · South Indian Bank · Bandhan Bank · IndusInd Bank · Federal Bank · Bank of India · Central Bank of India · Capitec · Absa · Standard Bank · Bank of Ireland · AIB · Maybank · DBS / POSB · OCBC · UOB · Any bank
FNB and the other bank names on this site are trademarks of their respective owners. OfflineStatement is an independent tool by Tofu Labs and is not affiliated with, endorsed by or sponsored by any bank.
FAQ
Is this an FNB tool?
No. OfflineStatement is independent and not affiliated with or endorsed by FirstRand Bank Limited or First National Bank.
Can I convert a whole tax year at once?
The South African tax year runs from 1 March to the end of February. With Pro you drop all twelve statements together and get one file, with duplicate transactions removed. The free version converts one statement at a time.
Is my statement uploaded?
No. The PDF is read by code running in your browser. There is no server that receives your file, and you can disconnect from the internet after the page loads. Pro checks your license about once a day when you're online and keeps working offline in between.
Is it free?
Previewing a statement and downloading a CSV of its first 25 transactions is free. Pro gives you every transaction, batches of statements, Excel .xlsx and QuickBooks, Xero and OFX files.