If you need to convert an FNB bank statement to Excel, the fastest reliable route is usually not PDF conversion. Start by checking whether your South African FNB under FirstRand account gives you a native structured export first, because that can save you a lot of cleanup. Some FNB workflows support formats such as CSV, OFX, PASTEL, QIF, SAP, and SWIFT MT940. If those are not available for your account or statement type, many users end up with a verified statement PDF and then need to turn that into Excel or CSV for bookkeeping, reconciliation, or import prep.
This matters because search results also mix in content about US banks called First National Bank. This guide is specifically about South African FNB / FirstRand statements, and the right method depends on the format you can actually access from FNB.
| Path | Best when | Usual cleanup | Typical downstream use |
|---|---|---|---|
| Native FNB structured export | Your FNB profile offers CSV, OFX, PASTEL, QIF, SAP, or MT940 for the account you are working on | Low | Fastest route for reconciliation, bank-feed prep, and structured imports into accounting workflows |
| Verified statement PDF | You only have the official statement download or emailed PDF | Medium to high | Excel review, manual transaction checks, and spreadsheet prep before Xero or Sage Pastel import |
| Automated PDF extraction workflow | You have repeated PDF statements, many pages, or need a faster FNB bank statement to spreadsheet process | Low to medium, depending on output rules | Bulk conversion to Excel or CSV, standardised columns, and cleaner month-end bookkeeping prep |
Before you try to create a CSV from an FNB statement, identify what you actually have in hand: a structured export, a verified PDF, an emailed statement, or an enterprise-style banking export. That determines whether this is a quick download job or a conversion-and-cleanup workflow.
Use Native FNB Exports First When They Match Your Workflow
If you can get a structured file directly from FNB, start there. A native export usually gives you clean transaction rows, consistent columns, and far less Excel cleanup than a PDF conversion. For accountants, bookkeepers, and creditors clerks, that means a better starting point for review, reconciliation, and downstream import into accounting software.
Before you assume PDF conversion is necessary, check what your FNB channel offers. In personal and business Online Banking, the FNB Online Banking user guide lists a Recreated Statement export in CSV, PDF, Microsoft Money (OFX), Quicken (QIF) and Pastel for the dates you choose (the steps are below). Statement History, in Online Banking or the FNB App, gives you the statement itself, and its PDF is the official bank statement. On a business account, the email statement settings include a file format, so check what yours is set to send. If the account sits inside Online Banking Enterprise, confirm whether structured or scheduled exports are enabled for that profile.
Online Banking Enterprise goes further. According to FNB's official statement export formats, FNB Online Banking Enterprise says statement scheduled exports can be created in an Excel (.csv) spreadsheet and lists statement file layouts including CSV, OFX, ORACLE / SWIFT MT940, PASTEL, PDF, QIF, and SAP. SAP, MT940 and the rest of that longer list are Enterprise formats; personal and business Online Banking stop at the five above.
In practical terms, use the format that already matches your next step:
- CSV: Best for spreadsheet review, filtering, sorting, and a fast FNB statement to CSV workflow when you need to inspect transactions in Excel first.
- OFX or QIF: Often the better choice when your accounting or finance software accepts direct bank-feed style imports.
- PASTEL: The obvious first option for Sage Pastel-oriented workflows, because it may reduce remapping.
- SWIFT MT940 (Online Banking Enterprise): Useful in banking, treasury, and reconciliation processes where MT940 is already the expected statement structure.
If you can download FNB statement CSV, OFX, QIF, MT940, or a Pastel-ready export and your target workflow accepts it, use that before spending time on PDF conversion. A proper FNB CSV export will usually beat a PDF-to-Excel route because you are starting with structured data instead of trying to reconstruct tables from a statement layout.
A transaction download that stops short is usually Transaction History reaching its limit. FNB's Online Banking guide says it shows up to 60 days of history, and fewer on an account with many transactions flowing through it, while the FNB Banking App page limits the app's transfer history to 150 entries over up to three months. FNB also says Transaction History is not final and should not be used for reconciliation; for that, it points you to statement data for a defined period.
Online Banking Enterprise works on retention days instead. Its user guide sets transaction history to 60 days by default, which an administrator can extend to 90, 120, 150 or 180 days under Profiles > Site Settings > Retention Days, at a cost, and a search returns at most 60 days or 2,100 transactions. Its statement archive goes back to January 2004, searched across 24 months at a time.
For a structured file that covers whole statement periods rather than a search window, export a Recreated Statement in Online Banking (the From Date list shows how far back yours goes):
- Select My Bank Accounts, click More on the account, and choose Recreated Statement.
- Accept the disclaimer and select Continue.
- Open the Recreated Statements menu, select Search, then Export.
- Choose the From Date and To Date (the dates on offer follow your statement cycle), then enter the email address and subject for the export.
- Select up to three formats, such as CSV for Excel and Pastel for Sage Pastel.
A Recreated Statement carries the statement date, opening and closing balances, debit and credit totals and counts, and the transactions, so it gives you the figures to tie your spreadsheet back to. It is not an official bank statement, and FNB says it should not be presented to third parties. For a lender, auditor or other third party, download the statement from Statement History instead, where you can have it verified with a bank stamp at no additional cost.
Statement History also reaches much further back than Transaction History: FNB's Online Banking guide says historical statements for transactional accounts are available from 1996. The latest 12 statements download free, and FNB charges a fee for older ones. Those statements come as PDFs, so any history you can only get as statements becomes the conversion job below.
Convert an FNB PDF Statement to Excel When CSV Is Not Available
If your statement is not already structured, this is the situation many South African finance teams actually face: you have a verified PDF downloaded from the FNB App, an emailed monthly statement, a client-forwarded PDF, or a Recreated Statement downloaded as a PDF rather than exported in a structured format. At that point, an FNB PDF to Excel workflow is less about perfect conversion and more about getting clean transaction rows you can trust for bookkeeping, cashbook updates, or reconciling receipts and payments.
The manual route is the right first test because it shows you very quickly whether the statement is workable. If the PDF is a digital statement, not a scan, you can try opening it in Excel or copying the transaction table into a sheet and separating columns. For a short statement, that may be enough. For a month with many card swipes, EFT references, service fees, and reversals, the cracks usually show up fast:
- Transaction rows split across two lines because the description wraps
- Dates imported inconsistently, especially when Excel guesses the format
- Debit and credit signs flipped, or amounts landing in the wrong column
- Long references merged into neighbouring cells
- Running balances no longer matching once one row breaks
That last issue matters most. If one payment line is shifted, your balance trail stops lining up, which makes reconciliation harder than the original PDF review. That is why manual conversion is acceptable for a once-off statement with limited activity, but weak for recurring client work, multi-account bookkeeping, or month-end catch-up across several FNB PDFs.
Scanned statements are a different problem altogether. If you need to convert scanned FNB PDF statement files, you are no longer doing a quick table copy. You are dealing with extraction from images, which means the tool has to identify rows, amounts, dates, and references before Excel cleanup even starts. A digital PDF may let you salvage the table with moderate editing. A scan, mobile photo, or low-quality forwarded copy usually needs a true FNB bank statement converter workflow, not just paste-and-fix.
A repeatable process should look like this:
- Upload the FNB statement PDF.
- Specify the output you need, such as transaction date, description, debit, credit, balance, and account number, plus the file type you want.
- Review the extracted rows against the original statement, especially around wrapped references, fees, and balance changes.
- Export the result as Excel, CSV, or another structured format for your bookkeeping process.
That is where automation starts to help. If you regularly extract bank statement data into Excel automatically, Invoice Data Extraction can process bank statements, including scanned PDFs, and export structured Excel, CSV, or JSON files. You can define the columns you need, control how dates or amounts appear, and verify extracted rows against the source file and page reference before using the data.
If you work across banks, use the same decision pattern for ABSA, Standard Bank, and Nedbank: take the native export where available, and use PDF extraction only when the export is missing or unsuitable.
Prepare FNB Statement Data for Excel, Xero, and Sage Pastel
Whether your FNB data came from a native export, an email attachment, or a verified statement PDF, the next job is to make the file usable, not just readable. If the data came from a native FNB export, cleanup is usually light. If it came from a PDF, you should expect more work on column mapping, transaction signs, and broken description fields.
A practical cleanup order looks like this:
- Standardize the date column. Put every transaction date into one consistent format and make sure Excel recognizes it as a date, not text.
- Keep deposits and withdrawals signed correctly. Do not let credits and debits collapse into one unsigned amount. If your sheet uses a single Amount column, preserve positive and negative values consistently.
- Keep the balance column intact. The running balance helps you trace transaction order and spot rows that shifted during extraction.
- Split descriptions and references where needed. FNB statement lines often combine merchant text, payment references, and branch or channel details in one field. For spreadsheet work, it helps to keep a raw description column and add separate cleaned columns for reference, payee, or transaction type.
- Remove structural noise. Delete repeated page headers, footer text, opening balance labels, closing balance labels, and any carried-forward rows that came from a multi-page PDF.
If your goal is Excel analysis, keep the file flexible. Accountants and bookkeepers often want extra columns they can filter, sort, or use in pivot tables, even if those columns would not belong in an import file. That usually means keeping the original statement narrative, a cleaned description, the transaction date, the signed amount, the balance, and any extracted reference number in separate columns. This gives you a better base for month-end analysis, VAT support work, and transaction matching.
If you need to import FNB transactions into Xero, switch from analysis mode to import mode. Before upload, compare your final CSV against Xero bank statement CSV format requirements and make sure the layout you save matches the bank import screen you plan to use. Focus on clean transaction dates, readable descriptions, correctly signed amounts, and the right destination bank account in Xero. If the source came from PDF conversion rather than a native export, pay special attention to rows where money in and money out may have been flipped or merged incorrectly.
If you are preparing an FNB statement export for Sage Pastel, think the same way: start with the import structure your Pastel process expects, then shape the statement data to match it. Follow the Pastel Bank Manager file-preparation and import workflow for the destination-specific steps. The article on Sage and Sage 50 bank statement import requirements is useful here, especially when your source file started as a PDF rather than a bank-generated CSV. In those cases, wrapped descriptions, duplicated page rows, and misplaced references are common problems that need to be fixed before the file is ready for Sage Pastel.
When FNB's native structured export already matches your destination, only tidy what is necessary. When the data came from PDF extraction, treat cleanup as part of the conversion itself, because a file that looks correct in Excel can still be poorly shaped for Xero or Sage Pastel.
Before reconciliation or import, do a short tie-out against the original statement:
- Confirm statement dates, opening balance, closing balance, and net movement.
- Compare transaction counts and scan for duplicated dates, values, or references.
- Check that debit and credit signs still point the right way.
- Review the first and last transactions, plus a small sample from the middle of the statement.
- For scanned or multi-page PDFs, confirm every page was captured and repeated headers or footers did not become transaction rows.