Convert First National Bank Statement PDF to CSV, Excel

FirstRand Bank Accounts & Statement Challenges

Statement formats we've seen and verified for accuracy.

Synthetic example of a FirstRand Bank statement

Gold Business Account

Business

Common pain points with this format:

Running Balance Cross-Check

First National Bank statements include a running balance column that most converters ignore. Without validating it, missing or duplicate transactions go undetected. We extract this balance and cross-check it against opening/closing balances to ensure every transaction is accounted for.

Currency Symbols Breaking Numeric Parsing

FNB statements embed currency symbols (e.g., "$1,234.56") directly in amount cells, which breaks numeric parsing in Excel and most CSV importers. We strip these symbols so amounts import as clean numbers.

Fees in a Separate Column

First National Bank of South Africa statements include a separate column for fees and charges. We detect and extract these fees correctly, separating them from the transaction amount when needed.

Missing Year in Dates

These statements omit the year from transaction dates (e.g., "15/03" instead of "15/03/2025"), which makes it impossible to sort or reconcile without guessing. We infer the correct year from the statement period and surrounding context.

Fee Column Duplicated as Line Item

FirstRand Bank statements show fees both in a per-transaction fee column and as separate fee transactions later in the statement. The fee column is informational (accrued) — the actual charge appears as its own line. We detect this via balance math and avoid double-counting the fees.

Inconsistent Date Formats

The bank's statements use different date formats within the same document (e.g., "30 Jun 2025" for statement dates and "15/03/2025" for transactions), which can cause date parsing errors or silent misinterpretation. We normalize all dates to a consistent format automatically.

See 5 more challengesSee 3 more challenges

CSV output — compatible with Excel, Google Sheets, and accounting software. Learn more →

Excel output — auto-sized columns with numeric formatting, ready for analysis. Learn more →

QBO-ready output — compatible with QuickBooks Online and Desktop. Learn more →

Xero-ready output — CSV formatted for direct Xero bank statement import. Learn more →

Other South African Banks We Verified for Accuracy