First National Bank Statement to Excel Converter

ClearlyLedger converts First National Bank (South Africa) PDF statements into clean Excel and CSV files. This guide covers the common FNB pdf layout, DD/MM/YYYY dates and ZAR amounts. Exports are released only when verification checks pass. Most FNB statements (4–15 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-08-07

Read the FNB source layout correctly

Printed structure: PDF with Date, Description, Service Fee, Amount, Balance

Date notation: DD/MM/YYYY. Money notation: R ZAR. Observed statement size: 4–15 pages.

Amounts use a period decimal; fee and reference lines are kept as labelled rows.

Fields and row patterns found in First National Bank PDFs

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • FNB checkpoint 1: Service Fee column appears between Description and Amount — not a debit
  • FNB checkpoint 2: eBucks rewards credits appear as separate line items
  • FNB checkpoint 3: eWallet and mVoucher transfers identified by prefix in description
  • FNB checkpoint 4: Amounts use R prefix inside cells (e.g. R1 234.56)

Review the FNB extraction

A typical First National Bank file runs 4–15 pages. Confirm its DD/MM/YYYY dates, ZAR signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Service Fee column appears between Description and Amount — not a debit. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the First National Bank PDF.
  2. Inspect the documented FNB row patterns.
  3. Reconcile the ZAR transaction math.
  4. Download verified FNB Excel or CSV data.

Use the FNB output in South Africa

Excel suits source-document review and coding. CSV suits mapped imports into Sage, Xero, QuickBooks or another bookkeeping system. Those routes preserve the DD/MM/YYYY interpretation and ZAR values established from the First National Bank source.

FNB privacy and retention

The FNB PDF is processed in memory and deleted after conversion. The FNB transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around South Africa's POPIA for South Africa account holders.

FNB conversion FAQ

Which FNB statement layouts can ClearlyLedger convert?

First National Bank statements typically arrive as PDF with Date, Description, Service Fee, Amount, Balance. ClearlyLedger's FNB profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle FNB-specific quirks?

This guide highlights common FNB statement characteristics — for example: Service Fee column appears between Description and Amount — not a debit. The conversion is released only after its verification checks pass.

Can I import a converted FNB statement into Sage?

Yes. Export to CSV and import into Sage, Xero, QuickBooks or any tool that accepts a transaction file. The DD/MM/YYYY dates and ZAR amounts are normalised so the import maps cleanly.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free