Convert an FNB bank statement to Excel or CSV

How to convert an FNB statement

1. Sign in to FNB Online Banking, open the account and go to Statement History, where the latest 12 statements are listed. Our FNB download guide covers the app and email routes too.
2. Download the statement as a PDF. Choosing Verified gives you the bank-stamped version at no extra cost, and it converts exactly like an unstamped one.
3. If the PDF asks for a password when you open it, open it and save an unlocked copy. The converter cannot read a locked file.
4. Sign in to Payslip Generator with a free account and open the bank statement converter.
5. Upload the PDF. Each page counts once against your free pages for the month.
6. Check the preview: the number of transactions, the money in and money out totals, and the balance on the last row.
7. Choose the export you need, such as Excel, CSV, or a file for Xero, QuickBooks or Sage, and download it.

How FNB marks money in and money out

Most South African banks give money in and money out separate columns. FNB uses a single Amount column and tells the two apart with a suffix. An amount followed by Cr is a credit, money into the account. An amount followed by Dr, or by nothing at all, is a debit. The balance column uses the same suffix, where Cr means the account is in credit.

The converter applies that rule to every row, so the exported file has signed numbers instead of suffixes. It also strips the thousands separators. A comma inside a number is read either as text or as a decimal point, depending on your computer's regional settings, and either way the column stops adding up.

If the Amount column in your export adds up to the difference between the opening and closing balance on the PDF, every sign came through correctly.

Which FNB statement to convert

FNB produces several documents that look alike, and they are not interchangeable. For bookkeeping and tax, convert the monthly statement from Statement History. FNB's Online Banking guide says historical statements for transactional accounts go back to 1996, although only the latest 12 are listed on screen.

• Statement from Statement History: the official monthly statement. Download it as Verified if anyone else will see it.
• Transaction history: covers only the last 60 days and is not a statement. Fine for a quick look, not for a full month.
• Recreated statement: FNB lets you export one as CSV, PDF, OFX, QIF or Pastel, but says it is not an official statement.
• Credit card statement: kept under the card itself. Open the menu, select Accounts, choose the card, then Statement History.

A verified statement carries a reference a lender can check on FNB's website for three months. Converting it does not change the PDF, so send the original to anyone who needs proof and keep the spreadsheet for your own records.

Already have a CSV from FNB?

If you exported a recreated statement as CSV, you can upload that instead of the PDF. The converter recognises FNB's usual column order of date, amount, balance and description, and reads its day-first dates. A CSV is read in your browser, does not need an account, and counts as one page however long it is.

The PDF is still the better source when the figures must match an official statement exactly, for example when you are reconciling a month for your accountant or answering a query from SARS. A recreated statement is FNB's own reconstruction, and FNB is clear that it is not the official record.

FNB business accounts and longer periods

The converter reads FNB business statements the same way as personal ones, as long as the PDF has selectable text. The first time you convert a new kind of account, check the preview totals against the statement before you export, since that is where a layout difference would show.

A single upload can be up to 20 pages. For a busy business account that may be less than a month, so convert one monthly statement at a time and combine the files afterwards. On FNB business accounts the latest 12 stamped statements are free online or on the app, and older ones cost R12.60 each under the 2026/27 pricing guide, so download only the months you need.

Before you upload

• A free account converts 5 pages a month. Each PDF page counts as one, and a CSV counts as one however long it is. After that you can buy credits, and Premium subscribers convert without a monthly page limit.
• One PDF upload can be up to 20 pages and 8 MB. Split anything longer by month.
• The PDF must have selectable text. A scanned or photographed statement has none, so download the digital version from online banking instead.
• Password-protected PDFs have to be unlocked first. Our guide to password-protected bank statements shows how.
• Where a statement prints dates without the year, the converter takes the year from the statement period. If a statement runs from December into January, check those dates in the preview.
• A PDF is read in memory over an encrypted connection and is not saved. A CSV never leaves your browser.